home / russian-ads

display_ads (view)

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

21 rows where an ad_target was placements:on pages: News Feed 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:Jr., 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:Jr., 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:Jr., 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
935 location:United States, age:16 - 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:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, 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:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Syria-News, people_who_match:interests:Black (Color), people_who_match:interests:Refugees of the Syrian Civil War, people_who_match:interests:Syria Charity 52688 5519 https://www.facebook.com/blacktivists/ Police brutality in America gone crazy. But America is too busy bombing countries in the Middle East. 12.624319999999999 789.02 RUB 2017-05-24T08:24:35-07:00 2017-05-29T08:00:00-07:00
1696 location:United States, age:13 - 65+, placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Understanding racial segregation in the united states 421 2 https://www.facebook.com/Blackluive-1725227467722991/ Racism is not “Heritage and Honor”.lt’s time to stand up for what’s right. 1.2815999999999999 80.10 RUB 2016-03-17T09:07:59-07:00 2016-03-26T16:39:00-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:Jr., 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:Jr., 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:Jr., 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:Jr., 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
2752 location:United States, age:16 - 50, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:State police, people_who_match:interests:Support Law Enforcement, people_who_match:interests:Fallen Police Officers, people_who_match:interests:The Thin Blue Line, people_who_match:interests:Law enforcement, people_who_match:interests:Police officer, people_who_match:interests:Law enforcement agency, people_who_match:interests:Heroes Behind The Badge 1914 0 https://www.facebook.com/Back-the-Badge-341177102896426/ Community of real heroes who risk their lives to Make America Safe Again! 13.17648 823.53 RUB 2016-10-14T07:43:20-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
2887 location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Evangelism, people_who_match:interests:Catholicism, people_who_match:interests:Protestantism, and_must_also_match:interests:Jesus 1518 0 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Take up your cross and follow Jesus! 13.647680000000001 852.98 RUB 2016-10-14T08:09:03-07:00  
2946 location:United States, age:25 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Ron Paul, people_who_match:interests:Rand Paul, people_who_match:interests:Gary Johnson, and_must_also_match:interests:Libertarian Party (United States) 467 0 https://www.facebook.com/Defend-the-2nd-692068924291672/ We believe in individual liberty and think that our government is just a waste of our taxpayers money! 12.931840000000001 808.24 RUB 2016-10-14T07:21:51-07:00  
3037 location_living_in:United States, age:18 - 65+, 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:Stop Racism”, people_who_match:interests:African- American culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African- American history, people_who_match:interests:Say To No Racism, people_who_match:interests:Malcolm X 60 5 https://www.facebook.com/Williamsathalvin/ Explosion in Manchester, ISIS attack in Marawi, bomb attack in Bangkok, car bombing in Syria — all happened in one day. This is heartbreaking and we are praying for everyone. Don’t you think that it is vicious cycle? Now they will bomb more in Syria to stop terrorists. And then another bombing here and there. But these attacks can’t bring Peace. Stop wasting money on weapons. America, you better stay away from this and start taking care of your own people. Within your own country. 1.77056 110.66 RUB 2017-05-25T04:56:56-07:00 2017-05-28T07:52:35-07:00
3245 location:United States, age:18 - 65+, placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, placements:Instant Article 1 0 https://www.facebook.com/brownunitedfront/ LIKE if you've ever felt that way! 0.01408 0.88 RUB 2017-03-17T07:56:43-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 1325.723ms · Data source: simonw/russian-ira-facebook-ads-datasette