Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
| id | img | targeting | impressions | clicks | url | text | spend_usd | spend_amount | spend_currency | created | ended |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 940 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) | 58233 | 4781 | https://www.facebook.com/blacktivists/ | When you leave your baby girl alone with her father, that‘s what happens. When you leave your baby girl alone with her father, that‘s wh... | 3.2 | 200.00 | RUB | 2017-04-19T07:17:40-07:00 | 2017-04-20T12:00:00-07:00 |
| 970 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 0 | 0 | https://www.facebook.com/blacktivists/ | Before you buy new pair of Jordans, try to remember your ancestors, who worked day and night to afford at least one dress. | 0.0 | 0.00 | USD | 2017-04-13T04:41:04-07:00 | 2017-04-16T06:00:00-07:00 |
| 977 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 53511 | 9633 | https://www.facebook.com/blacktivists/ | Repost from @Williams&Kalvin ATTENTION! COMMUNITY CALLS FOR A BOYCOTT! Disturbing video shows Sung Ho Lim, an owner of Missha Beauty (in Charlotte, NC), kicked and choked a Black woman! This man absolutely crossed the line! According to Lim, he saw the unidentified woman stealing eyelashes. But, in the video, you can hear the woman tell Lim, “Check my bag. I’m telling you I don’t have anything.” And why did he attack her? Did he try arrest her or what? Corine Mack of the Charlotte-Mecklenburg Chapter of the NAACP demanded that Lim apologize to the Black community in Charlotte. But folks, lwant it be not only the boycott of this exact store but all shops and stores where Black people were treated disrespectfully! We don’t believe apologies, especially when we know that this man is sorry only about profit he's going to lose! | 6.4 | 400.00 | RUB | 2017-03-15T07:39:52-07:00 | 2017-03-16T09:00:00-07:00 |
| 994 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 64595 | 4936 | https://www.facebook.com/blacktivists/ | FINALLY! TWO GEORGIA POLICE OFFICERS HAVE BEEN FIRED AFTER VIDEO SHOWS THEM KICK BLACK MAN DURING TRAFFIC STOP Two Georgia police officers have been fired after police released the footage of the encounter where two Gwinnett County cops kicking a black college student during a traffic stop. According to a police report, 21-year-old Demetrius Ho||ins was pulled over near Lawrenceville for Changing |ines several times without signaling. When cops stopped him, Ho||ins was seen on video standing with his hands raised before one of the officers was seen punching the motorist in his face, and the second cop racing to the scene later, only to stomp Ho||ins in his face. The 21-year-old man said he feared for his life when he saw police approach him. Ho||ins raised his hands up in order to let him know that he didn‘t have anything where he could hurt him, but police beat him. Moreover, after the incident cops wrote in their police report that Ho||ins resisted arrest and Claimed that Ho||ins refused to place his hands behind his back and resisted arrest. Cops |itera||y lied and had no shame. This incident embarrassed and the Gwinnett County police and all law enforcement. They should be held accountable for their actions. Resignation is not the answer. We did not hear any criminal Charges, even though they admit the cops broke the law. Where is the justice? FINALLY! TWO GEORGIA POLICE OFFICERS HAVE BEEN FIRED AFTER VID... | 6.4 | 400.00 | RUB | 2017-04-21T07:37:40-07:00 | 2017-04-22T07:37:40-07:00 |
| 1017 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 11178 | 1165 | https://www.facebook.com/blacktivists/ | When people ask you ‘where you‘re from?’ and you reply America because that‘s where you and your parents were born, and then on que, they ask you again ‘no, where are you really from?; as if being black makes you less American. | 6.399520000000001 | 399.97 | RUB | 2017-04-13T04:39:28-07:00 | 2017-04-14T08:00:00-07:00 |
| 1037 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) | 56416 | 4011 | https://www.facebook.com/Blacktivist-128371547505950/ | When your mom sends you to shoot a hair tutorial so she can have a few minutes of peace. When your mom sends you to shoot a hair tutorial so she can ha... www.facebook.com | 4.8 | 300.00 | RUB | 2017-03-09T02:48:35-08:00 | 2017-03-10T02:48:35-08:00 |
| 1060 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 15201 | 1731 | https://www.facebook.com/blacktivists/ | When you support a bIaCk-owned business you support your community. | 8.0 | 500.00 | RUB | 2016-12-05T23:15:41-08:00 | 2016-12-06T23:15:41-08:00 |
| 1089 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 16093 | 2102 | https://www.facebook.com/blacktivists/ | COLIN KAEPERNICK DONATED TO BLACK YOUTH PROJECT 100 Of course, many of you will scoff at comparing 49ers quarterback Colin Kaepernick to Martin Luther King Jr., who also demanded better from America in 1966. But after all, Kaepernick is a great athlete who not just sat out the national anthem in protest, but also gave back to the community by donating to the Black Youth Project 100. Kaepernick donated to the Chicago Chapter of the organization toward “Chapter-specific ideas and endeavors centered on advancing Agenda to Build Black Futures” which is dedicated to creating justice and freedom for all Black people in order to improve the lives of black people in the United States of America. “I’ll continue to look at other communities in Chicago, as well, as far as what are ways I can help and what are ways I can try to help empower those communities,” he said. When someone strives to uplift the negativity surrounding black people, there is always someone who will distort the positivity. But we don‘t really care about haters. Goodjob, Colin. | 6.4 | 400.00 | RUB | 2016-12-07T07:17:08-08:00 | 2016-12-08T07:17:08-08:00 |
| 1120 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 48 | 27 | https://www.facebook.com/Blacktivist-128371547505950/ | US. ARMY LIFTS BAN ON DREADLOCKS. After the critics complained about the Army‘s unfair burden on black women‘s hair, the US. Army again lifted the ban on dreadlocks that was instated in April 2014. The ban faced an instant backlash from black women so the Army unbanned braids and twists amidst the criticism. Some of the female soldiers used harsh Chemicals to keep their hair straight. Moreover, every eight weeks it cost them to $80. Thus, the ban on dreadlocks caused a lot of unnecessary stress. The ban on loos, which was part of Army Regulation 670-1, remained until January 2017. The new rules offered female soldiers another hairstyle option. Now the rules allow dreadlocks and looks but only if they are less than a half- inch wide. Well, it took months for the Army to recognize that black women have different hair texture. | 3.2 | 200.00 | RUB | 2017-02-14T06:46:19-08:00 | 2017-02-15T06:46:19-08:00 |
| 1154 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 23334 | 3301 | https://www.facebook.com/blacktivists/ | It‘s not about wanting to be someone else. It‘s about knowing who you are and comfort in your skin. | 6.4 | 400.00 | RUB | 2016-12-06T23:30:56-08:00 | 2016-12-07T23:30:56-08:00 |
| 1172 | |
location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black (Color) | 21941 | 2647 | https://www.facebook.com/blacktivists/ | Based on scientific literature, skeletons and skulls of the ancient Egyptians indicate they were Negroid people with features very similar to those of modern Black Nubians and people of East Africa. Remember who you are and know your ancestors. | 6.4 | 400.00 | RUB | 2016-12-07T23:07:03-08:00 | 2016-12-08T23:07:03-08:00 |
| 2796 | |
location:United States, excluded_connections:Exclude people who like Nefertiti's Community, 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:Martin Luther King, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:Black history, people_who_match:interests:Black (Color) | 0 | 0 | https://www.facebook.com/Nefertitis-Community-576081822594619/ | Join us to study your blackness and get the power from your roots. Stay woke and natural! | 0.0 | 0.00 | USD | 2016-10-18T01:32:26-07:00 | |
| 2800 | |
location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 60, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:Black Enterprise, people_who_match:interests:Black (Color) | 167 | 29 | https://www.facebook.com/Nefertitis-Community-576081822594619/ | Surround yourself with only people who are going to lift you higher and break the chains in your mind! #black #powerful #quotes #panafrican | 0.63888 | 39.93 | RUB | 2016-11-15T05:16:56-08:00 | 2016-11-16T05:16:56-08:00 |
CREATE VIEW display_ads AS
select ads.id,
case when image is not null then
json_object("img_src", "https://raw.githubusercontent.com/umd-mith/irads/master/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