johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where recovered = 561 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- China 11
- Japan 6
- Colombia 2
- Cyprus 2
- Bolivia 1
- Canada 1
- Italy 1
- Jordan 1
- Mainland China 1
- Malaysia 1
- Niger 1
- Ukraine 1
- United Kingdom 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371548 | 2371548 | 2021-07-20 | Japan | Shimane | 608 | 2 | 561 | 45 | 35.07076 | 132.55406399999998 | 2021-07-21 04:21:40 | Shimane, Japan | ||
954666 | 954666 | 2021-04-25 | China | Fujian | 590 | 1 | 561 | 28 | 26.0789 | 117.9874 | 2021-04-26 04:21:04 | Fujian, China | ||
3923813 | 3923813 | 2021-04-24 | China | Fujian | 589 | 1 | 561 | 27 | 26.0789 | 117.9874 | 2021-04-25 04:20:32 | Fujian, China | ||
1408844 | 1408844 | 2021-04-23 | China | Fujian | 586 | 1 | 561 | 24 | 26.0789 | 117.9874 | 2021-04-24 04:20:38 | Fujian, China | ||
1567907 | 1567907 | 2021-04-22 | China | Fujian | 586 | 1 | 561 | 24 | 26.0789 | 117.9874 | 2021-04-23 04:20:52 | Fujian, China | ||
2571500 | 2571500 | 2021-04-13 | China | Shaanxi | 578 | 3 | 561 | 14 | 35.1917 | 108.8701 | 2021-04-14 04:20:41 | Shaanxi, China | ||
36251 | 36251 | 2021-04-12 | China | Shaanxi | 578 | 3 | 561 | 14 | 35.1917 | 108.8701 | 2021-04-13 04:20:37 | Shaanxi, China | ||
3883410 | 3883410 | 2021-04-11 | China | Shaanxi | 578 | 3 | 561 | 14 | 35.1917 | 108.8701 | 2021-04-12 04:21:00 | Shaanxi, China | ||
2983078 | 2983078 | 2021-04-10 | China | Shaanxi | 576 | 3 | 561 | 12 | 35.1917 | 108.8701 | 2021-04-11 04:20:56 | Shaanxi, China | ||
3085315 | 3085315 | 2021-04-05 | Japan | Iwate | 705 | 30 | 561 | 114 | 39.593287 | 141.361777 | 2021-04-06 04:20:32 | Iwate, Japan | ||
2367313 | 2367313 | 2021-02-28 | China | Jilin | 573 | 3 | 561 | 9 | 43.6661 | 126.1923 | 2021-03-01 05:23:01 | Jilin, China | ||
3065815 | 3065815 | 2021-02-27 | China | Jilin | 573 | 3 | 561 | 9 | 43.6661 | 126.1923 | 2021-02-28 05:22:20 | Jilin, China | ||
1136913 | 1136913 | 2021-01-01 | Japan | Oita | 700 | 6 | 561 | 133 | 33.200697 | 131.43323999999998 | 2021-01-02 05:22:33 | Oita, Japan | ||
3695260 | 3695260 | 2020-12-31 | Canada | New Brunswick | 599 | 9 | 561 | 29 | 46.5653 | -66.4619 | 2021-01-01 05:23:07 | New Brunswick, Canada | ||
1010350 | 1010350 | 2020-12-30 | Japan | Wakayama | 607 | 7 | 561 | 39 | 33.911879 | 135.505446 | 2020-12-31 05:22:49 | Wakayama, Japan | ||
3769884 | 3769884 | 2020-12-22 | Japan | Fukushima | 758 | 11 | 561 | 186 | 37.378867 | 140.223295 | 2020-12-23 05:22:03 | Fukushima, Japan | ||
3990589 | 3990589 | 2020-10-20 | Italy | Basilicata | 1313 | 39 | 561 | 713 | 40.63947052 | 15.80514834 | 2020-10-21 04:24:14 | Basilicata, Italy | ||
2812598 | 2812598 | 2020-09-25 | Colombia | Guaviare | 742 | 12 | 561 | 169 | 1.0654 | -73.2603 | 2020-09-26 04:23:00 | Guaviare, Colombia | ||
669924 | 669924 | 2020-09-16 | United Kingdom | Turks and Caicos Islands | 659 | 5 | 561 | 93 | 21.694 | -71.7979 | 2020-09-17 04:22:00 | Turks and Caicos Islands, United Kingdom | ||
582862 | 582862 | 2020-08-13 | Japan | Okinawa | 1397 | 10 | 561 | 826 | 25.768923 | 126.668016 | 2020-08-14 04:51:19 | Okinawa, Japan | ||
1503252 | 1503252 | 2020-07-25 | Malaysia | Sarawak | 649 | 18 | 561 | 70 | 1.5533 | 110.3592 | 2020-07-26 04:35:00 | Sarawak, Malaysia | ||
2684873 | 2684873 | 2020-07-06 | Ukraine | Kirovohrad Oblast | 659 | 32 | 561 | 66 | 48.5079 | 32.2623 | 2020-07-07 04:34:00 | Kirovohrad Oblast, Ukraine | ||
1195735 | 1195735 | 2020-06-17 | Colombia | Cundinamarca | 1835 | 46 | 561 | 1228 | 5.026 | -74.03 | 2020-06-18 04:33:18 | Cundinamarca, Colombia | ||
1273656 | 1273656 | 2020-06-11 | China | Sichuan | 582 | 3 | 561 | 18 | 30.6171 | 102.7103 | 2020-06-12 05:09:52 | Sichuan, China | ||
3867084 | 3867084 | 2020-06-03 | Jordan | 757 | 9 | 561 | 187 | 31.24 | 36.51 | 2020-06-04 02:33:14 | Jordan | |||
1864973 | 1864973 | 2020-05-22 | Cyprus | 923 | 17 | 561 | 345 | 35.1264 | 33.4299 | 2020-05-23 02:32:42 | Cyprus | |||
268479 | 268479 | 2020-05-21 | Cyprus | 922 | 17 | 561 | 344 | 35.1264 | 33.4299 | 2020-05-22 02:36:51 | Cyprus | |||
268458 | 268458 | 2020-05-21 | Bolivia | 5187 | 215 | 561 | 4411 | -16.2902 | -63.5887 | 2020-05-22 02:36:51 | Bolivia | |||
2110985 | 2110985 | 2020-05-06 | Niger | 770 | 38 | 561 | 171 | 17.607789 | 8.081666 | 2020-05-07 02:32:28 | Niger | |||
2524984 | 2524984 | 2020-04-23 | Uzbekistan | 1758 | 7 | 561 | 1190 | 41.377491 | 64.585262 | 2020-04-24 03:30:31 | Uzbekistan | |||
1720046 | 1720046 | 2020-02-19 | Mainland China | Hunan | 1008 | 4 | 561 | 27.6104 | 111.7088 | 2020-02-19T11:33:02 |
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]);