ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Clay" and state = "West Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
121153 | 121153 | 2020-05-06 | Clay | West Virginia | 54015 | 1 | 0 |
124133 | 124133 | 2020-05-07 | Clay | West Virginia | 54015 | 1 | 0 |
127118 | 127118 | 2020-05-08 | Clay | West Virginia | 54015 | 2 | 0 |
130108 | 130108 | 2020-05-09 | Clay | West Virginia | 54015 | 2 | 0 |
133098 | 133098 | 2020-05-10 | Clay | West Virginia | 54015 | 2 | 0 |
136088 | 136088 | 2020-05-11 | Clay | West Virginia | 54015 | 2 | 0 |
139079 | 139079 | 2020-05-12 | Clay | West Virginia | 54015 | 2 | 0 |
142075 | 142075 | 2020-05-13 | Clay | West Virginia | 54015 | 2 | 0 |
145072 | 145072 | 2020-05-14 | Clay | West Virginia | 54015 | 2 | 0 |
148075 | 148075 | 2020-05-15 | Clay | West Virginia | 54015 | 2 | 0 |
151084 | 151084 | 2020-05-16 | Clay | West Virginia | 54015 | 2 | 0 |
154095 | 154095 | 2020-05-17 | Clay | West Virginia | 54015 | 2 | 0 |
157112 | 157112 | 2020-05-18 | Clay | West Virginia | 54015 | 2 | 0 |
160136 | 160136 | 2020-05-19 | Clay | West Virginia | 54015 | 2 | 0 |
163164 | 163164 | 2020-05-20 | Clay | West Virginia | 54015 | 2 | 0 |
166193 | 166193 | 2020-05-21 | Clay | West Virginia | 54015 | 2 | 0 |
169229 | 169229 | 2020-05-22 | Clay | West Virginia | 54015 | 2 | 0 |
172270 | 172270 | 2020-05-23 | Clay | West Virginia | 54015 | 2 | 0 |
175313 | 175313 | 2020-05-24 | Clay | West Virginia | 54015 | 2 | 0 |
178358 | 178358 | 2020-05-25 | Clay | West Virginia | 54015 | 2 | 0 |
181402 | 181402 | 2020-05-26 | Clay | West Virginia | 54015 | 2 | 0 |
184453 | 184453 | 2020-05-27 | Clay | West Virginia | 54015 | 2 | 0 |
187510 | 187510 | 2020-05-28 | Clay | West Virginia | 54015 | 2 | 0 |
190574 | 190574 | 2020-05-29 | Clay | West Virginia | 54015 | 2 | 0 |
193640 | 193640 | 2020-05-30 | Clay | West Virginia | 54015 | 4 | 0 |
196710 | 196710 | 2020-05-31 | Clay | West Virginia | 54015 | 4 | 0 |
199783 | 199783 | 2020-06-01 | Clay | West Virginia | 54015 | 5 | 0 |
202859 | 202859 | 2020-06-02 | Clay | West Virginia | 54015 | 5 | 0 |
205938 | 205938 | 2020-06-03 | Clay | West Virginia | 54015 | 6 | 0 |
209020 | 209020 | 2020-06-04 | Clay | West Virginia | 54015 | 6 | 0 |
212105 | 212105 | 2020-06-05 | Clay | West Virginia | 54015 | 7 | 0 |
215192 | 215192 | 2020-06-06 | Clay | West Virginia | 54015 | 7 | 0 |
218282 | 218282 | 2020-06-07 | Clay | West Virginia | 54015 | 7 | 0 |
221374 | 221374 | 2020-06-08 | Clay | West Virginia | 54015 | 7 | 0 |
224470 | 224470 | 2020-06-09 | Clay | West Virginia | 54015 | 7 | 0 |
227570 | 227570 | 2020-06-10 | Clay | West Virginia | 54015 | 7 | 0 |
230674 | 230674 | 2020-06-11 | Clay | West Virginia | 54015 | 7 | 0 |
233779 | 233779 | 2020-06-12 | Clay | West Virginia | 54015 | 8 | 0 |
236886 | 236886 | 2020-06-13 | Clay | West Virginia | 54015 | 10 | 0 |
239994 | 239994 | 2020-06-14 | Clay | West Virginia | 54015 | 10 | 0 |
243105 | 243105 | 2020-06-15 | Clay | West Virginia | 54015 | 10 | 0 |
246218 | 246218 | 2020-06-16 | Clay | West Virginia | 54015 | 10 | 0 |
249330 | 249330 | 2020-06-17 | Clay | West Virginia | 54015 | 10 | 0 |
252445 | 252445 | 2020-06-18 | Clay | West Virginia | 54015 | 10 | 0 |
255564 | 255564 | 2020-06-19 | Clay | West Virginia | 54015 | 10 | 0 |
258691 | 258691 | 2020-06-20 | Clay | West Virginia | 54015 | 10 | 0 |
261818 | 261818 | 2020-06-21 | Clay | West Virginia | 54015 | 10 | 0 |
264947 | 264947 | 2020-06-22 | Clay | West Virginia | 54015 | 10 | 0 |
268076 | 268076 | 2020-06-23 | Clay | West Virginia | 54015 | 10 | 1 |
271210 | 271210 | 2020-06-24 | Clay | West Virginia | 54015 | 10 | 1 |
274350 | 274350 | 2020-06-25 | Clay | West Virginia | 54015 | 10 | 1 |
277498 | 277498 | 2020-06-26 | Clay | West Virginia | 54015 | 10 | 1 |
280646 | 280646 | 2020-06-27 | Clay | West Virginia | 54015 | 10 | 1 |
283792 | 283792 | 2020-06-28 | Clay | West Virginia | 54015 | 10 | 1 |
286938 | 286938 | 2020-06-29 | Clay | West Virginia | 54015 | 10 | 1 |
290088 | 290088 | 2020-06-30 | Clay | West Virginia | 54015 | 10 | 1 |
293241 | 293241 | 2020-07-01 | Clay | West Virginia | 54015 | 10 | 1 |
296396 | 296396 | 2020-07-02 | Clay | West Virginia | 54015 | 10 | 1 |
299558 | 299558 | 2020-07-03 | Clay | West Virginia | 54015 | 10 | 1 |
302722 | 302722 | 2020-07-04 | Clay | West Virginia | 54015 | 10 | 1 |
305886 | 305886 | 2020-07-05 | Clay | West Virginia | 54015 | 11 | 1 |
309054 | 309054 | 2020-07-06 | Clay | West Virginia | 54015 | 11 | 1 |
312223 | 312223 | 2020-07-07 | Clay | West Virginia | 54015 | 11 | 1 |
315398 | 315398 | 2020-07-08 | Clay | West Virginia | 54015 | 11 | 1 |
318571 | 318571 | 2020-07-09 | Clay | West Virginia | 54015 | 11 | 1 |
321750 | 321750 | 2020-07-10 | Clay | West Virginia | 54015 | 11 | 1 |
324931 | 324931 | 2020-07-11 | Clay | West Virginia | 54015 | 12 | 1 |
328117 | 328117 | 2020-07-12 | Clay | West Virginia | 54015 | 12 | 1 |
331303 | 331303 | 2020-07-13 | Clay | West Virginia | 54015 | 12 | 1 |
334496 | 334496 | 2020-07-14 | Clay | West Virginia | 54015 | 13 | 1 |
337691 | 337691 | 2020-07-15 | Clay | West Virginia | 54015 | 13 | 1 |
340887 | 340887 | 2020-07-16 | Clay | West Virginia | 54015 | 14 | 1 |
344086 | 344086 | 2020-07-17 | Clay | West Virginia | 54015 | 15 | 1 |
347286 | 347286 | 2020-07-18 | Clay | West Virginia | 54015 | 15 | 1 |
350487 | 350487 | 2020-07-19 | Clay | West Virginia | 54015 | 15 | 1 |
353689 | 353689 | 2020-07-20 | Clay | West Virginia | 54015 | 17 | 1 |
356892 | 356892 | 2020-07-21 | Clay | West Virginia | 54015 | 17 | 1 |
360097 | 360097 | 2020-07-22 | Clay | West Virginia | 54015 | 17 | 1 |
363303 | 363303 | 2020-07-23 | Clay | West Virginia | 54015 | 17 | 1 |
366510 | 366510 | 2020-07-24 | Clay | West Virginia | 54015 | 17 | 1 |
369719 | 369719 | 2020-07-25 | Clay | West Virginia | 54015 | 17 | 1 |
372931 | 372931 | 2020-07-26 | Clay | West Virginia | 54015 | 17 | 1 |
376145 | 376145 | 2020-07-27 | Clay | West Virginia | 54015 | 17 | 1 |
379361 | 379361 | 2020-07-28 | Clay | West Virginia | 54015 | 17 | 1 |
382578 | 382578 | 2020-07-29 | Clay | West Virginia | 54015 | 17 | 1 |
385796 | 385796 | 2020-07-30 | Clay | West Virginia | 54015 | 17 | 1 |
389013 | 389013 | 2020-07-31 | Clay | West Virginia | 54015 | 17 | 1 |
392230 | 392230 | 2020-08-01 | Clay | West Virginia | 54015 | 17 | 1 |
395446 | 395446 | 2020-08-02 | Clay | West Virginia | 54015 | 17 | 1 |
398662 | 398662 | 2020-08-03 | Clay | West Virginia | 54015 | 17 | 1 |
401878 | 401878 | 2020-08-04 | Clay | West Virginia | 54015 | 18 | 1 |
405096 | 405096 | 2020-08-05 | Clay | West Virginia | 54015 | 18 | 1 |
408316 | 408316 | 2020-08-06 | Clay | West Virginia | 54015 | 18 | 1 |
411535 | 411535 | 2020-08-07 | Clay | West Virginia | 54015 | 18 | 1 |
414755 | 414755 | 2020-08-08 | Clay | West Virginia | 54015 | 18 | 1 |
417976 | 417976 | 2020-08-09 | Clay | West Virginia | 54015 | 18 | 1 |
421197 | 421197 | 2020-08-10 | Clay | West Virginia | 54015 | 18 | 1 |
424418 | 424418 | 2020-08-11 | Clay | West Virginia | 54015 | 18 | 1 |
427642 | 427642 | 2020-08-12 | Clay | West Virginia | 54015 | 18 | 1 |
430870 | 430870 | 2020-08-13 | Clay | West Virginia | 54015 | 18 | 1 |
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);