johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 20732 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3461803 | 3461803 | 2022-11-21 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-22 04:20:47 | Grand Traverse, Michigan, US | |
1641988 | 1641988 | 2022-11-20 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-21 04:21:05 | Grand Traverse, Michigan, US | |
2065545 | 2065545 | 2022-11-19 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-20 04:21:08 | Grand Traverse, Michigan, US | |
1756939 | 1756939 | 2022-11-18 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-19 04:21:14 | Grand Traverse, Michigan, US | |
3027932 | 3027932 | 2022-11-17 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-18 04:21:15 | Grand Traverse, Michigan, US | |
2487643 | 2487643 | 2022-11-16 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-17 04:21:11 | Grand Traverse, Michigan, US | |
293654 | 293654 | 2022-11-15 | US | Michigan | Grand Traverse | 26055 | 20732 | 264 | 0 | 44.69565625 | -85.55585247 | 2022-11-16 04:21:09 | Grand Traverse, Michigan, US | |
3869982 | 3869982 | 2022-04-05 | US | North Dakota | Ward | 38101 | 20732 | 251 | 0 | 48.22390169 | -101.54367629999999 | 2022-04-06 04:20:49 | Ward, North Dakota, US | |
3855847 | 3855847 | 2022-02-18 | Japan | Oita | 20732 | 94 | 0 | 33.200697 | 131.43323999999998 | 2022-02-19 04:21:11 | Oita, Japan | |||
1465647 | 1465647 | 2022-02-10 | US | Maine | Penobscot | 23019 | 20732 | 271 | 0 | 45.40194593 | -68.65020455 | 2022-02-11 04:21:09 | Penobscot, Maine, US | |
554319 | 554319 | 2021-12-08 | US | Wisconsin | Fond du Lac | 55039 | 20732 | 176 | 0 | 43.75354908 | -88.48885325 | 2021-12-09 04:22:49 | Fond du Lac, Wisconsin, US | |
1804743 | 1804743 | 2021-11-25 | US | Montana | Flathead | 30029 | 20732 | 205 | 0 | 48.29575866 | -114.05205690000001 | 2021-11-26 04:22:33 | Flathead, Montana, US | |
906177 | 906177 | 2021-11-24 | US | Montana | Flathead | 30029 | 20732 | 205 | 0 | 48.29575866 | -114.05205690000001 | 2021-11-25 04:22:33 | Flathead, Montana, US | |
701785 | 701785 | 2021-11-04 | US | Virginia | Newport News | 51700 | 20732 | 301 | 0 | 37.08166899 | -76.51754109 | 2021-11-05 04:21:54 | Newport News, Virginia, US | |
2125951 | 2125951 | 2021-10-21 | US | New Mexico | San Juan | 35045 | 20732 | 546 | 0 | 36.50838318 | -108.32043700000001 | 2021-10-22 04:21:14 | San Juan, New Mexico, US | |
1604163 | 1604163 | 2021-08-16 | Haiti | 20732 | 583 | 0 | 18.9712 | -72.2852 | 2021-08-17 04:21:49 | Haiti | ||||
1771565 | 1771565 | 2021-05-23 | Russia | Mordovia Republic | 20732 | 270 | 18485 | 1977 | 54.4419829 | 44.4661144 | 2021-05-24 04:20:53 | Mordovia Republic, Russia | ||
2781310 | 2781310 | 2021-03-24 | Sweden | Orebro | 20732 | 298 | 0 | 20434 | 59.535 | 15.0066 | 2021-03-25 05:27:00 | Orebro, Sweden | ||
865304 | 865304 | 2020-11-12 | US | California | Contra Costa | 6013 | 20732 | 255 | 0 | 20482 | 37.91923498 | -121.9289527 | 2020-11-13 05:25:30 | Contra Costa, California, US |
61256 | 61256 | 2020-07-23 | US | Massachusetts | Suffolk | 25025 | 20732 | 1042 | 0 | 19690 | 42.3279514 | -71.07850442 | 2020-07-24 05:30:40 | Suffolk, Massachusetts, 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]);