johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 23220 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 26
- Russia 1
- Timor-Leste 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1627855 | 1627855 | 2022-09-22 | US | Wisconsin | Manitowoc | 55071 | 23220 | 198 | 0 | 44.11946801 | -87.80928853 | 2022-09-23 04:23:13 | Manitowoc, Wisconsin, US | |
1625446 | 1625446 | 2022-09-22 | US | Indiana | Warrick | 18173 | 23220 | 247 | 0 | 38.08922676 | -87.2716085 | 2022-09-23 04:23:13 | Warrick, Indiana, US | |
1371650 | 1371650 | 2022-09-21 | US | Indiana | Warrick | 18173 | 23220 | 247 | 0 | 38.08922676 | -87.2716085 | 2022-09-22 04:22:56 | Warrick, Indiana, US | |
374472 | 374472 | 2022-09-13 | US | New York | Steuben | 36101 | 23220 | 262 | 0 | 42.2689144 | -77.3829924 | 2022-09-14 04:20:44 | Steuben, New York, US | |
2395141 | 2395141 | 2022-09-12 | Timor-Leste | 23220 | 138 | 0 | -8.874217 | 125.727539 | 2022-09-13 04:20:57 | Timor-Leste | ||||
3546833 | 3546833 | 2022-08-08 | US | Virginia | Frederick | 51069 | 23220 | 257 | 0 | 39.20172582 | -78.25974949 | 2022-08-09 04:20:34 | Frederick, Virginia, US | |
1101394 | 1101394 | 2022-08-03 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-08-04 04:20:58 | Tooele, Utah, US | |
1408319 | 1408319 | 2022-08-02 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-08-03 04:20:59 | Tooele, Utah, US | |
3620357 | 3620357 | 2022-08-01 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-08-02 04:20:53 | Tooele, Utah, US | |
3874837 | 3874837 | 2022-07-31 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-08-01 04:21:03 | Tooele, Utah, US | |
677591 | 677591 | 2022-07-30 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-07-31 04:21:02 | Tooele, Utah, US | |
1786790 | 1786790 | 2022-07-29 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-07-30 04:20:42 | Tooele, Utah, US | |
1069153 | 1069153 | 2022-07-28 | US | Utah | Tooele | 49045 | 23220 | 108 | 0 | 40.44862644 | -113.1295715 | 2022-07-29 04:20:45 | Tooele, Utah, US | |
1576522 | 1576522 | 2022-04-10 | US | Alabama | Elmore | 1051 | 23220 | 343 | 0 | 32.59785413 | -86.14415284 | 2022-04-11 04:21:02 | Elmore, Alabama, US | |
1652764 | 1652764 | 2022-04-09 | US | Alabama | Elmore | 1051 | 23220 | 343 | 0 | 32.59785413 | -86.14415284 | 2022-04-10 04:20:52 | Elmore, Alabama, US | |
2116086 | 2116086 | 2022-04-08 | US | Alabama | Elmore | 1051 | 23220 | 343 | 0 | 32.59785413 | -86.14415284 | 2022-04-09 04:20:42 | Elmore, Alabama, US | |
1117133 | 1117133 | 2022-01-11 | US | Wisconsin | Eau Claire | 55035 | 23220 | 166 | 0 | 44.726614 | -91.28609183 | 2022-01-12 04:21:44 | Eau Claire, Wisconsin, US | |
1033074 | 1033074 | 2021-12-06 | US | Pennsylvania | Schuylkill | 42107 | 23220 | 514 | 0 | 40.70497338 | -76.2150785 | 2021-12-07 04:22:34 | Schuylkill, Pennsylvania, US | |
3196666 | 3196666 | 2021-09-06 | US | Pennsylvania | Erie | 42049 | 23220 | 434 | 0 | 41.99253829 | -80.03301954 | 2021-09-07 04:21:35 | Erie, Pennsylvania, US | |
3973174 | 3973174 | 2021-06-11 | US | Oregon | Marion | 41047 | 23220 | 322 | 0 | 44.90287942 | -122.5815117 | 2021-06-12 04:22:22 | Marion, Oregon, US | |
523304 | 523304 | 2021-06-09 | US | Arizona | Mohave | 4015 | 23220 | 741 | 0 | 35.70471703 | -113.7577902 | 2021-06-10 04:23:17 | Mohave, Arizona, US | |
2452278 | 2452278 | 2021-05-02 | US | Louisiana | Lafayette | 22055 | 23220 | 276 | 0 | 30.2049055 | -92.06959876 | 2021-05-03 04:20:39 | Lafayette, Louisiana, US | |
2826291 | 2826291 | 2021-05-01 | US | Louisiana | Lafayette | 22055 | 23220 | 276 | 0 | 30.2049055 | -92.06959876 | 2021-05-02 04:20:48 | Lafayette, Louisiana, US | |
381699 | 381699 | 2021-04-30 | US | Louisiana | Lafayette | 22055 | 23220 | 276 | 0 | 30.2049055 | -92.06959876 | 2021-05-01 04:20:47 | Lafayette, Louisiana, US | |
2983451 | 2983451 | 2021-04-10 | Russia | Chuvashia Republic | 23220 | 1278 | 21164 | 778 | 55.4259922 | 47.0849429 | 2021-04-11 04:20:56 | Chuvashia Republic, Russia | ||
3456424 | 3456424 | 2021-03-18 | US | Wisconsin | Racine | 55101 | 23220 | 358 | 0 | 42.74753117 | -88.05941254 | 2021-03-19 05:26:09 | Racine, Wisconsin, US | |
183935 | 183935 | 2021-02-21 | US | Missouri | Greene | 29077 | 23220 | 416 | 0 | 22804 | 37.2575872 | -93.34230916 | 2021-02-22 05:24:21 | Greene, Missouri, US |
227220 | 227220 | 2020-04-30 | US | California | Los Angeles | 6037 | 23220 | 1111 | 0 | 22109 | 34.30828379 | -118.22824109999999 | 2020-05-01 02:32:28 | Los Angeles, California, 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]);