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