johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63,127 rows where active = 0 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2020409 | 2020409 | 2022-09-20 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-21 04:23:22 | Pitcairn Islands, United Kingdom | ||
3574282 | 3574282 | 2022-09-19 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-20 04:22:48 | Pitcairn Islands, United Kingdom | ||
423021 | 423021 | 2022-09-18 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-19 04:21:49 | Pitcairn Islands, United Kingdom | ||
3377045 | 3377045 | 2022-09-17 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-18 04:22:50 | Pitcairn Islands, United Kingdom | ||
2359153 | 2359153 | 2022-09-16 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-17 04:20:19 | Pitcairn Islands, United Kingdom | ||
3990310 | 3990310 | 2022-09-15 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-16 04:21:19 | Pitcairn Islands, United Kingdom | ||
1892827 | 1892827 | 2022-09-14 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-15 04:21:02 | Pitcairn Islands, United Kingdom | ||
2398487 | 2398487 | 2022-09-12 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-13 04:20:57 | Pitcairn Islands, United Kingdom | ||
2398486 | 2398486 | 2022-09-12 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-13 04:20:57 | Tuvalu | |||
2398485 | 2398485 | 2022-09-12 | New Zealand | Niue | 77 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-13 04:20:57 | Niue, New Zealand | ||
2398484 | 2398484 | 2022-09-12 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-13 04:20:57 | Nauru | |||
3769565 | 3769565 | 2022-09-11 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-12 04:20:58 | Pitcairn Islands, United Kingdom | ||
3769564 | 3769564 | 2022-09-11 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-12 04:20:58 | Tuvalu | |||
3769563 | 3769563 | 2022-09-11 | New Zealand | Niue | 77 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-12 04:20:58 | Niue, New Zealand | ||
3769562 | 3769562 | 2022-09-11 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-12 04:20:58 | Nauru | |||
3828140 | 3828140 | 2022-09-10 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-11 04:20:50 | Pitcairn Islands, United Kingdom | ||
3828139 | 3828139 | 2022-09-10 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-11 04:20:50 | Tuvalu | |||
3828138 | 3828138 | 2022-09-10 | New Zealand | Niue | 77 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-11 04:20:50 | Niue, New Zealand | ||
3828137 | 3828137 | 2022-09-10 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-11 04:20:50 | Nauru | |||
966597 | 966597 | 2022-09-09 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-10 04:21:10 | Pitcairn Islands, United Kingdom | ||
966596 | 966596 | 2022-09-09 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-10 04:21:10 | Tuvalu | |||
966595 | 966595 | 2022-09-09 | New Zealand | Niue | 76 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-10 04:21:10 | Niue, New Zealand | ||
966594 | 966594 | 2022-09-09 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-10 04:21:10 | Nauru | |||
256999 | 256999 | 2022-09-08 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-09 04:21:11 | Pitcairn Islands, United Kingdom | ||
256998 | 256998 | 2022-09-08 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-09 04:21:11 | Tuvalu | |||
256997 | 256997 | 2022-09-08 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-09 04:21:11 | Niue, New Zealand | ||
256996 | 256996 | 2022-09-08 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-09 04:21:11 | Nauru | |||
3748797 | 3748797 | 2022-09-07 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-08 04:21:02 | Pitcairn Islands, United Kingdom | ||
3748796 | 3748796 | 2022-09-07 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-08 04:21:02 | Tuvalu | |||
3748795 | 3748795 | 2022-09-07 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-08 04:21:02 | Niue, New Zealand | ||
3748794 | 3748794 | 2022-09-07 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-08 04:21:02 | Nauru | |||
118437 | 118437 | 2022-09-06 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-07 04:20:59 | Pitcairn Islands, United Kingdom | ||
118436 | 118436 | 2022-09-06 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-07 04:20:59 | Tuvalu | |||
118435 | 118435 | 2022-09-06 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-07 04:20:59 | Niue, New Zealand | ||
118434 | 118434 | 2022-09-06 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-07 04:20:59 | Nauru | |||
2637409 | 2637409 | 2022-09-05 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-06 04:21:02 | Pitcairn Islands, United Kingdom | ||
2637408 | 2637408 | 2022-09-05 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-06 04:21:02 | Tuvalu | |||
2637407 | 2637407 | 2022-09-05 | New Zealand | Niue | 73 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-06 04:21:02 | Niue, New Zealand | ||
2637406 | 2637406 | 2022-09-05 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-06 04:21:02 | Nauru | |||
2990973 | 2990973 | 2022-09-04 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-05 04:21:01 | Pitcairn Islands, United Kingdom | ||
2990972 | 2990972 | 2022-09-04 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-05 04:21:01 | Tuvalu | |||
2990971 | 2990971 | 2022-09-04 | New Zealand | Niue | 73 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-05 04:21:01 | Niue, New Zealand | ||
2990970 | 2990970 | 2022-09-04 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-05 04:21:01 | Nauru | |||
2716658 | 2716658 | 2022-09-03 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-04 04:21:22 | Pitcairn Islands, United Kingdom | ||
2716657 | 2716657 | 2022-09-03 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-04 04:21:22 | Tuvalu | |||
2716656 | 2716656 | 2022-09-03 | New Zealand | Niue | 73 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-04 04:21:22 | Niue, New Zealand | ||
2716655 | 2716655 | 2022-09-03 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-04 04:21:22 | Nauru | |||
1397363 | 1397363 | 2022-09-02 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-03 04:21:04 | Pitcairn Islands, United Kingdom | ||
1397362 | 1397362 | 2022-09-02 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-03 04:21:04 | Tuvalu | |||
1397361 | 1397361 | 2022-09-02 | New Zealand | Niue | 71 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-03 04:21:04 | Niue, New Zealand | ||
1397360 | 1397360 | 2022-09-02 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-03 04:21:04 | Nauru | |||
3551192 | 3551192 | 2022-09-01 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-02 04:21:07 | Pitcairn Islands, United Kingdom | ||
3551191 | 3551191 | 2022-09-01 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-02 04:21:07 | Tuvalu | |||
3551190 | 3551190 | 2022-09-01 | New Zealand | Niue | 71 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-02 04:21:07 | Niue, New Zealand | ||
3551189 | 3551189 | 2022-09-01 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-02 04:21:07 | Nauru | |||
2347112 | 2347112 | 2022-08-31 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-01 04:21:03 | Pitcairn Islands, United Kingdom | ||
2347111 | 2347111 | 2022-08-31 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-01 04:21:03 | Tuvalu | |||
2347110 | 2347110 | 2022-08-31 | New Zealand | Niue | 71 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-01 04:21:03 | Niue, New Zealand | ||
2347109 | 2347109 | 2022-08-31 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-01 04:21:03 | Nauru | |||
3777592 | 3777592 | 2022-08-30 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-31 04:20:57 | Pitcairn Islands, United Kingdom | ||
3777591 | 3777591 | 2022-08-30 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-31 04:20:57 | Tuvalu | |||
3777590 | 3777590 | 2022-08-30 | New Zealand | Niue | 70 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-31 04:20:57 | Niue, New Zealand | ||
3777589 | 3777589 | 2022-08-30 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-31 04:20:57 | Nauru | |||
1684188 | 1684188 | 2022-08-29 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-30 04:21:03 | Pitcairn Islands, United Kingdom | ||
1684187 | 1684187 | 2022-08-29 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-30 04:21:03 | Tuvalu | |||
1684186 | 1684186 | 2022-08-29 | New Zealand | Niue | 68 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-30 04:21:03 | Niue, New Zealand | ||
1684185 | 1684185 | 2022-08-29 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-30 04:21:03 | Nauru | |||
1880672 | 1880672 | 2022-08-28 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-29 04:21:06 | Pitcairn Islands, United Kingdom | ||
1880671 | 1880671 | 2022-08-28 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-29 04:21:06 | Tuvalu | |||
1880670 | 1880670 | 2022-08-28 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-29 04:21:06 | Niue, New Zealand | ||
1880669 | 1880669 | 2022-08-28 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-29 04:21:06 | Nauru | |||
2099799 | 2099799 | 2022-08-27 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-28 04:21:02 | Pitcairn Islands, United Kingdom | ||
2099798 | 2099798 | 2022-08-27 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-28 04:21:02 | Tuvalu | |||
2099797 | 2099797 | 2022-08-27 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-28 04:21:02 | Niue, New Zealand | ||
2099796 | 2099796 | 2022-08-27 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-28 04:21:02 | Nauru | |||
1535614 | 1535614 | 2022-08-26 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-27 04:20:57 | Pitcairn Islands, United Kingdom | ||
1535613 | 1535613 | 2022-08-26 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-27 04:20:57 | Tuvalu | |||
1535612 | 1535612 | 2022-08-26 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-27 04:20:57 | Niue, New Zealand | ||
1535611 | 1535611 | 2022-08-26 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-27 04:20:57 | Nauru | |||
2832501 | 2832501 | 2022-08-25 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-26 04:21:02 | Pitcairn Islands, United Kingdom | ||
2832500 | 2832500 | 2022-08-25 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-26 04:21:02 | Tuvalu | |||
2832499 | 2832499 | 2022-08-25 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-26 04:21:02 | Niue, New Zealand | ||
2832498 | 2832498 | 2022-08-25 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-26 04:21:02 | Nauru | |||
2327034 | 2327034 | 2022-08-24 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-25 04:21:13 | Pitcairn Islands, United Kingdom | ||
2327033 | 2327033 | 2022-08-24 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-25 04:21:13 | Tuvalu | |||
2327032 | 2327032 | 2022-08-24 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-25 04:21:13 | Niue, New Zealand | ||
2327031 | 2327031 | 2022-08-24 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-25 04:21:13 | Nauru | |||
1254443 | 1254443 | 2022-08-23 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-24 04:20:46 | Pitcairn Islands, United Kingdom | ||
1254442 | 1254442 | 2022-08-23 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-24 04:20:46 | Tuvalu | |||
1254441 | 1254441 | 2022-08-23 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-24 04:20:46 | Niue, New Zealand | ||
1254440 | 1254440 | 2022-08-23 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-24 04:20:46 | Nauru | |||
2856547 | 2856547 | 2022-08-22 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-23 04:20:56 | Pitcairn Islands, United Kingdom | ||
2856546 | 2856546 | 2022-08-22 | Tuvalu | 8 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-23 04:20:56 | Tuvalu | |||
2856545 | 2856545 | 2022-08-22 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-23 04:20:56 | Niue, New Zealand | ||
2856544 | 2856544 | 2022-08-22 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-23 04:20:56 | Nauru | |||
2406519 | 2406519 | 2022-08-21 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-22 04:20:38 | Pitcairn Islands, United Kingdom | ||
2406518 | 2406518 | 2022-08-21 | Tuvalu | 8 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-22 04:20:38 | Tuvalu | |||
2406517 | 2406517 | 2022-08-21 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-22 04:20:38 | Niue, New Zealand | ||
2406516 | 2406516 | 2022-08-21 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-22 04:20:38 | Nauru | |||
3801597 | 3801597 | 2022-08-20 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-21 04:20:44 | Pitcairn Islands, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);