johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where country_or_region = "US", deaths = 95 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756398 | 2756398 | 2022-12-29 | US | West Virginia | Lewis | 54041 | 6830 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-30 04:21:04 | Lewis, West Virginia, US | |
1077404 | 1077404 | 2022-12-28 | US | West Virginia | Lewis | 54041 | 6822 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-29 04:21:01 | Lewis, West Virginia, US | |
331401 | 331401 | 2022-12-27 | US | West Virginia | Lewis | 54041 | 6818 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-28 04:21:04 | Lewis, West Virginia, US | |
221474 | 221474 | 2022-12-26 | US | West Virginia | Lewis | 54041 | 6810 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-27 04:21:07 | Lewis, West Virginia, US | |
3225931 | 3225931 | 2022-12-25 | US | West Virginia | Lewis | 54041 | 6810 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-26 04:21:06 | Lewis, West Virginia, US | |
1021845 | 1021845 | 2022-12-24 | US | West Virginia | Lewis | 54041 | 6810 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-25 04:21:04 | Lewis, West Virginia, US | |
693868 | 693868 | 2022-12-23 | US | West Virginia | Lewis | 54041 | 6810 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-24 04:21:02 | Lewis, West Virginia, US | |
2183078 | 2183078 | 2022-12-22 | US | West Virginia | Lewis | 54041 | 6810 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-23 04:21:04 | Lewis, West Virginia, US | |
454882 | 454882 | 2022-12-21 | US | West Virginia | Lewis | 54041 | 6803 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-22 04:20:56 | Lewis, West Virginia, US | |
2954881 | 2954881 | 2022-12-20 | US | West Virginia | Lewis | 54041 | 6802 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-21 04:21:03 | Lewis, West Virginia, US | |
3177283 | 3177283 | 2022-12-19 | US | West Virginia | Lewis | 54041 | 6802 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-20 04:21:04 | Lewis, West Virginia, US | |
1631800 | 1631800 | 2022-12-18 | US | West Virginia | Lewis | 54041 | 6796 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-19 04:21:03 | Lewis, West Virginia, US | |
507179 | 507179 | 2022-12-17 | US | West Virginia | Lewis | 54041 | 6796 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-18 04:21:03 | Lewis, West Virginia, US | |
3327751 | 3327751 | 2022-12-16 | US | West Virginia | Lewis | 54041 | 6796 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-17 04:21:04 | Lewis, West Virginia, US | |
546263 | 546263 | 2022-12-15 | US | West Virginia | Lewis | 54041 | 6793 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-16 04:21:01 | Lewis, West Virginia, US | |
351791 | 351791 | 2022-12-14 | US | West Virginia | Lewis | 54041 | 6788 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-15 04:20:58 | Lewis, West Virginia, US | |
311379 | 311379 | 2022-12-13 | US | West Virginia | Lewis | 54041 | 6788 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-14 04:21:04 | Lewis, West Virginia, US | |
1152440 | 1152440 | 2022-12-12 | US | West Virginia | Lewis | 54041 | 6786 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-13 04:21:01 | Lewis, West Virginia, US | |
872294 | 872294 | 2022-12-11 | US | West Virginia | Lewis | 54041 | 6782 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-12 04:21:01 | Lewis, West Virginia, US | |
260824 | 260824 | 2022-12-10 | US | West Virginia | Lewis | 54041 | 6782 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-11 04:20:50 | Lewis, West Virginia, US | |
3939538 | 3939538 | 2022-12-09 | US | West Virginia | Lewis | 54041 | 6782 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-10 04:21:02 | Lewis, West Virginia, US | |
3380870 | 3380870 | 2022-12-08 | US | West Virginia | Lewis | 54041 | 6781 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-09 04:21:05 | Lewis, West Virginia, US | |
1988141 | 1988141 | 2022-12-07 | US | West Virginia | Lewis | 54041 | 6776 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-08 04:21:07 | Lewis, West Virginia, US | |
3717664 | 3717664 | 2022-12-06 | US | West Virginia | Lewis | 54041 | 6776 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-07 04:20:58 | Lewis, West Virginia, US | |
2418369 | 2418369 | 2022-12-05 | US | West Virginia | Lewis | 54041 | 6772 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-06 04:21:03 | Lewis, West Virginia, US | |
721977 | 721977 | 2022-12-04 | US | West Virginia | Lewis | 54041 | 6768 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-05 04:20:58 | Lewis, West Virginia, US | |
2820266 | 2820266 | 2022-12-03 | US | West Virginia | Lewis | 54041 | 6768 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-04 04:20:56 | Lewis, West Virginia, US | |
837122 | 837122 | 2022-12-02 | US | West Virginia | Lewis | 54041 | 6768 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-03 04:21:02 | Lewis, West Virginia, US | |
2139652 | 2139652 | 2022-12-01 | US | West Virginia | Lewis | 54041 | 6768 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-02 04:21:07 | Lewis, West Virginia, US | |
1968068 | 1968068 | 2022-11-30 | US | West Virginia | Lewis | 54041 | 6765 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-12-01 04:21:03 | Lewis, West Virginia, US | |
2560082 | 2560082 | 2022-11-29 | US | West Virginia | Lewis | 54041 | 6764 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-30 04:21:07 | Lewis, West Virginia, US | |
1243156 | 1243156 | 2022-11-28 | US | West Virginia | Lewis | 54041 | 6762 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-29 04:21:05 | Lewis, West Virginia, US | |
3555144 | 3555144 | 2022-11-27 | US | West Virginia | Lewis | 54041 | 6761 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-28 04:21:02 | Lewis, West Virginia, US | |
2103624 | 2103624 | 2022-11-26 | US | West Virginia | Lewis | 54041 | 6761 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-27 04:21:05 | Lewis, West Virginia, US | |
491115 | 491115 | 2022-11-25 | US | West Virginia | Lewis | 54041 | 6761 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-26 04:21:11 | Lewis, West Virginia, US | |
3526944 | 3526944 | 2022-11-24 | US | West Virginia | Lewis | 54041 | 6761 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-25 04:21:06 | Lewis, West Virginia, US | |
3315727 | 3315727 | 2022-11-23 | US | West Virginia | Lewis | 54041 | 6761 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-24 04:21:09 | Lewis, West Virginia, US | |
1623768 | 1623768 | 2022-11-22 | US | West Virginia | Lewis | 54041 | 6756 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-23 04:21:06 | Lewis, West Virginia, US | |
3463656 | 3463656 | 2022-11-21 | US | West Virginia | Lewis | 54041 | 6755 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-22 04:20:47 | Lewis, West Virginia, US | |
1643841 | 1643841 | 2022-11-20 | US | West Virginia | Lewis | 54041 | 6753 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-21 04:21:05 | Lewis, West Virginia, US | |
2067398 | 2067398 | 2022-11-19 | US | West Virginia | Lewis | 54041 | 6753 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-20 04:21:08 | Lewis, West Virginia, US | |
1758792 | 1758792 | 2022-11-18 | US | West Virginia | Lewis | 54041 | 6753 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-19 04:21:14 | Lewis, West Virginia, US | |
3029785 | 3029785 | 2022-11-17 | US | West Virginia | Lewis | 54041 | 6752 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-18 04:21:15 | Lewis, West Virginia, US | |
2489496 | 2489496 | 2022-11-16 | US | West Virginia | Lewis | 54041 | 6750 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-17 04:21:11 | Lewis, West Virginia, US | |
295507 | 295507 | 2022-11-15 | US | West Virginia | Lewis | 54041 | 6749 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-16 04:21:09 | Lewis, West Virginia, US | |
3600537 | 3600537 | 2022-11-14 | US | West Virginia | Lewis | 54041 | 6748 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-15 04:21:16 | Lewis, West Virginia, US | |
315377 | 315377 | 2022-11-13 | US | West Virginia | Boone | 54005 | 8240 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-14 04:21:09 | Boone, West Virginia, US | |
315395 | 315395 | 2022-11-13 | US | West Virginia | Lewis | 54041 | 6744 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-14 04:21:09 | Lewis, West Virginia, US | |
66538 | 66538 | 2022-11-12 | US | West Virginia | Boone | 54005 | 8240 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-13 04:21:14 | Boone, West Virginia, US | |
66556 | 66556 | 2022-11-12 | US | West Virginia | Lewis | 54041 | 6744 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-13 04:21:14 | Lewis, West Virginia, US | |
2930700 | 2930700 | 2022-11-11 | US | West Virginia | Boone | 54005 | 8240 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-12 04:20:41 | Boone, West Virginia, US | |
2930718 | 2930718 | 2022-11-11 | US | West Virginia | Lewis | 54041 | 6744 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-12 04:20:41 | Lewis, West Virginia, US | |
2509536 | 2509536 | 2022-11-10 | US | West Virginia | Boone | 54005 | 8240 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-11 04:21:22 | Boone, West Virginia, US | |
2509554 | 2509554 | 2022-11-10 | US | West Virginia | Lewis | 54041 | 6744 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-11 04:21:22 | Lewis, West Virginia, US | |
2434411 | 2434411 | 2022-11-09 | US | West Virginia | Boone | 54005 | 8239 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-10 04:21:16 | Boone, West Virginia, US | |
2434429 | 2434429 | 2022-11-09 | US | West Virginia | Lewis | 54041 | 6741 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-10 04:21:16 | Lewis, West Virginia, US | |
483067 | 483067 | 2022-11-08 | US | West Virginia | Boone | 54005 | 8232 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-09 04:21:22 | Boone, West Virginia, US | |
483085 | 483085 | 2022-11-08 | US | West Virginia | Lewis | 54041 | 6739 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-09 04:21:22 | Lewis, West Virginia, US | |
2442217 | 2442217 | 2022-11-07 | US | West Virginia | Boone | 54005 | 8232 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-08 04:21:21 | Boone, West Virginia, US | |
2442235 | 2442235 | 2022-11-07 | US | West Virginia | Lewis | 54041 | 6739 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-08 04:21:21 | Lewis, West Virginia, US | |
1053315 | 1053315 | 2022-11-06 | US | West Virginia | Boone | 54005 | 8229 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-07 04:21:26 | Boone, West Virginia, US | |
1053333 | 1053333 | 2022-11-06 | US | West Virginia | Lewis | 54041 | 6735 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-07 04:21:26 | Lewis, West Virginia, US | |
621339 | 621339 | 2022-11-05 | US | West Virginia | Boone | 54005 | 8229 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-06 04:21:24 | Boone, West Virginia, US | |
621357 | 621357 | 2022-11-05 | US | West Virginia | Lewis | 54041 | 6735 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-06 04:21:24 | Lewis, West Virginia, US | |
1025843 | 1025843 | 2022-11-04 | US | West Virginia | Boone | 54005 | 8229 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-05 04:21:52 | Boone, West Virginia, US | |
1025861 | 1025861 | 2022-11-04 | US | West Virginia | Lewis | 54041 | 6735 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-05 04:21:52 | Lewis, West Virginia, US | |
434834 | 434834 | 2022-11-03 | US | West Virginia | Boone | 54005 | 8226 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-04 04:22:11 | Boone, West Virginia, US | |
434852 | 434852 | 2022-11-03 | US | West Virginia | Lewis | 54041 | 6729 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-04 04:22:11 | Lewis, West Virginia, US | |
853076 | 853076 | 2022-11-02 | US | West Virginia | Boone | 54005 | 8222 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-03 04:22:05 | Boone, West Virginia, US | |
853094 | 853094 | 2022-11-02 | US | West Virginia | Lewis | 54041 | 6727 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-03 04:22:05 | Lewis, West Virginia, US | |
713927 | 713927 | 2022-11-01 | US | West Virginia | Boone | 54005 | 8211 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-02 04:22:09 | Boone, West Virginia, US | |
713945 | 713945 | 2022-11-01 | US | West Virginia | Lewis | 54041 | 6725 | 95 | 0 | 38.9947249 | -80.49988181 | 2022-11-02 04:22:09 | Lewis, West Virginia, US | |
3288376 | 3288376 | 2022-10-31 | US | West Virginia | Boone | 54005 | 8207 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-11-01 04:22:36 | Boone, West Virginia, US | |
323409 | 323409 | 2022-10-30 | US | West Virginia | Boone | 54005 | 8204 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-31 04:21:36 | Boone, West Virginia, US | |
915685 | 915685 | 2022-10-29 | US | West Virginia | Boone | 54005 | 8204 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-30 04:22:14 | Boone, West Virginia, US | |
1369954 | 1369954 | 2022-10-28 | US | West Virginia | Boone | 54005 | 8204 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-29 04:21:13 | Boone, West Virginia, US | |
3041809 | 3041809 | 2022-10-27 | US | West Virginia | Boone | 54005 | 8196 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-28 04:22:31 | Boone, West Virginia, US | |
542229 | 542229 | 2022-10-26 | US | West Virginia | Boone | 54005 | 8190 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-27 04:22:01 | Boone, West Virginia, US | |
1833630 | 1833630 | 2022-10-25 | US | West Virginia | Boone | 54005 | 8187 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-26 04:22:19 | Boone, West Virginia, US | |
797891 | 797891 | 2022-10-24 | US | West Virginia | Boone | 54005 | 8187 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-25 04:21:53 | Boone, West Virginia, US | |
3280346 | 3280346 | 2022-10-23 | US | West Virginia | Boone | 54005 | 8185 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-24 04:22:29 | Boone, West Virginia, US | |
2271384 | 2271384 | 2022-10-22 | US | West Virginia | Boone | 54005 | 8185 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-23 04:22:46 | Boone, West Virginia, US | |
1595684 | 1595684 | 2022-10-21 | US | West Virginia | Boone | 54005 | 8185 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-22 04:22:53 | Boone, West Virginia, US | |
2275400 | 2275400 | 2022-10-20 | US | West Virginia | Boone | 54005 | 8184 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-21 04:22:23 | Boone, West Virginia, US | |
201735 | 201735 | 2022-10-19 | US | West Virginia | Boone | 54005 | 8182 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-20 04:22:59 | Boone, West Virginia, US | |
2760396 | 2760396 | 2022-10-18 | US | West Virginia | Boone | 54005 | 8181 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-19 04:22:26 | Boone, West Virginia, US | |
2028230 | 2028230 | 2022-10-17 | US | West Virginia | Boone | 54005 | 8176 | 95 | 0 | 38.01974191 | -81.69888019 | 2022-10-18 04:22:42 | Boone, West Virginia, US | |
3253663 | 3253663 | 2022-10-11 | US | West Virginia | Randolph | 54083 | 11332 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-12 04:22:51 | Randolph, West Virginia, US | |
2970922 | 2970922 | 2022-10-10 | US | West Virginia | Randolph | 54083 | 11322 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-11 04:23:05 | Randolph, West Virginia, US | |
3100958 | 3100958 | 2022-10-09 | US | West Virginia | Randolph | 54083 | 11322 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-10 04:22:32 | Randolph, West Virginia, US | |
4006183 | 4006183 | 2022-10-08 | US | West Virginia | Randolph | 54083 | 11322 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-09 04:21:16 | Randolph, West Virginia, US | |
399780 | 399780 | 2022-10-07 | US | West Virginia | Randolph | 54083 | 11322 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-08 04:22:56 | Randolph, West Virginia, US | |
2532897 | 2532897 | 2022-10-06 | US | West Virginia | Randolph | 54083 | 11322 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-07 04:23:08 | Randolph, West Virginia, US | |
1814291 | 1814291 | 2022-10-05 | US | West Virginia | Randolph | 54083 | 11318 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-06 04:21:22 | Randolph, West Virginia, US | |
134265 | 134265 | 2022-10-04 | US | West Virginia | Randolph | 54083 | 11311 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-05 04:23:06 | Randolph, West Virginia, US | |
2689212 | 2689212 | 2022-10-03 | US | West Virginia | Randolph | 54083 | 11305 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-04 04:22:55 | Randolph, West Virginia, US | |
2263279 | 2263279 | 2022-10-02 | US | West Virginia | Randolph | 54083 | 11295 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-03 04:23:11 | Randolph, West Virginia, US | |
2998805 | 2998805 | 2022-10-01 | US | West Virginia | Randolph | 54083 | 11295 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-02 04:21:23 | Randolph, West Virginia, US | |
857131 | 857131 | 2022-09-30 | US | West Virginia | Randolph | 54083 | 11295 | 95 | 0 | 38.769899 | -79.87919615 | 2022-10-01 04:23:01 | Randolph, West Virginia, US | |
2379057 | 2379057 | 2022-09-29 | US | West Virginia | Randolph | 54083 | 11291 | 95 | 0 | 38.769899 | -79.87919615 | 2022-09-30 04:23:09 | Randolph, 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]);