johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
267 rows where country_or_region = "US", deaths = 47 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756421 | 2756421 | 2022-12-29 | US | West Virginia | Roane | 54087 | 4361 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-30 04:21:04 | Roane, West Virginia, US | |
1077427 | 1077427 | 2022-12-28 | US | West Virginia | Roane | 54087 | 4357 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-29 04:21:01 | Roane, West Virginia, US | |
331424 | 331424 | 2022-12-27 | US | West Virginia | Roane | 54087 | 4354 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-28 04:21:04 | Roane, West Virginia, US | |
221497 | 221497 | 2022-12-26 | US | West Virginia | Roane | 54087 | 4339 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-27 04:21:07 | Roane, West Virginia, US | |
3225954 | 3225954 | 2022-12-25 | US | West Virginia | Roane | 54087 | 4339 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-26 04:21:06 | Roane, West Virginia, US | |
1021868 | 1021868 | 2022-12-24 | US | West Virginia | Roane | 54087 | 4339 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-25 04:21:04 | Roane, West Virginia, US | |
693891 | 693891 | 2022-12-23 | US | West Virginia | Roane | 54087 | 4339 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-24 04:21:02 | Roane, West Virginia, US | |
2183101 | 2183101 | 2022-12-22 | US | West Virginia | Roane | 54087 | 4339 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-23 04:21:04 | Roane, West Virginia, US | |
454905 | 454905 | 2022-12-21 | US | West Virginia | Roane | 54087 | 4334 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-22 04:20:56 | Roane, West Virginia, US | |
2954904 | 2954904 | 2022-12-20 | US | West Virginia | Roane | 54087 | 4329 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-21 04:21:03 | Roane, West Virginia, US | |
3177306 | 3177306 | 2022-12-19 | US | West Virginia | Roane | 54087 | 4314 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-20 04:21:04 | Roane, West Virginia, US | |
1631823 | 1631823 | 2022-12-18 | US | West Virginia | Roane | 54087 | 4303 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-19 04:21:03 | Roane, West Virginia, US | |
507202 | 507202 | 2022-12-17 | US | West Virginia | Roane | 54087 | 4303 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-18 04:21:03 | Roane, West Virginia, US | |
3327774 | 3327774 | 2022-12-16 | US | West Virginia | Roane | 54087 | 4303 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-17 04:21:04 | Roane, West Virginia, US | |
546286 | 546286 | 2022-12-15 | US | West Virginia | Roane | 54087 | 4301 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-16 04:21:01 | Roane, West Virginia, US | |
351814 | 351814 | 2022-12-14 | US | West Virginia | Roane | 54087 | 4298 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-15 04:20:58 | Roane, West Virginia, US | |
311402 | 311402 | 2022-12-13 | US | West Virginia | Roane | 54087 | 4292 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-14 04:21:04 | Roane, West Virginia, US | |
1152463 | 1152463 | 2022-12-12 | US | West Virginia | Roane | 54087 | 4288 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-13 04:21:01 | Roane, West Virginia, US | |
872317 | 872317 | 2022-12-11 | US | West Virginia | Roane | 54087 | 4282 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-12 04:21:01 | Roane, West Virginia, US | |
260847 | 260847 | 2022-12-10 | US | West Virginia | Roane | 54087 | 4282 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-11 04:20:50 | Roane, West Virginia, US | |
3939561 | 3939561 | 2022-12-09 | US | West Virginia | Roane | 54087 | 4282 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-10 04:21:02 | Roane, West Virginia, US | |
3380893 | 3380893 | 2022-12-08 | US | West Virginia | Roane | 54087 | 4272 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-09 04:21:05 | Roane, West Virginia, US | |
1988164 | 1988164 | 2022-12-07 | US | West Virginia | Roane | 54087 | 4267 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-08 04:21:07 | Roane, West Virginia, US | |
3717687 | 3717687 | 2022-12-06 | US | West Virginia | Roane | 54087 | 4262 | 47 | 0 | 38.71622686 | -81.35243568 | 2022-12-07 04:20:58 | Roane, West Virginia, US | |
1164671 | 1164671 | 2022-08-18 | US | West Virginia | Monroe | 54063 | 4931 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-19 04:20:54 | Monroe, West Virginia, US | |
3953995 | 3953995 | 2022-08-17 | US | West Virginia | Monroe | 54063 | 4908 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-18 04:21:11 | Monroe, West Virginia, US | |
994473 | 994473 | 2022-08-16 | US | West Virginia | Clay | 54015 | 2540 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-17 04:20:59 | Clay, West Virginia, US | |
994497 | 994497 | 2022-08-16 | US | West Virginia | Monroe | 54063 | 4900 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-17 04:20:59 | Monroe, West Virginia, US | |
2497512 | 2497512 | 2022-08-15 | US | West Virginia | Clay | 54015 | 2538 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-16 04:20:58 | Clay, West Virginia, US | |
2497536 | 2497536 | 2022-08-15 | US | West Virginia | Monroe | 54063 | 4887 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-16 04:20:58 | Monroe, West Virginia, US | |
3651062 | 3651062 | 2022-08-14 | US | West Virginia | Clay | 54015 | 2530 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-15 04:20:59 | Clay, West Virginia, US | |
3651086 | 3651086 | 2022-08-14 | US | West Virginia | Monroe | 54063 | 4862 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-15 04:20:59 | Monroe, West Virginia, US | |
1972068 | 1972068 | 2022-08-13 | US | West Virginia | Clay | 54015 | 2530 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-14 04:20:55 | Clay, West Virginia, US | |
1972092 | 1972092 | 2022-08-13 | US | West Virginia | Monroe | 54063 | 4862 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-14 04:20:55 | Monroe, West Virginia, US | |
2891877 | 2891877 | 2022-08-12 | US | West Virginia | Clay | 54015 | 2530 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-13 04:20:52 | Clay, West Virginia, US | |
2891901 | 2891901 | 2022-08-12 | US | West Virginia | Monroe | 54063 | 4862 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-13 04:20:52 | Monroe, West Virginia, US | |
3911482 | 3911482 | 2022-08-11 | US | West Virginia | Clay | 54015 | 2525 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-12 04:20:54 | Clay, West Virginia, US | |
3911506 | 3911506 | 2022-08-11 | US | West Virginia | Monroe | 54063 | 4858 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-12 04:20:54 | Monroe, West Virginia, US | |
1349799 | 1349799 | 2022-08-10 | US | West Virginia | Clay | 54015 | 2521 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-11 04:20:49 | Clay, West Virginia, US | |
1349823 | 1349823 | 2022-08-10 | US | West Virginia | Monroe | 54063 | 4848 | 47 | 0 | 37.56274716 | -80.54577965 | 2022-08-11 04:20:49 | Monroe, West Virginia, US | |
1089550 | 1089550 | 2022-08-09 | US | West Virginia | Braxton | 54007 | 4511 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-10 04:20:57 | Braxton, West Virginia, US | |
1089554 | 1089554 | 2022-08-09 | US | West Virginia | Clay | 54015 | 2519 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-10 04:20:57 | Clay, West Virginia, US | |
3546965 | 3546965 | 2022-08-08 | US | West Virginia | Braxton | 54007 | 4500 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-09 04:20:34 | Braxton, West Virginia, US | |
3546969 | 3546969 | 2022-08-08 | US | West Virginia | Clay | 54015 | 2511 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-09 04:20:34 | Clay, West Virginia, US | |
1073368 | 1073368 | 2022-08-07 | US | West Virginia | Braxton | 54007 | 4487 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-08 04:21:08 | Braxton, West Virginia, US | |
1073372 | 1073372 | 2022-08-07 | US | West Virginia | Clay | 54015 | 2506 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-08 04:21:08 | Clay, West Virginia, US | |
1943956 | 1943956 | 2022-08-06 | US | West Virginia | Braxton | 54007 | 4487 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-07 04:20:54 | Braxton, West Virginia, US | |
1943960 | 1943960 | 2022-08-06 | US | West Virginia | Clay | 54015 | 2506 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-07 04:20:54 | Clay, West Virginia, US | |
883755 | 883755 | 2022-08-05 | US | West Virginia | Braxton | 54007 | 4487 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-06 04:20:56 | Braxton, West Virginia, US | |
883759 | 883759 | 2022-08-05 | US | West Virginia | Clay | 54015 | 2506 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-06 04:20:56 | Clay, West Virginia, US | |
2012166 | 2012166 | 2022-08-04 | US | West Virginia | Braxton | 54007 | 4481 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-05 04:20:52 | Braxton, West Virginia, US | |
2012170 | 2012170 | 2022-08-04 | US | West Virginia | Clay | 54015 | 2502 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-05 04:20:52 | Clay, West Virginia, US | |
1101593 | 1101593 | 2022-08-03 | US | West Virginia | Braxton | 54007 | 4470 | 47 | 0 | 38.70036159 | -80.72011184 | 2022-08-04 04:20:58 | Braxton, West Virginia, US | |
1101597 | 1101597 | 2022-08-03 | US | West Virginia | Clay | 54015 | 2498 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-04 04:20:58 | Clay, West Virginia, US | |
1408522 | 1408522 | 2022-08-02 | US | West Virginia | Clay | 54015 | 2497 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-03 04:20:59 | Clay, West Virginia, US | |
3620560 | 3620560 | 2022-08-01 | US | West Virginia | Clay | 54015 | 2495 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-02 04:20:53 | Clay, West Virginia, US | |
3875040 | 3875040 | 2022-07-31 | US | West Virginia | Clay | 54015 | 2486 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-01 04:21:03 | Clay, West Virginia, US | |
677794 | 677794 | 2022-07-30 | US | West Virginia | Clay | 54015 | 2486 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-31 04:21:02 | Clay, West Virginia, US | |
1786993 | 1786993 | 2022-07-29 | US | West Virginia | Clay | 54015 | 2486 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-30 04:20:42 | Clay, West Virginia, US | |
1069356 | 1069356 | 2022-07-28 | US | West Virginia | Clay | 54015 | 2486 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-29 04:20:45 | Clay, West Virginia, US | |
2338875 | 2338875 | 2022-07-27 | US | West Virginia | Clay | 54015 | 2484 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-28 04:20:56 | Clay, West Virginia, US | |
1491065 | 1491065 | 2022-07-26 | US | West Virginia | Clay | 54015 | 2479 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-27 04:21:04 | Clay, West Virginia, US | |
2597511 | 2597511 | 2022-07-25 | US | West Virginia | Clay | 54015 | 2477 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-26 04:20:58 | Clay, West Virginia, US | |
899626 | 899626 | 2022-07-24 | US | West Virginia | Clay | 54015 | 2472 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-25 04:20:51 | Clay, West Virginia, US | |
94620 | 94620 | 2022-07-23 | US | West Virginia | Clay | 54015 | 2472 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-24 04:20:47 | Clay, West Virginia, US | |
903642 | 903642 | 2022-07-22 | US | West Virginia | Clay | 54015 | 2472 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-23 04:20:53 | Clay, West Virginia, US | |
673778 | 673778 | 2022-07-21 | US | West Virginia | Clay | 54015 | 2471 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-22 04:21:15 | Clay, West Virginia, US | |
1611741 | 1611741 | 2022-07-20 | US | West Virginia | Clay | 54015 | 2466 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-21 04:21:10 | Clay, West Virginia, US | |
962374 | 962374 | 2022-07-19 | US | West Virginia | Clay | 54015 | 2462 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-20 04:20:59 | Clay, West Virginia, US | |
3213761 | 3213761 | 2022-07-18 | US | West Virginia | Clay | 54015 | 2460 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-19 04:20:58 | Clay, West Virginia, US | |
3408936 | 3408936 | 2022-07-17 | US | West Virginia | Clay | 54015 | 2454 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-18 04:20:59 | Clay, West Virginia, US | |
2155136 | 2155136 | 2022-07-16 | US | West Virginia | Clay | 54015 | 2454 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-17 04:21:15 | Clay, West Virginia, US | |
2422369 | 2422369 | 2022-07-15 | US | West Virginia | Clay | 54015 | 2454 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-16 04:21:05 | Clay, West Virginia, US | |
3432444 | 3432444 | 2022-07-14 | US | West Virginia | Clay | 54015 | 2451 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-15 04:20:53 | Clay, West Virginia, US | |
3112964 | 3112964 | 2022-07-13 | US | West Virginia | Clay | 54015 | 2446 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-14 04:20:57 | Clay, West Virginia, US | |
1996174 | 1996174 | 2022-03-01 | US | West Virginia | Summers | 54089 | 2741 | 47 | 0 | 37.65390597 | -80.86009693 | 2022-03-02 04:21:07 | Summers, West Virginia, US | |
946348 | 946348 | 2022-02-28 | US | West Virginia | Summers | 54089 | 2739 | 47 | 0 | 37.65390597 | -80.86009693 | 2022-03-01 04:21:09 | Summers, West Virginia, US | |
2736539 | 2736539 | 2022-02-27 | US | West Virginia | Summers | 54089 | 2732 | 47 | 0 | 37.65390597 | -80.86009693 | 2022-02-28 04:21:05 | Summers, West Virginia, US | |
3049692 | 3049692 | 2022-02-26 | US | West Virginia | Summers | 54089 | 2732 | 47 | 0 | 37.65390597 | -80.86009693 | 2022-02-27 04:21:04 | Summers, West Virginia, US | |
578347 | 578347 | 2022-02-25 | US | West Virginia | Summers | 54089 | 2732 | 47 | 0 | 37.65390597 | -80.86009693 | 2022-02-26 04:21:12 | Summers, West Virginia, US | |
1514923 | 1514923 | 2022-02-24 | US | West Virginia | Summers | 54089 | 2729 | 47 | 0 | 37.65390597 | -80.86009693 | 2022-02-25 04:21:11 | Summers, West Virginia, US | |
3721671 | 3721671 | 2022-02-21 | US | West Virginia | Hardy | 54031 | 4131 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-22 04:21:01 | Hardy, West Virginia, US | |
3915505 | 3915505 | 2022-02-20 | US | West Virginia | Hardy | 54031 | 4122 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-21 04:21:05 | Hardy, West Virginia, US | |
3879063 | 3879063 | 2022-02-19 | US | West Virginia | Hardy | 54031 | 4122 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-20 04:21:00 | Hardy, West Virginia, US | |
3859319 | 3859319 | 2022-02-18 | US | West Virginia | Hardy | 54031 | 4122 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-19 04:21:11 | Hardy, West Virginia, US | |
1301538 | 1301538 | 2022-02-17 | US | West Virginia | Hardy | 54031 | 4115 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-18 04:21:04 | Hardy, West Virginia, US | |
3823924 | 3823924 | 2022-02-16 | US | West Virginia | Hardy | 54031 | 4106 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-17 04:20:56 | Hardy, West Virginia, US | |
3675138 | 3675138 | 2022-02-15 | US | West Virginia | Hardy | 54031 | 4101 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-16 04:21:10 | Hardy, West Virginia, US | |
2645239 | 2645239 | 2022-02-14 | US | West Virginia | Hardy | 54031 | 4101 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-15 04:21:09 | Hardy, West Virginia, US | |
189556 | 189556 | 2022-02-13 | US | West Virginia | Hardy | 54031 | 4099 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-14 04:20:51 | Hardy, West Virginia, US | |
319402 | 319402 | 2022-02-12 | US | West Virginia | Hardy | 54031 | 4094 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-13 04:21:00 | Hardy, West Virginia, US | |
236728 | 236728 | 2022-02-11 | US | West Virginia | Hardy | 54031 | 4085 | 47 | 0 | 39.00683177 | -78.85855301 | 2022-02-12 04:21:06 | Hardy, West Virginia, US | |
1663941 | 1663941 | 2021-12-12 | US | West Virginia | Taylor | 54091 | 2736 | 47 | 0 | 39.33602617 | -80.0421439 | 2021-12-13 04:22:02 | Taylor, West Virginia, US | |
1667957 | 1667957 | 2021-12-11 | US | West Virginia | Taylor | 54091 | 2723 | 47 | 0 | 39.33602617 | -80.0421439 | 2021-12-12 04:22:12 | Taylor, West Virginia, US | |
3659109 | 3659109 | 2021-12-10 | US | West Virginia | Taylor | 54091 | 2715 | 47 | 0 | 39.33602617 | -80.0421439 | 2021-12-11 04:22:45 | Taylor, West Virginia, US | |
1081440 | 1081440 | 2021-12-09 | US | West Virginia | Taylor | 54091 | 2704 | 47 | 0 | 39.33602617 | -80.0421439 | 2021-12-10 04:22:28 | Taylor, West Virginia, US | |
2290927 | 2290927 | 2021-11-15 | US | West Virginia | Barbour | 54001 | 2871 | 47 | 0 | 39.1307219 | -80.00350858 | 2021-11-16 04:21:10 | Barbour, West Virginia, US | |
1325733 | 1325733 | 2021-11-14 | US | West Virginia | Morgan | 54065 | 2203 | 47 | 0 | 39.55439028 | -78.26311676 | 2021-11-15 04:21:36 | Morgan, West Virginia, US | |
689859 | 689859 | 2021-11-13 | US | West Virginia | Morgan | 54065 | 2197 | 47 | 0 | 39.55439028 | -78.26311676 | 2021-11-14 04:21:31 | Morgan, West Virginia, US | |
717968 | 717968 | 2021-11-12 | US | West Virginia | Morgan | 54065 | 2185 | 47 | 0 | 39.55439028 | -78.26311676 | 2021-11-13 04:21:38 | Morgan, 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]);