home / russian-ads

display_ads (view)

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

9 rows where an ad_target was interests:Black (Color) and an ad_target was interests:African National Congress

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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
2488 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: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 8302 857 https://blackmattersus.com/17932-taraji-p-henson-Ioses-movie-role-to—white- “I couldn’t get served at that restaurant,” Taraji P. Henson said. Taraji P. Henson Loses Movie Role To White Actress | BM BM 8.0 500.00 RUB 2016-10-14T01:45:48-07:00 2016-10-15T01:45:47-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
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
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
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
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

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