V1 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10539716 10539729 10539782 10539783 10539877 +5 more | — |
| 2 | SEX | — | — | 2 9 1 | — |
| 3 | LINKNUMBER | — | — | 810246484 810246518 810246523 810246529 810246538 +5 more | — |
| 4 | ETHNICITY | — | — | S C 0 H K +5 more | — |
| 5 | DEATHCAUSECODE_1A | — | — | I259 J180 D70,A419 A403 K631 +5 more | — |
| 6 | DEATHCAUSECODE_1B | — | — | G931 C349 J961,S141,V892 I489 C482 +5 more | — |
| 7 | DEATHCAUSECODE_1C | — | — | C809 I330 R688 J449 C819 +5 more | — |
| 8 | DEATHCAUSECODE_2 | — | — | I802 I679,J449 M819,E039,I10 E119 I259,E039 +5 more | — |
| 9 | DEATHCAUSECODE_UNDERLYING | — | — | C509 G309 J180 K566 I711 +5 more | — |
| 10 | DEATHLOCATIONCODE | — | — | 1 4 2 X 5 +2 more | — |
| 11 | NEWVITALSTATUS | — | — | A D X | — |
| 12 | VITALSTATUSDATE | — | — | 2019-02-09 2019-02-07 2018-01-29 2019-01-23 2018-01-03 +5 more | — |