ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Fayette" 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 |
---|---|---|---|---|---|---|---|
537518 | 537518 | 2020-09-15 | Fayette | West Virginia | 54019 | 481 | 10 |
534282 | 534282 | 2020-09-14 | Fayette | West Virginia | 54019 | 475 | 10 |
531047 | 531047 | 2020-09-13 | Fayette | West Virginia | 54019 | 470 | 10 |
527810 | 527810 | 2020-09-12 | Fayette | West Virginia | 54019 | 450 | 10 |
524574 | 524574 | 2020-09-11 | Fayette | West Virginia | 54019 | 439 | 10 |
521338 | 521338 | 2020-09-10 | Fayette | West Virginia | 54019 | 432 | 9 |
518101 | 518101 | 2020-09-09 | Fayette | West Virginia | 54019 | 421 | 9 |
514866 | 514866 | 2020-09-08 | Fayette | West Virginia | 54019 | 420 | 8 |
511633 | 511633 | 2020-09-07 | Fayette | West Virginia | 54019 | 421 | 9 |
508400 | 508400 | 2020-09-06 | Fayette | West Virginia | 54019 | 412 | 9 |
505168 | 505168 | 2020-09-05 | Fayette | West Virginia | 54019 | 398 | 9 |
501934 | 501934 | 2020-09-04 | Fayette | West Virginia | 54019 | 377 | 10 |
498700 | 498700 | 2020-09-03 | Fayette | West Virginia | 54019 | 369 | 9 |
495467 | 495467 | 2020-09-02 | Fayette | West Virginia | 54019 | 365 | 10 |
492233 | 492233 | 2020-09-01 | Fayette | West Virginia | 54019 | 360 | 10 |
489000 | 489000 | 2020-08-31 | Fayette | West Virginia | 54019 | 292 | 9 |
485767 | 485767 | 2020-08-30 | Fayette | West Virginia | 54019 | 268 | 9 |
482532 | 482532 | 2020-08-29 | Fayette | West Virginia | 54019 | 247 | 9 |
479298 | 479298 | 2020-08-28 | Fayette | West Virginia | 54019 | 235 | 10 |
476065 | 476065 | 2020-08-27 | Fayette | West Virginia | 54019 | 215 | 10 |
472832 | 472832 | 2020-08-26 | Fayette | West Virginia | 54019 | 195 | 9 |
469600 | 469600 | 2020-08-25 | Fayette | West Virginia | 54019 | 188 | 9 |
466371 | 466371 | 2020-08-24 | Fayette | West Virginia | 54019 | 187 | 8 |
463142 | 463142 | 2020-08-23 | Fayette | West Virginia | 54019 | 186 | 8 |
459913 | 459913 | 2020-08-22 | Fayette | West Virginia | 54019 | 187 | 8 |
456686 | 456686 | 2020-08-21 | Fayette | West Virginia | 54019 | 183 | 8 |
453458 | 453458 | 2020-08-20 | Fayette | West Virginia | 54019 | 183 | 7 |
450230 | 450230 | 2020-08-19 | Fayette | West Virginia | 54019 | 178 | 7 |
447002 | 447002 | 2020-08-18 | Fayette | West Virginia | 54019 | 175 | 7 |
443775 | 443775 | 2020-08-17 | Fayette | West Virginia | 54019 | 168 | 7 |
440549 | 440549 | 2020-08-16 | Fayette | West Virginia | 54019 | 170 | 7 |
437323 | 437323 | 2020-08-15 | Fayette | West Virginia | 54019 | 166 | 7 |
434097 | 434097 | 2020-08-14 | Fayette | West Virginia | 54019 | 166 | 7 |
430872 | 430872 | 2020-08-13 | Fayette | West Virginia | 54019 | 160 | 7 |
427644 | 427644 | 2020-08-12 | Fayette | West Virginia | 54019 | 155 | 7 |
424420 | 424420 | 2020-08-11 | Fayette | West Virginia | 54019 | 154 | 7 |
421199 | 421199 | 2020-08-10 | Fayette | West Virginia | 54019 | 151 | 7 |
417978 | 417978 | 2020-08-09 | Fayette | West Virginia | 54019 | 148 | 7 |
414757 | 414757 | 2020-08-08 | Fayette | West Virginia | 54019 | 144 | 7 |
411537 | 411537 | 2020-08-07 | Fayette | West Virginia | 54019 | 140 | 5 |
408318 | 408318 | 2020-08-06 | Fayette | West Virginia | 54019 | 137 | 5 |
405098 | 405098 | 2020-08-05 | Fayette | West Virginia | 54019 | 134 | 5 |
401880 | 401880 | 2020-08-04 | Fayette | West Virginia | 54019 | 131 | 5 |
398664 | 398664 | 2020-08-03 | Fayette | West Virginia | 54019 | 131 | 5 |
395448 | 395448 | 2020-08-02 | Fayette | West Virginia | 54019 | 129 | 5 |
392232 | 392232 | 2020-08-01 | Fayette | West Virginia | 54019 | 129 | 5 |
389015 | 389015 | 2020-07-31 | Fayette | West Virginia | 54019 | 126 | 5 |
385798 | 385798 | 2020-07-30 | Fayette | West Virginia | 54019 | 124 | 5 |
382580 | 382580 | 2020-07-29 | Fayette | West Virginia | 54019 | 124 | 5 |
379363 | 379363 | 2020-07-28 | Fayette | West Virginia | 54019 | 122 | 5 |
376147 | 376147 | 2020-07-27 | Fayette | West Virginia | 54019 | 118 | 5 |
372933 | 372933 | 2020-07-26 | Fayette | West Virginia | 54019 | 117 | 5 |
369721 | 369721 | 2020-07-25 | Fayette | West Virginia | 54019 | 114 | 5 |
366511 | 366511 | 2020-07-24 | Fayette | West Virginia | 54019 | 111 | 5 |
363304 | 363304 | 2020-07-23 | Fayette | West Virginia | 54019 | 107 | 5 |
360098 | 360098 | 2020-07-22 | Fayette | West Virginia | 54019 | 107 | 5 |
356893 | 356893 | 2020-07-21 | Fayette | West Virginia | 54019 | 101 | 4 |
353690 | 353690 | 2020-07-20 | Fayette | West Virginia | 54019 | 101 | 4 |
350488 | 350488 | 2020-07-19 | Fayette | West Virginia | 54019 | 101 | 4 |
347287 | 347287 | 2020-07-18 | Fayette | West Virginia | 54019 | 102 | 4 |
344087 | 344087 | 2020-07-17 | Fayette | West Virginia | 54019 | 98 | 4 |
340888 | 340888 | 2020-07-16 | Fayette | West Virginia | 54019 | 95 | 4 |
337692 | 337692 | 2020-07-15 | Fayette | West Virginia | 54019 | 89 | 4 |
334497 | 334497 | 2020-07-14 | Fayette | West Virginia | 54019 | 84 | 4 |
331304 | 331304 | 2020-07-13 | Fayette | West Virginia | 54019 | 84 | 4 |
328118 | 328118 | 2020-07-12 | Fayette | West Virginia | 54019 | 81 | 4 |
324932 | 324932 | 2020-07-11 | Fayette | West Virginia | 54019 | 79 | 4 |
321751 | 321751 | 2020-07-10 | Fayette | West Virginia | 54019 | 79 | 4 |
318572 | 318572 | 2020-07-09 | Fayette | West Virginia | 54019 | 79 | 4 |
315399 | 315399 | 2020-07-08 | Fayette | West Virginia | 54019 | 78 | 4 |
312224 | 312224 | 2020-07-07 | Fayette | West Virginia | 54019 | 75 | 4 |
309055 | 309055 | 2020-07-06 | Fayette | West Virginia | 54019 | 72 | 4 |
305887 | 305887 | 2020-07-05 | Fayette | West Virginia | 54019 | 69 | 4 |
302723 | 302723 | 2020-07-04 | Fayette | West Virginia | 54019 | 67 | 4 |
299559 | 299559 | 2020-07-03 | Fayette | West Virginia | 54019 | 67 | 4 |
296397 | 296397 | 2020-07-02 | Fayette | West Virginia | 54019 | 67 | 4 |
293242 | 293242 | 2020-07-01 | Fayette | West Virginia | 54019 | 66 | 4 |
290089 | 290089 | 2020-06-30 | Fayette | West Virginia | 54019 | 66 | 4 |
286939 | 286939 | 2020-06-29 | Fayette | West Virginia | 54019 | 66 | 4 |
283793 | 283793 | 2020-06-28 | Fayette | West Virginia | 54019 | 67 | 4 |
280647 | 280647 | 2020-06-27 | Fayette | West Virginia | 54019 | 64 | 4 |
277499 | 277499 | 2020-06-26 | Fayette | West Virginia | 54019 | 62 | 4 |
274351 | 274351 | 2020-06-25 | Fayette | West Virginia | 54019 | 64 | 4 |
271211 | 271211 | 2020-06-24 | Fayette | West Virginia | 54019 | 62 | 4 |
268077 | 268077 | 2020-06-23 | Fayette | West Virginia | 54019 | 59 | 4 |
264948 | 264948 | 2020-06-22 | Fayette | West Virginia | 54019 | 59 | 4 |
261819 | 261819 | 2020-06-21 | Fayette | West Virginia | 54019 | 58 | 4 |
258692 | 258692 | 2020-06-20 | Fayette | West Virginia | 54019 | 57 | 4 |
255565 | 255565 | 2020-06-19 | Fayette | West Virginia | 54019 | 56 | 4 |
252446 | 252446 | 2020-06-18 | Fayette | West Virginia | 54019 | 56 | 4 |
249331 | 249331 | 2020-06-17 | Fayette | West Virginia | 54019 | 54 | 4 |
246219 | 246219 | 2020-06-16 | Fayette | West Virginia | 54019 | 54 | 4 |
243106 | 243106 | 2020-06-15 | Fayette | West Virginia | 54019 | 54 | 4 |
239995 | 239995 | 2020-06-14 | Fayette | West Virginia | 54019 | 54 | 4 |
236887 | 236887 | 2020-06-13 | Fayette | West Virginia | 54019 | 54 | 4 |
233780 | 233780 | 2020-06-12 | Fayette | West Virginia | 54019 | 54 | 4 |
230675 | 230675 | 2020-06-11 | Fayette | West Virginia | 54019 | 54 | 4 |
227571 | 227571 | 2020-06-10 | Fayette | West Virginia | 54019 | 54 | 4 |
224471 | 224471 | 2020-06-09 | Fayette | West Virginia | 54019 | 54 | 4 |
221375 | 221375 | 2020-06-08 | Fayette | West Virginia | 54019 | 54 | 4 |
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);