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 sorted by clicks

View and edit SQL

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  
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  
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  
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  
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  
1368 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  
1369 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/ Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-04-13T07:47:48-07:00  
1370 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/ Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1371 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 If you want to save America, you're a part of us. Like to join! 0.03648 2.28 RUB 2016-04-13T07:48:08-07:00  
1372 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  
1373 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 This page is dedicated to protection against illegal immigrants! Like to join! 0.01408 0.88 RUB 2016-04-13T07:46:50-07:00  
1374 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  
1375 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 This page is dedicated to protection against illegal immigrants! Like to join! 0.00128 0.08 RUB 2016-04-13T07:46:56-07:00  
1376 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  
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  
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  
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  
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  
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  
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  
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  

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