/**
 * Add additional data to the zip dataset. There were taken from the Geonames
 * US dataset (https://download.geonames.org/export/zip/), then enriched with
 * time zones via the AskGeo web service (https://askgeo.com/#web-api).
 */
INSERT INTO civicrm_geocoder_zip_dataset
VALUES ('01434', 'Devens', 'MA', 42.538500, -71.611500, 'UTC-5', 1),
       ('02298', 'Boston', 'MA', 42.382300, -71.032300, 'UTC-5', 1),
       ('02340', 'Hanover', 'MA', 42.113700, -70.816100, 'UTC-5', 1),
       ('02455', 'North Waltham', 'MA', 42.362100, -71.205500, 'UTC-5', 1),
       ('03285', 'Thornton', 'NH', 43.905000, -71.647000, 'UTC-5', 1),
       ('03586', 'Sugar Hill', 'NH', 44.220300, -71.796400, 'UTC-5', 1),
       ('03593', 'Randolph', 'NH', 44.375300, -71.279800, 'UTC-5', 1),
       ('03823', 'Madbury', 'NH', 43.172900, -70.941200, 'UTC-5', 1),
       ('03861', 'Lee', 'NH', 43.119200, -70.996900, 'UTC-5', 1),
       ('05408', 'Burlington', 'VT', 44.512000, -73.249200, 'UTC-5', 1),
       ('06042', 'Manchester', 'CT', 41.796600, -72.529200, 'UTC-5', 1),
       ('06338', 'Mashantucket', 'CT', 41.475700, -71.957400, 'UTC-5', 1),
       ('06461', 'Milford', 'CT', 41.233800, -73.074700, 'UTC-5', 1),
       ('06495', 'Wallingford', 'CT', 41.388500, -72.879500, 'UTC-5', 1),
       ('06792', 'Torrington', 'CT', 41.754900, -73.058200, 'UTC-5', 1),
       ('06828', 'Fairfield', 'CT', 41.169000, -73.233400, 'UTC-5', 1),
       ('06838', 'Greens Farms', 'CT', 41.123800, -73.319500, 'UTC-5', 1),
       ('07395', 'Jersey City', 'NJ', 40.727900, -74.078000, 'UTC-5', 1),
       ('07699', 'Teterboro', 'NJ', 40.846300, -74.061100, 'UTC-5', 1),
       ('08644', 'Trenton', 'NJ', 40.217100, -74.742900, 'UTC-5', 1),
       ('09001', 'APO AA', '', 38.110500, 15.661300, 'UTC+1', 0),
       ('09007', 'APO AE', '', 49.407700, 8.690800, 'UTC+1', 0),
       ('09008', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09009', 'APO AE', '', 49.433300, 7.600000, 'UTC+1', 0),
       ('09012', 'APO AE', '', 49.433300, 7.600000, 'UTC+1', 0),
       ('09014', 'APO AE', '', 49.407700, 8.690800, 'UTC+1', 0),
       ('09021', 'APO AE', '', 49.429200, 7.696900, 'UTC+1', 0),
       ('09025', 'APO AE', '', 49.111300, 9.739100, 'UTC+1', 0),
       ('09026', 'APO AE', '', 50.377600, 9.910900, 'UTC+1', 0),
       ('09028', 'APO AE', '', 49.543100, 8.449700, 'UTC+1', 0),
       ('09031', 'APO AE', '', 49.739700, 10.150700, 'UTC+1', 0),
       ('09033', 'APO AE', '', 50.049400, 10.221700, 'UTC+1', 0),
       ('09034', 'APO AE', '', 49.617400, 7.333800, 'UTC+1', 0),
       ('09036', 'APO AE', '', 49.793900, 9.951200, 'UTC+1', 0),
       ('09039', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09041', 'APO AE', '', 48.137400, 11.575500, 'UTC+1', 0),
       ('09044', 'APO AE', '', 49.981700, 11.613900, 'UTC+1', 0),
       ('09046', 'APO AE', '', 48.682100, 9.011700, 'UTC+1', 0),
       ('09047', 'APO AE', '', 49.759000, 9.508500, 'UTC+1', 0),
       ('09050', 'APO AE', '', 47.761100, 11.558900, 'UTC+1', 0),
       ('09052', 'APO AE', '', 49.246900, 7.369800, 'UTC+1', 0),
       ('09053', 'APO AE', '', 47.492600, 11.086500, 'UTC+1', 0),
       ('09054', 'APO AE', '', 49.443000, 7.771600, 'UTC+1', 0),
       ('09056', 'APO AE', '', 49.632800, 8.359200, 'UTC+1', 0),
       ('09057', 'APO AE', '', 50.000000, 8.666700, 'UTC+1', 0),
       ('09058', 'APO AE', '', 49.632800, 8.359200, 'UTC+1', 0),
       ('09059', 'APO AE', '', 49.405200, 7.437200, 'UTC+1', 0),
       ('09060', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09063', 'APO AE', '', 49.407700, 8.690800, 'UTC+1', 0),
       ('09064', 'APO AE', '', 50.000000, 8.666700, 'UTC+1', 0),
       ('09066', 'APO AE', '', 49.591000, 11.007800, 'UTC+1', 0),
       ('09067', 'APO AE', '', 49.443000, 7.771600, 'UTC+1', 0),
       ('09068', 'APO AE', '', 49.475900, 10.988600, 'UTC+1', 0),
       ('09069', 'APO AE', '', 53.550200, 8.576700, 'UTC+1', 0),
       ('09070', 'APO AE', '', 49.442400, 10.954100, 'UTC+1', 0),
       ('09071', 'APO AE', '', 49.442900, 11.862700, 'UTC+1', 0),
       ('09072', 'APO AE', '', 50.869900, 6.696900, 'UTC+1', 0),
       ('09073', 'APO AE', '', 48.703500, 9.652100, 'UTC+1', 0),
       ('09074', 'APO AE', '', 48.356900, 10.984600, 'UTC+1', 0),
       ('09077', 'APO AE', '', 50.433900, 8.671200, 'UTC+1', 0),
       ('09078', 'APO AE', '', 51.962400, 7.625700, 'UTC+1', 0),
       ('09079', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09080', 'APO AE', '', 50.684600, 7.153900, 'UTC+1', 0),
       ('09081', 'APO AE', '', 49.382200, 8.582300, 'UTC+1', 0),
       ('09082', 'APO AE', '', 50.100600, 8.766500, 'UTC+1', 0),
       ('09086', 'APO AE', '', 49.500000, 8.500000, 'UTC+1', 0),
       ('09089', 'APO AE', '', 49.965200, 8.951300, 'UTC+1', 0),
       ('09090', 'APO AE', '', 50.125400, 8.608900, 'UTC+1', 0),
       ('09091', 'APO AE', '', 50.201600, 9.187400, 'UTC+1', 0),
       ('09094', 'APO AE', '', 49.444500, 7.555300, 'UTC+1', 0),
       ('09095', 'APO AE', '', 49.223100, 8.363900, 'UTC+1', 0),
       ('09096', 'APO AE', '', 50.082600, 8.249300, 'UTC+1', 0),
       ('09097', 'APO AE', '', 50.000000, 8.666700, 'UTC+1', 0),
       ('09098', 'APO AE', '', 47.863800, 12.010500, 'UTC+1', 0),
       ('09099', 'APO AE', '', 49.407700, 8.690800, 'UTC+1', 0),
       ('09100', 'APO AE', '', 49.382200, 8.582300, 'UTC+1', 0),
       ('09102', 'APO AE', '', 49.407700, 8.690800, 'UTC+1', 0),
       ('09103', 'APO AE', '', 51.174700, 6.316900, 'UTC+1', 0),
       ('09104', 'APO AE', '', 50.967500, 6.117600, 'UTC+1', 0),
       ('09107', 'APO AE', '', 48.176100, 9.539200, 'UTC+1', 0),
       ('09108', 'APO AE', '', 48.137400, 11.575500, 'UTC+1', 0),
       ('09110', 'APO AE', '', 49.847200, 8.316700, 'UTC+1', 0),
       ('09111', 'APO AE', '', 49.841400, 7.867100, 'UTC+1', 0),
       ('09112', 'APO AE', '', 50.510600, 10.318700, 'UTC+1', 0),
       ('09114', 'APO AE', '', 49.717300, 11.906500, 'UTC+1', 0),
       ('09123', 'APO AE', '', 49.983300, 6.683300, 'UTC+1', 0),
       ('09126', 'APO AE', '', 49.983300, 6.683300, 'UTC+1', 0),
       ('09128', 'APO AE', '', 48.935600, 8.960400, 'UTC+1', 0),
       ('09130', 'APO AE', '', 49.511800, 7.866600, 'UTC+1', 0),
       ('09131', 'APO AE', '', 48.935600, 8.960400, 'UTC+1', 0),
       ('09132', 'APO AE', '', 49.967900, 6.527300, 'UTC+1', 0),
       ('09136', 'APO AE', '', 49.511800, 7.866600, 'UTC+1', 0),
       ('09137', 'APO AE', '', 48.703500, 9.652100, 'UTC+1', 0),
       ('09138', 'APO AE', '', 49.224900, 7.610400, 'UTC+1', 0),
       ('09139', 'APO AE', '', 49.898700, 10.900700, 'UTC+1', 0),
       ('09140', 'APO AE', '', 49.480400, 10.387700, 'UTC+1', 0),
       ('09141', 'APO AE', '', 50.872000, 9.708900, 'UTC+1', 0),
       ('09142', 'APO AE', '', 49.330500, 11.023500, 'UTC+1', 0),
       ('09143', 'APO AE', '', 50.587300, 8.675500, 'UTC+1', 0),
       ('09144', 'APO AE', '', 50.151400, 8.425000, 'UTC+1', 0),
       ('09154', 'APO AE', '', 48.782300, 9.177000, 'UTC+1', 0),
       ('09156', 'APO AE', '', 49.967900, 6.527300, 'UTC+1', 0),
       ('09157', 'APO AE', '', 48.371500, 10.898500, 'UTC+1', 0),
       ('09160', 'APO AE', '', 48.542000, 9.790500, 'UTC+1', 0),
       ('09162', 'APO AE', '', 49.977000, 9.152100, 'UTC+1', 0),
       ('09164', 'APO AE', '', 49.009400, 8.404400, 'UTC+1', 0),
       ('09165', 'APO AE', '', 50.134200, 8.914200, 'UTC+1', 0),
       ('09166', 'APO AE', '', 49.489100, 8.466900, 'UTC+1', 0),
       ('09169', 'APO AE', '', 50.587300, 8.675500, 'UTC+1', 0),
       ('09171', 'APO AE', '', 51.962400, 7.625700, 'UTC+1', 0),
       ('09172', 'APO AE', '', 47.598100, 11.066900, 'UTC+1', 0),
       ('09173', 'APO AE', '', 49.204000, 11.848400, 'UTC+1', 0),
       ('09175', 'APO AE', '', 49.871700, 8.650300, 'UTC+1', 0),
       ('09176', 'APO AE', '', 49.139900, 9.220500, 'UTC+1', 0),
       ('09177', 'APO AE', '', 49.304800, 10.593100, 'UTC+1', 0),
       ('09178', 'APO AE', '', 48.371500, 10.898500, 'UTC+1', 0),
       ('09180', 'APO AE', '', 49.413100, 7.570200, 'UTC+1', 0),
       ('09182', 'APO AE', '', 49.653100, 9.944400, 'UTC+1', 0),
       ('09183', 'APO AE', '', 48.137400, 11.575500, 'UTC+1', 0),
       ('09184', 'APO AE', '', 48.137400, 11.575500, 'UTC+1', 0),
       ('09185', 'APO AE', '', 49.984200, 8.279100, 'UTC+1', 0),
       ('09186', 'APO AE', '', 49.443000, 7.771600, 'UTC+1', 0),
       ('09187', 'APO AE', '', 52.524400, 13.410500, 'UTC+1', 0),
       ('09189', 'APO AE', '', 49.201400, 7.605300, 'UTC+1', 0),
       ('09192', 'APO AE', '', 50.082600, 8.249300, 'UTC+1', 0),
       ('09196', 'APO AE', '', 50.082600, 8.249300, 'UTC+1', 0),
       ('09202', 'APO AE', '', 50.009900, 8.282900, 'UTC+1', 0),
       ('09205', 'APO AE', '', 52.172700, 9.249100, 'UTC+1', 0),
       ('09211', 'APO AE', '', 49.871700, 8.650300, 'UTC+1', 0),
       ('09212', 'APO AE', '', 50.000000, 8.666700, 'UTC+1', 0),
       ('09213', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09214', 'APO AE', '', 50.173800, 7.063300, 'UTC+1', 0),
       ('09215', 'APO AE', '', 53.575300, 10.015300, 'UTC+1', 0),
       ('09216', 'APO AE', '', 52.133800, 10.889700, 'UTC+1', 0),
       ('09220', 'APO AE', '', 50.082600, 8.249300, 'UTC+1', 0),
       ('09222', 'APO AE', '', 49.475900, 10.988600, 'UTC+1', 0),
       ('09225', 'APO AE', '', 49.739700, 10.150700, 'UTC+1', 0),
       ('09226', 'APO AE', '', 50.049400, 10.221700, 'UTC+1', 0),
       ('09227', 'APO AE', '', 49.443000, 7.771600, 'UTC+1', 0),
       ('09228', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09229', 'APO AE', '', 49.443000, 7.771600, 'UTC+1', 0),
       ('09233', 'APO AE', '', 51.221700, 6.776200, 'UTC+1', 0),
       ('09235', 'APO AE', '', 52.524400, 13.410500, 'UTC+1', 0),
       ('09237', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09239', 'APO AE', '', 49.134400, 10.071900, 'UTC+1', 0),
       ('09242', 'APO AE', '', 50.115500, 8.684200, 'UTC+1', 0),
       ('09244', 'APO AE', '', 49.793900, 9.951200, 'UTC+1', 0),
       ('09245', 'APO AE', '', 48.137400, 11.575500, 'UTC+1', 0),
       ('09248', 'APO AE', '', 50.587300, 8.675500, 'UTC+1', 0),
       ('09249', 'APO AE', '', 49.246900, 7.369800, 'UTC+1', 0),
       ('09250', 'APO AE', '', 49.466700, 10.700000, 'UTC+1', 0),
       ('09251', 'APO AE', '', 49.246900, 7.369800, 'UTC+1', 0),
       ('09252', 'APO AE', '', 49.841400, 7.867100, 'UTC+1', 0),
       ('09258', 'APO AE', '', 49.444500, 7.555300, 'UTC+1', 0),
       ('09259', 'APO AE', '', 48.805500, 13.090200, 'UTC+1', 0),
       ('09261', 'APO AE', '', 51.739100, 6.291000, 'UTC+1', 0),
       ('09262', 'APO AE', '', 49.714400, 7.307800, 'UTC+1', 0),
       ('09263', 'APO AE', '', 49.443000, 7.771600, 'UTC+1', 0),
       ('09264', 'APO AE', '', 49.304800, 10.593100, 'UTC+1', 0),
       ('09265', 'APO AE', '', 50.202300, 10.077800, 'UTC+1', 0),
       ('09279', 'APO AE', '', 48.897300, 9.191600, 'UTC+1', 0),
       ('09281', 'APO AE', '', 48.799500, 9.798100, 'UTC+1', 0),
       ('09305', 'APO AE', '', 49.608400, 7.174100, 'UTC+1', 0),
       ('09333', 'APO AE', '', 49.466400, 8.557700, 'UTC+1', 0),
       ('09351', 'APO AE', '', 47.713800, 7.602800, 'UTC+1', 0),
       ('09352', 'APO AE', '', 49.568000, 10.885600, 'UTC+1', 0),
       ('09353', 'APO AE', '', 50.082600, 8.249300, 'UTC+1', 0),
       ('09354', 'APO AE', '', 54.784300, 9.439600, 'UTC+1', 0),
       ('09355', 'APO AE', '', 53.281000, 8.698600, 'UTC+1', 0),
       ('09358', 'APO AE', '', 50.082600, 8.249300, 'UTC+1', 0),
       ('09359', 'APO AE', '', 48.688400, 9.167700, 'UTC+1', 0),
       ('09360', 'APO AE', '', 49.032000, 8.342600, 'UTC+1', 0),
       ('09405', 'APO AE', '', 52.093300, 1.320400, 'UTC+0', 0),
       ('09415', 'FPO AE', '', 50.440600, -4.995400, 'UTC+0', 0),
       ('09418', 'FPO AE', '', 58.592700, -3.525900, 'UTC+0', 0),
       ('09419', 'FPO AE', '', 56.809100, -2.656000, 'UTC+0', 0),
       ('09420', 'FPO AE', '', 51.890800, -5.122400, 'UTC+0', 0),
       ('09421', 'FPO AE', '', 51.508500, -0.125700, 'UTC+0', 0),
       ('09422', 'FPO AE', '', 55.423200, -5.734700, 'UTC+0', 0),
       ('09447', 'APO AE', '', 51.401500, -1.324700, 'UTC+0', 0),
       ('09448', 'APO AE', '', 53.429500, -2.658500, 'UTC+0', 0),
       ('09449', 'APO AE', '', 51.548600, -0.480500, 'UTC+0', 0),
       ('09450', 'APO AE', '', 51.878200, 0.552900, 'UTC+0', 0),
       ('09456', 'APO AE', '', 51.708200, -1.781300, 'UTC+0', 0),
       ('09459', 'APO AE', '', 52.244300, 0.772400, 'UTC+0', 0),
       ('09461', 'APO AE', '', 52.416700, 0.750000, 'UTC+0', 0),
       ('09462', 'APO AE', '', 51.401500, -1.324700, 'UTC+0', 0),
       ('09463', 'APO AE', '', 51.401500, -1.324700, 'UTC+0', 0),
       ('09464', 'APO AE', '', 52.409300, 0.561000, 'UTC+0', 0),
       ('09467', 'APO AE', '', 51.900100, -2.079700, 'UTC+0', 0),
       ('09468', 'APO AE', '', 53.990800, -1.537300, 'UTC+0', 0),
       ('09469', 'APO AE', '', 52.369000, -0.260100, 'UTC+0', 0),
       ('09470', 'APO AE', '', 52.364200, -0.224300, 'UTC+0', 0),
       ('09471', 'APO AE', '', 51.629100, -0.749300, 'UTC+0', 0),
       ('09472', 'APO AE', '', 51.719300, -1.971400, 'UTC+0', 0),
       ('09494', 'APO AE', '', 51.997700, -1.204700, 'UTC+0', 0),
       ('09495', 'APO AE', '', 51.401500, -1.324700, 'UTC+0', 0),
       ('09497', 'APO AE', '', 52.093300, 1.320400, 'UTC+0', 0),
       ('09498', 'APO AE', '', 51.508500, -0.125700, 'UTC+0', 0),
       ('09499', 'APO AE', '', 51.508500, -0.125700, 'UTC+0', 0),
       ('09508', 'FPO AE', '', 19.906400, -75.206900, 'UTC-5', 1),
       ('09593', 'FPO AE', '', 19.906400, -75.206900, 'UTC-5', 1),
       ('09596', 'FPO AE', '', 19.906400, -75.206900, 'UTC-5', 1),
       ('09601', 'APO AE', '', 46.070600, 12.594700, 'UTC+1', 0),
       ('09602', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09604', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09605', 'APO AE', '', 40.632100, 17.936100, 'UTC+1', 0),
       ('09606', 'APO AE', '', 39.310300, 8.969600, 'UTC+1', 0),
       ('09609', 'FPO AE', '', 41.214100, 13.570800, 'UTC+1', 0),
       ('09610', 'APO AE', '', 45.402000, 10.276800, 'UTC+1', 0),
       ('09613', 'APO AE', '', 43.544300, 10.326200, 'UTC+1', 0),
       ('09618', 'APO AE', '', 40.850000, 9.166700, 'UTC+1', 0),
       ('09619', 'FPO AE', '', 40.852200, 14.268100, 'UTC+1', 0),
       ('09620', 'FPO AE', '', 40.852200, 14.268100, 'UTC+1', 0),
       ('09621', 'FPO AE', '', 40.852200, 14.268100, 'UTC+1', 0),
       ('09622', 'FPO AE', '', 40.882400, 14.269300, 'UTC+1', 0),
       ('09624', 'APO AE', '', 41.891900, 12.511300, 'UTC+1', 0),
       ('09625', 'FPO AE', '', 40.852200, 14.268100, 'UTC+1', 0),
       ('09626', 'FPO AE', '', 40.852200, 14.268100, 'UTC+1', 0),
       ('09627', 'FPO AE', '', 37.401700, 14.922400, 'UTC+1', 0),
       ('09628', 'APO AE', '', 45.429900, 10.984400, 'UTC+1', 0),
       ('09629', 'APO AE', '', 45.546700, 11.547500, 'UTC+1', 0),
       ('09630', 'APO AE', '', 45.546700, 11.547500, 'UTC+1', 0),
       ('09641', 'APO AE', '', 40.416500, -3.702600, 'UTC+1', 0),
       ('09642', 'APO AE', '', 40.416500, -3.702600, 'UTC+1', 0),
       ('09643', 'APO AE', '', 41.413600, -2.413200, 'UTC+1', 0),
       ('09644', 'FPO AE', '', 36.625500, -6.362200, 'UTC+1', 0),
       ('09645', 'FPO AE', '', 36.625500, -6.362200, 'UTC+1', 0),
       ('09646', 'APO AE', '', 41.656100, -0.877300, 'UTC+1', 0),
       ('09647', 'APO AE', '', 40.643300, -3.333800, 'UTC+1', 0),
       ('09648', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09655', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09658', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09670', 'FPO AE', '', 44.057500, 12.565300, 'UTC+1', 0),
       ('09680', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09681', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09682', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09683', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09694', 'APO AE', '', 36.948900, 14.607300, 'UTC+1', 0),
       ('09703', 'APO AE', '', 50.946700, 5.970800, 'UTC+1', 0),
       ('09704', 'APO AE', '', 76.531100, -68.701700, 'UTC-5', 1),
       ('09705', 'APO AE', '', 50.575800, 3.831000, 'UTC+1', 0),
       ('09706', 'APO AE', '', 59.929100, 10.519000, 'UTC+1', 0),
       ('09707', 'APO AE', '', 59.912700, 10.746100, 'UTC+1', 0),
       ('09708', 'APO AE', '', 50.587900, 3.807100, 'UTC+1', 0),
       ('09709', 'APO AE', '', 67.017000, -50.689300, 'UTC-2', 0),
       ('09713', 'APO AE', '', 50.848300, 5.688900, 'UTC+1', 0),
       ('09714', 'APO AE', '', 50.850400, 4.348800, 'UTC+1', 0),
       ('09715', 'APO AE', '', 52.082600, 4.315000, 'UTC+1', 0),
       ('09716', 'APO AE', '', 55.694700, 12.583200, 'UTC+1', 0),
       ('09717', 'APO AE', '', 50.848300, 5.688900, 'UTC+1', 0),
       ('09718', 'APO AE', '', 34.013300, -6.832600, 'UTC+1', 0),
       ('09719', 'APO AE', '', 46.070600, 12.594700, 'UTC+1', 0),
       ('09720', 'APO AE', '', 38.716700, -27.216700, 'UTC-1', 0),
       ('09721', 'APO AE', '', 60.169500, 24.935400, 'UTC+2', 0),
       ('09722', 'APO AE', '', 56.306700, 9.168300, 'UTC+1', 0),
       ('09723', 'APO AE', '', 60.169500, 24.935400, 'UTC+2', 0),
       ('09724', 'APO AE', '', 50.850400, 4.348800, 'UTC+1', 0),
       ('09725', 'APO AE', '', 64.004900, -22.562400, 'UTC+0', 0),
       ('09726', 'APO AE', '', 38.716700, -9.133300, 'UTC+0', 0),
       ('09727', 'FPO AE', '', 32.330200, -64.740000, 'UTC-4', 0),
       ('09728', 'FPO AE', '', 64.004900, -22.562400, 'UTC+0', 0),
       ('09729', 'FPO AE', '', 64.253900, -15.212100, 'UTC+0', 0),
       ('09730', 'FPO AE', '', 47.299900, -53.981400, 'UTC-3.5', 0),
       ('09731', 'FPO AE', '', 43.763200, -65.323500, 'UTC-4', 0),
       ('09732', 'APO AE', '', 46.316800, -79.466300, 'UTC-5', 1),
       ('09734', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09738', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09740', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09745', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09746', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09747', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09749', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09754', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09760', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09762', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09765', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09766', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09767', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09768', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09770', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09772', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09774', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09775', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09777', 'FPO AE', '', 48.853400, 2.348800, 'UTC+1', 0),
       ('09802', 'APO AE', '', 21.270300, 40.415800, 'UTC+3', 0),
       ('09803', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09804', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09805', 'APO AE', '', 25.400000, 49.650000, 'UTC+3', 0),
       ('09806', 'APO AE', '', 28.335600, 46.124700, 'UTC+3', 0),
       ('09808', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09809', 'APO AE', '', 18.300000, 42.733300, 'UTC+3', 0),
       ('09810', 'APO AE', '', 28.399800, 36.571500, 'UTC+3', 0),
       ('09811', 'APO AE', '', 21.542400, 39.198000, 'UTC+3', 0),
       ('09812', 'APO AE', '', 33.721500, 73.043300, 'UTC+5', 0),
       ('09813', 'APO AE', '', 6.300500, -10.796900, 'UTC+0', 0),
       ('09814', 'APO AE', '', 24.860800, 67.010400, 'UTC+5', 0),
       ('09815', 'APO AE', '', -4.616700, 55.450000, 'UTC+4', 0),
       ('09816', 'APO AE', '', 39.649200, 27.886100, 'UTC+3', 0),
       ('09817', 'APO AE', '', 38.350200, 38.316700, 'UTC+3', 0),
       ('09818', 'APO AE', '', 39.908600, 41.276900, 'UTC+3', 0),
       ('09819', 'APO AE', '', 38.412700, 27.138400, 'UTC+3', 0),
       ('09820', 'APO AE', '', 42.026800, 35.162500, 'UTC+3', 0),
       ('09821', 'APO AE', '', 38.412700, 27.138400, 'UTC+3', 0),
       ('09822', 'APO AE', '', 39.919900, 32.854300, 'UTC+3', 0),
       ('09823', 'APO AE', '', 39.919900, 32.854300, 'UTC+3', 0),
       ('09824', 'APO AE', '', 37.001700, 35.328900, 'UTC+3', 0),
       ('09825', 'APO AE', '', 37.913600, 40.217200, 'UTC+3', 0),
       ('09826', 'APO AE', '', 39.776700, 30.520600, 'UTC+3', 0),
       ('09827', 'APO AE', '', 41.013800, 28.949700, 'UTC+3', 0),
       ('09828', 'APO AE', '', -4.327600, 15.313600, 'UTC+1', 0),
       ('09829', 'APO AE', '', 15.551800, 32.532400, 'UTC+2', 0),
       ('09830', 'APO AE', '', 32.080900, 34.780600, 'UTC+2', 0),
       ('09831', 'APO AE', '', -1.283300, 36.816700, 'UTC+3', 0),
       ('09832', 'APO AE', '', 31.069000, 34.129200, 'UTC+2', 0),
       ('09833', 'APO AE', '', 27.915800, 34.329900, 'UTC+2', 0),
       ('09834', 'FPO AE', '', 26.210600, 50.611700, 'UTC+3', 0),
       ('09835', 'FPO AE', '', 30.062600, 31.249700, 'UTC+2', 0),
       ('09836', 'FPO AE', '', 35.175300, 33.364200, 'UTC+2', 0),
       ('09837', 'FPO AE', '', 26.210600, 50.611700, 'UTC+3', 0),
       ('09838', 'FPO AE', '', 37.381000, 38.457300, 'UTC+3', 0),
       ('09839', 'APO AE', '', 30.062600, 31.249700, 'UTC+2', 0),
       ('09840', 'APO AE', '', 37.979500, 23.716200, 'UTC+2', 0),
       ('09841', 'APO AE', '', 37.979500, 23.716200, 'UTC+2', 0),
       ('09842', 'APO AE', '', 37.979500, 23.716200, 'UTC+2', 0),
       ('09843', 'FPO AE', '', 38.165200, 21.408600, 'UTC+2', 0),
       ('09844', 'APO AE', '', 40.643600, 22.930900, 'UTC+2', 0),
       ('09845', 'APO AE', '', 38.041300, 23.543000, 'UTC+2', 0),
       ('09846', 'APO AE', '', 35.327900, 25.143400, 'UTC+2', 0),
       ('09847', 'FPO AE', '', 38.087300, 23.976400, 'UTC+2', 0),
       ('09848', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09850', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09851', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09852', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09853', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09855', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09858', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09861', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09864', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09865', 'FPO AE', '', 35.524900, 24.143500, 'UTC+2', 0),
       ('09866', 'APO AE', '', 26.210600, 50.611700, 'UTC+3', 0),
       ('09873', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09874', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09875', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09876', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09877', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09878', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09879', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09880', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09881', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09882', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09883', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09884', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09886', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09887', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09888', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09889', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09890', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09891', 'APO AA', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09892', 'FPO AE', '', 31.955200, 35.945000, 'UTC+3', 0),
       ('09893', 'APO AE', '', 30.062600, 31.249700, 'UTC+2', 0),
       ('09894', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09895', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09896', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('09897', 'APO AE', '', 24.687700, 46.721800, 'UTC+3', 0),
       ('09898', 'APO AE', '', 26.288600, 50.114000, 'UTC+3', 0),
       ('10065', 'New York', 'NY', 40.765100, -73.963800, 'UTC-5', 1),
       ('10075', 'New York', 'NY', 40.714300, -74.006000, 'UTC-5', 1),
       ('10949', 'Monroe', 'NY', 41.327400, -74.191100, 'UTC-5', 1),
       ('11437', 'Jamaica', 'NY', 40.676300, -73.796600, 'UTC-5', 1),
       ('13235', 'Syracuse', 'NY', 43.055900, -76.152600, 'UTC-5', 1),
       ('15289', 'Pittsburgh', 'PA', 40.444600, -79.945100, 'UTC-5', 1),
       ('15295', 'Pittsburgh', 'PA', 40.463000, -80.010800, 'UTC-5', 1),
       ('17202', 'Chambersburg', 'PA', 39.907200, -77.636000, 'UTC-5', 1),
       ('17334', 'Hanover', 'PA', 39.805000, -76.973600, 'UTC-5', 1),
       ('17335', 'Hanover', 'PA', 39.814400, -76.983700, 'UTC-5', 1),
       ('17408', 'York', 'PA', 39.949200, -76.801800, 'UTC-5', 1),
       ('17611', 'Lancaster', 'PA', 40.037900, -76.305500, 'UTC-5', 1),
       ('17622', 'Lancaster', 'PA', 40.041800, -76.301200, 'UTC-5', 1),
       ('18302', 'East Stroudsburg', 'PA', 41.093600, -75.118700, 'UTC-5', 1),
       ('18902', 'Doylestown', 'PA', 40.347700, -75.096800, 'UTC-5', 1),
       ('19060', 'Garnet Valley', 'PA', 39.852000, -75.500700, 'UTC-5', 1),
       ('19176', 'Philadelphia', 'PA', 39.952200, -75.164200, 'UTC-5', 1),
       ('19190', 'Philadelphia', 'PA', 39.948400, -75.144200, 'UTC-5', 1),
       ('19195', 'Philadelphia', 'PA', 39.952500, -75.164500, 'UTC-5', 1),
       ('19415', 'Eagleville', 'PA', 40.157200, -75.406000, 'UTC-5', 1),
       ('19906', 'Dover', 'DE', 39.157000, -75.529400, 'UTC-5', 1),
       ('20022', 'Washington', 'DC', 38.945000, -77.036400, 'UTC-5', 1),
       ('20027', 'Washington', 'DC', 38.900700, -77.050100, 'UTC-5', 1),
       ('20189', 'Dulles', 'VA', 39.009000, -77.442100, 'UTC-5', 1),
       ('20237', 'Washington', 'DC', 38.895000, -77.036700, 'UTC-5', 1),
       ('20252', 'Washington', 'DC', 38.958400, -77.051900, 'UTC-5', 1),
       ('20355', 'Washington', 'DC', 38.895100, -77.036900, 'UTC-5', 1),
       ('20376', 'Washington Navy Yard', 'DC', 38.916400, -76.994700, 'UTC-5', 1),
       ('20417', 'Washington', 'DC', 38.907000, -77.005800, 'UTC-5', 1),
       ('20509', 'Washington', 'DC', 38.898700, -77.035600, 'UTC-5', 1),
       ('20511', 'Washington', 'DC', 38.895100, -77.036400, 'UTC-5', 1),
       ('20528', 'Washington', 'DC', 38.895100, -77.036900, 'UTC-5', 1),
       ('20529', 'Washington', 'DC', 38.897300, -77.014200, 'UTC-5', 1),
       ('20588', 'Dhs', 'MD', 38.750400, -76.854400, 'UTC-5', 1),
       ('20598', 'Dhs', 'VA', 38.990400, -77.447700, 'UTC-5', 1),
       ('20792', 'Upper Marlboro', 'MD', 38.815800, -76.750000, 'UTC-5', 1),
       ('20810', 'Bethesda', 'MD', 38.980600, -77.100800, 'UTC-5', 1),
       ('20811', 'Bethesda', 'MD', 38.980600, -77.100800, 'UTC-5', 1),
       ('20883', 'Gaithersburg', 'MD', 39.088300, -77.156800, 'UTC-5', 1),
       ('20993', 'Silver Spring', 'MD', 39.033600, -76.986100, 'UTC-5', 1),
       ('21065', 'Hunt Valley', 'MD', 39.488300, -76.653800, 'UTC-5', 1),
       ('21409', 'Annapolis', 'MD', 39.041600, -76.437700, 'UTC-5', 1),
       ('22025', 'Dumfries', 'VA', 38.599300, -77.340300, 'UTC-5', 1),
       ('22107', 'Mc Lean', 'VA', 38.932100, -77.184100, 'UTC-5', 1),
       ('22108', 'Mc Lean', 'VA', 38.932100, -77.184100, 'UTC-5', 1),
       ('22350', 'Alexandria', 'VA', 38.804500, -77.050900, 'UTC-5', 1),
       ('22551', 'Spotsylvania', 'VA', 38.162000, -77.685400, 'UTC-5', 1),
       ('22556', 'Stafford', 'VA', 38.471800, -77.510200, 'UTC-5', 1),
       ('22803', 'Harrisonburg', 'VA', 38.449600, -78.868900, 'UTC-5', 1),
       ('23114', 'Midlothian', 'VA', 37.481500, -77.641900, 'UTC-5', 1),
       ('23295', 'Richmond', 'VA', 37.553200, -77.462100, 'UTC-5', 1),
       ('24205', 'Bristol', 'VA', 36.595000, -82.181900, 'UTC-5', 1),
       ('25403', 'Martinsburg', 'WV', 39.522700, -77.974700, 'UTC-5', 1),
       ('25404', 'Martinsburg', 'WV', 39.485200, -77.895400, 'UTC-5', 1),
       ('25405', 'Martinsburg', 'WV', 39.409200, -77.961500, 'UTC-5', 1),
       ('25888', 'Mount Hope', 'WV', 37.893000, -81.166800, 'UTC-5', 1),
       ('27268', 'High Point', 'NC', 35.969800, -79.993600, 'UTC-5', 1),
       ('27497', 'Greensboro', 'NC', 36.079800, -79.828200, 'UTC-5', 1),
       ('27527', 'Clayton', 'NC', 35.657700, -78.383700, 'UTC-5', 1),
       ('27528', 'Clayton', 'NC', 35.655500, -78.461100, 'UTC-5', 1),
       ('27815', 'Rocky Mount', 'NC', 35.897900, -77.793500, 'UTC-5', 1),
       ('28035', 'Davidson', 'NC', 35.499300, -80.848600, 'UTC-5', 1),
       ('28263', 'Charlotte', 'NC', 35.226800, -80.843200, 'UTC-5', 1),
       ('28271', 'Charlotte', 'NC', 35.216000, -80.835800, 'UTC-5', 1),
       ('28312', 'Fayetteville', 'NC', 34.954900, -78.740800, 'UTC-5', 1),
       ('28759', 'Mills River', 'NC', 35.390600, -82.568000, 'UTC-5', 1),
       ('29021', 'Camden', 'SC', 34.297400, -80.608900, 'UTC-5', 1),
       ('29395', 'Jonesville', 'SC', 34.846600, -81.722700, 'UTC-5', 1),
       ('29486', 'Summerville', 'SC', 33.018500, -80.175600, 'UTC-5', 1),
       ('29707', 'Fort Mill', 'SC', 34.977300, -80.858400, 'UTC-5', 1),
       ('30049', 'Lawrenceville', 'GA', 33.949500, -83.992200, 'UTC-5', 1),
       ('30112', 'Carrollton', 'GA', 33.580900, -85.079200, 'UTC-5', 1),
       ('30156', 'Kennesaw', 'GA', 34.017700, -84.625000, 'UTC-5', 1),
       ('30160', 'Kennesaw', 'GA', 34.017700, -84.625000, 'UTC-5', 1),
       ('30169', 'Canton', 'GA', 34.234000, -84.490400, 'UTC-5', 1),
       ('30270', 'Peachtree City', 'GA', 33.396800, -84.590000, 'UTC-5', 1),
       ('30536', 'Ellijay', 'GA', 34.655000, -84.355400, 'UTC-5', 1),
       ('31026', 'Eatonton', 'GA', 33.330400, -83.377000, 'UTC-5', 1),
       ('31059', 'Milledgeville', 'GA', 33.084600, -83.238000, 'UTC-5', 1),
       ('31136', 'Atlanta', 'GA', 33.747300, -84.382400, 'UTC-5', 1),
       ('31144', 'Kennesaw', 'GA', 34.023300, -84.615600, 'UTC-5', 1),
       ('31169', 'Peachtree City', 'GA', 33.396700, -84.595800, 'UTC-5', 1),
       ('31562', 'Saint George', 'GA', 30.522400, -82.037600, 'UTC-5', 1),
       ('32003', 'Fleming Island', 'FL', 30.093300, -81.719000, 'UTC-5', 1),
       ('32006', 'Fleming Island', 'FL', 30.107000, -81.716700, 'UTC-5', 1),
       ('32026', 'Raiford', 'FL', 30.069900, -82.192700, 'UTC-5', 1),
       ('32143', 'Palm Coast', 'FL', 29.585000, -81.207800, 'UTC-5', 1),
       ('32163', 'The Villages', 'FL', 28.933800, -81.991400, 'UTC-5', 1),
       ('32318', 'Tallahassee', 'FL', 30.438300, -84.280700, 'UTC-5', 1),
       ('32723', 'Deland', 'FL', 29.027500, -81.306800, 'UTC-5', 1),
       ('32753', 'Debary', 'FL', 28.883000, -81.308700, 'UTC-5', 1),
       ('32885', 'Orlando', 'FL', 28.545600, -81.378200, 'UTC-5', 1),
       ('32896', 'Orlando', 'FL', 28.541900, -81.379100, 'UTC-5', 1),
       ('33106', 'Miami', 'FL', 25.852700, -80.301200, 'UTC-5', 1),
       ('33112', 'Miami', 'FL', 25.796400, -80.384900, 'UTC-5', 1),
       ('33191', 'Miami', 'FL', 25.774300, -80.193700, 'UTC-5', 1),
       ('33198', 'Miami', 'FL', 25.774300, -80.193700, 'UTC-5', 1),
       ('33206', 'Miami', 'FL', 25.774300, -80.193700, 'UTC-5', 1),
       ('33222', 'Miami', 'FL', 25.757700, -80.374800, 'UTC-5', 1),
       ('33336', 'Fort Lauderdale', 'FL', 26.121900, -80.143600, 'UTC-5', 1),
       ('33449', 'Lake Worth', 'FL', 26.604800, -80.214900, 'UTC-5', 1),
       ('33472', 'Boynton Beach', 'FL', 26.538400, -80.185600, 'UTC-5', 1),
       ('33473', 'Boynton Beach', 'FL', 26.508800, -80.189600, 'UTC-5', 1),
       ('33508', 'Brandon', 'FL', 27.931800, -82.295000, 'UTC-5', 1),
       ('33545', 'Wesley Chapel', 'FL', 28.269700, -82.290300, 'UTC-5', 1),
       ('33575', 'Ruskin', 'FL', 27.714400, -82.429100, 'UTC-5', 1),
       ('33579', 'Riverview', 'FL', 27.802400, -82.275500, 'UTC-5', 1),
       ('33596', 'Valrico', 'FL', 27.892500, -82.243000, 'UTC-5', 1),
       ('33646', 'Tampa', 'FL', 28.094000, -82.402100, 'UTC-5', 1),
       ('33812', 'Lakeland', 'FL', 27.972900, -81.893100, 'UTC-5', 1),
       ('33929', 'Estero', 'FL', 26.438100, -81.806800, 'UTC-5', 1),
       ('33966', 'Fort Myers', 'FL', 26.582400, -81.832000, 'UTC-5', 1),
       ('33967', 'Fort Myers', 'FL', 26.472200, -81.812200, 'UTC-5', 1),
       ('33973', 'Lehigh Acres', 'FL', 26.602000, -81.731100, 'UTC-5', 1),
       ('33974', 'Lehigh Acres', 'FL', 26.567700, -81.595400, 'UTC-5', 1),
       ('33976', 'Lehigh Acres', 'FL', 26.595200, -81.684900, 'UTC-5', 1),
       ('34002', 'APO AA', '', 8.973300, -79.555600, 'UTC-5', 0),
       ('34003', 'APO AA', '', 8.950000, -79.550000, 'UTC-5', 0),
       ('34004', 'APO AA', '', 9.000000, -79.750000, 'UTC-5', 0),
       ('34005', 'APO AA', '', 9.291700, -79.907700, 'UTC-5', 0),
       ('34006', 'APO AA', '', 8.917100, -79.584300, 'UTC-5', 0),
       ('34007', 'APO AA', '', 8.939500, -79.549100, 'UTC-5', 0),
       ('34008', 'APO AA', '', 9.321900, -79.869700, 'UTC-5', 0),
       ('34009', 'APO AA', '', 8.966700, -79.550000, 'UTC-5', 0),
       ('34010', 'APO AA', '', 14.081800, -87.206800, 'UTC-6', 0),
       ('34011', 'APO AA', '', 8.966700, -79.550000, 'UTC-5', 0),
       ('34020', 'APO AA', '', 9.933300, -84.083300, 'UTC-5', 0),
       ('34021', 'APO AA', '', 12.132800, -86.250400, 'UTC-6', 0),
       ('34022', 'APO AA', '', 14.081800, -87.206800, 'UTC-6', 0),
       ('34023', 'APO AA', '', 13.689400, -89.187200, 'UTC-6', 0),
       ('34024', 'APO AA', '', 14.640700, -90.513300, 'UTC-6', 0),
       ('34030', 'APO AA', '', -22.911400, -43.173700, 'UTC-3', 0),
       ('34031', 'APO AA', '', -12.043200, -77.028200, 'UTC-5', 0),
       ('34032', 'APO AA', '', -16.500000, -68.150000, 'UTC-5', 0),
       ('34033', 'APO AA', '', -33.456900, -70.648300, 'UTC-5', 0),
       ('34034', 'APO AA', '', -34.613100, -58.377200, 'UTC-3', 0),
       ('34035', 'APO AA', '', -34.903300, -56.188200, 'UTC-3', 0),
       ('34036', 'APO AA', '', -25.300700, -57.635900, 'UTC-3', 0),
       ('34037', 'APO AA', '', 10.488000, -66.879200, 'UTC-4', 0),
       ('34038', 'APO AA', '', 4.609700, -74.081800, 'UTC-5', 0),
       ('34039', 'APO AA', '', -0.229900, -78.525000, 'UTC-5', 0),
       ('34040', 'APO AA', '', 18.466300, -66.105700, 'UTC-4', 0),
       ('34041', 'APO AA', '', 18.500100, -69.988600, 'UTC-5', 0),
       ('34042', 'APO AA', '', 14.382400, -87.621200, 'UTC-6', 0),
       ('34045', 'APO AA', '', 9.933300, -84.083300, 'UTC-5', 0),
       ('34046', 'APO AA', '', 14.081800, -87.206800, 'UTC-6', 0),
       ('34050', 'FPO AA', '', 18.478600, -67.168800, 'UTC-4', 0),
       ('34051', 'FPO AA', '', 18.235000, -65.629100, 'UTC-4', 0),
       ('34053', 'FPO AA', '', 18.426900, -66.184600, 'UTC-4', 0),
       ('34054', 'FPO AA', '', 17.050000, -61.800000, 'UTC-4', 0),
       ('34058', 'FPO AA', '', 24.433300, -77.950000, 'UTC-5', 0),
       ('34059', 'FPO AA', '', 8.939500, -79.549100, 'UTC-5', 0),
       ('34060', 'FPO AA', '', 9.400800, -79.869700, 'UTC-5', 0),
       ('34061', 'FPO AA', '', 8.950000, -79.583300, 'UTC-5', 0),
       ('34212', 'Bradenton', 'FL', 27.497800, -82.410100, 'UTC-5', 1),
       ('34249', 'Sarasota', 'FL', 27.266400, -82.484100, 'UTC-5', 1),
       ('34269', 'Arcadia', 'FL', 27.067500, -81.985500, 'UTC-5', 1),
       ('34290', 'North Port', 'FL', 27.045900, -82.249100, 'UTC-5', 1),
       ('34291', 'North Port', 'FL', 27.099700, -82.209500, 'UTC-5', 1),
       ('34441', 'Hernando', 'FL', 28.931100, -82.372000, 'UTC-5', 1),
       ('34637', 'Land O Lakes', 'FL', 28.278200, -82.462500, 'UTC-5', 1),
       ('34638', 'Land O Lakes', 'FL', 28.247800, -82.496200, 'UTC-5', 1),
       ('34692', 'Holiday', 'FL', 28.188000, -82.734600, 'UTC-5', 1),
       ('34714', 'Clermont', 'FL', 28.411300, -81.781200, 'UTC-5', 1),
       ('34715', 'Clermont', 'FL', 28.625900, -81.730600, 'UTC-5', 1),
       ('35270', 'Birmingham', 'AL', 33.520600, -86.802500, 'UTC-6', 1),
       ('36421', 'Andalusia', 'AL', 31.324700, -86.506700, 'UTC-6', 1),
       ('37544', 'Memphis', 'TN', 35.149600, -90.048700, 'UTC-6', 1),
       ('37934', 'Knoxville', 'TN', 35.876200, -84.174600, 'UTC-5', 1),
       ('39813', 'Arlington', 'GA', 31.442000, -84.724100, 'UTC-5', 1),
       ('39815', 'Attapulgus', 'GA', 30.749300, -84.484600, 'UTC-5', 1),
       ('39817', 'Bainbridge', 'GA', 30.938100, -84.593400, 'UTC-5', 1),
       ('39818', 'Bainbridge', 'GA', 30.884500, -84.565500, 'UTC-5', 1),
       ('39819', 'Bainbridge', 'GA', 30.903900, -84.569000, 'UTC-5', 1),
       ('39823', 'Blakely', 'GA', 31.379100, -84.935300, 'UTC-5', 1),
       ('39824', 'Bluffton', 'GA', 31.520000, -84.867000, 'UTC-5', 1),
       ('39825', 'Brinson', 'GA', 30.978800, -84.737300, 'UTC-5', 1),
       ('39826', 'Bronwood', 'GA', 31.830800, -84.364000, 'UTC-5', 1),
       ('39827', 'Cairo', 'GA', 30.952800, -84.206900, 'UTC-5', 1),
       ('39828', 'Cairo', 'GA', 30.876800, -84.209100, 'UTC-5', 1),
       ('39829', 'Calvary', 'GA', 30.746200, -84.312500, 'UTC-5', 1),
       ('39832', 'Cedar Springs', 'GA', 31.174500, -85.037000, 'UTC-5', 1),
       ('39834', 'Climax', 'GA', 30.875700, -84.445000, 'UTC-5', 1),
       ('39836', 'Coleman', 'GA', 31.672600, -84.890300, 'UTC-5', 1),
       ('39837', 'Colquitt', 'GA', 31.173000, -84.731000, 'UTC-5', 1),
       ('39840', 'Cuthbert', 'GA', 31.770600, -84.793600, 'UTC-5', 1),
       ('39841', 'Damascus', 'GA', 31.298400, -84.717500, 'UTC-5', 1),
       ('39842', 'Dawson', 'GA', 31.770300, -84.523800, 'UTC-5', 1),
       ('39845', 'Donalsonville', 'GA', 31.050500, -84.880100, 'UTC-6', 1),
       ('39846', 'Edison', 'GA', 31.560700, -84.738100, 'UTC-5', 1),
       ('39851', 'Fort Gaines', 'GA', 31.626400, -85.054800, 'UTC-5', 1),
       ('39852', 'Fowlstown', 'GA', 30.802400, -84.547100, 'UTC-5', 1),
       ('39854', 'Georgetown', 'GA', 31.885400, -85.105900, 'UTC-5', 1),
       ('39859', 'Iron City', 'GA', 31.013000, -84.813800, 'UTC-5', 1),
       ('39861', 'Jakin', 'GA', 31.182400, -85.012100, 'UTC-6', 1),
       ('39862', 'Leary', 'GA', 31.484900, -84.512800, 'UTC-5', 1),
       ('39866', 'Morgan', 'GA', 31.537400, -84.599400, 'UTC-5', 1),
       ('39867', 'Morris', 'GA', 31.834300, -84.925500, 'UTC-5', 1),
       ('39870', 'Newton', 'GA', 31.316400, -84.336700, 'UTC-5', 1),
       ('39877', 'Parrott', 'GA', 31.893900, -84.511200, 'UTC-5', 1),
       ('39885', 'Sasser', 'GA', 31.719100, -84.347900, 'UTC-5', 1),
       ('39886', 'Shellman', 'GA', 31.760800, -84.609200, 'UTC-5', 1),
       ('39897', 'Whigham', 'GA', 30.883600, -84.324600, 'UTC-5', 1),
       ('40122', 'Fort Knox', 'KY', 37.891100, -85.963600, 'UTC-6', 1),
       ('40129', 'Hillview', 'KY', 38.076400, -85.677400, 'UTC-6', 1),
       ('40166', 'Shepherdsville', 'KY', 37.988500, -85.715900, 'UTC-6', 1),
       ('40598', 'Lexington', 'KY', 38.077100, -84.529600, 'UTC-5', 1),
       ('40750', 'London', 'KY', 37.128900, -84.083300, 'UTC-5', 1),
       ('41021', 'Hebron', 'KY', 39.029000, -84.619500, 'UTC-5', 1),
       ('41025', 'Erlanger', 'KY', 39.060300, -84.630900, 'UTC-5', 1),
       ('43069', 'Reynoldsburg', 'OH', 39.955500, -82.799200, 'UTC-5', 1),
       ('43194', 'Lockbourne', 'OH', 39.809200, -82.972500, 'UTC-5', 1),
       ('43195', 'Groveport', 'OH', 39.861400, -82.891600, 'UTC-5', 1),
       ('45280', 'Cincinnati', 'OH', 39.162000, -84.456900, 'UTC-5', 1),
       ('46037', 'Fishers', 'IN', 39.955900, -85.960100, 'UTC-6', 1),
       ('46062', 'Noblesville', 'IN', 40.061700, -86.055500, 'UTC-5', 0),
       ('46085', 'Fishers', 'IN', 39.955600, -86.013900, 'UTC-5', 0),
       ('46213', 'Indianapolis', 'IN', 39.921300, -86.034400, 'UTC-5', 0),
       ('46262', 'Indianapolis', 'IN', 39.768400, -86.158000, 'UTC-5', 0),
       ('46288', 'Indianapolis', 'IN', 39.934700, -86.163300, 'UTC-5', 0),
       ('46296', 'Indianapolis', 'IN', 39.796000, -86.149500, 'UTC-5', 0),
       ('48033', 'Southfield', 'MI', 42.472300, -83.294000, 'UTC-5', 1),
       ('48193', 'Riverview', 'MI', 42.178200, -83.246100, 'UTC-5', 1),
       ('48480', 'Grand Blanc', 'MI', 42.918000, -83.617000, 'UTC-5', 1),
       ('48638', 'Saginaw', 'MI', 43.434300, -84.009100, 'UTC-5', 1),
       ('48951', 'Lansing', 'MI', 42.703500, -84.536500, 'UTC-5', 1),
       ('49037', 'Battle Creek', 'MI', 42.345300, -85.217800, 'UTC-5', 1),
       ('49519', 'Wyoming', 'MI', 42.897700, -85.718600, 'UTC-6', 1),
       ('49528', 'Grand Rapids', 'MI', 42.881100, -85.623900, 'UTC-6', 1),
       ('49534', 'Grand Rapids', 'MI', 43.014100, -85.754300, 'UTC-5', 1),
       ('50023', 'Ankeny', 'IA', 41.719400, -93.626600, 'UTC-6', 1),
       ('50099', 'Boone', 'IA', 42.059700, -93.880200, 'UTC-6', 1),
       ('50324', 'Windsor Heights', 'IA', 41.603200, -93.715200, 'UTC-6', 1),
       ('50982', 'Des Moines', 'IA', 41.600600, -93.608900, 'UTC-6', 1),
       ('50983', 'Des Moines', 'IA', 41.600600, -93.608900, 'UTC-6', 1),
       ('52734', 'Clinton', 'IA', 41.844400, -90.188500, 'UTC-6', 1),
       ('53548', 'Janesville', 'WI', 42.685400, -89.128700, 'UTC-6', 1),
       ('53774', 'Madison', 'WI', 43.046900, -89.374000, 'UTC-6', 1),
       ('54482', 'Stevens Point', 'WI', 44.556300, -89.518200, 'UTC-6', 1),
       ('55130', 'Saint Paul', 'MN', 44.973000, -93.082700, 'UTC-6', 1),
       ('55131', 'Saint Paul', 'MN', 44.973000, -93.082700, 'UTC-6', 1),
       ('55467', 'Minneapolis', 'MN', 44.986100, -93.270800, 'UTC-6', 1),
       ('56901', 'Washington', 'DC', 38.895200, -77.036500, 'UTC-5', 1),
       ('56915', 'Washington', 'DC', 38.895200, -77.036500, 'UTC-5', 1),
       ('56920', 'Washington', 'DC', 38.895200, -77.036500, 'UTC-5', 1),
       ('56933', 'Washington', 'DC', 38.895200, -77.036500, 'UTC-5', 1),
       ('56944', 'Washington', 'DC', 38.895200, -77.036500, 'UTC-5', 1),
       ('56972', 'Washington', 'DC', 38.895100, -77.036400, 'UTC-5', 1),
       ('57186', 'Sioux Falls', 'SD', 43.542400, -96.731200, 'UTC-6', 1),
       ('58803', 'Williston', 'ND', 48.146800, -103.619900, 'UTC-6', 1),
       ('60124', 'Elgin', 'IL', 42.029300, -88.374700, 'UTC-6', 1),
       ('60169', 'Hoffman Estates', 'IL', 42.049300, -88.106500, 'UTC-6', 1),
       ('60399', 'Wood Dale', 'IL', 41.954500, -87.937700, 'UTC-6', 1),
       ('60403', 'Crest Hill', 'IL', 41.554800, -88.098700, 'UTC-6', 1),
       ('60404', 'Shorewood', 'IL', 41.507600, -88.216900, 'UTC-6', 1),
       ('60418', 'Crestwood', 'IL', 41.644600, -87.741500, 'UTC-6', 1),
       ('60428', 'Markham', 'IL', 41.599800, -87.690600, 'UTC-6', 1),
       ('60484', 'University Park', 'IL', 41.441800, -87.710100, 'UTC-6', 1),
       ('60487', 'Tinley Park', 'IL', 41.563600, -87.834200, 'UTC-6', 1),
       ('60491', 'Homer Glen', 'IL', 41.602800, -87.959900, 'UTC-6', 1),
       ('60502', 'Aurora', 'IL', 41.784500, -88.261600, 'UTC-6', 1),
       ('60503', 'Aurora', 'IL', 41.719900, -88.254800, 'UTC-6', 1),
       ('60569', 'Aurora', 'IL', 41.812200, -88.217200, 'UTC-6', 1),
       ('60585', 'Plainfield', 'IL', 41.655800, -88.220300, 'UTC-6', 1),
       ('60586', 'Plainfield', 'IL', 41.564200, -88.217800, 'UTC-6', 1),
       ('60642', 'Chicago', 'IL', 41.900800, -87.652800, 'UTC-6', 1),
       ('60682', 'Chicago', 'IL', 41.837000, -87.685000, 'UTC-6', 1),
       ('60686', 'Chicago', 'IL', 41.875600, -87.637800, 'UTC-6', 1),
       ('60688', 'Chicago', 'IL', 41.872400, -87.668800, 'UTC-6', 1),
       ('60689', 'Chicago', 'IL', 41.874500, -87.635300, 'UTC-6', 1),
       ('60695', 'Chicago', 'IL', 41.883900, -87.631700, 'UTC-6', 1),
       ('60696', 'Chicago', 'IL', 41.868400, -87.664900, 'UTC-6', 1),
       ('60958', 'Pembroke Township', 'IL', 41.064600, -87.591700, 'UTC-6', 1),
       ('61705', 'Bloomington', 'IL', 40.440000, -89.067000, 'UTC-6', 1),
       ('62711', 'Springfield', 'IL', 39.765500, -89.729300, 'UTC-6', 1),
       ('62712', 'Springfield', 'IL', 39.753300, -89.580000, 'UTC-6', 1),
       ('63368', 'O Fallon', 'MO', 38.751300, -90.729600, 'UTC-6', 1),
       ('63380', 'Truesdale', 'MO', 38.811700, -91.130400, 'UTC-6', 1),
       ('64002', 'Lees Summit', 'MO', 38.928500, -94.398300, 'UTC-6', 1),
       ('64162', 'Kansas City', 'MO', 39.156200, -94.479700, 'UTC-6', 1),
       ('65897', 'Springfield', 'MO', 37.198700, -93.278400, 'UTC-6', 1),
       ('66630', 'Topeka', 'KS', 39.048300, -95.678000, 'UTC-6', 1),
       ('67843', 'Fort Dodge', 'KS', 37.730300, -99.937000, 'UTC-6', 1),
       ('68197', 'Omaha', 'NE', 41.256300, -95.940400, 'UTC-6', 1),
       ('68379', 'Julian', 'NE', 40.519900, -95.867400, 'UTC-6', 1),
       ('70097', 'Kenner', 'LA', 29.956500, -90.263500, 'UTC-6', 1),
       ('70873', 'Baton Rouge', 'LA', 30.530500, -91.116300, 'UTC-6', 1),
       ('70891', 'Baton Rouge', 'LA', 30.449200, -91.154700, 'UTC-6', 1),
       ('71150', 'Shreveport', 'LA', 32.505600, -93.743400, 'UTC-6', 1),
       ('71217', 'Monroe', 'LA', 32.511600, -92.084900, 'UTC-6', 1),
       ('72255', 'Little Rock', 'AR', 34.746400, -92.289400, 'UTC-6', 1),
       ('72260', 'Little Rock', 'AR', 34.739900, -92.340000, 'UTC-6', 1),
       ('72405', 'Jonesboro', 'AR', 35.779200, -90.766000, 'UTC-6', 1),
       ('72643', 'Lead Hill', 'MO', 36.940400, -92.952800, 'UTC-6', 1),
       ('72713', 'Bentonville', 'AR', 36.311500, -94.350300, 'UTC-6', 1),
       ('73025', 'Edmond', 'OK', 35.722000, -97.513300, 'UTC-6', 1),
       ('73039', 'Davis', 'OK', 34.506000, -97.113100, 'UTC-6', 1),
       ('73195', 'Oklahoma City', 'OK', 35.474000, -97.522700, 'UTC-6', 1),
       ('73960', 'Texhoma', 'TX', 36.505500, -101.782900, 'UTC-7', 1),
       ('74019', 'Claremore', 'OK', 36.280600, -95.603900, 'UTC-6', 1),
       ('74439', 'Braggs', 'OK', 35.676700, -95.177500, 'UTC-6', 1),
       ('75033', 'Frisco', 'TX', 33.255900, -96.885300, 'UTC-6', 1),
       ('75036', 'Frisco', 'TX', 33.149900, -96.824100, 'UTC-6', 1),
       ('75064', 'Irving', 'TX', 32.924700, -96.959800, 'UTC-6', 1),
       ('75072', 'Mckinney', 'TX', 33.197600, -96.615300, 'UTC-6', 1),
       ('75358', 'Dallas', 'TX', 32.794200, -96.765200, 'UTC-6', 1),
       ('75797', 'Big Sandy', 'TX', 32.576500, -95.131300, 'UTC-6', 1),
       ('76166', 'Fort Worth', 'TX', 32.753900, -97.336200, 'UTC-6', 1),
       ('76190', 'Fort Worth', 'TX', 32.742300, -97.331500, 'UTC-6', 1),
       ('77407', 'Richmond', 'TX', 29.662500, -95.727200, 'UTC-6', 1),
       ('77498', 'Sugar Land', 'TX', 29.639600, -95.650000, 'UTC-6', 1),
       ('77523', 'Baytown', 'TX', 29.770000, -94.860800, 'UTC-6', 1),
       ('78542', 'Edinburg', 'TX', 26.466100, -98.069500, 'UTC-6', 1),
       ('78633', 'Georgetown', 'TX', 30.717700, -97.754300, 'UTC-6', 1),
       ('78799', 'Austin', 'TX', 30.267200, -97.743100, 'UTC-6', 1),
       ('80023', 'Broomfield', 'CO', 39.961900, -105.014800, 'UTC-7', 1),
       ('80113', 'Englewood', 'CO', 39.640500, -104.961400, 'UTC-7', 1),
       ('80923', 'Colorado Springs', 'CO', 38.918900, -104.704500, 'UTC-7', 1),
       ('80927', 'Colorado Springs', 'CO', 38.928600, -104.658300, 'UTC-7', 1),
       ('80938', 'Colorado Springs', 'CO', 38.904700, -104.663400, 'UTC-7', 1),
       ('80939', 'Colorado Springs', 'CO', 38.877600, -104.677400, 'UTC-7', 1),
       ('80951', 'Colorado Springs', 'CO', 38.888100, -104.655600, 'UTC-7', 1),
       ('81403', 'Montrose', 'CO', 38.360200, -107.938100, 'UTC-7', 1),
       ('81507', 'Grand Junction', 'CO', 39.015700, -108.612900, 'UTC-7', 1),
       ('83414', 'Alta', 'WY', 43.888600, -110.949200, 'UTC-7', 1),
       ('83646', 'Meridian', 'ID', 43.649800, -116.430600, 'UTC-7', 1),
       ('84005', 'Eagle Mountain', 'UT', 40.380200, -111.991000, 'UTC-7', 1),
       ('84009', 'South Jordan', 'UT', 40.562200, -111.929700, 'UTC-7', 1),
       ('84045', 'Saratoga Springs', 'UT', 40.349500, -111.904300, 'UTC-7', 1),
       ('84081', 'West Jordan', 'UT', 40.603700, -112.041100, 'UTC-7', 1),
       ('84096', 'Herriman', 'UT', 40.514400, -112.032500, 'UTC-7', 1),
       ('84129', 'Salt Lake City', 'UT', 40.653100, -111.967400, 'UTC-7', 1),
       ('85083', 'Phoenix', 'AZ', 33.735200, -112.129400, 'UTC-7', 0),
       ('85117', 'Apache Junction', 'AZ', 33.328400, -111.327000, 'UTC-7', 1),
       ('85118', 'Gold Canyon', 'AZ', 33.328400, -111.350200, 'UTC-7', 1),
       ('85119', 'Apache Junction', 'AZ', 33.400100, -111.502800, 'UTC-7', 1),
       ('85120', 'Apache Junction', 'AZ', 33.393100, -111.576800, 'UTC-7', 1),
       ('85121', 'Bapchule', 'AZ', 33.140500, -111.912800, 'UTC-7', 0),
       ('85122', 'Casa Grande', 'AZ', 32.890500, -111.754000, 'UTC-7', 0),
       ('85127', 'Chandler Heights', 'AZ', 33.212500, -111.697000, 'UTC-7', 0),
       ('85128', 'Coolidge', 'AZ', 32.957400, -111.534400, 'UTC-7', 0),
       ('85130', 'Casa Grande', 'AZ', 32.815100, -111.705400, 'UTC-7', 0),
       ('85131', 'Eloy', 'AZ', 32.750900, -111.583300, 'UTC-7', 1),
       ('85132', 'Florence', 'AZ', 32.996900, -111.361200, 'UTC-7', 0),
       ('85135', 'Hayden', 'AZ', 33.004100, -110.786800, 'UTC-7', 1),
       ('85137', 'Kearny', 'AZ', 33.059400, -110.912300, 'UTC-7', 0),
       ('85138', 'Maricopa', 'AZ', 33.007300, -111.932400, 'UTC-7', 0),
       ('85139', 'Maricopa', 'AZ', 32.957600, -112.053400, 'UTC-7', 0),
       ('85140', 'San Tan Valley', 'AZ', 33.191100, -111.528000, 'UTC-7', 1),
       ('85141', 'Picacho', 'AZ', 32.668600, -111.454900, 'UTC-7', 0),
       ('85142', 'Queen Creek', 'AZ', 33.248700, -111.634300, 'UTC-7', 1),
       ('85143', 'San Tan Valley', 'AZ', 33.191100, -111.528000, 'UTC-7', 1),
       ('85144', 'San Tan Valley', 'AZ', 33.191100, -111.528000, 'UTC-7', 1),
       ('85145', 'Red Rock', 'AZ', 32.580000, -111.341000, 'UTC-7', 0),
       ('85147', 'Sacaton', 'AZ', 33.123400, -111.738400, 'UTC-7', 0),
       ('85172', 'Stanfield', 'AZ', 32.882300, -111.966000, 'UTC-7', 1),
       ('85173', 'Superior', 'AZ', 33.288700, -111.098500, 'UTC-7', 0),
       ('85178', 'Apache Junction', 'AZ', 33.405000, -111.547000, 'UTC-7', 0),
       ('85190', 'Tortilla Flat', 'AZ', 33.526400, -111.389200, 'UTC-7', 0),
       ('85191', 'Valley Farms', 'AZ', 32.982700, -111.442900, 'UTC-7', 0),
       ('85192', 'Winkelman', 'AZ', 33.005700, -110.772700, 'UTC-7', 0),
       ('85193', 'Casa Grande', 'AZ', 32.855400, -111.797300, 'UTC-7', 1),
       ('85194', 'Casa Grande', 'AZ', 32.898400, -111.626100, 'UTC-7', 1),
       ('85209', 'Mesa', 'AZ', 33.378200, -111.640600, 'UTC-7', 0),
       ('85295', 'Gilbert', 'AZ', 33.305400, -111.740800, 'UTC-7', 1),
       ('85298', 'Gilbert', 'AZ', 33.252200, -111.702200, 'UTC-7', 1),
       ('85388', 'Surprise', 'AZ', 33.613400, -112.451200, 'UTC-7', 0),
       ('85392', 'Avondale', 'AZ', 33.477700, -112.309300, 'UTC-7', 0),
       ('85396', 'Buckeye', 'AZ', 33.468000, -112.478700, 'UTC-7', 0),
       ('85658', 'Marana', 'AZ', 32.430500, -111.145900, 'UTC-7', 0),
       ('85755', 'Tucson', 'AZ', 32.422700, -110.976800, 'UTC-7', 0),
       ('85756', 'Tucson', 'AZ', 32.083900, -110.900400, 'UTC-7', 0),
       ('85757', 'Tucson', 'AZ', 32.133600, -111.097300, 'UTC-7', 0),
       ('86005', 'Flagstaff', 'AZ', 35.154500, -111.678900, 'UTC-7', 0),
       ('86315', 'Prescott Valley', 'AZ', 34.705500, -112.263900, 'UTC-7', 0),
       ('86409', 'Kingman', 'AZ', 35.263300, -114.022300, 'UTC-7', 0),
       ('87151', 'Albuquerque', 'NM', 35.023000, -106.855600, 'UTC-7', 1),
       ('87547', 'White Rock', 'NM', 35.827500, -106.203900, 'UTC-7', 1),
       ('87654', 'Spaceport City', 'NM', 32.990300, -106.969700, 'UTC-7', 1),
       ('88013', 'Las Cruces', 'NM', 32.583500, -106.771400, 'UTC-7', 1),
       ('89002', 'Henderson', 'NV', 36.000800, -114.958800, 'UTC-8', 1),
       ('89034', 'Mesquite', 'NV', 36.809000, -114.059100, 'UTC-7', 1),
       ('89037', 'Coyote Springs', 'NV', 36.157900, -114.934000, 'UTC-7', 1),
       ('89044', 'Henderson', 'NV', 35.902500, -115.178900, 'UTC-8', 1),
       ('89054', 'Sloan', 'NV', 35.935000, -115.205800, 'UTC-8', 1),
       ('89067', 'Moapa', 'NV', 36.659100, -114.665600, 'UTC-8', 1),
       ('89077', 'Henderson', 'NV', 36.039700, -114.981900, 'UTC-8', 1),
       ('89085', 'North Las Vegas', 'NV', 36.309700, -115.198100, 'UTC-8', 1),
       ('89087', 'North Las Vegas', 'NV', 36.220400, -115.145800, 'UTC-8', 1),
       ('89105', 'Las Vegas', 'NV', 36.086000, -115.147100, 'UTC-8', 1),
       ('89140', 'Las Vegas', 'NV', 36.086000, -115.147100, 'UTC-8', 1),
       ('89157', 'Las Vegas', 'NV', 36.175000, -115.137200, 'UTC-8', 1),
       ('89161', 'Las Vegas', 'NV', 36.000400, -115.363900, 'UTC-8', 1),
       ('89162', 'Las Vegas', 'NV', 36.172500, -115.141400, 'UTC-8', 1),
       ('89165', 'Las Vegas', 'NV', 36.330200, -115.325700, 'UTC-8', 1),
       ('89166', 'Las Vegas', 'NV', 36.326500, -115.339800, 'UTC-8', 1),
       ('89169', 'Las Vegas', 'NV', 36.123400, -115.142900, 'UTC-8', 1),
       ('89178', 'Las Vegas', 'NV', 35.997700, -115.286100, 'UTC-8', 1),
       ('89179', 'Las Vegas', 'NV', 36.254200, -115.526900, 'UTC-8', 1),
       ('89183', 'Las Vegas', 'NV', 35.995900, -115.157600, 'UTC-8', 1),
       ('89437', 'Sparks', 'NV', 39.626900, -119.708100, 'UTC-8', 1),
       ('89441', 'Sparks', 'NV', 39.658200, -119.695400, 'UTC-8', 1),
       ('89508', 'Reno', 'NV', 39.678100, -119.938300, 'UTC-8', 1),
       ('89519', 'Reno', 'NV', 39.481400, -119.859100, 'UTC-8', 1),
       ('89555', 'Reno', 'NV', 39.524600, -119.812500, 'UTC-8', 1),
       ('90090', 'Dodgertown', 'CA', 34.072500, -118.241800, 'UTC-8', 1),
       ('90134', 'Los Angeles', 'CA', 34.052200, -118.243700, 'UTC-8', 1),
       ('90189', 'Los Angeles', 'CA', 34.051500, -118.255900, 'UTC-8', 1),
       ('90895', 'Carson', 'CA', 33.839200, -118.220200, 'UTC-8', 1),
       ('90899', 'Long Beach', 'CA', 33.767000, -118.189200, 'UTC-8', 1),
       ('91008', 'Duarte', 'CA', 34.149000, -117.964400, 'UTC-8', 1),
       ('91199', 'Pasadena', 'CA', 34.147800, -118.143600, 'UTC-8', 1),
       ('92010', 'Carlsbad', 'CA', 33.163900, -117.300900, 'UTC-8', 1),
       ('92011', 'Carlsbad', 'CA', 33.107200, -117.294300, 'UTC-8', 1),
       ('92081', 'Vista', 'CA', 33.164400, -117.240300, 'UTC-8', 1),
       ('92247', 'La Quinta', 'CA', 33.673600, -116.295100, 'UTC-7', 1),
       ('92248', 'La Quinta', 'CA', 33.673600, -116.295100, 'UTC-7', 1),
       ('92331', 'Fontana', 'CA', 34.092200, -117.461200, 'UTC-8', 1),
       ('92344', 'Hesperia', 'CA', 34.423900, -117.407500, 'UTC-8', 1),
       ('92395', 'Victorville', 'CA', 34.501600, -117.294400, 'UTC-8', 1),
       ('92609', 'El Toro', 'CA', 33.624000, -117.690800, 'UTC-8', 1),
       ('92617', 'Irvine', 'CA', 33.642500, -117.841700, 'UTC-8', 1),
       ('92637', 'Laguna Woods', 'CA', 33.610300, -117.725300, 'UTC-8', 1),
       ('92809', 'Anaheim', 'CA', 33.842600, -117.938800, 'UTC-8', 1),
       ('93290', 'Visalia', 'CA', 36.329100, -119.292500, 'UTC-8', 1),
       ('93314', 'Bakersfield', 'CA', 35.386300, -119.170000, 'UTC-8', 1),
       ('93475', 'Oceano', 'CA', 35.100400, -120.611100, 'UTC-8', 1),
       ('93619', 'Clovis', 'CA', 36.843200, -119.651800, 'UTC-8', 1),
       ('93636', 'Madera', 'CA', 36.952800, -119.880600, 'UTC-8', 1),
       ('93723', 'Fresno', 'CA', 36.786300, -119.953200, 'UTC-8', 1),
       ('93730', 'Fresno', 'CA', 36.887800, -119.758900, 'UTC-8', 1),
       ('93737', 'Fresno', 'CA', 36.747700, -119.772400, 'UTC-8', 1),
       ('94158', 'San Francisco', 'CA', 37.769400, -122.386700, 'UTC-8', 1),
       ('94505', 'Discovery Bay', 'CA', 37.898900, -121.605400, 'UTC-8', 1),
       ('94582', 'San Ramon', 'CA', 37.763600, -121.915500, 'UTC-8', 1),
       ('94622', 'Oakland', 'CA', 37.799000, -122.233700, 'UTC-8', 1),
       ('95214', 'Stockton', 'CA', 37.905300, -121.226200, 'UTC-8', 1),
       ('95391', 'Tracy', 'CA', 37.769500, -121.539700, 'UTC-8', 1),
       ('95467', 'Hidden Valley Lake', 'CA', 38.803600, -122.540700, 'UTC-8', 1),
       ('95757', 'Elk Grove', 'CA', 38.408100, -121.429400, 'UTC-8', 1),
       ('95811', 'Sacramento', 'CA', 38.576200, -121.488000, 'UTC-8', 1),
       ('96201', 'APO AA', '', 34.716700, 128.583300, 'UTC+9', 0),
       ('96202', 'APO AA', '', 34.716700, 128.583300, 'UTC+9', 0),
       ('96203', 'APO AA', '', 37.533900, 126.977500, 'UTC+9', 0),
       ('96204', 'APO AA', '', 37.533900, 126.977500, 'UTC+9', 0),
       ('96205', 'APO AA', '', 37.533900, 126.977500, 'UTC+9', 0),
       ('96206', 'APO AA', '', 37.533900, 126.977500, 'UTC+9', 0),
       ('96207', 'APO AA', '', 37.533900, 126.977500, 'UTC+9', 0),
       ('96208', 'APO AA', '', 37.874700, 127.734200, 'UTC+9', 0),
       ('96212', 'APO AA', '', 35.870300, 128.591100, 'UTC+9', 0),
       ('96213', 'APO AA', '', 35.870300, 128.591100, 'UTC+9', 0),
       ('96214', 'APO AA', '', 35.234200, 128.881100, 'UTC+9', 0),
       ('96216', 'APO AA', '', 34.780000, 127.061500, 'UTC+9', 0),
       ('96218', 'APO AA', '', 35.870300, 128.591100, 'UTC+9', 0),
       ('96220', 'APO AA', '', 33.401700, 126.546100, 'UTC+9', 0),
       ('96224', 'APO AA', '', 37.921100, 127.062600, 'UTC+9', 0),
       ('96231', 'APO AA', '', 36.321400, 127.419700, 'UTC+9', 0),
       ('96236', 'APO AA', '', 33.600000, 130.416700, 'UTC+9', 0),
       ('96257', 'APO AA', '', 37.754000, 127.025500, 'UTC+9', 0),
       ('96258', 'APO AA', '', 37.754000, 127.025500, 'UTC+9', 0),
       ('96259', 'APO AA', '', 35.102800, 129.040300, 'UTC+9', 0),
       ('96260', 'APO AA', '', 35.992500, 128.397900, 'UTC+9', 0),
       ('96261', 'APO AA', '', 37.291100, 127.008900, 'UTC+9', 0),
       ('96264', 'APO AA', '', 35.978600, 126.711400, 'UTC+9', 0),
       ('96266', 'APO AA', '', 37.152200, 127.070600, 'UTC+9', 0),
       ('96267', 'APO AA', '', 37.152200, 127.070600, 'UTC+9', 0),
       ('96269', 'FPO AA', '', 35.064200, 128.765300, 'UTC+9', 0),
       ('96271', 'APO AA', '', 36.962200, 127.031100, 'UTC+9', 0),
       ('96272', 'APO AA', '', 36.962200, 127.031100, 'UTC+9', 0),
       ('96276', 'APO AA', '', 37.566000, 126.978400, 'UTC+9', 0),
       ('96278', 'APO AA', '', 37.090600, 127.029600, 'UTC+9', 0),
       ('96283', 'APO AA', '', 34.958600, 126.972800, 'UTC+9', 0),
       ('96284', 'APO AA', '', 34.958600, 126.972800, 'UTC+9', 0),
       ('96306', 'FPO AA', '', 35.442700, 139.369300, 'UTC+9', 0),
       ('96310', 'FPO AA', '', 34.163000, 132.220000, 'UTC+9', 0),
       ('96313', 'FPO AA', '', 35.491900, 139.475000, 'UTC+9', 0),
       ('96318', 'APO AA', '', 40.686800, 141.389700, 'UTC+9', 0),
       ('96319', 'APO AA', '', 40.686800, 141.389700, 'UTC+9', 0),
       ('96321', 'FPO AA', '', 33.159200, 129.722800, 'UTC+9', 0),
       ('96322', 'FPO AA', '', 33.159200, 129.722800, 'UTC+9', 0),
       ('96323', 'APO AA', '', 35.748500, 139.348500, 'UTC+9', 0),
       ('96325', 'APO AA', '', 35.748500, 139.348500, 'UTC+9', 0),
       ('96326', 'APO AA', '', 35.748500, 139.348500, 'UTC+9', 0),
       ('96328', 'APO AA', '', 35.748500, 139.348500, 'UTC+9', 0),
       ('96330', 'APO AA', '', 35.748500, 139.348500, 'UTC+9', 0),
       ('96336', 'APO AA', '', 35.689500, 139.691700, 'UTC+9', 0),
       ('96337', 'APO AA', '', 35.689500, 139.691700, 'UTC+9', 0),
       ('96338', 'APO AA', '', 35.689500, 139.691700, 'UTC+9', 0),
       ('96339', 'APO AA', '', 35.513800, 139.393700, 'UTC+9', 0),
       ('96343', 'APO AA', '', 35.689500, 139.691700, 'UTC+9', 0),
       ('96347', 'FPO AA', '', 35.433300, 139.650000, 'UTC+9', 0),
       ('96348', 'FPO AA', '', 35.433300, 139.650000, 'UTC+9', 0),
       ('96349', 'FPO AA', '', 35.283600, 139.667200, 'UTC+9', 0),
       ('96350', 'FPO AA', '', 35.283600, 139.667200, 'UTC+9', 0),
       ('96362', 'FPO AA', '', 26.300000, 127.766700, 'UTC+9', 0),
       ('96364', 'APO AA', '', 26.365200, 127.758600, 'UTC+9', 0),
       ('96365', 'APO STA', '', 26.365200, 127.758600, 'UTC+9', 0),
       ('96367', 'APO AA', '', 26.365200, 127.758600, 'UTC+9', 0),
       ('96368', 'APO AA', '', 26.365200, 127.758600, 'UTC+9', 0),
       ('96370', 'FPO AA', '', 26.350000, 127.766700, 'UTC+9', 0),
       ('96372', 'FPO AA', '', 26.287200, 127.773100, 'UTC+9', 0),
       ('96374', 'APO AA', '', 26.264400, 127.724400, 'UTC+9', 0),
       ('96375', 'FPO AA', '', 26.264400, 127.724400, 'UTC+9', 0),
       ('96376', 'APO AA', '', 26.264400, 127.724400, 'UTC+9', 0),
       ('96377', 'FPO AA', '', 26.390500, 127.858800, 'UTC+9', 0),
       ('96378', 'APO AA', '', 26.308600, 127.780400, 'UTC+9', 0),
       ('96379', 'FPO AA', '', 26.308600, 127.780400, 'UTC+9', 0),
       ('96382', 'FPO AA', '', 27.000000, 142.166700, 'UTC+9', 0),
       ('96390', 'APO AA', '', -23.697000, 133.881800, 'UTC+9.5', 0),
       ('96407', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96408', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96409', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96410', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96411', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96415', 'FPO AA', '', 15.331200, 120.589800, 'UTC+8', 0),
       ('96419', 'FPO AA', '', 15.142300, 120.975700, 'UTC+8', 0),
       ('96428', 'APO AA', '', 14.604200, 120.982200, 'UTC+8', 0),
       ('96431', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96432', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96434', 'APO AA', '', 15.150000, 120.583300, 'UTC+8', 0),
       ('96440', 'APO AA', '', 14.604200, 120.982200, 'UTC+8', 0),
       ('96445', 'FPO AA', '', 15.142300, 120.975700, 'UTC+8', 0),
       ('96447', 'APO AA', '', 16.615900, 120.316600, 'UTC+8', 0),
       ('96450', 'FPO AA', '', 14.794400, 120.271400, 'UTC+8', 0),
       ('96451', 'FPO AA', '', 14.794400, 120.271400, 'UTC+8', 0),
       ('96452', 'FPO AA', '', 14.794400, 120.271400, 'UTC+8', 0),
       ('96454', 'FPO AA', '', 14.794400, 120.271400, 'UTC+8', 0),
       ('96456', 'FPO AA', '', 15.331200, 120.589800, 'UTC+8', 0),
       ('96468', 'APO AA', '', 13.754000, 100.501400, 'UTC+7', 0),
       ('96498', 'APO AA', '', 14.748400, 120.965000, 'UTC+8', 0),
       ('96505', 'FPO AA', '', 51.880000, -176.658100, 'UTC-10', 0),
       ('96506', 'FPO AA', '', 51.880000, -176.658100, 'UTC-10', 0),
       ('96507', 'FPO AA', '', 51.567200, 178.877500, 'UTC-10', 0),
       ('96508', 'APO AA', '', 45.783300, -86.700100, 'UTC-6', 0),
       ('96509', 'APO AA', '', 64.300600, -149.112800, 'UTC-9', 0),
       ('96510', 'APO AA', '', 64.736100, -156.937200, 'UTC-10', 0),
       ('96511', 'FPO AA', '', 34.232200, 132.566600, 'UTC+9', 0),
       ('96512', 'APO AA', '', 52.724200, 174.118900, 'UTC-10', 0),
       ('96513', 'APO AA', '', 58.688300, -156.661400, 'UTC-10', 0),
       ('96514', 'FPO AA', '', 28.228000, -177.389000, 'UTC-10', 0),
       ('96516', 'FPO AA', '', 28.228000, -177.389000, 'UTC-10', 0),
       ('96517', 'FPO AA', '', 34.232200, 132.566600, 'UTC+9', 0),
       ('96518', 'APO AA', '', 19.281100, 166.643400, 'UTC+12', 0),
       ('96520', 'APO AA', '', -6.214600, 106.845100, 'UTC+7', 0),
       ('96521', 'FPO AA', '', 22.278300, 114.174700, 'UTC+8', 0),
       ('96522', 'FPO AA', '', 22.278300, 114.174700, 'UTC+8', 0),
       ('96531', 'FPO AA', '', -43.533300, 172.633300, 'UTC+13', 0),
       ('96534', 'FPO AA', '', 1.289700, 103.850100, 'UTC+8', 0),
       ('96539', 'FPO AA', '', 13.475700, 144.748900, 'UTC+10', 0),
       ('96540', 'FPO AA', '', 13.475700, 144.748900, 'UTC+10', 0),
       ('96541', 'APO AA', '', 13.475700, 144.748900, 'UTC+10', 0),
       ('96542', 'APO AA', '', 13.475700, 144.748900, 'UTC+10', 0),
       ('96543', 'APO AA', '', 13.475700, 144.748900, 'UTC+10', 0),
       ('96546', 'APO AA', '', 13.754000, 100.501400, 'UTC+7', 0),
       ('96548', 'APO AA', '', -23.697500, 133.883600, 'UTC+9.5', 0),
       ('96549', 'APO AA', '', -35.306500, 149.116200, 'UTC+11', 0),
       ('96550', 'FPO AA', '', -21.930600, 114.120900, 'UTC+8', 0),
       ('96551', 'APO AA', '', -37.847000, 144.980900, 'UTC+11', 0),
       ('96552', 'APO AA', '', -31.199800, 136.832600, 'UTC+10.5', 0),
       ('96553', 'APO AA', '', -33.867800, 151.207300, 'UTC+11', 0),
       ('96554', 'APO AA', '', -33.867800, 151.207300, 'UTC+11', 0),
       ('96556', 'APO AA', '', 19.754200, -155.585800, 'UTC-10', 0),
       ('96558', 'APO AA', '', 19.754200, -155.585800, 'UTC-10', 0),
       ('96598', 'FPO AA', '', -89.997600, 139.272900, 'UTC+13', 0),
       ('96599', 'FPO AA', '', -77.846000, 166.676000, 'UTC+13', 0),
       ('96960', 'Marshall Islands', 'MH', 7.112800, 171.237000, 'UTC+12', 0),
       ('96970', 'Ebeye', 'MH', 8.786000, 167.736500, 'UTC+12', 0),
       ('97003', 'Beaverton', 'OR', 45.520100, -122.860400, 'UTC-8', 1),
       ('97079', 'Beaverton', 'OR', 45.452000, -122.789300, 'UTC-8', 1),
       ('97086', 'Happy Valley', 'OR', 45.444600, -122.537200, 'UTC-8', 1),
       ('97089', 'Damascus', 'OR', 45.417600, -122.459000, 'UTC-8', 1),
       ('97129', 'Hillsboro', 'OR', 45.538700, -122.963600, 'UTC-8', 1),
       ('97250', 'Portland', 'OR', 45.523500, -122.676200, 'UTC-8', 1),
       ('97252', 'Portland', 'OR', 45.523500, -122.676200, 'UTC-8', 1),
       ('97317', 'Salem', 'OR', 44.902600, -122.907400, 'UTC-8', 1),
       ('97471', 'Roseburg', 'OR', 43.227000, -123.515800, 'UTC-8', 1),
       ('97475', 'Springfield', 'OR', 44.046200, -123.022000, 'UTC-8', 1),
       ('97703', 'Bend', 'OR', 44.091500, -121.407300, 'UTC-8', 1),
       ('98077', 'Woodinville', 'WA', 47.752900, -122.058200, 'UTC-8', 1),
       ('98087', 'Lynnwood', 'WA', 47.862000, -122.253200, 'UTC-8', 1),
       ('98089', 'Kent', 'WA', 47.387100, -122.202300, 'UTC-8', 1),
       ('98127', 'Seattle', 'WA', 47.606300, -122.330800, 'UTC-8', 1),
       ('98139', 'Seattle', 'WA', 47.647300, -122.399900, 'UTC-8', 1),
       ('98141', 'Seattle', 'WA', 47.615700, -122.344500, 'UTC-8', 1),
       ('98165', 'Seattle', 'WA', 47.716100, -122.300400, 'UTC-8', 1),
       ('98170', 'Seattle', 'WA', 47.609600, -122.331700, 'UTC-8', 1),
       ('98175', 'Seattle', 'WA', 47.716100, -122.300400, 'UTC-8', 1),
       ('98194', 'Seattle', 'WA', 47.602400, -122.326000, 'UTC-8', 1),
       ('98213', 'Everett', 'WA', 47.945100, -122.226900, 'UTC-8', 1),
       ('98391', 'Bonney Lake', 'WA', 47.143000, -122.164400, 'UTC-8', 1),
       ('98417', 'Tacoma', 'WA', 47.206100, -122.482200, 'UTC-8', 1),
       ('98419', 'Tacoma', 'WA', 47.206100, -122.482200, 'UTC-8', 1),
       ('98490', 'Tacoma', 'WA', 47.206100, -122.482200, 'UTC-8', 1),
       ('98496', 'Lakewood', 'WA', 47.166600, -122.508900, 'UTC-8', 1),
       ('98511', 'Tumwater', 'WA', 46.961600, -123.028300, 'UTC-8', 1),
       ('99354', 'Richland', 'WA', 46.325700, -119.306700, 'UTC-8', 1),
       ('99529', 'Anchorage', 'AK', 61.151500, -149.944300, 'UTC-9', 1),
       ('99530', 'Anchorage', 'AK', 61.151500, -149.944300, 'UTC-9', 1),
       ('99545', 'Kongiganak', 'AK', 59.959900, -162.891900, 'UTC-9', 1),
       ('99623', 'Wasilla', 'AK', 61.546300, -149.590100, 'UTC-9', 1),
       ('99629', 'Wasilla', 'AK', 61.584100, -149.443600, 'UTC-9', 1),
       ('99731', 'Fort Greely', 'AK', 63.952000, -146.451000, 'UTC-9', 1),
       ('99812', 'Juneau', 'AK', 58.327100, -134.474200, 'UTC-9', 1);
