home / russian-ads

display_ads (view)

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

44 rows where an ad_target was people_who_match:interests:National Rifle Association

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
475 location_living_in:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who like Being Patriotic, 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:Young Republicans, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America or Donald Trump for President, people_who_match:interests:Employers: NYPD, people_who_match:interests:US., army_reserve_industry:Military (Global) or Veterans (US), army_reserve_industry:Politics: US politics (conservative), army_reserve_industry:US politics (very conservative) 4171 551 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 31.9904 1999.40 RUB 2016-11-10T05:00:07-08:00 2016-11-11T21:00:00-08:00
679 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association 0 0 https://www.facebook.com/Secured.Borders/ America is at risk. To protect our country we need to secure the border. 0.0 0.00 USD 2016-10-17T07:07:28-07:00  
686 location:united_states:Alabama, location:united_states:Georgia, location:united_states:New Mexico, people_who_match:interests:Same-sex marriage, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump for President 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-10-11T09:11:47-07:00  
687 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-10-17T06:28:17-07:00  
691 location:united_states:Alabama, location:united_states:Georgia, location:united_states:New Mexico, people_who_match:interests:Same-sex marriage, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump for President 2502 258 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 48.40832 3025.52 RUB 2016-10-11T09:11:47-07:00  
692 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 0.0 0.00 USD 2016-10-17T06:28:17-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  
2910 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 or From my cold, people_who_match:interests:dead hands, 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:39:27-07:00  
2911 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 or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Preserve our right to keep and bear arms, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns & Weapons, and_must_also_match:interests:Citizens Committee for the Right to Keep and Bear Arms (CCRKBA), and_must_also_match:interests:Guns.com 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:40:12-07:00  
2912 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 or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Preserve our right to keep and bear arms, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns & Weapons, and_must_also_match:interests:Open Carry Texas, and_must_also_match:interests:Citizens Committee for the Right to Keep and Bear Arms (CCRKBA), and_must_also_match:interests:Gun Rights Across America, and_must_also_match:interests:Guns.com 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:41:29-07:00  
2914 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:National Rifle Association, people_who_match:interests:Gun Owners of America, people_who_match:interests:National Association for Gun Rights, and_must_also_match:interests:Protect the Second Amendment, 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, and_must_also_match:interests:Guns.com 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:47:54-07:00  
2915 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:National Association for Gun Rights, and_must_also_match:interests:Protect the Second Amendment, 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, and_must_also_match:interests:Guns.com 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:48:16-07:00  
2916 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:National Association for Gun Rights or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:Protect the Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns & Weapons, and_must_also_match:interests:Guns.com 26869 1364 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 134.68048000000002 8417.53 RUB 2017-04-19T07:49:28-07:00  
2917 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 or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Gun Rights Across America, and_must_also_match:interests:Guns.com 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:42:05-07:00  
2919 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:National Rifle Association, people_who_match:interests:Gun Owners of America, people_who_match:interests:National Association for Gun Rights, 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.com 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:47:54-07:00  
2920 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:National Association for Gun Rights, 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.com 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:48:16-07:00  
2921 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:National Association for Gun Rights or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns.com 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:49:28-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  
2935 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 or From my cold, people_who_match:interests:dead hands, 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:39:27-07:00  
2936 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 or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:The Second Amendment, 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.com 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:40:12-07:00  
2937 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 or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Gun Rights Across America, and_must_also_match:interests:Guns.com 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:41:29-07:00  
2939 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:National Rifle Association, people_who_match:interests:Gun Owners of America, people_who_match:interests:National Association for Gun Rights, 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.com 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:47:54-07:00  
2940 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:National Association for Gun Rights, 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.com 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:48:16-07:00  
2941 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:National Association for Gun Rights or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns.com 30264 1577 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 146.41152 9150.72 RUB 2017-04-19T07:49:28-07:00  
2950 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 or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Preserve our right to keep and bear arms, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns & Weapons, and_must_also_match:interests:Open Carry Texas, and_must_also_match:interests:Citizens Committee for the Right to Keep and Bear Arms (CCRKBA), and_must_also_match:interests:Gun Rights Across America, and_must_also_match:interests:Guns.com 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:42:05-07:00  
2952 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:National Rifle Association, people_who_match:interests:Gun Owners of America, people_who_match:interests:National Association for Gun Rights, and_must_also_match:interests:Protect the Second Amendment, 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, and_must_also_match:interests:Guns.com 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:47:54-07:00  
2953 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:National Association for Gun Rights, and_must_also_match:interests:Protect the Second Amendment, 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, and_must_also_match:interests:Guns.com 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:48:16-07:00  
2954 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:National Association for Gun Rights or From my cold, people_who_match:interests:dead hands, and_must_also_match:interests:Protect the Second Amendment, and_must_also_match:interests:Anything About Guns, and_must_also_match:interests:Open carry in the United States, and_must_also_match:interests:Guns & Patriots, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:Guns & Weapons, and_must_also_match:interests:Guns.com 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:49:28-07: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  
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  
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  
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  
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  

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 2982.048ms · Data source: simonw/russian-ira-facebook-ads-datasette