johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where recovered = 86 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- Japan 19
- Mainland China 5
- Netherlands 5
- Bhutan 3
- Colombia 3
- Malaysia 3
- Canada 2
- India 2
- Lebanon 2
- San Marino 2
- Australia 1
- Chile 1
- Georgia 1
- Guatemala 1
- Guyana 1
- Mexico 1
- North Macedonia 1
- Romania 1
- Sri Lanka 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3030068 | 3030068 | 2021-06-16 | Canada | Yukon | 120 | 3 | 86 | 31 | 64.2823 | -135.0 | 2021-06-17 04:22:36 | Yukon, Canada | ||
2339174 | 2339174 | 2021-06-15 | Canada | Yukon | 120 | 3 | 86 | 31 | 64.2823 | -135.0 | 2021-06-16 04:22:32 | Yukon, Canada | ||
236939 | 236939 | 2021-01-18 | Australia | Northern Territory | 93 | 0 | 86 | 7 | -12.4634 | 130.8456 | 2021-01-19 05:22:15 | Northern Territory, Australia | ||
2625914 | 2625914 | 2021-01-10 | Japan | Tottori | 165 | 1 | 86 | 78 | 35.359069 | 133.863619 | 2021-01-11 05:21:50 | Tottori, Japan | ||
1818789 | 1818789 | 2020-12-08 | Japan | Akita | 90 | 1 | 86 | 3 | 39.748679 | 140.408228 | 2020-12-09 05:28:01 | Akita, Japan | ||
3836528 | 3836528 | 2020-11-21 | Japan | Yamagata | 107 | 1 | 86 | 20 | 38.448396 | 140.102154 | 2020-11-22 05:25:45 | Yamagata, Japan | ||
2991291 | 2991291 | 2020-08-24 | Japan | Kochi | 109 | 3 | 86 | 20 | 33.422519 | 133.367307 | 2020-08-25 04:28:02 | Kochi, Japan | ||
2215686 | 2215686 | 2020-08-23 | Japan | Kochi | 109 | 3 | 86 | 20 | 33.422519 | 133.367307 | 2020-08-24 04:27:56 | Kochi, Japan | ||
3484334 | 3484334 | 2020-08-20 | Japan | Oita | 134 | 1 | 86 | 47 | 33.200697 | 131.43323999999998 | 2020-08-21 04:27:41 | Oita, Japan | ||
3177796 | 3177796 | 2020-08-18 | Chile | Aysen | 98 | 1 | 86 | 11 | -45.9864 | -73.7669 | 2020-08-19 04:27:00 | Aysen, Chile | ||
1920583 | 1920583 | 2020-08-10 | Netherlands | Sint Maarten | 189 | 17 | 86 | 86 | 18.0425 | -63.0548 | 2020-08-11 04:35:08 | Sint Maarten, Netherlands | ||
1920281 | 1920281 | 2020-08-10 | Japan | Ehime | 107 | 5 | 86 | 16 | 33.624835 | 132.856842 | 2020-08-11 04:35:08 | Ehime, Japan | ||
3923392 | 3923392 | 2020-08-09 | Netherlands | Sint Maarten | 189 | 17 | 86 | 86 | 18.0425 | -63.0548 | 2020-08-10 04:34:55 | Sint Maarten, Netherlands | ||
3923090 | 3923090 | 2020-08-09 | Japan | Ehime | 102 | 5 | 86 | 11 | 33.624835 | 132.856842 | 2020-08-10 04:34:55 | Ehime, Japan | ||
371560 | 371560 | 2020-08-08 | Netherlands | Sint Maarten | 177 | 17 | 86 | 74 | 18.0425 | -63.0548 | 2020-08-09 04:34:54 | Sint Maarten, Netherlands | ||
371273 | 371273 | 2020-08-08 | Japan | Fukushima | 96 | 0 | 86 | 10 | 37.378867 | 140.223295 | 2020-08-09 04:34:54 | Fukushima, Japan | ||
458744 | 458744 | 2020-08-07 | Netherlands | Sint Maarten | 176 | 16 | 86 | 74 | 18.0425 | -63.0548 | 2020-08-08 04:34:53 | Sint Maarten, Netherlands | ||
458457 | 458457 | 2020-08-07 | Japan | Fukushima | 95 | 0 | 86 | 9 | 37.378867 | 140.223295 | 2020-08-08 04:34:53 | Fukushima, Japan | ||
3612515 | 3612515 | 2020-08-06 | Japan | Yamanashi | 124 | 1 | 86 | 37 | 35.612364 | 138.61148899999998 | 2020-08-07 04:35:11 | Yamanashi, Japan | ||
3612429 | 3612429 | 2020-08-06 | Netherlands | Sint Maarten | 176 | 16 | 86 | 74 | 18.0425 | -63.0548 | 2020-08-07 04:35:11 | Sint Maarten, Netherlands | ||
3612142 | 3612142 | 2020-08-06 | Japan | Fukushima | 93 | 0 | 86 | 7 | 37.378867 | 140.223295 | 2020-08-07 04:35:11 | Fukushima, Japan | ||
3793345 | 3793345 | 2020-08-05 | Japan | Yamanashi | 114 | 1 | 86 | 27 | 35.612364 | 138.61148899999998 | 2020-08-06 04:35:02 | Yamanashi, Japan | ||
3792972 | 3792972 | 2020-08-05 | Japan | Fukushima | 91 | 0 | 86 | 5 | 37.378867 | 140.223295 | 2020-08-06 04:35:02 | Fukushima, Japan | ||
98208 | 98208 | 2020-08-04 | Japan | Fukushima | 89 | 0 | 86 | 3 | 37.378867 | 140.223295 | 2020-08-05 04:34:43 | Fukushima, Japan | ||
2958854 | 2958854 | 2020-07-29 | Bhutan | 99 | 0 | 86 | 13 | 27.5142 | 90.4336 | 2020-07-30 04:35:05 | Bhutan | |||
3185471 | 3185471 | 2020-07-28 | Bhutan | 99 | 0 | 86 | 13 | 27.5142 | 90.4336 | 2020-07-29 04:35:11 | Bhutan | |||
3185239 | 3185239 | 2020-07-28 | Japan | Niigata | 96 | 0 | 86 | 10 | 37.521819 | 138.918647 | 2020-07-29 04:35:11 | Niigata, Japan | ||
177521 | 177521 | 2020-07-27 | Bhutan | 99 | 0 | 86 | 13 | 27.5142 | 90.4336 | 2020-07-28 04:58:43 | Bhutan | |||
442795 | 442795 | 2020-07-26 | Japan | Wakayama | 122 | 3 | 86 | 33 | 33.911879 | 135.505446 | 2020-07-27 04:35:02 | Wakayama, Japan | ||
844555 | 844555 | 2020-07-22 | Colombia | Arauca | 173 | 1 | 86 | 86 | 7.0762 | -70.7105 | 2020-07-23 05:15:04 | Arauca, Colombia | ||
367615 | 367615 | 2020-07-16 | Japan | Tochigi | 112 | 0 | 86 | 26 | 36.689912 | 139.819213 | 2020-07-17 04:34:50 | Tochigi, Japan | ||
3491538 | 3491538 | 2020-07-13 | India | Sikkim | 192 | 0 | 86 | 106 | 27.571671000000002 | 88.472712 | 2020-07-14 04:34:46 | Sikkim, India | ||
302936 | 302936 | 2020-07-01 | India | Dadra and Nagar Haveli and Daman and Diu | 215 | 0 | 86 | 129 | 20.194742 | 73.080901 | 2020-07-02 04:33:46 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2386475 | 2386475 | 2020-06-16 | Colombia | Cesar | 554 | 17 | 86 | 451 | 9.3373 | -73.6536 | 2020-06-17 04:33:21 | Cesar, Colombia | ||
287038 | 287038 | 2020-06-15 | Colombia | Cesar | 554 | 17 | 86 | 451 | 9.3373 | -73.6536 | 2020-06-16 04:33:09 | Cesar, Colombia | ||
1211079 | 1211079 | 2020-06-09 | Guyana | 156 | 12 | 86 | 58 | 4.860416000000002 | -58.93018000000001 | 2020-06-10 04:07:00 | Guyana | |||
1793864 | 1793864 | 2020-05-31 | Mexico | Colima | 151 | 21 | 86 | 44 | 19.1223 | -104.0072 | 2020-06-01 02:32:46 | Colima, Mexico | ||
1790412 | 1790412 | 2020-05-29 | Japan | Nara | 88 | 2 | 86 | 0 | 34.317451 | 135.871644 | 2020-05-30 02:32:48 | Nara, Japan | ||
2111055 | 2111055 | 2020-05-06 | Malaysia | Kedah | 95 | 1 | 86 | 8 | 6.1184 | 100.3685 | 2020-05-07 02:32:28 | Kedah, Malaysia | ||
2110932 | 2110932 | 2020-05-06 | Guatemala | 798 | 21 | 86 | 691 | 15.7835 | -90.2308 | 2020-05-07 02:32:28 | Guatemala | |||
1932093 | 1932093 | 2020-05-05 | Malaysia | Kedah | 95 | 1 | 86 | 8 | 6.1184 | 100.3685 | 2020-05-06 02:32:31 | Kedah, Malaysia | ||
3084956 | 3084956 | 2020-05-04 | Malaysia | Kedah | 95 | 1 | 86 | 8 | 6.1184 | 100.3685 | 2020-05-05 02:32:34 | Kedah, Malaysia | ||
3084909 | 3084909 | 2020-05-04 | San Marino | 582 | 41 | 86 | 455 | 43.9424 | 12.4578 | 2020-05-05 02:32:34 | San Marino | |||
2278768 | 2278768 | 2020-05-03 | San Marino | 580 | 41 | 86 | 453 | 43.9424 | 12.4578 | 2020-05-04 02:32:28 | San Marino | |||
418943 | 418943 | 2020-04-18 | Sri Lanka | 254 | 7 | 86 | 161 | 7.873054 | 80.771797 | 2020-04-18 22:32:28 | Sri Lanka | |||
418850 | 418850 | 2020-04-18 | Georgia | 388 | 3 | 86 | 298 | 42.3154 | 43.3569 | 2020-04-18 22:32:28 | Georgia | |||
50354 | 50354 | 2020-04-17 | Lebanon | 668 | 21 | 86 | 561 | 33.8547 | 35.8623 | 2020-04-17 23:30:32 | Lebanon | |||
934348 | 934348 | 2020-04-16 | Lebanon | 663 | 21 | 86 | 556 | 33.8547 | 35.8623 | 2020-04-16 23:30:31 | Lebanon | |||
3338186 | 3338186 | 2020-04-14 | North Macedonia | 908 | 44 | 86 | 778 | 41.6086 | 21.7453 | 2020-04-14 23:33:12 | North Macedonia | |||
1132675 | 1132675 | 2020-03-25 | Romania | 906 | 17 | 86 | 803 | 45.9432 | 24.9668 | 2020-03-25 23:33:04 | Romania | |||
98835 | 98835 | 2020-03-04 | Mainland China | Jilin | 93 | 1 | 86 | 43.6661 | 126.1923 | 2020-03-04T10:03:19 | ||||
261051 | 261051 | 2020-03-03 | Mainland China | Gansu | 91 | 2 | 86 | 36.0611 | 103.8343 | 2020-03-03T13:43:03 | ||||
2263470 | 2263470 | 2020-02-20 | Mainland China | Hainan | 168 | 4 | 86 | 19.1959 | 109.7453 | 2020-02-20T09:53:02 | ||||
1720059 | 1720059 | 2020-02-19 | Mainland China | Guangxi | 244 | 2 | 86 | 23.8298 | 108.7881 | 2020-02-19T09:13:12 | ||||
3222002 | 3222002 | 2020-02-07 | Mainland China | Henan | 914 | 3 | 86 | 33.882 | 113.614 | 2020-02-07T14: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]);