johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 17660 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219630 | 219630 | 2022-12-26 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-27 04:21:07 | Isabella, Michigan, US | |
3224087 | 3224087 | 2022-12-25 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-26 04:21:06 | Isabella, Michigan, US | |
1020001 | 1020001 | 2022-12-24 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-25 04:21:04 | Isabella, Michigan, US | |
692024 | 692024 | 2022-12-23 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-24 04:21:02 | Isabella, Michigan, US | |
2181234 | 2181234 | 2022-12-22 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-23 04:21:04 | Isabella, Michigan, US | |
453038 | 453038 | 2022-12-21 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-22 04:20:56 | Isabella, Michigan, US | |
2953037 | 2953037 | 2022-12-20 | US | Michigan | Isabella | 26073 | 17660 | 231 | 0 | 43.64060976 | -84.84664923 | 2022-12-21 04:21:03 | Isabella, Michigan, US | |
3899023 | 3899023 | 2022-05-19 | US | Texas | Coryell | 48099 | 17660 | 211 | 0 | 31.39078397 | -97.79936155 | 2022-05-20 04:20:57 | Coryell, Texas, US | |
465405 | 465405 | 2022-05-02 | US | Montana | Lewis and Clark | 30049 | 17660 | 185 | 0 | 47.12610041 | -112.394698 | 2022-05-03 04:21:00 | Lewis and Clark, Montana, US | |
3725200 | 3725200 | 2022-04-25 | US | Tennessee | Tipton | 47167 | 17660 | 236 | 0 | 35.501942 | -89.73694895 | 2022-04-26 04:20:51 | Tipton, Tennessee, US | |
2031768 | 2031768 | 2022-04-24 | US | Tennessee | Tipton | 47167 | 17660 | 236 | 0 | 35.501942 | -89.73694895 | 2022-04-25 04:20:56 | Tipton, Tennessee, US | |
979317 | 979317 | 2022-02-01 | US | Alabama | DeKalb | 1049 | 17660 | 290 | 0 | 34.45946862 | -85.80782906 | 2022-02-02 04:21:09 | DeKalb, Alabama, US | |
3300757 | 3300757 | 2022-01-30 | US | California | Humboldt | 6023 | 17660 | 129 | 0 | 40.69923009 | -123.876044 | 2022-01-31 04:21:09 | Humboldt, California, US | |
1670282 | 1670282 | 2021-12-29 | US | Mississippi | Lee | 28081 | 17660 | 248 | 0 | 34.291877500000005 | -88.68149954 | 2021-12-30 04:21:25 | Lee, Mississippi, US | |
3830969 | 3830969 | 2021-12-21 | US | Ohio | Muskingum | 39119 | 17660 | 237 | 0 | 39.96575964 | -81.94363275 | 2021-12-22 04:21:54 | Muskingum, Ohio, US | |
2077019 | 2077019 | 2021-09-26 | US | Indiana | Clark | 18019 | 17660 | 231 | 0 | 38.48015445 | -85.70510334 | 2021-09-27 04:21:16 | Clark, Indiana, US | |
2462800 | 2462800 | 2021-09-14 | Japan | Gifu | 17660 | 207 | 0 | 35.778671 | 137.055925 | 2021-09-15 03:22:37 | Gifu, Japan | |||
3634754 | 3634754 | 2021-07-14 | US | South Carolina | Aiken | 45003 | 17660 | 225 | 0 | 33.54338026 | -81.63645384 | 2021-07-15 04:21:48 | Aiken, South Carolina, US | |
1451560 | 1451560 | 2021-06-03 | US | Tennessee | Out of TN | 80047 | 17660 | 100 | 0 | 36.55606529 | 0.0 | 2021-06-04 04:23:37 | Out of TN, Tennessee, US | |
3113625 | 3113625 | 2021-05-06 | Pakistan | Azad Jammu and Kashmir | 17660 | 499 | 15098 | 2063 | 34.027401 | 73.947253 | 2021-05-07 04:20:40 | Azad Jammu and Kashmir, Pakistan | ||
1411258 | 1411258 | 2021-04-23 | US | New York | Broome | 36007 | 17660 | 350 | 0 | 42.15903158 | -75.81326086 | 2021-04-24 04:20:38 | Broome, New York, US | |
2186706 | 2186706 | 2021-02-26 | US | Texas | Jefferson | 48245 | 17660 | 340 | 0 | 17773 | 29.8832777 | -94.16434171 | 2021-02-27 05:22:28 | Jefferson, Texas, US |
3601053 | 3601053 | 2021-02-17 | Japan | Hyogo | 17660 | 500 | 16333 | 827 | 35.039913 | 134.828057 | 2021-02-18 05:22:58 | Hyogo, Japan | ||
15684 | 15684 | 2021-01-26 | US | Virginia | Henrico | 51087 | 17660 | 333 | 0 | 17327 | 37.53460572 | -77.39326555 | 2021-01-27 05:23:41 | Henrico, Virginia, US |
2539297 | 2539297 | 2020-12-01 | US | Missouri | Jackson | 29095 | 17660 | 183 | 0 | 17477 | 39.01002188 | -94.34724536 | 2020-12-02 05:27:41 | Jackson, Missouri, US |
754474 | 754474 | 2020-10-28 | Peru | Ucayali | 17660 | 1509 | 0 | 16151 | -9.621718 | -73.444929 | 2020-10-29 04:24:49 | Ucayali, Peru | ||
2633045 | 2633045 | 2020-06-29 | India | Rajasthan | 17660 | 405 | 13618 | 3637 | 26.583423 | 73.847973 | 2020-06-30 04:33:48 | Rajasthan, India | ||
3765346 | 3765346 | 2020-03-13 | Italy | 17660 | 1266 | 1439 | 41.8719 | 12.5674 | 2020-03-11T20:00:00 |
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]);