V2 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10245765 10245826 10245832 10245844 10245885 +5 more | — |
| 2 | GENDER | — | — | 1 2 9 | — |
| 3 | ETHNICITY | — | — | B M R 8 CA +5 more | — |
| 4 | DEATHCAUSECODE_1A | — | — | C798 I259 C679 K566 C159 +5 more | — |
| 5 | DEATHCAUSECODE_1B | — | — | R13 K269 I255 A419 G20 +5 more | — |
| 6 | DEATHCAUSECODE_1C | — | — | R688,R54 G08,E119 K561 K631 C56 +5 more | — |
| 7 | DEATHCAUSECODE_2 | — | — | C180,I259 C189 E119,N183,I489 C187 K861,N189,C189 +5 more | — |
| 8 | DEATHCAUSECODE_UNDERLYING | — | — | C800 K746 C189 I639 I776 +5 more | — |
| 9 | DEATHLOCATIONCODE | — | — | 5 6 2 X 4 +1 more | — |
| 10 | VITALSTATUS | — | — | D5 X A D D3 +4 more | — |
| 11 | VITALSTATUSDATE | — | — | 2022-07-05 2021-07-22 2018-08-22 2021-01-12 2020-05-28 +5 more | — |
| 12 | LINKNUMBER | — | — | 100651203 100758357 101324463 101679943 101704798 +5 more | — |