johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where confirmed = 11792 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311062 | 311062 | 2022-12-13 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-14 04:21:04 | Medina, Texas, US | |
1152123 | 1152123 | 2022-12-12 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-13 04:21:01 | Medina, Texas, US | |
871977 | 871977 | 2022-12-11 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-12 04:21:01 | Medina, Texas, US | |
260507 | 260507 | 2022-12-10 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-11 04:20:50 | Medina, Texas, US | |
3939221 | 3939221 | 2022-12-09 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-10 04:21:02 | Medina, Texas, US | |
3380553 | 3380553 | 2022-12-08 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-09 04:21:05 | Medina, Texas, US | |
1987824 | 1987824 | 2022-12-07 | US | Texas | Medina | 48325 | 11792 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-12-08 04:21:07 | Medina, Texas, US | |
2970191 | 2970191 | 2022-10-10 | US | Puerto Rico | San Sebastian | 72131 | 11792 | 0 | 0 | 18.328646 | -66.971214 | 2022-10-11 04:23:05 | San Sebastian, Puerto Rico, US | |
1371562 | 1371562 | 2022-09-21 | US | Illinois | Woodford | 17203 | 11792 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-09-22 04:22:56 | Woodford, Illinois, US | |
2098848 | 2098848 | 2022-08-27 | US | Puerto Rico | Cidra | 72041 | 11792 | 0 | 0 | 18.173559 | -66.161179 | 2022-08-28 04:21:02 | Cidra, Puerto Rico, US | |
1993678 | 1993678 | 2022-03-01 | US | Illinois | Marion | 17121 | 11792 | 206 | 0 | 38.64963204 | -88.91899208 | 2022-03-02 04:21:07 | Marion, Illinois, US | |
981473 | 981473 | 2022-02-01 | US | Ohio | Washington | 39167 | 11792 | 189 | 0 | 39.45690571 | -81.49121382 | 2022-02-02 04:21:09 | Washington, Ohio, US | |
1232716 | 1232716 | 2021-11-28 | US | Indiana | Floyd | 18043 | 11792 | 225 | 0 | 38.32117957 | -85.90385377 | 2021-11-29 04:22:30 | Floyd, Indiana, US | |
1359423 | 1359423 | 2021-11-27 | US | Indiana | Floyd | 18043 | 11792 | 225 | 0 | 38.32117957 | -85.90385377 | 2021-11-28 04:22:43 | Floyd, Indiana, US | |
759414 | 759414 | 2021-11-26 | US | Indiana | Floyd | 18043 | 11792 | 225 | 0 | 38.32117957 | -85.90385377 | 2021-11-27 04:22:45 | Floyd, Indiana, US | |
1803831 | 1803831 | 2021-11-25 | US | Indiana | Floyd | 18043 | 11792 | 225 | 0 | 38.32117957 | -85.90385377 | 2021-11-26 04:22:33 | Floyd, Indiana, US | |
905265 | 905265 | 2021-11-24 | US | Indiana | Floyd | 18043 | 11792 | 225 | 0 | 38.32117957 | -85.90385377 | 2021-11-25 04:22:33 | Floyd, Indiana, US | |
3070455 | 3070455 | 2021-11-23 | US | Alaska | Kenai Peninsula | 2122 | 11792 | 65 | 0 | 60.24429722 | -151.53888840000005 | 2021-11-24 04:22:14 | Kenai Peninsula, Alaska, US | |
1277787 | 1277787 | 2021-10-03 | US | West Virginia | Monongalia | 54061 | 11792 | 119 | 0 | 39.63218457 | -80.04766838 | 2021-10-04 04:21:31 | Monongalia, West Virginia, US | |
1263457 | 1263457 | 2021-09-09 | US | Connecticut | Windham | 9015 | 11792 | 198 | 0 | 41.82972709 | -71.98182316 | 2021-09-10 04:21:20 | Windham, Connecticut, US | |
641817 | 641817 | 2021-09-07 | Djibouti | 11792 | 157 | 0 | 11.8251 | 42.5903 | 2021-09-08 04:21:31 | Djibouti | ||||
3107343 | 3107343 | 2021-08-24 | US | Missouri | Cole | 29051 | 11792 | 147 | 0 | 38.50455671 | -92.27860244 | 2021-08-25 04:21:41 | Cole, Missouri, US | |
2353323 | 2353323 | 2021-08-10 | US | Missouri | Clay | 29047 | 11792 | 180 | 0 | 39.31132056 | -94.41850862 | 2021-08-11 04:21:58 | Clay, Missouri, US | |
408778 | 408778 | 2021-07-28 | US | Arkansas | Garland | 5051 | 11792 | 270 | 0 | 34.57692074 | -93.14921604 | 2021-07-29 04:21:33 | Garland, Arkansas, US | |
2392528 | 2392528 | 2021-05-18 | US | Minnesota | Sherburne | 27141 | 11792 | 88 | 0 | 45.44447208 | -93.77617511 | 2021-05-19 04:20:42 | Sherburne, Minnesota, US | |
2412362 | 2412362 | 2021-04-19 | US | Louisiana | Rapides | 22079 | 11792 | 309 | 0 | 31.19778499 | -92.52997303 | 2021-04-20 04:20:41 | Rapides, Louisiana, US | |
390904 | 390904 | 2021-04-04 | US | Pennsylvania | Monroe | 42089 | 11792 | 289 | 0 | 41.05934058 | -75.34031025 | 2021-04-05 04:20:35 | Monroe, Pennsylvania, US | |
1203947 | 1203947 | 2021-03-22 | Pakistan | Azad Jammu and Kashmir | 11792 | 338 | 10406 | 1048 | 34.027401 | 73.947253 | 2021-03-23 05:26:18 | Azad Jammu and Kashmir, Pakistan | ||
1001683 | 1001683 | 2021-03-01 | US | Texas | Wichita | 48485 | 11792 | 346 | 0 | 14220 | 33.98842886 | -98.7041034 | 2021-03-02 05:23:30 | Wichita, Texas, US |
2370741 | 2370741 | 2021-02-28 | US | Texas | Wichita | 48485 | 11792 | 346 | 0 | 14220 | 33.98842886 | -98.7041034 | 2021-03-01 05:23:01 | Wichita, Texas, US |
3069243 | 3069243 | 2021-02-27 | US | Texas | Wichita | 48485 | 11792 | 345 | 0 | 14221 | 33.98842886 | -98.7041034 | 2021-02-28 05:22:20 | Wichita, Texas, US |
533688 | 533688 | 2021-02-22 | US | Tennessee | Sevier | 47155 | 11792 | 159 | 0 | 11678 | 35.78077323 | -83.52244332 | 2021-02-23 05:23:41 | Sevier, Tennessee, US |
3979150 | 3979150 | 2021-02-10 | US | California | Shasta | 6089 | 11792 | 142 | 0 | 11691 | 40.76391419 | -122.0396884 | 2021-02-11 05:23:55 | Shasta, California, US |
1751267 | 1751267 | 2020-12-14 | Jamaica | 11792 | 273 | 8098 | 3421 | 18.1096 | -77.2975 | 2020-12-15 05:26:38 | Jamaica | |||
3443435 | 3443435 | 2020-11-11 | US | Oregon | Multnomah | 41051 | 11792 | 188 | 0 | 11604 | 45.54747959 | -122.4169351 | 2020-11-12 05:25:55 | Multnomah, Oregon, US |
1057456 | 1057456 | 2020-10-23 | Ukraine | Volyn Oblast | 11792 | 233 | 6772 | 4787 | 50.7472 | 25.3254 | 2020-10-24 04:24:46 | Volyn Oblast, Ukraine | ||
1045613 | 1045613 | 2020-09-30 | Chile | Tarapaca | 11792 | 227 | 11293 | 272 | -19.9232 | -69.5132 | 2020-10-01 04:23:42 | Tarapaca, Chile | ||
1243666 | 1243666 | 2020-09-08 | Germany | Berlin | 11792 | 226 | 10833 | 819 | 52.52 | 13.405 | 2020-09-09 04:28:48 | Berlin, Germany |
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]);