V1 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10246623 10246626 10246628 10246649 10246652 +5 more | — |
| 2 | SEX | — | — | 2 9 1 | — |
| 3 | LINKNUMBER | — | — | 810123286 810123338 810123356 810123397 810123424 +5 more | — |
| 4 | ETHNICITY | — | — | C S 0 K H +5 more | — |
| 5 | DEATHCAUSECODE_1A | — | — | C349 C798 J22 C189 C159 +5 more | — |
| 6 | DEATHCAUSECODE_1B | — | — | C900 I509,A415 F03 I330 J449 +5 more | — |
| 7 | DEATHCAUSECODE_1C | — | — | I219,I501 I713,Y839 I251 J180 I710 +5 more | — |
| 8 | DEATHCAUSECODE_2 | — | — | I679,I64,I259,C819 N185 J449 J459 F03 +5 more | — |
| 9 | DEATHCAUSECODE_UNDERLYING | — | — | I259 C444 I713 C61 D469 +5 more | — |
| 10 | DEATHLOCATIONCODE | — | — | 1 5 6 3 4 +2 more | — |
| 11 | NEWVITALSTATUS | — | — | A D X | — |
| 12 | VITALSTATUSDATE | — | — | 2016-09-05 2017-04-20 2018-11-18 2019-01-09 2014-12-31 +5 more | — |