home / russian-ads

display_ads (view)

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

12 rows where an ad_target was interests:Nelson Mandela

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1220 no image location:united_states:Washington, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 620 100 https://www.facebook.com/Blacktivist-128371547505950/ You don‘t Choose the color to be born with, but you Choose your destiny. #IamBlackAndProud 1.6 100.00 RUB 2016-05-06T05:45:23-07:00 2016-05-07T05:45:23-07:00
1221 no image location:United States, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/   0.0 0.00 USD 2016-08-10T04:54:06-07:00 2016-05-07T05:45:23-07:00
1223 no image location:United States, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 805 60 https://www.facebook.com/pages/Blacktivist/128371547505950 Sidney Poitier, Harry Belafonte, and Charlton Heston at the Civil Rights March, c.1963 2.08 130.00 RUB 2015-09-07T00:47:57-07:00 2015-09-08T00:47:56-07:00
1226 no image location:united_states:Washington, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1256 82 https://www.facebook.com/Blacktivist-128371547505950/ All Roads Lead To Washington 00 On October 10, 2015 in Washington, DC, at the National Mall, The Honorable Minister Louis Farrakhan will convene the 20th Anniversary of the Million Man March under the theme: Justice or Else! “The Million Man March was one of the most historic organizing and mobilizing events in the history of Black people in the United States,” said Chicago—based Dr. Conrad Worrill, who was a main organizer of the March and the current president emeritus of the National United Black Front. The widespread death, rising racism, mob attacks and police brutality on Blacks coupled with economic deprivation and stark poverty, requires that something must be immediately done to address and correct the condition. We should stop the violence and the killings and present ourselves as a united front before the Government of the United States of America. Fredrick Douglas said “ Power concedes nothing except by a demand”. Our demand of government must be backed by the power of our unity and love of the brotherhood. It's really important for all of us, brothers and sisters. Join the Movement! 10-10-15 Justice Or Else! 11.200000000000001 700.00 RUB 2015-10-07T02:54:52-07:00 2015-10-09T02:54:51-07:00
1229 no image location:United States, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 16282 4984 https://www.facebook.com/Blacktivist-128371547505950/ When police officer attacks black man with cell phone for recording him and treats him like a little boy, it is harassment 11.200000000000001 700.00 RUB 2016-08-10T04:55:47-07:00 2016-08-11T04:55:44-07:00
1230 no image location:United States, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 7776 1840 https://www.facebook.com/Blacktivist-128371547505950/ The more force was necessary, the more likely the victim is to be black. 8.0 500.00 RUB 2016-08-10T04:55:14-07:00 2016-08-11T04:55:13-07:00
1231 no image location:United States, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 11337 2341 https://www.facebook.com/Blacktivist-128371547505950/ What if black cops, who are funded by tax payers to protect and serve start killing white people during traffic stops and raids? How much Blue Lives really matter then? 11.200000000000001 700.00 RUB 2016-08-10T04:54:42-07:00 2016-08-11T04:54:39-07:00
2487 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Melanin, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:T- shirt, interests:Black Women Are Beautiful, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 596 29 https://www.bonfirefunds.com/stop-police-brutality Attention, everyone! Whether you are participating in the National Day of Protest or not, you can support our movement and show your solidarity. You have a unique opportunity to purchase a branded t-shirt expressing your struggle against police brutality. Make everyone see what you think! httpszllwww.bonfirefunds.com/stop-police-brutality httpszllwww.bonfirefunds.com/nationaI-day-of-protest-1 Order your limited edition Stop Police Brutality custom shirts before 10/20/2016! All proceeds benefit BlackMattersUS. Stop Police Brutality BM 6.39968 399.98 RUB 2016-10-14T01:52:00-07:00 2016-10-15T01:51:59-07:00
2488 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Melanin, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Black Women Are Beautiful, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti- discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 8302 857 https://blackmattersus.com/17932-taraji-p-henson-Ioses-movie-role-to—white- “I couldn’t get served at that restaurant,” Taraji P. Henson said. Taraji P. Henson Loses Movie Role To White Actress | BM BM 8.0 500.00 RUB 2016-10-14T01:45:48-07:00 2016-10-15T01:45:47-07:00
2504 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4096 441 https://b|ackmattersus.com/17910-widow-of-dante-parker-i-sti|I-havent-seen- Bianca Carlisle Parker is the wife of Dante Parker, an African American man who was killed by police. Dante Parker, 36, a father of five and a popular newspaper pressman died in police custody on August 12, 2014. He was tasered over 25 times by cops who suspecte Widow Of Dante Parker: | Still Haven’t Seen Police Report | BM BM 8.0 500.00 RUB 2016-10-14T01:37:41-07:00 2016-10-17T01:37:40-07:00
2533 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5112 305 https://blackmattersus.com/17945-new-fi|m-features-b|ack-celebrities-as- Black celebrities star in a distressing new short film titled “Against The Wall.” New Film Features Black Celebrities As Police Brutality Victims | BM BM 8.0 500.00 RUB 2016-10-14T01:40:10-07:00 2016-10-15T01:40:09-07:00
2540 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4488 384 https://b|ackmattersus.com/17953-bIack-kids-Chess-trophies-mistaken-for- Two Black kids won trophies in Chess but most people congratulated them on winning a basketball game. Black Kids’ Chess Trophies Mistaken For Basketball Trophies | BM BM 8.0 500.00 RUB 2016-10-14T01:43:21-07:00 2016-10-15T01:43:20-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 1463.026ms · Data source: simonw/russian-ira-facebook-ads-datasette