home / russian-ads

display_ads (view)

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

37 rows where an ad_target was language:Arabic

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1612 location:united_states:Houston (+50 mi) Texas, interests:Islamism, interests:Glossary of Islam, interests:Sharia, interests:Hijra (Islam), age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 7 1 https://www.facebook.com/events/571644626347616/ It’s been only a month since Library of Islamic Knowledge at the center in Houston is open SAVE ISLAMIC KNOWLEDGE 0.164 10.25 RUB 2016-05-11T07:01:48-07:00 2016-05-18T07:01:46-07:00
1613 location:united_states:Houston (+50 mi) Texas, interests:Islamism, interests:Glossary of Islam, interests:Sharia, interests:Hijra (Islam), age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 2726 176 https://www.facebook.com/events/571644626347616/ It’s been only a month since Library of Islamic Knowledge at the center in Houston is open SAVE ISLAMIC KNOWLEDGE 44.11696 2757.31 RUB 2016-05-12T01:34:21-07:00 2016-05-18T07:01:46-07:00
1614 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 59, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 7217 361 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 78.57024000000001 4910.64 RUB 2015-12-18T03:59:48-08:00  
1615 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 48, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 213 3 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 2.11696 132.31 RUB 2016-02-12T01:19:12-08:00  
1616 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 0 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-03-10T05:35:24-08:00  
1617 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 5646 162 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 27.4976 1718.60 RUB 2016-03-10T05:36:14-08:00  
1622 location:United States, interests:Muslims Are Not Terrorists, interests:Islamism, interests:Muslim Brotherhood, connections:People who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 3337 540 https://www.facebook.com/United-Muslims-of—America-1479936895656747/ R.|.P Dr Ahmed Zewail. Share and be the media... 8.0 500.00 RUB 2016-08-04T05:51:52-07:00 2016-08-05T05:51:50-07:00
1623 location:united_states:Washington (+50 mi) District of Columbia, interests:Hillary Clinton, interests:Muslim Brotherhood, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1849 94 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! 63.697120000000005 3981.07 RUB 2016-06-24T03:28:02-07:00 2016-07-06T03:27:59-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
1625 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 3828 163 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! 74.40224 4650.14 RUB 2016-06-30T07:43:12-07:00 2016-07-06T03:27:59-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
1629 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 59, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 7755 244 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 90.7264 5670.40 RUB 2015-12-18T04:00:20-08:00  
1630 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 48, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 33027 819 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 322.90688 20181.68 RUB 2016-02-12T01:19:12-08:00  
1631 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 0 0 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 0.0 0.00 USD 2016-03-10T05:35:24-08:00  
1632 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 28841 942 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 174.74512 10921.57 RUB 2016-03-10T05:36:14-08:00  
1636 location:United States, interests:Muslims Are Not Terrorists, interests:Islamism, interests:Muslim Brotherhood, connections:People who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 3578 551 https://www.facebook.com/United-Muslims-of—America-1479936895656747/ We can end Islamophobia only by educating people that we are against terrorism too! let them know real Islam and Muslims and peaceful we are... 13.627360000000001 851.71 RUB 2016-07-21T05:21:41-07:00 2016-07-22T05:21:40-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
1638 location:united_states:Washington (+50 mi) District of Columbia, excluded_connections:Exclude 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:Islamism, people_who_match:interests:Proud to be A Muslim, people_who_match:interests:Muslim Brotherhood 7267 427 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 206.69488 12918.43 RUB 2016-08-15T07:24:16-07:00 2016-09-03T03:06:35-07:00
1639 location:united_states:Washington (+50 mi) District of Columbia, 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:Islam, people_who_match:interests:Islamism, people_who_match:interests:Proud to be A Muslim, people_who_match:interests:Muslim Brotherhood 23858 865 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 273.2968 17081.05 RUB 2016-08-23T04:43:48-07:00 2016-09-03T03:06:35-07:00
1644 location:united_states:Washington (+50 mi) District of Columbia, interests:Muslims Are Not Terrorists, interests:Muslim world, interests:Arab world, interests:Muslim Brotherhood, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 7838 443 https://www.facebook.com/events/1723204977963012/ We Muslims of the United States are subject to Islamophobia from the media where regularly STOP SCAPEGOATING MUSLIMS! 127.77664 7986.04 RUB 2016-05-24T06:45:13-07:00 2016-05-27T06:45:10-07:00
1645 location:united_states:Washington (+50 mi) District of Columbia, interests:Hillary Clinton, interests:Muslim Brotherhood, age:16 - 53, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 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-24T03:27:48-07:00 2016-05-27T06:45:10-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
1647 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 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-30T07:43:19-07:00 2016-05-27T06:45:10-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
1653 location:United States, interests:Muslim Brotherhood, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4596 589 https://www.facebook.com/United-Muslims-of—America-1479936895656747/ Attacker calls woman 'Muslim piece of trash' before pouring liquid on her in 8.0 500.00 RUB 2016-05-06T03:45:59-07:00 2016-05-07T03:45:58-07:00
1659 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 59, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 360 19 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 9.20416 575.26 RUB 2015-12-18T04:00:41-08:00  
1660 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 48, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 1411 41 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 15.1464 946.65 RUB 2016-02-12T01:19:12-08:00  
1661 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 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-03-10T05:35:24-08:00  
1662 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 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-03-10T05:36:14-08:00  
1666 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 59, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 73077 3063 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 819.0888000000001 51193.05 RUB 2015-12-18T03:55:37-08:00  
1667 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 48, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 2819 57 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 26.97424 1685.89 RUB 2016-02-12T01:19:12-08:00  
1668 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-03-10T05:35:24-08:00  
1669 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-03-10T05:36:14-08:00  
1678 no image location:united_states:New York, interests:Islamism, interests:Glossary of Islam, interests:Sharia, interests:Hijra (Islam), age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4869 330 https://www.facebook.com/MuslimAmerica/   40.0 2500.00 RUB 2016-03-11T07:26:06-08:00 2016-03-13T11:26:00-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 4593.517ms · Data source: simonw/russian-ira-facebook-ads-datasette