johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 17294 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
711076 | 711076 | 2022-11-01 | US | Colorado | Garfield | 8045 | 17294 | 102 | 0 | 39.59921777 | -107.902708 | 2022-11-02 04:22:09 | Garfield, Colorado, US | |
539330 | 539330 | 2022-10-26 | US | California | San Benito | 6069 | 17294 | 107 | 0 | 36.60308176 | -121.069975 | 2022-10-27 04:22:01 | San Benito, California, US | |
3952038 | 3952038 | 2022-08-17 | US | Louisiana | Vermilion | 22113 | 17294 | 233 | 0 | 29.83517605 | -92.30292538 | 2022-08-18 04:21:11 | Vermilion, Louisiana, US | |
3874498 | 3874498 | 2022-07-31 | US | Tennessee | Dickson | 47043 | 17294 | 245 | 0 | 36.14669837 | -87.35891709 | 2022-08-01 04:21:03 | Dickson, Tennessee, US | |
1113073 | 1113073 | 2022-05-21 | US | West Virginia | Mercer | 54055 | 17294 | 266 | 0 | 37.40481169 | -81.11023142 | 2022-05-22 04:20:52 | Mercer, West Virginia, US | |
1172697 | 1172697 | 2022-05-20 | US | West Virginia | Mercer | 54055 | 17294 | 266 | 0 | 37.40481169 | -81.11023142 | 2022-05-21 04:20:58 | Mercer, West Virginia, US | |
1577244 | 1577244 | 2022-04-10 | US | Indiana | Grant | 18053 | 17294 | 347 | 0 | 40.51587228 | -85.65468702 | 2022-04-11 04:21:02 | Grant, Indiana, US | |
1653486 | 1653486 | 2022-04-09 | US | Indiana | Grant | 18053 | 17294 | 347 | 0 | 40.51587228 | -85.65468702 | 2022-04-10 04:20:52 | Grant, Indiana, US | |
2116808 | 2116808 | 2022-04-08 | US | Indiana | Grant | 18053 | 17294 | 347 | 0 | 40.51587228 | -85.65468702 | 2022-04-09 04:20:42 | Grant, Indiana, US | |
3229962 | 3229962 | 2022-01-19 | US | West Virginia | Raleigh | 54081 | 17294 | 249 | 0 | 37.76936795 | -81.2456041 | 2022-01-20 04:21:07 | Raleigh, West Virginia, US | |
2611005 | 2611005 | 2022-01-06 | US | Idaho | Twin Falls | 16083 | 17294 | 251 | 0 | 42.35440512 | -114.6685381 | 2022-01-07 04:22:09 | Twin Falls, Idaho, US | |
1802664 | 1802664 | 2021-11-25 | Iceland | 17294 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-26 04:22:33 | Iceland | ||||
2003346 | 2003346 | 2021-11-07 | US | Pennsylvania | Lycoming | 42081 | 17294 | 365 | 0 | 41.34310539 | -77.06629984 | 2021-11-08 04:21:43 | Lycoming, Pennsylvania, US | |
684991 | 684991 | 2021-10-24 | US | Pennsylvania | Blair | 42013 | 17294 | 379 | 0 | 40.47961444 | -78.34917412 | 2021-10-25 04:22:31 | Blair, Pennsylvania, US | |
2812048 | 2812048 | 2021-09-16 | US | Virginia | Arlington | 51013 | 17294 | 261 | 0 | 38.8767675 | -77.10139853 | 2021-09-17 04:21:46 | Arlington, Virginia, US | |
1344099 | 1344099 | 2021-08-11 | US | Mississippi | Jackson | 28059 | 17294 | 264 | 0 | 30.54020656 | -88.64184064 | 2021-08-12 04:21:25 | Jackson, Mississippi, US | |
3683902 | 3683902 | 2021-08-02 | US | Arizona | Navajo | 4017 | 17294 | 559 | 0 | 35.3997715 | -110.3218983 | 2021-08-03 04:21:39 | Navajo, Arizona, US | |
340063 | 340063 | 2021-02-03 | Chile | Coquimbo | 17294 | 344 | 16231 | 719 | -29.959 | -71.3389 | 2021-02-04 05:22:26 | Coquimbo, Chile | ||
3782144 | 3782144 | 2020-10-13 | Russia | Saratov Oblast | 17294 | 126 | 11660 | 5508 | 51.6520555 | 46.86319520000001 | 2020-10-14 04:24:05 | Saratov Oblast, Russia | ||
3486254 | 3486254 | 2020-08-20 | US | Missouri | St. Louis | 29189 | 17294 | 710 | 0 | 16584 | 38.63770039999999 | -90.4458375 | 2020-08-21 04:27:41 | St. Louis, Missouri, 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]);