home / russian-ads

display_ads (view)

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

3 rows where an ad_target was location:united_states:Cleveland (+34 mi) Ohio

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1105 location:united_states:Cleveland (+34 mi) Ohio, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1094784283992152/ On October 15, 1966, Bobby Seale and Huey P. Newton have founded BPP. Their idea was simple - we can't just talk to make the Change, we must take action. They started to monitor the behavior of police officers and Challenge police brutality in Oakland, California. And they succeeded. Unfortunately, the government and especially Federal Bureau of Investigation called the party "the greatest threat to the internal security of the country". They tried to Close it, to incarcerate BPP's participants, and in 1982 the original party was dissolved. 50 years have passed since BBP's foundation, but the situation in the country stills the same. Cops are shooting Blacks. lt spreads through all the country like the disease. Nowadays we need Black Panthers as never before. We need a strong hand that can protect us, that can keep our people safe, that can make Black Lives really matter. Let's get together and celebrate the 50th anniversary of the party that has made the Change. Let's honor its founders and participants. Let's share their ideas and ideals! Black Panther Party 50th Anniversary 0.0 0.00 USD 2016-09-29T07:07:13-07:00 2016-10-14T15:00:00-07:00
1174 location:united_states:Cleveland (+34 mi) Ohio, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 5785 202 https://www.facebook.com/events/1607406689552066/ WHY are we holding the Black Unity March? The black community is facing a number of seriou Black Unity March 121.75072 7609.42 RUB 2016-08-23T04:35:12-07:00 2016-09-17T02:00:09-07:00
1175 location:united_states:Cleveland (+34 mi) Ohio, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power 3188 224 https://www.facebook.com/events/1607406689552066/ WHY are we holding the Black Unity March? The black community is facing a number of seriou Black Unity March 38.24928 2390.58 RUB 2016-09-15T06:27:18-07:00 2016-09-17T02:00:09-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 1234.254ms · Data source: simonw/russian-ira-facebook-ads-datasette