V2 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10122921 10122935 10122962 10122970 10123031 +5 more | — |
| 2 | GENDER | — | — | 1 2 9 | — |
| 3 | ETHNICITY | — | — | C S H 0 K +5 more | — |
| 4 | DEATHCAUSECODE_1A | — | — | I442 J180 C763 I259 C66 +5 more | — |
| 5 | DEATHCAUSECODE_1B | — | — | R13 K269 I255 A419 G20 +5 more | — |
| 6 | DEATHCAUSECODE_1C | — | — | K566 C61 I489,I259 I739 I259 +5 more | — |
| 7 | DEATHCAUSECODE_2 | — | — | F03,I259,I64 E119,I10 K519 C260,N19 I259 +5 more | — |
| 8 | DEATHCAUSECODE_UNDERLYING | — | — | C61 J180 C679 I259 G122 +5 more | — |
| 9 | DEATHLOCATIONCODE | — | — | 6 5 1 4 X +1 more | — |
| 10 | VITALSTATUS | — | — | X5 D4 X4 X2 A +4 more | — |
| 11 | VITALSTATUSDATE | — | — | 2022-07-05 2021-03-23 2019-06-23 2019-09-17 2016-11-05 +5 more | — |
| 12 | LINKNUMBER | — | — | 100560149 100772820 100635391 101310242 100016427 +5 more | — |