johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where recovered = 854 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- Bhutan 5
- China 3
- Colombia 3
- Burkina Faso 2
- Japan 2
- Ukraine 2
- Malta 1
- Mexico 1
- Russia 1
- Seychelles 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2637447 | 2637447 | 2021-02-11 | Bhutan | 861 | 1 | 854 | 6 | 27.5142 | 90.4336 | 2021-02-12 05:23:29 | Bhutan | |||
3978302 | 3978302 | 2021-02-10 | Bhutan | 861 | 1 | 854 | 6 | 27.5142 | 90.4336 | 2021-02-11 05:23:55 | Bhutan | |||
1527622 | 1527622 | 2021-02-09 | Bhutan | 861 | 1 | 854 | 6 | 27.5142 | 90.4336 | 2021-02-10 05:22:41 | Bhutan | |||
613413 | 613413 | 2021-02-08 | Bhutan | 861 | 1 | 854 | 6 | 27.5142 | 90.4336 | 2021-02-09 05:23:30 | Bhutan | |||
1672182 | 1672182 | 2021-02-07 | Bhutan | 861 | 1 | 854 | 6 | 27.5142 | 90.4336 | 2021-02-08 05:22:39 | Bhutan | |||
1684549 | 1684549 | 2021-02-02 | Japan | Yamanashi | 902 | 15 | 854 | 33 | 35.612364 | 138.61148899999998 | 2021-02-03 05:22:52 | Yamanashi, Japan | ||
2482244 | 2482244 | 2021-01-28 | Seychelles | 1130 | 3 | 854 | 273 | -4.6796 | 55.492 | 2021-01-29 05:22:23 | Seychelles | |||
2481796 | 2481796 | 2021-01-28 | China | Sichuan | 868 | 3 | 854 | 11 | 30.6171 | 102.7103 | 2021-01-29 05:22:23 | Sichuan, China | ||
3308026 | 3308026 | 2021-01-13 | China | Shandong | 864 | 7 | 854 | 3 | 36.3427 | 118.1498 | 2021-01-14 05:22:32 | Shandong, China | ||
122570 | 122570 | 2020-11-18 | Colombia | Vichada | 883 | 11 | 854 | 18 | 4.4234 | -69.2878 | 2020-11-19 05:25:23 | Vichada, Colombia | ||
3338458 | 3338458 | 2020-11-17 | Colombia | Vichada | 873 | 11 | 854 | 8 | 4.4234 | -69.2878 | 2020-11-18 05:40:31 | Vichada, Colombia | ||
3801745 | 3801745 | 2020-10-05 | Colombia | Guainia | 963 | 16 | 854 | 93 | 2.5854 | -68.5247 | 2020-10-06 04:23:33 | Guainia, Colombia | ||
970515 | 970515 | 2020-09-29 | Ukraine | Kirovohrad Oblast | 1090 | 56 | 854 | 180 | 48.5079 | 32.2623 | 2020-09-30 04:23:33 | Kirovohrad Oblast, Ukraine | ||
1354142 | 1354142 | 2020-09-03 | China | Shanghai | 913 | 7 | 854 | 52 | 31.202 | 121.4491 | 2020-09-04 04:28:26 | Shanghai, China | ||
1479626 | 1479626 | 2020-08-21 | Malta | 1546 | 10 | 854 | 682 | 35.9375 | 14.3754 | 2020-08-22 04:27:49 | Malta | |||
844538 | 844538 | 2020-07-22 | Russia | Altai Republic | 1331 | 1 | 854 | 476 | 50.7114101 | 86.8572186 | 2020-07-23 05:15:04 | Altai Republic, Russia | ||
415651 | 415651 | 2020-07-05 | Burkina Faso | 987 | 53 | 854 | 80 | 12.2383 | -1.5616 | 2020-07-06 04:33:57 | Burkina Faso | |||
530213 | 530213 | 2020-07-04 | Burkina Faso | 987 | 53 | 854 | 80 | 12.2383 | -1.5616 | 2020-07-05 04:33:46 | Burkina Faso | |||
3249318 | 3249318 | 2020-06-21 | Ukraine | Kharkiv Oblast | 1805 | 69 | 854 | 882 | 49.9935 | 36.2304 | 2020-06-22 04:33:20 | Kharkiv Oblast, Ukraine | ||
2386486 | 2386486 | 2020-06-16 | Japan | Chiba | 916 | 45 | 854 | 17 | 35.510141 | 140.198917 | 2020-06-17 04:33:21 | Chiba, Japan | ||
1269925 | 1269925 | 2020-06-05 | Mexico | Tlaxcala | 1257 | 183 | 854 | 220 | 19.3139 | -98.2404 | 2020-06-06 02:33:00 | Tlaxcala, Mexico |
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]);