Roger Sage CDL / MELVYL SSH Library Home
SSHL Home Data, Gov't & GIS Home
Social Sciences Data Collection (SSDC)

Record Layout for California Public Use Death Data, 1989-1995:

  • Data Years: 1989-1995
  • Number of records: 1,545,636
  • Record length: 101 (100 data characters + 1 newline character)
  • Format: Rectangular ASCII
RECORD LAYOUT:

Cols.    Record Data Variables:
============================================================
1-2      Year of Death: (YY)
------------------------------------------------------------
3-8      State File Number: 6 digit numeric
------------------------------------------------------------

Cols.    Decedents Data variables:
============================================================
9-20     First Name:  "Blank"=Unknown or Unstated
------------------------------------------------------------
21       Middle Initial:  "Blank"=Unknown or Unstated
------------------------------------------------------------
22-41    Last Name:  "ZZ"=Unknown or Unstated
------------------------------------------------------------
42-50    Social Security Number:  9 digit numeric ("999999999"=unknown)
------------------------------------------------------------
51       Age Group:
------------------------------------------------------------
         0=100+years
         1=Years
         2=Months
         3=Days
         4=Hours
         5=Minutes or Unknown (< 1 year)
         9=Unknown (>= 1 year)
------------------------------------------------------------
52-53    Age Units (Units within Age Group):
------------------------------------------------------------
         Age Group:                    Age Units:
         0 = 100+ years                00-99
         1 = Years                     01-99
         2 = Months                    01-11
         3 = Days                      01-27
         4 = Hours                     01-23
         5 = Minutes                   01-59
         5 = Unknown (< 1 year)           99
         9 = Unknown (>= 1 year)          99
Note: Code 599 (unknown < 1 year) was not used prior to 1994.
-------------------------------------------------------------
54       Century of Birth: (CC)
------------------------------------------------------------
55-60    Date of Birth:  (YYMMDD) "999999"=Unknown
------------------------------------------------------------
61-62    Place of Birth:
------------------------------------------------------------
  AK=Alaska          ME=Maine            TN=Tennessee
  AL=Alabama         MI=Michigan         TX=Texas
  AR=Arkansas        MN=Minnesota        UT=Utah
  AZ=Arizona         MO=Missouri         VA=Virginia
  CA=California      MS=Mississippi      VT=Vermont
  CO=Colorado        MT=Montana          WA=Washington
  CT=Connecticut     NB=Nebraska         WI=Wisconsin
  DC=Washington,DC   NC=North Carolina   WV=West Virginia
  DE=Delaware        ND=North Dakota     WY=Wyoming
  FL=Florida         NH=New Hampshire    CH=China
  GA=Georgia         NJ=New Jersey       CN=Canada
  HI=Hawaii          NM=New Mexico       CU=Cuba
  IA=Iowa            NV=Nevada           GU=Guam
  ID=Idaho           NY=New York         JA=Japan
  IL=Illinois        OH=Ohio             MX=Mexico
  IN=Indiana         OK=Oklahoma         NA=Unknown
  KS=Kansas          OR=Oregon           PI=Phillipines
  KY=Kentucky        PA=Pennsylvania     PR=Puerto Rico
  LA=Louisiana       RI=Rhode Island     RE=Rest of World
  MA=Massachusetts   SC=South Carolina   VI=Virgin Islands
  MD=Maryland        SD=South Dakota     VN=Vietnam
------------------------------------------------------------
63       Gender:
------------------------------------------------------------
         1=Male
         2=Female
------------------------------------------------------------
64-65    Race/Ethnicity:
------------------------------------------------------------
  10=White               51=Other-Specified
  20=Black               52=Asian-Indian
  30=American Indian     53=Filipino
  40=Asian-Unspecified   54=Hawaiian
  41=Asian-Specified     55=Guamanian
  42=Asian-Chinese       56=Samoan
  43=Asian-Japanese      57=Eskimo
  44=Asian-Korean        58=Aleut
  45=Asian-Vietnamese    59=Pacific Islander
                            (excludes Hawaiian, Guamanian, Samoan)
  46=Asian-Cambodian     98=Refused to State
  47=Asian-Thai          99=Unknown
  48=Asian-Laotian

Note:  Code 48 was not used in 1989.
------------------------------------------------------------
66       Hispanic Origin:
------------------------------------------------------------
         1=Not Spanish/Hispanic
         2=Mexican/Mexican-American/Chicano
         3=Puerto Rican
         4=Cuban
         5=Central or South American
         6=Other Spanish/Hispanic (Born Outside U.S.)
         7=Code Not Used
         8=Other Spanish/Hispanic (Born in the U.S.)
         9=Unknown
------------------------------------------------------------
67-68    Highest Grade Completed:
------------------------------------------------------------
         00=None
      01-12=Elementary/High School
         13=1 Year of College
         14=2 Years of College
         15=3 Years of College
         16=4 Years of College
         17=5+ Years of College
         99=Unknown
------------------------------------------------------------
69       Marital Status:
------------------------------------------------------------
         1=Married
         2=Single, Never Married
         3=Annulled (Included with Never Married)
         4=Divorced
         5=Widowed
         9=Unknown
------------------------------------------------------------
70       Military Service:
------------------------------------------------------------
         1=Yes
         2=No
         3=Unknown
------------------------------------------------------------
71-72    Place of Residence:
------------------------------------------------------------
  01=Alameda       23=Mendocino         45=Shasta
  02=Alpine        24=Merced            46=Sierra
  03=Amador        25=Modoc             47=Siskiyou
  04=Butte         26=Mono              48=Solano
  05=Calaveras     27=Monterey          49=Sonoma
  06=Colusa        28=Napa              50=Stanislaus
  07=Contra Costa  29=Nevada            51=Sutter
  08=Del Norte     30=Orange            52=Tehama
  09=El Dorado     31=Placer            53=Trinity
  10=Fresno        32=Plumas            54=Tulare
  11=Glenn         33=Riverside         55=Toulumne
  12=Humboldt      34=Sacramento        56=Ventura
  13=Imperial      35=San Benito        57=Yolo
  14=Inyo          36=San Bernardino    58=Yuba
  15=Kern          37=San Diego         91=Canada
  16=Kings         38=San Francisco     92=Mexico
  17=Lake          39=San Joaquin       93=Other Countries
  18=Lassen        40=San Luis Obispo   94=Guam
  19=Los Angeles   41=San Mateo         95=Puerto Rico
  20=Madera        42=Santa Barbara     96=Virgin Islands
  21=Marin         43=Santa Clara       97=Cuba
  22=Mariposa      44=Santa Cruz        98=Other U.S. States
------------------------------------------------------------
73-77    Zip Code of Residence:  5-Digit Codes "99999"=Unknown
------------------------------------------------------------

Cols.    Death Data:
============================================================
78       Blank
------------------------------------------------------------
79-84    Date of Death:  (YYMMDD)
------------------------------------------------------------
85-88    Underlying Cause of Death:  (ICD 9th Revision)
------------------------------------------------------------
         3-digit ICD's include a
         zero (0) as the 4th digit

         The following 4-digit ICD's
         are not coded beyond three
         digits.  They will also include
         a zero (0) as the 4th digit

         640-641, 643-644, 651-656
         658-669, 671, 673-676

         See the "Cause of Death Codes" file for ICD number,
         group and group number, cause of death.
------------------------------------------------------------
89-90    Underlying Group Cause:  (ICD 9th Revision)

         See the "Cause of Death Codes" file for ICD number,
         group and group number, cause of death.
------------------------------------------------------------
91       Contributing Cause of Death:
------------------------------------------------------------
  N=None                            5=AIDS
  0=Diabetes                        6=Neoplasm
  1=Lung Disease                    7=Sudden Infant Death Syndrome
  2=Lung Disease & Diabetes         8=AIDS & Cancer, AIDS & Diabetes
                                      and/or AIDS & Lung Disease
  3=Lung Disease & Cancer           9=Diabetes & Cancer
  4=Lung Disease, Cancer & Diabetes
------------------------------------------------------------
92       Autopsy Performed:
------------------------------------------------------------
         1=Yes
         2=No
         9=Unknown
------------------------------------------------------------
93       Autopsy Used:
------------------------------------------------------------
         1=Yes
         2=No
         3=No Autopsy
         9=Unknown
------------------------------------------------------------
94       Operation Performed:
------------------------------------------------------------
         1=Yes
         2=No
         9=Unknown
------------------------------------------------------------
95-96    Place of Occurrence:
------------------------------------------------------------
  01=Alameda       23=Mendocino         45=Shasta
  02=Alpine        24=Merced            46=Sierra
  03=Amador        25=Modoc             47=Siskiyou
  04=Butte         26=Mono              48=Solano
  05=Calaveras     27=Monterey          49=Sonoma
  06=Colusa        28=Napa              50=Stanislaus
  07=Contra Costa  29=Nevada            51=Sutter
  08=Del Norte     30=Orange            52=Tehama
  09=El Dorado     31=Placer            53=Trinity
  10=Fresno        32=Plumas            54=Tulare
  11=Glenn         33=Riverside         55=Toulumne
  12=Humboldt      34=Sacramento        56=Ventura
  13=Imperial      35=San Benito        57=Yolo
  14=Inyo          36=San Bernardino    58=Yuba
  15=Kern          37=San Diego         91=Canada
  16=Kings         38=San Francisco     92=Mexico
  17=Lake          39=San Joaquin       93=Other Countries
  18=Lassen        40=San Luis Obispo   94=Guam
  19=Los Angeles   41=San Mateo         95=Puerto Rico
  20=Madera        42=Santa Barbara     96=Virgin Islands
  21=Marin         43=Santa Clara       97=Cuba
  22=Mariposa      44=Santa Cruz        98=Other U.S. States
------------------------------------------------------------
97       Type of Facility:
------------------------------------------------------------
         1=State Licensed General, Except County
         2=State Licensed General, County
         3=State Mental
         4=All Facilities Identified as Nursing Homes, Rest Homes,
           Convalescent Homes, Sanitariums, Etc.
         5=All Other Facilities
         6=Dead on Arrival at any Facility
         7=No Facility Identified, or Out of State
           (Code 7 Only Used in 1989)
         8=Home
         9=Not a California Facility
------------------------------------------------------------
98       Death in Hospital:
------------------------------------------------------------
         1=Inpatient
         2=Emergency/Outpatient
         3=Dead on Arrival
         4=Inapplicable/Non-Hospital
         9=Unknown
------------------------------------------------------------
99       Injured at Work:
------------------------------------------------------------
         1=Yes
         2=No
         3=No Injury
         9=Unknown
------------------------------------------------------------
100      Place of Injury:
------------------------------------------------------------
         N=No Injury
         0=Home
         1=Farm
         2=Mine/Quarry
         3=Industrial Places
         4=Recreation/Sport
         5=Street and Highways
         6=Public Building
         7=Residential Institution
         8=Other Specified Places
         9=Not Specified		
------------------------------------------------------------
101      newline record delimiter
------------------------------------------------------------

ROGER | Sage | CDL/MELVYL | UCSD Home | UCSD Libraries Home

Official Web Page of the University of California, San Diego
© Copyright 2000, UCSD, All Rights Reserved. This site may not be reproduced.
Social Sciences & Humanities Library, 9500 Gilman Drive, La Jolla, CA 92093, 858-534-3336
Email SSDC Webmaster