johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
195 rows where country_or_region = "US", deaths = 52 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756381 | 2756381 | 2022-12-29 | US | West Virginia | Braxton | 54007 | 4918 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-30 04:21:04 | Braxton, West Virginia, US | |
2756393 | 2756393 | 2022-12-29 | US | West Virginia | Hardy | 54031 | 5556 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-30 04:21:04 | Hardy, West Virginia, US | |
1077387 | 1077387 | 2022-12-28 | US | West Virginia | Braxton | 54007 | 4916 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-29 04:21:01 | Braxton, West Virginia, US | |
1077399 | 1077399 | 2022-12-28 | US | West Virginia | Hardy | 54031 | 5544 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-29 04:21:01 | Hardy, West Virginia, US | |
331384 | 331384 | 2022-12-27 | US | West Virginia | Braxton | 54007 | 4913 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-28 04:21:04 | Braxton, West Virginia, US | |
331396 | 331396 | 2022-12-27 | US | West Virginia | Hardy | 54031 | 5536 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-28 04:21:04 | Hardy, West Virginia, US | |
221457 | 221457 | 2022-12-26 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-27 04:21:07 | Braxton, West Virginia, US | |
221469 | 221469 | 2022-12-26 | US | West Virginia | Hardy | 54031 | 5524 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-27 04:21:07 | Hardy, West Virginia, US | |
3225914 | 3225914 | 2022-12-25 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-26 04:21:06 | Braxton, West Virginia, US | |
3225926 | 3225926 | 2022-12-25 | US | West Virginia | Hardy | 54031 | 5524 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-26 04:21:06 | Hardy, West Virginia, US | |
1021828 | 1021828 | 2022-12-24 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-25 04:21:04 | Braxton, West Virginia, US | |
1021840 | 1021840 | 2022-12-24 | US | West Virginia | Hardy | 54031 | 5524 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-25 04:21:04 | Hardy, West Virginia, US | |
693851 | 693851 | 2022-12-23 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-24 04:21:02 | Braxton, West Virginia, US | |
693863 | 693863 | 2022-12-23 | US | West Virginia | Hardy | 54031 | 5524 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-24 04:21:02 | Hardy, West Virginia, US | |
2183061 | 2183061 | 2022-12-22 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-23 04:21:04 | Braxton, West Virginia, US | |
2183073 | 2183073 | 2022-12-22 | US | West Virginia | Hardy | 54031 | 5524 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-23 04:21:04 | Hardy, West Virginia, US | |
454865 | 454865 | 2022-12-21 | US | West Virginia | Braxton | 54007 | 4903 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-22 04:20:56 | Braxton, West Virginia, US | |
454877 | 454877 | 2022-12-21 | US | West Virginia | Hardy | 54031 | 5513 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-22 04:20:56 | Hardy, West Virginia, US | |
2954864 | 2954864 | 2022-12-20 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-21 04:21:03 | Braxton, West Virginia, US | |
2954876 | 2954876 | 2022-12-20 | US | West Virginia | Hardy | 54031 | 5503 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-21 04:21:03 | Hardy, West Virginia, US | |
3177266 | 3177266 | 2022-12-19 | US | West Virginia | Braxton | 54007 | 4902 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-20 04:21:04 | Braxton, West Virginia, US | |
3177278 | 3177278 | 2022-12-19 | US | West Virginia | Hardy | 54031 | 5503 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-20 04:21:04 | Hardy, West Virginia, US | |
1631783 | 1631783 | 2022-12-18 | US | West Virginia | Braxton | 54007 | 4894 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-19 04:21:03 | Braxton, West Virginia, US | |
1631795 | 1631795 | 2022-12-18 | US | West Virginia | Hardy | 54031 | 5493 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-19 04:21:03 | Hardy, West Virginia, US | |
507162 | 507162 | 2022-12-17 | US | West Virginia | Braxton | 54007 | 4894 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-18 04:21:03 | Braxton, West Virginia, US | |
507174 | 507174 | 2022-12-17 | US | West Virginia | Hardy | 54031 | 5493 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-18 04:21:03 | Hardy, West Virginia, US | |
3327734 | 3327734 | 2022-12-16 | US | West Virginia | Braxton | 54007 | 4894 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-17 04:21:04 | Braxton, West Virginia, US | |
3327746 | 3327746 | 2022-12-16 | US | West Virginia | Hardy | 54031 | 5493 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-17 04:21:04 | Hardy, West Virginia, US | |
546246 | 546246 | 2022-12-15 | US | West Virginia | Braxton | 54007 | 4894 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-16 04:21:01 | Braxton, West Virginia, US | |
351774 | 351774 | 2022-12-14 | US | West Virginia | Braxton | 54007 | 4889 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-15 04:20:58 | Braxton, West Virginia, US | |
311362 | 311362 | 2022-12-13 | US | West Virginia | Braxton | 54007 | 4886 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-14 04:21:04 | Braxton, West Virginia, US | |
1152423 | 1152423 | 2022-12-12 | US | West Virginia | Braxton | 54007 | 4884 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-13 04:21:01 | Braxton, West Virginia, US | |
872277 | 872277 | 2022-12-11 | US | West Virginia | Braxton | 54007 | 4879 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-12 04:21:01 | Braxton, West Virginia, US | |
260807 | 260807 | 2022-12-10 | US | West Virginia | Braxton | 54007 | 4879 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-11 04:20:50 | Braxton, West Virginia, US | |
3939521 | 3939521 | 2022-12-09 | US | West Virginia | Braxton | 54007 | 4879 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-10 04:21:02 | Braxton, West Virginia, US | |
3380853 | 3380853 | 2022-12-08 | US | West Virginia | Braxton | 54007 | 4878 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-09 04:21:05 | Braxton, West Virginia, US | |
1988124 | 1988124 | 2022-12-07 | US | West Virginia | Braxton | 54007 | 4876 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-08 04:21:07 | Braxton, West Virginia, US | |
3717647 | 3717647 | 2022-12-06 | US | West Virginia | Braxton | 54007 | 4874 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-07 04:20:58 | Braxton, West Virginia, US | |
2418352 | 2418352 | 2022-12-05 | US | West Virginia | Braxton | 54007 | 4870 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-06 04:21:03 | Braxton, West Virginia, US | |
721960 | 721960 | 2022-12-04 | US | West Virginia | Braxton | 54007 | 4870 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-05 04:20:58 | Braxton, West Virginia, US | |
2820249 | 2820249 | 2022-12-03 | US | West Virginia | Braxton | 54007 | 4870 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-04 04:20:56 | Braxton, West Virginia, US | |
837105 | 837105 | 2022-12-02 | US | West Virginia | Braxton | 54007 | 4870 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-03 04:21:02 | Braxton, West Virginia, US | |
2139635 | 2139635 | 2022-12-01 | US | West Virginia | Braxton | 54007 | 4870 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-02 04:21:07 | Braxton, West Virginia, US | |
1643828 | 1643828 | 2022-11-20 | US | West Virginia | Clay | 54015 | 2652 | 52 | 0 | 38.46231092 | -81.07652217 | 2022-11-21 04:21:05 | Clay, West Virginia, US | |
2067385 | 2067385 | 2022-11-19 | US | West Virginia | Clay | 54015 | 2652 | 52 | 0 | 38.46231092 | -81.07652217 | 2022-11-20 04:21:08 | Clay, West Virginia, US | |
1758779 | 1758779 | 2022-11-18 | US | West Virginia | Clay | 54015 | 2652 | 52 | 0 | 38.46231092 | -81.07652217 | 2022-11-19 04:21:14 | Clay, West Virginia, US | |
1849490 | 1849490 | 2022-04-18 | US | West Virginia | Summers | 54089 | 2806 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-19 04:21:00 | Summers, West Virginia, US | |
3420434 | 3420434 | 2022-04-17 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-18 04:21:12 | Summers, West Virginia, US | |
307383 | 307383 | 2022-04-16 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-17 04:20:59 | Summers, West Virginia, US | |
2673328 | 2673328 | 2022-04-15 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-16 04:20:48 | Summers, West Virginia, US | |
1227113 | 1227113 | 2022-04-14 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-15 04:20:57 | Summers, West Virginia, US | |
2446271 | 2446271 | 2022-04-13 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-13 23:21:06 | Summers, West Virginia, US | |
1952028 | 1952028 | 2022-04-12 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-13 04:21:03 | Summers, West Virginia, US | |
3209781 | 3209781 | 2022-04-11 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-12 04:20:49 | Summers, West Virginia, US | |
1579667 | 1579667 | 2022-04-10 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-11 04:21:02 | Summers, West Virginia, US | |
1655909 | 1655909 | 2022-04-09 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-10 04:20:52 | Summers, West Virginia, US | |
2119231 | 2119231 | 2022-04-08 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-09 04:20:42 | Summers, West Virginia, US | |
3323755 | 3323755 | 2022-04-07 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-08 04:20:48 | Summers, West Virginia, US | |
2804291 | 2804291 | 2022-04-06 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-07 04:20:53 | Summers, West Virginia, US | |
3871060 | 3871060 | 2022-04-05 | US | West Virginia | Summers | 54089 | 2805 | 52 | 0 | 37.65390597 | -80.86009693 | 2022-04-06 04:20:49 | Summers, West Virginia, US | |
2645235 | 2645235 | 2022-02-14 | US | West Virginia | Grant | 54023 | 3676 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-15 04:21:09 | Grant, West Virginia, US | |
189552 | 189552 | 2022-02-13 | US | West Virginia | Grant | 54023 | 3671 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-14 04:20:51 | Grant, West Virginia, US | |
319398 | 319398 | 2022-02-12 | US | West Virginia | Grant | 54023 | 3663 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-13 04:21:00 | Grant, West Virginia, US | |
236724 | 236724 | 2022-02-11 | US | West Virginia | Grant | 54023 | 3656 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-12 04:21:06 | Grant, West Virginia, US | |
1467566 | 1467566 | 2022-02-10 | US | West Virginia | Grant | 54023 | 3632 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-11 04:21:09 | Grant, West Virginia, US | |
3077527 | 3077527 | 2022-02-09 | US | West Virginia | Grant | 54023 | 3623 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-10 04:21:14 | Grant, West Virginia, US | |
1365834 | 1365834 | 2022-02-08 | US | West Virginia | Grant | 54023 | 3609 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-09 04:21:04 | Grant, West Virginia, US | |
74572 | 74572 | 2022-02-07 | US | West Virginia | Grant | 54023 | 3600 | 52 | 0 | 39.10314817 | -79.19440518 | 2022-02-08 04:21:15 | Grant, West Virginia, US | |
130248 | 130248 | 2022-01-09 | US | West Virginia | Taylor | 54091 | 3164 | 52 | 0 | 39.33602617 | -80.0421439 | 2022-01-10 04:22:07 | Taylor, West Virginia, US | |
1219083 | 1219083 | 2022-01-08 | US | West Virginia | Taylor | 54091 | 3143 | 52 | 0 | 39.33602617 | -80.0421439 | 2022-01-09 04:21:46 | Taylor, West Virginia, US | |
1393176 | 1393176 | 2022-01-07 | US | West Virginia | Taylor | 54091 | 3110 | 52 | 0 | 39.33602617 | -80.0421439 | 2022-01-08 04:21:53 | Taylor, West Virginia, US | |
3831972 | 3831972 | 2021-12-21 | US | West Virginia | Morgan | 54065 | 2672 | 52 | 0 | 39.55439028 | -78.26311676 | 2021-12-22 04:21:54 | Morgan, West Virginia, US | |
407764 | 407764 | 2021-12-07 | US | West Virginia | Barbour | 54001 | 3036 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-08 04:22:46 | Barbour, West Virginia, US | |
1033846 | 1033846 | 2021-12-06 | US | West Virginia | Barbour | 54001 | 3028 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-07 04:22:34 | Barbour, West Virginia, US | |
1033859 | 1033859 | 2021-12-06 | US | West Virginia | Hampshire | 54027 | 3777 | 52 | 0 | 39.32103553 | -78.60826476 | 2021-12-07 04:22:34 | Hampshire, West Virginia, US | |
1744009 | 1744009 | 2021-12-05 | US | West Virginia | Barbour | 54001 | 3021 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-06 04:22:34 | Barbour, West Virginia, US | |
141441 | 141441 | 2021-12-04 | US | West Virginia | Barbour | 54001 | 3017 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-05 04:22:25 | Barbour, West Virginia, US | |
2199094 | 2199094 | 2021-12-03 | US | West Virginia | Barbour | 54001 | 3013 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-04 04:22:18 | Barbour, West Virginia, US | |
3800 | 3800 | 2021-12-02 | US | West Virginia | Barbour | 54001 | 3004 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-03 04:23:05 | Barbour, West Virginia, US | |
3821 | 3821 | 2021-12-02 | US | West Virginia | Lincoln | 54043 | 3247 | 52 | 0 | 38.172154 | -82.07017953 | 2021-12-03 04:23:05 | Lincoln, West Virginia, US | |
1148399 | 1148399 | 2021-12-01 | US | West Virginia | Barbour | 54001 | 2987 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-02 04:22:37 | Barbour, West Virginia, US | |
1148420 | 1148420 | 2021-12-01 | US | West Virginia | Lincoln | 54043 | 3235 | 52 | 0 | 38.172154 | -82.07017953 | 2021-12-02 04:22:37 | Lincoln, West Virginia, US | |
3404911 | 3404911 | 2021-11-30 | US | West Virginia | Barbour | 54001 | 2968 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-12-01 04:22:29 | Barbour, West Virginia, US | |
153454 | 153454 | 2021-11-29 | US | West Virginia | Barbour | 54001 | 2962 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-30 04:22:53 | Barbour, West Virginia, US | |
1235100 | 1235100 | 2021-11-28 | US | West Virginia | Barbour | 54001 | 2940 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-29 04:22:30 | Barbour, West Virginia, US | |
1235126 | 1235126 | 2021-11-28 | US | West Virginia | McDowell | 54047 | 3124 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-29 04:22:30 | McDowell, West Virginia, US | |
1361807 | 1361807 | 2021-11-27 | US | West Virginia | Barbour | 54001 | 2940 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-28 04:22:43 | Barbour, West Virginia, US | |
1361833 | 1361833 | 2021-11-27 | US | West Virginia | McDowell | 54047 | 3124 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-28 04:22:43 | McDowell, West Virginia, US | |
761798 | 761798 | 2021-11-26 | US | West Virginia | Barbour | 54001 | 2940 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-27 04:22:45 | Barbour, West Virginia, US | |
761824 | 761824 | 2021-11-26 | US | West Virginia | McDowell | 54047 | 3124 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-27 04:22:45 | McDowell, West Virginia, US | |
1806215 | 1806215 | 2021-11-25 | US | West Virginia | Barbour | 54001 | 2940 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-26 04:22:33 | Barbour, West Virginia, US | |
1806241 | 1806241 | 2021-11-25 | US | West Virginia | McDowell | 54047 | 3124 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-26 04:22:33 | McDowell, West Virginia, US | |
907649 | 907649 | 2021-11-24 | US | West Virginia | Barbour | 54001 | 2940 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-25 04:22:33 | Barbour, West Virginia, US | |
907675 | 907675 | 2021-11-24 | US | West Virginia | McDowell | 54047 | 3124 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-25 04:22:33 | McDowell, West Virginia, US | |
3073499 | 3073499 | 2021-11-23 | US | West Virginia | Barbour | 54001 | 2925 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-24 04:22:14 | Barbour, West Virginia, US | |
3752597 | 3752597 | 2021-11-22 | US | West Virginia | Barbour | 54001 | 2924 | 52 | 0 | 39.1307219 | -80.00350858 | 2021-11-23 04:22:39 | Barbour, West Virginia, US | |
3752623 | 3752623 | 2021-11-22 | US | West Virginia | McDowell | 54047 | 3115 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-23 04:22:39 | McDowell, West Virginia, US | |
1017830 | 1017830 | 2021-11-21 | US | West Virginia | McDowell | 54047 | 3105 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-22 04:22:20 | McDowell, West Virginia, US | |
725994 | 725994 | 2021-11-20 | US | West Virginia | McDowell | 54047 | 3096 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-21 04:22:13 | McDowell, West Virginia, US | |
165524 | 165524 | 2021-11-19 | US | West Virginia | McDowell | 54047 | 3077 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-20 04:22:17 | McDowell, 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]);