home / russian-ads

display_ads (view)

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

2,279 rows where an ad_target was age:18 - 65+

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
5 no image location_living_in:united_states:Georgia, age:18 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:American Black Film Festival, people_who_match:interests:Cop Block or HuffPost Black Voices, people_who_match:interests:, behaviors:African American (US), behaviors:Field of study: African-American history, behaviors:, politics:Likely to engage with political content (liberal) 29786 201 https://www.facebook.com/GovSpending-1651761351759857/ WHERE is your VOICE? 59.4264 3714.15 RUB 2016-06-15T03:39:52-07:00  
10 location:United States, interests:United States Senate, interests:Election, interests:Government, interests:Politics, age:18 - 65+, language:English (US), placements:Instagram Feed 1625 11 https://instagram.Com/gov_spending/ Unbelievable amount of the US government's waste. Join us to learn more about Goverment spending statistics! The US Gov Spending Stats Instalol 10.59824 662.39 RUB 2015-11-16T05:49:20-08:00  
12 no image location:United States, age:18 - 65+, language:English (US), 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 Arts Movement, people_who_match:interests:Fight the Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Afrocentrism, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Black is beautiful, people_who_match:interests:Malcolm X, people_who_match:interests:HuffPost Black Voices 44111 625 https://www.facebook.com/Bat-240131319678646/ It's time for us to understand that we do deserve all best. It's time for our people to stand up and use all the opportunities of this life. Follow black pride us, if you agree! 78.29952 4893.72 RUB 2016-08-17T04:17:52-07:00  
14 location:United States, interests:United Nations Assistance Mission in Afghanistan, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 1598 10 https://instagram.Com/veterans_us/ This military campaign is very ambiguous given that it has cost nearly 2,500 American lives and hundreds of billions of dollars. The goal was to "disrupt the use of Afghanistan as a terrorist base of operations." Well, the intervention deprived aI-Qaida of a sanctuary. But aI-Qaida — even after its leader Osama bin Laden was killed by US. commandos — has spawned cells elsewhere and inspired other extremists in Syria and Iraq. And now ISIS is rising as the most powerful terrorist organisation in the world. So, the question is whether it's worth to risk the lives of thousands of American soldiers for the mission that hardly can be called successful? It seems that Obama should review his military strategy without delay.Joih us! Veterans USA ( @veterans GovSpending 10.55264 659.54 RUB 2015-11-16T05:17:56-08:00  
17 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 1872 2 https://instagram.Com/veterans_us/ What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending 5.86256 366.41 RUB 2015-11-18T02:43:22-08:00 2015-11-21T10:28:00-08:00
18 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/veterans_us/ What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-11-19T05:18:16-08:00 2015-11-21T10:28:00-08:00
19 location:United States, interests:Homeless shelter, politics:US politics (liberal), politics:US politics (moderate), age:18 - 65+, language:English (US), placements:Instagram Feed 2115 8 https://instagram.Com/gov_spending/ Who will save the Children? Click Learn more! The US Gov Spending Stats Instalol 15.6504 978.15 RUB 2015-11-19T05:35:36-08:00  
21 location:United States, interests:Tea Party Patriots, age:18 - 65+, placements:Instagram Feed 8292 73 https://instagram.Com/veterans_us/ Throughout the history of our nation, there have been many wars. The soldiers have always carried the burden of death or injury while in battles. Politicians continually act as if the soldiers are their pawns, and their soldier pawns are expendable in war. Hence, we have the saddest statistics of military injuries. 1 out of 10 veterans is disabled, often by injuries sustained in combat. Join us! Learn more! Veterans USA ( @veterans GovSpending 47.176320000000004 2948.52 RUB 2015-11-13T06:27:35-08:00  
22 location:united_states:Chicago (+40 km) Illinois, behaviors:African American (US), age:18 - 65+, language:English (US), placements:Instagram Feed 9555 32 https://www.instagram.com/black_america_today/ Click learn more! See the latest breaking news photos and videos! Black America Blacklivessss 24.80656 1550.41 RUB 2015-12-01T07:37:28-08:00  
23 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 10785 6 https://www.facebook.com/GovSpending-1651761351759857/ TAG YOUR PHOTOS WITH #TXagainst Send us the reason why don't you want illegals in Texas. Comments, photos, and videos are welcomed! 12.897440000000001 806.09 RUB 2016-04-19T08:23:46-07:00  
24 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 77759 9 https://www.facebook.com/GovSpending-1651761351759857/ TAG YOUR PHOTOS WITH #TXagainst Send us the reason why don't you want illegals in Texas. Comments, photos, and videos are welcomed! 105.892 6618.25 RUB 2016-04-20T00:07:11-07:00  
25 location:United States, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 3970 35 https://instagram.Com/veterans_us/ Homeland of brave. Support our veterans! Join us! Veterans USA GovSpending 22.4288 1401.80 RUB 2015-11-09T05:01:08-08:00  
26 location:united_states:Latitude 38.89 Longitude -77.03 Washington (+16 km) District of Columbia, location:united_states:Gallup (+40 km) New Mexico, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 1721 6 https://www.instagram.Com/veterans_us/ Home of the Brave. Support our Veterans! Click Learn More! Veterans USA ( @veterans GovSpending 14.37376 898.36 RUB 2015-12-01T05:51:31-08:00  
27 location:United States, interests:Tea Party Patriots, interests:Justice, age:18 - 65+, language:English (US), placements:Instagram Feed 2616 6 https://instagram.Com/gov_spending/ Why our government wastes $11 MLN per day on |S|L Instead of saving more than 1300 lives of vets. Why do we engage in another conflict when we have so many unsolved problems in the US? It is a shame that our vets are treated so badly. They do not receive proper health care and unemployment benefits. They do not receive the respect they deserve. I do not want our government to create new veterans in such conditions. Join us for more statistics! Click learn more! The US Gov Spending Stats Instalol 7.473920000000001 467.12 RUB 2015-11-18T03:33:41-08:00 2015-11-19T08:26:00-08:00
29 location:United States, interests:Patient Protection and Affordable Care Act, interests:Supporting Our Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 3527 33 https://instagram.Com/veterans_us/ What do you know about PTSD? Do you know that US Military deaths since 1999 count 6,904, while veterans suicides since 1999 account for 128,480? We'are losing 18 times more warriors in Civilian life than on the battlefields! Learn more! Follow us! Veterans USA ( @veterans GovSpending 24.09936 1506.21 RUB 2015-11-12T04:38:35-08:00  
30 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/veterans_us/ Click learn more! People don't want to look at the homeless. But maybe they will look at, or think about, or support dealing with homelessness once they know that 12% of the homeless adult population are veterans. Join us! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-11-19T05:20:22-08:00 2015-11-21T10:28:00-08:00
32 location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Florida, location:united_states:Georgia, location:united_states:Louisiana, location:united_states:Mississippi, location:united_states:North Carolina, location:united_states:South Carolina, location:united_states:Tennessee, location:united_states:Texas, location:united_states:Virginia, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Confederate Flag, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:confederate states america, people_who_match:interests:United Daughters of the Confederacy, people_who_match:interests:Confederate States of America, people_who_match:interests:Sons of Confederate Veterans, people_who_match:interests:Confederate States Army, people_who_match:interests:Robert E. Lee, people_who_match:interests:Southern United States, people_who_match:interests:Redneck Social Club 12727 375 https://www.instagram.com/south_united/ Heritage not hate y'all! Our flag has nothing to do with racism! The Federal Government shouldn’t be able to dictate what we can and cannot do. Go follow Confederate page #1 on Instagram south united if you are proud of our southern heritage. God bless Dixie! Confederate page #1 on Instagram! No racism, no hate! The south will rise again! https://twitter.com/March_for_Trump South United GovSpehding 49.700480000000006 3106.28 RUB 2016-08-18T08:31:16-07:00  
33 location:united_states:Massachusetts, interests:Liberalism, age:18 - 65+, language:English (US), placements:Instagram Feed 2404 6 https://instagram.Com/gov_spending/ Unbelievable amount of the US government's waste. Click Learn More! The US Gov Spending Stats GovSpending 15.200000000000001 950.00 RUB 2015-12-01T05:57:42-08:00  
42 no image location_living_in:united_states:Ohio; Tennessee; Virginia, age:18 - 65+, placements:Instagram Feed, people_who_match:politics:US politics (conservative), people_who_match:politics:US politics (very conservative), people_who_match:politics:Likely to engage with political content (conservative) 22608 266 https://www.facebook.com/Bat-240131319678646/ If we ever forget that we are One Nation Under God, then we will be a nation gone under. Ronald Reagan 96.2536 6015.85 RUB 2016-06-15T04:02:09-07:00  
43 location_living_in:United States, interests:Cop Block, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/Cop_block_us Together we can stop them. Join the fight. Follow @COp_b|OCk_US Cop block is a grassroots organization working to make police accountable for their actions. Cop Block Us (@COp_b|OCk_US) - Instagram photos and videos 0.0 0.00 USD 2015-10-13T02:27:35-07:00 2015-10-15T23:59:59-07:00
44 location_living_in:united_states:Texas, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/south_lone_star You can go to hell or follow @south_lone_star instead! Texas is where you always want to be! We are Texans and we're not like the rest! Follow us! Lone Star State Rebels (@south_lone_star) - Instagram photos and videos 0.0 0.00 USD 2015-10-13T01:34:37-07:00 2015-10-15T23:59:59-07:00
45 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria Charity, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:African- American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Syria- News or Malcolm X, people_who_match:interests:Employers: Syria 0 0 https://www.facebook.com/Woke-B|acks-294234600956431/ We always condemn racism and terrorism because they only affect the poor and less privilege in society. So don't be fooled into making this mistake: The war in Syria is just another rich white man's way to profit at the cost of innocent lives... and yes, Flint is stillwithout Clean water. #wokeblacks #PanAfricanism #BlackNationalism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BlaCkAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BIackIsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnification #AfricanUnity #BlackLove #theblackmancan #brotherhood #kings 0.0 0.00 USD 2017-05-25T00:25:16-07:00 2017-05-26T00:25:16-07:00
46 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/shootusa Obey the law and everything will be ok, they say 0.0 0.00 USD 2015-07-27T00:42:42-07:00 2015-07-28T00:42:41-07:00
47 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/shootusa Obey the law and everything will be ok, they say 0.0 0.00 USD 2015-07-24T02:24:10-07:00 2015-07-25T02:24:09-07:00
48 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/pages/Proud-BIacks/1065511110127506   0.0 0.00 USD 2015-08-13T03:30:11-07:00 2015-08-14T03:30:11-07:00
49 no image custom_audience:tesy, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4405 716 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters 12.51552 782.22 RUB 2016-06-20T08:22:58-07:00  
50 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 92618 6555 https://blackmattersus.com/ Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 215.33584 13458.49 RUB 2016-06-21T07:09:02-07:00  
51 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 12653 393 https://b|ackmattersus.com/?utm_source=facebook&utm_medium=Cpc&utm Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 18.69296 1168.31 RUB 2016-07-06T07:18:32-07:00  
52 no image custom_audience:tesy, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4544 724 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters 13.555040000000002 847.19 RUB 2016-06-20T08:03:12-07:00  
53 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:13:40-07:00  
54 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:Ferguson (+20 km), St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 201428 12127 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 854.7991999999999 53424.95 RUB 2015-07-13T07:20:58-07:00  
55 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 812 73 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 3.4312 214.45 RUB 2015-10-06T08:22:34-07:00  
58 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 16322 2446 https://www.facebook.com/blackmattersus/ Black Matters. Black community. 76.76944 4798.09 RUB 2015-10-06T08:25:00-07:00  
60 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 967 113 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 5.08096 317.56 RUB 2015-10-06T08:22:34-07:00  
62 location:united_states:Charleston (+70 km) South Carolina, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 42890 2182 https://www.facebook.com/events/257074994652475/ One year ago nine people were killed by a gunman, including the senior pastor, state senat Remember Victims of Charleston Shooting 230.37904 14398.69 RUB 2016-06-01T06:03:23-07:00 2016-06-19T06:03:19-07:00
63 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://b|ackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 0.0 0.00 USD 2016-06-21T07:08:44-07:00  
64 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 500 25 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us. Because we care 5.44544 340.34 RUB 2015-07-10T01:03:31-07:00  
65 location:united_states:Los Angeles (+40 km) California, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 41395 1734 https://www.facebook.com/events/1702267153358101/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford And Donnell Thompson 238.108 14881.75 RUB 2016-08-04T07:25:31-07:00 2016-08-20T07:25:28-07:00
79 location:United States, excluded_connections:Exclude people who like L for life, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 31 0 https://www.facebook.com/pages/L-for-Iife/994910227187446   0.53744 33.59 RUB 2015-06-09T03:50:21-07:00 2015-06-11T03:48:00-07:00
80 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 10825 1393 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 53.83344 3364.59 RUB 2015-10-06T08:22:32-07:00  
82 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 191 6 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 4.116 257.25 RUB 2015-07-10T01:02:58-07:00  
83 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 613 30 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us. Because we care 7.488 468.00 RUB 2015-07-10T01:03:32-07:00  
84 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 14050 1838 https://www.facebook.com/blackmattersus/ Black Matters. Black community. 60.166720000000005 3760.42 RUB 2015-10-06T08:24:58-07:00  
86 location_living_in:united_states:Los Angeles (+50 mi) California, interests:Martin Luther, interests:Black Panther Party, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2920 75 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford and Donnell Thompson 56.468160000000005 3529.26 RUB 2016-08-22T07:04:52-07:00 2016-09-03T07:04:49-07:00
87 location_living_in:united_states:Los Angeles (+50 mi) California, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Malcolm X 6368 180 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford and Donnell Thompson 113.76176 7110.11 RUB 2016-08-23T04:11:38-07:00 2016-09-03T07:04:49-07:00
88 custom_audience:Lookalike (US, 10%) - tesy, location_living_in:united_states:Los Angeles (+50 mi) California, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Malcolm X 5289 236 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford and Donnell Thompson 96.05632000000001 6003.52 RUB 2016-08-26T04:19:56-07:00 2016-09-03T07:04:49-07:00
89 custom_audience:Lookalike (US, 10%) - tesy, location_living_in:united_states:Los Angeles (+50 mi) California, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Latin, people_who_match:interests:Malcolm X 172 9 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford, Jesse Romero and Donnell Thompson 2.35568 147.23 RUB 2016-08-29T00:27:53-07:00 2016-09-03T07:04:49-07:00
90 location_living_in:united_states:Los Angeles (+50 mi) California, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Latin, people_who_match:interests:Malcolm X 3477 103 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford, Jesse Romero and Donnell Thompson 61.588 3849.25 RUB 2016-08-29T05:11:27-07:00 2016-09-03T07:04:49-07:00
92 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 608 27 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 7.1248000000000005 445.30 RUB 2015-07-10T01:03:03-07:00  
93 location:united_states:Cleveland (+50 km) Ohio, behaviors:African American (US), age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 17231 922 https://www.facebook.com/events/1486230091674577/ A Year Without Justice for Tamir Rice. Join the meeting! A Year Without Justice for Tamir Rice 63.81888 3988.68 RUB 2015-11-19T23:59:53-08:00  

Next page

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 1025.661ms · Data source: simonw/russian-ira-facebook-ads-datasette