home / russian-ads

display_ads (view)

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

19 rows where an ad_target was location:united_states:Florida

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  
525 location:united_states:Florida, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 59025 8382 https://www.facebook.com/events/620928338080560/ We announce a patriotic flash mob in Florida on August, 20! We either win Florida or lose Florida Goes Trump! 438.44752000000005 27402.97 RUB 2016-08-04T04:34:15-07:00 2016-08-20T04:34:13-07:00
1618 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1619 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 11 0 https://www.facebook.com/MuslimAmerica/ Stop Islamophobia 7777')? 7777977779??? 0.0 0.00 USD 2016-10-03T06:40:06-07:00  
1633 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1634 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 532 19 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 2.26608 141.63 RUB 2016-10-03T06:40:06-07:00  
1663 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1664 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ we are Muslims and we stand together 77') 7777')? 777') 7') 9797') 9797') 0.0 0.00 USD 2016-10-03T06:40:06-07:00  
1670 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-10-03T06:40:03-07:00  
1671 location:united_states:California, location:united_states:Florida, location:united_states:Illinois, location:united_states:Michigan, location:united_states:New Jersey, location:united_states:New York, location:united_states:Texas, location:united_states:Virginia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Islam, people_who_match:interests:Quran, people_who_match:interests:Muhammad, people_who_match:interests:State of Palestine, people_who_match:interests:Muslim world, people_who_match:interests:Mosque, people_who_match:interests:Allah, people_who_match:interests:Muslim Brotherhood or AII-american muslim culture, people_who_match:interests:School: St. Edward's University 0 0 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 0.0 0.00 USD 2016-10-03T06:40:06-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  
1945 no image location:united_states:Florida, location:united_states:Georgia, location:united_states:New York, age:16 - 60, placements:Instagram Feed, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Malcolm, x_field_of_study:African-American history 5609 2 https://www.facebook.com/Proudblacks-954167134618867/ Follow BlackAmericaToday! Stay woke! 10.145280000000001 634.08 RUB 2016-05-17T04:18:29-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 1286.421ms · Data source: simonw/russian-ira-facebook-ads-datasette