home / russian-ads

display_ads (view)

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

8 rows where an ad_target was interests:| Have a Dream

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
1224 no image location_living_in:United States, interests:| Have a Dream, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 91 7 https://www.facebook.com/pages/Blacktivist/128371547505950 I have a dream... 0.64 40.00 RUB 2015-09-04T02:51:27-07:00 2015-09-06T02:51:27-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

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 1335.133ms · Data source: simonw/russian-ira-facebook-ads-datasette