text: INSERT INTO city(name, county_id) VALUES ('Barrington', 2266);
  INSERT INTO city(name, county_id) VALUES ('Bristol', 2266);
  INSERT INTO city(name, county_id) VALUES ('Warren', 2266);
  INSERT INTO city(name, county_id) VALUES ('Johnston', 2269);
  INSERT INTO city(name, county_id) VALUES ('Bristol', 1730);
  INSERT INTO city(name, county_id) VALUES ('Forest Hills', 1830);
  INSERT INTO city(name, county_id) VALUES ('Killingly', 307);
  INSERT INTO city(name, county_id) VALUES ('Albion', 2269);
  INSERT INTO city(name, county_id) VALUES ('East Greenwich', 2267);
  INSERT INTO city(name, county_id) VALUES ('Canton', 1208);
  INSERT INTO city(name, county_id) VALUES ('Reading', 1206);
  INSERT INTO city(name, county_id) VALUES ('Dedham', 1208);
  INSERT INTO city(name, county_id) VALUES ('West Warwick', 2267);
  INSERT INTO city(name, county_id) VALUES ('Bedford', 1731);
  INSERT INTO city(name, county_id) VALUES ('Wrentham', 1208);
  INSERT INTO city(name, county_id) VALUES ('Lynnfield', 1202);
  INSERT INTO city(name, county_id) VALUES ('North Smithfield', 2269);
  INSERT INTO city(name, county_id) VALUES ('Lincoln', 2269);
  INSERT INTO city(name, county_id) VALUES ('Flushing', 1830);
  INSERT INTO city(name, county_id) VALUES ('Narragansett', 2270);
  INSERT INTO city(name, county_id) VALUES ('North Providence', 2269);
  INSERT INTO city(name, county_id) VALUES ('Andover', 1202);
  INSERT INTO city(name, county_id) VALUES ('Seekonk', 1200);
  INSERT INTO city(name, county_id) VALUES ('Burlington', 1206);
  INSERT INTO city(name, county_id) VALUES ('Coventry', 2267);
  INSERT INTO city(name, county_id) VALUES ('Riverside', 2269);
  INSERT INTO city(name, county_id) VALUES ('Millville', 1211);
  INSERT INTO city(name, county_id) VALUES ('Arlington', 1206);
  INSERT INTO city(name, county_id) VALUES ('Maplewood', 1742);
  INSERT INTO city(name, county_id) VALUES ('Manville', 2269);
  INSERT INTO city(name, county_id) VALUES ('Plymouth', 1209);
  INSERT INTO city(name, county_id) VALUES ('West Greenwich', 2267);
  INSERT INTO city(name, county_id) VALUES ('Brooklyn', 307);
  INSERT INTO city(name, county_id) VALUES ('Saunderstown', 2270);
  INSERT INTO city(name, county_id) VALUES ('Smithfield', 2269);
  INSERT INTO city(name, county_id) VALUES ('Dorchester', 1210);
  INSERT INTO city(name, county_id) VALUES ('East Walpole', 1208);
  INSERT INTO city(name, county_id) VALUES ('Rumford', 2269);
  INSERT INTO city(name, county_id) VALUES ('Fairhaven', 1200);
  INSERT INTO city(name, county_id) VALUES ('North Scituate', 2269);
  INSERT INTO city(name, county_id) VALUES ('Wakefield', 1206);
  INSERT INTO city(name, county_id) VALUES ('Needham', 1208);
  INSERT INTO city(name, county_id) VALUES ('Hingham', 1209);
  INSERT INTO city(name, county_id) VALUES ('Eastham', 1198);
  INSERT INTO city(name, county_id) VALUES ('Jamestown', 2268);
  INSERT INTO city(name, county_id) VALUES ('Watertown', 1206);
  INSERT INTO city(name, county_id) VALUES ('Rehoboth', 1200);
  INSERT INTO city(name, county_id) VALUES ('Sharon', 1208);
  INSERT INTO city(name, county_id) VALUES ('Rego Park', 1830);
  INSERT INTO city(name, county_id) VALUES ('Pacific Palisades', 198);
  INSERT INTO city(name, county_id) VALUES ('Windsor', 301);
  INSERT INTO city(name, county_id) VALUES ('Tiverton', 2268);
  INSERT INTO city(name, county_id) VALUES ('Bellingham', 1208);
  INSERT INTO city(name, county_id) VALUES ('Cumberland', 2269);
  INSERT INTO city(name, county_id) VALUES ('Walpole', 1208);
  INSERT INTO city(name, county_id) VALUES ('Waban', 1206);
  INSERT INTO city(name, county_id) VALUES ('Acton', 1206);
  INSERT INTO city(name, county_id) VALUES ('Wethersfield', 301);
  INSERT INTO city(name, county_id) VALUES ('South Boston', 1210);
  INSERT INTO city(name, county_id) VALUES ('Westford', 1206);
  INSERT INTO city(name, county_id) VALUES ('Westport', 1200);
  INSERT INTO city(name, county_id) VALUES ('East Boston', 1210);
  INSERT INTO city(name, county_id) VALUES ('Foster', 2269);
  INSERT INTO city(name, county_id) VALUES ('Chelmsford', 1206);
  INSERT INTO city(name, county_id) VALUES ('Chestnut Hill', 1210);
  INSERT INTO city(name, county_id) VALUES ('Foxborough', 1208);
  INSERT INTO city(name, county_id) VALUES ('Charlestown', 2270);
  INSERT INTO city(name, county_id) VALUES ('Cotuit', 1198);
  INSERT INTO city(name, county_id) VALUES ('Sagamore Beach', 1198);
  INSERT INTO city(name, county_id) VALUES ('Roxbury', 1210);
  INSERT INTO city(name, county_id) VALUES ('Stoughton', 1208);
  INSERT INTO city(name, county_id) VALUES ('Weston', 1206);
  INSERT INTO city(name, county_id) VALUES ('Milton', 1208);
  INSERT INTO city(name, county_id) VALUES ('Lakewood Ranch', 352);
  INSERT INTO city(name, county_id) VALUES ('Mattapan', 1210);
  INSERT INTO city(name, county_id) VALUES ('Brookline', 1208);
  INSERT INTO city(name, county_id) VALUES ('South Attleboro', 1200);
  INSERT INTO city(name, county_id) VALUES ('Swansea', 1200);
  INSERT INTO city(name, county_id) VALUES ('Holden', 1211);
  
  INSERT INTO city(name, county_id) VALUES ('Abington', 1209);
  INSERT INTO city(name, county_id) VALUES ('Acushnet', 1200);
  INSERT INTO city(name, county_id) VALUES ('Adams', 1199);
  INSERT INTO city(name, county_id) VALUES ('Alford', 1199);
  INSERT INTO city(name, county_id) VALUES ('Aquinnah', 1201);
  INSERT INTO city(name, county_id) VALUES ('Ashburnham', 1211);
  INSERT INTO city(name, county_id) VALUES ('Ashby', 1206);
  INSERT INTO city(name, county_id) VALUES ('Ashfield', 1203);
  INSERT INTO city(name, county_id) VALUES ('Ashland', 1206);
  INSERT INTO city(name, county_id) VALUES ('Athol', 1211);
  INSERT INTO city(name, county_id) VALUES ('Auburn', 1211);
  INSERT INTO city(name, county_id) VALUES ('Avon', 1208);
  INSERT INTO city(name, county_id) VALUES ('Ayer', 1206);
  INSERT INTO city(name, county_id) VALUES ('Barre', 1211);
  INSERT INTO city(name, county_id) VALUES ('Becket', 1199);
  INSERT INTO city(name, county_id) VALUES ('Bedford', 1206);
  INSERT INTO city(name, county_id) VALUES ('Belchertown', 1205);
  INSERT INTO city(name, county_id) VALUES ('Belmont', 1206);
  INSERT INTO city(name, county_id) VALUES ('Berkley', 1200);
  INSERT INTO city(name, county_id) VALUES ('Berlin', 1211);
  INSERT INTO city(name, county_id) VALUES ('Bernardston', 1203);
  INSERT INTO city(name, county_id) VALUES ('Billerica', 1206);
  INSERT INTO city(name, county_id) VALUES ('Blackstone', 1211);
  INSERT INTO city(name, county_id) VALUES ('Blandford', 1204);
  INSERT INTO city(name, county_id) VALUES ('Bolton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Bourne', 1198);
  INSERT INTO city(name, county_id) VALUES ('Boxborough', 1206);
  INSERT INTO city(name, county_id) VALUES ('Boxford', 1202);
  INSERT INTO city(name, county_id) VALUES ('Boylston', 1211);
  INSERT INTO city(name, county_id) VALUES ('Brewster', 1198);
  INSERT INTO city(name, county_id) VALUES ('Brighton', 1210);
  INSERT INTO city(name, county_id) VALUES ('Brimfield', 1204);
  INSERT INTO city(name, county_id) VALUES ('Brookfield', 1211);
  INSERT INTO city(name, county_id) VALUES ('Buckland', 1203);
  INSERT INTO city(name, county_id) VALUES ('Carlisle', 1206);
  INSERT INTO city(name, county_id) VALUES ('Carver', 1209);
  INSERT INTO city(name, county_id) VALUES ('Charlemont', 1203);
  INSERT INTO city(name, county_id) VALUES ('Charlestown', 1210);
  INSERT INTO city(name, county_id) VALUES ('Charlton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Chatham', 1198);
  INSERT INTO city(name, county_id) VALUES ('Cheshire', 1199);
  INSERT INTO city(name, county_id) VALUES ('Chester', 1204);
  INSERT INTO city(name, county_id) VALUES ('Chesterfield', 1205);
  INSERT INTO city(name, county_id) VALUES ('Chilmark', 1201);
  INSERT INTO city(name, county_id) VALUES ('Clarksburg', 1199);
  INSERT INTO city(name, county_id) VALUES ('Clinton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Cohasset', 1208);
  INSERT INTO city(name, county_id) VALUES ('Colrain', 1203);
  INSERT INTO city(name, county_id) VALUES ('Concord', 1206);
  INSERT INTO city(name, county_id) VALUES ('Conway', 1203);
  INSERT INTO city(name, county_id) VALUES ('Cummington', 1205);
  INSERT INTO city(name, county_id) VALUES ('Dalton', 1199);
  INSERT INTO city(name, county_id) VALUES ('Danvers', 1202);
  INSERT INTO city(name, county_id) VALUES ('Dartmouth', 1200);
  INSERT INTO city(name, county_id) VALUES ('Deerfield', 1203);
  INSERT INTO city(name, county_id) VALUES ('Dennis', 1198);
  INSERT INTO city(name, county_id) VALUES ('Dighton', 1200);
  INSERT INTO city(name, county_id) VALUES ('Douglas', 1211);
  INSERT INTO city(name, county_id) VALUES ('Dover', 1208);
  INSERT INTO city(name, county_id) VALUES ('Dracut', 1206);
  INSERT INTO city(name, county_id) VALUES ('Dudley', 1211);
  INSERT INTO city(name, county_id) VALUES ('Dunstable', 1206);
  INSERT INTO city(name, county_id) VALUES ('Duxbury', 1209);
  INSERT INTO city(name, county_id) VALUES ('East Bridgewater', 1209);
  INSERT INTO city(name, county_id) VALUES ('East Brookfield', 1211);
  INSERT INTO city(name, county_id) VALUES ('East Longmeadow', 1204);
  INSERT INTO city(name, county_id) VALUES ('Easton', 1200);
  INSERT INTO city(name, county_id) VALUES ('Edgartown', 1201);
  INSERT INTO city(name, county_id) VALUES ('Egremont', 1199);
  INSERT INTO city(name, county_id) VALUES ('Erving', 1203);
  INSERT INTO city(name, county_id) VALUES ('Essex', 1202);
  INSERT INTO city(name, county_id) VALUES ('Falmouth', 1198);
  INSERT INTO city(name, county_id) VALUES ('Florida', 1199);
  INSERT INTO city(name, county_id) VALUES ('Freetown', 1200);
  INSERT INTO city(name, county_id) VALUES ('Georgetown', 1202);
  INSERT INTO city(name, county_id) VALUES ('Gill', 1203);
  INSERT INTO city(name, county_id) VALUES ('Goshen', 1205);
  INSERT INTO city(name, county_id) VALUES ('Gosnold', 1201);
  INSERT INTO city(name, county_id) VALUES ('Grafton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Granby', 1205);
  INSERT INTO city(name, county_id) VALUES ('Granville', 1204);
  INSERT INTO city(name, county_id) VALUES ('Great Barrington', 1199);
  INSERT INTO city(name, county_id) VALUES ('Groton', 1206);
  INSERT INTO city(name, county_id) VALUES ('Groveland', 1202);
  INSERT INTO city(name, county_id) VALUES ('Hadley', 1205);
  INSERT INTO city(name, county_id) VALUES ('Halifax', 1209);
  INSERT INTO city(name, county_id) VALUES ('Hamilton', 1202);
  INSERT INTO city(name, county_id) VALUES ('Hampden', 1204);
  INSERT INTO city(name, county_id) VALUES ('Hancock', 1199);
  INSERT INTO city(name, county_id) VALUES ('Hanover', 1209);
  INSERT INTO city(name, county_id) VALUES ('Hanson', 1209);
  INSERT INTO city(name, county_id) VALUES ('Hardwick', 1211);
  INSERT INTO city(name, county_id) VALUES ('Harvard', 1211);
  INSERT INTO city(name, county_id) VALUES ('Harwich', 1198);
  INSERT INTO city(name, county_id) VALUES ('Hatfield', 1205);
  INSERT INTO city(name, county_id) VALUES ('Hawley', 1203);
  INSERT INTO city(name, county_id) VALUES ('Heath', 1203);
  INSERT INTO city(name, county_id) VALUES ('Hinsdale', 1199);
  INSERT INTO city(name, county_id) VALUES ('Holbrook', 1208);
  INSERT INTO city(name, county_id) VALUES ('Holland', 1204);
  INSERT INTO city(name, county_id) VALUES ('Holliston', 1206);
  INSERT INTO city(name, county_id) VALUES ('Hopedale', 1211);
  INSERT INTO city(name, county_id) VALUES ('Hopkinton', 1206);
  INSERT INTO city(name, county_id) VALUES ('Hubbardston', 1211);
  INSERT INTO city(name, county_id) VALUES ('Hudson', 1206);
  INSERT INTO city(name, county_id) VALUES ('Hull', 1209);
  INSERT INTO city(name, county_id) VALUES ('Huntington', 1205);
  INSERT INTO city(name, county_id) VALUES ('Hyde Park', 1210);
  INSERT INTO city(name, county_id) VALUES ('Ipswich', 1202);
  INSERT INTO city(name, county_id) VALUES ('Kingston', 1209);
  INSERT INTO city(name, county_id) VALUES ('Lakeville', 1209);
  INSERT INTO city(name, county_id) VALUES ('Lancaster', 1211);
  INSERT INTO city(name, county_id) VALUES ('Lanesborough', 1199);
  INSERT INTO city(name, county_id) VALUES ('Lee', 1199);
  INSERT INTO city(name, county_id) VALUES ('Leicester', 1211);
  INSERT INTO city(name, county_id) VALUES ('Lenox', 1199);
  INSERT INTO city(name, county_id) VALUES ('Leverett', 1203);
  INSERT INTO city(name, county_id) VALUES ('Lexington', 1206);
  INSERT INTO city(name, county_id) VALUES ('Leyden', 1203);
  INSERT INTO city(name, county_id) VALUES ('Lincoln', 1206);
  INSERT INTO city(name, county_id) VALUES ('Littleton', 1206);
  INSERT INTO city(name, county_id) VALUES ('Longmeadow', 1204);
  INSERT INTO city(name, county_id) VALUES ('Ludlow', 1204);
  INSERT INTO city(name, county_id) VALUES ('Lunenburg', 1211);
  INSERT INTO city(name, county_id) VALUES ('Manchester-by-the-Sea', 1202);
  INSERT INTO city(name, county_id) VALUES ('Mansfield', 1200);
  INSERT INTO city(name, county_id) VALUES ('Marblehead', 1202);
  INSERT INTO city(name, county_id) VALUES ('Marion', 1209);
  INSERT INTO city(name, county_id) VALUES ('Marshfield', 1209);
  INSERT INTO city(name, county_id) VALUES ('Mashpee', 1198);
  INSERT INTO city(name, county_id) VALUES ('Mattapoisett', 1209);
  INSERT INTO city(name, county_id) VALUES ('Maynard', 1206);
  INSERT INTO city(name, county_id) VALUES ('Medfield', 1208);
  INSERT INTO city(name, county_id) VALUES ('Medway', 1208);
  INSERT INTO city(name, county_id) VALUES ('Mendon', 1211);
  INSERT INTO city(name, county_id) VALUES ('Merrimac', 1202);
  INSERT INTO city(name, county_id) VALUES ('Methuen', 1202);
  INSERT INTO city(name, county_id) VALUES ('Middleborough', 1209);
  INSERT INTO city(name, county_id) VALUES ('Middlefield', 1205);
  INSERT INTO city(name, county_id) VALUES ('Middleton', 1202);
  INSERT INTO city(name, county_id) VALUES ('Milford', 1211);
  INSERT INTO city(name, county_id) VALUES ('Millbury', 1211);
  INSERT INTO city(name, county_id) VALUES ('Millis', 1208);
  INSERT INTO city(name, county_id) VALUES ('Monroe', 1203);
  INSERT INTO city(name, county_id) VALUES ('Monson', 1204);
  INSERT INTO city(name, county_id) VALUES ('Montague', 1203);
  INSERT INTO city(name, county_id) VALUES ('Monterey', 1199);
  INSERT INTO city(name, county_id) VALUES ('Montgomery', 1204);
  INSERT INTO city(name, county_id) VALUES ('Mount Washington', 1199);
  INSERT INTO city(name, county_id) VALUES ('Nahant', 1202);
  INSERT INTO city(name, county_id) VALUES ('Nantucket', 1207);
  INSERT INTO city(name, county_id) VALUES ('Natick', 1206);
  INSERT INTO city(name, county_id) VALUES ('New Ashford', 1199);
  INSERT INTO city(name, county_id) VALUES ('New Braintree', 1211);
  INSERT INTO city(name, county_id) VALUES ('New Marlborough', 1199);
  INSERT INTO city(name, county_id) VALUES ('New Salem', 1203);
  INSERT INTO city(name, county_id) VALUES ('Newbury', 1202);
  INSERT INTO city(name, county_id) VALUES ('Norfolk', 1208);
  INSERT INTO city(name, county_id) VALUES ('North Andover', 1202);
  INSERT INTO city(name, county_id) VALUES ('North Brookfield', 1211);
  INSERT INTO city(name, county_id) VALUES ('North Reading', 1206);
  INSERT INTO city(name, county_id) VALUES ('Northborough', 1211);
  INSERT INTO city(name, county_id) VALUES ('Northbridge', 1211);
  INSERT INTO city(name, county_id) VALUES ('Northfield', 1203);
  INSERT INTO city(name, county_id) VALUES ('Norton', 1200);
  INSERT INTO city(name, county_id) VALUES ('Norwell', 1209);
  INSERT INTO city(name, county_id) VALUES ('Norwood', 1208);
  INSERT INTO city(name, county_id) VALUES ('Oak Bluffs', 1201);
  INSERT INTO city(name, county_id) VALUES ('Oakham', 1211);
  INSERT INTO city(name, county_id) VALUES ('Orange', 1203);
  INSERT INTO city(name, county_id) VALUES ('Orleans', 1198);
  INSERT INTO city(name, county_id) VALUES ('Otis', 1199);
  INSERT INTO city(name, county_id) VALUES ('Oxford', 1211);
  INSERT INTO city(name, county_id) VALUES ('Paxton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Pelham', 1205);
  INSERT INTO city(name, county_id) VALUES ('Pembroke', 1209);
  INSERT INTO city(name, county_id) VALUES ('Pepperell', 1206);
  INSERT INTO city(name, county_id) VALUES ('Peru', 1199);
  INSERT INTO city(name, county_id) VALUES ('Petersham', 1211);
  INSERT INTO city(name, county_id) VALUES ('Phillipston', 1211);
  INSERT INTO city(name, county_id) VALUES ('Plainfield', 1205);
  INSERT INTO city(name, county_id) VALUES ('Plainville', 1208);
  INSERT INTO city(name, county_id) VALUES ('Plympton', 1209);
  INSERT INTO city(name, county_id) VALUES ('Princeton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Provincetown', 1198);
  INSERT INTO city(name, county_id) VALUES ('Raynham', 1200);
  INSERT INTO city(name, county_id) VALUES ('Richmond', 1199);
  INSERT INTO city(name, county_id) VALUES ('Rochester', 1209);
  INSERT INTO city(name, county_id) VALUES ('Rockland', 1209);
  INSERT INTO city(name, county_id) VALUES ('Rockport', 1202);
  INSERT INTO city(name, county_id) VALUES ('Rowe', 1203);
  INSERT INTO city(name, county_id) VALUES ('Rowley', 1202);
  INSERT INTO city(name, county_id) VALUES ('Royalston', 1211);
  INSERT INTO city(name, county_id) VALUES ('Russell', 1204);
  INSERT INTO city(name, county_id) VALUES ('Rutland', 1211);
  INSERT INTO city(name, county_id) VALUES ('Salisbury', 1202);
  INSERT INTO city(name, county_id) VALUES ('Sandisfield', 1199);
  INSERT INTO city(name, county_id) VALUES ('Sandwich', 1198);
  INSERT INTO city(name, county_id) VALUES ('Saugus', 1202);
  INSERT INTO city(name, county_id) VALUES ('Savoy', 1199);
  INSERT INTO city(name, county_id) VALUES ('Scituate', 1209);
  INSERT INTO city(name, county_id) VALUES ('Sheffield', 1199);
  INSERT INTO city(name, county_id) VALUES ('Shelburne', 1203);
  INSERT INTO city(name, county_id) VALUES ('Sherborn', 1206);
  INSERT INTO city(name, county_id) VALUES ('Shirley', 1206);
  INSERT INTO city(name, county_id) VALUES ('Shrewsbury', 1211);
  INSERT INTO city(name, county_id) VALUES ('Shutesbury', 1203);
  INSERT INTO city(name, county_id) VALUES ('Somerset', 1200);
  INSERT INTO city(name, county_id) VALUES ('South Hadley', 1205);
  INSERT INTO city(name, county_id) VALUES ('Southampton', 1205);
  INSERT INTO city(name, county_id) VALUES ('Southborough', 1211);
  INSERT INTO city(name, county_id) VALUES ('Southwick', 1204);
  INSERT INTO city(name, county_id) VALUES ('Spencer', 1211);
  INSERT INTO city(name, county_id) VALUES ('Sterling', 1211);
  INSERT INTO city(name, county_id) VALUES ('Stockbridge', 1199);
  INSERT INTO city(name, county_id) VALUES ('Stoneham', 1206);
  INSERT INTO city(name, county_id) VALUES ('Stow', 1206);
  INSERT INTO city(name, county_id) VALUES ('Sturbridge', 1211);
  INSERT INTO city(name, county_id) VALUES ('Sudbury', 1206);
  INSERT INTO city(name, county_id) VALUES ('Sunderland', 1203);
  INSERT INTO city(name, county_id) VALUES ('Sutton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Swampscott', 1202);
  INSERT INTO city(name, county_id) VALUES ('Templeton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Tewksbury', 1206);
  INSERT INTO city(name, county_id) VALUES ('Tisbury', 1201);
  INSERT INTO city(name, county_id) VALUES ('Tolland', 1204);
  INSERT INTO city(name, county_id) VALUES ('Topsfield', 1202);
  INSERT INTO city(name, county_id) VALUES ('Townsend', 1206);
  INSERT INTO city(name, county_id) VALUES ('Truro', 1198);
  INSERT INTO city(name, county_id) VALUES ('Tyngsborough', 1206);
  INSERT INTO city(name, county_id) VALUES ('Tyringham', 1199);
  INSERT INTO city(name, county_id) VALUES ('Upton', 1211);
  INSERT INTO city(name, county_id) VALUES ('Uxbridge', 1211);
  INSERT INTO city(name, county_id) VALUES ('Wales', 1204);
  INSERT INTO city(name, county_id) VALUES ('Ware', 1205);
  INSERT INTO city(name, county_id) VALUES ('Wareham', 1209);
  INSERT INTO city(name, county_id) VALUES ('Warren', 1211);
  INSERT INTO city(name, county_id) VALUES ('Warwick', 1203);
  INSERT INTO city(name, county_id) VALUES ('Washington', 1199);
  INSERT INTO city(name, county_id) VALUES ('Wayland', 1206);
  INSERT INTO city(name, county_id) VALUES ('Webster', 1211);
  INSERT INTO city(name, county_id) VALUES ('Wellesley', 1208);
  INSERT INTO city(name, county_id) VALUES ('Wellfleet', 1198);
  INSERT INTO city(name, county_id) VALUES ('Wendell', 1203);
  INSERT INTO city(name, county_id) VALUES ('Wenham', 1202);
  INSERT INTO city(name, county_id) VALUES ('West Boylston', 1211);
  INSERT INTO city(name, county_id) VALUES ('West Bridgewater', 1209);
  INSERT INTO city(name, county_id) VALUES ('West Brookfield', 1211);
  INSERT INTO city(name, county_id) VALUES ('West Newbury', 1202);
  INSERT INTO city(name, county_id) VALUES ('West Roxbury', 1210);
  INSERT INTO city(name, county_id) VALUES ('West Stockbridge', 1199);
  INSERT INTO city(name, county_id) VALUES ('West Tisbury', 1201);
  INSERT INTO city(name, county_id) VALUES ('Westborough', 1211);
  INSERT INTO city(name, county_id) VALUES ('Westhampton', 1205);
  INSERT INTO city(name, county_id) VALUES ('Westminster', 1211);
  INSERT INTO city(name, county_id) VALUES ('Westwood', 1208);
  INSERT INTO city(name, county_id) VALUES ('Whately', 1203);
  INSERT INTO city(name, county_id) VALUES ('Whitman', 1209);
  INSERT INTO city(name, county_id) VALUES ('Wilbraham', 1204);
  INSERT INTO city(name, county_id) VALUES ('Williamsburg', 1205);
  INSERT INTO city(name, county_id) VALUES ('Williamstown', 1199);
  INSERT INTO city(name, county_id) VALUES ('Wilmington', 1206);
  INSERT INTO city(name, county_id) VALUES ('Winchendon', 1211);
  INSERT INTO city(name, county_id) VALUES ('Winchester', 1206);
  INSERT INTO city(name, county_id) VALUES ('Windsor', 1199);
  INSERT INTO city(name, county_id) VALUES ('Worthington', 1205);
  INSERT INTO city(name, county_id) VALUES ('Yarmouth', 1198);
  INSERT INTO city(name, county_id) VALUES ('North Grafton', 1211);
  INSERT INTO city(name, county_id) VALUES ('South Grafton', 1211);
  
  INSERT INTO city(name, county_id) VALUES ('Andover', 306);
  INSERT INTO city(name, county_id) VALUES ('Ashford', 307);
  INSERT INTO city(name, county_id) VALUES ('Avon', 301);
  INSERT INTO city(name, county_id) VALUES ('Barkhamsted', 302);
  INSERT INTO city(name, county_id) VALUES ('Beacon Falls', 304);
  INSERT INTO city(name, county_id) VALUES ('Berlin', 301);
  INSERT INTO city(name, county_id) VALUES ('Bethany', 304);
  INSERT INTO city(name, county_id) VALUES ('Bethel', 300);
  INSERT INTO city(name, county_id) VALUES ('Bethlehem', 302);
  INSERT INTO city(name, county_id) VALUES ('Bloomfield', 301);
  INSERT INTO city(name, county_id) VALUES ('Bolton', 306);
  INSERT INTO city(name, county_id) VALUES ('Bozrah', 305);
  INSERT INTO city(name, county_id) VALUES ('Branford', 304);
  INSERT INTO city(name, county_id) VALUES ('Bridgewater', 302);
  INSERT INTO city(name, county_id) VALUES ('Brookfield', 300);
  INSERT INTO city(name, county_id) VALUES ('Burlington', 301);
  INSERT INTO city(name, county_id) VALUES ('Canterbury', 307);
  INSERT INTO city(name, county_id) VALUES ('Canton', 301);
  INSERT INTO city(name, county_id) VALUES ('Chaplin', 307);
  INSERT INTO city(name, county_id) VALUES ('Cheshire', 304);
  INSERT INTO city(name, county_id) VALUES ('Chester', 303);
  INSERT INTO city(name, county_id) VALUES ('Clinton', 303);
  INSERT INTO city(name, county_id) VALUES ('Colchester', 305);
  INSERT INTO city(name, county_id) VALUES ('Colebrook', 302);
  INSERT INTO city(name, county_id) VALUES ('Columbia', 306);
  INSERT INTO city(name, county_id) VALUES ('Cornwall', 302);
  INSERT INTO city(name, county_id) VALUES ('Coventry', 306);
  INSERT INTO city(name, county_id) VALUES ('Cromwell', 303);
  INSERT INTO city(name, county_id) VALUES ('Darien', 300);
  INSERT INTO city(name, county_id) VALUES ('Deep River', 303);
  INSERT INTO city(name, county_id) VALUES ('Durham', 303);
  INSERT INTO city(name, county_id) VALUES ('East Granby', 301);
  INSERT INTO city(name, county_id) VALUES ('East Haddam', 303);
  INSERT INTO city(name, county_id) VALUES ('East Hampton', 303);
  INSERT INTO city(name, county_id) VALUES ('East Hartford', 301);
  INSERT INTO city(name, county_id) VALUES ('East Haven', 304);
  INSERT INTO city(name, county_id) VALUES ('East Lyme', 305);
  INSERT INTO city(name, county_id) VALUES ('East Windsor', 301);
  INSERT INTO city(name, county_id) VALUES ('Eastford', 307);
  INSERT INTO city(name, county_id) VALUES ('Easton', 300);
  INSERT INTO city(name, county_id) VALUES ('Ellington', 306);
  INSERT INTO city(name, county_id) VALUES ('Enfield', 301);
  INSERT INTO city(name, county_id) VALUES ('Essex', 303);
  INSERT INTO city(name, county_id) VALUES ('Fairfield', 300);
  INSERT INTO city(name, county_id) VALUES ('Farmington', 301);
  INSERT INTO city(name, county_id) VALUES ('Franklin', 305);
  INSERT INTO city(name, county_id) VALUES ('Glastonbury', 301);
  INSERT INTO city(name, county_id) VALUES ('Goshen', 302);
  INSERT INTO city(name, county_id) VALUES ('Granby', 301);
  INSERT INTO city(name, county_id) VALUES ('Greenwich', 300);
  INSERT INTO city(name, county_id) VALUES ('Griswold', 305);
  INSERT INTO city(name, county_id) VALUES ('Groton', 305);
  INSERT INTO city(name, county_id) VALUES ('Guilford', 304);
  INSERT INTO city(name, county_id) VALUES ('Haddam', 303);
  INSERT INTO city(name, county_id) VALUES ('Hamden', 304);
  INSERT INTO city(name, county_id) VALUES ('Hampton', 307);
  INSERT INTO city(name, county_id) VALUES ('Hartland', 301);
  INSERT INTO city(name, county_id) VALUES ('Harwinton', 302);
  INSERT INTO city(name, county_id) VALUES ('Hebron', 306);
  INSERT INTO city(name, county_id) VALUES ('Kent', 302);
  INSERT INTO city(name, county_id) VALUES ('Killingworth', 303);
  INSERT INTO city(name, county_id) VALUES ('Lebanon', 305);
  INSERT INTO city(name, county_id) VALUES ('Ledyard', 305);
  INSERT INTO city(name, county_id) VALUES ('Lisbon', 305);
  INSERT INTO city(name, county_id) VALUES ('Litchfield', 302);
  INSERT INTO city(name, county_id) VALUES ('Lyme', 305);
  INSERT INTO city(name, county_id) VALUES ('Madison', 304);
  INSERT INTO city(name, county_id) VALUES ('Manchester', 301);
  INSERT INTO city(name, county_id) VALUES ('Mansfield', 306);
  INSERT INTO city(name, county_id) VALUES ('Marlborough', 301);
  INSERT INTO city(name, county_id) VALUES ('Middlebury', 304);
  INSERT INTO city(name, county_id) VALUES ('Middlefield', 303);
  INSERT INTO city(name, county_id) VALUES ('Monroe', 300);
  INSERT INTO city(name, county_id) VALUES ('Montville', 305);
  INSERT INTO city(name, county_id) VALUES ('Morris', 302);
  INSERT INTO city(name, county_id) VALUES ('New Canaan', 300);
  INSERT INTO city(name, county_id) VALUES ('New Fairfield', 300);
  INSERT INTO city(name, county_id) VALUES ('New Hartford', 302);
  INSERT INTO city(name, county_id) VALUES ('New Milford', 302);
  INSERT INTO city(name, county_id) VALUES ('Newington', 301);
  INSERT INTO city(name, county_id) VALUES ('Newtown', 300);
  INSERT INTO city(name, county_id) VALUES ('Norfolk', 302);
  INSERT INTO city(name, county_id) VALUES ('North Branford', 304);
  INSERT INTO city(name, county_id) VALUES ('North Canaan', 302);
  INSERT INTO city(name, county_id) VALUES ('North Haven', 304);
  INSERT INTO city(name, county_id) VALUES ('North Stonington', 305);
  INSERT INTO city(name, county_id) VALUES ('Old Lyme', 305);
  INSERT INTO city(name, county_id) VALUES ('Old Saybrook', 303);
  INSERT INTO city(name, county_id) VALUES ('Orange', 304);
  INSERT INTO city(name, county_id) VALUES ('Oxford', 304);
  INSERT INTO city(name, county_id) VALUES ('Plainfield', 307);
  INSERT INTO city(name, county_id) VALUES ('Plainville', 301);
  INSERT INTO city(name, county_id) VALUES ('Plymouth', 302);
  INSERT INTO city(name, county_id) VALUES ('Pomfret', 307);
  INSERT INTO city(name, county_id) VALUES ('Portland', 303);
  INSERT INTO city(name, county_id) VALUES ('Preston', 305);
  INSERT INTO city(name, county_id) VALUES ('Prospect', 304);
  INSERT INTO city(name, county_id) VALUES ('Putnam', 307);
  INSERT INTO city(name, county_id) VALUES ('Redding', 300);
  INSERT INTO city(name, county_id) VALUES ('Ridgefield', 300);
  INSERT INTO city(name, county_id) VALUES ('Rocky Hill', 301);
  INSERT INTO city(name, county_id) VALUES ('Roxbury', 302);
  INSERT INTO city(name, county_id) VALUES ('Salem', 305);
  INSERT INTO city(name, county_id) VALUES ('Salisbury', 302);
  INSERT INTO city(name, county_id) VALUES ('Scotland', 307);
  INSERT INTO city(name, county_id) VALUES ('Seymour', 304);
  INSERT INTO city(name, county_id) VALUES ('Sharon', 302);
  INSERT INTO city(name, county_id) VALUES ('Sherman', 300);
  INSERT INTO city(name, county_id) VALUES ('Simsbury', 301);
  INSERT INTO city(name, county_id) VALUES ('Somers', 306);
  INSERT INTO city(name, county_id) VALUES ('South Windsor', 301);
  INSERT INTO city(name, county_id) VALUES ('Southbury', 304);
  INSERT INTO city(name, county_id) VALUES ('Southington', 301);
  INSERT INTO city(name, county_id) VALUES ('Sprague', 305);
  INSERT INTO city(name, county_id) VALUES ('Stafford', 306);
  INSERT INTO city(name, county_id) VALUES ('Sterling', 307);
  INSERT INTO city(name, county_id) VALUES ('Stonington', 305);
  INSERT INTO city(name, county_id) VALUES ('Stratford', 300);
  INSERT INTO city(name, county_id) VALUES ('Suffield', 301);
  INSERT INTO city(name, county_id) VALUES ('Thomaston', 302);
  INSERT INTO city(name, county_id) VALUES ('Thompson', 307);
  INSERT INTO city(name, county_id) VALUES ('Tolland', 306);
  INSERT INTO city(name, county_id) VALUES ('Trumbull', 300);
  INSERT INTO city(name, county_id) VALUES ('Union', 306);
  INSERT INTO city(name, county_id) VALUES ('Vernon', 306);
  INSERT INTO city(name, county_id) VALUES ('Voluntown', 305);
  INSERT INTO city(name, county_id) VALUES ('Wallingford', 304);
  INSERT INTO city(name, county_id) VALUES ('Warren', 302);
  INSERT INTO city(name, county_id) VALUES ('Washington', 302);
  INSERT INTO city(name, county_id) VALUES ('Waterford', 305);
  INSERT INTO city(name, county_id) VALUES ('Watertown', 302);
  INSERT INTO city(name, county_id) VALUES ('West Hartford', 301);
  INSERT INTO city(name, county_id) VALUES ('Westbrook', 303);
  INSERT INTO city(name, county_id) VALUES ('Weston', 300);
  INSERT INTO city(name, county_id) VALUES ('Westport', 300);
  INSERT INTO city(name, county_id) VALUES ('Willington', 306);
  INSERT INTO city(name, county_id) VALUES ('Wilton', 300);
  INSERT INTO city(name, county_id) VALUES ('Winchester', 302);
  INSERT INTO city(name, county_id) VALUES ('Windham', 307);
  INSERT INTO city(name, county_id) VALUES ('Windsor Locks', 301);
  INSERT INTO city(name, county_id) VALUES ('Wolcott', 304);
  INSERT INTO city(name, county_id) VALUES ('Woodbridge', 304);
  INSERT INTO city(name, county_id) VALUES ('Woodbury', 302);
  INSERT INTO city(name, county_id) VALUES ('Woodstock', 307);
  
  INSERT INTO city(name, county_id) VALUES ('Burrillville', 2269);
  INSERT INTO city(name, county_id) VALUES ('Exeter', 2270);
  INSERT INTO city(name, county_id) VALUES ('Glocester', 2269);
  INSERT INTO city(name, county_id) VALUES ('Hopkinton', 2270);
  INSERT INTO city(name, county_id) VALUES ('Little Compton', 2268);
  INSERT INTO city(name, county_id) VALUES ('Middletown', 2268);
  INSERT INTO city(name, county_id) VALUES ('New Shoreham', 2270);
  INSERT INTO city(name, county_id) VALUES ('Portsmouth', 2268);
  INSERT INTO city(name, county_id) VALUES ('Richmond', 2270);
  INSERT INTO city(name, county_id) VALUES ('Scituate', 2269);
  INSERT INTO city(name, county_id) VALUES ('South Kingstown', 2270);
  INSERT INTO city(name, county_id) VALUES ('Westerly', 2270);
  
  INSERT INTO city(name, county_id) VALUES ('North Dartmouth', 1200);
  INSERT INTO city(name, county_id) VALUES ('South Dartmouth', 1200);
  
  INSERT INTO city(name, county_id) VALUES ('La Jolla', 216);
  
  INSERT INTO city(name, county_id) VALUES ('Vancouver', 3245);
  INSERT INTO city(name, county_id) VALUES ('Calgary', 3248);
  
  INSERT INTO city(name, county_id) VALUES ('Naples', 1824);
  INSERT INTO city(name, county_id) VALUES ('Cortlandt Manor', 1849);
  INSERT INTO city(name, county_id) VALUES ('Wellesley Hills', 1208);
  INSERT INTO city(name, county_id) VALUES ('Centerville', 1198);
  
  INSERT INTO city(name, county_id) VALUES ('Abbot', 1168);
  INSERT INTO city(name, county_id) VALUES ('Acton', 1173);
  INSERT INTO city(name, county_id) VALUES ('Addison', 1172);
  INSERT INTO city(name, county_id) VALUES ('Albion', 1163);
  INSERT INTO city(name, county_id) VALUES ('Alexander', 1172);
  INSERT INTO city(name, county_id) VALUES ('Alfred', 1173);
  INSERT INTO city(name, county_id) VALUES ('Allagash', 1159);
  INSERT INTO city(name, county_id) VALUES ('Alna', 1165);
  INSERT INTO city(name, county_id) VALUES ('Alton', 1167);
  INSERT INTO city(name, county_id) VALUES ('Amherst', 1162);
  INSERT INTO city(name, county_id) VALUES ('Amity', 1159);
  INSERT INTO city(name, county_id) VALUES ('Andover', 1166);
  INSERT INTO city(name, county_id) VALUES ('Anson', 1170);
  INSERT INTO city(name, county_id) VALUES ('Appleton', 1164);
  INSERT INTO city(name, county_id) VALUES ('Arrowsic', 1169);
  INSERT INTO city(name, county_id) VALUES ('Arundel', 1173);
  INSERT INTO city(name, county_id) VALUES ('Ashland', 1159);
  INSERT INTO city(name, county_id) VALUES ('Athens', 1170);
  INSERT INTO city(name, county_id) VALUES ('Aurora', 1162);
  INSERT INTO city(name, county_id) VALUES ('Avon', 1161);
  INSERT INTO city(name, county_id) VALUES ('Baileyville', 1172);
  INSERT INTO city(name, county_id) VALUES ('Baldwin', 1160);
  INSERT INTO city(name, county_id) VALUES ('Bar Harbor', 1162);
  INSERT INTO city(name, county_id) VALUES ('Beals', 1172);
  INSERT INTO city(name, county_id) VALUES ('Beaver Cove', 1168);
  INSERT INTO city(name, county_id) VALUES ('Beddington', 1172);
  INSERT INTO city(name, county_id) VALUES ('Belgrade', 1163);
  INSERT INTO city(name, county_id) VALUES ('Belmont', 1171);
  INSERT INTO city(name, county_id) VALUES ('Benton', 1163);
  INSERT INTO city(name, county_id) VALUES ('Berwick', 1173);
  INSERT INTO city(name, county_id) VALUES ('Bethel', 1166);
  INSERT INTO city(name, county_id) VALUES ('Bingham', 1170);
  INSERT INTO city(name, county_id) VALUES ('Blaine', 1159);
  INSERT INTO city(name, county_id) VALUES ('Blue Hill', 1162);
  INSERT INTO city(name, county_id) VALUES ('Boothbay', 1165);
  INSERT INTO city(name, county_id) VALUES ('Boothbay Harbor', 1165);
  INSERT INTO city(name, county_id) VALUES ('Bowdoin', 1169);
  INSERT INTO city(name, county_id) VALUES ('Bowdoinham', 1169);
  INSERT INTO city(name, county_id) VALUES ('Bowerbank', 1168);
  INSERT INTO city(name, county_id) VALUES ('Bradford', 1167);
  INSERT INTO city(name, county_id) VALUES ('Bradley', 1167);
  INSERT INTO city(name, county_id) VALUES ('Bremen', 1165);
  INSERT INTO city(name, county_id) VALUES ('Bridgewater', 1159);
  INSERT INTO city(name, county_id) VALUES ('Bridgton', 1160);
  INSERT INTO city(name, county_id) VALUES ('Bristol', 1165);
  INSERT INTO city(name, county_id) VALUES ('Brooklin', 1162);
  INSERT INTO city(name, county_id) VALUES ('Brooks', 1171);
  INSERT INTO city(name, county_id) VALUES ('Brooksville', 1162);
  INSERT INTO city(name, county_id) VALUES ('Brownfield', 1166);
  INSERT INTO city(name, county_id) VALUES ('Brownville', 1168);
  INSERT INTO city(name, county_id) VALUES ('Brunswick', 1160);
  INSERT INTO city(name, county_id) VALUES ('Buckfield', 1166);
  INSERT INTO city(name, county_id) VALUES ('Bucksport', 1162);
  INSERT INTO city(name, county_id) VALUES ('Burlington', 1167);
  INSERT INTO city(name, county_id) VALUES ('Burnham', 1171);
  INSERT INTO city(name, county_id) VALUES ('Buxton', 1173);
  INSERT INTO city(name, county_id) VALUES ('Byron', 1166);
  INSERT INTO city(name, county_id) VALUES ('Cambridge', 1170);
  INSERT INTO city(name, county_id) VALUES ('Camden', 1164);
  INSERT INTO city(name, county_id) VALUES ('Canaan', 1170);
  INSERT INTO city(name, county_id) VALUES ('Canton', 1166);
  INSERT INTO city(name, county_id) VALUES ('Cape Elizabeth', 1160);
  INSERT INTO city(name, county_id) VALUES ('Caratunk', 1170);
  INSERT INTO city(name, county_id) VALUES ('Carmel', 1167);
  INSERT INTO city(name, county_id) VALUES ('Carrabassett Valley', 1161);
  INSERT INTO city(name, county_id) VALUES ('Carthage', 1161);
  INSERT INTO city(name, county_id) VALUES ('Casco', 1160);
  INSERT INTO city(name, county_id) VALUES ('Castine', 1162);
  INSERT INTO city(name, county_id) VALUES ('Castle Hill', 1159);
  INSERT INTO city(name, county_id) VALUES ('Caswell', 1159);
  INSERT INTO city(name, county_id) VALUES ('Chapman', 1159);
  INSERT INTO city(name, county_id) VALUES ('Charleston', 1167);
  INSERT INTO city(name, county_id) VALUES ('Charlotte', 1172);
  INSERT INTO city(name, county_id) VALUES ('Chebeague Island', 1160);
  INSERT INTO city(name, county_id) VALUES ('Chelsea', 1163);
  INSERT INTO city(name, county_id) VALUES ('Cherryfield', 1172);
  INSERT INTO city(name, county_id) VALUES ('Chester', 1167);
  INSERT INTO city(name, county_id) VALUES ('Chesterville', 1161);
  INSERT INTO city(name, county_id) VALUES ('China', 1163);
  INSERT INTO city(name, county_id) VALUES ('Clifton', 1167);
  INSERT INTO city(name, county_id) VALUES ('Clinton', 1163);
  INSERT INTO city(name, county_id) VALUES ('Columbia', 1172);
  INSERT INTO city(name, county_id) VALUES ('Columbia Falls', 1172);
  INSERT INTO city(name, county_id) VALUES ('Cooper', 1172);
  INSERT INTO city(name, county_id) VALUES ('Corinna', 1167);
  INSERT INTO city(name, county_id) VALUES ('Corinth', 1167);
  INSERT INTO city(name, county_id) VALUES ('Cornish', 1173);
  INSERT INTO city(name, county_id) VALUES ('Cornville', 1170);
  INSERT INTO city(name, county_id) VALUES ('Cranberry Isles', 1162);
  INSERT INTO city(name, county_id) VALUES ('Crawford', 1172);
  INSERT INTO city(name, county_id) VALUES ('Crystal', 1159);
  INSERT INTO city(name, county_id) VALUES ('Cumberland', 1160);
  INSERT INTO city(name, county_id) VALUES ('Cushing', 1164);
  INSERT INTO city(name, county_id) VALUES ('Cutler', 1172);
  INSERT INTO city(name, county_id) VALUES ('Damariscotta', 1165);
  INSERT INTO city(name, county_id) VALUES ('Danforth', 1172);
  INSERT INTO city(name, county_id) VALUES ('Dayton', 1173);
  INSERT INTO city(name, county_id) VALUES ('Deblois', 1172);
  INSERT INTO city(name, county_id) VALUES ('Dedham', 1162);
  INSERT INTO city(name, county_id) VALUES ('Deer Isle', 1162);
  INSERT INTO city(name, county_id) VALUES ('Denmark', 1166);
  INSERT INTO city(name, county_id) VALUES ('Dennysville', 1172);
  INSERT INTO city(name, county_id) VALUES ('Detroit', 1170);
  INSERT INTO city(name, county_id) VALUES ('Dexter', 1167);
  INSERT INTO city(name, county_id) VALUES ('Dixfield', 1166);
  INSERT INTO city(name, county_id) VALUES ('Dixmont', 1167);
  INSERT INTO city(name, county_id) VALUES ('Dover-Foxcroft', 1168);
  INSERT INTO city(name, county_id) VALUES ('Dresden', 1165);
  INSERT INTO city(name, county_id) VALUES ('Durham', 1158);
  INSERT INTO city(name, county_id) VALUES ('Dyer Brook', 1159);
  INSERT INTO city(name, county_id) VALUES ('Eagle Lake', 1159);
  INSERT INTO city(name, county_id) VALUES ('East Machias', 1172);
  INSERT INTO city(name, county_id) VALUES ('East Millinocket', 1167);
  INSERT INTO city(name, county_id) VALUES ('Eastbrook', 1162);
  INSERT INTO city(name, county_id) VALUES ('Easton', 1159);
  INSERT INTO city(name, county_id) VALUES ('Eddington', 1167);
  INSERT INTO city(name, county_id) VALUES ('Edgecomb', 1165);
  INSERT INTO city(name, county_id) VALUES ('Edinburg', 1167);
  INSERT INTO city(name, county_id) VALUES ('Eliot', 1173);
  INSERT INTO city(name, county_id) VALUES ('Embden', 1170);
  INSERT INTO city(name, county_id) VALUES ('Enfield', 1167);
  INSERT INTO city(name, county_id) VALUES ('Etna', 1167);
  INSERT INTO city(name, county_id) VALUES ('Eustis', 1161);
  INSERT INTO city(name, county_id) VALUES ('Exeter', 1167);
  INSERT INTO city(name, county_id) VALUES ('Fairfield', 1170);
  INSERT INTO city(name, county_id) VALUES ('Falmouth', 1160);
  INSERT INTO city(name, county_id) VALUES ('Farmingdale', 1163);
  INSERT INTO city(name, county_id) VALUES ('Farmington', 1161);
  INSERT INTO city(name, county_id) VALUES ('Fayette', 1163);
  INSERT INTO city(name, county_id) VALUES ('Fort Fairfield', 1159);
  INSERT INTO city(name, county_id) VALUES ('Fort Kent', 1159);
  INSERT INTO city(name, county_id) VALUES ('Frankfort', 1171);
  INSERT INTO city(name, county_id) VALUES ('Franklin', 1162);
  INSERT INTO city(name, county_id) VALUES ('Freedom', 1171);
  INSERT INTO city(name, county_id) VALUES ('Freeport', 1160);
  INSERT INTO city(name, county_id) VALUES ('Frenchboro', 1162);
  INSERT INTO city(name, county_id) VALUES ('Frenchville', 1159);
  INSERT INTO city(name, county_id) VALUES ('Friendship', 1164);
  INSERT INTO city(name, county_id) VALUES ('Frye Island', 1160);
  INSERT INTO city(name, county_id) VALUES ('Fryeburg', 1166);
  INSERT INTO city(name, county_id) VALUES ('Garland', 1167);
  INSERT INTO city(name, county_id) VALUES ('Georgetown', 1169);
  INSERT INTO city(name, county_id) VALUES ('Gilead', 1166);
  INSERT INTO city(name, county_id) VALUES ('Glenburn', 1167);
  INSERT INTO city(name, county_id) VALUES ('Gorham', 1160);
  INSERT INTO city(name, county_id) VALUES ('Gouldsboro', 1162);
  INSERT INTO city(name, county_id) VALUES ('Grand Isle', 1159);
  INSERT INTO city(name, county_id) VALUES ('Gray', 1160);
  INSERT INTO city(name, county_id) VALUES ('Great Pond', 1162);
  INSERT INTO city(name, county_id) VALUES ('Greenbush', 1167);
  INSERT INTO city(name, county_id) VALUES ('Greene', 1158);
  INSERT INTO city(name, county_id) VALUES ('Greenville', 1168);
  INSERT INTO city(name, county_id) VALUES ('Greenwood', 1166);
  INSERT INTO city(name, county_id) VALUES ('Guilford', 1168);
  INSERT INTO city(name, county_id) VALUES ('Hamlin', 1159);
  INSERT INTO city(name, county_id) VALUES ('Hammond', 1159);
  INSERT INTO city(name, county_id) VALUES ('Hampden', 1167);
  INSERT INTO city(name, county_id) VALUES ('Hancock', 1162);
  INSERT INTO city(name, county_id) VALUES ('Hanover', 1166);
  INSERT INTO city(name, county_id) VALUES ('Harmony', 1170);
  INSERT INTO city(name, county_id) VALUES ('Harpswell', 1160);
  INSERT INTO city(name, county_id) VALUES ('Harrington', 1172);
  INSERT INTO city(name, county_id) VALUES ('Harrison', 1160);
  INSERT INTO city(name, county_id) VALUES ('Hartford', 1166);
  INSERT INTO city(name, county_id) VALUES ('Hartland', 1170);
  INSERT INTO city(name, county_id) VALUES ('Haynesville', 1159);
  INSERT INTO city(name, county_id) VALUES ('Hebron', 1166);
  INSERT INTO city(name, county_id) VALUES ('Hermon', 1167);
  INSERT INTO city(name, county_id) VALUES ('Hersey', 1159);
  INSERT INTO city(name, county_id) VALUES ('Hiram', 1166);
  INSERT INTO city(name, county_id) VALUES ('Hodgdon', 1159);
  INSERT INTO city(name, county_id) VALUES ('Holden', 1167);
  INSERT INTO city(name, county_id) VALUES ('Hollis', 1173);
  INSERT INTO city(name, county_id) VALUES ('Hope', 1164);
  INSERT INTO city(name, county_id) VALUES ('Houlton', 1159);
  INSERT INTO city(name, county_id) VALUES ('Howland', 1167);
  INSERT INTO city(name, county_id) VALUES ('Hudson', 1167);
  INSERT INTO city(name, county_id) VALUES ('Industry', 1161);
  INSERT INTO city(name, county_id) VALUES ('Island Falls', 1159);
  INSERT INTO city(name, county_id) VALUES ('Isle Au Haut', 1164);
  INSERT INTO city(name, county_id) VALUES ('Islesboro', 1171);
  INSERT INTO city(name, county_id) VALUES ('Jackman', 1170);
  INSERT INTO city(name, county_id) VALUES ('Jackson', 1171);
  INSERT INTO city(name, county_id) VALUES ('Jay', 1161);
  INSERT INTO city(name, county_id) VALUES ('Jefferson', 1165);
  INSERT INTO city(name, county_id) VALUES ('Jonesboro', 1172);
  INSERT INTO city(name, county_id) VALUES ('Jonesport', 1172);
  INSERT INTO city(name, county_id) VALUES ('Kenduskeag', 1167);
  INSERT INTO city(name, county_id) VALUES ('Kennebunk', 1173);
  INSERT INTO city(name, county_id) VALUES ('Kennebunkport', 1173);
  INSERT INTO city(name, county_id) VALUES ('Kingfield', 1161);
  INSERT INTO city(name, county_id) VALUES ('Kittery', 1173);
  INSERT INTO city(name, county_id) VALUES ('Knox', 1171);
  INSERT INTO city(name, county_id) VALUES ('Lagrange', 1167);
  INSERT INTO city(name, county_id) VALUES ('Lakeville', 1167);
  INSERT INTO city(name, county_id) VALUES ('Lamoine', 1162);
  INSERT INTO city(name, county_id) VALUES ('Lebanon', 1173);
  INSERT INTO city(name, county_id) VALUES ('Lee', 1167);
  INSERT INTO city(name, county_id) VALUES ('Leeds', 1158);
  INSERT INTO city(name, county_id) VALUES ('Levant', 1167);
  INSERT INTO city(name, county_id) VALUES ('Liberty', 1171);
  INSERT INTO city(name, county_id) VALUES ('Limerick', 1173);
  INSERT INTO city(name, county_id) VALUES ('Limestone', 1159);
  INSERT INTO city(name, county_id) VALUES ('Limington', 1173);
  INSERT INTO city(name, county_id) VALUES ('Lincoln', 1167);
  INSERT INTO city(name, county_id) VALUES ('Lincolnville', 1171);
  INSERT INTO city(name, county_id) VALUES ('Linneus', 1159);
  INSERT INTO city(name, county_id) VALUES ('Lisbon', 1158);
  INSERT INTO city(name, county_id) VALUES ('Litchfield', 1163);
  INSERT INTO city(name, county_id) VALUES ('Littleton', 1159);
  INSERT INTO city(name, county_id) VALUES ('Livermore', 1158);
  INSERT INTO city(name, county_id) VALUES ('Livermore Falls', 1158);
  INSERT INTO city(name, county_id) VALUES ('Long Island', 1160);
  INSERT INTO city(name, county_id) VALUES ('Lovell', 1166);
  INSERT INTO city(name, county_id) VALUES ('Lowell', 1167);
  INSERT INTO city(name, county_id) VALUES ('Lubec', 1172);
  INSERT INTO city(name, county_id) VALUES ('Ludlow', 1159);
  INSERT INTO city(name, county_id) VALUES ('Lyman', 1173);
  INSERT INTO city(name, county_id) VALUES ('Machias', 1172);
  INSERT INTO city(name, county_id) VALUES ('Machiasport', 1172);
  INSERT INTO city(name, county_id) VALUES ('Madawaska', 1159);
  INSERT INTO city(name, county_id) VALUES ('Madison', 1170);
  INSERT INTO city(name, county_id) VALUES ('Manchester', 1163);
  INSERT INTO city(name, county_id) VALUES ('Mapleton', 1159);
  INSERT INTO city(name, county_id) VALUES ('Mariaville', 1162);
  INSERT INTO city(name, county_id) VALUES ('Mars Hill', 1159);
  INSERT INTO city(name, county_id) VALUES ('Marshfield', 1172);
  INSERT INTO city(name, county_id) VALUES ('Masardis', 1159);
  INSERT INTO city(name, county_id) VALUES ('Mattawamkeag', 1167);
  INSERT INTO city(name, county_id) VALUES ('Maxfield', 1167);
  INSERT INTO city(name, county_id) VALUES ('Mechanic Falls', 1158);
  INSERT INTO city(name, county_id) VALUES ('Meddybemps', 1172);
  INSERT INTO city(name, county_id) VALUES ('Medford', 1168);
  INSERT INTO city(name, county_id) VALUES ('Medway', 1167);
  INSERT INTO city(name, county_id) VALUES ('Mercer', 1170);
  INSERT INTO city(name, county_id) VALUES ('Merrill', 1159);
  INSERT INTO city(name, county_id) VALUES ('Mexico', 1166);
  INSERT INTO city(name, county_id) VALUES ('Milbridge', 1172);
  INSERT INTO city(name, county_id) VALUES ('Milford', 1167);
  INSERT INTO city(name, county_id) VALUES ('Millinocket', 1167);
  INSERT INTO city(name, county_id) VALUES ('Milo', 1168);
  INSERT INTO city(name, county_id) VALUES ('Minot', 1158);
  INSERT INTO city(name, county_id) VALUES ('Monmouth', 1163);
  INSERT INTO city(name, county_id) VALUES ('Monroe', 1171);
  INSERT INTO city(name, county_id) VALUES ('Monson', 1168);
  INSERT INTO city(name, county_id) VALUES ('Monticello', 1159);
  INSERT INTO city(name, county_id) VALUES ('Montville', 1171);
  INSERT INTO city(name, county_id) VALUES ('Moose River', 1170);
  INSERT INTO city(name, county_id) VALUES ('Morrill', 1171);
  INSERT INTO city(name, county_id) VALUES ('Moscow', 1170);
  INSERT INTO city(name, county_id) VALUES ('Mount Chase', 1167);
  INSERT INTO city(name, county_id) VALUES ('Mount Desert', 1162);
  INSERT INTO city(name, county_id) VALUES ('Mount Vernon', 1163);
  INSERT INTO city(name, county_id) VALUES ('Naples', 1160);
  INSERT INTO city(name, county_id) VALUES ('New Canada', 1159);
  INSERT INTO city(name, county_id) VALUES ('New Gloucester', 1160);
  INSERT INTO city(name, county_id) VALUES ('New Limerick', 1159);
  INSERT INTO city(name, county_id) VALUES ('New Portland', 1170);
  INSERT INTO city(name, county_id) VALUES ('New Sharon', 1161);
  INSERT INTO city(name, county_id) VALUES ('New Sweden', 1159);
  INSERT INTO city(name, county_id) VALUES ('New Vineyard', 1161);
  INSERT INTO city(name, county_id) VALUES ('Newburgh', 1167);
  INSERT INTO city(name, county_id) VALUES ('Newcastle', 1165);
  INSERT INTO city(name, county_id) VALUES ('Newfield', 1173);
  INSERT INTO city(name, county_id) VALUES ('Newport', 1167);
  INSERT INTO city(name, county_id) VALUES ('Newry', 1166);
  INSERT INTO city(name, county_id) VALUES ('Nobleboro', 1165);
  INSERT INTO city(name, county_id) VALUES ('Norridgewock', 1170);
  INSERT INTO city(name, county_id) VALUES ('North Berwick', 1173);
  INSERT INTO city(name, county_id) VALUES ('North Haven', 1164);
  INSERT INTO city(name, county_id) VALUES ('North Yarmouth', 1160);
  INSERT INTO city(name, county_id) VALUES ('Northfield', 1172);
  INSERT INTO city(name, county_id) VALUES ('Northport', 1171);
  INSERT INTO city(name, county_id) VALUES ('Norway', 1166);
  INSERT INTO city(name, county_id) VALUES ('Oakfield', 1159);
  INSERT INTO city(name, county_id) VALUES ('Oakland', 1163);
  INSERT INTO city(name, county_id) VALUES ('Ogunquit', 1173);
  INSERT INTO city(name, county_id) VALUES ('Old Orchard Beach', 1173);
  INSERT INTO city(name, county_id) VALUES ('Orient', 1159);
  INSERT INTO city(name, county_id) VALUES ('Orland', 1162);
  INSERT INTO city(name, county_id) VALUES ('Orono', 1167);
  INSERT INTO city(name, county_id) VALUES ('Orrington', 1167);
  INSERT INTO city(name, county_id) VALUES ('Osborn', 1162);
  INSERT INTO city(name, county_id) VALUES ('Otis', 1162);
  INSERT INTO city(name, county_id) VALUES ('Otisfield', 1166);
  INSERT INTO city(name, county_id) VALUES ('Owls Head', 1164);
  INSERT INTO city(name, county_id) VALUES ('Oxford', 1166);
  INSERT INTO city(name, county_id) VALUES ('Palermo', 1171);
  INSERT INTO city(name, county_id) VALUES ('Palmyra', 1170);
  INSERT INTO city(name, county_id) VALUES ('Paris', 1166);
  INSERT INTO city(name, county_id) VALUES ('Parkman', 1168);
  INSERT INTO city(name, county_id) VALUES ('Parsonsfield', 1173);
  INSERT INTO city(name, county_id) VALUES ('Passadumkeag', 1167);
  INSERT INTO city(name, county_id) VALUES ('Patten', 1167);
  INSERT INTO city(name, county_id) VALUES ('Pembroke', 1172);
  INSERT INTO city(name, county_id) VALUES ('Penobscot', 1162);
  INSERT INTO city(name, county_id) VALUES ('Perham', 1159);
  INSERT INTO city(name, county_id) VALUES ('Perry', 1172);
  INSERT INTO city(name, county_id) VALUES ('Peru', 1166);
  INSERT INTO city(name, county_id) VALUES ('Phillips', 1161);
  INSERT INTO city(name, county_id) VALUES ('Phippsburg', 1169);
  INSERT INTO city(name, county_id) VALUES ('Pittsfield', 1170);
  INSERT INTO city(name, county_id) VALUES ('Pittston', 1163);
  INSERT INTO city(name, county_id) VALUES ('Plymouth', 1167);
  INSERT INTO city(name, county_id) VALUES ('Poland', 1158);
  INSERT INTO city(name, county_id) VALUES ('Portage Lake', 1159);
  INSERT INTO city(name, county_id) VALUES ('Porter', 1166);
  INSERT INTO city(name, county_id) VALUES ('Pownal', 1160);
  INSERT INTO city(name, county_id) VALUES ('Princeton', 1172);
  INSERT INTO city(name, county_id) VALUES ('Prospect', 1171);
  INSERT INTO city(name, county_id) VALUES ('Randolph', 1163);
  INSERT INTO city(name, county_id) VALUES ('Rangeley', 1161);
  INSERT INTO city(name, county_id) VALUES ('Raymond', 1160);
  INSERT INTO city(name, county_id) VALUES ('Readfield', 1163);
  INSERT INTO city(name, county_id) VALUES ('Richmond', 1169);
  INSERT INTO city(name, county_id) VALUES ('Ripley', 1170);
  INSERT INTO city(name, county_id) VALUES ('Robbinston', 1172);
  INSERT INTO city(name, county_id) VALUES ('Rockport', 1164);
  INSERT INTO city(name, county_id) VALUES ('Rome', 1163);
  INSERT INTO city(name, county_id) VALUES ('Roque Bluffs', 1172);
  INSERT INTO city(name, county_id) VALUES ('Roxbury', 1166);
  INSERT INTO city(name, county_id) VALUES ('Rumford', 1166);
  INSERT INTO city(name, county_id) VALUES ('Sabattus', 1158);
  INSERT INTO city(name, county_id) VALUES ('Sangerville', 1168);
  INSERT INTO city(name, county_id) VALUES ('Scarborough', 1160);
  INSERT INTO city(name, county_id) VALUES ('Searsmont', 1171);
  INSERT INTO city(name, county_id) VALUES ('Searsport', 1171);
  INSERT INTO city(name, county_id) VALUES ('Sebago', 1160);
  INSERT INTO city(name, county_id) VALUES ('Sebec', 1168);
  INSERT INTO city(name, county_id) VALUES ('Sedgwick', 1162);
  INSERT INTO city(name, county_id) VALUES ('Shapleigh', 1173);
  INSERT INTO city(name, county_id) VALUES ('Sherman', 1159);
  INSERT INTO city(name, county_id) VALUES ('Shirley', 1168);
  INSERT INTO city(name, county_id) VALUES ('Sidney', 1163);
  INSERT INTO city(name, county_id) VALUES ('Skowhegan', 1170);
  INSERT INTO city(name, county_id) VALUES ('Smithfield', 1170);
  INSERT INTO city(name, county_id) VALUES ('Smyrna', 1159);
  INSERT INTO city(name, county_id) VALUES ('Solon', 1170);
  INSERT INTO city(name, county_id) VALUES ('Somerville', 1165);
  INSERT INTO city(name, county_id) VALUES ('Sorrento', 1162);
  INSERT INTO city(name, county_id) VALUES ('South Berwick', 1173);
  INSERT INTO city(name, county_id) VALUES ('South Bristol', 1165);
  INSERT INTO city(name, county_id) VALUES ('South Thomaston', 1164);
  INSERT INTO city(name, county_id) VALUES ('Southport', 1165);
  INSERT INTO city(name, county_id) VALUES ('Southwest Harbor', 1162);
  INSERT INTO city(name, county_id) VALUES ('Springfield', 1167);
  INSERT INTO city(name, county_id) VALUES ('St. Agatha', 1159);
  INSERT INTO city(name, county_id) VALUES ('St. Albans', 1170);
  INSERT INTO city(name, county_id) VALUES ('St. Francis', 1159);
  INSERT INTO city(name, county_id) VALUES ('St. George', 1164);
  INSERT INTO city(name, county_id) VALUES ('Stacyville', 1167);
  INSERT INTO city(name, county_id) VALUES ('Standish', 1160);
  INSERT INTO city(name, county_id) VALUES ('Starks', 1170);
  INSERT INTO city(name, county_id) VALUES ('Stetson', 1167);
  INSERT INTO city(name, county_id) VALUES ('Steuben', 1172);
  INSERT INTO city(name, county_id) VALUES ('Stockholm', 1159);
  INSERT INTO city(name, county_id) VALUES ('Stockton Springs', 1171);
  INSERT INTO city(name, county_id) VALUES ('Stoneham', 1166);
  INSERT INTO city(name, county_id) VALUES ('Stonington', 1162);
  INSERT INTO city(name, county_id) VALUES ('Stow', 1166);
  INSERT INTO city(name, county_id) VALUES ('Strong', 1161);
  INSERT INTO city(name, county_id) VALUES ('Sullivan', 1162);
  INSERT INTO city(name, county_id) VALUES ('Sumner', 1166);
  INSERT INTO city(name, county_id) VALUES ('Surry', 1162);
  INSERT INTO city(name, county_id) VALUES ('Swan''S Island', 1162);
  INSERT INTO city(name, county_id) VALUES ('Swanville', 1171);
  INSERT INTO city(name, county_id) VALUES ('Sweden', 1166);
  INSERT INTO city(name, county_id) VALUES ('Talmadge', 1172);
  INSERT INTO city(name, county_id) VALUES ('Temple', 1161);
  INSERT INTO city(name, county_id) VALUES ('Thomaston', 1164);
  INSERT INTO city(name, county_id) VALUES ('Thorndike', 1171);
  INSERT INTO city(name, county_id) VALUES ('Topsfield', 1172);
  INSERT INTO city(name, county_id) VALUES ('Topsham', 1169);
  INSERT INTO city(name, county_id) VALUES ('Tremont', 1162);
  INSERT INTO city(name, county_id) VALUES ('Trenton', 1162);
  INSERT INTO city(name, county_id) VALUES ('Troy', 1171);
  INSERT INTO city(name, county_id) VALUES ('Turner', 1158);
  INSERT INTO city(name, county_id) VALUES ('Union', 1164);
  INSERT INTO city(name, county_id) VALUES ('Unity', 1171);
  INSERT INTO city(name, county_id) VALUES ('Upton', 1166);
  INSERT INTO city(name, county_id) VALUES ('Van Buren', 1159);
  INSERT INTO city(name, county_id) VALUES ('Vanceboro', 1172);
  INSERT INTO city(name, county_id) VALUES ('Vassalboro', 1163);
  INSERT INTO city(name, county_id) VALUES ('Veazie', 1167);
  INSERT INTO city(name, county_id) VALUES ('Verona Island', 1162);
  INSERT INTO city(name, county_id) VALUES ('Vienna', 1163);
  INSERT INTO city(name, county_id) VALUES ('Vinalhaven', 1164);
  INSERT INTO city(name, county_id) VALUES ('Wade', 1159);
  INSERT INTO city(name, county_id) VALUES ('Waite', 1172);
  INSERT INTO city(name, county_id) VALUES ('Waldo', 1171);
  INSERT INTO city(name, county_id) VALUES ('Waldoboro', 1165);
  INSERT INTO city(name, county_id) VALUES ('Wales', 1158);
  INSERT INTO city(name, county_id) VALUES ('Wallagrass', 1159);
  INSERT INTO city(name, county_id) VALUES ('Waltham', 1162);
  INSERT INTO city(name, county_id) VALUES ('Warren', 1164);
  INSERT INTO city(name, county_id) VALUES ('Washburn', 1159);
  INSERT INTO city(name, county_id) VALUES ('Washington', 1164);
  INSERT INTO city(name, county_id) VALUES ('Waterboro', 1173);
  INSERT INTO city(name, county_id) VALUES ('Waterford', 1166);
  INSERT INTO city(name, county_id) VALUES ('Wayne', 1163);
  INSERT INTO city(name, county_id) VALUES ('Weld', 1161);
  INSERT INTO city(name, county_id) VALUES ('Wellington', 1168);
  INSERT INTO city(name, county_id) VALUES ('Wells', 1173);
  INSERT INTO city(name, county_id) VALUES ('Wesley', 1172);
  INSERT INTO city(name, county_id) VALUES ('West Bath', 1169);
  INSERT INTO city(name, county_id) VALUES ('West Gardiner', 1163);
  INSERT INTO city(name, county_id) VALUES ('West Paris', 1166);
  INSERT INTO city(name, county_id) VALUES ('Westfield', 1159);
  INSERT INTO city(name, county_id) VALUES ('Westmanland', 1159);
  INSERT INTO city(name, county_id) VALUES ('Weston', 1159);
  INSERT INTO city(name, county_id) VALUES ('Westport Island', 1165);
  INSERT INTO city(name, county_id) VALUES ('Whitefield', 1165);
  INSERT INTO city(name, county_id) VALUES ('Whiting', 1172);
  INSERT INTO city(name, county_id) VALUES ('Whitneyville', 1172);
  INSERT INTO city(name, county_id) VALUES ('Willimantic', 1168);
  INSERT INTO city(name, county_id) VALUES ('Wilton', 1161);
  INSERT INTO city(name, county_id) VALUES ('Windham', 1160);
  INSERT INTO city(name, county_id) VALUES ('Windsor', 1163);
  INSERT INTO city(name, county_id) VALUES ('Winn', 1167);
  INSERT INTO city(name, county_id) VALUES ('Winslow', 1163);
  INSERT INTO city(name, county_id) VALUES ('Winter Harbor', 1162);
  INSERT INTO city(name, county_id) VALUES ('Winterport', 1171);
  INSERT INTO city(name, county_id) VALUES ('Winthrop', 1163);
  INSERT INTO city(name, county_id) VALUES ('Wiscasset', 1165);
  INSERT INTO city(name, county_id) VALUES ('Woodland', 1159);
  INSERT INTO city(name, county_id) VALUES ('Woodstock', 1166);
  INSERT INTO city(name, county_id) VALUES ('Woodville', 1167);
  INSERT INTO city(name, county_id) VALUES ('Woolwich', 1169);
  INSERT INTO city(name, county_id) VALUES ('Yarmouth', 1160);
  INSERT INTO city(name, county_id) VALUES ('York', 1173);
  
  INSERT INTO city(name, county_id) VALUES ('Acworth', 1735);
  INSERT INTO city(name, county_id) VALUES ('Albany', 1727);
  INSERT INTO city(name, county_id) VALUES ('Alexandria', 1730);
  INSERT INTO city(name, county_id) VALUES ('Allenstown', 1732);
  INSERT INTO city(name, county_id) VALUES ('Alstead', 1728);
  INSERT INTO city(name, county_id) VALUES ('Alton', 1726);
  INSERT INTO city(name, county_id) VALUES ('Amherst', 1731);
  INSERT INTO city(name, county_id) VALUES ('Andover', 1732);
  INSERT INTO city(name, county_id) VALUES ('Antrim', 1731);
  INSERT INTO city(name, county_id) VALUES ('Ashland', 1730);
  INSERT INTO city(name, county_id) VALUES ('Atkinson', 1733);
  INSERT INTO city(name, county_id) VALUES ('Auburn', 1733);
  INSERT INTO city(name, county_id) VALUES ('Barnstead', 1726);
  INSERT INTO city(name, county_id) VALUES ('Barrington', 1734);
  INSERT INTO city(name, county_id) VALUES ('Bartlett', 1727);
  INSERT INTO city(name, county_id) VALUES ('Bath', 1730);
  INSERT INTO city(name, county_id) VALUES ('Belmont', 1726);
  INSERT INTO city(name, county_id) VALUES ('Bennington', 1731);
  INSERT INTO city(name, county_id) VALUES ('Benton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Bethlehem', 1730);
  INSERT INTO city(name, county_id) VALUES ('Boscawen', 1732);
  INSERT INTO city(name, county_id) VALUES ('Bow', 1732);
  INSERT INTO city(name, county_id) VALUES ('Bradford', 1732);
  INSERT INTO city(name, county_id) VALUES ('Brentwood', 1733);
  INSERT INTO city(name, county_id) VALUES ('Bridgewater', 1730);
  INSERT INTO city(name, county_id) VALUES ('Brookfield', 1727);
  INSERT INTO city(name, county_id) VALUES ('Brookline', 1731);
  INSERT INTO city(name, county_id) VALUES ('Campton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Canaan', 1730);
  INSERT INTO city(name, county_id) VALUES ('Candia', 1733);
  INSERT INTO city(name, county_id) VALUES ('Canterbury', 1732);
  INSERT INTO city(name, county_id) VALUES ('Carroll', 1729);
  INSERT INTO city(name, county_id) VALUES ('Center Harbor', 1726);
  INSERT INTO city(name, county_id) VALUES ('Charlestown', 1735);
  INSERT INTO city(name, county_id) VALUES ('Chatham', 1727);
  INSERT INTO city(name, county_id) VALUES ('Chester', 1733);
  INSERT INTO city(name, county_id) VALUES ('Chesterfield', 1728);
  INSERT INTO city(name, county_id) VALUES ('Chichester', 1732);
  INSERT INTO city(name, county_id) VALUES ('Clarksville', 1729);
  INSERT INTO city(name, county_id) VALUES ('Colebrook', 1729);
  INSERT INTO city(name, county_id) VALUES ('Columbia', 1729);
  INSERT INTO city(name, county_id) VALUES ('Conway', 1727);
  INSERT INTO city(name, county_id) VALUES ('Cornish', 1735);
  INSERT INTO city(name, county_id) VALUES ('Croydon', 1735);
  INSERT INTO city(name, county_id) VALUES ('Dalton', 1729);
  INSERT INTO city(name, county_id) VALUES ('Danbury', 1732);
  INSERT INTO city(name, county_id) VALUES ('Danville', 1733);
  INSERT INTO city(name, county_id) VALUES ('Deerfield', 1733);
  INSERT INTO city(name, county_id) VALUES ('Deering', 1731);
  INSERT INTO city(name, county_id) VALUES ('Derry', 1733);
  INSERT INTO city(name, county_id) VALUES ('Dorchester', 1730);
  INSERT INTO city(name, county_id) VALUES ('Dublin', 1728);
  INSERT INTO city(name, county_id) VALUES ('Dummer', 1729);
  INSERT INTO city(name, county_id) VALUES ('Dunbarton', 1732);
  INSERT INTO city(name, county_id) VALUES ('Durham', 1734);
  INSERT INTO city(name, county_id) VALUES ('East Kingston', 1733);
  INSERT INTO city(name, county_id) VALUES ('Easton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Eaton', 1727);
  INSERT INTO city(name, county_id) VALUES ('Effingham', 1727);
  INSERT INTO city(name, county_id) VALUES ('Ellsworth', 1730);
  INSERT INTO city(name, county_id) VALUES ('Enfield', 1730);
  INSERT INTO city(name, county_id) VALUES ('Epping', 1733);
  INSERT INTO city(name, county_id) VALUES ('Epsom', 1732);
  INSERT INTO city(name, county_id) VALUES ('Errol', 1729);
  INSERT INTO city(name, county_id) VALUES ('Exeter', 1733);
  INSERT INTO city(name, county_id) VALUES ('Farmington', 1734);
  INSERT INTO city(name, county_id) VALUES ('Fitzwilliam', 1728);
  INSERT INTO city(name, county_id) VALUES ('Francestown', 1731);
  INSERT INTO city(name, county_id) VALUES ('Franconia', 1730);
  INSERT INTO city(name, county_id) VALUES ('Freedom', 1727);
  INSERT INTO city(name, county_id) VALUES ('Fremont', 1733);
  INSERT INTO city(name, county_id) VALUES ('Gilford', 1726);
  INSERT INTO city(name, county_id) VALUES ('Gilmanton', 1726);
  INSERT INTO city(name, county_id) VALUES ('Gilsum', 1728);
  INSERT INTO city(name, county_id) VALUES ('Goffstown', 1731);
  INSERT INTO city(name, county_id) VALUES ('Gorham', 1729);
  INSERT INTO city(name, county_id) VALUES ('Goshen', 1735);
  INSERT INTO city(name, county_id) VALUES ('Grafton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Grantham', 1735);
  INSERT INTO city(name, county_id) VALUES ('Greenfield', 1731);
  INSERT INTO city(name, county_id) VALUES ('Greenland', 1733);
  INSERT INTO city(name, county_id) VALUES ('Greenville', 1731);
  INSERT INTO city(name, county_id) VALUES ('Groton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Hampstead', 1733);
  INSERT INTO city(name, county_id) VALUES ('Hampton', 1733);
  INSERT INTO city(name, county_id) VALUES ('Hampton Falls', 1733);
  INSERT INTO city(name, county_id) VALUES ('Hancock', 1731);
  INSERT INTO city(name, county_id) VALUES ('Hanover', 1730);
  INSERT INTO city(name, county_id) VALUES ('Harrisville', 1728);
  INSERT INTO city(name, county_id) VALUES ('Hart''S Location', 1727);
  INSERT INTO city(name, county_id) VALUES ('Haverhill', 1730);
  INSERT INTO city(name, county_id) VALUES ('Hebron', 1730);
  INSERT INTO city(name, county_id) VALUES ('Henniker', 1732);
  INSERT INTO city(name, county_id) VALUES ('Hill', 1732);
  INSERT INTO city(name, county_id) VALUES ('Hillsborough', 1731);
  INSERT INTO city(name, county_id) VALUES ('Hinsdale', 1728);
  INSERT INTO city(name, county_id) VALUES ('Holderness', 1730);
  INSERT INTO city(name, county_id) VALUES ('Hollis', 1731);
  INSERT INTO city(name, county_id) VALUES ('Hooksett', 1732);
  INSERT INTO city(name, county_id) VALUES ('Hopkinton', 1732);
  INSERT INTO city(name, county_id) VALUES ('Hudson', 1731);
  INSERT INTO city(name, county_id) VALUES ('Jackson', 1727);
  INSERT INTO city(name, county_id) VALUES ('Jaffrey', 1728);
  INSERT INTO city(name, county_id) VALUES ('Jefferson', 1729);
  INSERT INTO city(name, county_id) VALUES ('Kensington', 1733);
  INSERT INTO city(name, county_id) VALUES ('Kingston', 1733);
  INSERT INTO city(name, county_id) VALUES ('Lancaster', 1729);
  INSERT INTO city(name, county_id) VALUES ('Landaff', 1730);
  INSERT INTO city(name, county_id) VALUES ('Langdon', 1735);
  INSERT INTO city(name, county_id) VALUES ('Lee', 1734);
  INSERT INTO city(name, county_id) VALUES ('Lempster', 1735);
  INSERT INTO city(name, county_id) VALUES ('Lincoln', 1730);
  INSERT INTO city(name, county_id) VALUES ('Lisbon', 1730);
  INSERT INTO city(name, county_id) VALUES ('Litchfield', 1731);
  INSERT INTO city(name, county_id) VALUES ('Littleton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Londonderry', 1733);
  INSERT INTO city(name, county_id) VALUES ('Loudon', 1732);
  INSERT INTO city(name, county_id) VALUES ('Lyman', 1730);
  INSERT INTO city(name, county_id) VALUES ('Lyme', 1730);
  INSERT INTO city(name, county_id) VALUES ('Lyndeborough', 1731);
  INSERT INTO city(name, county_id) VALUES ('Madbury', 1734);
  INSERT INTO city(name, county_id) VALUES ('Madison', 1727);
  INSERT INTO city(name, county_id) VALUES ('Marlborough', 1728);
  INSERT INTO city(name, county_id) VALUES ('Marlow', 1728);
  INSERT INTO city(name, county_id) VALUES ('Mason', 1731);
  INSERT INTO city(name, county_id) VALUES ('Meredith', 1726);
  INSERT INTO city(name, county_id) VALUES ('Merrimack', 1731);
  INSERT INTO city(name, county_id) VALUES ('Middleton', 1734);
  INSERT INTO city(name, county_id) VALUES ('Milan', 1729);
  INSERT INTO city(name, county_id) VALUES ('Milford', 1731);
  INSERT INTO city(name, county_id) VALUES ('Milton', 1734);
  INSERT INTO city(name, county_id) VALUES ('Monroe', 1730);
  INSERT INTO city(name, county_id) VALUES ('Mont Vernon', 1731);
  INSERT INTO city(name, county_id) VALUES ('Moultonborough', 1727);
  INSERT INTO city(name, county_id) VALUES ('Nelson', 1728);
  INSERT INTO city(name, county_id) VALUES ('New Boston', 1731);
  INSERT INTO city(name, county_id) VALUES ('New Castle', 1733);
  INSERT INTO city(name, county_id) VALUES ('New Durham', 1734);
  INSERT INTO city(name, county_id) VALUES ('New Hampton', 1726);
  INSERT INTO city(name, county_id) VALUES ('New Ipswich', 1731);
  INSERT INTO city(name, county_id) VALUES ('New London', 1732);
  INSERT INTO city(name, county_id) VALUES ('Newbury', 1732);
  INSERT INTO city(name, county_id) VALUES ('Newfields', 1733);
  INSERT INTO city(name, county_id) VALUES ('Newington', 1733);
  INSERT INTO city(name, county_id) VALUES ('Newmarket', 1733);
  INSERT INTO city(name, county_id) VALUES ('Newport', 1735);
  INSERT INTO city(name, county_id) VALUES ('Newton', 1733);
  INSERT INTO city(name, county_id) VALUES ('North Hampton', 1733);
  INSERT INTO city(name, county_id) VALUES ('Northfield', 1732);
  INSERT INTO city(name, county_id) VALUES ('Northumberland', 1729);
  INSERT INTO city(name, county_id) VALUES ('Northwood', 1733);
  INSERT INTO city(name, county_id) VALUES ('Nottingham', 1733);
  INSERT INTO city(name, county_id) VALUES ('Orange', 1730);
  INSERT INTO city(name, county_id) VALUES ('Orford', 1730);
  INSERT INTO city(name, county_id) VALUES ('Ossipee', 1727);
  INSERT INTO city(name, county_id) VALUES ('Pelham', 1731);
  INSERT INTO city(name, county_id) VALUES ('Pembroke', 1732);
  INSERT INTO city(name, county_id) VALUES ('Peterborough', 1731);
  INSERT INTO city(name, county_id) VALUES ('Piermont', 1730);
  INSERT INTO city(name, county_id) VALUES ('Pittsburg', 1729);
  INSERT INTO city(name, county_id) VALUES ('Pittsfield', 1732);
  INSERT INTO city(name, county_id) VALUES ('Plainfield', 1735);
  INSERT INTO city(name, county_id) VALUES ('Plaistow', 1733);
  INSERT INTO city(name, county_id) VALUES ('Plymouth', 1730);
  INSERT INTO city(name, county_id) VALUES ('Randolph', 1729);
  INSERT INTO city(name, county_id) VALUES ('Raymond', 1733);
  INSERT INTO city(name, county_id) VALUES ('Richmond', 1728);
  INSERT INTO city(name, county_id) VALUES ('Rindge', 1728);
  INSERT INTO city(name, county_id) VALUES ('Rollinsford', 1734);
  INSERT INTO city(name, county_id) VALUES ('Roxbury', 1728);
  INSERT INTO city(name, county_id) VALUES ('Rumney', 1730);
  INSERT INTO city(name, county_id) VALUES ('Rye', 1733);
  INSERT INTO city(name, county_id) VALUES ('Salem', 1733);
  INSERT INTO city(name, county_id) VALUES ('Salisbury', 1732);
  INSERT INTO city(name, county_id) VALUES ('Sanbornton', 1726);
  INSERT INTO city(name, county_id) VALUES ('Sandown', 1733);
  INSERT INTO city(name, county_id) VALUES ('Sandwich', 1727);
  INSERT INTO city(name, county_id) VALUES ('Seabrook', 1733);
  INSERT INTO city(name, county_id) VALUES ('Sharon', 1731);
  INSERT INTO city(name, county_id) VALUES ('Shelburne', 1729);
  INSERT INTO city(name, county_id) VALUES ('South Hampton', 1733);
  INSERT INTO city(name, county_id) VALUES ('Springfield', 1735);
  INSERT INTO city(name, county_id) VALUES ('Stark', 1729);
  INSERT INTO city(name, county_id) VALUES ('Stewartstown', 1729);
  INSERT INTO city(name, county_id) VALUES ('Stoddard', 1728);
  INSERT INTO city(name, county_id) VALUES ('Strafford', 1734);
  INSERT INTO city(name, county_id) VALUES ('Stratford', 1729);
  INSERT INTO city(name, county_id) VALUES ('Stratham', 1733);
  INSERT INTO city(name, county_id) VALUES ('Sugar Hill', 1730);
  INSERT INTO city(name, county_id) VALUES ('Sullivan', 1728);
  INSERT INTO city(name, county_id) VALUES ('Sunapee', 1735);
  INSERT INTO city(name, county_id) VALUES ('Surry', 1728);
  INSERT INTO city(name, county_id) VALUES ('Sutton', 1732);
  INSERT INTO city(name, county_id) VALUES ('Swanzey', 1728);
  INSERT INTO city(name, county_id) VALUES ('Tamworth', 1727);
  INSERT INTO city(name, county_id) VALUES ('Temple', 1731);
  INSERT INTO city(name, county_id) VALUES ('Thornton', 1730);
  INSERT INTO city(name, county_id) VALUES ('Tilton', 1726);
  INSERT INTO city(name, county_id) VALUES ('Troy', 1728);
  INSERT INTO city(name, county_id) VALUES ('Tuftonboro', 1727);
  INSERT INTO city(name, county_id) VALUES ('Unity', 1735);
  INSERT INTO city(name, county_id) VALUES ('Wakefield', 1727);
  INSERT INTO city(name, county_id) VALUES ('Walpole', 1728);
  INSERT INTO city(name, county_id) VALUES ('Warner', 1732);
  INSERT INTO city(name, county_id) VALUES ('Warren', 1730);
  INSERT INTO city(name, county_id) VALUES ('Washington', 1735);
  INSERT INTO city(name, county_id) VALUES ('Waterville Valley', 1730);
  INSERT INTO city(name, county_id) VALUES ('Weare', 1731);
  INSERT INTO city(name, county_id) VALUES ('Webster', 1732);
  INSERT INTO city(name, county_id) VALUES ('Wentworth', 1730);
  INSERT INTO city(name, county_id) VALUES ('Westmoreland', 1728);
  INSERT INTO city(name, county_id) VALUES ('Whitefield', 1729);
  INSERT INTO city(name, county_id) VALUES ('Wilmot', 1732);
  INSERT INTO city(name, county_id) VALUES ('Wilton', 1731);
  INSERT INTO city(name, county_id) VALUES ('Winchester', 1728);
  INSERT INTO city(name, county_id) VALUES ('Windham', 1733);
  INSERT INTO city(name, county_id) VALUES ('Windsor', 1731);
  INSERT INTO city(name, county_id) VALUES ('Wolfeboro', 1727);
  INSERT INTO city(name, county_id) VALUES ('Woodstock', 1730);
  
  INSERT INTO city(name, county_id) VALUES ('Adams', 1812);
  INSERT INTO city(name, county_id) VALUES ('Addison', 1840);
  INSERT INTO city(name, county_id) VALUES ('Afton', 1798);
  INSERT INTO city(name, county_id) VALUES ('Alabama', 1808);
  INSERT INTO city(name, county_id) VALUES ('Alden', 1804);
  INSERT INTO city(name, county_id) VALUES ('Alexander', 1808);
  INSERT INTO city(name, county_id) VALUES ('Alexandria', 1812);
  INSERT INTO city(name, county_id) VALUES ('Alfred', 1791);
  INSERT INTO city(name, county_id) VALUES ('Allegany', 1794);
  INSERT INTO city(name, county_id) VALUES ('Allen', 1791);
  INSERT INTO city(name, county_id) VALUES ('Alma', 1791);
  INSERT INTO city(name, county_id) VALUES ('Almond', 1791);
  INSERT INTO city(name, county_id) VALUES ('Altona', 1799);
  INSERT INTO city(name, county_id) VALUES ('Amboy', 1827);
  INSERT INTO city(name, county_id) VALUES ('Amenia', 1803);
  INSERT INTO city(name, county_id) VALUES ('Amherst', 1804);
  INSERT INTO city(name, county_id) VALUES ('Amity', 1791);
  INSERT INTO city(name, county_id) VALUES ('Ancram', 1800);
  INSERT INTO city(name, county_id) VALUES ('Andes', 1802);
  INSERT INTO city(name, county_id) VALUES ('Andover', 1791);
  INSERT INTO city(name, county_id) VALUES ('Angelica', 1791);
  INSERT INTO city(name, county_id) VALUES ('Annsville', 1822);
  INSERT INTO city(name, county_id) VALUES ('Antwerp', 1812);
  INSERT INTO city(name, county_id) VALUES ('Arcade', 1850);
  INSERT INTO city(name, county_id) VALUES ('Arcadia', 1848);
  INSERT INTO city(name, county_id) VALUES ('Argyle', 1847);
  INSERT INTO city(name, county_id) VALUES ('Arietta', 1810);
  INSERT INTO city(name, county_id) VALUES ('Arkwright', 1796);
  INSERT INTO city(name, county_id) VALUES ('Ashford', 1794);
  INSERT INTO city(name, county_id) VALUES ('Ashland', 1797);
  INSERT INTO city(name, county_id) VALUES ('Athens', 1809);
  INSERT INTO city(name, county_id) VALUES ('Attica', 1850);
  INSERT INTO city(name, county_id) VALUES ('Au Sable', 1799);
  INSERT INTO city(name, county_id) VALUES ('Augusta', 1822);
  INSERT INTO city(name, county_id) VALUES ('Aurelius', 1795);
  INSERT INTO city(name, county_id) VALUES ('Aurora', 1804);
  INSERT INTO city(name, county_id) VALUES ('Austerlitz', 1800);
  INSERT INTO city(name, county_id) VALUES ('Ava', 1822);
  INSERT INTO city(name, county_id) VALUES ('Avoca', 1840);
  INSERT INTO city(name, county_id) VALUES ('Avon', 1815);
  INSERT INTO city(name, county_id) VALUES ('Babylon', 1841);
  INSERT INTO city(name, county_id) VALUES ('Bainbridge', 1798);
  INSERT INTO city(name, county_id) VALUES ('Ballston', 1834);
  INSERT INTO city(name, county_id) VALUES ('Bangor', 1806);
  INSERT INTO city(name, county_id) VALUES ('Barker', 1793);
  INSERT INTO city(name, county_id) VALUES ('Barre', 1826);
  INSERT INTO city(name, county_id) VALUES ('Barrington', 1851);
  INSERT INTO city(name, county_id) VALUES ('Barton', 1843);
  INSERT INTO city(name, county_id) VALUES ('Bath', 1840);
  INSERT INTO city(name, county_id) VALUES ('Bedford', 1849);
  INSERT INTO city(name, county_id) VALUES ('Beekman', 1803);
  INSERT INTO city(name, county_id) VALUES ('Beekmantown', 1799);
  INSERT INTO city(name, county_id) VALUES ('Belfast', 1791);
  INSERT INTO city(name, county_id) VALUES ('Bellmont', 1806);
  INSERT INTO city(name, county_id) VALUES ('Bennington', 1850);
  INSERT INTO city(name, county_id) VALUES ('Benson', 1810);
  INSERT INTO city(name, county_id) VALUES ('Benton', 1851);
  INSERT INTO city(name, county_id) VALUES ('Bergen', 1808);
  INSERT INTO city(name, county_id) VALUES ('Berkshire', 1843);
  INSERT INTO city(name, county_id) VALUES ('Berlin', 1831);
  INSERT INTO city(name, county_id) VALUES ('Berne', 1790);
  INSERT INTO city(name, county_id) VALUES ('Bethany', 1808);
  INSERT INTO city(name, county_id) VALUES ('Bethel', 1842);
  INSERT INTO city(name, county_id) VALUES ('Bethlehem', 1790);
  INSERT INTO city(name, county_id) VALUES ('Big Flats', 1797);
  INSERT INTO city(name, county_id) VALUES ('Birdsall', 1791);
  INSERT INTO city(name, county_id) VALUES ('Black Brook', 1799);
  INSERT INTO city(name, county_id) VALUES ('Bleecker', 1807);
  INSERT INTO city(name, county_id) VALUES ('Blenheim', 1836);
  INSERT INTO city(name, county_id) VALUES ('Blooming Grove', 1825);
  INSERT INTO city(name, county_id) VALUES ('Bolivar', 1791);
  INSERT INTO city(name, county_id) VALUES ('Bolton', 1846);
  INSERT INTO city(name, county_id) VALUES ('Bombay', 1806);
  INSERT INTO city(name, county_id) VALUES ('Boonville', 1822);
  INSERT INTO city(name, county_id) VALUES ('Boston', 1804);
  INSERT INTO city(name, county_id) VALUES ('Bovina', 1802);
  INSERT INTO city(name, county_id) VALUES ('Boylston', 1827);
  INSERT INTO city(name, county_id) VALUES ('Bradford', 1840);
  INSERT INTO city(name, county_id) VALUES ('Brandon', 1806);
  INSERT INTO city(name, county_id) VALUES ('Brant', 1804);
  INSERT INTO city(name, county_id) VALUES ('Brasher', 1839);
  INSERT INTO city(name, county_id) VALUES ('Bridgewater', 1822);
  INSERT INTO city(name, county_id) VALUES ('Brighton', 1806);
  INSERT INTO city(name, county_id) VALUES ('Bristol', 1824);
  INSERT INTO city(name, county_id) VALUES ('Broadalbin', 1807);
  INSERT INTO city(name, county_id) VALUES ('Brookfield', 1816);
  INSERT INTO city(name, county_id) VALUES ('Brookhaven', 1841);
  INSERT INTO city(name, county_id) VALUES ('Broome', 1836);
  INSERT INTO city(name, county_id) VALUES ('Brownville', 1812);
  INSERT INTO city(name, county_id) VALUES ('Brunswick', 1831);
  INSERT INTO city(name, county_id) VALUES ('Brutus', 1795);
  INSERT INTO city(name, county_id) VALUES ('Burke', 1806);
  INSERT INTO city(name, county_id) VALUES ('Burlington', 1828);
  INSERT INTO city(name, county_id) VALUES ('Burns', 1791);
  INSERT INTO city(name, county_id) VALUES ('Busti', 1796);
  INSERT INTO city(name, county_id) VALUES ('Butler', 1848);
  INSERT INTO city(name, county_id) VALUES ('Butternuts', 1828);
  INSERT INTO city(name, county_id) VALUES ('Byron', 1808);
  INSERT INTO city(name, county_id) VALUES ('Cairo', 1809);
  INSERT INTO city(name, county_id) VALUES ('Caledonia', 1815);
  INSERT INTO city(name, county_id) VALUES ('Callicoon', 1842);
  INSERT INTO city(name, county_id) VALUES ('Cambria', 1821);
  INSERT INTO city(name, county_id) VALUES ('Cambridge', 1847);
  INSERT INTO city(name, county_id) VALUES ('Camden', 1822);
  INSERT INTO city(name, county_id) VALUES ('Cameron', 1840);
  INSERT INTO city(name, county_id) VALUES ('Camillus', 1823);
  INSERT INTO city(name, county_id) VALUES ('Campbell', 1840);
  INSERT INTO city(name, county_id) VALUES ('Canaan', 1800);
  INSERT INTO city(name, county_id) VALUES ('Canadice', 1824);
  INSERT INTO city(name, county_id) VALUES ('Canajoharie', 1818);
  INSERT INTO city(name, county_id) VALUES ('Canandaigua', 1824);
  INSERT INTO city(name, county_id) VALUES ('Candor', 1843);
  INSERT INTO city(name, county_id) VALUES ('Caneadea', 1791);
  INSERT INTO city(name, county_id) VALUES ('Canisteo', 1840);
  INSERT INTO city(name, county_id) VALUES ('Canton', 1839);
  INSERT INTO city(name, county_id) VALUES ('Cape Vincent', 1812);
  INSERT INTO city(name, county_id) VALUES ('Carlisle', 1836);
  INSERT INTO city(name, county_id) VALUES ('Carlton', 1826);
  INSERT INTO city(name, county_id) VALUES ('Carmel', 1829);
  INSERT INTO city(name, county_id) VALUES ('Caroga', 1807);
  INSERT INTO city(name, county_id) VALUES ('Caroline', 1844);
  INSERT INTO city(name, county_id) VALUES ('Carroll', 1796);
  INSERT INTO city(name, county_id) VALUES ('Carrollton', 1794);
  INSERT INTO city(name, county_id) VALUES ('Castile', 1850);
  INSERT INTO city(name, county_id) VALUES ('Catharine', 1837);
  INSERT INTO city(name, county_id) VALUES ('Catlin', 1797);
  INSERT INTO city(name, county_id) VALUES ('Cato', 1795);
  INSERT INTO city(name, county_id) VALUES ('Caton', 1840);
  INSERT INTO city(name, county_id) VALUES ('Catskill', 1809);
  INSERT INTO city(name, county_id) VALUES ('Cayuta', 1837);
  INSERT INTO city(name, county_id) VALUES ('Cazenovia', 1816);
  INSERT INTO city(name, county_id) VALUES ('Centerville', 1791);
  INSERT INTO city(name, county_id) VALUES ('Champion', 1812);
  INSERT INTO city(name, county_id) VALUES ('Champlain', 1799);
  INSERT INTO city(name, county_id) VALUES ('Charleston', 1818);
  INSERT INTO city(name, county_id) VALUES ('Charlotte', 1796);
  INSERT INTO city(name, county_id) VALUES ('Charlton', 1834);
  INSERT INTO city(name, county_id) VALUES ('Chateaugay', 1806);
  INSERT INTO city(name, county_id) VALUES ('Chatham', 1800);
  INSERT INTO city(name, county_id) VALUES ('Chautauqua', 1796);
  INSERT INTO city(name, county_id) VALUES ('Chazy', 1799);
  INSERT INTO city(name, county_id) VALUES ('Cheektowaga', 1804);
  INSERT INTO city(name, county_id) VALUES ('Chemung', 1797);
  INSERT INTO city(name, county_id) VALUES ('Chenango', 1793);
  INSERT INTO city(name, county_id) VALUES ('Cherry Creek', 1796);
  INSERT INTO city(name, county_id) VALUES ('Cherry Valley', 1828);
  INSERT INTO city(name, county_id) VALUES ('Chesterfield', 1805);
  INSERT INTO city(name, county_id) VALUES ('Chili', 1817);
  INSERT INTO city(name, county_id) VALUES ('Cicero', 1823);
  INSERT INTO city(name, county_id) VALUES ('Cincinnatus', 1801);
  INSERT INTO city(name, county_id) VALUES ('Clare', 1839);
  INSERT INTO city(name, county_id) VALUES ('Clarence', 1804);
  INSERT INTO city(name, county_id) VALUES ('Clarendon', 1826);
  INSERT INTO city(name, county_id) VALUES ('Clarkson', 1817);
  INSERT INTO city(name, county_id) VALUES ('Clarkstown', 1833);
  INSERT INTO city(name, county_id) VALUES ('Clarksville', 1791);
  INSERT INTO city(name, county_id) VALUES ('Claverack', 1800);
  INSERT INTO city(name, county_id) VALUES ('Clay', 1823);
  INSERT INTO city(name, county_id) VALUES ('Clayton', 1812);
  INSERT INTO city(name, county_id) VALUES ('Clermont', 1800);
  INSERT INTO city(name, county_id) VALUES ('Clifton', 1839);
  INSERT INTO city(name, county_id) VALUES ('Clifton Park', 1834);
  INSERT INTO city(name, county_id) VALUES ('Clymer', 1796);
  INSERT INTO city(name, county_id) VALUES ('Cobleskill', 1836);
  INSERT INTO city(name, county_id) VALUES ('Cochecton', 1842);
  INSERT INTO city(name, county_id) VALUES ('Coeymans', 1790);
  INSERT INTO city(name, county_id) VALUES ('Cohocton', 1840);
  INSERT INTO city(name, county_id) VALUES ('Colchester', 1802);
  INSERT INTO city(name, county_id) VALUES ('Colden', 1804);
  INSERT INTO city(name, county_id) VALUES ('Coldspring', 1794);
  INSERT INTO city(name, county_id) VALUES ('Colesville', 1793);
  INSERT INTO city(name, county_id) VALUES ('Collins', 1804);
  INSERT INTO city(name, county_id) VALUES ('Colonie', 1790);
  INSERT INTO city(name, county_id) VALUES ('Colton', 1839);
  INSERT INTO city(name, county_id) VALUES ('Columbia', 1811);
  INSERT INTO city(name, county_id) VALUES ('Columbus', 1798);
  INSERT INTO city(name, county_id) VALUES ('Concord', 1804);
  INSERT INTO city(name, county_id) VALUES ('Conesus', 1815);
  INSERT INTO city(name, county_id) VALUES ('Conesville', 1836);
  INSERT INTO city(name, county_id) VALUES ('Conewango', 1794);
  INSERT INTO city(name, county_id) VALUES ('Conklin', 1793);
  INSERT INTO city(name, county_id) VALUES ('Conquest', 1795);
  INSERT INTO city(name, county_id) VALUES ('Constable', 1806);
  INSERT INTO city(name, county_id) VALUES ('Constantia', 1827);
  INSERT INTO city(name, county_id) VALUES ('Copake', 1800);
  INSERT INTO city(name, county_id) VALUES ('Corinth', 1834);
  INSERT INTO city(name, county_id) VALUES ('Cornwall', 1825);
  INSERT INTO city(name, county_id) VALUES ('Cortlandt', 1849);
  INSERT INTO city(name, county_id) VALUES ('Cortlandville', 1801);
  INSERT INTO city(name, county_id) VALUES ('Coventry', 1798);
  INSERT INTO city(name, county_id) VALUES ('Covert', 1838);
  INSERT INTO city(name, county_id) VALUES ('Covington', 1850);
  INSERT INTO city(name, county_id) VALUES ('Coxsackie', 1809);
  INSERT INTO city(name, county_id) VALUES ('Crawford', 1825);
  INSERT INTO city(name, county_id) VALUES ('Croghan', 1814);
  INSERT INTO city(name, county_id) VALUES ('Crown Point', 1805);
  INSERT INTO city(name, county_id) VALUES ('Cuba', 1791);
  INSERT INTO city(name, county_id) VALUES ('Cuyler', 1801);
  INSERT INTO city(name, county_id) VALUES ('Danby', 1844);
  INSERT INTO city(name, county_id) VALUES ('Dannemora', 1799);
  INSERT INTO city(name, county_id) VALUES ('Danube', 1811);
  INSERT INTO city(name, county_id) VALUES ('Darien', 1808);
  INSERT INTO city(name, county_id) VALUES ('Davenport', 1802);
  INSERT INTO city(name, county_id) VALUES ('Day', 1834);
  INSERT INTO city(name, county_id) VALUES ('Dayton', 1794);
  INSERT INTO city(name, county_id) VALUES ('De Kalb', 1839);
  INSERT INTO city(name, county_id) VALUES ('De Peyster', 1839);
  INSERT INTO city(name, county_id) VALUES ('Deruyter', 1816);
  INSERT INTO city(name, county_id) VALUES ('Dewitt (De Witt)', 1823);
  INSERT INTO city(name, county_id) VALUES ('Decatur', 1828);
  INSERT INTO city(name, county_id) VALUES ('Deerfield', 1822);
  INSERT INTO city(name, county_id) VALUES ('Deerpark', 1825);
  INSERT INTO city(name, county_id) VALUES ('Delaware', 1842);
  INSERT INTO city(name, county_id) VALUES ('Delhi', 1802);
  INSERT INTO city(name, county_id) VALUES ('Denmark', 1814);
  INSERT INTO city(name, county_id) VALUES ('Denning', 1845);
  INSERT INTO city(name, county_id) VALUES ('Deposit', 1802);
  INSERT INTO city(name, county_id) VALUES ('Diana', 1814);
  INSERT INTO city(name, county_id) VALUES ('Dickinson', 1793);
  INSERT INTO city(name, county_id) VALUES ('Dix', 1837);
  INSERT INTO city(name, county_id) VALUES ('Dover', 1803);
  INSERT INTO city(name, county_id) VALUES ('Dresden', 1847);
  INSERT INTO city(name, county_id) VALUES ('Dryden', 1844);
  INSERT INTO city(name, county_id) VALUES ('Duane', 1806);
  INSERT INTO city(name, county_id) VALUES ('Duanesburg', 1835);
  INSERT INTO city(name, county_id) VALUES ('Durham', 1809);
  INSERT INTO city(name, county_id) VALUES ('Eagle', 1850);
  INSERT INTO city(name, county_id) VALUES ('East Bloomfield', 1824);
  INSERT INTO city(name, county_id) VALUES ('East Fishkill', 1803);
  INSERT INTO city(name, county_id) VALUES ('East Greenbush', 1831);
  INSERT INTO city(name, county_id) VALUES ('East Hampton', 1841);
  INSERT INTO city(name, county_id) VALUES ('East Otto', 1794);
  INSERT INTO city(name, county_id) VALUES ('Eastchester', 1849);
  INSERT INTO city(name, county_id) VALUES ('Easton', 1847);
  INSERT INTO city(name, county_id) VALUES ('Eaton', 1816);
  INSERT INTO city(name, county_id) VALUES ('Eden', 1804);
  INSERT INTO city(name, county_id) VALUES ('Edinburg', 1834);
  INSERT INTO city(name, county_id) VALUES ('Edmeston', 1828);
  INSERT INTO city(name, county_id) VALUES ('Edwards', 1839);
  INSERT INTO city(name, county_id) VALUES ('Elba', 1808);
  INSERT INTO city(name, county_id) VALUES ('Elbridge', 1823);
  INSERT INTO city(name, county_id) VALUES ('Elizabethtown', 1805);
  INSERT INTO city(name, county_id) VALUES ('Ellenburg', 1799);
  INSERT INTO city(name, county_id) VALUES ('Ellery', 1796);
  INSERT INTO city(name, county_id) VALUES ('Ellicott', 1796);
  INSERT INTO city(name, county_id) VALUES ('Ellicottville', 1794);
  INSERT INTO city(name, county_id) VALUES ('Ellington', 1796);
  INSERT INTO city(name, county_id) VALUES ('Ellisburg', 1812);
  INSERT INTO city(name, county_id) VALUES ('Elma', 1804);
  INSERT INTO city(name, county_id) VALUES ('Enfield', 1844);
  INSERT INTO city(name, county_id) VALUES ('Ephratah', 1807);
  INSERT INTO city(name, county_id) VALUES ('Erin', 1797);
  INSERT INTO city(name, county_id) VALUES ('Erwin', 1840);
  INSERT INTO city(name, county_id) VALUES ('Esopus', 1845);
  INSERT INTO city(name, county_id) VALUES ('Esperance', 1836);
  INSERT INTO city(name, county_id) VALUES ('Essex', 1805);
  INSERT INTO city(name, county_id) VALUES ('Evans', 1804);
  INSERT INTO city(name, county_id) VALUES ('Exeter', 1828);
  INSERT INTO city(name, county_id) VALUES ('Fabius', 1823);
  INSERT INTO city(name, county_id) VALUES ('Fairfield', 1811);
  INSERT INTO city(name, county_id) VALUES ('Fallsburg', 1842);
  INSERT INTO city(name, county_id) VALUES ('Farmersville', 1794);
  INSERT INTO city(name, county_id) VALUES ('Farmington', 1824);
  INSERT INTO city(name, county_id) VALUES ('Fayette', 1838);
  INSERT INTO city(name, county_id) VALUES ('Fenner', 1816);
  INSERT INTO city(name, county_id) VALUES ('Fenton', 1793);
  INSERT INTO city(name, county_id) VALUES ('Fine', 1839);
  INSERT INTO city(name, county_id) VALUES ('Fishkill', 1803);
  INSERT INTO city(name, county_id) VALUES ('Fleming', 1795);
  INSERT INTO city(name, county_id) VALUES ('Florence', 1822);
  INSERT INTO city(name, county_id) VALUES ('Floyd', 1822);
  INSERT INTO city(name, county_id) VALUES ('Forestburgh', 1842);
  INSERT INTO city(name, county_id) VALUES ('Forestport', 1822);
  INSERT INTO city(name, county_id) VALUES ('Fort Ann', 1847);
  INSERT INTO city(name, county_id) VALUES ('Fort Covington', 1806);
  INSERT INTO city(name, county_id) VALUES ('Fort Edward', 1847);
  INSERT INTO city(name, county_id) VALUES ('Fowler', 1839);
  INSERT INTO city(name, county_id) VALUES ('Frankfort', 1811);
  INSERT INTO city(name, county_id) VALUES ('Franklinville', 1794);
  INSERT INTO city(name, county_id) VALUES ('Freedom', 1794);
  INSERT INTO city(name, county_id) VALUES ('Freetown', 1801);
  INSERT INTO city(name, county_id) VALUES ('Fremont', 1840);
  INSERT INTO city(name, county_id) VALUES ('French Creek', 1796);
  INSERT INTO city(name, county_id) VALUES ('Friendship', 1791);
  INSERT INTO city(name, county_id) VALUES ('Gaines', 1826);
  INSERT INTO city(name, county_id) VALUES ('Gainesville', 1850);
  INSERT INTO city(name, county_id) VALUES ('Galen', 1848);
  INSERT INTO city(name, county_id) VALUES ('Gallatin', 1800);
  INSERT INTO city(name, county_id) VALUES ('Galway', 1834);
  INSERT INTO city(name, county_id) VALUES ('Gardiner', 1845);
  INSERT INTO city(name, county_id) VALUES ('Gates', 1817);
  INSERT INTO city(name, county_id) VALUES ('Geddes', 1823);
  INSERT INTO city(name, county_id) VALUES ('Genesee', 1791);
  INSERT INTO city(name, county_id) VALUES ('Genesee Falls', 1850);
  INSERT INTO city(name, county_id) VALUES ('Geneseo', 1815);
  INSERT INTO city(name, county_id) VALUES ('Genoa', 1795);
  INSERT INTO city(name, county_id) VALUES ('Georgetown', 1816);
  INSERT INTO city(name, county_id) VALUES ('German', 1798);
  INSERT INTO city(name, county_id) VALUES ('German Flatts', 1811);
  INSERT INTO city(name, county_id) VALUES ('Germantown', 1800);
  INSERT INTO city(name, county_id) VALUES ('Gerry', 1796);
  INSERT INTO city(name, county_id) VALUES ('Ghent', 1800);
  INSERT INTO city(name, county_id) VALUES ('Gilboa', 1836);
  INSERT INTO city(name, county_id) VALUES ('Glen', 1818);
  INSERT INTO city(name, county_id) VALUES ('Glenville', 1835);
  INSERT INTO city(name, county_id) VALUES ('Gorham', 1824);
  INSERT INTO city(name, county_id) VALUES ('Goshen', 1825);
  INSERT INTO city(name, county_id) VALUES ('Gouverneur', 1839);
  INSERT INTO city(name, county_id) VALUES ('Grafton', 1831);
  INSERT INTO city(name, county_id) VALUES ('Granby', 1827);
  INSERT INTO city(name, county_id) VALUES ('Grand Island', 1804);
  INSERT INTO city(name, county_id) VALUES ('Granger', 1791);
  INSERT INTO city(name, county_id) VALUES ('Granville', 1847);
  INSERT INTO city(name, county_id) VALUES ('Great Valley', 1794);
  INSERT INTO city(name, county_id) VALUES ('Greece', 1817);
  INSERT INTO city(name, county_id) VALUES ('Greenburgh', 1849);
  INSERT INTO city(name, county_id) VALUES ('Greene', 1798);
  INSERT INTO city(name, county_id) VALUES ('Greenfield', 1834);
  INSERT INTO city(name, county_id) VALUES ('Greenport', 1800);
  INSERT INTO city(name, county_id) VALUES ('Greenwich', 1847);
  INSERT INTO city(name, county_id) VALUES ('Greenwood', 1840);
  INSERT INTO city(name, county_id) VALUES ('Greig', 1814);
  INSERT INTO city(name, county_id) VALUES ('Groton', 1844);
  INSERT INTO city(name, county_id) VALUES ('Grove', 1791);
  INSERT INTO city(name, county_id) VALUES ('Groveland', 1815);
  INSERT INTO city(name, county_id) VALUES ('Guilderland', 1790);
  INSERT INTO city(name, county_id) VALUES ('Guilford', 1798);
  INSERT INTO city(name, county_id) VALUES ('Hadley', 1834);
  INSERT INTO city(name, county_id) VALUES ('Hague', 1846);
  INSERT INTO city(name, county_id) VALUES ('Halcott', 1809);
  INSERT INTO city(name, county_id) VALUES ('Halfmoon', 1834);
  INSERT INTO city(name, county_id) VALUES ('Hamburg', 1804);
  INSERT INTO city(name, county_id) VALUES ('Hamden', 1802);
  INSERT INTO city(name, county_id) VALUES ('Hamilton', 1816);
  INSERT INTO city(name, county_id) VALUES ('Hamlin', 1817);
  INSERT INTO city(name, county_id) VALUES ('Hammond', 1839);
  INSERT INTO city(name, county_id) VALUES ('Hampton', 1847);
  INSERT INTO city(name, county_id) VALUES ('Hamptonburgh', 1825);
  INSERT INTO city(name, county_id) VALUES ('Hancock', 1802);
  INSERT INTO city(name, county_id) VALUES ('Hannibal', 1827);
  INSERT INTO city(name, county_id) VALUES ('Hanover', 1796);
  INSERT INTO city(name, county_id) VALUES ('Hardenburgh', 1845);
  INSERT INTO city(name, county_id) VALUES ('Harford', 1801);
  INSERT INTO city(name, county_id) VALUES ('Harmony', 1796);
  INSERT INTO city(name, county_id) VALUES ('Harpersfield', 1802);
  INSERT INTO city(name, county_id) VALUES ('Harrietstown', 1806);
  INSERT INTO city(name, county_id) VALUES ('Harrisburg', 1814);
  INSERT INTO city(name, county_id) VALUES ('Hartford', 1847);
  INSERT INTO city(name, county_id) VALUES ('Hartland', 1821);
  INSERT INTO city(name, county_id) VALUES ('Hartsville', 1840);
  INSERT INTO city(name, county_id) VALUES ('Hartwick', 1828);
  INSERT INTO city(name, county_id) VALUES ('Hastings', 1827);
  INSERT INTO city(name, county_id) VALUES ('Haverstraw', 1833);
  INSERT INTO city(name, county_id) VALUES ('Hebron', 1847);
  INSERT INTO city(name, county_id) VALUES ('Hector', 1837);
  INSERT INTO city(name, county_id) VALUES ('Hempstead', 1819);
  INSERT INTO city(name, county_id) VALUES ('Henderson', 1812);
  INSERT INTO city(name, county_id) VALUES ('Henrietta', 1817);
  INSERT INTO city(name, county_id) VALUES ('Herkimer', 1811);
  INSERT INTO city(name, county_id) VALUES ('Hermon', 1839);
  INSERT INTO city(name, county_id) VALUES ('Highlands', 1825);
  INSERT INTO city(name, county_id) VALUES ('Hillsdale', 1800);
  INSERT INTO city(name, county_id) VALUES ('Hinsdale', 1794);
  INSERT INTO city(name, county_id) VALUES ('Holland', 1804);
  INSERT INTO city(name, county_id) VALUES ('Homer', 1801);
  INSERT INTO city(name, county_id) VALUES ('Hoosick', 1831);
  INSERT INTO city(name, county_id) VALUES ('Hope', 1810);
  INSERT INTO city(name, county_id) VALUES ('Hopewell', 1824);
  INSERT INTO city(name, county_id) VALUES ('Hopkinton', 1839);
  INSERT INTO city(name, county_id) VALUES ('Horicon', 1846);
  INSERT INTO city(name, county_id) VALUES ('Hornby', 1840);
  INSERT INTO city(name, county_id) VALUES ('Hornellsville', 1840);
  INSERT INTO city(name, county_id) VALUES ('Horseheads', 1797);
  INSERT INTO city(name, county_id) VALUES ('Hounsfield', 1812);
  INSERT INTO city(name, county_id) VALUES ('Howard', 1840);
  INSERT INTO city(name, county_id) VALUES ('Hume', 1791);
  INSERT INTO city(name, county_id) VALUES ('Humphrey', 1794);
  INSERT INTO city(name, county_id) VALUES ('Hunter', 1809);
  INSERT INTO city(name, county_id) VALUES ('Huntington', 1841);
  INSERT INTO city(name, county_id) VALUES ('Hurley', 1845);
  INSERT INTO city(name, county_id) VALUES ('Huron', 1848);
  INSERT INTO city(name, county_id) VALUES ('Hyde Park', 1803);
  INSERT INTO city(name, county_id) VALUES ('Independence', 1791);
  INSERT INTO city(name, county_id) VALUES ('Indian Lake', 1810);
  INSERT INTO city(name, county_id) VALUES ('Inlet', 1810);
  INSERT INTO city(name, county_id) VALUES ('Ira', 1795);
  INSERT INTO city(name, county_id) VALUES ('Irondequoit', 1817);
  INSERT INTO city(name, county_id) VALUES ('Ischua', 1794);
  INSERT INTO city(name, county_id) VALUES ('Islip', 1841);
  INSERT INTO city(name, county_id) VALUES ('Italy', 1851);
  INSERT INTO city(name, county_id) VALUES ('Jackson', 1847);
  INSERT INTO city(name, county_id) VALUES ('Jasper', 1840);
  INSERT INTO city(name, county_id) VALUES ('Java', 1850);
  INSERT INTO city(name, county_id) VALUES ('Jay', 1805);
  INSERT INTO city(name, county_id) VALUES ('Jefferson', 1836);
  INSERT INTO city(name, county_id) VALUES ('Jerusalem', 1851);
  INSERT INTO city(name, county_id) VALUES ('Jewett', 1809);
  INSERT INTO city(name, county_id) VALUES ('Johnsburg', 1846);
  INSERT INTO city(name, county_id) VALUES ('Junius', 1838);
  INSERT INTO city(name, county_id) VALUES ('Keene', 1805);
  INSERT INTO city(name, county_id) VALUES ('Kendall', 1826);
  INSERT INTO city(name, county_id) VALUES ('Kent', 1829);
  INSERT INTO city(name, county_id) VALUES ('Kiantone', 1796);
  INSERT INTO city(name, county_id) VALUES ('Kinderhook', 1800);
  INSERT INTO city(name, county_id) VALUES ('Kingsbury', 1847);
  INSERT INTO city(name, county_id) VALUES ('Kirkland', 1822);
  INSERT INTO city(name, county_id) VALUES ('Kirkwood', 1793);
  INSERT INTO city(name, county_id) VALUES ('Knox', 1790);
  INSERT INTO city(name, county_id) VALUES ('Kortright', 1802);
  INSERT INTO city(name, county_id) VALUES ('Lafayette', 1823);
  INSERT INTO city(name, county_id) VALUES ('Lagrange (La Grange)', 1803);
  INSERT INTO city(name, county_id) VALUES ('Lake George', 1846);
  INSERT INTO city(name, county_id) VALUES ('Lake Luzerne', 1846);
  INSERT INTO city(name, county_id) VALUES ('Lake Pleasant', 1810);
  INSERT INTO city(name, county_id) VALUES ('Lancaster', 1804);
  INSERT INTO city(name, county_id) VALUES ('Lansing', 1844);
  INSERT INTO city(name, county_id) VALUES ('Lapeer', 1801);
  INSERT INTO city(name, county_id) VALUES ('Laurens', 1828);
  INSERT INTO city(name, county_id) VALUES ('Le Ray', 1812);
  INSERT INTO city(name, county_id) VALUES ('Le Roy', 1808);
  INSERT INTO city(name, county_id) VALUES ('Lebanon', 1816);
  INSERT INTO city(name, county_id) VALUES ('Ledyard', 1795);
  INSERT INTO city(name, county_id) VALUES ('Lee', 1822);
  INSERT INTO city(name, county_id) VALUES ('Leicester', 1815);
  INSERT INTO city(name, county_id) VALUES ('Lenox', 1816);
  INSERT INTO city(name, county_id) VALUES ('Leon', 1794);
  INSERT INTO city(name, county_id) VALUES ('Lewis', 1805);
  INSERT INTO city(name, county_id) VALUES ('Lewisboro', 1849);
  INSERT INTO city(name, county_id) VALUES ('Lewiston', 1821);
  INSERT INTO city(name, county_id) VALUES ('Lexington', 1809);
  INSERT INTO city(name, county_id) VALUES ('Leyden', 1814);
  INSERT INTO city(name, county_id) VALUES ('Liberty', 1842);
  INSERT INTO city(name, county_id) VALUES ('Lima', 1815);
  INSERT INTO city(name, county_id) VALUES ('Lincklaen', 1798);
  INSERT INTO city(name, county_id) VALUES ('Lincoln', 1816);
  INSERT INTO city(name, county_id) VALUES ('Lindley', 1840);
  INSERT INTO city(name, county_id) VALUES ('Lisbon', 1839);
  INSERT INTO city(name, county_id) VALUES ('Lisle', 1793);
  INSERT INTO city(name, county_id) VALUES ('Litchfield', 1811);
  INSERT INTO city(name, county_id) VALUES ('Little Valley', 1794);
  INSERT INTO city(name, county_id) VALUES ('Livingston', 1800);
  INSERT INTO city(name, county_id) VALUES ('Livonia', 1815);
  INSERT INTO city(name, county_id) VALUES ('Lloyd', 1845);
  INSERT INTO city(name, county_id) VALUES ('Locke', 1795);
  INSERT INTO city(name, county_id) VALUES ('Lodi', 1838);
  INSERT INTO city(name, county_id) VALUES ('Long Lake', 1810);
  INSERT INTO city(name, county_id) VALUES ('Lorraine', 1812);
  INSERT INTO city(name, county_id) VALUES ('Louisville', 1839);
  INSERT INTO city(name, county_id) VALUES ('Lowville', 1814);
  INSERT INTO city(name, county_id) VALUES ('Lumberland', 1842);
  INSERT INTO city(name, county_id) VALUES ('Lyme', 1812);
  INSERT INTO city(name, county_id) VALUES ('Lyndon', 1794);
  INSERT INTO city(name, county_id) VALUES ('Lyons', 1848);
  INSERT INTO city(name, county_id) VALUES ('Lyonsdale', 1814);
  INSERT INTO city(name, county_id) VALUES ('Lysander', 1823);
  INSERT INTO city(name, county_id) VALUES ('Macedon', 1848);
  INSERT INTO city(name, county_id) VALUES ('Machias', 1794);
  INSERT INTO city(name, county_id) VALUES ('Macomb', 1839);
  INSERT INTO city(name, county_id) VALUES ('Madison', 1816);
  INSERT INTO city(name, county_id) VALUES ('Madrid', 1839);
  INSERT INTO city(name, county_id) VALUES ('Maine', 1793);
  INSERT INTO city(name, county_id) VALUES ('Malone', 1806);
  INSERT INTO city(name, county_id) VALUES ('Malta', 1834);
  INSERT INTO city(name, county_id) VALUES ('Mamakating', 1842);
  INSERT INTO city(name, county_id) VALUES ('Mamaroneck', 1849);
  INSERT INTO city(name, county_id) VALUES ('Manchester', 1824);
  INSERT INTO city(name, county_id) VALUES ('Manheim', 1811);
  INSERT INTO city(name, county_id) VALUES ('Manlius', 1823);
  INSERT INTO city(name, county_id) VALUES ('Mansfield', 1794);
  INSERT INTO city(name, county_id) VALUES ('Marathon', 1801);
  INSERT INTO city(name, county_id) VALUES ('Marbletown', 1845);
  INSERT INTO city(name, county_id) VALUES ('Marcellus', 1823);
  INSERT INTO city(name, county_id) VALUES ('Marcy', 1822);
  INSERT INTO city(name, county_id) VALUES ('Marilla', 1804);
  INSERT INTO city(name, county_id) VALUES ('Marion', 1848);
  INSERT INTO city(name, county_id) VALUES ('Marlborough', 1845);
  INSERT INTO city(name, county_id) VALUES ('Marshall', 1822);
  INSERT INTO city(name, county_id) VALUES ('Martinsburg', 1814);
  INSERT INTO city(name, county_id) VALUES ('Maryland', 1828);
  INSERT INTO city(name, county_id) VALUES ('Masonville', 1802);
  INSERT INTO city(name, county_id) VALUES ('Massena', 1839);
  INSERT INTO city(name, county_id) VALUES ('Mayfield', 1807);
  INSERT INTO city(name, county_id) VALUES ('Mcdonough', 1798);
  INSERT INTO city(name, county_id) VALUES ('Mendon', 1817);
  INSERT INTO city(name, county_id) VALUES ('Mentz', 1795);
  INSERT INTO city(name, county_id) VALUES ('Meredith', 1802);
  INSERT INTO city(name, county_id) VALUES ('Mexico', 1827);
  INSERT INTO city(name, county_id) VALUES ('Middleburgh', 1836);
  INSERT INTO city(name, county_id) VALUES ('Middlebury', 1850);
  INSERT INTO city(name, county_id) VALUES ('Middlefield', 1828);
  INSERT INTO city(name, county_id) VALUES ('Middlesex', 1851);
  INSERT INTO city(name, county_id) VALUES ('Milan', 1803);
  INSERT INTO city(name, county_id) VALUES ('Milford', 1828);
  INSERT INTO city(name, county_id) VALUES ('Milo', 1851);
  INSERT INTO city(name, county_id) VALUES ('Mina', 1796);
  INSERT INTO city(name, county_id) VALUES ('Minden', 1818);
  INSERT INTO city(name, county_id) VALUES ('Minerva', 1805);
  INSERT INTO city(name, county_id) VALUES ('Minetto', 1827);
  INSERT INTO city(name, county_id) VALUES ('Minisink', 1825);
  INSERT INTO city(name, county_id) VALUES ('Mohawk', 1818);
  INSERT INTO city(name, county_id) VALUES ('Moira', 1806);
  INSERT INTO city(name, county_id) VALUES ('Monroe', 1825);
  INSERT INTO city(name, county_id) VALUES ('Montague', 1814);
  INSERT INTO city(name, county_id) VALUES ('Montezuma', 1795);
  INSERT INTO city(name, county_id) VALUES ('Montgomery', 1825);
  INSERT INTO city(name, county_id) VALUES ('Montour', 1837);
  INSERT INTO city(name, county_id) VALUES ('Mooers', 1799);
  INSERT INTO city(name, county_id) VALUES ('Moravia', 1795);
  INSERT INTO city(name, county_id) VALUES ('Moreau', 1834);
  INSERT INTO city(name, county_id) VALUES ('Morehouse', 1810);
  INSERT INTO city(name, county_id) VALUES ('Moriah', 1805);
  INSERT INTO city(name, county_id) VALUES ('Morris', 1828);
  INSERT INTO city(name, county_id) VALUES ('Morristown', 1839);
  INSERT INTO city(name, county_id) VALUES ('Mount Hope', 1825);
  INSERT INTO city(name, county_id) VALUES ('Mount Morris', 1815);
  INSERT INTO city(name, county_id) VALUES ('Mount Pleasant', 1849);
  INSERT INTO city(name, county_id) VALUES ('Murray', 1826);
  INSERT INTO city(name, county_id) VALUES ('Nanticoke', 1793);
  INSERT INTO city(name, county_id) VALUES ('Napoli', 1794);
  INSERT INTO city(name, county_id) VALUES ('Nassau', 1831);
  INSERT INTO city(name, county_id) VALUES ('Nelson', 1816);
  INSERT INTO city(name, county_id) VALUES ('Neversink', 1842);
  INSERT INTO city(name, county_id) VALUES ('New Albion', 1794);
  INSERT INTO city(name, county_id) VALUES ('New Baltimore', 1809);
  INSERT INTO city(name, county_id) VALUES ('New Berlin', 1798);
  INSERT INTO city(name, county_id) VALUES ('New Bremen', 1814);
  INSERT INTO city(name, county_id) VALUES ('New Castle', 1849);
  INSERT INTO city(name, county_id) VALUES ('New Hartford', 1822);
  INSERT INTO city(name, county_id) VALUES ('New Haven', 1827);
  INSERT INTO city(name, county_id) VALUES ('New Hudson', 1791);
  INSERT INTO city(name, county_id) VALUES ('New Lebanon', 1800);
  INSERT INTO city(name, county_id) VALUES ('New Lisbon', 1828);
  INSERT INTO city(name, county_id) VALUES ('New Paltz', 1845);
  INSERT INTO city(name, county_id) VALUES ('New Scotland', 1790);
  INSERT INTO city(name, county_id) VALUES ('New Windsor', 1825);
  INSERT INTO city(name, county_id) VALUES ('Newark Valley', 1843);
  INSERT INTO city(name, county_id) VALUES ('Newburgh', 1825);
  INSERT INTO city(name, county_id) VALUES ('Newcomb', 1805);
  INSERT INTO city(name, county_id) VALUES ('Newfane', 1821);
  INSERT INTO city(name, county_id) VALUES ('Newfield', 1844);
  INSERT INTO city(name, county_id) VALUES ('Newport', 1811);
  INSERT INTO city(name, county_id) VALUES ('Newstead', 1804);
  INSERT INTO city(name, county_id) VALUES ('Niagara', 1821);
  INSERT INTO city(name, county_id) VALUES ('Nichols', 1843);
  INSERT INTO city(name, county_id) VALUES ('Niles', 1795);
  INSERT INTO city(name, county_id) VALUES ('Niskayuna', 1835);
  INSERT INTO city(name, county_id) VALUES ('Norfolk', 1839);
  INSERT INTO city(name, county_id) VALUES ('North Castle', 1849);
  INSERT INTO city(name, county_id) VALUES ('North Collins', 1804);
  INSERT INTO city(name, county_id) VALUES ('North Dansville', 1815);
  INSERT INTO city(name, county_id) VALUES ('North East', 1803);
  INSERT INTO city(name, county_id) VALUES ('North Elba', 1805);
  INSERT INTO city(name, county_id) VALUES ('North Greenbush', 1831);
  INSERT INTO city(name, county_id) VALUES ('North Harmony', 1796);
  INSERT INTO city(name, county_id) VALUES ('North Hempstead', 1819);
  INSERT INTO city(name, county_id) VALUES ('North Hudson', 1805);
  INSERT INTO city(name, county_id) VALUES ('North Norwich', 1798);
  INSERT INTO city(name, county_id) VALUES ('North Salem', 1849);
  INSERT INTO city(name, county_id) VALUES ('Northampton', 1807);
  INSERT INTO city(name, county_id) VALUES ('Northumberland', 1834);
  INSERT INTO city(name, county_id) VALUES ('Norway', 1811);
  INSERT INTO city(name, county_id) VALUES ('Nunda', 1815);
  INSERT INTO city(name, county_id) VALUES ('Oakfield', 1808);
  INSERT INTO city(name, county_id) VALUES ('Ogden', 1817);
  INSERT INTO city(name, county_id) VALUES ('Ohio', 1811);
  INSERT INTO city(name, county_id) VALUES ('Olive', 1845);
  INSERT INTO city(name, county_id) VALUES ('Onondaga', 1823);
  INSERT INTO city(name, county_id) VALUES ('Ontario', 1848);
  INSERT INTO city(name, county_id) VALUES ('Oppenheim', 1807);
  INSERT INTO city(name, county_id) VALUES ('Orange', 1837);
  INSERT INTO city(name, county_id) VALUES ('Orangetown', 1833);
  INSERT INTO city(name, county_id) VALUES ('Orangeville', 1850);
  INSERT INTO city(name, county_id) VALUES ('Orchard Park', 1804);
  INSERT INTO city(name, county_id) VALUES ('Orleans', 1812);
  INSERT INTO city(name, county_id) VALUES ('Orwell', 1827);
  INSERT INTO city(name, county_id) VALUES ('Osceola', 1814);
  INSERT INTO city(name, county_id) VALUES ('Ossian', 1815);
  INSERT INTO city(name, county_id) VALUES ('Ossining', 1849);
  INSERT INTO city(name, county_id) VALUES ('Oswegatchie', 1839);
  INSERT INTO city(name, county_id) VALUES ('Otego', 1828);
  INSERT INTO city(name, county_id) VALUES ('Otisco', 1823);
  INSERT INTO city(name, county_id) VALUES ('Otsego', 1828);
  INSERT INTO city(name, county_id) VALUES ('Otselic', 1798);
  INSERT INTO city(name, county_id) VALUES ('Otto', 1794);
  INSERT INTO city(name, county_id) VALUES ('Ovid', 1838);
  INSERT INTO city(name, county_id) VALUES ('Owasco', 1795);
  INSERT INTO city(name, county_id) VALUES ('Owego', 1843);
  INSERT INTO city(name, county_id) VALUES ('Oxford', 1798);
  INSERT INTO city(name, county_id) VALUES ('Oyster Bay', 1819);
  INSERT INTO city(name, county_id) VALUES ('Palatine', 1818);
  INSERT INTO city(name, county_id) VALUES ('Palermo', 1827);
  INSERT INTO city(name, county_id) VALUES ('Palm Tree', 1825);
  INSERT INTO city(name, county_id) VALUES ('Palmyra', 1848);
  INSERT INTO city(name, county_id) VALUES ('Pamelia', 1812);
  INSERT INTO city(name, county_id) VALUES ('Paris', 1822);
  INSERT INTO city(name, county_id) VALUES ('Parish', 1827);
  INSERT INTO city(name, county_id) VALUES ('Parishville', 1839);
  INSERT INTO city(name, county_id) VALUES ('Parma', 1817);
  INSERT INTO city(name, county_id) VALUES ('Patterson', 1829);
  INSERT INTO city(name, county_id) VALUES ('Pavilion', 1808);
  INSERT INTO city(name, county_id) VALUES ('Pawling', 1803);
  INSERT INTO city(name, county_id) VALUES ('Pelham', 1849);
  INSERT INTO city(name, county_id) VALUES ('Pembroke', 1808);
  INSERT INTO city(name, county_id) VALUES ('Pendleton', 1821);
  INSERT INTO city(name, county_id) VALUES ('Penfield', 1817);
  INSERT INTO city(name, county_id) VALUES ('Perinton', 1817);
  INSERT INTO city(name, county_id) VALUES ('Perry', 1850);
  INSERT INTO city(name, county_id) VALUES ('Perrysburg', 1794);
  INSERT INTO city(name, county_id) VALUES ('Persia', 1794);
  INSERT INTO city(name, county_id) VALUES ('Perth', 1807);
  INSERT INTO city(name, county_id) VALUES ('Peru', 1799);
  INSERT INTO city(name, county_id) VALUES ('Petersburgh', 1831);
  INSERT INTO city(name, county_id) VALUES ('Pharsalia', 1798);
  INSERT INTO city(name, county_id) VALUES ('Phelps', 1824);
  INSERT INTO city(name, county_id) VALUES ('Philadelphia', 1812);
  INSERT INTO city(name, county_id) VALUES ('Philipstown', 1829);
  INSERT INTO city(name, county_id) VALUES ('Piercefield', 1839);
  INSERT INTO city(name, county_id) VALUES ('Pierrepont', 1839);
  INSERT INTO city(name, county_id) VALUES ('Pike', 1850);
  INSERT INTO city(name, county_id) VALUES ('Pinckney', 1814);
  INSERT INTO city(name, county_id) VALUES ('Pine Plains', 1803);
  INSERT INTO city(name, county_id) VALUES ('Pitcairn', 1839);
  INSERT INTO city(name, county_id) VALUES ('Pitcher', 1798);
  INSERT INTO city(name, county_id) VALUES ('Pittsfield', 1828);
  INSERT INTO city(name, county_id) VALUES ('Pittsford', 1817);
  INSERT INTO city(name, county_id) VALUES ('Pittstown', 1831);
  INSERT INTO city(name, county_id) VALUES ('Plainfield', 1828);
  INSERT INTO city(name, county_id) VALUES ('Plattekill', 1845);
  INSERT INTO city(name, county_id) VALUES ('Pleasant Valley', 1803);
  INSERT INTO city(name, county_id) VALUES ('Plymouth', 1798);
  INSERT INTO city(name, county_id) VALUES ('Poestenkill', 1831);
  INSERT INTO city(name, county_id) VALUES ('Poland', 1796);
  INSERT INTO city(name, county_id) VALUES ('Pomfret', 1796);
  INSERT INTO city(name, county_id) VALUES ('Pompey', 1823);
  INSERT INTO city(name, county_id) VALUES ('Portage', 1815);
  INSERT INTO city(name, county_id) VALUES ('Porter', 1821);
  INSERT INTO city(name, county_id) VALUES ('Portland', 1796);
  INSERT INTO city(name, county_id) VALUES ('Portville', 1794);
  INSERT INTO city(name, county_id) VALUES ('Potsdam', 1839);
  INSERT INTO city(name, county_id) VALUES ('Potter', 1851);
  INSERT INTO city(name, county_id) VALUES ('Pound Ridge', 1849);
  INSERT INTO city(name, county_id) VALUES ('Prattsburgh', 1840);
  INSERT INTO city(name, county_id) VALUES ('Prattsville', 1809);
  INSERT INTO city(name, county_id) VALUES ('Preble', 1801);
  INSERT INTO city(name, county_id) VALUES ('Preston', 1798);
  INSERT INTO city(name, county_id) VALUES ('Princetown', 1835);
  INSERT INTO city(name, county_id) VALUES ('Providence', 1834);
  INSERT INTO city(name, county_id) VALUES ('Pulteney', 1840);
  INSERT INTO city(name, county_id) VALUES ('Putnam', 1847);
  INSERT INTO city(name, county_id) VALUES ('Putnam Valley', 1829);
  INSERT INTO city(name, county_id) VALUES ('Queensbury', 1846);
  INSERT INTO city(name, county_id) VALUES ('Ramapo', 1833);
  INSERT INTO city(name, county_id) VALUES ('Randolph', 1794);
  INSERT INTO city(name, county_id) VALUES ('Rathbone', 1840);
  INSERT INTO city(name, county_id) VALUES ('Reading', 1837);
  INSERT INTO city(name, county_id) VALUES ('Red Hook', 1803);
  INSERT INTO city(name, county_id) VALUES ('Red House', 1794);
  INSERT INTO city(name, county_id) VALUES ('Redfield', 1827);
  INSERT INTO city(name, county_id) VALUES ('Remsen', 1822);
  INSERT INTO city(name, county_id) VALUES ('Rensselaerville', 1790);
  INSERT INTO city(name, county_id) VALUES ('Rhinebeck', 1803);
  INSERT INTO city(name, county_id) VALUES ('Richfield', 1828);
  INSERT INTO city(name, county_id) VALUES ('Richford', 1843);
  INSERT INTO city(name, county_id) VALUES ('Richland', 1827);
  INSERT INTO city(name, county_id) VALUES ('Richmond', 1824);
  INSERT INTO city(name, county_id) VALUES ('Richmondville', 1836);
  INSERT INTO city(name, county_id) VALUES ('Ridgeway', 1826);
  INSERT INTO city(name, county_id) VALUES ('Riga', 1817);
  INSERT INTO city(name, county_id) VALUES ('Ripley', 1796);
  INSERT INTO city(name, county_id) VALUES ('Riverhead', 1841);
  INSERT INTO city(name, county_id) VALUES ('Rockland', 1842);
  INSERT INTO city(name, county_id) VALUES ('Rodman', 1812);
  INSERT INTO city(name, county_id) VALUES ('Romulus', 1838);
  INSERT INTO city(name, county_id) VALUES ('Root', 1818);
  INSERT INTO city(name, county_id) VALUES ('Rose', 1848);
  INSERT INTO city(name, county_id) VALUES ('Roseboom', 1828);
  INSERT INTO city(name, county_id) VALUES ('Rosendale', 1845);
  INSERT INTO city(name, county_id) VALUES ('Rossie', 1839);
  INSERT INTO city(name, county_id) VALUES ('Rotterdam', 1835);
  INSERT INTO city(name, county_id) VALUES ('Roxbury', 1802);
  INSERT INTO city(name, county_id) VALUES ('Royalton', 1821);
  INSERT INTO city(name, county_id) VALUES ('Rush', 1817);
  INSERT INTO city(name, county_id) VALUES ('Rushford', 1791);
  INSERT INTO city(name, county_id) VALUES ('Russell', 1839);
  INSERT INTO city(name, county_id) VALUES ('Russia', 1811);
  INSERT INTO city(name, county_id) VALUES ('Rutland', 1812);
  INSERT INTO city(name, county_id) VALUES ('Rye', 1849);
  INSERT INTO city(name, county_id) VALUES ('Salem', 1847);
  INSERT INTO city(name, county_id) VALUES ('Salina', 1823);
  INSERT INTO city(name, county_id) VALUES ('Sand Lake', 1831);
  INSERT INTO city(name, county_id) VALUES ('Sandy Creek', 1827);
  INSERT INTO city(name, county_id) VALUES ('Sanford', 1793);
  INSERT INTO city(name, county_id) VALUES ('Sangerfield', 1822);
  INSERT INTO city(name, county_id) VALUES ('Santa Clara', 1806);
  INSERT INTO city(name, county_id) VALUES ('Saranac', 1799);
  INSERT INTO city(name, county_id) VALUES ('Saratoga', 1834);
  INSERT INTO city(name, county_id) VALUES ('Sardinia', 1804);
  INSERT INTO city(name, county_id) VALUES ('Saugerties', 1845);
  INSERT INTO city(name, county_id) VALUES ('Savannah', 1848);
  INSERT INTO city(name, county_id) VALUES ('Schaghticoke', 1831);
  INSERT INTO city(name, county_id) VALUES ('Schodack', 1831);
  INSERT INTO city(name, county_id) VALUES ('Schoharie', 1836);
  INSERT INTO city(name, county_id) VALUES ('Schroeppel', 1827);
  INSERT INTO city(name, county_id) VALUES ('Schroon', 1805);
  INSERT INTO city(name, county_id) VALUES ('Schuyler', 1811);
  INSERT INTO city(name, county_id) VALUES ('Schuyler Falls', 1799);
  INSERT INTO city(name, county_id) VALUES ('Scio', 1791);
  INSERT INTO city(name, county_id) VALUES ('Scipio', 1795);
  INSERT INTO city(name, county_id) VALUES ('Scott', 1801);
  INSERT INTO city(name, county_id) VALUES ('Scriba', 1827);
  INSERT INTO city(name, county_id) VALUES ('Sempronius', 1795);
  INSERT INTO city(name, county_id) VALUES ('Seneca', 1824);
  INSERT INTO city(name, county_id) VALUES ('Seneca Falls', 1838);
  INSERT INTO city(name, county_id) VALUES ('Sennett', 1795);
  INSERT INTO city(name, county_id) VALUES ('Seward', 1836);
  INSERT INTO city(name, county_id) VALUES ('Shandaken', 1845);
  INSERT INTO city(name, county_id) VALUES ('Sharon', 1836);
  INSERT INTO city(name, county_id) VALUES ('Shawangunk', 1845);
  INSERT INTO city(name, county_id) VALUES ('Shelby', 1826);
  INSERT INTO city(name, county_id) VALUES ('Sheldon', 1850);
  INSERT INTO city(name, county_id) VALUES ('Shelter Island', 1841);
  INSERT INTO city(name, county_id) VALUES ('Sherburne', 1798);
  INSERT INTO city(name, county_id) VALUES ('Sheridan', 1796);
  INSERT INTO city(name, county_id) VALUES ('Sherman', 1796);
  INSERT INTO city(name, county_id) VALUES ('Sidney', 1802);
  INSERT INTO city(name, county_id) VALUES ('Skaneateles', 1823);
  INSERT INTO city(name, county_id) VALUES ('Smithfield', 1816);
  INSERT INTO city(name, county_id) VALUES ('Smithtown', 1841);
  INSERT INTO city(name, county_id) VALUES ('Smithville', 1798);
  INSERT INTO city(name, county_id) VALUES ('Smyrna', 1798);
  INSERT INTO city(name, county_id) VALUES ('Sodus', 1848);
  INSERT INTO city(name, county_id) VALUES ('Solon', 1801);
  INSERT INTO city(name, county_id) VALUES ('Somers', 1849);
  INSERT INTO city(name, county_id) VALUES ('Somerset', 1821);
  INSERT INTO city(name, county_id) VALUES ('South Bristol', 1824);
  INSERT INTO city(name, county_id) VALUES ('South Valley', 1794);
  INSERT INTO city(name, county_id) VALUES ('Southampton', 1841);
  INSERT INTO city(name, county_id) VALUES ('Southeast', 1829);
  INSERT INTO city(name, county_id) VALUES ('Southold', 1841);
  INSERT INTO city(name, county_id) VALUES ('Southport', 1797);
  INSERT INTO city(name, county_id) VALUES ('Spafford', 1823);
  INSERT INTO city(name, county_id) VALUES ('Sparta', 1815);
  INSERT INTO city(name, county_id) VALUES ('Spencer', 1843);
  INSERT INTO city(name, county_id) VALUES ('Springfield', 1828);
  INSERT INTO city(name, county_id) VALUES ('Springport', 1795);
  INSERT INTO city(name, county_id) VALUES ('Springwater', 1815);
  INSERT INTO city(name, county_id) VALUES ('St. Armand', 1805);
  INSERT INTO city(name, county_id) VALUES ('St. Johnsville', 1818);
  INSERT INTO city(name, county_id) VALUES ('Stafford', 1808);
  INSERT INTO city(name, county_id) VALUES ('Stamford', 1802);
  INSERT INTO city(name, county_id) VALUES ('Stanford', 1803);
  INSERT INTO city(name, county_id) VALUES ('Stark', 1811);
  INSERT INTO city(name, county_id) VALUES ('Starkey', 1851);
  INSERT INTO city(name, county_id) VALUES ('Stephentown', 1831);
  INSERT INTO city(name, county_id) VALUES ('Sterling', 1795);
  INSERT INTO city(name, county_id) VALUES ('Steuben', 1822);
  INSERT INTO city(name, county_id) VALUES ('Stillwater', 1834);
  INSERT INTO city(name, county_id) VALUES ('Stockbridge', 1816);
  INSERT INTO city(name, county_id) VALUES ('Stockholm', 1839);
  INSERT INTO city(name, county_id) VALUES ('Stockport', 1800);
  INSERT INTO city(name, county_id) VALUES ('Stockton', 1796);
  INSERT INTO city(name, county_id) VALUES ('Stony Creek', 1846);
  INSERT INTO city(name, county_id) VALUES ('Stony Point', 1833);
  INSERT INTO city(name, county_id) VALUES ('Stratford', 1807);
  INSERT INTO city(name, county_id) VALUES ('Stuyvesant', 1800);
  INSERT INTO city(name, county_id) VALUES ('Sullivan', 1816);
  INSERT INTO city(name, county_id) VALUES ('Summerhill', 1795);
  INSERT INTO city(name, county_id) VALUES ('Summit', 1836);
  INSERT INTO city(name, county_id) VALUES ('Sweden', 1817);
  INSERT INTO city(name, county_id) VALUES ('Taghkanic', 1800);
  INSERT INTO city(name, county_id) VALUES ('Taylor', 1801);
  INSERT INTO city(name, county_id) VALUES ('Theresa', 1812);
  INSERT INTO city(name, county_id) VALUES ('Thompson', 1842);
  INSERT INTO city(name, county_id) VALUES ('Throop', 1795);
  INSERT INTO city(name, county_id) VALUES ('Thurman', 1846);
  INSERT INTO city(name, county_id) VALUES ('Thurston', 1840);
  INSERT INTO city(name, county_id) VALUES ('Ticonderoga', 1805);
  INSERT INTO city(name, county_id) VALUES ('Tioga', 1843);
  INSERT INTO city(name, county_id) VALUES ('Tompkins', 1802);
  INSERT INTO city(name, county_id) VALUES ('Torrey', 1851);
  INSERT INTO city(name, county_id) VALUES ('Trenton', 1822);
  INSERT INTO city(name, county_id) VALUES ('Triangle', 1793);
  INSERT INTO city(name, county_id) VALUES ('Troupsburg', 1840);
  INSERT INTO city(name, county_id) VALUES ('Truxton', 1801);
  INSERT INTO city(name, county_id) VALUES ('Tully', 1823);
  INSERT INTO city(name, county_id) VALUES ('Tupper Lake', 1806);
  INSERT INTO city(name, county_id) VALUES ('Turin', 1814);
  INSERT INTO city(name, county_id) VALUES ('Tuscarora', 1840);
  INSERT INTO city(name, county_id) VALUES ('Tusten', 1842);
  INSERT INTO city(name, county_id) VALUES ('Tuxedo', 1825);
  INSERT INTO city(name, county_id) VALUES ('Tyre', 1838);
  INSERT INTO city(name, county_id) VALUES ('Tyrone', 1837);
  INSERT INTO city(name, county_id) VALUES ('Ulster', 1845);
  INSERT INTO city(name, county_id) VALUES ('Ulysses', 1844);
  INSERT INTO city(name, county_id) VALUES ('Unadilla', 1828);
  INSERT INTO city(name, county_id) VALUES ('Union', 1793);
  INSERT INTO city(name, county_id) VALUES ('Union Vale', 1803);
  INSERT INTO city(name, county_id) VALUES ('Urbana', 1840);
  INSERT INTO city(name, county_id) VALUES ('Van Buren', 1823);
  INSERT INTO city(name, county_id) VALUES ('Van Etten', 1797);
  INSERT INTO city(name, county_id) VALUES ('Varick', 1838);
  INSERT INTO city(name, county_id) VALUES ('Venice', 1795);
  INSERT INTO city(name, county_id) VALUES ('Vernon', 1822);
  INSERT INTO city(name, county_id) VALUES ('Verona', 1822);
  INSERT INTO city(name, county_id) VALUES ('Vestal', 1793);
  INSERT INTO city(name, county_id) VALUES ('Veteran', 1797);
  INSERT INTO city(name, county_id) VALUES ('Victor', 1824);
  INSERT INTO city(name, county_id) VALUES ('Victory', 1795);
  INSERT INTO city(name, county_id) VALUES ('Vienna', 1822);
  INSERT INTO city(name, county_id) VALUES ('Villenova', 1796);
  INSERT INTO city(name, county_id) VALUES ('Virgil', 1801);
  INSERT INTO city(name, county_id) VALUES ('Volney', 1827);
  INSERT INTO city(name, county_id) VALUES ('Waddington', 1839);
  INSERT INTO city(name, county_id) VALUES ('Wales', 1804);
  INSERT INTO city(name, county_id) VALUES ('Wallkill', 1825);
  INSERT INTO city(name, county_id) VALUES ('Walton', 1802);
  INSERT INTO city(name, county_id) VALUES ('Walworth', 1848);
  INSERT INTO city(name, county_id) VALUES ('Wappinger', 1803);
  INSERT INTO city(name, county_id) VALUES ('Ward', 1791);
  INSERT INTO city(name, county_id) VALUES ('Warren', 1811);
  INSERT INTO city(name, county_id) VALUES ('Warrensburg', 1846);
  INSERT INTO city(name, county_id) VALUES ('Warsaw', 1850);
  INSERT INTO city(name, county_id) VALUES ('Warwick', 1825);
  INSERT INTO city(name, county_id) VALUES ('Washington', 1803);
  INSERT INTO city(name, county_id) VALUES ('Waterford', 1834);
  INSERT INTO city(name, county_id) VALUES ('Waterloo', 1838);
  INSERT INTO city(name, county_id) VALUES ('Watson', 1814);
  INSERT INTO city(name, county_id) VALUES ('Wawarsing', 1845);
  INSERT INTO city(name, county_id) VALUES ('Wawayanda', 1825);
  INSERT INTO city(name, county_id) VALUES ('Wayland', 1840);
  INSERT INTO city(name, county_id) VALUES ('Wayne', 1840);
  INSERT INTO city(name, county_id) VALUES ('Webb', 1811);
  INSERT INTO city(name, county_id) VALUES ('Webster', 1817);
  INSERT INTO city(name, county_id) VALUES ('Wells', 1810);
  INSERT INTO city(name, county_id) VALUES ('Wellsville', 1791);
  INSERT INTO city(name, county_id) VALUES ('West Almond', 1791);
  INSERT INTO city(name, county_id) VALUES ('West Bloomfield', 1824);
  INSERT INTO city(name, county_id) VALUES ('West Monroe', 1827);
  INSERT INTO city(name, county_id) VALUES ('West Seneca', 1804);
  INSERT INTO city(name, county_id) VALUES ('West Sparta', 1815);
  INSERT INTO city(name, county_id) VALUES ('West Turin', 1814);
  INSERT INTO city(name, county_id) VALUES ('West Union', 1840);
  INSERT INTO city(name, county_id) VALUES ('Westerlo', 1790);
  INSERT INTO city(name, county_id) VALUES ('Western', 1822);
  INSERT INTO city(name, county_id) VALUES ('Westfield', 1796);
  INSERT INTO city(name, county_id) VALUES ('Westford', 1828);
  INSERT INTO city(name, county_id) VALUES ('Westmoreland', 1822);
  INSERT INTO city(name, county_id) VALUES ('Westport', 1805);
  INSERT INTO city(name, county_id) VALUES ('Westville', 1806);
  INSERT INTO city(name, county_id) VALUES ('Wethersfield', 1850);
  INSERT INTO city(name, county_id) VALUES ('Wheatfield', 1821);
  INSERT INTO city(name, county_id) VALUES ('Wheatland', 1817);
  INSERT INTO city(name, county_id) VALUES ('Wheeler', 1840);
  INSERT INTO city(name, county_id) VALUES ('White Creek', 1847);
  INSERT INTO city(name, county_id) VALUES ('Whitehall', 1847);
  INSERT INTO city(name, county_id) VALUES ('Whitestown', 1822);
  INSERT INTO city(name, county_id) VALUES ('Willet', 1801);
  INSERT INTO city(name, county_id) VALUES ('Williamson', 1848);
  INSERT INTO city(name, county_id) VALUES ('Williamstown', 1827);
  INSERT INTO city(name, county_id) VALUES ('Willing', 1791);
  INSERT INTO city(name, county_id) VALUES ('Willsboro', 1805);
  INSERT INTO city(name, county_id) VALUES ('Wilmington', 1805);
  INSERT INTO city(name, county_id) VALUES ('Wilna', 1812);
  INSERT INTO city(name, county_id) VALUES ('Wilson', 1821);
  INSERT INTO city(name, county_id) VALUES ('Wilton', 1834);
  INSERT INTO city(name, county_id) VALUES ('Windham', 1809);
  INSERT INTO city(name, county_id) VALUES ('Windsor', 1793);
  INSERT INTO city(name, county_id) VALUES ('Winfield', 1811);
  INSERT INTO city(name, county_id) VALUES ('Wirt', 1791);
  INSERT INTO city(name, county_id) VALUES ('Wolcott', 1848);
  INSERT INTO city(name, county_id) VALUES ('Woodhull', 1840);
  INSERT INTO city(name, county_id) VALUES ('Woodstock', 1845);
  INSERT INTO city(name, county_id) VALUES ('Worcester', 1828);
  INSERT INTO city(name, county_id) VALUES ('Worth', 1812);
  INSERT INTO city(name, county_id) VALUES ('Wright', 1836);
  INSERT INTO city(name, county_id) VALUES ('Yates', 1826);
  INSERT INTO city(name, county_id) VALUES ('York', 1815);
  INSERT INTO city(name, county_id) VALUES ('Yorkshire', 1794);
  INSERT INTO city(name, county_id) VALUES ('Yorktown', 1849);
  
  INSERT INTO city(name, county_id) VALUES ('Fresh Meadows', 1830);
  INSERT INTO city(name, county_id) VALUES ('Browns Summit', 1892);
  INSERT INTO city(name, county_id) VALUES ('West Newton', 1206);
  INSERT INTO city(name, county_id) VALUES ('Newtown Square', 2221);
  
  INSERT INTO city(name, county_id) VALUES ('Bois D''Arc', 2466);
  INSERT INTO city(name, county_id) VALUES ('Cayuga', 2466);
  INSERT INTO city(name, county_id) VALUES ('Montalba', 2466);
  INSERT INTO city(name, county_id) VALUES ('Neches', 2466);
  INSERT INTO city(name, county_id) VALUES ('Slocum', 2466);
  INSERT INTO city(name, county_id) VALUES ('Tennessee Colony', 2466);
  INSERT INTO city(name, county_id) VALUES ('Wild Cat Bluff', 2466);
  INSERT INTO city(name, county_id) VALUES ('Fasken', 2467);
  INSERT INTO city(name, county_id) VALUES ('Shafter Lake', 2467);
  INSERT INTO city(name, county_id) VALUES ('Herty', 2468);
  INSERT INTO city(name, county_id) VALUES ('Homer', 2468);
  INSERT INTO city(name, county_id) VALUES ('Oak Flat', 2468);
  INSERT INTO city(name, county_id) VALUES ('Pollok', 2468);
  INSERT INTO city(name, county_id) VALUES ('Anarene', 2470);
  INSERT INTO city(name, county_id) VALUES ('Huff', 2470);
  INSERT INTO city(name, county_id) VALUES ('Washburn', 2471);
  INSERT INTO city(name, county_id) VALUES ('Goodnight', 2471);
  INSERT INTO city(name, county_id) VALUES ('Wayside', 2471);
  INSERT INTO city(name, county_id) VALUES ('Amphion', 2472);
  INSERT INTO city(name, county_id) VALUES ('Campbellton', 2472);
  INSERT INTO city(name, county_id) VALUES ('Peggy', 2472);
  INSERT INTO city(name, county_id) VALUES ('Mccoy', 2472);
  INSERT INTO city(name, county_id) VALUES ('Bleiblerville', 2473);
  INSERT INTO city(name, county_id) VALUES ('Cat Spring', 2473);
  INSERT INTO city(name, county_id) VALUES ('Kenney', 2473);
  INSERT INTO city(name, county_id) VALUES ('New Ulm', 2473);
  INSERT INTO city(name, county_id) VALUES ('Shelby', 2473);
  INSERT INTO city(name, county_id) VALUES ('Bula', 2474);
  INSERT INTO city(name, county_id) VALUES ('Enochs', 2474);
  INSERT INTO city(name, county_id) VALUES ('Virginia City', 2474);
  INSERT INTO city(name, county_id) VALUES ('Maple', 2474);
  INSERT INTO city(name, county_id) VALUES ('Needmore', 2474);
  INSERT INTO city(name, county_id) VALUES ('Bandera Falls', 2475);
  INSERT INTO city(name, county_id) VALUES ('Pipe Creek', 2475);
  INSERT INTO city(name, county_id) VALUES ('Tarpley', 2475);
  INSERT INTO city(name, county_id) VALUES ('Vanderpool', 2475);
  INSERT INTO city(name, county_id) VALUES ('Alum Creek', 2476);
  INSERT INTO city(name, county_id) VALUES ('Bateman', 2476);
  INSERT INTO city(name, county_id) VALUES ('Butler', 2476);
  INSERT INTO city(name, county_id) VALUES ('Cedar Creek', 2476);
  INSERT INTO city(name, county_id) VALUES ('Colorado', 2476);
  INSERT INTO city(name, county_id) VALUES ('Jeddo', 2476);
  INSERT INTO city(name, county_id) VALUES ('Jorden', 2476);
  INSERT INTO city(name, county_id) VALUES ('Kovar', 2476);
  INSERT INTO city(name, county_id) VALUES ('Paige', 2476);
  INSERT INTO city(name, county_id) VALUES ('Pettytown', 2476);
  INSERT INTO city(name, county_id) VALUES ('Red Rock', 2476);
  INSERT INTO city(name, county_id) VALUES ('Rockne', 2476);
  INSERT INTO city(name, county_id) VALUES ('Rosanky', 2476);
  INSERT INTO city(name, county_id) VALUES ('Togo', 2476);
  INSERT INTO city(name, county_id) VALUES ('Upton', 2476);
  INSERT INTO city(name, county_id) VALUES ('Utley', 2476);
  INSERT INTO city(name, county_id) VALUES ('Mabelle', 2477);
  INSERT INTO city(name, county_id) VALUES ('Red Springs', 2477);
  INSERT INTO city(name, county_id) VALUES ('Mineral', 2478);
  INSERT INTO city(name, county_id) VALUES ('Tulsita', 2478);
  INSERT INTO city(name, county_id) VALUES ('Cyclone', 2479);
  INSERT INTO city(name, county_id) VALUES ('Ding Dong', 2479);
  INSERT INTO city(name, county_id) VALUES ('Heidenheimer', 2479);
  INSERT INTO city(name, county_id) VALUES ('Pendleton', 2479);
  INSERT INTO city(name, county_id) VALUES ('Prairie Dell', 2479);
  INSERT INTO city(name, county_id) VALUES ('White Hall', 2479);
  INSERT INTO city(name, county_id) VALUES ('Adkins', 2480);
  INSERT INTO city(name, county_id) VALUES ('Atascosa', 2480);
  INSERT INTO city(name, county_id) VALUES ('Lackland Air Force Base', 2480);
  INSERT INTO city(name, county_id) VALUES ('Leon Springs', 2480);
  INSERT INTO city(name, county_id) VALUES ('Randolph Air Force Base', 2480);
  INSERT INTO city(name, county_id) VALUES ('Sayers', 2480);
  INSERT INTO city(name, county_id) VALUES ('Wetmore', 2480);
  INSERT INTO city(name, county_id) VALUES ('Hye', 2481);
  INSERT INTO city(name, county_id) VALUES ('Kopperl', 2483);
  INSERT INTO city(name, county_id) VALUES ('Mosheim', 2483);
  INSERT INTO city(name, county_id) VALUES ('Womack', 2483);
  INSERT INTO city(name, county_id) VALUES ('Boston', 2484);
  INSERT INTO city(name, county_id) VALUES ('Dalby Springs', 2484);
  INSERT INTO city(name, county_id) VALUES ('Friendship Village', 2484);
  INSERT INTO city(name, county_id) VALUES ('Malta', 2484);
  INSERT INTO city(name, county_id) VALUES ('Simms', 2484);
  INSERT INTO city(name, county_id) VALUES ('South Texarkana', 2484);
  INSERT INTO city(name, county_id) VALUES ('Friendship', 2484);
  INSERT INTO city(name, county_id) VALUES ('Abercrombie', 2485);
  INSERT INTO city(name, county_id) VALUES ('Amsterdam', 2485);
  INSERT INTO city(name, county_id) VALUES ('Chocolate Bayou', 2485);
  INSERT INTO city(name, county_id) VALUES ('Danciger', 2485);
  INSERT INTO city(name, county_id) VALUES ('Lochridge', 2485);
  INSERT INTO city(name, county_id) VALUES ('Old Ocean', 2485);
  INSERT INTO city(name, county_id) VALUES ('Otey', 2485);
  INSERT INTO city(name, county_id) VALUES ('Turtle Cove', 2485);
  INSERT INTO city(name, county_id) VALUES ('Wellborn', 2486);
  INSERT INTO city(name, county_id) VALUES ('Lajitas', 2487);
  INSERT INTO city(name, county_id) VALUES ('Rachal', 2489);
  INSERT INTO city(name, county_id) VALUES ('Brookesmith', 2490);
  INSERT INTO city(name, county_id) VALUES ('May', 2490);
  INSERT INTO city(name, county_id) VALUES ('Winchell', 2490);
  INSERT INTO city(name, county_id) VALUES ('Zephyr', 2490);
  INSERT INTO city(name, county_id) VALUES ('Birch', 2491);
  INSERT INTO city(name, county_id) VALUES ('Chriesman', 2491);
  INSERT INTO city(name, county_id) VALUES ('Clay', 2491);
  INSERT INTO city(name, county_id) VALUES ('Cooks Point', 2491);
  INSERT INTO city(name, county_id) VALUES ('Davidson', 2491);
  INSERT INTO city(name, county_id) VALUES ('Deanville', 2491);
  INSERT INTO city(name, county_id) VALUES ('Frenstat', 2491);
  INSERT INTO city(name, county_id) VALUES ('Goodwill', 2491);
  INSERT INTO city(name, county_id) VALUES ('Gus', 2491);
  INSERT INTO city(name, county_id) VALUES ('Harmony', 2491);
  INSERT INTO city(name, county_id) VALUES ('Hix', 2491);
  INSERT INTO city(name, county_id) VALUES ('Hogg', 2491);
  INSERT INTO city(name, county_id) VALUES ('Lyons', 2491);
  INSERT INTO city(name, county_id) VALUES ('Merle', 2491);
  INSERT INTO city(name, county_id) VALUES ('Rita', 2491);
  INSERT INTO city(name, county_id) VALUES ('Scofield', 2491);
  INSERT INTO city(name, county_id) VALUES ('Tunis', 2491);
  INSERT INTO city(name, county_id) VALUES ('Wilcox', 2491);
  INSERT INTO city(name, county_id) VALUES ('Briggs', 2492);
  INSERT INTO city(name, county_id) VALUES ('Lake Victor', 2492);
  INSERT INTO city(name, county_id) VALUES ('Oakalla', 2492);
  INSERT INTO city(name, county_id) VALUES ('Oatmeal', 2492);
  INSERT INTO city(name, county_id) VALUES ('Smithwick', 2492);
  INSERT INTO city(name, county_id) VALUES ('Spicewood', 2492);
  INSERT INTO city(name, county_id) VALUES ('Dale', 2493);
  INSERT INTO city(name, county_id) VALUES ('Fentress', 2493);
  INSERT INTO city(name, county_id) VALUES ('Lytton Springs', 2493);
  INSERT INTO city(name, county_id) VALUES ('Maxwell', 2493);
  INSERT INTO city(name, county_id) VALUES ('Prairie Lea', 2493);
  INSERT INTO city(name, county_id) VALUES ('Saint Johns Colony', 2493);
  INSERT INTO city(name, county_id) VALUES ('Seawillow', 2493);
  INSERT INTO city(name, county_id) VALUES ('Stairtown', 2493);
  INSERT INTO city(name, county_id) VALUES ('Alamo Beach', 2494);
  INSERT INTO city(name, county_id) VALUES ('Indianola', 2494);
  INSERT INTO city(name, county_id) VALUES ('Long Mott', 2494);
  INSERT INTO city(name, county_id) VALUES ('Magnolia Beach', 2494);
  INSERT INTO city(name, county_id) VALUES ('Belle Plain', 2495);
  INSERT INTO city(name, county_id) VALUES ('Callahan City', 2495);
  INSERT INTO city(name, county_id) VALUES ('Eula', 2495);
  INSERT INTO city(name, county_id) VALUES ('Arroyo Alto', 2496);
  INSERT INTO city(name, county_id) VALUES ('Encantada-Ranchito El Calaboz', 2496);
  INSERT INTO city(name, county_id) VALUES ('Grand Acres', 2496);
  INSERT INTO city(name, county_id) VALUES ('Leesburg', 2497);
  INSERT INTO city(name, county_id) VALUES ('Bivins', 2499);
  INSERT INTO city(name, county_id) VALUES ('Kildare', 2499);
  INSERT INTO city(name, county_id) VALUES ('Mcleod', 2499);
  INSERT INTO city(name, county_id) VALUES ('Hilburn', 2500);
  INSERT INTO city(name, county_id) VALUES ('Summerfield', 2500);
  INSERT INTO city(name, county_id) VALUES ('Sunnyside', 2500);
  INSERT INTO city(name, county_id) VALUES ('Double Bayou', 2501);
  INSERT INTO city(name, county_id) VALUES ('Hankamer', 2501);
  INSERT INTO city(name, county_id) VALUES ('Monroe City', 2501);
  INSERT INTO city(name, county_id) VALUES ('Seabreeze', 2501);
  INSERT INTO city(name, county_id) VALUES ('Smith Point', 2501);
  INSERT INTO city(name, county_id) VALUES ('Turtle Bayou', 2501);
  INSERT INTO city(name, county_id) VALUES ('Wallisville', 2501);
  INSERT INTO city(name, county_id) VALUES ('Blackjack', 2502);
  INSERT INTO city(name, county_id) VALUES ('Dialville', 2502);
  INSERT INTO city(name, county_id) VALUES ('Etna', 2502);
  INSERT INTO city(name, county_id) VALUES ('Forest', 2502);
  INSERT INTO city(name, county_id) VALUES ('Maydelle', 2502);
  INSERT INTO city(name, county_id) VALUES ('Mount Selman', 2502);
  INSERT INTO city(name, county_id) VALUES ('Reese', 2502);
  INSERT INTO city(name, county_id) VALUES ('Concord', 2502);
  INSERT INTO city(name, county_id) VALUES ('Carey', 2503);
  INSERT INTO city(name, county_id) VALUES ('Tell', 2503);
  INSERT INTO city(name, county_id) VALUES ('Bluegrove', 2504);
  INSERT INTO city(name, county_id) VALUES ('Charlie', 2504);
  INSERT INTO city(name, county_id) VALUES ('Halsell', 2504);
  INSERT INTO city(name, county_id) VALUES ('Hurnville', 2504);
  INSERT INTO city(name, county_id) VALUES ('Joy', 2504);
  INSERT INTO city(name, county_id) VALUES ('Shannon', 2504);
  INSERT INTO city(name, county_id) VALUES ('Stanfield', 2504);
  INSERT INTO city(name, county_id) VALUES ('Thornberry', 2504);
  INSERT INTO city(name, county_id) VALUES ('Vashti', 2504);
  INSERT INTO city(name, county_id) VALUES ('Bledsoe', 2505);
  INSERT INTO city(name, county_id) VALUES ('Sanco', 2506);
  INSERT INTO city(name, county_id) VALUES ('Silver', 2506);
  INSERT INTO city(name, county_id) VALUES ('Tennyson', 2506);
  INSERT INTO city(name, county_id) VALUES ('Burkett', 2507);
  INSERT INTO city(name, county_id) VALUES ('Goldsboro', 2507);
  INSERT INTO city(name, county_id) VALUES ('Gouldbusk', 2507);
  INSERT INTO city(name, county_id) VALUES ('Leaday', 2507);
  INSERT INTO city(name, county_id) VALUES ('Rockwood', 2507);
  INSERT INTO city(name, county_id) VALUES ('Talpa', 2507);
  INSERT INTO city(name, county_id) VALUES ('Valera', 2507);
  INSERT INTO city(name, county_id) VALUES ('Voss', 2507);
  INSERT INTO city(name, county_id) VALUES ('Whon', 2507);
  INSERT INTO city(name, county_id) VALUES ('Altoga', 2508);
  INSERT INTO city(name, county_id) VALUES ('Branch', 2508);
  INSERT INTO city(name, county_id) VALUES ('Copeville', 2508);
  INSERT INTO city(name, county_id) VALUES ('Culleoka', 2508);
  INSERT INTO city(name, county_id) VALUES ('Desert', 2508);
  INSERT INTO city(name, county_id) VALUES ('Frognot', 2508);
  INSERT INTO city(name, county_id) VALUES ('Pike', 2508);
  INSERT INTO city(name, county_id) VALUES ('Dozier', 2509);
  INSERT INTO city(name, county_id) VALUES ('Alleyton', 2510);
  INSERT INTO city(name, county_id) VALUES ('Altair', 2510);
  INSERT INTO city(name, county_id) VALUES ('Frelsburg', 2510);
  INSERT INTO city(name, county_id) VALUES ('Garwood', 2510);
  INSERT INTO city(name, county_id) VALUES ('Nada', 2510);
  INSERT INTO city(name, county_id) VALUES ('Oakland', 2510);
  INSERT INTO city(name, county_id) VALUES ('Rock Island', 2510);
  INSERT INTO city(name, county_id) VALUES ('Sheridan', 2510);
  INSERT INTO city(name, county_id) VALUES ('Bracken', 2511);
  INSERT INTO city(name, county_id) VALUES ('Canyon City', 2511);
  INSERT INTO city(name, county_id) VALUES ('Fischer', 2511);
  INSERT INTO city(name, county_id) VALUES ('Sattler', 2511);
  INSERT INTO city(name, county_id) VALUES ('Startzville', 2511);
  INSERT INTO city(name, county_id) VALUES ('Duster', 2512);
  INSERT INTO city(name, county_id) VALUES ('Energy', 2512);
  INSERT INTO city(name, county_id) VALUES ('Hasse', 2512);
  INSERT INTO city(name, county_id) VALUES ('Proctor', 2512);
  INSERT INTO city(name, county_id) VALUES ('Rucker', 2512);
  INSERT INTO city(name, county_id) VALUES ('Sidney', 2512);
  INSERT INTO city(name, county_id) VALUES ('Eola', 2513);
  INSERT INTO city(name, county_id) VALUES ('Lowake', 2513);
  INSERT INTO city(name, county_id) VALUES ('Millersview', 2513);
  INSERT INTO city(name, county_id) VALUES ('Vick', 2513);
  INSERT INTO city(name, county_id) VALUES ('Bulcher', 2514);
  INSERT INTO city(name, county_id) VALUES ('Era', 2514);
  INSERT INTO city(name, county_id) VALUES ('Marysville', 2514);
  INSERT INTO city(name, county_id) VALUES ('Myra', 2514);
  INSERT INTO city(name, county_id) VALUES ('Rosston', 2514);
  INSERT INTO city(name, county_id) VALUES ('Sivells Bend', 2514);
  INSERT INTO city(name, county_id) VALUES ('Bee House', 2515);
  INSERT INTO city(name, county_id) VALUES ('Flat', 2515);
  INSERT INTO city(name, county_id) VALUES ('Fort Gates', 2515);
  INSERT INTO city(name, county_id) VALUES ('Jonesboro', 2515);
  INSERT INTO city(name, county_id) VALUES ('Leon Junction', 2515);
  INSERT INTO city(name, county_id) VALUES ('Mound', 2515);
  INSERT INTO city(name, county_id) VALUES ('Purmela', 2515);
  INSERT INTO city(name, county_id) VALUES ('Cee Vee', 2516);
  INSERT INTO city(name, county_id) VALUES ('Narcisso', 2516);
  INSERT INTO city(name, county_id) VALUES ('Tubbs Corner', 2517);
  INSERT INTO city(name, county_id) VALUES ('Emerald', 2518);
  INSERT INTO city(name, county_id) VALUES ('Cone', 2519);
  INSERT INTO city(name, county_id) VALUES ('Kalgary', 2519);
  INSERT INTO city(name, county_id) VALUES ('Kent', 2520);
  INSERT INTO city(name, county_id) VALUES ('Kerrick', 2521);
  INSERT INTO city(name, county_id) VALUES ('Perico', 2521);
  INSERT INTO city(name, county_id) VALUES ('Sand Branch', 2522);
  INSERT INTO city(name, county_id) VALUES ('Patricia', 2523);
  INSERT INTO city(name, county_id) VALUES ('Klondike', 2523);
  INSERT INTO city(name, county_id) VALUES ('Bootleg', 2525);
  INSERT INTO city(name, county_id) VALUES ('Dawn', 2525);
  INSERT INTO city(name, county_id) VALUES ('Glenrio', 2525);
  INSERT INTO city(name, county_id) VALUES ('New Mexico', 2525);
  INSERT INTO city(name, county_id) VALUES ('Antioch', 2526);
  INSERT INTO city(name, county_id) VALUES ('Ben Franklin', 2526);
  INSERT INTO city(name, county_id) VALUES ('Charleston', 2526);
  INSERT INTO city(name, county_id) VALUES ('Enloe', 2526);
  INSERT INTO city(name, county_id) VALUES ('Lake Creek', 2526);
  INSERT INTO city(name, county_id) VALUES ('Bolivar', 2527);
  INSERT INTO city(name, county_id) VALUES ('Elizabethtown', 2527);
  INSERT INTO city(name, county_id) VALUES ('Navo', 2527);
  INSERT INTO city(name, county_id) VALUES ('Hochheim', 2524);
  INSERT INTO city(name, county_id) VALUES ('Meyersville', 2524);
  INSERT INTO city(name, county_id) VALUES ('Pearl City', 2524);
  INSERT INTO city(name, county_id) VALUES ('Thomaston', 2524);
  INSERT INTO city(name, county_id) VALUES ('Westhoff', 2524);
  INSERT INTO city(name, county_id) VALUES ('Afton', 2528);
  INSERT INTO city(name, county_id) VALUES ('Mcadoo', 2528);
  INSERT INTO city(name, county_id) VALUES ('Brundage', 2529);
  INSERT INTO city(name, county_id) VALUES ('Lelia Lake', 2530);
  INSERT INTO city(name, county_id) VALUES ('Ramirez', 2531);
  INSERT INTO city(name, county_id) VALUES ('Rios', 2531);
  INSERT INTO city(name, county_id) VALUES ('Sejita', 2531);
  INSERT INTO city(name, county_id) VALUES ('Desdemona', 2532);
  INSERT INTO city(name, county_id) VALUES ('Mangum', 2532);
  INSERT INTO city(name, county_id) VALUES ('Morton Valley', 2532);
  INSERT INTO city(name, county_id) VALUES ('Okra', 2532);
  INSERT INTO city(name, county_id) VALUES ('Olden', 2532);
  INSERT INTO city(name, county_id) VALUES ('Romney', 2532);
  INSERT INTO city(name, county_id) VALUES ('Notrees', 2533);
  INSERT INTO city(name, county_id) VALUES ('Penwell', 2533);
  INSERT INTO city(name, county_id) VALUES ('Pleasant Farms', 2533);
  INSERT INTO city(name, county_id) VALUES ('Barksdale', 2534);
  INSERT INTO city(name, county_id) VALUES ('Carta Valley', 2534);
  INSERT INTO city(name, county_id) VALUES ('Montana Vista', 2535);
  INSERT INTO city(name, county_id) VALUES ('Newman', 2535);
  INSERT INTO city(name, county_id) VALUES ('Avalon', 2536);
  INSERT INTO city(name, county_id) VALUES ('Forreston', 2536);
  INSERT INTO city(name, county_id) VALUES ('Ike', 2536);
  INSERT INTO city(name, county_id) VALUES ('Rockett', 2536);
  INSERT INTO city(name, county_id) VALUES ('Telico', 2536);
  INSERT INTO city(name, county_id) VALUES ('Bluff Dale', 2537);
  INSERT INTO city(name, county_id) VALUES ('Huckabay', 2537);
  INSERT INTO city(name, county_id) VALUES ('Lingleville', 2537);
  INSERT INTO city(name, county_id) VALUES ('Morgan Mill', 2537);
  INSERT INTO city(name, county_id) VALUES ('Thurber', 2537);
  INSERT INTO city(name, county_id) VALUES ('Barclay', 2538);
  INSERT INTO city(name, county_id) VALUES ('Cedar Springs', 2538);
  INSERT INTO city(name, county_id) VALUES ('Cego', 2538);
  INSERT INTO city(name, county_id) VALUES ('Durango', 2538);
  INSERT INTO city(name, county_id) VALUES ('Highbank', 2538);
  INSERT INTO city(name, county_id) VALUES ('Otto', 2538);
  INSERT INTO city(name, county_id) VALUES ('Perry', 2538);
  INSERT INTO city(name, county_id) VALUES ('Reagan', 2538);
  INSERT INTO city(name, county_id) VALUES ('Satin', 2538);
  INSERT INTO city(name, county_id) VALUES ('Tomlinson Hill', 2538);
  INSERT INTO city(name, county_id) VALUES ('Westphalia', 2538);
  INSERT INTO city(name, county_id) VALUES ('Wilderville', 2538);
  INSERT INTO city(name, county_id) VALUES ('Zipperlandville', 2538);
  INSERT INTO city(name, county_id) VALUES ('Gober', 2539);
  INSERT INTO city(name, county_id) VALUES ('Randolph', 2539);
  INSERT INTO city(name, county_id) VALUES ('Telephone', 2539);
  INSERT INTO city(name, county_id) VALUES ('Elwood', 2539);
  INSERT INTO city(name, county_id) VALUES ('Ammannsville', 2540);
  INSERT INTO city(name, county_id) VALUES ('Black Jack Springs', 2540);
  INSERT INTO city(name, county_id) VALUES ('Bluff', 2540);
  INSERT INTO city(name, county_id) VALUES ('Cistern', 2540);
  INSERT INTO city(name, county_id) VALUES ('Dubina', 2540);
  INSERT INTO city(name, county_id) VALUES ('Ellinger', 2540);
  INSERT INTO city(name, county_id) VALUES ('Engle', 2540);
  INSERT INTO city(name, county_id) VALUES ('Freyburg', 2540);
  INSERT INTO city(name, county_id) VALUES ('High Hill', 2540);
  INSERT INTO city(name, county_id) VALUES ('Holman', 2540);
  INSERT INTO city(name, county_id) VALUES ('Hostyn', 2540);
  INSERT INTO city(name, county_id) VALUES ('Kirtley', 2540);
  INSERT INTO city(name, county_id) VALUES ('Ledbetter', 2540);
  INSERT INTO city(name, county_id) VALUES ('Muldoon', 2540);
  INSERT INTO city(name, county_id) VALUES ('Mullins Prairie', 2540);
  INSERT INTO city(name, county_id) VALUES ('Nechanitz', 2540);
  INSERT INTO city(name, county_id) VALUES ('Oldenburg', 2540);
  INSERT INTO city(name, county_id) VALUES ('O''Quinn', 2540);
  INSERT INTO city(name, county_id) VALUES ('Park', 2540);
  INSERT INTO city(name, county_id) VALUES ('Plum', 2540);
  INSERT INTO city(name, county_id) VALUES ('Praha', 2540);
  INSERT INTO city(name, county_id) VALUES ('Rabbs Prairie', 2540);
  INSERT INTO city(name, county_id) VALUES ('Rek Hill', 2540);
  INSERT INTO city(name, county_id) VALUES ('Roznov', 2540);
  INSERT INTO city(name, county_id) VALUES ('Rutersville', 2540);
  INSERT INTO city(name, county_id) VALUES ('St. John', 2540);
  INSERT INTO city(name, county_id) VALUES ('Swiss Alp', 2540);
  INSERT INTO city(name, county_id) VALUES ('Waldeck', 2540);
  INSERT INTO city(name, county_id) VALUES ('Walhalla', 2540);
  INSERT INTO city(name, county_id) VALUES ('Warda', 2540);
  INSERT INTO city(name, county_id) VALUES ('Warrenton', 2540);
  INSERT INTO city(name, county_id) VALUES ('West Point', 2540);
  INSERT INTO city(name, county_id) VALUES ('Mccaulley', 2541);
  INSERT INTO city(name, county_id) VALUES ('Sylvester', 2541);
  INSERT INTO city(name, county_id) VALUES ('South Plains', 2542);
  INSERT INTO city(name, county_id) VALUES ('Dougherty', 2542);
  INSERT INTO city(name, county_id) VALUES ('Aiken', 2542);
  INSERT INTO city(name, county_id) VALUES ('Thalia', 2543);
  INSERT INTO city(name, county_id) VALUES ('Booth', 2544);
  INSERT INTO city(name, county_id) VALUES ('Clodine', 2544);
  INSERT INTO city(name, county_id) VALUES ('Dewalt', 2544);
  INSERT INTO city(name, county_id) VALUES ('Foster', 2544);
  INSERT INTO city(name, county_id) VALUES ('Greatwood', 2544);
  INSERT INTO city(name, county_id) VALUES ('Guy', 2544);
  INSERT INTO city(name, county_id) VALUES ('Long Point', 2544);
  INSERT INTO city(name, county_id) VALUES ('New Territory', 2544);
  INSERT INTO city(name, county_id) VALUES ('Pittsville', 2544);
  INSERT INTO city(name, county_id) VALUES ('Powell Point', 2544);
  INSERT INTO city(name, county_id) VALUES ('Tavener', 2544);
  INSERT INTO city(name, county_id) VALUES ('Scroggins', 2545);
  INSERT INTO city(name, county_id) VALUES ('Coutchman', 2546);
  INSERT INTO city(name, county_id) VALUES ('Dew', 2546);
  INSERT INTO city(name, county_id) VALUES ('Donie', 2546);
  INSERT INTO city(name, county_id) VALUES ('Frio Town', 2547);
  INSERT INTO city(name, county_id) VALUES ('Algoa', 2549);
  INSERT INTO city(name, county_id) VALUES ('Alta Loma', 2549);
  INSERT INTO city(name, county_id) VALUES ('Caplen', 2549);
  INSERT INTO city(name, county_id) VALUES ('Gilchrist', 2549);
  INSERT INTO city(name, county_id) VALUES ('High Island', 2549);
  INSERT INTO city(name, county_id) VALUES ('Arcadia', 2549);
  INSERT INTO city(name, county_id) VALUES ('Close City', 2550);
  INSERT INTO city(name, county_id) VALUES ('Justiceburg', 2550);
  INSERT INTO city(name, county_id) VALUES ('Southland', 2550);
  INSERT INTO city(name, county_id) VALUES ('Albert', 2551);
  INSERT INTO city(name, county_id) VALUES ('Doss', 2551);
  INSERT INTO city(name, county_id) VALUES ('Luckenbach Stonewall', 2551);
  INSERT INTO city(name, county_id) VALUES ('Saint Lawrence', 2552);
  INSERT INTO city(name, county_id) VALUES ('Berclair', 2553);
  INSERT INTO city(name, county_id) VALUES ('Fannin', 2553);
  INSERT INTO city(name, county_id) VALUES ('Weesatche', 2553);
  INSERT INTO city(name, county_id) VALUES ('Bebe', 2554);
  INSERT INTO city(name, county_id) VALUES ('Belmont', 2554);
  INSERT INTO city(name, county_id) VALUES ('Cost', 2554);
  INSERT INTO city(name, county_id) VALUES ('Harwood', 2554);
  INSERT INTO city(name, county_id) VALUES ('Leesville', 2554);
  INSERT INTO city(name, county_id) VALUES ('Ottine', 2554);
  INSERT INTO city(name, county_id) VALUES ('Wrightsboro', 2554);
  INSERT INTO city(name, county_id) VALUES ('Alanreed', 2555);
  INSERT INTO city(name, county_id) VALUES ('Ambrose', 2556);
  INSERT INTO city(name, county_id) VALUES ('Bugtussle', 2556);
  INSERT INTO city(name, county_id) VALUES ('Gordonville', 2556);
  INSERT INTO city(name, county_id) VALUES ('Luella', 2556);
  INSERT INTO city(name, county_id) VALUES ('Elderville', 2557);
  INSERT INTO city(name, county_id) VALUES ('Judson', 2557);
  INSERT INTO city(name, county_id) VALUES ('Shiloh', 2557);
  INSERT INTO city(name, county_id) VALUES ('Courtney', 2558);
  INSERT INTO city(name, county_id) VALUES ('Richards', 2558);
  INSERT INTO city(name, county_id) VALUES ('Roans Prairie', 2558);
  INSERT INTO city(name, county_id) VALUES ('Shiro', 2558);
  INSERT INTO city(name, county_id) VALUES ('Singleton', 2558);
  INSERT INTO city(name, county_id) VALUES ('Stoneham', 2558);
  INSERT INTO city(name, county_id) VALUES ('Northcliff', 2559);
  INSERT INTO city(name, county_id) VALUES ('Sweet Home', 2559);
  INSERT INTO city(name, county_id) VALUES ('Cotton Center', 2560);
  INSERT INTO city(name, county_id) VALUES ('Carlton', 2562);
  INSERT INTO city(name, county_id) VALUES ('Fairy', 2562);
  INSERT INTO city(name, county_id) VALUES ('Mcgirk', 2562);
  INSERT INTO city(name, county_id) VALUES ('Pottsville', 2562);
  INSERT INTO city(name, county_id) VALUES ('Batson', 2565);
  INSERT INTO city(name, county_id) VALUES ('Bragg', 2565);
  INSERT INTO city(name, county_id) VALUES ('Honey Island', 2565);
  INSERT INTO city(name, county_id) VALUES ('Saratoga', 2565);
  INSERT INTO city(name, county_id) VALUES ('Thicket', 2565);
  INSERT INTO city(name, county_id) VALUES ('Village Mills', 2565);
  INSERT INTO city(name, county_id) VALUES ('Votaw', 2565);
  INSERT INTO city(name, county_id) VALUES ('Bammel', 2566);
  INSERT INTO city(name, county_id) VALUES ('Barker', 2566);
  INSERT INTO city(name, county_id) VALUES ('Beaumont Place', 2566);
  INSERT INTO city(name, county_id) VALUES ('Bridgeland Community', 2566);
  INSERT INTO city(name, county_id) VALUES ('Cedar Bayou', 2566);
  INSERT INTO city(name, county_id) VALUES ('Champion Forest', 2566);
  INSERT INTO city(name, county_id) VALUES ('Cypress', 2566);
  INSERT INTO city(name, county_id) VALUES ('Dyersdale', 2566);
  INSERT INTO city(name, county_id) VALUES ('Hockley', 2566);
  INSERT INTO city(name, county_id) VALUES ('Houmont Park', 2566);
  INSERT INTO city(name, county_id) VALUES ('Hufsmith', 2566);
  INSERT INTO city(name, county_id) VALUES ('Kinwood', 2566);
  INSERT INTO city(name, county_id) VALUES ('Klein', 2566);
  INSERT INTO city(name, county_id) VALUES ('Kleinbrook', 2566);
  INSERT INTO city(name, county_id) VALUES ('Kohrville', 2566);
  INSERT INTO city(name, county_id) VALUES ('Louetta', 2566);
  INSERT INTO city(name, county_id) VALUES ('Lynchburg', 2566);
  INSERT INTO city(name, county_id) VALUES ('Mcnair', 2566);
  INSERT INTO city(name, county_id) VALUES ('North Houston', 2566);
  INSERT INTO city(name, county_id) VALUES ('Northcliffe', 2566);
  INSERT INTO city(name, county_id) VALUES ('Northcliffe Manor', 2566);
  INSERT INTO city(name, county_id) VALUES ('Remington Ranch', 2566);
  INSERT INTO city(name, county_id) VALUES ('Satsuma', 2566);
  INSERT INTO city(name, county_id) VALUES ('Timber Meadows', 2566);
  INSERT INTO city(name, county_id) VALUES ('Traces', 2566);
  INSERT INTO city(name, county_id) VALUES ('Westfield', 2566);
  INSERT INTO city(name, county_id) VALUES ('Rose Hill', 2566);
  INSERT INTO city(name, county_id) VALUES ('Elysian Fields', 2567);
  INSERT INTO city(name, county_id) VALUES ('Gill', 2567);
  INSERT INTO city(name, county_id) VALUES ('Harleton', 2567);
  INSERT INTO city(name, county_id) VALUES ('Jonesville', 2567);
  INSERT INTO city(name, county_id) VALUES ('Karnack', 2567);
  INSERT INTO city(name, county_id) VALUES ('Woodlawn', 2567);
  INSERT INTO city(name, county_id) VALUES ('Paint Creek', 2569);
  INSERT INTO city(name, county_id) VALUES ('Sagerton', 2569);
  INSERT INTO city(name, county_id) VALUES ('Goforth', 2570);
  INSERT INTO city(name, county_id) VALUES ('Glazier', 2571);
  INSERT INTO city(name, county_id) VALUES ('Larue', 2572);
  INSERT INTO city(name, county_id) VALUES ('Latex', 2572);
  INSERT INTO city(name, county_id) VALUES ('New York', 2572);
  INSERT INTO city(name, county_id) VALUES ('Alton North', 2573);
  INSERT INTO city(name, county_id) VALUES ('Cuevitas', 2573);
  INSERT INTO city(name, county_id) VALUES ('El Gato', 2573);
  INSERT INTO city(name, county_id) VALUES ('Faysville', 2573);
  INSERT INTO city(name, county_id) VALUES ('Runn', 2573);
  INSERT INTO city(name, county_id) VALUES ('Birome', 2574);
  INSERT INTO city(name, county_id) VALUES ('Brandon', 2574);
  INSERT INTO city(name, county_id) VALUES ('Irene', 2574);
  INSERT INTO city(name, county_id) VALUES ('Pep', 2575);
  INSERT INTO city(name, county_id) VALUES ('Whitharral', 2575);
  INSERT INTO city(name, county_id) VALUES ('Acton', 2576);
  INSERT INTO city(name, county_id) VALUES ('Paluxy', 2576);
  INSERT INTO city(name, county_id) VALUES ('Brashear', 2577);
  INSERT INTO city(name, county_id) VALUES ('Dike', 2577);
  INSERT INTO city(name, county_id) VALUES ('Gafford', 2577);
  INSERT INTO city(name, county_id) VALUES ('Pickton', 2577);
  INSERT INTO city(name, county_id) VALUES ('Saltillo', 2577);
  INSERT INTO city(name, county_id) VALUES ('Sulphur Bluff', 2577);
  INSERT INTO city(name, county_id) VALUES ('Who''D Thought It', 2577);
  INSERT INTO city(name, county_id) VALUES ('Austonio', 2578);
  INSERT INTO city(name, county_id) VALUES ('Pennington', 2578);
  INSERT INTO city(name, county_id) VALUES ('Ratcliff', 2578);
  INSERT INTO city(name, county_id) VALUES ('Elbow', 2579);
  INSERT INTO city(name, county_id) VALUES ('Knott', 2579);
  INSERT INTO city(name, county_id) VALUES ('Vealmoor', 2579);
  INSERT INTO city(name, county_id) VALUES ('Acala', 2580);
  INSERT INTO city(name, county_id) VALUES ('Allamoore', 2580);
  INSERT INTO city(name, county_id) VALUES ('Salt Flat', 2580);
  INSERT INTO city(name, county_id) VALUES ('Cash', 2581);
  INSERT INTO city(name, county_id) VALUES ('Clinton', 2581);
  INSERT INTO city(name, county_id) VALUES ('Fairlie', 2581);
  INSERT INTO city(name, county_id) VALUES ('Floyd', 2581);
  INSERT INTO city(name, county_id) VALUES ('Hogeye', 2581);
  INSERT INTO city(name, county_id) VALUES ('Jacobia', 2581);
  INSERT INTO city(name, county_id) VALUES ('Kingston', 2581);
  INSERT INTO city(name, county_id) VALUES ('Merit', 2581);
  INSERT INTO city(name, county_id) VALUES ('Wagner', 2581);
  INSERT INTO city(name, county_id) VALUES ('Wieland', 2581);
  INSERT INTO city(name, county_id) VALUES ('Adobe Walls', 2582);
  INSERT INTO city(name, county_id) VALUES ('Phillips', 2582);
  INSERT INTO city(name, county_id) VALUES ('Plemons', 2582);
  INSERT INTO city(name, county_id) VALUES ('Pringle', 2582);
  INSERT INTO city(name, county_id) VALUES ('Whittenburg', 2582);
  INSERT INTO city(name, county_id) VALUES ('Arden', 2583);
  INSERT INTO city(name, county_id) VALUES ('Barnhart', 2583);
  INSERT INTO city(name, county_id) VALUES ('Sherwood', 2583);
  INSERT INTO city(name, county_id) VALUES ('Antelope', 2584);
  INSERT INTO city(name, county_id) VALUES ('Jermyn', 2584);
  INSERT INTO city(name, county_id) VALUES ('Joplin', 2584);
  INSERT INTO city(name, county_id) VALUES ('Francitas', 2585);
  INSERT INTO city(name, county_id) VALUES ('La Salle', 2585);
  INSERT INTO city(name, county_id) VALUES ('Beans', 2586);
  INSERT INTO city(name, county_id) VALUES ('Bessmay', 2586);
  INSERT INTO city(name, county_id) VALUES ('Bon Ami', 2586);
  INSERT INTO city(name, county_id) VALUES ('Brookeland', 2586);
  INSERT INTO city(name, county_id) VALUES ('Ebenezer', 2586);
  INSERT INTO city(name, county_id) VALUES ('Erin', 2586);
  INSERT INTO city(name, county_id) VALUES ('Magnolia Springs', 2586);
  INSERT INTO city(name, county_id) VALUES ('Roganville', 2586);
  INSERT INTO city(name, county_id) VALUES ('Zeirath', 2586);
  INSERT INTO city(name, county_id) VALUES ('Hamshire', 2588);
  INSERT INTO city(name, county_id) VALUES ('Labelle', 2588);
  INSERT INTO city(name, county_id) VALUES ('Sabine Pass', 2588);
  INSERT INTO city(name, county_id) VALUES ('Agua Nueva', 2589);
  INSERT INTO city(name, county_id) VALUES ('Guerra', 2589);
  INSERT INTO city(name, county_id) VALUES ('Randado', 2589);
  INSERT INTO city(name, county_id) VALUES ('Ben Bolt', 2590);
  INSERT INTO city(name, county_id) VALUES ('Bentonville', 2590);
  INSERT INTO city(name, county_id) VALUES ('Palito Blanco', 2590);
  INSERT INTO city(name, county_id) VALUES ('Rancho De La Parita', 2590);
  INSERT INTO city(name, county_id) VALUES ('Casa Blanca', 2590);
  INSERT INTO city(name, county_id) VALUES ('La Gloria', 2590);
  INSERT INTO city(name, county_id) VALUES ('Lillian', 2591);
  INSERT INTO city(name, county_id) VALUES ('Avoca', 2592);
  INSERT INTO city(name, county_id) VALUES ('Noodle', 2592);
  INSERT INTO city(name, county_id) VALUES ('Nugent', 2592);
  INSERT INTO city(name, county_id) VALUES ('Radium', 2592);
  INSERT INTO city(name, county_id) VALUES ('Tuxedo', 2592);
  INSERT INTO city(name, county_id) VALUES ('Cestohowa', 2593);
  INSERT INTO city(name, county_id) VALUES ('Ecleto', 2593);
  INSERT INTO city(name, county_id) VALUES ('Gillett', 2593);
  INSERT INTO city(name, county_id) VALUES ('Helena', 2593);
  INSERT INTO city(name, county_id) VALUES ('Hobson', 2593);
  INSERT INTO city(name, county_id) VALUES ('Panna Maria', 2593);
  INSERT INTO city(name, county_id) VALUES ('Wintergreen', 2593);
  INSERT INTO city(name, county_id) VALUES ('Ables Springs', 2594);
  INSERT INTO city(name, county_id) VALUES ('Poetry', 2594);
  INSERT INTO city(name, county_id) VALUES ('Bergheim', 2595);
  INSERT INTO city(name, county_id) VALUES ('Kendalia', 2595);
  INSERT INTO city(name, county_id) VALUES ('Sisterdale', 2595);
  INSERT INTO city(name, county_id) VALUES ('Waring', 2595);
  INSERT INTO city(name, county_id) VALUES ('Armstrong', 2596);
  INSERT INTO city(name, county_id) VALUES ('Clairemont', 2597);
  INSERT INTO city(name, county_id) VALUES ('Camp Verde', 2598);
  INSERT INTO city(name, county_id) VALUES ('Center Point', 2598);
  INSERT INTO city(name, county_id) VALUES ('Hunt', 2598);
  INSERT INTO city(name, county_id) VALUES ('Mountain Home', 2598);
  INSERT INTO city(name, county_id) VALUES ('London', 2599);
  INSERT INTO city(name, county_id) VALUES ('Telegraph', 2599);
  INSERT INTO city(name, county_id) VALUES ('Roosevelt', 2599);
  INSERT INTO city(name, county_id) VALUES ('Dumont', 2600);
  INSERT INTO city(name, county_id) VALUES ('Finney', 2600);
  INSERT INTO city(name, county_id) VALUES ('Grow', 2600);
  INSERT INTO city(name, county_id) VALUES ('Loyola Beach', 2602);
  INSERT INTO city(name, county_id) VALUES ('Vattman', 2602);
  INSERT INTO city(name, county_id) VALUES ('Rhineland', 2603);
  INSERT INTO city(name, county_id) VALUES ('Truscott', 2603);
  INSERT INTO city(name, county_id) VALUES ('Artesia Wells', 2604);
  INSERT INTO city(name, county_id) VALUES ('Los Angeles', 2604);
  INSERT INTO city(name, county_id) VALUES ('Arthur City', 2605);
  INSERT INTO city(name, county_id) VALUES ('Brookston', 2605);
  INSERT INTO city(name, county_id) VALUES ('Chicota', 2605);
  INSERT INTO city(name, county_id) VALUES ('Cunningham', 2605);
  INSERT INTO city(name, county_id) VALUES ('High', 2605);
  INSERT INTO city(name, county_id) VALUES ('Midcity', 2605);
  INSERT INTO city(name, county_id) VALUES ('Pattonville', 2605);
  INSERT INTO city(name, county_id) VALUES ('Petty', 2605);
  INSERT INTO city(name, county_id) VALUES ('Sumner', 2605);
  INSERT INTO city(name, county_id) VALUES ('Fieldton', 2606);
  INSERT INTO city(name, county_id) VALUES ('Bend', 2607);
  INSERT INTO city(name, county_id) VALUES ('Izoro', 2607);
  INSERT INTO city(name, county_id) VALUES ('Speaks', 2608);
  INSERT INTO city(name, county_id) VALUES ('Sublime', 2608);
  INSERT INTO city(name, county_id) VALUES ('Blue', 2609);
  INSERT INTO city(name, county_id) VALUES ('Dime Box', 2609);
  INSERT INTO city(name, county_id) VALUES ('Hills', 2609);
  INSERT INTO city(name, county_id) VALUES ('Lincoln', 2609);
  INSERT INTO city(name, county_id) VALUES ('Serbin', 2609);
  INSERT INTO city(name, county_id) VALUES ('Flynn', 2610);
  INSERT INTO city(name, county_id) VALUES ('Keechi', 2610);
  INSERT INTO city(name, county_id) VALUES ('Egypt', 2610);
  INSERT INTO city(name, county_id) VALUES ('Dolen', 2611);
  INSERT INTO city(name, county_id) VALUES ('Hightower', 2611);
  INSERT INTO city(name, county_id) VALUES ('Hoop And Holler', 2611);
  INSERT INTO city(name, county_id) VALUES ('Moss Bluff', 2611);
  INSERT INTO city(name, county_id) VALUES ('Moss Hill', 2611);
  INSERT INTO city(name, county_id) VALUES ('Rayburn', 2611);
  INSERT INTO city(name, county_id) VALUES ('Raywood', 2611);
  INSERT INTO city(name, county_id) VALUES ('Romayor', 2611);
  INSERT INTO city(name, county_id) VALUES ('Rye', 2611);
  INSERT INTO city(name, county_id) VALUES ('Stilson', 2611);
  INSERT INTO city(name, county_id) VALUES ('Tarkington Prairie', 2611);
  INSERT INTO city(name, county_id) VALUES ('Ben Hur', 2612);
  INSERT INTO city(name, county_id) VALUES ('Fair Oaks', 2612);
  INSERT INTO city(name, county_id) VALUES ('Forest Glade', 2612);
  INSERT INTO city(name, county_id) VALUES ('Prairie Hill', 2612);
  INSERT INTO city(name, county_id) VALUES ('Dinero', 2614);
  INSERT INTO city(name, county_id) VALUES ('Lebanon', 2614);
  INSERT INTO city(name, county_id) VALUES ('Oakville', 2614);
  INSERT INTO city(name, county_id) VALUES ('Ray Point', 2614);
  INSERT INTO city(name, county_id) VALUES ('Swinney Switch', 2614);
  INSERT INTO city(name, county_id) VALUES ('Whitsett', 2614);
  INSERT INTO city(name, county_id) VALUES ('Bluffton', 2615);
  INSERT INTO city(name, county_id) VALUES ('Castell', 2615);
  INSERT INTO city(name, county_id) VALUES ('Tow', 2615);
  INSERT INTO city(name, county_id) VALUES ('Valley Spring', 2615);
  INSERT INTO city(name, county_id) VALUES ('Porterville', 2616);
  INSERT INTO city(name, county_id) VALUES ('Acuff', 2617);
  INSERT INTO city(name, county_id) VALUES ('Heckville', 2617);
  INSERT INTO city(name, county_id) VALUES ('Reese Center', 2617);
  INSERT INTO city(name, county_id) VALUES ('Slide', 2617);
  INSERT INTO city(name, county_id) VALUES ('Woodrow', 2617);
  INSERT INTO city(name, county_id) VALUES ('Grassland', 2618);
  INSERT INTO city(name, county_id) VALUES ('North Zulch', 2619);
  INSERT INTO city(name, county_id) VALUES ('Lodi', 2620);
  INSERT INTO city(name, county_id) VALUES ('Smithland', 2620);
  INSERT INTO city(name, county_id) VALUES ('Lenorah', 2621);
  INSERT INTO city(name, county_id) VALUES ('Tarzan', 2621);
  INSERT INTO city(name, county_id) VALUES ('Art', 2622);
  INSERT INTO city(name, county_id) VALUES ('Fredonia', 2622);
  INSERT INTO city(name, county_id) VALUES ('Katemcy', 2622);
  INSERT INTO city(name, county_id) VALUES ('Pontotoc', 2622);
  INSERT INTO city(name, county_id) VALUES ('Allenhurst', 2623);
  INSERT INTO city(name, county_id) VALUES ('Caney', 2623);
  INSERT INTO city(name, county_id) VALUES ('Cedar Lake', 2623);
  INSERT INTO city(name, county_id) VALUES ('Cedar Lane', 2623);
  INSERT INTO city(name, county_id) VALUES ('Clemville', 2623);
  INSERT INTO city(name, county_id) VALUES ('Collegeport', 2623);
  INSERT INTO city(name, county_id) VALUES ('Elmaton', 2623);
  INSERT INTO city(name, county_id) VALUES ('Hawkinsville', 2623);
  INSERT INTO city(name, county_id) VALUES ('Midfield', 2623);
  INSERT INTO city(name, county_id) VALUES ('Pledger', 2623);
  INSERT INTO city(name, county_id) VALUES ('Sargent', 2623);
  INSERT INTO city(name, county_id) VALUES ('Wadsworth', 2623);
  INSERT INTO city(name, county_id) VALUES ('Doole', 2625);
  INSERT INTO city(name, county_id) VALUES ('Fife', 2625);
  INSERT INTO city(name, county_id) VALUES ('Lohn', 2625);
  INSERT INTO city(name, county_id) VALUES ('Mercury', 2625);
  INSERT INTO city(name, county_id) VALUES ('Pear Valley', 2625);
  INSERT INTO city(name, county_id) VALUES ('Rochelle', 2625);
  INSERT INTO city(name, county_id) VALUES ('Voca', 2625);
  INSERT INTO city(name, county_id) VALUES ('Axtell', 2626);
  INSERT INTO city(name, county_id) VALUES ('Elm Mott', 2626);
  INSERT INTO city(name, county_id) VALUES ('Ocee', 2626);
  INSERT INTO city(name, county_id) VALUES ('Calliham', 2627);
  INSERT INTO city(name, county_id) VALUES ('Dunlay', 2628);
  INSERT INTO city(name, county_id) VALUES ('Mico', 2628);
  INSERT INTO city(name, county_id) VALUES ('Pearson', 2628);
  INSERT INTO city(name, county_id) VALUES ('Rio Medina', 2628);
  INSERT INTO city(name, county_id) VALUES ('Yancey', 2628);
  INSERT INTO city(name, county_id) VALUES ('Beyer Crossing', 2629);
  INSERT INTO city(name, county_id) VALUES ('Callan', 2629);
  INSERT INTO city(name, county_id) VALUES ('Fort Mckavett', 2629);
  INSERT INTO city(name, county_id) VALUES ('Hext', 2629);
  INSERT INTO city(name, county_id) VALUES ('Saline', 2629);
  INSERT INTO city(name, county_id) VALUES ('Greenwood', 2630);
  INSERT INTO city(name, county_id) VALUES ('Ben Arnold', 2631);
  INSERT INTO city(name, county_id) VALUES ('Burlington', 2631);
  INSERT INTO city(name, county_id) VALUES ('Cummins Crossing', 2631);
  INSERT INTO city(name, county_id) VALUES ('Davilla', 2631);
  INSERT INTO city(name, county_id) VALUES ('Elevation', 2631);
  INSERT INTO city(name, county_id) VALUES ('Gause', 2631);
  INSERT INTO city(name, county_id) VALUES ('Maysfield', 2631);
  INSERT INTO city(name, county_id) VALUES ('Salty', 2631);
  INSERT INTO city(name, county_id) VALUES ('Val Verde', 2631);
  INSERT INTO city(name, county_id) VALUES ('Priddy', 2632);
  INSERT INTO city(name, county_id) VALUES ('Star', 2632);
  INSERT INTO city(name, county_id) VALUES ('Belcherville', 2634);
  INSERT INTO city(name, county_id) VALUES ('Bonita', 2634);
  INSERT INTO city(name, county_id) VALUES ('Capps Corner', 2634);
  INSERT INTO city(name, county_id) VALUES ('Forestburg', 2634);
  INSERT INTO city(name, county_id) VALUES ('Illinois Bend', 2634);
  INSERT INTO city(name, county_id) VALUES ('Red River Station', 2634);
  INSERT INTO city(name, county_id) VALUES ('Ringgold', 2634);
  INSERT INTO city(name, county_id) VALUES ('Spanish Fort', 2634);
  INSERT INTO city(name, county_id) VALUES ('Stoneburg', 2634);
  INSERT INTO city(name, county_id) VALUES ('Chateau Woods', 2635);
  INSERT INTO city(name, county_id) VALUES ('Dobbin', 2635);
  INSERT INTO city(name, county_id) VALUES ('Grangerland', 2635);
  INSERT INTO city(name, county_id) VALUES ('Imperial Oaks', 2635);
  INSERT INTO city(name, county_id) VALUES ('Porter', 2635);
  INSERT INTO city(name, county_id) VALUES ('Tamina', 2635);
  INSERT INTO city(name, county_id) VALUES ('Masterson', 2636);
  INSERT INTO city(name, county_id) VALUES ('Cason', 2637);
  INSERT INTO city(name, county_id) VALUES ('Flomot', 2638);
  INSERT INTO city(name, county_id) VALUES ('Northfield', 2638);
  INSERT INTO city(name, county_id) VALUES ('Tee Pee City', 2638);
  INSERT INTO city(name, county_id) VALUES ('Douglass', 2639);
  INSERT INTO city(name, county_id) VALUES ('Etoile', 2639);
  INSERT INTO city(name, county_id) VALUES ('Martinsville', 2639);
  INSERT INTO city(name, county_id) VALUES ('Sacul', 2639);
  INSERT INTO city(name, county_id) VALUES ('Woden', 2639);
  INSERT INTO city(name, county_id) VALUES ('Chatfield', 2640);
  INSERT INTO city(name, county_id) VALUES ('Purdon', 2640);
  INSERT INTO city(name, county_id) VALUES ('Biloxi', 2641);
  INSERT INTO city(name, county_id) VALUES ('Bon Wier', 2641);
  INSERT INTO city(name, county_id) VALUES ('Call', 2641);
  INSERT INTO city(name, county_id) VALUES ('Trotti', 2641);
  INSERT INTO city(name, county_id) VALUES ('Wiergate', 2641);
  INSERT INTO city(name, county_id) VALUES ('Bitter Creek', 2642);
  INSERT INTO city(name, county_id) VALUES ('Maryneal', 2642);
  INSERT INTO city(name, county_id) VALUES ('Nolan', 2642);
  INSERT INTO city(name, county_id) VALUES ('Chapman Ranch', 2643);
  INSERT INTO city(name, county_id) VALUES ('Violet', 2643);
  INSERT INTO city(name, county_id) VALUES ('Farnsworth', 2644);
  INSERT INTO city(name, county_id) VALUES ('Waka', 2644);
  INSERT INTO city(name, county_id) VALUES ('Boise', 2645);
  INSERT INTO city(name, county_id) VALUES ('Gruhlkey', 2645);
  INSERT INTO city(name, county_id) VALUES ('Herring', 2645);
  INSERT INTO city(name, county_id) VALUES ('Landergin', 2645);
  INSERT INTO city(name, county_id) VALUES ('Magenta', 2645);
  INSERT INTO city(name, county_id) VALUES ('Tascosa', 2645);
  INSERT INTO city(name, county_id) VALUES ('Trujillo', 2645);
  INSERT INTO city(name, county_id) VALUES ('Wildorado', 2645);
  INSERT INTO city(name, county_id) VALUES ('Forest Heights', 2646);
  INSERT INTO city(name, county_id) VALUES ('Lemonville', 2646);
  INSERT INTO city(name, county_id) VALUES ('Little Cypress', 2646);
  INSERT INTO city(name, county_id) VALUES ('Orangefield', 2646);
  INSERT INTO city(name, county_id) VALUES ('Texla', 2646);
  INSERT INTO city(name, county_id) VALUES ('Brazos', 2647);
  INSERT INTO city(name, county_id) VALUES ('Lone Camp', 2647);
  INSERT INTO city(name, county_id) VALUES ('Oran', 2647);
  INSERT INTO city(name, county_id) VALUES ('Santo', 2647);
  INSERT INTO city(name, county_id) VALUES ('Clayton', 2648);
  INSERT INTO city(name, county_id) VALUES ('Deadwood', 2648);
  INSERT INTO city(name, county_id) VALUES ('Deberry', 2648);
  INSERT INTO city(name, county_id) VALUES ('Galloway', 2648);
  INSERT INTO city(name, county_id) VALUES ('Long Branch', 2648);
  INSERT INTO city(name, county_id) VALUES ('Mineral Springs', 2648);
  INSERT INTO city(name, county_id) VALUES ('Murvaul', 2648);
  INSERT INTO city(name, county_id) VALUES ('Panola', 2648);
  INSERT INTO city(name, county_id) VALUES ('Brock', 2649);
  INSERT INTO city(name, county_id) VALUES ('Dennis', 2649);
  INSERT INTO city(name, county_id) VALUES ('Garner', 2649);
  INSERT INTO city(name, county_id) VALUES ('Peaster', 2649);
  INSERT INTO city(name, county_id) VALUES ('Poolville', 2649);
  INSERT INTO city(name, county_id) VALUES ('Whitt', 2649);
  INSERT INTO city(name, county_id) VALUES ('Black', 2650);
  INSERT INTO city(name, county_id) VALUES ('Lazbuddie', 2650);
  INSERT INTO city(name, county_id) VALUES ('Bakersfield', 2651);
  INSERT INTO city(name, county_id) VALUES ('Girvin', 2651);
  INSERT INTO city(name, county_id) VALUES ('Sheffield', 2651);
  INSERT INTO city(name, county_id) VALUES ('Ace', 2652);
  INSERT INTO city(name, county_id) VALUES ('Barnum', 2652);
  INSERT INTO city(name, county_id) VALUES ('Blanchard', 2652);
  INSERT INTO city(name, county_id) VALUES ('Camden', 2652);
  INSERT INTO city(name, county_id) VALUES ('Dallardsville', 2652);
  INSERT INTO city(name, county_id) VALUES ('Laurelia', 2652);
  INSERT INTO city(name, county_id) VALUES ('Leggett', 2652);
  INSERT INTO city(name, county_id) VALUES ('Moscow', 2652);
  INSERT INTO city(name, county_id) VALUES ('Segno', 2652);
  INSERT INTO city(name, county_id) VALUES ('Bushland', 2653);
  INSERT INTO city(name, county_id) VALUES ('Candelaria', 2654);
  INSERT INTO city(name, county_id) VALUES ('Chinati', 2654);
  INSERT INTO city(name, county_id) VALUES ('Plata', 2654);
  INSERT INTO city(name, county_id) VALUES ('Ruidosa', 2654);
  INSERT INTO city(name, county_id) VALUES ('Shafter', 2654);
  INSERT INTO city(name, county_id) VALUES ('Umbarger', 2656);
  INSERT INTO city(name, county_id) VALUES ('Best', 2657);
  INSERT INTO city(name, county_id) VALUES ('Stiles', 2657);
  INSERT INTO city(name, county_id) VALUES ('Texon', 2657);
  INSERT INTO city(name, county_id) VALUES ('Rio Frio', 2658);
  INSERT INTO city(name, county_id) VALUES ('Bagwell', 2659);
  INSERT INTO city(name, county_id) VALUES ('Saragosa', 2660);
  INSERT INTO city(name, county_id) VALUES ('Toyahvale', 2660);
  INSERT INTO city(name, county_id) VALUES ('Verhalen', 2660);
  INSERT INTO city(name, county_id) VALUES ('Black Jack', 2663);
  INSERT INTO city(name, county_id) VALUES ('Easterly', 2663);
  INSERT INTO city(name, county_id) VALUES ('Hammond', 2663);
  INSERT INTO city(name, county_id) VALUES ('Mumford', 2663);
  INSERT INTO city(name, county_id) VALUES ('New Baden', 2663);
  INSERT INTO city(name, county_id) VALUES ('Ridge', 2663);
  INSERT INTO city(name, county_id) VALUES ('Tidwell Prairie', 2663);
  INSERT INTO city(name, county_id) VALUES ('Wheelock', 2663);
  INSERT INTO city(name, county_id) VALUES ('Marie', 2665);
  INSERT INTO city(name, county_id) VALUES ('Maverick', 2665);
  INSERT INTO city(name, county_id) VALUES ('Norton', 2665);
  INSERT INTO city(name, county_id) VALUES ('Rowena', 2665);
  INSERT INTO city(name, county_id) VALUES ('Wingate', 2665);
  INSERT INTO city(name, county_id) VALUES ('Joinerville', 2666);
  INSERT INTO city(name, county_id) VALUES ('Laird Hill', 2666);
  INSERT INTO city(name, county_id) VALUES ('Laneville', 2666);
  INSERT INTO city(name, county_id) VALUES ('Leverett''S Chapel', 2666);
  INSERT INTO city(name, county_id) VALUES ('Price', 2666);
  INSERT INTO city(name, county_id) VALUES ('Selman City', 2666);
  INSERT INTO city(name, county_id) VALUES ('Turnertown', 2666);
  INSERT INTO city(name, county_id) VALUES ('Bronson', 2667);
  INSERT INTO city(name, county_id) VALUES ('Fairmount', 2667);
  INSERT INTO city(name, county_id) VALUES ('Geneva', 2667);
  INSERT INTO city(name, county_id) VALUES ('Isla', 2667);
  INSERT INTO city(name, county_id) VALUES ('Rosevine', 2667);
  INSERT INTO city(name, county_id) VALUES ('Sexton', 2667);
  INSERT INTO city(name, county_id) VALUES ('Yellowpine', 2667);
  INSERT INTO city(name, county_id) VALUES ('Doyle', 2670);
  INSERT INTO city(name, county_id) VALUES ('Cherokee', 2671);
  INSERT INTO city(name, county_id) VALUES ('Adams', 2672);
  INSERT INTO city(name, county_id) VALUES ('Hulldale', 2672);
  INSERT INTO city(name, county_id) VALUES ('Dermott', 2673);
  INSERT INTO city(name, county_id) VALUES ('Dunn', 2673);
  INSERT INTO city(name, county_id) VALUES ('Fluvanna', 2673);
  INSERT INTO city(name, county_id) VALUES ('Ira', 2673);
  INSERT INTO city(name, county_id) VALUES ('Dreka', 2675);
  INSERT INTO city(name, county_id) VALUES ('Shelbyville', 2675);
  INSERT INTO city(name, county_id) VALUES ('New Harmony', 2675);
  INSERT INTO city(name, county_id) VALUES ('Bascom', 2677);
  INSERT INTO city(name, county_id) VALUES ('Dogwood City', 2677);
  INSERT INTO city(name, county_id) VALUES ('Flint', 2677);
  INSERT INTO city(name, county_id) VALUES ('Gresham', 2677);
  INSERT INTO city(name, county_id) VALUES ('Mount Sylvan', 2677);
  INSERT INTO city(name, county_id) VALUES ('Owentown', 2677);
  INSERT INTO city(name, county_id) VALUES ('Starrville', 2677);
  INSERT INTO city(name, county_id) VALUES ('Swan', 2677);
  INSERT INTO city(name, county_id) VALUES ('Nemo', 2678);
  INSERT INTO city(name, county_id) VALUES ('Rainbow', 2678);
  INSERT INTO city(name, county_id) VALUES ('Anacua', 2679);
  INSERT INTO city(name, county_id) VALUES ('Chapeno', 2679);
  INSERT INTO city(name, county_id) VALUES ('East Lopez', 2679);
  INSERT INTO city(name, county_id) VALUES ('El Mesquite', 2679);
  INSERT INTO city(name, county_id) VALUES ('El Socio', 2679);
  INSERT INTO city(name, county_id) VALUES ('Escobar I', 2679);
  INSERT INTO city(name, county_id) VALUES ('Falcon Village', 2679);
  INSERT INTO city(name, county_id) VALUES ('Garciasville', 2679);
  INSERT INTO city(name, county_id) VALUES ('Guadalupe-Guerra', 2679);
  INSERT INTO city(name, county_id) VALUES ('Indio', 2679);
  INSERT INTO city(name, county_id) VALUES ('Jardin De San Julian', 2679);
  INSERT INTO city(name, county_id) VALUES ('Jf Villarreal', 2679);
  INSERT INTO city(name, county_id) VALUES ('La Casita', 2679);
  INSERT INTO city(name, county_id) VALUES ('La Reforma', 2679);
  INSERT INTO city(name, county_id) VALUES ('Los Arrieros', 2679);
  INSERT INTO city(name, county_id) VALUES ('Manuel Garcia Ii', 2679);
  INSERT INTO city(name, county_id) VALUES ('Martinez', 2679);
  INSERT INTO city(name, county_id) VALUES ('Moraida', 2679);
  INSERT INTO city(name, county_id) VALUES ('Narciso Pena', 2679);
  INSERT INTO city(name, county_id) VALUES ('Netos', 2679);
  INSERT INTO city(name, county_id) VALUES ('Northridge', 2679);
  INSERT INTO city(name, county_id) VALUES ('Old Escobares', 2679);
  INSERT INTO city(name, county_id) VALUES ('Rafael Pena', 2679);
  INSERT INTO city(name, county_id) VALUES ('Rivera', 2679);
  INSERT INTO city(name, county_id) VALUES ('Roma Creek', 2679);
  INSERT INTO city(name, county_id) VALUES ('Sammy Martinez', 2679);
  INSERT INTO city(name, county_id) VALUES ('Sandoval', 2679);
  INSERT INTO city(name, county_id) VALUES ('Santa Catarina', 2679);
  INSERT INTO city(name, county_id) VALUES ('Santa Cruz', 2679);
  INSERT INTO city(name, county_id) VALUES ('Santa Elena', 2679);
  INSERT INTO city(name, county_id) VALUES ('Tierra Dorada', 2679);
  INSERT INTO city(name, county_id) VALUES ('Valle Hermoso', 2679);
  INSERT INTO city(name, county_id) VALUES ('Zarate', 2679);
  INSERT INTO city(name, county_id) VALUES ('Caddo', 2680);
  INSERT INTO city(name, county_id) VALUES ('La Casa', 2680);
  INSERT INTO city(name, county_id) VALUES ('Broome', 3144);
  INSERT INTO city(name, county_id) VALUES ('Old Glory', 2681);
  INSERT INTO city(name, county_id) VALUES ('Peacock', 2681);
  INSERT INTO city(name, county_id) VALUES ('Rath City', 2681);
  INSERT INTO city(name, county_id) VALUES ('Swenson', 2681);
  INSERT INTO city(name, county_id) VALUES ('Vigo Park', 2683);
  INSERT INTO city(name, county_id) VALUES ('Eagle Mountain', 2684);
  INSERT INTO city(name, county_id) VALUES ('Caps', 2685);
  INSERT INTO city(name, county_id) VALUES ('Hamby', 2685);
  INSERT INTO city(name, county_id) VALUES ('Ovalo', 2685);
  INSERT INTO city(name, county_id) VALUES ('View', 2685);
  INSERT INTO city(name, county_id) VALUES ('Dryden', 2686);
  INSERT INTO city(name, county_id) VALUES ('Tokio', 2687);
  INSERT INTO city(name, county_id) VALUES ('Cookville', 2689);
  INSERT INTO city(name, county_id) VALUES ('Ben Ficklin', 2690);
  INSERT INTO city(name, county_id) VALUES ('Harriett', 2690);
  INSERT INTO city(name, county_id) VALUES ('Knickerbocker', 2690);
  INSERT INTO city(name, county_id) VALUES ('Mereta', 2690);
  INSERT INTO city(name, county_id) VALUES ('Orient', 2690);
  INSERT INTO city(name, county_id) VALUES ('Tankersley', 2690);
  INSERT INTO city(name, county_id) VALUES ('Vancourt', 2690);
  INSERT INTO city(name, county_id) VALUES ('Veribest', 2690);
  INSERT INTO city(name, county_id) VALUES ('Wall', 2690);
  INSERT INTO city(name, county_id) VALUES ('Water Valley', 2690);
  INSERT INTO city(name, county_id) VALUES ('Anderson Mill', 2691);
  INSERT INTO city(name, county_id) VALUES ('Del Valle', 2691);
  INSERT INTO city(name, county_id) VALUES ('Jollyville', 2691);
  INSERT INTO city(name, county_id) VALUES ('Onion Creek', 2691);
  INSERT INTO city(name, county_id) VALUES ('Windemere', 2691);
  INSERT INTO city(name, county_id) VALUES ('Apple Springs', 2692);
  INSERT INTO city(name, county_id) VALUES ('Centralia', 2692);
  INSERT INTO city(name, county_id) VALUES ('Nogalus Prairie', 2692);
  INSERT INTO city(name, county_id) VALUES ('Woodlake', 2692);
  INSERT INTO city(name, county_id) VALUES ('Doucette', 2693);
  INSERT INTO city(name, county_id) VALUES ('Fred', 2693);
  INSERT INTO city(name, county_id) VALUES ('Hillister', 2693);
  INSERT INTO city(name, county_id) VALUES ('Rockland', 2693);
  INSERT INTO city(name, county_id) VALUES ('Spurger', 2693);
  INSERT INTO city(name, county_id) VALUES ('Diana', 2694);
  INSERT INTO city(name, county_id) VALUES ('Enoch', 2694);
  INSERT INTO city(name, county_id) VALUES ('Kelsey', 2694);
  INSERT INTO city(name, county_id) VALUES ('Rhonesboro', 2694);
  INSERT INTO city(name, county_id) VALUES ('Simpsonville', 2694);
  INSERT INTO city(name, county_id) VALUES ('Midkiff', 2695);
  INSERT INTO city(name, county_id) VALUES ('Comstock', 2697);
  INSERT INTO city(name, county_id) VALUES ('Juno', 2697);
  INSERT INTO city(name, county_id) VALUES ('Langtry', 2697);
  INSERT INTO city(name, county_id) VALUES ('Laughlin Air Force Base', 2697);
  INSERT INTO city(name, county_id) VALUES ('Pandale', 2697);
  INSERT INTO city(name, county_id) VALUES ('Ben Wheeler', 2698);
  INSERT INTO city(name, county_id) VALUES ('Martin''S Mill', 2698);
  INSERT INTO city(name, county_id) VALUES ('Whitton', 2698);
  INSERT INTO city(name, county_id) VALUES ('Mcfaddin', 2699);
  INSERT INTO city(name, county_id) VALUES ('Moursund', 2699);
  INSERT INTO city(name, county_id) VALUES ('Nursery', 2699);
  INSERT INTO city(name, county_id) VALUES ('Raisin', 2699);
  INSERT INTO city(name, county_id) VALUES ('Telferner', 2699);
  INSERT INTO city(name, county_id) VALUES ('Dodge', 2700);
  INSERT INTO city(name, county_id) VALUES ('Fields Store', 2701);
  INSERT INTO city(name, county_id) VALUES ('Monaville', 2701);
  INSERT INTO city(name, county_id) VALUES ('Royalty', 2702);
  INSERT INTO city(name, county_id) VALUES ('Chappell Hill', 2703);
  INSERT INTO city(name, county_id) VALUES ('Gay Hill', 2703);
  INSERT INTO city(name, county_id) VALUES ('Greenvine', 2703);
  INSERT INTO city(name, county_id) VALUES ('Independence', 2703);
  INSERT INTO city(name, county_id) VALUES ('Latium', 2703);
  INSERT INTO city(name, county_id) VALUES ('Quarry', 2703);
  INSERT INTO city(name, county_id) VALUES ('Washington-On-The-Brazos', 2703);
  INSERT INTO city(name, county_id) VALUES ('Aguilares', 2704);
  INSERT INTO city(name, county_id) VALUES ('Callaghan', 2704);
  INSERT INTO city(name, county_id) VALUES ('Darwin', 2704);
  INSERT INTO city(name, county_id) VALUES ('Four Points', 2704);
  INSERT INTO city(name, county_id) VALUES ('Hillside Acres', 2704);
  INSERT INTO city(name, county_id) VALUES ('Islitas', 2704);
  INSERT INTO city(name, county_id) VALUES ('Laredo Ranchettes', 2704);
  INSERT INTO city(name, county_id) VALUES ('Laredo Ranchettes West', 2704);
  INSERT INTO city(name, county_id) VALUES ('Larga Vista', 2704);
  INSERT INTO city(name, county_id) VALUES ('Las Haciendas', 2704);
  INSERT INTO city(name, county_id) VALUES ('Las Pilas', 2704);
  INSERT INTO city(name, county_id) VALUES ('Las Tiendas', 2704);
  INSERT INTO city(name, county_id) VALUES ('Los Centenarios', 2704);
  INSERT INTO city(name, county_id) VALUES ('Los Corralitos', 2704);
  INSERT INTO city(name, county_id) VALUES ('Los Ojuelos', 2704);
  INSERT INTO city(name, county_id) VALUES ('Pescadito', 2704);
  INSERT INTO city(name, county_id) VALUES ('Pueblo East', 2704);
  INSERT INTO city(name, county_id) VALUES ('Santo Tomás', 2704);
  INSERT INTO city(name, county_id) VALUES ('Tanquecitos South Acres Ii', 2704);
  INSERT INTO city(name, county_id) VALUES ('Valle Verde', 2704);
  INSERT INTO city(name, county_id) VALUES ('Webb', 2704);
  INSERT INTO city(name, county_id) VALUES ('Bonus', 2705);
  INSERT INTO city(name, county_id) VALUES ('Danevang', 2705);
  INSERT INTO city(name, county_id) VALUES ('Glen Flora', 2705);
  INSERT INTO city(name, county_id) VALUES ('Hillje', 2705);
  INSERT INTO city(name, county_id) VALUES ('Lane City', 2705);
  INSERT INTO city(name, county_id) VALUES ('Lissie', 2705);
  INSERT INTO city(name, county_id) VALUES ('Newgulf', 2705);
  INSERT INTO city(name, county_id) VALUES ('Pierce', 2705);
  INSERT INTO city(name, county_id) VALUES ('Allison', 2706);
  INSERT INTO city(name, county_id) VALUES ('Briscoe', 2706);
  INSERT INTO city(name, county_id) VALUES ('Kelton', 2706);
  INSERT INTO city(name, county_id) VALUES ('Lela', 2706);
  INSERT INTO city(name, county_id) VALUES ('Twitty', 2706);
  INSERT INTO city(name, county_id) VALUES ('Bacon', 2707);
  INSERT INTO city(name, county_id) VALUES ('Haynesville', 2707);
  INSERT INTO city(name, county_id) VALUES ('Kamay', 2707);
  INSERT INTO city(name, county_id) VALUES ('Harrold', 2708);
  INSERT INTO city(name, county_id) VALUES ('Odell', 2708);
  INSERT INTO city(name, county_id) VALUES ('Oklaunion', 2708);
  INSERT INTO city(name, county_id) VALUES ('Lyford South', 2709);
  INSERT INTO city(name, county_id) VALUES ('Santa Monica', 2709);
  INSERT INTO city(name, county_id) VALUES ('Willamar', 2709);
  INSERT INTO city(name, county_id) VALUES ('Hare', 2710);
  INSERT INTO city(name, county_id) VALUES ('Jonah', 2710);
  INSERT INTO city(name, county_id) VALUES ('Norman''S Crossing', 2710);
  INSERT INTO city(name, county_id) VALUES ('Schwertner', 2710);
  INSERT INTO city(name, county_id) VALUES ('Walburg', 2710);
  INSERT INTO city(name, county_id) VALUES ('Waterloo', 2710);
  INSERT INTO city(name, county_id) VALUES ('Carpenter', 2711);
  INSERT INTO city(name, county_id) VALUES ('Doseido Colony', 2711);
  INSERT INTO city(name, county_id) VALUES ('Grass Pond Colony', 2711);
  INSERT INTO city(name, county_id) VALUES ('Kicaster', 2711);
  INSERT INTO city(name, county_id) VALUES ('Pandora', 2711);
  INSERT INTO city(name, county_id) VALUES ('Sandy Hills', 2711);
  INSERT INTO city(name, county_id) VALUES ('Saspamco', 2711);
  INSERT INTO city(name, county_id) VALUES ('Sutherland Springs', 2711);
  INSERT INTO city(name, county_id) VALUES ('Slidell', 2713);
  INSERT INTO city(name, county_id) VALUES ('Crow', 2714);
  INSERT INTO city(name, county_id) VALUES ('Golden', 2714);
  INSERT INTO city(name, county_id) VALUES ('Hainesville', 2714);
  INSERT INTO city(name, county_id) VALUES ('Eliasville', 2716);
  INSERT INTO city(name, county_id) VALUES ('Loving', 2716);
  INSERT INTO city(name, county_id) VALUES ('South Bend', 2716);
  INSERT INTO city(name, county_id) VALUES ('Falcon', 2717);
  INSERT INTO city(name, county_id) VALUES ('Las Palmas', 2717);
  INSERT INTO city(name, county_id) VALUES ('Los Lobos', 2717);
  INSERT INTO city(name, county_id) VALUES ('Morales-Sanchez', 2717);
  INSERT INTO city(name, county_id) VALUES ('Cometa', 2718);
  
  INSERT INTO city(name, county_id) VALUES ('Jamaica Plain', 1210);
  INSERT INTO city(name, county_id) VALUES ('Roslindale', 1210);
  INSERT INTO city(name, county_id) VALUES ('Georges Mills', 1735);
  INSERT INTO city(name, county_id) VALUES ('Hope', 2269);
  INSERT INTO city(name, county_id) VALUES ('Astoria', 1830);
  INSERT INTO city(name, county_id) VALUES ('Slatersville', 2269);
  INSERT INTO city(name, county_id) VALUES ('Wollaston', 1208);
  
  INSERT INTO city(name, county_id) VALUES ('North Brunswick', 1747);
  INSERT INTO city(name, county_id) VALUES ('West Kingston', 2270);
  INSERT INTO city(name, county_id) VALUES ('Needham Heights', 1208);
  INSERT INTO city(name, county_id) VALUES ('South Weymouth', 1208);
  INSERT INTO city(name, county_id) VALUES ('Newton Centre', 1206);
  INSERT INTO city(name, county_id) VALUES ('Allston', 1210);
  INSERT INTO city(name, county_id) VALUES ('West Barnstable', 1198);
  INSERT INTO city(name, county_id) VALUES ('Glendale', 2269);
  INSERT INTO city(name, county_id) VALUES ('Fiskeville', 2269);
  INSERT INTO city(name, county_id) VALUES ('Forestdale', 2269);
  INSERT INTO city(name, county_id) VALUES ('Ocean Bluff', 1209);
  INSERT INTO city(name, county_id) VALUES ('Westport Point', 1200);
  INSERT INTO city(name, county_id) VALUES ('North Quincy', 1208);
  INSERT INTO city(name, county_id) VALUES ('Osterville', 1198);
  INSERT INTO city(name, county_id) VALUES ('North Easton', 1200);
  INSERT INTO city(name, county_id) VALUES ('North Dighton', 1200);
  INSERT INTO city(name, county_id) VALUES ('South Easton', 1200);
  INSERT INTO city(name, county_id) VALUES ('Newtonville', 1206);
  INSERT INTO city(name, county_id) VALUES ('Sheldonville', 1208);
  INSERT INTO city(name, county_id) VALUES ('Jamaica', 1830);
  INSERT INTO city(name, county_id) VALUES ('Corona', 1830);
  INSERT INTO city(name, county_id) VALUES ('East Henrietta', 1817);
  INSERT INTO city(name, county_id) VALUES ('West Henrietta', 1817);
  INSERT INTO city(name, county_id) VALUES ('Long Island City', 1830);
  INSERT INTO city(name, county_id) VALUES ('Far Rockaway', 1830);
  INSERT INTO city(name, county_id) VALUES ('Garrison', 1829);
  INSERT INTO city(name, county_id) VALUES ('East Elmhurst', 1830);
  INSERT INTO city(name, county_id) VALUES ('Howard Beach', 1830);
  INSERT INTO city(name, county_id) VALUES ('St. Johns', 370);
  INSERT INTO city(name, county_id) VALUES ('Maple Shade', 1738);
  INSERT INTO city(name, county_id) VALUES ('Wayne', 1751);
  INSERT INTO city(name, county_id) VALUES ('Brick', 1750);
  INSERT INTO city(name, county_id) VALUES ('Parsippany', 1749);
  INSERT INTO city(name, county_id) VALUES ('Sparta', 1754);
  INSERT INTO city(name, county_id) VALUES ('Mount Laurel', 1738);
  INSERT INTO city(name, county_id) VALUES ('Cranford', 1755);
  INSERT INTO city(name, county_id) VALUES ('Voorhees', 1739);
  INSERT INTO city(name, county_id) VALUES ('Hillsborough', 1753);
  INSERT INTO city(name, county_id) VALUES ('Lebanon', 1745);
  INSERT INTO city(name, county_id) VALUES ('Palos Verdes Peninsula', 198);
  INSERT INTO city(name, county_id) VALUES ('Mira Loma', 212);
  INSERT INTO city(name, county_id) VALUES ('Cumberland Foreside', 1160);
  INSERT INTO city(name, county_id) VALUES ('Belgrade Lakes', 1163);
  INSERT INTO city(name, county_id) VALUES ('Chester Springs', 2213);
  INSERT INTO city(name, county_id) VALUES ('Doylestown', 2207);
  INSERT INTO city(name, county_id) VALUES ('Havertown', 2221);
  INSERT INTO city(name, county_id) VALUES ('Landenberg', 2213);
  INSERT INTO city(name, county_id) VALUES ('Whittier', 1901);
  INSERT INTO city(name, county_id) VALUES ('St. Johnsbury', 2750);
  INSERT INTO city(name, county_id) VALUES ('West Lebanon', 1730);
  INSERT INTO city(name, county_id) VALUES ('Putney', 2759);
  INSERT INTO city(name, county_id) VALUES ('Newfane', 2759);
  INSERT INTO city(name, county_id) VALUES ('North Kingstown', 2270);
  INSERT INTO city(name, county_id) VALUES ('Newton Upper Falls', 1206);
  INSERT INTO city(name, county_id) VALUES ('Tokyo', 3246);
  INSERT INTO city(name, county_id) VALUES ('Shanghai', 3247);
  INSERT INTO city(name, county_id) VALUES ('East Taunton', 1200);
  INSERT INTO city(name, county_id) VALUES ('Bala Cynwyd', 2244);
  INSERT INTO city(name, county_id) VALUES ('Dayville', 307);
  INSERT INTO city(name, county_id) VALUES ('Wakefield', 2270);
  INSERT INTO city(name, county_id) VALUES ('Charlotte', 2751);
  INSERT INTO city(name, county_id) VALUES ('North Waltham', 1206);
  INSERT INTO city(name, county_id) VALUES ('Block Island', 2270);
  INSERT INTO city(name, county_id) VALUES ('Dummerston', 2759);
  INSERT INTO city(name, county_id) VALUES ('East Arlington', 1206);
  DELETE FROM city WHERE id = 1365;
  INSERT INTO city(name, county_id) VALUES ('Centerville', 2270);
  INSERT INTO city(name, county_id) VALUES ('La Crescenta', 198);
  INSERT INTO city(name, county_id) VALUES ('Bayside', 1830);
  INSERT INTO city(name, county_id) VALUES ('Maspeth', 1830);
  INSERT INTO city(name, county_id) VALUES ('Pauline', 2312);
  INSERT INTO city(name, county_id) VALUES ('Sewickley', 2200);
  