johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where recovered = 631 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3019001 | 3019001 | 2021-08-01 | United Kingdom | Cayman Islands | 643 | 2 | 631 | 10 | 19.3133 | -81.2546 | 2021-08-02 04:21:36 | Cayman Islands, United Kingdom | ||
3907624 | 3907624 | 2021-07-31 | United Kingdom | Cayman Islands | 643 | 2 | 631 | 10 | 19.3133 | -81.2546 | 2021-08-01 04:21:50 | Cayman Islands, United Kingdom | ||
3295999 | 3295999 | 2021-07-30 | China | Shaanxi | 656 | 3 | 631 | 22 | 35.1917 | 108.8701 | 2021-07-31 04:21:35 | Shaanxi, China | ||
1535627 | 1535627 | 2021-03-28 | Australia | South Australia | 650 | 4 | 631 | 15 | -34.9285 | 138.6007 | 2021-03-29 04:28:35 | South Australia, Australia | ||
1219267 | 1219267 | 2021-03-27 | Australia | South Australia | 650 | 4 | 631 | 15 | -34.9285 | 138.6007 | 2021-03-28 05:28:10 | South Australia, Australia | ||
2481972 | 2481972 | 2021-01-28 | Japan | Aomori | 699 | 13 | 631 | 55 | 40.781541 | 140.828896 | 2021-01-29 05:22:23 | Aomori, Japan | ||
435081 | 435081 | 2021-01-21 | Bhutan | 850 | 1 | 631 | 218 | 27.5142 | 90.4336 | 2021-01-22 05:22:10 | Bhutan | |||
1093813 | 1093813 | 2021-01-20 | Bhutan | 850 | 1 | 631 | 218 | 27.5142 | 90.4336 | 2021-01-21 05:22:01 | Bhutan | |||
3101210 | 3101210 | 2021-01-16 | Canada | New Brunswick | 911 | 12 | 631 | 268 | 46.5653 | -66.4619 | 2021-01-17 05:22:17 | New Brunswick, Canada | ||
774393 | 774393 | 2021-01-12 | Japan | Wakayama | 786 | 8 | 631 | 147 | 33.911879 | 135.505446 | 2021-01-13 05:22:15 | Wakayama, Japan | ||
927801 | 927801 | 2020-12-21 | Monaco | 742 | 3 | 631 | 108 | 43.7333 | 7.4167 | 2020-12-22 05:22:33 | Monaco | |||
75114 | 75114 | 2020-12-03 | Japan | Nagano | 760 | 6 | 631 | 123 | 36.132134 | 138.045528 | 2020-12-04 05:27:27 | Nagano, Japan | ||
1519041 | 1519041 | 2020-09-28 | United Kingdom | Turks and Caicos Islands | 682 | 5 | 631 | 46 | 21.694000000000006 | -71.7979 | 2020-09-29 04:23:42 | Turks and Caicos Islands, United Kingdom | ||
2848854 | 2848854 | 2020-09-18 | Japan | Ishikawa | 744 | 44 | 631 | 69 | 36.769464 | 136.771027 | 2020-09-19 04:22:00 | Ishikawa, Japan | ||
666474 | 666474 | 2020-09-16 | Russia | Jewish Autonomous Okrug | 742 | 10 | 631 | 101 | 48.57527615 | 132.6630746 | 2020-09-17 04:22:00 | Jewish Autonomous Okrug, Russia | ||
582730 | 582730 | 2020-08-13 | France | Reunion | 754 | 5 | 631 | 118 | -21.1151 | 55.5364 | 2020-08-14 04:51:19 | Reunion, France | ||
3531349 | 3531349 | 2020-08-12 | France | Reunion | 734 | 5 | 631 | 98 | -21.1151 | 55.5364 | 2020-08-13 04:29:15 | Reunion, France | ||
662198 | 662198 | 2020-08-11 | France | Reunion | 702 | 5 | 631 | 66 | -21.1151 | 55.5364 | 2020-08-12 04:27:29 | Reunion, France | ||
1920535 | 1920535 | 2020-08-10 | France | Reunion | 690 | 5 | 631 | 54 | -21.1151 | 55.5364 | 2020-08-11 04:35:08 | Reunion, France | ||
3923344 | 3923344 | 2020-08-09 | France | Reunion | 687 | 5 | 631 | 51 | -21.1151 | 55.5364 | 2020-08-10 04:34:55 | Reunion, France | ||
371512 | 371512 | 2020-08-08 | France | Reunion | 681 | 5 | 631 | 45 | -21.1151 | 55.5364 | 2020-08-09 04:34:54 | Reunion, France | ||
371196 | 371196 | 2020-08-08 | Colombia | Boyaca | 1509 | 34 | 631 | 844 | 5.4545 | -73.362 | 2020-08-09 04:34:54 | Boyaca, Colombia | ||
458696 | 458696 | 2020-08-07 | France | Reunion | 675 | 5 | 631 | 39 | -21.1151 | 55.5364 | 2020-08-08 04:34:53 | Reunion, France | ||
1503148 | 1503148 | 2020-07-25 | Liberia | 1135 | 71 | 631 | 433 | 6.4280550000000005 | -9.429499 | 2020-07-26 04:35:00 | Liberia | |||
62214 | 62214 | 2020-07-23 | Australia | Western Australia | 654 | 9 | 631 | 14 | -31.9505 | 115.8605 | 2020-07-24 05:30:40 | Western Australia, Australia | ||
845032 | 845032 | 2020-07-22 | Australia | Western Australia | 654 | 9 | 631 | 14 | -31.9505 | 115.8605 | 2020-07-23 05:15:04 | Western Australia, Australia | ||
1522486 | 1522486 | 2020-06-23 | Russia | Novgorod Oblast | 2535 | 20 | 631 | 1884 | 58.2843833 | 32.5169757 | 2020-06-24 04:33:28 | Novgorod Oblast, Russia | ||
1511034 | 1511034 | 2020-06-22 | Uganda | 774 | 0 | 631 | 143 | 1.373333 | 32.290275 | 2020-06-23 04:33:22 | Uganda | |||
2386788 | 2386788 | 2020-06-16 | Canada | Saskatchewan | 684 | 13 | 631 | 40 | 52.9399 | -106.4509 | 2020-06-17 04:33:21 | Saskatchewan, Canada | ||
1836998 | 1836998 | 2020-06-14 | India | Chhattisgarh | 1512 | 6 | 631 | 875 | 21.264705 | 82.035366 | 2020-06-15 03:33:14 | Chhattisgarh, India | ||
217159 | 217159 | 2020-06-08 | Russia | Kalmykia Republic | 1179 | 16 | 631 | 532 | 46.2313018 | 45.3275745 | 2020-06-09 03:33:03 | Kalmykia Republic, Russia | ||
2548404 | 2548404 | 2020-05-27 | Gabon | 2319 | 14 | 631 | 1674 | -0.8037 | 11.6094 | 2020-05-28 02:32:31 | Gabon | |||
2581445 | 2581445 | 2020-05-12 | China | Shanghai | 660 | 7 | 631 | 22 | 31.202 | 121.4491 | 2020-05-13 03:32:26 | Shanghai, China | ||
418865 | 418865 | 2020-04-18 | Indonesia | 6248 | 535 | 631 | 5082 | -0.7893 | 113.9213 | 2020-04-18 22:32:28 | Indonesia | |||
934261 | 934261 | 2020-04-16 | Argentina | 2571 | 115 | 631 | 1825 | -38.4161 | -63.6167 | 2020-04-16 23:30:31 | Argentina | |||
3562196 | 3562196 | 2020-04-08 | Saudi Arabia | 2932 | 41 | 631 | 2260 | 23.885942 | 45.079162 | 2020-04-08 22:51:39 | Saudi Arabia | |||
3701533 | 3701533 | 2020-04-02 | China | Jiangsu | 647 | 0 | 631 | 16 | 32.9711 | 119.455 | 4/2/20 0:58 | Jiangsu, China | ||
3364737 | 3364737 | 2020-04-01 | China | Jiangsu | 646 | 0 | 631 | 15 | 32.9711 | 119.455 | 2020-03-31 01:10:41 | Jiangsu, China | ||
3815830 | 3815830 | 2020-03-31 | China | Jiangsu | 646 | 0 | 631 | 15 | 32.9711 | 119.455 | 2020-03-31 01:10:41 | Jiangsu, China | ||
1872382 | 1872382 | 2020-03-30 | China | Jiangsu | 645 | 0 | 631 | 14 | 32.9711 | 119.455 | 3/30/20 1:49 | Jiangsu, China | ||
2875619 | 2875619 | 2020-03-29 | China | Jiangsu | 644 | 0 | 631 | 13 | 32.9711 | 119.455 | 3/29/20 2:00 | Jiangsu, China | ||
3946955 | 3946955 | 2020-03-28 | China | Jiangsu | 641 | 0 | 631 | 10 | 32.9711 | 119.455 | 3/27/20 1:49 | Jiangsu, China | ||
809005 | 809005 | 2020-03-27 | China | Jiangsu | 641 | 0 | 631 | 10 | 32.9711 | 119.455 | 2020-03-27 01:49:01 | Jiangsu, China | ||
919098 | 919098 | 2020-03-26 | China | Jiangsu | 640 | 0 | 631 | 9 | 32.9711 | 119.455 | 2020-03-26 01:23:32 | Jiangsu, China | ||
1132501 | 1132501 | 2020-03-25 | China | Jiangsu | 638 | 0 | 631 | 7 | 32.9711 | 119.455 | 2020-03-25 06:43:02 | Jiangsu, China | ||
1479009 | 1479009 | 2020-03-24 | China | Jiangsu | 636 | 0 | 631 | 5 | 32.9711 | 119.455 | 2020-03-24 03:30:55 | Jiangsu, China | ||
2147068 | 2147068 | 2020-03-23 | China | Jiangsu | 633 | 0 | 631 | 2 | 32.9711 | 119.455 | 2020-03-23 01:58:00 | Jiangsu, China | ||
2910619 | 2910619 | 2020-03-22 | China | Jiangsu | 633 | 0 | 631 | 2 | 32.9711 | 119.455 | 3/22/20 7:20 | Jiangsu, China | ||
339662 | 339662 | 2020-03-21 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
3733953 | 3733953 | 2020-03-20 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
1526902 | 1526902 | 2020-03-19 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
1176902 | 1176902 | 2020-03-18 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
3891333 | 3891333 | 2020-03-17 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
2255138 | 2255138 | 2020-03-16 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
1463487 | 1463487 | 2020-03-15 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 |
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]);