Mortality multiple cause data layouts — mortality

Metadata tables describing the fixed-width file layout for US mortality multiple cause datasets from the CDC NCHS. Each object covers one data year and contains the column positions, types, and code mappings needed to parse the corresponding fixed-width file.

data_mortality_multiple_1968

data_mortality_multiple_1969

data_mortality_multiple_1970

data_mortality_multiple_1971

data_mortality_multiple_1972

data_mortality_multiple_1973

data_mortality_multiple_1974

data_mortality_multiple_1975

data_mortality_multiple_1976

data_mortality_multiple_1977

data_mortality_multiple_1978

data_mortality_multiple_1979

data_mortality_multiple_1980

data_mortality_multiple_1981

data_mortality_multiple_1982

data_mortality_multiple_1983

data_mortality_multiple_1984

data_mortality_multiple_1985

data_mortality_multiple_1986

data_mortality_multiple_1987

data_mortality_multiple_2010

data_mortality_multiple_2011

data_mortality_multiple_2012

data_mortality_multiple_2013

data_mortality_multiple_2014

data_mortality_multiple_2015

data_mortality_multiple_2016

data_mortality_multiple_2017

data_mortality_multiple_2018

data_mortality_multiple_2019

data_mortality_multiple_2020

data_mortality_multiple_2021

data_mortality_multiple_2022

data_mortality_multiple_2024

data_mortality_multiple_2003

data_mortality_multiple_2004

data_mortality_multiple_2005

data_mortality_multiple_2006

data_mortality_multiple_2007

data_mortality_multiple_2008

data_mortality_multiple_2009

data_mortality_multiple_2023

Format

A tibble with 7 variables:

name: Column name
start: Start position in fixed-width file
end: End position in fixed-width file
size: Field width in characters
type: Data type: "int" or "str"
description: Human-readable field description
codes: Pipe-delimited key=label pairs for coded fields, empty string if none

An object of class tbl_df (inherits from tbl, data.frame) with 43 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 99 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 101 rows and 6 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 106 rows and 6 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 107 rows and 6 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 108 rows and 6 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 106 rows and 6 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 88 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 56 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 17 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 16 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 88 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 89 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 94 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 89 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 91 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 107 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 88 rows and 7 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 91 rows and 7 columns.

Source

https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Datasets/DVS/mortality/

Note

This is an early year with limited coding — several fields left blank.

1968-1978 all use the same user guide. We only make data_mortality_multiple_1969 because its a funny number.

Both 1989 and 2003 education revision fields are present. Bridged-race variables are the only race summary fields; race_recode_40 is absent.

Occupation and industry fields are absent. method_of_disposition uses a simplified code set (Burial, Cremation, Other, Unknown only).

Both education revision fields are present, though the 1989 field is blank in practice as all states completed the 2003 transition this year.

race_recode_40 is introduced alongside the existing bridged-race variables. Occupation and industry fields are absent.

Layout is structurally identical to 2018. Five records were corrected in a March 2021 re-release, recoding erroneous terrorism firearm deaths to X95.

method_of_disposition retains the simplified code set from 2017–2018; occupation and industry fields are absent.

Occupation and industry fields are introduced for the first time, with data from 46 participating states coded to 2012 Census classifications via NIOSH.

This is the first year in which COVID-19 (U07.1) appears as a cause of death and is included as a rankable cause in the recode lists.

The record_type field is introduced at position 19. The 1989 education revision field is removed, as is the full bridged-race variable block.

race_recode_40 is now the sole race summary field, using the 1997 OMB standard. Occupation and industry fields are retained.

Layout follows the 2021 structure with record_type, 2003-only education, and race_recode_40 as the sole race summary field.

Occupation and industry fields are retained.

Layout follows the 2021–2022 structure with record_type, 2003-only education, and race_recode_40 as the sole race summary field.

Occupation and industry fields are retained.

Geographic identifiers are present: positions 21–60 contain state, county, and city of both occurrence and residence, PMSA/MSA, CMSA, and place of birth. This detail was removed from public-use files from 2005 onward per NCHS data access policy.

Both 1989 and 2003 education revision fields are present alongside an education_reporting_flag indicating which revision was used.

record_type is present at position 19. marital_status includes code N (not on certificate). Occupation and industry fields are absent.

Layout is structurally identical to 2003, retaining full geographic detail in positions 21–60 and dual education revision fields.

record_type is present at position 19. marital_status includes code N (not on certificate). Occupation and industry fields are absent.

Geographic identifiers were removed from the public-use file this year per a new NCHS data access policy. Positions 1–19 and 21–60 are reserved (blank). The record_type field is absent from 2005 onward.

marital_status code N (not on certificate) is removed. Both 1989 and 2003 education revision fields are retained. Occupation and industry fields are absent.

Layout is structurally identical to 2005. Geographic identifiers remain excluded per NCHS data access policy.

Both education revision fields are present. Occupation and industry fields are absent.

Layout is structurally identical to 2005–2006. Geographic identifiers remain excluded per NCHS data access policy.

Both education revision fields are present. Occupation and industry fields are absent.

Layout is structurally identical to 2005–2007. Geographic identifiers remain excluded per NCHS data access policy.

Both education revision fields are present. Occupation and industry fields are absent.

Layout is structurally identical to 2005–2008. Geographic identifiers remain excluded per NCHS data access policy.

Both education revision fields are present. Occupation and industry fields are absent.

This year introduced a revised race classification schema.

Additional cause of death fields were added to the layout this year.