ny_times_us_counties

Table actions
⚠️ 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

55 rows where "date" is on date 2021-01-20 and state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

state 1

  • West Virginia · 55 ✖
Link rowid date ▲ county state fips cases deaths
949497 949497 2021-01-20 Barbour West Virginia 54001 1018 15
949498 949498 2021-01-20 Berkeley West Virginia 54003 8227 73
949499 949499 2021-01-20 Boone West Virginia 54005 1315 28
949500 949500 2021-01-20 Braxton West Virginia 54007 694 1
949501 949501 2021-01-20 Brooke West Virginia 54009 1801 47
949502 949502 2021-01-20 Cabell West Virginia 54011 6556 133
949503 949503 2021-01-20 Calhoun West Virginia 54013 191 0
949504 949504 2021-01-20 Clay West Virginia 54015 306 4
949505 949505 2021-01-20 Doddridge West Virginia 54017 369 4
949506 949506 2021-01-20 Fayette West Virginia 54019 2204 61
949507 949507 2021-01-20 Gilmer West Virginia 54021 539 6
949508 949508 2021-01-20 Grant West Virginia 54023 932 19
949509 949509 2021-01-20 Greenbrier West Virginia 54025 2083 47
949510 949510 2021-01-20 Hampshire West Virginia 54027 1257 24
949511 949511 2021-01-20 Hancock West Virginia 54029 2344 76
949512 949512 2021-01-20 Hardy West Virginia 54031 1107 14
949513 949513 2021-01-20 Harrison West Virginia 54033 4114 44
949514 949514 2021-01-20 Jackson West Virginia 54035 1510 43
949515 949515 2021-01-20 Jefferson West Virginia 54037 3059 31
949516 949516 2021-01-20 Kanawha West Virginia 54039 10439 243
949517 949517 2021-01-20 Lewis West Virginia 54041 737 11
949518 949518 2021-01-20 Lincoln West Virginia 54043 1054 9
949519 949519 2021-01-20 Logan West Virginia 54045 2160 66
949520 949520 2021-01-20 Marion West Virginia 54049 2977 24
949521 949521 2021-01-20 Marshall West Virginia 54051 2593 60
949522 949522 2021-01-20 Mason West Virginia 54053 1405 26
949523 949523 2021-01-20 McDowell West Virginia 54047 1145 8
949524 949524 2021-01-20 Mercer West Virginia 54055 3737 77
949525 949525 2021-01-20 Mineral West Virginia 54057 2331 73
949526 949526 2021-01-20 Mingo West Virginia 54059 1795 20
949527 949527 2021-01-20 Monongalia West Virginia 54061 6574 54
949528 949528 2021-01-20 Monroe West Virginia 54063 834 11
949529 949529 2021-01-20 Morgan West Virginia 54065 830 10
949530 949530 2021-01-20 Nicholas West Virginia 54067 957 9
949531 949531 2021-01-20 Ohio West Virginia 54069 3154 57
949532 949532 2021-01-20 Pendleton West Virginia 54071 492 3
949533 949533 2021-01-20 Pleasants West Virginia 54073 732 13
949534 949534 2021-01-20 Pocahontas West Virginia 54075 521 9
949535 949535 2021-01-20 Preston West Virginia 54077 2266 35
949536 949536 2021-01-20 Putnam West Virginia 54079 3578 67
949537 949537 2021-01-20 Raleigh West Virginia 54081 3769 40
949538 949538 2021-01-20 Randolph West Virginia 54083 2008 8
949539 949539 2021-01-20 Ritchie West Virginia 54085 508 8
949540 949540 2021-01-20 Roane West Virginia 54087 410 6
949541 949541 2021-01-20 Summers West Virginia 54089 641 19
949542 949542 2021-01-20 Taylor West Virginia 54091 920 15
949543 949543 2021-01-20 Tucker West Virginia 54093 422 7
949544 949544 2021-01-20 Tyler West Virginia 54095 515 3
949545 949545 2021-01-20 Upshur West Virginia 54097 1307 20
949546 949546 2021-01-20 Wayne West Virginia 54099 2149 26
949547 949547 2021-01-20 Webster West Virginia 54101 223 0
949548 949548 2021-01-20 Wetzel West Virginia 54103 924 18
949549 949549 2021-01-20 Wirt West Virginia 54105 303 1
949550 949550 2021-01-20 Wood West Virginia 54107 6192 84
949551 949551 2021-01-20 Wyoming West Virginia 54109 1449 26

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);