V1 av_patient
Column details, descriptions, and lookup mappings
| # | Column | Description | Null % | Sample Values | Lookup |
|---|---|---|---|---|---|
| 1 | PATIENTID | — | — | 10293269 10293305 10293388 10293419 10293471 +5 more | — |
| 2 | SEX | — | — | 1 2 9 | — |
| 3 | LINKNUMBER | — | — | 810123248 810123392 810123411 810123455 810123466 +5 more | — |
| 4 | ETHNICITY | — | — | B 8 M R CA +5 more | — |
| 5 | DEATHCAUSECODE_1A | — | — | I259 J180 D70,A419 A403 K631 +5 more | — |
| 6 | DEATHCAUSECODE_1B | — | — | J22 I489 C189 I500 I119,N189 +5 more | — |
| 7 | DEATHCAUSECODE_1C | — | — | C55 J449 I219 F03 N185,Y841 +5 more | — |
| 8 | DEATHCAUSECODE_2 | — | — | C61 I259 J449,J47 C449,S325,X590 E119 +5 more | — |
| 9 | DEATHCAUSECODE_UNDERLYING | — | — | C831 G309 I713 C509 I259 +5 more | — |
| 10 | DEATHLOCATIONCODE | — | — | 1 X 4 2 5 +2 more | — |
| 11 | NEWVITALSTATUS | — | — | D X A | — |
| 12 | VITALSTATUSDATE | — | — | 2019-02-09 2019-02-07 2018-01-29 2019-01-23 2018-01-03 +5 more | — |