home / russian-ads

display_ads (view)

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

11 rows where an ad_target was location:united_states:New Mexico

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
685 location:united_states:New Mexico, location:united_states:Arizona (+25 mi) Texas, excluded_connections:Exclude people who like Secured Borders, age:15 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-09-20T07:06:40-07:00  
686 location:united_states:Alabama, location:united_states:Georgia, location:united_states:New Mexico, people_who_match:interests:Same-sex marriage, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump for President 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-10-11T09:11:47-07:00  
690 location:united_states:New Mexico, location:united_states:Arizona (+25 mi) Texas, excluded_connections:Exclude people who like Secured Borders, age:15 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 11481 873 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 241.42048000000003 15088.78 RUB 2016-09-20T07:06:40-07:00  
691 location:united_states:Alabama, location:united_states:Georgia, location:united_states:New Mexico, people_who_match:interests:Same-sex marriage, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump for President 2502 258 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 48.40832 3025.52 RUB 2016-10-11T09:11:47-07:00  
1707 no image location:united_states:Atlanta (+40 km) Georgia, location:united_states:New Mexico, location:united_states:North Carolina, location:united_states:Ohio, location:united_states:South Carolina, age:17 - 61, placements:Instagram Feed 8863 2 https://www.facebook.com/Funnylnst-489676547881868/ Either We Together or We Ain't! 24.203680000000002 1512.73 RUB 2016-05-17T04:05:42-07:00  
2439 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2395 269 https://www.faoebook.com/BIack-Edification-1772583676310336/ So let's do this. Since no one knew what he looked like and the bible forbade idolatry how about we all stop trying to draw Jesus! 4.84752 302.97 RUB 2016-06-28T11:05:51-07:00 2016-06-29T11:05:50-07:00
2440 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African—American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2318 146 https://www.facebook.com/BIack-Edification-1772583676310336/ Many of us are poor and struggling due to systemic racisml! 80 fight for something! IT IS OUR DUTY!! WE HAVE NOTHING TO LOSE BUT OUR CHAINS! 1.18 73.75 RUB 2016-07-19T14:16:10-07:00 2016-07-26T14:16:09-07:00
2441 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 658 145 https://www.facebook.com/BIack-Edification-1772583676310336/ The Original Statue of Liberty presented to the US. was a Statue of a..."BIack Woman". - Urban Intellectuals 2.21056 138.16 RUB 2016-06-28T11:59:55-07:00 2016-07-05T11:59:54-07:00
2442 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African-American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4717 470 https://www.facebook.com/Black-Edification-1772583676310336/ Melanin is gold. It's a gift of God. We have to appreciate this in all shades. The black girls with freckles are also beautiful. 8.0 500.00 RUB 2016-06-25T13:08:42-07:00 2016-06-27T13:08:40-07:00
2443 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African-American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Black-Edification-1772583676310336/ Melanin is gold. It's a gift of God. We have to appreciate this in all shades. The black girls with freckles are also beautiful. 0.0 0.00 USD 2016-07-17T00:37:25-07:00 2016-06-27T13:08:40-07:00
2444 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 15771 4020 https://www.faoebook.com/BIack-Edification-1772583676310336/ Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that. Martin Luther King, Jr. 8.0 500.00 RUB 2016-07-17T00:48:23-07:00 2016-07-24T00:48:22-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/umd-mith/irads/master/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 1387.624ms · Data source: simonw/russian-ira-facebook-ads-datasette