johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where recovered = 1020 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2339221 | 2339221 | 2021-06-15 | China | Sichuan | 1056 | 3 | 1020 | 33 | 30.6171 | 102.7103 | 2021-06-16 04:22:32 | Sichuan, China | ||
3393728 | 3393728 | 2021-04-28 | Timor-Leste | 2124 | 3 | 1020 | 1101 | -8.874217 | 125.727539 | 2021-04-29 04:20:55 | Timor-Leste | |||
1409091 | 1409091 | 2021-04-23 | Japan | Yamanashi | 1117 | 19 | 1020 | 78 | 35.612364 | 138.61148899999998 | 2021-04-24 04:20:38 | Yamanashi, Japan | ||
1408812 | 1408812 | 2021-04-23 | Canada | Newfoundland and Labrador | 1053 | 6 | 1020 | 27 | 53.1355 | -57.6604 | 2021-04-24 04:20:38 | Newfoundland and Labrador, Canada | ||
2983586 | 2983586 | 2021-04-10 | Taiwan* | 1056 | 10 | 1020 | 26 | 23.7 | 121.0 | 2021-04-11 04:20:56 | Taiwan* | |||
241481 | 241481 | 2021-04-02 | Russia | Nenets Autonomous Okrug | 1087 | 4 | 1020 | 63 | 68.27557185 | 57.1686375 | 2021-04-03 04:20:44 | Nenets Autonomous Okrug, Russia | ||
1936250 | 1936250 | 2021-02-23 | China | Beijing | 1047 | 9 | 1020 | 18 | 40.1824 | 116.4142 | 2021-02-24 05:29:16 | Beijing, China | ||
2677639 | 2677639 | 2021-02-13 | China | Hunan | 1033 | 4 | 1020 | 9 | 27.6104 | 111.7088 | 2021-02-14 05:23:43 | Hunan, China | ||
3539272 | 3539272 | 2021-02-12 | China | Hunan | 1033 | 4 | 1020 | 9 | 27.6104 | 111.7088 | 2021-02-13 05:22:12 | Hunan, China | ||
2637535 | 2637535 | 2021-02-11 | China | Hunan | 1033 | 4 | 1020 | 9 | 27.6104 | 111.7088 | 2021-02-12 05:23:29 | Hunan, China | ||
3978622 | 3978622 | 2021-02-10 | Japan | Wakayama | 1118 | 16 | 1020 | 82 | 33.911879 | 135.505446 | 2021-02-11 05:23:55 | Wakayama, Japan | ||
3978390 | 3978390 | 2021-02-10 | China | Hunan | 1033 | 4 | 1020 | 9 | 27.6104 | 111.7088 | 2021-02-11 05:23:55 | Hunan, China | ||
3157260 | 3157260 | 2021-01-27 | United Kingdom | Turks and Caicos Islands | 1312 | 8 | 1020 | 284 | 21.694000000000006 | -71.7979 | 2021-01-28 05:22:24 | Turks and Caicos Islands, United Kingdom | ||
15995 | 15995 | 2021-01-26 | United Kingdom | Turks and Caicos Islands | 1312 | 8 | 1020 | 284 | 21.694000000000006 | -71.7979 | 2021-01-27 05:23:41 | Turks and Caicos Islands, United Kingdom | ||
845590 | 845590 | 2020-12-12 | Japan | Kumamoto | 1227 | 13 | 1020 | 194 | 32.608154 | 130.74523100000002 | 2020-12-13 05:27:20 | Kumamoto, Japan | ||
821549 | 821549 | 2020-11-19 | Italy | Basilicata | 5883 | 101 | 1020 | 4762 | 40.63947052 | 15.80514834 | 2020-11-20 05:26:28 | Basilicata, Italy | ||
1826440 | 1826440 | 2020-10-04 | Vietnam | 1096 | 35 | 1020 | 41 | 14.058324 | 108.277199 | 2020-10-05 04:23:33 | Vietnam | |||
2517824 | 2517824 | 2020-10-03 | Vietnam | 1096 | 35 | 1020 | 41 | 14.058324 | 108.277199 | 2020-10-04 04:23:44 | Vietnam | |||
3393042 | 3393042 | 2020-10-02 | Vietnam | 1096 | 35 | 1020 | 41 | 14.058324 | 108.277199 | 2020-10-03 04:23:40 | Vietnam | |||
1121364 | 1121364 | 2020-09-17 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-18 05:05:00 | Nova Scotia, Canada | ||
666053 | 666053 | 2020-09-16 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-17 04:22:00 | Nova Scotia, Canada | ||
2728778 | 2728778 | 2020-09-15 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-16 04:22:53 | Nova Scotia, Canada | ||
344050 | 344050 | 2020-09-14 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-15 03:22:50 | Nova Scotia, Canada | ||
2868489 | 2868489 | 2020-09-13 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-14 04:26:00 | Nova Scotia, Canada | ||
546528 | 546528 | 2020-09-12 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-13 04:30:52 | Nova Scotia, Canada | ||
98777 | 98777 | 2020-08-04 | Malaysia | Negeri Sembilan | 1030 | 8 | 1020 | 2 | 2.7258 | 101.9424 | 2020-08-05 04:34:43 | Negeri Sembilan, Malaysia | ||
1511032 | 1511032 | 2020-06-22 | Tunisia | 1159 | 50 | 1020 | 89 | 33.886917 | 9.537499 | 2020-06-23 04:33:22 | Tunisia | |||
1510854 | 1510854 | 2020-06-22 | Russia | Vologda Oblast | 1445 | 16 | 1020 | 409 | 60.0391461 | 43.1215213 | 2020-06-23 04:33:22 | Vologda Oblast, Russia | ||
3249771 | 3249771 | 2020-06-21 | Tunisia | 1157 | 50 | 1020 | 87 | 33.886917 | 9.537499 | 2020-06-22 04:33:20 | Tunisia | |||
1837340 | 1837340 | 2020-06-14 | Ukraine | Ternopil Oblast | 1427 | 26 | 1020 | 381 | 49.5535 | 25.5948 | 2020-06-15 03:33:14 | Ternopil Oblast, Ukraine | ||
3061025 | 3061025 | 2020-06-13 | Italy | Calabria | 1162 | 97 | 1020 | 45 | 38.90597598 | 16.59440194 | 2020-06-14 03:33:15 | Calabria, Italy | ||
1790532 | 1790532 | 2020-05-29 | Italy | Valle d'Aosta | 1182 | 143 | 1020 | 19 | 45.73750286 | 7.320149366 | 2020-05-30 02:32:48 | Valle d'Aosta, Italy | ||
2712386 | 2712386 | 2020-05-28 | Mexico | Tamaulipas | 1441 | 97 | 1020 | 324 | 24.2669 | -98.8363 | 2020-05-29 02:32:50 | Tamaulipas, Mexico |
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]);