home / russian-ads

russian-ads

Custom SQL query returning 174 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
e6200 placements:News Feed on desktop computers 102 ['bf1e7', 'e6200'] See 102 ads matching ["bf1e7","e6200"]
b1201 placements:News Feed on mobile devices 84 ['bf1e7', 'b1201'] See 84 ads matching ["bf1e7","b1201"]
371f0 age:18 - 65+ 58 ['bf1e7', '371f0'] See 58 ads matching ["bf1e7","371f0"]
cc5ed location_living_in:United States 55 ['bf1e7', 'cc5ed'] See 55 ads matching ["bf1e7","cc5ed"]
902e5 placements:Right column on desktop computers 52 ['bf1e7', '902e5'] See 52 ads matching ["bf1e7","902e5"]
59d75 language:English (US) 50 ['bf1e7', '59d75'] See 50 ads matching ["bf1e7","59d75"]
5e075 language:English (UK) 47 ['bf1e7', '5e075'] See 47 ads matching ["bf1e7","5e075"]
cb80d excluded_connections:Exclude people who like Defend the 2nd 44 ['bf1e7', 'cb80d'] See 44 ads matching ["bf1e7","cb80d"]
c1190 exclude_location:united_states:California; Illinois 40 ['bf1e7', 'c1190'] See 40 ads matching ["bf1e7","c1190"]
ec3ac location:United States 37 ['bf1e7', 'ec3ac'] See 37 ads matching ["bf1e7","ec3ac"]
77d7e people_who_match:interests:Gun Owners of America 32 ['bf1e7', '77d7e'] See 32 ads matching ["bf1e7","77d7e"]
bc1ac people_who_match:interests:Right to keep and bear arms 32 ['bf1e7', 'bc1ac'] See 32 ads matching ["bf1e7","bc1ac"]
5b456 people_who_match:interests:National Rifle Association 31 ['bf1e7', '5b456'] See 31 ads matching ["bf1e7","5b456"]
6ec75 people_who_match:interests:2nd Amendment 26 ['bf1e7', '6ec75'] See 26 ads matching ["bf1e7","6ec75"]
26bad people_who_match:behaviors:Facebook access (browser): Chrome 25 ['bf1e7', '26bad'] See 25 ads matching ["bf1e7","26bad"]
9dfd5 age:13 - 30 25 ['bf1e7', '9dfd5'] See 25 ads matching ["bf1e7","9dfd5"]
1aa29 and_must_also_match:interests:Anything About Guns 24 ['bf1e7', '1aa29'] See 24 ads matching ["bf1e7","1aa29"]
469ba people_who_match:interests:National Association for Gun Rights 24 ['bf1e7', '469ba'] See 24 ads matching ["bf1e7","469ba"]
87529 and_must_also_match:interests:Gun Rights 24 ['bf1e7', '87529'] See 24 ads matching ["bf1e7","87529"]
b0c29 and_must_also_match:interests:Guns & Patriots 20 ['bf1e7', 'b0c29'] See 20 ads matching ["bf1e7","b0c29"]
266f1 and_must_also_match:interests:Guns.com 18 ['bf1e7', '266f1'] See 18 ads matching ["bf1e7","266f1"]
658c9 and_must_also_match:interests:Free software 17 ['bf1e7', '658c9'] See 17 ads matching ["bf1e7","658c9"]
77f6e and_must_also_match:interests:free music 17 ['bf1e7', '77f6e'] See 17 ads matching ["bf1e7","77f6e"]
c46d7 people_who_match:interests:Second Amendment to the United States Constitution 16 ['bf1e7', 'c46d7'] See 16 ads matching ["bf1e7","c46d7"]
e5437 people_who_match:interests:Concealed carry in the United States 16 ['bf1e7', 'e5437'] See 16 ads matching ["bf1e7","e5437"]
b918e people_who_match:interests:The Second Amendment 15 ['bf1e7', 'b918e'] See 15 ads matching ["bf1e7","b918e"]
927de and_must_also_match:interests:2nd Amendment 14 ['bf1e7', '927de'] See 14 ads matching ["bf1e7","927de"]
c237c excluded_connections:Exclude people who like Secured Borders 12 ['bf1e7', 'c237c'] See 12 ads matching ["bf1e7","c237c"]
ed59f people_who_match:interests:dead hands 12 ['bf1e7', 'ed59f'] See 12 ads matching ["bf1e7","ed59f"]
feaa7 people_who_match:interests:Guns & Ammo 12 ['bf1e7', 'feaa7'] See 12 ads matching ["bf1e7","feaa7"]
1d7a4 and_must_also_match:interests:Guns & Weapons 10 ['bf1e7', '1d7a4'] See 10 ads matching ["bf1e7","1d7a4"]
25d0f and_must_also_match:interests:National Rifle Association 10 ['bf1e7', '25d0f'] See 10 ads matching ["bf1e7","25d0f"]
83826 people_who_match:interests:Politics: US politics (conservative) 9 ['bf1e7', '83826'] See 9 ads matching ["bf1e7","83826"]
0ce79 and_must_also_match:interests:Support Law Enforcement 8 ['bf1e7', '0ce79'] See 8 ads matching ["bf1e7","0ce79"]
2113e people_who_match:interests:Law enforcement 8 ['bf1e7', '2113e'] See 8 ads matching ["bf1e7","2113e"]
22cc9 and_must_also_match:interests:The Thin Blue Line 8 ['bf1e7', '22cc9'] See 8 ads matching ["bf1e7","22cc9"]
31a58 and_must_also_match:interests:Apple Music 8 ['bf1e7', '31a58'] See 8 ads matching ["bf1e7","31a58"]
35025 people_who_match:interests:Law enforcement in the United States 8 ['bf1e7', '35025'] See 8 ads matching ["bf1e7","35025"]
35c78 and_must_also_match:interests:Gun Owners of America 8 ['bf1e7', '35c78'] See 8 ads matching ["bf1e7","35c78"]
415bf and_must_also_match:interests:Officer Down Memorial Page 8 ['bf1e7', '415bf'] See 8 ads matching ["bf1e7","415bf"]
46d55 people_who_match:interests:Protect the Second Amendment 8 ['bf1e7', '46d55'] See 8 ads matching ["bf1e7","46d55"]
51ad1 and_must_also_match:interests:Open carry in the United States 8 ['bf1e7', '51ad1'] See 8 ads matching ["bf1e7","51ad1"]
56921 and_must_also_match:interests:Music 8 ['bf1e7', '56921'] See 8 ads matching ["bf1e7","56921"]
597b7 people_who_match:interests:Anything About Guns 8 ['bf1e7', '597b7'] See 8 ads matching ["bf1e7","597b7"]
5be59 people_who_match:interests:Guns & Ammo or From my cold 8 ['bf1e7', '5be59'] See 8 ads matching ["bf1e7","5be59"]
5f339 and_must_also_match:interests:The Thin Blue Line (emblem) 8 ['bf1e7', '5f339'] See 8 ads matching ["bf1e7","5f339"]
66d45 age:45 - 64 8 ['bf1e7', '66d45'] See 8 ads matching ["bf1e7","66d45"]
74b62 people_who_match:interests:State police 8 ['bf1e7', '74b62'] See 8 ads matching ["bf1e7","74b62"]
8123a people_who_match:interests:Stop Illegal Immigration 8 ['bf1e7', '8123a'] See 8 ads matching ["bf1e7","8123a"]
85029 age:17 - 65+ 8 ['bf1e7', '85029'] See 8 ads matching ["bf1e7","85029"]
984e7 and_must_also_match:interests:Heroes Behind The Badge 8 ['bf1e7', '984e7'] See 8 ads matching ["bf1e7","984e7"]
a40b9 and_must_also_match:interests:The Second Amendment 8 ['bf1e7', 'a40b9'] See 8 ads matching ["bf1e7","a40b9"]
b043e and_must_also_match:interests:SoundCloud 8 ['bf1e7', 'b043e'] See 8 ads matching ["bf1e7","b043e"]
b4bbb and_must_also_match:interests:Protect the Second Amendment 8 ['bf1e7', 'b4bbb'] See 8 ads matching ["bf1e7","b4bbb"]
d14f5 and_must_also_match:interests:Police Wives Unite 8 ['bf1e7', 'd14f5'] See 8 ads matching ["bf1e7","d14f5"]
d7ff4 and_must_also_match:interests:Spotify 8 ['bf1e7', 'd7ff4'] See 8 ads matching ["bf1e7","d7ff4"]
ded2a and_must_also_match:interests:ITunes 8 ['bf1e7', 'ded2a'] See 8 ads matching ["bf1e7","ded2a"]
0e9bf people_who_match:interests:Protecting Your Gun Rights 7 ['bf1e7', '0e9bf'] See 7 ads matching ["bf1e7","0e9bf"]
0f722 and_must_also_match:interests:National Police Wives Association 7 ['bf1e7', '0f722'] See 7 ads matching ["bf1e7","0f722"]
13800 age:25 - 65+ 7 ['bf1e7', '13800'] See 7 ads matching ["bf1e7","13800"]
22093 people_who_match:interests:Guns 7 ['bf1e7', '22093'] See 7 ads matching ["bf1e7","22093"]
e0e2d people_who_match:interests:& American Freedom 7 ['bf1e7', 'e0e2d'] See 7 ads matching ["bf1e7","e0e2d"]
e5ea3 location:United Kingdom, United States 7 ['bf1e7', 'e5ea3'] See 7 ads matching ["bf1e7","e5ea3"]
ea4d7 excluded_connections:Exclude people who like Stop A.|. 7 ['bf1e7', 'ea4d7'] See 7 ads matching ["bf1e7","ea4d7"]
edcd8 people_who_match:interests:God 7 ['bf1e7', 'edcd8'] See 7 ads matching ["bf1e7","edcd8"]
561d9 people_who_match:interests:Preserve our right to keep and bear arms 6 ['bf1e7', '561d9'] See 6 ads matching ["bf1e7","561d9"]
56bb6 and_must_also_match:interests:AR-15 6 ['bf1e7', '56bb6'] See 6 ads matching ["bf1e7","56bb6"]
7e7c6 people_who_match:interests:Veterans 6 ['bf1e7', '7e7c6'] See 6 ads matching ["bf1e7","7e7c6"]
afd28 people_who_match:interests:Sheriffs in the United States 6 ['bf1e7', 'afd28'] See 6 ads matching ["bf1e7","afd28"]
db8b3 people_who_match:interests:Police 6 ['bf1e7', 'db8b3'] See 6 ads matching ["bf1e7","db8b3"]
fd049 and_must_also_match:interests:Guns & Ammo 6 ['bf1e7', 'fd049'] See 6 ads matching ["bf1e7","fd049"]
4a7fd politics:US politics (conservative) 5 ['bf1e7', '4a7fd'] See 5 ads matching ["bf1e7","4a7fd"]
04182 and_must_also_match:interests:National Association for Gun Rights 4 ['bf1e7', '04182'] See 4 ads matching ["bf1e7","04182"]
17bc7 exclude:behaviors:Hispanic (US - English dominant) 4 ['bf1e7', '17bc7'] See 4 ads matching ["bf1e7","17bc7"]
1e955 people_who_match:interests:Police officer 4 ['bf1e7', '1e955'] See 4 ads matching ["bf1e7","1e955"]
1fd76 people_who_match:interests:Gun Rights 4 ['bf1e7', '1fd76'] See 4 ads matching ["bf1e7","1fd76"]
20509 exclude:behaviors:African American (US) 4 ['bf1e7', '20509'] See 4 ads matching ["bf1e7","20509"]
21405 and_must_also_match:interests:Police officer 4 ['bf1e7', '21405'] See 4 ads matching ["bf1e7","21405"]
22955 people_who_match:interests:AR-15 4 ['bf1e7', '22955'] See 4 ads matching ["bf1e7","22955"]
42fde people_who_match:interests:Second Amendment Supporters 4 ['bf1e7', '42fde'] See 4 ads matching ["bf1e7","42fde"]
48ab1 people_who_match:interests:Gun Rights or Second Amendment Supporters 4 ['bf1e7', '48ab1'] See 4 ads matching ["bf1e7","48ab1"]
88f4a people_who_match:interests:National Association for Gun Rights or From my cold 4 ['bf1e7', '88f4a'] See 4 ads matching ["bf1e7","88f4a"]
95f91 exclude:behaviors:Asian American (US) 4 ['bf1e7', '95f91'] See 4 ads matching ["bf1e7","95f91"]
a7f5a and_must_also_match:interests: 4 ['bf1e7', 'a7f5a'] See 4 ads matching ["bf1e7","a7f5a"]
aa04d exclude:behaviors:Hispanic (US - Bilingual: English and Spanish) 4 ['bf1e7', 'aa04d'] See 4 ads matching ["bf1e7","aa04d"]
b42a4 exclude:behaviors:Hispanic (US - All) 4 ['bf1e7', 'b42a4'] See 4 ads matching ["bf1e7","b42a4"]
becf5 and_must_also_match:interests:Gun Rights Across America 4 ['bf1e7', 'becf5'] See 4 ads matching ["bf1e7","becf5"]
cc9a5 and_must_also_match:interests:Thank a Police officer 4 ['bf1e7', 'cc9a5'] See 4 ads matching ["bf1e7","cc9a5"]
d679e exclude:behaviors:Hispanic (US - Spanish dominant) 4 ['bf1e7', 'd679e'] See 4 ads matching ["bf1e7","d679e"]
dbf07 and_must_also_match:interests:Right to keep and bear arms 4 ['bf1e7', 'dbf07'] See 4 ads matching ["bf1e7","dbf07"]
f478a people_who_match:interests:Guns & Weapons or Second Amendment Supporters 4 ['bf1e7', 'f478a'] See 4 ads matching ["bf1e7","f478a"]
0e564 location:united_states:Cleveland (+25 mi) Ohio 3 ['bf1e7', '0e564'] See 3 ads matching ["bf1e7","0e564"]
16ae8 location:united_states:St. Louis (+25 mi) Missouri 3 ['bf1e7', '16ae8'] See 3 ads matching ["bf1e7","16ae8"]
1da53 and_must_also_match:interests:Preserve our right to keep and bear arms 3 ['bf1e7', '1da53'] See 3 ads matching ["bf1e7","1da53"]
28463 location:united_states:Atlanta (+25 mi) Georgia 3 ['bf1e7', '28463'] See 3 ads matching ["bf1e7","28463"]
40a0a people_who_match:interests:Donald Trump for President 3 ['bf1e7', '40a0a'] See 3 ads matching ["bf1e7","40a0a"]
6b827 excluded_connections:Exclude people who like Don't Shoot 3 ['bf1e7', '6b827'] See 3 ads matching ["bf1e7","6b827"]
7ceb1 interests:Cop Block 3 ['bf1e7', '7ceb1'] See 3 ads matching ["bf1e7","7ceb1"]
858a7 people_who_match:employers:Facebook 3 ['bf1e7', '858a7'] See 3 ads matching ["bf1e7","858a7"]
9dc02 location:united_states:Baltimore (+25 mi) Maryland 3 ['bf1e7', '9dc02'] See 3 ads matching ["bf1e7","9dc02"]
9e20a and_must_also_match:interests:Citizens Committee for the Right to Keep and Bear Arms (CCRKBA) 3 ['bf1e7', '9e20a'] See 3 ads matching ["bf1e7","9e20a"]
c4902 location:united_states:New Orleans (+25 mi) Louisiana 3 ['bf1e7', 'c4902'] See 3 ads matching ["bf1e7","c4902"]
07bb3 and_must_also_match:interests:The Second Amendment or Gun Rights 2 ['bf1e7', '07bb3'] See 2 ads matching ["bf1e7","07bb3"]
09b01 and_must_also_match:interests:Concealed carry in the United States 2 ['bf1e7', '09b01'] See 2 ads matching ["bf1e7","09b01"]
0d63c and_must_also_match:interests:Open Carry Texas 2 ['bf1e7', '0d63c'] See 2 ads matching ["bf1e7","0d63c"]
384b9 location:united_states:Georgia 2 ['bf1e7', '384b9'] See 2 ads matching ["bf1e7","384b9"]
39305 and_must_also_match:interests:Preserve our right to keep and bear arms or Gun Rights 2 ['bf1e7', '39305'] See 2 ads matching ["bf1e7","39305"]
71d36 people_who_match:interests:Students for Concealed Carry 2 ['bf1e7', '71d36'] See 2 ads matching ["bf1e7","71d36"]
7b150 age:18 — 65+ 2 ['bf1e7', '7b150'] See 2 ads matching ["bf1e7","7b150"]
a1291 people_who_match:interests:Same-sex marriage 2 ['bf1e7', 'a1291'] See 2 ads matching ["bf1e7","a1291"]
a5efc people_who_match:interests:Concealed carry 2 ['bf1e7', 'a5efc'] See 2 ads matching ["bf1e7","a5efc"]
af0a7 and_must_also_match:interests:Second Amendment to the United States Constitution 2 ['bf1e7', 'af0a7'] See 2 ads matching ["bf1e7","af0a7"]
b733d location:united_states:New Mexico 2 ['bf1e7', 'b733d'] See 2 ads matching ["bf1e7","b733d"]
d5b24 and_must_also_match:interests:Police 2 ['bf1e7', 'd5b24'] See 2 ads matching ["bf1e7","d5b24"]
f6566 location:united_states:Alabama 2 ['bf1e7', 'f6566'] See 2 ads matching ["bf1e7","f6566"]
073d4 location_living_in:united_states:Waco (+39 mi) Texas 1 ['bf1e7', '073d4'] See 1 ads matching ["bf1e7","073d4"]
0f6f1 excluded_connections:Exclude people who like Angry Eagle 1 ['bf1e7', '0f6f1'] See 1 ads matching ["bf1e7","0f6f1"]
14d09 and_must_also_match:interests:Vietnam veterans america 1 ['bf1e7', '14d09'] See 1 ads matching ["bf1e7","14d09"]
17c6c people_who_match:interests:Humour 1 ['bf1e7', '17c6c'] See 1 ads matching ["bf1e7","17c6c"]
1c6ee people_who_match:industry:Veterans (US) 1 ['bf1e7', '1c6ee'] See 1 ads matching ["bf1e7","1c6ee"]
21b44 age:15 - 25 1 ['bf1e7', '21b44'] See 1 ads matching ["bf1e7","21b44"]
21f8d and_must_also_match:interests:Vietnam Veterans of America 1 ['bf1e7', '21f8d'] See 1 ads matching ["bf1e7","21f8d"]
2482b location_living_in:united_states:Temple (+35 mi) 1 ['bf1e7', '2482b'] See 1 ads matching ["bf1e7","2482b"]
269a5 and_must_also_match:interests:conservative daily 1 ['bf1e7', '269a5'] See 1 ads matching ["bf1e7","269a5"]
27a51 and_must_also_match:interests:breitbart 1 ['bf1e7', '27a51'] See 1 ads matching ["bf1e7","27a51"]
2cd21 and_must_also_match:interests:Vietnam Veterans Against the War 1 ['bf1e7', '2cd21'] See 1 ads matching ["bf1e7","2cd21"]
3502d placements:Instagram Feed 1 ['bf1e7', '3502d'] See 1 ads matching ["bf1e7","3502d"]
4704e people_who_match:interests:Funny Pics 1 ['bf1e7', '4704e'] See 1 ads matching ["bf1e7","4704e"]
546d7 interests:American Civil War reenactment 1 ['bf1e7', '546d7'] See 1 ads matching ["bf1e7","546d7"]
5eedc and_must_also_match:interests:US Military Veterans 1 ['bf1e7', '5eedc'] See 1 ads matching ["bf1e7","5eedc"]
660a5 location_living_in:united_states:Dallas (+33 mi) 1 ['bf1e7', '660a5'] See 1 ads matching ["bf1e7","660a5"]
669e2 location_living_in:united_states:Houston (+34 mi) 1 ['bf1e7', '669e2'] See 1 ads matching ["bf1e7","669e2"]
674d7 excluded_connections:Exclude people who like Memopolis 1 ['bf1e7', '674d7'] See 1 ads matching ["bf1e7","674d7"]
6a7d5 location_living_in:united_states:Abilene (+30 mi) 1 ['bf1e7', '6a7d5'] See 1 ads matching ["bf1e7","6a7d5"]
77912 and_must_also_match:interests:National Police V\fives Association 1 ['bf1e7', '77912'] See 1 ads matching ["bf1e7","77912"]
78f62 and_must_also_match:interests:Vietnam Veterans of America Foundation 1 ['bf1e7', '78f62'] See 1 ads matching ["bf1e7","78f62"]
7b958 location_living_in:united_states:Bryan (+33 mi) 1 ['bf1e7', '7b958'] See 1 ads matching ["bf1e7","7b958"]
7c883 location_recently_in:united_states:Palo Alto (+10 mi) California 1 ['bf1e7', '7c883'] See 1 ads matching ["bf1e7","7c883"]
7fc32 location_living_in:united_states:San Antonio (+28 mi) 1 ['bf1e7', '7fc32'] See 1 ads matching ["bf1e7","7fc32"]
80df1 interests:Confederate Flag 1 ['bf1e7', '80df1'] See 1 ads matching ["bf1e7","80df1"]
814aa location_living_in:united_states:San Angelo (+39 mi) 1 ['bf1e7', '814aa'] See 1 ads matching ["bf1e7","814aa"]
88d1a and_must_also_match:interests:iFunny 1 ['bf1e7', '88d1a'] See 1 ads matching ["bf1e7","88d1a"]
8f694 location_living_in:united_states:South Plains (+36 mi) 1 ['bf1e7', '8f694'] See 1 ads matching ["bf1e7","8f694"]
9590d location_living_in:united_states:Conroe (+31 mi) 1 ['bf1e7', '9590d'] See 1 ads matching ["bf1e7","9590d"]
99241 people_who_match:interests: 1 ['bf1e7', '99241'] See 1 ads matching ["bf1e7","99241"]
9d6fe location_living_in:united_states:Texas City (+35 mi) 1 ['bf1e7', '9d6fe'] See 1 ads matching ["bf1e7","9d6fe"]
a9339 and_must_also_match:interests:Disabled American Veterans 1 ['bf1e7', 'a9339'] See 1 ads matching ["bf1e7","a9339"]
a9887 and_must_also_match:interests:Vietnam Veterans Memorial Fund 1 ['bf1e7', 'a9887'] See 1 ads matching ["bf1e7","a9887"]
aff2c people_who_match:interests:Meme 1 ['bf1e7', 'aff2c'] See 1 ads matching ["bf1e7","aff2c"]
b023d location_living_in:united_states:Lubbock (+32 mi) 1 ['bf1e7', 'b023d'] See 1 ads matching ["bf1e7","b023d"]
b6fd0 excluded_connections:Exclude people who are going to Get Ready to Secedel 1 ['bf1e7', 'b6fd0'] See 1 ads matching ["bf1e7","b6fd0"]
b78bb and_must_also_match:interests:Imgur 1 ['bf1e7', 'b78bb'] See 1 ads matching ["bf1e7","b78bb"]
b7cc8 location_living_in:united_states:Gainesville (+25 mi) Florida 1 ['bf1e7', 'b7cc8'] See 1 ads matching ["bf1e7","b7cc8"]
b8f9f and_must_also_match:interests:Cracked.com 1 ['bf1e7', 'b8f9f'] See 1 ads matching ["bf1e7","b8f9f"]
c552d location_living_in:united_states:Tyler (+35 mi) 1 ['bf1e7', 'c552d'] See 1 ads matching ["bf1e7","c552d"]
c7490 location_living_in:united_states:Brownwood (+32 mi) 1 ['bf1e7', 'c7490'] See 1 ads matching ["bf1e7","c7490"]
c803f location_living_in:united_states:Corpus Christi (+31 mi) 1 ['bf1e7', 'c803f'] See 1 ads matching ["bf1e7","c803f"]
c9109 location_living_in:united_states:Amarillo (+30 mi) 1 ['bf1e7', 'c9109'] See 1 ads matching ["bf1e7","c9109"]
ca7c9 location:united_states:Palo Alto (+10 mi) California 1 ['bf1e7', 'ca7c9'] See 1 ads matching ["bf1e7","ca7c9"]
cba3e excluded_connections:Exclude people who like Veterans Come First 1 ['bf1e7', 'cba3e'] See 1 ads matching ["bf1e7","cba3e"]
cebf9 people_who_match:interests:9GAG 1 ['bf1e7', 'cebf9'] See 1 ads matching ["bf1e7","cebf9"]
d74ac location_living_in:united_states:Palo Alto (+10 mi) California 1 ['bf1e7', 'd74ac'] See 1 ads matching ["bf1e7","d74ac"]
d7bec location_living_in:united_states:Fort Worth (+33 mi) 1 ['bf1e7', 'd7bec'] See 1 ads matching ["bf1e7","d7bec"]
dfca7 people_who_match:interests:Internet meme 1 ['bf1e7', 'dfca7'] See 1 ads matching ["bf1e7","dfca7"]
e456e people_who_match:interests:BuzzFeed 1 ['bf1e7', 'e456e'] See 1 ads matching ["bf1e7","e456e"]
ecafd people_who_match:industry:Home Composition: Veterans in home 1 ['bf1e7', 'ecafd'] See 1 ads matching ["bf1e7","ecafd"]
ed665 connections:People who like Heart of Texas 1 ['bf1e7', 'ed665'] See 1 ads matching ["bf1e7","ed665"]
ee344 people_who_match:interests:The Second Amendment or Second Amendment Supporters 1 ['bf1e7', 'ee344'] See 1 ads matching ["bf1e7","ee344"]
f0980 and_must_also_match:interests:Institute for Veterans and Military Families 1 ['bf1e7', 'f0980'] See 1 ads matching ["bf1e7","f0980"]
f1655 and_must_also_match:interests:Vietnam Veterans Memorial 1 ['bf1e7', 'f1655'] See 1 ads matching ["bf1e7","f1655"]
f187d people_who_match:interests:Preserve our right to keep and bear arms or Second Amendment Supporters 1 ['bf1e7', 'f187d'] See 1 ads matching ["bf1e7","f187d"]
f5d04 location_living_in:united_states:Odessa (+33 mi) 1 ['bf1e7', 'f5d04'] See 1 ads matching ["bf1e7","f5d04"]
fb7e7 location_living_in:united_states:Beaumont (+31 mi) 1 ['bf1e7', 'fb7e7'] See 1 ads matching ["bf1e7","fb7e7"]
ff144 location_living_in:united_states:Austin (+35 mi) 1 ['bf1e7', 'ff144'] See 1 ads matching ["bf1e7","ff144"]
Powered by Datasette · Query took 46.46ms