Data Dictionary for US Population Data on CD#2

File Format

  • Fixed length ASCII text records (28 bytes)
  • One population per record/line
  • Windows (CR/LF) line delimiters
  • All numeric data is zero filled to the left
Variable Name and Values Start Column Length Data Type
Year
(1973, 1974, 1975...)
1
4
numeric
State postal abbreviation
5
2
character
State FIPS code
7
2
numeric
County FIPS code
9
3
numeric
Registry
01 = San Francisco-Oakland SMSA
02 = Connecticut
20 = Detroit (Metropolitan)
21 = Hawaii
22 = Iowa
23 = New Mexico
25 = Seattle (Puget Sound)
26 = Utah
27 = Atlanta (Metropolitan)
29 = Alaska Natives
31 = San Jose-Monterey
35 = Los Angeles
37 = Rural Georgia
41 = California excluding SF/SJM/LA
42 = Kentucky
43 = Louisiana
44 = New Jersey
12
2
numeric
Race*
1973+ data:
1 = White
2 = Black
3 = Other
1992+ and 2000+ data:
1 = White
2 = Black
3 = American Indian/Alaska Native
4 = Asian or Pacific Islander
14
1
numeric
Origin
Applicable to 1992+ data:
0 = Non-Hispanic
1 = Hispanic
9 = Not applicable in 1973+ W,B,O file
15
1
numeric
Sex
1 = Male
2 = Female
16
1
numeric
Age
19 Age group data:
00 = 0 years
01 = 1-4 years
02 = 5-9 years
03 = 10-14 years
04 = 15-19 years
17 = 80-84 years
18 = 85+ years
Single age data:
00 = 0 years
01 = 1 years
02 = 2 years
84 = 84 years
85 = 85+ years
17
2
numeric
Population
19
10.1
numeric (e.g. 12345678.9)