johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 21630 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1560299 | 1560299 | 2022-09-28 | Russia | Jewish Autonomous Okrug | 21630 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-09-29 04:22:34 | Jewish Autonomous Okrug, Russia | |||
1372655 | 1372655 | 2022-09-21 | US | New Hampshire | Grafton | 33009 | 21630 | 79 | 0 | 43.93779815 | -71.82057197 | 2022-09-22 04:22:56 | Grafton, New Hampshire, US | |
1490883 | 1490883 | 2022-07-26 | US | Virgin Islands | 78 | 21630 | 120 | 0 | 18.3358 | -64.8963 | 2022-07-27 04:21:04 | Virgin Islands, US | ||
2418960 | 2418960 | 2022-07-15 | Malaysia | W.P. Labuan | 21630 | 155 | 0 | 5.2831 | 115.2308 | 2022-07-16 04:21:05 | W.P. Labuan, Malaysia | |||
2536801 | 2536801 | 2022-05-12 | US | Virginia | Roanoke City | 51770 | 21630 | 376 | 0 | 37.27791025 | -79.96189766 | 2022-05-13 04:20:51 | Roanoke City, Virginia, US | |
682566 | 682566 | 2021-10-24 | Russia | Mari El Republic | 21630 | 670 | 0 | 56.576750399999995 | 47.881751200000004 | 2021-10-25 04:22:31 | Mari El Republic, Russia | |||
510345 | 510345 | 2021-08-14 | US | Pennsylvania | Cumberland | 42041 | 21630 | 532 | 0 | 40.1625372 | -77.26130755 | 2021-08-15 04:21:41 | Cumberland, Pennsylvania, US | |
563192 | 563192 | 2021-06-22 | Russia | Mordovia Republic | 21630 | 314 | 19375 | 1941 | 54.4419829 | 44.4661144 | 2021-06-23 04:21:46 | Mordovia Republic, Russia | ||
1538721 | 1538721 | 2021-03-28 | US | South Carolina | Anderson | 45007 | 21630 | 495 | 0 | 34.51828081 | -82.63959517 | 2021-03-29 04:28:35 | Anderson, South Carolina, US | |
1001999 | 1001999 | 2021-03-01 | US | Wisconsin | Outagamie | 55087 | 21630 | 207 | 0 | 21423 | 44.41578887 | -88.46565023 | 2021-03-02 05:23:30 | Outagamie, Wisconsin, US |
2187205 | 2187205 | 2021-02-26 | Ukraine | Kherson Oblast | 21630 | 636 | 20189 | 805 | 46.6354 | 32.6169 | 2021-02-27 05:22:28 | Kherson Oblast, Ukraine | ||
3052347 | 3052347 | 2021-02-16 | US | New Jersey | Somerset | 34035 | 21630 | 772 | 0 | 20858 | 40.56465737 | -74.61683016 | 2021-02-17 05:23:10 | Somerset, New Jersey, US |
1243702 | 1243702 | 2020-09-08 | India | Goa | 21630 | 256 | 16875 | 4499 | 15.359682 | 74.057396 | 2020-09-09 04:28:48 | Goa, India |
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]);