home / russian-ads

russian-ads

Custom SQL query returning 147 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 143 ['18a64', 'b1201'] See 143 ads matching ["18a64","b1201"]
e6200 placements:News Feed on desktop computers 135 ['18a64', 'e6200'] See 135 ads matching ["18a64","e6200"]
7c38f people_who_match:interests:Black Panther Party 134 ['18a64', '7c38f'] See 134 ads matching ["18a64","7c38f"]
59d75 language:English (US) 124 ['18a64', '59d75'] See 124 ads matching ["18a64","59d75"]
5e075 language:English (UK) 115 ['18a64', '5e075'] See 115 ads matching ["18a64","5e075"]
7ee91 people_who_match:interests:Cop Block 101 ['18a64', '7ee91'] See 101 ads matching ["18a64","7ee91"]
4801f age:16 - 65+ 100 ['18a64', '4801f'] See 100 ads matching ["18a64","4801f"]
27369 people_who_match:interests:Malcolm X 67 ['18a64', '27369'] See 67 ads matching ["18a64","27369"]
862ed people_who_match:interests:Jr. 66 ['18a64', '862ed'] See 66 ads matching ["18a64","862ed"]
8a7ee people_who_match:interests:Martin Luther King 66 ['18a64', '8a7ee'] See 66 ads matching ["18a64","8a7ee"]
abb72 people_who_match:interests:African-American history 52 ['18a64', 'abb72'] See 52 ads matching ["18a64","abb72"]
31177 people_who_match:interests:Social justice 51 ['18a64', '31177'] See 51 ads matching ["18a64","31177"]
9295b people_who_match:interests:Racial equality 51 ['18a64', '9295b'] See 51 ads matching ["18a64","9295b"]
ebcbb location_living_in:united_states:New York (+25 mi) New York 51 ['18a64', 'ebcbb'] See 51 ads matching ["18a64","ebcbb"]
93975 people_who_match:interests:Angela Davis 49 ['18a64', '93975'] See 49 ads matching ["18a64","93975"]
371f0 age:18 - 65+ 42 ['18a64', '371f0'] See 42 ads matching ["18a64","371f0"]
f788a people_who_match:interests:Black history 38 ['18a64', 'f788a'] See 38 ads matching ["18a64","f788a"]
809af people_who_match:interests:Black History Month 35 ['18a64', '809af'] See 35 ads matching ["18a64","809af"]
e128e people_who_match:interests:Black (Color) 35 ['18a64', 'e128e'] See 35 ads matching ["18a64","e128e"]
a1307 people_who_match:interests:African-American Civil Rights Movement (1954—68) 33 ['18a64', 'a1307'] See 33 ads matching ["18a64","a1307"]
01e8a and_must_also_match:interests:Right of self—defense 31 ['18a64', '01e8a'] See 31 ads matching ["18a64","01e8a"]
2aa57 and_must_also_match:interests:Self Defense Family 31 ['18a64', '2aa57'] See 31 ads matching ["18a64","2aa57"]
425d7 and_must_also_match:interests:Active Self Protection 31 ['18a64', '425d7'] See 31 ads matching ["18a64","425d7"]
66f82 people_who_match:interests:African American 31 ['18a64', '66f82'] See 31 ads matching ["18a64","66f82"]
724f8 and_must_also_match:interests:The Women's Self Defense Institute 31 ['18a64', '724f8'] See 31 ads matching ["18a64","724f8"]
7c580 and_must_also_match:interests:Martial arts 31 ['18a64', '7c580'] See 31 ads matching ["18a64","7c580"]
8b0bf and_must_also_match:interests:Personal Defense 31 ['18a64', '8b0bf'] See 31 ads matching ["18a64","8b0bf"]
9c206 and_must_also_match:interests:Mixed martial arts 31 ['18a64', '9c206'] See 31 ads matching ["18a64","9c206"]
b6f60 and_must_also_match:interests:PERSONAL & HOME DEFENSE 31 ['18a64', 'b6f60'] See 31 ads matching ["18a64","b6f60"]
cc5ed location_living_in:United States 31 ['18a64', 'cc5ed'] See 31 ads matching ["18a64","cc5ed"]
ebf60 people_who_match:interests:Pan-Africanism 27 ['18a64', 'ebf60'] See 27 ads matching ["18a64","ebf60"]
06d39 and_must_also_match:interests:SeIf-defense 25 ['18a64', '06d39'] See 25 ads matching ["18a64","06d39"]
2ab82 and_must_also_match:interests:Self- defense (United States) 24 ['18a64', '2ab82'] See 24 ads matching ["18a64","2ab82"]
9848a people_who_match:interests:African- American Civil Rights Movement (1954—68) 21 ['18a64', '9848a'] See 21 ads matching ["18a64","9848a"]
3502d placements:Instagram Feed 19 ['18a64', '3502d'] See 19 ads matching ["18a64","3502d"]
37724 people_who_match:interests:Self Defense Family 19 ['18a64', '37724'] See 19 ads matching ["18a64","37724"]
48e80 location:united_states:Philadelphia, Pittsburgh Pennsylvania 19 ['18a64', '48e80'] See 19 ads matching ["18a64","48e80"]
80def people_who_match:interests:The Self Defense Company 19 ['18a64', '80def'] See 19 ads matching ["18a64","80def"]
d5ec6 people_who_match:interests:Martial arts 19 ['18a64', 'd5ec6'] See 19 ads matching ["18a64","d5ec6"]
c6b59 location_living_in:united_states:Minneapolis (+25 mi) Minnesota 17 ['18a64', 'c6b59'] See 17 ads matching ["18a64","c6b59"]
a2d21 people_who_match:interests:African-American culture 16 ['18a64', 'a2d21'] See 16 ads matching ["18a64","a2d21"]
7b150 age:18 — 65+ 12 ['18a64', '7b150'] See 12 ads matching ["18a64","7b150"]
902e5 placements:Right column on desktop computers 12 ['18a64', '902e5'] See 12 ads matching ["18a64","902e5"]
2ce65 people_who_match:interests:Black is beautiful 10 ['18a64', '2ce65'] See 10 ads matching ["18a64","2ce65"]
bd3d9 people_who_match:interests:Black panther 10 ['18a64', 'bd3d9'] See 10 ads matching ["18a64","bd3d9"]
ec3ac location:United States 9 ['18a64', 'ec3ac'] See 9 ads matching ["18a64","ec3ac"]
4accc placements:on pages: News Feed on desktop computers 8 ['18a64', '4accc'] See 8 ads matching ["18a64","4accc"]
a340a placements:Instream Video on desktop computers 8 ['18a64', 'a340a'] See 8 ads matching ["18a64","a340a"]
d003e placements:Instream Video on mobile devices 8 ['18a64', 'd003e'] See 8 ads matching ["18a64","d003e"]
d65e1 people_who_match:interests:Fight the Power 8 ['18a64', 'd65e1'] See 8 ads matching ["18a64","d65e1"]
df1f0 people_who_match:interests:African- American culture 8 ['18a64', 'df1f0'] See 8 ads matching ["18a64","df1f0"]
13ab6 people_who_match:interests:Pan—Africanism 7 ['18a64', '13ab6'] See 7 ads matching ["18a64","13ab6"]
d1aa5 people_who_match:interests:My Black is Beautiful 7 ['18a64', 'd1aa5'] See 7 ads matching ["18a64","d1aa5"]
1518e people_who_match:interests:Behaviors: African American (US) 6 ['18a64', '1518e'] See 6 ads matching ["18a64","1518e"]
39ce1 and_must_also_match:interests:Self— defense (United States) 6 ['18a64', '39ce1'] See 6 ads matching ["18a64","39ce1"]
6d811 and_must_also_match:interests:SeIf—defense 6 ['18a64', '6d811'] See 6 ads matching ["18a64","6d811"]
15db9 people_who_match:interests:Pan- Africanism 5 ['18a64', '15db9'] See 5 ads matching ["18a64","15db9"]
189ac location_living_in:united_states:Charlotte (+25 mi) North Carolina 5 ['18a64', '189ac'] See 5 ads matching ["18a64","189ac"]
38705 people_who_match:interests:Black (Color) or Cop Block 5 ['18a64', '38705'] See 5 ads matching ["18a64","38705"]
4225c people_who_match:interests:African—American history 5 ['18a64', '4225c'] See 5 ads matching ["18a64","4225c"]
ad8b2 people_who_match:interests:Human rights 5 ['18a64', 'ad8b2'] See 5 ads matching ["18a64","ad8b2"]
d2749 people_who_match:interests:African— American culture 5 ['18a64', 'd2749'] See 5 ads matching ["18a64","d2749"]
1d2ab people_who_match:interests:African—American Civil Rights Movement (1954—68) 4 ['18a64', '1d2ab'] See 4 ads matching ["18a64","1d2ab"]
4f515 location_living_in:united_states:Long Beach (+25 mi) California 4 ['18a64', '4f515'] See 4 ads matching ["18a64","4f515"]
94bdc people_who_match:interests:Multicultural Affinity: African American (US) 4 ['18a64', '94bdc'] See 4 ads matching ["18a64","94bdc"]
04e82 people_who_match:interests:Malcolm X or Black (Color) 3 ['18a64', '04e82'] See 3 ads matching ["18a64","04e82"]
3da9b excluded_connections:Exclude people who like Pan-African roots MOVE 3 ['18a64', '3da9b'] See 3 ads matching ["18a64","3da9b"]
41b26 people_who_match:interests:Black Consciousness Movement 3 ['18a64', '41b26'] See 3 ads matching ["18a64","41b26"]
4e97e location_living_in:united_states:Atlanta (+25 mi) Georgia 3 ['18a64', '4e97e'] See 3 ads matching ["18a64","4e97e"]
5ea35 people_who_match:interests:Black Arts Movement 3 ['18a64', '5ea35'] See 3 ads matching ["18a64","5ea35"]
6f328 people_who_match:interests:Afrocentrism 3 ['18a64', '6f328'] See 3 ads matching ["18a64","6f328"]
940ef location:united_states:Houston (+50 mi) Texas 3 ['18a64', '940ef'] See 3 ads matching ["18a64","940ef"]
9c17e location_living_in:united_states:Lansing (+25 mi) Michigan 3 ['18a64', '9c17e'] See 3 ads matching ["18a64","9c17e"]
a5ab5 people_who_match:interests:African-Amerioan culture 3 ['18a64', 'a5ab5'] See 3 ads matching ["18a64","a5ab5"]
a8e8b location:united_states:Astoria (+25 mi) New York 3 ['18a64', 'a8e8b'] See 3 ads matching ["18a64","a8e8b"]
d6347 people_who_match:interests:Black nationalism 3 ['18a64', 'd6347'] See 3 ads matching ["18a64","d6347"]
07be8 location:united_states:Atlanta (+50 mi) Georgia 2 ['18a64', '07be8'] See 2 ads matching ["18a64","07be8"]
1f9d8 location_living_in:united_states:Connecticut; Maryland; Massachusetts; New Jersey; New York; Pennsylvania; Vermont 2 ['18a64', '1f9d8'] See 2 ads matching ["18a64","1f9d8"]
3fbed people_who_match:interests:African-Amerioan history 2 ['18a64', '3fbed'] See 2 ads matching ["18a64","3fbed"]
65f5f people_who_match:interests:Afrocentric education 2 ['18a64', '65f5f'] See 2 ads matching ["18a64","65f5f"]
6a05f people_who_match:interests:New Black Panther Party 2 ['18a64', '6a05f'] See 2 ads matching ["18a64","6a05f"]
6b1c5 location_living_in:united_states:Astoria (+50 mi) New York 2 ['18a64', '6b1c5'] See 2 ads matching ["18a64","6b1c5"]
72a45 people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz) 2 ['18a64', '72a45'] See 2 ads matching ["18a64","72a45"]
7746b people_who_match:interests:Black Girls Rock! 2 ['18a64', '7746b'] See 2 ads matching ["18a64","7746b"]
91693 people_who_match:interests:African—American culture 2 ['18a64', '91693'] See 2 ads matching ["18a64","91693"]
c4d21 location_living_in:united_states:Orlando (+50 mi) Florida 2 ['18a64', 'c4d21'] See 2 ads matching ["18a64","c4d21"]
da17a people_who_match:interests:Melanin 2 ['18a64', 'da17a'] See 2 ads matching ["18a64","da17a"]
e42ca people_who_match:interests:Slavery by Another Name 2 ['18a64', 'e42ca'] See 2 ads matching ["18a64","e42ca"]
014b0 age:13 — 65+ 1 ['18a64', '014b0'] See 1 ads matching ["18a64","014b0"]
045ef location:united_states:Louisiana 1 ['18a64', '045ef'] See 1 ads matching ["18a64","045ef"]
15228 and_must_also_match:interests:Pan-African colours 1 ['18a64', '15228'] See 1 ads matching ["18a64","15228"]
1d380 age:18 - 43 1 ['18a64', '1d380'] See 1 ads matching ["18a64","1d380"]
1e076 and_must_also_match:interests:Kemetism 1 ['18a64', '1e076'] See 1 ads matching ["18a64","1e076"]
203d9 age:13 - 6O 1 ['18a64', '203d9'] See 1 ads matching ["18a64","203d9"]
225c8 people_who_match:interests:Baptism 1 ['18a64', '225c8'] See 1 ads matching ["18a64","225c8"]
23e78 and_must_also_match:interests:Kwame Nkrumah 1 ['18a64', '23e78'] See 1 ads matching ["18a64","23e78"]
23f8e and_must_also_match:interests:Afrocentrism 1 ['18a64', '23f8e'] See 1 ads matching ["18a64","23f8e"]
27335 excluded_connections:Exclude people who like Woke Blacks 1 ['18a64', '27335'] See 1 ads matching ["18a64","27335"]
2d05d location_living_in:united_states:Alabama; Florida; Georgia; Illinois; Louisiana; Mississippi; New York; South Carolina; Virginia 1 ['18a64', '2d05d'] See 1 ads matching ["18a64","2d05d"]
302cc people_who_match:interests:Black Girls Rock! or HuffPost Black Voices 1 ['18a64', '302cc'] See 1 ads matching ["18a64","302cc"]
384b9 location:united_states:Georgia 1 ['18a64', '384b9'] See 1 ads matching ["18a64","384b9"]
3eb1f people_who_match:interests:Black Church 1 ['18a64', '3eb1f'] See 1 ads matching ["18a64","3eb1f"]
3f884 and_must_also_match:interests:South Africa 1 ['18a64', '3f884'] See 1 ads matching ["18a64","3f884"]
4511e location:united_states:Cleveland (+34 mi) Ohio 1 ['18a64', '4511e'] See 1 ads matching ["18a64","4511e"]
49b74 location:united_states:Florida 1 ['18a64', '49b74'] See 1 ads matching ["18a64","49b74"]
49bb7 and_must_also_match:interests:Hotep 1 ['18a64', '49bb7'] See 1 ads matching ["18a64","49bb7"]
4a08c age:16 - 45 1 ['18a64', '4a08c'] See 1 ads matching ["18a64","4a08c"]
54d8d and_must_also_match:interests:Nelson Mandela 1 ['18a64', '54d8d'] See 1 ads matching ["18a64","54d8d"]
564d4 and_must_also_match:interests:Personal Defense Network 1 ['18a64', '564d4'] See 1 ads matching ["18a64","564d4"]
57006 location:united_states:New York 1 ['18a64', '57006'] See 1 ads matching ["18a64","57006"]
5b77d people_who_match:interests:Prayer 1 ['18a64', '5b77d'] See 1 ads matching ["18a64","5b77d"]
6060b excluded_connections:Exclude people who like BIack_Baptist_church 1 ['18a64', '6060b'] See 1 ads matching ["18a64","6060b"]
61c1a age:18 - 50 1 ['18a64', '61c1a'] See 1 ads matching ["18a64","61c1a"]
64dc9 and_must_also_match:interests:Marcus Garvey 1 ['18a64', '64dc9'] See 1 ads matching ["18a64","64dc9"]
65b27 location:united_states:Cleveland (+40 km) Ohio 1 ['18a64', '65b27'] See 1 ads matching ["18a64","65b27"]
711dd location:united_states:Chicago (+40 km) Illinois 1 ['18a64', '711dd'] See 1 ads matching ["18a64","711dd"]
762c9 and_must_also_match:interests:The Self Defense Company 1 ['18a64', '762c9'] See 1 ads matching ["18a64","762c9"]
77050 people_who_match:interests:African Methodist Episcopal Church 1 ['18a64', '77050'] See 1 ads matching ["18a64","77050"]
7f1e9 age:16 - 60 1 ['18a64', '7f1e9'] See 1 ads matching ["18a64","7f1e9"]
838d3 people_who_match:interests:Faith 1 ['18a64', '838d3'] See 1 ads matching ["18a64","838d3"]
85186 people_who_match:interests:Traditional black gospel 1 ['18a64', '85186'] See 1 ads matching ["18a64","85186"]
89dda age:13 - 60 1 ['18a64', '89dda'] See 1 ads matching ["18a64","89dda"]
8eeb0 x_field_of_study:African-American history 1 ['18a64', '8eeb0'] See 1 ads matching ["18a64","8eeb0"]
99464 and_must_also_match:interests:Safety 1 ['18a64', '99464'] See 1 ads matching ["18a64","99464"]
9eb05 people_who_match:interests:Bible 1 ['18a64', '9eb05'] See 1 ads matching ["18a64","9eb05"]
aaf5a age:18 - 51 1 ['18a64', 'aaf5a'] See 1 ads matching ["18a64","aaf5a"]
ac76f location_living_in:united_states:New York 1 ['18a64', 'ac76f'] See 1 ads matching ["18a64","ac76f"]
ac7e2 location:united_states:Baltimore (+40 km) Maryland 1 ['18a64', 'ac7e2'] See 1 ads matching ["18a64","ac7e2"]
b5c9f and_must_also_match:interests:Nigeria 1 ['18a64', 'b5c9f'] See 1 ads matching ["18a64","b5c9f"]
b8132 girls_rock_behaviors:Field of study: African- American history 1 ['18a64', 'b8132'] See 1 ads matching ["18a64","b8132"]
bd0bb people_who_match:interests:Worship 1 ['18a64', 'bd0bb'] See 1 ads matching ["18a64","bd0bb"]
c2b64 and_must_also_match:interests:SeIf-defense (United States) 1 ['18a64', 'c2b64'] See 1 ads matching ["18a64","c2b64"]
c3801 people_who_match:interests:Black 1 ['18a64', 'c3801'] See 1 ads matching ["18a64","c3801"]
ca0eb location:united_states:Baton Rouge (+40 km) Louisiana 1 ['18a64', 'ca0eb'] See 1 ads matching ["18a64","ca0eb"]
ced33 people_who_match:interests:Malcolm 1 ['18a64', 'ced33'] See 1 ads matching ["18a64","ced33"]
cf4f6 people_who_match:interests:Christianity 1 ['18a64', 'cf4f6'] See 1 ads matching ["18a64","cf4f6"]
d27ad and_must_also_match:interests:martial arts and self defense 1 ['18a64', 'd27ad'] See 1 ads matching ["18a64","d27ad"]
d75c0 people_who_match:interests:HuffPost Black Voices 1 ['18a64', 'd75c0'] See 1 ads matching ["18a64","d75c0"]
ddd45 people_who_match:interests:The African History Network 1 ['18a64', 'ddd45'] See 1 ads matching ["18a64","ddd45"]
e0435 location:united_states:Minnesota 1 ['18a64', 'e0435'] See 1 ads matching ["18a64","e0435"]
e4b8e people_who_match:interests:Gospel 1 ['18a64', 'e4b8e'] See 1 ads matching ["18a64","e4b8e"]
ecfcb girls_rock_behaviors:African American (US) 1 ['18a64', 'ecfcb'] See 1 ads matching ["18a64","ecfcb"]
edcd8 people_who_match:interests:God 1 ['18a64', 'edcd8'] See 1 ads matching ["18a64","edcd8"]
f32e5 people_who_match:interests:Pan-Africahism 1 ['18a64', 'f32e5'] See 1 ads matching ["18a64","f32e5"]
f431c people_who_match:interests:African— American history 1 ['18a64', 'f431c'] See 1 ads matching ["18a64","f431c"]
f6f14 people_who_match:interests:Christian Church 1 ['18a64', 'f6f14'] See 1 ads matching ["18a64","f6f14"]
fec0a people_who_match:interests:Huey P. Newton or Malcolm X 1 ['18a64', 'fec0a'] See 1 ads matching ["18a64","fec0a"]
Powered by Datasette · Query took 62.989ms