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 |
---|---|---|---|---|---|---|---|
1088487 | 1088487 | 2021-03-04 | Anderson | Tennessee | 47001 | 8044 | 158 |
1085242 | 1085242 | 2021-03-03 | Anderson | Tennessee | 47001 | 8027 | 158 |
1081996 | 1081996 | 2021-03-02 | Anderson | Tennessee | 47001 | 7991 | 157 |
1078750 | 1078750 | 2021-03-01 | Anderson | Tennessee | 47001 | 7981 | 156 |
1075505 | 1075505 | 2021-02-28 | Anderson | Tennessee | 47001 | 7971 | 156 |
1072259 | 1072259 | 2021-02-27 | Anderson | Tennessee | 47001 | 7953 | 156 |
1069013 | 1069013 | 2021-02-26 | Anderson | Tennessee | 47001 | 7941 | 156 |
1065768 | 1065768 | 2021-02-25 | Anderson | Tennessee | 47001 | 7922 | 156 |
1062523 | 1062523 | 2021-02-24 | Anderson | Tennessee | 47001 | 7893 | 155 |
1059278 | 1059278 | 2021-02-23 | Anderson | Tennessee | 47001 | 7874 | 155 |
1056032 | 1056032 | 2021-02-22 | Anderson | Tennessee | 47001 | 7863 | 153 |
1052786 | 1052786 | 2021-02-21 | Anderson | Tennessee | 47001 | 7853 | 152 |
1049539 | 1049539 | 2021-02-20 | Anderson | Tennessee | 47001 | 7838 | 150 |
1046292 | 1046292 | 2021-02-19 | Anderson | Tennessee | 47001 | 7817 | 149 |
1043047 | 1043047 | 2021-02-18 | Anderson | Tennessee | 47001 | 7794 | 149 |
1039802 | 1039802 | 2021-02-17 | Anderson | Tennessee | 47001 | 7778 | 149 |
1036557 | 1036557 | 2021-02-16 | Anderson | Tennessee | 47001 | 7746 | 149 |
1033312 | 1033312 | 2021-02-15 | Anderson | Tennessee | 47001 | 7708 | 149 |
1030066 | 1030066 | 2021-02-14 | Anderson | Tennessee | 47001 | 7675 | 149 |
1026819 | 1026819 | 2021-02-13 | Anderson | Tennessee | 47001 | 7644 | 147 |
1023574 | 1023574 | 2021-02-12 | Anderson | Tennessee | 47001 | 7597 | 147 |
1020329 | 1020329 | 2021-02-11 | Anderson | Tennessee | 47001 | 7576 | 147 |
1017084 | 1017084 | 2021-02-10 | Anderson | Tennessee | 47001 | 7524 | 148 |
1013839 | 1013839 | 2021-02-09 | Anderson | Tennessee | 47001 | 7432 | 147 |
1010594 | 1010594 | 2021-02-08 | Anderson | Tennessee | 47001 | 7387 | 145 |
1007348 | 1007348 | 2021-02-07 | Anderson | Tennessee | 47001 | 7377 | 143 |
1004102 | 1004102 | 2021-02-06 | Anderson | Tennessee | 47001 | 7359 | 143 |
1000856 | 1000856 | 2021-02-05 | Anderson | Tennessee | 47001 | 7337 | 142 |
997610 | 997610 | 2021-02-04 | Anderson | Tennessee | 47001 | 7307 | 140 |
994364 | 994364 | 2021-02-03 | Anderson | Tennessee | 47001 | 7290 | 138 |
991118 | 991118 | 2021-02-02 | Anderson | Tennessee | 47001 | 7264 | 134 |
987872 | 987872 | 2021-02-01 | Anderson | Tennessee | 47001 | 7248 | 129 |
984625 | 984625 | 2021-01-31 | Anderson | Tennessee | 47001 | 7239 | 128 |
981378 | 981378 | 2021-01-30 | Anderson | Tennessee | 47001 | 7208 | 127 |
978132 | 978132 | 2021-01-29 | Anderson | Tennessee | 47001 | 7181 | 125 |
974887 | 974887 | 2021-01-28 | Anderson | Tennessee | 47001 | 7103 | 124 |
971642 | 971642 | 2021-01-27 | Anderson | Tennessee | 47001 | 7085 | 120 |
968397 | 968397 | 2021-01-26 | Anderson | Tennessee | 47001 | 7054 | 116 |
965153 | 965153 | 2021-01-25 | Anderson | Tennessee | 47001 | 7031 | 116 |
961908 | 961908 | 2021-01-24 | Anderson | Tennessee | 47001 | 7013 | 114 |
958663 | 958663 | 2021-01-23 | Anderson | Tennessee | 47001 | 6983 | 114 |
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 |
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);