home / russian-ads

display_ads (view)

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

13 rows where an ad_target was placements:Instream Video on desktop computers

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
800 location:United States, interests:Martin Luther King, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 65+, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ I pity anyone who has to deal with neighbors in an apartment building. Especially when you have to deal with the complaining and passive- aggressive types. Oh, and let’s not forget gentrifiers. Or, as I like to call them, “white migrators.” Apparently, instead of knocking on a neighbor’s door, people take the easy and passive-aggressive way out and just leave notes instead. But one man wasn’t having it. Link: https://scontent-arn2-1 .xx.fbcdn.net/v/t1 .0-9/14572967_1772905896322 988_913778538274424647_n.jpg?oh=984945f2582b54297fe1f8f786f297be& oe=5862D508 Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 0.0 0.00 USD 2016-10-18T02:55:16-07:00 2016-10-15T02:45:48-07:00
801 location:United States, interests:Martin Luther King, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ I pity anyone who has to deal with neighbors in an apartment building. Especially when you have to deal with the complaining and passive- aggressive types. Oh, and let’s not forget gentrifiers. Or, as I like to call them, “white migrators.” Apparently, instead of knocking on a neighbor’s door, people take the easy and passive-aggressive way out and just leave notes instead. But one man wasn’t having it. Link: https://scontent-arn2-1 .xx.fbcdn.net/v/t1 .0-9/14572967_1772905896322 988_913778538274424647_n.jpg?oh=984945f2582b54297fe1f8f786f297be& oe=5862D508 Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 0.0 0.00 USD 2016-10-20T08:03:20-07:00 2016-10-15T02:45:48-07:00
844 location:United States, interests:Martin Luther King, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Danney Williams, 30, has been trying since at least 1999 to be acknowledged as the out-of-wedlock son of former President Bill Clinton and a black prostitute in Little Rock, Arkansas. Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvin 0.0 0.00 USD 2016-10-20T08:03:20-07:00 2016-10-19T02:55:24-07:00
2341 location:united_states:Philadelphia, Pittsburgh Pennsylvania, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Black Power, people_who_match:interests:Racial equality, people_who_match:interests:Social justice, people_who_match:interests:Black Panther Party, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ Please share this disturbing video. A routine revenue collection stop turned into a nightmare for this black man. Kevin Campbell was driving his wife‘s minivan home in June when he was targeted for revenue collection by Allen Park Police Officer Daniel Mack. Mack literally kidnapped Campbell, placed him in handcuffs, threw him in a cage over a suspended license, accused Campbell of having drugs on him despite the fact that the K9 didn‘t find anything. Moreover, the cop sodomized him by putting the illegal substance inside his body. There was no search warrant. 0.0 0.00 USD 2016-10-26T06:12:51-07:00 2016-10-13T01:06:08-07:00
2342 location_living_in:united_states:Minneapolis (+25 mi) Minnesota, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Black Power, people_who_match:interests:Racial equality, people_who_match:interests:Social justice, people_who_match:interests:Black Panther Party, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ Please share this disturbing video. A routine revenue collection stop turned into a nightmare for this black man. Kevin Campbell was driving his wife‘s minivan home in June when he was targeted for revenue collection by Allen Park Police Officer Daniel Mack. Mack literally kidnapped Campbell, placed him in handcuffs, threw him in a cage over a suspended license, accused Campbell of having drugs on him despite the fact that the K9 didn‘t find anything. Moreover, the cop sodomized him by putting the illegal substance inside his body. There was no search warrant. 0.0 0.00 USD 2016-10-26T06:13:56-07:00 2016-10-13T01:06:08-07:00
2343 location_living_in:united_states:New York (+25 mi) New York, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Black Power, people_who_match:interests:Racial equality, people_who_match:interests:Social justice, people_who_match:interests:Black Panther Party, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ Please share this disturbing video. A routine revenue collection stop turned into a nightmare for this black man. Kevin Campbell was driving his wife‘s minivan home in June when he was targeted for revenue collection by Allen Park Police Officer Daniel Mack. Mack literally kidnapped Campbell, placed him in handcuffs, threw him in a cage over a suspended license, accused Campbell of having drugs on him despite the fact that the K9 didn‘t find anything. Moreover, the cop sodomized him by putting the illegal substance inside his body. There was no search warrant. 0.0 0.00 USD 2016-11-01T03:03:08-07:00 2016-10-13T01:06:08-07:00
2344 location_living_in:united_states:New York (+25 mi) New York, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Martin Luther King, people_who_match:interests:Black Power, people_who_match:interests:African- American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ Please share this disturbing video. A routine revenue collection stop turned into a nightmare for this black man. Kevin Campbell was driving his wife‘s minivan home in June when he was targeted for revenue collection by Allen Park Police Officer Daniel Mack. Mack literally kidnapped Campbell, placed him in handcuffs, threw him in a cage over a suspended license, accused Campbell of having drugs on him despite the fact that the K9 didn‘t find anything. Moreover, the cop sodomized him by putting the illegal substance inside his body. There was no search warrant. 0.0 0.00 USD 2016-11-03T00:29:17-07:00 2016-10-13T01:06:08-07:00
2375 location:united_states:Philadelphia, Pittsburgh Pennsylvania, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Black Power, people_who_match:interests:Racial equality, people_who_match:interests:Social justice, people_who_match:interests:Black Panther Party, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ The cop beat this man like he was a runaway slave. 0.0 0.00 USD 2016-10-26T06:12:51-07:00 2016-10-03T04:47:13-07:00
2376 location_living_in:united_states:Minneapolis (+25 mi) Minnesota, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Black Power, people_who_match:interests:Racial equality, people_who_match:interests:Social justice, people_who_match:interests:Black Panther Party, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ The cop beat this man like he was a runaway slave. 0.0 0.00 USD 2016-10-26T06:13:56-07:00 2016-10-03T04:47:13-07:00
2377 location_living_in:united_states:New York (+25 mi) New York, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Black Power, people_who_match:interests:Racial equality, people_who_match:interests:Social justice, people_who_match:interests:Black Panther Party, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ The cop beat this man like he was a runaway slave. 0.0 0.00 USD 2016-11-01T03:03:08-07:00 2016-10-03T04:47:13-07:00
2378 location_living_in:united_states:New York (+25 mi) New York, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers, people_who_match:interests:Martin Luther King, people_who_match:interests:Black Power, people_who_match:interests:African- American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/blackmattersus.mvmnt/ The cop beat this man like he was a runaway slave. 0.0 0.00 USD 2016-11-03T00:29:17-07:00 2016-10-03T04:47:13-07:00
2512 location_living_in:United States, interests:Martin Luther King, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 0 0 https://www.facebook.com/blackmattersus.mvmnt/ This cop brutalized the Child for taking a shortcut back home. This is why we have the BLM movement against injustice and police brutality. 0.0 0.00 USD 2016-10-21T08:42:27-07:00 2016-10-21T07:25:02-07:00
2526 location_living_in:United States, interests:Martin Luther King, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 19226 1236 https://www.facebook.com/blackmattersus.mvmnt/ Here is yet another reminder that in America it takes seven cops to take down one black man. 6.13488 383.43 RUB 2016-10-21T08:42:27-07:00 2016-10-24T05:34:00-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/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 1306.367ms · Data source: simonw/russian-ira-facebook-ads-datasette