home / russian-ads

display_ads (view)

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

9 rows where an ad_target was people_who_match:interests:Muslims Are Not Terrorists

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1611 custom_audience:Lookalike (US, 1%) - People who like United Muslims of America, location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Muslim Brotherhood 9300 467 https://www.facebook.com/MuslimAmerica/ Proud to be a Muslim 77') 777') 7777')? 54.77536 3423.46 RUB 2016-10-18T02:27:41-07:00  
1626 location:united_states:Washington (+50 mi) District of Columbia, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood 1469 112 https://www.facebook.com/events/1170988439609888/ The time has come to understand one simple thing: we the American muslims are as American Support Hillary. Save American Muslims! 26.29408 1643.38 RUB 2016-07-04T01:30:07-07:00 2016-07-06T03:27:59-07:00
1627 location:united_states:Washington (+50 mi) District of Columbia, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood, people_who_match:interests:ProductiveMuslim 0 0 https://www.facebook.com/events/1170988439609888/ The time has come to understand one simple thing: we the American muslims are as American Support Hillary. Save American Muslims! 0.0 0.00 USD 2016-07-05T03:49:11-07:00 2016-07-06T03:27:59-07:00
1628 location:united_states:Washington (+50 mi) District of Columbia, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood, people_who_match:interests:ProductiveMuslim 3655 144 https://www.facebook.com/events/1170988439609888/ The time has come to understand one simple thing: we the American muslims are as American Support Hillary. Save American Muslims! 33.527519999999996 2095.47 RUB 2016-07-05T03:49:19-07:00 2016-07-06T03:27:59-07:00
1637 location:united_states:Washington (+50 mi) District of Columbia, connections:People who like United Muslims of America, age:18 - 61, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood 3072 107 https://www.facebook.com/events/1092180614203742/ The safety, freedom, and dignity of all people must be safeguarded. Terrorism and anti-Mus Safe Space for Muslim Neighborhood 80.06880000000001 5004.30 RUB 2016-08-10T03:06:37-07:00 2016-09-03T03:06:35-07:00
1648 location:united_states:Washington (+50 mi) District of Columbia, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood 0 0 https://www.facebook.com/events/1723204977963012/ We Muslims of the United States are subject to Islamophobia from the media where regularly STOP SCAPEGOATING MUSLIMS! 0.0 0.00 USD 2016-07-04T01:30:00-07:00 2016-05-27T06:45:10-07:00
1649 location:united_states:Washington (+50 mi) District of Columbia, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood, people_who_match:interests:ProductiveMuslim 0 0 https://www.facebook.com/events/1723204977963012/ We Muslims of the United States are subject to Islamophobia from the media where regularly STOP SCAPEGOATING MUSLIMS! 0.0 0.00 USD 2016-07-05T03:49:03-07:00 2016-05-27T06:45:10-07:00
1654 custom_audience:Lookalike (US, 1%) - People who like United Muslims of America, location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Muslim Brotherhood 0 0 https://www.facebook.com/MuslimAmerica/ Proud to be a Muslim 77') 777') 7777')? 0.0 0.00 USD 2016-10-18T02:27:41-07:00  
1655 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Zaid Shakir, people_who_match:interests:ProductiveMuslim, people_who_match:interests:Abu Eesa Niamatullah 103079 4491 https://www.facebook.com/MuslimAmerica/ A page to unit all Muslim people living in the USA! 951.26016 59453.76 RUB 2015-12-18T03:52:42-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 1322.316ms · Data source: simonw/russian-ira-facebook-ads-datasette