home / russian-ads

display_ads (view)

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

7 rows where an ad_target was people_who_match:interests:Afrocentrism

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
12 no image location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Power, people_who_match:interests:Black Arts Movement, people_who_match:interests:Fight the Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Afrocentrism, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Black is beautiful, people_who_match:interests:Malcolm X, people_who_match:interests:HuffPost Black Voices 44111 625 https://www.facebook.com/Bat-240131319678646/ It's time for us to understand that we do deserve all best. It's time for our people to stand up and use all the opportunities of this life. Follow black pride us, if you agree! 78.29952 4893.72 RUB 2016-08-17T04:17:52-07:00  
1688 location:united_states:New York, age:18 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:Leadership development, people_who_match:interests:California African American Museum, people_who_match:interests:The African History Network, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Rosa Parks, people_who_match:interests:Sister 2 Sister magazine, people_who_match:interests:The Autobiography of Malcolm X, people_who_match:interests:World Day of Social Justice, people_who_match:interests:Leadership, people_who_match:interests:Black Arts Movement, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:Jesse Jackson, people_who_match:interests:BlackNews.com, people_who_match:interests:Racial equality, people_who_match:interests:African-American literature, people_who_match:interests:Afrocentrism, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Racial integration, people_who_match:interests:Phaedra Parks, people_who_match:interests:Black History Month, people_who_match:interests:Sister 2 Sister, people_who_match:interests:African-American history, people_who_match:interests:Black is beautiful, people_who_match:interests:The Honorable Minister Louis Farrakhan, people_who_match:interests:madeas family reunion, people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz), people_who_match:interests:Slavery by Another Name, people_who_match:interests:African American Museum in Philadelphia, people_who_match:interests:Afrocentric education, people_who_match:interests:Bias, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, people_who_match:interests:Social Justice Solutions 26919 646 https://b|ackmattersus.com/10683-hever-forget-never- Yesterday and the day before yesterday and many days before that, we had to witness horrible crimes committed by the police against Black men. The killing of AI Never Forget Never July 16th, 1 pm. Washington Square Park, NYC Blackluive 41.80944 2613.09 RUB 2016-07-14T06:01:49-07:00  
1933 location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Black nationalism, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Power, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:Afrocentrism, 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:Black is beautiful, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Malcolm X, people_who_match:interests:New Black Panther Party 2756 79 https://www.instagram.com/black_america_today/ You can achieve anything you want without taking your Clothes off. For more positive black pictures follow BLACK_AMER|CA_TODAY! Today is the day to rise up and act! Proudblacks 8.629280000000001 539.33 RUB 2016-08-04T06:54:34-07:00 2016-09-04T06:47:01-07:00
2821 location_living_in:United States, age:18 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Suggested Video on desktop computers, placements:News Feed on mobile devices, placements:Suggested Video on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africanism, people_who_match:interests:Kemetism, people_who_match:interests:Afrocentrism, 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:Syria-News, people_who_match:interests:Malcolm X, people_who_match:interests:Refugees of the Syrian Civil War, people_who_match:interests:Syria Charity 24977 3182 https://www.facebook.com/PanAfrootsmove/ “You got money for war but can’t feed the poor” 10.861120000000001 678.82 RUB 2017-05-26T07:56:47-07:00 2017-05-29T08:00:00-07:00
2827 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:Hotep, people_who_match:interests:Nelson Mandela, people_who_match:interests:Kemetism, people_who_match:interests:Kwame Nkrumah, people_who_match:interests:Afrocentrism, people_who_match:interests:Marcus Garvey, people_who_match:interests:Nigeria, and_must_also_match:interests:Martin Luther King, and_must_also_match:interests:Jr., and_must_also_match:interests:Pan-Africanism, and_must_also_match:interests:African—American culture, and_must_also_match:interests:African—American Civil Rights Movement (1954—68), and_must_also_match:interests:African-American history, and_must_also_match:interests:Malcolm X 1226 105 https://www.facebook.com/PanAfrootsmove/ Unapologetically melaneted Kings and Queens are powerful together. Join us! 14.69824 918.64 RUB 2016-11-10T07:17:06-08:00  
2842 location_living_in:United States, 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:Syria Charity, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan- Africanism, people_who_match:interests:Kemetism, people_who_match:interests:Afrocentrism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Syria-News, people_who_match:interests:Malcolm X 5555 649 https://www.facebook.com/PanAfrootsmove/ This is what happens when a white man wants to make money from your country. This should remind us all - never trust a white American man! 3.45456 215.91 RUB 2017-05-26T07:55:28-07:00 2017-05-28T17:00:00-07:00
3014 location_living_in:United States, excluded_connections:Exclude people who like BIack_Baptist_church, age:18 - 51, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:God, people_who_match:interests:Christian Church, people_who_match:interests:Black Power, people_who_match:interests:Baptism, people_who_match:interests:Traditional black gospel, people_who_match:interests:Christianity, people_who_match:interests:Black Church, people_who_match:interests:Prayer, people_who_match:interests:Afrocentrism, people_who_match:interests:Black is beautiful, people_who_match:interests:Bible, people_who_match:interests:African Methodist Episcopal Church, people_who_match:interests:Gospel, people_who_match:interests:Faith, people_who_match:interests:Worship, people_who_match:interests:Black (Color) 1339 29 https://www.facebook.com/Black_|iberation_churCh-1160193507389202/ Our aim, to make Christianity real for Blacks! 32.60096 2037.56 RUB 2016-10-14T06:01:41-07: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/edsu/irads/03fb4b/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 1512.757ms · Data source: simonw/russian-ira-facebook-ads-datasette