Place Name Database TM (2024 version)

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.

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

• Workstation License - single-user, single workstation
• Enterprise License - unlimited users on unlimited sites within one company
• Duplication Addendum - Addendum to Enterprise or Workstation License for redistributing the data of the Place Name database outside your company.

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