home / russian-ads

display_ads (view)

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

45 rows where an ad_target was excluded_connections:Exclude people who like Heart of Texas

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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  
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  

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