johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
313 rows where country_or_region = "US", deaths = 41 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
256828 | 256828 | 2022-09-08 | US | West Virginia | Roane | 54087 | 3994 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-09 04:21:11 | Roane, West Virginia, US | |
3748626 | 3748626 | 2022-09-07 | US | West Virginia | Roane | 54087 | 3972 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-08 04:21:02 | Roane, West Virginia, US | |
118266 | 118266 | 2022-09-06 | US | West Virginia | Roane | 54087 | 3956 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-07 04:20:59 | Roane, West Virginia, US | |
2637238 | 2637238 | 2022-09-05 | US | West Virginia | Roane | 54087 | 3895 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-06 04:21:02 | Roane, West Virginia, US | |
2990802 | 2990802 | 2022-09-04 | US | West Virginia | Roane | 54087 | 3895 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-05 04:21:01 | Roane, West Virginia, US | |
2716487 | 2716487 | 2022-09-03 | US | West Virginia | Roane | 54087 | 3895 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-04 04:21:22 | Roane, West Virginia, US | |
1397192 | 1397192 | 2022-09-02 | US | West Virginia | Roane | 54087 | 3895 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-03 04:21:04 | Roane, West Virginia, US | |
3551021 | 3551021 | 2022-09-01 | US | West Virginia | Roane | 54087 | 3881 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-02 04:21:07 | Roane, West Virginia, US | |
2346941 | 2346941 | 2022-08-31 | US | West Virginia | Roane | 54087 | 3873 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-01 04:21:03 | Roane, West Virginia, US | |
3777421 | 3777421 | 2022-08-30 | US | West Virginia | Roane | 54087 | 3864 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-31 04:20:57 | Roane, West Virginia, US | |
1684017 | 1684017 | 2022-08-29 | US | West Virginia | Roane | 54087 | 3854 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-30 04:21:03 | Roane, West Virginia, US | |
1880501 | 1880501 | 2022-08-28 | US | West Virginia | Roane | 54087 | 3840 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-29 04:21:06 | Roane, West Virginia, US | |
2099628 | 2099628 | 2022-08-27 | US | West Virginia | Roane | 54087 | 3840 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-28 04:21:02 | Roane, West Virginia, US | |
1535443 | 1535443 | 2022-08-26 | US | West Virginia | Roane | 54087 | 3840 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-27 04:20:57 | Roane, West Virginia, US | |
2832330 | 2832330 | 2022-08-25 | US | West Virginia | Roane | 54087 | 3835 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-26 04:21:02 | Roane, West Virginia, US | |
2326863 | 2326863 | 2022-08-24 | US | West Virginia | Roane | 54087 | 3829 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-25 04:21:13 | Roane, West Virginia, US | |
1254272 | 1254272 | 2022-08-23 | US | West Virginia | Roane | 54087 | 3826 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-24 04:20:46 | Roane, West Virginia, US | |
2856376 | 2856376 | 2022-08-22 | US | West Virginia | Roane | 54087 | 3821 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-23 04:20:56 | Roane, West Virginia, US | |
2406348 | 2406348 | 2022-08-21 | US | West Virginia | Roane | 54087 | 3813 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-22 04:20:38 | Roane, West Virginia, US | |
3801426 | 3801426 | 2022-08-20 | US | West Virginia | Roane | 54087 | 3813 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-21 04:20:44 | Roane, West Virginia, US | |
2367012 | 2367012 | 2022-08-19 | US | West Virginia | Roane | 54087 | 3813 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-20 04:21:01 | Roane, West Virginia, US | |
1164683 | 1164683 | 2022-08-18 | US | West Virginia | Roane | 54087 | 3803 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-19 04:20:54 | Roane, West Virginia, US | |
3954007 | 3954007 | 2022-08-17 | US | West Virginia | Roane | 54087 | 3800 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-18 04:21:11 | Roane, West Virginia, US | |
994509 | 994509 | 2022-08-16 | US | West Virginia | Roane | 54087 | 3794 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-17 04:20:59 | Roane, West Virginia, US | |
2497548 | 2497548 | 2022-08-15 | US | West Virginia | Roane | 54087 | 3790 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-16 04:20:58 | Roane, West Virginia, US | |
3651098 | 3651098 | 2022-08-14 | US | West Virginia | Roane | 54087 | 3769 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-15 04:20:59 | Roane, West Virginia, US | |
1972104 | 1972104 | 2022-08-13 | US | West Virginia | Roane | 54087 | 3769 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-14 04:20:55 | Roane, West Virginia, US | |
2891913 | 2891913 | 2022-08-12 | US | West Virginia | Roane | 54087 | 3769 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-13 04:20:52 | Roane, West Virginia, US | |
3911518 | 3911518 | 2022-08-11 | US | West Virginia | Roane | 54087 | 3760 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-12 04:20:54 | Roane, West Virginia, US | |
1349835 | 1349835 | 2022-08-10 | US | West Virginia | Roane | 54087 | 3752 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-11 04:20:49 | Roane, West Virginia, US | |
1089590 | 1089590 | 2022-08-09 | US | West Virginia | Roane | 54087 | 3747 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-10 04:20:57 | Roane, West Virginia, US | |
3547005 | 3547005 | 2022-08-08 | US | West Virginia | Roane | 54087 | 3741 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-09 04:20:34 | Roane, West Virginia, US | |
1073408 | 1073408 | 2022-08-07 | US | West Virginia | Roane | 54087 | 3720 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-08 04:21:08 | Roane, West Virginia, US | |
1943996 | 1943996 | 2022-08-06 | US | West Virginia | Roane | 54087 | 3720 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-07 04:20:54 | Roane, West Virginia, US | |
883795 | 883795 | 2022-08-05 | US | West Virginia | Roane | 54087 | 3720 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-06 04:20:56 | Roane, West Virginia, US | |
2012206 | 2012206 | 2022-08-04 | US | West Virginia | Roane | 54087 | 3710 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-05 04:20:52 | Roane, West Virginia, US | |
1101633 | 1101633 | 2022-08-03 | US | West Virginia | Roane | 54087 | 3700 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-04 04:20:58 | Roane, West Virginia, US | |
1408558 | 1408558 | 2022-08-02 | US | West Virginia | Roane | 54087 | 3691 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-03 04:20:59 | Roane, West Virginia, US | |
3620596 | 3620596 | 2022-08-01 | US | West Virginia | Roane | 54087 | 3681 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-02 04:20:53 | Roane, West Virginia, US | |
3875076 | 3875076 | 2022-07-31 | US | West Virginia | Roane | 54087 | 3650 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-08-01 04:21:03 | Roane, West Virginia, US | |
677830 | 677830 | 2022-07-30 | US | West Virginia | Roane | 54087 | 3650 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-07-31 04:21:02 | Roane, West Virginia, US | |
1787029 | 1787029 | 2022-07-29 | US | West Virginia | Roane | 54087 | 3650 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-07-30 04:20:42 | Roane, West Virginia, US | |
1069392 | 1069392 | 2022-07-28 | US | West Virginia | Roane | 54087 | 3645 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-07-29 04:20:45 | Roane, West Virginia, US | |
2051346 | 2051346 | 2022-05-25 | US | West Virginia | Clay | 54015 | 2365 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-26 04:20:50 | Clay, West Virginia, US | |
3002784 | 3002784 | 2022-05-24 | US | West Virginia | Clay | 54015 | 2364 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-25 04:20:56 | Clay, West Virginia, US | |
3596505 | 3596505 | 2022-05-23 | US | West Virginia | Clay | 54015 | 2363 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-24 04:20:57 | Clay, West Virginia, US | |
625357 | 625357 | 2022-05-22 | US | West Virginia | Clay | 54015 | 2365 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-26 04:20:50 | Clay, West Virginia, US | |
1113053 | 1113053 | 2022-05-21 | US | West Virginia | Clay | 54015 | 2358 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-22 04:20:52 | Clay, West Virginia, US | |
1172677 | 1172677 | 2022-05-20 | US | West Virginia | Clay | 54015 | 2358 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-21 04:20:58 | Clay, West Virginia, US | |
3899440 | 3899440 | 2022-05-19 | US | West Virginia | Clay | 54015 | 2357 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-20 04:20:57 | Clay, West Virginia, US | |
1188224 | 1188224 | 2022-05-18 | US | West Virginia | Clay | 54015 | 2354 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-19 04:20:54 | Clay, West Virginia, US | |
3586121 | 3586121 | 2022-05-17 | US | West Virginia | Clay | 54015 | 2354 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-18 04:20:50 | Clay, West Virginia, US | |
1507078 | 1507078 | 2022-05-16 | US | West Virginia | Clay | 54015 | 2354 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-17 04:20:59 | Clay, West Virginia, US | |
2087437 | 2087437 | 2022-05-15 | US | West Virginia | Clay | 54015 | 2351 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-16 04:20:47 | Clay, West Virginia, US | |
3358147 | 3358147 | 2022-05-14 | US | West Virginia | Clay | 54015 | 2351 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-15 04:20:53 | Clay, West Virginia, US | |
661792 | 661792 | 2022-05-13 | US | West Virginia | Clay | 54015 | 2351 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-14 04:20:48 | Clay, West Virginia, US | |
2536875 | 2536875 | 2022-05-12 | US | West Virginia | Clay | 54015 | 2348 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-13 04:20:51 | Clay, West Virginia, US | |
3448321 | 3448321 | 2022-05-11 | US | West Virginia | Clay | 54015 | 2348 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-12 04:20:54 | Clay, West Virginia, US | |
3538938 | 3538938 | 2022-05-10 | US | West Virginia | Clay | 54015 | 2345 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-11 04:20:48 | Clay, West Virginia, US | |
225473 | 225473 | 2022-05-09 | US | West Virginia | Clay | 54015 | 2345 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-10 04:20:50 | Clay, West Virginia, US | |
2334858 | 2334858 | 2022-05-08 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-09 04:20:54 | Clay, West Virginia, US | |
363820 | 363820 | 2022-05-07 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-08 04:20:49 | Clay, West Virginia, US | |
1401171 | 1401171 | 2022-05-06 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-07 04:21:09 | Clay, West Virginia, US | |
2601526 | 2601526 | 2022-05-05 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-06 04:21:00 | Clay, West Virginia, US | |
3268975 | 3268975 | 2022-05-04 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-05 04:20:55 | Clay, West Virginia, US | |
1575614 | 1575614 | 2022-05-03 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-04 04:20:59 | Clay, West Virginia, US | |
466874 | 466874 | 2022-05-02 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-03 04:21:00 | Clay, West Virginia, US | |
3919513 | 3919513 | 2022-05-01 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-02 04:21:10 | Clay, West Virginia, US | |
2844317 | 2844317 | 2022-04-30 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-01 04:20:57 | Clay, West Virginia, US | |
1160630 | 1160630 | 2022-04-29 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-30 04:21:05 | Clay, West Virginia, US | |
1699812 | 1699812 | 2022-04-28 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-29 04:20:59 | Clay, West Virginia, US | |
3855295 | 3855295 | 2022-04-27 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-28 04:20:47 | Clay, West Virginia, US | |
1329725 | 1329725 | 2022-04-26 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-27 04:20:52 | Clay, West Virginia, US | |
3725679 | 3725679 | 2022-04-25 | US | West Virginia | Clay | 54015 | 2343 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-26 04:20:51 | Clay, West Virginia, US | |
2032247 | 2032247 | 2022-04-24 | US | West Virginia | Clay | 54015 | 2340 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-25 04:20:56 | Clay, West Virginia, US | |
749822 | 749822 | 2022-04-23 | US | West Virginia | Clay | 54015 | 2340 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-24 04:20:56 | Clay, West Virginia, US | |
3440307 | 3440307 | 2022-04-22 | US | West Virginia | Clay | 54015 | 2340 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-23 04:20:50 | Clay, West Virginia, US | |
2895892 | 2895892 | 2022-04-21 | US | West Virginia | Clay | 54015 | 2340 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-22 04:20:45 | Clay, West Virginia, US | |
2310764 | 2310764 | 2022-04-20 | US | West Virginia | Clay | 54015 | 2340 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-21 04:20:46 | Clay, West Virginia, US | |
2254903 | 2254903 | 2022-04-19 | US | West Virginia | Clay | 54015 | 2340 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-20 04:20:45 | Clay, West Virginia, US | |
2752365 | 2752365 | 2022-04-04 | US | West Virginia | Clay | 54015 | 2341 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-05 04:20:48 | Clay, West Virginia, US | |
3733711 | 3733711 | 2022-04-03 | US | West Virginia | Clay | 54015 | 2339 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-04 04:20:51 | Clay, West Virginia, US | |
503146 | 503146 | 2022-04-02 | US | West Virginia | Clay | 54015 | 2339 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-03 04:20:48 | Clay, West Virginia, US | |
3354131 | 3354131 | 2022-04-01 | US | West Virginia | Clay | 54015 | 2339 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-02 04:20:47 | Clay, West Virginia, US | |
1543436 | 1543436 | 2022-03-31 | US | West Virginia | Clay | 54015 | 2339 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-01 04:20:28 | Clay, West Virginia, US | |
2267393 | 2267393 | 2022-03-14 | US | West Virginia | Monroe | 54063 | 4167 | 41 | 0 | 37.56274716 | -80.54577965 | 2022-03-15 04:20:47 | Monroe, West Virginia, US | |
3631459 | 3631459 | 2022-03-13 | US | West Virginia | Monroe | 54063 | 4166 | 41 | 0 | 37.56274716 | -80.54577965 | 2022-03-14 04:20:46 | Monroe, West Virginia, US | |
954367 | 954367 | 2022-03-12 | US | West Virginia | Monroe | 54063 | 4166 | 41 | 0 | 37.56274716 | -80.54577965 | 2022-03-13 04:20:49 | Monroe, West Virginia, US | |
359828 | 359828 | 2022-03-11 | US | West Virginia | Monroe | 54063 | 4166 | 41 | 0 | 37.56274716 | -80.54577965 | 2022-03-12 04:20:50 | Monroe, West Virginia, US | |
1868980 | 1868980 | 2022-03-10 | US | West Virginia | Monroe | 54063 | 4164 | 41 | 0 | 37.56274716 | -80.54577965 | 2022-03-11 04:20:50 | Monroe, West Virginia, US | |
2143675 | 2143675 | 2022-03-09 | US | West Virginia | Monroe | 54063 | 4160 | 41 | 0 | 37.56274716 | -80.54577965 | 2022-03-10 04:20:48 | Monroe, West Virginia, US | |
1996133 | 1996133 | 2022-03-01 | US | West Virginia | Braxton | 54007 | 3769 | 41 | 0 | 38.70036159 | -80.72011184 | 2022-03-02 04:21:07 | Braxton, West Virginia, US | |
946307 | 946307 | 2022-02-28 | US | West Virginia | Braxton | 54007 | 3717 | 41 | 0 | 38.70036159 | -80.72011184 | 2022-03-01 04:21:09 | Braxton, West Virginia, US | |
2736498 | 2736498 | 2022-02-27 | US | West Virginia | Braxton | 54007 | 3699 | 41 | 0 | 38.70036159 | -80.72011184 | 2022-02-28 04:21:05 | Braxton, West Virginia, US | |
3049651 | 3049651 | 2022-02-26 | US | West Virginia | Braxton | 54007 | 3699 | 41 | 0 | 38.70036159 | -80.72011184 | 2022-02-27 04:21:04 | Braxton, West Virginia, US | |
578306 | 578306 | 2022-02-25 | US | West Virginia | Braxton | 54007 | 3699 | 41 | 0 | 38.70036159 | -80.72011184 | 2022-02-26 04:21:12 | Braxton, West Virginia, US | |
558275 | 558275 | 2022-01-16 | US | West Virginia | Hardy | 54031 | 3507 | 41 | 0 | 39.00683177 | -78.85855301 | 2022-01-17 04:21:08 | Hardy, West Virginia, US | |
3843996 | 3843996 | 2022-01-15 | US | West Virginia | Hardy | 54031 | 3478 | 41 | 0 | 39.00683177 | -78.85855301 | 2022-01-16 04:21:12 | Hardy, West Virginia, US | |
102811 | 102811 | 2022-01-14 | US | West Virginia | Hardy | 54031 | 3439 | 41 | 0 | 39.00683177 | -78.85855301 | 2022-01-15 04:21:07 | Hardy, West Virginia, US | |
3690966 | 3690966 | 2022-01-13 | US | West Virginia | Hardy | 54031 | 3406 | 41 | 0 | 39.00683177 | -78.85855301 | 2022-01-14 04:21:54 | Hardy, 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]);