ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
711 rows where county = "Unknown" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923050 | 923050 | 2021-01-12 | Unknown | Tennessee | 12463 | 105 | |
919805 | 919805 | 2021-01-11 | Unknown | Tennessee | 12547 | 100 | |
916560 | 916560 | 2021-01-10 | Unknown | Tennessee | 12618 | 99 | |
913315 | 913315 | 2021-01-09 | Unknown | Tennessee | 11506 | 89 | |
910070 | 910070 | 2021-01-08 | Unknown | Tennessee | 11342 | 96 | |
906825 | 906825 | 2021-01-07 | Unknown | Tennessee | 10140 | 77 | |
903579 | 903579 | 2021-01-06 | Unknown | Tennessee | 8998 | 73 | |
900334 | 900334 | 2021-01-05 | Unknown | Tennessee | 7910 | 75 | |
897089 | 897089 | 2021-01-04 | Unknown | Tennessee | 7038 | 63 | |
893843 | 893843 | 2021-01-03 | Unknown | Tennessee | 6742 | 61 | |
890597 | 890597 | 2021-01-02 | Unknown | Tennessee | 7618 | 57 | |
887350 | 887350 | 2021-01-01 | Unknown | Tennessee | 5946 | 57 | |
884105 | 884105 | 2020-12-31 | Unknown | Tennessee | 6903 | 59 | |
880860 | 880860 | 2020-12-30 | Unknown | Tennessee | 7679 | 50 | |
877615 | 877615 | 2020-12-29 | Unknown | Tennessee | 5056 | 46 | |
874370 | 874370 | 2020-12-28 | Unknown | Tennessee | 5048 | 41 | |
871125 | 871125 | 2020-12-27 | Unknown | Tennessee | 4626 | 41 | |
867880 | 867880 | 2020-12-26 | Unknown | Tennessee | 5917 | 44 | |
864635 | 864635 | 2020-12-25 | Unknown | Tennessee | 6232 | 43 | |
861390 | 861390 | 2020-12-24 | Unknown | Tennessee | 4887 | 48 | |
858145 | 858145 | 2020-12-23 | Unknown | Tennessee | 4939 | 48 | |
854900 | 854900 | 2020-12-22 | Unknown | Tennessee | 2497 | 43 | |
851655 | 851655 | 2020-12-21 | Unknown | Tennessee | 4353 | 39 | |
848410 | 848410 | 2020-12-20 | Unknown | Tennessee | 3052 | 38 | |
845165 | 845165 | 2020-12-19 | Unknown | Tennessee | 0 | 37 | |
841919 | 841919 | 2020-12-18 | Unknown | Tennessee | 3264 | 42 | |
838674 | 838674 | 2020-12-17 | Unknown | Tennessee | 2489 | 47 | |
835428 | 835428 | 2020-12-16 | Unknown | Tennessee | 1932 | 34 | |
832182 | 832182 | 2020-12-15 | Unknown | Tennessee | 1023 | 35 | |
828935 | 828935 | 2020-12-14 | Unknown | Tennessee | 1525 | 31 | |
825689 | 825689 | 2020-12-13 | Unknown | Tennessee | 2087 | 33 | |
822442 | 822442 | 2020-12-12 | Unknown | Tennessee | 1275 | 28 | |
819196 | 819196 | 2020-12-11 | Unknown | Tennessee | 589 | 29 | |
815950 | 815950 | 2020-12-10 | Unknown | Tennessee | 511 | 25 | |
812704 | 812704 | 2020-12-09 | Unknown | Tennessee | 661 | 17 | |
809460 | 809460 | 2020-12-08 | Unknown | Tennessee | 486 | 18 | |
806215 | 806215 | 2020-12-07 | Unknown | Tennessee | 669 | 15 | |
802970 | 802970 | 2020-12-06 | Unknown | Tennessee | 0 | 14 | |
799725 | 799725 | 2020-12-05 | Unknown | Tennessee | 315 | 1 | |
796480 | 796480 | 2020-12-04 | Unknown | Tennessee | 166 | 4 | |
793235 | 793235 | 2020-12-03 | Unknown | Tennessee | 285 | 1 | |
789990 | 789990 | 2020-12-02 | Unknown | Tennessee | 641 | 0 | |
786745 | 786745 | 2020-12-01 | Unknown | Tennessee | 676 | 0 | |
783501 | 783501 | 2020-11-30 | Unknown | Tennessee | 1108 | 3 | |
780256 | 780256 | 2020-11-29 | Unknown | Tennessee | 2278 | 7 | |
777010 | 777010 | 2020-11-28 | Unknown | Tennessee | 2198 | 8 | |
773765 | 773765 | 2020-11-27 | Unknown | Tennessee | 1387 | 10 | |
770520 | 770520 | 2020-11-26 | Unknown | Tennessee | 931 | 13 | |
767274 | 767274 | 2020-11-25 | Unknown | Tennessee | 34 | 10 | |
764029 | 764029 | 2020-11-24 | Unknown | Tennessee | 49 | 6 | |
760784 | 760784 | 2020-11-23 | Unknown | Tennessee | 389 | 2 | |
757539 | 757539 | 2020-11-22 | Unknown | Tennessee | 255 | 2 | |
754292 | 754292 | 2020-11-21 | Unknown | Tennessee | 438 | 1 | |
751046 | 751046 | 2020-11-20 | Unknown | Tennessee | 147 | 1 | |
747800 | 747800 | 2020-11-19 | Unknown | Tennessee | 227 | 1 | |
744554 | 744554 | 2020-11-18 | Unknown | Tennessee | 994 | 0 | |
741307 | 741307 | 2020-11-17 | Unknown | Tennessee | 526 | 0 | |
738061 | 738061 | 2020-11-16 | Unknown | Tennessee | 1678 | 0 | |
734817 | 734817 | 2020-11-15 | Unknown | Tennessee | 839 | 0 | |
731571 | 731571 | 2020-11-14 | Unknown | Tennessee | 272 | 0 | |
725083 | 725083 | 2020-11-12 | Unknown | Tennessee | 37 | 0 | |
721840 | 721840 | 2020-11-11 | Unknown | Tennessee | 262 | 0 | |
718597 | 718597 | 2020-11-10 | Unknown | Tennessee | 34 | 0 | |
715354 | 715354 | 2020-11-09 | Unknown | Tennessee | 867 | 0 | |
712110 | 712110 | 2020-11-08 | Unknown | Tennessee | 201 | 0 | |
708866 | 708866 | 2020-11-07 | Unknown | Tennessee | 423 | 0 | |
699136 | 699136 | 2020-11-04 | Unknown | Tennessee | 132 | 0 | |
666704 | 666704 | 2020-10-25 | Unknown | Tennessee | 159 | 0 | |
663459 | 663459 | 2020-10-24 | Unknown | Tennessee | 382 | 0 | |
660215 | 660215 | 2020-10-23 | Unknown | Tennessee | 535 | 0 | |
656971 | 656971 | 2020-10-22 | Unknown | Tennessee | 460 | 0 | |
653726 | 653726 | 2020-10-21 | Unknown | Tennessee | 643 | 0 | |
650481 | 650481 | 2020-10-20 | Unknown | Tennessee | 442 | 0 | |
647237 | 647237 | 2020-10-19 | Unknown | Tennessee | 1041 | 0 | |
643991 | 643991 | 2020-10-18 | Unknown | Tennessee | 604 | 0 | |
640743 | 640743 | 2020-10-17 | Unknown | Tennessee | 503 | 0 | |
634251 | 634251 | 2020-10-15 | Unknown | Tennessee | 403 | 0 | |
631006 | 631006 | 2020-10-14 | Unknown | Tennessee | 129 | 0 | |
627762 | 627762 | 2020-10-13 | Unknown | Tennessee | 222 | 0 | |
624520 | 624520 | 2020-10-12 | Unknown | Tennessee | 743 | 2 | |
621277 | 621277 | 2020-10-11 | Unknown | Tennessee | 288 | 2 | |
618034 | 618034 | 2020-10-10 | Unknown | Tennessee | 153 | 1 | |
614792 | 614792 | 2020-10-09 | Unknown | Tennessee | 118 | 0 | |
611551 | 611551 | 2020-10-08 | Unknown | Tennessee | 164 | 7 | |
608309 | 608309 | 2020-10-07 | Unknown | Tennessee | 36 | 4 | |
605066 | 605066 | 2020-10-06 | Unknown | Tennessee | 157 | 6 | |
601824 | 601824 | 2020-10-05 | Unknown | Tennessee | 241 | 3 | |
598581 | 598581 | 2020-10-04 | Unknown | Tennessee | 0 | 3 | |
595338 | 595338 | 2020-10-03 | Unknown | Tennessee | 0 | 3 | |
588856 | 588856 | 2020-10-01 | Unknown | Tennessee | 0 | 1 | |
579136 | 579136 | 2020-09-28 | Unknown | Tennessee | 0 | 3 | |
575895 | 575895 | 2020-09-27 | Unknown | Tennessee | 51 | 3 | |
572651 | 572651 | 2020-09-26 | Unknown | Tennessee | 0 | 3 | |
569409 | 569409 | 2020-09-25 | Unknown | Tennessee | 0 | 1 | |
566168 | 566168 | 2020-09-24 | Unknown | Tennessee | 0 | 2 | |
562927 | 562927 | 2020-09-23 | Unknown | Tennessee | 0 | 4 | |
556453 | 556453 | 2020-09-21 | Unknown | Tennessee | 0 | 3 | |
553216 | 553216 | 2020-09-20 | Unknown | Tennessee | 0 | 2 | |
549977 | 549977 | 2020-09-19 | Unknown | Tennessee | 0 | 2 | |
546738 | 546738 | 2020-09-18 | Unknown | Tennessee | 0 | 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);