Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
| id | name | num_ads | apply_this_facet | category | prefix |
|---|---|---|---|---|---|
| e6200 | placements:News Feed on desktop computers | 3233 ads | Faceted browse | placements | placements |
| b1201 | placements:News Feed on mobile devices | 3217 ads | Faceted browse | placements | placements |
| 371f0 | age:18 - 65+ | 2279 ads | Faceted browse | age | age |
| 59d75 | language:English (US) | 1594 ads | Faceted browse | language | language |
| 5e075 | language:English (UK) | 1426 ads | Faceted browse | language | language |
| ec3ac | location:United States | 1353 ads | Faceted browse | location | location |
| cc5ed | location_living_in:United States | 1277 ads | Faceted browse | location_living_in | location_living_in |
| abb72 | people_who_match:interests:African-American history | 544 ads | Faceted browse | people_who_match | people_who_match:interests |
| 8a7ee | people_who_match:interests:Martin Luther King | 525 ads | Faceted browse | people_who_match | people_who_match:interests |
| a1307 | people_who_match:interests:African-American Civil Rights Movement (1954—68) | 517 ads | Faceted browse | people_who_match | people_who_match:interests |
| 27369 | people_who_match:interests:Malcolm X | 508 ads | Faceted browse | people_who_match | people_who_match:interests |
| 4801f | age:16 - 65+ | 336 ads | Faceted browse | age | age |
| 902e5 | placements:Right column on desktop computers | 335 ads | Faceted browse | placements | placements |
| e128e | people_who_match:interests:Black (Color) | 331 ads | Faceted browse | people_who_match | people_who_match:interests |
| d6ade | interests:Martin Luther King | 222 ads | Faceted browse | interests | interests |
| a0f55 | interests:Malcolm X | 221 ads | Faceted browse | interests | interests |
| d3539 | people_who_match:interests:Chicano Movement | 202 ads | Faceted browse | people_who_match | people_who_match:interests |
| 313af | interests:African-American Civil Rights Movement (1954—68) | 201 ads | Faceted browse | interests | interests |
| 3502d | placements:Instagram Feed | 199 ads | Faceted browse | placements | placements |
| 4f89e | people_who_match:interests:La Raza | 199 ads | Faceted browse | people_who_match | people_who_match:interests |
| ebe26 | interests:African-American history | 196 ads | Faceted browse | interests | interests |
| ebf60 | people_who_match:interests:Pan-Africanism | 191 ads | Faceted browse | people_who_match | people_who_match:interests |
| ffca2 | people_who_match:interests:Chicano rap | 188 ads | Faceted browse | people_who_match | people_who_match:interests |
| 007df | people_who_match:interests:Latin hip hop | 186 ads | Faceted browse | people_who_match | people_who_match:interests |
| 60626 | people_who_match:interests:Hispanidad | 186 ads | Faceted browse | people_who_match | people_who_match:interests |
| 839f9 | people_who_match:interests:Lowrider | 185 ads | Faceted browse | people_who_match | people_who_match:interests |
| 5f10e | people_who_match:interests:Mexico | 184 ads | Faceted browse | people_who_match | people_who_match:interests |
| a2d21 | people_who_match:interests:African-American culture | 171 ads | Faceted browse | people_who_match | people_who_match:interests |
| cb431 | people_who_match:People who like Black Matters | 163 ads | Faceted browse | people_who_match | people_who_match |
| d5740 | people_who_match:Friends of connections: Friends of people who are connected to Black Matters | 163 ads | Faceted browse | people_who_match | people_who_match:Friends of connections |
| 18a64 | people_who_match:interests:Black Power | 162 ads | Faceted browse | people_who_match | people_who_match:interests |
| 7c38f | people_who_match:interests:Black Panther Party | 137 ads | Faceted browse | people_who_match | people_who_match:interests |
| 7ee91 | people_who_match:interests:Cop Block | 133 ads | Faceted browse | people_who_match | people_who_match:interests |
| 1073c | interests:Black (Color) | 129 ads | Faceted browse | interests | interests |
| 6fba5 | excluded_connections:Exclude people who like Black Matters | 128 ads | Faceted browse | excluded_connections | excluded_connections |
| 1c31d | age:18 - 54 | 123 ads | Faceted browse | age | age |
| 6a38c | people_who_match:interests:Stop Police Brutality | 113 ads | Faceted browse | people_who_match | people_who_match:interests |
| 41b26 | people_who_match:interests:Black Consciousness Movement | 109 ads | Faceted browse | people_who_match | people_who_match:interests |
| bf1e7 | gender:Male | 109 ads | Faceted browse | gender | gender |
| d6347 | people_who_match:interests:Black nationalism | 108 ads | Faceted browse | people_who_match | people_who_match:interests |
| 9a8c6 | people_who_match:interests:Police misconduct | 106 ads | Faceted browse | people_who_match | people_who_match:interests |
| 2db78 | people_who_match:interests:Martin Luther King III | 103 ads | Faceted browse | people_who_match | people_who_match:interests |
| 18789 | interests:BuzzFeed | 99 ads | Faceted browse | interests | interests |
| 26bad | people_who_match:behaviors:Facebook access (browser): Chrome | 99 ads | Faceted browse | people_who_match | people_who_match:behaviors:Facebook access (browser) |
| 398aa | interests:CollegeHumor | 98 ads | Faceted browse | interests | interests |
| 49bfd | interests:9GAG | 97 ads | Faceted browse | interests | interests |
| f788a | people_who_match:interests:Black history | 96 ads | Faceted browse | people_who_match | people_who_match:interests |
| 40ff5 | behaviors:African American (US) | 94 ads | Faceted browse | behaviors | behaviors |
| 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 |
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