Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
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 |
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