home / russian-ads

display_ads (view)

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

17 rows where an ad_target was interests:Police Brutality is a Crime

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
775 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African—American Civil Rights Movement (1954—68), interests:African—American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12624 2096 https://www.facebook.com/WiIliamsKalvin-788980617892144/ Have you ever noticed that?! 4.770560000000001 298.16 RUB 2016-11-01T06:07:42-07:00  
786 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 — 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WiIliamsKalvin-788980617892144/ You are no longer safe and sound even in your own house. You can be killed without a reason even if you commityted no crime. You will see no mercy even if you are a pregnant woman, a black pregnant woman. Subscribe to our Channel: https://www.youtube.oom/channel/UCszPCwUDPvDCRGVRaOthg 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.comNViIliams8kalvin 0.0 0.00 USD 2016-11-01T06:05:06-07:00  
803 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12654 693 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Ice-Cream is something more than just a food you love. When a business expresses its views, cops are attacking, because they know no other way to act! Ben & Jerry’s ice-cream is boycotted by the police officers just because of the opinion of the business owners. So, let’s stand against the political repressions! 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.oom/Williams8kalvih 12.7992 799.95 RUB 2016-10-21T07:46:31-07:00 2016-10-24T07:46:28-07:00
853 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 7428 508 https://www.facebook.com/WiIliamsKalvin—788980617892144/ Kirk Figueroa, 33, ambushed two officers who responded to his East Boston apartment late Wednesday after they received a call about a domestic disturbance possibly involving a gun at the location. He wanted to die exactly the way he ultimately did while vowing to "revolutionize policing." Subscribe to our channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.oom/williams.and.kalvin Follow me on Twitter: https://twitter.oomNVi||iams8kalvin 12.78576 799.11 RUB 2016-11-01T06:06:31-07:00  
857 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 10022 766 https://www.facebook.com/WilIiamsKalvin-788980617892144/ For years, white supremacists in the Dothan, Alabama, police department allegedly planted drugs and guns on black people. There’s a lot going on in this story, which the Alabama Justice Project is said to have helped break thanks to anonymous whistleblowers within the Dothan Police Department. 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 All Cops are Criminals 12.81968 801.23 RUB 2016-11-01T06:06:05-07:00  
863 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 0 0 https://www.facebook.com/Wil|iamsKa|vin-788980617892144/ Black America is not into politics. This is not our game and we don’t want to play with whites. You know why? Because I don’t give a fuck about it! I really don’t care and I don’t know why any black American should care anyhow. We have our own life and our own future in this country. 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/williamsand.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 0.0 0.00 USD 2016-11-18T08:16:22-08:00 2016-11-19T08:16:22-08:00
864 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2635 576 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Never forget to tell Black girls how amazing and beautiful they are! 2.20784 137.99 RUB 2016-10-23T09:54:21-07:00 2016-10-26T09:54:20-07: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 1391.052ms · Data source: simonw/russian-ira-facebook-ads-datasette