Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Political Science: A self-inflicted wound?

Sage Stats and CQ Political Stats Trial

Breaking News: Protect the 2020 Census

The Fastest Growing US Cities Are Mostly In the West

Another rule from NIH: Demographers might get to ignore this one

Data Services Knowledge Base

Q:  

The 1970 natality detail file does not have FIPS codes to identify states and counties. It has NCHS codes. Is there a crosswalk between the two?

A:  

I am not aware of a crosswalk. There is an appendix to the 1970 file that provides the counties associated with each code:

http://ariel.psc.isr.umich.edu/L3/data/s819/s819_1970b.pdf.

If you are interested in just a few counties, you can look up the FIPS codes for those counties from this source:

http://www.census.gov/geo/www/fips/fips65/index.html.

Another source is a list of FIPS codes by states:

http://www.census.gov/geo/www/fips/fips65/data/national.txt.

However, if you are interested in converting all the NCHS codes to FIPS codes, here is some SAS code that does this:

http://www.psc.isr.umich.edu/dis/data/kb/downloads/t1046_nchs2fips.txt)..

Note that the simple algorithm of

FIPS = (NCHS*2) - 1

works for many states as FIPS codes generally follow a pattern of 1, 3, 5, 7 and NCHS codes generally follow this sequence: 1, 2, 3, 4 . . . However, there are many exceptions so the code ends up being about 50 lines long rather than 1 line. The majority of the exceptions are in New York state and Virginia.

There have been changes in FIPS county codes over time. Some counties have been renamed (Dade, Florida to Miami-Dade, Florida), which means a change in FIPS codes from 025 to 086. New counties have been formed (e.g., Broomfield county, Colorado). Thus, depending on what you are trying to do, you may need to be aware of changes in county boundaries over time. The following is a list of significant county changes since 1970 by decade:

http://www.census.gov/geo/www/tiger/ctychng.html.

Direct Links:

Downloads:

Related Question Groups: