johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where deaths = 167 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2326832 | 2326832 | 2022-08-24 | US | West Virginia | Greenbrier | 54025 | 11294 | 167 | 0 | 37.9463652 | -80.45335881 | 2022-08-25 04:21:13 | Greenbrier, West Virginia, US | |
1254241 | 1254241 | 2022-08-23 | US | West Virginia | Greenbrier | 54025 | 11278 | 167 | 0 | 37.9463652 | -80.45335881 | 2022-08-24 04:20:46 | Greenbrier, West Virginia, US | |
1507105 | 1507105 | 2022-05-16 | US | West Virginia | Ohio | 54069 | 11374 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-17 04:20:59 | Ohio, West Virginia, US | |
2087464 | 2087464 | 2022-05-15 | US | West Virginia | Ohio | 54069 | 11335 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-16 04:20:47 | Ohio, West Virginia, US | |
3358174 | 3358174 | 2022-05-14 | US | West Virginia | Ohio | 54069 | 11335 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-15 04:20:53 | Ohio, West Virginia, US | |
661819 | 661819 | 2022-05-13 | US | West Virginia | Ohio | 54069 | 11335 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-14 04:20:48 | Ohio, West Virginia, US | |
2536902 | 2536902 | 2022-05-12 | US | West Virginia | Ohio | 54069 | 11321 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-13 04:20:51 | Ohio, West Virginia, US | |
3448348 | 3448348 | 2022-05-11 | US | West Virginia | Ohio | 54069 | 11297 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-12 04:20:54 | Ohio, West Virginia, US | |
3538965 | 3538965 | 2022-05-10 | US | West Virginia | Ohio | 54069 | 11263 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-11 04:20:48 | Ohio, West Virginia, US | |
225500 | 225500 | 2022-05-09 | US | West Virginia | Ohio | 54069 | 11263 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-10 04:20:50 | Ohio, West Virginia, US | |
2334885 | 2334885 | 2022-05-08 | US | West Virginia | Ohio | 54069 | 11240 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-09 04:20:54 | Ohio, West Virginia, US | |
363847 | 363847 | 2022-05-07 | US | West Virginia | Ohio | 54069 | 11240 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-08 04:20:49 | Ohio, West Virginia, US | |
1401198 | 1401198 | 2022-05-06 | US | West Virginia | Ohio | 54069 | 11240 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-07 04:21:09 | Ohio, West Virginia, US | |
2601553 | 2601553 | 2022-05-05 | US | West Virginia | Ohio | 54069 | 11225 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-06 04:21:00 | Ohio, West Virginia, US | |
3269002 | 3269002 | 2022-05-04 | US | West Virginia | Ohio | 54069 | 11200 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-05 04:20:55 | Ohio, West Virginia, US | |
1575641 | 1575641 | 2022-05-03 | US | West Virginia | Ohio | 54069 | 11186 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-04 04:20:59 | Ohio, West Virginia, US | |
466901 | 466901 | 2022-05-02 | US | West Virginia | Ohio | 54069 | 11180 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-03 04:21:00 | Ohio, West Virginia, US | |
3919540 | 3919540 | 2022-05-01 | US | West Virginia | Ohio | 54069 | 11156 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-02 04:21:10 | Ohio, West Virginia, US | |
2844344 | 2844344 | 2022-04-30 | US | West Virginia | Ohio | 54069 | 11156 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-05-01 04:20:57 | Ohio, West Virginia, US | |
1160657 | 1160657 | 2022-04-29 | US | West Virginia | Ohio | 54069 | 11156 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-04-30 04:21:05 | Ohio, West Virginia, US | |
1699839 | 1699839 | 2022-04-28 | US | West Virginia | Ohio | 54069 | 11149 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-04-29 04:20:59 | Ohio, West Virginia, US | |
3855322 | 3855322 | 2022-04-27 | US | West Virginia | Ohio | 54069 | 11127 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-04-28 04:20:47 | Ohio, West Virginia, US | |
1440088 | 1440088 | 2022-03-28 | US | West Virginia | Ohio | 54069 | 11031 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-03-29 04:20:46 | Ohio, West Virginia, US | |
879769 | 879769 | 2022-03-27 | US | West Virginia | Ohio | 54069 | 11027 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-03-28 04:20:33 | Ohio, West Virginia, US | |
2167052 | 2167052 | 2022-03-26 | US | West Virginia | Ohio | 54069 | 11027 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-03-27 04:20:47 | Ohio, West Virginia, US | |
1723988 | 1723988 | 2022-03-25 | US | West Virginia | Ohio | 54069 | 11027 | 167 | 0 | 40.0955451 | -80.62203992 | 2022-03-26 04:20:23 | Ohio, West Virginia, US | |
923178 | 923178 | 2022-03-08 | US | West Virginia | Marion | 54049 | 14768 | 167 | 0 | 39.50984542 | -80.24244659 | 2022-03-09 04:20:59 | Marion, West Virginia, US | |
1551465 | 1551465 | 2022-03-07 | US | West Virginia | Marion | 54049 | 14753 | 167 | 0 | 39.50984542 | -80.24244659 | 2022-03-08 04:20:54 | Marion, West Virginia, US | |
1514901 | 1514901 | 2022-02-24 | US | West Virginia | Logan | 54045 | 9403 | 167 | 0 | 37.8299889 | -81.93528571 | 2022-02-25 04:21:11 | Logan, West Virginia, US | |
1061342 | 1061342 | 2022-02-23 | US | West Virginia | Logan | 54045 | 9379 | 167 | 0 | 37.8299889 | -81.93528571 | 2022-02-24 04:21:14 | Logan, West Virginia, US | |
1144413 | 1144413 | 2022-01-23 | US | West Virginia | Monongalia | 54061 | 21126 | 167 | 0 | 39.63218457 | -80.04766838 | 2022-01-24 04:21:12 | Monongalia, West Virginia, US | |
2836331 | 2836331 | 2022-01-22 | US | West Virginia | Monongalia | 54061 | 20832 | 167 | 0 | 39.63218457 | -80.04766838 | 2022-01-23 04:21:13 | Monongalia, West Virginia, US | |
3428449 | 3428449 | 2022-01-21 | US | West Virginia | Monongalia | 54061 | 20481 | 167 | 0 | 39.63218457 | -80.04766838 | 2022-01-22 04:21:13 | Monongalia, West Virginia, US | |
2127252 | 2127252 | 2021-10-21 | US | West Virginia | Raleigh | 54081 | 11123 | 167 | 0 | 37.76936795 | -81.2456041 | 2021-10-22 04:21:14 | Raleigh, West Virginia, US | |
637394 | 637394 | 2021-10-13 | US | West Virginia | Berkeley | 54003 | 17644 | 167 | 0 | 39.46704621 | -78.02414609 | 2021-10-14 04:21:29 | Berkeley, West Virginia, US | |
1495072 | 1495072 | 2021-10-12 | US | West Virginia | Berkeley | 54003 | 17574 | 167 | 0 | 39.46704621 | -78.02414609 | 2021-10-13 04:20:51 | Berkeley, West Virginia, US | |
3010805 | 3010805 | 2021-10-11 | US | West Virginia | Berkeley | 54003 | 17527 | 167 | 0 | 39.46704621 | -78.02414609 | 2021-10-12 04:21:09 | Berkeley, West Virginia, US | |
2024239 | 2024239 | 2021-04-20 | US | West Virginia | Wood | 54107 | 7580 | 167 | 0 | 39.20967886 | -81.5162836 | 2021-04-21 04:21:14 | Wood, West Virginia, US | |
173560 | 173560 | 2021-04-16 | US | West Virginia | Wood | 54107 | 7564 | 167 | 0 | 39.20967886 | -81.5162836 | 2021-04-17 04:20:40 | Wood, West Virginia, US | |
2552391 | 2552391 | 2021-04-15 | US | West Virginia | Wood | 54107 | 7554 | 167 | 0 | 39.20967886 | -81.5162836 | 2021-04-16 04:20:46 | Wood, West Virginia, US | |
1845461 | 1845461 | 2021-04-14 | US | West Virginia | Wood | 54107 | 7548 | 167 | 0 | 39.20967886 | -81.5162836 | 2021-04-15 04:20:54 | Wood, West Virginia, US | |
2059348 | 2059348 | 2021-03-15 | US | West Virginia | Cabell | 54011 | 8085 | 167 | 0 | 38.42424062 | -82.23855912 | 2021-03-16 05:25:13 | Cabell, West Virginia, US | |
1735960 | 1735960 | 2021-03-14 | US | West Virginia | Cabell | 54011 | 8076 | 167 | 0 | 38.42424062 | -82.23855912 | 2021-03-15 05:25:51 | Cabell, West Virginia, US | |
1583617 | 1583617 | 2021-03-13 | US | West Virginia | Cabell | 54011 | 8071 | 167 | 0 | 38.42424062 | -82.23855912 | 2021-03-14 05:25:37 | Cabell, West Virginia, US | |
1841396 | 1841396 | 2021-03-12 | US | West Virginia | Cabell | 54011 | 8055 | 167 | 0 | 38.42424062 | -82.23855912 | 2021-03-13 05:25:15 | Cabell, West Virginia, US | |
1754745 | 1754745 | 2020-12-14 | US | West Virginia | Kanawha | 54039 | 7099 | 167 | 0 | 6932 | 38.33860077 | -81.52857054 | 2020-12-15 05:26:38 | 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]);