johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where recovered = 906 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- Japan 7
- Australia 2
- Russia 2
- Taiwan* 2
- Bhutan 1
- Chile 1
- Germany 1
- Iraq 1
- Mainland China 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1567830 | 1567830 | 2021-04-22 | Bhutan | 992 | 1 | 906 | 85 | 27.5142 | 90.4336 | 2021-04-23 04:20:52 | Bhutan | |||
1732197 | 1732197 | 2021-03-14 | Australia | Western Australia | 925 | 9 | 906 | 10 | -31.9505 | 115.8605 | 2021-03-15 05:25:51 | Western Australia, Australia | ||
1579854 | 1579854 | 2021-03-13 | Australia | Western Australia | 924 | 9 | 906 | 9 | -31.9505 | 115.8605 | 2021-03-14 05:25:37 | Western Australia, Australia | ||
2183912 | 2183912 | 2021-02-26 | Taiwan* | 951 | 9 | 906 | 36 | 23.7 | 121.0 | 2021-02-27 05:22:28 | Taiwan* | |||
1858334 | 1858334 | 2021-02-25 | Taiwan* | 951 | 9 | 906 | 36 | 23.7 | 121.0 | 2021-02-26 05:22:40 | Taiwan* | |||
280231 | 280231 | 2021-02-24 | Japan | Yamanashi | 939 | 16 | 906 | 17 | 35.612364 | 138.61148899999998 | 2021-02-25 05:24:57 | Yamanashi, Japan | ||
1936499 | 1936499 | 2021-02-23 | Japan | Yamanashi | 936 | 16 | 906 | 14 | 35.612364 | 138.61148899999998 | 2021-02-24 05:29:16 | Yamanashi, Japan | ||
3695504 | 3695504 | 2020-12-31 | Japan | Ishikawa | 1071 | 51 | 906 | 114 | 36.769464 | 136.771027 | 2021-01-01 05:23:07 | Ishikawa, Japan | ||
1350445 | 1350445 | 2020-11-24 | Netherlands | Sint Maarten | 1020 | 25 | 906 | 89 | 18.0425 | -63.0548 | 2020-11-25 05:27:20 | Sint Maarten, Netherlands | ||
1479470 | 1479470 | 2020-08-21 | Germany | Mecklenburg-Vorpommern | 984 | 20 | 906 | 63 | 53.6127 | 12.4296 | 2020-08-22 04:27:49 | Mecklenburg-Vorpommern, Germany | ||
582623 | 582623 | 2020-08-13 | Chile | Los Rios | 996 | 15 | 906 | 75 | -40.231 | -72.3311 | 2020-08-14 04:51:19 | Los Rios, Chile | ||
3435880 | 3435880 | 2020-07-11 | Japan | Chiba | 1081 | 46 | 906 | 129 | 35.510141 | 140.198917 | 2020-07-12 04:34:30 | Chiba, Japan | ||
3237378 | 3237378 | 2020-07-10 | Japan | Chiba | 1068 | 46 | 906 | 116 | 35.510141 | 140.198917 | 2020-07-11 04:34:26 | Chiba, Japan | ||
2974427 | 2974427 | 2020-06-30 | Russia | Kostroma Oblast | 1583 | 17 | 906 | 660 | 58.424756 | 44.2533273 | 2020-07-01 04:33:52 | Kostroma Oblast, Russia | ||
1273415 | 1273415 | 2020-06-11 | Japan | Hokkaido | 1144 | 91 | 906 | 147 | 43.385711 | 142.55231799999999 | 2020-06-12 05:09:52 | Hokkaido, Japan | ||
2863858 | 2863858 | 2020-06-10 | Japan | Hokkaido | 1137 | 91 | 906 | 140 | 43.385711 | 142.552318 | 2020-06-11 03:33:41 | Hokkaido, Japan | ||
2555761 | 2555761 | 2020-06-02 | Russia | Ingushetia Republic | 2164 | 52 | 906 | 1206 | 43.11542075 | 45.01713552 | 2020-06-03 02:33:13 | Ingushetia Republic, Russia | ||
50339 | 50339 | 2020-04-17 | Iraq | 1482 | 81 | 906 | 495 | 33.223191 | 43.679291 | 2020-04-17 23:30:32 | Iraq | |||
261023 | 261023 | 2020-03-03 | Mainland China | Hunan | 1018 | 4 | 906 | 27.6104 | 111.7088 | 2020-03-03T13:03:04 |
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]);