home / russian-ads

display_ads (view)

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

3 rows where an ad_target was placements:Suggested Video on desktop computers

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
935 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Suggested Video on desktop computers, placements:News Feed on mobile devices, placements:Suggested Video on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Syria-News, people_who_match:interests:Black (Color), people_who_match:interests:Refugees of the Syrian Civil War, people_who_match:interests:Syria Charity 52688 5519 https://www.facebook.com/blacktivists/ Police brutality in America gone crazy. But America is too busy bombing countries in the Middle East. 12.624319999999999 789.02 RUB 2017-05-24T08:24:35-07:00 2017-05-29T08:00:00-07:00
2821 location_living_in:United States, age:18 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Suggested Video on desktop computers, placements:News Feed on mobile devices, placements:Suggested Video on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Pan-Africanism, people_who_match:interests:Kemetism, people_who_match:interests:Afrocentrism, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Syria-News, people_who_match:interests:Malcolm X, people_who_match:interests:Refugees of the Syrian Civil War, people_who_match:interests:Syria Charity 24977 3182 https://www.facebook.com/PanAfrootsmove/ “You got money for war but can’t feed the poor” 10.861120000000001 678.82 RUB 2017-05-26T07:56:47-07:00 2017-05-29T08:00:00-07:00
3037 location_living_in:United States, age:18 - 65+, placements:on pages: News Feed on desktop computers, placements:Suggested Video on desktop computers, placements:News Feed on mobile devices, placements:Suggested Video on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Stop Racism”, people_who_match:interests:African- American culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African- American history, people_who_match:interests:Say To No Racism, people_who_match:interests:Malcolm X 60 5 https://www.facebook.com/Williamsathalvin/ Explosion in Manchester, ISIS attack in Marawi, bomb attack in Bangkok, car bombing in Syria — all happened in one day. This is heartbreaking and we are praying for everyone. Don’t you think that it is vicious cycle? Now they will bomb more in Syria to stop terrorists. And then another bombing here and there. But these attacks can’t bring Peace. Stop wasting money on weapons. America, you better stay away from this and start taking care of your own people. Within your own country. 1.77056 110.66 RUB 2017-05-25T04:56:56-07:00 2017-05-28T07:52:35-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 2133.761ms · Data source: simonw/russian-ira-facebook-ads-datasette