Skip to content

Instantly share code, notes, and snippets.

@jbaldivieso

jbaldivieso/gist:4515013

Created January 11, 2013 23:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jbaldivieso/4515013 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jbaldivieso/4515013 to your computer and use it in GitHub Desktop.
Download ZIP
Zip codes for big cities
Raw
gistfile1.txt
CITIES = [
# "newyork":
"10453", "10457", "10460", "10458", "10467", "10468", "10451",
"10452", "10456", "10454", "10455", "10459", "10474", "10463", "10471",
"10466", "10469", "10470", "10475", "10461", "10462", "10464", "10465",
"10472", "10473", "11212", "11213", "11216", "11233", "11238", "11209",
"11214", "11228", "11204", "11218", "11219", "11230", "11234", "11236",
"11239", "11223", "11224", "11229", "11235", "11201", "11205", "11215",
"11217", "11231", "11203", "11210", "11225", "11226", "11207", "11208",
"11211", "11222", "11220", "11232", "11206", "11221", "11237", "10026",
"10027", "10030", "10037", "10039", "10001", "10011", "10018", "10019",
"10020", "10036", "10029", "10035", "10010", "10016", "10017", "10022",
"10012", "10013", "10014", "10004", "10005", "10006", "10007", "10038",
"10280", "10002", "10003", "10009", "10021", "10028", "10044", "10128",
"10023", "10024", "10025", "10031", "10032", "10033", "10034", "10040",
"11361", "11362", "11363", "11364", "11354", "11355", "11356", "11357",
"11358", "11359", "11360", "11365", "11366", "11367", "11412", "11423",
"11432", "11433", "11434", "11435", "11436", "11101", "11102", "11103",
"11104", "11105", "11106", "11374", "11375", "11379", "11385", "11691",
"11692", "11693", "11694", "11695", "11697", "11004", "11005", "11411",
"11413", "11422", "11426", "11427", "11428", "11429", "11414", "11415",
"11416", "11417", "11418", "11419", "11420", "11421", "11368", "11369",
"11370", "11372", "11373", "11377", "11378", "10302", "10303", "10310",
"10306", "10307", "10308", "10309", "10312", "10301", "10304", "10305",
"10314",
# seattle:
"98105", "98124", "98121", "98112", "98127", "98102", "98154", "98195",
"98119", "98032", "98168", "98158", "98166", "98107", "98126", "98118",
"98116", "98177", "98188", "98144", "98109", "98199", "98115", "98125",
"98122", "98198", "98104", "98134", "98136", "98117", "98161", "98178",
"98103", "98146", "98155", "98106", "98133", "98164", "98108", "98101",
"98148",
# los angeles:
"90034", "90056", "90021", "90057", "90095", "90277", "90048", "90003",
"90037", "90089", "90033", "90061", "90035", "90045", "90040", "90019",
"90017", "90031", "90028", "90007", "90049", "90004", "90058", "90024",
"90063", "90038", "90044", "90002", "90292", "90069", "90071", "90046",
"90025", "90064", "90001", "90041", "90066", "90018", "90023", "90291",
"90032", "90026", "90006", "90047", "90079", "90014", "90011", "90013",
"90245", "90062", "90015", "90036", "90022", "90211", "90010", "90068",
"90230", "90020", "90077", "91604", "90008", "90042", "90059", "90067",
"90005", "90232", "90029", "90065", "90016", "90012", "90043", "90027",
"90039",
#"chicago":
"60601", "60602", "60603", "60604", "60605", "60606", "60607",
"60608", "60609", "60610", "60611", "60612", "60613", "60614", "60615",
"60616", "60617", "60618", "60619", "60620", "60621", "60622", "60623",
"60624", "60625", "60626", "60628", "60629", "60630", "60631", "60632",
"60633", "60634", "60636", "60637", "60638", "60639", "60640", "60641",
"60643", "60644", "60645", "60646", "60647", "60649", "60651", "60652",
"60653", "60654", "60655", "60656", "60657", "60659", "60660", "60661",
"60663", "60664", "60665", "60667", "60668", "60669", "60670", "60671",
"60672", "60673", "60674", "60675", "60677", "60678", "60679", "60680",
"60681", "60683", "60684", "60685", "60687", "60688", "60690", "60691",
"60693", "60694", "60696", "60697", "60699", "60701",
# "sanfrancisco":
"94102", "94103", "94104", "94105", "94107", "94108",
"94109", "94110", "94111", "94112", "94114", "94115", "94116", "94117",
"94118", "94119", "94120", "94121", "94122", "94123", "94124", "94125",
"94126", "94127", "94128", "94129", "94130", "94131", "94132", "94133",
"94134", "94137", "94139", "94140", "94141", "94142", "94143", "94144",
"94145", "94146", "94147", "94151", "94153", "94154", "94156", "94158",
"94159", "94160", "94161", "94162", "94163", "94164", "94171", "94172",
"94177", "94188",
# "portland":
"97201", "97202", "97203", "97204", "97205", "97206", "97207",
"97208", "97209", "97210", "97211", "97212", "97213", "97214", "97215",
"97216", "97217", "97218", "97219", "97220", "97221", "97222", "97223",
"97224", "97225", "97227", "97228", "97229", "97230", "97231", "97232",
"97233", "97236", "97238", "97240", "97242", "97251", "97253", "97254",
"97255", "97256", "97258", "97259", "97266", "97267", "97268", "97269",
"97271", "97272", "97280", "97281", "97282", "97283", "97286", "97290",
"97291", "97292", "97293", "97294", "97296", "97298", "97299",
# "boston":
"02101", "02102", "02103", "02104", "02105", "02106", "02107",
"02108", "02109", "02110", "02111", "02112", "02113", "02114", "02115",
"02116", "02117", "02118", "02119", "02120", "02121", "02122", "02123",
"02124", "02125", "02127", "02128", "02133", "02163", "02196", "02199",
"02201", "02202", "02203", "02204", "02205", "02206", "02207", "02208",
"02209", "02210", "02211", "02212", "02215", "02216", "02217", "02222",
"02241", "02266", "02283", "02284", "02293", "02295", "02297",
#"philadelphia":
"19019", "19092", "19093", "19099", "19101", "19102",
"19103", "19104", "19105", "19106", "19107", "19108", "19109", "19110",
"19111", "19112", "19113", "19114", "19115", "19116", "19118", "19119",
"19120", "19121", "19122", "19123", "19124", "19125", "19126", "19127",
"19128", "19129", "19130", "19131", "19132", "19133", "19134", "19135",
"19136", "19137", "19138", "19139", "19140", "19141", "19142", "19143",
"19144", "19145", "19146", "19147", "19148", "19149", "19150", "19151",
"19152", "19153", "19154", "19155", "19160", "19161", "19162", "19170",
"19171", "19172", "19173", "19175", "19177", "19178", "19179", "19181",
"19182", "19183", "19184", "19185", "19187", "19188", "19191", "19192",
"19193", "19194", "19196", "19197", "19244", "19255",
# "austin":
"73301", "73344", "78701", "78702", "78703", "78704", "78705",
"78708", "78709", "78710", "78711", "78712", "78713", "78714", "78715",
"78716", "78717", "78718", "78719", "78720", "78721", "78722", "78723",
"78724", "78725", "78726", "78727", "78728", "78729", "78730", "78731",
"78732", "78733", "78734", "78735", "78736", "78737", "78738", "78739",
"78741", "78742", "78744", "78745", "78746", "78747", "78748", "78749",
"78750", "78751", "78752", "78753", "78754", "78755", "78756", "78757",
"78758", "78759", "78760", "78761", "78762", "78763", "78764", "78765",
"78766", "78767", "78768", "78769", "78772", "78773", "78774", "78778",
"78779", "78780", "78781", "78783", "78785", "78786", "78788", "78789",
"78799",
]
# these are zip codes from the list above that we don't have Yelp data for
# AND we don't have Single Platform data (really don't care about the Yelp
# side of things, but that's a way of simplifying the queries)
dont_care_about = [
'10044', '11359', '11695', '98124', '60663', '60665', '60667', '60668',
'60669', '60670', '60671', '60672', '60673', '60674', '60675', '60677',
'60679', '60680', '60681', '60683', '60684', '60685', '60687', '60688',
'60690', '60691', '60693', '60694', '60696', '60697', '60699', '60701',
'94126', '94137', '94139', '94140', '94141', '94142', '94144', '94145',
'94146', '94151', '94153', '94156', '94159', '94160', '94161', '94162',
'94163', '94164', '94171', '94172', '94177', '94188', '97207', '97208',
'97228', '97238', '97242', '97251', '97254', '97256', '97259', '97268',
'97269', '97271', '97272', '97280', '97281', '97282', '97283', '97286',
'97290', '97291', '97292', '97293', '97294', '97296', '97298', '97299',
'02101', '02102', '02103', '02104', '02105', '02106', '02107', '02112',
'02117', '02123', '02133', '02163', '02196', '02202', '02204', '02205',
'02206', '02207', '02208', '02209', '02211', '02212', '02217', '02222',
'02241', '02266', '02283', '02284', '02293', '02295', '02297', '19092',
'19093', '19099', '19105', '19108', '19110', '19155', '19160', '19161',
'19162', '19170', '19171', '19172', '19173', '19175', '19177', '19178',
'19179', '19181', '19182', '19183', '19184', '19185', '19187', '19188',
'19191', '19192', '19193', '19194', '19196', '19197', '19244', '19255',
'73301', '73344', '78708', '78709', '78710', '78714', '78715', '78716',
'78718', '78720', '78725', '78755', '78760', '78762', '78763', '78765',
'78766', '78767', '78768', '78769', '78773', '78774', '78778', '78779',
'78780', '78781', '78783', '78785', '78786', '78788', '78789',
]
CITIES = [z for z in CITIES if z not in dont_care_about]
NEW_CITIES = [
#Houston | 1665
"77057", "77033", "77051", "77379", "77039", "77055", "77071", "77072",
"77044", "77003", "77054", "77096", "77083", "77093", "77060", "77095",
"77040", "77005", "77059", "77034", "77024", "77022", "77074", "77269",
"77063", "77041", "77020", "77068", "77070", "77098", "77082", "77099",
"77205", "77046", "77027", "77015", "77045", "77086", "38851", "77008",
"77013", "77085", "77061", "77006", "77089", "77069", "77209", "77018",
"77049", "77028", "77017", "77346", "77079", "77081", "77025", "15342",
"77091", "77043", "77032", "65483", "77053", "77064", "77204", "77062",
"77092", "77010", "77094", "77014", "77050", "77035", "77078", "77080",
"77056", "77030", "77073", "77031", "77019", "77088", "77087", "77002",
"77023", "77076", "77065", "77009", "77007", "77029", "77084", "77012",
"77037", "77042", "77058", "77385", "77036", "77001", "77077", "77067",
"77004", "77598", "77090", "77075",
#Brooklyn | 1288 (only 7 of these haven't already been dealt with)
"11215", "11225", "11233", "11239", "11230", "11209", "11220", "11226",
"11238", "11203", "11216", "49230", "11236", "11210", "11237", "11228",
"11249", "11221", "11222", "11219", "06234", "10009", "11377", "11231",
"11218", "11208", "11229", "11224", "11214", "11232", "11207", "11235",
"11204", "11205", "11202", "11213", "11234", "11217", "52211", "11206",
"11212", "11223", "11201", "21225", "11211", "44144",
#Washington | 1176
"48094", "06793", "20004", "63090", "20016", "20017", "20310", "20002",
"30673", "48095", "20037", "47501", "52353", "20003", "20018", "22747",
"20012", "20019", "20560", "20064", "20005", "20024", "73093", "27889",
"20007", "20410", "84780", "20010", "20036", "06777", "15301", "20015",
"20045", "20009", "20001", "20006", "61571", "07882", "20011", "85719",
"20052", "77880", "20020", "20008",
#Atlanta | 1129
"30320", "30326", "30305", "30033", "30334", "30680", "30338", "30336",
"30361", "46031", "30314", "30342", "30331", "30312", "30337", "30324",
"30335", "30341", "30363", "39326", "12345", "30327", "30360", "30346",
"30311", "30302", "30308", "30303", "30309", "30315", "75551", "30319",
"30084", "30318", "30345", "30068", "30328", "30339", "30354", "30310",
"30307", "30067", "30306", "30329", "30316", "30313", "30349", "30317",
"30350", "30340", "30344", "83716",
#San Diego | 1114
"92101", "92116", "92117", "92111", "92127", "92104", "92126", "92107",
"92114", "92105", "92124", "92102", "92129", "92121", "92109", "92119",
"92160", "92110", "92103", "92154", "92108", "92120", "92128", "92106",
"92122", "92131", "92182", "92123", "92064", "92139", "92113", "92115",
"92130", "92037",
#Las Vegas | 1047
"89156", "89074", "89183", "89108", "89129", "89144", "87701", "89110",
"89142", "89115", "89178", "89117", "89124", "89121", "89315", "89145",
"89122", "89107", "89118", "89104", "89148", "89147", "89119", "89146",
"89141", "89113", "89128", "89177", "89199", "89106", "89109", "89101",
"89131", "89103", "89130", "89102", "89111", "89169", "89044", "89120",
"89123", "89139", "89158", "89135", "89136", "89134", "89149", "89143",
#Dallas | 1013
"75235", "75226", "75233", "75001", "75237", "75234", "75248", "75246",
"75207", "75243", "75208", "75326", "75217", "75223", "75230", "75342",
"75252", "75229", "75261", "75240", "75228", "75220", "75270", "30132",
"75247", "75205", "75201", "75251", "75762", "75216", "75390", "75203",
"75210", "75287", "75238", "75224", "18612", "75231", "75244", "97338",
"30157", "75211", "75209", "75206", "75214", "75227", "75254", "75057",
"75303", "75202", "75236", "75204", "75241", "75212", "75215", "75225",
"28034", "75232", "75219", "75218",
]
NEW_CITIES = [z for z in NEW_CITIES if z not in CITIES]
# San Antonio
NEW_CITIES += ['78225', '78209', '78215', '78238', '78205', '78261', '78207',
'78250', '78264', '78206', '78254', '76903', '78252', '78240',
'78226', '78210', '78253', '78528', '78213', '78202', '78229',
'78228', '78201', '78212', '78260', '78258', '78216', '78232',
'78247', '78244', '78208', '78239', '78288', '78257', '78230',
'78259', '78233', '78214', '78237', '78227', '78220', '78222',
'78266', '33576', '78221', '78251', '78203', '78263', '78224',
'78255', '78234', '78256', '78245', '78249', '78236', '78223',
'78217', '78231', '78211', '78218', '78248', '78242', '78204',
'78219']
# Phoenix
NEW_CITIES += ['85021', '85034', '97535', '85004', '85306', '85028', '85017',
'85029', '85310', '85035', '85085', '85282', '85331', '85073',
'85012', '85014', '21131', '85033', '85044', '85018', '85008',
'85041', '85019', '85015', '85020', '85031', '85054', '85040',
'85022', '85284', '85043', '85037', '85048', '13135', '85050',
'85053', '85027', '85006', '85003', '85016', '85009', '85042',
'85007', '85051', '85086', '85254', '85032', '85023', '85301',
'85339', '85024', '85013']
# Columbus
NEW_CITIES += ['43203', '43223', '31901', '43214', '39705', '43220', '28722',
'43210', '43081', '43207', '43206', '31993', '43228', '31906',
'43202', '39702', '31904', '43221', '43209', '43230', '43224',
'43201', '43211', '43240', '43205', '39701', '43235', '31909',
'43212', '43085', '68601', '43204', '31903', '43215', '53925',
'43222', '43227', '43017', '43213', '78934', '43219', '43231',
'66725', '43232', '43229', '47021', '47203', '43026', '43123',
'47201', '31907']
# Orlando
NEW_CITIES += ['32835', '32829', '32801', '32832', '32811', '32816', '32810',
'32825', '32824', '32809', '32837', '32805', '32830', '32821',
'32803', '32819', '32826', '32812', '32820', '32822', '32808',
'32818', '32807', '32834', '32804', '32836', '32806', '32828',
'32817', '32814', '32827', '32839', '32802']
# Indianapolis
NEW_CITIES += ['46221', '46224', '46254', '46282', '46202', '46240', '46229',
'46236', '46203', '46205', '46218', '46020', '46256', '46259',
'46077', '46235', '46250', '46107', '46249', '46260', '46231',
'46234', '46228', '46560', '46074', '46142', '46204', '46214',
'46208', '46227', '46168', '46280', '46278', '46217', '46225',
'46143', '46237', '46268', '76240', '46201', '46290', '46241',
'46219', '46220', '46226', '46222', '46239', '46216', '43225']
# Denver
NEW_CITIES += ['80220', '80205', '80231', '80233', '80215', '80264', '80207',
'80206', '28037', '80002', '80265', '50622', '80211', '80212',
'80247', '80227', '80209', '80224', '80234', '80230', '80232',
'80204', '80219', '80249', '80229', '80226', '80241', '80237',
'80216', '80014', '80223', '80202', '80221', '77007', '80012',
'80236', '80218', '80222', '80260', '80203', '80246', '80238',
'17517', '80214', '80228', '80123', '80239', '80210']
# Jacksonville
NEW_CITIES += ['32238', '32203', '32207', '28546', '32204', '32266', '32256',
'32211', '28540', '32201', '62650', '32277', '32244', '32217',
'32212', '32202', '32990', '32224', '32258', '32226', '32250',
'32214', '32225', '32222', '32209', '32234', '32220', '32246',
'36265', '32099', '32259', '72099', '32233', '32219', '97530',
'72076', '32205', '32208', '32206', '75766', '32290', '32257',
'32254', '32221', '32210', '32269', '32216', '32218', '32223']
# Miami
NEW_CITIES += ['33128', '33147', '33183', '33187', '33166', '33176', '33185',
'33157', '33189', '33154', '33136', '33173', '33165', '33122',
'33138', '33135', '33126', '33180', '33184', '33169', '33196',
'33231', '33167', '33133', '33132', '33129', '33140', '33144',
'33155', '33134', '33181', '33174', '33145', '33160', '33125',
'33179', '33131', '33168', '33175', '33161', '33127', '33146',
'33178', '33194', '74354', '33150', '33156', '33193', '33172',
'33182', '33186', '74355', '33177', '33142', '33143', '33299',
'33141', '33162', '33170', '33137', '33139', '33130', '85539',
'33199', '33116']
# Louisville
NEW_CITIES += ['40245', '40258', '40229', '44641', '40242', '40222', '40202',
'40299', '40206', '40208', '40210', '40243', '40211', '40215',
'40204', '40059', '40291', '40213', '40218', '40241', '80027',
'40223', '30434', '40219', '40209', '47129', '40228', '37777',
'40216', '40207', '39339', '40212', '40217', '40203', '68037',
'40205', '40272', '62858', '40220', '40214']
# Minneapolis
NEW_CITIES += ['55450', '55403', '55426', '55455', '55448', '55432', '55411',
'55414', '55406', '55401', '55467', '55449', '55427', '55402',
'55442', '55428', '55409', '55430', '55438', '55425', '55415',
'55488', '55144', '55435', '55422', '55447', '55419', '55413',
'67467', '55441', '55410', '55446', '55408', '55444', '55429',
'55454', '55439', '55416', '55418', '55443', '55421', '55405',
'55423', '55404', '55436', '55420', '55437', '55431', '55407',
'55424', '55445', '55433', '55434', '55412', '55417']
# Cincinnati
NEW_CITIES += ['45216', '45103', '45244', '45204', '45232', '45225', '45240',
'45211', '45036', '45220', '45069', '45243', '45209', '45251',
'45249', '45202', '45241', '47006', '45231', '45247', '45275',
'45230', '45233', '45226', '45201', '45208', '45040', '45205',
'45224', '45236', '45248', '45213', '45221', '45214', '45238',
'45206', '45217', '45229', '45255', '45252', '45245', '45237',
'45207', '45215', '45203', '45219', '45246', '45228', '45227',
'45223', '45239', '45212', '45242']
# Springfield
NEW_CITIES += ['22150', '65806', '37172', '45503', '65809', '65804', '70462',
'45506', '65721', '62712', '22159', '07081', '01107', '65802',
'01103', '01109', '01105', '22153', '45502', '62703', '57062',
'19064', '68059', '97478', '01108', '65803', '22315', '31329',
'22151', '56087', '62707', '22152', '97477', '62711', '45504',
'62704', '01119', '45505', '01118', '62702', '01104', '49037',
'62701', '01115', '01129', '81073', '01128', '65810', '01151',
'05156', '65897', '40069', '65807']
# Cleveland
NEW_CITIES += ['44129', '44104', '44123', '44130', '44146', '44125', '44128',
'44110', '74020', '44106', '44112', '44120', '44139', '44114',
'44124', '44147', '77328', '64734', '44107', '44195', '44118',
'37311', '44109', '44132', '44145', '44108', '30528', '44143',
'44103', '53015', '44111', '44134', '44101', '44113', '44126',
'44105', '44135', '44136', '44115', '27013', '44121', '37312',
'44122', '44102', '38732', '44142', '44137', '37364', '44116',
'44131', '44119', '44127', '44138', '44141', '44140', '44133',
'77327', '44144', '37323']
# Charlotte
NEW_CITIES += ['28216', '28270', '28214', '28282', '28205', '28246', '28208',
'48813', '28244', '28280', '28215', '28213', '28278', '28206',
'28204', '28209', '28224', '28262', '28223', '28219', '28273',
'28275', '28211', '28202', '28269', '28207', '28217', '28277',
'28210', '28201', '28203', '28226', '37036', '28284', '28212',
'28227']
# Tampa
NEW_CITIES += ['33624', '33602', '33618', '33635', '33630', '33637', '33622',
'33607', '33634', '33606', '33647', '33615', '33626', '33625',
'33613', '33619', '33773', '33620', '33605', '33835', '33614',
'33601', '33603', '33621', '33617', '33609', '33629', '33616',
'33612', '33610', '33604', '33611']
ALL_CITIES = CITIES + NEW_CITIES
BAY_AREA = ["94579", "95050", "94612", "95070", "94925", "94574", "94502",
"95488", "94040", "94928", "94401", "94803", "94568", "94618",
"95121", "94703", "90049", "94564", "94904", "94608", "94534",
"94595", "95036", "95138", "94025", "94582", "94708", "94304",
"95404", "94622", "94611", "95687", "94607", "94086", "94501",
"95014", "95117", "94566", "94599", "95133", "94551", "94583",
"95118", "94590", "94804", "94011", "95401", "94621", "94085",
"94952", "94941", "95030", "94062", "94526", "94028", "95113",
"94019", "94014", "94602", "94066", "94549", "94061", "94002",
"94930", "95136", "95127", "95129", "94089", "95032", "94070",
"95116", "94553", "94705", "94515", "94605", "94403", "94949",
"95132", "94530", "94303", "94558", "94538", "94903", "95124",
"94901", "95123", "95403", "94603", "95148", "95139", "94609",
"95111", "95472", "94806", "94555", "95035", "94402", "95492",
"94939", "94030", "94706", "94523", "95119", "94619", "94305",
"94517", "94660", "94707", "94041", "94080", "94591", "94510",
"95037", "94585", "94301", "94521", "94518", "94547", "94588",
"94509", "95122", "94596", "95407", "94556", "94702", "95015",
"94801", "94578", "94015", "94022", "95131", "94704", "94617",
"94520", "94965", "94947", "94531", "94710", "94598", "95126",
"94587", "95135", "94966", "94519", "94010", "95134", "94044",
"94610", "94960", "95688", "94539", "94561", "95405", "94606",
"94536", "94544", "95130", "94560", "95476", "94945", "94506",
"94027", "94920", "94546", "95620", "95101", "94087", "94589",
"94542", "94545", "94931", "94128", "95409", "94601", "94035",
"94306", "94577", "94513", "94541", "94503", "94043", "94497",
"94597", "95033", "94805", "94533", "95448", "95008", "94005",
"95051", "94550", "94709", "95020", "95128", "95110", "95125",
"94063", "94065", "95425", "94571", "94404", "95112", "94563",
"94954", "94565", "94024", "94559", "95054", "94302", "95120",]
BAY_AREA = [z for z in BAY_AREA if z not in ALL_CITIES]
ALL_CITIES += BAY_AREA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment