johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where country_or_region = "US", deaths = 153 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2310781 | 2310781 | 2022-04-20 | US | West Virginia | Marshall | 54051 | 8963 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-21 04:20:46 | Marshall, West Virginia, US | |
2254920 | 2254920 | 2022-04-19 | US | West Virginia | Marshall | 54051 | 8952 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-20 04:20:45 | Marshall, West Virginia, US | |
1849470 | 1849470 | 2022-04-18 | US | West Virginia | Marshall | 54051 | 8950 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-19 04:21:00 | Marshall, West Virginia, US | |
3420414 | 3420414 | 2022-04-17 | US | West Virginia | Marshall | 54051 | 8944 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-18 04:21:12 | Marshall, West Virginia, US | |
307363 | 307363 | 2022-04-16 | US | West Virginia | Marshall | 54051 | 8944 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-17 04:20:59 | Marshall, West Virginia, US | |
2673308 | 2673308 | 2022-04-15 | US | West Virginia | Marshall | 54051 | 8944 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-16 04:20:48 | Marshall, West Virginia, US | |
1227093 | 1227093 | 2022-04-14 | US | West Virginia | Marshall | 54051 | 8944 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-15 04:20:57 | Marshall, West Virginia, US | |
2446251 | 2446251 | 2022-04-13 | US | West Virginia | Marshall | 54051 | 8942 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-13 23:21:06 | Marshall, West Virginia, US | |
1952008 | 1952008 | 2022-04-12 | US | West Virginia | Marshall | 54051 | 8943 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-04-13 04:21:03 | Marshall, West Virginia, US | |
2804259 | 2804259 | 2022-04-06 | US | West Virginia | Greenbrier | 54025 | 9503 | 153 | 0 | 37.9463652 | -80.45335881 | 2022-04-07 04:20:53 | Greenbrier, West Virginia, US | |
3871028 | 3871028 | 2022-04-05 | US | West Virginia | Greenbrier | 54025 | 9500 | 153 | 0 | 37.9463652 | -80.45335881 | 2022-04-06 04:20:49 | Greenbrier, West Virginia, US | |
1440066 | 1440066 | 2022-03-28 | US | West Virginia | Greenbrier | 54025 | 9476 | 153 | 0 | 37.9463652 | -80.45335881 | 2022-03-29 04:20:46 | Greenbrier, West Virginia, US | |
1908691 | 1908691 | 2022-03-22 | US | West Virginia | Marshall | 54051 | 8914 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-23 04:20:48 | Marshall, West Virginia, US | |
3241822 | 3241822 | 2022-03-21 | US | West Virginia | Marshall | 54051 | 8912 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-22 04:20:54 | Marshall, West Virginia, US | |
27895 | 27895 | 2022-03-20 | US | West Virginia | Marshall | 54051 | 8909 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-21 04:20:50 | Marshall, West Virginia, US | |
1659905 | 1659905 | 2022-03-19 | US | West Virginia | Marshall | 54051 | 8909 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-20 04:20:45 | Marshall, West Virginia, US | |
339431 | 339431 | 2022-03-18 | US | West Virginia | Marshall | 54051 | 8909 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-19 04:20:47 | Marshall, West Virginia, US | |
697884 | 697884 | 2022-03-17 | US | West Virginia | Marshall | 54051 | 8904 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-18 04:20:55 | Marshall, West Virginia, US | |
2322827 | 2322827 | 2022-03-16 | US | West Virginia | Marshall | 54051 | 8900 | 153 | 0 | 39.86064362 | -80.66591062 | 2022-03-17 04:20:56 | Marshall, West Virginia, US | |
2203139 | 2203139 | 2022-03-06 | US | West Virginia | Mineral | 54057 | 7793 | 153 | 0 | 39.41561583 | -78.94104895 | 2022-03-07 04:20:47 | Mineral, West Virginia, US | |
2095596 | 2095596 | 2022-03-05 | US | West Virginia | Mineral | 54057 | 7793 | 153 | 0 | 39.41561583 | -78.94104895 | 2022-03-06 04:20:49 | Mineral, West Virginia, US | |
2669296 | 2669296 | 2022-03-04 | US | West Virginia | Mineral | 54057 | 7793 | 153 | 0 | 39.41561583 | -78.94104895 | 2022-03-05 04:21:10 | Mineral, West Virginia, US | |
1647861 | 1647861 | 2022-03-03 | US | West Virginia | Mineral | 54057 | 7785 | 153 | 0 | 39.41561583 | -78.94104895 | 2022-03-04 04:21:09 | Mineral, West Virginia, US | |
2528864 | 2528864 | 2022-03-02 | US | West Virginia | Mineral | 54057 | 7783 | 153 | 0 | 39.41561583 | -78.94104895 | 2022-03-03 04:21:01 | Mineral, West Virginia, US | |
1996164 | 1996164 | 2022-03-01 | US | West Virginia | Ohio | 54069 | 10938 | 153 | 0 | 40.0955451 | -80.62203992 | 2022-03-02 04:21:07 | Ohio, West Virginia, US | |
74584 | 74584 | 2022-02-07 | US | West Virginia | Marion | 54049 | 13672 | 153 | 0 | 39.50984542 | -80.24244659 | 2022-02-08 04:21:15 | Marion, West Virginia, US | |
74600 | 74600 | 2022-02-07 | US | West Virginia | Putnam | 54079 | 15568 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-08 04:21:15 | Putnam, West Virginia, US | |
2016200 | 2016200 | 2022-02-06 | US | West Virginia | Marion | 54049 | 13624 | 153 | 0 | 39.50984542 | -80.24244659 | 2022-02-07 04:21:05 | Marion, West Virginia, US | |
2016216 | 2016216 | 2022-02-06 | US | West Virginia | Putnam | 54079 | 15536 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-07 04:21:05 | Putnam, West Virginia, US | |
1297529 | 1297529 | 2022-02-05 | US | West Virginia | Marion | 54049 | 13579 | 153 | 0 | 39.50984542 | -80.24244659 | 2022-02-06 04:21:00 | Marion, West Virginia, US | |
1297545 | 1297545 | 2022-02-05 | US | West Virginia | Putnam | 54079 | 15493 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-06 04:21:00 | Putnam, West Virginia, US | |
2330857 | 2330857 | 2022-02-04 | US | West Virginia | Marion | 54049 | 13476 | 153 | 0 | 39.50984542 | -80.24244659 | 2022-02-05 04:21:05 | Marion, West Virginia, US | |
2330873 | 2330873 | 2022-02-04 | US | West Virginia | Putnam | 54079 | 15356 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-05 04:21:05 | Putnam, West Virginia, US | |
2477464 | 2477464 | 2022-02-03 | US | West Virginia | Putnam | 54079 | 15269 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-04 04:21:10 | Putnam, West Virginia, US | |
462873 | 462873 | 2022-02-02 | US | West Virginia | Marion | 54049 | 13336 | 153 | 0 | 39.50984542 | -80.24244659 | 2022-02-03 04:21:21 | Marion, West Virginia, US | |
462889 | 462889 | 2022-02-02 | US | West Virginia | Putnam | 54079 | 15090 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-03 04:21:21 | Putnam, West Virginia, US | |
982458 | 982458 | 2022-02-01 | US | West Virginia | Putnam | 54079 | 14973 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-02 04:21:09 | Putnam, West Virginia, US | |
2661300 | 2661300 | 2022-01-31 | US | West Virginia | Putnam | 54079 | 14933 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-02-01 04:21:11 | Putnam, West Virginia, US | |
3065508 | 3065508 | 2022-01-29 | US | West Virginia | Putnam | 54079 | 14753 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-01-30 04:21:26 | Putnam, West Virginia, US | |
3813442 | 3813442 | 2022-01-28 | US | West Virginia | Putnam | 54079 | 14613 | 153 | 0 | 38.50782345 | -81.9082131 | 2022-01-29 04:21:10 | Putnam, West Virginia, US | |
1144392 | 1144392 | 2022-01-23 | US | West Virginia | Fayette | 54019 | 10121 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-24 04:21:12 | Fayette, West Virginia, US | |
2836310 | 2836310 | 2022-01-22 | US | West Virginia | Fayette | 54019 | 9949 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-23 04:21:13 | Fayette, West Virginia, US | |
3428428 | 3428428 | 2022-01-21 | US | West Virginia | Fayette | 54019 | 9695 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-22 04:21:13 | Fayette, West Virginia, US | |
1964036 | 1964036 | 2022-01-20 | US | West Virginia | Fayette | 54019 | 9496 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-21 04:21:09 | Fayette, West Virginia, US | |
3229931 | 3229931 | 2022-01-19 | US | West Virginia | Fayette | 54019 | 9362 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-20 04:21:07 | Fayette, West Virginia, US | |
3467656 | 3467656 | 2022-01-18 | US | West Virginia | Fayette | 54019 | 9246 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-19 04:21:23 | Fayette, West Virginia, US | |
1475595 | 1475595 | 2022-01-17 | US | West Virginia | Fayette | 54019 | 9190 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-18 04:21:04 | Fayette, West Virginia, US | |
558269 | 558269 | 2022-01-16 | US | West Virginia | Fayette | 54019 | 9086 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-17 04:21:08 | Fayette, West Virginia, US | |
3843990 | 3843990 | 2022-01-15 | US | West Virginia | Fayette | 54019 | 8924 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-16 04:21:12 | Fayette, West Virginia, US | |
102805 | 102805 | 2022-01-14 | US | West Virginia | Fayette | 54019 | 8787 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-15 04:21:07 | Fayette, West Virginia, US | |
3690960 | 3690960 | 2022-01-13 | US | West Virginia | Fayette | 54019 | 8646 | 153 | 0 | 38.02974928 | -81.08286634 | 2022-01-14 04:21:54 | Fayette, West Virginia, US | |
734020 | 734020 | 2021-12-27 | US | West Virginia | Logan | 54045 | 6197 | 153 | 0 | 37.8299889 | -81.93528571 | 2021-12-28 04:21:47 | Logan, West Virginia, US | |
2115192 | 2115192 | 2021-12-26 | US | West Virginia | Logan | 54045 | 6155 | 153 | 0 | 37.8299889 | -81.93528571 | 2021-12-27 04:21:58 | Logan, West Virginia, US | |
3608564 | 3608564 | 2021-12-25 | US | West Virginia | Logan | 54045 | 6155 | 153 | 0 | 37.8299889 | -81.93528571 | 2021-12-26 04:21:50 | Logan, West Virginia, US | |
2966882 | 2966882 | 2021-12-24 | US | West Virginia | Logan | 54045 | 6155 | 153 | 0 | 37.8299889 | -81.93528571 | 2021-12-25 04:21:37 | Logan, West Virginia, US | |
3819914 | 3819914 | 2021-12-23 | US | West Virginia | Logan | 54045 | 6155 | 153 | 0 | 37.8299889 | -81.93528571 | 2021-12-24 04:21:34 | Logan, West Virginia, US | |
2907216 | 2907216 | 2021-12-19 | US | West Virginia | Monongalia | 54061 | 15040 | 153 | 0 | 39.63218457 | -80.04766838 | 2021-12-20 04:21:43 | Monongalia, West Virginia, US | |
1262289 | 1262289 | 2021-12-18 | US | West Virginia | Monongalia | 54061 | 15010 | 153 | 0 | 39.63218457 | -80.04766838 | 2021-12-19 04:21:11 | Monongalia, West Virginia, US | |
1719855 | 1719855 | 2021-12-16 | US | West Virginia | Monongalia | 54061 | 14943 | 153 | 0 | 39.63218457 | -80.04766838 | 2021-12-17 04:22:14 | Monongalia, West Virginia, US | |
3514890 | 3514890 | 2021-11-01 | US | West Virginia | Harrison | 54033 | 11311 | 153 | 0 | 39.2853852 | -80.37919577 | 2021-11-02 04:22:03 | Harrison, West Virginia, US | |
1818243 | 1818243 | 2021-09-19 | US | West Virginia | Berkeley | 54003 | 15827 | 153 | 0 | 39.46704621 | -78.02414609 | 2021-09-20 04:21:22 | Berkeley, West Virginia, US | |
19823 | 19823 | 2021-09-18 | US | West Virginia | Berkeley | 54003 | 15755 | 153 | 0 | 39.46704621 | -78.02414609 | 2021-09-19 04:21:34 | Berkeley, West Virginia, US | |
2621508 | 2621508 | 2021-09-17 | US | West Virginia | Berkeley | 54003 | 15684 | 153 | 0 | 39.46704621 | -78.02414609 | 2021-09-18 04:21:24 | Berkeley, 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]);