home / russian-ads

display_ads (view)

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

85 rows where an ad_target was interests:Independence

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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  
3519 location:United States, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Being Patriotic, 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/patriototus Best patriotic page ever! Join! 0.0 0.00 USD 2015-07-08T05:49:40-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 1105.303ms · Data source: simonw/russian-ira-facebook-ads-datasette