home / russian-ads

display_ads (view)

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

23 rows where an ad_target was people_who_match:interests:Veterans

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
16 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support our troops, people_who_match:interests:Veterans, people_who_match:interests:AMVETS, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Chris Kyle, people_who_match:interests:Supporting Our Veterans, and_must_also_match:interests:Paralyzed Veterans of America, and_must_also_match:interests:Veterans Day, and_must_also_match:interests:Wounded Warrior Project, and_must_also_match:interests:Support our troops, and_must_also_match:interests:Veterans, and_must_also_match:interests:AMVETS, and_must_also_match:interests:United States Army Reserve, and_must_also_match:interests:Patriotism, and_must_also_match:interests:Disabled American Veterans, and_must_also_match:interests:The Veterans Site, and_must_also_match:interests:Chris Kyle, and_must_also_match:interests:Supporting Our Veterans 21093 53 https://www.instagram.Com/veterahs_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! The US Gov Spending Stats Instalol 34.10304 2131.44 RUB 2016-05-12T02:37:39-07:00  
34 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservatism, people_who_match:interests:Veterans Day, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Veterans, people_who_match:interests:Republican Party (United States), people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterans_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol 0.0 0.00 USD 2016-05-12T02:31:30-07:00  
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  
1784 location_living_in:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Paralyzed Veterans of America, people_who_match:interests:Iraq and Afghanistan Veterans of America, people_who_match:interests:Vietnam Veterans of America Foundation, people_who_match:interests:Veterans For America, people_who_match:interests:Support our troops, people_who_match:interests:Vietnam Veterans of America, people_who_match:interests:Vietnam Veterans Against the War, people_who_match:interests:Vietnam Vets, people_who_match:interests:Support Our Veterans, people_who_match:interests:Vietnam Veterans Memorial Fund, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Veterans, united_network_employers:US. Military 509 5 https://www.instagram.com/veterans_us/ Think of all little boys and girls who can lose or have already lost their fathers... God bless our troops! We are forever grateful! Home of the Brave. Support our Veterans! Please, repost it you like and don't forget to tag me! Follow the link. Veterans USA Funnylnst 2.2564800000000003 141.03 RUB 2016-08-12T02:10:06-07:00  
1937 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Support our troops, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Proud to be an American, people_who_match:interests:ForAmerica, people_who_match:interests:United States Armed Forces, people_who_match:interests:Veterans, people_who_match:interests:Patriotism, people_who_match:interests:The Veterans Site 22635 41 https://www.instagram.com/instotus/ This is a community for everyone whose heart is with America. Don't be a stranger - Follow @instotus Instagram Of The United Instotus 46.559839999999994 2909.99 RUB 2016-02-25T01:06:31-08:00 2016-03-24T05:00:00-07:00
2748 location_living_in:United States, age:45 - 64, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Police, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Veterans, people_who_match:interests:Law enforcement, people_who_match:interests:Police officer, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:The Thin Blue Line (emblem), and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:National Police Wives Association, and_must_also_match:interests:Heroes Behind The Badge 0 0 https://www.facebook.com/Copsareheroes/ Community of people who support our brave Police Officers. 0.0 0.00 USD 2016-10-18T08:27:21-07:00  
2749 location_living_in:United States, age:45 - 64, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Police, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Veterans, people_who_match:interests:Law enforcement, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:The Thin Blue Line (emblem), and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:Police officer, and_must_also_match:interests:National Police Wives Association, and_must_also_match:interests:Heroes Behind The Badge 0 0 https://www.facebook.com/Copsareheroes/ Community of people who support our brave Police Officers. 0.0 0.00 USD 2016-10-18T08:27:51-07:00  
2750 location_living_in:United States, age:45 - 64, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Veterans, people_who_match:interests:Law enforcement, and_must_also_match:interests:Police, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:The Thin Blue Line (emblem), and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:Police officer, and_must_also_match:interests:National Police Wives Association, and_must_also_match:interests:Heroes Behind The Badge 437 42 https://www.facebook.com/Copsareheroes/ Community of people who support our brave Police Officers. 8.57712 536.07 RUB 2016-10-18T08:28:10-07:00  
2759 location_living_in:United States, age:45 - 64, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Police, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Veterans, people_who_match:interests:Law enforcement, people_who_match:interests:Police officer, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:Thank a Police officer, and_must_also_match:interests:The Thin Blue Line (emblem), and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:National Police Wives Association, and_must_also_match:interests:Heroes Behind The Badge 0 0 https://www.facebook.com/copsareheroes/ BLUE LIVES MATTER !! 0.0 0.00 USD 2016-10-18T08:27:21-07:00 2016-10-13T06:09:16-07:00
2760 location_living_in:United States, age:45 - 64, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Police, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Veterans, people_who_match:interests:Law enforcement, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:Thank a Police officer, and_must_also_match:interests:The Thin Blue Line (emblem), and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:Police officer, and_must_also_match:interests:National Police V\fives Association, and_must_also_match:interests:Heroes Behind The Badge 0 0 https://www.facebook.com/copsareheroes/ BLUE LIVES MATTER !! 0.0 0.00 USD 2016-10-18T08:27:51-07:00 2016-10-13T06:09:16-07:00
2761 location_living_in:United States, age:45 - 64, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Veterans, people_who_match:interests:Law enforcement, and_must_also_match:interests:Police, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:Thank a Police officer, and_must_also_match:interests:The Thin Blue Line (emblem), and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:Police officer, and_must_also_match:interests:National Police Wives Association, and_must_also_match:interests:Heroes Behind The Badge 0 0 https://www.facebook.com/copsareheroes/ BLUE LIVES MATTER !! 0.0 0.00 USD 2016-10-18T08:28:11-07:00 2016-10-13T06:09:16-07:00
2781 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans or Supporting Our Veterans, people_who_match:interests:, politics:Likely to engage with political content (conservative), politics:Likely to engage with political content (moderate), and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 21 4 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.50448 31.53 RUB 2017-02-22T05:50:58-08:00  
2782 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 4878 274 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 30.12912 1883.07 RUB 2017-02-22T06:43:39-08:00  
2785 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 39, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-21T05:16:27-08:00  
2786 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 3186 296 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 17.279040000000002 1079.94 RUB 2017-02-21T05:17:24-08:00  
2787 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 5394 317 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 30.38864 1899.29 RUB 2017-02-22T02:24:13-08:00  
2788 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans or Supporting Our Veterans, people_who_match:interests:, politics:Likely to engage with political content (conservative), politics:Likely to engage with political content (moderate), and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-22T05:48:59-08:00  
2792 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 39, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-21T05:16:27-08:00  
2793 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 47 3 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.89776 56.11 RUB 2017-02-21T05:17:24-08:00  
2794 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-22T02:24:13-08:00  
2795 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans or Supporting Our Veterans, people_who_match:interests:, politics:Likely to engage with political content (conservative), politics:Likely to engage with political content (moderate), and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! Veterans Come First 0.0 0.00 USD 2017-02-22T05:48:59-08:00  
3392 location:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Family 147 5 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! Veterans Come First 2.36 2.36 USD 2017-03-10T01:29:58-08: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 1266.251ms · Data source: simonw/russian-ira-facebook-ads-datasette