home / russian-ads

display_ads (view)

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

2 rows where an ad_target was location_living_in:united_states:Temple (+35 mi)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
725 location_living_in:united_states:Abilene (+30 mi), location_living_in:united_states:Amarillo (+30 mi), location_living_in:united_states:Austin (+35 mi), location_living_in:united_states:Beaumont (+31 mi), location_living_in:united_states:Brownwood (+32 mi), location_living_in:united_states:Bryan (+33 mi), location_living_in:united_states:Conroe (+31 mi), location_living_in:united_states:Corpus Christi (+31 mi), location_living_in:united_states:Dallas (+33 mi), location_living_in:united_states:Fort Worth (+33 mi), location_living_in:united_states:Houston (+34 mi), location_living_in:united_states:Lubbock (+32 mi), location_living_in:united_states:Odessa (+33 mi), location_living_in:united_states:San Angelo (+39 mi), location_living_in:united_states:San Antonio (+28 mi), location_living_in:united_states:South Plains (+36 mi), location_living_in:united_states:Temple (+35 mi), location_living_in:united_states:Texas City (+35 mi), location_living_in:united_states:Tyler (+35 mi), location_living_in:united_states:Waco (+39 mi) Texas, connections:People who like Heart of Texas, excluded_connections:Exclude people who are going to Get Ready to Secedel, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 17334 1807 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 Secedel 70.18111999999999 4386.32 RUB 2016-11-02T05:16:25-07:00 2016-11-03T11:07:27-07:00
726 location_living_in:united_states:Abilene (+30 mi), location_living_in:united_states:Amarillo (+30 mi), location_living_in:united_states:Austin (+35 mi), location_living_in:united_states:Beaumont (+31 mi), location_living_in:united_states:Brownwood (+32 mi), location_living_in:united_states:Bryan (+33 mi), location_living_in:united_states:Conroe (+31 mi), location_living_in:united_states:Corpus Christi (+31 mi), location_living_in:united_states:Dallas (+33 mi), location_living_in:united_states:Fort Worth (+33 mi), location_living_in:united_states:Houston (+34 mi), location_living_in:united_states:Lubbock (+32 mi), location_living_in:united_states:Odessa (+33 mi), location_living_in:united_states:San Angelo (+39 mi), location_living_in:united_states:San Antonio (+28 mi), location_living_in:united_states:South Plains (+36 mi), location_living_in:united_states:Temple (+35 mi), location_living_in:united_states:Texas City (+35 mi), location_living_in:united_states:Tyler (+35 mi), location_living_in:united_states:Waco (+39 mi) Texas, connections:People who like Heart of Texas, excluded_connections:Exclude people who are going to Get Ready to Secedel, age:18 — 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 2897 225 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 Secedel 10.04288 627.68 RUB 2016-11-03T07:56:02-07:00 2016-11-03T11:07:27-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 1442.068ms · Data source: simonw/russian-ira-facebook-ads-datasette