johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where country_or_region = "US", deaths = 176 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3725711 | 3725711 | 2022-04-25 | US | West Virginia | Putnam | 54079 | 16736 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-26 04:20:51 | Putnam, West Virginia, US | |
2032279 | 2032279 | 2022-04-24 | US | West Virginia | Putnam | 54079 | 16716 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-25 04:20:56 | Putnam, West Virginia, US | |
749854 | 749854 | 2022-04-23 | US | West Virginia | Putnam | 54079 | 16716 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-24 04:20:56 | Putnam, West Virginia, US | |
3440339 | 3440339 | 2022-04-22 | US | West Virginia | Putnam | 54079 | 16716 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-23 04:20:50 | Putnam, West Virginia, US | |
2895924 | 2895924 | 2022-04-21 | US | West Virginia | Putnam | 54079 | 16703 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-22 04:20:45 | Putnam, West Virginia, US | |
2310796 | 2310796 | 2022-04-20 | US | West Virginia | Putnam | 54079 | 16698 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-21 04:20:46 | Putnam, West Virginia, US | |
2254935 | 2254935 | 2022-04-19 | US | West Virginia | Putnam | 54079 | 16695 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-20 04:20:45 | Putnam, West Virginia, US | |
3871039 | 3871039 | 2022-04-05 | US | West Virginia | Marion | 54049 | 14962 | 176 | 0 | 39.50984542 | -80.24244659 | 2022-04-06 04:20:49 | Marion, West Virginia, US | |
1471594 | 1471594 | 2022-03-24 | US | West Virginia | Marion | 54049 | 14916 | 176 | 0 | 39.50984542 | -80.24244659 | 2022-03-25 04:20:46 | Marion, West Virginia, US | |
1471610 | 1471610 | 2022-03-24 | US | West Virginia | Putnam | 54079 | 16582 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-03-25 04:20:46 | Putnam, West Virginia, US | |
3025768 | 3025768 | 2022-03-23 | US | West Virginia | Marion | 54049 | 14914 | 176 | 0 | 39.50984542 | -80.24244659 | 2022-03-24 04:20:43 | Marion, West Virginia, US | |
3025784 | 3025784 | 2022-03-23 | US | West Virginia | Putnam | 54079 | 16579 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-03-24 04:20:43 | Putnam, West Virginia, US | |
1365853 | 1365853 | 2022-02-08 | US | West Virginia | Monongalia | 54061 | 23230 | 176 | 0 | 39.63218457 | -80.04766838 | 2022-02-09 04:21:04 | Monongalia, West Virginia, US | |
3335050 | 3335050 | 2021-07-21 | US | West Virginia | Wood | 54107 | 7989 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-22 04:21:19 | Wood, West Virginia, US | |
2375031 | 2375031 | 2021-07-20 | US | West Virginia | Wood | 54107 | 7984 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-21 04:21:40 | Wood, West Virginia, US | |
487110 | 487110 | 2021-07-19 | US | West Virginia | Wood | 54107 | 7979 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-20 04:21:48 | Wood, West Virginia, US | |
2677333 | 2677333 | 2021-07-18 | US | West Virginia | Wood | 54107 | 7967 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-19 04:21:24 | Wood, West Virginia, US | |
3709645 | 3709645 | 2021-07-17 | US | West Virginia | Wood | 54107 | 7967 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-18 04:22:07 | Wood, West Virginia, US | |
2950876 | 2950876 | 2021-07-16 | US | West Virginia | Wood | 54107 | 7967 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-17 04:22:22 | Wood, West Virginia, US | |
299532 | 299532 | 2021-07-15 | US | West Virginia | Wood | 54107 | 7967 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-16 04:21:22 | Wood, West Virginia, US | |
3635477 | 3635477 | 2021-07-14 | US | West Virginia | Wood | 54107 | 7967 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-15 04:21:48 | Wood, West Virginia, US | |
582352 | 582352 | 2021-07-13 | US | West Virginia | Wood | 54107 | 7965 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-14 04:21:35 | Wood, West Virginia, US | |
3744601 | 3744601 | 2021-07-12 | US | West Virginia | Wood | 54107 | 7965 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-13 04:21:18 | Wood, West Virginia, US | |
3663114 | 3663114 | 2021-07-11 | US | West Virginia | Wood | 54107 | 7957 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-12 04:21:34 | Wood, West Virginia, US | |
629398 | 629398 | 2021-07-10 | US | West Virginia | Wood | 54107 | 7957 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-11 04:21:43 | Wood, West Virginia, US | |
833117 | 833117 | 2021-07-09 | US | West Virginia | Wood | 54107 | 7957 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-10 04:21:25 | Wood, West Virginia, US | |
781881 | 781881 | 2021-07-08 | US | West Virginia | Wood | 54107 | 7957 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-09 04:21:21 | Wood, West Virginia, US | |
1444103 | 1444103 | 2021-07-07 | US | West Virginia | Wood | 54107 | 7954 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-08 04:21:26 | Wood, West Virginia, US | |
2697208 | 2697208 | 2021-07-06 | US | West Virginia | Wood | 54107 | 7953 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-07 04:21:20 | Wood, West Virginia, US | |
1935957 | 1935957 | 2021-07-05 | US | West Virginia | Wood | 54107 | 7948 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-06 04:21:32 | Wood, West Virginia, US | |
1168688 | 1168688 | 2021-07-04 | US | West Virginia | Wood | 54107 | 7948 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-05 04:21:28 | Wood, West Virginia, US | |
1499122 | 1499122 | 2021-07-03 | US | West Virginia | Wood | 54107 | 7948 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-04 04:21:38 | Wood, West Virginia, US | |
2075437 | 2075437 | 2021-07-02 | US | West Virginia | Wood | 54107 | 7948 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-03 04:21:37 | Wood, West Virginia, US | |
2768453 | 2768453 | 2021-07-01 | US | West Virginia | Wood | 54107 | 7949 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-02 04:21:47 | Wood, West Virginia, US | |
1896661 | 1896661 | 2021-06-30 | US | West Virginia | Wood | 54107 | 7948 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-07-01 04:21:19 | Wood, West Virginia, US | |
403784 | 403784 | 2021-06-29 | US | West Virginia | Wood | 54107 | 7947 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-30 04:21:41 | Wood, West Virginia, US | |
3129027 | 3129027 | 2021-06-28 | US | West Virginia | Wood | 54107 | 7944 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-29 04:21:28 | Wood, West Virginia, US | |
2593522 | 2593522 | 2021-06-27 | US | West Virginia | Wood | 54107 | 7944 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-28 04:21:29 | Wood, West Virginia, US | |
3962026 | 3962026 | 2021-06-26 | US | West Virginia | Wood | 54107 | 7944 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-27 04:21:39 | Wood, West Virginia, US | |
1715845 | 1715845 | 2021-06-25 | US | West Virginia | Wood | 54107 | 7944 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-26 04:21:43 | Wood, West Virginia, US | |
2298970 | 2298970 | 2021-06-24 | US | West Virginia | Wood | 54107 | 7943 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-25 04:21:33 | Wood, West Virginia, US | |
2426409 | 2426409 | 2021-06-23 | US | West Virginia | Wood | 54107 | 7936 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-24 04:21:55 | Wood, West Virginia, US | |
566486 | 566486 | 2021-06-22 | US | West Virginia | Wood | 54107 | 7930 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-23 04:21:46 | Wood, West Virginia, US | |
3362188 | 3362188 | 2021-06-21 | US | West Virginia | Wood | 54107 | 7925 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-22 04:21:34 | Wood, West Virginia, US | |
2887887 | 2887887 | 2021-06-20 | US | West Virginia | Wood | 54107 | 7925 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-21 04:21:41 | Wood, West Virginia, US | |
110970 | 110970 | 2021-06-19 | US | West Virginia | Wood | 54107 | 7925 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-20 04:21:48 | Wood, West Virginia, US | |
1129113 | 1129113 | 2021-06-18 | US | West Virginia | Wood | 54107 | 7925 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-19 04:22:33 | Wood, West Virginia, US | |
2914691 | 2914691 | 2021-06-17 | US | West Virginia | Wood | 54107 | 7925 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-18 04:22:16 | Wood, West Virginia, US | |
3033807 | 3033807 | 2021-06-16 | US | West Virginia | Wood | 54107 | 7923 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-17 04:22:36 | Wood, West Virginia, US | |
2342913 | 2342913 | 2021-06-15 | US | West Virginia | Wood | 54107 | 7922 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-16 04:22:32 | Wood, West Virginia, US | |
1567609 | 1567609 | 2021-06-14 | US | West Virginia | Wood | 54107 | 7921 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-15 04:22:22 | Wood, West Virginia, US | |
3384892 | 3384892 | 2021-06-13 | US | West Virginia | Wood | 54107 | 7918 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-14 04:22:46 | Wood, West Virginia, US | |
1740026 | 1740026 | 2021-06-12 | US | West Virginia | Wood | 54107 | 7918 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-13 04:22:44 | Wood, West Virginia, US | |
3974067 | 3974067 | 2021-06-11 | US | West Virginia | Wood | 54107 | 7918 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-12 04:22:22 | Wood, West Virginia, US | |
2720489 | 2720489 | 2021-06-10 | US | West Virginia | Wood | 54107 | 7917 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-11 04:23:20 | Wood, West Virginia, US | |
526374 | 526374 | 2021-06-09 | US | West Virginia | Wood | 54107 | 7912 | 176 | 0 | 39.20967886 | -81.5162836 | 2021-06-10 04:23:17 | Wood, West Virginia, US | |
3006772 | 3006772 | 2021-04-06 | US | West Virginia | Cabell | 54011 | 8473 | 176 | 0 | 38.42424062 | -82.23855912 | 2021-04-07 04:20:53 | Cabell, West Virginia, US | |
2131470 | 2131470 | 2020-12-17 | US | West Virginia | Kanawha | 54039 | 7412 | 176 | 0 | 7236 | 38.33860077 | -81.52857054 | 2020-12-18 05:28:18 | 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]);