ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Anderson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955417 | 955417 | 2021-01-22 | Anderson | Tennessee | 47001 | 6947 | 114 |
952172 | 952172 | 2021-01-21 | Anderson | Tennessee | 47001 | 6904 | 112 |
948927 | 948927 | 2021-01-20 | Anderson | Tennessee | 47001 | 6864 | 107 |
945681 | 945681 | 2021-01-19 | Anderson | Tennessee | 47001 | 6818 | 104 |
942434 | 942434 | 2021-01-18 | Anderson | Tennessee | 47001 | 6792 | 103 |
939189 | 939189 | 2021-01-17 | Anderson | Tennessee | 47001 | 6759 | 102 |
935944 | 935944 | 2021-01-16 | Anderson | Tennessee | 47001 | 6723 | 102 |
932699 | 932699 | 2021-01-15 | Anderson | Tennessee | 47001 | 6678 | 101 |
929454 | 929454 | 2021-01-14 | Anderson | Tennessee | 47001 | 6623 | 101 |
926209 | 926209 | 2021-01-13 | Anderson | Tennessee | 47001 | 6553 | 96 |
922963 | 922963 | 2021-01-12 | Anderson | Tennessee | 47001 | 6506 | 93 |
919718 | 919718 | 2021-01-11 | Anderson | Tennessee | 47001 | 6473 | 91 |
916473 | 916473 | 2021-01-10 | Anderson | Tennessee | 47001 | 6433 | 90 |
913228 | 913228 | 2021-01-09 | Anderson | Tennessee | 47001 | 6323 | 88 |
909983 | 909983 | 2021-01-08 | Anderson | Tennessee | 47001 | 6268 | 86 |
906738 | 906738 | 2021-01-07 | Anderson | Tennessee | 47001 | 6192 | 81 |
903492 | 903492 | 2021-01-06 | Anderson | Tennessee | 47001 | 6072 | 80 |
900247 | 900247 | 2021-01-05 | Anderson | Tennessee | 47001 | 5998 | 75 |
897002 | 897002 | 2021-01-04 | Anderson | Tennessee | 47001 | 5957 | 73 |
893756 | 893756 | 2021-01-03 | Anderson | Tennessee | 47001 | 5936 | 72 |
890510 | 890510 | 2021-01-02 | Anderson | Tennessee | 47001 | 5879 | 72 |
887263 | 887263 | 2021-01-01 | Anderson | Tennessee | 47001 | 5631 | 72 |
884018 | 884018 | 2020-12-31 | Anderson | Tennessee | 47001 | 5631 | 72 |
880773 | 880773 | 2020-12-30 | Anderson | Tennessee | 47001 | 5595 | 66 |
877528 | 877528 | 2020-12-29 | Anderson | Tennessee | 47001 | 5516 | 60 |
874283 | 874283 | 2020-12-28 | Anderson | Tennessee | 47001 | 5461 | 58 |
871038 | 871038 | 2020-12-27 | Anderson | Tennessee | 47001 | 5402 | 56 |
867793 | 867793 | 2020-12-26 | Anderson | Tennessee | 47001 | 5373 | 55 |
864548 | 864548 | 2020-12-25 | Anderson | Tennessee | 47001 | 5305 | 55 |
861303 | 861303 | 2020-12-24 | Anderson | Tennessee | 47001 | 5218 | 55 |
858058 | 858058 | 2020-12-23 | Anderson | Tennessee | 47001 | 5150 | 54 |
854813 | 854813 | 2020-12-22 | Anderson | Tennessee | 47001 | 5085 | 52 |
851568 | 851568 | 2020-12-21 | Anderson | Tennessee | 47001 | 5045 | 51 |
848323 | 848323 | 2020-12-20 | Anderson | Tennessee | 47001 | 4926 | 48 |
845078 | 845078 | 2020-12-19 | Anderson | Tennessee | 47001 | 4809 | 46 |
841832 | 841832 | 2020-12-18 | Anderson | Tennessee | 47001 | 4705 | 46 |
838587 | 838587 | 2020-12-17 | Anderson | Tennessee | 47001 | 4550 | 45 |
835341 | 835341 | 2020-12-16 | Anderson | Tennessee | 47001 | 4461 | 43 |
832095 | 832095 | 2020-12-15 | Anderson | Tennessee | 47001 | 4363 | 41 |
828848 | 828848 | 2020-12-14 | Anderson | Tennessee | 47001 | 4205 | 40 |
825602 | 825602 | 2020-12-13 | Anderson | Tennessee | 47001 | 4073 | 40 |
822355 | 822355 | 2020-12-12 | Anderson | Tennessee | 47001 | 3868 | 39 |
819109 | 819109 | 2020-12-11 | Anderson | Tennessee | 47001 | 3804 | 39 |
815863 | 815863 | 2020-12-10 | Anderson | Tennessee | 47001 | 3741 | 38 |
812617 | 812617 | 2020-12-09 | Anderson | Tennessee | 47001 | 3675 | 35 |
809373 | 809373 | 2020-12-08 | Anderson | Tennessee | 47001 | 3560 | 35 |
806128 | 806128 | 2020-12-07 | Anderson | Tennessee | 47001 | 3499 | 34 |
802883 | 802883 | 2020-12-06 | Anderson | Tennessee | 47001 | 3361 | 32 |
799638 | 799638 | 2020-12-05 | Anderson | Tennessee | 47001 | 3330 | 32 |
796393 | 796393 | 2020-12-04 | Anderson | Tennessee | 47001 | 3272 | 32 |
793148 | 793148 | 2020-12-03 | Anderson | Tennessee | 47001 | 3239 | 31 |
789903 | 789903 | 2020-12-02 | Anderson | Tennessee | 47001 | 3197 | 30 |
786658 | 786658 | 2020-12-01 | Anderson | Tennessee | 47001 | 3167 | 30 |
783414 | 783414 | 2020-11-30 | Anderson | Tennessee | 47001 | 3107 | 29 |
780169 | 780169 | 2020-11-29 | Anderson | Tennessee | 47001 | 2987 | 29 |
776923 | 776923 | 2020-11-28 | Anderson | Tennessee | 47001 | 2946 | 29 |
773678 | 773678 | 2020-11-27 | Anderson | Tennessee | 47001 | 2833 | 28 |
770433 | 770433 | 2020-11-26 | Anderson | Tennessee | 47001 | 2806 | 28 |
767187 | 767187 | 2020-11-25 | Anderson | Tennessee | 47001 | 2765 | 28 |
763942 | 763942 | 2020-11-24 | Anderson | Tennessee | 47001 | 2744 | 27 |
760697 | 760697 | 2020-11-23 | Anderson | Tennessee | 47001 | 2737 | 25 |
757452 | 757452 | 2020-11-22 | Anderson | Tennessee | 47001 | 2715 | 25 |
754205 | 754205 | 2020-11-21 | Anderson | Tennessee | 47001 | 2650 | 25 |
750959 | 750959 | 2020-11-20 | Anderson | Tennessee | 47001 | 2589 | 25 |
747713 | 747713 | 2020-11-19 | Anderson | Tennessee | 47001 | 2535 | 25 |
744467 | 744467 | 2020-11-18 | Anderson | Tennessee | 47001 | 2510 | 25 |
741220 | 741220 | 2020-11-17 | Anderson | Tennessee | 47001 | 2488 | 25 |
737974 | 737974 | 2020-11-16 | Anderson | Tennessee | 47001 | 2452 | 23 |
734730 | 734730 | 2020-11-15 | Anderson | Tennessee | 47001 | 2359 | 23 |
731484 | 731484 | 2020-11-14 | Anderson | Tennessee | 47001 | 2311 | 22 |
728240 | 728240 | 2020-11-13 | Anderson | Tennessee | 47001 | 2272 | 21 |
724996 | 724996 | 2020-11-12 | Anderson | Tennessee | 47001 | 2227 | 19 |
721753 | 721753 | 2020-11-11 | Anderson | Tennessee | 47001 | 2206 | 19 |
718510 | 718510 | 2020-11-10 | Anderson | Tennessee | 47001 | 2185 | 18 |
715267 | 715267 | 2020-11-09 | Anderson | Tennessee | 47001 | 2176 | 18 |
712023 | 712023 | 2020-11-08 | Anderson | Tennessee | 47001 | 2123 | 18 |
708779 | 708779 | 2020-11-07 | Anderson | Tennessee | 47001 | 2061 | 18 |
705536 | 705536 | 2020-11-06 | Anderson | Tennessee | 47001 | 1998 | 18 |
702293 | 702293 | 2020-11-05 | Anderson | Tennessee | 47001 | 1959 | 18 |
699049 | 699049 | 2020-11-04 | Anderson | Tennessee | 47001 | 1938 | 18 |
695806 | 695806 | 2020-11-03 | Anderson | Tennessee | 47001 | 1909 | 16 |
692564 | 692564 | 2020-11-02 | Anderson | Tennessee | 47001 | 1902 | 16 |
689320 | 689320 | 2020-11-01 | Anderson | Tennessee | 47001 | 1869 | 16 |
686075 | 686075 | 2020-10-31 | Anderson | Tennessee | 47001 | 1868 | 16 |
682832 | 682832 | 2020-10-30 | Anderson | Tennessee | 47001 | 1848 | 16 |
679589 | 679589 | 2020-10-29 | Anderson | Tennessee | 47001 | 1813 | 14 |
676346 | 676346 | 2020-10-28 | Anderson | Tennessee | 47001 | 1767 | 14 |
673103 | 673103 | 2020-10-27 | Anderson | Tennessee | 47001 | 1727 | 14 |
669861 | 669861 | 2020-10-26 | Anderson | Tennessee | 47001 | 1697 | 13 |
666617 | 666617 | 2020-10-25 | Anderson | Tennessee | 47001 | 1688 | 14 |
663372 | 663372 | 2020-10-24 | Anderson | Tennessee | 47001 | 1666 | 14 |
660128 | 660128 | 2020-10-23 | Anderson | Tennessee | 47001 | 1646 | 14 |
656884 | 656884 | 2020-10-22 | Anderson | Tennessee | 47001 | 1611 | 14 |
653639 | 653639 | 2020-10-21 | Anderson | Tennessee | 47001 | 1596 | 13 |
650394 | 650394 | 2020-10-20 | Anderson | Tennessee | 47001 | 1567 | 13 |
647150 | 647150 | 2020-10-19 | Anderson | Tennessee | 47001 | 1555 | 13 |
643904 | 643904 | 2020-10-18 | Anderson | Tennessee | 47001 | 1544 | 13 |
640656 | 640656 | 2020-10-17 | Anderson | Tennessee | 47001 | 1526 | 13 |
637410 | 637410 | 2020-10-16 | Anderson | Tennessee | 47001 | 1498 | 13 |
634164 | 634164 | 2020-10-15 | Anderson | Tennessee | 47001 | 1486 | 13 |
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);