johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where recovered = 529 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1841985 | 1841985 | 2021-04-14 | Japan | Tokushima | 761 | 24 | 529 | 208 | 33.919178 | 134.242091 | 2021-04-15 04:20:54 | Tokushima, Japan | ||
3085305 | 3085305 | 2021-04-05 | Japan | Fukui | 619 | 25 | 529 | 65 | 35.846614 | 136.22465400000002 | 2021-04-06 04:20:32 | Fukui, Japan | ||
3369375 | 3369375 | 2021-03-21 | Japan | Yamagata | 646 | 16 | 529 | 101 | 38.448396 | 140.102154 | 2021-03-22 05:25:43 | Yamagata, Japan | ||
1744585 | 1744585 | 2021-03-20 | Japan | Yamagata | 615 | 16 | 529 | 70 | 38.448396 | 140.102154 | 2021-03-21 05:25:44 | Yamagata, Japan | ||
3539281 | 3539281 | 2021-02-12 | China | Shaanxi | 543 | 3 | 529 | 11 | 35.1917 | 108.8701 | 2021-02-13 05:22:12 | Shaanxi, China | ||
2637544 | 2637544 | 2021-02-11 | China | Shaanxi | 543 | 3 | 529 | 11 | 35.1917 | 108.8701 | 2021-02-12 05:23:29 | Shaanxi, China | ||
3978399 | 3978399 | 2021-02-10 | China | Shaanxi | 543 | 3 | 529 | 11 | 35.1917 | 108.8701 | 2021-02-11 05:23:55 | Shaanxi, China | ||
1672259 | 1672259 | 2021-02-07 | China | Fujian | 545 | 1 | 529 | 15 | 26.0789 | 117.9874 | 2021-02-08 05:22:39 | Fujian, China | ||
974720 | 974720 | 2021-02-06 | China | Fujian | 545 | 1 | 529 | 15 | 26.0789 | 117.9874 | 2021-02-07 05:23:00 | Fujian, China | ||
3503360 | 3503360 | 2021-01-17 | Japan | Aomori | 643 | 8 | 529 | 106 | 40.781541 | 140.828896 | 2021-01-18 05:22:34 | Aomori, Japan | ||
2223538 | 2223538 | 2020-12-26 | Japan | Oita | 617 | 5 | 529 | 83 | 33.200697 | 131.43323999999998 | 2020-12-27 05:22:55 | Oita, Japan | ||
1584203 | 1584203 | 2020-11-30 | Japan | Tochigi | 638 | 2 | 529 | 107 | 36.689912 | 139.819213 | 2020-12-01 05:26:18 | Tochigi, Japan | ||
2919218 | 2919218 | 2020-11-04 | Japan | Shiga | 563 | 9 | 529 | 25 | 35.21582700000001 | 136.138064 | 2020-11-05 06:05:03 | Shiga, Japan | ||
1177516 | 1177516 | 2020-10-22 | Japan | Mie | 554 | 7 | 529 | 18 | 34.508018 | 136.376013 | 2020-10-23 04:24:46 | Mie, Japan | ||
817577 | 817577 | 2020-10-09 | Japan | Hiroshima | 622 | 3 | 529 | 90 | 34.605309000000005 | 132.788719 | 2020-10-10 04:23:57 | Hiroshima, Japan | ||
2653796 | 2653796 | 2020-09-23 | Japan | Nara | 551 | 9 | 529 | 13 | 34.317451 | 135.871644 | 2020-09-24 04:23:00 | Nara, Japan | ||
3316245 | 3316245 | 2020-09-22 | Japan | Nara | 549 | 9 | 529 | 11 | 34.317451 | 135.871644 | 2020-09-23 04:23:00 | Nara, Japan | ||
2836844 | 2836844 | 2020-09-21 | Japan | Nara | 548 | 9 | 529 | 10 | 34.317451 | 135.871644 | 2020-09-22 04:23:00 | Nara, Japan | ||
1928150 | 1928150 | 2020-07-30 | Japan | Aichi | 1636 | 35 | 529 | 1072 | 35.035551 | 137.211621 | 2020-07-31 04:35:18 | Aichi, Japan | ||
844617 | 844617 | 2020-07-22 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-23 05:15:04 | Channel Islands, United Kingdom | ||
1707356 | 1707356 | 2020-07-21 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-22 04:34:42 | Channel Islands, United Kingdom | ||
326847 | 326847 | 2020-07-20 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-21 04:38:46 | Channel Islands, United Kingdom | ||
121752 | 121752 | 2020-07-19 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-20 05:34:40 | Channel Islands, United Kingdom | ||
3205141 | 3205141 | 2020-07-18 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-19 04:34:58 | Channel Islands, United Kingdom | ||
2708443 | 2708443 | 2020-07-17 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-18 04:34:45 | Channel Islands, United Kingdom | ||
367262 | 367262 | 2020-07-16 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-17 04:34:50 | Channel Islands, United Kingdom | ||
2222574 | 2222574 | 2020-07-08 | Ukraine | Cherkasy Oblast | 695 | 27 | 529 | 139 | 49.4444 | 32.0598 | 2020-07-09 04:34:23 | Cherkasy Oblast, Ukraine | ||
2306410 | 2306410 | 2020-06-28 | India | Himachal Pradesh | 916 | 9 | 529 | 378 | 31.927213000000002 | 77.233081 | 2020-06-29 04:33:44 | Himachal Pradesh, India | ||
2039799 | 2039799 | 2020-06-27 | Ukraine | Kirovohrad Oblast | 642 | 31 | 529 | 82 | 48.5079 | 32.2623 | 2020-06-28 04:34:04 | Kirovohrad Oblast, Ukraine | ||
2555646 | 2555646 | 2020-06-02 | Mexico | Baja California Sur | 660 | 35 | 529 | 96 | 26.0444 | -111.6661 | 2020-06-03 02:33:13 | Baja California Sur, Mexico | ||
1432206 | 1432206 | 2020-05-20 | Malaysia | Johor | 672 | 18 | 529 | 125 | 1.4854 | 103.7618 | 2020-05-21 02:32:48 | Johor, Malaysia | ||
2390426 | 2390426 | 2020-05-19 | Malaysia | Johor | 672 | 18 | 529 | 125 | 1.4854 | 103.7618 | 2020-05-20 02:32:19 | Johor, Malaysia | ||
2390342 | 2390342 | 2020-05-19 | Mali | 901 | 53 | 529 | 319 | 17.570692 | -3.996166000000001 | 2020-05-20 02:32:19 | Mali | |||
934294 | 934294 | 2020-04-16 | Croatia | 1791 | 35 | 529 | 1227 | 45.1 | 15.2 | 2020-04-16 23:30:31 | Croatia |
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]);