johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 26682 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260248 | 260248 | 2022-12-10 | US | Tennessee | Anderson | 47001 | 26682 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-11 04:20:50 | Anderson, Tennessee, US | |
152444 | 152444 | 2021-11-29 | US | Ohio | Delaware | 39041 | 26682 | 192 | 0 | 40.27942393 | -83.00457058 | 2021-11-30 04:22:53 | Delaware, Ohio, US | |
905658 | 905658 | 2021-11-24 | US | Kentucky | Warren | 21227 | 26682 | 274 | 0 | 36.99903045 | -86.42672751 | 2021-11-25 04:22:33 | Warren, Kentucky, US | |
3834252 | 3834252 | 2021-10-05 | US | Minnesota | Stearns | 27145 | 26682 | 247 | 0 | 45.55192576 | -94.61078221 | 2021-10-06 04:21:33 | Stearns, Minnesota, US | |
2069421 | 2069421 | 2021-08-31 | US | Louisiana | Ouachita | 22073 | 26682 | 502 | 0 | 32.47645559 | -92.15704172 | 2021-09-01 04:21:38 | Ouachita, Louisiana, US | |
1776875 | 1776875 | 2021-08-30 | US | Louisiana | Ouachita | 22073 | 26682 | 502 | 0 | 32.47645559 | -92.15704172 | 2021-08-31 04:21:46 | Ouachita, Louisiana, US | |
3893449 | 3893449 | 2021-08-29 | US | Louisiana | Ouachita | 22073 | 26682 | 502 | 0 | 32.47645559 | -92.15704172 | 2021-08-30 04:21:23 | Ouachita, Louisiana, US | |
2794552 | 2794552 | 2021-08-28 | US | Louisiana | Ouachita | 22073 | 26682 | 502 | 0 | 32.47645559 | -92.15704172 | 2021-08-29 04:21:14 | Ouachita, Louisiana, US | |
2924711 | 2924711 | 2021-08-27 | US | Louisiana | Ouachita | 22073 | 26682 | 502 | 0 | 32.47645559 | -92.15704172 | 2021-08-28 04:21:28 | Ouachita, Louisiana, US | |
2673773 | 2673773 | 2021-07-18 | India | Nagaland | 26682 | 528 | 25005 | 1149 | 26.06702 | 94.470302 | 2021-07-19 04:21:24 | Nagaland, India | ||
107648 | 107648 | 2021-06-19 | Russia | Chuvashia Republic | 26682 | 1494 | 24415 | 773 | 55.4259922 | 47.0849429 | 2021-06-20 04:21:48 | Chuvashia Republic, Russia | ||
3052340 | 3052340 | 2021-02-16 | US | New Jersey | Mercer | 34021 | 26682 | 851 | 0 | 25831 | 40.28047017 | -74.70479631 | 2021-02-17 05:23:10 | Mercer, New Jersey, US |
2541520 | 2541520 | 2021-01-07 | Namibia | 26682 | 240 | 22666 | 3776 | -22.9576 | 18.4904 | 2021-01-08 05:22:42 | Namibia | |||
3233900 | 3233900 | 2021-01-03 | US | Washington | Spokane | 53063 | 26682 | 349 | 0 | 26333 | 47.62113146 | -117.4046494 | 2021-01-04 05:22:02 | Spokane, Washington, US |
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]);