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 | — | — | 810000004 810000047 810000073 810000087 810000103 +5 more | — |
| 4 | ETHNICITY | — | — | M B R 8 CA +5 more | — |
| 5 | DEATHCAUSECODE_1A | — | — | C809 C159,C786 R688 K859 N185 +5 more | — |
| 6 | DEATHCAUSECODE_1B | — | — | I309 I269 I259 C809,C349 R13 +5 more | — |
| 7 | DEATHCAUSECODE_1C | — | — | K579 C439 I10,E780 I251 I259 +5 more | — |
| 8 | DEATHCAUSECODE_2 | — | — | I802 I679,J449 M819,E039,I10 E119 I259,E039 +5 more | — |
| 9 | DEATHCAUSECODE_UNDERLYING | — | — | C61 C159 I713 I259 C679 +5 more | — |
| 10 | DEATHLOCATIONCODE | — | — | 5 6 3 4 2 +2 more | — |
| 11 | NEWVITALSTATUS | — | — | A D X | — |
| 12 | VITALSTATUSDATE | — | — | 2016-08-03 2018-06-25 2017-11-03 2018-04-26 2016-12-20 +5 more | — |