johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where recovered = 348 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3659372 | 3659372 | 2021-07-11 | Canada | Yukon | 461 | 5 | 348 | 108 | 64.2823 | -135.0 | 2021-07-12 04:21:34 | Yukon, Canada | ||
625656 | 625656 | 2021-07-10 | Canada | Yukon | 461 | 5 | 348 | 108 | 64.2823 | -135.0 | 2021-07-11 04:21:43 | Yukon, Canada | ||
829375 | 829375 | 2021-07-09 | Canada | Yukon | 461 | 5 | 348 | 108 | 64.2823 | -135.0 | 2021-07-10 04:21:25 | Yukon, Canada | ||
1125424 | 1125424 | 2021-06-18 | China | Yunnan | 384 | 2 | 348 | 34 | 24.974 | 101.487 | 2021-06-19 04:22:33 | Yunnan, China | ||
2911002 | 2911002 | 2021-06-17 | China | Yunnan | 382 | 2 | 348 | 32 | 24.974 | 101.487 | 2021-06-18 04:22:16 | Yunnan, China | ||
3030120 | 3030120 | 2021-06-16 | China | Yunnan | 380 | 2 | 348 | 30 | 24.974 | 101.487 | 2021-06-17 04:22:36 | Yunnan, China | ||
2339226 | 2339226 | 2021-06-15 | China | Yunnan | 377 | 2 | 348 | 27 | 24.974 | 101.487 | 2021-06-16 04:22:32 | Yunnan, China | ||
1563922 | 1563922 | 2021-06-14 | China | Yunnan | 377 | 2 | 348 | 27 | 24.974 | 101.487 | 2021-06-15 04:22:22 | Yunnan, China | ||
3381205 | 3381205 | 2021-06-13 | China | Yunnan | 376 | 2 | 348 | 26 | 24.974 | 101.487 | 2021-06-14 04:22:46 | Yunnan, China | ||
3397075 | 3397075 | 2021-04-28 | Malaysia | Perlis | 358 | 2 | 348 | 8 | 6.4449 | 100.2048 | 2021-04-29 04:20:55 | Perlis, Malaysia | ||
153797 | 153797 | 2021-01-08 | China | Inner Mongolia | 366 | 1 | 348 | 17 | 44.0935 | 113.9448 | 2021-01-09 05:22:18 | Inner Mongolia, China | ||
1140532 | 1140532 | 2021-01-01 | United Kingdom | Isle of Man | 377 | 25 | 348 | 4 | 54.2361 | -4.5481 | 2021-01-02 05:22:33 | Isle of Man, United Kingdom | ||
3699138 | 3699138 | 2020-12-31 | United Kingdom | Isle of Man | 377 | 25 | 348 | 4 | 54.2361 | -4.5481 | 2021-01-01 05:23:07 | Isle of Man, United Kingdom | ||
1013953 | 1013953 | 2020-12-30 | United Kingdom | Isle of Man | 377 | 25 | 348 | 4 | 54.2361 | -4.5481 | 2020-12-31 05:22:49 | Isle of Man, United Kingdom | ||
3761588 | 3761588 | 2020-12-28 | Japan | Ehime | 431 | 12 | 348 | 71 | 33.624835 | 132.856842 | 2020-12-29 05:22:37 | Ehime, Japan | ||
1901195 | 1901195 | 2020-12-18 | Japan | Niigata | 428 | 3 | 348 | 77 | 37.521819 | 138.918647 | 2020-12-19 05:27:52 | Niigata, Japan | ||
1751316 | 1751316 | 2020-12-14 | Japan | Yamanashi | 454 | 9 | 348 | 97 | 35.612364 | 138.61148899999998 | 2020-12-15 05:26:38 | Yamanashi, Japan | ||
3847836 | 3847836 | 2020-12-13 | Japan | Yamanashi | 451 | 9 | 348 | 94 | 35.612364 | 138.61148899999998 | 2020-12-14 05:26:27 | Yamanashi, Japan | ||
845618 | 845618 | 2020-12-12 | Japan | Yamanashi | 451 | 9 | 348 | 94 | 35.612364 | 138.61148899999998 | 2020-12-13 05:27:20 | Yamanashi, Japan | ||
2978902 | 2978902 | 2020-12-09 | Malaysia | Kelantan | 460 | 4 | 348 | 108 | 6.1254 | 102.2381 | 2020-12-10 05:26:19 | Kelantan, Malaysia | ||
2537587 | 2537587 | 2020-12-01 | Russia | Chukotka Autonomous Okrug | 392 | 3 | 348 | 41 | 66.0006475 | 169.4900869 | 2020-12-02 05:27:41 | Chukotka Autonomous Okrug, Russia | ||
2784732 | 2784732 | 2020-11-13 | Bhutan | 369 | 0 | 348 | 21 | 27.5142 | 90.4336 | 2020-11-14 05:25:37 | Bhutan | |||
2605700 | 2605700 | 2020-10-10 | Malaysia | Kedah | 1653 | 6 | 348 | 1299 | 6.1184 | 100.3685 | 2020-10-11 04:23:46 | Kedah, Malaysia | ||
1045839 | 1045839 | 2020-09-30 | Japan | Miyagi | 406 | 2 | 348 | 56 | 38.446859 | 140.927086 | 2020-10-01 04:23:42 | Miyagi, Japan | ||
1354325 | 1354325 | 2020-09-03 | Japan | Gunma | 463 | 19 | 348 | 96 | 36.504479 | 138.985605 | 2020-09-04 04:28:26 | Gunma, Japan | ||
194103 | 194103 | 2020-08-31 | Japan | Shiga | 450 | 5 | 348 | 97 | 35.21582700000001 | 136.138064 | 2020-09-01 04:28:31 | Shiga, Japan | ||
145982 | 145982 | 2020-08-15 | Japan | Hiroshima | 435 | 3 | 348 | 84 | 34.605309000000005 | 132.788719 | 2020-08-16 04:27:42 | Hiroshima, Japan | ||
1612206 | 1612206 | 2020-08-14 | India | Mizoram | 657 | 0 | 348 | 309 | 23.309381 | 92.83822 | 2020-08-15 04:27:31 | Mizoram, India | ||
3612270 | 3612270 | 2020-08-06 | Canada | Manitoba | 474 | 8 | 348 | 118 | 53.7609 | -98.8139 | 2020-08-07 04:35:11 | Manitoba, Canada | ||
3205231 | 3205231 | 2020-07-18 | Colombia | Huila | 520 | 15 | 348 | 157 | 2.5359 | -75.5277 | 2020-07-19 04:34:58 | Huila, Colombia | ||
2748130 | 2748130 | 2020-07-15 | India | Nagaland | 902 | 0 | 348 | 554 | 26.06702 | 94.470302 | 2020-07-16 04:44:59 | Nagaland, India | ||
2222714 | 2222714 | 2020-07-08 | Japan | Kyoto | 415 | 18 | 348 | 49 | 35.253815 | 135.443341 | 2020-07-09 04:34:23 | Kyoto, Japan | ||
887323 | 887323 | 2020-07-07 | Japan | Kyoto | 413 | 18 | 348 | 47 | 35.253815 | 135.443341 | 2020-07-08 05:33:48 | Kyoto, Japan | ||
2234728 | 2234728 | 2020-07-03 | Russia | Sakhalin Oblast | 885 | 0 | 348 | 537 | 49.7219665 | 143.448533 | 2020-07-04 04:33:51 | Sakhalin Oblast, Russia | ||
3249145 | 3249145 | 2020-06-21 | Pakistan | Azad Jammu and Kashmir | 845 | 20 | 348 | 477 | 34.027401 | 73.947253 | 2020-06-22 04:33:20 | Azad Jammu and Kashmir, Pakistan | ||
1273337 | 1273337 | 2020-06-11 | Ukraine | Cherkasy Oblast | 506 | 19 | 348 | 139 | 49.4444 | 32.0598 | 2020-06-12 05:09:52 | Cherkasy Oblast, Ukraine | ||
2863905 | 2863905 | 2020-06-10 | Ukraine | Khmelnytskyi Oblast | 520 | 14 | 348 | 158 | 49.423 | 26.9871 | 2020-06-11 03:33:41 | Khmelnytskyi Oblast, Ukraine | ||
573946 | 573946 | 2020-06-06 | France | French Guiana | 639 | 1 | 348 | 290 | 4.0 | -53.0 | 2020-06-07 03:53:30 | French Guiana, France | ||
3866740 | 3866740 | 2020-06-03 | Russia | Karachay-Cherkess Republic | 1276 | 5 | 348 | 923 | 43.7368326 | 41.7267991 | 2020-06-04 02:33:14 | Karachay-Cherkess Republic, Russia | ||
2555649 | 2555649 | 2020-06-02 | Italy | Basilicata | 399 | 27 | 348 | 24 | 40.63947052 | 15.80514834 | 2020-06-03 02:33:13 | Basilicata, Italy | ||
1794262 | 1794262 | 2020-05-31 | Somalia | 1976 | 78 | 348 | 1550 | 5.152149 | 46.199616 | 2020-06-01 02:32:46 | Somalia | |||
998083 | 998083 | 2020-05-23 | West Bank and Gaza | 423 | 3 | 348 | 72 | 31.9522 | 35.2332 | 2020-05-24 02:32:43 | West Bank and Gaza | |||
1931998 | 1931998 | 2020-05-05 | Latvia | 896 | 17 | 348 | 531 | 56.8796 | 24.6032 | 2020-05-06 02:32:31 | Latvia | |||
3084861 | 3084861 | 2020-05-04 | Latvia | 896 | 16 | 348 | 532 | 56.8796 | 24.6032 | 2020-05-05 02:32:34 | Latvia | |||
2278720 | 2278720 | 2020-05-03 | Latvia | 879 | 16 | 348 | 515 | 56.8796 | 24.6032 | 2020-05-04 02:32:28 | Latvia | |||
2043396 | 2043396 | 2020-05-02 | Latvia | 871 | 16 | 348 | 507 | 56.8796 | 24.6032 | 2020-05-03 02:32:28 | Latvia | |||
1184290 | 1184290 | 2020-05-01 | Latvia | 870 | 16 | 348 | 506 | 56.8796 | 24.6032 | 2020-05-02 02:32:27 | Latvia | |||
228771 | 228771 | 2020-04-30 | Latvia | 858 | 15 | 348 | 495 | 56.8796 | 24.6032 | 2020-05-01 02:32:28 | Latvia | |||
137517 | 137517 | 2020-04-29 | Latvia | 849 | 15 | 348 | 486 | 56.8796 | 24.6032 | 2020-04-30 02:32:27 | Latvia | |||
271723 | 271723 | 2020-04-28 | Jordan | 449 | 8 | 348 | 93 | 31.24 | 36.51 | 2020-04-29 02:32:29 | Jordan | |||
2567224 | 2567224 | 2020-04-11 | Malaysia | W.P. Kuala Lumpur | 764 | 10 | 348 | 406 | 3.139 | 101.6869 | 2020-04-11 22:45:33 | W.P. Kuala Lumpur, Malaysia | ||
3949996 | 3949996 | 2020-04-09 | Egypt | 1699 | 118 | 348 | 1233 | 26.820553000000004 | 30.802497999999996 | 2020-04-09 23:02:19 | Egypt | |||
3740536 | 3740536 | 2020-04-03 | China | Shanghai | 526 | 6 | 348 | 172 | 31.201999999999998 | 121.4491 | 2020-04-03 06:56:51 | Shanghai, China | ||
1479034 | 1479034 | 2020-03-24 | US | Recovered | 0 | 0 | 348 | 0 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Recovered, US |
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]);