home / russian-ads

display_ads (view)

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

4 rows where an ad_target was interests:Pan—Africanism

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1087 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:African—American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 12055 1781 https://www.facebook.com/Blacktivist-128371547505950/ Positive young black men serving this country will not be on any news outlet. That‘s why we decided to post it here. 6.4 400.00 RUB 2016-10-18T06:57:44-07:00 2016-10-19T06:57:43-07:00
1095 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:Police misconduct, interests:African— American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 17618 2094 https://www.facebook.com/Blacktivist-128371547505950/ Never back down, my friends. Black America is so tired of explaining and debating. 6.4 400.00 RUB 2016-11-01T06:24:00-07:00 2016-11-02T06:23:59-07:00
1136 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:African—American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 9746 1415 https://www.facebook.com/Blacktivist-128371547505950/ Share this and make it go viral. Media won‘t share this because positive Black male images it‘s not okay to display in America. 6.4 400.00 RUB 2016-10-18T06:58:45-07:00 2016-10-19T06:58:44-07:00
1140 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:African—American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 11817 2744 https://www.facebook.com/BIacktivist-128371547505950/ A black man employed by Comcast being given a ticket for doing his job. This man was working on a house when a bystander reported him to the cops. When police showed up, they drew the gun and told the man to put his hands up because he was accused of walking around the property, looking through windows and searching for a way to steal from home. Despite the fact that the man wore a red Comcast shirt and was standing next to his white Comcast truck searching for some wiring to do his job, the police gave him a ticket for literally doing hisjob. Welcome to the United States of Racism. 6.4 400.00 RUB 2016-10-18T06:44:30-07:00 2016-10-19T06:44:29-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 1262.222ms · Data source: simonw/russian-ira-facebook-ads-datasette