home / russian-ads

display_ads (view)

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

29 rows where an ad_target was age:18 - 50

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
96 location:united_states:Atlanta (+20 km) Georgia, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 54463 2813 https://www.facebook.com/events/1579032272388106/ Counter-protest against 'White Power' Confederate rally at Stone Mountain Not My Heritage 238.60496 14912.81 RUB 2016-04-06T08:41:45-07:00 2016-04-24T22:41:00-07:00
108 location:united_states:Jackson (+20 km) Mississippi, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9306 261 https://www.facebook.com/events/227388350945080/ We don’t want to honor racism, slavery and hatred. Sand ur ground -join the rally! Not My Heritage Rally 45.4432 2840.20 RUB 2016-03-18T07:55:46-07:00 2016-03-25T07:55:00-07:00
208 no image location:united_states:Jackson (+20 km) Mississippi, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 21 0 https://www.facebook.com/blackmattersus/ Governor of the State of Mississippi has proclaimed the month of April 2016 as Confederate Heritage Month. We don’t want to honor racism, slavery and hatred. Yet this is what Confederate Heritage is. The Confederate flag is America’s most potent symbol of white supremacy. Symbols of hate have no place in our government. Join our "Not My Heritage" Rally at 2 pm on March 26th, 398 Mississipi st, Jackson, Mississipi. More info: https://www.facebook.com/events/227388350945080/ 0.03536 2.21 RUB 2016-03-18T07:54:09-07:00 2016-03-21T07:54:08-07:00
771 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 11442 1288 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Knowledge will free you! Buy here: https://represent.com/straight-outta-2018?store=blaCk-matters-us 6.4 400.00 RUB 2016-11-18T08:13:20-08:00 2016-11-19T08:13:20-08:00
772 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 6060 268 https://www.facebook.com/WilliamsKalvin-788980617892144/ Therer are two kinds of kids in American schools. One kind of kids have a lot of opportunities to learn and to develop all their skills and they are white. Another kind of kids is black and the only thing they learn at school is to obey the police. Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 12.66192 791.37 RUB 2016-11-01T06:05:37-07:00  
774 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 24584 3288 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Know your rights and stay woke. Just like #Kaepernick! 8.08608 505.38 RUB 2016-11-01T06:07:11-07:00  
775 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African—American Civil Rights Movement (1954—68), interests:African—American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12624 2096 https://www.facebook.com/WiIliamsKalvin-788980617892144/ Have you ever noticed that?! 4.770560000000001 298.16 RUB 2016-11-01T06:07:42-07:00  
787 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 2776 197 https://www.facebook.com/WilIiamsKalvin-788980617892144/ If you didn't vote for Trump, buy this awesome t-shirt and support the struggle! httpszllrepresent.com/store/notmypresident 6.4 400.00 RUB 2016-11-18T08:15:55-08:00 2016-11-19T08:15:55-08:00
798 location:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 7721 335 https://www.facebook.com/WilIiamsKalvin-788980617892144/ There's no reason to fight the whole government if you are alone. You will die but you can never win. You need people who can stand with you for what you all think is right. Still , can we do this? Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: httpszllwww.instagram.Com/williams.and.kalvin 12.762080000000001 797.63 RUB 2016-11-01T06:04:00-07:00  
801 location:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ I pity anyone who has to deal with neighbors in an apartment building. Especially when you have to deal with the complaining and passive- aggressive types. Oh, and let’s not forget gentrifiers. Or, as I like to call them, “white migrators.” Apparently, instead of knocking on a neighbor’s door, people take the easy and passive-aggressive way out and just leave notes instead. But one man wasn’t having it. Link: https://scontent-arn2-1 .xx.fbcdn.net/v/t1 .0-9/14572967_1772905896322 988_913778538274424647_n.jpg?oh=984945f2582b54297fe1f8f786f297be& oe=5862D508 Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 0.0 0.00 USD 2016-10-20T08:03:20-07:00 2016-10-15T02:45:48-07:00
803 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12654 693 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Ice-Cream is something more than just a food you love. When a business expresses its views, cops are attacking, because they know no other way to act! Ben & Jerry’s ice-cream is boycotted by the police officers just because of the opinion of the business owners. So, let’s stand against the political repressions! Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.oom/Williams8kalvih 12.7992 799.95 RUB 2016-10-21T07:46:31-07:00 2016-10-24T07:46:28-07:00
822 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9015 443 https://www.facebook.com/WilIiamsKalvin-788980617892144/ The police are killing black people without a reason and no one can even indict them even if their guilt is evident. And how can we judge a killer cop if he uses a drone? Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: httpszllwww.instagram.Com/williams.and.kalvin Follow me on Twitter: httpszlltwitter.com/Williams8kalvih 12.77632 798.52 RUB 2016-11-01T06:04:39-07:00  
823 location:United States, interests:HuffPost Black Voices, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Hypocrisy of our society has gone way too far... Celebrating human rights day, when black society is being oppressed by authorities and racist radicals every day is a spit in our faces! Why do black people are always guilty in everything in this country? Aren‘t african americans humans? 80... this day creates more questions than give answers... Thanks everybody for watching! 0.0 0.00 USD 2015-12-18T03:20:05-08:00 2015-12-21T03:20:04-08:00
824 location:United States, age:18 - 50, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:HuffPost Black Voices 686 20 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Hypocrisy of our society has gone way too far... Celebrating human rights day, when black society is being oppressed by authorities and racist radicals every day is a spit in our faces! Why do black people are always guilty in everything in this country? Aren‘t african americans humans? 80... this day creates more questions than give answers... Thanks everybody for watching! 3.2 200.00 RUB 2015-12-18T03:21:54-08:00 2015-12-21T03:20:04-08:00
833 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 22088 4372 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Black girl magic! 8.11344 507.09 RUB 2016-11-01T06:08:08-07:00  
835 location:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Black guys are smart and no one can deny this. White cops are one of the hardest of the problems we face every day, still, we found the way how to deal with this bastards. So we developed the app that can collect and organize the information about cos’ misconduct. Use it and you will help the entire black community. Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williamsand.kalvin Follow me on Twitter: https://twitter.oom/Williams8kalvin 0.0 0.00 USD 2016-10-20T08:03:34-07:00 2016-10-21T08:03:32-07:00
844 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:on pages: News Feed on desktop computers, placements:News Feed on mobile devices, placements:Instream Video on mobile devices, placements:Instream Video on desktop computers 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Danney Williams, 30, has been trying since at least 1999 to be acknowledged as the out-of-wedlock son of former President Bill Clinton and a black prostitute in Little Rock, Arkansas. Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvin 0.0 0.00 USD 2016-10-20T08:03:20-07:00 2016-10-19T02:55:24-07:00
845 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Danney Williams, 30, has been trying since at least 1999 to be acknowledged as the out-of-wedlock son of former President Bill Clinton and a black prostitute in Little Rock, Arkansas. Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: httpszllwww.instagram.Com/williams.and.kalvin Follow me on Twitter: httpszlltwitter.com/Williams8kalvin 0.0 0.00 USD 2016-12-01T03:23:56-08:00 2016-10-19T02:55:24-07:00
846 location:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4657 897 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Tell me once again that there is no such thing as white privilege. 3.9728000000000003 248.30 RUB 2016-10-20T08:04:02-07:00 2016-10-21T08:04:01-07:00
853 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 7428 508 https://www.facebook.com/WiIliamsKalvin—788980617892144/ Kirk Figueroa, 33, ambushed two officers who responded to his East Boston apartment late Wednesday after they received a call about a domestic disturbance possibly involving a gun at the location. He wanted to die exactly the way he ultimately did while vowing to "revolutionize policing." Subscribe to our channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.oom/williams.and.kalvin Follow me on Twitter: https://twitter.oomNVi||iams8kalvin 12.78576 799.11 RUB 2016-11-01T06:06:31-07:00  
857 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 10022 766 https://www.facebook.com/WilIiamsKalvin-788980617892144/ For years, white supremacists in the Dothan, Alabama, police department allegedly planted drugs and guns on black people. There’s a lot going on in this story, which the Alabama Justice Project is said to have helped break thanks to anonymous whistleblowers within the Dothan Police Department. Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih All Cops are Criminals 12.81968 801.23 RUB 2016-11-01T06:06:05-07:00  
863 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 0 0 https://www.facebook.com/Wil|iamsKa|vin-788980617892144/ Black America is not into politics. This is not our game and we don’t want to play with whites. You know why? Because I don’t give a fuck about it! I really don’t care and I don’t know why any black American should care anyhow. We have our own life and our own future in this country. Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williamsand.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 0.0 0.00 USD 2016-11-18T08:16:22-08:00 2016-11-19T08:16:22-08:00
864 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2635 576 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Never forget to tell Black girls how amazing and beautiful they are! 2.20784 137.99 RUB 2016-10-23T09:54:21-07:00 2016-10-26T09:54:20-07:00
1085 location_living_in:united_states:Buffalo (+14 mi) New York, age:18 - 50, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 4011 288 https://www.facebook.com/events/1707140032898957/ Show up, fight racism and take a stand for equality. Monday, May 2 at 4 PM at Erie County Holding Center Justice For India: Not 1 More! 17.317439999999998 1082.34 RUB 2016-04-21T06:52:37-07:00 2016-04-28T06:52:36-07:00
1181 location_living_in:united_states:Buffalo (+14 mi) New York, age:18 - 50, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US) 1458 212 https://www.facebook.com/Blacktivist-128371547505950/ Afeni Shakur was a revolutionary activist, Black Panther and mother of one of the greatest rappers in America Tupac Amaru Shakur. She inspired her son, rap icon and fostered his legacy for years after he was slain. You will be missed. Rest in Peace, Afeni Shakur. 1.6 100.00 RUB 2016-05-06T05:45:47-07:00 2016-05-09T05:45:46-07:00
1871 location:United States, interests:Imgur, interests:CollegeHumor, interests:Reddit, age:18 - 50, language:English (US), placements:Instagram Feed 3330 25 https://www.instagram.Com/nuts.news/ Hello friends! Enjoy us daily! All the funniest memes and actual news. Click Learn More! Nuts News ( @nuts.news) Funnylnst 15.3208 957.55 RUB 2015-12-01T04:32:19-08:00  
2818 location_living_in:United States, excluded_connections:Exclude people who like Woke Blacks, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:The African History Network, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africahism, people_who_match:interests:Melanin, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, 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 (Color), people_who_match:interests:Black, girls_rock_behaviors:African American (US), girls_rock_behaviors:Field of study: African- American history 822 43 https://www.facebook.com/Woke-B|acks-294234600956431/ Come Check out our page, Uniting Black people worldwide! 30.80752 1925.47 RUB 2016-10-14T07:24:14-07:00  
3177 no image location_living_in:United States, age:18 - 50, placements:News Feed on desktop computers, placements:Right column on desktop computers, people_who_match:interests:Donald Trump for President, and_must_also_match:interests:Flash Games 0 0 http://hi||tendo.com/ Check this out! While Americans are deciding who to vote for at the 2016 presidential election, the official Democratic nominee, Hillary Clinton, is having fun. Travel with Hillary as far as you can, picking up emails and money, avoiding FBI agents, journalists and missiles along the way. Hilltendo Hilltendo 0.0 0.00 USD 2016-10-14T04:58:21-07:00  
3178 no image location_living_in:United States, age:18 - 50, placements:News Feed on desktop computers, placements:Right column on desktop computers, people_who_match:interests:Donald Trump, people_who_match:interests:Donald Trump for President, and_must_also_match:interests:Online games, and_must_also_match:interests:Flash Games 1042 32 http://hi||tendo.com/ Check this out! While Americans are deciding who to vote for at the 2016 presidential election, the official Democratic nominee, Hillary Clinton, is having fun. Travel with Hillary as far as you can, picking up emails and money, avoiding FBI agents, journalists and missiles along the way. Hilltendo Hilltendo 21.58464 1349.04 RUB 2016-10-14T05:00:04-07:00  

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/edsu/irads/03fb4b/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1269.09ms · Data source: simonw/russian-ira-facebook-ads-datasette