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-03-09 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 |
---|---|---|---|---|---|---|---|
2291115 | 2291115 | 2022-03-09 | Barbour | West Virginia | 54001 | 4756 | 74 |
2291116 | 2291116 | 2022-03-09 | Berkeley | West Virginia | 54003 | 35432 | 268 |
2291117 | 2291117 | 2022-03-09 | Boone | West Virginia | 54005 | 6538 | 74 |
2291118 | 2291118 | 2022-03-09 | Braxton | West Virginia | 54007 | 3836 | 42 |
2291119 | 2291119 | 2022-03-09 | Brooke | West Virginia | 54009 | 4949 | 103 |
2291120 | 2291120 | 2022-03-09 | Cabell | West Virginia | 54011 | 27185 | 359 |
2291121 | 2291121 | 2022-03-09 | Calhoun | West Virginia | 54013 | 1812 | 13 |
2291122 | 2291122 | 2022-03-09 | Clay | West Virginia | 54015 | 2330 | 37 |
2291123 | 2291123 | 2022-03-09 | Doddridge | West Virginia | 54017 | 2138 | 18 |
2291124 | 2291124 | 2022-03-09 | Fayette | West Virginia | 54019 | 12944 | 181 |
2291125 | 2291125 | 2022-03-09 | Gilmer | West Virginia | 54021 | 2079 | 18 |
2291126 | 2291126 | 2022-03-09 | Grant | West Virginia | 54023 | 3751 | 56 |
2291127 | 2291127 | 2022-03-09 | Greenbrier | West Virginia | 54025 | 9373 | 147 |
2291128 | 2291128 | 2022-03-09 | Hampshire | West Virginia | 54027 | 5788 | 68 |
2291129 | 2291129 | 2022-03-09 | Hancock | West Virginia | 54029 | 6656 | 140 |
2291130 | 2291130 | 2022-03-09 | Hardy | West Virginia | 54031 | 4164 | 48 |
2291131 | 2291131 | 2022-03-09 | Harrison | West Virginia | 54033 | 19629 | 242 |
2291132 | 2291132 | 2022-03-09 | Jackson | West Virginia | 54035 | 6827 | 131 |
2291133 | 2291133 | 2022-03-09 | Jefferson | West Virginia | 54037 | 14109 | 132 |
2291134 | 2291134 | 2022-03-09 | Kanawha | West Virginia | 54039 | 46865 | 690 |
2291135 | 2291135 | 2022-03-09 | Lewis | West Virginia | 54041 | 5268 | 80 |
2291136 | 2291136 | 2022-03-09 | Lincoln | West Virginia | 54043 | 5472 | 72 |
2291137 | 2291137 | 2022-03-09 | Logan | West Virginia | 54045 | 9518 | 173 |
2291138 | 2291138 | 2022-03-09 | Marion | West Virginia | 54049 | 14782 | 169 |
2291139 | 2291139 | 2022-03-09 | Marshall | West Virginia | 54051 | 8800 | 150 |
2291140 | 2291140 | 2022-03-09 | Mason | West Virginia | 54053 | 6584 | 89 |
2291141 | 2291141 | 2022-03-09 | McDowell | West Virginia | 54047 | 5514 | 64 |
2291142 | 2291142 | 2022-03-09 | Mercer | West Virginia | 54055 | 16751 | 250 |
2291143 | 2291143 | 2022-03-09 | Mineral | West Virginia | 54057 | 7810 | 155 |
2291144 | 2291144 | 2022-03-09 | Mingo | West Virginia | 54059 | 7858 | 119 |
2291145 | 2291145 | 2022-03-09 | Monongalia | West Virginia | 54061 | 24324 | 192 |
2291146 | 2291146 | 2022-03-09 | Monroe | West Virginia | 54063 | 4160 | 41 |
2291147 | 2291147 | 2022-03-09 | Morgan | West Virginia | 54065 | 4210 | 68 |
2291148 | 2291148 | 2022-03-09 | Nicholas | West Virginia | 54067 | 7234 | 91 |
2291149 | 2291149 | 2022-03-09 | Ohio | West Virginia | 54069 | 10981 | 156 |
2291150 | 2291150 | 2022-03-09 | Pendleton | West Virginia | 54071 | 1925 | 17 |
2291151 | 2291151 | 2022-03-09 | Pleasants | West Virginia | 54073 | 2055 | 34 |
2291152 | 2291152 | 2022-03-09 | Pocahontas | West Virginia | 54075 | 1998 | 27 |
2291153 | 2291153 | 2022-03-09 | Preston | West Virginia | 54077 | 9154 | 129 |
2291154 | 2291154 | 2022-03-09 | Putnam | West Virginia | 54079 | 16513 | 170 |
2291155 | 2291155 | 2022-03-09 | Raleigh | West Virginia | 54081 | 22413 | 316 |
2291156 | 2291156 | 2022-03-09 | Randolph | West Virginia | 54083 | 9303 | 77 |
2291157 | 2291157 | 2022-03-09 | Ritchie | West Virginia | 54085 | 2403 | 30 |
2291158 | 2291158 | 2022-03-09 | Roane | West Virginia | 54087 | 3119 | 36 |
2291159 | 2291159 | 2022-03-09 | Summers | West Virginia | 54089 | 2772 | 49 |
2291160 | 2291160 | 2022-03-09 | Taylor | West Virginia | 54091 | 4460 | 66 |
2291161 | 2291161 | 2022-03-09 | Tucker | West Virginia | 54093 | 1959 | 33 |
2291162 | 2291162 | 2022-03-09 | Tyler | West Virginia | 54095 | 2184 | 30 |
2291163 | 2291163 | 2022-03-09 | Upshur | West Virginia | 54097 | 6755 | 85 |
2291164 | 2291164 | 2022-03-09 | Wayne | West Virginia | 54099 | 9757 | 111 |
2291165 | 2291165 | 2022-03-09 | Webster | West Virginia | 54101 | 2208 | 29 |
2291166 | 2291166 | 2022-03-09 | Wetzel | West Virginia | 54103 | 4276 | 80 |
2291167 | 2291167 | 2022-03-09 | Wirt | West Virginia | 54105 | 1433 | 23 |
2291168 | 2291168 | 2022-03-09 | Wood | West Virginia | 54107 | 22013 | 336 |
2291169 | 2291169 | 2022-03-09 | Wyoming | West Virginia | 54109 | 6903 | 100 |
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);