johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where country_or_region = "US", deaths = 154 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3538955 | 3538955 | 2022-05-10 | US | West Virginia | Marshall | 54051 | 9065 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-11 04:20:48 | Marshall, West Virginia, US | |
225490 | 225490 | 2022-05-09 | US | West Virginia | Marshall | 54051 | 9065 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-10 04:20:50 | Marshall, West Virginia, US | |
2334875 | 2334875 | 2022-05-08 | US | West Virginia | Marshall | 54051 | 9050 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-09 04:20:54 | Marshall, West Virginia, US | |
363837 | 363837 | 2022-05-07 | US | West Virginia | Marshall | 54051 | 9050 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-08 04:20:49 | Marshall, West Virginia, US | |
1401188 | 1401188 | 2022-05-06 | US | West Virginia | Marshall | 54051 | 9050 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-07 04:21:09 | Marshall, West Virginia, US | |
2601543 | 2601543 | 2022-05-05 | US | West Virginia | Marshall | 54051 | 9048 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-06 04:21:00 | Marshall, West Virginia, US | |
3268992 | 3268992 | 2022-05-04 | US | West Virginia | Marshall | 54051 | 9043 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-05 04:20:55 | Marshall, West Virginia, US | |
1575631 | 1575631 | 2022-05-03 | US | West Virginia | Marshall | 54051 | 9037 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-04 04:20:59 | Marshall, West Virginia, US | |
466891 | 466891 | 2022-05-02 | US | West Virginia | Marshall | 54051 | 9031 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-03 04:21:00 | Marshall, West Virginia, US | |
3919530 | 3919530 | 2022-05-01 | US | West Virginia | Marshall | 54051 | 9022 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-02 04:21:10 | Marshall, West Virginia, US | |
2844334 | 2844334 | 2022-04-30 | US | West Virginia | Marshall | 54051 | 9022 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-05-01 04:20:57 | Marshall, West Virginia, US | |
1160647 | 1160647 | 2022-04-29 | US | West Virginia | Marshall | 54051 | 9022 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-30 04:21:05 | Marshall, West Virginia, US | |
1699829 | 1699829 | 2022-04-28 | US | West Virginia | Marshall | 54051 | 9015 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-29 04:20:59 | Marshall, West Virginia, US | |
3855312 | 3855312 | 2022-04-27 | US | West Virginia | Marshall | 54051 | 9002 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-28 04:20:47 | Marshall, West Virginia, US | |
1329742 | 1329742 | 2022-04-26 | US | West Virginia | Marshall | 54051 | 8998 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-27 04:20:52 | Marshall, West Virginia, US | |
3725696 | 3725696 | 2022-04-25 | US | West Virginia | Marshall | 54051 | 8993 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-26 04:20:51 | Marshall, West Virginia, US | |
2032264 | 2032264 | 2022-04-24 | US | West Virginia | Marshall | 54051 | 8985 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-25 04:20:56 | Marshall, West Virginia, US | |
749839 | 749839 | 2022-04-23 | US | West Virginia | Marshall | 54051 | 8985 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-24 04:20:56 | Marshall, West Virginia, US | |
3440324 | 3440324 | 2022-04-22 | US | West Virginia | Marshall | 54051 | 8985 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-23 04:20:50 | Marshall, West Virginia, US | |
2895909 | 2895909 | 2022-04-21 | US | West Virginia | Marshall | 54051 | 8974 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-22 04:20:45 | Marshall, West Virginia, US | |
3323723 | 3323723 | 2022-04-07 | US | West Virginia | Greenbrier | 54025 | 9505 | 154 | 0 | 37.9463652 | -80.45335881 | 2022-04-08 04:20:48 | Greenbrier, West Virginia, US | |
2752382 | 2752382 | 2022-04-04 | US | West Virginia | Marshall | 54051 | 8928 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-05 04:20:48 | Marshall, West Virginia, US | |
3733728 | 3733728 | 2022-04-03 | US | West Virginia | Marshall | 54051 | 8931 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-04 04:20:51 | Marshall, West Virginia, US | |
503163 | 503163 | 2022-04-02 | US | West Virginia | Marshall | 54051 | 8931 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-03 04:20:48 | Marshall, West Virginia, US | |
3354148 | 3354148 | 2022-04-01 | US | West Virginia | Marshall | 54051 | 8931 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-02 04:20:47 | Marshall, West Virginia, US | |
1543453 | 1543453 | 2022-03-31 | US | West Virginia | Marshall | 54051 | 8929 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-04-01 04:20:28 | Marshall, West Virginia, US | |
2481466 | 2481466 | 2022-03-30 | US | West Virginia | Marshall | 54051 | 8928 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-31 04:20:56 | Marshall, West Virginia, US | |
161495 | 161495 | 2022-03-29 | US | West Virginia | Greenbrier | 54025 | 9478 | 154 | 0 | 37.9463652 | -80.45335881 | 2022-03-30 04:20:45 | Greenbrier, West Virginia, US | |
161507 | 161507 | 2022-03-29 | US | West Virginia | Marshall | 54051 | 8927 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-30 04:20:45 | Marshall, West Virginia, US | |
1440078 | 1440078 | 2022-03-28 | US | West Virginia | Marshall | 54051 | 8926 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-29 04:20:46 | Marshall, West Virginia, US | |
879759 | 879759 | 2022-03-27 | US | West Virginia | Marshall | 54051 | 8924 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-28 04:20:33 | Marshall, West Virginia, US | |
2167042 | 2167042 | 2022-03-26 | US | West Virginia | Marshall | 54051 | 8924 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-27 04:20:47 | Marshall, West Virginia, US | |
1723978 | 1723978 | 2022-03-25 | US | West Virginia | Marshall | 54051 | 8924 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-26 04:20:23 | Marshall, West Virginia, US | |
1471595 | 1471595 | 2022-03-24 | US | West Virginia | Marshall | 54051 | 8920 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-25 04:20:46 | Marshall, West Virginia, US | |
3025769 | 3025769 | 2022-03-23 | US | West Virginia | Marshall | 54051 | 8918 | 154 | 0 | 39.86064362 | -80.66591062 | 2022-03-24 04:20:43 | Marshall, West Virginia, US | |
1551470 | 1551470 | 2022-03-07 | US | West Virginia | Mineral | 54057 | 7803 | 154 | 0 | 39.41561583 | -78.94104895 | 2022-03-08 04:20:54 | Mineral, West Virginia, US | |
1467578 | 1467578 | 2022-02-10 | US | West Virginia | Marion | 54049 | 13863 | 154 | 0 | 39.50984542 | -80.24244659 | 2022-02-11 04:21:09 | Marion, West Virginia, US | |
3077539 | 3077539 | 2022-02-09 | US | West Virginia | Marion | 54049 | 13796 | 154 | 0 | 39.50984542 | -80.24244659 | 2022-02-10 04:21:14 | Marion, West Virginia, US | |
1365846 | 1365846 | 2022-02-08 | US | West Virginia | Marion | 54049 | 13735 | 154 | 0 | 39.50984542 | -80.24244659 | 2022-02-09 04:21:04 | Marion, West Virginia, US | |
1365862 | 1365862 | 2022-02-08 | US | West Virginia | Putnam | 54079 | 15614 | 154 | 0 | 38.50782345 | -81.9082131 | 2022-02-09 04:21:04 | Putnam, West Virginia, US | |
3303717 | 3303717 | 2022-01-30 | US | West Virginia | Putnam | 54079 | 14884 | 154 | 0 | 38.50782345 | -81.9082131 | 2022-01-31 04:21:09 | Putnam, West Virginia, US | |
2055362 | 2055362 | 2022-01-25 | US | West Virginia | Fayette | 54019 | 10285 | 154 | 0 | 38.02974928 | -81.08286634 | 2022-01-26 04:21:07 | Fayette, West Virginia, US | |
1231093 | 1231093 | 2022-01-24 | US | West Virginia | Fayette | 54019 | 10231 | 154 | 0 | 38.02974928 | -81.08286634 | 2022-01-25 04:21:05 | Fayette, West Virginia, US | |
1285482 | 1285482 | 2022-01-05 | US | West Virginia | Logan | 54045 | 6458 | 154 | 0 | 37.8299889 | -81.93528571 | 2022-01-06 04:22:09 | Logan, West Virginia, US | |
1289498 | 1289498 | 2022-01-04 | US | West Virginia | Logan | 54045 | 6429 | 154 | 0 | 37.8299889 | -81.93528571 | 2022-01-05 04:21:59 | Logan, West Virginia, US | |
1703842 | 1703842 | 2022-01-03 | US | West Virginia | Logan | 54045 | 6390 | 154 | 0 | 37.8299889 | -81.93528571 | 2022-01-04 04:22:17 | Logan, West Virginia, US | |
3522925 | 3522925 | 2022-01-02 | US | West Virginia | Logan | 54045 | 6279 | 154 | 0 | 37.8299889 | -81.93528571 | 2022-01-03 02:22:25 | Logan, West Virginia, US | |
2171055 | 2171055 | 2022-01-01 | US | West Virginia | Logan | 54045 | 6279 | 154 | 0 | 37.8299889 | -81.93528571 | 2022-01-02 04:20:52 | Logan, West Virginia, US | |
2780486 | 2780486 | 2021-12-31 | US | West Virginia | Logan | 54045 | 6279 | 154 | 0 | 37.8299889 | -81.93528571 | 2022-01-01 04:22:14 | Logan, West Virginia, US | |
4002143 | 4002143 | 2021-12-30 | US | West Virginia | Logan | 54045 | 6279 | 154 | 0 | 37.8299889 | -81.93528571 | 2021-12-31 04:21:50 | Logan, West Virginia, US | |
1671950 | 1671950 | 2021-12-29 | US | West Virginia | Logan | 54045 | 6253 | 154 | 0 | 37.8299889 | -81.93528571 | 2021-12-30 04:21:25 | Logan, West Virginia, US | |
1436059 | 1436059 | 2021-12-28 | US | West Virginia | Logan | 54045 | 6218 | 154 | 0 | 37.8299889 | -81.93528571 | 2021-12-29 03:21:43 | Logan, West Virginia, US | |
1258273 | 1258273 | 2021-12-20 | US | West Virginia | Monongalia | 54061 | 15070 | 154 | 0 | 39.63218457 | -80.04766838 | 2021-12-21 03:21:27 | Monongalia, West Virginia, US | |
2402317 | 2402317 | 2021-12-17 | US | West Virginia | Monongalia | 54061 | 14978 | 154 | 0 | 39.63218457 | -80.04766838 | 2021-12-18 02:22:20 | Monongalia, West Virginia, US | |
1337772 | 1337772 | 2021-09-28 | US | West Virginia | Mercer | 54055 | 7709 | 154 | 0 | 37.40481169 | -81.11023142 | 2021-09-29 04:21:45 | Mercer, West Virginia, US | |
1239141 | 1239141 | 2021-09-27 | US | West Virginia | Mercer | 54055 | 7662 | 154 | 0 | 37.40481169 | -81.11023142 | 2021-09-28 04:21:28 | Mercer, West Virginia, US | |
3760941 | 3760941 | 2021-09-21 | US | West Virginia | Berkeley | 54003 | 15924 | 154 | 0 | 39.46704621 | -78.02414609 | 2021-09-22 04:21:45 | Berkeley, West Virginia, US | |
813044 | 813044 | 2021-09-20 | US | West Virginia | Berkeley | 54003 | 15875 | 154 | 0 | 39.46704621 | -78.02414609 | 2021-09-21 04:21:26 | Berkeley, West Virginia, US | |
3982042 | 3982042 | 2021-02-10 | US | West Virginia | Cabell | 54011 | 7381 | 154 | 0 | 7227 | 38.42424062 | -82.23855912 | 2021-02-11 05:23:55 | 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]);