home / russian-ads

display_ads (view)

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

21 rows where an ad_target was interests:Police misconduct

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1021 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 38002 5645 https://www.facebook.com/BIacktivist-128371547505950/ repost Back when tv was dope... melanin #blacklove #tv #blacksitcoms #blacktv #blacktelevision 8.0 500.00 RUB 2016-11-18T08:22:22-08:00 2016-11-19T08:22:22-08:00
1041 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 31096 3516 https://www.facebook.com/Blacktivist-128371547505950/ Black intelligence is one of the most highly feared things in this country. 4.8 300.00 RUB 2016-11-03T08:09:10-07:00 2016-11-10T07:09:10-08:00
1045 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 20322 2847 https://www.facebook.com/BIacktivist-128371547505950/ Absolutely stunning Child. 6.4 400.00 RUB 2016-11-01T06:22:57-07:00 2016-11-02T06:22:56-07:00
1052 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 10808 2218 https://www.facebook.com/BIacktivist-128371547505950/ How interesting! But you can only get white from black. 9.6 600.00 RUB 2016-10-20T07:54:43-07:00 2016-10-21T07:54:41-07:00
1057 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 16202 1872 https://www.facebook.com/blacktivists/ Growing up dark skinned in America is not an easy task to do. Tell your Children that they represent a rainbow of beautiful shades, that make them special. 6.4 400.00 RUB 2016-11-01T06:23:30-07:00 2016-11-02T06:23:29-07:00
1070 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 28025 3291 https://www.facebook.com/BIacktivist-128371547505950/ Bless this kid and her parents who keep out Heritage alive. #RosaParks 6.4 400.00 RUB 2016-11-01T06:21:48-07:00 2016-11-02T06:21:47-07:00
1072 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 12077 2393 https://www.facebook.com/BIacktivist-128371547505950/ Dear cop, please stop using our children for publicity stunts. 8.0 500.00 RUB 2016-10-20T07:51:40-07:00 2016-10-21T07:48:36-07:00
1074 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 68239 9666 https://www.facebook.com/Blacktivist-128371547505950/ It‘s should be an official terminology. 8.0 500.00 RUB 2016-11-03T08:09:45-07:00 2016-11-10T07:09:45-08:00
1095 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:Police misconduct, interests:African— American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 17618 2094 https://www.facebook.com/Blacktivist-128371547505950/ Never back down, my friends. Black America is so tired of explaining and debating. 6.4 400.00 RUB 2016-11-01T06:24:00-07:00 2016-11-02T06:23:59-07:00
1098 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 18808 2494 https://www.facebook.com/Blacktivist-128371547505950/ You won‘t see this image Circulating on social media, because it‘s too positive for America. 4.8 300.00 RUB 2016-11-18T08:22:43-08:00 2016-11-19T08:22:43-08:00
1179 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 20526 3605 https://www.facebook.com/BIacktivist-128371547505950/   6.4 400.00 RUB 2016-11-18T08:21:54-08:00 2016-11-19T08:21:54-08:00
2510 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:Police misconduct, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3735 461 https://b|ackmattersus.com/18360-blaCk-Iives-matter-flag-hoisted-on-campus- Black Lives Matter vigil draws crowd to ISU The school President of Illinois State University, Larry Dietz among several other supporters gathered at the campus square to participate in the Black Lives Ma Black Lives Matter Flag Hoisted On Campus To Honor Black Lives | BM BM 6.4 400.00 RUB 2016-10-21T05:32:21-07:00 2016-10-24T05:32:20-07:00
2517 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:Police misconduct, interests:African—American culture, interests:African—American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus.mvmnt/ More and more unarmed black people are killed by police. And the cases of abuse and excessive force are simply swept under the rug. #ThatsWhyWeProtest https:l/www.facebook.comlevents/662307087278604/ 0.0 0.00 USD 2016-10-21T05:34:54-07:00 2016-10-24T05:34:53-07:00
2537 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:Police misconduct, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4771 649 https://www.facebook.com/blackmattersus.mvmnt/ I guess social issues such as police brutality is not a priority for American politicians. 4.89424 305.89 RUB 2016-10-20T07:23:44-07:00 2016-10-21T07:23:43-07:00
2985 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African— American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-disorimination, interests:Cop Block, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 723 146 https://www.facebook.com/Watch-the—Police-1095374457243609/ On the video you see Brinkley Police Department Chief Edward Randle driving his car more than 100 miles per hour to the football game. He is pulled over by cops. They realize that they stopped their chief, so they just laughed together and let their chief go. According to THV11 "since the officer did not announce the truck’s license plate number into his radio, nobody else would know the chief had been pulled over.” Fortunately this guardian of order didn't kill anyone with his speeding car that day, but he probably will do it next time. 1.6 100.00 RUB 2016-11-03T07:59:21-07:00 2016-11-04T07:59:21-07:00
2986 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African— American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 721 101 https://www.facebook.com/WatCh-the-Police-1095374457243609/ The man on the video knows his rights better than cops do. Police state failed in this case. 1.04 65.00 RUB 2016-11-11T06:07:26-08:00 2016-11-12T06:07:26-08:00
2987 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African— American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 416 38 https://www.facebook.com/WatCh-the-Police-1095374457243609/ Incredible battle: cop against his own logic and evidence. Such "officers" make only annoy people! 1.59984 99.99 RUB 2016-11-03T07:59:54-07:00 2016-11-04T07:59:54-07:00
2989 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African- American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti—disorimination, interests:Cop Block, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 445 51 https://www.facebook.com/Watch-the—Police-1095374457243609/ Once again it's legal to film the police. You don't have to be a journalist to do that. You don't need a special permission. It's your constitutional right! Here you can see what lesson was given to a cop who threatened man with jail for filming him. Film the Police! It's legal! 1.6 100.00 RUB 2016-11-03T07:59:38-07:00 2016-11-04T07:59:38-07:00
2990 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African— American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-disorimination, interests:Cop Block, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Watch-the—Police-1095374457243609/ Here you can see guy was harassed for allegedly having a bottle of alcohol in his University dorm room. Pigs forced their way into the room without his consent and opened the fridge. When they didn't find alcohol (there was just ranch dressing) they threatened him with expelling from University. VVTF?? This is what you get when you are going to get education in America. 0.0 0.00 USD 2016-11-11T06:08:00-08:00 2016-11-12T06:08:00-08:00
2993 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African- American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Watch-the—Police-1095374457243609/ The man pulled over because cop thought that he "parked weirdly". The cop calls him "tatted up gangster" and claims that he is talking shit. Is it a proper behavior of public servant? 0.0 0.00 USD 2016-11-11T06:06:27-08:00 2016-11-12T06:06:27-08:00
2995 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African- American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Watch-the-Police-1095374457243609/ This 17-year-old girl refused to put away her lollipop and a bag of chips in the New York Metro. Food is prohibited in New York Metro. Cops decided not to take her food away. Look what they did instead of this. After the incident police didn't charge the girl with anything. It means they did it just for their own pleasure. 0.0 0.00 USD 2016-11-03T07:59:05-07:00 2016-11-04T07:59:05-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 1365.144ms · Data source: simonw/russian-ira-facebook-ads-datasette