daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
57 rows where recovered = 516 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- Japan 15
- China 8
- Papua New Guinea 7
- Mauritius 6
- Canada 4
- Denmark 2
- Jamaica 2
- Malaysia 2
- Ukraine 2
- Australia 1
- Colombia 1
- Cyprus 1
- Hungary 1
- Mainland China 1
- Paraguay 1
- Philippines 1
- Russia 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-02 | Canada | Yukon | 596 | 7 | 516 | 73 | 64.2823 | -135.0 | 2021-08-03 04:21:39 | Yukon, Canada | ||
2021-08-01 | Canada | Yukon | 596 | 7 | 516 | 73 | 64.2823 | -135.0 | 2021-08-02 04:21:36 | Yukon, Canada | ||
2021-07-31 | Canada | Yukon | 596 | 7 | 516 | 73 | 64.2823 | -135.0 | 2021-08-01 04:21:50 | Yukon, Canada | ||
2021-07-30 | Canada | Yukon | 596 | 7 | 516 | 73 | 64.2823 | -135.0 | 2021-07-31 04:21:35 | Yukon, Canada | ||
2021-03-08 | Japan | Yamagata | 544 | 15 | 516 | 13 | 38.448396 | 140.102154 | 2021-03-09 05:28:19 | Yamagata, Japan | ||
2021-03-07 | Japan | Yamagata | 543 | 15 | 516 | 12 | 38.448396 | 140.102154 | 2021-03-08 05:24:48 | Yamagata, Japan | ||
2021-03-06 | Japan | Yamagata | 543 | 15 | 516 | 12 | 38.448396 | 140.102154 | 2021-03-07 05:21:54 | Yamagata, Japan | ||
2021-03-05 | Japan | Yamagata | 543 | 15 | 516 | 12 | 38.448396 | 140.102154 | 2021-03-06 04:23:41 | Yamagata, Japan | ||
2021-03-04 | Japan | Fukui | 545 | 25 | 516 | 4 | 35.846614 | 136.22465400000002 | 2021-03-05 05:26:29 | Fukui, Japan | ||
2021-03-03 | Japan | Fukui | 545 | 25 | 516 | 4 | 35.846614 | 136.22465400000002 | 2021-03-04 05:24:24 | Fukui, Japan | ||
2021-03-02 | Japan | Iwate | 554 | 30 | 516 | 8 | 39.593287 | 141.361777 | 2021-03-03 05:23:28 | Iwate, Japan | ||
2021-03-02 | Japan | Fukui | 545 | 25 | 516 | 4 | 35.846614 | 136.22465400000002 | 2021-03-03 05:23:28 | Fukui, Japan | ||
2021-03-01 | Japan | Fukui | 545 | 25 | 516 | 4 | 35.846614 | 136.22465400000002 | 2021-03-02 05:23:30 | Fukui, Japan | ||
2021-02-19 | China | Jilin | 573 | 3 | 516 | 54 | 43.6661 | 126.1923 | 2021-02-20 05:22:51 | Jilin, China | ||
2021-02-06 | China | Shaanxi | 542 | 3 | 516 | 23 | 35.1917 | 108.8701 | 2021-02-07 05:23:00 | Shaanxi, China | ||
2021-02-05 | China | Shaanxi | 542 | 3 | 516 | 23 | 35.1917 | 108.8701 | 2021-02-06 05:23:55 | Shaanxi, China | ||
2021-02-04 | China | Shaanxi | 541 | 3 | 516 | 22 | 35.1917 | 108.8701 | 2021-02-05 05:22:38 | Shaanxi, China | ||
2021-01-23 | China | Fujian | 534 | 1 | 516 | 17 | 26.0789 | 117.9874 | 2021-01-24 05:22:35 | Fujian, China | ||
2021-01-17 | Mauritius | 547 | 10 | 516 | 21 | -20.348404 | 57.552152 | 2021-01-18 05:22:34 | Mauritius | |||
2021-01-16 | Mauritius | 547 | 10 | 516 | 21 | -20.348404 | 57.552152 | 2021-01-17 05:22:17 | Mauritius | |||
2021-01-16 | Japan | Saga | 751 | 3 | 516 | 232 | 33.286977 | 130.115738 | 2021-01-17 05:22:17 | Saga, Japan | ||
2021-01-15 | Mauritius | 547 | 10 | 516 | 21 | -20.348404 | 57.552152 | 2021-01-16 05:22:40 | Mauritius | |||
2021-01-14 | Mauritius | 547 | 10 | 516 | 21 | -20.348404 | 57.552152 | 2021-01-15 05:22:24 | Mauritius | |||
2021-01-13 | Mauritius | 546 | 10 | 516 | 21 | -20.348404 | 57.552152 | 2021-01-14 05:22:32 | Mauritius | |||
2021-01-12 | Mauritius | 545 | 10 | 516 | 20 | -20.348404 | 57.552152 | 2021-01-13 05:22:15 | Mauritius | |||
2021-01-07 | Japan | Yamaguchi | 656 | 3 | 516 | 137 | 34.201190000000004 | 131.573293 | 2021-01-08 05:22:42 | Yamaguchi, Japan | ||
2020-12-19 | Denmark | Faroe Islands | 539 | 0 | 516 | 23 | 61.8926 | -6.9118 | 2020-12-20 05:27:32 | Faroe Islands, Denmark | ||
2020-12-18 | Denmark | Faroe Islands | 534 | 0 | 516 | 18 | 61.8926 | -6.9118 | 2020-12-19 05:27:52 | Faroe Islands, Denmark | ||
2020-11-24 | Australia | South Australia | 558 | 4 | 516 | 38 | -34.9285 | 138.6007 | 2020-11-25 05:27:20 | South Australia, Australia | ||
2020-10-27 | Japan | Miyagi | 655 | 2 | 516 | 137 | 38.446859 | 140.927086 | 2020-10-28 04:24:39 | Miyagi, Japan | ||
2020-10-25 | United Kingdom | Gibraltar | 667 | 0 | 516 | 151 | 36.1408 | -5.3536 | 2020-10-26 04:25:02 | Gibraltar, United Kingdom | ||
2020-10-01 | Japan | Shizuoka | 548 | 2 | 516 | 30 | 34.916975 | 138.40778400000002 | 2020-10-02 04:23:51 | Shizuoka, Japan | ||
2020-09-30 | Papua New Guinea | 534 | 7 | 516 | 11 | -6.314993 | 143.95555 | 2020-10-01 04:23:42 | Papua New Guinea | |||
2020-09-30 | Japan | Shizuoka | 541 | 2 | 516 | 23 | 34.916975 | 138.40778400000002 | 2020-10-01 04:23:42 | Shizuoka, Japan | ||
2020-09-29 | Papua New Guinea | 534 | 7 | 516 | 11 | -6.314993 | 143.95555 | 2020-09-30 04:23:33 | Papua New Guinea | |||
2020-09-29 | Japan | Shizuoka | 534 | 2 | 516 | 16 | 34.916975 | 138.40778400000002 | 2020-09-30 04:23:33 | Shizuoka, Japan | ||
2020-09-28 | Ukraine | Luhansk Oblast | 979 | 11 | 516 | 452 | 48.574 | 39.3078 | 2020-09-29 04:23:42 | Luhansk Oblast, Ukraine | ||
2020-09-28 | Papua New Guinea | 532 | 7 | 516 | 9 | -6.314993 | 143.95555 | 2020-09-29 04:23:42 | Papua New Guinea | |||
2020-09-27 | Ukraine | Luhansk Oblast | 974 | 11 | 516 | 447 | 48.574 | 39.3078 | 2020-09-28 04:23:00 | Luhansk Oblast, Ukraine | ||
2020-09-27 | Papua New Guinea | 532 | 7 | 516 | 9 | -6.314993 | 143.95555 | 2020-09-28 04:23:00 | Papua New Guinea | |||
2020-09-26 | Papua New Guinea | 532 | 7 | 516 | 9 | -6.314993 | 143.95555 | 2020-09-27 04:23:00 | Papua New Guinea | |||
2020-09-25 | Papua New Guinea | 532 | 7 | 516 | 9 | -6.314993 | 143.95555 | 2020-09-26 04:23:00 | Papua New Guinea | |||
2020-09-24 | Papua New Guinea | 531 | 7 | 516 | 8 | -6.314993 | 143.95555 | 2020-09-25 04:23:00 | Papua New Guinea | |||
2020-07-14 | Colombia | Sucre | 2583 | 168 | 516 | 1899 | 8.814 | -74.7233 | 2020-07-15 04:34:39 | Sucre, Colombia | ||
2020-06-22 | Jamaica | 665 | 10 | 516 | 139 | 18.1096 | -77.2975 | 2020-06-23 04:33:22 | Jamaica | |||
2020-06-21 | Jamaica | 659 | 10 | 516 | 133 | 18.1096 | -77.2975 | 2020-06-22 04:33:20 | Jamaica | |||
2020-06-11 | Russia | Udmurt Republic | 1031 | 12 | 516 | 503 | 57.1961165 | 52.69598320000001 | 2020-06-12 05:09:52 | Udmurt Republic, Russia | ||
2020-06-05 | Malaysia | Sarawak | 553 | 17 | 516 | 20 | 1.5533 | 110.3592 | 2020-06-06 02:33:00 | Sarawak, Malaysia | ||
2020-06-05 | Paraguay | 1087 | 11 | 516 | 560 | -23.4425 | -58.4438 | 2020-06-06 02:33:00 | Paraguay | |||
2020-06-04 | Malaysia | Sarawak | 552 | 17 | 516 | 19 | 1.5533 | 110.3592 | 2020-06-05 02:33:06 | Sarawak, Malaysia | ||
2020-05-20 | Cyprus | 918 | 17 | 516 | 385 | 35.1264 | 33.4299 | 2020-05-21 02:32:48 | Cyprus | |||
2020-04-28 | Hungary | 2649 | 291 | 516 | 1842 | 47.1625 | 19.5033 | 2020-04-29 02:32:29 | Hungary | |||
2020-04-21 | China | Beijing | 593 | 8 | 516 | 69 | 40.1824 | 116.4142 | 2020-04-21 01:01:23 | Beijing, China | ||
2020-04-18 | Philippines | 6087 | 397 | 516 | 5174 | 12.879721 | 121.774017 | 2020-04-18 22:32:28 | Philippines | |||
2020-03-16 | China | Sichuan | 539 | 3 | 516 | 30.6171 | 102.7103 | 2020-03-15T18:20:18 | ||||
2020-03-15 | China | Sichuan | 539 | 3 | 516 | 30.6171 | 102.7103 | 2020-03-15T18:20:18 | ||||
2020-03-04 | Mainland China | Shandong | 758 | 6 | 516 | 36.3427 | 118.1498 | 2020-03-04T12:53:03 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;