johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where country_or_region = "US", deaths = 207 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
872304 | 872304 | 2022-12-11 | US | West Virginia | Monongalia | 54061 | 30329 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-12 04:21:01 | Monongalia, West Virginia, US | |
872313 | 872313 | 2022-12-11 | US | West Virginia | Putnam | 54079 | 20207 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-12 04:21:01 | Putnam, West Virginia, US | |
260834 | 260834 | 2022-12-10 | US | West Virginia | Monongalia | 54061 | 30329 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-11 04:20:50 | Monongalia, West Virginia, US | |
260843 | 260843 | 2022-12-10 | US | West Virginia | Putnam | 54079 | 20207 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-11 04:20:50 | Putnam, West Virginia, US | |
3939548 | 3939548 | 2022-12-09 | US | West Virginia | Monongalia | 54061 | 30329 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-10 04:21:02 | Monongalia, West Virginia, US | |
3939557 | 3939557 | 2022-12-09 | US | West Virginia | Putnam | 54079 | 20207 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-10 04:21:02 | Putnam, West Virginia, US | |
3380880 | 3380880 | 2022-12-08 | US | West Virginia | Monongalia | 54061 | 30320 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-09 04:21:05 | Monongalia, West Virginia, US | |
3380889 | 3380889 | 2022-12-08 | US | West Virginia | Putnam | 54079 | 20193 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-09 04:21:05 | Putnam, West Virginia, US | |
1988151 | 1988151 | 2022-12-07 | US | West Virginia | Monongalia | 54061 | 30303 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-08 04:21:07 | Monongalia, West Virginia, US | |
1988160 | 1988160 | 2022-12-07 | US | West Virginia | Putnam | 54079 | 20188 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-08 04:21:07 | Putnam, West Virginia, US | |
3717674 | 3717674 | 2022-12-06 | US | West Virginia | Monongalia | 54061 | 30287 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-07 04:20:58 | Monongalia, West Virginia, US | |
3717683 | 3717683 | 2022-12-06 | US | West Virginia | Putnam | 54079 | 20179 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-07 04:20:58 | Putnam, West Virginia, US | |
2418379 | 2418379 | 2022-12-05 | US | West Virginia | Monongalia | 54061 | 30272 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-06 04:21:03 | Monongalia, West Virginia, US | |
2418388 | 2418388 | 2022-12-05 | US | West Virginia | Putnam | 54079 | 20167 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-06 04:21:03 | Putnam, West Virginia, US | |
721987 | 721987 | 2022-12-04 | US | West Virginia | Monongalia | 54061 | 30240 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-05 04:20:58 | Monongalia, West Virginia, US | |
721996 | 721996 | 2022-12-04 | US | West Virginia | Putnam | 54079 | 20148 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-05 04:20:58 | Putnam, West Virginia, US | |
2820276 | 2820276 | 2022-12-03 | US | West Virginia | Monongalia | 54061 | 30240 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-04 04:20:56 | Monongalia, West Virginia, US | |
2820285 | 2820285 | 2022-12-03 | US | West Virginia | Putnam | 54079 | 20148 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-04 04:20:56 | Putnam, West Virginia, US | |
837132 | 837132 | 2022-12-02 | US | West Virginia | Monongalia | 54061 | 30240 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-03 04:21:02 | Monongalia, West Virginia, US | |
837141 | 837141 | 2022-12-02 | US | West Virginia | Putnam | 54079 | 20148 | 207 | 0 | 38.50782345 | -81.9082131 | 2022-12-03 04:21:02 | Putnam, West Virginia, US | |
2139662 | 2139662 | 2022-12-01 | US | West Virginia | Monongalia | 54061 | 30224 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-02 04:21:07 | Monongalia, West Virginia, US | |
1968078 | 1968078 | 2022-11-30 | US | West Virginia | Monongalia | 54061 | 30205 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-12-01 04:21:03 | Monongalia, West Virginia, US | |
2560092 | 2560092 | 2022-11-29 | US | West Virginia | Monongalia | 54061 | 30190 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-30 04:21:07 | Monongalia, West Virginia, US | |
1243166 | 1243166 | 2022-11-28 | US | West Virginia | Monongalia | 54061 | 30171 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-29 04:21:05 | Monongalia, West Virginia, US | |
3555154 | 3555154 | 2022-11-27 | US | West Virginia | Monongalia | 54061 | 30118 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-28 04:21:02 | Monongalia, West Virginia, US | |
2103634 | 2103634 | 2022-11-26 | US | West Virginia | Monongalia | 54061 | 30118 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-27 04:21:05 | Monongalia, West Virginia, US | |
491125 | 491125 | 2022-11-25 | US | West Virginia | Monongalia | 54061 | 30118 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-26 04:21:11 | Monongalia, West Virginia, US | |
3526954 | 3526954 | 2022-11-24 | US | West Virginia | Monongalia | 54061 | 30118 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-25 04:21:06 | Monongalia, West Virginia, US | |
3315737 | 3315737 | 2022-11-23 | US | West Virginia | Monongalia | 54061 | 30118 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-24 04:21:09 | Monongalia, West Virginia, US | |
1623778 | 1623778 | 2022-11-22 | US | West Virginia | Monongalia | 54061 | 30103 | 207 | 0 | 39.63218457 | -80.04766838 | 2022-11-23 04:21:06 | Monongalia, West Virginia, US | |
2982738 | 2982738 | 2022-06-13 | US | West Virginia | Fayette | 54019 | 13631 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-14 04:20:52 | Fayette, West Virginia, US | |
2238864 | 2238864 | 2022-06-12 | US | West Virginia | Fayette | 54019 | 13595 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-13 04:21:14 | Fayette, West Virginia, US | |
3145062 | 3145062 | 2022-06-11 | US | West Virginia | Fayette | 54019 | 13595 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-12 04:20:53 | Fayette, West Virginia, US | |
1947978 | 1947978 | 2022-06-10 | US | West Virginia | Fayette | 54019 | 13595 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-11 04:21:01 | Fayette, West Virginia, US | |
3161117 | 3161117 | 2022-06-09 | US | West Virginia | Fayette | 54019 | 13589 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-10 04:20:55 | Fayette, West Virginia, US | |
1424584 | 1424584 | 2022-06-08 | US | West Virginia | Fayette | 54019 | 13576 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-09 04:20:54 | Fayette, West Virginia, US | |
3729698 | 3729698 | 2022-06-07 | US | West Virginia | Fayette | 54019 | 13567 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-08 04:20:55 | Fayette, West Virginia, US | |
3891100 | 3891100 | 2022-06-06 | US | West Virginia | Fayette | 54019 | 13561 | 207 | 0 | 38.02974928 | -81.08286634 | 2022-06-07 04:21:08 | Fayette, West Virginia, US | |
3690967 | 3690967 | 2022-01-13 | US | West Virginia | Harrison | 54033 | 14805 | 207 | 0 | 39.2853852 | -80.37919577 | 2022-01-14 04:21:54 | Harrison, West Virginia, US | |
2776501 | 2776501 | 2021-09-30 | US | West Virginia | Wood | 54107 | 11735 | 207 | 0 | 39.20967886 | -81.5162836 | 2021-10-01 04:21:35 | Wood, West Virginia, US | |
1818247 | 1818247 | 2021-09-19 | US | West Virginia | Cabell | 54011 | 12688 | 207 | 0 | 38.42424062 | -82.23855912 | 2021-09-20 04:21:22 | Cabell, West Virginia, US | |
19827 | 19827 | 2021-09-18 | US | West Virginia | Cabell | 54011 | 12607 | 207 | 0 | 38.42424062 | -82.23855912 | 2021-09-19 04:21:34 | Cabell, West Virginia, US | |
2621512 | 2621512 | 2021-09-17 | US | West Virginia | Cabell | 54011 | 12485 | 207 | 0 | 38.42424062 | -82.23855912 | 2021-09-18 04:21:24 | Cabell, West Virginia, US | |
1140361 | 1140361 | 2021-01-01 | US | West Virginia | Kanawha | 54039 | 8766 | 207 | 0 | 8559 | 38.33860077 | -81.52857054 | 2021-01-02 05:22:33 | 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]);