johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where country_or_region = "US", deaths = 370 and province_or_state = "West Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 31 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
872328 | 872328 | 2022-12-11 | US | West Virginia | Wood | 54107 | 27191 | 370 | 0 | 39.20967886 | -81.5162836 | 2022-12-12 04:21:01 | Wood, West Virginia, US | |
260858 | 260858 | 2022-12-10 | US | West Virginia | Wood | 54107 | 27191 | 370 | 0 | 39.20967886 | -81.5162836 | 2022-12-11 04:20:50 | Wood, West Virginia, US | |
3939572 | 3939572 | 2022-12-09 | US | West Virginia | Wood | 54107 | 27191 | 370 | 0 | 39.20967886 | -81.5162836 | 2022-12-10 04:21:02 | Wood, West Virginia, US | |
3380904 | 3380904 | 2022-12-08 | US | West Virginia | Wood | 54107 | 27174 | 370 | 0 | 39.20967886 | -81.5162836 | 2022-12-09 04:21:05 | Wood, West Virginia, US | |
1988175 | 1988175 | 2022-12-07 | US | West Virginia | Wood | 54107 | 27165 | 370 | 0 | 39.20967886 | -81.5162836 | 2022-12-08 04:21:07 | Wood, West Virginia, US | |
3717698 | 3717698 | 2022-12-06 | US | West Virginia | Wood | 54107 | 27151 | 370 | 0 | 39.20967886 | -81.5162836 | 2022-12-07 04:20:58 | Wood, West Virginia, US | |
994506 | 994506 | 2022-08-16 | US | West Virginia | Raleigh | 54081 | 26706 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-17 04:20:59 | Raleigh, West Virginia, US | |
2497545 | 2497545 | 2022-08-15 | US | West Virginia | Raleigh | 54081 | 26664 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-16 04:20:58 | Raleigh, West Virginia, US | |
3651095 | 3651095 | 2022-08-14 | US | West Virginia | Raleigh | 54081 | 26582 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-15 04:20:59 | Raleigh, West Virginia, US | |
1972101 | 1972101 | 2022-08-13 | US | West Virginia | Raleigh | 54081 | 26582 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-14 04:20:55 | Raleigh, West Virginia, US | |
2891910 | 2891910 | 2022-08-12 | US | West Virginia | Raleigh | 54081 | 26582 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-13 04:20:52 | Raleigh, West Virginia, US | |
3911515 | 3911515 | 2022-08-11 | US | West Virginia | Raleigh | 54081 | 26540 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-12 04:20:54 | Raleigh, West Virginia, US | |
1349832 | 1349832 | 2022-08-10 | US | West Virginia | Raleigh | 54081 | 26461 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-11 04:20:49 | Raleigh, West Virginia, US | |
1089587 | 1089587 | 2022-08-09 | US | West Virginia | Raleigh | 54081 | 26414 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-10 04:20:57 | Raleigh, West Virginia, US | |
3547002 | 3547002 | 2022-08-08 | US | West Virginia | Raleigh | 54081 | 26358 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-09 04:20:34 | Raleigh, West Virginia, US | |
1073405 | 1073405 | 2022-08-07 | US | West Virginia | Raleigh | 54081 | 26259 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-08 04:21:08 | Raleigh, West Virginia, US | |
1943993 | 1943993 | 2022-08-06 | US | West Virginia | Raleigh | 54081 | 26259 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-07 04:20:54 | Raleigh, West Virginia, US | |
883792 | 883792 | 2022-08-05 | US | West Virginia | Raleigh | 54081 | 26259 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-06 04:20:56 | Raleigh, West Virginia, US | |
2012203 | 2012203 | 2022-08-04 | US | West Virginia | Raleigh | 54081 | 26195 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-05 04:20:52 | Raleigh, West Virginia, US | |
1101630 | 1101630 | 2022-08-03 | US | West Virginia | Raleigh | 54081 | 26147 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-04 04:20:58 | Raleigh, West Virginia, US | |
1408555 | 1408555 | 2022-08-02 | US | West Virginia | Raleigh | 54081 | 26080 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-03 04:20:59 | Raleigh, West Virginia, US | |
3620593 | 3620593 | 2022-08-01 | US | West Virginia | Raleigh | 54081 | 26013 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-02 04:20:53 | Raleigh, West Virginia, US | |
3875073 | 3875073 | 2022-07-31 | US | West Virginia | Raleigh | 54081 | 25876 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-08-01 04:21:03 | Raleigh, West Virginia, US | |
677827 | 677827 | 2022-07-30 | US | West Virginia | Raleigh | 54081 | 25876 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-07-31 04:21:02 | Raleigh, West Virginia, US | |
1787026 | 1787026 | 2022-07-29 | US | West Virginia | Raleigh | 54081 | 25876 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-07-30 04:20:42 | Raleigh, West Virginia, US | |
1069389 | 1069389 | 2022-07-28 | US | West Virginia | Raleigh | 54081 | 25819 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-07-29 04:20:45 | Raleigh, West Virginia, US | |
2338908 | 2338908 | 2022-07-27 | US | West Virginia | Raleigh | 54081 | 25719 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-07-28 04:20:56 | Raleigh, West Virginia, US | |
1491098 | 1491098 | 2022-07-26 | US | West Virginia | Raleigh | 54081 | 25648 | 370 | 0 | 37.76936795 | -81.2456041 | 2022-07-27 04:21:04 | Raleigh, West Virginia, US | |
2322808 | 2322808 | 2022-03-16 | US | West Virginia | Cabell | 54011 | 27258 | 370 | 0 | 38.42424062 | -82.23855912 | 2022-03-17 04:20:56 | Cabell, West Virginia, US | |
1599692 | 1599692 | 2021-08-26 | US | West Virginia | Kanawha | 54039 | 17231 | 370 | 0 | 38.33860077 | -81.52857054 | 2021-08-27 04:21:37 | Kanawha, West Virginia, US | |
35901 | 35901 | 2021-08-25 | US | West Virginia | Kanawha | 54039 | 17035 | 370 | 0 | 38.33860077 | -81.52857054 | 2021-08-26 04:21:28 | Kanawha, West Virginia, 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]);