home / russian-ads

display_ads (view)

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

7 rows where an ad_target was people_who_match:interests:Jesus

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
6 location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 0 0 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 0.0 0.00 USD 2016-05-12T04:06:17-07:00  
7 no image location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 23408 54 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 45.89696 2868.56 RUB 2016-05-13T01:18:08-07:00  
1253 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:Laura Ingraham, people_who_match:interests:Fox News Channel, people_who_match:interests:Ron Paul, people_who_match:interests:Tucker Carlson, people_who_match:interests:Rand Paul, people_who_match:interests:Christianity, people_who_match:interests:Bill O'Reilly (political commentator), people_who_match:interests:Rush Limbaugh, people_who_match:interests:Andrew Breitbart, people_who_match:interests:breitbart, people_who_match:interests:Bible, people_who_match:interests:Conservatism in the United States, people_who_match:interests:Sean Hannity, people_who_match:interests:Michael Savage, people_who_match:interests:Mike Pence, people_who_match:interests:Michelle Malkin, people_who_match:interests:Mike Huckabee, people_who_match:interests:Jesus, people_who_match:interests:TheBIaze, people_who_match:interests:Donald, trump_jr_politics:US politics (very conservative) 2781 282 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. America is at risk now more than even 33.51584 2094.74 RUB 2017-08-13T22:47:48-07:00 2017-08-15T22:47:53-07:00
1258 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:Laura Ingraham, people_who_match:interests:Fox News Channel, people_who_match:interests:Ron Paul, people_who_match:interests:Tucker Carlson, people_who_match:interests:Rand Paul, people_who_match:interests:Christianity, people_who_match:interests:Bill O'Reilly (political commentator), people_who_match:interests:Rush Limbaugh, people_who_match:interests:Andrew Breitbart, people_who_match:interests:breitbart, people_who_match:interests:Bible, people_who_match:interests:Conservatism in the United States, people_who_match:interests:Sean Hannity, people_who_match:interests:Michael Savage, people_who_match:interests:Mike Pence, people_who_match:interests:Michelle Malkin, people_who_match:interests:Mike Huckabee, people_who_match:interests:Jesus, people_who_match:interests:TheBIaze, people_who_match:interests:Donald, trump_jr_politics:US politics (very conservative) 0 0 https://www.facebook.com/Iogin/?hext=https%3A%2F%2Fl.facebook.com%2 Today Americans are able to elect a president with godly moral principles. Hillary is a Satan, and her crimes and lies had proved just how evil she is. And even though Donald Trump isn’t a saint by any means, he’s at least an honest man and he cares deeply for this country. My vote goes for him! 0.0 0.00 USD 2017-07-27T11:10:02-07:00 2016-10-20T08:45:00-07:00
1259 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:Laura Ingraham, people_who_match:interests:Fox News Channel, people_who_match:interests:Ron Paul, people_who_match:interests:Tucker Carlson, people_who_match:interests:Rand Paul, people_who_match:interests:Christianity, people_who_match:interests:Bill O'Reilly (political commentator), people_who_match:interests:Rush Limbaugh, people_who_match:interests:Andrew Breitbart, people_who_match:interests:breitbart, people_who_match:interests:Bible, people_who_match:interests:Conservatism in the United States, people_who_match:interests:Sean Hannity, people_who_match:interests:Michael Savage, people_who_match:interests:Mike Pence, people_who_match:interests:Michelle Malkin, people_who_match:interests:Mike Huckabee, people_who_match:interests:Jesus, people_who_match:interests:TheBIaze, people_who_match:interests:Donald, trump_jr_politics:US politics (very conservative) 3069 291 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. America is at risk now more than even 33.535360000000004 2095.96 RUB 2017-07-27T11:11:10-07:00 2017-07-29T11:11:15-07:00
2999 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pentecostalism, people_who_match:interests:Baptism, people_who_match:interests:Presbyterianism, people_who_match:interests:Lutheranism, people_who_match:interests:Baptism of Jesus, people_who_match:interests:Jesus 0 0 https://www.facebook.com/B|ack_Baptist_churCh-1160193507389202/ You are an Awesome God, i will forever praise you for your goodness, love and kindness. #ittakestime #soblessed #waitingonthelord #Iord #amen #hallelujah #salvation #Blacksforchrist #jesus #jesussaves #prayer #jesusistruth #jesusforall #Iiveforchrist #america #saved #Christians #Christfanatics #Jesus #Christ #Cristo #Church #amor #Iove #God #jesuslovesyou #jesuschrist #prayer #Godisincontrol #praisebetotheLord 0.0 0.00 USD 2017-01-31T03:30:55-08:00 2017-02-01T03:30:55-08:00
3000 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pentecostalism, people_who_match:interests:Baptism, people_who_match:interests:Presbyterianism, people_who_match:interests:Lutheranism, people_who_match:interests:Baptism of Jesus, people_who_match:interests:Jesus 0 0 https://www.facebook.com/B|ack_Baptist_churCh-1160193507389202/ God created you and loves you! Never forget! ? .#ittakestime #soblessed #waitingonthelord#lord #amen #hallelujah #salvation #Blacksforchrist #jesus #jesussaves #prayer #jesusistruth #jesusforall #Iiveforchrist #america #saved #Christians #Christfanatics #Jesus #Christ #Cristo #Church #amor #Iove #God #jesuslovesyou #jesuschrist #prayer #Godisincontrol #praisebetotheLord 0.0 0.00 USD 2017-01-31T03:30:17-08:00 2017-02-07T03:30:17-08: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 1222.156ms · Data source: simonw/russian-ira-facebook-ads-datasette