home / russian-ads

russian-ads

Custom SQL query returning 127 rows

select
    target_id,
    targets.name,
    count(*) as n,
    json_object(
        "href", "/russian-ads/faceted-targets?targets=" || urllib_quote_plus(
            json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
        ),
        "label", json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
    ) as apply_this_facet,
    json_object(
        "href", "/russian-ads/display_ads?_targets_json=" || urllib_quote_plus(
            json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
        ),
        "label", "See " || count(*) || " ads matching " || json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
    ) as browse_these_ads
from ad_targets
join targets on ad_targets.target_id = targets.id
where
    json_array_length(:targets) == 0 or
    ad_id in (
        select ad_id
        from "ad_targets"
        where "ad_targets".target_id in (select value from json_each(:targets))
        group by "ad_targets".ad_id
        having count(distinct "ad_targets".target_id) = json_array_length(:targets)
    )
    and target_id not in (select value from json_each(:targets))
group by
    target_id order by n desc

Query parameters

target_idnamenapply_this_facetbrowse_these_ads
b1201 placements:News Feed on mobile devices 329 ['4801f', 'b1201'] See 329 ads matching ["4801f","b1201"]
e6200 placements:News Feed on desktop computers 320 ['4801f', 'e6200'] See 320 ads matching ["4801f","e6200"]
59d75 language:English (US) 314 ['4801f', '59d75'] See 314 ads matching ["4801f","59d75"]
5e075 language:English (UK) 313 ['4801f', '5e075'] See 313 ads matching ["4801f","5e075"]
ec3ac location:United States 213 ['4801f', 'ec3ac'] See 213 ads matching ["4801f","ec3ac"]
abb72 people_who_match:interests:African-American history 164 ['4801f', 'abb72'] See 164 ads matching ["4801f","abb72"]
e128e people_who_match:interests:Black (Color) 164 ['4801f', 'e128e'] See 164 ads matching ["4801f","e128e"]
ebf60 people_who_match:interests:Pan-Africanism 152 ['4801f', 'ebf60'] See 152 ads matching ["4801f","ebf60"]
a1307 people_who_match:interests:African-American Civil Rights Movement (1954—68) 103 ['4801f', 'a1307'] See 103 ads matching ["4801f","a1307"]
18a64 people_who_match:interests:Black Power 100 ['4801f', '18a64'] See 100 ads matching ["4801f","18a64"]
41b26 people_who_match:interests:Black Consciousness Movement 94 ['4801f', '41b26'] See 94 ads matching ["4801f","41b26"]
6a38c people_who_match:interests:Stop Police Brutality 94 ['4801f', '6a38c'] See 94 ads matching ["4801f","6a38c"]
9a8c6 people_who_match:interests:Police misconduct 94 ['4801f', '9a8c6'] See 94 ads matching ["4801f","9a8c6"]
d6347 people_who_match:interests:Black nationalism 94 ['4801f', 'd6347'] See 94 ads matching ["4801f","d6347"]
2db78 people_who_match:interests:Martin Luther King III 92 ['4801f', '2db78'] See 92 ads matching ["4801f","2db78"]
7ee91 people_who_match:interests:Cop Block 90 ['4801f', '7ee91'] See 90 ads matching ["4801f","7ee91"]
7c38f people_who_match:interests:Black Panther Party 80 ['4801f', '7c38f'] See 80 ads matching ["4801f","7c38f"]
31177 people_who_match:interests:Social justice 57 ['4801f', '31177'] See 57 ads matching ["4801f","31177"]
9295b people_who_match:interests:Racial equality 51 ['4801f', '9295b'] See 51 ads matching ["4801f","9295b"]
1d2ab people_who_match:interests:African—American Civil Rights Movement (1954—68) 47 ['4801f', '1d2ab'] See 47 ads matching ["4801f","1d2ab"]
91693 people_who_match:interests:African—American culture 47 ['4801f', '91693'] See 47 ads matching ["4801f","91693"]
1073c interests:Black (Color) 45 ['4801f', '1073c'] See 45 ads matching ["4801f","1073c"]
a2d21 people_who_match:interests:African-American culture 45 ['4801f', 'a2d21'] See 45 ads matching ["4801f","a2d21"]
ebcbb location_living_in:united_states:New York (+25 mi) New York 35 ['4801f', 'ebcbb'] See 35 ads matching ["4801f","ebcbb"]
96bbd interests:Pan-Africanism 31 ['4801f', '96bbd'] See 31 ads matching ["4801f","96bbd"]
313af interests:African-American Civil Rights Movement (1954—68) 30 ['4801f', '313af'] See 30 ads matching ["4801f","313af"]
27369 people_who_match:interests:Malcolm X 25 ['4801f', '27369'] See 25 ads matching ["4801f","27369"]
862ed people_who_match:interests:Jr. 25 ['4801f', '862ed'] See 25 ads matching ["4801f","862ed"]
8a7ee people_who_match:interests:Martin Luther King 25 ['4801f', '8a7ee'] See 25 ads matching ["4801f","8a7ee"]
ebe26 interests:African-American history 25 ['4801f', 'ebe26'] See 25 ads matching ["4801f","ebe26"]
aabe0 interests:Black Consciousness Movement 24 ['4801f', 'aabe0'] See 24 ads matching ["4801f","aabe0"]
cc5ed location_living_in:United States 23 ['4801f', 'cc5ed'] See 23 ads matching ["4801f","cc5ed"]
17183 interests:Black nationalism 22 ['4801f', '17183'] See 22 ads matching ["4801f","17183"]
48e80 location:united_states:Philadelphia, Pittsburgh Pennsylvania 20 ['4801f', '48e80'] See 20 ads matching ["4801f","48e80"]
9848a people_who_match:interests:African- American Civil Rights Movement (1954—68) 20 ['4801f', '9848a'] See 20 ads matching ["4801f","9848a"]
93975 people_who_match:interests:Angela Davis 18 ['4801f', '93975'] See 18 ads matching ["4801f","93975"]
c6b59 location_living_in:united_states:Minneapolis (+25 mi) Minnesota 17 ['4801f', 'c6b59'] See 17 ads matching ["4801f","c6b59"]
3e5f6 interests:Martin Luther King III 14 ['4801f', '3e5f6'] See 14 ads matching ["4801f","3e5f6"]
3fbed people_who_match:interests:African-Amerioan history 13 ['4801f', '3fbed'] See 13 ads matching ["4801f","3fbed"]
189ac location_living_in:united_states:Charlotte (+25 mi) North Carolina 12 ['4801f', '189ac'] See 12 ads matching ["4801f","189ac"]
487f2 people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68) 12 ['4801f', '487f2'] See 12 ads matching ["4801f","487f2"]
87fac interests:Stop Police Brutality 12 ['4801f', '87fac'] See 12 ads matching ["4801f","87fac"]
902e5 placements:Right column on desktop computers 12 ['4801f', '902e5'] See 12 ads matching ["4801f","902e5"]
b322d people_who_match:interests:Pan-Afrioanism 11 ['4801f', 'b322d'] See 11 ads matching ["4801f","b322d"]
d4179 interests:African-American culture 11 ['4801f', 'd4179'] See 11 ads matching ["4801f","d4179"]
343d8 interests:African- American culture 10 ['4801f', '343d8'] See 10 ads matching ["4801f","343d8"]
550f6 interests:Police misconduct 10 ['4801f', '550f6'] See 10 ads matching ["4801f","550f6"]
bd3d9 people_who_match:interests:Black panther 10 ['4801f', 'bd3d9'] See 10 ads matching ["4801f","bd3d9"]
4accc placements:on pages: News Feed on desktop computers 9 ['4801f', '4accc'] See 9 ads matching ["4801f","4accc"]
a340a placements:Instream Video on desktop computers 8 ['4801f', 'a340a'] See 8 ads matching ["4801f","a340a"]
c3780 interests:Black is beautiful 8 ['4801f', 'c3780'] See 8 ads matching ["4801f","c3780"]
d003e placements:Instream Video on mobile devices 8 ['4801f', 'd003e'] See 8 ads matching ["4801f","d003e"]
3502d placements:Instagram Feed 7 ['4801f', '3502d'] See 7 ads matching ["4801f","3502d"]
e38cb interests:Martin Luther King ”I 7 ['4801f', 'e38cb'] See 7 ads matching ["4801f","e38cb"]
e0460 interests:African—American Civil Rights Movement (1954—68) 6 ['4801f', 'e0460'] See 6 ads matching ["4801f","e0460"]
f9cc2 interests:African- American history 6 ['4801f', 'f9cc2'] See 6 ads matching ["4801f","f9cc2"]
1518e people_who_match:interests:Behaviors: African American (US) 5 ['4801f', '1518e'] See 5 ads matching ["4801f","1518e"]
15db9 people_who_match:interests:Pan- Africanism 5 ['4801f', '15db9'] See 5 ads matching ["4801f","15db9"]
2601e location_living_in:united_states:New York New York 5 ['4801f', '2601e'] See 5 ads matching ["4801f","2601e"]
2dfbd interests:African-Amerioan Civil Rights Movement (1954—68) 5 ['4801f', '2dfbd'] See 5 ads matching ["4801f","2dfbd"]
2ed33 excluded_connections:Exclude people who like Brown Power 5 ['4801f', '2ed33'] See 5 ads matching ["4801f","2ed33"]
38705 people_who_match:interests:Black (Color) or Cop Block 5 ['4801f', '38705'] See 5 ads matching ["4801f","38705"]
4225c people_who_match:interests:African—American history 5 ['4801f', '4225c'] See 5 ads matching ["4801f","4225c"]
ad8b2 people_who_match:interests:Human rights 5 ['4801f', 'ad8b2'] See 5 ads matching ["4801f","ad8b2"]
bca17 interests:Pan-Afrioanism 5 ['4801f', 'bca17'] See 5 ads matching ["4801f","bca17"]
d2747 language:Spanish 5 ['4801f', 'd2747'] See 5 ads matching ["4801f","d2747"]
f9d07 language:Spanish (Spain) 5 ['4801f', 'f9d07'] See 5 ads matching ["4801f","f9d07"]
02db8 interests:African— American history 4 ['4801f', '02db8'] See 4 ads matching ["4801f","02db8"]
16102 interests:Human rights 4 ['4801f', '16102'] See 4 ads matching ["4801f","16102"]
1f895 interests:Culture 4 ['4801f', '1f895'] See 4 ads matching ["4801f","1f895"]
4e7f1 interests:African-Amerioan history 4 ['4801f', '4e7f1'] See 4 ads matching ["4801f","4e7f1"]
5bb13 placements:Third-party Apps and Websites on mobile devices 4 ['4801f', '5bb13'] See 4 ads matching ["4801f","5bb13"]
a5df2 interests:Slavery in the United States 4 ['4801f', 'a5df2'] See 4 ads matching ["4801f","a5df2"]
cbcce interests:Anti-discrimination 4 ['4801f', 'cbcce'] See 4 ads matching ["4801f","cbcce"]
d582c interests:Equal opportunity 4 ['4801f', 'd582c'] See 4 ads matching ["4801f","d582c"]
e9db4 interests:Justice 4 ['4801f', 'e9db4'] See 4 ads matching ["4801f","e9db4"]
8de7c interests:Angela Davis 3 ['4801f', '8de7c'] See 3 ads matching ["4801f","8de7c"]
940ef location:united_states:Houston (+50 mi) Texas 3 ['4801f', '940ef'] See 3 ads matching ["4801f","940ef"]
9e07c interests:Martin Luther King I” 3 ['4801f', '9e07c'] See 3 ads matching ["4801f","9e07c"]
afc04 interests:Pan—Africanism 3 ['4801f', 'afc04'] See 3 ads matching ["4801f","afc04"]
c4200 interests:African—American culture 3 ['4801f', 'c4200'] See 3 ads matching ["4801f","c4200"]
fed4c location_living_in:united_states:Staten Island New York 3 ['4801f', 'fed4c'] See 3 ads matching ["4801f","fed4c"]
007df people_who_match:interests:Latin hip hop 2 ['4801f', '007df'] See 2 ads matching ["4801f","007df"]
07be8 location:united_states:Atlanta (+50 mi) Georgia 2 ['4801f', '07be8'] See 2 ads matching ["4801f","07be8"]
29a48 interests:Chicano rap 2 ['4801f', '29a48'] See 2 ads matching ["4801f","29a48"]
2d239 interests:Hispanidad 2 ['4801f', '2d239'] See 2 ads matching ["4801f","2d239"]
2f752 exclude_location:united_states:Washington 2 ['4801f', '2f752'] See 2 ads matching ["4801f","2f752"]
3b9ba custom_audience:Lookalike (US, 1%) - newtestaudit 2 ['4801f', '3b9ba'] See 2 ads matching ["4801f","3b9ba"]
4c9fb location_living_in:united_states:Washington (+50 mi) District of Columbia 2 ['4801f', '4c9fb'] See 2 ads matching ["4801f","4c9fb"]
5c628 interests:African culture 2 ['4801f', '5c628'] See 2 ads matching ["4801f","5c628"]
5f10e people_who_match:interests:Mexico 2 ['4801f', '5f10e'] See 2 ads matching ["4801f","5f10e"]
60626 people_who_match:interests:Hispanidad 2 ['4801f', '60626'] See 2 ads matching ["4801f","60626"]
6e219 interests:African—American history 2 ['4801f', '6e219'] See 2 ads matching ["4801f","6e219"]
6e79b connections:People who like BM 2 ['4801f', '6e79b'] See 2 ads matching ["4801f","6e79b"]
6f57d interests:Politics and social issues 2 ['4801f', '6f57d'] See 2 ads matching ["4801f","6f57d"]
839f9 people_who_match:interests:Lowrider 2 ['4801f', '839f9'] See 2 ads matching ["4801f","839f9"]
83f98 interests:Lowrider 2 ['4801f', '83f98'] See 2 ads matching ["4801f","83f98"]
878ce interests:Nigerians 2 ['4801f', '878ce'] See 2 ads matching ["4801f","878ce"]
a56e6 and_must_also_match:interests:La Raza 2 ['4801f', 'a56e6'] See 2 ads matching ["4801f","a56e6"]
a5ab5 people_who_match:interests:African-Amerioan culture 2 ['4801f', 'a5ab5'] See 2 ads matching ["4801f","a5ab5"]
ade9f interests:End Slavery Now 2 ['4801f', 'ade9f'] See 2 ads matching ["4801f","ade9f"]
d3539 people_who_match:interests:Chicano Movement 2 ['4801f', 'd3539'] See 2 ads matching ["4801f","d3539"]
dcc45 interests:Latin hip hop 2 ['4801f', 'dcc45'] See 2 ads matching ["4801f","dcc45"]
e17ba interests:Malcolm X Memorial Foundation 2 ['4801f', 'e17ba'] See 2 ads matching ["4801f","e17ba"]
e3eda interests:Politics 2 ['4801f', 'e3eda'] See 2 ads matching ["4801f","e3eda"]
e5284 interests:Malcolm X Grassroots Movement 2 ['4801f', 'e5284'] See 2 ads matching ["4801f","e5284"]
ef21b interests:Mexico 2 ['4801f', 'ef21b'] See 2 ads matching ["4801f","ef21b"]
fd7d6 interests:Pan-Africahism 2 ['4801f', 'fd7d6'] See 2 ads matching ["4801f","fd7d6"]
ffb7e interests:Chicano Movement 2 ['4801f', 'ffb7e'] See 2 ads matching ["4801f","ffb7e"]
ffca2 people_who_match:interests:Chicano rap 2 ['4801f', 'ffca2'] See 2 ads matching ["4801f","ffca2"]
03f36 people_who_match:interests:Islam 1 ['4801f', '03f36'] See 1 ads matching ["4801f","03f36"]
086cd people_who_match:interests:Martin Luther King I” 1 ['4801f', '086cd'] See 1 ads matching ["4801f","086cd"]
1742f location_living_in:united_states:Detroit (+35 mi) Michigan 1 ['4801f', '1742f'] See 1 ads matching ["4801f","1742f"]
25df6 people_who_match:interests:Job title: Coal Miner 1 ['4801f', '25df6'] See 1 ads matching ["4801f","25df6"]
3c576 people_who_match:interests:Martin Luther King lll 1 ['4801f', '3c576'] See 1 ads matching ["4801f","3c576"]
42bf9 people_who_match:interests:Refugees of the Syrian Civil War 1 ['4801f', '42bf9'] See 1 ads matching ["4801f","42bf9"]
4de4f excluded_connections:Exclude people who like United Muslims of America 1 ['4801f', '4de4f'] See 1 ads matching ["4801f","4de4f"]
4f89e people_who_match:interests:La Raza 1 ['4801f', '4f89e'] See 1 ads matching ["4801f","4f89e"]
60170 placements:Suggested Video on desktop computers 1 ['4801f', '60170'] See 1 ads matching ["4801f","60170"]
61a62 people_who_match:interests:Manufacturing 1 ['4801f', '61a62'] See 1 ads matching ["4801f","61a62"]
7a9b5 placements:Suggested Video on mobile devices 1 ['4801f', '7a9b5'] See 1 ads matching ["4801f","7a9b5"]
ab8e0 people_who_match:interests:Donald Trump 1 ['4801f', 'ab8e0'] See 1 ads matching ["4801f","ab8e0"]
b156f people_who_match:multicultural_affinity:African American (US) 1 ['4801f', 'b156f'] See 1 ads matching ["4801f","b156f"]
c3fd0 interests:Detroit 1 ['4801f', 'c3fd0'] See 1 ads matching ["4801f","c3fd0"]
c4c8c people_who_match:interests:Syria-News 1 ['4801f', 'c4c8c'] See 1 ads matching ["4801f","c4c8c"]
ec99a people_who_match:interests:Donald Trump for President or conservative daily 1 ['4801f', 'ec99a'] See 1 ads matching ["4801f","ec99a"]
f6c6f people_who_match:interests:Syria Charity 1 ['4801f', 'f6c6f'] See 1 ads matching ["4801f","f6c6f"]
Powered by Datasette · Query took 106.053ms