V2 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10250740 10250755 10250756 10250763 10250777 +5 more | — |
| 2 | GENDER | — | — | 1 2 9 | — |
| 3 | ETHNICITY | — | — | R M B CA 8 +5 more | — |
| 4 | DEATHCAUSECODE_1A | — | — | G20,F03 R688,R54,R418 I639 R048 I259,J189 +5 more | — |
| 5 | DEATHCAUSECODE_1B | — | — | C349 K550 J189 I489 I10,I251 +5 more | — |
| 6 | DEATHCAUSECODE_1C | — | — | L039,A491 I219 W19 J441 A498 +5 more | — |
| 7 | DEATHCAUSECODE_2 | — | — | C61 I259 C61,E119 C61,I10,I489 C679 +5 more | — |
| 8 | DEATHCAUSECODE_UNDERLYING | — | — | G309 C444 I259 K566 I739 +5 more | — |
| 9 | DEATHLOCATIONCODE | — | — | 1 5 6 4 2 +1 more | — |
| 10 | VITALSTATUS | — | — | D5 X X4 X5 D4 +4 more | — |
| 11 | VITALSTATUSDATE | — | — | 2022-07-05 2018-06-01 2016-06-12 2022-03-16 2020-05-02 +5 more | — |
| 12 | LINKNUMBER | — | — | 101710236 100384047 100450575 101856224 101792460 +5 more | — |