ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clay" and fips = 47027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922976 | 922976 | 2021-01-12 | Clay | Tennessee | 47027 | 896 | 25 |
919731 | 919731 | 2021-01-11 | Clay | Tennessee | 47027 | 894 | 25 |
916486 | 916486 | 2021-01-10 | Clay | Tennessee | 47027 | 894 | 25 |
913241 | 913241 | 2021-01-09 | Clay | Tennessee | 47027 | 888 | 25 |
909996 | 909996 | 2021-01-08 | Clay | Tennessee | 47027 | 876 | 24 |
906751 | 906751 | 2021-01-07 | Clay | Tennessee | 47027 | 873 | 24 |
903505 | 903505 | 2021-01-06 | Clay | Tennessee | 47027 | 864 | 23 |
900260 | 900260 | 2021-01-05 | Clay | Tennessee | 47027 | 859 | 23 |
897015 | 897015 | 2021-01-04 | Clay | Tennessee | 47027 | 854 | 23 |
893769 | 893769 | 2021-01-03 | Clay | Tennessee | 47027 | 854 | 23 |
890523 | 890523 | 2021-01-02 | Clay | Tennessee | 47027 | 853 | 23 |
887276 | 887276 | 2021-01-01 | Clay | Tennessee | 47027 | 845 | 23 |
884031 | 884031 | 2020-12-31 | Clay | Tennessee | 47027 | 845 | 23 |
880786 | 880786 | 2020-12-30 | Clay | Tennessee | 47027 | 840 | 23 |
877541 | 877541 | 2020-12-29 | Clay | Tennessee | 47027 | 829 | 23 |
874296 | 874296 | 2020-12-28 | Clay | Tennessee | 47027 | 825 | 23 |
871051 | 871051 | 2020-12-27 | Clay | Tennessee | 47027 | 823 | 23 |
867806 | 867806 | 2020-12-26 | Clay | Tennessee | 47027 | 823 | 23 |
864561 | 864561 | 2020-12-25 | Clay | Tennessee | 47027 | 822 | 23 |
861316 | 861316 | 2020-12-24 | Clay | Tennessee | 47027 | 808 | 23 |
858071 | 858071 | 2020-12-23 | Clay | Tennessee | 47027 | 796 | 23 |
854826 | 854826 | 2020-12-22 | Clay | Tennessee | 47027 | 787 | 21 |
851581 | 851581 | 2020-12-21 | Clay | Tennessee | 47027 | 782 | 21 |
848336 | 848336 | 2020-12-20 | Clay | Tennessee | 47027 | 776 | 21 |
845091 | 845091 | 2020-12-19 | Clay | Tennessee | 47027 | 768 | 21 |
841845 | 841845 | 2020-12-18 | Clay | Tennessee | 47027 | 758 | 21 |
838600 | 838600 | 2020-12-17 | Clay | Tennessee | 47027 | 740 | 21 |
835354 | 835354 | 2020-12-16 | Clay | Tennessee | 47027 | 706 | 19 |
832108 | 832108 | 2020-12-15 | Clay | Tennessee | 47027 | 687 | 19 |
828861 | 828861 | 2020-12-14 | Clay | Tennessee | 47027 | 676 | 19 |
825615 | 825615 | 2020-12-13 | Clay | Tennessee | 47027 | 663 | 19 |
822368 | 822368 | 2020-12-12 | Clay | Tennessee | 47027 | 655 | 19 |
819122 | 819122 | 2020-12-11 | Clay | Tennessee | 47027 | 647 | 19 |
815876 | 815876 | 2020-12-10 | Clay | Tennessee | 47027 | 629 | 19 |
812630 | 812630 | 2020-12-09 | Clay | Tennessee | 47027 | 614 | 19 |
809386 | 809386 | 2020-12-08 | Clay | Tennessee | 47027 | 610 | 19 |
806141 | 806141 | 2020-12-07 | Clay | Tennessee | 47027 | 605 | 19 |
802896 | 802896 | 2020-12-06 | Clay | Tennessee | 47027 | 596 | 19 |
799651 | 799651 | 2020-12-05 | Clay | Tennessee | 47027 | 586 | 19 |
796406 | 796406 | 2020-12-04 | Clay | Tennessee | 47027 | 578 | 19 |
793161 | 793161 | 2020-12-03 | Clay | Tennessee | 47027 | 571 | 19 |
789916 | 789916 | 2020-12-02 | Clay | Tennessee | 47027 | 571 | 18 |
786671 | 786671 | 2020-12-01 | Clay | Tennessee | 47027 | 562 | 18 |
783427 | 783427 | 2020-11-30 | Clay | Tennessee | 47027 | 560 | 18 |
780182 | 780182 | 2020-11-29 | Clay | Tennessee | 47027 | 554 | 18 |
776936 | 776936 | 2020-11-28 | Clay | Tennessee | 47027 | 553 | 18 |
773691 | 773691 | 2020-11-27 | Clay | Tennessee | 47027 | 540 | 18 |
770446 | 770446 | 2020-11-26 | Clay | Tennessee | 47027 | 538 | 18 |
767200 | 767200 | 2020-11-25 | Clay | Tennessee | 47027 | 533 | 18 |
763955 | 763955 | 2020-11-24 | Clay | Tennessee | 47027 | 528 | 18 |
760710 | 760710 | 2020-11-23 | Clay | Tennessee | 47027 | 525 | 18 |
757465 | 757465 | 2020-11-22 | Clay | Tennessee | 47027 | 524 | 18 |
754218 | 754218 | 2020-11-21 | Clay | Tennessee | 47027 | 520 | 18 |
750972 | 750972 | 2020-11-20 | Clay | Tennessee | 47027 | 519 | 18 |
747726 | 747726 | 2020-11-19 | Clay | Tennessee | 47027 | 510 | 18 |
744480 | 744480 | 2020-11-18 | Clay | Tennessee | 47027 | 497 | 17 |
741233 | 741233 | 2020-11-17 | Clay | Tennessee | 47027 | 485 | 17 |
737987 | 737987 | 2020-11-16 | Clay | Tennessee | 47027 | 479 | 17 |
734743 | 734743 | 2020-11-15 | Clay | Tennessee | 47027 | 474 | 16 |
731497 | 731497 | 2020-11-14 | Clay | Tennessee | 47027 | 470 | 16 |
728253 | 728253 | 2020-11-13 | Clay | Tennessee | 47027 | 469 | 16 |
725009 | 725009 | 2020-11-12 | Clay | Tennessee | 47027 | 461 | 17 |
721766 | 721766 | 2020-11-11 | Clay | Tennessee | 47027 | 454 | 17 |
718523 | 718523 | 2020-11-10 | Clay | Tennessee | 47027 | 454 | 17 |
715280 | 715280 | 2020-11-09 | Clay | Tennessee | 47027 | 447 | 17 |
712036 | 712036 | 2020-11-08 | Clay | Tennessee | 47027 | 446 | 17 |
708792 | 708792 | 2020-11-07 | Clay | Tennessee | 47027 | 443 | 17 |
705549 | 705549 | 2020-11-06 | Clay | Tennessee | 47027 | 437 | 16 |
702306 | 702306 | 2020-11-05 | Clay | Tennessee | 47027 | 433 | 16 |
699062 | 699062 | 2020-11-04 | Clay | Tennessee | 47027 | 432 | 16 |
695819 | 695819 | 2020-11-03 | Clay | Tennessee | 47027 | 431 | 16 |
692577 | 692577 | 2020-11-02 | Clay | Tennessee | 47027 | 427 | 16 |
689333 | 689333 | 2020-11-01 | Clay | Tennessee | 47027 | 426 | 16 |
686088 | 686088 | 2020-10-31 | Clay | Tennessee | 47027 | 425 | 16 |
682845 | 682845 | 2020-10-30 | Clay | Tennessee | 47027 | 422 | 16 |
679602 | 679602 | 2020-10-29 | Clay | Tennessee | 47027 | 418 | 15 |
676359 | 676359 | 2020-10-28 | Clay | Tennessee | 47027 | 415 | 15 |
673116 | 673116 | 2020-10-27 | Clay | Tennessee | 47027 | 410 | 15 |
669874 | 669874 | 2020-10-26 | Clay | Tennessee | 47027 | 406 | 15 |
666630 | 666630 | 2020-10-25 | Clay | Tennessee | 47027 | 406 | 13 |
663385 | 663385 | 2020-10-24 | Clay | Tennessee | 47027 | 401 | 13 |
660141 | 660141 | 2020-10-23 | Clay | Tennessee | 47027 | 394 | 13 |
656897 | 656897 | 2020-10-22 | Clay | Tennessee | 47027 | 383 | 14 |
653652 | 653652 | 2020-10-21 | Clay | Tennessee | 47027 | 379 | 13 |
650407 | 650407 | 2020-10-20 | Clay | Tennessee | 47027 | 371 | 12 |
647163 | 647163 | 2020-10-19 | Clay | Tennessee | 47027 | 363 | 12 |
643917 | 643917 | 2020-10-18 | Clay | Tennessee | 47027 | 362 | 9 |
640669 | 640669 | 2020-10-17 | Clay | Tennessee | 47027 | 355 | 9 |
637423 | 637423 | 2020-10-16 | Clay | Tennessee | 47027 | 351 | 7 |
634177 | 634177 | 2020-10-15 | Clay | Tennessee | 47027 | 351 | 7 |
630932 | 630932 | 2020-10-14 | Clay | Tennessee | 47027 | 344 | 6 |
627688 | 627688 | 2020-10-13 | Clay | Tennessee | 47027 | 325 | 6 |
624446 | 624446 | 2020-10-12 | Clay | Tennessee | 47027 | 320 | 6 |
621203 | 621203 | 2020-10-11 | Clay | Tennessee | 47027 | 313 | 6 |
617960 | 617960 | 2020-10-10 | Clay | Tennessee | 47027 | 305 | 6 |
614718 | 614718 | 2020-10-09 | Clay | Tennessee | 47027 | 292 | 6 |
611477 | 611477 | 2020-10-08 | Clay | Tennessee | 47027 | 281 | 6 |
608235 | 608235 | 2020-10-07 | Clay | Tennessee | 47027 | 272 | 6 |
604992 | 604992 | 2020-10-06 | Clay | Tennessee | 47027 | 267 | 6 |
601750 | 601750 | 2020-10-05 | Clay | Tennessee | 47027 | 267 | 6 |
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);