home / russian-ads

display_ads (view)

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

34 rows where an ad_target was age:13 - 65+

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
39 location:United States, age:13 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 95140 300 https://www.instagram.com/black_america_today/ Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss 146.57407999999998 9160.88 RUB 2016-01-14T06:07:11-08:00  
629 location:United States, age:13 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT history, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:LGBT social movements 870 64 https://www.facebook.com/LGBT—United—839497472793277/ HUMAN RIGHTS PHOTO CHALLENGE Despite our race, religion, gender, age, education, sexual orientation and beliefs, we are all HUMANS. In the midst of the presidential race, all what politicians dream about is money. They keep giving empty promises in order to win votes. And this is our friendly reminder for the candidates: we are the ones who elect them. We don’t deserve having problems with employment, marriage, Child birth etc... We all deserve the right to be accepted. Go for it! Clicking the “like” button is not enough. If you want to attract the candidates' attention to the fight for human rights, do the following: 1) Take a picture with Campaign (HUMAN RIGHTS) logo (state required) 2) Post it in comments within a week 3) Share with your friends For the first place $50; second place $30; third place $20 2.7054400000000003 169.09 RUB 2016-03-22T07:17:38-07:00  
1691 location:United States, age:13 - 65+, language:English (US), placements:Instagram Feed 37539 19 https://www.facebook.com/Blackluive-1725227467722991/ BlackMatters is a nonprofit news outlet that delivers raw and original information on the most urgent issues important to the African-American community in America. Join us! 48.74192 3046.37 RUB 2016-04-06T06:34:47-07:00  
1693 location:united_states:Michigan, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Police brutality in the United States or Stop Police Brutality, people_who_match:interests:Multicultural Affinity: African American (US) 33183 1 https://www.facebook.com/BIackluive-1725227467722991/ We are looking for brave people who are ready to help our movement, who are creative and active, if you are one of such people, just let us know! Comment below or DM! 88.08352000000001 5505.22 RUB 2016-05-05T08:21:51-07:00  
1696 location:United States, age:13 - 65+, placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Understanding racial segregation in the united states 421 2 https://www.facebook.com/Blackluive-1725227467722991/ Racism is not “Heritage and Honor”.lt’s time to stand up for what’s right. 1.2815999999999999 80.10 RUB 2016-03-17T09:07:59-07:00 2016-03-26T16:39:00-07:00
1697 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states 12518 0 https://www.facebook.com/Blackluive-1725227467722991/ Racism is not “Heritage and Honor”.lt’s time to stand up for what’s right. 49.55536 3097.21 RUB 2016-03-23T07:43:04-07:00 2016-03-26T16:39:00-07:00
1701 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Police Brutality is a Crime, people_who_match:interests:Media bias, people_who_match:interests:National Resistance Movement, people_who_match:interests:Police misconduct, people_who_match:interests:Anonymous (group), people_who_match:interests:Police brutality in the United States, people_who_match:interests:Stop Police Brutality 8446 0 https://www.facebook.com/AmericanCops-1667165370195771/ Know your rights! 1. Record the interaction. 2. FOLLOW @cop_block_us 11.991200000000001 749.45 RUB 2016-03-16T08:01:13-07:00 2016-03-21T07:51:00-07:00
1709 location:united_states:Illinois, location:united_states:Virginia, location:united_states:West Virginia, age:13 - 65+, placements:Instagram Feed 37354 12 https://www.facebook.com/AmericanCops-1667165370195771/ Police are beyond out of control, help us make this viral! Follow our account in order to spread the truth! 103.9752 6498.45 RUB 2016-05-06T02:45:26-07:00  
1781 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 65+, placements:News Feed on mobile devices 51 2 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 1.10368 68.98 RUB 2016-04-12T00:23:03-07:00 2016-04-19T07:58:26-07:00
1868 location:United States, age:13 - 65+, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Donald Trump, people_who_match:interests:Multicultural Affinity: African American (US) 21555 67 https://www.instagram.com/blackmattersus/ Hey, everyonel’? You know, a great number of black people support us saying that #HillaryClintonlsNotMyPresident! So this time we would like to make a #flashmob against #HillaryClinton because she is the real enemy of black community and our followers prove it showing their disgrace to her personality and policy. That's why we ask you to do the same and send your photos to us. Why? Because we want to live in a better future and Hillary is not the person who will help us in getting justice and peace by all means! Dear followers, if you agree, just don't be ignorant to your future in America, join our flashmob and take a photo with #HillaryClintonForPrison2016 or #nohillary2016 and tag @blackmattersusl? Looking forward to your photos?? BlackMattersUS AmericanCops 31.258080000000003 1953.63 RUB 2016-04-06T04:26:42-07:00  
1895 location:united_states:New Orleans (+40 km) Louisiana, age:13 - 65+, language:English (US), placements:Instagram Feed 12983 103 https://www.instagram.com/p/BAw7thMbc4/ We won't tolerate removing general Robert E.Lee from Lee Circle! On this Saturday, Jan 23, at 3:00 pm at Lee Circle, New Orleans, Louisiana. Come and defend him! Like he defend the south! Click Learn More! South United On Yoyoyoyoyo 80.0 5000.00 RUB 2016-01-21T06:17:07-08:00  
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  
1906 location:united_states:Texas, behaviors:facebook_access_(mobile):all mobile devices, generation:Millennials, politics:US politics (conservative), politics:US politics (very conservative), politics:Likely to engage with political content (conservative), age:13 - 65+, language:English (US), placements:Instagram Feed 0 0 https://www.instagram.Com/tea_party_news/ Christmas is coming !We're sure that you won't be able to find a better present than a gun! Don't believe us? Just try once and you'll understand what we're talking about! Gun power, self-confidence, freedom! Tea Party News ( @tea Teapartypat 0.0 0.00 USD 2015-12-18T03:25:39-08:00  
1907 location:united_states:Texas, behaviors:facebook_access_(mobile):all mobile devices, generation:Millennials, politics:US politics (conservative), politics:US politics (very conservative), politics:Likely to engage with political content (conservative), age:13 - 65+, language:English (US), placements:Instagram Feed 23781 78 https://www.instagram.Com/tea_party_news/ Christmas is coming !We're sure that you won't be able to find a better present than a gun! Don't believe us?Just try once and you'll understand what we're talking about! Gun power, self—confidence, freedom! Tea Party News ( @tea Teapartypat 51.92656 3245.41 RUB 2015-12-18T03:27:24-08:00  
1908 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 279 1 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Elections2016. Let's have some fun! Don't stay aside! Tea Party News ( @tea Teapartypat 0.02112 1.32 RUB 2016-04-19T08:12:20-07:00  
1909 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 165121 78 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News ( @tea Teapartypat 159.52928 9970.58 RUB 2016-04-21T00:28:18-07:00  
1912 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Donald Trump for President 0 0 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News Teapartypat 0.0 0.00 USD 2016-04-19T08:08:19-07:00  
1913 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Tea Party movement, people_who_match:interests:The Tea Party, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Americans for Prosperity, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Donald Trump Jr. 0 0 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News Teapartypat 0.0 0.00 USD 2016-04-19T08:05:39-07:00  
1914 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Donald Trump for President 0 0 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News Teapartypat 0.0 0.00 USD 2016-04-19T08:07:22-07:00  
1917 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Conservative Republicans of Texas, people_who_match:interests:Donald Trump for President 108433 857 https://www.facebook.com/Teapartypat—1649468318669272/ This is the way our Children have to be raised. It's not the promotion of violence. It's the promotion of confidence and the ability to defend yourself. Follow us if this video makes you proud! 276.9112 17306.95 RUB 2016-04-22T10:43:02-07:00  
1924 location:United States, age:13 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:The Tea Party 0 0 https://www.instagram.Com/tea_party_news/ Are you sick and tired of people saying "ready for Hillary"? Because they piss me off every day. And I really feel hopeless trying to explain to them she's not a good Choice. Unless you want to see America in flames. Click to Learn More! Tea Party News ( @tea Teapartypat 0.0 0.00 USD 2016-01-15T02:09:19-08:00  
1927 location_living_in:united_states:Baltimore (+17 km) Maryland, behaviors:New smartphone and tablet users, behaviors:Multicultural Affinity: Hispanic (US - All), behaviors:Multicultural Affinity: African American (US), age:13 - 65+, placements:Instagram Feed 1073 1 https://www.instagram.com/baltimore.blackvoice/ Stand with #BIackLivesMatter movement. All recent news the media will never show! (@baltimoreBlackvoice) Baltimore News 0.47056000000000003 29.41 RUB 2015-12-31T01:02:36-08:00  
1936 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:ForAmerica, people_who_match:interests:Patriotism 22567 92 https://www.instagram.oom/instotus/ We are Patriots. We fight for the traditions, for the National Symbols and for the Future. If you don't like the liberal ideas and you are not the one who supports gun control, gay marriage and black lives matter activists. If America is more than just a country for you, we want you to join us! This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! Instagram Of The United Instotus 58.899680000000004 3681.23 RUB 2016-05-06T07:29:40-07:00  
1937 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Support our troops, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Proud to be an American, people_who_match:interests:ForAmerica, people_who_match:interests:United States Armed Forces, people_who_match:interests:Veterans, people_who_match:interests:Patriotism, people_who_match:interests:The Veterans Site 22635 41 https://www.instagram.com/instotus/ This is a community for everyone whose heart is with America. Don't be a stranger - Follow @instotus Instagram Of The United Instotus 46.559839999999994 2909.99 RUB 2016-02-25T01:06:31-08:00 2016-03-24T05:00:00-07:00
1939 location:United States, interests:Fitness and wellness, interests:Sports and outdoors, interests:Family and relationships, behaviors:facebook_access_(mobile):smartphones and tablets, generation:Millennials, age:13 - 65+, language:English (UK), language:English (US), placements:Instagram Feed 57750 210 https://www.instagram.Com/stay4police/ Support those who protect you. Pro—police. Anti-criminal. Stop the war on our policePress 'Iearn more' to step behind this thin blue line! Support The Police Libelibe 72.95776 4559.86 RUB 2015-12-16T01:58:29-08:00  
1941 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Police, people_who_match:interests:Police officer, people_who_match:interests:Safety 418904 9211 https://www.facebook.com/Libelibe—1484239251885741/ Join Us! Support The Police! 425.57584 26598.49 RUB 2016-04-13T09:15:28-07:00  
1942 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:field_of_study:Police officer, people_who_match:field_of_study:Employers: Seaman, people_who_match:field_of_study:Job title: Polisi militer, people_who_match:field_of_study:Soldado, people_who_match:field_of_study:Retired Police Officer, people_who_match:field_of_study:Officer, people_who_match:field_of_study:Colonel, people_who_match:field_of_study:Major general (United States), people_who_match:field_of_study:Master sergeant, people_who_match:field_of_study:Chief of police, people_who_match:field_of_study:Commander (United States), people_who_match:field_of_study:Sergeant, people_who_match:field_of_study:Police commissioner, people_who_match:field_of_study:Brigadier general, people_who_match:field_of_study:Petty officer, people_who_match:field_of_study:Officer cadet, people_who_match:field_of_study:Sergeant Major of the Army, people_who_match:field_of_study:Lieutenant colonel (United States), people_who_match:field_of_study:Chief petty officer, people_who_match:field_of_study:Lieutenant commander, people_who_match:field_of_study:Squadron leader, people_who_match:field_of_study:911 Dispatcher, people_who_match:field_of_study:Rear Admiral 8 0 https://www.facebook.com/Instotus-1751255138430954/ NO MORE CHAOS! Instagram Of The US stands against racism! God Bless America! 0.02416 1.51 RUB 2016-02-12T09:15:21-08:00 2016-02-16T09:05:00-08:00
1943 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:field_of_study:Police officer, people_who_match:field_of_study:Employers: Seaman, people_who_match:field_of_study:Job title: Polisi militer, people_who_match:field_of_study:Soldado, people_who_match:field_of_study:Retired Police Officer, people_who_match:field_of_study:Officer, people_who_match:field_of_study:Colonel, people_who_match:field_of_study:Major general (United States), people_who_match:field_of_study:Master sergeant, people_who_match:field_of_study:Chief of police, people_who_match:field_of_study:Commander (United States), people_who_match:field_of_study:Sergeant, people_who_match:field_of_study:Police commissioner, people_who_match:field_of_study:Brigadier general, people_who_match:field_of_study:Petty officer, people_who_match:field_of_study:Officer cadet, people_who_match:field_of_study:Sergeant Major of the Army, people_who_match:field_of_study:Lieutenant colonel (United States), people_who_match:field_of_study:Chief petty officer, people_who_match:field_of_study:Lieutenant commander, people_who_match:field_of_study:Squadron leader, people_who_match:field_of_study:911 Dispatcher, people_who_match:field_of_study:Rear Admiral 7588 0 https://www.facebook.com/Instotus-1751255138430954/ NO MORE CHAOS! Instagram Of The US stands against racism! God Bless America! 23.97584 1498.49 RUB 2016-02-14T23:13:46-08:00 2016-02-16T09:05:00-08:00
1947 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Patriot (American Revolution), people_who_match:interests:Tea Party Patriots 21912 86 https://www.instagram.com/instotus/ Instagram Of The United StatesDon't be a stranger, be a patriot! Follow us! instotus Instagram Of The United Instotus 94.94976 5934.36 RUB 2016-03-16T07:43:24-07:00  
1951 location:united_states:Connecticut, location:united_states:Delaware, location:united_states:Maine, location:united_states:Maryland, location:united_states:Massachusetts, location:united_states:Ferguson (+40 km) Missouri, location:united_states:Virginia City (+40 km) Nevada, location:united_states:New Hampshire, location:united_states:New Jersey, location:united_states:New York (+40 km) New York, location:united_states:Ohio, location:united_states:Pennsylvania, location:united_states:Rhode Island, location:united_states:Vermont, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:HispanicTV, people_who_match:interests:Behaviors: African American (US) 26514 0 https://www.facebook.com/Proudblacks-954167134618867/ New York. 18-19 Feb. 11:00. Meet at Dag Hammarskjold Plaza on 47 street. 40.0 2500.00 RUB 2016-02-18T05:03:07-08:00 2016-02-19T11:26:00-08:00
1952 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:behaviors:African American (US) 1499 0 https://www.facebook.com/Proudblacks-954167134618867/ Stop the white privilege by participating in a PRO-Beyonce Rally! Support Queen B! 0.52176 32.61 RUB 2016-02-12T09:05:44-08:00 2016-02-16T03:53:00-08:00
1953 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:behaviors:African American (US) 38437 0 https://www.facebook.com/Proudblacks-954167134618867/ Stop the white privilege by participating in a PRO-Beyonce Rally! Support Queen B! 23.478240000000003 1467.39 RUB 2016-02-14T23:12:52-08:00 2016-02-16T03:53:00-08:00
1954 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:behaviors:African American (US) 0 0 https://www.facebook.com/Proudblacks-954167134618867/ NEW YORK! 18, 19 Feb! Protest with us at the UN! Charge America with genocide & human rights violations! 0.0 0.00 USD 2016-02-18T04:36:08-08:00 2016-02-16T03:53:00-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 1289.917ms · Data source: simonw/russian-ira-facebook-ads-datasette