home / russian-ads

display_ads (view)

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

4 rows where an ad_target was people_who_match:interests:Tea Party Patriots

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
34 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservatism, people_who_match:interests:Veterans Day, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Veterans, people_who_match:interests:Republican Party (United States), people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterans_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol 0.0 0.00 USD 2016-05-12T02:31:30-07:00  
1913 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Tea Party movement, people_who_match:interests:The Tea Party, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Americans for Prosperity, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Donald Trump Jr. 0 0 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News Teapartypat 0.0 0.00 USD 2016-04-19T08:05:39-07:00  
1937 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Support our troops, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Proud to be an American, people_who_match:interests:ForAmerica, people_who_match:interests:United States Armed Forces, people_who_match:interests:Veterans, people_who_match:interests:Patriotism, people_who_match:interests:The Veterans Site 22635 41 https://www.instagram.com/instotus/ This is a community for everyone whose heart is with America. Don't be a stranger - Follow @instotus Instagram Of The United Instotus 46.559839999999994 2909.99 RUB 2016-02-25T01:06:31-08:00 2016-03-24T05:00:00-07:00
1947 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Patriot (American Revolution), people_who_match:interests:Tea Party Patriots 21912 86 https://www.instagram.com/instotus/ Instagram Of The United StatesDon't be a stranger, be a patriot! Follow us! instotus Instagram Of The United Instotus 94.94976 5934.36 RUB 2016-03-16T07:43:24-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 1236.183ms · Data source: simonw/russian-ira-facebook-ads-datasette