johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 71223 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 4
- Australia 1
- Netherlands 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
256324 | 256324 | 2022-09-08 | US | Tennessee | Williamson | 47187 | 71223 | 422 | 0 | 35.89099229 | -86.89281867 | 2022-09-09 04:21:11 | Williamson, Tennessee, US | |
253990 | 253990 | 2022-09-08 | US | Delaware | Sussex | 10005 | 71223 | 896 | 0 | 38.66143781 | -75.39031349 | 2022-09-09 04:21:11 | Sussex, Delaware, US | |
1313881 | 1313881 | 2022-05-27 | Australia | Northern Territory | 71223 | 49 | 0 | -12.4634 | 130.8456 | 2022-05-28 04:21:07 | Northern Territory, Australia | |||
99447 | 99447 | 2022-01-14 | Netherlands | Drenthe | 71223 | 425 | 0 | 52.862485 | 6.6184350000000025 | 2022-01-15 04:21:07 | Drenthe, Netherlands | |||
1284649 | 1284649 | 2022-01-05 | US | Pennsylvania | Chester | 42029 | 71223 | 976 | 0 | 39.97291773 | -75.74768357 | 2022-01-06 04:22:09 | Chester, Pennsylvania, US | |
3971088 | 3971088 | 2021-06-11 | US | California | Contra Costa | 6013 | 71223 | 808 | 0 | 37.91923498 | -121.9289527 | 2021-06-12 04:22:22 | Contra Costa, California, US | |
3249356 | 3249356 | 2020-06-21 | Spain | Madrid | 71223 | 8416 | 40736 | 22071 | 40.4168 | -3.7038 | 2020-06-22 04:33:20 | Madrid, Spain |
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]);