johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where country_or_region = "US", deaths = 148 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2772452 | 2772452 | 2022-09-26 | US | West Virginia | Hancock | 54029 | 7881 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-27 04:23:01 | Hancock, West Virginia, US | |
1980105 | 1980105 | 2022-09-25 | US | West Virginia | Hancock | 54029 | 7870 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-26 04:20:52 | Hancock, West Virginia, US | |
2653272 | 2653272 | 2022-09-24 | US | West Virginia | Hancock | 54029 | 7870 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-25 04:23:31 | Hancock, West Virginia, US | |
387712 | 387712 | 2022-09-23 | US | West Virginia | Hancock | 54029 | 7870 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-24 04:21:40 | Hancock, West Virginia, US | |
1627778 | 1627778 | 2022-09-22 | US | West Virginia | Hancock | 54029 | 7866 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-23 04:23:13 | Hancock, West Virginia, US | |
1373982 | 1373982 | 2022-09-21 | US | West Virginia | Hancock | 54029 | 7860 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-22 04:22:56 | Hancock, West Virginia, US | |
2267374 | 2267374 | 2022-03-14 | US | West Virginia | Greenbrier | 54025 | 9406 | 148 | 0 | 37.9463652 | -80.45335881 | 2022-03-15 04:20:47 | Greenbrier, West Virginia, US | |
3631440 | 3631440 | 2022-03-13 | US | West Virginia | Greenbrier | 54025 | 9388 | 148 | 0 | 37.9463652 | -80.45335881 | 2022-03-14 04:20:46 | Greenbrier, West Virginia, US | |
954348 | 954348 | 2022-03-12 | US | West Virginia | Greenbrier | 54025 | 9388 | 148 | 0 | 37.9463652 | -80.45335881 | 2022-03-13 04:20:49 | Greenbrier, West Virginia, US | |
359809 | 359809 | 2022-03-11 | US | West Virginia | Greenbrier | 54025 | 9388 | 148 | 0 | 37.9463652 | -80.45335881 | 2022-03-12 04:20:50 | Greenbrier, West Virginia, US | |
1868961 | 1868961 | 2022-03-10 | US | West Virginia | Greenbrier | 54025 | 9383 | 148 | 0 | 37.9463652 | -80.45335881 | 2022-03-11 04:20:50 | Greenbrier, West Virginia, US | |
1061344 | 1061344 | 2022-02-23 | US | West Virginia | Marshall | 54051 | 8621 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-24 04:21:14 | Marshall, West Virginia, US | |
2450267 | 2450267 | 2022-02-22 | US | West Virginia | Marshall | 54051 | 8605 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-23 04:21:09 | Marshall, West Virginia, US | |
3721680 | 3721680 | 2022-02-21 | US | West Virginia | Marshall | 54051 | 8594 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-22 04:21:01 | Marshall, West Virginia, US | |
3915514 | 3915514 | 2022-02-20 | US | West Virginia | Marshall | 54051 | 8571 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-21 04:21:05 | Marshall, West Virginia, US | |
3915524 | 3915524 | 2022-02-20 | US | West Virginia | Ohio | 54069 | 10825 | 148 | 0 | 40.0955451 | -80.62203992 | 2022-02-21 04:21:05 | Ohio, West Virginia, US | |
3879072 | 3879072 | 2022-02-19 | US | West Virginia | Marshall | 54051 | 8571 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-20 04:21:00 | Marshall, West Virginia, US | |
3879082 | 3879082 | 2022-02-19 | US | West Virginia | Ohio | 54069 | 10825 | 148 | 0 | 40.0955451 | -80.62203992 | 2022-02-20 04:21:00 | Ohio, West Virginia, US | |
3859328 | 3859328 | 2022-02-18 | US | West Virginia | Marshall | 54051 | 8571 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-19 04:21:11 | Marshall, West Virginia, US | |
3859338 | 3859338 | 2022-02-18 | US | West Virginia | Ohio | 54069 | 10825 | 148 | 0 | 40.0955451 | -80.62203992 | 2022-02-19 04:21:11 | Ohio, West Virginia, US | |
1301547 | 1301547 | 2022-02-17 | US | West Virginia | Marshall | 54051 | 8534 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-18 04:21:04 | Marshall, West Virginia, US | |
1301557 | 1301557 | 2022-02-17 | US | West Virginia | Ohio | 54069 | 10817 | 148 | 0 | 40.0955451 | -80.62203992 | 2022-02-18 04:21:04 | Ohio, West Virginia, US | |
3823933 | 3823933 | 2022-02-16 | US | West Virginia | Marshall | 54051 | 8512 | 148 | 0 | 39.86064362 | -80.66591062 | 2022-02-17 04:20:56 | Marshall, West Virginia, US | |
1467583 | 1467583 | 2022-02-10 | US | West Virginia | Mineral | 54057 | 7536 | 148 | 0 | 39.41561583 | -78.94104895 | 2022-02-11 04:21:09 | Mineral, West Virginia, US | |
3077544 | 3077544 | 2022-02-09 | US | West Virginia | Mineral | 54057 | 7493 | 148 | 0 | 39.41561583 | -78.94104895 | 2022-02-10 04:21:14 | Mineral, West Virginia, US | |
1365851 | 1365851 | 2022-02-08 | US | West Virginia | Mineral | 54057 | 7474 | 148 | 0 | 39.41561583 | -78.94104895 | 2022-02-09 04:21:04 | Mineral, West Virginia, US | |
74589 | 74589 | 2022-02-07 | US | West Virginia | Mineral | 54057 | 7448 | 148 | 0 | 39.41561583 | -78.94104895 | 2022-02-08 04:21:15 | Mineral, West Virginia, US | |
1782880 | 1782880 | 2022-01-27 | US | West Virginia | Marion | 54049 | 12856 | 148 | 0 | 39.50984542 | -80.24244659 | 2022-01-28 04:21:09 | Marion, West Virginia, US | |
1475625 | 1475625 | 2022-01-17 | US | West Virginia | Putnam | 54079 | 12887 | 148 | 0 | 38.50782345 | -81.9082131 | 2022-01-18 04:21:04 | Putnam, West Virginia, US | |
558299 | 558299 | 2022-01-16 | US | West Virginia | Putnam | 54079 | 12782 | 148 | 0 | 38.50782345 | -81.9082131 | 2022-01-17 04:21:08 | Putnam, West Virginia, US | |
3844020 | 3844020 | 2022-01-15 | US | West Virginia | Putnam | 54079 | 12663 | 148 | 0 | 38.50782345 | -81.9082131 | 2022-01-16 04:21:12 | Putnam, West Virginia, US | |
102835 | 102835 | 2022-01-14 | US | West Virginia | Putnam | 54079 | 12419 | 148 | 0 | 38.50782345 | -81.9082131 | 2022-01-15 04:21:07 | Putnam, West Virginia, US | |
3690990 | 3690990 | 2022-01-13 | US | West Virginia | Putnam | 54079 | 12264 | 148 | 0 | 38.50782345 | -81.9082131 | 2022-01-14 04:21:54 | Putnam, West Virginia, US | |
3616574 | 3616574 | 2022-01-12 | US | West Virginia | Putnam | 54079 | 11943 | 148 | 0 | 38.50782345 | -81.9082131 | 2022-01-13 08:00:09 | Putnam, West Virginia, US | |
554266 | 554266 | 2021-12-08 | US | West Virginia | Logan | 54045 | 5871 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-09 04:22:49 | Logan, West Virginia, US | |
407786 | 407786 | 2021-12-07 | US | West Virginia | Logan | 54045 | 5860 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-08 04:22:46 | Logan, West Virginia, US | |
1033868 | 1033868 | 2021-12-06 | US | West Virginia | Logan | 54045 | 5845 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-07 04:22:34 | Logan, West Virginia, US | |
1744031 | 1744031 | 2021-12-05 | US | West Virginia | Logan | 54045 | 5834 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-06 04:22:34 | Logan, West Virginia, US | |
1744039 | 1744039 | 2021-12-05 | US | West Virginia | Monongalia | 54061 | 14561 | 148 | 0 | 39.63218457 | -80.04766838 | 2021-12-06 04:22:34 | Monongalia, West Virginia, US | |
141463 | 141463 | 2021-12-04 | US | West Virginia | Logan | 54045 | 5817 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-05 04:22:25 | Logan, West Virginia, US | |
141471 | 141471 | 2021-12-04 | US | West Virginia | Monongalia | 54061 | 14515 | 148 | 0 | 39.63218457 | -80.04766838 | 2021-12-05 04:22:25 | Monongalia, West Virginia, US | |
2199116 | 2199116 | 2021-12-03 | US | West Virginia | Logan | 54045 | 5799 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-04 04:22:18 | Logan, West Virginia, US | |
2199124 | 2199124 | 2021-12-03 | US | West Virginia | Monongalia | 54061 | 14474 | 148 | 0 | 39.63218457 | -80.04766838 | 2021-12-04 04:22:18 | Monongalia, West Virginia, US | |
3822 | 3822 | 2021-12-02 | US | West Virginia | Logan | 54045 | 5784 | 148 | 0 | 37.8299889 | -81.93528571 | 2021-12-03 04:23:05 | Logan, West Virginia, US | |
3830 | 3830 | 2021-12-02 | US | West Virginia | Monongalia | 54061 | 14439 | 148 | 0 | 39.63218457 | -80.04766838 | 2021-12-03 04:23:05 | Monongalia, West Virginia, US | |
2462301 | 2462301 | 2021-10-06 | US | West Virginia | Raleigh | 54081 | 10484 | 148 | 0 | 37.76936795 | -81.2456041 | 2021-10-07 04:21:36 | Raleigh, West Virginia, US | |
793848 | 793848 | 2021-02-04 | US | West Virginia | Cabell | 54011 | 7218 | 148 | 0 | 7070 | 38.42424062 | -82.23855912 | 2021-02-05 05:22:38 | Cabell, West Virginia, US |
78566 | 78566 | 2020-12-03 | US | West Virginia | Kanawha | 54039 | 5931 | 148 | 0 | 5783 | 38.33860077 | -81.52857054 | 2020-12-04 05:27:27 | Kanawha, West Virginia, US |
741778 | 741778 | 2020-12-02 | US | West Virginia | Kanawha | 54039 | 5862 | 148 | 0 | 5714 | 38.33860077 | -81.52857054 | 2020-12-03 05:28:22 | Kanawha, West Virginia, US |
2540872 | 2540872 | 2020-12-01 | US | West Virginia | Kanawha | 54039 | 5785 | 148 | 0 | 5637 | 38.33860077 | -81.52857054 | 2020-12-02 05:27: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]);