home / russian-ads

display_ads (view)

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

10 rows where an ad_target was location:united_states:Mississippi

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
32 location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Florida, location:united_states:Georgia, location:united_states:Louisiana, location:united_states:Mississippi, location:united_states:North Carolina, location:united_states:South Carolina, location:united_states:Tennessee, location:united_states:Texas, location:united_states:Virginia, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Confederate Flag, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:confederate states america, people_who_match:interests:United Daughters of the Confederacy, people_who_match:interests:Confederate States of America, people_who_match:interests:Sons of Confederate Veterans, people_who_match:interests:Confederate States Army, people_who_match:interests:Robert E. Lee, people_who_match:interests:Southern United States, people_who_match:interests:Redneck Social Club 12727 375 https://www.instagram.com/south_united/ Heritage not hate y'all! Our flag has nothing to do with racism! The Federal Government shouldn’t be able to dictate what we can and cannot do. Go follow Confederate page #1 on Instagram south united if you are proud of our southern heritage. God bless Dixie! Confederate page #1 on Instagram! No racism, no hate! The south will rise again! https://twitter.com/March_for_Trump South United GovSpehding 49.700480000000006 3106.28 RUB 2016-08-18T08:31:16-07:00  
1885 no image location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Georgia, location:united_states:Illinois, location:united_states:Iowa, location:united_states:Louisiana, location:united_states:Minnesota, location:united_states:Mississippi, location:united_states:Nebraska, location:united_states:Wisconsin, age:16 - 60, placements:Instagram Feed, people_who_match:interests:U.S. Patriot Tactical, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:The Patriot Post, people_who_match:interests:Confederate States of America, people_who_match:interests:American Patriots, people_who_match:interests:Thank A Soldier, people_who_match:interests:Flag of the United States, people_who_match:interests:Guns & Patriots, people_who_match:interests:American Patriot, people_who_match:interests:Proud to be an American, people_who_match:interests:American patriotism, people_who_match:interests:Chris Kyle 13211 10 https://www.facebook.com/Lalalo-1028159433939877/ INSTagram Of The United States or simply - INSTOTUS. Unique Instagram page for American patriots only! FOLLOW! JUST DO IT! 36.44064 2277.54 RUB 2016-05-20T04:36:31-07:00  
1910 location:united_states:Alabama, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:South Carolina, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservative News Today, people_who_match:interests:Young Republicans, people_who_match:interests:The Conservative, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America, people_who_match:interests:Donald Trump for President, people_who_match:interests:College Republicans 0 0 https://www.instagram.Com/tea_party_news/ Florida goes Trump! Here are Florida Cities participating: Daytona Beach, Tampa, Fort Myers, Miami, Orlando, Pensacola, Ft Lauderdale, Sarasota, Clearwater, Oxford, West Palm Beach, Coral Springs. For more details write us in comments or via DM. Go Tea Party! Pro- American, Pro—Guns, Pro—Patriotic! Tea Party News Muslimlnst 0.0 0.00 USD 2016-08-16T05:47:11-07:00  
1911 location:united_states:Alabama, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:South Carolina, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservative News Today, people_who_match:interests:Young Republicans, people_who_match:interests:The Conservative, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America, people_who_match:interests:Donald Trump for President, people_who_match:interests:College Republicans 9244 85 https://www.instagram.Com/tea_party_news/ Florida goes Trump! Here are Florida Cities participating: Daytona Beach, Tampa, Fort Myers, Miami, Orlando, Pensacola, Ft Lauderdale, Sarasota, Clearwater, Oxford, West Palm Beach, Coral Springs. For more details write us in comments or via DM. Go Tea Party! Pro- American, Pro—Guns, Pro—Patriotic! Tea Party News Teapartypat 50.85056 3178.16 RUB 2016-08-16T05:49:47-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/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 1453.724ms · Data source: simonw/russian-ira-facebook-ads-datasette