home / russian-ads

display_ads (view)

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

7 rows where an ad_target was people_who_match:interests:The Tea Party

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1908 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 279 1 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 #Elections2016. Let's have some fun! Don't stay aside! Tea Party News ( @tea Teapartypat 0.02112 1.32 RUB 2016-04-19T08:12:20-07:00  
1909 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 165121 78 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 ( @tea Teapartypat 159.52928 9970.58 RUB 2016-04-21T00:28:18-07:00  
1910 location:united_states:Alabama, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:South Carolina, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservative News Today, people_who_match:interests:Young Republicans, people_who_match:interests:The Conservative, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America, people_who_match:interests:Donald Trump for President, people_who_match:interests:College Republicans 0 0 https://www.instagram.Com/tea_party_news/ Florida goes Trump! Here are Florida Cities participating: Daytona Beach, Tampa, Fort Myers, Miami, Orlando, Pensacola, Ft Lauderdale, Sarasota, Clearwater, Oxford, West Palm Beach, Coral Springs. For more details write us in comments or via DM. Go Tea Party! Pro- American, Pro—Guns, Pro—Patriotic! Tea Party News Muslimlnst 0.0 0.00 USD 2016-08-16T05:47:11-07:00  
1911 location:united_states:Alabama, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:South Carolina, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservative News Today, people_who_match:interests:Young Republicans, people_who_match:interests:The Conservative, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America, people_who_match:interests:Donald Trump for President, people_who_match:interests:College Republicans 9244 85 https://www.instagram.Com/tea_party_news/ Florida goes Trump! Here are Florida Cities participating: Daytona Beach, Tampa, Fort Myers, Miami, Orlando, Pensacola, Ft Lauderdale, Sarasota, Clearwater, Oxford, West Palm Beach, Coral Springs. For more details write us in comments or via DM. Go Tea Party! Pro- American, Pro—Guns, Pro—Patriotic! Tea Party News Teapartypat 50.85056 3178.16 RUB 2016-08-16T05:49:47-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  
1917 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Conservative Republicans of Texas, people_who_match:interests:Donald Trump for President 108433 857 https://www.facebook.com/Teapartypat—1649468318669272/ This is the way our Children have to be raised. It's not the promotion of violence. It's the promotion of confidence and the ability to defend yourself. Follow us if this video makes you proud! 276.9112 17306.95 RUB 2016-04-22T10:43:02-07:00  
1924 location:United States, age:13 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:The Tea Party 0 0 https://www.instagram.Com/tea_party_news/ Are you sick and tired of people saying "ready for Hillary"? Because they piss me off every day. And I really feel hopeless trying to explain to them she's not a good Choice. Unless you want to see America in flames. Click to Learn More! Tea Party News ( @tea Teapartypat 0.0 0.00 USD 2016-01-15T02:09:19-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 1232.677ms · Data source: simonw/russian-ira-facebook-ads-datasette