johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 46372 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
899285 | 899285 | 2022-07-24 | US | Texas | Johnson | 48251 | 46372 | 745 | 0 | 32.37877812 | -97.36615819 | 2022-07-25 04:20:51 | Johnson, Texas, US | |
2732799 | 2732799 | 2022-02-27 | Chile | Magallanes | 46372 | 569 | 0 | -52.368 | -70.9863 | 2022-02-28 04:21:05 | Magallanes, Chile | |||
1358953 | 1358953 | 2021-11-27 | US | Colorado | Douglas | 8035 | 46372 | 335 | 0 | 39.33133796 | -104.930001 | 2021-11-28 04:22:43 | Douglas, Colorado, US | |
597546 | 597546 | 2021-10-19 | Eswatini | 46372 | 1236 | 0 | -26.5225 | 31.4659 | 2021-10-20 04:21:00 | Eswatini | ||||
2899877 | 2899877 | 2021-08-12 | Russia | Belgorod Oblast | 46372 | 947 | 0 | 50.7080119 | 37.5837615 | 2021-08-13 04:21:24 | Belgorod Oblast, Russia | |||
825843 | 825843 | 2021-06-06 | Russia | Vologda Oblast | 46372 | 1109 | 43202 | 2061 | 60.0391461 | 43.1215213 | 2021-06-07 04:22:51 | Vologda Oblast, Russia | ||
1121323 | 1121323 | 2020-09-17 | Brazil | Amapa | 46372 | 688 | 34389 | 11295 | 0.902 | -52.003 | 2020-09-18 05:05:00 | Amapa, Brazil |
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]);