johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where confirmed = 21136 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1203076 | 1203076 | 2022-07-06 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-07 04:20:55 | Central Utah, Utah, US | ||
3969819 | 3969819 | 2022-07-05 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-06 04:20:58 | Central Utah, Utah, US | ||
3081330 | 3081330 | 2022-07-04 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-05 04:20:45 | Central Utah, Utah, US | ||
1770612 | 1770612 | 2022-07-03 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-04 04:20:54 | Central Utah, Utah, US | ||
3368598 | 3368598 | 2022-07-02 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-03 04:20:59 | Central Utah, Utah, US | ||
596927 | 596927 | 2022-07-01 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-02 04:21:16 | Central Utah, Utah, US | ||
3943328 | 3943328 | 2022-06-30 | US | Utah | Central Utah | 21136 | 167 | 0 | 39.37231946 | -111.5758676 | 2022-07-01 04:21:10 | Central Utah, Utah, US | ||
2310689 | 2310689 | 2022-04-20 | US | Virginia | Roanoke | 51161 | 21136 | 281 | 0 | 37.26865804 | -80.06396753 | 2022-04-21 04:20:46 | Roanoke, Virginia, US | |
1115751 | 1115751 | 2022-01-11 | US | New Hampshire | Strafford | 33017 | 21136 | 169 | 0 | 43.291833000000004 | -71.02336013 | 2022-01-12 04:21:44 | Strafford, New Hampshire, US | |
683178 | 683178 | 2021-10-24 | US | Georgia | Lowndes | 13185 | 21136 | 306 | 0 | 30.83568832 | -83.27056716 | 2021-10-25 04:22:31 | Lowndes, Georgia, US | |
771186 | 771186 | 2021-10-23 | US | Georgia | Lowndes | 13185 | 21136 | 306 | 0 | 30.83568832 | -83.27056716 | 2021-10-24 04:21:22 | Lowndes, Georgia, US | |
654833 | 654833 | 2021-10-22 | US | Georgia | Lowndes | 13185 | 21136 | 306 | 0 | 30.83568832 | -83.27056716 | 2021-10-23 04:21:32 | Lowndes, Georgia, US | |
3107801 | 3107801 | 2021-08-24 | US | North Carolina | Onslow | 37133 | 21136 | 171 | 0 | 34.72607366 | -77.42908179 | 2021-08-25 04:21:41 | Onslow, North Carolina, US | |
1344587 | 1344587 | 2021-08-11 | US | North Carolina | Catawba | 37035 | 21136 | 312 | 0 | 35.66211129 | -81.2132617 | 2021-08-12 04:21:25 | Catawba, North Carolina, US | |
57461 | 57461 | 2021-03-07 | US | Pennsylvania | Dauphin | 42043 | 21136 | 500 | 0 | 40.41377078 | -76.77993242 | 2021-03-08 05:24:48 | Dauphin, Pennsylvania, US | |
2681386 | 2681386 | 2021-02-13 | US | Wisconsin | Outagamie | 55087 | 21136 | 196 | 0 | 20940 | 44.41578887 | -88.46565023 | 2021-02-14 05:23:43 | Outagamie, Wisconsin, US |
202052 | 202052 | 2020-12-25 | Chile | OHiggins | 21136 | 577 | 20152 | 407 | -34.5755 | -71.0022 | 2020-12-26 05:22:28 | OHiggins, Chile | ||
8115 | 8115 | 2020-10-25 | Chile | Antofagasta | 21136 | 528 | 20312 | 296 | -23.6509 | -70.3975 | 2020-10-26 04:25:02 | Antofagasta, Chile | ||
3782226 | 3782226 | 2020-10-13 | Sweden | Vastra Gotaland | 21136 | 867 | 0 | 20269 | 58.2528 | 13.0596 | 2020-10-14 04:24:05 | Vastra Gotaland, Sweden |
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]);