johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where recovered = 1685 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3706140 | 3706140 | 2021-07-17 | Japan | Iwate | 1845 | 47 | 1685 | 113 | 39.593287 | 141.361777 | 2021-07-18 04:22:07 | Iwate, Japan | ||
3705823 | 3705823 | 2021-07-17 | Australia | Queensland | 1755 | 7 | 1685 | 63 | -27.4698 | 153.0251 | 2021-07-18 04:22:07 | Queensland, Australia | ||
2947054 | 2947054 | 2021-07-16 | Australia | Queensland | 1754 | 7 | 1685 | 62 | -27.4698 | 153.0251 | 2021-07-17 04:22:22 | Queensland, Australia | ||
3358393 | 3358393 | 2021-06-21 | Bhutan | 1939 | 1 | 1685 | 253 | 27.5142 | 90.4336 | 2021-06-22 04:21:34 | Bhutan | |||
1081959 | 1081959 | 2021-05-14 | Japan | Saga | 2170 | 15 | 1685 | 470 | 33.286977 | 130.115738 | 2021-05-15 04:20:58 | Saga, Japan | ||
954633 | 954633 | 2021-04-25 | Canada | New Brunswick | 1851 | 35 | 1685 | 131 | 46.5653 | -66.4619 | 2021-04-26 04:21:04 | New Brunswick, Canada | ||
1034642 | 1034642 | 2020-12-15 | San Marino | 1982 | 52 | 1685 | 245 | 43.9424 | 12.4578 | 2020-12-16 05:28:04 | San Marino | |||
3117276 | 3117276 | 2020-10-06 | Chile | Los Rios | 2203 | 21 | 1685 | 497 | -40.231 | -72.3311 | 2020-10-07 04:23:40 | Los Rios, Chile | ||
1045809 | 1045809 | 2020-09-30 | Italy | Sardegna | 3900 | 154 | 1685 | 2061 | 39.21531192 | 9.110616306 | 2020-10-01 04:23:42 | Sardegna, Italy | ||
967169 | 967169 | 2020-09-29 | Sierra Leone | 2222 | 72 | 1685 | 465 | 8.460555000000001 | -11.779889 | 2020-09-30 04:23:33 | Sierra Leone | |||
1243945 | 1243945 | 2020-09-08 | Russia | Chechen Republic | 2314 | 40 | 1685 | 589 | 43.39761470000001 | 45.6985005 | 2020-09-09 04:28:48 | Chechen Republic, Russia | ||
1105584 | 1105584 | 2020-09-02 | Japan | Okinawa | 2140 | 29 | 1685 | 426 | 25.768923 | 126.668016 | 2020-09-03 04:28:22 | Okinawa, Japan | ||
2059913 | 2059913 | 2020-09-01 | Japan | Okinawa | 2126 | 28 | 1685 | 413 | 25.768923 | 126.668016 | 2020-09-02 04:28:25 | Okinawa, Japan | ||
662305 | 662305 | 2020-08-11 | Japan | Fukuoka | 3136 | 38 | 1685 | 1413 | 33.526032 | 130.666949 | 2020-08-12 04:27:29 | Fukuoka, Japan | ||
458935 | 458935 | 2020-08-07 | Lithuania | 2137 | 64 | 1685 | 440 | 55.1694 | 23.8813 | 2020-08-08 04:34:53 | Lithuania | |||
458581 | 458581 | 2020-08-07 | Chile | Magallanes | 1942 | 30 | 1685 | 227 | -52.368 | -70.9863 | 2020-08-08 04:34:53 | Magallanes, Chile | ||
2740143 | 2740143 | 2020-08-03 | Ukraine | Ivano-Frankivsk Oblast | 4914 | 141 | 1685 | 3088 | 48.9226 | 24.7111 | 2020-08-04 04:41:59 | Ivano-Frankivsk Oblast, Ukraine | ||
753508 | 753508 | 2020-08-01 | Russia | Kurgan Oblast | 2267 | 10 | 1685 | 572 | 55.7655302 | 64.5632681 | 2020-08-02 04:34:47 | Kurgan Oblast, Russia | ||
2386448 | 2386448 | 2020-06-16 | Colombia | Bolivar | 5256 | 224 | 1685 | 3347 | 8.6704 | -74.03 | 2020-06-17 04:33:21 | Bolivar, Colombia | ||
287011 | 287011 | 2020-06-15 | Colombia | Bolivar | 5256 | 224 | 1685 | 3347 | 8.6704 | -74.03 | 2020-06-16 04:33:09 | Bolivar, Colombia | ||
1281493 | 1281493 | 2020-06-04 | Djibouti | 4054 | 26 | 1685 | 2343 | 11.8251 | 42.5903 | 2020-06-05 02:33:06 | Djibouti |
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]);