home / russian-ads

display_ads (view)

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

102 rows where search matches "guns" sorted by clicks

id img targeting impressions clicks ▼ url text spend_usd spend_amount spend_currency created ended
728 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
730 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
732 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
734 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
736 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
738 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
740 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
742 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
744 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
746 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
748 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
758 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede Texas - homeland of guns, BBQ and ur heart! 0.0 0.00 USD 2015-09-22T07:44:15-07:00  
847 location:United States, interests:BIackNews.com, interests:HuffPost Politics, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Why don‘t american cops realize that being black is not a crime? African american kids are being shot only for playing with toy guns... How is it possible? Where is the justice? Our Government is blind, they simply don‘t want to pay attention to this legalized homicide of own people... This is crazy! We must speak about it! 0.0 0.00 USD 2016-01-05T02:03:13-08:00 2016-01-08T02:03:12-08:00
849 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, accessing_facebook_on:Wi-Fi, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Politics, and_must_also_match:interests:HuffPost Black Voices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Why don‘t american cops realize that being black is not a crime? African american kids are being shot only for playing with toy guns... How is it possible? Where is the justice? Our Government is blind, they simply don‘t want to pay attention to this legalized homicide of own people... This is crazy! We must speak about it! 0.0 0.00 USD 2016-01-19T03:45:52-08:00 2016-01-08T02:03:12-08:00
1478 no image location:United States, interests:Social justice, interests:St. Louis, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Everyday we watch, read and receive news of police beating, assaulting, and killing innocent people. These videos and instances have become so common that people are rarely shocked by even the most brutal of cases. We were wondering how long time would it take to make people fighting back? So now, karma's coming back for blue pigs! A shocking video was shared on social media Tuesday showing two police officers being attacked. Two unidentified men were seen beating up the two officers for seemingly no reason. The incident occurred Monday afternoon in Northeast Philadelphia after two school police officers were called to break up a fight outside of a local pizza shop. As we can see police couldn't stop the fight. Now we see what kind of police do we have. Those cops are slow weak doughnuts, who can do |itera||y nothing without using their guns. Cops can blame themselves when shit like this happens. They live by their own laws, they can break your arms and legs, torture you with Chemical and electrical ways, rape or even kill you "doing theirjob." All those things and more are well within departmental policy. So I'd rather give a fight for my rights than ignore the fact our country becoming a Nazi States of America. Look around, the only other thing that will happen is that people will whine about it, but will ultimately do nothing to actively stop this behavior, and this is why cops are so violent now. If we want to stop it, we should fight as our ancestors did it for centuries. Take out a few dozen cops and the rest will Change. Amen. 0.0 0.00 USD 2016-05-06T06:35:56-07:00 2016-05-09T06:35:55-07:00
1479 no image location:United States, interests:Cop Block, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Everyday we watch, read and receive news of police beating, assaulting, and killing innocent people. These videos and instances have become so common that people are rarely shocked by even the most brutal of cases. We were wondering how long time would it take to make people fighting back? So now, karma's coming back for blue pigs! A shocking video was shared on social media Tuesday showing two police officers being attacked. Two unidentified men were seen beating up the two officers for seemingly no reason. The incident occurred Monday afternoon in Northeast Philadelphia after two school police officers were called to break up a fight outside of a local pizza shop. As we can see police couldn't stop the fight. Now we see what kind of police do we have. Those cops are slow weak doughnuts, who can do |itera||y nothing without using their guns. Cops can blame themselves when shit like this happens. They live by their own laws, they can break your arms and legs, torture you with Chemical and electrical ways, rape or even kill you "doing theirjob." All those things and more are well within departmental policy. So I'd rather give a fight for my rights than ignore the fact our country becoming a Nazi States of America. Look around, the only other thing that will happen is that people will whine about it, but will ultimately do nothing to actively stop this behavior, and this is why cops are so violent now. If we want to stop it, we should fight as our ancestors did it for centuries. Take out a few dozen cops and the rest will Change. Amen. 0.0 0.00 USD 2016-06-28T06:49:02-07:00 2016-05-09T06:35:55-07:00
1480 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Everyday we watch, read and receive news of police beating, assaulting, and killing innocent people. These videos and instances have become so common that people are rarely shocked by even the most brutal of cases. We were wondering how long time would it take to make people fighting back? So now, karma's coming back for blue pigs! A shocking video was shared on social media Tuesday showing two police officers being attacked. Two unidentified men were seen beating up the two officers for seemingly no reason. The incident occurred Monday afternoon in Northeast Philadelphia after two school police officers were called to break up a fight outside of a local pizza shop. As we can see police couldn't stop the fight. Now we see what kind of police do we have. Those cops are slow weak doughnuts, who can do |itera||y nothing without using their guns. Cops can blame themselves when shit like this happens. They live by their own laws, they can break your arms and legs, torture you with Chemical and electrical ways, rape or even kill you "doing theirjob." All those things and more are well within departmental policy. So I'd rather give a fight for my rights than ignore the fact our country becoming a Nazi States of America. Look around, the only other thing that will happen is that people will whine about it, but will ultimately do nothing to actively stop this behavior, and this is why cops are so violent now. If we want to stop it, we should fight as our ancestors did it for centuries. Take out a few dozen cops and the rest will Change. Amen. 0.0 0.00 USD 2016-07-06T07:05:50-07:00 2016-05-09T06:35:55-07:00
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  
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  
2904 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: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 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:54-07:00  
2905 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: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:Second Amendment Supporters, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association, and_must_also_match:interests:National Association for 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:36:54-07:00  
2906 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: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:Second Amendment Supporters, and_must_also_match:interests:Right to keep and bear arms, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association, and_must_also_match:interests:Gun Owners of America, and_must_also_match:interests:Second Amendment to the United States Constitution, and_must_also_match:interests:Concealed carry in the United States, and_must_also_match:interests:National Association for Gun Rights, 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:37:37-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  
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  
2918 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:politics:US politics (conservative), and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:AR-15, and_must_also_match:interests:2nd Amendment, 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:44:07-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  
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  
2925 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:Anything About Guns, people_who_match:interests:Gun Rights 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  
2926 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:Anything About Guns, people_who_match:interests:Gun Rights 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  
2927 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:Anything About Guns, people_who_match:interests:Gun Rights 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  
2928 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:Anything About Guns, people_who_match:interests:Gun Rights 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  
2929 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 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:54-07:00  
2930 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:Second Amendment Supporters, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association, and_must_also_match:interests:National Association for 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:36:54-07:00  
2931 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:Second Amendment Supporters, and_must_also_match:interests:Right to keep and bear arms, and_must_also_match:interests:2nd Amendment, and_must_also_match:interests:National Rifle Association, and_must_also_match:interests:Gun Owners of America, and_must_also_match:interests:Second Amendment to the United States Constitution, and_must_also_match:interests:Concealed carry in the United States, and_must_also_match:interests:National Association for Gun Rights, 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:37:37-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  

Next page

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