johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 31516 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3038868 | 3038868 | 2022-10-27 | US | Arkansas | Unassigned | 90005 | 31516 | 0 | 0 | 36.38177105 | 0.0 | 2022-10-28 04:22:31 | Unassigned, Arkansas, US | |
3586057 | 3586057 | 2022-05-17 | US | Virginia | Stafford | 51179 | 31516 | 177 | 0 | 38.41758738 | -77.45917053 | 2022-05-18 04:20:50 | Stafford, Virginia, US | |
1432825 | 1432825 | 2021-12-28 | Russia | Tyva Republic | 31516 | 317 | 0 | 51.401714899999995 | 93.8582593 | 2021-12-29 03:21:43 | Tyva Republic, Russia | |||
491580 | 491580 | 2021-10-14 | India | Nagaland | 31516 | 673 | 0 | 26.06702 | 94.470302 | 2021-10-15 04:21:26 | Nagaland, India | |||
3883844 | 3883844 | 2021-04-11 | Russia | Udmurt Republic | 31516 | 777 | 28103 | 2636 | 57.1961165 | 52.69598320000001 | 2021-04-12 04:21:00 | Udmurt Republic, Russia | ||
2056081 | 2056081 | 2021-03-15 | Russia | Ivanovo Oblast | 31516 | 982 | 29768 | 766 | 56.9167446 | 41.43521370000001 | 2021-03-16 05:25:13 | Ivanovo Oblast, Russia | ||
2183790 | 2183790 | 2021-02-26 | Russia | Kemerovo Oblast | 31516 | 556 | 30650 | 310 | 54.53357809999999 | 87.342861 | 2021-02-27 05:22:28 | Kemerovo Oblast, Russia |
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]);