V2 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10122921 10122935 10122962 10122966 10122970 +5 more | — |
| 2 | GENDER | — | — | 1 2 9 | — |
| 3 | ETHNICITY | — | — | B R M 8 CA +5 more | — |
| 4 | DEATHCAUSECODE_1A | — | — | C798 I259 C679 K566 C159 +5 more | — |
| 5 | DEATHCAUSECODE_1B | — | — | R568 I219,I251 I739 C442,Y836 G255 +5 more | — |
| 6 | DEATHCAUSECODE_1C | — | — | I639 C911 K20,K929 J111 T810,Y848,C349 +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 | — | — | 4 X 2 1 6 +1 more | — |
| 10 | VITALSTATUS | — | — | X5 D4 X4 X2 D5 +4 more | — |
| 11 | VITALSTATUSDATE | — | — | 2016-12-24 2021-07-07 2020-08-12 2021-04-11 2019-07-27 +5 more | — |
| 12 | LINKNUMBER | — | — | 100693032 100223631 101427257 100635676 101136394 +5 more | — |