home / russian-ads

display_ads (view)

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

6 rows where an ad_target was people_who_match:Friends of connections: Friends of people who are connected to Stop A.|.

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1299 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 1492 288 https://www.facebook.com/Stop-AI-896610653786585/ Fortunately, some patriots in the United States don't stay away, while traitors destroy this country. Our friends from San Diego organized a rally to support ideas of Donald Trump. Patriots carried and waved American flags, while the CIinton/Sanders supporters carried MEXICAN flags and attempted to confront a very diverse group of Donald Trump supporters. That explains why the Democrats encourage the illegal immigration. They are ready to destroy America just to be elected. We have to defend this nation! Let's organize rallies against the illegal immigration around the whole country! Let's flood the United States with American flags! If you have a desire to organize a rally in your City, please contact us. We can help you. Only our patriotism can save the United States of America! 3.2 200.00 RUB 2016-06-06T07:46:25-07:00 2016-06-08T07:46:24-07:00
1321 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 0 0 https://www.facebook.com/Stop-AI-896610653786585/ German Police arrested a 27-year-old man after he stabbed four people at a train station located near Munich early Tuesday morning. He killed a 50-year-old man and injured three other men. Witnesses Claim the man screamed “Allah Akbar” during the attack, but liberal officials think the suspect had no Islamist motive. 0.0 0.00 USD 2016-05-12T01:39:36-07:00 2016-05-14T01:39:36-07:00
1329 location:united_states:Tennessee, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 682 192 https://www.facebook.com/Stop-AI-896610653786585/ I cannot understand why democrats encourage breaking the law. They harbor illegal aliens who are breaking our immigration and labor laws. They praise rioters and vandals... What's wrong with them? 8.0 500.00 RUB 2016-07-14T02:32:13-07:00 2016-07-15T02:32:12-07:00
3258 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 10534 2523 https://www.facebook.com/StopAlllnvaders/ No more mosques! We have to protect American culture! 3.2 200.00 RUB 2017-05-18T08:21:15-07:00 2017-05-20T12:51:00-07:00
3261 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 2572 566 https://www.facebook.com/StopAlllnvaders/ Like = yes. Share = hell, yeah! Ignore = no. 1.22384 76.49 RUB 2017-05-15T08:27:57-07:00 2017-05-17T08:27:57-07:00
3263 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 6355 1015 https://www.facebook.com/StopAlllnvaders/ This invasive war cult has no place in any Civilized society! America, as the land of the free, should ban Sharia on federal level! 3.2 200.00 RUB 2017-05-17T08:29:31-07:00 2017-05-19T08:29:31-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 1325.719ms · Data source: simonw/russian-ira-facebook-ads-datasette