johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where country_or_region = "US", deaths = 172 and province_or_state = "West Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 54 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2379028 | 2379028 | 2022-09-29 | US | West Virginia | Greenbrier | 54025 | 11915 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-30 04:23:09 | Greenbrier, West Virginia, US | |
1563579 | 1563579 | 2022-09-28 | US | West Virginia | Greenbrier | 54025 | 11906 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-29 04:22:34 | Greenbrier, West Virginia, US | |
3998122 | 3998122 | 2022-09-27 | US | West Virginia | Greenbrier | 54025 | 11901 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-28 04:23:01 | Greenbrier, West Virginia, US | |
2772450 | 2772450 | 2022-09-26 | US | West Virginia | Greenbrier | 54025 | 11895 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-27 04:23:01 | Greenbrier, West Virginia, US | |
1980103 | 1980103 | 2022-09-25 | US | West Virginia | Greenbrier | 54025 | 11881 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-26 04:20:52 | Greenbrier, West Virginia, US | |
2653270 | 2653270 | 2022-09-24 | US | West Virginia | Greenbrier | 54025 | 11881 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-25 04:23:31 | Greenbrier, West Virginia, US | |
387710 | 387710 | 2022-09-23 | US | West Virginia | Greenbrier | 54025 | 11881 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-24 04:21:40 | Greenbrier, West Virginia, US | |
1627776 | 1627776 | 2022-09-22 | US | West Virginia | Greenbrier | 54025 | 11865 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-23 04:23:13 | Greenbrier, West Virginia, US | |
1373980 | 1373980 | 2022-09-21 | US | West Virginia | Greenbrier | 54025 | 11856 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-22 04:22:56 | Greenbrier, West Virginia, US | |
2020210 | 2020210 | 2022-09-20 | US | West Virginia | Greenbrier | 54025 | 11835 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-21 04:23:22 | Greenbrier, West Virginia, US | |
3574083 | 3574083 | 2022-09-19 | US | West Virginia | Greenbrier | 54025 | 11818 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-20 04:22:48 | Greenbrier, West Virginia, US | |
422822 | 422822 | 2022-09-18 | US | West Virginia | Greenbrier | 54025 | 11774 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-19 04:21:49 | Greenbrier, West Virginia, US | |
3376846 | 3376846 | 2022-09-17 | US | West Virginia | Greenbrier | 54025 | 11774 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-18 04:22:50 | Greenbrier, West Virginia, US | |
2358954 | 2358954 | 2022-09-16 | US | West Virginia | Greenbrier | 54025 | 11774 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-17 04:20:19 | Greenbrier, West Virginia, US | |
3990111 | 3990111 | 2022-09-15 | US | West Virginia | Greenbrier | 54025 | 11750 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-16 04:21:19 | Greenbrier, West Virginia, US | |
1892628 | 1892628 | 2022-09-14 | US | West Virginia | Greenbrier | 54025 | 11738 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-15 04:21:02 | Greenbrier, West Virginia, US | |
375683 | 375683 | 2022-09-13 | US | West Virginia | Greenbrier | 54025 | 11719 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-14 04:20:44 | Greenbrier, West Virginia, US | |
2398285 | 2398285 | 2022-09-12 | US | West Virginia | Greenbrier | 54025 | 11694 | 172 | 0 | 37.9463652 | -80.45335881 | 2022-09-13 04:20:57 | Greenbrier, West Virginia, US | |
2982763 | 2982763 | 2022-06-13 | US | West Virginia | Ohio | 54069 | 11824 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-14 04:20:52 | Ohio, West Virginia, US | |
2238889 | 2238889 | 2022-06-12 | US | West Virginia | Ohio | 54069 | 11797 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-13 04:21:14 | Ohio, West Virginia, US | |
3145087 | 3145087 | 2022-06-11 | US | West Virginia | Ohio | 54069 | 11797 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-12 04:20:53 | Ohio, West Virginia, US | |
1948003 | 1948003 | 2022-06-10 | US | West Virginia | Ohio | 54069 | 11797 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-11 04:21:01 | Ohio, West Virginia, US | |
3161142 | 3161142 | 2022-06-09 | US | West Virginia | Ohio | 54069 | 11791 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-10 04:20:55 | Ohio, West Virginia, US | |
1424609 | 1424609 | 2022-06-08 | US | West Virginia | Ohio | 54069 | 11779 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-09 04:20:54 | Ohio, West Virginia, US | |
3729723 | 3729723 | 2022-06-07 | US | West Virginia | Ohio | 54069 | 11762 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-08 04:20:55 | Ohio, West Virginia, US | |
3891125 | 3891125 | 2022-06-06 | US | West Virginia | Ohio | 54069 | 11749 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-07 04:21:08 | Ohio, West Virginia, US | |
3510894 | 3510894 | 2022-06-05 | US | West Virginia | Ohio | 54069 | 11705 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-06 04:20:57 | Ohio, West Virginia, US | |
3530971 | 3530971 | 2022-06-04 | US | West Virginia | Ohio | 54069 | 11705 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-05 04:20:55 | Ohio, West Virginia, US | |
3137057 | 3137057 | 2022-06-03 | US | West Virginia | Ohio | 54069 | 11705 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-04 04:20:58 | Ohio, West Virginia, US | |
2804286 | 2804286 | 2022-04-06 | US | West Virginia | Putnam | 54079 | 16634 | 172 | 0 | 38.50782345 | -81.9082131 | 2022-04-07 04:20:53 | Putnam, West Virginia, US | |
3871055 | 3871055 | 2022-04-05 | US | West Virginia | Putnam | 54079 | 16629 | 172 | 0 | 38.50782345 | -81.9082131 | 2022-04-06 04:20:49 | Putnam, West Virginia, US | |
697899 | 697899 | 2022-03-17 | US | West Virginia | Putnam | 54079 | 16561 | 172 | 0 | 38.50782345 | -81.9082131 | 2022-03-18 04:20:55 | Putnam, West Virginia, US | |
2322842 | 2322842 | 2022-03-16 | US | West Virginia | Putnam | 54079 | 16559 | 172 | 0 | 38.50782345 | -81.9082131 | 2022-03-17 04:20:56 | Putnam, West Virginia, US | |
1551464 | 1551464 | 2022-03-07 | US | West Virginia | Logan | 54045 | 9514 | 172 | 0 | 37.8299889 | -81.93528571 | 2022-03-08 04:20:54 | Logan, West Virginia, US | |
2203133 | 2203133 | 2022-03-06 | US | West Virginia | Logan | 54045 | 9504 | 172 | 0 | 37.8299889 | -81.93528571 | 2022-03-07 04:20:47 | Logan, West Virginia, US | |
2095590 | 2095590 | 2022-03-05 | US | West Virginia | Logan | 54045 | 9504 | 172 | 0 | 37.8299889 | -81.93528571 | 2022-03-06 04:20:49 | Logan, West Virginia, US | |
2669290 | 2669290 | 2022-03-04 | US | West Virginia | Logan | 54045 | 9504 | 172 | 0 | 37.8299889 | -81.93528571 | 2022-03-05 04:21:10 | Logan, West Virginia, US | |
1514888 | 1514888 | 2022-02-24 | US | West Virginia | Fayette | 54019 | 12714 | 172 | 0 | 38.02974928 | -81.08286634 | 2022-02-25 04:21:11 | Fayette, West Virginia, US | |
1061329 | 1061329 | 2022-02-23 | US | West Virginia | Fayette | 54019 | 12672 | 172 | 0 | 38.02974928 | -81.08286634 | 2022-02-24 04:21:14 | Fayette, West Virginia, US | |
2450252 | 2450252 | 2022-02-22 | US | West Virginia | Fayette | 54019 | 12657 | 172 | 0 | 38.02974928 | -81.08286634 | 2022-02-23 04:21:09 | Fayette, West Virginia, US | |
1313685 | 1313685 | 2021-05-26 | US | West Virginia | Wood | 54107 | 7873 | 172 | 0 | 39.20967886 | -81.5162836 | 2021-05-27 04:20:59 | Wood, West Virginia, US | |
86611 | 86611 | 2021-05-25 | US | West Virginia | Wood | 54107 | 7868 | 172 | 0 | 39.20967886 | -81.5162836 | 2021-05-26 04:20:35 | Wood, West Virginia, US | |
1416524 | 1416524 | 2021-05-24 | US | West Virginia | Cabell | 54011 | 8776 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-25 04:21:08 | Cabell, West Virginia, US | |
1774810 | 1774810 | 2021-05-23 | US | West Virginia | Cabell | 54011 | 8770 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-24 04:20:53 | Cabell, West Virginia, US | |
729965 | 729965 | 2021-05-22 | US | West Virginia | Cabell | 54011 | 8770 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-23 04:20:51 | Cabell, West Virginia, US | |
1955980 | 1955980 | 2021-05-21 | US | West Virginia | Cabell | 54011 | 8770 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-22 04:20:45 | Cabell, West Virginia, US | |
1916679 | 1916679 | 2021-05-20 | US | West Virginia | Cabell | 54011 | 8763 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-21 04:20:43 | Cabell, West Virginia, US | |
2259200 | 2259200 | 2021-05-19 | US | West Virginia | Cabell | 54011 | 8754 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-20 04:21:05 | Cabell, West Virginia, US | |
2394238 | 2394238 | 2021-05-18 | US | West Virginia | Cabell | 54011 | 8748 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-19 04:20:42 | Cabell, West Virginia, US | |
3578063 | 3578063 | 2021-05-17 | US | West Virginia | Cabell | 54011 | 8737 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-18 04:20:33 | Cabell, West Virginia, US | |
2942793 | 2942793 | 2021-05-16 | US | West Virginia | Cabell | 54011 | 8727 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-05-17 04:20:34 | Cabell, West Virginia, US | |
1802104 | 1802104 | 2021-03-23 | US | West Virginia | Cabell | 54011 | 8228 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-03-24 05:25:40 | Cabell, West Virginia, US | |
1207272 | 1207272 | 2021-03-22 | US | West Virginia | Cabell | 54011 | 8207 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-03-23 05:26:18 | Cabell, West Virginia, US | |
3624546 | 3624546 | 2021-03-17 | US | West Virginia | Cabell | 54011 | 8114 | 172 | 0 | 38.42424062 | -82.23855912 | 2021-03-18 05:26:22 | 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]);