daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 26175 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-11 | US | Wisconsin | Ozaukee | 55089 | 26175 | 193 | 0 | 43.38352225 | -87.94625009 | 2022-10-12 04:22:51 | Ozaukee, Wisconsin, US | |
2022-09-27 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-28 04:23:01 | Northumberland, Pennsylvania, US | |
2022-09-26 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-27 04:23:01 | Northumberland, Pennsylvania, US | |
2022-09-25 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-26 04:20:52 | Northumberland, Pennsylvania, US | |
2022-09-24 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-25 04:23:31 | Northumberland, Pennsylvania, US | |
2022-09-23 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-24 04:21:40 | Northumberland, Pennsylvania, US | |
2022-09-22 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-23 04:23:13 | Northumberland, Pennsylvania, US | |
2022-09-21 | US | Pennsylvania | Northumberland | 42097 | 26175 | 560 | 0 | 40.84785433 | -76.70798222 | 2022-09-22 04:22:56 | Northumberland, Pennsylvania, US | |
2022-07-11 | US | Tennessee | Putnam | 47141 | 26175 | 306 | 0 | 36.14005459 | -85.50646123 | 2022-07-12 04:20:51 | Putnam, Tennessee, US | |
2022-06-30 | US | Alabama | Limestone | 1083 | 26175 | 296 | 0 | 34.81185586 | -86.98310072 | 2022-07-01 04:21:10 | Limestone, Alabama, US | |
2022-05-24 | US | Indiana | LaPorte | 18091 | 26175 | 369 | 0 | 41.54366008 | -86.74072188 | 2022-05-25 04:20:56 | LaPorte, Indiana, US | |
2022-05-23 | US | Indiana | LaPorte | 18091 | 26175 | 369 | 0 | 41.54366008 | -86.74072188 | 2022-05-24 04:20:57 | LaPorte, Indiana, US | |
2022-02-27 | US | Minnesota | Carver | 27019 | 26175 | 110 | 0 | 44.82017001 | -93.80099179999999 | 2022-02-28 04:21:05 | Carver, Minnesota, US | |
2022-02-26 | US | Minnesota | Carver | 27019 | 26175 | 110 | 0 | 44.82017001 | -93.80099179999999 | 2022-02-27 04:21:04 | Carver, Minnesota, US | |
2022-02-25 | US | Minnesota | Carver | 27019 | 26175 | 110 | 0 | 44.82017001 | -93.80099179999999 | 2022-02-26 04:21:12 | Carver, Minnesota, US | |
2022-02-13 | US | Wisconsin | Walworth | 55127 | 26175 | 266 | 0 | 42.66858202 | -88.54163073 | 2022-02-14 04:20:51 | Walworth, Wisconsin, US | |
2022-02-12 | US | Wisconsin | Walworth | 55127 | 26175 | 266 | 0 | 42.66858202 | -88.54163073 | 2022-02-13 04:21:00 | Walworth, Wisconsin, US | |
2022-02-11 | US | Wisconsin | Walworth | 55127 | 26175 | 266 | 0 | 42.66858202 | -88.54163073 | 2022-02-12 04:21:06 | Walworth, Wisconsin, US | |
2021-12-14 | US | Georgia | Paulding | 13223 | 26175 | 350 | 0 | 33.91969522 | -84.86848792 | 2021-12-15 03:22:16 | Paulding, Georgia, US | |
2021-11-07 | US | Pennsylvania | Butler | 42019 | 26175 | 515 | 0 | 40.91152759 | -79.91351055 | 2021-11-08 04:21:43 | Butler, Pennsylvania, US | |
2021-08-17 | US | New Mexico | Dona Ana | 35013 | 26175 | 504 | 0 | 32.35275771 | -106.83293870000001 | 2021-08-18 04:21:35 | Dona Ana, New Mexico, US | |
2021-08-10 | Sweden | Sormland | 26175 | 477 | 0 | 59.0336 | 16.7519 | 2021-08-11 04:21:58 | Sormland, Sweden | |||
2021-08-04 | US | Georgia | Richmond | 13245 | 26175 | 536 | 0 | 33.35777107 | -82.07026432 | 2021-08-05 04:21:51 | Richmond, Georgia, US | |
2021-08-04 | US | Alabama | Baldwin | 1003 | 26175 | 329 | 0 | 30.72774991 | -87.72207058 | 2021-08-05 04:21:51 | Baldwin, Alabama, US | |
2021-05-08 | Japan | Hokkaido | 26175 | 890 | 22549 | 2736 | 43.385711 | 142.552318 | 2021-05-09 04:20:35 | Hokkaido, Japan | ||
2021-01-18 | US | Florida | Manatee | 12081 | 26175 | 461 | 0 | 25714 | 27.47196942 | -82.31831044 | 2021-01-19 05:22:15 | Manatee, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;