johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where recovered = 969 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2781323 | 2781323 | 2021-03-24 | Taiwan* | 1009 | 10 | 969 | 30 | 23.7 | 121.0 | 2021-03-25 05:27:00 | Taiwan* | |||
1798968 | 1798968 | 2021-03-23 | Taiwan* | 1007 | 10 | 969 | 28 | 23.7 | 121.0 | 2021-03-24 05:25:40 | Taiwan* | |||
1732721 | 1732721 | 2021-03-14 | Russia | Nenets Autonomous Okrug | 1060 | 3 | 969 | 88 | 68.27557185 | 57.1686375 | 2021-03-15 05:25:51 | Nenets Autonomous Okrug, Russia | ||
1580378 | 1580378 | 2021-03-13 | Russia | Nenets Autonomous Okrug | 1057 | 3 | 969 | 85 | 68.27557185 | 57.1686375 | 2021-03-14 05:25:37 | Nenets Autonomous Okrug, Russia | ||
3601045 | 3601045 | 2021-02-17 | Japan | Ehime | 1029 | 22 | 969 | 38 | 33.624835 | 132.856842 | 2021-02-18 05:22:58 | Ehime, Japan | ||
157660 | 157660 | 2021-01-08 | Malaysia | Pahang | 1535 | 8 | 969 | 558 | 3.8126 | 103.3256 | 2021-01-09 05:22:18 | Pahang, Malaysia | ||
154000 | 154000 | 2021-01-08 | Japan | Kagoshima | 1189 | 14 | 969 | 206 | 31.009484000000004 | 130.430665 | 2021-01-09 05:22:18 | Kagoshima, Japan | ||
2545084 | 2545084 | 2021-01-07 | Malaysia | Pahang | 1507 | 8 | 969 | 530 | 3.8126 | 103.3256 | 2021-01-08 05:22:42 | Pahang, Malaysia | ||
2347444 | 2347444 | 2020-12-07 | Japan | Kumamoto | 1100 | 13 | 969 | 118 | 32.608154 | 130.74523100000002 | 2020-12-08 05:27:42 | Kumamoto, Japan | ||
3863478 | 3863478 | 2020-12-04 | United Kingdom | Gibraltar | 1042 | 5 | 969 | 68 | 36.1408 | -5.3536 | 2020-12-05 05:27:36 | Gibraltar, United Kingdom | ||
2935255 | 2935255 | 2020-11-28 | Japan | Miyagi | 1194 | 10 | 969 | 215 | 38.446859 | 140.927086 | 2020-11-29 05:25:55 | Miyagi, Japan | ||
3338422 | 3338422 | 2020-11-17 | China | Xinjiang | 980 | 3 | 969 | 8 | 41.1129 | 85.2401 | 2020-11-18 05:40:31 | Xinjiang, China | ||
837673 | 837673 | 2020-08-17 | Libya | 8579 | 157 | 969 | 7453 | 26.3351 | 17.228331 | 2020-08-18 04:27:56 | Libya | |||
753306 | 753306 | 2020-08-01 | India | Arunachal Pradesh | 1673 | 3 | 969 | 701 | 27.768456 | 96.384277 | 2020-08-02 04:34:47 | Arunachal Pradesh, India | ||
887680 | 887680 | 2020-07-07 | Jordan | 1169 | 10 | 969 | 190 | 31.24 | 36.51 | 2020-07-08 05:33:48 | Jordan | |||
2234726 | 2234726 | 2020-07-03 | Japan | Saitama | 1188 | 65 | 969 | 154 | 35.997101 | 139.347635 | 2020-07-04 04:33:51 | Saitama, Japan | ||
1136317 | 1136317 | 2020-06-26 | Russia | Udmurt Republic | 1334 | 15 | 969 | 350 | 57.1961165 | 52.69598320000001 | 2020-06-27 04:33:35 | Udmurt Republic, Russia | ||
1270148 | 1270148 | 2020-06-05 | Tunisia | 1087 | 49 | 969 | 69 | 33.886917 | 9.537499 | 2020-06-06 02:33:00 | Tunisia | |||
997824 | 997824 | 2020-05-23 | Canada | Nova Scotia | 1049 | 58 | 969 | 22 | 44.681999999999995 | -63.7443 | 2020-05-24 02:32:43 | Nova Scotia, Canada | ||
2581560 | 2581560 | 2020-05-12 | Lithuania | 1418 | 39 | 969 | 480 | 55.1694 | 23.8813 | 2020-05-13 03:32:26 | Lithuania | |||
2567100 | 2567100 | 2020-04-11 | India | 8446 | 288 | 969 | 7189 | 20.593684 | 78.96288 | 2020-04-11 22:45:13 | India |
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]);