ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42,238 rows where state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 54037 302
- 54055 301
- 54061 300
- 54093 300
- 54035 299
- 54039 299
- 54051 298
- 54079 298
- 54003 295
- 54033 295
- 54077 295
- 54107 295
- 54045 294
- 54049 294
- 54069 294
- 54081 294
- 54053 293
- 54097 293
- 54025 292
- 54029 292
- 54073 292
- 54011 290
- 54065 290
- 54103 290
- 54105 290
- 54083 289
- 54087 289
- 54031 288
- 54001 287
- 54071 286
- …
county >30
- Jefferson 302
- Mercer 301
- Monongalia 300
- Tucker 300
- Jackson 299
- Kanawha 299
- Marshall 298
- Putnam 298
- Berkeley 295
- Harrison 295
- Preston 295
- Wood 295
- Logan 294
- Marion 294
- Ohio 294
- Raleigh 294
- Mason 293
- Upshur 293
- Greenbrier 292
- Hancock 292
- Pleasants 292
- Cabell 290
- Morgan 290
- Wetzel 290
- Wirt 290
- Randolph 289
- Roane 289
- Hardy 288
- Barbour 287
- Pendleton 286
- …
state 1
- West Virginia · 15,506 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923533 | 923533 | 2021-01-12 | Barbour | West Virginia | 54001 | 1088 | 14 |
923534 | 923534 | 2021-01-12 | Berkeley | West Virginia | 54003 | 7597 | 60 |
923535 | 923535 | 2021-01-12 | Boone | West Virginia | 54005 | 1228 | 25 |
923536 | 923536 | 2021-01-12 | Braxton | West Virginia | 54007 | 633 | 1 |
923537 | 923537 | 2021-01-12 | Brooke | West Virginia | 54009 | 1654 | 40 |
923538 | 923538 | 2021-01-12 | Cabell | West Virginia | 54011 | 6101 | 121 |
923539 | 923539 | 2021-01-12 | Calhoun | West Virginia | 54013 | 177 | 0 |
923540 | 923540 | 2021-01-12 | Clay | West Virginia | 54015 | 288 | 4 |
923541 | 923541 | 2021-01-12 | Doddridge | West Virginia | 54017 | 320 | 3 |
923542 | 923542 | 2021-01-12 | Fayette | West Virginia | 54019 | 2063 | 55 |
923543 | 923543 | 2021-01-12 | Gilmer | West Virginia | 54021 | 506 | 5 |
923544 | 923544 | 2021-01-12 | Grant | West Virginia | 54023 | 882 | 19 |
923545 | 923545 | 2021-01-12 | Greenbrier | West Virginia | 54025 | 1914 | 43 |
923546 | 923546 | 2021-01-12 | Hampshire | West Virginia | 54027 | 1175 | 23 |
923547 | 923547 | 2021-01-12 | Hancock | West Virginia | 54029 | 2200 | 61 |
923548 | 923548 | 2021-01-12 | Hardy | West Virginia | 54031 | 1011 | 11 |
923549 | 923549 | 2021-01-12 | Harrison | West Virginia | 54033 | 3742 | 39 |
923550 | 923550 | 2021-01-12 | Jackson | West Virginia | 54035 | 1411 | 39 |
923551 | 923551 | 2021-01-12 | Jefferson | West Virginia | 54037 | 2828 | 28 |
923552 | 923552 | 2021-01-12 | Kanawha | West Virginia | 54039 | 9853 | 227 |
923553 | 923553 | 2021-01-12 | Lewis | West Virginia | 54041 | 663 | 8 |
923554 | 923554 | 2021-01-12 | Lincoln | West Virginia | 54043 | 954 | 9 |
923555 | 923555 | 2021-01-12 | Logan | West Virginia | 54045 | 1992 | 63 |
923556 | 923556 | 2021-01-12 | Marion | West Virginia | 54049 | 2580 | 19 |
923557 | 923557 | 2021-01-12 | Marshall | West Virginia | 54051 | 2433 | 57 |
923558 | 923558 | 2021-01-12 | Mason | West Virginia | 54053 | 1232 | 24 |
923559 | 923559 | 2021-01-12 | McDowell | West Virginia | 54047 | 1095 | 7 |
923560 | 923560 | 2021-01-12 | Mercer | West Virginia | 54055 | 3534 | 67 |
923561 | 923561 | 2021-01-12 | Mineral | West Virginia | 54057 | 2264 | 71 |
923562 | 923562 | 2021-01-12 | Mingo | West Virginia | 54059 | 1666 | 20 |
923563 | 923563 | 2021-01-12 | Monongalia | West Virginia | 54061 | 6157 | 49 |
923564 | 923564 | 2021-01-12 | Monroe | West Virginia | 54063 | 757 | 11 |
923565 | 923565 | 2021-01-12 | Morgan | West Virginia | 54065 | 784 | 9 |
923566 | 923566 | 2021-01-12 | Nicholas | West Virginia | 54067 | 856 | 9 |
923567 | 923567 | 2021-01-12 | Ohio | West Virginia | 54069 | 2906 | 51 |
923568 | 923568 | 2021-01-12 | Pendleton | West Virginia | 54071 | 410 | 2 |
923569 | 923569 | 2021-01-12 | Pleasants | West Virginia | 54073 | 692 | 7 |
923570 | 923570 | 2021-01-12 | Pocahontas | West Virginia | 54075 | 425 | 9 |
923571 | 923571 | 2021-01-12 | Preston | West Virginia | 54077 | 2043 | 34 |
923572 | 923572 | 2021-01-12 | Putnam | West Virginia | 54079 | 3348 | 61 |
923573 | 923573 | 2021-01-12 | Raleigh | West Virginia | 54081 | 3356 | 33 |
923574 | 923574 | 2021-01-12 | Randolph | West Virginia | 54083 | 1589 | 8 |
923575 | 923575 | 2021-01-12 | Ritchie | West Virginia | 54085 | 465 | 7 |
923576 | 923576 | 2021-01-12 | Roane | West Virginia | 54087 | 365 | 6 |
923577 | 923577 | 2021-01-12 | Summers | West Virginia | 54089 | 585 | 17 |
923578 | 923578 | 2021-01-12 | Taylor | West Virginia | 54091 | 853 | 13 |
923579 | 923579 | 2021-01-12 | Tucker | West Virginia | 54093 | 403 | 4 |
923580 | 923580 | 2021-01-12 | Tyler | West Virginia | 54095 | 447 | 3 |
923581 | 923581 | 2021-01-12 | Upshur | West Virginia | 54097 | 1188 | 12 |
923582 | 923582 | 2021-01-12 | Wayne | West Virginia | 54099 | 1993 | 24 |
923583 | 923583 | 2021-01-12 | Webster | West Virginia | 54101 | 198 | 0 |
923584 | 923584 | 2021-01-12 | Wetzel | West Virginia | 54103 | 833 | 16 |
923585 | 923585 | 2021-01-12 | Wirt | West Virginia | 54105 | 270 | 1 |
923586 | 923586 | 2021-01-12 | Wood | West Virginia | 54107 | 5857 | 62 |
923587 | 923587 | 2021-01-12 | Wyoming | West Virginia | 54109 | 1339 | 23 |
920288 | 920288 | 2021-01-11 | Barbour | West Virginia | 54001 | 1083 | 14 |
920289 | 920289 | 2021-01-11 | Berkeley | West Virginia | 54003 | 7538 | 60 |
920290 | 920290 | 2021-01-11 | Boone | West Virginia | 54005 | 1215 | 24 |
920291 | 920291 | 2021-01-11 | Braxton | West Virginia | 54007 | 632 | 1 |
920292 | 920292 | 2021-01-11 | Brooke | West Virginia | 54009 | 1643 | 39 |
920293 | 920293 | 2021-01-11 | Cabell | West Virginia | 54011 | 6066 | 119 |
920294 | 920294 | 2021-01-11 | Calhoun | West Virginia | 54013 | 174 | 0 |
920295 | 920295 | 2021-01-11 | Clay | West Virginia | 54015 | 286 | 4 |
920296 | 920296 | 2021-01-11 | Doddridge | West Virginia | 54017 | 316 | 3 |
920297 | 920297 | 2021-01-11 | Fayette | West Virginia | 54019 | 2052 | 55 |
920298 | 920298 | 2021-01-11 | Gilmer | West Virginia | 54021 | 494 | 3 |
920299 | 920299 | 2021-01-11 | Grant | West Virginia | 54023 | 879 | 18 |
920300 | 920300 | 2021-01-11 | Greenbrier | West Virginia | 54025 | 1877 | 43 |
920301 | 920301 | 2021-01-11 | Hampshire | West Virginia | 54027 | 1164 | 23 |
920302 | 920302 | 2021-01-11 | Hancock | West Virginia | 54029 | 2173 | 61 |
920303 | 920303 | 2021-01-11 | Hardy | West Virginia | 54031 | 995 | 11 |
920304 | 920304 | 2021-01-11 | Harrison | West Virginia | 54033 | 3681 | 38 |
920305 | 920305 | 2021-01-11 | Jackson | West Virginia | 54035 | 1392 | 33 |
920306 | 920306 | 2021-01-11 | Jefferson | West Virginia | 54037 | 2795 | 27 |
920307 | 920307 | 2021-01-11 | Kanawha | West Virginia | 54039 | 9776 | 226 |
920308 | 920308 | 2021-01-11 | Lewis | West Virginia | 54041 | 654 | 6 |
920309 | 920309 | 2021-01-11 | Lincoln | West Virginia | 54043 | 947 | 9 |
920310 | 920310 | 2021-01-11 | Logan | West Virginia | 54045 | 1965 | 63 |
920311 | 920311 | 2021-01-11 | Marion | West Virginia | 54049 | 2546 | 17 |
920312 | 920312 | 2021-01-11 | Marshall | West Virginia | 54051 | 2421 | 57 |
920313 | 920313 | 2021-01-11 | Mason | West Virginia | 54053 | 1218 | 22 |
920314 | 920314 | 2021-01-11 | McDowell | West Virginia | 54047 | 1091 | 7 |
920315 | 920315 | 2021-01-11 | Mercer | West Virginia | 54055 | 3508 | 64 |
920316 | 920316 | 2021-01-11 | Mineral | West Virginia | 54057 | 2259 | 71 |
920317 | 920317 | 2021-01-11 | Mingo | West Virginia | 54059 | 1656 | 20 |
920318 | 920318 | 2021-01-11 | Monongalia | West Virginia | 54061 | 6110 | 45 |
920319 | 920319 | 2021-01-11 | Monroe | West Virginia | 54063 | 756 | 11 |
920320 | 920320 | 2021-01-11 | Morgan | West Virginia | 54065 | 781 | 9 |
920321 | 920321 | 2021-01-11 | Nicholas | West Virginia | 54067 | 834 | 9 |
920322 | 920322 | 2021-01-11 | Ohio | West Virginia | 54069 | 2884 | 51 |
920323 | 920323 | 2021-01-11 | Pendleton | West Virginia | 54071 | 405 | 2 |
920324 | 920324 | 2021-01-11 | Pleasants | West Virginia | 54073 | 690 | 6 |
920325 | 920325 | 2021-01-11 | Pocahontas | West Virginia | 54075 | 419 | 9 |
920326 | 920326 | 2021-01-11 | Preston | West Virginia | 54077 | 2024 | 34 |
920327 | 920327 | 2021-01-11 | Putnam | West Virginia | 54079 | 3335 | 60 |
920328 | 920328 | 2021-01-11 | Raleigh | West Virginia | 54081 | 3323 | 33 |
920329 | 920329 | 2021-01-11 | Randolph | West Virginia | 54083 | 1565 | 6 |
920330 | 920330 | 2021-01-11 | Ritchie | West Virginia | 54085 | 462 | 7 |
920331 | 920331 | 2021-01-11 | Roane | West Virginia | 54087 | 361 | 6 |
920332 | 920332 | 2021-01-11 | Summers | West Virginia | 54089 | 574 | 17 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);