johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where confirmed = 25488 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3890606 | 3890606 | 2022-06-06 | US | Tennessee | Putnam | 47141 | 25488 | 305 | 0 | 36.14005459 | -85.50646123 | 2022-06-07 04:21:08 | Putnam, Tennessee, US | |
3888006 | 3888006 | 2022-06-06 | US | Alabama | Limestone | 1083 | 25488 | 295 | 0 | 34.81185586 | -86.98310072 | 2022-06-07 04:21:08 | Limestone, Alabama, US | |
1318882 | 1318882 | 2022-01-26 | US | Connecticut | Middlesex | 9007 | 25488 | 447 | 0 | 41.45949668 | -72.53714864 | 2022-01-27 04:21:19 | Middlesex, Connecticut, US | |
3289772 | 3289772 | 2021-11-18 | US | Georgia | Paulding | 13223 | 25488 | 345 | 0 | 33.91969522 | -84.86848792 | 2021-11-19 04:21:40 | Paulding, Georgia, US | |
28973 | 28973 | 2021-11-11 | US | California | Madera | 6039 | 25488 | 293 | 0 | 37.21513971 | -119.76655890000002 | 2021-11-12 04:22:01 | Madera, California, US | |
3904423 | 3904423 | 2021-07-31 | US | Arizona | Mohave | 4015 | 25488 | 792 | 0 | 35.70471703 | -113.7577902 | 2021-08-01 04:21:50 | Mohave, Arizona, US | |
83289 | 83289 | 2021-05-25 | Russia | Chuvashia Republic | 25488 | 1413 | 23272 | 803 | 55.4259922 | 47.0849429 | 2021-05-26 04:20:35 | Chuvashia Republic, Russia | ||
845800 | 845800 | 2020-12-12 | Russia | Omsk Oblast | 25488 | 728 | 23135 | 1625 | 56.09352629999999 | 73.5099936 | 2020-12-13 05:27:20 | Omsk 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]);