johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where recovered = 545 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1872728 | 1872728 | 2021-05-15 | Canada | Nunavut | 623 | 4 | 545 | 74 | 70.2998 | -83.1076 | 2021-05-16 04:20:49 | Nunavut, Canada | ||
3663429 | 3663429 | 2021-03-09 | China | Shaanxi | 558 | 3 | 545 | 10 | 35.1917 | 108.8701 | 2021-03-10 05:24:35 | Shaanxi, China | ||
2359288 | 2359288 | 2021-03-08 | China | Shaanxi | 557 | 3 | 545 | 9 | 35.1917 | 108.8701 | 2021-03-09 05:28:19 | Shaanxi, China | ||
54626 | 54626 | 2021-03-07 | China | Shaanxi | 557 | 3 | 545 | 9 | 35.1917 | 108.8701 | 2021-03-08 05:24:48 | Shaanxi, China | ||
1936267 | 1936267 | 2021-02-23 | China | Jilin | 573 | 3 | 545 | 25 | 43.6661 | 126.1923 | 2021-02-24 05:29:16 | Jilin, China | ||
3879604 | 3879604 | 2021-01-14 | Japan | Niigata | 738 | 5 | 545 | 188 | 37.521819 | 138.918647 | 2021-01-15 05:22:24 | Niigata, Japan | ||
1065522 | 1065522 | 2021-01-04 | Malaysia | Kelantan | 934 | 9 | 545 | 380 | 6.1254 | 102.2381 | 2021-01-05 05:21:49 | Kelantan, Malaysia | ||
2119721 | 2119721 | 2020-12-20 | Japan | Fukushima | 737 | 10 | 545 | 182 | 37.378867 | 140.223295 | 2020-12-21 05:27:58 | Fukushima, Japan | ||
1584389 | 1584389 | 2020-11-30 | Russia | Nenets Autonomous Okrug | 655 | 0 | 545 | 110 | 68.27557185 | 57.1686375 | 2020-12-01 05:26:18 | Nenets Autonomous Okrug, Russia | ||
821898 | 821898 | 2020-11-19 | Taiwan* | 609 | 7 | 545 | 57 | 23.7 | 121.0 | 2020-11-20 05:26:28 | Taiwan* | |||
8477 | 8477 | 2020-10-25 | Papua New Guinea | 583 | 7 | 545 | 31 | -6.314993 | 143.95555 | 2020-10-26 04:25:02 | Papua New Guinea | |||
3651714 | 3651714 | 2020-10-24 | Papua New Guinea | 583 | 7 | 545 | 31 | -6.314993 | 143.95555 | 2020-10-25 04:24:36 | Papua New Guinea | |||
1053969 | 1053969 | 2020-10-23 | Papua New Guinea | 583 | 7 | 545 | 31 | -6.314993 | 143.95555 | 2020-10-24 04:24:46 | Papua New Guinea | |||
1177639 | 1177639 | 2020-10-22 | Papua New Guinea | 583 | 7 | 545 | 31 | -6.314993 | 143.95555 | 2020-10-23 04:24:46 | Papua New Guinea | |||
2379657 | 2379657 | 2020-10-01 | Japan | Nara | 567 | 9 | 545 | 13 | 34.317451 | 135.871644 | 2020-10-02 04:23:51 | Nara, Japan | ||
3316238 | 3316238 | 2020-09-22 | Japan | Kumamoto | 571 | 8 | 545 | 18 | 32.608154 | 130.745231 | 2020-09-23 04:23:00 | Kumamoto, Japan | ||
2836837 | 2836837 | 2020-09-21 | Japan | Kumamoto | 571 | 8 | 545 | 18 | 32.608154 | 130.745231 | 2020-09-22 04:23:00 | Kumamoto, Japan | ||
2868722 | 2868722 | 2020-09-13 | Japan | Gifu | 592 | 10 | 545 | 37 | 35.778671 | 137.055925 | 2020-09-14 04:26:00 | Gifu, Japan | ||
546761 | 546761 | 2020-09-12 | Japan | Gifu | 580 | 10 | 545 | 25 | 35.778671 | 137.055925 | 2020-09-13 04:30:52 | Gifu, Japan | ||
2063519 | 2063519 | 2020-09-01 | United Kingdom | Channel Islands | 0 | 0 | 545 | 37 | 49.3723 | -2.3644 | 2020-09-02 04:28:25 | Channel Islands, United Kingdom | ||
197704 | 197704 | 2020-08-31 | United Kingdom | Channel Islands | 0 | 0 | 545 | 32 | 49.3723 | -2.3644 | 2020-09-01 04:28:31 | Channel Islands, United Kingdom | ||
3935659 | 3935659 | 2020-08-30 | United Kingdom | Channel Islands | 0 | 0 | 545 | 32 | 49.3723 | -2.3644 | 2020-08-31 04:28:27 | Channel Islands, United Kingdom | ||
613321 | 613321 | 2020-08-29 | United Kingdom | Channel Islands | 0 | 0 | 545 | 32 | 49.3723 | -2.3644 | 2020-08-30 04:28:22 | Channel Islands, United Kingdom | ||
1526816 | 1526816 | 2020-08-28 | United Kingdom | Channel Islands | 0 | 0 | 545 | 32 | 49.3723 | -2.3644 | 2020-08-29 04:28:19 | Channel Islands, United Kingdom | ||
2513817 | 2513817 | 2020-08-27 | United Kingdom | Channel Islands | 0 | 0 | 545 | 30 | 49.3723 | -2.3644 | 2020-08-28 04:28:11 | Channel Islands, United Kingdom | ||
2000277 | 2000277 | 2020-08-26 | United Kingdom | Channel Islands | 0 | 0 | 545 | 30 | 49.3723 | -2.3644 | 2020-08-27 04:28:15 | Channel Islands, United Kingdom | ||
3566201 | 3566201 | 2020-08-25 | United Kingdom | Channel Islands | 0 | 0 | 545 | 27 | 49.3723 | -2.3644 | 2020-08-26 04:28:11 | Channel Islands, United Kingdom | ||
2994905 | 2994905 | 2020-08-24 | United Kingdom | Channel Islands | 0 | 0 | 545 | 23 | 49.3723 | -2.3644 | 2020-08-25 04:28:02 | Channel Islands, United Kingdom | ||
2219300 | 2219300 | 2020-08-23 | United Kingdom | Channel Islands | 0 | 0 | 545 | 21 | 49.3723 | -2.3644 | 2020-08-24 04:27:56 | Channel Islands, United Kingdom | ||
2303082 | 2303082 | 2020-08-22 | United Kingdom | Channel Islands | 0 | 0 | 545 | 21 | 49.3723 | -2.3644 | 2020-08-23 04:27:48 | Channel Islands, United Kingdom | ||
1483203 | 1483203 | 2020-08-21 | Vietnam | 1009 | 25 | 545 | 439 | 14.058324 | 108.277199 | 2020-08-22 04:27:49 | Vietnam | |||
1483188 | 1483188 | 2020-08-21 | United Kingdom | Channel Islands | 0 | 0 | 545 | 21 | 49.3723 | -2.3644 | 2020-08-22 04:27:49 | Channel Islands, United Kingdom | ||
3487937 | 3487937 | 2020-08-20 | United Kingdom | Channel Islands | 0 | 0 | 545 | 20 | 49.3723 | -2.3644 | 2020-08-21 04:27:41 | Channel Islands, United Kingdom | ||
209886 | 209886 | 2020-08-19 | United Kingdom | Channel Islands | 0 | 0 | 545 | 20 | 49.3723 | -2.3644 | 2020-08-20 04:27:43 | Channel Islands, United Kingdom | ||
3181638 | 3181638 | 2020-08-18 | United Kingdom | Channel Islands | 0 | 0 | 545 | 17 | 49.3723 | -2.3644 | 2020-08-19 04:27:00 | Channel Islands, United Kingdom | ||
841242 | 841242 | 2020-08-17 | United Kingdom | Channel Islands | 0 | 0 | 545 | 17 | 49.3723 | -2.3644 | 2020-08-18 04:27:56 | Channel Islands, United Kingdom | ||
837443 | 837443 | 2020-08-17 | China | Xinjiang | 902 | 3 | 545 | 354 | 41.1129 | 85.2401 | 2020-08-18 04:27:56 | Xinjiang, China | ||
1559598 | 1559598 | 2020-08-16 | United Kingdom | Channel Islands | 0 | 0 | 545 | 15 | 49.3723 | -2.3644 | 2020-08-17 04:27:20 | Channel Islands, United Kingdom | ||
149600 | 149600 | 2020-08-15 | United Kingdom | Channel Islands | 0 | 0 | 545 | 15 | 49.3723 | -2.3644 | 2020-08-16 04:27:42 | Channel Islands, United Kingdom | ||
1615875 | 1615875 | 2020-08-14 | United Kingdom | Channel Islands | 0 | 0 | 545 | 15 | 49.3723 | -2.3644 | 2020-08-15 04:27:31 | Channel Islands, United Kingdom | ||
586459 | 586459 | 2020-08-13 | United Kingdom | Channel Islands | 0 | 0 | 545 | 11 | 49.3723 | -2.3644 | 2020-08-14 04:51:19 | Channel Islands, United Kingdom | ||
3535076 | 3535076 | 2020-08-12 | United Kingdom | Channel Islands | 0 | 0 | 545 | 11 | 49.3723 | -2.3644 | 2020-08-13 04:29:15 | Channel Islands, United Kingdom | ||
662666 | 662666 | 2020-08-11 | United Kingdom | Channel Islands | 0 | 0 | 545 | 7 | 49.3723 | -2.3644 | 2020-08-12 04:27:29 | Channel Islands, United Kingdom | ||
1920247 | 1920247 | 2020-08-10 | United Kingdom | Channel Islands | 0 | 0 | 545 | 7 | 49.3723 | -2.3644 | 2020-08-11 04:35:08 | Channel Islands, United Kingdom | ||
530375 | 530375 | 2020-07-04 | Malaysia | Sarawak | 571 | 17 | 545 | 9 | 1.5533 | 110.3592 | 2020-07-05 04:33:46 | Sarawak, Malaysia | ||
2235036 | 2235036 | 2020-07-03 | Malaysia | Sarawak | 571 | 17 | 545 | 9 | 1.5533 | 110.3592 | 2020-07-04 04:33:51 | Sarawak, Malaysia | ||
1837468 | 1837468 | 2020-06-14 | Ethiopia | 3345 | 57 | 545 | 2743 | 9.145 | 40.4897 | 2020-06-15 03:33:14 | Ethiopia | |||
2799965 | 2799965 | 2020-06-07 | Ukraine | Kharkiv Oblast | 1251 | 52 | 545 | 654 | 49.9935 | 36.2304 | 2020-06-08 03:33:22 | Kharkiv Oblast, Ukraine | ||
1790223 | 1790223 | 2020-05-29 | Mexico | Aguascalientes | 797 | 33 | 545 | 219 | 21.8853 | -102.2916 | 2020-05-30 02:32:48 | Aguascalientes, Mexico | ||
1864926 | 1864926 | 2020-05-22 | Australia | Western Australia | 557 | 9 | 545 | 3 | -31.9505 | 115.8605 | 2020-05-23 02:32:42 | Western Australia, Australia | ||
268432 | 268432 | 2020-05-21 | Australia | Western Australia | 557 | 9 | 545 | 3 | -31.9505 | 115.8605 | 2020-05-22 02:36:51 | Western Australia, Australia | ||
1432015 | 1432015 | 2020-05-20 | Australia | Western Australia | 557 | 9 | 545 | 3 | -31.9505 | 115.8605 | 2020-05-21 02:32:48 | Western Australia, Australia | ||
2390234 | 2390234 | 2020-05-19 | Australia | Western Australia | 557 | 9 | 545 | 3 | -31.9505 | 115.8605 | 2020-05-20 02:32:19 | Western Australia, Australia | ||
3260972 | 3260972 | 2020-05-18 | Australia | Western Australia | 557 | 9 | 545 | 3 | -31.9505 | 115.8605 | 2020-05-19 02:32:18 | Western Australia, Australia | ||
3276345 | 3276345 | 2020-05-15 | Bulgaria | 2138 | 102 | 545 | 1491 | 42.7339 | 25.4858 | 2020-05-16 02:32:19 | Bulgaria | |||
3847430 | 3847430 | 2020-05-13 | Uruguay | 719 | 19 | 545 | 155 | -32.5228 | -55.7658 | 2020-05-14 03:32:28 | Uruguay | |||
2899155 | 2899155 | 2020-05-09 | Andorra | 754 | 48 | 545 | 161 | 42.5063 | 1.5218 | 2020-05-10 02:32:30 | Andorra | |||
3084793 | 3084793 | 2020-05-04 | Burkina Faso | 672 | 46 | 545 | 81 | 12.2383 | -1.5616 | 2020-05-05 02:32:34 | Burkina Faso | |||
1385108 | 1385108 | 2020-04-19 | Armenia | 1291 | 20 | 545 | 726 | 40.0691 | 45.0382 | 2020-04-19 23:40:41 | Armenia |
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]);