johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where recovered = 389 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331360 | 3331360 | 2021-07-21 | China | Yunnan | 678 | 2 | 389 | 287 | 24.974 | 101.487 | 2021-07-22 04:21:19 | Yunnan, China | ||
400090 | 400090 | 2021-06-29 | China | Tianjin | 401 | 3 | 389 | 9 | 39.3054 | 117.323 | 2021-06-30 04:21:41 | Tianjin, China | ||
3125333 | 3125333 | 2021-06-28 | China | Tianjin | 401 | 3 | 389 | 9 | 39.3054 | 117.323 | 2021-06-29 04:21:28 | Tianjin, China | ||
1712138 | 1712138 | 2021-06-25 | China | Inner Mongolia | 394 | 1 | 389 | 4 | 44.0935 | 113.9448 | 2021-06-26 04:21:43 | Inner Mongolia, China | ||
3420691 | 3420691 | 2021-03-19 | Canada | Nunavut | 395 | 4 | 389 | 2 | 70.2998 | -83.1076 | 2021-03-20 05:25:46 | Nunavut, Canada | ||
3452629 | 3452629 | 2021-03-18 | Canada | Nunavut | 395 | 4 | 389 | 2 | 70.2998 | -83.1076 | 2021-03-19 05:26:09 | Nunavut, Canada | ||
1527714 | 1527714 | 2021-02-09 | China | Jilin | 573 | 3 | 389 | 181 | 43.6661 | 126.1923 | 2021-02-10 05:22:41 | Jilin, China | ||
340045 | 340045 | 2021-02-03 | Canada | Newfoundland and Labrador | 410 | 4 | 389 | 17 | 53.1355 | -57.6604 | 2021-02-04 05:22:26 | Newfoundland and Labrador, Canada | ||
237287 | 237287 | 2021-01-18 | Japan | Yamagata | 443 | 13 | 389 | 41 | 38.448396 | 140.102154 | 2021-01-19 05:22:15 | Yamagata, Japan | ||
2625581 | 2625581 | 2021-01-10 | Barbados | 878 | 7 | 389 | 482 | 13.1939 | -59.5432 | 2021-01-11 05:21:50 | Barbados | |||
2223543 | 2223543 | 2020-12-26 | Japan | Saga | 443 | 3 | 389 | 51 | 33.286977 | 130.115738 | 2020-12-27 05:22:55 | Saga, Japan | ||
1904842 | 1904842 | 2020-12-18 | Malaysia | Melaka | 686 | 6 | 389 | 291 | 2.1896 | 102.2501 | 2020-12-19 05:27:52 | Melaka, Malaysia | ||
2131668 | 2131668 | 2020-12-17 | Malaysia | Melaka | 546 | 6 | 389 | 151 | 2.1896 | 102.2501 | 2020-12-18 05:28:18 | Melaka, Malaysia | ||
3153268 | 3153268 | 2020-12-16 | Malaysia | Melaka | 448 | 6 | 389 | 53 | 2.1896 | 102.2501 | 2020-12-17 05:28:12 | Melaka, Malaysia | ||
2701535 | 2701535 | 2020-11-20 | Japan | Nagano | 567 | 6 | 389 | 172 | 36.132134 | 138.045528 | 2020-11-21 05:25:51 | Nagano, Japan | ||
2880212 | 2880212 | 2020-11-15 | Japan | Fukushima | 435 | 6 | 389 | 40 | 37.378867 | 140.223295 | 2020-11-16 05:25:57 | Fukushima, Japan | ||
210313 | 210313 | 2020-10-29 | Mauritius | 441 | 10 | 389 | 40 | -20.348404 | 57.552152 | 2020-10-30 04:24:49 | Mauritius | |||
754375 | 754375 | 2020-10-28 | Mauritius | 439 | 10 | 389 | 40 | -20.348404 | 57.552152 | 2020-10-29 04:24:49 | Mauritius | |||
1452659 | 1452659 | 2020-10-27 | Mauritius | 439 | 10 | 389 | 40 | -20.348404 | 57.552152 | 2020-10-28 04:24:39 | Mauritius | |||
3480383 | 3480383 | 2020-10-26 | Mauritius | 435 | 10 | 389 | 40 | -20.348404 | 57.552152 | 2020-10-27 04:24:45 | Mauritius | |||
2291486 | 2291486 | 2020-10-12 | Japan | Toyama | 422 | 26 | 389 | 7 | 36.637464 | 137.26934599999998 | 2020-10-13 04:24:02 | Toyama, Japan | ||
3785939 | 3785939 | 2020-10-11 | Japan | Toyama | 422 | 26 | 389 | 7 | 36.637464 | 137.26934599999998 | 2020-10-12 04:23:45 | Toyama, Japan | ||
2602077 | 2602077 | 2020-10-10 | Japan | Toyama | 422 | 26 | 389 | 7 | 36.637464 | 137.26934599999998 | 2020-10-11 04:23:46 | Toyama, Japan | ||
2836839 | 2836839 | 2020-09-21 | Japan | Mie | 475 | 6 | 389 | 80 | 34.508018 | 136.376013 | 2020-09-22 04:23:00 | Mie, Japan | ||
3093443 | 3093443 | 2020-09-20 | Japan | Mie | 471 | 5 | 389 | 77 | 34.508018 | 136.376013 | 2020-09-21 04:23:00 | Mie, Japan | ||
2510211 | 2510211 | 2020-08-27 | Japan | Nara | 500 | 5 | 389 | 106 | 34.317451 | 135.871644 | 2020-08-28 04:28:11 | Nara, Japan | ||
3562606 | 3562606 | 2020-08-25 | Japan | Shizuoka | 454 | 1 | 389 | 64 | 34.916975 | 138.40778400000002 | 2020-08-26 04:28:11 | Shizuoka, Japan | ||
1612018 | 1612018 | 2020-08-14 | Canada | Manitoba | 643 | 8 | 389 | 246 | 53.7609 | -98.8139 | 2020-08-15 04:27:31 | Manitoba, Canada | ||
326841 | 326841 | 2020-07-20 | Colombia | Cauca | 1136 | 36 | 389 | 711 | 2.705 | -76.82600000000002 | 2020-07-21 04:38:46 | Cauca, Colombia | ||
2748129 | 2748129 | 2020-07-15 | Ukraine | Mykolaiv Oblast | 494 | 12 | 389 | 93 | 46.975 | 31.9946 | 2020-07-16 04:44:59 | Mykolaiv Oblast, Ukraine | ||
2158879 | 2158879 | 2020-07-14 | Colombia | Santander | 1362 | 30 | 389 | 943 | 6.6437 | -73.6536 | 2020-07-15 04:34:39 | Santander, Colombia | ||
3045221 | 3045221 | 2020-07-02 | India | Chandigarh | 450 | 6 | 389 | 55 | 30.733839 | 76.76827800000002 | 2020-07-03 04:33:54 | Chandigarh, India | ||
1829764 | 1829764 | 2020-05-16 | Taiwan* | 440 | 7 | 389 | 44 | 23.7 | 121.0 | 2020-05-17 02:32:32 | Taiwan* | |||
3459696 | 3459696 | 2020-05-10 | Jordan | 540 | 9 | 389 | 142 | 31.24 | 36.51 | 2020-05-11 02:32:30 | Jordan | |||
1199286 | 1199286 | 2020-04-22 | Burkina Faso | 609 | 39 | 389 | 181 | 12.2383 | -1.5616 | 2020-04-22 23:30:32 | Burkina Faso | |||
3627394 | 3627394 | 2020-04-06 | China | Shanghai | 536 | 6 | 389 | 141 | 31.202 | 121.4491 | 4/6/20 5:30 | Shanghai, China |
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]);