Place Name Database TM (2023 version)

Complete Place Name database with geographic coordinates for the entire USA. Includes city, town, and township names, Census place codes, county names and county FIPS codes, state abbreviations and state FIPS codes plus latitude and longitude. More than 196,000 records!

Download Place Name database with city, town, and township names, county, and place codes information immediately!

Description
The Place Name Database contains the official names of US cities, towns, counties, and other "populated places" as defined by the US Census Bureau and the US Government.

For each named place the database includes latitude and longitude coordinates of the place, the Census code, the state abbreviation and state FIPS code, the county name and county FIPS code. If the place lies in two or more counties, all counties are listed.

The database contains more than 196,000 place name records, and is approximately 20 MB in size (uncompressed).

Please Note: The encoding has been updated from ASCII to Unicode for the October 2023 update to provide better matching with actual place names and modernize the file.

The database is available in comma delimited ASCII (CSV) format. Because this database is available as a simple text file, it can be used on almost every type of computer, including PCs and compatibles, Macs, and Linux workstations.

Record Layout
Field Type Length
Place Name Variable length text 104 characters max
State Code Fixed length text 2 characters
Census code Fixed length text 5 digits
Place Type Variable length text 15 characters max
Place Class Fixed length 2 alphanumeric characters
State FIPS Code Fixed length text 2 digits
County FIPS Code Fixed length text 3 digits
County Name Variable length text 29 characters max
County Number Numeric 2 digits max
Latitude Numeric 12 digits max
Longitude Numeric 13 digits max
Feature ID Numeric 10 digits max

Note that all FIPS fields are treated as text fields. This prevents the loss of leading zeroes in these fields when the data is imported into a database program.

The Place Name is the actual name by which the place is locally known. Note: if a place lies in two or more counties, there will be two or more records for that place name, each showing a different county FIPS, county name, and county number.

The State code is the normal two-letter abbreviation for the state, as assigned by the US Postal Service.

The Census Place Code is a 5-digit numeric field containing a unique numeric identification assigned to each city, town, borough, village, or census district in a given state by the Census Bureau. Please note that the Federal Government has replaced the Census place code with the Feature ID code, effective January 2006.

The Place Type field broadly defines the place as a city, town, or other entity. This is an interpretation of the Census Bureau place class code.

The Place Class is the specific definition of the place type, according to Census Bureau standards. We include with the database a list of Census Bureau place class codes.

The State FIPS code is a two-digit numeric code assigned by the US Government to each of the states and territories of the USA.

The County FIPS identifies a county which contains some portion of the place. The County FIPS Code is a 3-digit field containing a unique numeric identification assigned to each county in a given state by the US government. Note: if a place lies in two or more counties, there will be two or more records for that place name, each showing a different county FIPS, county name, and county number.

The County Name field is the name of the county defined by the County FIPS field. Note that for Alaska, which has no counties, this name represents a "county equivalent" defined for statistical purposes by the Census Bureau.

The County Number field indicates the record number within a group of records belonging to a place which exists in multiple counties. Note: if a place lies in two or more counties, there will be two or more records for that place name, each showing a different county FIPS, county name, and county number.

The Latitude and Longitude fields contain the geographic coordinates of the place in units of degrees.

The Feature ID field contains the official identifier assigned by the US Government for that place.

Sample Records
Place Name
Addison
Addison
Addison
Addison
Addison
Addison
ST Code
AL
AL
CT
IL
KY
MI
Census Code
00484
90027
00240
00243
00370
00380
Place Type
Pop Place
MCD
Pop Place
Pop Place
Pop Place
Pop Place
Place Class
P1
Z5
U6
P1
P1
P1
ST FIPS
01
01
09
17
21
26
County FIPS
133
133
003
043
027
091
County Name
Winston
Winston
Hartford
DuPage
Breckinridge
Lenawee
County Number
1
1
1
1
1
1
Latitude
34.2023243
34.155103
41.7184328
41.931696
37.9161709
41.9864341
Longitude
-87.1814012
-87.2055675
-72.5767558
-87.9889556
-86.5649809
-84.3471684
Feature ID
159051
161625
205046
421692
510220
619840

Click here to download sample records in comma-delimited ASCII (CSV) format.

Available File Formats
Format Compression Download Size
Comma-delimited ASCII self-extracting 5 MB
Comma-delimited ASCII PKZip 5 MB
Comma-delimited ASCII uncompressed 20 MB

Licenses

Please read our License Overview to determine which license you need.


Prices
Place Name Database
Workstation License $104.95
Enterprise License: $209.95
Duplication Addendum:
up to 100 copies
unlimited copies

$418.95
$838.95

Prices subject to change without notice.

Delivery:
Internet: Download Place Name Database immediately after you place your order online via our secure server. We'll include an invoice which states what you ordered and paid.


30-Day Money-Back Guarantee
We back the Place Name Database with our 30-Day Money-Back Guarantee. If you are not satisfied with Place Name Database we will cheerfully refund the purchase price of the product.

What our Customers say about our Database Products and about us

Yes, I want to order the Place Name Database with state FIPS code, place FIPS code, place name, and state code


ZIP code Products - ZIP code Product Search - About Us - Contact Us - Home


Place Name database with city names, town names, township names, county, and place FIPS codes information

Copyright © 2023 Melissa Data Corporation