johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where confirmed = 20232 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2344025 | 2344025 | 2022-08-31 | US | California | Yuba | 6115 | 20232 | 129 | 0 | 39.26255932 | -121.3535644 | 2022-09-01 04:21:03 | Yuba, California, US | |
159666 | 159666 | 2022-03-29 | US | Michigan | Lapeer | 26087 | 20232 | 417 | 0 | 43.09052506 | -83.22153148 | 2022-03-30 04:20:45 | Lapeer, Michigan, US | |
1438237 | 1438237 | 2022-03-28 | US | Michigan | Lapeer | 26087 | 20232 | 417 | 0 | 43.09052506 | -83.22153148 | 2022-03-29 04:20:46 | Lapeer, Michigan, US | |
188440 | 188440 | 2022-02-13 | US | North Carolina | Surry | 37171 | 20232 | 299 | 0 | 36.41689489 | -80.69102283 | 2022-02-14 04:20:51 | Surry, North Carolina, US | |
318286 | 318286 | 2022-02-12 | US | North Carolina | Surry | 37171 | 20232 | 299 | 0 | 36.41689489 | -80.69102283 | 2022-02-13 04:21:00 | Surry, North Carolina, US | |
235612 | 235612 | 2022-02-11 | US | North Carolina | Surry | 37171 | 20232 | 299 | 0 | 36.41689489 | -80.69102283 | 2022-02-12 04:21:06 | Surry, North Carolina, US | |
2112849 | 2112849 | 2021-12-26 | US | Indiana | Vigo | 18167 | 20232 | 321 | 0 | 39.42944561 | -87.39169027 | 2021-12-27 04:21:58 | Vigo, Indiana, US | |
3606221 | 3606221 | 2021-12-25 | US | Indiana | Vigo | 18167 | 20232 | 321 | 0 | 39.42944561 | -87.39169027 | 2021-12-26 04:21:50 | Vigo, Indiana, US | |
2964539 | 2964539 | 2021-12-24 | US | Indiana | Vigo | 18167 | 20232 | 321 | 0 | 39.42944561 | -87.39169027 | 2021-12-25 04:21:37 | Vigo, Indiana, US | |
3817571 | 3817571 | 2021-12-23 | US | Indiana | Vigo | 18167 | 20232 | 321 | 0 | 39.42944561 | -87.39169027 | 2021-12-24 04:21:34 | Vigo, Indiana, US | |
799579 | 799579 | 2021-12-22 | US | Indiana | Vigo | 18167 | 20232 | 321 | 0 | 39.42944561 | -87.39169027 | 2021-12-23 04:21:21 | Vigo, Indiana, US | |
2903635 | 2903635 | 2021-12-19 | Iceland | 20232 | 36 | 0 | 64.9631 | -19.0208 | 2021-12-20 04:21:43 | Iceland | ||||
1258708 | 1258708 | 2021-12-18 | Iceland | 20232 | 36 | 0 | 64.9631 | -19.0208 | 2021-12-19 04:21:11 | Iceland | ||||
2400228 | 2400228 | 2021-12-17 | US | Kentucky | Hardin | 21093 | 20232 | 332 | 0 | 37.6976111 | -85.96319251 | 2021-12-18 02:22:20 | Hardin, Kentucky, US | |
2398736 | 2398736 | 2021-12-17 | Iceland | 20232 | 36 | 0 | 64.9631 | -19.0208 | 2021-12-18 02:22:20 | Iceland | ||||
1886419 | 1886419 | 2021-09-12 | US | Kentucky | Kenton | 21117 | 20232 | 225 | 0 | 38.93950319 | -84.53241199 | 2021-09-13 04:21:15 | Kenton, Kentucky, US | |
486719 | 486719 | 2021-07-19 | US | Texas | Jefferson | 48245 | 20232 | 443 | 0 | 29.8832777 | -94.16434171 | 2021-07-20 04:21:48 | Jefferson, Texas, US | |
2676942 | 2676942 | 2021-07-18 | US | Texas | Jefferson | 48245 | 20232 | 443 | 0 | 29.8832777 | -94.16434171 | 2021-07-19 04:21:24 | Jefferson, Texas, US | |
3709254 | 3709254 | 2021-07-17 | US | Texas | Jefferson | 48245 | 20232 | 443 | 0 | 29.8832777 | -94.16434171 | 2021-07-18 04:22:07 | Jefferson, Texas, US | |
3132833 | 3132833 | 2021-04-18 | US | Virginia | Chesapeake | 51550 | 20232 | 283 | 0 | 36.67670048 | -76.30545744 | 2021-04-19 04:20:57 | Chesapeake, Virginia, US | |
2784581 | 2784581 | 2021-03-24 | US | Wisconsin | Winnebago | 55139 | 20232 | 207 | 0 | 44.06886922 | -88.64477096 | 2021-03-25 05:27:00 | Winnebago, Wisconsin, US | |
3371119 | 3371119 | 2021-03-21 | US | Mississippi | DeSoto | 28033 | 20232 | 245 | 0 | 34.87625235 | -89.99091418 | 2021-03-22 05:25:43 | DeSoto, Mississippi, US | |
1581637 | 1581637 | 2021-03-13 | US | Louisiana | Calcasieu | 22019 | 20232 | 372 | 0 | 30.22931235 | -93.35400434 | 2021-03-14 05:25:37 | Calcasieu, Louisiana, US | |
1839416 | 1839416 | 2021-03-12 | US | Louisiana | Calcasieu | 22019 | 20232 | 372 | 0 | 30.22931235 | -93.35400434 | 2021-03-13 05:25:15 | Calcasieu, Louisiana, US | |
3518084 | 3518084 | 2021-01-15 | US | Pennsylvania | Northampton | 42095 | 20232 | 503 | 0 | 19729 | 40.75182733 | -75.30471829 | 2021-01-16 05:22:40 | Northampton, Pennsylvania, US |
3389601 | 3389601 | 2020-10-02 | Russia | Krasnoyarsk Krai | 20232 | 555 | 15475 | 4202 | 63.3233807 | 97.0979974 | 2020-10-03 04:23:40 | Krasnoyarsk Krai, Russia | ||
996473 | 996473 | 2020-05-23 | US | Massachusetts | Middlesex | 25017 | 20232 | 1512 | 0 | 18720 | 42.48607732 | -71.39049229 | 2020-05-24 02:32:43 | Middlesex, Massachusetts, 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]);