home / russian-ads

display_ads (view)

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

3 rows where an ad_target was age:16 - 60

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1261 location_living_in:united_states:New York, excluded_connections:Exclude people who like United Muslims of America, age:16 - 60, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Civil and political rights, people_who_match:interests:Human rights, people_who_match:interests:Anarchism, people_who_match:interests:Nonviolence, people_who_match:interests:Stop the War Coalition, people_who_match:interests:Anti-fascism, people_who_match:interests:Pacifism, people_who_match:interests:Peace movement, people_who_match:interests:The Anarchy, people_who_match:interests:World peace, people_who_match:interests:Anti-war movement, people_who_match:interests:Feminism, people_who_match:interests:PeaonnEarth, people_who_match:interests:Be a Peacekeeper - The World Peacekeepers Movement, and_must_also_match:politics:Likely to engage with political content (liberal) 5456 256 https://www.facebook.com/events/239129926564203/ If you don't want refugees, stop creating them! Hands off Syria! Please, come out to support us on June 3rd in front of Trump Tower in New York. We must stop this madness! Some believed Trump would withdraw the US. from useless and bloody military campaigns. But what we see is only the enhancement of hostility. We don't need wars no more! We want peace! It's time for politicians to take care of the US. residents instead of fating them, as well as other nationals, to death. We're organizing a peaceful gathering to draw public attention to the above- mentioned terrible problem. Our President and Congress must listen to those who granted them power - us, the people. If you also think that there should only be peace, come with us and let's make it happen. Stop war! Stop killing the innocent! Make peace, not war! Make peace, not war! 33.68304 2105.19 RUB 2017-05-26T02:05:30-07:00  
1885 no image location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Georgia, location:united_states:Illinois, location:united_states:Iowa, location:united_states:Louisiana, location:united_states:Minnesota, location:united_states:Mississippi, location:united_states:Nebraska, location:united_states:Wisconsin, age:16 - 60, placements:Instagram Feed, people_who_match:interests:U.S. Patriot Tactical, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:The Patriot Post, people_who_match:interests:Confederate States of America, people_who_match:interests:American Patriots, people_who_match:interests:Thank A Soldier, people_who_match:interests:Flag of the United States, people_who_match:interests:Guns & Patriots, people_who_match:interests:American Patriot, people_who_match:interests:Proud to be an American, people_who_match:interests:American patriotism, people_who_match:interests:Chris Kyle 13211 10 https://www.facebook.com/Lalalo-1028159433939877/ INSTagram Of The United States or simply - INSTOTUS. Unique Instagram page for American patriots only! FOLLOW! JUST DO IT! 36.44064 2277.54 RUB 2016-05-20T04:36:31-07:00  
1945 no image location:united_states:Florida, location:united_states:Georgia, location:united_states:New York, age:16 - 60, placements:Instagram Feed, people_who_match:interests:Martin Luther King, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Malcolm, x_field_of_study:African-American history 5609 2 https://www.facebook.com/Proudblacks-954167134618867/ Follow BlackAmericaToday! Stay woke! 10.145280000000001 634.08 RUB 2016-05-17T04:18: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 1269.983ms · Data source: simonw/russian-ira-facebook-ads-datasette