home / russian-ads

display_ads (view)

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

27 rows where an ad_target was people_who_match:interests:Guns & Ammo

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
2898 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:AR-15, people_who_match:interests:2nd Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Protect the Second Amendment, and_must_also_match:interests:Preserve our right to keep and bear arms or Gun Rights, and_must_also_match:interests:, politics:US politics (conservative) 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:28:05-07:00  
2899 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:AR-15, people_who_match:interests:2nd Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Protect the Second Amendment, and_must_also_match:interests:Preserve our right to keep and bear arms or Gun Rights, and_must_also_match:interests:, politics:US politics (conservative) 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:28:30-07:00  
2907 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:National Association for Gun Rights, people_who_match:interests:Guns & Ammo 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:38:10-07:00  
2908 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns & Weapons 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:38:37-07:00  
2909 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Gun Rights 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:38:56-07:00  
2923 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:AR-15, people_who_match:interests:2nd Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:The Second Amendment or Gun Rights, and_must_also_match:interests:, politics:US politics (conservative) 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:28:05-07:00  
2924 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:AR-15, people_who_match:interests:2nd Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:The Second Amendment or Gun Rights, and_must_also_match:interests:, politics:US politics (conservative) 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:28:30-07:00  
2932 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:National Association for Gun Rights, people_who_match:interests:Guns & Ammo 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:38:10-07:00  
2933 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:38:37-07:00  
2934 location_living_in:United States, exclude_location:united_states:California; Illinois, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, gender:Male, 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:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Gun Rights 0 0 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2017-04-19T07:38:56-07:00  
2945 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, 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:The Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Guns & Patriots, people_who_match:interests:Second Amendment Sisters, people_who_match:interests:Gun Rights, people_who_match:interests:American Guns, people_who_match:interests:Guns & Ammo, people_who_match:interests:Second Amendment Supporters, people_who_match:interests:Gunsoom, and_must_also_match:interests:Right to keep and bear arms 42 1 https://www.facebook.com/savethe2a/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 0.20832 13.02 RUB 2017-02-07T23:28:35-08:00  
2947 location_living_in:United States, age:18 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Students for Concealed Carry 0 0 https://www.facebook.com/savetheZa/ Masterpiece! 0.0 0.00 USD 2017-02-10T06:56:03-08:00 2017-02-13T06:56:40-08:00
2948 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Students for Concealed Carry 0 0 https://www.facebook.com/savetheZa/ Masterpiece! 0.0 0.00 USD 2017-02-10T06:56:40-08:00 2017-02-13T06:56:40-08:00
2949 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Students for Concealed Carry 39158 4043 https://www.facebook.com/savetheZa/ Masterpiece! 14.4 900.00 RUB 2017-02-10T06:56:40-08:00 2017-02-13T06:56:40-08:00
2955 location:United States, excluded_connections:Exclude people who like Defend the 2nd, 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:Right to keep and bear arms, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Second Amendment Sisters, 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, and_must_also_match:interests:Second Amendment Sisters, and_must_also_match:interests:Second Amendment Supporters 0 0 https://www.facebook.com/Defend-the-2nd-692068924291672/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 0.0 0.00 USD 2016-10-21T08:17:43-07:00  
2958 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, 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:The Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Guns & Patriots, people_who_match:interests:Second Amendment Sisters, people_who_match:interests:Gun Rights, people_who_match:interests:American Guns, people_who_match:interests:Guns & Ammo, people_who_match:interests:Second Amendment Supporters, people_who_match:interests:Gunsoom, and_must_also_match:interests:Right to keep and bear arms 25520 2614 https://www.facebook.com/savetheZa/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 149.62207999999998 9351.38 RUB 2017-02-02T00:08:46-08:00  
2959 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, 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:The Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Guns & Patriots, people_who_match:interests:Second Amendment Sisters, people_who_match:interests:Gun Rights, people_who_match:interests:American Guns, people_who_match:interests:Guns & Ammo, people_who_match:interests:Second Amendment Supporters, people_who_match:interests:Gunsoom, and_must_also_match:interests:Right to keep and bear arms 24705 1734 https://www.facebook.com/savethe2a/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 104.22944000000001 6514.34 RUB 2017-02-13T04:42:23-08:00  
2964 no image location_living_in:united_states:Gainesville (+25 mi) Florida, age:18 — 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Students for Concealed Carry 1149 55 https://www.facebook.com/Defend-the-2nd-692068924291672/ FREE shooting practice for our subscribers! (Hurry, only 8 packages left!) Dear subscribers, we offer you to gather together and visit shooting range in Gainesville, FL. Oh we are making an event for our subscribers. Join the event and share it with your friends. First 8 people who will message us will get a FREE 9mm Shooting Package (includes the day pass, a rental handgun, 100 rounds 9mm, 1 target, eye/ear protection if neededi. If iou want to get it, just message us Shooting practice at 16.0 1000.00 RUB 2017-02-17T07:48:04-08:00 2017-02-20T07:48:04-08:00
2968 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, 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:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:SeIf-defense, people_who_match:interests:Second Amendment Sisters, 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:Gun Rights, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Gun Rights Across America, and_must_also_match:interests:2nd Amendment 0 0 https://www.facebook.com/savetheZa/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 0.0 0.00 USD 2017-01-17T23:22:49-08:00  
2969 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, 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:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Second Amendment Sisters, 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:Gun Rights, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Gun Rights Across America, and_must_also_match:interests:2nd Amendment 43451 3721 https://www.facebook.com/savethe2a/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 203.64496 12727.81 RUB 2017-01-19T03:05:56-08:00  
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  
3192 location:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., 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, people_who_match:interests:Black (Color), people_who_match:interests:Guns & Ammo 1488 175 https://www.facebook.com/ProtectBIackGunOwners/ It's all about self preservation and protection people. Exercise those rights, they are there for you! 4.8 300.00 RUB 2016-12-23T00:03:01-08:00 2016-12-24T00:03:01-08:00
3193 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., 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, people_who_match:interests:Black (Color), people_who_match:interests:Guns & Ammo 1584 207 https://www.facebook.com/ProtectBIackGunOwners/ 10.5 300 BLK 3.2 200.00 RUB 2016-12-23T00:04:12-08:00 2016-12-24T00:04:12-08:00
3194 location:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., 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, people_who_match:interests:Black (Color), people_who_match:interests:Guns & Ammo 22519 2 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 22.433439999999997 1402.09 RUB 2016-11-11T07:00:17-08:00  
3195 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., 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, people_who_match:interests:Black (Color), people_who_match:interests:Guns & Ammo 512 68 https://www.facebook.com/ProtectBIackGunOwners/ G360 guns with standard hybrid carry handle from a G36. 3.2 200.00 RUB 2016-12-23T00:03:20-08:00 2016-12-26T00:03:20-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 1552.543ms · Data source: simonw/russian-ira-facebook-ads-datasette