home / russian-ads

display_ads (view)

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

4 rows where an ad_target was interests:Supporting Our Veterans sorted by impressions

id img targeting impressions ▼ clicks url text spend_usd spend_amount spend_currency created ended
2784 location_living_in:United States, interests:Veterans, interests:United States Department of Veterans Affairs, interests:Disabled American Veterans, interests:Supporting Our Veterans, home_composition:Veterans in home, excluded_connections:Exclude people who like Veterans Come First, age:18 - 39, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! Veterans Come First 0.0 0.00 USD 2017-02-21T01:13:46-08:00  
2791 location_living_in:United States, interests:Veterans, interests:United States Department of Veterans Affairs, interests:Disabled American Veterans, interests:Supporting Our Veterans, home_composition:Veterans in home, excluded_connections:Exclude people who like Veterans Come First, age:18 - 39, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 15 2 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.80096 50.06 RUB 2017-02-21T01:13:46-08:00  
2790 location_living_in:United States, interests:Support our Homeless Veterans., interests:Supporting Our Veterans, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 164 5 https://www.facebook.comNeterans-Come-First-1757336424535312/ HILLARY CLINTON CHEATS AMERICAN VETERANS The last time Hillary Clinton had a press conference on veterans’ issues was in 2015 and since then all her plans and offers concerning veterans’ life improvement were stated only in emails made by her staff. And here are some real Clinton decisions: —Last year, Clinton Claimed that the Veterans Administration Scandal had been exaggerated by Republicans. —In 2007, Clinton was one of only 14 senators to vote against a 2007 supplemental appropriations bill that contained $1.8 billion for veterans’ medical care. -In 2006, Clinton voted against an amendment that would have added $20 million for veterans’ health care facilities. -In 2003, Clinton voted against a budget resolution that called for “$13 billion for veterans to receive concurrent disability and retirement benefits.” In other words, Hillary Clinton is one of the politicians who are to blame for the poor social condition of our veterans. She has systematically ignored the issue and even voted against providing veterans with financial aid which they need so bad! Hardly will she Change her mind on the issue if she is elected. Clinton poses a direct threat to the American veterans’ society, but still practically no one raises these concerns. Think twice before voting for her! 1.6 100.00 RUB 2016-10-12T05:56:41-07:00 2016-10-13T05:55:07-07:00
29 location:United States, interests:Patient Protection and Affordable Care Act, interests:Supporting Our Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 3527 33 https://instagram.Com/veterans_us/ What do you know about PTSD? Do you know that US Military deaths since 1999 count 6,904, while veterans suicides since 1999 account for 128,480? We'are losing 18 times more warriors in Civilian life than on the battlefields! Learn more! Follow us! Veterans USA ( @veterans GovSpending 24.09936 1506.21 RUB 2015-11-12T04:38:35-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 1396.083ms · Data source: simonw/russian-ira-facebook-ads-datasette