home / russian-ads

display_ads (view)

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

30 rows where an ad_target was people_who_match:interests:Gun Rights

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
2900 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:The Second Amendment, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Protecting Your Gun Rights, people_who_match:interests:God, people_who_match:interests:Guns, people_who_match:interests:& American Freedom, people_who_match:interests:Preserve our right to keep and bear arms, people_who_match:interests:Gun Rights, people_who_match:interests:Guns & Weapons or Second Amendment Supporters, people_who_match:interests:Politics: US politics (conservative), and_must_also_match:interests:Right to keep and bear arms, and_must_also_match:interests:AR-15, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:Gun Owners of America, and_must_also_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:31:12-07:00  
2901 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:The Second Amendment, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Protecting Your Gun Rights, people_who_match:interests:God, people_who_match:interests:Guns, people_who_match:interests:& American Freedom, people_who_match:interests:Preserve our right to keep and bear arms, people_who_match:interests:Gun Rights, people_who_match:interests:Guns & Weapons or Second Amendment Supporters, people_who_match:interests:Politics: US politics (conservative), and_must_also_match:interests:AR-15, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:Gun Owners of America, and_must_also_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:32:00-07:00  
2902 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:The Second Amendment, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Protecting Your Gun Rights, people_who_match:interests:God, people_who_match:interests:Guns, people_who_match:interests:& American Freedom, people_who_match:interests:Preserve our right to keep and bear arms, people_who_match:interests:Gun Rights, people_who_match:interests:Guns & Weapons or Second Amendment Supporters, people_who_match:interests:Politics: US politics (conservative), and_must_also_match:interests:AR-15, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association, and_must_also_match:interests:Gun Owners of America 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:33:25-07:00  
2903 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:The Second Amendment, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Anything About Guns, people_who_match:interests:Protecting Your Gun Rights, people_who_match:interests:God, people_who_match:interests:Guns, people_who_match:interests:& American Freedom, people_who_match:interests:Preserve our right to keep and bear arms, people_who_match:interests:Gun Rights, people_who_match:interests:Guns & Weapons or Second Amendment Supporters, people_who_match:interests:Politics: US politics (conservative), and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association 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:35:22-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  
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  
2965 location_living_in: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: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 or Gun Rights Across America, people_who_match:interests:Employers: Gun Owners of America, and_must_also_match:interests:2nd Amendment 301608 24955 https://www.facebook.com/Defend-the-2nd-692068924291672/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 772.8888000000001 48305.55 RUB 2016-10-21T07:51:03-07: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  
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  
3264 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 248 40 https://www.facebook.com/ProtectBIackGunOwners/ FNX45 and HK45 1.8568 116.05 RUB 2016-12-27T23:25:41-08:00 2016-12-28T23:25:41-08:00
3265 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 3220 522 https://www.facebook.com/ProtectBIaCkGunOwners/ My wife doing some dry fire training. Let's give a SALUTE ??to all the Sista's that shoot! 4.8 300.00 RUB 2017-02-03T01:32:43-08:00 2017-02-04T01:32:43-08:00
3266 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 3478 596 https://www.facebook.com/ProtectBIackGunOwners/ Truer words were never spoken. The importance of understanding the 2nd amendment and exercising that right can't be overstated. Let's do what's right and educate ourselves. 6.4 400.00 RUB 2017-02-03T01:33:12-08:00 2017-02-04T01:33:12-08:00
3267 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 1406 219 https://www.facebook.com/ProtectBIaCkGunOwners/ When 30 or 40 round mags no longer do and a 75 round drum is the only way. Repost from — 3.2 200.00 RUB 2017-02-01T05:25:30-08:00 2017-02-02T05:25:30-08:00
3268 location_living_in:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 1059 138 https://www.facebook.com/ProtectBIackGunOwners/ Never forget people, you have got the right to bear arms for your own protection. Educate yourselves on your 2nd amendment, don't sleep on it! 3.2 200.00 RUB 2016-12-29T02:52:55-08:00 2016-12-30T02:52:55-08:00
3269 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 602 81 https://www.facebook.com/ProtectBIackGunOwners/ Crye Precision Six-12 12 ga shotgun with Silencerco Salvo 12 Suppressor 3.2 200.00 RUB 2016-12-29T02:53:12-08:00 2016-12-30T02:53:12-08:00
3270 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 881 109 https://www.facebook.com/ProtectBIackGunOwners/ A crackin' piece of PDW 1.88944 118.09 RUB 2016-12-27T23:32:51-08:00 2016-12-28T23:32:51-08:00
3271 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 831 147 https://www.facebook.com/ProtectBIackGunOwners/ The day time cool but the nights evil ? Repeat from — 3.2 200.00 RUB 2017-02-01T05:25:15-08:00 2017-02-02T05:25:15-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  
3275 location_living_in:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 447 79 https://www.facebook.com/ProtectBIackGunOwners/ The holidays are here people! It's also a great time for you and yours to get to the range for some practice. 2.0648000000000004 129.05 RUB 2016-12-27T23:34:35-08:00 2016-12-28T23:34:35-08:00
3276 location_living_in:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 900 113 https://www.facebook.com/ProtectBIackGunOwners/ Actor and comedian Ricky Harris died of a heart attack on Monday, his manager, Cindy Ambers, confirmed in an emailed statement. A cause of death has yet to be released. Harris was well-known for his role as Malvo in the Chris Rock series “Everybody Hates Chris," as well as for his two-year stint on ”Moesha.” He most recently appeared on FX’s “The People v. OJ. Simpson: American Crime Story.” On the big screen, Harris scored a part in 1993’s “Poetic Justice” with Janet Jackson and Tupac Shakur, starred alongside Robert De Niro in 1995’s “Heat,” and recently appeared in 2015’s “Dope.” Harris also collaborated with his Childhood friend Snoop Dogg and rappers Ice Cube and Dr. Dre on some of their albums. May his beautiful soul R.I.P! 4.8 300.00 RUB 2016-12-29T02:52:37-08:00 2016-12-30T02:52:37-08:00
3277 location_living_in:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 645 111 https://www.facebook.com/ProtectBIackGunOwners/ You feel safe with a gun and even safer when your lady's woke on the 2nd. Protect yourselves! 3.2 200.00 RUB 2017-02-01T05:26:35-08:00 2017-02-02T05:26:35-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  
3279 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:2nd Amendment, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Gun Rights, people_who_match:interests:Huey P. Newton, people_who_match:interests:Malcolm X 1300 237 https://www.facebook.com/ProtectBIackGunOwners/ Repost from — 3.2 200.00 RUB 2017-02-01T05:27:29-08:00 2017-02-02T05:27:29-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 1283.453ms · Data source: simonw/russian-ira-facebook-ads-datasette