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
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
862ed people_who_match:interests:Jr. 525 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
8e7b3 interests:Jr. 222 ads Faceted browse interests 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

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 439.481ms · Data source: simonw/russian-ira-facebook-ads-datasette