ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2022-04-22" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2434290 | 2434290 | 2022-04-22 | Barbour | West Virginia | 54001 | 4796 | 73 |
2434291 | 2434291 | 2022-04-22 | Berkeley | West Virginia | 54003 | 35787 | 291 |
2434292 | 2434292 | 2022-04-22 | Boone | West Virginia | 54005 | 6576 | 75 |
2434293 | 2434293 | 2022-04-22 | Braxton | West Virginia | 54007 | 3908 | 43 |
2434294 | 2434294 | 2022-04-22 | Brooke | West Virginia | 54009 | 5027 | 104 |
2434295 | 2434295 | 2022-04-22 | Cabell | West Virginia | 54011 | 27499 | 372 |
2434296 | 2434296 | 2022-04-22 | Calhoun | West Virginia | 54013 | 1848 | 14 |
2434297 | 2434297 | 2022-04-22 | Clay | West Virginia | 54015 | 2340 | 41 |
2434298 | 2434298 | 2022-04-22 | Doddridge | West Virginia | 54017 | 2152 | 18 |
2434299 | 2434299 | 2022-04-22 | Fayette | West Virginia | 54019 | 13072 | 199 |
2434300 | 2434300 | 2022-04-22 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2434301 | 2434301 | 2022-04-22 | Grant | West Virginia | 54023 | 3776 | 56 |
2434302 | 2434302 | 2022-04-22 | Greenbrier | West Virginia | 54025 | 9537 | 159 |
2434303 | 2434303 | 2022-04-22 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2434304 | 2434304 | 2022-04-22 | Hancock | West Virginia | 54029 | 6714 | 142 |
2434305 | 2434305 | 2022-04-22 | Hardy | West Virginia | 54031 | 4184 | 49 |
2434306 | 2434306 | 2022-04-22 | Harrison | West Virginia | 54033 | 19854 | 250 |
2434307 | 2434307 | 2022-04-22 | Jackson | West Virginia | 54035 | 6887 | 131 |
2434308 | 2434308 | 2022-04-22 | Jefferson | West Virginia | 54037 | 14262 | 130 |
2434309 | 2434309 | 2022-04-22 | Kanawha | West Virginia | 54039 | 47189 | 715 |
2434310 | 2434310 | 2022-04-22 | Lewis | West Virginia | 54041 | 5321 | 85 |
2434311 | 2434311 | 2022-04-22 | Lincoln | West Virginia | 54043 | 5532 | 81 |
2434312 | 2434312 | 2022-04-22 | Logan | West Virginia | 54045 | 9599 | 183 |
2434313 | 2434313 | 2022-04-22 | Marion | West Virginia | 54049 | 15020 | 178 |
2434314 | 2434314 | 2022-04-22 | Marshall | West Virginia | 54051 | 8985 | 154 |
2434315 | 2434315 | 2022-04-22 | Mason | West Virginia | 54053 | 6658 | 93 |
2434316 | 2434316 | 2022-04-22 | McDowell | West Virginia | 54047 | 5619 | 74 |
2434317 | 2434317 | 2022-04-22 | Mercer | West Virginia | 54055 | 17038 | 265 |
2434318 | 2434318 | 2022-04-22 | Mineral | West Virginia | 54057 | 7875 | 156 |
2434319 | 2434319 | 2022-04-22 | Mingo | West Virginia | 54059 | 7938 | 122 |
2434320 | 2434320 | 2022-04-22 | Monongalia | West Virginia | 54061 | 24729 | 196 |
2434321 | 2434321 | 2022-04-22 | Monroe | West Virginia | 54063 | 4178 | 46 |
2434322 | 2434322 | 2022-04-22 | Morgan | West Virginia | 54065 | 4264 | 69 |
2434323 | 2434323 | 2022-04-22 | Nicholas | West Virginia | 54067 | 7311 | 96 |
2434324 | 2434324 | 2022-04-22 | Ohio | West Virginia | 54069 | 11079 | 166 |
2434325 | 2434325 | 2022-04-22 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2434326 | 2434326 | 2022-04-22 | Pleasants | West Virginia | 54073 | 2065 | 36 |
2434327 | 2434327 | 2022-04-22 | Pocahontas | West Virginia | 54075 | 2015 | 29 |
2434328 | 2434328 | 2022-04-22 | Preston | West Virginia | 54077 | 9289 | 135 |
2434329 | 2434329 | 2022-04-22 | Putnam | West Virginia | 54079 | 16716 | 176 |
2434330 | 2434330 | 2022-04-22 | Raleigh | West Virginia | 54081 | 22743 | 342 |
2434331 | 2434331 | 2022-04-22 | Randolph | West Virginia | 54083 | 9428 | 88 |
2434332 | 2434332 | 2022-04-22 | Ritchie | West Virginia | 54085 | 2448 | 31 |
2434333 | 2434333 | 2022-04-22 | Roane | West Virginia | 54087 | 3163 | 36 |
2434334 | 2434334 | 2022-04-22 | Summers | West Virginia | 54089 | 2809 | 54 |
2434335 | 2434335 | 2022-04-22 | Taylor | West Virginia | 54091 | 4531 | 73 |
2434336 | 2434336 | 2022-04-22 | Tucker | West Virginia | 54093 | 2003 | 37 |
2434337 | 2434337 | 2022-04-22 | Tyler | West Virginia | 54095 | 2203 | 31 |
2434338 | 2434338 | 2022-04-22 | Upshur | West Virginia | 54097 | 6833 | 95 |
2434339 | 2434339 | 2022-04-22 | Wayne | West Virginia | 54099 | 9824 | 122 |
2434340 | 2434340 | 2022-04-22 | Webster | West Virginia | 54101 | 2261 | 33 |
2434341 | 2434341 | 2022-04-22 | Wetzel | West Virginia | 54103 | 4340 | 86 |
2434342 | 2434342 | 2022-04-22 | Wirt | West Virginia | 54105 | 1446 | 24 |
2434343 | 2434343 | 2022-04-22 | Wood | West Virginia | 54107 | 22208 | 343 |
2434344 | 2434344 | 2022-04-22 | Wyoming | West Virginia | 54109 | 7011 | 113 |
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);