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:Patriotism

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
434 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 72 4 Join the Crusade against Federal tyranny! Protect the Constitution! - 1.99696 124.81 RUB 2016-04-13T03:24:27-07:00  
441 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 15 0 It’s time for THE PEOPLE to stand for Constitutional rights! Join - 0.3992 24.95 RUB 2016-04-13T03:23:03-07:00  
443 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 34 1     0.88512 55.32 RUB 2016-04-13T03:23:43-07:00  
451 location:United States, excluded_connections:Exclude people who like Being Patriotic, 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:Independence, people_who_match:interests:Patriotism 99946 11684 https://www.facebook.com/patriototus/ United We Stand! Welcome every patriot we can reach. Flag and news! 578.5600000000001 36160.00 RUB 2016-09-15T02:50:06-07:00  
455 location:united_states:Atlanta (+50 km) Georgia, age:18 - 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 16 0 https://www.facebook.com/events/1678907209017708/ Stop federal overreach! Stand for the patriots in a protest rally in Atlanta, GA! American Crusade - Ga 0.19936 12.46 RUB 2016-04-13T03:23:42-07:00  
462 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 60 1 Join the Crusade against Federal tyranny! Protect the Constitution! _ 0.7780800000000001 48.63 RUB 2016-04-13T03:24:25-07:00  
463 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 14 0     0.17984 11.24 RUB 2016-04-13T03:24:30-07:00  
483 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 60 3     1.34416 84.01 RUB 2016-04-13T03:22:57-07:00  
486 location:united_states:Atlanta (+50 km) Georgia, 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:Veterans Day, people_who_match:interests:Patriotism 560 39     13.14128 821.33 RUB 2016-04-14T04:15:57-07:00  
487 location:united_states:Atlanta (+50 km) Georgia, 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:Veterans Day, people_who_match:interests:Patriotism 3335 171     69.82752 4364.22 RUB 2016-04-12T01:59:17-07:00  
493 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 94 4     2.37968 148.73 RUB 2016-04-13T03:24:03-07:00  
496 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 132 7     2.78288 173.93 RUB 2016-04-13T03:24:00-07:00  
501 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 78 3     1.73024 108.14 RUB 2016-04-13T03:23:39-07:00  
509 location:united_states:Atlanta (+50 km) Georgia, age:18 - 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 12 0 https://www.facebook.com/events/1678907209017708/ It’s time for THE PEOPLE to stand for Constitutional rights! Join the American Crusade! American Crusade - Ga 0.1968 12.30 RUB 2016-04-13T03:23:00-07:00  
512 location:united_states:Atlanta (+50 km) Georgia, age:18 - 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 20 0 https://www.facebook.com/events/1678907209017708/ Stand for the people not the Government! Join the rally in Atlanta this Sunday! American Crusade - Ga 0.34400000000000003 21.50 RUB 2016-04-13T03:23:58-07:00  
515 location:united_states:Atlanta (+50 km) Georgia, 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:Veterans Day, people_who_match:interests:Patriotism 636 41 Join our Rally on .Free the patriots, stand for liberty and our rights! 13.4048 837.80 RUB 2016-04-14T04:15:55-07:00  
532 location:united_states:Atlanta (+50 km) Georgia, 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:Veterans Day, people_who_match:interests:Patriotism 0 0 Join our Rally on 'Free the patriots, stand for liberty and our rights! 0.0 0.00 USD 2016-04-14T04:15:52-07:00  
533 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 6 0 Stop federal overreach! Stand for the patriots in a protest rally in Atlanta, GA! — 0.07056 4.41 RUB 2016-04-13T03:23:45-07:00  
534 location:united_states:Atlanta (+50 km) Georgia, age:18 - 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 5 0 https://www.facebook.com/events/1678907209017708/ Stand for the people not the Government! Join the rally in Atlanta this Sunday! American Crusade - Ga 0.17088 10.68 RUB 2016-04-13T03:24:02-07:00  
535 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 88 6 Join the Crusade against Federal tyranny! Protect the Constitution! _ Atlanta— 1.4168 88.55 RUB 2016-04-13T03:24:29-07:00  
536 location:united_states:Atlanta (+50 km) Georgia, age:18 — 59, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Independence, people_who_match:interests:Patriotism 4 0     0.03568 2.23 RUB 2016-04-13T03:23:02-07:00  
1936 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:ForAmerica, people_who_match:interests:Patriotism 22567 92 https://www.instagram.oom/instotus/ We are Patriots. We fight for the traditions, for the National Symbols and for the Future. If you don't like the liberal ideas and you are not the one who supports gun control, gay marriage and black lives matter activists. If America is more than just a country for you, we want you to join us! This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! Instagram Of The United Instotus 58.899680000000004 3681.23 RUB 2016-05-06T07:29:40-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

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