johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where country_or_region = "US", deaths = 127 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
542282 | 542282 | 2022-10-26 | US | West Virginia | Wyoming | 54109 | 9057 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-27 04:22:01 | Wyoming, West Virginia, US | |
1833683 | 1833683 | 2022-10-25 | US | West Virginia | Wyoming | 54109 | 9052 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-26 04:22:19 | Wyoming, West Virginia, US | |
797944 | 797944 | 2022-10-24 | US | West Virginia | Wyoming | 54109 | 9049 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-25 04:21:53 | Wyoming, West Virginia, US | |
3280399 | 3280399 | 2022-10-23 | US | West Virginia | Wyoming | 54109 | 9039 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-24 04:22:29 | Wyoming, West Virginia, US | |
2271437 | 2271437 | 2022-10-22 | US | West Virginia | Wyoming | 54109 | 9039 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-23 04:22:46 | Wyoming, West Virginia, US | |
1595737 | 1595737 | 2022-10-21 | US | West Virginia | Wyoming | 54109 | 9039 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-22 04:22:53 | Wyoming, West Virginia, US | |
2275453 | 2275453 | 2022-10-20 | US | West Virginia | Wyoming | 54109 | 9031 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-21 04:22:23 | Wyoming, West Virginia, US | |
201788 | 201788 | 2022-10-19 | US | West Virginia | Wyoming | 54109 | 9024 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-20 04:22:59 | Wyoming, West Virginia, US | |
2760449 | 2760449 | 2022-10-18 | US | West Virginia | Wyoming | 54109 | 9011 | 127 | 0 | 37.612327 | -81.54511071 | 2022-10-19 04:22:26 | Wyoming, West Virginia, US | |
375700 | 375700 | 2022-09-13 | US | West Virginia | Mingo | 54059 | 9101 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-14 04:20:44 | Mingo, West Virginia, US | |
2398302 | 2398302 | 2022-09-12 | US | West Virginia | Mingo | 54059 | 9079 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-13 04:20:57 | Mingo, West Virginia, US | |
3769380 | 3769380 | 2022-09-11 | US | West Virginia | Mingo | 54059 | 9066 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-12 04:20:58 | Mingo, West Virginia, US | |
3827955 | 3827955 | 2022-09-10 | US | West Virginia | Mingo | 54059 | 9066 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-11 04:20:50 | Mingo, West Virginia, US | |
966412 | 966412 | 2022-09-09 | US | West Virginia | Mingo | 54059 | 9066 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-10 04:21:10 | Mingo, West Virginia, US | |
256814 | 256814 | 2022-09-08 | US | West Virginia | Mingo | 54059 | 9048 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-09 04:21:11 | Mingo, West Virginia, US | |
3748612 | 3748612 | 2022-09-07 | US | West Virginia | Mingo | 54059 | 9026 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-08 04:21:02 | Mingo, West Virginia, US | |
118252 | 118252 | 2022-09-06 | US | West Virginia | Mingo | 54059 | 8997 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-07 04:20:59 | Mingo, West Virginia, US | |
2637224 | 2637224 | 2022-09-05 | US | West Virginia | Mingo | 54059 | 8985 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-06 04:21:02 | Mingo, West Virginia, US | |
2990788 | 2990788 | 2022-09-04 | US | West Virginia | Mingo | 54059 | 8985 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-05 04:21:01 | Mingo, West Virginia, US | |
2716473 | 2716473 | 2022-09-03 | US | West Virginia | Mingo | 54059 | 8985 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-04 04:21:22 | Mingo, West Virginia, US | |
1397178 | 1397178 | 2022-09-02 | US | West Virginia | Mingo | 54059 | 8985 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-03 04:21:04 | Mingo, West Virginia, US | |
3551007 | 3551007 | 2022-09-01 | US | West Virginia | Mingo | 54059 | 8976 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-02 04:21:07 | Mingo, West Virginia, US | |
2346927 | 2346927 | 2022-08-31 | US | West Virginia | Mingo | 54059 | 8969 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-01 04:21:03 | Mingo, West Virginia, US | |
3777407 | 3777407 | 2022-08-30 | US | West Virginia | Mingo | 54059 | 8965 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-08-31 04:20:57 | Mingo, West Virginia, US | |
1684003 | 1684003 | 2022-08-29 | US | West Virginia | Mingo | 54059 | 8950 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-08-30 04:21:03 | Mingo, West Virginia, US | |
2191135 | 2191135 | 2022-06-22 | US | West Virginia | Wayne | 54099 | 10254 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-23 04:20:55 | Wayne, West Virginia, US | |
169566 | 169566 | 2022-06-21 | US | West Virginia | Wayne | 54099 | 10248 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-22 04:20:54 | Wayne, West Virginia, US | |
1766849 | 1766849 | 2022-06-20 | US | West Virginia | Wayne | 54099 | 10222 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-21 04:20:56 | Wayne, West Virginia, US | |
3273035 | 3273035 | 2022-06-19 | US | West Virginia | Wayne | 54099 | 10222 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-20 04:21:01 | Wayne, West Virginia, US | |
3400947 | 3400947 | 2022-06-18 | US | West Virginia | Wayne | 54099 | 10222 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-19 04:20:51 | Wayne, West Virginia, US | |
2314824 | 2314824 | 2022-06-17 | US | West Virginia | Wayne | 54099 | 10222 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-18 04:21:10 | Wayne, West Virginia, US | |
562328 | 562328 | 2022-06-16 | US | West Virginia | Wayne | 54099 | 10222 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-17 04:20:56 | Wayne, West Virginia, US | |
3986130 | 3986130 | 2022-06-15 | US | West Virginia | Wayne | 54099 | 10212 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-16 04:20:55 | Wayne, West Virginia, US | |
950371 | 950371 | 2022-06-14 | US | West Virginia | Wayne | 54099 | 10207 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-15 04:20:54 | Wayne, West Virginia, US | |
2982779 | 2982779 | 2022-06-13 | US | West Virginia | Wayne | 54099 | 10192 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-14 04:20:52 | Wayne, West Virginia, US | |
2238905 | 2238905 | 2022-06-12 | US | West Virginia | Wayne | 54099 | 10174 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-13 04:21:14 | Wayne, West Virginia, US | |
3145103 | 3145103 | 2022-06-11 | US | West Virginia | Wayne | 54099 | 10174 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-12 04:20:53 | Wayne, West Virginia, US | |
1948019 | 1948019 | 2022-06-10 | US | West Virginia | Wayne | 54099 | 10174 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-11 04:21:01 | Wayne, West Virginia, US | |
3161158 | 3161158 | 2022-06-09 | US | West Virginia | Wayne | 54099 | 10165 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-10 04:20:55 | Wayne, West Virginia, US | |
1424625 | 1424625 | 2022-06-08 | US | West Virginia | Wayne | 54099 | 10158 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-09 04:20:54 | Wayne, West Virginia, US | |
3729739 | 3729739 | 2022-06-07 | US | West Virginia | Wayne | 54099 | 10134 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-08 04:20:55 | Wayne, West Virginia, US | |
2203149 | 2203149 | 2022-03-06 | US | West Virginia | Preston | 54077 | 9108 | 127 | 0 | 39.46770987 | -79.66712803 | 2022-03-07 04:20:47 | Preston, West Virginia, US | |
2095606 | 2095606 | 2022-03-05 | US | West Virginia | Preston | 54077 | 9108 | 127 | 0 | 39.46770987 | -79.66712803 | 2022-03-06 04:20:49 | Preston, West Virginia, US | |
2669306 | 2669306 | 2022-03-04 | US | West Virginia | Preston | 54077 | 9108 | 127 | 0 | 39.46770987 | -79.66712803 | 2022-03-05 04:21:10 | Preston, West Virginia, US | |
1061338 | 1061338 | 2022-02-23 | US | West Virginia | Jefferson | 54037 | 13988 | 127 | 0 | 39.30776166 | -77.86014147 | 2022-02-24 04:21:14 | Jefferson, West Virginia, US | |
2016189 | 2016189 | 2022-02-06 | US | West Virginia | Greenbrier | 54025 | 8555 | 127 | 0 | 37.9463652 | -80.45335881 | 2022-02-07 04:21:05 | Greenbrier, West Virginia, US | |
1297518 | 1297518 | 2022-02-05 | US | West Virginia | Greenbrier | 54025 | 8512 | 127 | 0 | 37.9463652 | -80.45335881 | 2022-02-06 04:21:00 | Greenbrier, West Virginia, US | |
2330846 | 2330846 | 2022-02-04 | US | West Virginia | Greenbrier | 54025 | 8419 | 127 | 0 | 37.9463652 | -80.45335881 | 2022-02-05 04:21:05 | Greenbrier, West Virginia, US | |
1475600 | 1475600 | 2022-01-17 | US | West Virginia | Hancock | 54029 | 5864 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-18 04:21:04 | Hancock, West Virginia, US | |
558274 | 558274 | 2022-01-16 | US | West Virginia | Hancock | 54029 | 5763 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-17 04:21:08 | Hancock, West Virginia, US | |
3843995 | 3843995 | 2022-01-15 | US | West Virginia | Hancock | 54029 | 5731 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-16 04:21:12 | Hancock, West Virginia, US | |
102810 | 102810 | 2022-01-14 | US | West Virginia | Hancock | 54029 | 5700 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-15 04:21:07 | Hancock, West Virginia, US | |
3690965 | 3690965 | 2022-01-13 | US | West Virginia | Hancock | 54029 | 5659 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-14 04:21:54 | Hancock, West Virginia, US | |
3616549 | 3616549 | 2022-01-12 | US | West Virginia | Hancock | 54029 | 5613 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-13 08:00:09 | Hancock, West Virginia, US | |
407792 | 407792 | 2021-12-07 | US | West Virginia | Mineral | 54057 | 5065 | 127 | 0 | 39.41561583 | -78.94104895 | 2021-12-08 04:22:46 | Mineral, West Virginia, US | |
1033874 | 1033874 | 2021-12-06 | US | West Virginia | Mineral | 54057 | 5059 | 127 | 0 | 39.41561583 | -78.94104895 | 2021-12-07 04:22:34 | Mineral, West Virginia, US | |
495135 | 495135 | 2021-10-14 | US | West Virginia | Monongalia | 54061 | 12269 | 127 | 0 | 39.63218457 | -80.04766838 | 2021-10-15 04:21:26 | Monongalia, West Virginia, US | |
426836 | 426836 | 2021-10-10 | US | West Virginia | Harrison | 54033 | 10266 | 127 | 0 | 39.2853852 | -80.37919577 | 2021-10-11 04:21:31 | Harrison, West Virginia, US | |
2879693 | 2879693 | 2021-10-09 | US | West Virginia | Harrison | 54033 | 10195 | 127 | 0 | 39.2853852 | -80.37919577 | 2021-10-10 04:21:38 | Harrison, West Virginia, US | |
2962859 | 2962859 | 2021-10-08 | US | West Virginia | Harrison | 54033 | 10111 | 127 | 0 | 39.2853852 | -80.37919577 | 2021-10-09 04:21:34 | Harrison, West Virginia, US | |
813083 | 813083 | 2021-09-20 | US | West Virginia | Raleigh | 54081 | 9647 | 127 | 0 | 37.76936795 | -81.2456041 | 2021-09-21 04:21:26 | Raleigh, West Virginia, US | |
1935930 | 1935930 | 2021-07-05 | US | West Virginia | Mercer | 54055 | 5193 | 127 | 0 | 37.40481169 | -81.11023142 | 2021-07-06 04:21:32 | Mercer, West Virginia, US | |
1168661 | 1168661 | 2021-07-04 | US | West Virginia | Mercer | 54055 | 5193 | 127 | 0 | 37.40481169 | -81.11023142 | 2021-07-05 04:21:28 | Mercer, West Virginia, US | |
1499095 | 1499095 | 2021-07-03 | US | West Virginia | Mercer | 54055 | 5193 | 127 | 0 | 37.40481169 | -81.11023142 | 2021-07-04 04:21:38 | Mercer, West Virginia, US | |
2075410 | 2075410 | 2021-07-02 | US | West Virginia | Mercer | 54055 | 5193 | 127 | 0 | 37.40481169 | -81.11023142 | 2021-07-03 04:21:37 | Mercer, 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]);