johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 51791 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1980176 | 1980176 | 2022-09-25 | US | Wisconsin | Kenosha | 55059 | 51791 | 667 | 0 | 42.57639354 | -88.04051686 | 2022-09-26 04:20:52 | Kenosha, Wisconsin, US | |
2653343 | 2653343 | 2022-09-24 | US | Wisconsin | Kenosha | 55059 | 51791 | 667 | 0 | 42.57639354 | -88.04051686 | 2022-09-25 04:23:31 | Kenosha, Wisconsin, US | |
387783 | 387783 | 2022-09-23 | US | Wisconsin | Kenosha | 55059 | 51791 | 667 | 0 | 42.57639354 | -88.04051686 | 2022-09-24 04:21:40 | Kenosha, Wisconsin, US | |
2147849 | 2147849 | 2022-06-27 | Russia | Kalmykia Republic | 51791 | 843 | 0 | 46.2313018 | 45.3275745 | 2022-06-28 04:20:58 | Kalmykia Republic, Russia | |||
3002102 | 3002102 | 2022-05-24 | US | Rhode Island | Kent | 44003 | 51791 | 514 | 0 | 41.67106337 | -71.57641596 | 2022-05-25 04:20:56 | Kent, Rhode Island, US | |
3595823 | 3595823 | 2022-05-23 | US | Rhode Island | Kent | 44003 | 51791 | 514 | 0 | 41.67106337 | -71.57641596 | 2022-05-24 04:20:57 | Kent, Rhode Island, US | |
1112371 | 1112371 | 2022-05-21 | US | Rhode Island | Kent | 44003 | 51791 | 514 | 0 | 41.67106337 | -71.57641596 | 2022-05-22 04:20:52 | Kent, Rhode Island, US | |
1171995 | 1171995 | 2022-05-20 | US | Rhode Island | Kent | 44003 | 51791 | 514 | 0 | 41.67106337 | -71.57641596 | 2022-05-21 04:20:58 | Kent, Rhode Island, US | |
3898758 | 3898758 | 2022-05-19 | US | Rhode Island | Kent | 44003 | 51791 | 514 | 0 | 41.67106337 | -71.57641596 | 2022-05-20 04:20:57 | Kent, Rhode Island, US | |
1187542 | 1187542 | 2022-05-18 | US | Rhode Island | Kent | 44003 | 51791 | 514 | 0 | 41.67106337 | -71.57641596 | 2022-05-19 04:20:54 | Kent, Rhode Island, US | |
2255023 | 2255023 | 2022-04-19 | US | Wisconsin | Winnebago | 55139 | 51791 | 380 | 0 | 44.06886922 | -88.64477096 | 2022-04-20 04:20:45 | Winnebago, Wisconsin, US | |
2092102 | 2092102 | 2022-03-05 | Japan | Kumamoto | 51791 | 244 | 0 | 32.608154 | 130.74523100000002 | 2022-03-06 04:20:49 | Kumamoto, Japan | |||
1059658 | 1059658 | 2022-02-23 | US | Mississippi | Hinds | 28049 | 51791 | 753 | 0 | 32.2656285 | -90.44435448 | 2022-02-24 04:21:14 | Hinds, Mississippi, US | |
2657989 | 2657989 | 2022-01-31 | Russia | Chuvashia Republic | 51791 | 4202 | 0 | 55.4259922 | 47.0849429 | 2022-02-01 04:21:11 | Chuvashia Republic, Russia | |||
1432877 | 1432877 | 2021-12-28 | Suriname | 51791 | 1188 | 0 | 3.9193 | -56.0278 | 2021-12-29 03:21:43 | Suriname | ||||
3894443 | 3894443 | 2021-08-29 | US | Ohio | Summit | 39153 | 51791 | 1048 | 0 | 41.12464734 | -81.53123079 | 2021-08-30 04:21:23 | Summit, Ohio, US | |
2991025 | 2991025 | 2020-08-24 | Brazil | Rondonia | 51791 | 1073 | 42800 | 7918 | -11.5057 | -63.5806 | 2020-08-25 04:28:02 | Rondonia, Brazil | ||
3923612 | 3923612 | 2020-08-09 | Poland | 51791 | 1807 | 36691 | 13293 | 51.9194 | 19.1451 | 2020-08-10 04:34:55 | Poland |
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]);