home / russian-ads

display_ads (view)

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

2 rows where an ad_target was people_who_match:interests:Zakat

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1902 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Jesus in Islam, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Twelver, people_who_match:interests:Hasan ibn Ali, people_who_match:interests:Ali aI-Asghar ibn Husayn, people_who_match:interests:Umar, people_who_match:interests:Mecca, people_who_match:interests:Umrah, people_who_match:interests:Muhammad, people_who_match:interests:Muhammad aI-Baqir, people_who_match:interests:Ramadan, people_who_match:interests:Abu Bakr, people_who_match:interests:Muhammad aI-Mahdi, people_who_match:interests:Prophets and messengers in Islam, people_who_match:interests:Ya Hussain, people_who_match:interests:Names of God in Islam, people_who_match:interests:Ahl aI-Bayt, people_who_match:interests:"KARBALA IMAM HUSSEIN (A.S) SHRINE", people_who_match:interests:Fard, people_who_match:interests:Ulama, people_who_match:interests:Sunnah, people_who_match:interests:Ummah, people_who_match:interests:Caliphate, people_who_match:interests:Mufti, people_who_match:interests:Imam, people_who_match:interests:Kaaba, people_who_match:interests:Shia Islam, people_who_match:interests:Abu Talib ibn AbduI-Muttalib, people_who_match:interests:Islamism, people_who_match:interests:Glossary of Islam, people_who_match:interests:Hadith, people_who_match:interests:Hajj, people_who_match:interests:Zaynab bint Ali, people_who_match:interests:Fiqh, people_who_match:interests:Musa al- Kadhim, people_who_match:interests:Sharia, people_who_match:interests:Sukayna bint Husayn, people_who_match:interests:Mosque, people_who_match:interests:Imam Ali Mosque, people_who_match:interests:Takbir, people_who_match:interests:Hasan aI-Askari, people_who_match:interests:Zakat, people_who_match:interests:Shahada, people_who_match:interests:Basmala, people_who_match:interests:Allah, people_who_match:interests:Eid al-Adha, people_who_match:interests:Hijra (Islam), people_who_match:interests:Prophet, people_who_match:interests:Ali, people_who_match:interests:Fatimah, people_who_match:interests:Ja'far aI-Sadiq, people_who_match:interests:Husayn ibn Ali, people_who_match:interests:Abbas ibn Ali, people_who_match:interests:Medina, people_who_match:interests:Sheikh, people_who_match:interests:Sakinah (Fatima aI-Kubra) bint Husayn, people_who_match:interests:Ali ibn Husayn Zayn al- Abidin, people_who_match:interests:As-salamu alaykum, people_who_match:interests:Abraham in Islam, people_who_match:interests:Eid al-Fitr, people_who_match:interests:Mary in Islam or Ali aI-Ridha, people_who_match:interests:Employers: Allah 3476 0 https://www.facebook.com/MuslimInst-1681844195367390/ Just the response to those who think that if a woman wears the #hijab she is a threat. 27.72512 1732.82 RUB 2016-03-18T09:47:41-07:00 2016-03-20T20:40:00-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 1215.293ms · Data source: simonw/russian-ira-facebook-ads-datasette