home / russian-ads

display_ads (view)

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

199 rows where an ad_target was placements:Instagram Feed

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1 location_living_in:United States, interests:News broadcasting, interests:Political party, interests:Breaking news, interests:Politics and social issues, age:18 - 51, language:English (US), placements:Instagram Feed 358 6 https://instagram.Com/us_daily/ Instgogogo 2.5796799999999998 161.23 RUB 2015-10-25T06:28:33-07:00 2015-10-27T23:59:00-07:00
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  
6 location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 0 0 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 0.0 0.00 USD 2016-05-12T04:06:17-07:00  
7 no image location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 23408 54 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 45.89696 2868.56 RUB 2016-05-13T01:18:08-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  
15 location:United States, interests:Tax, interests:Republican Party (United States), age:20 - 65+, language:English (US), placements:Instagram Feed 1614 12 https://instagram.Com/gov_spending/ And what would you Choose if u were a president: to create 11200 military- related jobs or to create 26700 jobs in education? Join us! Learn more! The US Gov Spending Stats Instalol 9.54608 596.63 RUB 2015-11-17T07:07:36-08:00  
16 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support our troops, people_who_match:interests:Veterans, people_who_match:interests:AMVETS, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Chris Kyle, people_who_match:interests:Supporting Our Veterans, and_must_also_match:interests:Paralyzed Veterans of America, and_must_also_match:interests:Veterans Day, and_must_also_match:interests:Wounded Warrior Project, and_must_also_match:interests:Support our troops, and_must_also_match:interests:Veterans, and_must_also_match:interests:AMVETS, and_must_also_match:interests:United States Army Reserve, and_must_also_match:interests:Patriotism, and_must_also_match:interests:Disabled American Veterans, and_must_also_match:interests:The Veterans Site, and_must_also_match:interests:Chris Kyle, and_must_also_match:interests:Supporting Our Veterans 21093 53 https://www.instagram.Com/veterahs_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! The US Gov Spending Stats Instalol 34.10304 2131.44 RUB 2016-05-12T02:37:39-07: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  
20 location:United States, interests:Patriotism, behaviors:facebook_access_(mobile):all mobile devices, age:14 - 65+, language:English (US), placements:Instagram Feed 514 0 https://www.instagram.Com/veterahs_us/ Click Learn More if you really love your country! A small puppy wandered up to US. Marines from Alpha Company. After following the Marines numerous miles, a soft hearted Marine picked the puppy up and carried the puppy in his drop pouch. Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-12-16T04:26:55-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
28 location:United States, interests:Tax, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 15398 46 https://www.instagram.Com/gov_spending/ How to know the truth? Click learn more! Wouldn't it be better to solve the internal problems first? The US Gov Spending Stats Instalol 33.12672 2070.42 RUB 2015-12-16T06:45:58-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
31 location:United States, age:13 - 35, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Afro—American religion, people_who_match:interests:Malcolm X 23670 235 https://www.instagram.com/black_america_today/ Quiz from EBONY magazine April 1952. Which is Negro? Which is White? Passing for white is a direct consequence of how race works in America. Because of the One Drop Rule if you look at all part black African you are seen as “black” by “whites” and suffer all the racism that goes with that. Click "Learn More" Black America ( @black Blacklivessss 64.64272 4040.17 RUB 2016-03-11T04:54:05-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  
34 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservatism, people_who_match:interests:Veterans Day, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Veterans, people_who_match:interests:Republican Party (United States), people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterans_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol 0.0 0.00 USD 2016-05-12T02:31:30-07:00  
35 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 0 0 https://www.instagram.Com/veterahs_us/ There are some people who will always support you! And unfortunately, the VA is not on the list. There are numerous examples of disgusting treatment of our Veterans by the VA employees. And there is little Chance the situation will Change in the near future. The failure of the Defense Department and VA to create a joint electronic health record, despite spending $1 billion for development is just another example of it. Click Learn More! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2016-01-14T06:25:20-08:00  
36 location:United States, age:13 — 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 143644 496 https://www.instagram.com/veterans_usl He's lucky to return home to reunite with his family for the holidays. But he's just one of a few servicemen to do this. For many of our brave troops stationed abroad and far from their loved ones. Our brave servicemen and servicewomen will continue to make sacrifices for our great country while the VA employees will be having their dinner and laughing at the VA backlog. Click to Learn More! Veterans USA ( @veterans GovSpending 133.42592000000002 8339.12 RUB 2016-01-14T07:18:30-08:00  
37 location:United States, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 56837 216 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 64.49296 4030.81 RUB 2015-12-22T03:42:46-08:00  
38 location:United States, interests:HuffPost Black Voices, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 24866 95 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 28.743840000000002 1796.49 RUB 2016-01-06T01:45:12-08:00  
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  
40 location:United States, interests:Independence, interests:Patriotism, age:14 - 65+, language:English (US), placements:Instagram Feed 12476 25 https://www.instagram.com/veterans_us/ Let's make America great again for the future generations! Click Learn More! Veterans USA ( @veterans GovSpending 19.25616 1203.51 RUB 2016-01-06T03:11:48-08:00  
41 no image location_living_in:united_states:Maryland, age:18 - 40, placements:Instagram Feed, people_who_match:interests:Cop Block 7190 479 https://www.facebook.com/BIacklivessss-930158090385628/ gather recent videos about outrageous police misconduct, really valuable ones but underrepresented by mass media. 84.32000000000001 5270.00 RUB 2016-06-15T02:14:28-07: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
1250 location_living_in:United States, age:18 - 65+, placements:Instagram Feed 19765 21 https://www.instagram.com/instotus/ We are honored to be the main and the biggest American Instagram account! Follow @instotus for the best patriotic imagery and US. latest news exclusives. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! 7.65888 478.68 RUB 2015-10-08T00:39:23-07:00 2015-10-09T23:59:59-07:00
1251 location_living_in:united_states:Washington (+50 mi) District of Columbia, exclude_location:united_states:Washington, interests:Politics, interests:Politics and social issues, age:16 - 65+, placements:Instagram Feed 0 0 https://instagram.com/black_america_news Americalnstotus 0.0 0.00 USD 2015-10-09T05:50:41-07:00 2015-10-11T01:00:59-07:00
1252 location_living_in:united_states:Washington (+50 mi) District of Columbia, exclude_location:united_states:Washington, interests:Politics, interests:Politics and social issues, age:16 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.com/black_america_news Americalnstotus 0.0 0.00 USD 2015-10-09T08:04:33-07:00 2015-10-11T01:00:59-07:00
1267 location_living_in:United States, age:18 - 65+, placements:Instagram Feed 0 0 https://www.instagram.com/instotus/ We are honored to be the main and the biggest American Instagram accountlFollow @instotus for the best patriotic imagery and US. latest news exclusives. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! 0.0 0.00 USD 2015-10-07T01:15:58-07:00 2015-10-08T21:59:59-07:00
1608 location_living_in:United States, interests:Politics, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://www.instagram.com/instotus/ We are honored to be the main and the biggest American Instagram account! Follow @instotus for the best patriotic imagery and US. latest news exclusives. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! 0.0 0.00 USD 2015-10-06T02:08:02-07:00 2015-10-07T23:59:59-07:00
1682 location:United States, interests:Anti-racism, interests:Anti-discrimination, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://www.change.org/p/baraCk-obama-u-s-house-of-representatives-u-s- The KKK is an American terror group! Join the fight! Sign the petition to give that racist organization the REAL name! Sign the petition today! Click below to learn more Barack Obama, US. Hou... Blackusa 0.0 0.00 USD 2015-11-10T01:32:16-08:00  
1683 no image location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Police corruption, people_who_match:interests:Cop Block 27675 606 https://www.facebook.com/AmericanCops-1667165370195771/ Just don't mistake man's member for a deadly weapon and follow cop block us! 93.25919999999999 5828.70 RUB 2016-08-16T02:58:27-07:00  
1684 no image location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Black is beautiful, people_who_match:interests:Malcolm X, people_who_match:interests:Black Girls Rock! 11812 147 https://www.facebook.com/Blackluive-1725227467722991/ Our existence is being threatened by a race that sees itself 'masters over our melanin, but clear Strong Black Men, the system and racism got re—engaged so we have no Choice but to fight back, anyway, anyhow! Follow blackmattersus. 27.54112 1721.32 RUB 2016-08-18T05:05:43-07:00  
1686 location:United States, age:13 - 35, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:United States Holocaust Memorial Museum, people_who_match:interests:Fascism 9836 53 https://www.instagram.Com/Cop_block_us/ Back when I studied the #Holocaust in school, I remember thinking, "How did Hitler get over 6 million people to follow along blindly and not fight back?" Then I realised, I'm watching my fellow #Americans take the same path. Be among those who fight for their rights and freedom in this #policestate! Click to Learn More! Cop Block Us AmericanCops 68.0752 4254.70 RUB 2016-03-11T06:07:11-08:00  
1687 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Humour 113296 778 https://www.instagram.Com/Cop_block_us/ Fed up with police violence? Wanna stop police brutality? Join us! Cop Block Us ( @COp Block AmericanCops 112.29056 7018.16 RUB 2015-12-17T05:21:36-08: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  
1689 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:BuzzFeed, people_who_match:interests:Humour 119733 1256 https://www.instagram.Com/nuts.news/ 5-year-old David Southwick of Cortlandville had an argument with his wife in the parking lot and got into his car trying to run over the woman. He was so pissed off that he intentionally hit 14 vehicles and drove into the porch of a nearby house. Join us to read more funny news! Nuts News ( @nuts.news) Funnylnst 112.57600000000001 7036.00 RUB 2015-12-17T06:43:41-08:00  
1690 location:United States, age:15 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Justice (band) or Cop Block, people_who_match:interests:Behaviors: African American (US) 34117 226 https://www.instagram.Com/Cop_block_us/ Just smile and buy him a diet coke! Join us! Click Learn More! Cop Block Us ( @COp Block AmericanCops 35.8136 2238.35 RUB 2015-12-11T02:59:43-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 1318.987ms · Data source: simonw/russian-ira-facebook-ads-datasette