home / russian-ads

display_ads (view)

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

42 rows where an ad_target was location:united_states:St. Louis (+20 km) Missouri

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
53 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:13:40-07:00  
64 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 500 25 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us. Because we care 5.44544 340.34 RUB 2015-07-10T01:03:31-07:00  
82 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 191 6 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 4.116 257.25 RUB 2015-07-10T01:02:58-07:00  
83 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 613 30 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us. Because we care 7.488 468.00 RUB 2015-07-10T01:03:32-07:00  
92 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 608 27 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 7.1248000000000005 445.30 RUB 2015-07-10T01:03:03-07:00  
94 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-13T07:17:59-07:00  
100 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-13T07:18:00-07:00  
110 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:13:41-07:00  
319 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 0.0 0.00 USD 2015-07-13T07:12:00-07:00  
321 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 0.0 0.00 USD 2015-07-13T07:12:24-07:00  
323 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:16:57-07:00  
324 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:16:58-07:00  
360 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-06-10T03:01:20-07:00  
361 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 82 5 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.5545599999999999 34.66 RUB 2015-06-10T03:20:43-07:00  
363 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-06-10T03:01:20-07:00  
364 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 46447 2740 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 205.73536 12858.46 RUB 2015-06-10T03:29:48-07:00  
366 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 158 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Keeping eye on our brother's cases and much more 0.80176 50.11 RUB 2015-06-10T03:01:19-07:00  
368 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Join us because we care. Black matters. 0.0 0.00 USD 2015-06-10T02:59:59-07:00  
369 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 56408 3296 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us because we care. Black matters. 219.26432 13704.02 RUB 2015-06-10T03:27:28-07:00  
371 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Join us because we care. Black matters. 0.0 0.00 USD 2015-06-10T02:59:57-07:00  
372 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 26442 1574 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us because we care. Black matters. 112.30336 7018.96 RUB 2015-06-10T03:30:17-07:00  
374 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 137 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us because we care. Black matters. 0.71792 44.87 RUB 2015-06-10T02:59:53-07:00  
376 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Your life matterMy life matter. Black matters. 0.0 0.00 USD 2015-06-10T02:58:57-07:00  
377 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 249 7 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Your life matterMy life matter. Black matters. 1.37008 85.63 RUB 2015-06-10T03:31:26-07:00  
379 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Your life matterMy life matter. Black matters. 0.0 0.00 USD 2015-06-10T02:58:56-07:00  
380 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 207 7 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Your life matterMy life matter. Black matters. 1.11296 69.56 RUB 2015-06-10T03:30:43-07:00  
382 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 157 2 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Your life matterMy life matter. Black matters. 0.8025599999999999 50.16 RUB 2015-06-10T02:58:54-07:00  
384 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus We really can Change the world if we stay united. 0.0 0.00 USD 2015-06-10T02:58:20-07:00  
385 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 66 3 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We really can Change the world if we stay united. 0.41392 25.87 RUB 2015-06-10T03:28:34-07:00  
387 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus We really can Change the world if we stay united. 0.0 0.00 USD 2015-06-10T02:58:20-07:00  
388 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 311 8 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We really can Change the world if we stay united. 1.68992 105.62 RUB 2015-06-10T03:21:09-07:00  
390 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 204 4 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We really can Change the world if we stay united. 1.04976 65.61 RUB 2015-06-10T02:58:18-07:00  
392 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Black matters because everyone's life matters 0.0 0.00 USD 2015-06-10T02:58:03-07:00  
393 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 191 2 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black matters because everyone's life matters 0.9044800000000001 56.53 RUB 2015-06-10T03:22:04-07:00  
395 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Black matters because everyone's life matters 0.0 0.00 USD 2015-06-10T02:58:01-07:00  
396 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 250 7 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black matters because everyone's life matters 1.33152 83.22 RUB 2015-06-10T03:27:56-07:00  
398 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 136 1 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black matters because everyone's life matters 0.62224 38.89 RUB 2015-06-10T02:58:00-07:00  
400 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus We can be heard only when we stand together. Black matters. 0.0 0.00 USD 2015-06-10T02:57:12-07:00  
401 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 203 4 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We can be heard only when we stand together. Black matters. 1.18512 74.07 RUB 2015-06-10T03:26:57-07:00  
403 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus We can be heard only when we stand together. Black matters. 0.0 0.00 USD 2015-06-10T02:57:12-07:00  
404 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 248 6 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We can be heard only when we stand together. Black matters. 1.2438399999999998 77.74 RUB 2015-06-10T03:21:36-07:00  
406 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 160 1 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We can be heard only when we stand together. Black matters. 0.73152 45.72 RUB 2015-06-10T02:57:10-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 1650.523ms · Data source: simonw/russian-ira-facebook-ads-datasette