home / russian-ads

display_ads (view)

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

16 rows where an ad_target was interests:Tea Party Patriots

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
21 location:United States, interests:Tea Party Patriots, age:18 - 65+, placements:Instagram Feed 8292 73 https://instagram.Com/veterans_us/ Throughout the history of our nation, there have been many wars. The soldiers have always carried the burden of death or injury while in battles. Politicians continually act as if the soldiers are their pawns, and their soldier pawns are expendable in war. Hence, we have the saddest statistics of military injuries. 1 out of 10 veterans is disabled, often by injuries sustained in combat. Join us! Learn more! Veterans USA ( @veterans GovSpending 47.176320000000004 2948.52 RUB 2015-11-13T06:27:35-08:00  
27 location:United States, interests:Tea Party Patriots, interests:Justice, age:18 - 65+, language:English (US), placements:Instagram Feed 2616 6 https://instagram.Com/gov_spending/ Why our government wastes $11 MLN per day on |S|L Instead of saving more than 1300 lives of vets. Why do we engage in another conflict when we have so many unsolved problems in the US? It is a shame that our vets are treated so badly. They do not receive proper health care and unemployment benefits. They do not receive the respect they deserve. I do not want our government to create new veterans in such conditions. Join us for more statistics! Click learn more! The US Gov Spending Stats Instalol 7.473920000000001 467.12 RUB 2015-11-18T03:33:41-08:00 2015-11-19T08:26:00-08:00
1285 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 40 1 https://www.facebook.com/stoptherefugees/ Stop refugees! Humor and latest news! 1.1736 73.35 RUB 2015-12-22T06:40:56-08:00  
1303 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 486 55 https://www.facebook.com/stoptherefugees/ Stop refugees! The're taking ourjobs! 11.39536 712.21 RUB 2015-12-22T06:40:56-08:00  
1320 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 109 12 https://www.facebook.com/stoptherefugees/ This is become a real problem! Stop refugees! 3.33456 208.41 RUB 2015-12-22T06:40:56-08:00  
1390 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ Your home is your home, stop invading! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1392 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ Stop refugees! Humor and latest news! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1395 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ Stop refugees! They're taking ourjobs! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1397 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ This time you need to stay at home! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1399 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ This time you need to stay at home! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1401 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ Anti-immigration is the only salvation! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1403 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ This is become a real problem! Stop refugees! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1405 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ Your home is your home, stop invading! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1407 location:United States, interests:Tea Party Patriots, interests:Confederate States of America, interests:Chicks On The Right, interests:Conservative Tribune, interests:100 Percent FED Up, excluded_connections:Exclude people who like Stop Refugees, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/stoptherefugees/ Anti-immigration is the only salvation! 0.0 0.00 USD 2015-12-22T06:40:56-08:00  
1898 location:United States, interests:Tea Party movement, interests:Tea Party Patriots, interests:Ted Cruz, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://www.instagram.Com/tea_party_news/ Tea Party: Pictures, Videos, Breaking News. Click Learn More! Tea Party News ( @tea Teapartypat 0.0 0.00 USD 2015-12-01T06:35:35-08:00  
1899 location:United States, interests:Tea Party movement, interests:Tea Party Patriots, interests:Ted Cruz, age:18 - 65+, language:English (US), placements:Instagram Feed 9222 52 https://www.instagram.Com/tea_party_news/ Tea Party: Pictures, Videos, Breaking News. Click Learn More! Tea Party News ( @tea Teapartypat 43.89664 2743.54 RUB 2015-12-02T05:13:16-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 1347.262ms · Data source: simonw/russian-ira-facebook-ads-datasette