home / russian-ads

top_targets (view)

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

1,665 rows

id name num_ads apply_this_facet category prefix
72f3e interests:Patriotism 90 ads Faceted browse interests interests
b668a excluded_connections:Exclude people who like Williams&Ka|vin 90 ads Faceted browse excluded_connections excluded_connections
ea4d7 excluded_connections:Exclude people who like Stop A.|. 86 ads Faceted browse excluded_connections excluded_connections
0b28b interests:Independence 85 ads Faceted browse interests interests
4e91f location:united_states:Ferguson, St. Louis Missouri 82 ads Faceted browse location location:united_states
72c69 location:united_states:Baltimore Maryland 82 ads Faceted browse location location:united_states
75114 location:united_states:Cleveland Ohio 82 ads Faceted browse location location:united_states
7b150 age:18 — 65+ 82 ads Faceted browse age age
4a957 people_who_match:interests:Mexican Pride 76 ads Faceted browse people_who_match people_who_match:interests
5849a people_who_match:interests:Mexican american culture 76 ads Faceted browse people_who_match people_who_match:interests
5dcb2 people_who_match:interests:Chicano 76 ads Faceted browse people_who_match people_who_match:interests
77d7e people_who_match:interests:Gun Owners of America 76 ads Faceted browse people_who_match people_who_match:interests
eab5e people_who_match:interests:Hispanic culture 73 ads Faceted browse people_who_match people_who_match:interests
37b6b interests:HuffPost Black Voices 72 ads Faceted browse interests interests
17bc7 exclude:behaviors:Hispanic (US - English dominant) 71 ads Faceted browse exclude exclude:behaviors
31177 people_who_match:interests:Social justice 71 ads Faceted browse people_who_match people_who_match:interests
95f91 exclude:behaviors:Asian American (US) 71 ads Faceted browse exclude exclude:behaviors
aa04d exclude:behaviors:Hispanic (US - Bilingual: English and Spanish) 71 ads Faceted browse exclude exclude:behaviors:Hispanic (US - Bilingual
b42a4 exclude:behaviors:Hispanic (US - All) 71 ads Faceted browse exclude exclude:behaviors
d679e exclude:behaviors:Hispanic (US - Spanish dominant) 71 ads Faceted browse exclude exclude:behaviors
1d2ab people_who_match:interests:African—American Civil Rights Movement (1954—68) 70 ads Faceted browse people_who_match people_who_match:interests
a14cf age:18 - 45 70 ads Faceted browse age age
d9d8c people_who_match:interests:Hispanic and latino american culture 70 ads Faceted browse people_who_match people_who_match:interests
022da people_who_match:People who like LGBT United 69 ads Faceted browse people_who_match people_who_match
4e13d people_who_match:Friends of connections: Friends of people who are connected to LGBT United 69 ads Faceted browse people_who_match people_who_match:Friends of connections
8b401 people_who_match:interests:Latino culture 69 ads Faceted browse people_who_match people_who_match:interests
9eadd location:united_states:Texas 67 ads Faceted browse location location:united_states
cb80d excluded_connections:Exclude people who like Defend the 2nd 67 ads Faceted browse excluded_connections excluded_connections
aabe0 interests:Black Consciousness Movement 66 ads Faceted browse interests interests
3da9b excluded_connections:Exclude people who like Pan-African roots MOVE 59 ads Faceted browse excluded_connections excluded_connections
7b676 people_who_match:Friends of connections: Friends of people who are connected to Don't Shoot 59 ads Faceted browse people_who_match people_who_match:Friends of connections
91693 people_who_match:interests:African—American culture 59 ads Faceted browse people_who_match people_who_match:interests
e650b people_who_match:People who like Don't Shoot 59 ads Faceted browse people_who_match people_who_match
f03e5 people_who_match:interests:Politics 59 ads Faceted browse people_who_match people_who_match:interests
0aa7f people_who_match:People who like Being Patriotic 58 ads Faceted browse people_who_match people_who_match
40a6c people_who_match:interests:Immigration 58 ads Faceted browse people_who_match people_who_match:interests
eb159 people_who_match:Friends of connections: Friends of people who are connected to Being Patriotic 58 ads Faceted browse people_who_match people_who_match:Friends of connections
df1f0 people_who_match:interests:African- American culture 55 ads Faceted browse people_who_match people_who_match:interests
7ceb1 interests:Cop Block 54 ads Faceted browse interests interests
9848a people_who_match:interests:African- American Civil Rights Movement (1954—68) 54 ads Faceted browse people_who_match people_who_match:interests
8d2e9 people_who_match:interests:African- American history 53 ads Faceted browse people_who_match people_who_match:interests
eaba0 interests:BlackNews.com 53 ads Faceted browse interests interests
ebcbb location_living_in:united_states:New York (+25 mi) New York 53 ads Faceted browse location_living_in location_living_in:united_states
6ec75 people_who_match:interests:2nd Amendment 52 ads Faceted browse people_who_match people_who_match:interests
9295b people_who_match:interests:Racial equality 52 ads Faceted browse people_who_match people_who_match:interests
dd761 location:united_states:Baltimore (+20 km) Maryland 52 ads Faceted browse location location:united_states
04629 interest_expansion:On 51 ads Faceted browse interest_expansion interest_expansion
1518e people_who_match:interests:Behaviors: African American (US) 51 ads Faceted browse people_who_match people_who_match:interests:Behaviors
d4179 interests:African-American culture 51 ads Faceted browse interests interests
e95f6 excluded_connections:Exclude people who like Blacktivist 51 ads Faceted browse excluded_connections excluded_connections

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW top_targets AS 
        select id, name,
            json_object(
                "href", "/russian-ads-ae17624/display_ads?_target=" || urllib_quote_plus(id),
                "label", count(*) || " ads"
            ) as num_ads,
            json_object(
                "href", "/russian-ads/faceted-targets?targets=" || urllib_quote_plus(
                    json_array(id)
                ),
                "label", "Faceted browse"
            ) as apply_this_facet,
            category, prefix
        from targets
            join ad_targets on targets.id = ad_targets.target_id
        group by ad_targets.target_id
        order by count(*) desc
Powered by Datasette · Query took 128.015ms · Data source: simonw/russian-ira-facebook-ads-datasette