V2 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10245798 10245801 10245812 10245834 10245842 +5 more | — |
| 2 | GENDER | — | — | 1 2 9 | — |
| 3 | ETHNICITY | — | — | C S H 0 K +5 more | — |
| 4 | DEATHCAUSECODE_1A | — | — | R688,R54 C189 A419 I219 I724 +5 more | — |
| 5 | DEATHCAUSECODE_1B | — | — | R568 I219,I251 I739 C442,Y836 G255 +5 more | — |
| 6 | DEATHCAUSECODE_1C | — | — | G709 K631 C837 C798,C809 K631,C851 +5 more | — |
| 7 | DEATHCAUSECODE_2 | — | — | I251,I269 C220 F019,C449 D471,I500,N189 I509,J449,I10 +5 more | — |
| 8 | DEATHCAUSECODE_UNDERLYING | — | — | I119 C159 I713 I259 D70 +5 more | — |
| 9 | DEATHLOCATIONCODE | — | — | 1 6 5 4 X +1 more | — |
| 10 | VITALSTATUS | — | — | D5 X X5 D4 X4 +4 more | — |
| 11 | VITALSTATUSDATE | — | — | 2021-11-10 2017-10-12 2021-07-01 2020-11-30 2020-03-30 +5 more | — |
| 12 | LINKNUMBER | — | — | 101708680 101734546 101525714 101734887 101646587 +5 more | — |