home / russian-ads

display_ads (view)

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

10 rows where an ad_target was people_who_match:interests:Fight the Power

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  
1684 no image location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:My Black is Beautiful, 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:Malcolm X, people_who_match:interests:Black Girls Rock! 11812 147 https://www.facebook.com/Blackluive-1725227467722991/ Our existence is being threatened by a race that sees itself 'masters over our melanin, but clear Strong Black Men, the system and racism got re—engaged so we have no Choice but to fight back, anyway, anyhow! Follow blackmattersus. 27.54112 1721.32 RUB 2016-08-18T05:05:43-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  
1695 no image location:united_states:Louisiana, location:united_states:Minnesota, age:13 - 60, placements:Instagram Feed, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Slavery by Another Name, people_who_match:interests:Malcolm X, people_who_match:interests:Cop Block 36601 920 https://www.facebook.com/Blackluive-1725227467722991/ I didn't believe the media, 80 | BECAME ONE. Follow! 79.07808 4942.38 RUB 2016-07-11T02:41:37-07:00  
1700 no image location:united_states:Chicago (+40 km) Illinois, location:united_states:Baton Rouge (+40 km) Louisiana, location:united_states:Baltimore (+40 km) Maryland, location:united_states:Cleveland (+40 km) Ohio, age:13 - 6O, placements:Instagram Feed, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Slavery by Another Name, people_who_match:interests:Malcolm X, people_who_match:interests:Cop Block 36585 765 https://www.facebook.com/AmericanCops-1667165370195771/ Oooops seems like someone screwed up! Salute our brave and smart cops who mistake man's member for a deadly weapon. Follow US and stay WOKE! 89.45088000000001 5590.68 RUB 2016-07-12T07:44:02-07:00  
1715 no image location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Black is beautiful or Cop Block, people_who_match:interests:Behaviors: African American (US) 61822 1075 https://www.facebook.com/Blackluive-1725227467722991/ If you do care about the future of black community, follow blackmattersus! Know the truth, stay tuned! 106.83888 6677.43 RUB 2016-08-16T02:29:55-07:00  
1932 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:Pan-Africanism, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:My Black is Beautiful, people_who_match:interests:African-American history, people_who_match:interests:Black is beautiful, people_who_match:interests:Black Girls Rock! 38262 683 https://www.facebook.com/BaIt-194465337564400/ Black people all around the world are proud of who they are and these Black twins are proudly identifying with their roots. 59.58144 3723.84 RUB 2016-08-12T09:06:46-07:00  
1949 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 history, people_who_match:interests:Black Panther Party, people_who_match:interests:My Black is Beautiful, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black is beautiful, people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz), people_who_match:interests:Afrocentric education, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/BaIt-194465337564400/   0.0 0.00 USD 2016-08-05T02:42:43-07:00  
1950 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 history, people_who_match:interests:Black Panther Party, people_who_match:interests:My Black is Beautiful, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black is beautiful, people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz), people_who_match:interests:Afrocentric education, people_who_match:interests:Malcolm X 5403 149 https://www.facebook.com/BaIt-194465337564400/ We are black. We are not weird. We are limited edition. 8.83424 552.14 RUB 2016-08-05T02:46:52-07:00  
2818 location_living_in:United States, excluded_connections:Exclude people who like Woke Blacks, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:The African History Network, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africahism, people_who_match:interests:Melanin, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:My Black is Beautiful, 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:Malcolm X, people_who_match:interests:Black (Color), people_who_match:interests:Black, girls_rock_behaviors:African American (US), girls_rock_behaviors:Field of study: African- American history 822 43 https://www.facebook.com/Woke-B|acks-294234600956431/ Come Check out our page, Uniting Black people worldwide! 30.80752 1925.47 RUB 2016-10-14T07:24:14-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 1466.848ms · Data source: simonw/russian-ira-facebook-ads-datasette