home / russian-ads

display_ads (view)

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

13 rows where an ad_target was people_who_match:interests:Pan-Afrioanism

View and edit SQL

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:Jr., 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

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 1899.657ms · Data source: simonw/russian-ira-facebook-ads-datasette