home / russian-ads

display_ads (view)

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

25 rows where an ad_target was interests:Anti-discrimination

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1061 location:United States, interests:Human rights, interests:Malcolm X Memorial Foundation, interests:Malcolm X Grassroots Movement, interests:End Slavery Now, interests:Justice, interests:Culture, interests:Slavery in the United States, interests:African-American culture, interests:African culture, interests:Black is beautiful, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Equal opportunity, interests:Angela Davis, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Black (Color), interests:Nigerians, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 11932 2056 https://www.facebook.com/Blacktivist-128371547505950/ Anyways, nobody is listening to us. 6.3884799999999995 399.28 RUB 2016-10-12T03:59:42-07:00 2016-10-13T03:59:39-07:00
1064 location:United States, interests:Human rights, interests:Justice, interests:Culture, interests:Slavery in the United States, interests:Black is beautiful, interests:Equal opportunity, interests:Angela Davis, interests:Anti-discrimination, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 11148 1265 https://www.facebook.com/Blacktivist-128371547505950/ Don‘t Choose the side of the oppressor! There is enough room for you in the fight for black equality and justice. A fight for Civil Rights isn‘t over 9.6 600.00 RUB 2016-10-14T03:20:14-07:00 2016-10-15T03:20:13-07:00
1090 location:United States, interests:Human rights, interests:Justice, interests:Culture, interests:Slavery in the United States, interests:Black is beautiful, interests:Equal opportunity, interests:Anti-discrimination, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 14848 2379 https://www.facebook.com/Blacktivist-128371547505950/ It‘s sad to realize that Facebook can teach you more about your ancestors than your school. Know the truth, because it might set you free. 6.39088 399.43 RUB 2016-10-12T03:56:36-07:00 2016-10-13T03:56:34-07:00
1092 location:United States, interests:Human rights, interests:Malcolm X Memorial Foundation, interests:Malcolm X Grassroots Movement, interests:End Slavery Now, interests:Justice, interests:Culture, interests:Slavery in the United States, interests:African-American culture, interests:African culture, interests:Black is beautiful, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Equal opportunity, interests:Angela Davis, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Black (Color), interests:Nigerians, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 57648 8903 https://www.facebook.com/Blacktivist-128371547505950/ This young woman who resembles an iconic activist, Angela Davis brought back good memories. 19.2 1200.00 RUB 2016-10-14T03:17:23-07:00 2016-10-17T03:17:22-07:00
1682 location:United States, interests:Anti-racism, interests:Anti-discrimination, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://www.change.org/p/baraCk-obama-u-s-house-of-representatives-u-s- The KKK is an American terror group! Join the fight! Sign the petition to give that racist organization the REAL name! Sign the petition today! Click below to learn more Barack Obama, US. Hou... Blackusa 0.0 0.00 USD 2015-11-10T01:32:16-08:00  
2479 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Justice, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2914 261 https://b|ackmattersus.com/17542-and-stilI-i-rise-maya-angelous-documentary- The release date for the classic documentary, ‘And Still | Rise,’ 3 life story of Maya Angelou is slated to be out on October 14. ‘And Still | Rise,’ Maya Angelou’s Documentary To Hit Theatres Soon | BM BM 5.79152 361.97 RUB 2016-10-11T07:00:58-07:00 2016-10-12T07:00:56-07:00
2480 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Justice, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5933 616 https://b|ackmattersus.com/17528-jaiI-videos-reveaI-blaCk-inmate-died-after— Circulating jail videos show, Michael Sabbie begged for breath before dying as he was being manhandled by several police officers in his cell. Jail Videos Reveal Black Inmate Died After Assault By Officers | BM BM 6.20976 388.11 RUB 2016-10-11T06:58:37-07:00 2016-10-12T06:59:21-07:00
2487 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Melanin, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:T- shirt, interests:Black Women Are Beautiful, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 596 29 https://www.bonfirefunds.com/stop-police-brutality Attention, everyone! Whether you are participating in the National Day of Protest or not, you can support our movement and show your solidarity. You have a unique opportunity to purchase a branded t-shirt expressing your struggle against police brutality. Make everyone see what you think! httpszllwww.bonfirefunds.com/stop-police-brutality httpszllwww.bonfirefunds.com/nationaI-day-of-protest-1 Order your limited edition Stop Police Brutality custom shirts before 10/20/2016! All proceeds benefit BlackMattersUS. Stop Police Brutality BM 6.39968 399.98 RUB 2016-10-14T01:52:00-07:00 2016-10-15T01:51:59-07:00
2503 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 13721 1500 https://b|ackmattersus.com/18148-teen-files-Iawsuit-agaihst-d-C-police-for- Black teen sues the police involved in his false arrest, following violent detention after woman felt ‘uneasy’ at ATM. Black teen sues the police involved in his false arrest, following his violent detention after woman felt ‘uneasy’ at ATM. Teen Files Lawsuit Against 00 Police For False Arrest | BM BM 9.6 600.00 RUB 2016-10-18T05:32:04-07:00 2016-10-19T05:32:03-07:00
2504 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4096 441 https://b|ackmattersus.com/17910-widow-of-dante-parker-i-sti|I-havent-seen- Bianca Carlisle Parker is the wife of Dante Parker, an African American man who was killed by police. Dante Parker, 36, a father of five and a popular newspaper pressman died in police custody on August 12, 2014. He was tasered over 25 times by cops who suspecte Widow Of Dante Parker: | Still Haven’t Seen Police Report | BM BM 8.0 500.00 RUB 2016-10-14T01:37:41-07:00 2016-10-17T01:37:40-07:00
2505 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 7664 1018 https://blackmattersus.com/18022-damieon-f|owers-those-boys-had-fear—in- Damieon Flowers’ video of a confrontation between a cop and three Black juveniles went viral on social media. The frequency at which ordinary stops by the police escalate into horrible and sometimes fatal encounters has led to a high level of distrust between Black comm Damieon Flowers: Those Boys Had Fear In Their Eyes 80 | Stepped In | BM BM 6.4 400.00 RUB 2016-10-18T05:33:00-07:00 2016-10-19T05:32:59-07:00
2514 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1045 60 https://www.facebook.com/blackmattersus.mvmnt/ Your voices matter! We are looking for the authors. Your opinions will be published! In our work we have discovered that many Kings and Queens were silenced and had no opportunity to voice their concerns and opinions. But today, we want to give you this opportunity. We want America to know what bothers you as a member of the Black community. We are ready to publish your articles and your opinions. Plus, it‘s a good Chance for you to be a part of our team that is interested in educating African Americans and making real Changes! If you have something to say or you have good writing skills or you care about Black Lives, please DM us and become the part of our team. 3.9792 248.70 RUB 2016-10-18T05:35:40-07:00 2016-10-19T05:35:39-07:00
2516 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5351 497 https://b|ackmattersus.com/18087-bIaCk-hairstyles-bIaCk-girI-sent-out-of- Nine-year-old Aubrey Zvovushe-Ramos was prevented from joining her teammates to play a soccer match because of her Black hairstyle Nine-year- old Aubrey Zvovushe-Ramos was prevented from joining her teammates to play a soccer match because of her Black hairstyle. Black Hairstyles: Black Girl Sent Out Of Soccer Pitch | BM BM 6.4 400.00 RUB 2016-10-18T05:33:29-07:00 2016-10-19T05:33:27-07:00
2520 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Justice, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1120 75 https://b|ackmattersus.com/17618-IetsbuyblaCk-blaCk-americans-encouraged- African-American entrepreneurs, DeShawn Bullard and Rene Green share their experience and Challenges in the Black hair industry. #Let’sBuyBlack: BIaCk-Americans Encouraged To Patronize BIaCk-Owned Businesses | BM BM 4.30192 268.87 RUB 2016-10-11T07:02:23-07:00 2016-10-12T07:02:23-07:00
2521 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://blackmattersus.com/17618-IetsbuyblaCk-blaCk-americans-encouraged- African-American entrepreneurs, DeShawn Bullard and Rene Green share their experience and Challenges in the Black hair industry. #Let’sBuyBlack: BIaCk-Americans Encouraged To Patronize BIaCk-Owned Businesses | BM BM 0.0 0.00 USD 2016-10-18T05:30:39-07:00 2016-10-12T07:02:23-07:00
2528 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Justice, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3418 370 https://b|ackmattersus.com/17461-b|ack-ceIebrities-t-i-raps-against-social- The famous rapper had his take on police brutality and social injustice in marvelous BET performance. Black Celebrities: T.|. Raps Against Social Injustice And Police Brutality In BET Performance | BM BM 6.0968 381.05 RUB 2016-10-11T07:01:40-07:00 2016-10-12T07:01:39-07:00
2529 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://blackmattersus.com/17461-b|ack-ceIebrities-t-i-raps-against-social- The famous rapper had his take on police brutality and social injustice in marvelous BET performance. Black Celebrities: T.|. Raps Against Social Injustice And Police Brutality In BET Performance | BM BM 0.0 0.00 USD 2016-10-18T05:32:40-07:00 2016-10-12T07:01:39-07:00
2533 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5112 305 https://blackmattersus.com/17945-new-fi|m-features-b|ack-celebrities-as- Black celebrities star in a distressing new short film titled “Against The Wall.” New Film Features Black Celebrities As Police Brutality Victims | BM BM 8.0 500.00 RUB 2016-10-14T01:40:10-07:00 2016-10-15T01:40:09-07:00
2538 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2401 159 https://blackmattersus.com/18034-b|aCk-doctor-prevented-from-heIping-dying- Tamika Cross, 3 Black doctor felt humiliated when Delta Airlines flight attendants refuse to believe that she was a qualified physician. Black Doctor Prevented From Helping Dying Man On Board | BM BM 6.4 400.00 RUB 2016-10-18T05:30:53-07:00 2016-10-19T05:30:52-07:00
2540 location_living_in:United States, interests:Human rights, interests:Martin Luther King, interests:Jr., interests:African National Congress, interests:Nelson Mandela, interests:Justice, interests:Muhammad Ali, interests:Violence prevention, interests:Pan Africanist Congress of Azania, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4488 384 https://b|ackmattersus.com/17953-bIack-kids-Chess-trophies-mistaken-for- Two Black kids won trophies in Chess but most people congratulated them on winning a basketball game. Black Kids’ Chess Trophies Mistaken For Basketball Trophies | BM BM 8.0 500.00 RUB 2016-10-14T01:43:21-07:00 2016-10-15T01:43:20-07:00
2545 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 6092 719 https://b|ackmattersus.com/18007-00Iorado-springs-police-handcuff-two—black- Two Black brothers were handcuffed by Colorado Springs police in a traffic stop for ‘driving while Black’. Colorado Springs Police Handcuff Two Black Brothers For No Given Reason | BM BM 6.4 400.00 RUB 2016-10-18T05:36:31-07:00 2016-10-19T05:36:29-07:00
2986 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African— American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 721 101 https://www.facebook.com/WatCh-the-Police-1095374457243609/ The man on the video knows his rights better than cops do. Police state failed in this case. 1.04 65.00 RUB 2016-11-11T06:07:26-08:00 2016-11-12T06:07:26-08:00
2987 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African— American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 416 38 https://www.facebook.com/WatCh-the-Police-1095374457243609/ Incredible battle: cop against his own logic and evidence. Such "officers" make only annoy people! 1.59984 99.99 RUB 2016-11-03T07:59:54-07:00 2016-11-04T07:59:54-07:00
2993 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African- American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Watch-the—Police-1095374457243609/ The man pulled over because cop thought that he "parked weirdly". The cop calls him "tatted up gangster" and claims that he is talking shit. Is it a proper behavior of public servant? 0.0 0.00 USD 2016-11-11T06:06:27-08:00 2016-11-12T06:06:27-08:00
2995 location_living_in:United States, interests:Police Brutality is a Crime, interests:Copwatch, interests:Police misconduct, interests:African- American Civil Rights Movement (1954—68), interests:Black Consciousness Movement, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Anti-discrimination, interests:Cop Block, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Watch-the-Police-1095374457243609/ This 17-year-old girl refused to put away her lollipop and a bag of chips in the New York Metro. Food is prohibited in New York Metro. Cops decided not to take her food away. Look what they did instead of this. After the incident police didn't charge the girl with anything. It means they did it just for their own pleasure. 0.0 0.00 USD 2016-11-03T07:59:05-07:00 2016-11-04T07:59:05-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 1439.174ms · Data source: simonw/russian-ira-facebook-ads-datasette