Place Name Database TM (updated annually)
Complete Place Name database for the entire USA, with city, town, and township names, place FIPS codes, county names and FIPS codes, state abbreviations and FIPS codes, and MSA. More than 196,000 records!
Description
The Place Name Database contains the names of US cities, towns, counties, military bases, airports, federal facilities, national parks, prisons, branch post offices, Indian reservations, and other "populated places" as defined by the US Census Bureau and the US Government.
For each place name the database includes the place FIPS code, the state abbreviation and FIPS code, the county name and FIPS code, and the MSA (if any). FIPS stands for Federal Information Processing Standard, a data encoding standard defined and used by the US government.
The database is available in two formats: comma delimited ASCII and native MS Access 97. The database contains more than 196,000 place name records, and is approximately 13 MB in size (uncompressed). The ASCII file can be searched using most text editors and word processors, or can be imported into most commercial database programs, such as Paradox, dBase, or Visual FoxPro.
Because this database is available as a simple text file, it can be used on almost every type of computer, including PCs and compatibles, Macintoshes, and UNIX workstations.
Record Layout
| Field | Type | Length | ||
|---|---|---|---|---|
| Place Name | Variable length text | 52 characters max | ||
| State Code | Fixed length text | 2 characters | ||
| Place FIPS code | Fixed length text | 5 digits | ||
| Place Type | Variable length text | 8 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 | 22 characters max | ||
| MSA | Fixed length text | 4 digits | ||
| County Count | Numeric | 2 digits max | ||
| County Number | Numeric | 2 digits max |
Note that all FIPS fields and the MSA field 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. We have standardized spellings to eliminate abbreviations and alternate spellings where practical.
The State code is the normal two-letter abbreviation for the state, as assigned by the US Postal Service.
The Place FIPS 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 US government.
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, accoding 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 more than one county, the County Count field contains a number greater than 1, indicating the number of different counties which contain some portion of the place.
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 MSA/PMSA field contains the Metropolitan Statistical Area code or Primary Metropolitan Statistical Area code, if any, in which the place lies. The MSA/PMSA code is assigned by the Office of Management and Budget of the US Government. Note: only places which exist within defined "metropolitan" areas have an MSA or PMSA code. Most rural places do not have an assigned MSA/PMSA code. We include with the database a list of all MSA/PMSA codes.
The County Count field indicates the number of counties in which some portion of the place lies. For most places this count is one, indicating that the place lies entirely within a single county. A County Count greater than one means that the place crosses county boundaries and lies partially within multiple counties. This also means that the place name is represented in the Place Name Database by a group of similar place name records. There is one record for each county in which the place partially lies.
The County Number field indicates the record number within a group of records belonging to a place which exists in multiple counties.
Sample Records
| Place Name |
|---|
| Addison |
| Addison |
| Addison |
| Addison |
| Addison |
| Addison |
| ST Code |
|---|
| AL |
| AL |
| CT |
| IL |
| IL |
| IN |
| Place FIPS |
|---|
| 00484 |
| 90027 |
| 00240 |
| 00243 |
| 00250 |
| 00568 |
| Place Type |
|---|
| City |
| MCD |
| CDP |
| City |
| Township |
| Township |
| Place Class |
|---|
| C1 |
| Z5 |
| U6 |
| C1 |
| T1 |
| T1 |
| ST FIPS |
|---|
| 01 |
| 01 |
| 09 |
| 17 |
| 17 |
| 18 |
| County FIPS |
|---|
| 133 |
| 133 |
| 003 |
| 043 |
| 043 |
| 145 |
| County Name |
|---|
| Winston |
| Winston |
| Hartford |
| DuPage |
| DuPage |
| Shelby |
| MSA |
|---|
| 3280 |
| 1600 |
| 1600 |
| 3480 |
| County Count |
|---|
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| County Number |
|---|
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
Click here to download a self-extracting file containing sample records in Access 97 format (about 26 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 19 KB).
Available File Formats
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| MS Access 97 | self-extracting | 3.6 MB | ||
| Comma-delimited ASCII | self-extracting | 2.8 MB | ||
| Comma-delimited ASCII | PKZip 2.04g | 2.8 MB | ||
| Comma-delimited ASCII | uncompressed | 12.5 MB |
Licenses
We offer different Licenses for the Place Name Database
- 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 | $99.95 |
| Enterprise License: | $199.95 |
| Duplication Addendum: up to 100 copies unlimited copies |
$399.00 $799.00 |
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. If you place your order via phone, fax or mail we will process your order usually within 1 business day. After we process your order we will send you an email message with the download information. We'll include an invoice which states what you ordered and paid. No shipping and handling charges for Internet delivery. |
||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CDROM: | We'll process and ship your order within one business day. The following shipping and handling charges apply to delivery on CDROM: | ||||||||||||||||||
|
Payment
All orders must be prepaid. We do not accept Purchase Orders. We accept Visa, MasterCard, Discover Card and American Express for online or telephone orders.
We also accept checks and money orders in US funds drawn on a US bank. The payment must include shipping and handling charges, if applicable. Orders which do not include appropriate shipping and handling charges will be delayed. If you need an invoice to submit to your accounting department to have a check cut please contact us at 800-571-3914 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email, fax, or snail mail. However, your order will not be shipped until we receive payment in full.
Attention Texas residents: Orders for delivery to a Texas address, whether downloaded via the Internet or delivered on CDROM, must include sales tax of 6.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 6.25% of the order total will automatically be added to all Texas orders processed through our online ordering system. Tax exempt organizations in Texas must fax a tax exemption certificate to us at 281-292-3608 and should contact us at 800-571-3914 to place their orders. Orders which do not include appropriate sales tax or a valid tax exemption certificate will be delayed.
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
ZIP code Products -
ZIP code Product Search -
About Us -
Home
Sales: sales@zipinfo.com
Support: support@zipinfo.com
Mail: CD Light, LLC, 230 N Tranquil Path Dr, The Woodlands TX 77380-2758
Voice: 800-571-3914 or 281-292-3270
Fax: 281-292-3608