johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where country_or_region = "US", deaths = 169 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
256797 | 256797 | 2022-09-08 | US | West Virginia | Greenbrier | 54025 | 11597 | 169 | 0 | 37.9463652 | -80.45335881 | 2022-09-09 04:21:11 | Greenbrier, West Virginia, US | |
3748595 | 3748595 | 2022-09-07 | US | West Virginia | Greenbrier | 54025 | 11572 | 169 | 0 | 37.9463652 | -80.45335881 | 2022-09-08 04:21:02 | Greenbrier, West Virginia, US | |
118235 | 118235 | 2022-09-06 | US | West Virginia | Greenbrier | 54025 | 11546 | 169 | 0 | 37.9463652 | -80.45335881 | 2022-09-07 04:20:59 | Greenbrier, West Virginia, US | |
1853497 | 1853497 | 2022-05-26 | US | West Virginia | Ohio | 54069 | 11558 | 169 | 0 | 40.0955451 | -80.62203992 | 2022-05-27 04:20:56 | Ohio, West Virginia, US | |
2051373 | 2051373 | 2022-05-25 | US | West Virginia | Ohio | 54069 | 11521 | 169 | 0 | 40.0955451 | -80.62203992 | 2022-05-26 04:20:50 | Ohio, West Virginia, US | |
3002811 | 3002811 | 2022-05-24 | US | West Virginia | Ohio | 54069 | 11510 | 169 | 0 | 40.0955451 | -80.62203992 | 2022-05-25 04:20:56 | Ohio, West Virginia, US | |
625384 | 625384 | 2022-05-22 | US | West Virginia | Ohio | 54069 | 11521 | 169 | 0 | 40.0955451 | -80.62203992 | 2022-05-26 04:20:50 | Ohio, West Virginia, US | |
2143667 | 2143667 | 2022-03-09 | US | West Virginia | Marion | 54049 | 14782 | 169 | 0 | 39.50984542 | -80.24244659 | 2022-03-10 04:20:48 | Marion, West Virginia, US | |
1647855 | 1647855 | 2022-03-03 | US | West Virginia | Logan | 54045 | 9492 | 169 | 0 | 37.8299889 | -81.93528571 | 2022-03-04 04:21:09 | Logan, West Virginia, US | |
2528858 | 2528858 | 2022-03-02 | US | West Virginia | Logan | 54045 | 9478 | 169 | 0 | 37.8299889 | -81.93528571 | 2022-03-03 04:21:01 | Logan, West Virginia, US | |
2528875 | 2528875 | 2022-03-02 | US | West Virginia | Putnam | 54079 | 16446 | 169 | 0 | 38.50782345 | -81.9082131 | 2022-03-03 04:21:01 | Putnam, West Virginia, US | |
1996169 | 1996169 | 2022-03-01 | US | West Virginia | Putnam | 54079 | 16443 | 169 | 0 | 38.50782345 | -81.9082131 | 2022-03-02 04:21:07 | Putnam, West Virginia, US | |
1301532 | 1301532 | 2022-02-17 | US | West Virginia | Fayette | 54019 | 12471 | 169 | 0 | 38.02974928 | -81.08286634 | 2022-02-18 04:21:04 | Fayette, West Virginia, US | |
3823918 | 3823918 | 2022-02-16 | US | West Virginia | Fayette | 54019 | 12441 | 169 | 0 | 38.02974928 | -81.08286634 | 2022-02-17 04:20:56 | Fayette, West Virginia, US | |
3675132 | 3675132 | 2022-02-15 | US | West Virginia | Fayette | 54019 | 12424 | 169 | 0 | 38.02974928 | -81.08286634 | 2022-02-16 04:21:10 | Fayette, West Virginia, US | |
3303708 | 3303708 | 2022-01-30 | US | West Virginia | Monongalia | 54061 | 22392 | 169 | 0 | 39.63218457 | -80.04766838 | 2022-01-31 04:21:09 | Monongalia, West Virginia, US | |
3065499 | 3065499 | 2022-01-29 | US | West Virginia | Monongalia | 54061 | 22251 | 169 | 0 | 39.63218457 | -80.04766838 | 2022-01-30 04:21:26 | Monongalia, West Virginia, US | |
3813433 | 3813433 | 2022-01-28 | US | West Virginia | Monongalia | 54061 | 22061 | 169 | 0 | 39.63218457 | -80.04766838 | 2022-01-29 04:21:10 | Monongalia, West Virginia, US | |
3797404 | 3797404 | 2021-10-25 | US | West Virginia | Raleigh | 54081 | 11295 | 169 | 0 | 37.76936795 | -81.2456041 | 2021-10-26 04:22:09 | Raleigh, West Virginia, US | |
495106 | 495106 | 2021-10-14 | US | West Virginia | Berkeley | 54003 | 17721 | 169 | 0 | 39.46704621 | -78.02414609 | 2021-10-15 04:21:26 | Berkeley, West Virginia, US | |
1876472 | 1876472 | 2021-05-15 | US | West Virginia | Wood | 54107 | 7802 | 169 | 0 | 39.20967886 | -81.5162836 | 2021-05-16 04:20:49 | Wood, West Virginia, US | |
1085441 | 1085441 | 2021-05-14 | US | West Virginia | Wood | 54107 | 7796 | 169 | 0 | 39.20967886 | -81.5162836 | 2021-05-15 04:20:58 | Wood, West Virginia, US | |
3057707 | 3057707 | 2021-05-13 | US | West Virginia | Wood | 54107 | 7788 | 169 | 0 | 39.20967886 | -81.5162836 | 2021-05-14 04:20:41 | Wood, West Virginia, US | |
2008177 | 2008177 | 2021-05-12 | US | West Virginia | Wood | 54107 | 7767 | 169 | 0 | 39.20967886 | -81.5162836 | 2021-05-13 04:20:51 | Wood, West Virginia, US | |
1639783 | 1639783 | 2021-04-29 | US | West Virginia | Cabell | 54011 | 8572 | 169 | 0 | 38.42424062 | -82.23855912 | 2021-04-30 04:21:03 | Cabell, West Virginia, US | |
3396862 | 3396862 | 2021-04-28 | US | West Virginia | Cabell | 54011 | 8557 | 169 | 0 | 38.42424062 | -82.23855912 | 2021-04-29 04:20:55 | Cabell, West Virginia, US | |
3705578 | 3705578 | 2021-04-27 | US | West Virginia | Cabell | 54011 | 8544 | 169 | 0 | 38.42424062 | -82.23855912 | 2021-04-28 04:20:32 | Cabell, West Virginia, US | |
705870 | 705870 | 2021-03-16 | US | West Virginia | Cabell | 54011 | 8099 | 169 | 0 | 38.42424062 | -82.23855912 | 2021-03-17 05:25:07 | Cabell, 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]);