johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where deaths = 280 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3756975 | 3756975 | 2022-10-13 | US | West Virginia | Mercer | 54055 | 21855 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-14 04:22:28 | Mercer, West Virginia, US | |
3217800 | 3217800 | 2022-10-12 | US | West Virginia | Mercer | 54055 | 21847 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-13 04:22:39 | Mercer, West Virginia, US | |
3253649 | 3253649 | 2022-10-11 | US | West Virginia | Mercer | 54055 | 21835 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-12 04:22:51 | Mercer, West Virginia, US | |
2970908 | 2970908 | 2022-10-10 | US | West Virginia | Mercer | 54055 | 21798 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-11 04:23:05 | Mercer, West Virginia, US | |
3100944 | 3100944 | 2022-10-09 | US | West Virginia | Mercer | 54055 | 21798 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-10 04:22:32 | Mercer, West Virginia, US | |
4006169 | 4006169 | 2022-10-08 | US | West Virginia | Mercer | 54055 | 21798 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-09 04:21:16 | Mercer, West Virginia, US | |
399766 | 399766 | 2022-10-07 | US | West Virginia | Mercer | 54055 | 21798 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-08 04:22:56 | Mercer, West Virginia, US | |
2532883 | 2532883 | 2022-10-06 | US | West Virginia | Mercer | 54055 | 21791 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-07 04:23:08 | Mercer, West Virginia, US | |
1814277 | 1814277 | 2022-10-05 | US | West Virginia | Mercer | 54055 | 21782 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-06 04:21:22 | Mercer, West Virginia, US | |
134251 | 134251 | 2022-10-04 | US | West Virginia | Mercer | 54055 | 21764 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-05 04:23:06 | Mercer, West Virginia, US | |
2689198 | 2689198 | 2022-10-03 | US | West Virginia | Mercer | 54055 | 21758 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-04 04:22:55 | Mercer, West Virginia, US | |
2263265 | 2263265 | 2022-10-02 | US | West Virginia | Mercer | 54055 | 21712 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-03 04:23:11 | Mercer, West Virginia, US | |
2998791 | 2998791 | 2022-10-01 | US | West Virginia | Mercer | 54055 | 21712 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-02 04:21:23 | Mercer, West Virginia, US | |
857117 | 857117 | 2022-09-30 | US | West Virginia | Mercer | 54055 | 21712 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-10-01 04:23:01 | Mercer, West Virginia, US | |
2379043 | 2379043 | 2022-09-29 | US | West Virginia | Mercer | 54055 | 21698 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-30 04:23:09 | Mercer, West Virginia, US | |
1563594 | 1563594 | 2022-09-28 | US | West Virginia | Mercer | 54055 | 21680 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-29 04:22:34 | Mercer, West Virginia, US | |
3998137 | 3998137 | 2022-09-27 | US | West Virginia | Mercer | 54055 | 21671 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-28 04:23:01 | Mercer, West Virginia, US | |
2772465 | 2772465 | 2022-09-26 | US | West Virginia | Mercer | 54055 | 21659 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-27 04:23:01 | Mercer, West Virginia, US | |
1980118 | 1980118 | 2022-09-25 | US | West Virginia | Mercer | 54055 | 21601 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-26 04:20:52 | Mercer, West Virginia, US | |
2653285 | 2653285 | 2022-09-24 | US | West Virginia | Mercer | 54055 | 21601 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-25 04:23:31 | Mercer, West Virginia, US | |
387725 | 387725 | 2022-09-23 | US | West Virginia | Mercer | 54055 | 21601 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-24 04:21:40 | Mercer, West Virginia, US | |
1627791 | 1627791 | 2022-09-22 | US | West Virginia | Mercer | 54055 | 21567 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-23 04:23:13 | Mercer, West Virginia, US | |
1373995 | 1373995 | 2022-09-21 | US | West Virginia | Mercer | 54055 | 21528 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-22 04:22:56 | Mercer, West Virginia, US | |
2020225 | 2020225 | 2022-09-20 | US | West Virginia | Mercer | 54055 | 21502 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-21 04:23:22 | Mercer, West Virginia, US | |
3574098 | 3574098 | 2022-09-19 | US | West Virginia | Mercer | 54055 | 21478 | 280 | 0 | 37.40481169 | -81.11023142 | 2022-09-20 04:22:48 | Mercer, West Virginia, US | |
74601 | 74601 | 2022-02-07 | US | West Virginia | Raleigh | 54081 | 21002 | 280 | 0 | 37.76936795 | -81.2456041 | 2022-02-08 04:21:15 | Raleigh, West Virginia, US | |
1017809 | 1017809 | 2021-11-21 | US | West Virginia | Cabell | 54011 | 15730 | 280 | 0 | 38.42424062 | -82.23855912 | 2021-11-22 04:22:20 | Cabell, West Virginia, US | |
725973 | 725973 | 2021-11-20 | US | West Virginia | Cabell | 54011 | 15716 | 280 | 0 | 38.42424062 | -82.23855912 | 2021-11-21 04:22:13 | Cabell, West Virginia, US | |
165503 | 165503 | 2021-11-19 | US | West Virginia | Cabell | 54011 | 15671 | 280 | 0 | 38.42424062 | -82.23855912 | 2021-11-20 04:22:17 | Cabell, West Virginia, US | |
1939930 | 1939930 | 2021-02-23 | US | West Virginia | Kanawha | 54039 | 11920 | 280 | 0 | 11640 | 38.33860077 | -81.52857054 | 2021-02-24 05:29:16 | Kanawha, West Virginia, US |
534185 | 534185 | 2021-02-22 | US | West Virginia | Kanawha | 54039 | 11891 | 280 | 0 | 11611 | 38.33860077 | -81.52857054 | 2021-02-23 05:23:41 | 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]);