home / russian-ads

display_ads (view)

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

23 rows where an ad_target was location:united_states:New York New York

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
183 no image location:united_states:New York New York, interests:Black Tea Patriots, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1847 144 https://www.facebook.com/blackmattersus/ Join our upcoming event: https://www.facebook.com/events/162707160753103/ Confirmed speakers for the #WeWantFreedom protest include black activist #CrimesOfGenocide 16.0 1000.00 RUB 2016-02-12T00:36:55-08:00 2016-02-14T00:36:55-08:00
184 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 10457 1000 https://www.facebook.com/blackmattersus/ Officer Liang, who fatally shot 28-year-old Akai Gurley, was found guilty of manslaughter, assault, and other criminal Charges. Read more: http://b|ackmattersus.oom/1786-nypd-officer-Iee-Charged-with-manslaughter- and-other—charges/ 24.0 1500.00 RUB 2016-02-12T07:09:39-08:00 2016-02-15T07:09:39-08:00
185 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 16684 1237 https://www.facebook.com/blackmattersus/ 26-year-old Mario Woods was killed by the San Francisco police on 2 December. An autopsy released on Thursday shows that Mario was hit 20 times by officers’ bullets. Sixteen of the wounds were said to have gone from “back to front” through Woods’ body, including six in his back and two in the back of his head. Read more: http://b|ackmattersus.com/1760-20-bul|ets-recovered-from-body-of-mario— woods-autopsy-reports-show/ 24.0 1500.00 RUB 2016-02-12T07:01:48-08:00 2016-02-15T07:01:47-08:00
186 no image location:united_states:New York New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1590 180 https://www.facebook.com/blackmattersus/ “Formation”, undoubtedly focuses on “black identity”, as Beyonce justifies her authority as a proud Black woman and concurrently authenticating her roots and history. Read more: http://b|ackmattersus.com/1670-20-time-grammy-winner—and-proud-queen- diva-be-goes-politicaI-with-her-form ation/ 7.39136 461.96 RUB 2016-02-12T00:36:07-08:00 2016-02-21T00:36:06-08:00
188 no image location:united_states:New York New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 10016 283 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! Join the We need your support! We'll provide you with free food and coffee. Come and bring your friends! Join the FB event for more details: 23.9312 1495.70 RUB 2016-02-18T05:57:41-08:00 2016-02-19T05:46:31-08:00
193 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 20 1 https://www.facebook.com/BlaCk-Matters-1579673598947501/ 21-year-old Lane Durham from Oklahoma is facing up to 40 years of confinement for sexual harassment, when he volunteered as a missionary in Kenya. “All I wanted was to follow God’s plan for me,” Durham told before court pleading for mercy. In June 2014, Matthew Durham came under national spotlight when he was accused of raping and molesting several young black girls and boys in an orphanage in Kenya. Now, 21-year-old Lane Durham from Oklahoma is facing up to 40 years of confinement for sexual harassment, when he volunteered as a missi... 40 Years For Sexually Abusing Kenyan Orphans Isn’t Enough | Black Matters Black Matters 0.32144 20.09 RUB 2016-03-10T04:13:40-08:00 2016-03-11T04:13:38-08:00
194 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 1818 150 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Sean Chung, 20, was sent to Riker’s Island last month because of a music video he posted in November. The last thing you would imagine someone will go to jail for is their rap lyrics. Afterwards this is America --- the Land of the Free and home of the Brave. The country where artists like lce-T and Ice Cube can sing about killing cops and win multi-million dollar record deals. “I’m ’bout to dust som... A Blatant Disregard For The First Amendment: Young Rapper Jailed For Lyrics | Black Matters Black Matters 6.1435200000000005 383.97 RUB 2016-03-10T04:12:29-08:00 2016-03-11T04:12:28-08:00
195 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 393 32 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Family members of India Kager will receive the video of India and Angelo’s shooting today, March 10th. On March 8, women all over the world celebrated heartily, the pride in being a women. But in the case of Gina, she only wishes the justice to be served. Gina’s grieving ever since the death of her daughter India Kager along with Angelo Perry, India’s boyfriend, has been escalated by an attorney’s de... Gina Kager Receives The Video Of India’s Death | Black Matters Black Matters 3.19936 199.96 RUB 2016-03-11T01:52:05-08:00 2016-03-12T01:52:04-08:00
196 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 1829 184 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A narcotics detective, who abused his power in the past, was shot in the shoulder by his fellow officer. It's time to reap what you sow. The day before yesterday an unidentified police sergeant accidentally shot Jon Gladstone, a narcotics detective, while firing at two unarmed drug dealers in Brooklyn. The drug dealers were surrounded by these two undercover oops. It happened while the criminals were sitting in a parked van. When the... NYPD Cop Shot Another Cop During A Drug Bust | Black Matters Black Matters 6.4 400.00 RUB 2016-03-11T01:51:39-08:00 2016-03-13T01:51:39-08:00
197 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 5 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The VA State Attorney Colon Stolle sees no law violation in Virginia Police actions. The VA State Attorney Colon Stolle on Wednesday gave a verdict concerning the four Virginia Police Officers who were involved in the shooting of India Kager at a press conference. He is sure that they didn’t violate the law and shouldn’t be prosecuted. During the press conference, a minute video of... No Charges For VA Beach Police For Killing India Kager | Black Matters Black Matters 0.01088 0.68 RUB 2016-03-11T01:51:03-08:00 2016-03-13T01:51:02-08:00
198 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 4 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The family of Luis Martinez wants Dist. Attorney Jackie Lacey to file Charges against the police officers who were involved in the fatal shooting of a 35-year- old man. On April 21 2015, Hollenbeck Division patrol officers were called by Martinez’s wife reporting that her husband, Luis Martinez had stabbed himself. Luis Martinez was a 35-year-old man with a broken hip from falling over a railing from the third floor of his apartment. Martinez’s injuries were so sev... Family Seeks Charges Against LAPD Involved in Fatal Shooting OfA Man | Black Matters Black Matters 0.03008 1.88 RUB 2016-03-11T01:50:37-08:00 2016-03-12T01:50:36-08:00
199 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 3484 320 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The mother of Tamir Rice wants to inspire young activists to rally against a system that is stacked against communities of color. Samaria Rice, the mother of 12-year-old Tamir Rice, who was fatally shot by officer Timothy Loehmann in 2014, will address police brutality and other important issues at Kalamazoo College in Michigan on Wednesday. She wants to speak out at the college in order to inspire students to stand up against... Samaria Rice To Speak At Michigan College | Black Matters Black Matters 16.0 1000.00 RUB 2016-03-11T01:49:33-08:00 2016-03-14T02:49:33-07:00
200 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 359 29 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Since history men have developed fetishes on the curve body figures of black women making them feel like sex objects. Alessandrai Rhines explains why it is wrong to use black women as experiments. Since history men have developed fetishes on the curve body figures of black women making them feel like sex objects. Black women have been made to feel like they are highly sexualized beings since slavery. Poet Alessandria Rhines performed at Button Poetry Live, in January 2016, explaining in her p... Alessandrai Rhines Explains Why It Is Wrong To Use Black Women As Experiments | Black Matters Black Matters 3.2 200.00 RUB 2016-03-11T01:48:30-08:00 2016-03-12T01:48:30-08:00
201 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 391 39 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Maryland’s Highest Court on Tuesday ordered a Baltimore police officer to testify against his colleagues who were also Charged with Freddie Gray’s death. Baltimore’s police officer William Porter is set to testify against his colleagues who sort the death of Freddie Gray under the grant of limited immunity, which means that what he says can’t be used against him during his own trial, as the court ordered. The Court of Appeals gave no reason for the d... Second Freddie Gray Trial Said Officer Must Testify Against Co- Defendants | Black Matters Black Matters 2.30912 144.32 RUB 2016-03-10T04:07:33-08:00 2016-03-11T04:07:32-08:00
202 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 7 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ University of Missouri assistant communications professor is appealing her firing last month over her role in racism protests last year. Melissa Click, who was caught on tape cursing student journalists and also police officers during protest last year, stated on Tuesday that her dismissal on Feb. 25 by university system curators was unprofessional. "In their decision to terminate my employment, the curators bowed to conservative voi... Missouri Professor Dismissed Over Misconduct Files Appeal | Black Matters Black Matters 0.11952 7.47 RUB 2016-03-10T04:07:22-08:00 2016-03-11T04:07:21-08:00
203 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 432 42 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A seventh-grade student at a private school in Hopewell, Virginia, was told by school administrators he must remove his dreadlocks if he wanted to stay in the school. A seventh-grade student at a private school in Hopewell, Virginia, was told by school administrators he must remove his dreadlocks if he wanted to stay in the school. Isaiah Freeman, 13, has had dreadlocks at the West End Christian School since third grade. It therefore, came as a surprise to his fa... Seventh-Grader Told To Cut Dreadlocks Or Leave The School | Black Matters Black Matters 2.33072 145.67 RUB 2016-03-10T04:07:06-08:00 2016-03-11T04:07:06-08:00
204 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 19 2 https://www.facebook.com/BlaCk-Matters-1579673598947501/ She didn’t only win the women Champions against Maria Sharapova last year, but now she is on her way to being the highest paid. On the fact of it, American sports are dominated by Black Americans. Talk of Basketball, Soccer, American football, Athletics and the like, we have represented the nation on an international level and almost always brought glory to this nation. This is because Black culture has imbibed into us drive... Serena Williams Will Be World’s Highest Paid Female Athlete | Black Matters Black Matters 0.0544 3.40 RUB 2016-03-14T01:54:00-07:00 2016-03-15T06:11:54-07:00
205 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 10 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Unrepentant hateful Trump supporter enjoyed sucker punching black man at rally. https://b|ackmattersus.com/4652-trump-supporter—who—punched-blaCk-man-at- nC-raIIy-next-time-we-might-have-to—kiII-him/ Following statements from his emperor saying he’d like to punch a protester in the face, Donald Trump supporter, John McGraw, 78, was caught on video sucker punching a black man during a rally Wednesday in Fayetteville, North Carolina. Videos posted to social media showing several angles of McGraw's... Trump Supporter Who Punched Black Man at NC Rally: ‘Next Time We Might Have to Kill Him’ | Black... Black Matters 0.08736000000000001 5.46 RUB 2016-03-14T06:11:31-07:00 2016-03-15T06:11:30-07:00
206 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 15 0 https://b|ackmattersus.com/4678-police-says-run-them-over—and-goes-scot- A St. Paul Police sergeant who posted on Facebook “run them over” about BLM protesters won’t face any criminal Charges. https://b|ackmattersus.com/4678-police-says-run-them-over—and-goes-scot- free/ The sergeant Jeffrey Rothecker, in his Facebook comment, referred to protesters as idiots. He wrote about how drivers could even escape Charges if they ever killed any of the protesters during protests. He out smarted the police department and resigned before any disciplinary actions were taken. The... Police Says “Run Them Over” And Goes Soot—Free | Black Matters Black Matters 0.18832 11.77 RUB 2016-03-14T06:11:09-07:00 2016-03-15T06:11:08-07:00
207 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 45 5 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Trump said “You know, Barack Obama — African-Amerioan — if I were African- American, I would be so angry at him,” “I will do more for the African- American people in one year than Barack Obama has done in his seven years, soon to be eight years, and then by the way, he’s out and thank goodness, OK?”. The controversial Trump has made so many promises especially to African-Americans during his recent campaigns. Some of these promises include Trump saying, “I’m going to unify the country,” Trump told thousands of people at a rally in this suburb of Detroit. “I’m going to unify blacks and whites.” A... Donald Trump’s Promises to African-Americans | Black Matters Black Matters 0.12336 7.71 RUB 2016-03-14T06:10:15-07:00 2016-03-15T06:10:14-07:00
309 location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 197 15 https://www.facebook.com/blackmattersus/ We finally made it! Welcome to the official Black Matters Website! http://b|ackmattersus.com/ 2.26896 141.81 RUB 2016-03-10T05:50:56-08:00 2016-03-11T05:50:55-08:00
310 no image location:united_states:New York New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ As what happened to India while in police custody remains a major concern, many are wondering why the 27-year-old was denied an appropriate medical evaluation and proper care. The frequent reports of police brutality and extreme use of force, leading to death has regrettably become a daily course. Consequently, protests and demonstrations overflow in every nook and cranny, demanding answers and justice. On February 1, India T. Cummings was under the influence of the synth... #JusticeForlhdia: 27-Year-old Denied Medical Treatment, Dies in Police Custody | Black Matters Black Matters 0.0 0.00 USD 2016-03-04T00:41:08-08:00 2016-03-05T00:41:08-08:00
311 no image location:united_states:New York New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 8 1 https://www.facebook.com/blackmattersus/   0.08752 5.47 RUB 2016-02-12T07:00:28-08:00 2016-02-15T07:00:27-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 1607.101ms · Data source: simonw/russian-ira-facebook-ads-datasette