johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 50991 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 4
- Japan 1
- Netherlands 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1984859 | 1984859 | 2022-12-07 | Russia | Karachay-Cherkess Republic | 50991 | 991 | 0 | 43.7368326 | 41.7267991 | 2022-12-08 04:21:07 | Karachay-Cherkess Republic, Russia | |||
230750 | 230750 | 2022-05-31 | US | Louisiana | Ouachita | 22073 | 50991 | 755 | 0 | 32.47645559 | -92.15704172 | 2022-06-01 04:20:55 | Ouachita, Louisiana, US | |
443480 | 443480 | 2021-10-20 | Netherlands | Groningen | 50991 | 262 | 0 | 53.217921999999994 | 6.741514 | 2021-10-21 04:21:18 | Groningen, Netherlands | |||
936198 | 936198 | 2021-10-16 | US | Kentucky | Fayette | 21067 | 50991 | 383 | 0 | 38.0368225 | -84.45576892 | 2021-10-17 04:21:29 | Fayette, Kentucky, US | |
1956917 | 1956917 | 2021-08-05 | US | Alabama | Mobile | 1097 | 50991 | 876 | 0 | 30.78472347 | -88.20842409 | 2021-08-06 04:21:18 | Mobile, Alabama, US | |
3125507 | 3125507 | 2021-06-28 | Japan | Aichi | 50991 | 960 | 48810 | 1221 | 35.035551 | 137.211621 | 2021-06-29 04:21:28 | Aichi, Japan | ||
3963184 | 3963184 | 2021-03-10 | US | Delaware | New Castle | 10003 | 50991 | 737 | 0 | 39.57992638 | -75.64054974 | 2021-03-11 05:25:48 | New Castle, Delaware, 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]);