daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where recovered = 429 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-28 | Japan | Shimane | 529 | 0 | 429 | 100 | 35.07076 | 132.55406399999998 | 2021-05-29 04:20:41 | Shimane, Japan | ||
2021-02-02 | Japan | Fukui | 517 | 20 | 429 | 68 | 35.846614 | 136.22465400000002 | 2021-02-03 05:22:52 | Fukui, Japan | ||
2020-11-21 | Russia | Nenets Autonomous Okrug | 621 | 0 | 429 | 192 | 68.27557185 | 57.1686375 | 2020-11-22 05:25:45 | Nenets Autonomous Okrug, Russia | ||
2020-11-07 | China | Shaanxi | 472 | 3 | 429 | 40 | 35.1917 | 108.8701 | 2020-11-08 05:24:56 | Shaanxi, China | ||
2020-11-06 | Eritrea | 484 | 0 | 429 | 55 | 15.1794 | 39.7823 | 2020-11-07 05:24:52 | Eritrea | |||
2020-11-05 | Eritrea | 484 | 0 | 429 | 55 | 15.1794 | 39.7823 | 2020-11-06 05:24:55 | Eritrea | |||
2020-10-01 | Denmark | Faroe Islands | 472 | 0 | 429 | 43 | 61.8926 | -6.9118 | 2020-10-02 04:23:51 | Faroe Islands, Denmark | ||
2020-09-30 | Denmark | Faroe Islands | 467 | 0 | 429 | 38 | 61.8926 | -6.9118 | 2020-10-01 04:23:42 | Faroe Islands, Denmark | ||
2020-09-15 | Italy | Basilicata | 618 | 28 | 429 | 161 | 40.63947052 | 15.80514834 | 2020-09-16 04:22:53 | Basilicata, Italy | ||
2020-09-14 | Italy | Basilicata | 613 | 28 | 429 | 156 | 40.63947052 | 15.80514834 | 2020-09-15 03:22:50 | Basilicata, Italy | ||
2020-09-13 | Italy | Basilicata | 613 | 28 | 429 | 156 | 40.63947052 | 15.80514834 | 2020-09-14 04:26:00 | Basilicata, Italy | ||
2020-08-20 | Italy | Molise | 507 | 23 | 429 | 55 | 41.55774754 | 14.65916051 | 2020-08-21 04:27:41 | Molise, Italy | ||
2020-08-19 | Italy | Molise | 503 | 23 | 429 | 51 | 41.55774754 | 14.65916051 | 2020-08-20 04:27:43 | Molise, Italy | ||
2020-08-18 | Italy | Molise | 496 | 23 | 429 | 44 | 41.55774754 | 14.65916051 | 2020-08-19 04:27:00 | Molise, Italy | ||
2020-08-17 | Italy | Molise | 487 | 23 | 429 | 35 | 41.55774754 | 14.65916051 | 2020-08-18 04:27:56 | Molise, Italy | ||
2020-08-16 | Italy | Molise | 487 | 23 | 429 | 35 | 41.55774754 | 14.65916051 | 2020-08-17 04:27:20 | Molise, Italy | ||
2020-08-15 | Italy | Molise | 487 | 23 | 429 | 35 | 41.55774754 | 14.65916051 | 2020-08-16 04:27:42 | Molise, Italy | ||
2020-07-27 | Ukraine | Mykolaiv Oblast | 559 | 13 | 429 | 117 | 46.975 | 31.9946 | 2020-07-28 04:58:43 | Mykolaiv Oblast, Ukraine | ||
2020-07-26 | Ukraine | Mykolaiv Oblast | 546 | 13 | 429 | 104 | 46.975 | 31.9946 | 2020-07-27 04:35:02 | Mykolaiv Oblast, Ukraine | ||
2020-07-25 | Ukraine | Mykolaiv Oblast | 539 | 12 | 429 | 98 | 46.975 | 31.9946 | 2020-07-26 04:35:00 | Mykolaiv Oblast, Ukraine | ||
2020-07-16 | Colombia | Risaralda | 833 | 22 | 429 | 382 | 5.3158 | -75.9928 | 2020-07-17 04:34:50 | Risaralda, Colombia | ||
2020-06-21 | Mexico | Zacatecas | 695 | 72 | 429 | 194 | 22.7709 | -102.5832 | 2020-06-22 04:33:20 | Zacatecas, Mexico | ||
2020-06-06 | Taiwan* | 443 | 7 | 429 | 7 | 23.7 | 121.0 | 2020-06-07 03:53:30 | Taiwan* | |||
2020-06-05 | Taiwan* | 443 | 7 | 429 | 7 | 23.7 | 121.0 | 2020-06-06 02:33:00 | Taiwan* | |||
2020-06-05 | Russia | Novgorod Oblast | 1588 | 9 | 429 | 1150 | 58.2843833 | 32.516975699999996 | 2020-06-06 02:33:00 | Novgorod Oblast, Russia | ||
2020-05-27 | Mexico | Queretaro | 786 | 89 | 429 | 268 | 20.5888 | -100.3899 | 2020-05-28 02:32:31 | Queretaro, Mexico | ||
2020-05-05 | Australia | South Australia | 438 | 4 | 429 | 5 | -34.9285 | 138.6007 | 2020-05-06 02:32:31 | South Australia, Australia | ||
2020-04-07 | Pakistan | 4035 | 57 | 429 | 3549 | 30.3753 | 69.3451 | 2020-04-07 23:04:29 | Pakistan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;