home / russian-ads

display_ads (view)

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

10 rows where an ad_target was interests:Martin Luther King and 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

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