ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2022-04-13 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2404986 | 2404986 | 2022-04-13 | Barbour | West Virginia | 54001 | 4787 | 73 |
2404987 | 2404987 | 2022-04-13 | Berkeley | West Virginia | 54003 | 35694 | 287 |
2404988 | 2404988 | 2022-04-13 | Boone | West Virginia | 54005 | 6563 | 75 |
2404989 | 2404989 | 2022-04-13 | Braxton | West Virginia | 54007 | 3898 | 42 |
2404990 | 2404990 | 2022-04-13 | Brooke | West Virginia | 54009 | 5011 | 104 |
2404991 | 2404991 | 2022-04-13 | Cabell | West Virginia | 54011 | 27425 | 369 |
2404992 | 2404992 | 2022-04-13 | Calhoun | West Virginia | 54013 | 1833 | 13 |
2404993 | 2404993 | 2022-04-13 | Clay | West Virginia | 54015 | 2340 | 40 |
2404994 | 2404994 | 2022-04-13 | Doddridge | West Virginia | 54017 | 2150 | 18 |
2404995 | 2404995 | 2022-04-13 | Fayette | West Virginia | 54019 | 13053 | 198 |
2404996 | 2404996 | 2022-04-13 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2404997 | 2404997 | 2022-04-13 | Grant | West Virginia | 54023 | 3768 | 56 |
2404998 | 2404998 | 2022-04-13 | Greenbrier | West Virginia | 54025 | 9501 | 157 |
2404999 | 2404999 | 2022-04-13 | Hampshire | West Virginia | 54027 | 5824 | 71 |
2405000 | 2405000 | 2022-04-13 | Hancock | West Virginia | 54029 | 6698 | 142 |
2405001 | 2405001 | 2022-04-13 | Hardy | West Virginia | 54031 | 4177 | 49 |
2405002 | 2405002 | 2022-04-13 | Harrison | West Virginia | 54033 | 19828 | 248 |
2405003 | 2405003 | 2022-04-13 | Jackson | West Virginia | 54035 | 6878 | 131 |
2405004 | 2405004 | 2022-04-13 | Jefferson | West Virginia | 54037 | 14214 | 130 |
2405005 | 2405005 | 2022-04-13 | Kanawha | West Virginia | 54039 | 47117 | 708 |
2405006 | 2405006 | 2022-04-13 | Lewis | West Virginia | 54041 | 5316 | 85 |
2405007 | 2405007 | 2022-04-13 | Lincoln | West Virginia | 54043 | 5523 | 80 |
2405008 | 2405008 | 2022-04-13 | Logan | West Virginia | 54045 | 9580 | 182 |
2405009 | 2405009 | 2022-04-13 | Marion | West Virginia | 54049 | 14988 | 178 |
2405010 | 2405010 | 2022-04-13 | Marshall | West Virginia | 54051 | 8942 | 153 |
2405011 | 2405011 | 2022-04-13 | Mason | West Virginia | 54053 | 6643 | 92 |
2405012 | 2405012 | 2022-04-13 | McDowell | West Virginia | 54047 | 5607 | 73 |
2405013 | 2405013 | 2022-04-13 | Mercer | West Virginia | 54055 | 16988 | 264 |
2405014 | 2405014 | 2022-04-13 | Mineral | West Virginia | 54057 | 7850 | 156 |
2405015 | 2405015 | 2022-04-13 | Mingo | West Virginia | 54059 | 7930 | 122 |
2405016 | 2405016 | 2022-04-13 | Monongalia | West Virginia | 54061 | 24637 | 196 |
2405017 | 2405017 | 2022-04-13 | Monroe | West Virginia | 54063 | 4173 | 46 |
2405018 | 2405018 | 2022-04-13 | Morgan | West Virginia | 54065 | 4248 | 69 |
2405019 | 2405019 | 2022-04-13 | Nicholas | West Virginia | 54067 | 7303 | 96 |
2405020 | 2405020 | 2022-04-13 | Ohio | West Virginia | 54069 | 11049 | 166 |
2405021 | 2405021 | 2022-04-13 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2405022 | 2405022 | 2022-04-13 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2405023 | 2405023 | 2022-04-13 | Pocahontas | West Virginia | 54075 | 2013 | 28 |
2405024 | 2405024 | 2022-04-13 | Preston | West Virginia | 54077 | 9265 | 134 |
2405025 | 2405025 | 2022-04-13 | Putnam | West Virginia | 54079 | 16659 | 174 |
2405026 | 2405026 | 2022-04-13 | Raleigh | West Virginia | 54081 | 22696 | 340 |
2405027 | 2405027 | 2022-04-13 | Randolph | West Virginia | 54083 | 9399 | 85 |
2405028 | 2405028 | 2022-04-13 | Ritchie | West Virginia | 54085 | 2444 | 31 |
2405029 | 2405029 | 2022-04-13 | Roane | West Virginia | 54087 | 3159 | 36 |
2405030 | 2405030 | 2022-04-13 | Summers | West Virginia | 54089 | 2805 | 52 |
2405031 | 2405031 | 2022-04-13 | Taylor | West Virginia | 54091 | 4515 | 73 |
2405032 | 2405032 | 2022-04-13 | Tucker | West Virginia | 54093 | 1998 | 37 |
2405033 | 2405033 | 2022-04-13 | Tyler | West Virginia | 54095 | 2200 | 30 |
2405034 | 2405034 | 2022-04-13 | Upshur | West Virginia | 54097 | 6818 | 95 |
2405035 | 2405035 | 2022-04-13 | Wayne | West Virginia | 54099 | 9816 | 121 |
2405036 | 2405036 | 2022-04-13 | Webster | West Virginia | 54101 | 2258 | 33 |
2405037 | 2405037 | 2022-04-13 | Wetzel | West Virginia | 54103 | 4332 | 84 |
2405038 | 2405038 | 2022-04-13 | Wirt | West Virginia | 54105 | 1446 | 24 |
2405039 | 2405039 | 2022-04-13 | Wood | West Virginia | 54107 | 22176 | 343 |
2405040 | 2405040 | 2022-04-13 | Wyoming | West Virginia | 54109 | 6991 | 112 |
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);