johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where country_or_region = "US", deaths = 158 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2338892 | 2338892 | 2022-07-27 | US | West Virginia | Marshall | 54051 | 9906 | 158 | 0 | 39.86064362 | -80.66591062 | 2022-07-28 04:20:56 | Marshall, West Virginia, US | |
1491082 | 1491082 | 2022-07-26 | US | West Virginia | Marshall | 54051 | 9885 | 158 | 0 | 39.86064362 | -80.66591062 | 2022-07-27 04:21:04 | Marshall, West Virginia, US | |
974419 | 974419 | 2022-06-01 | US | West Virginia | Mineral | 54057 | 8215 | 158 | 0 | 39.41561583 | -78.94104895 | 2022-06-02 05:20:39 | Mineral, West Virginia, US | |
2310769 | 2310769 | 2022-04-20 | US | West Virginia | Greenbrier | 54025 | 9529 | 158 | 0 | 37.9463652 | -80.45335881 | 2022-04-21 04:20:46 | Greenbrier, West Virginia, US | |
2254908 | 2254908 | 2022-04-19 | US | West Virginia | Greenbrier | 54025 | 9524 | 158 | 0 | 37.9463652 | -80.45335881 | 2022-04-20 04:20:45 | Greenbrier, West Virginia, US | |
1849458 | 1849458 | 2022-04-18 | US | West Virginia | Greenbrier | 54025 | 9518 | 158 | 0 | 37.9463652 | -80.45335881 | 2022-04-19 04:21:00 | Greenbrier, West Virginia, US | |
2267396 | 2267396 | 2022-03-14 | US | West Virginia | Ohio | 54069 | 10991 | 158 | 0 | 40.0955451 | -80.62203992 | 2022-03-15 04:20:47 | Ohio, West Virginia, US | |
3631462 | 3631462 | 2022-03-13 | US | West Virginia | Ohio | 54069 | 10991 | 158 | 0 | 40.0955451 | -80.62203992 | 2022-03-14 04:20:46 | Ohio, West Virginia, US | |
954370 | 954370 | 2022-03-12 | US | West Virginia | Ohio | 54069 | 10991 | 158 | 0 | 40.0955451 | -80.62203992 | 2022-03-13 04:20:49 | Ohio, West Virginia, US | |
359831 | 359831 | 2022-03-11 | US | West Virginia | Ohio | 54069 | 10991 | 158 | 0 | 40.0955451 | -80.62203992 | 2022-03-12 04:20:50 | Ohio, West Virginia, US | |
1868983 | 1868983 | 2022-03-10 | US | West Virginia | Ohio | 54069 | 10987 | 158 | 0 | 40.0955451 | -80.62203992 | 2022-03-11 04:20:50 | Ohio, West Virginia, US | |
3721679 | 3721679 | 2022-02-21 | US | West Virginia | Marion | 54049 | 14361 | 158 | 0 | 39.50984542 | -80.24244659 | 2022-02-22 04:21:01 | Marion, West Virginia, US | |
1301546 | 1301546 | 2022-02-17 | US | West Virginia | Marion | 54049 | 14228 | 158 | 0 | 39.50984542 | -80.24244659 | 2022-02-18 04:21:04 | Marion, West Virginia, US | |
462859 | 462859 | 2022-02-02 | US | West Virginia | Fayette | 54019 | 11369 | 158 | 0 | 38.02974928 | -81.08286634 | 2022-02-03 04:21:21 | Fayette, West Virginia, US | |
982428 | 982428 | 2022-02-01 | US | West Virginia | Fayette | 54019 | 11290 | 158 | 0 | 38.02974928 | -81.08286634 | 2022-02-02 04:21:09 | Fayette, West Virginia, US | |
2661270 | 2661270 | 2022-01-31 | US | West Virginia | Fayette | 54019 | 11214 | 158 | 0 | 38.02974928 | -81.08286634 | 2022-02-01 04:21:11 | Fayette, West Virginia, US | |
3303687 | 3303687 | 2022-01-30 | US | West Virginia | Fayette | 54019 | 11119 | 158 | 0 | 38.02974928 | -81.08286634 | 2022-01-31 04:21:09 | Fayette, West Virginia, US | |
3065478 | 3065478 | 2022-01-29 | US | West Virginia | Fayette | 54019 | 10884 | 158 | 0 | 38.02974928 | -81.08286634 | 2022-01-30 04:21:26 | Fayette, West Virginia, US | |
3813412 | 3813412 | 2022-01-28 | US | West Virginia | Fayette | 54019 | 10769 | 158 | 0 | 38.02974928 | -81.08286634 | 2022-01-29 04:21:10 | Fayette, West Virginia, US | |
1782879 | 1782879 | 2022-01-27 | US | West Virginia | Logan | 54045 | 8171 | 158 | 0 | 37.8299889 | -81.93528571 | 2022-01-28 04:21:09 | Logan, West Virginia, US | |
1289506 | 1289506 | 2022-01-04 | US | West Virginia | Monongalia | 54061 | 16345 | 158 | 0 | 39.63218457 | -80.04766838 | 2022-01-05 04:21:59 | Monongalia, West Virginia, US | |
1703850 | 1703850 | 2022-01-03 | US | West Virginia | Monongalia | 54061 | 16266 | 158 | 0 | 39.63218457 | -80.04766838 | 2022-01-04 04:22:17 | Monongalia, West Virginia, US | |
3522933 | 3522933 | 2022-01-02 | US | West Virginia | Monongalia | 54061 | 15710 | 158 | 0 | 39.63218457 | -80.04766838 | 2022-01-03 02:22:25 | Monongalia, West Virginia, US | |
2171063 | 2171063 | 2022-01-01 | US | West Virginia | Monongalia | 54061 | 15710 | 158 | 0 | 39.63218457 | -80.04766838 | 2022-01-02 04:20:52 | Monongalia, West Virginia, US | |
2780494 | 2780494 | 2021-12-31 | US | West Virginia | Monongalia | 54061 | 15710 | 158 | 0 | 39.63218457 | -80.04766838 | 2022-01-01 04:22:14 | Monongalia, West Virginia, US | |
4002151 | 4002151 | 2021-12-30 | US | West Virginia | Monongalia | 54061 | 15710 | 158 | 0 | 39.63218457 | -80.04766838 | 2021-12-31 04:21:50 | Monongalia, West Virginia, US | |
1671958 | 1671958 | 2021-12-29 | US | West Virginia | Monongalia | 54061 | 15534 | 158 | 0 | 39.63218457 | -80.04766838 | 2021-12-30 04:21:25 | Monongalia, West Virginia, US | |
637433 | 637433 | 2021-10-13 | US | West Virginia | Raleigh | 54081 | 10769 | 158 | 0 | 37.76936795 | -81.2456041 | 2021-10-14 04:21:29 | Raleigh, West Virginia, US | |
1495111 | 1495111 | 2021-10-12 | US | West Virginia | Raleigh | 54081 | 10719 | 158 | 0 | 37.76936795 | -81.2456041 | 2021-10-13 04:20:51 | Raleigh, West Virginia, US | |
3010844 | 3010844 | 2021-10-11 | US | West Virginia | Raleigh | 54081 | 10687 | 158 | 0 | 37.76936795 | -81.2456041 | 2021-10-12 04:21:09 | Raleigh, West Virginia, US | |
1277758 | 1277758 | 2021-10-03 | US | West Virginia | Berkeley | 54003 | 16963 | 158 | 0 | 39.46704621 | -78.02414609 | 2021-10-04 04:21:31 | Berkeley, West Virginia, US | |
3931511 | 3931511 | 2021-10-02 | US | West Virginia | Berkeley | 54003 | 16887 | 158 | 0 | 39.46704621 | -78.02414609 | 2021-10-03 04:21:24 | Berkeley, West Virginia, US | |
2135491 | 2135491 | 2021-10-01 | US | West Virginia | Berkeley | 54003 | 16777 | 158 | 0 | 39.46704621 | -78.02414609 | 2021-10-02 04:21:25 | Berkeley, West Virginia, US | |
2776448 | 2776448 | 2021-09-30 | US | West Virginia | Berkeley | 54003 | 16695 | 158 | 0 | 39.46704621 | -78.02414609 | 2021-10-01 04:21:35 | Berkeley, West Virginia, US | |
474877 | 474877 | 2021-02-19 | US | West Virginia | Cabell | 54011 | 7646 | 158 | 0 | 7488 | 38.42424062 | -82.23855912 | 2021-02-20 05:22:51 | Cabell, West Virginia, US |
1156586 | 1156586 | 2021-02-18 | US | West Virginia | Cabell | 54011 | 7655 | 158 | 0 | 7497 | 38.42424062 | -82.23855912 | 2021-02-19 05:24:16 | Cabell, West Virginia, US |
3604506 | 3604506 | 2021-02-17 | US | West Virginia | Cabell | 54011 | 7591 | 158 | 0 | 7433 | 38.42424062 | -82.23855912 | 2021-02-18 05:22:58 | Cabell, West Virginia, US |
3053641 | 3053641 | 2021-02-16 | US | West Virginia | Cabell | 54011 | 7545 | 158 | 0 | 7387 | 38.42424062 | -82.23855912 | 2021-02-17 05:23:10 | Cabell, West Virginia, US |
1341740 | 1341740 | 2021-02-15 | US | West Virginia | Cabell | 54011 | 7529 | 158 | 0 | 7371 | 38.42424062 | -82.23855912 | 2021-02-16 05:24:38 | Cabell, West Virginia, US |
2286891 | 2286891 | 2021-02-14 | US | West Virginia | Cabell | 54011 | 7517 | 158 | 0 | 7359 | 38.42424062 | -82.23855912 | 2021-02-15 05:24:49 | Cabell, West Virginia, US |
1822265 | 1822265 | 2020-12-08 | US | West Virginia | Kanawha | 54039 | 6478 | 158 | 0 | 6320 | 38.33860077 | -81.52857054 | 2020-12-09 05:28:01 | 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]);