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 = "2022-04-29" and state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • West Virginia · 55 ✖
Link rowid date ▲ county state fips cases deaths
2457082 2457082 2022-04-29 Barbour West Virginia 54001 4809 73
2457083 2457083 2022-04-29 Berkeley West Virginia 54003 35913 292
2457084 2457084 2022-04-29 Boone West Virginia 54005 6598 75
2457085 2457085 2022-04-29 Braxton West Virginia 54007 3917 43
2457086 2457086 2022-04-29 Brooke West Virginia 54009 5045 104
2457087 2457087 2022-04-29 Cabell West Virginia 54011 27564 374
2457088 2457088 2022-04-29 Calhoun West Virginia 54013 1877 14
2457089 2457089 2022-04-29 Clay West Virginia 54015 2343 41
2457090 2457090 2022-04-29 Doddridge West Virginia 54017 2154 18
2457091 2457091 2022-04-29 Fayette West Virginia 54019 13099 202
2457092 2457092 2022-04-29 Gilmer West Virginia 54021 2099 19
2457093 2457093 2022-04-29 Grant West Virginia 54023 3785 56
2457094 2457094 2022-04-29 Greenbrier West Virginia 54025 9574 159
2457095 2457095 2022-04-29 Hampshire West Virginia 54027 5872 72
2457096 2457096 2022-04-29 Hancock West Virginia 54029 6729 142
2457097 2457097 2022-04-29 Hardy West Virginia 54031 4190 49
2457098 2457098 2022-04-29 Harrison West Virginia 54033 19888 251
2457099 2457099 2022-04-29 Jackson West Virginia 54035 6889 132
2457100 2457100 2022-04-29 Jefferson West Virginia 54037 14310 131
2457101 2457101 2022-04-29 Kanawha West Virginia 54039 47329 720
2457102 2457102 2022-04-29 Lewis West Virginia 54041 5329 86
2457103 2457103 2022-04-29 Lincoln West Virginia 54043 5554 81
2457104 2457104 2022-04-29 Logan West Virginia 54045 9642 185
2457105 2457105 2022-04-29 Marion West Virginia 54049 15072 178
2457106 2457106 2022-04-29 Marshall West Virginia 54051 9022 154
2457107 2457107 2022-04-29 Mason West Virginia 54053 6670 93
2457108 2457108 2022-04-29 McDowell West Virginia 54047 5630 75
2457109 2457109 2022-04-29 Mercer West Virginia 54055 17070 265
2457110 2457110 2022-04-29 Mineral West Virginia 54057 7886 156
2457111 2457111 2022-04-29 Mingo West Virginia 54059 7945 122
2457112 2457112 2022-04-29 Monongalia West Virginia 54061 24806 196
2457113 2457113 2022-04-29 Monroe West Virginia 54063 4193 46
2457114 2457114 2022-04-29 Morgan West Virginia 54065 4283 69
2457115 2457115 2022-04-29 Nicholas West Virginia 54067 7326 97
2457116 2457116 2022-04-29 Ohio West Virginia 54069 11156 167
2457117 2457117 2022-04-29 Pendleton West Virginia 54071 1972 22
2457118 2457118 2022-04-29 Pleasants West Virginia 54073 2066 36
2457119 2457119 2022-04-29 Pocahontas West Virginia 54075 2050 30
2457120 2457120 2022-04-29 Preston West Virginia 54077 9307 136
2457121 2457121 2022-04-29 Putnam West Virginia 54079 16762 178
2457122 2457122 2022-04-29 Raleigh West Virginia 54081 22838 345
2457123 2457123 2022-04-29 Randolph West Virginia 54083 9459 89
2457124 2457124 2022-04-29 Ritchie West Virginia 54085 2453 31
2457125 2457125 2022-04-29 Roane West Virginia 54087 3167 36
2457126 2457126 2022-04-29 Summers West Virginia 54089 2809 54
2457127 2457127 2022-04-29 Taylor West Virginia 54091 4535 73
2457128 2457128 2022-04-29 Tucker West Virginia 54093 2008 38
2457129 2457129 2022-04-29 Tyler West Virginia 54095 2204 32
2457130 2457130 2022-04-29 Upshur West Virginia 54097 6852 95
2457131 2457131 2022-04-29 Wayne West Virginia 54099 9838 123
2457132 2457132 2022-04-29 Webster West Virginia 54101 2263 33
2457133 2457133 2022-04-29 Wetzel West Virginia 54103 4352 86
2457134 2457134 2022-04-29 Wirt West Virginia 54105 1452 24
2457135 2457135 2022-04-29 Wood West Virginia 54107 22234 344
2457136 2457136 2022-04-29 Wyoming West Virginia 54109 7015 114

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