johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
70 rows where deaths = 147 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2020212 | 2020212 | 2022-09-20 | US | West Virginia | Hancock | 54029 | 7853 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-21 04:23:22 | Hancock, West Virginia, US | |
3574085 | 3574085 | 2022-09-19 | US | West Virginia | Hancock | 54029 | 7846 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-20 04:22:48 | Hancock, West Virginia, US | |
422824 | 422824 | 2022-09-18 | US | West Virginia | Hancock | 54029 | 7836 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-19 04:21:49 | Hancock, West Virginia, US | |
3376848 | 3376848 | 2022-09-17 | US | West Virginia | Hancock | 54029 | 7836 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-18 04:22:50 | Hancock, West Virginia, US | |
2358956 | 2358956 | 2022-09-16 | US | West Virginia | Hancock | 54029 | 7836 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-17 04:20:19 | Hancock, West Virginia, US | |
3990113 | 3990113 | 2022-09-15 | US | West Virginia | Hancock | 54029 | 7826 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-16 04:21:19 | Hancock, West Virginia, US | |
1892630 | 1892630 | 2022-09-14 | US | West Virginia | Hancock | 54029 | 7824 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-15 04:21:02 | Hancock, West Virginia, US | |
375685 | 375685 | 2022-09-13 | US | West Virginia | Hancock | 54029 | 7814 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-14 04:20:44 | Hancock, West Virginia, US | |
2398287 | 2398287 | 2022-09-12 | US | West Virginia | Hancock | 54029 | 7800 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-13 04:20:57 | Hancock, West Virginia, US | |
3769365 | 3769365 | 2022-09-11 | US | West Virginia | Hancock | 54029 | 7771 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-12 04:20:58 | Hancock, West Virginia, US | |
3827940 | 3827940 | 2022-09-10 | US | West Virginia | Hancock | 54029 | 7771 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-11 04:20:50 | Hancock, West Virginia, US | |
966397 | 966397 | 2022-09-09 | US | West Virginia | Hancock | 54029 | 7771 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-10 04:21:10 | Hancock, West Virginia, US | |
256799 | 256799 | 2022-09-08 | US | West Virginia | Hancock | 54029 | 7751 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-09 04:21:11 | Hancock, West Virginia, US | |
3748597 | 3748597 | 2022-09-07 | US | West Virginia | Hancock | 54029 | 7733 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-08 04:21:02 | Hancock, West Virginia, US | |
118237 | 118237 | 2022-09-06 | US | West Virginia | Hancock | 54029 | 7719 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-07 04:20:59 | Hancock, West Virginia, US | |
2637209 | 2637209 | 2022-09-05 | US | West Virginia | Hancock | 54029 | 7681 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-06 04:21:02 | Hancock, West Virginia, US | |
2990773 | 2990773 | 2022-09-04 | US | West Virginia | Hancock | 54029 | 7681 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-05 04:21:01 | Hancock, West Virginia, US | |
2716458 | 2716458 | 2022-09-03 | US | West Virginia | Hancock | 54029 | 7681 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-04 04:21:22 | Hancock, West Virginia, US | |
1397163 | 1397163 | 2022-09-02 | US | West Virginia | Hancock | 54029 | 7681 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-03 04:21:04 | Hancock, West Virginia, US | |
2143656 | 2143656 | 2022-03-09 | US | West Virginia | Greenbrier | 54025 | 9373 | 147 | 0 | 37.9463652 | -80.45335881 | 2022-03-10 04:20:48 | Greenbrier, West Virginia, US | |
3823943 | 3823943 | 2022-02-16 | US | West Virginia | Ohio | 54069 | 10799 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-17 04:20:56 | Ohio, West Virginia, US | |
3675147 | 3675147 | 2022-02-15 | US | West Virginia | Marshall | 54051 | 8498 | 147 | 0 | 39.86064362 | -80.66591062 | 2022-02-16 04:21:10 | Marshall, West Virginia, US | |
3675157 | 3675157 | 2022-02-15 | US | West Virginia | Ohio | 54069 | 10785 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-16 04:21:10 | Ohio, West Virginia, US | |
2645258 | 2645258 | 2022-02-14 | US | West Virginia | Ohio | 54069 | 10786 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-15 04:21:09 | Ohio, West Virginia, US | |
189575 | 189575 | 2022-02-13 | US | West Virginia | Ohio | 54069 | 10784 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-14 04:20:51 | Ohio, West Virginia, US | |
319421 | 319421 | 2022-02-12 | US | West Virginia | Ohio | 54069 | 10763 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-13 04:21:00 | Ohio, West Virginia, US | |
236747 | 236747 | 2022-02-11 | US | West Virginia | Ohio | 54069 | 10751 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-12 04:21:06 | Ohio, West Virginia, US | |
1467589 | 1467589 | 2022-02-10 | US | West Virginia | Ohio | 54069 | 10728 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-11 04:21:09 | Ohio, West Virginia, US | |
3077550 | 3077550 | 2022-02-09 | US | West Virginia | Ohio | 54069 | 10677 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-10 04:21:14 | Ohio, West Virginia, US | |
1365857 | 1365857 | 2022-02-08 | US | West Virginia | Ohio | 54069 | 10635 | 147 | 0 | 40.0955451 | -80.62203992 | 2022-02-09 04:21:04 | Ohio, West Virginia, US | |
2016205 | 2016205 | 2022-02-06 | US | West Virginia | Mineral | 54057 | 7440 | 147 | 0 | 39.41561583 | -78.94104895 | 2022-02-07 04:21:05 | Mineral, West Virginia, US | |
1297534 | 1297534 | 2022-02-05 | US | West Virginia | Mineral | 54057 | 7417 | 147 | 0 | 39.41561583 | -78.94104895 | 2022-02-06 04:21:00 | Mineral, West Virginia, US | |
2330862 | 2330862 | 2022-02-04 | US | West Virginia | Mineral | 54057 | 7356 | 147 | 0 | 39.41561583 | -78.94104895 | 2022-02-05 04:21:05 | Mineral, West Virginia, US | |
2477453 | 2477453 | 2022-02-03 | US | West Virginia | Mineral | 54057 | 7333 | 147 | 0 | 39.41561583 | -78.94104895 | 2022-02-04 04:21:10 | Mineral, West Virginia, US | |
462878 | 462878 | 2022-02-02 | US | West Virginia | Mineral | 54057 | 7294 | 147 | 0 | 39.41561583 | -78.94104895 | 2022-02-03 04:21:21 | Mineral, West Virginia, US | |
1117099 | 1117099 | 2022-01-11 | US | West Virginia | Putnam | 54079 | 11786 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-12 04:21:44 | Putnam, West Virginia, US | |
1695827 | 1695827 | 2022-01-10 | US | West Virginia | Putnam | 54079 | 11718 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-11 04:22:01 | Putnam, West Virginia, US | |
130242 | 130242 | 2022-01-09 | US | West Virginia | Putnam | 54079 | 11654 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-10 04:22:07 | Putnam, West Virginia, US | |
1219077 | 1219077 | 2022-01-08 | US | West Virginia | Putnam | 54079 | 11603 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-09 04:21:46 | Putnam, West Virginia, US | |
1393170 | 1393170 | 2022-01-07 | US | West Virginia | Putnam | 54079 | 11455 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-08 04:21:53 | Putnam, West Virginia, US | |
2613557 | 2613557 | 2022-01-06 | US | West Virginia | Putnam | 54079 | 11264 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-07 04:22:09 | Putnam, West Virginia, US | |
1285499 | 1285499 | 2022-01-05 | US | West Virginia | Putnam | 54079 | 11121 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-06 04:22:09 | Putnam, West Virginia, US | |
1289515 | 1289515 | 2022-01-04 | US | West Virginia | Putnam | 54079 | 11030 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-05 04:21:59 | Putnam, West Virginia, US | |
1703859 | 1703859 | 2022-01-03 | US | West Virginia | Putnam | 54079 | 10972 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-04 04:22:17 | Putnam, West Virginia, US | |
3522942 | 3522942 | 2022-01-02 | US | West Virginia | Putnam | 54079 | 10690 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-03 02:22:25 | Putnam, West Virginia, US | |
2171072 | 2171072 | 2022-01-01 | US | West Virginia | Putnam | 54079 | 10690 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-02 04:20:52 | Putnam, West Virginia, US | |
2780503 | 2780503 | 2021-12-31 | US | West Virginia | Putnam | 54079 | 10690 | 147 | 0 | 38.50782345 | -81.9082131 | 2022-01-01 04:22:14 | Putnam, West Virginia, US | |
4002160 | 4002160 | 2021-12-30 | US | West Virginia | Putnam | 54079 | 10690 | 147 | 0 | 38.50782345 | -81.9082131 | 2021-12-31 04:21:50 | Putnam, West Virginia, US | |
734007 | 734007 | 2021-12-27 | US | West Virginia | Fayette | 54019 | 7573 | 147 | 0 | 38.02974928 | -81.08286634 | 2021-12-28 04:21:47 | Fayette, West Virginia, US | |
2115179 | 2115179 | 2021-12-26 | US | West Virginia | Fayette | 54019 | 7502 | 147 | 0 | 38.02974928 | -81.08286634 | 2021-12-27 04:21:58 | Fayette, West Virginia, US | |
3608551 | 3608551 | 2021-12-25 | US | West Virginia | Fayette | 54019 | 7502 | 147 | 0 | 38.02974928 | -81.08286634 | 2021-12-26 04:21:50 | Fayette, West Virginia, US | |
2966869 | 2966869 | 2021-12-24 | US | West Virginia | Fayette | 54019 | 7502 | 147 | 0 | 38.02974928 | -81.08286634 | 2021-12-25 04:21:37 | Fayette, West Virginia, US | |
3819901 | 3819901 | 2021-12-23 | US | West Virginia | Fayette | 54019 | 7502 | 147 | 0 | 38.02974928 | -81.08286634 | 2021-12-24 04:21:34 | Fayette, West Virginia, US | |
801909 | 801909 | 2021-12-22 | US | West Virginia | Fayette | 54019 | 7466 | 147 | 0 | 38.02974928 | -81.08286634 | 2021-12-23 04:21:21 | Fayette, West Virginia, US | |
1148429 | 1148429 | 2021-12-01 | US | West Virginia | Monongalia | 54061 | 14391 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-12-02 04:22:37 | Monongalia, West Virginia, US | |
3404941 | 3404941 | 2021-11-30 | US | West Virginia | Monongalia | 54061 | 14345 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-12-01 04:22:29 | Monongalia, West Virginia, US | |
1235130 | 1235130 | 2021-11-28 | US | West Virginia | Monongalia | 54061 | 14213 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-29 04:22:30 | Monongalia, West Virginia, US | |
1361837 | 1361837 | 2021-11-27 | US | West Virginia | Monongalia | 54061 | 14213 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-28 04:22:43 | Monongalia, West Virginia, US | |
761828 | 761828 | 2021-11-26 | US | West Virginia | Monongalia | 54061 | 14213 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-27 04:22:45 | Monongalia, West Virginia, US | |
1806245 | 1806245 | 2021-11-25 | US | West Virginia | Monongalia | 54061 | 14213 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-26 04:22:33 | Monongalia, West Virginia, US | |
907679 | 907679 | 2021-11-24 | US | West Virginia | Monongalia | 54061 | 14213 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-25 04:22:33 | Monongalia, West Virginia, US | |
3073529 | 3073529 | 2021-11-23 | US | West Virginia | Monongalia | 54061 | 14195 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-24 04:22:14 | Monongalia, West Virginia, US | |
3752627 | 3752627 | 2021-11-22 | US | West Virginia | Monongalia | 54061 | 14166 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-23 04:22:39 | Monongalia, West Virginia, US | |
1017834 | 1017834 | 2021-11-21 | US | West Virginia | Monongalia | 54061 | 14151 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-22 04:22:20 | Monongalia, West Virginia, US | |
725998 | 725998 | 2021-11-20 | US | West Virginia | Monongalia | 54061 | 14124 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-21 04:22:13 | Monongalia, West Virginia, US | |
165528 | 165528 | 2021-11-19 | US | West Virginia | Monongalia | 54061 | 14083 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-20 04:22:17 | Monongalia, West Virginia, US | |
3292415 | 3292415 | 2021-11-18 | US | West Virginia | Monongalia | 54061 | 14059 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-19 04:21:40 | Monongalia, West Virginia, US | |
450871 | 450871 | 2021-11-17 | US | West Virginia | Monongalia | 54061 | 14022 | 147 | 0 | 39.63218457 | -80.04766838 | 2021-11-18 04:21:33 | Monongalia, West Virginia, US | |
343740 | 343740 | 2021-02-03 | US | West Virginia | Cabell | 54011 | 7201 | 147 | 0 | 7054 | 38.42424062 | -82.23855912 | 2021-02-04 05:22:26 | Cabell, West Virginia, US |
1587641 | 1587641 | 2020-11-30 | US | West Virginia | Kanawha | 54039 | 5713 | 147 | 0 | 5566 | 38.33860077 | -81.52857054 | 2020-12-01 05:26:18 | 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]);