johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where recovered = 620 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- Australia 8
- China 6
- United Kingdom 6
- Japan 5
- Mexico 3
- Albania 1
- Costa Rica 1
- Ethiopia 1
- India 1
- Jamaica 1
- Malaysia 1
- Netherlands 1
- Russia 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3221949 | 3221949 | 2021-07-26 | United Kingdom | Cayman Islands | 636 | 2 | 620 | 14 | 19.3133 | -81.2546 | 2021-07-27 04:21:18 | Cayman Islands, United Kingdom | ||
1382158 | 1382158 | 2021-07-25 | United Kingdom | Cayman Islands | 636 | 2 | 620 | 14 | 19.3133 | -81.2546 | 2021-07-26 04:21:28 | Cayman Islands, United Kingdom | ||
1333898 | 1333898 | 2021-07-24 | United Kingdom | Cayman Islands | 636 | 2 | 620 | 14 | 19.3133 | -81.2546 | 2021-07-25 04:22:12 | Cayman Islands, United Kingdom | ||
778182 | 778182 | 2021-07-08 | China | Shaanxi | 631 | 3 | 620 | 8 | 35.1917 | 108.8701 | 2021-07-09 04:21:21 | Shaanxi, China | ||
1440404 | 1440404 | 2021-07-07 | China | Shaanxi | 631 | 3 | 620 | 8 | 35.1917 | 108.8701 | 2021-07-08 04:21:26 | Shaanxi, China | ||
2589803 | 2589803 | 2021-06-27 | China | Fujian | 672 | 1 | 620 | 51 | 26.0789 | 117.9874 | 2021-06-28 04:21:29 | Fujian, China | ||
702104 | 702104 | 2021-03-16 | Australia | South Australia | 638 | 4 | 620 | 14 | -34.9285 | 138.6007 | 2021-03-17 05:25:07 | South Australia, Australia | ||
2055582 | 2055582 | 2021-03-15 | Australia | South Australia | 636 | 4 | 620 | 12 | -34.9285 | 138.6007 | 2021-03-16 05:25:13 | South Australia, Australia | ||
1732194 | 1732194 | 2021-03-14 | Australia | South Australia | 634 | 4 | 620 | 10 | -34.9285 | 138.6007 | 2021-03-15 05:25:51 | South Australia, Australia | ||
1579851 | 1579851 | 2021-03-13 | Australia | South Australia | 631 | 4 | 620 | 7 | -34.9285 | 138.6007 | 2021-03-14 05:25:37 | South Australia, Australia | ||
1837630 | 1837630 | 2021-03-12 | Australia | South Australia | 631 | 4 | 620 | 7 | -34.9285 | 138.6007 | 2021-03-13 05:25:15 | South Australia, Australia | ||
3503405 | 3503405 | 2021-01-17 | Japan | Yamaguchi | 833 | 5 | 620 | 208 | 34.201190000000004 | 131.573293 | 2021-01-18 05:22:34 | Yamaguchi, Japan | ||
3515451 | 3515451 | 2021-01-15 | Japan | Yamanashi | 829 | 11 | 620 | 198 | 35.612364 | 138.61148899999998 | 2021-01-16 05:22:40 | Yamanashi, Japan | ||
3413088 | 3413088 | 2020-11-01 | United Kingdom | Gibraltar | 703 | 0 | 620 | 83 | 36.1408 | -5.3536 | 2020-11-02 05:25:04 | Gibraltar, United Kingdom | ||
3990618 | 3990618 | 2020-10-20 | Japan | Gifu | 647 | 10 | 620 | 17 | 35.778671 | 137.055925 | 2020-10-21 04:24:14 | Gifu, Japan | ||
1794638 | 1794638 | 2020-10-19 | Japan | Gifu | 644 | 10 | 620 | 14 | 35.778671 | 137.055925 | 2020-10-20 04:24:22 | Gifu, Japan | ||
2689807 | 2689807 | 2020-10-08 | Netherlands | Sint Maarten | 699 | 22 | 620 | 57 | 18.0425 | -63.0548 | 2020-10-09 04:23:59 | Sint Maarten, Netherlands | ||
2585629 | 2585629 | 2020-09-27 | United Kingdom | Turks and Caicos Islands | 682 | 5 | 620 | 57 | 21.694 | -71.7979 | 2020-09-28 04:23:00 | Turks and Caicos Islands, United Kingdom | ||
2617681 | 2617681 | 2020-09-26 | United Kingdom | Turks and Caicos Islands | 681 | 5 | 620 | 56 | 21.694 | -71.7979 | 2020-09-27 04:23:00 | Turks and Caicos Islands, United Kingdom | ||
2510012 | 2510012 | 2020-08-27 | China | Sichuan | 648 | 3 | 620 | 25 | 30.6171 | 102.7103 | 2020-08-28 04:28:11 | Sichuan, China | ||
3612718 | 3612718 | 2020-08-06 | Malaysia | Sarawak | 678 | 19 | 620 | 39 | 1.5533 | 110.3592 | 2020-08-07 04:35:11 | Sarawak, Malaysia | ||
98075 | 98075 | 2020-08-04 | Japan | Aichi | 2435 | 35 | 620 | 1780 | 35.035551 | 137.211621 | 2020-08-05 04:34:43 | Aichi, Japan | ||
3737977 | 3737977 | 2020-07-12 | Jamaica | 758 | 10 | 620 | 128 | 18.1096 | -77.2975 | 2020-07-13 04:43:04 | Jamaica | |||
3682630 | 3682630 | 2020-06-18 | Russia | Karachay-Cherkess Republic | 2545 | 9 | 620 | 1916 | 43.7368326 | 41.7267991 | 2020-06-19 04:33:17 | Karachay-Cherkess Republic, Russia | ||
287517 | 287517 | 2020-06-15 | Ethiopia | 3521 | 60 | 620 | 2841 | 9.145 | 40.4897 | 2020-06-16 04:33:09 | Ethiopia | |||
3061251 | 3061251 | 2020-06-13 | Mexico | Nayarit | 985 | 110 | 620 | 255 | 21.7514 | -104.8455 | 2020-06-14 03:33:15 | Nayarit, Mexico | ||
875755 | 875755 | 2020-05-24 | Costa Rica | 930 | 10 | 620 | 300 | 9.7489 | -83.7534 | 2020-05-25 02:32:44 | Costa Rica | |||
875572 | 875572 | 2020-05-24 | Mexico | Guanajuato | 1054 | 88 | 620 | 346 | 21.019000000000002 | -101.2574 | 2020-05-25 02:32:44 | Guanajuato, Mexico | ||
1865083 | 1865083 | 2020-05-22 | Sri Lanka | 1068 | 9 | 620 | 439 | 7.873054 | 80.77179699999998 | 2020-05-23 02:32:42 | Sri Lanka | |||
268309 | 268309 | 2020-05-21 | Mexico | Jalisco | 1028 | 96 | 620 | 312 | 20.6595 | -103.3494 | 2020-05-22 02:36:51 | Jalisco, Mexico | ||
114202 | 114202 | 2020-05-08 | Albania | 850 | 31 | 620 | 199 | 41.1533 | 20.1683 | 2020-05-09 02:32:35 | Albania | |||
2110848 | 2110848 | 2020-05-06 | China | Shanghai | 657 | 7 | 620 | 30 | 31.201999999999998 | 121.4491 | 2020-05-07 02:32:28 | Shanghai, China | ||
1931888 | 1931888 | 2020-05-05 | China | Shanghai | 656 | 7 | 620 | 29 | 31.202 | 121.4491 | 2020-05-06 02:32:31 | Shanghai, China | ||
3950022 | 3950022 | 2020-04-09 | India | 6725 | 226 | 620 | 5879 | 20.593684 | 78.96288 | 2020-04-09 23:02:19 | India | |||
3562047 | 3562047 | 2020-04-08 | Australia | Victoria | 1212 | 12 | 620 | 580 | -37.8136 | 144.9631 | 2020-04-08 22:59:00 | Victoria, Australia | ||
3021722 | 3021722 | 2020-04-07 | Australia | Victoria | 1191 | 11 | 620 | 560 | -37.8136 | 144.9631 | 2020-04-07 23:11:31 | Victoria, Australia | ||
3627404 | 3627404 | 2020-04-06 | Australia | Victoria | 1158 | 10 | 620 | 528 | -37.8136 | 144.9631 | 4/6/20 23:28 | Victoria, Australia |
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]);