johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where recovered = 731 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- Japan 7
- China 3
- Malaysia 3
- Taiwan* 2
- Canada 1
- Costa Rica 1
- Georgia 1
- Lebanon 1
- Mainland China 1
- Uganda 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
400078 | 400078 | 2021-06-29 | China | Jiangsu | 742 | 0 | 731 | 11 | 32.9711 | 119.455 | 2021-06-30 04:21:41 | Jiangsu, China | ||
1580168 | 1580168 | 2021-03-13 | Japan | Kagawa | 765 | 18 | 731 | 16 | 34.217292 | 133.969047 | 2021-03-14 05:25:37 | Kagawa, Japan | ||
435375 | 435375 | 2021-01-21 | Japan | Kochi | 813 | 13 | 731 | 69 | 33.422519 | 133.367307 | 2021-01-22 05:22:10 | Kochi, Japan | ||
3879904 | 3879904 | 2021-01-14 | Taiwan* | 842 | 7 | 731 | 104 | 23.7 | 121.0 | 2021-01-15 05:22:24 | Taiwan* | |||
3308531 | 3308531 | 2021-01-13 | Taiwan* | 842 | 7 | 731 | 104 | 23.7 | 121.0 | 2021-01-14 05:22:32 | Taiwan* | |||
821597 | 821597 | 2020-11-19 | Japan | Nara | 912 | 11 | 731 | 170 | 34.317451 | 135.871644 | 2020-11-20 05:26:28 | Nara, Japan | ||
122742 | 122742 | 2020-11-18 | Japan | Shizuoka | 996 | 4 | 731 | 261 | 34.916975 | 138.40778400000002 | 2020-11-19 05:25:23 | Shizuoka, Japan | ||
3440642 | 3440642 | 2020-11-11 | China | Sichuan | 782 | 3 | 731 | 48 | 30.6171 | 102.7103 | 2020-11-12 05:25:55 | Sichuan, China | ||
1543957 | 1543957 | 2020-11-07 | Japan | Ibaraki | 806 | 18 | 731 | 57 | 36.303588 | 140.319591 | 2020-11-08 05:24:56 | Ibaraki, Japan | ||
757981 | 757981 | 2020-10-28 | Malaysia | Sarawak | 846 | 19 | 731 | 96 | 1.5533 | 110.3592 | 2020-10-29 04:24:49 | Sarawak, Malaysia | ||
1456265 | 1456265 | 2020-10-27 | Malaysia | Sarawak | 819 | 19 | 731 | 69 | 1.5533 | 110.3592 | 2020-10-28 04:24:39 | Sarawak, Malaysia | ||
1053838 | 1053838 | 2020-10-23 | Japan | Ishikawa | 797 | 49 | 731 | 17 | 36.769464 | 136.771027 | 2020-10-24 04:24:46 | Ishikawa, Japan | ||
1177508 | 1177508 | 2020-10-22 | Japan | Ishikawa | 795 | 48 | 731 | 16 | 36.769464 | 136.771027 | 2020-10-23 04:24:46 | Ishikawa, Japan | ||
193838 | 193838 | 2020-08-31 | Canada | Manitoba | 1214 | 14 | 731 | 469 | 53.7609 | -98.8139 | 2020-09-01 04:28:31 | Manitoba, Canada | ||
3923382 | 3923382 | 2020-08-09 | China | Shanghai | 786 | 7 | 731 | 48 | 31.201999999999998 | 121.4491 | 2020-08-10 04:34:55 | Shanghai, China | ||
2625515 | 2625515 | 2020-06-25 | Uganda | 821 | 0 | 731 | 90 | 1.373333 | 32.290275 | 2020-06-26 04:33:43 | Uganda | |||
1196197 | 1196197 | 2020-06-17 | Georgia | 888 | 14 | 731 | 143 | 42.3154 | 43.3569 | 2020-06-18 04:33:18 | Georgia | |||
737822 | 737822 | 2020-06-12 | Costa Rica | 1612 | 12 | 731 | 869 | 9.7489 | -83.7534 | 2020-06-13 03:33:14 | Costa Rica | |||
1281538 | 1281538 | 2020-06-04 | Lebanon | 1306 | 28 | 731 | 547 | 33.8547 | 35.8623 | 2020-06-05 02:33:06 | Lebanon | |||
3589500 | 3589500 | 2020-04-27 | Malaysia | W.P. Kuala Lumpur | 1196 | 15 | 731 | 450 | 3.139 | 101.6869 | 2020-04-28 02:30:51 | W.P. Kuala Lumpur, Malaysia | ||
3551197 | 3551197 | 2020-02-24 | Mainland China | Hunan | 1016 | 4 | 731 | 27.6104 | 111.7088 | 2020-02-24T14:13:11 |
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]);