home / russian-ads

display_ads (view)

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

11 rows where an ad_target was interests:Union of Huffington Post Writers and Bloggers

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
3043 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Elections in the United States, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Malcolm X, interests:United States presidential election, interests:2016, interests:Union of Huffington Post Writers and Bloggers, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 14577 1926 https://www.facebook.com/WilliamsandKalvin/ Never doubt that! 2.0963200000000004 131.02 RUB 2016-11-11T07:28:43-08:00 2016-11-14T07:28:43-08:00
3060 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Elections in the United States, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Malcolm X, interests:United States presidential election, interests:2016, interests:Union of Huffington Post Writers and Bloggers, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 1114 85 https://www.facebook.com/Williamsathalvin/ White racist can’t keep calm when a black man is all fine. They can’t keep calm even if black people are treated just like white people. I mean they are just treated equally. And no white racist can stand it! Why? I wonder if all the white Americans are sick in their heads? 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 3.2 200.00 RUB 2016-12-03T06:50:52-08:00 2016-12-05T06:50:52-08:00
3068 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Elections in the United States, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Malcolm X, interests:United States presidential election, interests:2016, interests:Union of Huffington Post Writers and Bloggers, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilliamsandKalvin/ Agree! 0.0 0.00 USD 2016-12-08T06:09:39-08:00 2016-12-09T06:09:39-08:00
3072 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:Elections in the United States, interests:African— American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Malcolm X, interests:United States presidential election, interests:2016, interests:Union of Huffington Post Writers and Bloggers, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 8610 1071 https://www.facebook.com/WilliamsandKalvin/ If your black matters, Click https://represent.com/my-black-matters?store=black-matters-us 3.2 200.00 RUB 2016-11-22T07:25:56-08:00 2016-11-25T07:25:56-08: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 1394.67ms · Data source: simonw/russian-ira-facebook-ads-datasette