home / russian-ads

display_ads (view)

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

22 rows where an ad_target was location:united_states:New York

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1238 no image location:united_states:New York, interests:Black Tea Patriots, interests:Black Knowledge, interests:BlaCkNews.com, interests:BEING BLACK!!!, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blacktivists/ BE A BLACKTIVIST —JOIN THE We all know that black communities and Natives have always been plagued by an array of issues that we have to deal on a daily basis. Watching America’s reaction to racism is very telling. Last year, police brutality and racism have made it t the forefront. Hundreds of unarmed black men and women died at the hands of police officers. We are tired to feel neglected and ignored. We all have had enough. And now we need to come together, be honest and get the government‘s attention. You are all invited to em We do not expect you to solve generations of inequality and oppression overnight. We do, however, expect you to come and to address the issues and put forward a plan to make change. —#StopNativeGenocide #BIaokLivesMatter 0.0 0.00 USD 2016-02-18T05:30:07-08:00 2016-02-19T05:30:06-08:00
1239 no image location:united_states:New York, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:BlackNews.com, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 9778 1179 https://www.facebook.com/blacktivists/   80.0 5000.00 RUB 2016-02-18T05:33:23-08:00 2016-02-19T05:30:06-08:00
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  
1621 location:united_states:New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like United Muslims of America, people_who_match:Friends of connections: Friends of people who are connected to United Muslims of America 1640 213 https://www.facebook.com/MuslimAmerica/ Who is ready to do the same in any public place during the weekends ?? We really need to stop Islamophobia and the fear of Muslims, and Change that false image about us, it's everybody's duty... 8.0 500.00 RUB 2016-03-17T04:22:59-07:00 2016-03-19T04:22: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  
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  
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  
1675 location:united_states:New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like United Muslims of America, people_who_match:Friends of connections: Friends of people who are connected to United Muslims of America 450 52 https://www.facebook.com/MuslimAmerica/ We are all immigrants and refugees if it's not you then it's your father or grandfather we all came on the same boat !! #refugeesWelcome #SyrianRefugees 3.2 200.00 RUB 2016-03-17T04:20:25-07:00 2016-03-18T04:20:25-07: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
1688 location:united_states:New York, age:18 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:Leadership development, people_who_match:interests:California African American Museum, people_who_match:interests:The African History Network, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Rosa Parks, people_who_match:interests:Sister 2 Sister magazine, people_who_match:interests:The Autobiography of Malcolm X, people_who_match:interests:World Day of Social Justice, people_who_match:interests:Leadership, people_who_match:interests:Black Arts Movement, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:Jesse Jackson, people_who_match:interests:BlackNews.com, people_who_match:interests:Racial equality, people_who_match:interests:African-American literature, people_who_match:interests:Afrocentrism, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Racial integration, people_who_match:interests:Phaedra Parks, people_who_match:interests:Black History Month, people_who_match:interests:Sister 2 Sister, people_who_match:interests:African-American history, people_who_match:interests:Black is beautiful, people_who_match:interests:The Honorable Minister Louis Farrakhan, people_who_match:interests:madeas family reunion, people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz), people_who_match:interests:Slavery by Another Name, people_who_match:interests:African American Museum in Philadelphia, people_who_match:interests:Afrocentric education, people_who_match:interests:Bias, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, people_who_match:interests:Social Justice Solutions 26919 646 https://b|ackmattersus.com/10683-hever-forget-never- Yesterday and the day before yesterday and many days before that, we had to witness horrible crimes committed by the police against Black men. The killing of AI Never Forget Never July 16th, 1 pm. Washington Square Park, NYC Blackluive 41.80944 2613.09 RUB 2016-07-14T06:01:49-07:00  
1877 no image location:united_states:New York, age:14 - 65+, placements:Instagram Feed, people_who_match:interests:Malcolm X, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Church, people_who_match:interests:Louis Farrakhan, people_who_match:interests:Black Panther Party, people_who_match:interests:The Honorable Minister Louis Farrakhan or National Black Police Association (United Kingdom), people_who_match:interests:Field of study: African-American history 10114 9 https://www.facebook.com/Yoyoyoyoyoy-1729293847304592/ Black lives do matter! We want justice or else! Follow us to know the truth! Go to our website to stay abreast of the latest black news in America. ( link in the bio) 35.55936 2222.46 RUB 2016-05-20T04:41:47-07:00  
1945 no image location:united_states:Florida, location:united_states:Georgia, location:united_states:New York, age:16 - 60, placements:Instagram Feed, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Malcolm, x_field_of_study:African-American history 5609 2 https://www.facebook.com/Proudblacks-954167134618867/ Follow BlackAmericaToday! Stay woke! 10.145280000000001 634.08 RUB 2016-05-17T04:18:29-07:00  
2439 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2395 269 https://www.faoebook.com/BIack-Edification-1772583676310336/ So let's do this. Since no one knew what he looked like and the bible forbade idolatry how about we all stop trying to draw Jesus! 4.84752 302.97 RUB 2016-06-28T11:05:51-07:00 2016-06-29T11:05:50-07:00
2440 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African—American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2318 146 https://www.facebook.com/BIack-Edification-1772583676310336/ Many of us are poor and struggling due to systemic racisml! 80 fight for something! IT IS OUR DUTY!! WE HAVE NOTHING TO LOSE BUT OUR CHAINS! 1.18 73.75 RUB 2016-07-19T14:16:10-07:00 2016-07-26T14:16:09-07:00
2441 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 658 145 https://www.facebook.com/BIack-Edification-1772583676310336/ The Original Statue of Liberty presented to the US. was a Statue of a..."BIack Woman". - Urban Intellectuals 2.21056 138.16 RUB 2016-06-28T11:59:55-07:00 2016-07-05T11:59:54-07:00
2442 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African-American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4717 470 https://www.facebook.com/Black-Edification-1772583676310336/ Melanin is gold. It's a gift of God. We have to appreciate this in all shades. The black girls with freckles are also beautiful. 8.0 500.00 RUB 2016-06-25T13:08:42-07:00 2016-06-27T13:08:40-07:00
2443 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African-American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Black-Edification-1772583676310336/ Melanin is gold. It's a gift of God. We have to appreciate this in all shades. The black girls with freckles are also beautiful. 0.0 0.00 USD 2016-07-17T00:37:25-07:00 2016-06-27T13:08:40-07:00
2444 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 15771 4020 https://www.faoebook.com/BIack-Edification-1772583676310336/ Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that. Martin Luther King, Jr. 8.0 500.00 RUB 2016-07-17T00:48:23-07:00 2016-07-24T00:48:22-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 1446.623ms · Data source: simonw/russian-ira-facebook-ads-datasette