home / russian-ads

display_ads (view)

Data source: simonw/russian-ira-facebook-ads-datasette

19 rows where an ad_target was people_who_match:interests:Pan—Africanism

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
943 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 6524 863 https://www.facebook.com/blacktivists/ No child should grow with an unhealthy sense of self—esteem. Be proud of who you are! 2.90464 181.54 RUB 2017-05-18T07:11:34-07:00 2017-05-19T15:00:00-07:00
946 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 63405 3990 https://www.facebook.com/blacktivists/ We should more often expose our children to positive cultural traditions. We should more often expose our children to positive cultural 3.2 200.00 RUB 2017-03-23T02:44:31-07:00 2017-03-24T13:00:00-07:00
1011 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 93044 5582 https://www.facebook.com/blacktivists/ Watch this baby drama. This child‘s great escape is hilarious. Watch this baby drama. This child‘s great escape is hilarious. 2.77504 173.44 RUB 2017-04-14T07:58:44-07:00 2017-04-15T08:00:00-07:00
1013 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 3834 550 https://www.facebook.com/blacktivists/ Hopefully, it will reach someone. Please, understand our struggles. One person cannot represent the whole race. 0.77488 48.43 RUB 2017-04-13T04:45:19-07:00 2017-04-14T04:45:19-07:00
1029 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 55233 3140 https://www.facebook.com/blacktivists/ This incredibly talented and adorable little boy created his own melody at the age of ONE! 6.23808 389.88 RUB 2016-12-05T06:09:12-08:00 2016-12-07T06:09:12-08:00
1032 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 32315 1849 https://www.facebook.com/blacktivists/ Listen to what this kid just said. The role of adults in Children‘s life is very important. Adults need to set the example for kids. 6.4 400.00 RUB 2016-12-08T05:47:30-08:00 2016-12-09T05:47:30-08:00
1040 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 295361 23054 https://www.facebook.com/Blacktivist-128371547505950/ When ballet dancers can mix modern dance and ballet. When ballet dancers can mix modern dance and ballet. 4.8 300.00 RUB 2017-02-09T23:34:38-08:00 2017-02-10T23:34:38-08:00
1054 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 88 4 https://www.facebook.com/Blacktivist-128371547505950/ Remember folks, dance and music is a large part of our culture. Remember folks, dance and music is a large part of our culture. 0.01216 0.76 RUB 2017-01-26T01:29:39-08:00 2017-01-27T01:29:39-08:00
1133 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 67886 11269 https://www.facebook.com/Blacktivist-128371547505950/   6.4 400.00 RUB 2017-02-16T03:50:16-08:00 2017-02-17T03:50:16-08:00
1137 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/Blacktivist-128371547505950/ When ballet dancers can mix modern dance and ballet. When ballet dancers can mix modern dance and ballet. 0.0 0.00 USD 2017-02-09T23:32:25-08:00 2017-02-11T03:48:08-08:00
1186 location:United States, age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/Blacktivist-128371547505950/ When ballet dancers can mix modern dance and ballet. When ballet dancers can mix modern dance and ballet. 0.0 0.00 USD 2017-02-09T03:48:08-08:00 2017-02-10T03:48:08-08:00
2804 location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 60, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Hotep, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Dresses, people_who_match:interests:Black Enterprise, people_who_match:interests:BLACK MODELS & FASHION, people_who_match:interests:Black (Color) 68 5 https://www.facebook.com/Nefertitis—Community-576081822594619/ Once we recognize what it is we are feeling, once we recognize we can feel deeply, love deeply, can feel joy, then we will demand that all parts of our lives produce that kind of joy #black #woman #quotes #powerful #woke #panafrican 0.65216 40.76 RUB 2016-11-15T05:18:54-08:00 2016-11-16T05:18:54-08:00
2826 location:United States, excluded_connections:Exclude people who like Pan-African roots MOVE, age:18 — 65+, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Black nationalism, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Malcolm X, and_must_also_match:interests:Hotep, and_must_also_match:interests:Nelson Mandela, and_must_also_match:interests:Kemetism, and_must_also_match:interests:South Africa, and_must_also_match:interests:Pan-African colours, and_must_also_match:interests:Kwame Nkrumah, and_must_also_match:interests:Afrocentrism, and_must_also_match:interests:Marcus Garvey, and_must_also_match:interests:Nigeria 36208 2369 https://www.facebook.com/PanAfrootsmove/ Unapologetically melaneted Kings and Queens are powerful together. Join us! 145.40176000000002 9087.61 RUB 2016-10-21T06:28:12-07:00  
3317 location:united_states:Astoria (+25 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 0 0 https://www.facebook.com/events/694209204073106/ The second seIf-defense class—Joih the event, bring your friends, feel safe with us!!! Self—defense classes with — 0.0 0.00 USD 2017-02-10T04:54:43-08:00 2017-02-11T15:29:15-08:00
3324 location:united_states:Astoria (+25 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 1533 72 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event, bring your friends, feel safe with us!!! Self—defense classes 23.53696 1471.06 RUB 2017-02-09T06:58:01-08:00 2017-02-11T15:29:15-08:00
3335 location_living_in:united_states:New York (+25 mi) New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:Martial arts, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Self Defense Family, people_who_match:interests:Black (Color), people_who_match:interests:The Self Defense Company, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 2918 92 https://www.meetup.com/BIack-Fist-SeIf-Defense-Project/ Join the event, bring your friends, feel safe with us! It's free! Organized on a donation basis. Come and train with us— https://www.meetup.com/BlaCk—Fist—SeIf—Defense—Project/ Free SeIf—defense 24.0 1500.00 RUB 2017-03-21T08:24:54-07:00 2017-03-24T08:00:00-07:00
3365 location_living_in:united_states:New York (+25 mi) New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:Martial arts, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Self Defense Family, people_who_match:interests:Black (Color), people_who_match:interests:The Self Defense Company, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 3483 103 https://www.meetup.com/BIack-Fist-SeIf-Defense-Project/ Join the event, bring your friends, feel safe with us! It's free! Organized on a donation basis. Come and train with us — https://www.meetup.com/BlaCk—Fist—SeIf—Defense—Project/ Free SeIf—defense 21.22544 1326.59 RUB 2017-03-22T05:23:10-07:00 2017-03-29T05:23:10-07:00
3369 location_living_in:united_states:Astoria (+50 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 1274 55 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event, bring your friends, feel safe with us!!! Self—defense classes 23.35584 1459.74 RUB 2017-02-10T04:57:36-08:00 2017-02-11T09:00:00-08:00
3377 location:united_states:Astoria (+25 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 16 0 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event brin your friends, feel safe with us!!! Self—defense classes 0.7056 44.10 RUB 2017-02-09T01:01:32-08:00 2017-02-11T15:29:15-08:00

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/umd-mith/irads/master/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1343.319ms · Data source: simonw/russian-ira-facebook-ads-datasette