johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where recovered = 216 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- Australia 35
- China 8
- Russia 6
- United Kingdom 6
- Japan 5
- Colombia 4
- Mainland China 2
- Ukraine 2
- Burma 1
- Costa Rica 1
- Egypt 1
- Kyrgyzstan 1
- Malaysia 1
- Mexico 1
- Rwanda 1
- Timor-Leste 1
- Tunisia 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
241588 | 241588 | 2021-04-02 | Timor-Leste | 677 | 0 | 216 | 461 | -8.874217 | 125.727539 | 2021-04-03 04:20:44 | Timor-Leste | |||
1684502 | 1684502 | 2021-02-02 | Japan | Akita | 262 | 3 | 216 | 43 | 39.748679 | 140.408228 | 2021-02-03 05:22:52 | Akita, Japan | ||
2864546 | 2864546 | 2021-01-06 | China | Yunnan | 230 | 2 | 216 | 12 | 24.974 | 101.487 | 2021-01-07 05:22:03 | Yunnan, China | ||
3034133 | 3034133 | 2021-01-05 | China | Yunnan | 230 | 2 | 216 | 12 | 24.974 | 101.487 | 2021-01-06 05:22:16 | Yunnan, China | ||
1061678 | 1061678 | 2021-01-04 | China | Yunnan | 230 | 2 | 216 | 12 | 24.974 | 101.487 | 2021-01-05 05:21:49 | Yunnan, China | ||
3773564 | 3773564 | 2020-12-22 | Malaysia | W.P. Putrajaya | 240 | 2 | 216 | 22 | 2.9264 | 101.6964 | 2020-12-23 05:22:03 | W.P. Putrajaya, Malaysia | ||
1034393 | 1034393 | 2020-12-15 | Japan | Kochi | 404 | 4 | 216 | 184 | 33.422519 | 133.367307 | 2020-12-16 05:28:04 | Kochi, Japan | ||
1009935 | 1009935 | 2020-12-06 | United Kingdom | Bermuda | 288 | 9 | 216 | 63 | 32.3078 | -64.7505 | 2020-12-07 05:26:14 | Bermuda, United Kingdom | ||
1635944 | 1635944 | 2020-12-05 | United Kingdom | Bermuda | 288 | 9 | 216 | 63 | 32.3078 | -64.7505 | 2020-12-06 05:26:18 | Bermuda, United Kingdom | ||
3863472 | 3863472 | 2020-12-04 | United Kingdom | Bermuda | 278 | 9 | 216 | 53 | 32.3078 | -64.7505 | 2020-12-05 05:27:36 | Bermuda, United Kingdom | ||
78730 | 78730 | 2020-12-03 | United Kingdom | Bermuda | 272 | 9 | 216 | 47 | 32.3078 | -64.7505 | 2020-12-04 05:27:27 | Bermuda, United Kingdom | ||
1972413 | 1972413 | 2020-11-25 | China | Shanxi | 220 | 0 | 216 | 4 | 37.5777 | 112.2922 | 2020-11-26 05:27:44 | Shanxi, China | ||
864995 | 864995 | 2020-11-12 | Russia | Nenets Autonomous Okrug | 550 | 0 | 216 | 334 | 68.27557185 | 57.1686375 | 2020-11-13 05:25:30 | Nenets Autonomous Okrug, Russia | ||
3304385 | 3304385 | 2020-11-02 | Russia | Chukotka Autonomous Okrug | 243 | 2 | 216 | 25 | 66.0006475 | 169.4900869 | 2020-11-03 06:00:16 | Chukotka Autonomous Okrug, Russia | ||
3409634 | 3409634 | 2020-11-01 | Russia | Chukotka Autonomous Okrug | 243 | 2 | 216 | 25 | 66.0006475 | 169.4900869 | 2020-11-02 05:25:04 | Chukotka Autonomous Okrug, Russia | ||
2080123 | 2080123 | 2020-10-31 | Russia | Chukotka Autonomous Okrug | 241 | 2 | 216 | 23 | 66.0006475 | 169.4900869 | 2020-11-01 04:36:19 | Chukotka Autonomous Okrug, Russia | ||
3483951 | 3483951 | 2020-10-26 | United Kingdom | Cayman Islands | 239 | 1 | 216 | 22 | 19.3133 | -81.2546 | 2020-10-27 04:24:45 | Cayman Islands, United Kingdom | ||
344124 | 344124 | 2020-09-14 | Colombia | Guainia | 349 | 9 | 216 | 124 | 2.5854 | -68.5247 | 2020-09-15 03:22:50 | Guainia, Colombia | ||
2171377 | 2171377 | 2020-09-09 | China | Tianjin | 233 | 3 | 216 | 14 | 39.3054 | 117.323 | 2020-09-10 04:29:01 | Tianjin, China | ||
1243586 | 1243586 | 2020-09-08 | China | Tianjin | 233 | 3 | 216 | 14 | 39.3054 | 117.323 | 2020-09-09 04:28:48 | Tianjin, China | ||
2059927 | 2059927 | 2020-09-01 | Japan | Wakayama | 230 | 4 | 216 | 10 | 33.911879 | 135.505446 | 2020-09-02 04:28:25 | Wakayama, Japan | ||
193782 | 193782 | 2020-08-31 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-09-01 04:28:31 | Tasmania, Australia | ||
3931876 | 3931876 | 2020-08-30 | Colombia | Guaviare | 265 | 1 | 216 | 48 | 1.0654 | -73.2603 | 2020-08-31 04:28:27 | Guaviare, Colombia | ||
3931741 | 3931741 | 2020-08-30 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-31 04:28:27 | Tasmania, Australia | ||
609403 | 609403 | 2020-08-29 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-30 04:28:22 | Tasmania, Australia | ||
1522898 | 1522898 | 2020-08-28 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-29 04:28:19 | Tasmania, Australia | ||
2513820 | 2513820 | 2020-08-27 | United Kingdom | Gibraltar | 272 | 0 | 216 | 56 | 36.1408 | -5.3536 | 2020-08-28 04:28:11 | Gibraltar, United Kingdom | ||
2509899 | 2509899 | 2020-08-27 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-28 04:28:11 | Tasmania, Australia | ||
1996359 | 1996359 | 2020-08-26 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-27 04:28:15 | Tasmania, Australia | ||
3562283 | 3562283 | 2020-08-25 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-26 04:28:11 | Tasmania, Australia | ||
2990987 | 2990987 | 2020-08-24 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-25 04:28:02 | Tasmania, Australia | ||
2215382 | 2215382 | 2020-08-23 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-24 04:27:56 | Tasmania, Australia | ||
2299164 | 2299164 | 2020-08-22 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-23 04:27:48 | Tasmania, Australia | ||
1479271 | 1479271 | 2020-08-21 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-22 04:27:49 | Tasmania, Australia | ||
3484020 | 3484020 | 2020-08-20 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-21 04:27:41 | Tasmania, Australia | ||
205969 | 205969 | 2020-08-19 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-20 04:27:43 | Tasmania, Australia | ||
3177723 | 3177723 | 2020-08-18 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-19 04:27:00 | Tasmania, Australia | ||
837327 | 837327 | 2020-08-17 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-18 04:27:56 | Tasmania, Australia | ||
1555685 | 1555685 | 2020-08-16 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-17 04:27:20 | Tasmania, Australia | ||
145687 | 145687 | 2020-08-15 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-16 04:27:42 | Tasmania, Australia | ||
1611962 | 1611962 | 2020-08-14 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-15 04:27:31 | Tasmania, Australia | ||
582546 | 582546 | 2020-08-13 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-14 04:51:19 | Tasmania, Australia | ||
3531165 | 3531165 | 2020-08-12 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-13 04:29:15 | Tasmania, Australia | ||
662342 | 662342 | 2020-08-11 | Japan | Toyama | 293 | 22 | 216 | 55 | 36.637464 | 137.26934599999998 | 2020-08-12 04:27:29 | Toyama, Japan | ||
662014 | 662014 | 2020-08-11 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-12 04:27:29 | Tasmania, Australia | ||
1920601 | 1920601 | 2020-08-10 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-11 04:35:08 | Tasmania, Australia | ||
3923410 | 3923410 | 2020-08-09 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-10 04:34:55 | Tasmania, Australia | ||
371578 | 371578 | 2020-08-08 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-09 04:34:54 | Tasmania, Australia | ||
458762 | 458762 | 2020-08-07 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-08 04:34:53 | Tasmania, Australia | ||
3612447 | 3612447 | 2020-08-06 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-07 04:35:11 | Tasmania, Australia | ||
3793277 | 3793277 | 2020-08-05 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-06 04:35:02 | Tasmania, Australia | ||
98513 | 98513 | 2020-08-04 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-05 04:34:43 | Tasmania, Australia | ||
2740396 | 2740396 | 2020-08-03 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-04 04:41:59 | Tasmania, Australia | ||
2808148 | 2808148 | 2020-08-02 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-03 04:34:35 | Tasmania, Australia | ||
753716 | 753716 | 2020-08-01 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-02 04:34:47 | Tasmania, Australia | ||
753455 | 753455 | 2020-08-01 | Japan | Ibaraki | 308 | 10 | 216 | 82 | 36.303588 | 140.319591 | 2020-08-02 04:34:47 | Ibaraki, Japan | ||
3264881 | 3264881 | 2020-07-31 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-01 04:36:27 | Tasmania, Australia | ||
367575 | 367575 | 2020-07-16 | Ukraine | Sevastopol* | 285 | 5 | 216 | 64 | 44.6054 | 33.522 | 2020-07-17 04:34:50 | Sevastopol*, Ukraine | ||
530073 | 530073 | 2020-07-04 | Colombia | Santander | 846 | 15 | 216 | 615 | 6.6437 | -73.6536 | 2020-07-05 04:33:46 | Santander, Colombia | ||
2974263 | 2974263 | 2020-06-30 | Colombia | Boyaca | 359 | 16 | 216 | 127 | 5.4545 | -73.362 | 2020-07-01 04:33:52 | Boyaca, Colombia | ||
2040114 | 2040114 | 2020-06-27 | Burma | 296 | 6 | 216 | 74 | 21.9162 | 95.956 | 2020-06-28 04:34:04 | Burma | |||
2386678 | 2386678 | 2020-06-16 | Ukraine | Mykolaiv Oblast | 321 | 7 | 216 | 98 | 46.975 | 31.9946 | 2020-06-17 04:33:21 | Mykolaiv Oblast, Ukraine | ||
2863942 | 2863942 | 2020-06-10 | Russia | Magadan Oblast | 359 | 4 | 216 | 139 | 62.48858785 | 153.9903764 | 2020-06-11 03:33:41 | Magadan Oblast, Russia | ||
1281022 | 1281022 | 2020-06-04 | Russia | Amur Oblast | 588 | 5 | 216 | 367 | 52.8032368 | 128.437295 | 2020-06-05 02:33:06 | Amur Oblast, Russia | ||
3867000 | 3867000 | 2020-06-03 | Mexico | Zacatecas | 322 | 39 | 216 | 67 | 22.7709 | -102.5832 | 2020-06-04 02:33:14 | Zacatecas, Mexico | ||
1432154 | 1432154 | 2020-05-20 | Rwanda | 314 | 0 | 216 | 98 | -1.9403 | 29.8739 | 2020-05-21 02:32:48 | Rwanda | |||
3592638 | 3592638 | 2020-04-26 | Tunisia | 949 | 38 | 216 | 695 | 33.886917 | 9.537499 | 2020-04-27 02:30:33 | Tunisia | |||
1459259 | 1459259 | 2020-04-24 | Costa Rica | 687 | 6 | 216 | 465 | 9.7489 | -83.7534 | 2020-04-25 06:30:33 | Costa Rica | |||
522502 | 522502 | 2020-04-21 | Vietnam | 268 | 0 | 216 | 52 | 14.058323999999999 | 108.277199 | 2020-04-21 23:30:30 | Vietnam | |||
522417 | 522417 | 2020-04-21 | Kyrgyzstan | 590 | 7 | 216 | 367 | 41.20438 | 74.766098 | 2020-04-21 23:30:30 | Kyrgyzstan | |||
43157 | 43157 | 2020-04-13 | Australia | Western Australia | 517 | 6 | 216 | 295 | -31.9505 | 115.8605 | 2020-04-13 23:15:42 | Western Australia, Australia | ||
2578183 | 2578183 | 2020-04-12 | Australia | Western Australia | 514 | 6 | 216 | 292 | -31.9505 | 115.8605 | 2020-04-12 23:25:00 | Western Australia, Australia | ||
2567020 | 2567020 | 2020-04-11 | Australia | Western Australia | 514 | 6 | 216 | 292 | -31.9505 | 115.8605 | 2020-04-11 22:52:46 | Western Australia, Australia | ||
3021673 | 3021673 | 2020-04-07 | China | Hong Kong | 935 | 4 | 216 | 715 | 22.3 | 114.2 | 2020-04-07 09:08:12 | Hong Kong, China | ||
3627355 | 3627355 | 2020-04-06 | China | Hong Kong | 914 | 4 | 216 | 694 | 22.3 | 114.2 | 4/6/20 9:37 | Hong Kong, China | ||
3740602 | 3740602 | 2020-04-03 | Egypt | 985 | 66 | 216 | 703 | 26.820553000000004 | 30.802497999999996 | 2020-04-03 22:46:20 | Egypt | |||
261038 | 261038 | 2020-03-03 | Mainland China | Shaanxi | 245 | 1 | 216 | 35.1917 | 108.8701 | 2020-03-02T08:03:12 | ||||
1152654 | 1152654 | 2020-03-02 | Mainland China | Shaanxi | 245 | 1 | 216 | 35.1917 | 108.8701 | 2020-03-02T08:03:12 |
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]);