home / russian-ads

display_ads (view)

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

2 rows where an ad_target was location:united_states:Atlanta (+50 mi) Georgia

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1106 location:united_states:Atlanta (+50 mi) Georgia, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 22839 1943 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 64.0 4000.00 RUB 2016-09-29T07:13:03-07:00 2016-10-14T15:00:00-07:00
1126 location:united_states:Atlanta (+50 mi) Georgia, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 0 0 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 0.0 0.00 USD 2016-10-05T04:46:16-07:00 2016-10-14T16:00: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 1383.032ms · Data source: simonw/russian-ira-facebook-ads-datasette