V1 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10000125 10000170 10000188 10000201 10000223 +5 more | — |
| 2 | SEX | — | — | 1 2 9 | — |
| 3 | LINKNUMBER | — | — | 810246561 810246672 810246697 810246761 810246785 +5 more | — |
| 4 | ETHNICITY | — | — | B R M 8 CA +5 more | — |
| 5 | DEATHCAUSECODE_1A | — | — | G309 C798,C800 J969,J988 R54,R688 C349 +5 more | — |
| 6 | DEATHCAUSECODE_1B | — | — | I059,I251 J90 J449 F03 I219 +5 more | — |
| 7 | DEATHCAUSECODE_1C | — | — | I259 K562 I251 I709 K746 +5 more | — |
| 8 | DEATHCAUSECODE_2 | — | — | E119 I679 C509,N189,E119 E875,N179 K631 +5 more | — |
| 9 | DEATHCAUSECODE_UNDERLYING | — | — | I259 C444 I713 C61 D469 +5 more | — |
| 10 | DEATHLOCATIONCODE | — | — | 1 4 2 X 5 +2 more | — |
| 11 | NEWVITALSTATUS | — | — | D X A | — |
| 12 | VITALSTATUSDATE | — | — | 2016-09-05 2017-04-20 2018-11-18 2019-01-09 2014-12-31 +5 more | — |