home / russian-ads

display_ads (view)

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

3 rows where an ad_target was location_living_in:united_states:Texas

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
44 location_living_in:united_states:Texas, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/south_lone_star You can go to hell or follow @south_lone_star instead! Texas is where you always want to be! We are Texans and we're not like the rest! Follow us! Lone Star State Rebels (@south_lone_star) - Instagram photos and videos 0.0 0.00 USD 2015-10-13T01:34:37-07:00 2015-10-15T23:59:59-07:00
720 location_living_in:united_states:Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 38198 2933 https://www.facebook.com/events/150705875335985/ Five police officers were killed in an organized attack during the protest in Dallas this Blue Lives Matter 138.16864 8635.54 RUB 2016-07-08T04:44:17-07:00 2016-07-10T04:44:15-07:00
1962 no image location_living_in:united_states:Texas, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 18 3 https://www.facebook.com/Secured-Borders-757183957716200/ Barack Hussein Obama has tried very hard to open the doors for his friends from Middle East and to create a most welcoming environment for Muslims in general. He forced our government to give them countless benefits and managed to create an atmosphere of total omnipotence for them with the help of CAIR. It all would be alright, if he was a president of a Muslim country, but he is president of UNITED STATES OF AMERICA, which makes his eternal love for Muslims a mere TREACHERY! Barack Hussein Obama and his lap dog Hillary should never be allowed control our lives ever again! 7.891520000000001 493.22 RUB 2016-08-04T05:12:07-07:00 2016-08-05T05:12:06-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 1727.523ms · Data source: simonw/russian-ira-facebook-ads-datasette