home / russian-ads

display_ads (view)

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

335 rows where an ad_target was placements:Right column on desktop computers

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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
314 location:united_states:Cleveland (+50 km) Ohio, behaviors:multicultural_affinity:African American (US), 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 0 0 https://www.facebook.com/events/1486230091674577/ A Year Without Justice for Tamir Rice. Join the meeting! A Year Without Justice for Tamir Rice 0.0 0.00 USD 2015-11-19T23:27:57-08:00  
468 location:united_states:Pennsylvania, 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, people_who_match:interests:Donald Trump for President, people_who_match:interests:Job title: Coal Miner 0 0 https://www.facebook.com/events/312522819127036/ America has always been hinged on hard-working people. If you remove jobs, you’ll remove our country from the world map. The state of Pennsylvania rose owing to multiple enterprises mining coal, producing steel, and creating the need for otherjobs, groceries, doctors, dentists, insurance, gas, vehicles, mechanics and the list goes on. As far as Mr. Trump pursues the goal of creating more jobs and supports the working Class. He said he would put miners back to work. We could help Mr. Trump win Pennsylvania which is a battleground state. We’d like to organize a rally “Miners for Trump” in Pennsylvania. Have something against coal industries? Please note then that burning coal is not more harmful than lumber. Alternative energy is only possible when subsidized by government for it is not lucrative. You cannot leave tens of thousands of people without a job just because of lobbyists’ interests. The current list of locations is being elaborated. Suggested Cities are Erie, Pittsburg, Scranton, Harrisburg, Allentown, and Philly. Confirmed locations: Marconi Plaza, Philadelphia. Miners for Trump: Unity clay in Pennsylvania 0.0 0.00 USD 2016-09-22T05:09:05-07:00 2016-10-01T13:00:00-07:00
469 location:united_states:Allentown, Erie, Harrisburg, Philadelphia, Pittsburgh, Scranton Pennsylvania, 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, people_who_match:interests:Donald Trump for President, people_who_match:interests:Job title: Coal Miner 1225 77 https://www.facebook.com/events/312522819127036/ America has always been hinged on hard-working people. If you remove jobs, you’ll remove our country from the world map. The state of Pennsylvania rose owing to multiple enterprises mining coal, producing steel, and creating the need for otherjobs, groceries, doctors, dentists, insurance, gas, vehicles, mechanics and the list goes on. As far as Mr. Trump pursues the goal of creating more jobs and supports the working Class. He said he would put miners back to work. We could help Mr. Trump win Pennsylvania which is a battleground state. We’d like to organize a rally “Miners for Trump” in Pennsylvania. Have something against coal industries? Please note then that burning coal is not more harmful than lumber. Alternative energy is only possible when subsidized by government for it is not lucrative. You cannot leave tens of thousands of people without a job just because of lobbyists’ interests. The current list of locations is being elaborated. Suggested Cities are Erie, Pittsburg, Scranton, Harrisburg, Allentown, and Philly. Confirmed locations: Marconi Plaza, Philadelphia. Miners for Trump: Unity clay in Pennsylvania 14.023040000000002 876.44 RUB 2016-09-22T05:13:54-07:00 2016-10-01T13:00:00-07:00
470 location:united_states:Philadelphia, Pittsburgh Pennsylvania, age:16 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump, people_who_match:interests:Manufacturing, people_who_match:interests:Donald Trump for President or conservative daily, people_who_match:interests:Job title: Coal Miner 7282 457 https://www.facebook.com/events/312522819127036/ America has always been hinged on hard-working people. If you remove jobs, you’ll remove our country from the world map. The state of Pennsylvania rose owing to multiple enterprises mining coal, producing steel, and creating the need for otherjobs, groceries, doctors, dentists, insurance, gas, vehicles, mechanics and the list goes on. As far as Mr. Trump pursues the goal of creating more jobs and supports the working Class. He said he would put miners back to work. We could help Mr. Trump win Pennsylvania which is a battleground state. We’d like to organize a rally “Miners for Trump” in Pennsylvania. Have something against coal industries? Please note then that burning coal is not more harmful than lumber. Alternative energy is only possible when subsidized by government for it is not lucrative. You cannot leave tens of thousands of people without a job just because of lobbyists’ interests. The current list of locations is being elaborated. Suggested Cities are Erie, Pittsburg, Scranton, Harrisburg, Allentown, and Philly. Confirmed locations: Marconi Plaza, Philadelphia. Miners for Trump: Unity clay in Pennsylvania 113.92960000000001 7120.60 RUB 2016-09-23T02:42:16-07:00 2016-10-01T13:00:00-07:00
475 location_living_in:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Young Republicans, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America or Donald Trump for President, people_who_match:interests:Employers: NYPD, people_who_match:interests:US., army_reserve_industry:Military (Global) or Veterans (US), army_reserve_industry:Politics: US politics (conservative), army_reserve_industry:US politics (very conservative) 4171 551 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 31.9904 1999.40 RUB 2016-11-10T05:00:07-08:00 2016-11-11T21:00:00-08:00
725 location_living_in:united_states:Abilene (+30 mi), location_living_in:united_states:Amarillo (+30 mi), location_living_in:united_states:Austin (+35 mi), location_living_in:united_states:Beaumont (+31 mi), location_living_in:united_states:Brownwood (+32 mi), location_living_in:united_states:Bryan (+33 mi), location_living_in:united_states:Conroe (+31 mi), location_living_in:united_states:Corpus Christi (+31 mi), location_living_in:united_states:Dallas (+33 mi), location_living_in:united_states:Fort Worth (+33 mi), location_living_in:united_states:Houston (+34 mi), location_living_in:united_states:Lubbock (+32 mi), location_living_in:united_states:Odessa (+33 mi), location_living_in:united_states:San Angelo (+39 mi), location_living_in:united_states:San Antonio (+28 mi), location_living_in:united_states:South Plains (+36 mi), location_living_in:united_states:Temple (+35 mi), location_living_in:united_states:Texas City (+35 mi), location_living_in:united_states:Tyler (+35 mi), location_living_in:united_states:Waco (+39 mi) Texas, connections:People who like Heart of Texas, excluded_connections:Exclude people who are going to Get Ready to Secedel, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 17334 1807 https://www.facebook.com/evehts/1828560880690663/ Fellow Texans! It's time to say a strong NO to the establishment robbers. It is unacceptable for us to see them ruin all we've been building for decades. For centuries. The establishment thinks they can treat us like stupid sheep but they are wrong. We won’t put up with this anymore. The corrupt media does not talk about the crimes committed by Killary Rotten Clinton, neither does it mention the leaked emails but it would rather keep on kicking around some outdated tapes featuring Trump. Even Republicans are now offering her a victory by renouncing their nominee. What is this if not treason? No, no, no. We are free Citizens of Texas and we’ve had enough of this Cheap show on the screen. We're ready to prove our commitment to liberty, low taxes and gun rights. If Trump wins, there will be a possibility to secede peacefully but not without tension. What will happen if Hitlery becomes President? Higher taxes to feed undocumented aliens. More refugees, mosques, and terrorist attacks. Banned guns. Continuing economic depression. Let’s remind them what Texas is made of and show that we’re ready to SECEDE! Use our page to team up with other locals. Invite your friends and family, spread the word and let's make this effort together! Get Ready to Secedel 70.18111999999999 4386.32 RUB 2016-11-02T05:16:25-07:00 2016-11-03T11:07:27-07:00
726 location_living_in:united_states:Abilene (+30 mi), location_living_in:united_states:Amarillo (+30 mi), location_living_in:united_states:Austin (+35 mi), location_living_in:united_states:Beaumont (+31 mi), location_living_in:united_states:Brownwood (+32 mi), location_living_in:united_states:Bryan (+33 mi), location_living_in:united_states:Conroe (+31 mi), location_living_in:united_states:Corpus Christi (+31 mi), location_living_in:united_states:Dallas (+33 mi), location_living_in:united_states:Fort Worth (+33 mi), location_living_in:united_states:Houston (+34 mi), location_living_in:united_states:Lubbock (+32 mi), location_living_in:united_states:Odessa (+33 mi), location_living_in:united_states:San Angelo (+39 mi), location_living_in:united_states:San Antonio (+28 mi), location_living_in:united_states:South Plains (+36 mi), location_living_in:united_states:Temple (+35 mi), location_living_in:united_states:Texas City (+35 mi), location_living_in:united_states:Tyler (+35 mi), location_living_in:united_states:Waco (+39 mi) Texas, connections:People who like Heart of Texas, excluded_connections:Exclude people who are going to Get Ready to Secedel, age:18 — 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 2897 225 https://www.facebook.com/evehts/1828560880690663/ Fellow Texans! It's time to say a strong NO to the establishment robbers. It is unacceptable for us to see them ruin all we've been building for decades. For centuries. The establishment thinks they can treat us like stupid sheep but they are wrong. We won’t put up with this anymore. The corrupt media does not talk about the crimes committed by Killary Rotten Clinton, neither does it mention the leaked emails but it would rather keep on kicking around some outdated tapes featuring Trump. Even Republicans are now offering her a victory by renouncing their nominee. What is this if not treason? No, no, no. We are free Citizens of Texas and we’ve had enough of this Cheap show on the screen. We're ready to prove our commitment to liberty, low taxes and gun rights. If Trump wins, there will be a possibility to secede peacefully but not without tension. What will happen if Hitlery becomes President? Higher taxes to feed undocumented aliens. More refugees, mosques, and terrorist attacks. Banned guns. Continuing economic depression. Let’s remind them what Texas is made of and show that we’re ready to SECEDE! Use our page to team up with other locals. Invite your friends and family, spread the word and let's make this effort together! Get Ready to Secedel 10.04288 627.68 RUB 2016-11-03T07:56:02-07:00 2016-11-03T11:07:27-07:00
762 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 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, people_who_match:interests:Fly the American Flag, people_who_match:interests:America the Beautiful, people_who_match:interests:American Patriots, people_who_match:interests:| Love the USA, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:Flag of the United States, people_who_match:interests:American Patriot or American patriotism, people_who_match:interests:, employers:Proud to be an American, and_must_also_match:politics:Likely to engage with political content (conservative) 1828 141 https://www.facebook.com/patriototus/ "Patriotism is looking out for yourself by looking out for your country" - Calvin Coolidge. Being Patriotic 16.09856 1006.16 RUB 2017-05-16T01:35:01-07:00  
763 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 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, people_who_match:interests:Right-wing politics, and_must_also_match:interests:Fly the American Flag, and_must_also_match:interests:America the Beautiful, and_must_also_match:interests:American Patriots, and_must_also_match:interests:| Love the USA, and_must_also_match:interests:Proud to be an American, and_must_also_match:interests:Patriot Nation, and_must_also_match:interests:American Patriot, and_must_also_match:interests:American patriotism 0 0 https://www.facebook.com/patriototus/ "Patriotism is looking out for yourself by looking out for your country" - Calvin Coolidge. Being Patriotic 0.0 0.00 USD 2017-05-18T02:33:00-07:00  
764 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 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, people_who_match:interests:Right-wing politics, and_must_also_match:interests:Fly the American Flag, and_must_also_match:interests:America the Beautiful, and_must_also_match:interests:American Patriots, and_must_also_match:interests:| Love the USA, and_must_also_match:interests:Proud to be an American, and_must_also_match:interests:Patriot Nation, and_must_also_match:interests:American Patriot, and_must_also_match:interests:American patriotism 11717 1452 https://www.facebook.com/patriototus/ Supporting the Old Glory, the Constitution and traditional values. God bless America! Being Patriotic 110.94144 6933.84 RUB 2017-05-18T02:36:10-07:00  
1128 location:united_states:Houston (+50 mi) Texas, age:16 - 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, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 9693 878 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 14.61824 913.64 RUB 2016-10-06T01:03:54-07:00 2016-10-14T16:00:00-07:00
1253 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:Laura Ingraham, people_who_match:interests:Fox News Channel, people_who_match:interests:Ron Paul, people_who_match:interests:Tucker Carlson, people_who_match:interests:Rand Paul, people_who_match:interests:Christianity, people_who_match:interests:Bill O'Reilly (political commentator), people_who_match:interests:Rush Limbaugh, people_who_match:interests:Andrew Breitbart, people_who_match:interests:breitbart, people_who_match:interests:Bible, people_who_match:interests:Conservatism in the United States, people_who_match:interests:Sean Hannity, people_who_match:interests:Michael Savage, people_who_match:interests:Mike Pence, people_who_match:interests:Michelle Malkin, people_who_match:interests:Mike Huckabee, people_who_match:interests:Jesus, people_who_match:interests:TheBIaze, people_who_match:interests:Donald, trump_jr_politics:US politics (very conservative) 2781 282 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. America is at risk now more than even 33.51584 2094.74 RUB 2017-08-13T22:47:48-07:00 2017-08-15T22:47:53-07:00
1254 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 184 16 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. America is at risk and we need to protect our... 3.26704 204.19 RUB 2017-07-16T15:51:18-07:00 2017-07-19T15:51:23-07:00
1255 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. We need to protect America now more than ever. 0.0 0.00 USD 2017-07-16T23:37:07-07:00 2017-07-19T15:51:23-07:00
1256 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 1706 194 https://www.facebook.com/Secured.Borders/ Secured borders should be a top priority. We need to protect America now more than ever. 26.01264 1625.79 RUB 2017-07-16T23:38:24-07:00 2017-07-19T15:51:23-07:00
1259 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:Laura Ingraham, people_who_match:interests:Fox News Channel, people_who_match:interests:Ron Paul, people_who_match:interests:Tucker Carlson, people_who_match:interests:Rand Paul, people_who_match:interests:Christianity, people_who_match:interests:Bill O'Reilly (political commentator), people_who_match:interests:Rush Limbaugh, people_who_match:interests:Andrew Breitbart, people_who_match:interests:breitbart, people_who_match:interests:Bible, people_who_match:interests:Conservatism in the United States, people_who_match:interests:Sean Hannity, people_who_match:interests:Michael Savage, people_who_match:interests:Mike Pence, people_who_match:interests:Michelle Malkin, people_who_match:interests:Mike Huckabee, people_who_match:interests:Jesus, people_who_match:interests:TheBIaze, people_who_match:interests:Donald, trump_jr_politics:US politics (very conservative) 3069 291 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. America is at risk now more than even 33.535360000000004 2095.96 RUB 2017-07-27T11:11:10-07:00 2017-07-29T11:11:15-07:00
1260 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 1072 90 https://www.facebook.com/Secured.Borders/ Secured borders should be a top priority. We need to protect America now more than ever. 14.381440000000001 898.84 RUB 2017-05-28T23:26:02-07:00 2017-05-31T23:26:07-07:00
1261 location_living_in:united_states:New York, excluded_connections:Exclude people who like United Muslims of America, age:16 - 60, 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:Civil and political rights, people_who_match:interests:Human rights, people_who_match:interests:Anarchism, people_who_match:interests:Nonviolence, people_who_match:interests:Stop the War Coalition, people_who_match:interests:Anti-fascism, people_who_match:interests:Pacifism, people_who_match:interests:Peace movement, people_who_match:interests:The Anarchy, people_who_match:interests:World peace, people_who_match:interests:Anti-war movement, people_who_match:interests:Feminism, people_who_match:interests:PeaonnEarth, people_who_match:interests:Be a Peacekeeper - The World Peacekeepers Movement, and_must_also_match:politics:Likely to engage with political content (liberal) 5456 256 https://www.facebook.com/events/239129926564203/ If you don't want refugees, stop creating them! Hands off Syria! Please, come out to support us on June 3rd in front of Trump Tower in New York. We must stop this madness! Some believed Trump would withdraw the US. from useless and bloody military campaigns. But what we see is only the enhancement of hostility. We don't need wars no more! We want peace! It's time for politicians to take care of the US. residents instead of fating them, as well as other nationals, to death. We're organizing a peaceful gathering to draw public attention to the above- mentioned terrible problem. Our President and Congress must listen to those who granted them power - us, the people. If you also think that there should only be peace, come with us and let's make it happen. Stop war! Stop killing the innocent! Make peace, not war! Make peace, not war! 33.68304 2105.19 RUB 2017-05-26T02:05:30-07:00  
1270 location:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who are going to American Flag March in Memory of 9/11, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump 0 0     0.0 0.00 USD 2016-08-30T02:32:29-07:00  
1611 custom_audience:Lookalike (US, 1%) - People who like United Muslims of America, location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Muslim Brotherhood 9300 467 https://www.facebook.com/MuslimAmerica/ Proud to be a Muslim 77') 777') 7777')? 54.77536 3423.46 RUB 2016-10-18T02:27:41-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  
1620 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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 15292 514 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 63.27968 3954.98 RUB 2016-10-03T12:09:31-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  
1635 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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 14341 502 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 52.27792 3267.37 RUB 2016-10-03T12:09:31-07:00  
1654 custom_audience:Lookalike (US, 1%) - People who like United Muslims of America, location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Muslims Are Not Terrorists, people_who_match:interests:Muslim Brotherhood 0 0 https://www.facebook.com/MuslimAmerica/ Proud to be a Muslim 77') 777') 7777')? 0.0 0.00 USD 2016-10-18T02:27:41-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  
1665 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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-03T12:09:31-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  
1672 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:16 - 55, 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-03T12:09:31-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
1780 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 4O, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Entertainment, people_who_match:interests:Humour 0 0 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 0.0 0.00 USD 2016-04-12T00:21:47-07:00 2016-04-19T07:58:26-07:00
1815 location:United States, interests:Entertainment, interests:BuzzFeed, interests:9GAG, interests:Hobbies and activities, excluded_connections:Exclude people who like Memopolis, age:13 - 45, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 28226 1135 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 68.52047999999999 4282.53 RUB 2016-06-17T06:31:04-07:00 2016-07-24T06:31:04-07:00
1816 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 45, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Imgur, people_who_match:interests:BuzzFeed, people_who_match:interests:9GAG 19164 1042 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 92.17664 5761.04 RUB 2016-06-23T07:05:10-07:00 2016-07-24T06:31:04-07:00
1817 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 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:Imgur, people_who_match:interests:BuzzFeed, people_who_match:interests:9GAG 7857 420 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 35.2 2200.00 RUB 2016-07-20T07:09:26-07:00 2016-07-24T06:31:04-07:00
1849 location:United States, interests:Entertainment, interests:BuzzFeed, interests:Hobbies and activities, excluded_connections:Exclude people who like Memopolis, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 0.0 0.00 USD 2016-04-09T07:56:50-07:00  
1850 location:United States, interests:Entertainment, interests:BuzzFeed, interests:Hobbies and activities, excluded_connections:Exclude people who like Memopolis, age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 808 32 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 5.2664 329.15 RUB 2016-04-09T07:57:42-07:00  
1851 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 4O, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Entertainment, people_who_match:interests:BuzzFeed, people_who_match:interests:Hobbies and activities 1245 34 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 6.9928 437.05 RUB 2016-04-11T00:50:25-07:00  
1852 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 4O, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Entertainment, people_who_match:interests:Humour 97300 2778 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 212.61616 13288.51 RUB 2016-04-11T23:58:16-07:00  
1865 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 4O, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Entertainment, people_who_match:interests:Humour 0 0 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 0.0 0.00 USD 2016-04-12T00:19:43-07:00  
1923 location_living_in:United States, interests:Facebook, interests:community, interests:Fitness and wellness, interests:Family, interests:Photography, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 http://www.a|jazeera.com/ News, analysis from the Middle East & worldwide, multimedia & interactives, opinions Al Jazeera English - Live Muslimlnst 0.0 0.00 USD 2015-11-23T23:20:26-08:00 2015-12-03T23:20:29-08:00
1955 location_living_in:United States, interests:Conservatism, interests:Confederate States of America, interests:Donald Trump, interests:Republican Party (United States), interests:Dixie, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 15370 2158 https://www.facebook.com/Secured-Borders-757183957716200/ We should not only strengthen our geographical boundaries but also our cultural. Like us! 163.036 10189.75 RUB 2016-06-07T00:14:39-07:00  
1963 location:United States, age:15 - 26, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Internet meme, people_who_match:interests:Humour 213 4 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 0.9112 56.95 RUB 2016-10-11T06:08:02-07:00 2016-11-10T07:30:26-08:00
1964 location:United States, excluded_connections:Exclude people who like Memopolis, age:15 - 25, gender:Male, 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:Internet meme, people_who_match:interests:BuzzFeed, people_who_match:interests:Meme, people_who_match:interests:Humour, people_who_match:interests:Funny Pics, people_who_match:interests:9GAG, and_must_also_match:interests:Imgur, and_must_also_match:interests:Cracked.com, and_must_also_match:interests:iFunny 72197 3116 https://www.facebook.com/Memopolis-450474615151098/ Hot Chicks. Dank memes. Dope stuff. 171.15664 10697.29 RUB 2016-10-14T05:09:53-07:00  
1965 location:United States, age:15 - 26, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Internet meme, people_who_match:interests:Humour 204 4 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 0.59616 37.26 RUB 2016-10-11T23:54:57-07:00 2016-11-11T00:23:21-08:00
1998 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, excluded_connections:Exclude people who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 80206 6125 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism. Join us! Black Lives Matter! 264.172 16510.75 RUB 2016-08-30T01:04:29-07:00  
1999 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, excluded_connections:Exclude people who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 5249 130 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism, inequality and injustice. Join us! 5.685600000000001 355.35 RUB 2016-12-01T05:49:13-08:00  
2000 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, excluded_connections:Exclude people who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 107295 4669 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about inequality and injustice. Join us! BM 247.65152 15478.22 RUB 2016-12-08T06:34:13-08:00  
2196 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, excluded_connections:Exclude people who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 223343 18796 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism. Join us! Black Lives Matter! 636.39648 39774.78 RUB 2016-08-30T01:04:27-07:00  
2197 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, excluded_connections:Exclude people who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 601 6 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism, inequality and injustice. Join us! 0.43568 27.23 RUB 2016-12-01T05:49:13-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 1786.795ms · Data source: simonw/russian-ira-facebook-ads-datasette