johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where recovered = 1061 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
625677 | 625677 | 2021-07-10 | China | Beijing | 1078 | 9 | 1061 | 8 | 40.1824 | 116.4142 | 2021-07-11 04:21:43 | Beijing, China | ||
829396 | 829396 | 2021-07-09 | China | Beijing | 1078 | 9 | 1061 | 8 | 40.1824 | 116.4142 | 2021-07-10 04:21:25 | Beijing, China | ||
778160 | 778160 | 2021-07-08 | China | Beijing | 1078 | 9 | 1061 | 8 | 40.1824 | 116.4142 | 2021-07-09 04:21:21 | Beijing, China | ||
1424872 | 1424872 | 2021-05-09 | Canada | Newfoundland and Labrador | 1138 | 6 | 1061 | 71 | 53.1355 | -57.6604 | 2021-05-10 04:20:38 | Newfoundland and Labrador, Canada | ||
3230490 | 3230490 | 2021-01-03 | Japan | Tochigi | 1662 | 6 | 1061 | 595 | 36.689912 | 139.819213 | 2021-01-04 05:22:02 | Tochigi, Japan | ||
1013987 | 1013987 | 2020-12-30 | Malaysia | Sarawak | 1115 | 19 | 1061 | 35 | 1.5533 | 110.3592 | 2020-12-31 05:22:49 | Sarawak, Malaysia | ||
3483967 | 3483967 | 2020-10-26 | Vietnam | 1169 | 35 | 1061 | 73 | 14.058324 | 108.277199 | 2020-10-27 04:24:45 | Vietnam | |||
1053672 | 1053672 | 2020-10-23 | Colombia | Guainia | 1103 | 18 | 1061 | 24 | 2.5854 | -68.5247 | 2020-10-24 04:24:46 | Guainia, Colombia | ||
327128 | 327128 | 2020-07-20 | Australia | Queensland | 1072 | 6 | 1061 | 5 | -27.4698 | 153.0251 | 2020-07-21 04:38:46 | Queensland, Australia | ||
122033 | 122033 | 2020-07-19 | Australia | Queensland | 1072 | 6 | 1061 | 5 | -27.4698 | 153.0251 | 2020-07-20 05:34:40 | Queensland, Australia | ||
367215 | 367215 | 2020-07-16 | Pakistan | Azad Jammu and Kashmir | 1771 | 46 | 1061 | 664 | 34.027401 | 73.947253 | 2020-07-17 04:34:50 | Azad Jammu and Kashmir, Pakistan | ||
2747883 | 2747883 | 2020-07-15 | Pakistan | Azad Jammu and Kashmir | 1771 | 46 | 1061 | 664 | 34.027401 | 73.947253 | 2020-07-16 04:44:59 | Azad Jammu and Kashmir, Pakistan | ||
2222992 | 2222992 | 2020-07-08 | Ukraine | Zhytomyr Oblast | 1484 | 32 | 1061 | 391 | 50.2547 | 28.6587 | 2020-07-09 04:34:23 | Zhytomyr Oblast, Ukraine | ||
2684793 | 2684793 | 2020-07-06 | India | Goa | 1813 | 7 | 1061 | 745 | 15.359682000000001 | 74.057396 | 2020-07-07 04:34:00 | Goa, India | ||
3045303 | 3045303 | 2020-07-02 | Japan | Hokkaido | 1275 | 101 | 1061 | 113 | 43.385711 | 142.552318 | 2020-07-03 04:33:54 | Hokkaido, Japan | ||
3061126 | 3061126 | 2020-06-13 | China | Hong Kong | 1109 | 4 | 1061 | 44 | 22.3 | 114.2 | 2020-06-14 03:33:15 | Hong Kong, China | ||
573838 | 573838 | 2020-06-06 | Russia | Altai Krai | 2255 | 14 | 1061 | 1180 | 52.693224300000004 | 82.69314240000001 | 2020-06-07 03:53:30 | Altai Krai, Russia | ||
3638825 | 3638825 | 2020-05-30 | Japan | Kanagawa | 1361 | 85 | 1061 | 215 | 35.415312 | 139.338983 | 2020-05-31 02:32:45 | Kanagawa, Japan | ||
1790366 | 1790366 | 2020-05-29 | Japan | Kanagawa | 1357 | 84 | 1061 | 212 | 35.415312 | 139.338983 | 2020-05-30 02:32:48 | Kanagawa, Japan | ||
1385149 | 1385149 | 2020-04-19 | Ecuador | 9468 | 474 | 1061 | 7933 | -1.8312 | -78.1834 | 2020-04-19 23:40:41 | Ecuador |
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]);