ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 54105 and state = "West Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19596 | 19596 | 2020-03-29 | Wirt | West Virginia | 54105 | 1 | 0 |
21665 | 21665 | 2020-03-30 | Wirt | West Virginia | 54105 | 1 | 0 |
23815 | 23815 | 2020-03-31 | Wirt | West Virginia | 54105 | 1 | 0 |
26034 | 26034 | 2020-04-01 | Wirt | West Virginia | 54105 | 1 | 0 |
28326 | 28326 | 2020-04-02 | Wirt | West Virginia | 54105 | 1 | 0 |
30680 | 30680 | 2020-04-03 | Wirt | West Virginia | 54105 | 1 | 0 |
33081 | 33081 | 2020-04-04 | Wirt | West Virginia | 54105 | 1 | 0 |
35519 | 35519 | 2020-04-05 | Wirt | West Virginia | 54105 | 1 | 0 |
38005 | 38005 | 2020-04-06 | Wirt | West Virginia | 54105 | 1 | 0 |
40545 | 40545 | 2020-04-07 | Wirt | West Virginia | 54105 | 1 | 0 |
43117 | 43117 | 2020-04-08 | Wirt | West Virginia | 54105 | 1 | 0 |
45714 | 45714 | 2020-04-09 | Wirt | West Virginia | 54105 | 1 | 0 |
48342 | 48342 | 2020-04-10 | Wirt | West Virginia | 54105 | 1 | 0 |
51002 | 51002 | 2020-04-11 | Wirt | West Virginia | 54105 | 2 | 0 |
53679 | 53679 | 2020-04-12 | Wirt | West Virginia | 54105 | 2 | 0 |
56369 | 56369 | 2020-04-13 | Wirt | West Virginia | 54105 | 2 | 0 |
59076 | 59076 | 2020-04-14 | Wirt | West Virginia | 54105 | 2 | 0 |
61795 | 61795 | 2020-04-15 | Wirt | West Virginia | 54105 | 2 | 0 |
64528 | 64528 | 2020-04-16 | Wirt | West Virginia | 54105 | 2 | 0 |
67276 | 67276 | 2020-04-17 | Wirt | West Virginia | 54105 | 2 | 0 |
70038 | 70038 | 2020-04-18 | Wirt | West Virginia | 54105 | 2 | 0 |
72807 | 72807 | 2020-04-19 | Wirt | West Virginia | 54105 | 2 | 0 |
75583 | 75583 | 2020-04-20 | Wirt | West Virginia | 54105 | 2 | 0 |
78366 | 78366 | 2020-04-21 | Wirt | West Virginia | 54105 | 2 | 0 |
81159 | 81159 | 2020-04-22 | Wirt | West Virginia | 54105 | 2 | 0 |
83960 | 83960 | 2020-04-23 | Wirt | West Virginia | 54105 | 3 | 0 |
86767 | 86767 | 2020-04-24 | Wirt | West Virginia | 54105 | 3 | 0 |
89583 | 89583 | 2020-04-25 | Wirt | West Virginia | 54105 | 3 | 0 |
92401 | 92401 | 2020-04-26 | Wirt | West Virginia | 54105 | 3 | 0 |
95231 | 95231 | 2020-04-27 | Wirt | West Virginia | 54105 | 3 | 0 |
98076 | 98076 | 2020-04-28 | Wirt | West Virginia | 54105 | 3 | 0 |
100926 | 100926 | 2020-04-29 | Wirt | West Virginia | 54105 | 3 | 0 |
103781 | 103781 | 2020-04-30 | Wirt | West Virginia | 54105 | 3 | 0 |
106645 | 106645 | 2020-05-01 | Wirt | West Virginia | 54105 | 3 | 0 |
109514 | 109514 | 2020-05-02 | Wirt | West Virginia | 54105 | 3 | 0 |
112389 | 112389 | 2020-05-03 | Wirt | West Virginia | 54105 | 3 | 0 |
115272 | 115272 | 2020-05-04 | Wirt | West Virginia | 54105 | 3 | 0 |
118231 | 118231 | 2020-05-05 | Wirt | West Virginia | 54105 | 3 | 0 |
121196 | 121196 | 2020-05-06 | Wirt | West Virginia | 54105 | 3 | 0 |
124176 | 124176 | 2020-05-07 | Wirt | West Virginia | 54105 | 3 | 0 |
127161 | 127161 | 2020-05-08 | Wirt | West Virginia | 54105 | 3 | 0 |
130151 | 130151 | 2020-05-09 | Wirt | West Virginia | 54105 | 3 | 0 |
133141 | 133141 | 2020-05-10 | Wirt | West Virginia | 54105 | 3 | 0 |
136131 | 136131 | 2020-05-11 | Wirt | West Virginia | 54105 | 3 | 0 |
139122 | 139122 | 2020-05-12 | Wirt | West Virginia | 54105 | 3 | 0 |
142118 | 142118 | 2020-05-13 | Wirt | West Virginia | 54105 | 3 | 0 |
145115 | 145115 | 2020-05-14 | Wirt | West Virginia | 54105 | 3 | 0 |
148118 | 148118 | 2020-05-15 | Wirt | West Virginia | 54105 | 3 | 0 |
151127 | 151127 | 2020-05-16 | Wirt | West Virginia | 54105 | 3 | 0 |
154139 | 154139 | 2020-05-17 | Wirt | West Virginia | 54105 | 3 | 0 |
157155 | 157155 | 2020-05-18 | Wirt | West Virginia | 54105 | 3 | 0 |
160179 | 160179 | 2020-05-19 | Wirt | West Virginia | 54105 | 4 | 0 |
163207 | 163207 | 2020-05-20 | Wirt | West Virginia | 54105 | 4 | 0 |
166236 | 166236 | 2020-05-21 | Wirt | West Virginia | 54105 | 4 | 0 |
169272 | 169272 | 2020-05-22 | Wirt | West Virginia | 54105 | 4 | 0 |
172313 | 172313 | 2020-05-23 | Wirt | West Virginia | 54105 | 4 | 0 |
175356 | 175356 | 2020-05-24 | Wirt | West Virginia | 54105 | 4 | 0 |
178401 | 178401 | 2020-05-25 | Wirt | West Virginia | 54105 | 4 | 0 |
181445 | 181445 | 2020-05-26 | Wirt | West Virginia | 54105 | 4 | 0 |
184496 | 184496 | 2020-05-27 | Wirt | West Virginia | 54105 | 4 | 0 |
187553 | 187553 | 2020-05-28 | Wirt | West Virginia | 54105 | 4 | 0 |
190617 | 190617 | 2020-05-29 | Wirt | West Virginia | 54105 | 4 | 0 |
193683 | 193683 | 2020-05-30 | Wirt | West Virginia | 54105 | 4 | 0 |
196753 | 196753 | 2020-05-31 | Wirt | West Virginia | 54105 | 4 | 0 |
199826 | 199826 | 2020-06-01 | Wirt | West Virginia | 54105 | 4 | 0 |
202902 | 202902 | 2020-06-02 | Wirt | West Virginia | 54105 | 4 | 0 |
205981 | 205981 | 2020-06-03 | Wirt | West Virginia | 54105 | 4 | 0 |
209063 | 209063 | 2020-06-04 | Wirt | West Virginia | 54105 | 4 | 0 |
212148 | 212148 | 2020-06-05 | Wirt | West Virginia | 54105 | 4 | 0 |
215235 | 215235 | 2020-06-06 | Wirt | West Virginia | 54105 | 4 | 0 |
218325 | 218325 | 2020-06-07 | Wirt | West Virginia | 54105 | 4 | 0 |
221417 | 221417 | 2020-06-08 | Wirt | West Virginia | 54105 | 4 | 0 |
224513 | 224513 | 2020-06-09 | Wirt | West Virginia | 54105 | 4 | 0 |
227613 | 227613 | 2020-06-10 | Wirt | West Virginia | 54105 | 4 | 0 |
230717 | 230717 | 2020-06-11 | Wirt | West Virginia | 54105 | 4 | 0 |
233822 | 233822 | 2020-06-12 | Wirt | West Virginia | 54105 | 4 | 0 |
236929 | 236929 | 2020-06-13 | Wirt | West Virginia | 54105 | 4 | 0 |
240037 | 240037 | 2020-06-14 | Wirt | West Virginia | 54105 | 4 | 0 |
243148 | 243148 | 2020-06-15 | Wirt | West Virginia | 54105 | 4 | 0 |
246261 | 246261 | 2020-06-16 | Wirt | West Virginia | 54105 | 4 | 0 |
249373 | 249373 | 2020-06-17 | Wirt | West Virginia | 54105 | 4 | 0 |
252488 | 252488 | 2020-06-18 | Wirt | West Virginia | 54105 | 4 | 0 |
255607 | 255607 | 2020-06-19 | Wirt | West Virginia | 54105 | 4 | 0 |
258734 | 258734 | 2020-06-20 | Wirt | West Virginia | 54105 | 4 | 0 |
261861 | 261861 | 2020-06-21 | Wirt | West Virginia | 54105 | 4 | 0 |
264990 | 264990 | 2020-06-22 | Wirt | West Virginia | 54105 | 4 | 0 |
268119 | 268119 | 2020-06-23 | Wirt | West Virginia | 54105 | 4 | 0 |
271253 | 271253 | 2020-06-24 | Wirt | West Virginia | 54105 | 4 | 0 |
274393 | 274393 | 2020-06-25 | Wirt | West Virginia | 54105 | 4 | 0 |
277541 | 277541 | 2020-06-26 | Wirt | West Virginia | 54105 | 4 | 0 |
280689 | 280689 | 2020-06-27 | Wirt | West Virginia | 54105 | 4 | 0 |
283835 | 283835 | 2020-06-28 | Wirt | West Virginia | 54105 | 4 | 0 |
286981 | 286981 | 2020-06-29 | Wirt | West Virginia | 54105 | 4 | 0 |
290131 | 290131 | 2020-06-30 | Wirt | West Virginia | 54105 | 4 | 0 |
293284 | 293284 | 2020-07-01 | Wirt | West Virginia | 54105 | 4 | 0 |
296439 | 296439 | 2020-07-02 | Wirt | West Virginia | 54105 | 4 | 0 |
299601 | 299601 | 2020-07-03 | Wirt | West Virginia | 54105 | 4 | 0 |
302765 | 302765 | 2020-07-04 | Wirt | West Virginia | 54105 | 4 | 0 |
305929 | 305929 | 2020-07-05 | Wirt | West Virginia | 54105 | 4 | 0 |
309098 | 309098 | 2020-07-06 | Wirt | West Virginia | 54105 | 5 | 0 |
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);