home / russian-ads

display_ads (view)

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

5 rows where an ad_target was people_who_match:interests:Understanding racial segregation in the united states

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
5 no image location_living_in:united_states:Georgia, age:18 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:American Black Film Festival, people_who_match:interests:Cop Block or HuffPost Black Voices, people_who_match:interests:, behaviors:African American (US), behaviors:Field of study: African-American history, behaviors:, politics:Likely to engage with political content (liberal) 29786 201 https://www.facebook.com/GovSpending-1651761351759857/ WHERE is your VOICE? 59.4264 3714.15 RUB 2016-06-15T03:39:52-07:00  
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  
1694 no image location:united_states:Detroit (+40 km) Michigan, age:13 - 55, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states, people_who_match:interests:Behaviors: African American (US) 7603 6 https://www.facebook.com/Blackluive-1725227467722991/ Detroit! A peaceful rally is planned in front of the Coleman A. Young Municipal Center on May 21 to honor the memory of Aiyana Mo'Nay Stanley-Jones, a 7-year-old little girl killed by the #Detroit police in her home on the night of May 16, 2010, and other victims of police violence and demand demilitarization of police. We need your help and support! Join us! #JusticeForAiyana 25.357599999999998 1584.85 RUB 2016-05-17T02:55:35-07:00  
1696 location:United States, age:13 - 65+, placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Understanding racial segregation in the united states 421 2 https://www.facebook.com/Blackluive-1725227467722991/ Racism is not “Heritage and Honor”.lt’s time to stand up for what’s right. 1.2815999999999999 80.10 RUB 2016-03-17T09:07:59-07:00 2016-03-26T16:39:00-07:00
1697 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Understanding racial segregation in the united states 12518 0 https://www.facebook.com/Blackluive-1725227467722991/ Racism is not “Heritage and Honor”.lt’s time to stand up for what’s right. 49.55536 3097.21 RUB 2016-03-23T07:43:04-07:00 2016-03-26T16:39:00-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 1648.426ms · Data source: simonw/russian-ira-facebook-ads-datasette