johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where recovered = 783 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- Japan 10
- China 7
- United Kingdom 5
- Ukraine 3
- Colombia 2
- Albania 1
- Algeria 1
- Chile 1
- Kyrgyzstan 1
- Mainland China 1
- Netherlands 1
- Niger 1
- Taiwan* 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1165169 | 1165169 | 2021-07-04 | Japan | Akita | 907 | 20 | 783 | 104 | 39.748679 | 140.408228 | 2021-07-05 04:21:28 | Akita, Japan | ||
3962522 | 3962522 | 2021-03-10 | Japan | Aomori | 828 | 20 | 783 | 25 | 40.781541 | 140.828896 | 2021-03-11 05:25:48 | Aomori, Japan | ||
1459802 | 1459802 | 2021-01-31 | Japan | Toyama | 872 | 27 | 783 | 62 | 36.637464 | 137.26934599999998 | 2021-02-01 05:22:53 | Toyama, Japan | ||
2211710 | 2211710 | 2021-01-30 | Japan | Toyama | 870 | 27 | 783 | 60 | 36.637464 | 137.26934599999998 | 2021-01-31 05:22:42 | Toyama, Japan | ||
2427232 | 2427232 | 2021-01-23 | Taiwan* | 884 | 7 | 783 | 94 | 23.7 | 121.0 | 2021-01-24 05:22:35 | Taiwan* | |||
2541414 | 2541414 | 2021-01-07 | Japan | Fukushima | 1102 | 27 | 783 | 292 | 37.378867 | 140.223295 | 2021-01-08 05:22:42 | Fukushima, Japan | ||
1065501 | 1065501 | 2021-01-04 | United Kingdom | Turks and Caicos Islands | 910 | 6 | 783 | 121 | 21.694000000000006 | -71.7979 | 2021-01-05 05:21:49 | Turks and Caicos Islands, United Kingdom | ||
3234104 | 3234104 | 2021-01-03 | United Kingdom | Turks and Caicos Islands | 910 | 6 | 783 | 121 | 21.694000000000006 | -71.7979 | 2021-01-04 05:22:02 | Turks and Caicos Islands, United Kingdom | ||
2231173 | 2231173 | 2021-01-02 | United Kingdom | Turks and Caicos Islands | 909 | 6 | 783 | 120 | 21.694000000000006 | -71.7979 | 2021-01-03 05:22:52 | Turks and Caicos Islands, United Kingdom | ||
1140537 | 1140537 | 2021-01-01 | United Kingdom | Turks and Caicos Islands | 893 | 6 | 783 | 104 | 21.694000000000006 | -71.7979 | 2021-01-02 05:22:33 | Turks and Caicos Islands, United Kingdom | ||
3699143 | 3699143 | 2020-12-31 | United Kingdom | Turks and Caicos Islands | 893 | 6 | 783 | 104 | 21.694000000000006 | -71.7979 | 2021-01-01 05:23:07 | Turks and Caicos Islands, United Kingdom | ||
1818615 | 1818615 | 2020-12-08 | China | Sichuan | 822 | 3 | 783 | 36 | 30.6171 | 102.7103 | 2020-12-09 05:28:01 | Sichuan, China | ||
2537409 | 2537409 | 2020-12-01 | Japan | Ishikawa | 859 | 50 | 783 | 26 | 36.769464 | 136.771027 | 2020-12-02 05:27:41 | Ishikawa, Japan | ||
1584178 | 1584178 | 2020-11-30 | Japan | Ishikawa | 853 | 50 | 783 | 20 | 36.769464 | 136.771027 | 2020-12-01 05:26:18 | Ishikawa, Japan | ||
3566581 | 3566581 | 2020-11-29 | Japan | Ishikawa | 850 | 50 | 783 | 17 | 36.769464 | 136.771027 | 2020-11-30 05:26:13 | Ishikawa, Japan | ||
376298 | 376298 | 2020-11-06 | Netherlands | Curacao | 1053 | 2 | 783 | 268 | 12.1696 | -68.99 | 2020-11-07 05:24:52 | Curacao, Netherlands | ||
3801746 | 3801746 | 2020-10-05 | Colombia | Guaviare | 979 | 18 | 783 | 178 | 1.0654 | -73.2603 | 2020-10-06 04:23:33 | Guaviare, Colombia | ||
1822636 | 1822636 | 2020-10-04 | Colombia | Guaviare | 943 | 18 | 783 | 142 | 1.0654 | -73.2603 | 2020-10-05 04:23:33 | Guaviare, Colombia | ||
3097038 | 3097038 | 2020-09-20 | Ukraine | Kirovohrad Oblast | 985 | 54 | 783 | 148 | 48.5079 | 32.2623 | 2020-09-21 04:23:00 | Kirovohrad Oblast, Ukraine | ||
2000270 | 2000270 | 2020-08-26 | Ukraine | Zaporizhia Oblast | 1439 | 24 | 783 | 632 | 47.8388 | 35.1396 | 2020-08-27 04:28:15 | Zaporizhia Oblast, Ukraine | ||
1479382 | 1479382 | 2020-08-21 | China | Shanghai | 875 | 7 | 783 | 85 | 31.202 | 121.4491 | 2020-08-22 04:27:49 | Shanghai, China | ||
3612009 | 3612009 | 2020-08-06 | Japan | Aichi | 2725 | 37 | 783 | 1905 | 35.035551 | 137.211621 | 2020-08-07 04:35:11 | Aichi, Japan | ||
442547 | 442547 | 2020-07-26 | Chile | Los Rios | 875 | 13 | 783 | 79 | -40.231 | -72.3311 | 2020-07-27 04:35:02 | Los Rios, Chile | ||
2234829 | 2234829 | 2020-07-03 | Ukraine | Volyn Oblast | 2571 | 63 | 783 | 1725 | 50.7472 | 25.3254 | 2020-07-04 04:33:51 | Volyn Oblast, Ukraine | ||
1691679 | 1691679 | 2020-06-19 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-20 04:33:19 | Shandong, China | ||
3682828 | 3682828 | 2020-06-18 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-19 04:33:17 | Shandong, China | ||
1196031 | 1196031 | 2020-06-17 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-18 04:33:18 | Shandong, China | ||
2386794 | 2386794 | 2020-06-16 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-17 04:33:21 | Shandong, China | ||
287357 | 287357 | 2020-06-15 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-16 04:33:09 | Shandong, China | ||
3638805 | 3638805 | 2020-05-30 | Japan | Hokkaido | 1085 | 86 | 783 | 216 | 43.385711 | 142.55231799999999 | 2020-05-31 02:32:45 | Hokkaido, Japan | ||
875835 | 875835 | 2020-05-24 | Niger | 945 | 61 | 783 | 101 | 17.607789 | 8.081666 | 2020-05-25 02:32:44 | Niger | |||
997911 | 997911 | 2020-05-23 | Albania | 989 | 31 | 783 | 175 | 41.1533 | 20.1683 | 2020-05-24 02:32:43 | Albania | |||
1829694 | 1829694 | 2020-05-16 | Kyrgyzstan | 1117 | 14 | 783 | 320 | 41.20438 | 74.766098 | 2020-05-17 02:32:32 | Kyrgyzstan | |||
934257 | 934257 | 2020-04-16 | Algeria | 2268 | 348 | 783 | 1137 | 28.0339 | 1.6596 | 2020-04-16 23:30:31 | Algeria | |||
2509751 | 2509751 | 2020-02-26 | Mainland China | Hunan | 1016 | 4 | 783 | 27.6104 | 111.7088 | 2020-02-26T10:13:11 |
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]);