johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where recovered = 497 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3456507 | 3456507 | 2021-03-18 | United Kingdom | Isle of Man | 1411 | 26 | 497 | 888 | 54.2361 | -4.5481 | 2021-03-19 05:26:09 | Isle of Man, United Kingdom | ||
2183598 | 2183598 | 2021-02-26 | Japan | Iwate | 553 | 30 | 497 | 26 | 39.593287 | 141.361777 | 2021-02-27 05:22:28 | Iwate, Japan | ||
1858020 | 1858020 | 2021-02-25 | Japan | Iwate | 553 | 30 | 497 | 26 | 39.593287 | 141.361777 | 2021-02-26 05:22:40 | Iwate, Japan | ||
2625674 | 2625674 | 2021-01-10 | China | Fujian | 527 | 1 | 497 | 29 | 26.0789 | 117.9874 | 2021-01-11 05:21:50 | Fujian, China | ||
3899988 | 3899988 | 2021-01-09 | Japan | Niigata | 640 | 3 | 497 | 140 | 37.521819 | 138.918647 | 2021-01-10 05:22:12 | Niigata, Japan | ||
3899782 | 3899782 | 2021-01-09 | China | Shaanxi | 522 | 3 | 497 | 22 | 35.1917 | 108.8701 | 2021-01-10 05:22:12 | Shaanxi, China | ||
3899762 | 3899762 | 2021-01-09 | China | Fujian | 526 | 1 | 497 | 28 | 26.0789 | 117.9874 | 2021-01-10 05:22:12 | Fujian, China | ||
3699164 | 3699164 | 2020-12-31 | Malaysia | Kelantan | 758 | 8 | 497 | 253 | 6.1254 | 102.2381 | 2021-01-01 05:23:07 | Kelantan, Malaysia | ||
2406860 | 2406860 | 2020-12-23 | Japan | Oita | 587 | 5 | 497 | 85 | 33.200697 | 131.43323999999998 | 2020-12-24 05:23:04 | Oita, Japan | ||
1751292 | 1751292 | 2020-12-14 | Japan | Miyazaki | 611 | 3 | 497 | 111 | 32.193203999999994 | 131.299374 | 2020-12-15 05:26:38 | Miyazaki, Japan | ||
3847812 | 3847812 | 2020-12-13 | Japan | Miyazaki | 605 | 3 | 497 | 105 | 32.193203999999994 | 131.299374 | 2020-12-14 05:26:27 | Miyazaki, Japan | ||
3847795 | 3847795 | 2020-12-13 | Japan | Fukushima | 611 | 8 | 497 | 106 | 37.378867 | 140.223295 | 2020-12-14 05:26:27 | Fukushima, Japan | ||
845594 | 845594 | 2020-12-12 | Japan | Miyazaki | 590 | 3 | 497 | 90 | 32.193203999999994 | 131.299374 | 2020-12-13 05:27:20 | Miyazaki, Japan | ||
678188 | 678188 | 2020-11-23 | Denmark | Faroe Islands | 500 | 0 | 497 | 3 | 61.8926 | -6.9118 | 2020-11-24 05:27:31 | Faroe Islands, Denmark | ||
3189864 | 3189864 | 2020-11-22 | Denmark | Faroe Islands | 500 | 0 | 497 | 3 | 61.8926 | -6.9118 | 2020-11-23 05:25:26 | Faroe Islands, Denmark | ||
821678 | 821678 | 2020-11-19 | Monaco | 573 | 3 | 497 | 73 | 43.7333 | 7.4167 | 2020-11-20 05:26:28 | Monaco | |||
3651331 | 3651331 | 2020-10-24 | Burundi | 555 | 1 | 497 | 57 | -3.3731 | 29.9189 | 2020-10-25 04:24:36 | Burundi | |||
1054150 | 1054150 | 2020-10-23 | Taiwan* | 548 | 7 | 497 | 44 | 23.7 | 121.0 | 2020-10-24 04:24:46 | Taiwan* | |||
1053847 | 1053847 | 2020-10-23 | Japan | Miyagi | 565 | 2 | 497 | 66 | 38.446859 | 140.927086 | 2020-10-24 04:24:46 | Miyagi, Japan | ||
1053586 | 1053586 | 2020-10-23 | Burundi | 553 | 1 | 497 | 55 | -3.3731 | 29.9189 | 2020-10-24 04:24:46 | Burundi | |||
1177820 | 1177820 | 2020-10-22 | Taiwan* | 548 | 7 | 497 | 44 | 23.7 | 121.0 | 2020-10-23 04:24:46 | Taiwan* | |||
1177256 | 1177256 | 2020-10-22 | Burundi | 551 | 1 | 497 | 53 | -3.3731 | 29.9189 | 2020-10-23 04:24:46 | Burundi | |||
2191361 | 2191361 | 2020-10-21 | Burundi | 550 | 1 | 497 | 52 | -3.3731 | 29.9189 | 2020-10-22 04:24:27 | Burundi | |||
3990372 | 3990372 | 2020-10-20 | Burundi | 550 | 1 | 497 | 52 | -3.3731 | 29.9189 | 2020-10-21 04:24:14 | Burundi | |||
1794392 | 1794392 | 2020-10-19 | Burundi | 549 | 1 | 497 | 51 | -3.3731 | 29.9189 | 2020-10-20 04:24:22 | Burundi | |||
762350 | 762350 | 2020-10-18 | Japan | Shiga | 524 | 8 | 497 | 19 | 35.21582700000001 | 136.138064 | 2020-10-19 04:24:16 | Shiga, Japan | ||
762076 | 762076 | 2020-10-18 | Burundi | 542 | 1 | 497 | 44 | -3.3731 | 29.9189 | 2020-10-19 04:24:16 | Burundi | |||
1026388 | 1026388 | 2020-10-17 | Japan | Shiga | 522 | 8 | 497 | 17 | 35.21582700000001 | 136.138064 | 2020-10-18 04:24:25 | Shiga, Japan | ||
1026114 | 1026114 | 2020-10-17 | Burundi | 536 | 1 | 497 | 38 | -3.3731 | 29.9189 | 2020-10-18 04:24:25 | Burundi | |||
2856609 | 2856609 | 2020-10-16 | Burundi | 531 | 1 | 497 | 33 | -3.3731 | 29.9189 | 2020-10-17 04:24:12 | Burundi | |||
786139 | 786139 | 2020-10-15 | Burundi | 529 | 1 | 497 | 31 | -3.3731 | 29.9189 | 2020-10-16 04:24:01 | Burundi | |||
78850 | 78850 | 2020-10-14 | Burundi | 529 | 1 | 497 | 31 | -3.3731 | 29.9189 | 2020-10-15 04:24:28 | Burundi | |||
3785918 | 3785918 | 2020-10-11 | Japan | Mie | 538 | 7 | 497 | 34 | 34.508018 | 136.376013 | 2020-10-12 04:23:45 | Mie, Japan | ||
1822766 | 1822766 | 2020-10-04 | Italy | Basilicata | 920 | 33 | 497 | 390 | 40.63947052 | 15.80514834 | 2020-10-05 04:23:33 | Basilicata, Italy | ||
2609640 | 2609640 | 2020-09-24 | Ukraine | Kherson Oblast | 905 | 21 | 497 | 387 | 46.6354 | 32.6169 | 2020-09-25 04:23:00 | Kherson Oblast, Ukraine | ||
1125213 | 1125213 | 2020-09-17 | Ukraine | Sevastopol* | 713 | 21 | 497 | 195 | 44.6054 | 33.522 | 2020-09-18 05:05:00 | Sevastopol*, Ukraine | ||
1173210 | 1173210 | 2020-09-10 | Japan | Nara | 536 | 8 | 497 | 31 | 34.317451 | 135.871644 | 2020-09-11 04:46:23 | Nara, Japan | ||
2222587 | 2222587 | 2020-07-08 | Mexico | Colima | 757 | 94 | 497 | 166 | 19.1223 | -104.0072 | 2020-07-09 04:34:23 | Colima, Mexico | ||
3682880 | 3682880 | 2020-06-18 | Russia | Tyva Republic | 2883 | 3 | 497 | 2383 | 51.4017149 | 93.8582593 | 2020-06-19 04:33:17 | Tyva Republic, Russia | ||
3682645 | 3682645 | 2020-06-18 | Ukraine | Kirovohrad Oblast | 604 | 30 | 497 | 77 | 48.5079 | 32.2623 | 2020-06-19 04:33:17 | Kirovohrad Oblast, Ukraine | ||
1793821 | 1793821 | 2020-05-31 | Mexico | Baja California Sur | 631 | 35 | 497 | 99 | 26.0444 | -111.6661 | 2020-06-01 02:32:46 | Baja California Sur, Mexico | ||
2712509 | 2712509 | 2020-05-28 | Jordan | 728 | 9 | 497 | 222 | 31.24 | 36.51 | 2020-05-29 02:32:50 | Jordan |
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]);