ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Clay" and fips = 54015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637986 | 637986 | 2020-10-16 | Clay | West Virginia | 54015 | 51 | 2 |
634741 | 634741 | 2020-10-15 | Clay | West Virginia | 54015 | 50 | 2 |
631496 | 631496 | 2020-10-14 | Clay | West Virginia | 54015 | 48 | 2 |
628252 | 628252 | 2020-10-13 | Clay | West Virginia | 54015 | 51 | 2 |
625009 | 625009 | 2020-10-12 | Clay | West Virginia | 54015 | 49 | 2 |
621766 | 621766 | 2020-10-11 | Clay | West Virginia | 54015 | 49 | 2 |
618523 | 618523 | 2020-10-10 | Clay | West Virginia | 54015 | 48 | 2 |
615281 | 615281 | 2020-10-09 | Clay | West Virginia | 54015 | 48 | 2 |
612040 | 612040 | 2020-10-08 | Clay | West Virginia | 54015 | 44 | 2 |
608798 | 608798 | 2020-10-07 | Clay | West Virginia | 54015 | 43 | 2 |
605555 | 605555 | 2020-10-06 | Clay | West Virginia | 54015 | 37 | 2 |
602313 | 602313 | 2020-10-05 | Clay | West Virginia | 54015 | 37 | 2 |
599070 | 599070 | 2020-10-04 | Clay | West Virginia | 54015 | 37 | 2 |
595827 | 595827 | 2020-10-03 | Clay | West Virginia | 54015 | 37 | 2 |
592585 | 592585 | 2020-10-02 | Clay | West Virginia | 54015 | 37 | 2 |
589345 | 589345 | 2020-10-01 | Clay | West Virginia | 54015 | 37 | 2 |
586104 | 586104 | 2020-09-30 | Clay | West Virginia | 54015 | 37 | 2 |
582864 | 582864 | 2020-09-29 | Clay | West Virginia | 54015 | 36 | 2 |
579625 | 579625 | 2020-09-28 | Clay | West Virginia | 54015 | 36 | 2 |
576384 | 576384 | 2020-09-27 | Clay | West Virginia | 54015 | 35 | 2 |
573140 | 573140 | 2020-09-26 | Clay | West Virginia | 54015 | 34 | 2 |
569898 | 569898 | 2020-09-25 | Clay | West Virginia | 54015 | 34 | 2 |
566657 | 566657 | 2020-09-24 | Clay | West Virginia | 54015 | 34 | 2 |
563416 | 563416 | 2020-09-23 | Clay | West Virginia | 54015 | 36 | 2 |
560177 | 560177 | 2020-09-22 | Clay | West Virginia | 54015 | 35 | 2 |
556941 | 556941 | 2020-09-21 | Clay | West Virginia | 54015 | 34 | 2 |
553704 | 553704 | 2020-09-20 | Clay | West Virginia | 54015 | 35 | 2 |
550465 | 550465 | 2020-09-19 | Clay | West Virginia | 54015 | 34 | 2 |
547226 | 547226 | 2020-09-18 | Clay | West Virginia | 54015 | 33 | 2 |
543989 | 543989 | 2020-09-17 | Clay | West Virginia | 54015 | 33 | 2 |
540753 | 540753 | 2020-09-16 | Clay | West Virginia | 54015 | 32 | 2 |
537516 | 537516 | 2020-09-15 | Clay | West Virginia | 54015 | 30 | 2 |
534280 | 534280 | 2020-09-14 | Clay | West Virginia | 54015 | 29 | 2 |
531045 | 531045 | 2020-09-13 | Clay | West Virginia | 54015 | 30 | 2 |
527808 | 527808 | 2020-09-12 | Clay | West Virginia | 54015 | 30 | 2 |
524572 | 524572 | 2020-09-11 | Clay | West Virginia | 54015 | 30 | 2 |
521336 | 521336 | 2020-09-10 | Clay | West Virginia | 54015 | 30 | 2 |
518099 | 518099 | 2020-09-09 | Clay | West Virginia | 54015 | 30 | 2 |
514864 | 514864 | 2020-09-08 | Clay | West Virginia | 54015 | 29 | 2 |
511631 | 511631 | 2020-09-07 | Clay | West Virginia | 54015 | 29 | 2 |
508398 | 508398 | 2020-09-06 | Clay | West Virginia | 54015 | 29 | 2 |
505166 | 505166 | 2020-09-05 | Clay | West Virginia | 54015 | 29 | 2 |
501932 | 501932 | 2020-09-04 | Clay | West Virginia | 54015 | 27 | 2 |
498698 | 498698 | 2020-09-03 | Clay | West Virginia | 54015 | 27 | 2 |
495465 | 495465 | 2020-09-02 | Clay | West Virginia | 54015 | 27 | 2 |
492231 | 492231 | 2020-09-01 | Clay | West Virginia | 54015 | 27 | 2 |
488998 | 488998 | 2020-08-31 | Clay | West Virginia | 54015 | 27 | 2 |
485765 | 485765 | 2020-08-30 | Clay | West Virginia | 54015 | 26 | 2 |
482530 | 482530 | 2020-08-29 | Clay | West Virginia | 54015 | 20 | 2 |
479296 | 479296 | 2020-08-28 | Clay | West Virginia | 54015 | 20 | 2 |
476063 | 476063 | 2020-08-27 | Clay | West Virginia | 54015 | 19 | 2 |
472830 | 472830 | 2020-08-26 | Clay | West Virginia | 54015 | 19 | 1 |
469598 | 469598 | 2020-08-25 | Clay | West Virginia | 54015 | 19 | 1 |
466369 | 466369 | 2020-08-24 | Clay | West Virginia | 54015 | 19 | 1 |
463140 | 463140 | 2020-08-23 | Clay | West Virginia | 54015 | 19 | 1 |
459911 | 459911 | 2020-08-22 | Clay | West Virginia | 54015 | 19 | 1 |
456684 | 456684 | 2020-08-21 | Clay | West Virginia | 54015 | 19 | 1 |
453456 | 453456 | 2020-08-20 | Clay | West Virginia | 54015 | 19 | 1 |
450228 | 450228 | 2020-08-19 | Clay | West Virginia | 54015 | 18 | 1 |
447000 | 447000 | 2020-08-18 | Clay | West Virginia | 54015 | 18 | 1 |
443773 | 443773 | 2020-08-17 | Clay | West Virginia | 54015 | 18 | 1 |
440547 | 440547 | 2020-08-16 | Clay | West Virginia | 54015 | 18 | 1 |
437321 | 437321 | 2020-08-15 | Clay | West Virginia | 54015 | 18 | 1 |
434095 | 434095 | 2020-08-14 | Clay | West Virginia | 54015 | 18 | 1 |
430870 | 430870 | 2020-08-13 | Clay | West Virginia | 54015 | 18 | 1 |
427642 | 427642 | 2020-08-12 | Clay | West Virginia | 54015 | 18 | 1 |
424418 | 424418 | 2020-08-11 | Clay | West Virginia | 54015 | 18 | 1 |
421197 | 421197 | 2020-08-10 | Clay | West Virginia | 54015 | 18 | 1 |
417976 | 417976 | 2020-08-09 | Clay | West Virginia | 54015 | 18 | 1 |
414755 | 414755 | 2020-08-08 | Clay | West Virginia | 54015 | 18 | 1 |
411535 | 411535 | 2020-08-07 | Clay | West Virginia | 54015 | 18 | 1 |
408316 | 408316 | 2020-08-06 | Clay | West Virginia | 54015 | 18 | 1 |
405096 | 405096 | 2020-08-05 | Clay | West Virginia | 54015 | 18 | 1 |
401878 | 401878 | 2020-08-04 | Clay | West Virginia | 54015 | 18 | 1 |
398662 | 398662 | 2020-08-03 | Clay | West Virginia | 54015 | 17 | 1 |
395446 | 395446 | 2020-08-02 | Clay | West Virginia | 54015 | 17 | 1 |
392230 | 392230 | 2020-08-01 | Clay | West Virginia | 54015 | 17 | 1 |
389013 | 389013 | 2020-07-31 | Clay | West Virginia | 54015 | 17 | 1 |
385796 | 385796 | 2020-07-30 | Clay | West Virginia | 54015 | 17 | 1 |
382578 | 382578 | 2020-07-29 | Clay | West Virginia | 54015 | 17 | 1 |
379361 | 379361 | 2020-07-28 | Clay | West Virginia | 54015 | 17 | 1 |
376145 | 376145 | 2020-07-27 | Clay | West Virginia | 54015 | 17 | 1 |
372931 | 372931 | 2020-07-26 | Clay | West Virginia | 54015 | 17 | 1 |
369719 | 369719 | 2020-07-25 | Clay | West Virginia | 54015 | 17 | 1 |
366510 | 366510 | 2020-07-24 | Clay | West Virginia | 54015 | 17 | 1 |
363303 | 363303 | 2020-07-23 | Clay | West Virginia | 54015 | 17 | 1 |
360097 | 360097 | 2020-07-22 | Clay | West Virginia | 54015 | 17 | 1 |
356892 | 356892 | 2020-07-21 | Clay | West Virginia | 54015 | 17 | 1 |
353689 | 353689 | 2020-07-20 | Clay | West Virginia | 54015 | 17 | 1 |
350487 | 350487 | 2020-07-19 | Clay | West Virginia | 54015 | 15 | 1 |
347286 | 347286 | 2020-07-18 | Clay | West Virginia | 54015 | 15 | 1 |
344086 | 344086 | 2020-07-17 | Clay | West Virginia | 54015 | 15 | 1 |
340887 | 340887 | 2020-07-16 | Clay | West Virginia | 54015 | 14 | 1 |
337691 | 337691 | 2020-07-15 | Clay | West Virginia | 54015 | 13 | 1 |
334496 | 334496 | 2020-07-14 | Clay | West Virginia | 54015 | 13 | 1 |
331303 | 331303 | 2020-07-13 | Clay | West Virginia | 54015 | 12 | 1 |
328117 | 328117 | 2020-07-12 | Clay | West Virginia | 54015 | 12 | 1 |
324931 | 324931 | 2020-07-11 | Clay | West Virginia | 54015 | 12 | 1 |
321750 | 321750 | 2020-07-10 | Clay | West Virginia | 54015 | 11 | 1 |
318571 | 318571 | 2020-07-09 | Clay | West Virginia | 54015 | 11 | 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);