home / russian-ads

display_ads (view)

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

13 rows where an ad_target was age:16 - 45

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1036 location:united_states:Chicago (+10 mi) Illinois, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 6227 344 https://www.facebook.com/events/1751718638376338/ July 13 will mark the one-year anniversary of the death of Sandra Bland, a 28-year-old bla Rally in Memory of Sandra Bland 96.0 6000.00 RUB 2016-07-13T07:16:57-07:00 2016-07-16T07:16:53-07:00
1059 location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, 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) 0 0 https://www.facebook.com/events/607910082706490/ Join us at Erie Center! We need your support! Justice for India Cummings! India Cummings. SayHerName 0.0 0.00 USD 2016-04-08T08:09:51-07:00 2016-03-27T07:39:00-07:00
1091 location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, 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) 0 0 https://www.facebook.com/BIacktivist-128371547505950/ Go well beyond profiling 0.0 0.00 USD 2016-05-11T05:07:07-07:00 2016-05-15T07:00:01-07:00
1105 location:united_states:Cleveland (+34 mi) Ohio, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1094784283992152/ On October 15, 1966, Bobby Seale and Huey P. Newton have founded BPP. Their idea was simple - we can't just talk to make the Change, we must take action. They started to monitor the behavior of police officers and Challenge police brutality in Oakland, California. And they succeeded. Unfortunately, the government and especially Federal Bureau of Investigation called the party "the greatest threat to the internal security of the country". They tried to Close it, to incarcerate BPP's participants, and in 1982 the original party was dissolved. 50 years have passed since BBP's foundation, but the situation in the country stills the same. Cops are shooting Blacks. lt spreads through all the country like the disease. Nowadays we need Black Panthers as never before. We need a strong hand that can protect us, that can keep our people safe, that can make Black Lives really matter. Let's get together and celebrate the 50th anniversary of the party that has made the Change. Let's honor its founders and participants. Let's share their ideas and ideals! Black Panther Party 50th Anniversary 0.0 0.00 USD 2016-09-29T07:07:13-07:00 2016-10-14T15:00:00-07:00
1146 location:united_states:Chicago (+10 mi) Illinois, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 6375 400 https://www.facebook.com/events/1751718638376338/ Chicagoans, join us on July 16th outside the Homan Square facility to protest against police brutality and violence against black people in the country and honor the memory of Sandra Bland. Rally in Memory of Sandra Bland 97.41856 6088.66 RUB 2016-06-06T08:33:49-07:00 2016-06-13T08:33:48-07:00
1174 location:united_states:Cleveland (+34 mi) Ohio, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 5785 202 https://www.facebook.com/events/1607406689552066/ WHY are we holding the Black Unity March? The black community is facing a number of seriou Black Unity March 121.75072 7609.42 RUB 2016-08-23T04:35:12-07:00 2016-09-17T02:00:09-07:00
1175 location:united_states:Cleveland (+34 mi) Ohio, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power 3188 224 https://www.facebook.com/events/1607406689552066/ WHY are we holding the Black Unity March? The black community is facing a number of seriou Black Unity March 38.24928 2390.58 RUB 2016-09-15T06:27:18-07:00 2016-09-17T02:00:09-07:00
1178 location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, 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) 1235 93 https://www.facebook.com/Blacktivist-128371547505950/ There is a blood on American hands. Our country still seeks for Nazi war criminals but doesn‘t even look for home grown terrorist groups such as KKK, who are responsible for murder of thousands of innocent people. 1.584 99.00 RUB 2016-05-06T05:46:09-07:00 2016-05-09T05:46:09-07:00
1222 no image location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, 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) 22 1 https://www.facebook.com/Blacktivist-128371547505950/ BLACK STATE TROOPER WHO WON LAWSUIT AGAINST POLICE DEPARTMENT FOR RACIAL DISCRIMINATION FACED THE SAME ISSUED WHEN HE RETURNED TO WORK Two Michigan Black police troopers who recently won lawsuit in racial discrimination and were awarded $5.2 million are suing police department again, Claiming they faced the same issues. According to State Police troopers Darzeil Hall and Lamarr Johnson, ever since they returned to work, they have been subjected to petty attacks and denied attempts in promotion. Instead of correcting the wrong behavior toward black employees, police department aggressively criticized their conduct. For instance, police trooper Ha|| received a “need improvement rating,” his squad car was taken away, and his gym car was deactivated for a minor mistake. Along with Hall, police trooper Johnson was denied at least five promotions after the lawsuit ended on the basis of race. Once again the race car is alive and well. Unfortunately, black police officers still remain second-class officers and experience unfair treatment in police department despite the fact that we live in a “post-racial” society. 0.076 4.75 RUB 2016-05-11T05:01:41-07:00 2016-05-12T05:01:41-07:00
1232 location:united_states:Rochester (+50 mi) New York, interests:Copwatch, interests:Rodney King, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Cop Block, interests:Photography is Not a Crime, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 2195 91 https://www.facebook.com/events/853677788070082/ JOIN OUR RALLY 4 INDIA CUMMINGS ON THURSDAY, MAY 26 Feb. 1, she is arrested for carjacking among other things. Feb. 9, she doesnt recognized her own arraignment Feb 1- Feb. 17, she was denied numerous visits. Her family was denied visits I should say. By Feb. 17, she had broken ribs, irreparable brain damage, blood Clot in her leg, was thoroughly dehydrated among other things. Legally, she was dead. Feb. 17, she was shipped to Buffalo geneneral medical hospital. Feb. 17, Feb 21, family believed amputation of leg was critical. Feb. 21, India Cummings was pronounced dead. Feb. 21, her remaining organs crashed and she was pronounced dead. Feb. 17, sheriff Howard called the situation a "medical event" and said very little else. #JusticeforlndiaCummings https://www.facebook.com/events/853677788070082/ Rally 4 India Cummings-ROC Remix 36.689440000000005 2293.09 RUB 2016-05-11T08:15:34-07:00 2016-05-19T08:15:33-07:00
1233 location:united_states:Rochester (+50 mi) New York, age:16 - 45, 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) 14 2     0.04496 2.81 RUB 2016-05-16T08:26:53-07:00 2016-05-19T08:15:33-07:00
1234 location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, 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) 51 7 https://www.facebook.com/Blacktivist-128371547505950/ MAN WHO WAS CHARGED WITH BURNING DA VINCI APARTMENT WAS ANGRY ABOUT POLICE KILLINGS OF BLACK PEOPLE The man who was accused of Da Vinci apartment complex arson that caused the City $100 million in damages testified that he was angry at high-profile killing of black men. Dawud Abdulwali attended a party in a Hollywood hotel where he ranted about the August 2014 killing of unarmed Michael Brown by a white police officer in Ferguson. According to one of the witnesses, he was so mad about the high profile killing of unarmed black men, so he burned the building. Abdulwalia‘s anger at police was not a good reason to burn down some apartments, but injustice brought him to this action. Either way, crime should not be tolerated. But we have to start thinking about the message he was trying to send: having a black president Changes almost nothing. 0.22688 14.18 RUB 2016-05-11T05:04:41-07:00 2016-05-12T07:00:01-07:00
1235 location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, 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) 21 4 https://www.facebook.com/Blacktivist-128371547505950/ FAMILY MEMBERS OF NINE VICTIMS KILLED IN THE MASS SHOOTING INSIDE A SC CHURCH AREN‘T PLEASED WITH DONATIONA PAYOUT The family members of South Carolina Church massacre victims are upset with the distribution of donations the Church has received since June shooting. The Methodist Episcopal Church have decided that the families will have to divide $1.5 million in donations, while they will keep $1.8 million, with plans to make Iong-needed repairs to the Church. For instance, the wife of the Rev. Clementa Pinckney who was among those killed by white shooter Dylan Roof, has not received any of the donation proceeds. Nothing will bring the victims of Charleston massacre back, but this money will help aid in bridging the gap in the loss of an income. Donations are important for these families since they did not receive a cent from the government. 0.08288 5.18 RUB 2016-05-11T05:01:25-07:00 2016-05-12T05:01:24-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 1293.093ms · Data source: simonw/russian-ira-facebook-ads-datasette