johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where confirmed = 31822 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 7
- Russia 2
- Mauritania 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
91708 | 91708 | 2022-07-23 | US | California | Napa | 6055 | 31822 | 148 | 0 | 38.50735751 | -122.332839 | 2022-07-24 04:20:47 | Napa, California, US | |
900730 | 900730 | 2022-07-22 | US | California | Napa | 6055 | 31822 | 148 | 0 | 38.50735751 | -122.332839 | 2022-07-23 04:20:53 | Napa, California, US | |
670866 | 670866 | 2022-07-21 | US | California | Napa | 6055 | 31822 | 145 | 0 | 38.50735751 | -122.332839 | 2022-07-22 04:21:15 | Napa, California, US | |
144981 | 144981 | 2022-07-09 | US | Tennessee | Sevier | 47155 | 31822 | 424 | 0 | 35.78077323 | -83.52244332 | 2022-07-10 04:20:54 | Sevier, Tennessee, US | |
129381 | 129381 | 2022-01-09 | US | Pennsylvania | Beaver | 42007 | 31822 | 624 | 0 | 40.6825484 | -80.34921611 | 2022-01-10 04:22:07 | Beaver, Pennsylvania, US | |
2288979 | 2288979 | 2021-11-15 | US | Louisiana | Ouachita | 22073 | 31822 | 592 | 0 | 32.47645559 | -92.15704172 | 2021-11-16 04:21:10 | Ouachita, Louisiana, US | |
770555 | 770555 | 2021-10-23 | Russia | Kalmykia Republic | 31822 | 642 | 0 | 46.2313018 | 45.3275745 | 2021-10-24 04:21:22 | Kalmykia Republic, Russia | |||
2175626 | 2175626 | 2021-08-22 | Mauritania | 31822 | 673 | 0 | 21.0079 | -10.9408 | 2021-08-23 04:21:27 | Mauritania | ||||
484603 | 484603 | 2021-07-19 | US | Illinois | Madison | 17119 | 31822 | 533 | 0 | 38.83042506 | -89.90422563 | 2021-07-20 04:21:48 | Madison, Illinois, US | |
2207842 | 2207842 | 2021-03-04 | Russia | Belgorod Oblast | 31822 | 494 | 29138 | 2190 | 50.7080119 | 37.5837615 | 2021-03-05 05:26:29 | Belgorod 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]);