V1 av_patient
2,200,625 rows · 12 columns
| PATIENTID | SEX | LINKNUMBER | ETHNICITY | DEATHCAUSECODE_1A | DEATHCAUSECODE_1B | DEATHCAUSECODE_1C | DEATHCAUSECODE_2 | DEATHCAUSECODE_UNDERLYING | DEATHLOCATIONCODE | NEWVITALSTATUS | VITALSTATUSDATE |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40157804 | 2 | 840157804 | A | J189 | C349 | null | null | C349 | 1 | D | 2017-09-04 |
| 130001067 | 2 | 930001067 | A | null | null | null | null | null | null | A | 2019-02-08 |
| 40172677 | 2 | 840172677 | A | C321 | null | null | null | C349 | 4 | D | 2017-09-15 |
| 130026004 | 2 | 930026004 | C | null | null | null | null | null | null | A | 2019-02-09 |
| 130025747 | 2 | 930025747 | C | null | null | null | null | null | null | D | 2018-09-10 |
| 130004816 | 2 | 930004816 | A | null | null | null | null | null | null | A | 2019-02-07 |
| 130005740 | 2 | 930005740 | P | null | null | null | null | null | null | A | 2019-02-08 |
| 130005448 | 2 | 930005448 | A | null | null | null | null | null | null | A | 2019-02-09 |
| 40173676 | 2 | 840173676 | A | null | null | null | null | null | null | D | 2017-11-27 |
| 130004400 | 2 | 930004400 | A | null | null | null | null | null | null | A | 2019-02-06 |
| 130023583 | 2 | 930023583 | A | null | null | null | null | null | null | A | 2019-02-06 |
| 130023878 | 2 | 930023878 | A | null | null | null | null | null | null | A | 2019-02-08 |
| 130021573 | 2 | 930021573 | A | null | null | null | null | null | null | A | 2019-02-06 |
| 130026005 | 2 | 930026005 | C | null | null | null | null | null | null | A | 2019-02-08 |
| 130001825 | 2 | 930001825 | A | null | null | null | null | null | null | A | 2019-02-06 |
| 130024988 | 2 | 930024988 | A | C541 | null | C541 | null | C541 | 1 | A | 2019-02-09 |
| 40173892 | 2 | 840173892 | A | C349 | null | null | I259,E119,C509 | C349 | 2 | D | 2015-06-02 |
| 120012924 | 2 | 920012924 | A | C679 | null | null | null | C679 | 4 | A | 2019-02-08 |
| 120006576 | 2 | 920006576 | Z | C679 | null | null | F019 | I64 | 1 | D | 2017-04-06 |
| 130006309 | 2 | 930006309 | H | null | null | null | null | null | null | D | 2015-04-24 |
| 130004582 | 2 | 930004582 | A | C541,C779 | null | null | null | C541 | 2 | A | 2019-02-09 |
| 120035231 | 2 | 920035231 | A | C679 | I469 | null | E119 | C679 | 2 | A | 2019-02-09 |
| 130001826 | 2 | 930001826 | A | null | null | null | null | null | null | A | 2019-02-09 |
| 130026668 | 2 | 930026668 | A | null | null | null | null | null | null | A | 2019-02-07 |
| 40172737 | 2 | 840172737 | A | C349 | null | null | null | C349 | 2 | D | 2013-03-10 |
| 130001239 | 2 | 930001239 | A | C541 | null | null | null | C541 | 4 | A | 2019-02-08 |
| 130024708 | 2 | 930024708 | A | C541 | null | null | null | C800 | 2 | A | 2019-02-09 |
| 130022494 | 2 | 930022494 | A | C541 | null | null | null | C541 | 2 | A | 2019-02-08 |
| 130025547 | 2 | 930025547 | J | null | null | null | null | null | null | A | 2019-02-09 |
| 130004474 | 2 | 930004474 | A | null | null | null | null | null | null | D | 2016-10-24 |
| 40160603 | 2 | 840160603 | A | J189 | null | null | F03,G20 | C349 | 1 | D | 2016-06-23 |
| 130006861 | 2 | 930006861 | J | null | null | null | null | null | null | A | 2019-02-06 |
| 120008945 | 2 | 920008945 | D | null | null | null | null | null | null | D | 2015-06-08 |
| 120006293 | 2 | 920006293 | A | R54 | C80 | null | I259,M316,C679 | C679 | 1 | A | 2019-02-08 |
| 120006235 | 2 | 920006235 | A | C679 | C680 | null | G459,I10 | C679 | 4 | D | 2016-05-16 |
| 40173090 | 2 | 840173090 | A | C349 | null | null | null | I219 | 4 | D | 2016-01-04 |
| 120011384 | 2 | 920011384 | A | C679 | C679 | null | J449 | C679 | 4 | A | 2019-02-09 |
| 130026669 | 2 | 930026669 | A | null | null | null | null | null | null | A | 2019-02-09 |
| 130005449 | 2 | 930005449 | A | null | null | null | null | null | null | A | 2019-02-08 |
| 130024989 | 2 | 930024989 | A | null | null | null | null | null | null | A | 2019-02-09 |
| 130021642 | 2 | 930021642 | A | null | null | null | null | null | null | D | 2015-05-12 |
| 120031149 | 2 | 920031149 | A | I64 | null | null | null | I110 | 5 | D | 2015-09-09 |
| 120010951 | 2 | 920010951 | A | C679,I802 | null | null | null | C679 | X | D | 2013-05-16 |
| 130004371 | 2 | 930004371 | A | null | null | null | null | null | null | A | 2019-02-06 |
| 130001827 | 2 | 930001827 | A | null | null | null | null | null | null | A | 2019-02-09 |
| 120013007 | 2 | 920013007 | A | null | null | null | null | null | null | D | 2017-09-17 |
| 120006220 | 2 | 920006220 | A | C679 | null | null | null | C689 | 2 | A | 2016-06-30 |
| 120034966 | 2 | 920034966 | A | C679,C780,C798,C795 | null | null | Q059,I802 | C679 | 4 | D | 2015-10-01 |
| 130024468 | 2 | 930024468 | A | null | null | null | null | null | null | A | 2019-02-09 |
| 130024558 | 2 | 930024558 | A | I269 | null | null | null | C55 | 4 | A | 2019-02-09 |