home / russian-ads

display_ads (view)

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

10 rows where an ad_target was people_who_match:interests:

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
5 no image location_living_in:united_states:Georgia, age:18 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:American Black Film Festival, people_who_match:interests:Cop Block or HuffPost Black Voices, people_who_match:interests:, behaviors:African American (US), behaviors:Field of study: African-American history, behaviors:, politics:Likely to engage with political content (liberal) 29786 201 https://www.facebook.com/GovSpending-1651761351759857/ WHERE is your VOICE? 59.4264 3714.15 RUB 2016-06-15T03:39:52-07:00  
112 location:United States, age:16 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:BlackNews.com or HuffPost Black Voices, people_who_match:interests:, multicultural_affinity:African American (US) 3086 117 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Get breaking news of African American community in the US! 4.336 271.00 RUB 2016-04-12T07:44:27-07:00  
762 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Fly the American Flag, people_who_match:interests:America the Beautiful, people_who_match:interests:American Patriots, people_who_match:interests:| Love the USA, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:Flag of the United States, people_who_match:interests:American Patriot or American patriotism, people_who_match:interests:, employers:Proud to be an American, and_must_also_match:politics:Likely to engage with political content (conservative) 1828 141 https://www.facebook.com/patriototus/ "Patriotism is looking out for yourself by looking out for your country" - Calvin Coolidge. Being Patriotic 16.09856 1006.16 RUB 2017-05-16T01:35:01-07:00  
1714 location:United States, age:13 - 27, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:BlackNews.com or HuffPost Black Voices, people_who_match:interests:, behaviors:African American (US) 65475 92 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Blackluive 135.1328 8445.80 RUB 2016-02-05T06:34:53-08:00  
2781 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans or Supporting Our Veterans, people_who_match:interests:, politics:Likely to engage with political content (conservative), politics:Likely to engage with political content (moderate), and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 21 4 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.50448 31.53 RUB 2017-02-22T05:50:58-08:00  
2783 location:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 65+, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans Day, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support Our Veterans or Disabled American Veterans, people_who_match:interests:Employers: Veteran, people_who_match:interests:, job_title:Veteran, and_must_also_match:industry:Veterans (US) 41172 4134 https://www.facebook.comNeterans-Come-First-1757336424535312/ The community of brave people who make America Great and Free. 240.0 15000.00 RUB 2016-10-14T06:07:27-07:00  
2788 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans or Supporting Our Veterans, people_who_match:interests:, politics:Likely to engage with political content (conservative), politics:Likely to engage with political content (moderate), and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-22T05:48:59-08:00  
2795 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans or Supporting Our Veterans, people_who_match:interests:, politics:Likely to engage with political content (conservative), politics:Likely to engage with political content (moderate), and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! Veterans Come First 0.0 0.00 USD 2017-02-22T05:48:59-08:00  
2904 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:The Second Amendment, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Protecting Your Gun Rights, people_who_match:interests:God, people_who_match:interests:Guns, people_who_match:interests:& American Freedom, people_who_match:interests:Preserve our right to keep and bear arms or Second Amendment Supporters, people_who_match:interests:, politics:US politics (conservative), and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:35:54-07:00  
3205 location_living_in:United States, excluded_connections:Exclude people who like Black4Black, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history or Black is beautiful, people_who_match:interests:, behaviors:Small business owners, and_must_also_match:interests:Black Economic Empowerment, interest_expansion:On 1088 71 https://www.facebook.com/Black4BlaCk-1268698556482143/ Supporting and developing bIk-owned Businesses is the key to raising our community! 12.9952 812.20 RUB 2016-12-05T06:16:27-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 1495.003ms · Data source: simonw/russian-ira-facebook-ads-datasette