INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14086', 'S', 'Lancaster', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.905877, -78.627625);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14091', 'S', 'Lawtons', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.539825, -78.865691);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14092', 'S', 'Lewiston', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.170345, -78.988244);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14092', 'S', 'Stella Niagara', 'A', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.170345, -78.988244);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14094', 'S', 'Lockport', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.161194, -78.689344);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14094', 'S', 'Pendleton', 'N', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.161194, -78.689344);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14095', 'P', 'Lockport', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.171046, -78.688835);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14098', 'S', 'Lyndonville', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.337372, -78.377353);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14101', 'S', 'Machias', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.407012, -78.51734);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14102', 'S', 'Marilla', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.836658, -78.553177);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14103', 'S', 'Medina', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.217164, -78.385469);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14105', 'S', 'Middleport', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.209014, -78.492391);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14107', 'P', 'Model City', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.193133, -78.98327);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14108', 'S', 'Newfane', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.26296, -78.726232);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14109', 'P', 'Niagara University', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.13435, -79.03593);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14110', 'P', 'North Boston', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.684526, -78.774487);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14111', 'S', 'North Collins', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.58351, -78.908047);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14112', 'P', 'North Evans', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.697844, -78.98493);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14113', 'S', 'North Java', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.67487, -78.338627);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14120', 'S', 'North Tonawanda', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.074275, -78.841759);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14120', 'S', 'Pendleton', 'N', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.074275, -78.841759);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14120', 'S', 'Wheatfield', 'N', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.074275, -78.841759);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14125', 'S', 'East Oakfield', 'N', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.078642, -78.272493);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14125', 'S', 'Oakfield', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.078642, -78.272493);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14126', 'P', 'Olcott', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.332652, -78.718556);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14127', 'S', 'Orchard Park', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.764164, -78.742821);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14129', 'S', 'Perrysburg', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.469663, -79.006594);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14130', 'P', 'Pike', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.554652, -78.144859);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14131', 'S', 'Ransomville', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.228804, -78.911638);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14132', 'S', 'Pendleton', 'N', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.147891, -78.872724);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14132', 'S', 'Sanborn', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.147891, -78.872724);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14133', 'P', 'Sandusky', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.499653, -78.378886);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14134', 'S', 'Sardinia', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.534136, -78.52412);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14135', 'P', 'Sheridan', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.487157, -79.240878);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14136', 'S', 'Silver Creek', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.53635, -79.168058);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14138', 'S', 'South Dayton', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.399405, -79.100331);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14139', 'S', 'South Wales', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.718999, -78.536856);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14140', 'P', 'Spring Brook', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.801249, -78.665071);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14140', 'P', 'Springbrook', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.801249, -78.665071);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14141', 'S', 'Springville', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.521734, -78.704161);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14143', 'S', 'Stafford', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.981048, -78.080897);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14144', 'P', 'Stella Niagara', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.19788, -79.046406);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14145', 'S', 'Sheldon', 'N', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.722585, -78.427328);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14145', 'S', 'Strykersville', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.722585, -78.427328);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14150', 'S', 'Tonawanda', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.001575, -78.861741);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14151', 'P', 'Tonawanda', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.016876, -78.878188);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14166', 'P', 'Dunkirk', 'A', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.450113, -79.417318);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14166', 'P', 'Van Buren Bay', 'N', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.450113, -79.417318);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14166', 'P', 'Van Buren Point', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.450113, -79.417318);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14167', 'S', 'Varysburg', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.737511, -78.317594);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14168', 'P', 'Versailles', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.518902, -78.991091);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14169', 'P', 'Wales Center', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.766324, -78.527795);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14170', 'S', 'West Falls', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.704094, -78.670831);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14171', 'S', 'West Valley', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.417525, -78.638025);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14172', 'S', 'Wilson', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.276519, -78.809408);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14173', 'P', 'Yorkshire', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.527409, -78.47335);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14174', 'S', 'Youngstown', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.249215, -79.02603);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14201', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.89797, -78.884047);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14202', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.882757, -78.877245);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14203', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.88215, -78.867026);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14204', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.881129, -78.864058);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14205', 'P', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.892353, -78.868805);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14206', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.878991, -78.814887);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14206', 'S', 'Cheektowaga', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.878991, -78.814887);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14206', 'S', 'West Seneca', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.878991, -78.814887);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14207', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.945566, -78.896412);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14207', 'S', 'Town of Tonawanda', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.945566, -78.896412);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14208', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.912922, -78.851613);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14209', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.917486, -78.86498);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14210', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.863725, -78.827208);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14210', 'S', 'West Seneca', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.863725, -78.827208);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14211', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.909859, -78.82294);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14211', 'S', 'Cheektowaga', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.909859, -78.82294);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14212', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.893956, -78.821559);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14212', 'S', 'Cheektowaga', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.893956, -78.821559);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14212', 'S', 'Sloan', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.893956, -78.821559);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14213', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.917852, -78.889241);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14214', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.941449, -78.836451);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14215', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.933454, -78.81184);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14215', 'S', 'Cheektowaga', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.933454, -78.81184);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14216', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.947283, -78.859475);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14217', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.972758, -78.876061);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14217', 'S', 'Kenmore', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.972758, -78.876061);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14217', 'S', 'Tonawanda', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.972758, -78.876061);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14217', 'S', 'Town of Tonawanda', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.972758, -78.876061);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14218', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.816727, -78.819627);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14218', 'S', 'Lackawanna', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.816727, -78.819627);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14218', 'S', 'West Seneca', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.816727, -78.819627);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14219', 'S', 'Blasdell', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.785549, -78.822312);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14219', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.785549, -78.822312);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14219', 'S', 'Hamburg', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.785549, -78.822312);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14220', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.844204, -78.816936);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14220', 'S', 'West Seneca', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.844204, -78.816936);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14221', 'S', 'Amherst', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.980183, -78.734894);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14221', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.980183, -78.734894);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14221', 'S', 'Clarence', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.980183, -78.734894);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14221', 'S', 'Williamsville', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.980183, -78.734894);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14222', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.919299, -78.876334);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14223', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969212, -78.84124);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14223', 'S', 'Hiler', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969212, -78.84124);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14223', 'S', 'Kenmore', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969212, -78.84124);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14223', 'S', 'Tonawanda', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969212, -78.84124);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14223', 'S', 'Town of Tonawanda', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969212, -78.84124);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14224', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.834121, -78.755389);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14224', 'S', 'West Seneca', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.834121, -78.755389);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14225', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.928334, -78.760842);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14225', 'S', 'Cheektowaga', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.928334, -78.760842);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14226', 'S', 'Amherst', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969504, -78.798576);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14226', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969504, -78.798576);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14226', 'S', 'Eggertsville', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969504, -78.798576);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14226', 'S', 'Snyder', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969504, -78.798576);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14226', 'S', 'Snyder Square', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.969504, -78.798576);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14227', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.876735, -78.744457);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14227', 'S', 'Cheektowaga', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.876735, -78.744457);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14227', 'S', 'South Cheektowaga', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.876735, -78.744457);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14228', 'S', 'Amherst', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.042462, -78.785527);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14228', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.042462, -78.785527);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14228', 'S', 'West Amherst', 'N', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.042462, -78.785527);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14231', 'P', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.98039, -78.737853);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14231', 'P', 'Williamsville', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.98039, -78.737853);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14233', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.875099, -78.869022);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14240', 'P', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.87884, -78.80962);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14241', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.927923, -78.74765);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14260', 'U', 'Amherst', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.003074, -78.785924);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14260', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.003074, -78.785924);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14261', 'U', 'Amherst', 'A', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.00245, -78.781965);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14261', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.00245, -78.781965);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14263', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.873378, -78.869243);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14264', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.887206, -78.823444);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14265', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.978557, -78.750032);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14267', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.916696, -78.877078);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14269', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.86514, -78.869492);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14270', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.87, -78.832208);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14272', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.872268, -78.870254);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14273', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.870716, -78.869699);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14276', 'U', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.86027, -78.916095);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14280', 'S', 'Buffalo', 'D', 'Erie', '36029', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 42.886929, -78.871237);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14301', 'S', 'Niagara Falls', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.093678, -79.041792);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14302', 'P', 'Niagara Falls', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.087809, -79.061883);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14303', 'S', 'Niagara Falls', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.087115, -79.037731);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14304', 'S', 'Niagara Falls', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.089703, -78.964149);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14304', 'S', 'Wheatfield', 'N', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.089703, -78.964149);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14305', 'S', 'Niagara Falls', 'D', 'Niagara', '36063', 'New York', 'NY', '36', '1280', '716', 'Eastern', -5, 'Y', 43.117629, -79.02919);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14410', 'S', 'Adams Basin', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.192205, -77.855545);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14411', 'S', 'Albion', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.239907, -78.202239);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14411', 'S', 'Eagle Harbor', 'A', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.239907, -78.202239);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14413', 'P', 'Alton', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.208705, -76.983214);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14414', 'S', 'Avon', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.897668, -77.736093);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14415', 'S', 'Bellona', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.756258, -77.019723);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14416', 'S', 'Bergen', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.07373, -77.985432);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14418', 'S', 'Branchport', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.613768, -77.211323);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14420', 'S', 'Brockport', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.214548, -77.929502);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14422', 'S', 'Byron', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.07615, -78.071607);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14423', 'S', 'Caledonia', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.941518, -77.843078);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14424', 'S', 'Canandaigua', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.843523, -77.301225);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14425', 'S', 'Canandaigua', 'A', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.956711, -77.331325);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14425', 'S', 'Farmington', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.956711, -77.331325);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14427', 'S', 'Castile', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.642063, -78.046828);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14428', 'S', 'Churchville', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.0825, -77.846192);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14428', 'S', 'Clifton', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.0825, -77.846192);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14429', 'P', 'Clarendon', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.192479, -78.063625);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14430', 'P', 'Clarkson', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.235446, -77.925235);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14432', 'S', 'Clifton Springs', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 42.963132, -77.147698);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14433', 'S', 'Clyde', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.08127, -76.869374);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14435', 'S', 'Conesus', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.724523, -77.677278);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14437', 'S', 'Dansville', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.572707, -77.731377);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14441', 'S', 'Dresden', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.688633, -76.955886);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14443', 'P', 'East Bloomfield', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.890395, -77.446504);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14445', 'S', 'East Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.11255, -77.489182);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14449', 'P', 'East Williamson', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.232738, -77.150121);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14450', 'S', 'Fairport', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.087492, -77.432058);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14452', 'P', 'Fancher', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.243195, -78.087864);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14453', 'P', 'Fishers', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.012541, -77.462743);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14454', 'S', 'Geneseo', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.788901, -77.771652);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14456', 'S', 'Geneva', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 42.862982, -76.997939);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14461', 'P', 'Gorham', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.801791, -77.130502);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14462', 'S', 'Groveland', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.680605, -77.749793);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14463', 'P', 'Hall', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.797345, -77.069035);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14464', 'S', 'Hamlin', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.316716, -77.921667);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14466', 'S', 'Hemlock', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.77155, -77.559436);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14467', 'S', 'Henrietta', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.053743, -77.609162);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14468', 'S', 'Hilton', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.295049, -77.789588);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14469', 'S', 'Bloomfield', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.877952, -77.456375);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14469', 'S', 'East Bloomfield', 'N', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.877952, -77.456375);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14469', 'S', 'Holcomb', 'N', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.877952, -77.456375);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14470', 'S', 'Holley', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.216953, -78.048887);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14470', 'S', 'Hulberton', 'A', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.216953, -78.048887);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14471', 'S', 'Honeoye', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.761985, -77.496841);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14472', 'S', 'Honeoye Falls', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.970369, -77.596338);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14475', 'S', 'Ionia', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.934998, -77.511407);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14476', 'S', 'Kendall', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.333198, -78.04693);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14477', 'S', 'Kent', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.340537, -78.14236);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14478', 'S', 'Bluff Point', 'A', 'Yates', '36123', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.587954, -77.12449);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14478', 'S', 'Keuka Park', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.587954, -77.12449);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14479', 'P', 'Knowlesville', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.237153, -78.309111);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14480', 'S', 'Lakeville', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.834968, -77.704898);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14481', 'S', 'Leicester', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.777475, -77.909721);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14482', 'S', 'Le Roy', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.979836, -77.984161);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14482', 'S', 'Leroy', 'N', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.979836, -77.984161);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14485', 'S', 'Lima', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.89156, -77.614458);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14486', 'S', 'Linwood', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.892704, -77.920284);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14487', 'S', 'Livonia', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.811143, -77.668155);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14488', 'P', 'Livonia Center', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.818813, -77.64226);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14489', 'S', 'Lyons', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.087298, -76.996974);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14502', 'S', 'Macedon', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.087022, -77.333368);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14504', 'S', 'Manchester', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.969996, -77.2299);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14505', 'S', 'Marion', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.152501, -77.172245);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14506', 'S', 'Mendon', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.998096, -77.499835);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14507', 'S', 'Middlesex', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.704465, -77.268077);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14508', 'P', 'Morton', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.327041, -77.999192);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14510', 'S', 'Mount Morris', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.698894, -77.87328);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14510', 'S', 'Tuscarora', 'A', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.698894, -77.87328);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14511', 'P', 'Mumford', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.991585, -77.860852);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14512', 'S', 'Naples', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.657539, -77.413799);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14513', 'S', 'East Palmyra', 'A', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.052762, -77.096188);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14513', 'S', 'Newark', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.052762, -77.096188);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14514', 'S', 'North Chili', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.114248, -77.792506);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14515', 'S', 'North Greece', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.255445, -77.72991);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14516', 'S', 'North Rose', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.193625, -76.907679);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14517', 'S', 'Nunda', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.587711, -77.911103);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14518', 'P', 'Oaks Corners', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 42.930174, -77.012457);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14519', 'S', 'Ontario', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.235743, -77.302362);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14520', 'P', 'Ontario Center', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.227431, -77.306963);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14521', 'S', 'Hayt Corners', 'A', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.67249, -76.808623);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14521', 'S', 'Ovid', 'D', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.67249, -76.808623);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14522', 'S', 'Palmyra', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.068259, -77.224663);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14525', 'S', 'Pavilion', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.898777, -78.030271);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14526', 'S', 'Penfield', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.141702, -77.455684);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14527', 'S', 'Penn Yan', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.658509, -77.061185);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14529', 'P', 'Perkinsville', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.533783, -77.626665);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14530', 'S', 'Perry', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.735814, -78.015498);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14532', 'S', 'Phelps', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 42.967137, -77.044133);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14532', 'S', 'West Junius', 'N', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 42.967137, -77.044133);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14533', 'S', 'Piffard', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.843359, -77.888278);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14533', 'S', 'Wadsworth', 'A', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.843359, -77.888278);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14534', 'S', 'Pittsford', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.069507, -77.514294);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14536', 'S', 'Portageville', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.550639, -78.081712);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14536', 'S', 'Rossburg', 'A', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.550639, -78.081712);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14537', 'P', 'Port Gibson', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.035448, -77.158404);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14538', 'P', 'Pultneyville', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.278042, -77.1722);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14539', 'P', 'Retsof', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.835036, -77.880566);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14541', 'S', 'Mac Dougall', 'A', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.766299, -76.842927);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14541', 'S', 'Romulus', 'D', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '315', 'Eastern', -5, 'Y', 42.766299, -76.842927);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14542', 'P', 'Rose', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.156346, -76.873817);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14543', 'S', 'Industry', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.994532, -77.664004);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14543', 'S', 'Rush', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.994532, -77.664004);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14543', 'S', 'West Rush', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.994532, -77.664004);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14544', 'S', 'Rushville', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.742889, -77.245455);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14545', 'S', 'Groveland', 'A', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.663666, -77.713631);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14545', 'S', 'Scottsburg', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.663666, -77.713631);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14546', 'S', 'Scottsville', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.029866, -77.765882);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14547', 'P', 'Seneca Castle', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 42.904938, -77.126529);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14548', 'S', 'Shortsville', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.96318, -77.238668);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14549', 'P', 'Silver Lake', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.699111, -78.02408);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14550', 'S', 'Rock Glen', 'A', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.67299, -78.09439);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14550', 'S', 'Silver Springs', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.67299, -78.09439);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14551', 'S', 'Sodus', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.223243, -77.047982);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14551', 'S', 'Sodus Center', 'A', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.223243, -77.047982);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14555', 'S', 'Sodus Point', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.266985, -76.988411);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14556', 'P', 'Sonyea', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.679657, -77.826587);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14557', 'P', 'South Byron', 'D', 'Genesee', '36037', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.046795, -78.066225);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14558', 'P', 'South Lima', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.853824, -77.677651);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14559', 'S', 'Spencerport', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.189174, -77.807274);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14560', 'S', 'Springwater', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.711095, -77.553933);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14560', 'S', 'Webster Crossing', 'A', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.711095, -77.553933);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14561', 'S', 'Stanley', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.823591, -77.098747);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14563', 'P', 'Union Hill', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '716', 'Eastern', -5, 'Y', 43.223103, -77.371355);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14564', 'S', 'Victor', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.979988, -77.424394);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14568', 'S', 'Walworth', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.142109, -77.287732);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14569', 'S', 'Warsaw', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.739675, -78.16465);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14571', 'S', 'Waterport', 'D', 'Orleans', '36073', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.347169, -78.247079);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14572', 'S', 'Wayland', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.541439, -77.588869);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14580', 'S', 'Webster', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.220645, -77.464013);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14585', 'S', 'West Bloomfield', 'D', 'Ontario', '36069', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.908597, -77.552853);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14586', 'S', 'West Henrietta', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.043209, -77.679662);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14588', 'P', 'Willard', 'D', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.681759, -76.872085);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14589', 'S', 'Williamson', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.246564, -77.18323);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14590', 'S', 'Wolcott', 'D', 'Wayne', '36117', 'New York', 'NY', '36', '6840', '315', 'Eastern', -5, 'Y', 43.245974, -76.832666);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14591', 'S', 'Wyoming', 'D', 'Wyoming', '36121', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.827666, -78.08667);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14592', 'P', 'York', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.873962, -77.884221);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14602', 'P', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.168234, -77.601928);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14603', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.160031, -77.605267);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14604', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.157946, -77.604476);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14605', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.165247, -77.600096);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14606', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.167126, -77.687832);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14607', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.151853, -77.593546);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14608', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.15275, -77.625651);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14609', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.174537, -77.559782);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14610', 'S', 'Brighton', 'N', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.140249, -77.545983);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14610', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.140249, -77.545983);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14611', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.148324, -77.643809);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14612', 'S', 'Greece', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.256923, -77.669136);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14612', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.256923, -77.669136);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14613', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.177983, -77.63461);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14614', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.155018, -77.609665);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14615', 'S', 'Greece', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.207456, -77.649511);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14615', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.207456, -77.649511);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14616', 'S', 'Greece', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.234473, -77.653267);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14616', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.234473, -77.653267);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14617', 'S', 'Irondequoit', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.220241, -77.599083);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14617', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.220241, -77.599083);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14618', 'S', 'Loehmanns Plaza', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.119768, -77.556663);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14618', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.119768, -77.556663);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14619', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.133202, -77.64409);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14620', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.132792, -77.600284);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14621', 'S', 'Irondequoit', 'N', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.182834, -77.602085);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14621', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.182834, -77.602085);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14622', 'S', 'Irondequoit', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.216211, -77.562561);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14622', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.216211, -77.562561);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14623', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.081673, -77.633588);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14624', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.120619, -77.729488);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14624', 'S', 'Westgate', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.120619, -77.729488);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14625', 'S', 'Panorama', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.145996, -77.505992);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14625', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.145996, -77.505992);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14626', 'S', 'Greece', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.20974, -77.703726);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14626', 'S', 'Ridgemont', 'A', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.20974, -77.703726);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14626', 'S', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.20974, -77.703726);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14627', 'P', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.122454, -77.669125);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14638', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.15714, -77.606676);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14639', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.158018, -77.605115);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14642', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.122242, -77.625204);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14643', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.155367, -77.607291);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14644', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.153845, -77.603654);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14645', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.156956, -77.600708);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14646', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.151509, -77.605675);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14647', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.157199, -77.608041);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14649', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.157109, -77.604365);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14650', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.162172, -77.621673);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14651', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.160651, -77.619606);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14652', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.150617, -77.728304);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14653', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.15213, -77.623329);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14664', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.154791, -77.604444);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14673', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.15503, -77.613071);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14683', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.08918, -77.597408);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14692', 'P', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.084621, -77.598456);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14694', 'U', 'Rochester', 'D', 'Monroe', '36055', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 43.088842, -77.599683);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14701', 'S', 'Jamestown', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.094174, -79.251081);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14702', 'P', 'Jamestown', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.096597, -79.234978);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14703', 'U', 'Jamestown', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.097304, -79.237685);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14704', 'U', 'Jamestown', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.096094, -79.234548);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14706', 'S', 'Allegany', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.103002, -78.493761);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14707', 'P', 'Allentown', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.090634, -78.062163);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14708', 'S', 'Alma', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.013652, -78.025114);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14709', 'S', 'Angelica', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.310729, -78.024817);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14710', 'S', 'Ashville', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.078716, -79.373737);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14711', 'S', 'Belfast', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.341095, -78.119974);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14712', 'S', 'Bemus Point', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.152037, -79.357012);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14714', 'S', 'Black Creek', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.285552, -78.256921);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14715', 'S', 'Alma', 'N', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.075166, -78.157392);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14715', 'S', 'Bolivar', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.075166, -78.157392);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14715', 'S', 'South Bolivar', 'N', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.075166, -78.157392);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14716', 'S', 'Brocton', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.38762, -79.43515);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14717', 'S', 'Caneadea', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.372527, -78.210567);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14718', 'S', 'Cassadaga', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.348088, -79.292917);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14719', 'S', 'Cattaraugus', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.329564, -78.86951);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14720', 'P', 'Celoron', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.10848, -79.28304);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14721', 'S', 'Ceres', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.011321, -78.271295);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14722', 'P', 'Chautauqua', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.207332, -79.466845);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14723', 'S', 'Cherry Creek', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.311195, -79.141523);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14724', 'S', 'Clymer', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.052487, -79.669917);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14726', 'S', 'Conewango Valley', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.238377, -79.060848);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14727', 'S', 'Cuba', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.211225, -78.268103);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14728', 'S', 'Dewittville', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.241482, -79.401184);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14729', 'S', 'East Otto', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.409324, -78.725794);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14730', 'P', 'East Randolph', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.17125, -78.948137);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14731', 'S', 'Ellicottville', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.292555, -78.658909);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14732', 'P', 'Ellington', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.219861, -79.103575);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14733', 'S', 'Falconer', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.128136, -79.190161);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14735', 'S', 'Fillmore', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.4533, -78.087607);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14736', 'S', 'Findley Lake', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.107656, -79.73234);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14737', 'S', 'Franklinville', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.333354, -78.431625);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14738', 'S', 'Frewsburg', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.053607, -79.134602);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14739', 'S', 'Friendship', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.203341, -78.139046);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14740', 'S', 'Gerry', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.198621, -79.226713);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14741', 'S', 'Great Valley', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.215287, -78.613314);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14741', 'S', 'Humphrey', 'N', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.215287, -78.613314);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14742', 'P', 'Greenhurst', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.120268, -79.305125);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14743', 'S', 'Hinsdale', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.190437, -78.399674);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14743', 'S', 'Ischua', 'A', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.190437, -78.399674);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14744', 'S', 'Houghton', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.416695, -78.167853);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14745', 'P', 'Hume', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.470999, -78.137723);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14747', 'S', 'Kennedy', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.155243, -79.101242);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14748', 'S', 'Kill Buck', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.149646, -78.639987);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14750', 'S', 'Lakewood', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.10072, -79.322878);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14751', 'P', 'Leon', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.293682, -79.017978);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14752', 'P', 'Lily Dale', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.350044, -79.326995);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14753', 'S', 'Limestone', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.035199, -78.640416);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14754', 'S', 'Little Genesee', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.024649, -78.18395);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14755', 'S', 'Little Valley', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.248809, -78.800866);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14756', 'P', 'Dewittville', 'N', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.196953, -79.424756);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14756', 'P', 'Maple Springs', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.196953, -79.424756);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14757', 'S', 'Mayville', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.250678, -79.500191);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14758', 'P', 'Niobe', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.011416, -79.450406);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14760', 'S', 'Knapp Creek', 'A', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.081747, -78.426015);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14760', 'S', 'Olean', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.081747, -78.426015);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14766', 'P', 'Otto', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.349305, -78.828802);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14767', 'S', 'Panama', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.181055, -79.447193);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14769', 'S', 'Portland', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.377963, -79.471958);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14770', 'S', 'Portville', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.037594, -78.334611);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14772', 'S', 'Randolph', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.146804, -78.981588);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14774', 'P', 'Richburg', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.089324, -78.155021);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14775', 'S', 'Forsyth', 'N', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.26458, -79.707146);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14775', 'S', 'Ripley', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.26458, -79.707146);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14777', 'S', 'Rushford', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.387916, -78.242115);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14778', 'P', 'Saint Bonaventure', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.080151, -78.474616);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14779', 'S', 'Salamanca', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.157839, -78.717434);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14781', 'S', 'Sherman', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.158808, -79.597595);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14782', 'S', 'Sinclairville', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.275424, -79.244039);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14783', 'P', 'Steamburg', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.106997, -78.904621);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14784', 'S', 'Stockton', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.325907, -79.365843);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14785', 'P', 'Stow', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.157319, -79.404216);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14786', 'P', 'West Clarksville', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.125215, -78.229883);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14787', 'S', 'Westfield', 'D', 'Chautauqua', '36013', 'New York', 'NY', '36', '3610', '716', 'Eastern', -5, 'Y', 42.324371, -79.570661);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14788', 'P', 'Weston Mills', 'N', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.060494, -78.380393);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14788', 'P', 'Westons Mills', 'D', 'Cattaraugus', '36009', 'New York', 'NY', '36', '0000', '716', 'Eastern', -5, 'Y', 42.060494, -78.380393);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14801', 'S', 'Addison', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.107463, -77.230985);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14802', 'S', 'Alfred', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.255151, -77.785384);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14803', 'S', 'Alfred Station', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.256785, -77.788411);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14804', 'S', 'Almond', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.327793, -77.824559);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14805', 'S', 'Alpine', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.362451, -76.731395);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14806', 'S', 'Andover', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.155375, -77.804776);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14807', 'S', 'Arkport', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.427575, -77.668725);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14808', 'S', 'Atlanta', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.552703, -77.480345);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14808', 'S', 'North Cohocton', 'A', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.552703, -77.480345);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14809', 'S', 'Avoca', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.409568, -77.449282);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14809', 'S', 'Wallace', 'A', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.409568, -77.449282);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14810', 'S', 'Bath', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.34203, -77.318938);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14810', 'S', 'Veterans Administration', 'A', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.34203, -77.318938);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14812', 'S', 'Beaver Dams', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.307691, -76.988302);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14813', 'S', 'Belmont', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.230607, -78.017742);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14814', 'S', 'Big Flats', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.145843, -76.947025);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14815', 'S', 'Bradford', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.390147, -77.083086);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14816', 'S', 'Breesport', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.172988, -76.730149);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14817', 'S', 'Brooktondale', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.370141, -76.365201);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14818', 'S', 'Burdett', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.437057, -76.828291);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14819', 'S', 'Cameron', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.201213, -77.462912);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14819', 'S', 'Cameron Mills', 'N', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.201213, -77.462912);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14820', 'S', 'Cameron Mills', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.233846, -77.337118);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14821', 'S', 'Campbell', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.243643, -77.195401);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14822', 'S', 'Canaseraga', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.453413, -77.787943);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14823', 'S', 'Canisteo', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.25975, -77.584644);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14824', 'S', 'Cayuta', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.276635, -76.70193);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14825', 'S', 'Chemung', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.046766, -76.61945);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14826', 'S', 'Cohocton', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.498624, -77.510139);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14827', 'P', 'Coopers Plains', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.178306, -77.14086);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14830', 'S', 'Corning', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.14317, -77.052149);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14831', 'U', 'Corning', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.147148, -77.056466);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14836', 'S', 'Dalton', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.543587, -77.919905);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14837', 'S', 'Dundee', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.525317, -76.973125);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14838', 'S', 'Erin', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.19726, -76.684904);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14839', 'S', 'Greenwood', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.144281, -77.644114);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14840', 'S', 'Hammondsport', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.450089, -77.184976);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14841', 'S', 'Hector', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.498593, -76.873441);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14841', 'S', 'Valois', 'A', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.498593, -76.873441);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14842', 'S', 'Himrod', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.592474, -76.947431);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14843', 'S', 'Hornell', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.328714, -77.656438);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14844', 'P', 'Horseheads', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.162289, -76.878208);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14845', 'S', 'Horseheads', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.180601, -76.841295);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14846', 'S', 'Hunt', 'D', 'Livingston', '36051', 'New York', 'NY', '36', '6840', '585', 'Eastern', -5, 'Y', 42.558498, -78.003025);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14847', 'S', 'Interlaken', 'D', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.614405, -76.729358);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14850', 'S', 'Ithaca', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.445573, -76.496428);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14850', 'S', 'Ithaca College', 'A', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.445573, -76.496428);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14851', 'P', 'Ithaca', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.447569, -76.503192);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14852', 'P', 'Ithaca', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.507018, -76.471133);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14853', 'S', 'Ithaca', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.439636, -76.487351);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14854', 'P', 'Jacksonville', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.502545, -76.610456);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14855', 'S', 'Jasper', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.103259, -77.528682);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14856', 'P', 'Kanona', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.334564, -77.320273);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14857', 'P', 'Lakemont', 'D', 'Yates', '36123', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.518741, -76.928255);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14858', 'S', 'Lindley', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.059605, -77.146474);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14859', 'S', 'Lockwood', 'D', 'Tioga', '36107', 'New York', 'NY', '36', '0960', '607', 'Eastern', -5, 'Y', 42.090387, -76.579355);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14860', 'S', 'Lodi', 'D', 'Seneca', '36099', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.603278, -76.842228);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14861', 'S', 'Lowman', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.136889, -76.727834);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14863', 'P', 'Mecklenburg', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.455504, -76.711047);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14864', 'S', 'Millport', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.2671, -76.840236);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14865', 'S', 'Montour Falls', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.34496, -76.837674);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14867', 'S', 'Newfield', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.359059, -76.599327);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14869', 'S', 'Odessa', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.350105, -76.776852);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14870', 'S', 'Painted Post', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.155826, -77.115626);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14871', 'S', 'Pine City', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.050672, -76.866098);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14872', 'S', 'Pine Valley', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.227341, -76.852554);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14873', 'S', 'Prattsburgh', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.524871, -77.249474);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14874', 'S', 'Pulteney', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.531331, -77.171206);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14876', 'P', 'Reading Center', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.433722, -76.950153);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14877', 'S', 'Rexville', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.075702, -77.667295);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14878', 'S', 'Rock Stream', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.469548, -76.930728);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14879', 'S', 'Savona', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.307167, -77.182785);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14880', 'S', 'Scio', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.166475, -77.984285);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14881', 'S', 'Slaterville Springs', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.396767, -76.358163);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14882', 'S', 'Ithaca', 'A', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.569242, -76.541585);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14882', 'S', 'Lansing', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.569242, -76.541585);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14883', 'S', 'Spencer', 'D', 'Tioga', '36107', 'New York', 'NY', '36', '0960', '607', 'Eastern', -5, 'Y', 42.220258, -76.485155);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14883', 'S', 'West Danby', 'A', 'Tioga', '36107', 'New York', 'NY', '36', '0960', '607', 'Eastern', -5, 'Y', 42.220258, -76.485155);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14884', 'S', 'Swain', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.454043, -77.895389);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14885', 'S', 'Troupsburg', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.066319, -77.564807);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14886', 'S', 'Trumansburg', 'D', 'Tompkins', '36109', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.521119, -76.643605);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14887', 'P', 'Tyrone', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.402468, -77.069893);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14889', 'S', 'Van Etten', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.215462, -76.579551);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14891', 'S', 'Watkins Glen', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.372716, -76.913044);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14892', 'S', 'Waverly', 'D', 'Tioga', '36107', 'New York', 'NY', '36', '0960', '607', 'Eastern', -5, 'Y', 42.015892, -76.533539);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14893', 'P', 'Wayne', 'D', 'Schuyler', '36097', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.466821, -77.111453);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14894', 'S', 'Wellsburg', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.010247, -76.730286);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14895', 'S', 'Wellsville', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '585', 'Eastern', -5, 'Y', 42.11197, -77.945146);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14897', 'S', 'Whitesville', 'D', 'Allegany', '36003', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.035503, -77.777158);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14898', 'S', 'Woodhull', 'D', 'Steuben', '36101', 'New York', 'NY', '36', '0000', '607', 'Eastern', -5, 'Y', 42.077279, -77.409549);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14901', 'S', 'Elmira', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.098491, -76.808792);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14902', 'P', 'Elmira', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.10412, -76.812185);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14903', 'S', 'Elmira', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.130311, -76.848824);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14903', 'S', 'Elmira Heights', 'A', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.130311, -76.848824);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14904', 'S', 'Elmira', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.07222, -76.805797);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14905', 'S', 'Elmira', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.090047, -76.839445);
INSERT INTO `[prefix]_zipcodes` (`zipcode`, `zipcodetype`, `city`, `citytype`, `county`, `countyfips`, `state`, `statecode`, `statefips`, `msa`, `areacode`, `timezone`, `gmtoffset`, `dst`, `latitude`, `longitude`) VALUES ('14925', 'S', 'Elmira', 'D', 'Chemung', '36015', 'New York', 'NY', '36', '2335', '607', 'Eastern', -5, 'Y', 42.11594, -76.761776);
