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

This data as JSON, CSV (advanced)

id	img	targeting	impressions	clicks	url	text	spend_usd	spend_amount	spend_currency	created	ended
775		location:United States, interests:Martin Luther King, 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: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: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: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: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: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: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: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: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: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: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

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/umd-mith/irads/master/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