home / russian-ads

display_ads (view)

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

17 rows where an ad_target was excluded_connections:Exclude people who like Black guns matter

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
3179 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Gun Owners of America, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Firearm, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo 355 33 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense is your priority! 13.12912 820.57 RUB 2016-11-16T01:26:41-08:00  
3180 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Gun Owners of America, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Firearm, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo 0 0 https://www.facebook.com/ProtectBIackGUhOwners/ We are African Americans and we support the 2nd Amendment! Join us, if seIf-defense is your priority! Black Guns Matter 0.0 0.00 USD 2016-12-07T07:19:01-08:00  
3181 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Firearm, people_who_match:interests:Malcolm X, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo 505 30 https://www.facebook.com/ProtectBIackGUhOwners/ We are African Americans and we support the 2nd Amendment! Join us, if seIf-defense is your priority! 16.32608 1020.38 RUB 2016-12-07T07:19:36-08:00  
3182 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African-American culture or African-American history Interests: 2nd Amendment Interests: African-American culture, and_must_also_match:interests:African-American Civil Rights Movement (1954—68), and_must_also_match:interests:African-American history 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We are African Americans and we support the 2nd Amendment! Join us, if seIf-defense is your priority! 0.0 0.00 USD 2016-12-08T05:30:05-08:00  
3183 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African-American culture, and_must_also_match:interests:African-American history Interests: 2nd Amendment 309 27 https://www.facebook.com/ProtectBIackGunOwners/ We are African Americans and we support the 2nd Amendment! Join us, if seIf-defense is your priority! 9.479840000000001 592.49 RUB 2016-12-08T05:30:34-08:00  
3184 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African-American culture, and_must_also_match:interests:African-American history Interests: 2nd Amendment 11 3 https://www.facebook.com/ProtectBIackGunOwners/ We support the 2nd Amendment! Join us, if seIf-defense is your top priority! 0.87648 54.78 RUB 2016-12-09T01:40:40-08:00  
3185 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African-American culture, and_must_also_match:interests:African-American history, and_must_also_match:interests:Huey P. Newton Interests: 2nd Amendment 9202 933 https://www.facebook.com/ProtectBIackGunOwners/ We support the 2nd Amendment! Join us, if seIf-defense is your top priority! Black Guns Matter 100.83760000000001 6302.35 RUB 2016-12-09T07:00:35-08:00  
3186 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Firearm, people_who_match:interests:Malcolm X 396 32 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 16.81232 1050.77 RUB 2016-11-14T04:10:27-08:00  
3187 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:2nd Amendment, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 0.0 0.00 USD 2016-11-16T01:08:41-08:00  
3188 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 0.0 0.00 USD 2016-11-16T01:15:28-08:00  
3189 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense if a priority for you. 0.0 0.00 USD 2016-11-16T01:21:46-08:00  
3190 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, 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:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense if a priority for you. 0.0 0.00 USD 2016-11-16T01:22:34-08:00  
3191 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, 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:Malcolm X 175 15 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense is your priority! 8.425120000000001 526.57 RUB 2016-11-16T01:26:33-08:00  
3272 location_living_in:United Kingdom, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African—American Civil Rights Movement (1954—68), and_must_also_match:interests:Huey P. Newton, and_must_also_match:interests:Malcolm X Interests: 2nd Amendment 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We support the 2nd Ammendment! Join us, if seIf-defense is your priority! Black Guns Matter 0.0 0.00 USD 2016-12-26T06:39:01-08:00  
3273 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African—American Civil Rights Movement (1954—68), and_must_also_match:interests:Huey P. Newton, and_must_also_match:interests:Malcolm X Interests: 2nd Amendment 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We support the 2nd Ammendment! Join us, if seIf-defense is your priority! Black Guns Matter 0.0 0.00 USD 2016-12-26T06:39:43-08:00  
3274 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African—American Civil Rights Movement (1954—68), and_must_also_match:interests:Huey P. Newton, and_must_also_match:interests:Malcolm X Interests: 2nd Amendment 15609 1456 https://www.facebook.com/ProtectBIackGunOwners/ We support the 2nd Amendment! Join us, if seIf-defense is your priority! Black Guns Matter 140.18336 8761.46 RUB 2016-12-26T06:40:25-08:00  
3278 location:United States, excluded_connections:Exclude people who like Black guns matter, age:18 - 65+, 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:2nd Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, and_must_also_match:interests:African-American Civil Rights Movement (1954—68), and_must_also_match:interests:Huey P. Newton, and_must_also_match:interests:Malcolm X 11028 1205 https://www.facebook.com/ProtectBIackGunOwners/ We support the 2nd Amendment! Join us, if seIf-defense is your priority! Black Guns Matter 84.4056 5275.35 RUB 2017-02-03T01:40:54-08: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 3793.191ms · Data source: simonw/russian-ira-facebook-ads-datasette