home / russian-ads

display_ads (view)

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

1 row where an ad_target was people_who_match:interests:California African American Museum

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1688 location:united_states:New York, age:18 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:Leadership development, people_who_match:interests:California African American Museum, people_who_match:interests:The African History Network, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Rosa Parks, people_who_match:interests:Sister 2 Sister magazine, people_who_match:interests:The Autobiography of Malcolm X, people_who_match:interests:World Day of Social Justice, people_who_match:interests:Leadership, people_who_match:interests:Black Arts Movement, people_who_match:interests:Fight the Power, people_who_match:interests:Black history, people_who_match:interests:Jesse Jackson, people_who_match:interests:BlackNews.com, people_who_match:interests:Racial equality, people_who_match:interests:African-American literature, people_who_match:interests:Afrocentrism, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Racial integration, people_who_match:interests:Phaedra Parks, people_who_match:interests:Black History Month, people_who_match:interests:Sister 2 Sister, people_who_match:interests:African-American history, people_who_match:interests:Black is beautiful, people_who_match:interests:The Honorable Minister Louis Farrakhan, people_who_match:interests:madeas family reunion, people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz), people_who_match:interests:Slavery by Another Name, people_who_match:interests:African American Museum in Philadelphia, people_who_match:interests:Afrocentric education, people_who_match:interests:Bias, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, people_who_match:interests:Social Justice Solutions 26919 646 https://b|ackmattersus.com/10683-hever-forget-never- Yesterday and the day before yesterday and many days before that, we had to witness horrible crimes committed by the police against Black men. The killing of AI Never Forget Never July 16th, 1 pm. Washington Square Park, NYC Blackluive 41.80944 2613.09 RUB 2016-07-14T06:01:49-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 1360.084ms · Data source: simonw/russian-ira-facebook-ads-datasette