johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where country_or_region = "US", deaths = 361 and province_or_state = "West Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2532910 | 2532910 | 2022-10-06 | US | West Virginia | Wood | 54107 | 26515 | 361 | 0 | 39.20967886 | -81.5162836 | 2022-10-07 04:23:08 | Wood, West Virginia, US | |
1814304 | 1814304 | 2022-10-05 | US | West Virginia | Wood | 54107 | 26505 | 361 | 0 | 39.20967886 | -81.5162836 | 2022-10-06 04:21:22 | Wood, West Virginia, US | |
134278 | 134278 | 2022-10-04 | US | West Virginia | Wood | 54107 | 26492 | 361 | 0 | 39.20967886 | -81.5162836 | 2022-10-05 04:23:06 | Wood, West Virginia, US | |
411779 | 411779 | 2021-07-28 | US | West Virginia | Kanawha | 54039 | 15663 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-29 04:21:33 | Kanawha, West Virginia, US | |
1309640 | 1309640 | 2021-07-27 | US | West Virginia | Kanawha | 54039 | 15649 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-28 04:21:39 | Kanawha, West Virginia, US | |
3221783 | 3221783 | 2021-07-26 | US | West Virginia | Kanawha | 54039 | 15630 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-27 04:21:18 | Kanawha, West Virginia, US | |
1381992 | 1381992 | 2021-07-25 | US | West Virginia | Kanawha | 54039 | 15594 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-26 04:21:28 | Kanawha, West Virginia, US | |
1333732 | 1333732 | 2021-07-24 | US | West Virginia | Kanawha | 54039 | 15594 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-25 04:22:12 | Kanawha, West Virginia, US | |
3141036 | 3141036 | 2021-07-23 | US | West Virginia | Kanawha | 54039 | 15594 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-24 00:21:36 | Kanawha, West Virginia, US | |
3479796 | 3479796 | 2021-07-22 | US | West Virginia | Kanawha | 54039 | 15586 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-23 04:21:29 | Kanawha, West Virginia, US | |
3335015 | 3335015 | 2021-07-21 | US | West Virginia | Kanawha | 54039 | 15579 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-22 04:21:19 | Kanawha, West Virginia, US | |
2374996 | 2374996 | 2021-07-20 | US | West Virginia | Kanawha | 54039 | 15574 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-21 04:21:40 | Kanawha, West Virginia, US | |
487075 | 487075 | 2021-07-19 | US | West Virginia | Kanawha | 54039 | 15569 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-20 04:21:48 | Kanawha, West Virginia, US | |
2677298 | 2677298 | 2021-07-18 | US | West Virginia | Kanawha | 54039 | 15553 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-19 04:21:24 | Kanawha, West Virginia, US | |
3709610 | 3709610 | 2021-07-17 | US | West Virginia | Kanawha | 54039 | 15553 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-18 04:22:07 | Kanawha, West Virginia, US | |
2950841 | 2950841 | 2021-07-16 | US | West Virginia | Kanawha | 54039 | 15553 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-17 04:22:22 | Kanawha, West Virginia, US | |
299497 | 299497 | 2021-07-15 | US | West Virginia | Kanawha | 54039 | 15547 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-16 04:21:22 | Kanawha, West Virginia, US | |
3635442 | 3635442 | 2021-07-14 | US | West Virginia | Kanawha | 54039 | 15539 | 361 | 0 | 38.33860077 | -81.52857054 | 2021-07-15 04:21:48 | 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]);