home / russian-ads

display_ads (view)

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

3 rows where an ad_target was friends_of_connections:Friends of people who are connected to LGBT United

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
591 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:LGBT community, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:Same-sex marriage 93925 5441 https://www.facebook.com/Igbtun/ We speak for all fellow members of LGBT community across the nation. 507.40992 31713.12 RUB 2016-03-23T05:36:11-07:00  
592 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage 190076 7289 https://www.facebook.com/Igbtun/ We speak for all fellow members of LGBT community across the nation. 576.0 36000.00 RUB 2016-08-04T04:20:05-07:00  
625 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 496 86 https://www.facebook.com/LGBT-United-839497472793277/ THIS IS WHAT RUBY ROSE THINKS OF GIRLS WHO TELL HER THEY'VE 'TURNED THEM GAY' Ruby Rose has recently shared her opinion on the people saying that she “turned them gay”. She gets hundreds of flirty messages every day and she laughs at the idea that Changes someone’s sexuality. Roby Rose thinks that it’s not possible to Change someone’s sexuality because it’s something you’re born with and it’s not Changeable. I agree with her! Unfortunately, bigots like to say that homosexuality is a Choice, so it can be “cured”. Just like Ben Carson thinks that you’re Choosing to be gay and the prison is the proof of that. These ideas lead to thousands of broken lives. Why is it so hard to accept the fact that we were born this way?! 1.00928 63.08 RUB 2016-04-14T07:45: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 1285.008ms · Data source: simonw/russian-ira-facebook-ads-datasette