johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where confirmed = 35173 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3463158 | 3463158 | 2022-11-21 | US | Tennessee | Sevier | 47155 | 35173 | 439 | 0 | 35.78077323 | -83.52244332 | 2022-11-22 04:20:47 | Sevier, Tennessee, US | |
3953725 | 3953725 | 2022-08-17 | US | Texas | Taylor | 48441 | 35173 | 737 | 0 | 32.30163422 | -99.89007449 | 2022-08-18 04:21:11 | Taylor, Texas, US | |
2008880 | 2008880 | 2022-08-04 | Russia | Altai Republic | 35173 | 622 | 0 | 50.7114101 | 86.8572186 | 2022-08-05 04:20:52 | Altai Republic, Russia | |||
3729413 | 3729413 | 2022-06-07 | US | Texas | Parker | 48367 | 35173 | 450 | 0 | 32.77757172 | -97.80500621 | 2022-06-08 04:20:55 | Parker, Texas, US | |
1398178 | 1398178 | 2022-05-06 | US | Arkansas | Faulkner | 5045 | 35173 | 315 | 0 | 35.14719007 | -92.33717519 | 2022-05-07 04:21:09 | Faulkner, Arkansas, US | |
1061048 | 1061048 | 2022-02-23 | US | Texas | Potter | 48375 | 35173 | 669 | 0 | 35.40133773 | -101.893964 | 2022-02-24 04:21:14 | Potter, Texas, US | |
315861 | 315861 | 2022-02-12 | India | Nagaland | 35173 | 750 | 0 | 26.06702 | 94.470302 | 2022-02-13 04:21:00 | Nagaland, India | |||
3615366 | 3615366 | 2022-01-12 | US | North Carolina | Catawba | 37035 | 35173 | 480 | 0 | 35.66211129 | -81.2132617 | 2022-01-13 08:00:09 | Catawba, North Carolina, US | |
3831585 | 3831585 | 2021-12-21 | US | Texas | Hays | 48209 | 35173 | 411 | 0 | 30.05669873 | -98.02944344 | 2021-12-22 04:21:54 | Hays, Texas, US | |
838170 | 838170 | 2020-08-17 | US | California | San Diego | 6073 | 35173 | 626 | 0 | 34547 | 33.03484597 | -116.7365326 | 2020-08-18 04:27:56 | San Diego, California, 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]);