johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where confirmed = 17951 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1628915 | 1628915 | 2022-12-18 | US | Colorado | Broomfield | 8014 | 17951 | 127 | 0 | 39.95998787 | -105.0566324 | 2022-12-19 04:21:03 | Broomfield, Colorado, US | |
504294 | 504294 | 2022-12-17 | US | Colorado | Broomfield | 8014 | 17951 | 127 | 0 | 39.95998787 | -105.0566324 | 2022-12-18 04:21:03 | Broomfield, Colorado, US | |
3324866 | 3324866 | 2022-12-16 | US | Colorado | Broomfield | 8014 | 17951 | 127 | 0 | 39.95998787 | -105.0566324 | 2022-12-17 04:21:04 | Broomfield, Colorado, US | |
320415 | 320415 | 2022-10-30 | US | Arkansas | Crawford | 5033 | 17951 | 278 | 0 | 35.58928601 | -94.2446814 | 2022-10-31 04:21:36 | Crawford, Arkansas, US | |
3431591 | 3431591 | 2022-07-14 | US | Oregon | Josephine | 41033 | 17951 | 348 | 0 | 42.3665549 | -123.5561938 | 2022-07-15 04:20:53 | Josephine, Oregon, US | |
1419872 | 1419872 | 2022-07-08 | US | Puerto Rico | Toa Baja | 72137 | 17951 | 0 | 0 | 18.431446 | -66.213553 | 2022-07-09 04:20:59 | Toa Baja, Puerto Rico, US | |
3188991 | 3188991 | 2022-05-30 | US | Tennessee | Tipton | 47167 | 17951 | 236 | 0 | 35.501942 | -89.73694895 | 2022-05-31 04:20:51 | Tipton, Tennessee, US | |
2476655 | 2476655 | 2022-02-03 | US | Pennsylvania | Somerset | 42111 | 17951 | 378 | 0 | 39.97172723 | -79.02699593 | 2022-02-04 04:21:10 | Somerset, Pennsylvania, US | |
3464511 | 3464511 | 2022-01-18 | Taiwan* | 17951 | 851 | 0 | 23.7 | 121.0 | 2022-01-19 04:21:23 | Taiwan* | ||||
153523 | 153523 | 2021-11-29 | US | Wisconsin | Dodge | 55027 | 17951 | 239 | 0 | 43.41576662 | -88.70928178 | 2021-11-30 04:22:53 | Dodge, Wisconsin, US | |
1358783 | 1358783 | 2021-11-27 | US | Arizona | Cochise | 4003 | 17951 | 387 | 0 | 31.87934684 | -109.7516088 | 2021-11-28 04:22:43 | Cochise, Arizona, US | |
3752574 | 3752574 | 2021-11-22 | US | Washington | Kitsap | 53035 | 17951 | 246 | 0 | 47.63479026 | -122.6436061 | 2021-11-23 04:22:39 | Kitsap, Washington, US | |
2773369 | 2773369 | 2021-09-30 | US | Alabama | Marshall | 1095 | 17951 | 280 | 0 | 34.36975964 | -86.30486727 | 2021-10-01 04:21:35 | Marshall, Alabama, US | |
1712769 | 1712769 | 2021-06-25 | US | Arizona | Coconino | 4005 | 17951 | 330 | 0 | 35.83883429 | -111.7707178 | 2021-06-26 04:21:43 | Coconino, Arizona, US | |
2784843 | 2784843 | 2020-11-13 | Colombia | Boyaca | 17951 | 368 | 15568 | 2015 | 5.4545 | -73.362 | 2020-11-14 05:25:37 | Boyaca, Colombia | ||
894946 | 894946 | 2020-11-05 | US | South Carolina | Richland | 45079 | 17951 | 277 | 0 | 17674 | 34.01791263 | -80.90267209 | 2020-11-06 05:24:55 | Richland, South Carolina, US |
2655935 | 2655935 | 2020-09-23 | US | New Jersey | Union | 34039 | 17951 | 1356 | 0 | 16595 | 40.65835409 | -74.30680092 | 2020-09-24 04:23:00 | Union, New Jersey, US |
3610705 | 3610705 | 2020-08-06 | US | New Jersey | Middlesex | 34023 | 17951 | 1401 | 0 | 16550 | 40.43629879 | -74.41426991 | 2020-08-07 04:35:11 | Middlesex, New Jersey, US |
2808133 | 2808133 | 2020-08-02 | Mexico | Sonora | 17951 | 1988 | 15019 | 944 | 29.2972 | -110.3309 | 2020-08-03 04:34:35 | Sonora, Mexico |
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]);