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