johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where recovered = 1543 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468406 | 3468406 | 2021-08-03 | Russia | Nenets Autonomous Okrug | 1612 | 12 | 1543 | 57 | 68.27557185 | 57.1686375 | 2021-08-04 04:21:25 | Nenets Autonomous Okrug, Russia | ||
2586028 | 2586028 | 2021-06-05 | Japan | Tokushima | 1636 | 63 | 1543 | 30 | 33.919178 | 134.242091 | 2021-06-06 04:24:03 | Tokushima, Japan | ||
1188802 | 1188802 | 2021-05-31 | Laos | 1912 | 3 | 1543 | 366 | 19.85627 | 102.495496 | 2021-06-01 04:23:09 | Laos | |||
1913258 | 1913258 | 2021-05-20 | Japan | Yamagata | 1798 | 37 | 1543 | 218 | 38.448396 | 140.102154 | 2021-05-21 04:20:43 | Yamagata, Japan | ||
3245979 | 3245979 | 2021-04-21 | United Kingdom | Isle of Man | 1582 | 29 | 1543 | 10 | 54.2361 | -4.5481 | 2021-04-22 04:20:53 | Isle of Man, United Kingdom | ||
2024375 | 2024375 | 2021-04-20 | United Kingdom | Isle of Man | 1577 | 29 | 1543 | 5 | 54.2361 | -4.5481 | 2021-04-21 04:21:14 | Isle of Man, United Kingdom | ||
2207680 | 2207680 | 2021-03-04 | Japan | Nagasaki | 1612 | 37 | 1543 | 32 | 33.235712 | 129.608033 | 2021-03-05 05:26:29 | Nagasaki, Japan | ||
1090101 | 1090101 | 2021-03-03 | Japan | Nagasaki | 1612 | 37 | 1543 | 32 | 33.235712 | 129.608033 | 2021-03-04 05:24:24 | Nagasaki, Japan | ||
1522963 | 1522963 | 2020-08-28 | Canada | Saskatchewan | 1611 | 24 | 1543 | 44 | 52.9399 | -106.4509 | 2020-08-29 04:28:19 | Saskatchewan, Canada | ||
2991111 | 2991111 | 2020-08-24 | Colombia | Boyaca | 3212 | 61 | 1543 | 1608 | 5.4545 | -73.362 | 2020-08-25 04:28:02 | Boyaca, Colombia | ||
3181622 | 3181622 | 2020-08-18 | Ukraine | Odessa Oblast | 5158 | 81 | 1543 | 3534 | 46.4846 | 30.7326 | 2020-08-19 04:27:00 | Odessa Oblast, Ukraine | ||
458557 | 458557 | 2020-08-07 | Colombia | La Guajira | 2584 | 140 | 1543 | 901 | 11.3548 | -72.5205 | 2020-08-08 04:34:53 | La Guajira, Colombia | ||
1928380 | 1928380 | 2020-07-30 | Russia | Kurgan Oblast | 2199 | 9 | 1543 | 647 | 55.7655302 | 64.5632681 | 2020-07-31 04:35:18 | Kurgan Oblast, Russia | ||
2958355 | 2958355 | 2020-07-29 | Pakistan | Azad Jammu and Kashmir | 2055 | 50 | 1543 | 462 | 34.027401 | 73.947253 | 2020-07-30 04:35:05 | Azad Jammu and Kashmir, Pakistan | ||
177643 | 177643 | 2020-07-27 | Somalia | 3196 | 93 | 1543 | 1560 | 5.152149 | 46.199616 | 2020-07-28 04:58:43 | Somalia | |||
1210847 | 1210847 | 2020-06-09 | Russia | Orel Oblast | 3092 | 32 | 1543 | 1517 | 52.96854329999999 | 36.0692477 | 2020-06-10 04:07:00 | Orel Oblast, Russia | ||
573863 | 573863 | 2020-06-06 | Colombia | Atlantico | 5808 | 173 | 1543 | 4092 | 10.6966 | -74.8741 | 2020-06-07 03:53:30 | Atlantico, Colombia | ||
1269560 | 1269560 | 2020-06-05 | Colombia | Atlantico | 5808 | 173 | 1543 | 4092 | 10.6966 | -74.8741 | 2020-06-06 02:33:00 | Atlantico, Colombia | ||
3847285 | 3847285 | 2020-05-13 | Cameroon | 2800 | 136 | 1543 | 1121 | 3.848 | 11.5021 | 2020-05-14 03:32:28 | Cameroon |
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]);