home / russian-ads

display_ads (view)

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

16 rows where an ad_target was people_who_match:interests:Multicultural Affinity: African American (US)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
832 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US — English dominant), exclude:multicultural_affinity:Hispanic (US — Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 6508 1240 https://www.facebook.com/WiIliamsKalvin-788980617892144/ BLACK DOLLARS MATTER While Black activists are trying to strict American government’s attention by organizing protests, Black bank owners urge Black Americans to transfer money into their banks. A few days ago there were started the #MoveYourMany campaign which the main goal is to demonstrate the value of Black lives within America. At the request of rapper Killer Mike, over 8,000 people have transferred their money into BIack—owned banks in the last 5 days. 50 years ago Martin Luther King Jr. requested Blacks to replace their funds from non-Black banks to BIack-owned institutions which would help to empower and advance Black community. The best way to fight the system is to break its capitalist back which is why it is important for Blacks to invest in ourselves! 8.0 500.00 RUB 2016-07-21T09:17:51-07:00 2016-07-22T09:17:50-07:00
837 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 2801 12 https://www.facebook.com/Williamsathalvin/ Questions about why police shot and critically wounded a 17-year-old Somali refugee in Salt Lake City grew Monday as Civil rights groups called for answers and several hundred protesters took the streets holdings signs that read, “Stop killer cops.” It’s very insane when those who are to protect us have turned into serial killers. The most annoying part is that they have refused to release the footage video. They need retraining. Whatever happened to Tasers? Whatever to rubber bullets? Whatever happened to shooting shots in the sky as a warning? Why are police wearing body cam and we can’t see it? If they’re right, let’s see it. Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Subscribe to my YouTube Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow me on Twitter: https://twitter.oom/Williams8kalvih 3.2 200.00 RUB 2016-03-10T01:28:08-08:00 2016-03-12T01:28:07-08:00
869 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US — All), exclude:multicultural_affinity:Hispanic (US — Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 5 0 https://www.facebook.com/WiIliamsKalvin-788980617892144/ Don't believe the stereotypes that media created to discredit black dads! They're the best! Like if you agree! 0.05072 3.17 RUB 2016-05-05T01:08:27-07:00 2016-05-06T01:08:27-07:00
897 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racismll, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 6881 192 https://www.facebook.com/WilliamsKalvin-788980617892144/ Robert Bentley, Alabama Governor, has decided to reform prison system. This is actually good news? Alabama happens to be one of the nation’s poorest states which have led to overcrowd in its prison. The prison system houses 24,000 inmates but it was designed for 13,000.Let me enlighten you a little on how it’s going to be done. Four other larger prisons will be built additionally to prevent the rate of overcrowd. Even though one would have taught of using this money for projects like health care facilities and other, he Chose prisons. It’s not bad though, at least inmates will have free live behind bars. It shows how much he cares for his people. Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Subscribe to my YouTube Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow me on Twitter: https://twitter.oom/Williams8kalvih 18.20848 1138.03 RUB 2016-03-22T07:34:48-07:00 2016-03-23T07:34:47-07:00
911 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 47 1 https://www.facebook.com/WilliamsandKalvin/ Black Discrimination Awareness! Like to join! 0.0 0.00 USD 2016-01-14T06:53:13-08:00  
915 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 44 0 https://www.facebook.com/WilliamsandKalvin/ BIaCk-Americans deserves equal justice! Like to join! 0.0 0.00 USD 2016-01-14T06:50:06-08:00  
918 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 137 1 https://www.facebook.com/WilliamsandKalvin/ Society need to see beyond skin color! Afro—american community welcomes you! 0.6316799999999999 39.48 RUB 2016-01-14T06:52:41-08:00  
921 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 145 3 https://www.facebook.com/WilliamsandKalvin/ Stop hating black people! Like to join! 1.26096 78.81 RUB 2016-01-14T06:51:15-08:00  
922 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 170 2 https://www.facebook.com/WilliamsandKalvin/ Black is beautiful! News and videos for BIaCk-Americans! 1.30304 81.44 RUB 2016-01-14T06:51:56-08:00  
923 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 267 3 https://www.facebook.com/WilliamsandKalvin/ Videoblog about racism and black social issues! 1.788 111.75 RUB 2016-01-14T06:46:44-08:00  
1693 location:united_states:Michigan, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Police brutality in the United States or Stop Police Brutality, people_who_match:interests:Multicultural Affinity: African American (US) 33183 1 https://www.facebook.com/BIackluive-1725227467722991/ We are looking for brave people who are ready to help our movement, who are creative and active, if you are one of such people, just let us know! Comment below or DM! 88.08352000000001 5505.22 RUB 2016-05-05T08:21:51-07:00  
1868 location:United States, age:13 - 65+, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Donald Trump, people_who_match:interests:Multicultural Affinity: African American (US) 21555 67 https://www.instagram.com/blackmattersus/ Hey, everyonel’? You know, a great number of black people support us saying that #HillaryClintonlsNotMyPresident! So this time we would like to make a #flashmob against #HillaryClinton because she is the real enemy of black community and our followers prove it showing their disgrace to her personality and policy. That's why we ask you to do the same and send your photos to us. Why? Because we want to live in a better future and Hillary is not the person who will help us in getting justice and peace by all means! Dear followers, if you agree, just don't be ignorant to your future in America, join our flashmob and take a photo with #HillaryClintonForPrison2016 or #nohillary2016 and tag @blackmattersusl? Looking forward to your photos?? BlackMattersUS AmericanCops 31.258080000000003 1953.63 RUB 2016-04-06T04:26:42-07:00  
3317 location:united_states:Astoria (+25 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 0 0 https://www.facebook.com/events/694209204073106/ The second seIf-defense class—Joih the event, bring your friends, feel safe with us!!! Self—defense classes with — 0.0 0.00 USD 2017-02-10T04:54:43-08:00 2017-02-11T15:29:15-08:00
3324 location:united_states:Astoria (+25 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 1533 72 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event, bring your friends, feel safe with us!!! Self—defense classes 23.53696 1471.06 RUB 2017-02-09T06:58:01-08:00 2017-02-11T15:29:15-08:00
3360 location_living_in:united_states:Orlando (+50 mi) Florida, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black Panther Party, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Huey P. Newton or Malcolm X, people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:martial arts and self defense, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:SeIf-defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Personal Defense Network, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Safety, and_must_also_match:interests:Active Self Protection, and_must_also_match:interests:The Self Defense Company 1720 49 https://www.facebook.com/events/180754319075270/ The first self—defense Class —Join the event, bring your friends, feel safe with us!!! SeIf-defense classes— 29.129759999999997 1820.61 RUB 2017-02-09T01:02:47-08:00 2017-02-11T08:00:00-08:00
3377 location:united_states:Astoria (+25 mi) New York, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan—Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African- American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African—American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 16 0 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event brin your friends, feel safe with us!!! Self—defense classes 0.7056 44.10 RUB 2017-02-09T01:01:32-08:00 2017-02-11T15:29:15-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 1343.756ms · Data source: simonw/russian-ira-facebook-ads-datasette