home / russian-ads

display_ads (view)

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

67 rows where an ad_target was location:united_states:Texas

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
32 location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Florida, location:united_states:Georgia, location:united_states:Louisiana, location:united_states:Mississippi, location:united_states:North Carolina, location:united_states:South Carolina, location:united_states:Tennessee, location:united_states:Texas, location:united_states:Virginia, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Confederate Flag, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:confederate states america, people_who_match:interests:United Daughters of the Confederacy, people_who_match:interests:Confederate States of America, people_who_match:interests:Sons of Confederate Veterans, people_who_match:interests:Confederate States Army, people_who_match:interests:Robert E. Lee, people_who_match:interests:Southern United States, people_who_match:interests:Redneck Social Club 12727 375 https://www.instagram.com/south_united/ Heritage not hate y'all! Our flag has nothing to do with racism! The Federal Government shouldn’t be able to dictate what we can and cannot do. Go follow Confederate page #1 on Instagram south united if you are proud of our southern heritage. God bless Dixie! Confederate page #1 on Instagram! No racism, no hate! The south will rise again! https://twitter.com/March_for_Trump South United GovSpehding 49.700480000000006 3106.28 RUB 2016-08-18T08:31:16-07:00  
700 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 5401 1501 https://www.facebook.com/Heart-of-Texas-761114847343674/ After what happened in Dallas ordinary Texans did not remain indifferent. Several men armed with AR-15 went to the Splendora Police Department and stood guarding the building. Y’all should do the same thing — we must protect our cops! We won’t let some gangsters attack the people who keep our security. If this is a war against police - we're joining this war on the cop's side! 8.0 500.00 RUB 2016-07-14T00:54:34-07:00 2016-07-15T00:54:33-07:00
701 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 12334 1290 https://www.facebook.com/timetosecede/ Heart of Texas! Time to secede! 129.19792 8074.87 RUB 2015-09-22T07:44:46-07:00  
702 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 2409 130 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 7.31312 457.07 RUB 2016-10-11T07:47:39-07:00  
708 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 3361 808 https://www.facebook.com/Heart-of-Texas-761114847343674/ Border Patrol agents in South Texas arrested an illegal alien from Honduras that had previously been deported and convicted of Rape Second Degree. Thanks to Obama's and Hillary's policy, illegals come here because they wait for amnesty promised. The wrong course had been Chosen by the American government, but all those politicians are too far from the border to see who actually sneaks through it illegally. Rapists, drug dealers, human traffickers, and others. The percent of innocent poor families searching for a better life is too small to become an argument for amnesty and Texas warm welcome. 8.0 500.00 RUB 2016-08-04T05:57:19-07:00 2016-08-05T05:57:18-07:00
709 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 2070 382 https://www.facebook.com/Heart-of-Texas-761114847343674/ Hillary Clinton has a 69 percent disapproval rate among all veterans. Indeed, there are many reasons for it. First of all, Benghazi: four people died on her watch and she did not send help. Secondly, Hillary refused to apologize to all veterans, when she has made several remarks about veterans "embellishing" the situation at the VA. Finally, Hillary is the only one politician (except Barack Obama) who is despised by the overwhelming majority of American veterans. If Hillary becomes the President of the US, the American army should be withdrawn from Hillary's control according to the amendments to the Constitution. 8.0 500.00 RUB 2016-05-25T07:22:38-07:00 2016-05-26T07:22:37-07:00
710 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 3060 679 https://www.facebook.com/Heart-of-Texas-761114847343674/ The police report that the Black Lives Matter terrorist sniper Micah Johnson used to buildings owned by Muslim Arabs to carry his attack. If you think it was just a coincidence, you make a mistake. Johnson got set up in one building and moved more than 10 miles away to another building owned by the same people to shoot from. It doesn't look like it is a coincidence. Moreover, some witnesses said that they saw Jonson visiting a mosque. Muslims seem to be not peace-Ioving as they say. And I don't want to see 10,000 potential terrorists here in Texas. 8.0 500.00 RUB 2016-07-14T00:54:17-07:00 2016-07-15T00:54:16-07:00
711 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 1954 368 https://www.facebook.com/Heart-of-Texas-761114847343674/ Austin’s Robert E. Lee Elementary school has a new name: Russell Lee. The Austin School Board voted 8-1 to Change the name Monday night.The school board had three name options from which to Choose: Russell Lee, a photographer from the school’s neighborhood who started UT’s photography program. The board approved Russell Lee at the request of the school’s Campus Advisory Council. So, what can I say? This is a disgrace for the Texas authorities! I am shocked at the dismantling of southern history. We know that our ancestors fought for our freedom. These names were, are and always will be the part of Texas history. Why is Texas administration willing to do anything what feds say them? Isn't it obvious that the Federal government aims to destroy our history? This is a madness! Therefore, I need to ask you: are you ready to defend our Heritage? The Southern history needs protection now more than ever before! 4.8 300.00 RUB 2016-05-25T07:22:16-07:00 2016-05-26T07:22:15-07:00
717 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 4186 926 https://www.facebook.com/Heart-of-Texas-761114847343674/ President Barack Obama defended his decision to open up bathrooms to students of both sexes based on preference, Citing his religious faith as a reason he decided to do it. “My reading of scripture tells me that that [the] Golden Rule is pretty high up there in terms of my Christian belief,” he said during a town hall in Elkhart, Indiana. Obama is nothing more than an ignoramus and provocateur shamelessly mocking the Bible. Thanks God, the national nightmare is almost over. He tries to create as many conflicts among the population as it's possible destroying everything we hold of worth. 8.0 500.00 RUB 2016-06-06T08:25:39-07:00 2016-06-07T08:25:38-07:00
718 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 68285 8733 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ and ur heart! 767.93664 47996.04 RUB 2015-09-22T07:44:09-07:00  
719 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 14070 1037 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 58.446400000000004 3652.90 RUB 2016-10-11T07:47:39-07:00  
721 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 1968 347 https://www.facebook.com/Heart-of-Texas-761114847343674/ Texas is a free and independent State All political power is inherent in the people they have at all times the inalienable right to alter their government in such manner as they might think proper. Texas Constitution. 1876 8.0 500.00 RUB 2016-05-25T07:22:55-07:00 2016-05-26T07:22:54-07:00
722 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 15808 1521 https://www.facebook.com/timetosecede/ When you live in Texas you know that you are the Chosen one! 152.20352 9512.72 RUB 2015-09-22T07:42:20-07:00  
723 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 3178 204 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 10.72608 670.38 RUB 2016-10-11T07:47:39-07:00  
724 location:united_states:Texas, connections:People who like Heart of Texas, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 16168 2342 https://www.facebook.com/evehts/1828560880690663/ Fellow Texans! It's time to say a strong NO to the establishment robbers. It is unacceptable for us to see them ruin all we've been building for decades. For centuries. The establishment thinks they can treat us like stupid sheep but they are wrong. We won’t put up with this anymore. The corrupt media does not talk about the crimes committed by Killary Rotten Clinton, neither does it mention the leaked emails but it would rather keep on kicking around some outdated tapes featuring Trump. Even Republicans are now offering her a victory by renouncing their nominee. What is this if not treason? No, no, no. We are free citizens of Texas and we’ve had enough of this Cheap show on the screen. We're ready to prove our commitment to liberty, low taxes and gun rights. If Trump wins, there will be a possibility to secede peacefully but not without tension. What will happen if Hitlery becomes President? Higher taxes to feed undocumented aliens. More refugees, mosques, and terrorist attacks. Banned guns. Continuing economic depression. Let’s remind them what Texas is made of and show that we’re ready to SECEDE! Use our page to team up with other locals. Invite your friends and family, spread the word and let's make this effort together! Get Ready to Secede! 51.2 3200.00 RUB 2016-10-26T04:07:29-07:00 2016-11-03T11:07:27-07:00
727 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 1035 103 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ There are so many reasons to live and love Texas! Join to find out! 11.86224 741.39 RUB 2015-09-22T07:41:23-07:00  
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  
729 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 717 83 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ This page is about our best state! Lone Star of Blessed America! 10.7288 670.55 RUB 2015-09-22T07:39:28-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  
731 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 61357 4612 https://www.facebook.com/timetosecede/ Heart of Texas! Time to secede! 593.2712 37079.45 RUB 2015-09-22T07:44:43-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  
733 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 956 76 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ and ur heart! 10.8976 681.10 RUB 2015-09-22T07:44:13-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  
735 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 2792 272 https://www.facebook.com/timetosecede/ Best state in US! News, fun, events! Subscribe! 42.34176 2646.36 RUB 2015-09-22T07:43:22-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  
737 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 6687 689 https://www.facebook.com/timetosecede/ Best state in US! News, fun, events! Subscribe! 85.87183999999999 5366.99 RUB 2015-09-22T07:43:19-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  
739 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 36702 3868 https://www.facebook.com/timetosecede/ Best state in US! Should I say more? 497.66464 31104.04 RUB 2015-09-22T07:42:53-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  
741 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 439 38 https://www.facebook.com/timetosecede When you live in Texas you know that you are the Chosen one! 6.389600000000001 399.35 RUB 2015-09-22T07:42:26-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  
743 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 2900 275 https://www.facebook.com/timetosecede/ This page is about our best state! Lone Star of Blessed America! 33.99808 2124.88 RUB 2015-09-22T07:39:21-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  
745 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 175705 18083 https://www.facebook.com/timetosecede/ Best state in US! Should I say more? 1894.93632 118433.52 RUB 2015-09-22T07:42:46-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  
747 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 597 42 https://www.facebook.com/timetosecede/ There are so many reasons to live and love Texas! Join to find out! 7.36144 460.09 RUB 2015-09-22T07:41:18-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  
750 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 5060 1203 https://www.facebook.com/Heart-of-Texas-761114847343674/ It's not about the reason, it's all about the time! Texas holds a strong state identity and more conservative ideology than much of the rest of the country. It“ be enough for Texas to woke up and say "We're clone with Washingtonl". Texas has the power to become independent. Hillary's presidency will only become a stronger push for us to secede, but she also can do anything to prevent us from it! Stay conscious y'all! 8.0 500.00 RUB 2016-08-04T05:57:35-07:00 2016-08-05T05:57:33-07:00
751 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/Heart-of-Texas-761114847343674/ Obama is a total hypocrite and a liar! He visited the Dallas memorial service to blame us of racism. He just had to turn a ceremony honoring the fallen officers into a disgraceful. He doesn't care about fallen officers! Obama is not our leader! Texans have already honored our heroes, laying flowers at Dallas police headquarters. But Obama's speech did not make sense at all. That's why we have to support all police officers who refused to applaud Obama. Taking sides with these rioters and racists, Obama literally called for open war against police officers and whites. He came there and he lectured officers who are targeted every day for assassination by Black Lives Matter that they need to Change. Kick this asshole out of Texas! 0.0 0.00 USD 2016-07-14T00:54:14-07:00 2016-07-15T00:54:13-07:00
752 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 3569 658 https://www.facebook.com/Heart-of-Texas-761114847343674/ 6 months into legal open carry in Texas: no problems reported. Democrats, gunsense zealots, moms, students, professors and store owners told us that open carry WOULD be a problem, but as it turned out, there wasn't any. Yes, people are scared of people walking up carrying guns. But the truth is they don't realize that there much more people who carry guns illegally. That's why open carry is a guarantee of peace and stability in Texas. 8.0 500.00 RUB 2016-06-06T08:26:17-07:00 2016-06-07T08:26:16-07:00
755 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 Best state in US! Should I say more? 0.0 0.00 USD 2015-09-22T07:42:50-07:00  
756 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/ When you live in Texas you know that you are the Chosen one! 0.0 0.00 USD 2015-09-22T07:42:23-07:00  
757 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 Heart of Texas! Time to secede! 0.0 0.00 USD 2015-09-22T07:44:49-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  
759 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 Best state in US! News, fun, events! Subscribe! 0.0 0.00 USD 2015-09-22T07:43:25-07:00  
760 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/Heart-of-Texas-761114847343674/timeline/ There are so many reasons to live and love Texas! Join to find out! 0.0 0.00 USD 2015-09-22T07:41:20-07:00  
761 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/Heart-of-Texas-761114847343674/timeline/ This page is about our best state! Lone Star of Blessed America! 0.0 0.00 USD 2015-09-22T07:39:25-07:00  
1618 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1619 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, 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:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 11 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-10-03T06:40:06-07:00  
1633 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 0.0 0.00 USD 2016-10-03T06:40:03-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 1112.567ms · Data source: simonw/russian-ira-facebook-ads-datasette