home / russian-ads

display_ads (view)

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

3 rows where an ad_target was interests:Melanin

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
799 location:United States, interests:Martin Luther King, interests:Melanin, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), interests:HuffPost Black Voices, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 13263 1100 https://www.facebook.com/WilIiamsKalvin-788980617892144/ I pity anyone who has to deal with neighbors in an apartment building. Especially when you have to deal with the complaining and passive- aggressive types. Oh, and let’s not forget gentrifiers. Or, as I like to call them, “white migrators.” Apparently, instead of knocking on a neighbor’s door, people take the easy and passive-aggressive way out and just leave notes instead. But one man wasn’t having it. Link: https://scontent-arn2-1 .xx.fbcdn.net/v/t1 .0-9/14572967_1772905896322 988_913778538274424647_n.jpg?oh=9a4945f2582b54297fe1f8f786f297be& oe=5862D508 Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 19.2 1200.00 RUB 2016-10-14T02:45:50-07:00 2016-10-15T02:45:48-07:00
2487 location_living_in:United States, interests:Human rights, interests:Martin Luther King, 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: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

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/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
Powered by Datasette · Query took 1289.38ms · Data source: simonw/russian-ira-facebook-ads-datasette