home / russian-ads

display_ads (view)

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

17 rows where an ad_target was people_who_match:interests:Independence

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

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