johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
206 rows where country_or_region = "US", deaths = 40 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2338911 | 2338911 | 2022-07-27 | US | West Virginia | Roane | 54087 | 3639 | 40 | 0 | 38.71622686 | -81.35243568 | 2022-07-28 04:20:56 | Roane, West Virginia, US | |
1491101 | 1491101 | 2022-07-26 | US | West Virginia | Roane | 54087 | 3635 | 40 | 0 | 38.71622686 | -81.35243568 | 2022-07-27 04:21:04 | Roane, West Virginia, US | |
1849453 | 1849453 | 2022-04-18 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-19 04:21:00 | Clay, West Virginia, US | |
3420397 | 3420397 | 2022-04-17 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-18 04:21:12 | Clay, West Virginia, US | |
307346 | 307346 | 2022-04-16 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-17 04:20:59 | Clay, West Virginia, US | |
2673291 | 2673291 | 2022-04-15 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-16 04:20:48 | Clay, West Virginia, US | |
1227076 | 1227076 | 2022-04-14 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-15 04:20:57 | Clay, West Virginia, US | |
2446234 | 2446234 | 2022-04-13 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-13 23:21:06 | Clay, West Virginia, US | |
1951991 | 1951991 | 2022-04-12 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-13 04:21:03 | Clay, West Virginia, US | |
3209744 | 3209744 | 2022-04-11 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-12 04:20:49 | Clay, West Virginia, US | |
1579630 | 1579630 | 2022-04-10 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-11 04:21:02 | Clay, West Virginia, US | |
1655872 | 1655872 | 2022-04-09 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-10 04:20:52 | Clay, West Virginia, US | |
2119194 | 2119194 | 2022-04-08 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-09 04:20:42 | Clay, West Virginia, US | |
3323718 | 3323718 | 2022-04-07 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-08 04:20:48 | Clay, West Virginia, US | |
2804254 | 2804254 | 2022-04-06 | US | West Virginia | Clay | 54015 | 2340 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-07 04:20:53 | Clay, West Virginia, US | |
3871023 | 3871023 | 2022-04-05 | US | West Virginia | Clay | 54015 | 2341 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-06 04:20:49 | Clay, West Virginia, US | |
2481449 | 2481449 | 2022-03-30 | US | West Virginia | Clay | 54015 | 2337 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-31 04:20:56 | Clay, West Virginia, US | |
161490 | 161490 | 2022-03-29 | US | West Virginia | Clay | 54015 | 2337 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-30 04:20:45 | Clay, West Virginia, US | |
1440061 | 1440061 | 2022-03-28 | US | West Virginia | Clay | 54015 | 2337 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-29 04:20:46 | Clay, West Virginia, US | |
879742 | 879742 | 2022-03-27 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-28 04:20:33 | Clay, West Virginia, US | |
2167025 | 2167025 | 2022-03-26 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-27 04:20:47 | Clay, West Virginia, US | |
1723961 | 1723961 | 2022-03-25 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-26 04:20:23 | Clay, West Virginia, US | |
1471578 | 1471578 | 2022-03-24 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-25 04:20:46 | Clay, West Virginia, US | |
3025752 | 3025752 | 2022-03-23 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-24 04:20:43 | Clay, West Virginia, US | |
1908674 | 1908674 | 2022-03-22 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-23 04:20:48 | Clay, West Virginia, US | |
3241805 | 3241805 | 2022-03-21 | US | West Virginia | Clay | 54015 | 2335 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-22 04:20:54 | Clay, West Virginia, US | |
27878 | 27878 | 2022-03-20 | US | West Virginia | Clay | 54015 | 2334 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-21 04:20:50 | Clay, West Virginia, US | |
1659888 | 1659888 | 2022-03-19 | US | West Virginia | Clay | 54015 | 2334 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-20 04:20:45 | Clay, West Virginia, US | |
339414 | 339414 | 2022-03-18 | US | West Virginia | Clay | 54015 | 2334 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-19 04:20:47 | Clay, West Virginia, US | |
697867 | 697867 | 2022-03-17 | US | West Virginia | Clay | 54015 | 2333 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-03-18 04:20:55 | Clay, West Virginia, US | |
923186 | 923186 | 2022-03-08 | US | West Virginia | Monroe | 54063 | 4156 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-09 04:20:59 | Monroe, West Virginia, US | |
1551473 | 1551473 | 2022-03-07 | US | West Virginia | Monroe | 54063 | 4157 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-08 04:20:54 | Monroe, West Virginia, US | |
2203142 | 2203142 | 2022-03-06 | US | West Virginia | Monroe | 54063 | 4146 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-07 04:20:47 | Monroe, West Virginia, US | |
2095599 | 2095599 | 2022-03-05 | US | West Virginia | Monroe | 54063 | 4146 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-06 04:20:49 | Monroe, West Virginia, US | |
2669299 | 2669299 | 2022-03-04 | US | West Virginia | Monroe | 54063 | 4146 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-05 04:21:10 | Monroe, West Virginia, US | |
1647864 | 1647864 | 2022-03-03 | US | West Virginia | Monroe | 54063 | 4137 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-04 04:21:09 | Monroe, West Virginia, US | |
2528867 | 2528867 | 2022-03-02 | US | West Virginia | Monroe | 54063 | 4130 | 40 | 0 | 37.56274716 | -80.54577965 | 2022-03-03 04:21:01 | Monroe, West Virginia, US | |
1514882 | 1514882 | 2022-02-24 | US | West Virginia | Braxton | 54007 | 3701 | 40 | 0 | 38.70036159 | -80.72011184 | 2022-02-25 04:21:11 | Braxton, West Virginia, US | |
3522918 | 3522918 | 2022-01-02 | US | West Virginia | Hardy | 54031 | 2966 | 40 | 0 | 39.00683177 | -78.85855301 | 2022-01-03 02:22:25 | Hardy, West Virginia, US | |
2171048 | 2171048 | 2022-01-01 | US | West Virginia | Hardy | 54031 | 2966 | 40 | 0 | 39.00683177 | -78.85855301 | 2022-01-02 04:20:52 | Hardy, West Virginia, US | |
2780479 | 2780479 | 2021-12-31 | US | West Virginia | Hardy | 54031 | 2966 | 40 | 0 | 39.00683177 | -78.85855301 | 2022-01-01 04:22:14 | Hardy, West Virginia, US | |
4002136 | 4002136 | 2021-12-30 | US | West Virginia | Hardy | 54031 | 2966 | 40 | 0 | 39.00683177 | -78.85855301 | 2021-12-31 04:21:50 | Hardy, West Virginia, US | |
1671943 | 1671943 | 2021-12-29 | US | West Virginia | Hardy | 54031 | 2937 | 40 | 0 | 39.00683177 | -78.85855301 | 2021-12-30 04:21:25 | Hardy, West Virginia, US | |
1033857 | 1033857 | 2021-12-06 | US | West Virginia | Grant | 54023 | 2505 | 40 | 0 | 39.10314817 | -79.19440518 | 2021-12-07 04:22:34 | Grant, West Virginia, US | |
3346136 | 3346136 | 2021-11-16 | US | West Virginia | Taylor | 54091 | 2489 | 40 | 0 | 39.33602617 | -80.0421439 | 2021-11-17 04:21:48 | Taylor, West Virginia, US | |
2290972 | 2290972 | 2021-11-15 | US | West Virginia | Taylor | 54091 | 2481 | 40 | 0 | 39.33602617 | -80.0421439 | 2021-11-16 04:21:10 | Taylor, West Virginia, US | |
446856 | 446856 | 2021-10-20 | US | West Virginia | Morgan | 54065 | 2048 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-21 04:21:18 | Morgan, West Virginia, US | |
601175 | 601175 | 2021-10-19 | US | West Virginia | Morgan | 54065 | 2040 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-20 04:21:00 | Morgan, West Virginia, US | |
601176 | 601176 | 2021-10-19 | US | West Virginia | Nicholas | 54067 | 3525 | 40 | 0 | 38.29617706 | -80.79759588 | 2021-10-20 04:21:00 | Nicholas, West Virginia, US | |
2047352 | 2047352 | 2021-10-18 | US | West Virginia | Morgan | 54065 | 2035 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-19 04:20:54 | Morgan, West Virginia, US | |
2047353 | 2047353 | 2021-10-18 | US | West Virginia | Nicholas | 54067 | 3511 | 40 | 0 | 38.29617706 | -80.79759588 | 2021-10-19 04:20:54 | Nicholas, West Virginia, US | |
1912713 | 1912713 | 2021-10-17 | US | West Virginia | Morgan | 54065 | 2028 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-18 04:21:10 | Morgan, West Virginia, US | |
938302 | 938302 | 2021-10-16 | US | West Virginia | Morgan | 54065 | 2022 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-17 04:21:29 | Morgan, West Virginia, US | |
2946857 | 2946857 | 2021-10-15 | US | West Virginia | Morgan | 54065 | 2003 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-16 04:21:15 | Morgan, West Virginia, US | |
495137 | 495137 | 2021-10-14 | US | West Virginia | Morgan | 54065 | 1990 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-15 04:21:26 | Morgan, West Virginia, US | |
637425 | 637425 | 2021-10-13 | US | West Virginia | Morgan | 54065 | 1973 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-14 04:21:29 | Morgan, West Virginia, US | |
1495103 | 1495103 | 2021-10-12 | US | West Virginia | Morgan | 54065 | 1964 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-13 04:20:51 | Morgan, West Virginia, US | |
3010836 | 3010836 | 2021-10-11 | US | West Virginia | Morgan | 54065 | 1963 | 40 | 0 | 39.55439028 | -78.26311676 | 2021-10-12 04:21:09 | Morgan, West Virginia, US | |
3010845 | 3010845 | 2021-10-11 | US | West Virginia | Randolph | 54083 | 4878 | 40 | 0 | 38.769899 | -79.87919615 | 2021-10-12 04:21:09 | Randolph, West Virginia, US | |
2462281 | 2462281 | 2021-10-06 | US | West Virginia | Lewis | 54041 | 2721 | 40 | 0 | 38.9947249 | -80.49988181 | 2021-10-07 04:21:36 | Lewis, West Virginia, US | |
2462287 | 2462287 | 2021-10-06 | US | West Virginia | McDowell | 54047 | 2694 | 40 | 0 | 37.38002939 | -81.65083669 | 2021-10-07 04:21:36 | McDowell, West Virginia, US | |
2776447 | 2776447 | 2021-09-30 | US | West Virginia | Barbour | 54001 | 2417 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-10-01 04:21:35 | Barbour, West Virginia, US | |
709903 | 709903 | 2021-09-29 | US | West Virginia | Barbour | 54001 | 2397 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-30 04:21:20 | Barbour, West Virginia, US | |
1337745 | 1337745 | 2021-09-28 | US | West Virginia | Barbour | 54001 | 2384 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-29 04:21:45 | Barbour, West Virginia, US | |
1239114 | 1239114 | 2021-09-27 | US | West Virginia | Barbour | 54001 | 2379 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-28 04:21:28 | Barbour, West Virginia, US | |
2079415 | 2079415 | 2021-09-26 | US | West Virginia | Barbour | 54001 | 2368 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-27 04:21:16 | Barbour, West Virginia, US | |
1727967 | 1727967 | 2021-09-25 | US | West Virginia | Barbour | 54001 | 2361 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-26 04:21:29 | Barbour, West Virginia, US | |
1924687 | 1924687 | 2021-09-24 | US | West Virginia | Barbour | 54001 | 2352 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-25 04:21:31 | Barbour, West Virginia, US | |
605158 | 605158 | 2021-09-23 | US | West Virginia | Barbour | 54001 | 2323 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-24 04:21:44 | Barbour, West Virginia, US | |
3014802 | 3014802 | 2021-09-22 | US | West Virginia | Barbour | 54001 | 2310 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-23 04:21:43 | Barbour, West Virginia, US | |
3760940 | 3760940 | 2021-09-21 | US | West Virginia | Barbour | 54001 | 2296 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-22 04:21:45 | Barbour, West Virginia, US | |
813043 | 813043 | 2021-09-20 | US | West Virginia | Barbour | 54001 | 2281 | 40 | 0 | 39.1307219 | -80.00350858 | 2021-09-21 04:21:26 | Barbour, West Virginia, US | |
3284360 | 3284360 | 2021-09-05 | US | West Virginia | Mason | 54053 | 2624 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-09-06 04:21:22 | Mason, West Virginia, US | |
252774 | 252774 | 2021-09-04 | US | West Virginia | Mason | 54053 | 2595 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-09-05 04:21:33 | Mason, West Virginia, US | |
3978055 | 3978055 | 2021-09-03 | US | West Virginia | Mason | 54053 | 2553 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-09-04 04:21:28 | Mason, West Virginia, US | |
181517 | 181517 | 2021-09-02 | US | West Virginia | Mason | 54053 | 2518 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-09-03 04:21:20 | Mason, West Virginia, US | |
70552 | 70552 | 2021-09-01 | US | West Virginia | Mason | 54053 | 2504 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-09-02 04:21:15 | Mason, West Virginia, US | |
2071394 | 2071394 | 2021-08-31 | US | West Virginia | Mason | 54053 | 2478 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-09-01 04:21:38 | Mason, West Virginia, US | |
1778848 | 1778848 | 2021-08-30 | US | West Virginia | Mason | 54053 | 2463 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-31 04:21:46 | Mason, West Virginia, US | |
3895422 | 3895422 | 2021-08-29 | US | West Virginia | Mason | 54053 | 2439 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-30 04:21:23 | Mason, West Virginia, US | |
2796525 | 2796525 | 2021-08-28 | US | West Virginia | Mason | 54053 | 2422 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-29 04:21:14 | Mason, West Virginia, US | |
2926684 | 2926684 | 2021-08-27 | US | West Virginia | Mason | 54053 | 2398 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-28 04:21:28 | Mason, West Virginia, US | |
1599698 | 1599698 | 2021-08-26 | US | West Virginia | Mason | 54053 | 2385 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-27 04:21:37 | Mason, West Virginia, US | |
35907 | 35907 | 2021-08-25 | US | West Virginia | Mason | 54053 | 2362 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-26 04:21:28 | Mason, West Virginia, US | |
3108946 | 3108946 | 2021-08-24 | US | West Virginia | Mason | 54053 | 2343 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-25 04:21:41 | Mason, West Virginia, US | |
3169117 | 3169117 | 2021-08-23 | US | West Virginia | Mason | 54053 | 2335 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-24 04:21:19 | Mason, West Virginia, US | |
2179044 | 2179044 | 2021-08-22 | US | West Virginia | Mason | 54053 | 2298 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-23 04:21:27 | Mason, West Virginia, US | |
3559140 | 3559140 | 2021-08-21 | US | West Virginia | Mason | 54053 | 2298 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-22 04:21:29 | Mason, West Virginia, US | |
1857482 | 1857482 | 2021-08-20 | US | West Virginia | Mason | 54053 | 2298 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-21 04:21:38 | Mason, West Virginia, US | |
515189 | 515189 | 2021-08-19 | US | West Virginia | Mason | 54053 | 2288 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-20 04:21:33 | Mason, West Virginia, US | |
2521668 | 2521668 | 2021-08-18 | US | West Virginia | Mason | 54053 | 2278 | 40 | 0 | 38.77071799 | -82.02524219 | 2021-08-19 04:21:15 | Mason, West Virginia, US | |
2768454 | 2768454 | 2021-07-01 | US | West Virginia | Wyoming | 54109 | 2057 | 40 | 0 | 37.612327 | -81.54511071 | 2021-07-02 04:21:47 | Wyoming, West Virginia, US | |
1896662 | 1896662 | 2021-06-30 | US | West Virginia | Wyoming | 54109 | 2058 | 40 | 0 | 37.612327 | -81.54511071 | 2021-07-01 04:21:19 | Wyoming, West Virginia, US | |
403785 | 403785 | 2021-06-29 | US | West Virginia | Wyoming | 54109 | 2055 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-30 04:21:41 | Wyoming, West Virginia, US | |
3129028 | 3129028 | 2021-06-28 | US | West Virginia | Wyoming | 54109 | 2055 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-29 04:21:28 | Wyoming, West Virginia, US | |
2593523 | 2593523 | 2021-06-27 | US | West Virginia | Wyoming | 54109 | 2047 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-28 04:21:29 | Wyoming, West Virginia, US | |
3962027 | 3962027 | 2021-06-26 | US | West Virginia | Wyoming | 54109 | 2047 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-27 04:21:39 | Wyoming, West Virginia, US | |
1715846 | 1715846 | 2021-06-25 | US | West Virginia | Wyoming | 54109 | 2047 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-26 04:21:43 | Wyoming, West Virginia, US | |
2298971 | 2298971 | 2021-06-24 | US | West Virginia | Wyoming | 54109 | 2045 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-25 04:21:33 | Wyoming, West Virginia, US | |
2426410 | 2426410 | 2021-06-23 | US | West Virginia | Wyoming | 54109 | 2044 | 40 | 0 | 37.612327 | -81.54511071 | 2021-06-24 04:21:55 | Wyoming, 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]);