Congressional District Database for the 112th Congress (May 2012 data)
This Congressional District Database includes the congressional district code, city name, city Place FIPS, county name, county FIPS code, state code and state FIPS code for every zip+4 in the entire USA!
Description
The CD Light, LLC Congressional District Database lists the current congressional district of the 112th Congress for each zip+4 (9-digit zipcode) defined by the US Postal Service. The 150 MB compressed database comes on a single CD-ROM. The database consists of 55 ASCII files, one for each of the 50 states, plus Washington DC, Puerto Rico, US Virgin Islands, American Samoa, and Guam.
We update every record in Congressional District Database monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely zipcode data from any other source! We license our zipcode data directly from the US Postal Service, and collect and cross-check all the other data continuously from a variety of sources.
Each of the 55 files is compressed using PKZIP V2.04g. Uncompressed, the database amounts to more than 4GB.
Included with the Congressional District Database is the Congressional District Cross-Reference Database. This ASCII file lists the name, state, district, and telephone number for all 540 Members of Congress (435 members plus 5 delegates of the House and 100 members of the Senate).
The database also includes a file containing a list of all the states and territories, with the 2-digit state FIPS code assigned to each by the US Government.
Record Layout
Each state file is formatted as a variable number of ASCII text records. Each record contains exactly eight comma-separated text fields, defined
as follows:
| Field | Type | Content | ||
|---|---|---|---|---|
| ZIP+4 | Fixed length ASCII | nnnnn-nnnn | ||
| Preferred City Name | Variable length ASCII | 28 alphanumeric maximum | ||
| City Place FIPS | Fixed length ASCII | 5 numeric characters | ||
| County Name | Variable length ASCII | 25 alphanumeric maximum | ||
| County FIPS | Fixed length ASCII | 5 numeric characters | ||
| State Code | Fixed length ASCII | 2 alpha characters | ||
| State FIPS | Fixed length ASCII | 2 numeric characters | ||
| Congressional District | Fixed length ASCII | 2 numeric characters |
All fields are treated as text fields, but the fields are NOT quote delimited, to conserve file space. Fields do not contain embedded commas. For numeric fields, leading zeroes are retained in all cases. This prevents problems importing the data into database programs.
In each record, the fields contain data relating to the particular zip+4 identified by the zip+4 field. All data but the city Place FIPS code comes from the US Postal Service's national address database.
The city Place FIPS code comes from the Census Bureau Place FIPS file, which does not always agree with US Postal Service naming and spelling for a given place name. Where no matching city Place FIPS code can be determined, the city FIPS code is set to 00000.
The County FIPS code is a 5-digit numeric field containing a unique numeric identification assigned to each county by the US government. The county FIPS code is actually a 3-digit code, but most people prefer to combine the 2-digit state FIPS code with the 3-digit county FIPS code to yield a 5-digit code which can be used to uniquely identify each county in the USA. Note that the state FIPS code is repeated in a separate field.
For states with only a single congressional district, the congressional district is shown as 00.
Each record ends in an ASCII CR-LF pair.
Click here to download a self-extracting file containing sample records in Access 2003 format (about 24 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 16 KB).
File Format:
Comma-separated ASCII file format.
Requirements:
If you want to decompress all 55 files you need at least 4GB of free space on your hard disk. CD-ROM drive. WinZip or WinZip.
Licenses:
We offer different Licenses for the Congressional District 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 Congressional District Database outside your company.
| May 2012 data | Quarterly* Subscription save up to 62% |
Monthly** Subscription save up to 68% |
|
|---|---|---|---|
| Workstation License: | $299.00 | $499.00 | $1,249.00 |
| Enterprise License: | $399.00 | $599.00 | $1,499.00 |
| Duplication Addendum: up to 100 copies unlimited copies |
$799.00 $1,599.00 |
$1,199.00 $2,399.00 |
$2,999.00 $5,999.00 |
* Quarterly subscription: You'll receive the latest Congressional District database every three months for a full year, starting with May 2012.
** Monthly subscription: You'll receive the latest Congressional District database every month for a full year, starting with May 2012.
Prices subject to change without notice.
Delivery:
| CD-ROM: | This product is available only on CD-ROM. Normally we process and ship all orders within 1 business day using the shipping method you chose. The following shipping and handling charges apply: | ||||||||||||||||||
|
Payment
All orders must be prepaid. We accept Visa, MasterCard, Discover Card and American Express. We also accept checks and money orders in US funds drawn on a US bank. The payment must include sales tax for Texas residents as well as shipping and handling charges.
30-Day Money-Back Guarantee
We back Congressional District Database with our 30-Day Money-Back Guarantee. If you are not satisfied with Congressional District Database we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about
us
Order Information - Product Catalog - About Us - Contact Us - Home