johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where recovered = 531 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- China 4
- Japan 3
- Saint Kitts and Nevis 2
- Ukraine 2
- Albania 1
- Bulgaria 1
- Denmark 1
- India 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306423 | 1306423 | 2021-07-27 | Saint Kitts and Nevis | 578 | 3 | 531 | 44 | 17.357822 | -62.782998 | 2021-07-28 04:21:39 | Saint Kitts and Nevis | |||
3218566 | 3218566 | 2021-07-26 | Saint Kitts and Nevis | 573 | 3 | 531 | 39 | 17.357822 | -62.782998 | 2021-07-27 04:21:18 | Saint Kitts and Nevis | |||
1736546 | 1736546 | 2021-06-12 | Japan | Shimane | 549 | 0 | 531 | 18 | 35.07076 | 132.55406399999998 | 2021-06-13 04:22:44 | Shimane, Japan | ||
3049998 | 3049998 | 2021-02-16 | China | Shaanxi | 547 | 3 | 531 | 13 | 35.1917 | 108.8701 | 2021-02-17 05:23:10 | Shaanxi, China | ||
1338097 | 1338097 | 2021-02-15 | China | Shaanxi | 547 | 3 | 531 | 13 | 35.1917 | 108.8701 | 2021-02-16 05:24:38 | Shaanxi, China | ||
2283248 | 2283248 | 2021-02-14 | China | Shaanxi | 545 | 3 | 531 | 11 | 35.1917 | 108.8701 | 2021-02-15 05:24:49 | Shaanxi, China | ||
3978379 | 3978379 | 2021-02-10 | China | Fujian | 548 | 1 | 531 | 16 | 26.0789 | 117.9874 | 2021-02-11 05:23:55 | Fujian, China | ||
2545048 | 2545048 | 2021-01-07 | United Kingdom | Bermuda | 636 | 11 | 531 | 94 | 32.3078 | -64.7505 | 2021-01-08 05:22:42 | Bermuda, United Kingdom | ||
3777780 | 3777780 | 2020-12-27 | Denmark | Faroe Islands | 579 | 0 | 531 | 48 | 61.8926 | -6.9118 | 2020-12-28 05:22:06 | Faroe Islands, Denmark | ||
2606053 | 2606053 | 2020-09-24 | Japan | Nara | 551 | 9 | 531 | 11 | 34.317451 | 135.871644 | 2020-09-25 04:23:00 | Nara, Japan | ||
3161629 | 3161629 | 2020-09-06 | Japan | Gifu | 564 | 10 | 531 | 23 | 35.778671 | 137.055925 | 2020-09-07 04:28:30 | Gifu, Japan | ||
61824 | 61824 | 2020-07-23 | India | Chandigarh | 800 | 13 | 531 | 256 | 30.733839 | 76.76827800000002 | 2020-07-24 05:30:40 | Chandigarh, India | ||
2306464 | 2306464 | 2020-06-28 | Ukraine | Kirovohrad Oblast | 646 | 31 | 531 | 84 | 48.5079 | 32.2623 | 2020-06-29 04:33:44 | Kirovohrad Oblast, Ukraine | ||
1210774 | 1210774 | 2020-06-09 | Ukraine | Lviv Oblast | 2211 | 73 | 531 | 1607 | 49.8397 | 24.0297 | 2020-06-10 04:07:00 | Lviv Oblast, Ukraine | ||
1404519 | 1404519 | 2020-05-14 | Bulgaria | 2100 | 99 | 531 | 1470 | 42.7339 | 25.4858 | 2020-05-15 02:33:02 | Bulgaria | |||
2278628 | 2278628 | 2020-05-03 | Albania | 795 | 31 | 531 | 233 | 41.1533 | 20.1683 | 2020-05-04 02:32:28 | Albania |
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]);