johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
92 rows where country_or_region = "US", deaths = 200 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2489498 | 2489498 | 2022-11-16 | US | West Virginia | Logan | 54045 | 12337 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-17 04:21:11 | Logan, West Virginia, US | |
295509 | 295509 | 2022-11-15 | US | West Virginia | Logan | 54045 | 12332 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-16 04:21:09 | Logan, West Virginia, US | |
3600539 | 3600539 | 2022-11-14 | US | West Virginia | Logan | 54045 | 12332 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-15 04:21:16 | Logan, West Virginia, US | |
315397 | 315397 | 2022-11-13 | US | West Virginia | Logan | 54045 | 12319 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-14 04:21:09 | Logan, West Virginia, US | |
66558 | 66558 | 2022-11-12 | US | West Virginia | Logan | 54045 | 12319 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-13 04:21:14 | Logan, West Virginia, US | |
2930720 | 2930720 | 2022-11-11 | US | West Virginia | Logan | 54045 | 12319 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-12 04:20:41 | Logan, West Virginia, US | |
2509556 | 2509556 | 2022-11-10 | US | West Virginia | Logan | 54045 | 12319 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-11 04:21:22 | Logan, West Virginia, US | |
2434431 | 2434431 | 2022-11-09 | US | West Virginia | Logan | 54045 | 12315 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-10 04:21:16 | Logan, West Virginia, US | |
483087 | 483087 | 2022-11-08 | US | West Virginia | Logan | 54045 | 12309 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-09 04:21:22 | Logan, West Virginia, US | |
2442237 | 2442237 | 2022-11-07 | US | West Virginia | Logan | 54045 | 12309 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-08 04:21:21 | Logan, West Virginia, US | |
1053335 | 1053335 | 2022-11-06 | US | West Virginia | Logan | 54045 | 12298 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-07 04:21:26 | Logan, West Virginia, US | |
621359 | 621359 | 2022-11-05 | US | West Virginia | Logan | 54045 | 12298 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-06 04:21:24 | Logan, West Virginia, US | |
1025863 | 1025863 | 2022-11-04 | US | West Virginia | Logan | 54045 | 12298 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-05 04:21:52 | Logan, West Virginia, US | |
434854 | 434854 | 2022-11-03 | US | West Virginia | Logan | 54045 | 12283 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-04 04:22:11 | Logan, West Virginia, US | |
853096 | 853096 | 2022-11-02 | US | West Virginia | Logan | 54045 | 12274 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-03 04:22:05 | Logan, West Virginia, US | |
713947 | 713947 | 2022-11-01 | US | West Virginia | Logan | 54045 | 12270 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-02 04:22:09 | Logan, West Virginia, US | |
3288396 | 3288396 | 2022-10-31 | US | West Virginia | Logan | 54045 | 12266 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-11-01 04:22:36 | Logan, West Virginia, US | |
323429 | 323429 | 2022-10-30 | US | West Virginia | Logan | 54045 | 12255 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-31 04:21:36 | Logan, West Virginia, US | |
915705 | 915705 | 2022-10-29 | US | West Virginia | Logan | 54045 | 12255 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-30 04:22:14 | Logan, West Virginia, US | |
1369974 | 1369974 | 2022-10-28 | US | West Virginia | Logan | 54045 | 12255 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-29 04:21:13 | Logan, West Virginia, US | |
3041829 | 3041829 | 2022-10-27 | US | West Virginia | Logan | 54045 | 12251 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-28 04:22:31 | Logan, West Virginia, US | |
542249 | 542249 | 2022-10-26 | US | West Virginia | Logan | 54045 | 12244 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-27 04:22:01 | Logan, West Virginia, US | |
1833650 | 1833650 | 2022-10-25 | US | West Virginia | Logan | 54045 | 12240 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-26 04:22:19 | Logan, West Virginia, US | |
797911 | 797911 | 2022-10-24 | US | West Virginia | Logan | 54045 | 12237 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-25 04:21:53 | Logan, West Virginia, US | |
3280366 | 3280366 | 2022-10-23 | US | West Virginia | Logan | 54045 | 12218 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-24 04:22:29 | Logan, West Virginia, US | |
2271404 | 2271404 | 2022-10-22 | US | West Virginia | Logan | 54045 | 12218 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-23 04:22:46 | Logan, West Virginia, US | |
1595704 | 1595704 | 2022-10-21 | US | West Virginia | Logan | 54045 | 12218 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-22 04:22:53 | Logan, West Virginia, US | |
2275420 | 2275420 | 2022-10-20 | US | West Virginia | Logan | 54045 | 12211 | 200 | 0 | 37.8299889 | -81.93528571 | 2022-10-21 04:22:23 | Logan, West Virginia, US | |
2020237 | 2020237 | 2022-09-20 | US | West Virginia | Putnam | 54079 | 19704 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-21 04:23:22 | Putnam, West Virginia, US | |
3574110 | 3574110 | 2022-09-19 | US | West Virginia | Putnam | 54079 | 19697 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-20 04:22:48 | Putnam, West Virginia, US | |
422849 | 422849 | 2022-09-18 | US | West Virginia | Putnam | 54079 | 19657 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-19 04:21:49 | Putnam, West Virginia, US | |
3376873 | 3376873 | 2022-09-17 | US | West Virginia | Putnam | 54079 | 19657 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-18 04:22:50 | Putnam, West Virginia, US | |
2358981 | 2358981 | 2022-09-16 | US | West Virginia | Putnam | 54079 | 19657 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-17 04:20:19 | Putnam, West Virginia, US | |
3990138 | 3990138 | 2022-09-15 | US | West Virginia | Putnam | 54079 | 19646 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-16 04:21:19 | Putnam, West Virginia, US | |
1892655 | 1892655 | 2022-09-14 | US | West Virginia | Putnam | 54079 | 19627 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-15 04:21:02 | Putnam, West Virginia, US | |
375710 | 375710 | 2022-09-13 | US | West Virginia | Putnam | 54079 | 19613 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-14 04:20:44 | Putnam, West Virginia, US | |
2398312 | 2398312 | 2022-09-12 | US | West Virginia | Putnam | 54079 | 19581 | 200 | 0 | 38.50782345 | -81.9082131 | 2022-09-13 04:20:57 | Putnam, West Virginia, US | |
3769381 | 3769381 | 2022-09-11 | US | West Virginia | Monongalia | 54061 | 29189 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-12 04:20:58 | Monongalia, West Virginia, US | |
3827956 | 3827956 | 2022-09-10 | US | West Virginia | Monongalia | 54061 | 29189 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-11 04:20:50 | Monongalia, West Virginia, US | |
966413 | 966413 | 2022-09-09 | US | West Virginia | Monongalia | 54061 | 29189 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-10 04:21:10 | Monongalia, West Virginia, US | |
256815 | 256815 | 2022-09-08 | US | West Virginia | Monongalia | 54061 | 29136 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-09 04:21:11 | Monongalia, West Virginia, US | |
3748613 | 3748613 | 2022-09-07 | US | West Virginia | Monongalia | 54061 | 29102 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-08 04:21:02 | Monongalia, West Virginia, US | |
118253 | 118253 | 2022-09-06 | US | West Virginia | Monongalia | 54061 | 29064 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-07 04:20:59 | Monongalia, West Virginia, US | |
2637225 | 2637225 | 2022-09-05 | US | West Virginia | Monongalia | 54061 | 28947 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-06 04:21:02 | Monongalia, West Virginia, US | |
2990789 | 2990789 | 2022-09-04 | US | West Virginia | Monongalia | 54061 | 28947 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-05 04:21:01 | Monongalia, West Virginia, US | |
2716474 | 2716474 | 2022-09-03 | US | West Virginia | Monongalia | 54061 | 28947 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-04 04:21:22 | Monongalia, West Virginia, US | |
1397179 | 1397179 | 2022-09-02 | US | West Virginia | Monongalia | 54061 | 28947 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-03 04:21:04 | Monongalia, West Virginia, US | |
3551008 | 3551008 | 2022-09-01 | US | West Virginia | Monongalia | 54061 | 28901 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-02 04:21:07 | Monongalia, West Virginia, US | |
2346928 | 2346928 | 2022-08-31 | US | West Virginia | Monongalia | 54061 | 28873 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-09-01 04:21:03 | Monongalia, West Virginia, US | |
3777408 | 3777408 | 2022-08-30 | US | West Virginia | Monongalia | 54061 | 28818 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-31 04:20:57 | Monongalia, West Virginia, US | |
1684004 | 1684004 | 2022-08-29 | US | West Virginia | Monongalia | 54061 | 28792 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-30 04:21:03 | Monongalia, West Virginia, US | |
1880488 | 1880488 | 2022-08-28 | US | West Virginia | Monongalia | 54061 | 28688 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-29 04:21:06 | Monongalia, West Virginia, US | |
2099615 | 2099615 | 2022-08-27 | US | West Virginia | Monongalia | 54061 | 28688 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-28 04:21:02 | Monongalia, West Virginia, US | |
1535430 | 1535430 | 2022-08-26 | US | West Virginia | Monongalia | 54061 | 28688 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-27 04:20:57 | Monongalia, West Virginia, US | |
2832317 | 2832317 | 2022-08-25 | US | West Virginia | Monongalia | 54061 | 28624 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-26 04:21:02 | Monongalia, West Virginia, US | |
2326850 | 2326850 | 2022-08-24 | US | West Virginia | Monongalia | 54061 | 28575 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-25 04:21:13 | Monongalia, West Virginia, US | |
1254259 | 1254259 | 2022-08-23 | US | West Virginia | Monongalia | 54061 | 28524 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-24 04:20:46 | Monongalia, West Virginia, US | |
2856363 | 2856363 | 2022-08-22 | US | West Virginia | Monongalia | 54061 | 28494 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-23 04:20:56 | Monongalia, West Virginia, US | |
2406335 | 2406335 | 2022-08-21 | US | West Virginia | Monongalia | 54061 | 28385 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-22 04:20:38 | Monongalia, West Virginia, US | |
3801413 | 3801413 | 2022-08-20 | US | West Virginia | Monongalia | 54061 | 28385 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-21 04:20:44 | Monongalia, West Virginia, US | |
2366999 | 2366999 | 2022-08-19 | US | West Virginia | Monongalia | 54061 | 28385 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-20 04:21:01 | Monongalia, West Virginia, US | |
1164670 | 1164670 | 2022-08-18 | US | West Virginia | Monongalia | 54061 | 28353 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-19 04:20:54 | Monongalia, West Virginia, US | |
3953994 | 3953994 | 2022-08-17 | US | West Virginia | Monongalia | 54061 | 28320 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-18 04:21:11 | Monongalia, West Virginia, US | |
994496 | 994496 | 2022-08-16 | US | West Virginia | Monongalia | 54061 | 28281 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-17 04:20:59 | Monongalia, West Virginia, US | |
2497535 | 2497535 | 2022-08-15 | US | West Virginia | Monongalia | 54061 | 28256 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-16 04:20:58 | Monongalia, West Virginia, US | |
3651085 | 3651085 | 2022-08-14 | US | West Virginia | Monongalia | 54061 | 28205 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-15 04:20:59 | Monongalia, West Virginia, US | |
1972091 | 1972091 | 2022-08-13 | US | West Virginia | Monongalia | 54061 | 28205 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-14 04:20:55 | Monongalia, West Virginia, US | |
2891900 | 2891900 | 2022-08-12 | US | West Virginia | Monongalia | 54061 | 28205 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-13 04:20:52 | Monongalia, West Virginia, US | |
3911505 | 3911505 | 2022-08-11 | US | West Virginia | Monongalia | 54061 | 28166 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-12 04:20:54 | Monongalia, West Virginia, US | |
1349822 | 1349822 | 2022-08-10 | US | West Virginia | Monongalia | 54061 | 28131 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-11 04:20:49 | Monongalia, West Virginia, US | |
1089577 | 1089577 | 2022-08-09 | US | West Virginia | Monongalia | 54061 | 28070 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-10 04:20:57 | Monongalia, West Virginia, US | |
3546992 | 3546992 | 2022-08-08 | US | West Virginia | Monongalia | 54061 | 28040 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-09 04:20:34 | Monongalia, West Virginia, US | |
1073395 | 1073395 | 2022-08-07 | US | West Virginia | Monongalia | 54061 | 27950 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-08 04:21:08 | Monongalia, West Virginia, US | |
1943983 | 1943983 | 2022-08-06 | US | West Virginia | Monongalia | 54061 | 27950 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-07 04:20:54 | Monongalia, West Virginia, US | |
883782 | 883782 | 2022-08-05 | US | West Virginia | Monongalia | 54061 | 27950 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-06 04:20:56 | Monongalia, West Virginia, US | |
2012193 | 2012193 | 2022-08-04 | US | West Virginia | Monongalia | 54061 | 27912 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-05 04:20:52 | Monongalia, West Virginia, US | |
1101620 | 1101620 | 2022-08-03 | US | West Virginia | Monongalia | 54061 | 27872 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-04 04:20:58 | Monongalia, West Virginia, US | |
1408545 | 1408545 | 2022-08-02 | US | West Virginia | Monongalia | 54061 | 27828 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-03 04:20:59 | Monongalia, West Virginia, US | |
3620583 | 3620583 | 2022-08-01 | US | West Virginia | Monongalia | 54061 | 27802 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-02 04:20:53 | Monongalia, West Virginia, US | |
3875063 | 3875063 | 2022-07-31 | US | West Virginia | Monongalia | 54061 | 27721 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-08-01 04:21:03 | Monongalia, West Virginia, US | |
677817 | 677817 | 2022-07-30 | US | West Virginia | Monongalia | 54061 | 27721 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-07-31 04:21:02 | Monongalia, West Virginia, US | |
1787016 | 1787016 | 2022-07-29 | US | West Virginia | Monongalia | 54061 | 27721 | 200 | 0 | 39.63218457 | -80.04766838 | 2022-07-30 04:20:42 | Monongalia, West Virginia, US | |
1436053 | 1436053 | 2021-12-28 | US | West Virginia | Harrison | 54033 | 13289 | 200 | 0 | 39.2853852 | -80.37919577 | 2021-12-29 03:21:43 | Harrison, West Virginia, US | |
554284 | 554284 | 2021-12-08 | US | West Virginia | Raleigh | 54081 | 12784 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-09 04:22:49 | Raleigh, West Virginia, US | |
407804 | 407804 | 2021-12-07 | US | West Virginia | Raleigh | 54081 | 12723 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-08 04:22:46 | Raleigh, West Virginia, US | |
1033886 | 1033886 | 2021-12-06 | US | West Virginia | Raleigh | 54081 | 12679 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-07 04:22:34 | Raleigh, West Virginia, US | |
1744049 | 1744049 | 2021-12-05 | US | West Virginia | Raleigh | 54081 | 12654 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-06 04:22:34 | Raleigh, West Virginia, US | |
141481 | 141481 | 2021-12-04 | US | West Virginia | Raleigh | 54081 | 12630 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-05 04:22:25 | Raleigh, West Virginia, US | |
2199134 | 2199134 | 2021-12-03 | US | West Virginia | Raleigh | 54081 | 12577 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-04 04:22:18 | Raleigh, West Virginia, US | |
3840 | 3840 | 2021-12-02 | US | West Virginia | Raleigh | 54081 | 12524 | 200 | 0 | 37.76936795 | -81.2456041 | 2021-12-03 04:23:05 | Raleigh, West Virginia, US | |
3760994 | 3760994 | 2021-09-21 | US | West Virginia | Wood | 54107 | 10959 | 200 | 0 | 39.20967886 | -81.5162836 | 2021-09-22 04:21:45 | Wood, West Virginia, US | |
1389102 | 1389102 | 2021-09-13 | US | West Virginia | Cabell | 54011 | 11982 | 200 | 0 | 38.42424062 | -82.23855912 | 2021-09-14 04:21:41 | Cabell, 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]);