home / russian-ads

display_ads (view)

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

15 rows where an ad_target was and_must_also_match:interests:HuffPost Black Voices

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
73 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 141500 6282 https://b|ackmattersus.oom/ Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters 386.6528 24165.80 RUB 2016-02-04T23:54:33-08:00  
74 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 42072 1805 https://b|ackmattersus.oom/ Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters 170.8296 10676.85 RUB 2016-04-25T05:36:07-07:00  
75 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 0 0 https://b|ackmattersus.oom/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-Amerioan fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy MoDoIe, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Girl Gets Rope Burns During A Camping Trip When Sandy Rougely’s 12-year-old daughter returned from a one day camping trip on April 28, Sandy was shocked to see a horrible rope burn on the front side of the kid’s heck. Black Matters 0.0 0.00 USD 2016-05-23T08:02:51-07:00  
76 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 89836 3402 https://b|ackmattersus.com/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-American fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy McDole, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Matters 226.92176 14182.61 RUB 2016-05-24T00:19:06-07:00  
77 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US), and_must_also_match:interests:Black Tea Patriots, and_must_also_match:interests:Black Knowledge, and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 0 0 https://b|ackmattersus.com/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-American fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy McDole, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Matters 0.0 0.00 USD 2016-06-16T01:21:05-07:00  
78 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 44405 1739 https://b|ackmattersus.com/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Chicago IPRA Finally Gets Dashcam Video Of Darius Pinex Shooting It took over five years for the IPRA to get the key evidence in the fatal police shooting of a black Chicago man committed in 2011. Orlando Nightclub Massacre And The Race Factor Orlando tragedy shed light on how hate and terrorism can destroy innocent lives within a matter of seconds. Pepper-Sprayed Victim Donates $100K Settlement To Social Justice A Seattle high school history teacher Jesse Hagopian, pepper- sprayed by police, says he’ll donate the $100K settlement to help movement forjustice. NYPD Cop Pulls A Gun On Black Cyclist In Fender-Bender A 21-year-old black cyclist plans to sue a white NYPD police officer for threatening his life by pointing a gun at him during a fender-bender. Black Matters 95.05472 5940.92 RUB 2016-06-16T01:32:37-07:00  
805 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 11206 1132 https://www.facebook.com/Williamsathalvin/ A 21-year-old Oklahoma man was sentenced on Monday to 40 years in prison for sexually assaulting orphaned Children while on a missionary trip in Kenya in 2014. Matthew works at an orphanage built and run by an American Citizen named Upendo Children Centre. The main aim of this orphanage was to assist abandoned Children in Nairobi, Kenya. Upon Matthew’s arrival in Kenya, he insisted on not staying in the apartment allocated to him by authorities but preferred to stay in the very dormitory where these Children stayed. He also based his choice on being in a better position to assist the Children should the need arise. Mathew raped three teenagers — ages of 5, 9, and 15 respectively for not less than 8 times. He also maltreated a 12 year old boy. This outrageous act led to his sentence of 40 years imprisonment and a fined of $15, 863. 80.0 5000.00 RUB 2016-03-17T05:30:18-07:00 2016-03-20T05:30:18-07:00
810 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:behaviors:African American (US), and_must_also_match:interests:BIaokNewsoom, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 716 42 https://www.facebook.com/Williamsathalvin/ This is just for laughs :D No offends, just saying things the way they are. Guys, what do you think about this Trump (stitches parody)? #TheTrump #just4laughs 4.8 300.00 RUB 2016-03-17T05:32:20-07:00 2016-03-20T05:32:19-07:00
830 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 4234 416 https://www.facebook.com/Williamsathalvin/ Ku Klux Klan is a movement in the United States that have advocated through terrorism for white supremacy, white nationalism and anti-immigration. They normally aimed at groups whom they opposed. The Klan held an anti- immigration rally on Saturday. They got surrounded by group of protesters who beat and kicked them violently. On Monday evening, a crowd of Civil right protesters gathered for a vigil against Ku Klux Klan. It was a march where the protesters carried signs that had the inscription “Power through Peace”. This march was an intended peaceful march which was meant to bring peace and unity. Subscribe to my Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow me on Twitter: https://twitter.com/Williams8kalvih 8.53552 533.47 RUB 2016-03-11T00:38:58-08:00 2016-03-13T00:38:57-08:00
849 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, accessing_facebook_on:Wi-Fi, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Why don‘t american cops realize that being black is not a crime? African american kids are being shot only for playing with toy guns... How is it possible? Where is the justice? Our Government is blind, they simply don‘t want to pay attention to this legalized homicide of own people... This is crazy! We must speak about it! 0.0 0.00 USD 2016-01-19T03:45:52-08:00 2016-01-08T02:03:12-08:00
900 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 748 104 https://www.facebook.com/Williamsathalvin/ Serena Williams will be world’s highest paid female athlete — After her dominance in the singles women tennis Championship. Congratulations to her for lifting the image of Black Americans. Her achievement is ours and we’re with her all the way through. #SelinaWilliams #Highlypaidfemaleathlete #BlackWomenAchievements 3.2 200.00 RUB 2016-03-11T00:39:21-08:00 2016-03-12T00:39:20-08:00
906 location:United States, age:18 - 54, 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), and_must_also_match:interests:BIaokNewsoom, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 0 0 https://www.facebook.com/Williamsathalvin/ As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberation of Black Americans, the question is "who will keep his dream alive"? He saw the promise-Iand where blacks and whites live together in harmony and each of them given equal rights and privileges, freedom and justice. Today, we do not see this equality among blacks and whites in America. These rights and privileges, freedom and justice shouldn't be for some selected few but all! 0.0 0.00 USD 2016-01-19T07:54:51-08:00 2016-01-22T07:54:50-08:00
907 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:behaviors:African American (US), and_must_also_match:interests:BIaokNewsoom, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 2975 64 https://www.facebook.com/Williamsathalvin/ As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberation of Black Americans, the question is "who will keep his dream alive"? He saw the promise-Iand where blacks and whites live together in harmony and each of them given equal rights and privileges, freedom and justice. Today, we do not see this equality among blacks and whites in America. These rights and privileges, freedom and justice shouldn't be for some selected few but all! 9.83296 614.56 RUB 2016-01-19T07:56:20-08:00 2016-01-22T07:54:50-08:00
908 no image location:United States, age:18 - 54, 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), and_must_also_match:interests:BIaokNewsoom, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 0 0 https://www.facebook.com/Williamsathalvin/ As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberation of Black Americans, the question is "who will keep his dream alive"? He saw the promise-Iand where blacks and whites live together in harmony and each of them given equal rights and privileges, freedom and justice. Today, we do not see this equality among blacks and whites in America. These rights and privileges, freedom and justice shouldn't be for some selected few but all! Thanks for watching, I'd like to hear from you; Click like, Share and Comment. Together we can make America a better place. https://www.youtube.com/watch?v=th|85XjHKc As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberatio... WHO WILL BE THE NEXT MARTIN LUTHER KING JR? Williams&Ka|vin 0.0 0.00 USD 2016-01-19T04:43:54-08:00 2016-01-22T04:43:53-08:00
909 no image location:United States, age:18 - 54, 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), and_must_also_match:interests:BIaokNewsoom, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 0 0 https://www.facebook.com/Williamsathalvin/ As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberation of Black Americans, the question is "who will keep his dream alive"? He saw the promise-Iand where blacks and whites live together in harmony and each of them given equal rights and privileges, freedom and justice. Today, we do not see this equality among blacks and whites in America. These rights and privileges, freedom and justice shouldn't be for some selected few but all! Thanks for watching, I'd like to hear from you; Click like, Share and Comment. Together we can make America a better place. https://www.youtube.com/watch?v=th|85XjHKc As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberatio... WHO WILL BE THE NEXT MARTIN LUTHER KING JR? Williams&Ka|vin 0.0 0.00 USD 2016-01-19T03:46:37-08:00 2016-01-22T03:46:36-08:00

Advanced export

JSON shape: default, array

CSV options:

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