home / russian-ads

display_ads (view)

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

15 rows where an ad_target was people_who_match:interests:Muslim world

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1618 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1619 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 11 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-10-03T06:40:06-07:00  
1620 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 15292 514 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 63.27968 3954.98 RUB 2016-10-03T12:09:31-07:00  
1624 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:Muslim world, people_who_match:interests:Islamism, people_who_match:interests:Muslim Brotherhood 1293 76 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! 19.197599999999998 1199.85 RUB 2016-06-29T02:00:21-07:00 2016-07-06T03:27:59-07:00
1633 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1634 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 532 19 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 2.26608 141.63 RUB 2016-10-03T06:40:06-07:00  
1635 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 14341 502 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 52.27792 3267.37 RUB 2016-10-03T12:09:31-07:00  
1646 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:Muslim world, 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-06-29T02:00:28-07:00 2016-05-27T06:45:10-07:00
1663 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1664 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 0.0 0.00 USD 2016-10-03T06:40:06-07:00  
1665 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 0.0 0.00 USD 2016-10-03T12:09:31-07:00  
1670 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1671 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-10-03T06:40:06-07:00  
1672 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-10-03T12:09:31-07:00  
1903 location_living_in:united_states:Washington (+40 km) District of Columbia, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Mecca, people_who_match:interests:Muhammad, people_who_match:interests:Muhammad aI-Baqir, people_who_match:interests:Prophets and messengers in Islam, people_who_match:interests:Muslim world, people_who_match:interests:Muslim Youth, connections:People who like United Muslims of America, people_who_match:interests:Fiqh, people_who_match:interests:Ana muslim, people_who_match:interests:Sharia, people_who_match:interests:Muslim League (Pakistan), people_who_match:interests:Imam Ali Mosque, people_who_match:interests:Zakat, people_who_match:interests:Muslim Brotherhood, people_who_match:interests:Ja'far aI-Sadiq, people_who_match:interests:History of Islam, people_who_match:interests:Medina, people_who_match:interests:As—salamu alaykum or Islam Book, people_who_match:interests:School: Islam, people_who_match:interests:Jesus Christ, people_who_match:interests:Saudi Arabia or Quran, people_who_match:interests:Field of study: Arabic, people_who_match:interests:Islamic studies, people_who_match:interests:Sharia, people_who_match:interests:Islamic philosophy or Quran, people_who_match:interests:Employers: Saudi Aramco, people_who_match:interests:Mosque, people_who_match:interests:Muslim, people_who_match:interests:Islam, people_who_match:interests:Saudi Arabia, people_who_match:interests:Quran or Saba University, people_who_match:interests:Job title: Muslim, people_who_match:interests:Islam, people_who_match:interests:Ulama, people_who_match:interests:Saudi Arabia 15690 429 https://www.instagram.com/muslim_voice/ Remember, islamophobia is a help to the world terrorism! This is the community which unites all the muslims who live in the US. We all are Children of the Middle East. It's time to unite! @muslim Voice - Muslimlnst 53.82544 3364.09 RUB 2016-07-15T03:36:32-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 1256.868ms · Data source: simonw/russian-ira-facebook-ads-datasette