johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where recovered = 673 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137352 | 3137352 | 2021-07-23 | China | Fujian | 715 | 1 | 673 | 41 | 26.0789 | 117.9874 | 2021-07-24 00:21:36 | Fujian, China | ||
3453050 | 3453050 | 2021-03-18 | Russia | Chukotka Autonomous Okrug | 714 | 5 | 673 | 36 | 66.0006475 | 169.4900869 | 2021-03-19 05:26:09 | Chukotka Autonomous Okrug, Russia | ||
3621274 | 3621274 | 2021-03-17 | Russia | Chukotka Autonomous Okrug | 712 | 5 | 673 | 34 | 66.0006475 | 169.4900869 | 2021-03-18 05:26:22 | Chukotka Autonomous Okrug, Russia | ||
702598 | 702598 | 2021-03-16 | Russia | Chukotka Autonomous Okrug | 709 | 5 | 673 | 31 | 66.0006475 | 169.4900869 | 2021-03-17 05:25:07 | Chukotka Autonomous Okrug, Russia | ||
2641365 | 2641365 | 2021-02-11 | United Kingdom | Bermuda | 694 | 12 | 673 | 9 | 32.3078 | -64.7505 | 2021-02-12 05:23:29 | Bermuda, United Kingdom | ||
3982220 | 3982220 | 2021-02-10 | United Kingdom | Bermuda | 694 | 12 | 673 | 9 | 32.3078 | -64.7505 | 2021-02-11 05:23:55 | Bermuda, United Kingdom | ||
1531540 | 1531540 | 2021-02-09 | United Kingdom | Bermuda | 694 | 12 | 673 | 9 | 32.3078 | -64.7505 | 2021-02-10 05:22:41 | Bermuda, United Kingdom | ||
3515422 | 3515422 | 2021-01-15 | Japan | Kochi | 761 | 12 | 673 | 76 | 33.422519 | 133.367307 | 2021-01-16 05:22:40 | Kochi, Japan | ||
1136891 | 1136891 | 2021-01-01 | Japan | Fukushima | 956 | 21 | 673 | 262 | 37.378867 | 140.223295 | 2021-01-02 05:22:33 | Fukushima, Japan | ||
3778012 | 3778012 | 2020-12-27 | Monaco | 797 | 3 | 673 | 121 | 43.7333 | 7.4167 | 2020-12-28 05:22:06 | Monaco | |||
2223617 | 2223617 | 2020-12-26 | Monaco | 797 | 3 | 673 | 121 | 43.7333 | 7.4167 | 2020-12-27 05:22:55 | Monaco | |||
860902 | 860902 | 2020-12-11 | Russia | Nenets Autonomous Okrug | 706 | 0 | 673 | 33 | 68.27557185 | 57.1686375 | 2020-12-12 05:26:19 | Nenets Autonomous Okrug, Russia | ||
1600444 | 1600444 | 2020-12-10 | Russia | Nenets Autonomous Okrug | 699 | 0 | 673 | 26 | 68.27557185 | 57.1686375 | 2020-12-11 05:26:59 | Nenets Autonomous Okrug, Russia | ||
2975453 | 2975453 | 2020-12-09 | Russia | Nenets Autonomous Okrug | 694 | 0 | 673 | 21 | 68.27557185 | 57.1686375 | 2020-12-10 05:26:19 | Nenets Autonomous Okrug, Russia | ||
1819013 | 1819013 | 2020-12-08 | Russia | Nenets Autonomous Okrug | 688 | 0 | 673 | 15 | 68.27557185 | 57.1686375 | 2020-12-09 05:28:01 | Nenets Autonomous Okrug, Russia | ||
379828 | 379828 | 2020-11-06 | United Kingdom | Gibraltar | 770 | 0 | 673 | 97 | 36.1408 | -5.3536 | 2020-11-07 05:24:52 | Gibraltar, United Kingdom | ||
762327 | 762327 | 2020-10-18 | Japan | Ibaraki | 728 | 18 | 673 | 37 | 36.303588 | 140.319591 | 2020-10-19 04:24:16 | Ibaraki, Japan | ||
1030001 | 1030001 | 2020-10-17 | United Kingdom | Turks and Caicos Islands | 698 | 6 | 673 | 19 | 21.694000000000006 | -71.7979 | 2020-10-18 04:24:25 | Turks and Caicos Islands, United Kingdom | ||
1026365 | 1026365 | 2020-10-17 | Japan | Ibaraki | 725 | 18 | 673 | 34 | 36.303588 | 140.319591 | 2020-10-18 04:24:25 | Ibaraki, Japan | ||
790025 | 790025 | 2020-10-15 | United Kingdom | Turks and Caicos Islands | 696 | 6 | 673 | 17 | 21.694000000000006 | -71.7979 | 2020-10-16 04:24:01 | Turks and Caicos Islands, United Kingdom | ||
82736 | 82736 | 2020-10-14 | United Kingdom | Turks and Caicos Islands | 696 | 6 | 673 | 17 | 21.694000000000006 | -71.7979 | 2020-10-15 04:24:28 | Turks and Caicos Islands, United Kingdom | ||
3785551 | 3785551 | 2020-10-13 | United Kingdom | Turks and Caicos Islands | 696 | 6 | 673 | 17 | 21.694000000000006 | -71.7979 | 2020-10-14 04:24:05 | Turks and Caicos Islands, United Kingdom | ||
2601861 | 2601861 | 2020-10-10 | China | Sichuan | 721 | 3 | 673 | 45 | 30.6171 | 102.7103 | 2020-10-11 04:23:46 | Sichuan, China | ||
2582178 | 2582178 | 2020-09-27 | Russia | Jewish Autonomous Okrug | 883 | 12 | 673 | 198 | 48.57527615 | 132.6630746 | 2020-09-28 04:23:00 | Jewish Autonomous Okrug, Russia | ||
2614230 | 2614230 | 2020-09-26 | Russia | Jewish Autonomous Okrug | 868 | 11 | 673 | 184 | 48.57527615 | 132.6630746 | 2020-09-27 04:23:00 | Jewish Autonomous Okrug, Russia | ||
431010 | 431010 | 2020-09-07 | Malaysia | Sarawak | 699 | 19 | 673 | 7 | 1.5533 | 110.3592 | 2020-09-08 04:28:25 | Sarawak, Malaysia | ||
193903 | 193903 | 2020-08-31 | Colombia | Arauca | 925 | 17 | 673 | 235 | 7.0762 | -70.7105 | 2020-09-01 04:28:31 | Arauca, Colombia | ||
2303062 | 2303062 | 2020-08-22 | Ukraine | Kirovohrad Oblast | 756 | 45 | 673 | 38 | 48.5079 | 32.2623 | 2020-08-23 04:27:48 | Kirovohrad Oblast, Ukraine | ||
1555935 | 1555935 | 2020-08-16 | India | Sikkim | 1167 | 1 | 673 | 493 | 27.571671 | 88.472712 | 2020-08-17 04:27:20 | Sikkim, India | ||
98747 | 98747 | 2020-08-04 | Togo | 988 | 19 | 673 | 296 | 8.6195 | 0.8248 | 2020-08-05 04:34:43 | Togo | |||
2808318 | 2808318 | 2020-08-02 | Liberia | 1189 | 75 | 673 | 441 | 6.4280550000000005 | -9.429499 | 2020-08-03 04:34:35 | Liberia | |||
753886 | 753886 | 2020-08-01 | Liberia | 1186 | 75 | 673 | 438 | 6.4280550000000005 | -9.429499 | 2020-08-02 04:34:47 | Liberia | |||
1707372 | 1707372 | 2020-07-21 | Mexico | Colima | 1249 | 145 | 673 | 431 | 19.1223 | -104.0072 | 2020-07-22 04:34:42 | Colima, Mexico | ||
367349 | 367349 | 2020-07-16 | Japan | Hyogo | 776 | 45 | 673 | 58 | 35.039913 | 134.828057 | 2020-07-17 04:34:50 | Hyogo, Japan | ||
887779 | 887779 | 2020-07-07 | Malaysia | Johor | 697 | 19 | 673 | 5 | 1.4854 | 103.7618 | 2020-07-08 05:33:48 | Johor, Malaysia | ||
2685339 | 2685339 | 2020-07-06 | Malaysia | Johor | 696 | 19 | 673 | 4 | 1.4854 | 103.7618 | 2020-07-07 04:34:00 | Johor, Malaysia | ||
287584 | 287584 | 2020-06-15 | Paraguay | 1296 | 12 | 673 | 611 | -23.4425 | -58.4438 | 2020-06-16 04:33:09 | Paraguay | |||
737416 | 737416 | 2020-06-12 | Pakistan | Gilgit-Baltistan | 1030 | 15 | 673 | 342 | 35.792146 | 74.982138 | 2020-06-13 03:33:14 | Gilgit-Baltistan, Pakistan | ||
1273386 | 1273386 | 2020-06-11 | Pakistan | Gilgit-Baltistan | 1030 | 15 | 673 | 342 | 35.792146 | 74.982138 | 2020-06-12 05:09:52 | Gilgit-Baltistan, Pakistan | ||
2863808 | 2863808 | 2020-06-10 | Ukraine | Dnipropetrovsk Oblast | 973 | 22 | 673 | 278 | 48.4647 | 35.0462 | 2020-06-11 03:33:41 | Dnipropetrovsk Oblast, Ukraine |
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]);