daily_reports (view)
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 >30
- US 29,426
- China 7,169
- United Kingdom 4,798
- Canada 2,265
- Japan 1,562
- New Zealand 1,338
- Malaysia 1,227
- Australia 971
- Spain 947
- Nauru 905
- Tuvalu 905
- Ukraine 842
- Korea, North 784
- Antarctica 689
- Winter Olympics 2022 688
- Tonga 586
- India 560
- France 521
- Palau 501
- Summer Olympics 2020 454
- Peru 434
- Kiribati 422
- Colombia 411
- Denmark 410
- Samoa 390
- Chile 385
- Mexico 269
- Belgium 266
- Marshall Islands 249
- Diamond Princess 245
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
2022-09-12 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-13 04:20:57 | Tuvalu | |||
2022-09-12 | New Zealand | Niue | 77 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-13 04:20:57 | Niue, New Zealand | ||
2022-09-12 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-13 04:20:57 | Nauru | |||
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 | ||
2022-09-11 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-12 04:20:58 | Tuvalu | |||
2022-09-11 | New Zealand | Niue | 77 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-12 04:20:58 | Niue, New Zealand | ||
2022-09-11 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-12 04:20:58 | Nauru | |||
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 | ||
2022-09-10 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-11 04:20:50 | Tuvalu | |||
2022-09-10 | New Zealand | Niue | 77 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-11 04:20:50 | Niue, New Zealand | ||
2022-09-10 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-11 04:20:50 | Nauru | |||
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 | ||
2022-09-09 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-10 04:21:10 | Tuvalu | |||
2022-09-09 | New Zealand | Niue | 76 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-10 04:21:10 | Niue, New Zealand | ||
2022-09-09 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-10 04:21:10 | Nauru | |||
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 | ||
2022-09-08 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-09 04:21:11 | Tuvalu | |||
2022-09-08 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-09 04:21:11 | Niue, New Zealand | ||
2022-09-08 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-09 04:21:11 | Nauru | |||
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 | ||
2022-09-07 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-08 04:21:02 | Tuvalu | |||
2022-09-07 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-08 04:21:02 | Niue, New Zealand | ||
2022-09-07 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-08 04:21:02 | Nauru | |||
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 | ||
2022-09-06 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-07 04:20:59 | Tuvalu | |||
2022-09-06 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-07 04:20:59 | Niue, New Zealand | ||
2022-09-06 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-07 04:20:59 | Nauru | |||
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 | ||
2022-09-05 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-06 04:21:02 | Tuvalu | |||
2022-09-05 | New Zealand | Niue | 73 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-06 04:21:02 | Niue, New Zealand | ||
2022-09-05 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-06 04:21:02 | Nauru | |||
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 | ||
2022-09-04 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-05 04:21:01 | Tuvalu | |||
2022-09-04 | New Zealand | Niue | 73 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-05 04:21:01 | Niue, New Zealand | ||
2022-09-04 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-05 04:21:01 | Nauru | |||
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 | ||
2022-09-03 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-04 04:21:22 | Tuvalu | |||
2022-09-03 | New Zealand | Niue | 73 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-04 04:21:22 | Niue, New Zealand | ||
2022-09-03 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-04 04:21:22 | Nauru | |||
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 | ||
2022-09-02 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-03 04:21:04 | Tuvalu | |||
2022-09-02 | New Zealand | Niue | 71 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-03 04:21:04 | Niue, New Zealand | ||
2022-09-02 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-03 04:21:04 | Nauru | |||
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 | ||
2022-09-01 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-02 04:21:07 | Tuvalu | |||
2022-09-01 | New Zealand | Niue | 71 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-02 04:21:07 | Niue, New Zealand | ||
2022-09-01 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-02 04:21:07 | Nauru | |||
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 | ||
2022-08-31 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-01 04:21:03 | Tuvalu | |||
2022-08-31 | New Zealand | Niue | 71 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-01 04:21:03 | Niue, New Zealand | ||
2022-08-31 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-09-01 04:21:03 | Nauru | |||
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 | ||
2022-08-30 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-31 04:20:57 | Tuvalu | |||
2022-08-30 | New Zealand | Niue | 70 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-31 04:20:57 | Niue, New Zealand | ||
2022-08-30 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-31 04:20:57 | Nauru | |||
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 | ||
2022-08-29 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-30 04:21:03 | Tuvalu | |||
2022-08-29 | New Zealand | Niue | 68 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-30 04:21:03 | Niue, New Zealand | ||
2022-08-29 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-30 04:21:03 | Nauru | |||
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 | ||
2022-08-28 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-29 04:21:06 | Tuvalu | |||
2022-08-28 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-29 04:21:06 | Niue, New Zealand | ||
2022-08-28 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-29 04:21:06 | Nauru | |||
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 | ||
2022-08-27 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-28 04:21:02 | Tuvalu | |||
2022-08-27 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-28 04:21:02 | Niue, New Zealand | ||
2022-08-27 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-28 04:21:02 | Nauru | |||
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 | ||
2022-08-26 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-27 04:20:57 | Tuvalu | |||
2022-08-26 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-27 04:20:57 | Niue, New Zealand | ||
2022-08-26 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-27 04:20:57 | Nauru | |||
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 | ||
2022-08-25 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-26 04:21:02 | Tuvalu | |||
2022-08-25 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-26 04:21:02 | Niue, New Zealand | ||
2022-08-25 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-26 04:21:02 | Nauru | |||
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 | ||
2022-08-24 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-25 04:21:13 | Tuvalu | |||
2022-08-24 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-25 04:21:13 | Niue, New Zealand | ||
2022-08-24 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-25 04:21:13 | Nauru | |||
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 | ||
2022-08-23 | Tuvalu | 20 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-24 04:20:46 | Tuvalu | |||
2022-08-23 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-24 04:20:46 | Niue, New Zealand | ||
2022-08-23 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-24 04:20:46 | Nauru | |||
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 | ||
2022-08-22 | Tuvalu | 8 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-23 04:20:56 | Tuvalu | |||
2022-08-22 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-23 04:20:56 | Niue, New Zealand | ||
2022-08-22 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-23 04:20:56 | Nauru | |||
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 | ||
2022-08-21 | Tuvalu | 8 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2022-08-22 04:20:38 | Tuvalu | |||
2022-08-21 | New Zealand | Niue | 60 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-22 04:20:38 | Niue, New Zealand | ||
2022-08-21 | Nauru | 4610 | 1 | 0 | 0 | -0.5228 | 166.9315 | 2022-08-22 04:20:38 | Nauru | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;