home / russian-ads

display_ads (view)

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

59 rows where an ad_target was people_who_match:interests:Politics

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
35 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 0 0 https://www.instagram.Com/veterahs_us/ There are some people who will always support you! And unfortunately, the VA is not on the list. There are numerous examples of disgusting treatment of our Veterans by the VA employees. And there is little Chance the situation will Change in the near future. The failure of the Defense Department and VA to create a joint electronic health record, despite spending $1 billion for development is just another example of it. Click Learn More! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2016-01-14T06:25:20-08:00  
36 location:United States, age:13 — 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 143644 496 https://www.instagram.com/veterans_usl He's lucky to return home to reunite with his family for the holidays. But he's just one of a few servicemen to do this. For many of our brave troops stationed abroad and far from their loved ones. Our brave servicemen and servicewomen will continue to make sacrifices for our great country while the VA employees will be having their dinner and laughing at the VA backlog. Click to Learn More! Veterans USA ( @veterans GovSpending 133.42592000000002 8339.12 RUB 2016-01-14T07:18:30-08:00  
1271 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1737 215 https://www.facebook.com/Stop-AI-896610653786585/ If you want to save America, you're a part of us. Like to join! 13.37152 835.72 RUB 2016-04-13T07:48:07-07:00  
1272 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 13188 2179 https://www.facebook.com/Stop-AI-896610653786585/ If you want to save America, you're a part of us. Like to join! 131.19776000000002 8199.86 RUB 2016-05-05T03:27:06-07:00  
1273 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 718 11 https://www.facebook.com/Stop-AI-896610653786585/ Like if you are against illegal immigration! News and analysis! 0.9795200000000001 61.22 RUB 2016-01-14T05:01:22-08:00  
1277 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 1599 106 https://www.facebook.com/Stop-AI-896610653786585/ Not all refugees are good. 17.079520000000002 1067.47 RUB 2016-01-14T05:04:49-08:00  
1282 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 847 82 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 7.017600000000001 438.60 RUB 2016-04-13T07:47:50-07:00  
1283 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 19223 2335 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 111.89775999999999 6993.61 RUB 2016-05-05T03:27:06-07:00  
1296 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 2109 34 https://www.facebook.com/Stop-AI-896610653786585/ You are not the only one to despise immigration. Join our community! 0.7152000000000001 44.70 RUB 2016-01-14T05:04:06-08:00  
1307 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 2995 163 https://www.facebook.com/Stop-AI-896610653786585/ News is telling you enough about good refugees. We take on bad ones. 25.479200000000002 1592.45 RUB 2016-01-14T05:05:22-08:00  
1308 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 1610 25 https://www.facebook.com/Stop-AI-896610653786585/ Like if you are against illegal immigration! 4.2623999999999995 266.40 RUB 2016-01-14T05:01:43-08:00  
1315 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 1968 23 https://www.facebook.com/Stop-AI-896610653786585/ Your voice counts! Stop illegal immigration! 1.39392 87.12 RUB 2016-01-14T05:00:25-08:00  
1318 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 666 6 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants 0.25792000000000004 16.12 RUB 2016-01-14T04:59:29-08:00  
1325 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 12834 3051 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 185.62896 11601.81 RUB 2016-04-13T07:46:57-07:00  
1326 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 91603 18259 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 832.3352 52020.95 RUB 2016-05-05T03:27:06-07:00  
1333 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-04-13T07:48:09-07:00  
1334 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1335 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 223 25 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 3.43104 214.44 RUB 2016-04-13T07:47:57-07:00  
1336 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1337 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-04-13T07:47:24-07:00  
1338 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1339 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-04-13T07:47:22-07:00  
1340 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1341 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 144 16 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 2.68752 167.97 RUB 2016-04-13T07:48:10-07:00  
1342 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1343 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/Stop-AI-896610653786585/ Close the borders until it's too late. Like to join! 0.028 1.75 RUB 2016-04-13T07:48:28-07:00  
1344 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1345 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.02432 1.52 RUB 2016-04-13T07:48:29-07:00  
1346 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1347 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 4 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.04096 2.56 RUB 2016-04-13T07:48:34-07:00  
1348 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1349 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.01056 0.66 RUB 2016-04-13T07:48:33-07:00  
1350 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1351 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/Stop-AI-896610653786585/ The nation without borders is not a nation at all. Like to join! 0.012 0.75 RUB 2016-04-13T07:47:21-07:00  
1352 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1353 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 3 0 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 0.04144 2.59 RUB 2016-04-13T07:46:51-07:00  
1354 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1355 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 20 2 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.40368000000000004 25.23 RUB 2016-04-13T07:47:22-07:00  
1356 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1357 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.016800000000000002 1.05 RUB 2016-04-13T07:48:32-07:00  
1358 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1359 no image location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.016 1.00 RUB 2016-04-13T07:48:09-07:00  
1360 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1361 no image location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants! Like to join! 0.0 0.00 USD 2016-04-13T07:46:49-07:00  
1362 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants! Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1363 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.02688 1.68 RUB 2016-04-13T07:47:25-07:00  
1364 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1365 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-04-13T07:48:01-07:00  
1366 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1367 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.020640000000000002 1.29 RUB 2016-04-13T07:48:04-07:00  

Next page

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 1295.574ms · Data source: simonw/russian-ira-facebook-ads-datasette