home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

  • 54037 788
  • 54055 787
  • 54061 786
  • 54093 786
  • 54035 785
  • 54039 785
  • 54051 784
  • 54079 784
  • 54003 781
  • 54033 781
  • 54077 781
  • 54107 781
  • 54045 780
  • 54049 780
  • 54069 780
  • 54081 780
  • 54053 779
  • 54097 779
  • 54025 778
  • 54029 778
  • 54073 778
  • 54011 776
  • 54065 776
  • 54103 776
  • 54105 776
  • 54083 775
  • 54087 775
  • 54031 774
  • 54001 773
  • 54071 772
  • …

county >30

  • Jefferson 788
  • Mercer 787
  • Monongalia 786
  • Tucker 786
  • Jackson 785
  • Kanawha 785
  • Marshall 784
  • Putnam 784
  • Berkeley 781
  • Harrison 781
  • Preston 781
  • Wood 781
  • Logan 780
  • Marion 780
  • Ohio 780
  • Raleigh 780
  • Mason 779
  • Upshur 779
  • Greenbrier 778
  • Hancock 778
  • Pleasants 778
  • Cabell 776
  • Morgan 776
  • Wetzel 776
  • Wirt 776
  • Randolph 775
  • Roane 775
  • Hardy 774
  • Barbour 773
  • Pendleton 772
  • …

state 1

  • West Virginia · 42,238 ✖
Link rowid date ▲ county state fips cases deaths
2502683 2502683 2022-05-13 Barbour West Virginia 54001 4838 73
2502684 2502684 2022-05-13 Berkeley West Virginia 54003 36247 295
2502685 2502685 2022-05-13 Boone West Virginia 54005 6660 75
2502686 2502686 2022-05-13 Braxton West Virginia 54007 3940 43
2502687 2502687 2022-05-13 Brooke West Virginia 54009 5082 104
2502688 2502688 2022-05-13 Cabell West Virginia 54011 27842 375
2502689 2502689 2022-05-13 Calhoun West Virginia 54013 1887 15
2502690 2502690 2022-05-13 Clay West Virginia 54015 2351 41
2502691 2502691 2022-05-13 Doddridge West Virginia 54017 2162 18
2502692 2502692 2022-05-13 Fayette West Virginia 54019 13217 205
2502693 2502693 2022-05-13 Gilmer West Virginia 54021 2101 19
2502694 2502694 2022-05-13 Grant West Virginia 54023 3786 56
2502695 2502695 2022-05-13 Greenbrier West Virginia 54025 9763 160
2502696 2502696 2022-05-13 Hampshire West Virginia 54027 5906 73
2502697 2502697 2022-05-13 Hancock West Virginia 54029 6809 142
2502698 2502698 2022-05-13 Hardy West Virginia 54031 4202 49
2502699 2502699 2022-05-13 Harrison West Virginia 54033 20062 253
2502700 2502700 2022-05-13 Jackson West Virginia 54035 6926 132
2502701 2502701 2022-05-13 Jefferson West Virginia 54037 14513 132
2502702 2502702 2022-05-13 Kanawha West Virginia 54039 47739 724
2502703 2502703 2022-05-13 Lewis West Virginia 54041 5359 86
2502704 2502704 2022-05-13 Lincoln West Virginia 54043 5606 82
2502705 2502705 2022-05-13 Logan West Virginia 54045 9747 186
2502706 2502706 2022-05-13 Marion West Virginia 54049 15266 179
2502707 2502707 2022-05-13 Marshall West Virginia 54051 9085 155
2502708 2502708 2022-05-13 Mason West Virginia 54053 6703 93
2502709 2502709 2022-05-13 McDowell West Virginia 54047 5662 75
2502710 2502710 2022-05-13 Mercer West Virginia 54055 17177 266
2502711 2502711 2022-05-13 Mineral West Virginia 54057 7914 156
2502712 2502712 2022-05-13 Mingo West Virginia 54059 7968 123
2502713 2502713 2022-05-13 Monongalia West Virginia 54061 25092 196
2502714 2502714 2022-05-13 Monroe West Virginia 54063 4260 46
2502715 2502715 2022-05-13 Morgan West Virginia 54065 4307 69
2502716 2502716 2022-05-13 Nicholas West Virginia 54067 7378 97
2502717 2502717 2022-05-13 Ohio West Virginia 54069 11335 167
2502718 2502718 2022-05-13 Pendleton West Virginia 54071 2001 22
2502719 2502719 2022-05-13 Pleasants West Virginia 54073 2077 36
2502720 2502720 2022-05-13 Pocahontas West Virginia 54075 2077 32
2502721 2502721 2022-05-13 Preston West Virginia 54077 9367 137
2502722 2502722 2022-05-13 Putnam West Virginia 54079 16889 178
2502723 2502723 2022-05-13 Raleigh West Virginia 54081 23094 349
2502724 2502724 2022-05-13 Randolph West Virginia 54083 9533 89
2502725 2502725 2022-05-13 Ritchie West Virginia 54085 2462 31
2502726 2502726 2022-05-13 Roane West Virginia 54087 3187 36
2502727 2502727 2022-05-13 Summers West Virginia 54089 2831 54
2502728 2502728 2022-05-13 Taylor West Virginia 54091 4585 73
2502729 2502729 2022-05-13 Tucker West Virginia 54093 2024 38
2502730 2502730 2022-05-13 Tyler West Virginia 54095 2214 32
2502731 2502731 2022-05-13 Upshur West Virginia 54097 6928 95
2502732 2502732 2022-05-13 Wayne West Virginia 54099 9915 125
2502733 2502733 2022-05-13 Webster West Virginia 54101 2274 33
2502734 2502734 2022-05-13 Wetzel West Virginia 54103 4367 86
2502735 2502735 2022-05-13 Wirt West Virginia 54105 1455 25
2502736 2502736 2022-05-13 Wood West Virginia 54107 22312 346
2502737 2502737 2022-05-13 Wyoming West Virginia 54109 7044 116
2499425 2499425 2022-05-12 Barbour West Virginia 54001 4835 73
2499426 2499426 2022-05-12 Berkeley West Virginia 54003 36218 295
2499427 2499427 2022-05-12 Boone West Virginia 54005 6655 75
2499428 2499428 2022-05-12 Braxton West Virginia 54007 3937 43
2499429 2499429 2022-05-12 Brooke West Virginia 54009 5080 104
2499430 2499430 2022-05-12 Cabell West Virginia 54011 27808 375
2499431 2499431 2022-05-12 Calhoun West Virginia 54013 1885 15
2499432 2499432 2022-05-12 Clay West Virginia 54015 2348 41
2499433 2499433 2022-05-12 Doddridge West Virginia 54017 2162 18
2499434 2499434 2022-05-12 Fayette West Virginia 54019 13207 205
2499435 2499435 2022-05-12 Gilmer West Virginia 54021 2101 19
2499436 2499436 2022-05-12 Grant West Virginia 54023 3786 56
2499437 2499437 2022-05-12 Greenbrier West Virginia 54025 9749 160
2499438 2499438 2022-05-12 Hampshire West Virginia 54027 5904 73
2499439 2499439 2022-05-12 Hancock West Virginia 54029 6805 142
2499440 2499440 2022-05-12 Hardy West Virginia 54031 4201 49
2499441 2499441 2022-05-12 Harrison West Virginia 54033 20039 253
2499442 2499442 2022-05-12 Jackson West Virginia 54035 6920 132
2499443 2499443 2022-05-12 Jefferson West Virginia 54037 14491 132
2499444 2499444 2022-05-12 Kanawha West Virginia 54039 47672 724
2499445 2499445 2022-05-12 Lewis West Virginia 54041 5355 86
2499446 2499446 2022-05-12 Lincoln West Virginia 54043 5601 82
2499447 2499447 2022-05-12 Logan West Virginia 54045 9737 186
2499448 2499448 2022-05-12 Marion West Virginia 54049 15243 179
2499449 2499449 2022-05-12 Marshall West Virginia 54051 9075 155
2499450 2499450 2022-05-12 Mason West Virginia 54053 6695 93
2499451 2499451 2022-05-12 McDowell West Virginia 54047 5663 75
2499452 2499452 2022-05-12 Mercer West Virginia 54055 17166 266
2499453 2499453 2022-05-12 Mineral West Virginia 54057 7912 156
2499454 2499454 2022-05-12 Mingo West Virginia 54059 7967 123
2499455 2499455 2022-05-12 Monongalia West Virginia 54061 25046 196
2499456 2499456 2022-05-12 Monroe West Virginia 54063 4247 46
2499457 2499457 2022-05-12 Morgan West Virginia 54065 4303 69
2499458 2499458 2022-05-12 Nicholas West Virginia 54067 7376 97
2499459 2499459 2022-05-12 Ohio West Virginia 54069 11321 167
2499460 2499460 2022-05-12 Pendleton West Virginia 54071 1998 22
2499461 2499461 2022-05-12 Pleasants West Virginia 54073 2077 36
2499462 2499462 2022-05-12 Pocahontas West Virginia 54075 2077 32
2499463 2499463 2022-05-12 Preston West Virginia 54077 9362 137
2499464 2499464 2022-05-12 Putnam West Virginia 54079 16875 178
2499465 2499465 2022-05-12 Raleigh West Virginia 54081 23063 349
2499466 2499466 2022-05-12 Randolph West Virginia 54083 9526 89
2499467 2499467 2022-05-12 Ritchie West Virginia 54085 2460 31
2499468 2499468 2022-05-12 Roane West Virginia 54087 3186 36
2499469 2499469 2022-05-12 Summers West Virginia 54089 2830 54

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 417.787ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette