Contents
What are the tables in the US cities database?
The SQL file contains two tables: US_STATES: ID, STATE_CODE and STATE_NAME. US_CITIES: ID, ID_STATE, CITY, COUNTY, LATITUDE and LONGITUDE. The US_CITIES table has all (or almost all) cities from the United States. The us_cities.sql file is compatible with MySQL.
Where can I find data on all US cities?
By collecting and analyzing data from a variety of government and private sources, we’re able to create detailed, informative profiles for every city in the United States. From crime rates to weather patterns, you’ll find the data you’re looking for on City-Data.com.
What do you need to know about city state product?
City State Product is a comprehensive list of ZIP Codes with corresponding city and county names. This file also contains other names by which a Post Office™ may be known. City State Product can assist mailers with city, state, and 5-digit ZIP validation; ZIP Code and finance number assignment; and county code/name identification.
Is the US cities table compatible with MySQL?
The US_CITIES table has all (or almost all) cities from the United States. The us_cities.sql file is compatible with MySQL. See sqlite for the sqlite3 compatible version.
How many county equivalents are there in the United States?
Wikipedia list article An enlargeable map of the 3,143 countiesand county equivalentslocated in the 50 U.S. statesand the District of Columbia. The 100 county equivalents in the U.S. territoriesare not on this map. This article lists the 3,143 counties and county equivalents of the United States.
Where can I find list of all US cities?
US_CITIES: ID, ID_STATE, CITY, COUNTY, LATITUDE and LONGITUDE. The US_CITIES table has all (or almost all) cities from the United States. The us_cities.sql file is compatible with MySQL. See sqlite for the sqlite3 compatible version.
Are there any counties that are not part of a state?
Maryland, Missouriand Nevadaare each composed entirely of counties, except that each also has exactly one independent city: Baltimore, St. Louis, and Carson City, respectively. The District of Columbiais a single federal district that is not part of any state or county.