ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Montgomery" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091795 | 1091795 | 2021-03-05 | Montgomery | Tennessee | 47125 | 17505 | 213 |
1088549 | 1088549 | 2021-03-04 | Montgomery | Tennessee | 47125 | 17484 | 213 |
1085304 | 1085304 | 2021-03-03 | Montgomery | Tennessee | 47125 | 17440 | 213 |
1082058 | 1082058 | 2021-03-02 | Montgomery | Tennessee | 47125 | 17414 | 213 |
1078812 | 1078812 | 2021-03-01 | Montgomery | Tennessee | 47125 | 17399 | 213 |
1075567 | 1075567 | 2021-02-28 | Montgomery | Tennessee | 47125 | 17380 | 212 |
1072321 | 1072321 | 2021-02-27 | Montgomery | Tennessee | 47125 | 17344 | 212 |
1069075 | 1069075 | 2021-02-26 | Montgomery | Tennessee | 47125 | 17310 | 212 |
1065830 | 1065830 | 2021-02-25 | Montgomery | Tennessee | 47125 | 17269 | 209 |
1062585 | 1062585 | 2021-02-24 | Montgomery | Tennessee | 47125 | 17207 | 207 |
1059340 | 1059340 | 2021-02-23 | Montgomery | Tennessee | 47125 | 17171 | 207 |
1056094 | 1056094 | 2021-02-22 | Montgomery | Tennessee | 47125 | 17150 | 205 |
1052848 | 1052848 | 2021-02-21 | Montgomery | Tennessee | 47125 | 17132 | 205 |
1049601 | 1049601 | 2021-02-20 | Montgomery | Tennessee | 47125 | 17074 | 204 |
1046354 | 1046354 | 2021-02-19 | Montgomery | Tennessee | 47125 | 17063 | 203 |
1043109 | 1043109 | 2021-02-18 | Montgomery | Tennessee | 47125 | 17025 | 203 |
1039864 | 1039864 | 2021-02-17 | Montgomery | Tennessee | 47125 | 17007 | 203 |
1036619 | 1036619 | 2021-02-16 | Montgomery | Tennessee | 47125 | 16995 | 202 |
1033374 | 1033374 | 2021-02-15 | Montgomery | Tennessee | 47125 | 16973 | 201 |
1030128 | 1030128 | 2021-02-14 | Montgomery | Tennessee | 47125 | 16937 | 201 |
1026881 | 1026881 | 2021-02-13 | Montgomery | Tennessee | 47125 | 16892 | 200 |
1023636 | 1023636 | 2021-02-12 | Montgomery | Tennessee | 47125 | 16832 | 200 |
1020391 | 1020391 | 2021-02-11 | Montgomery | Tennessee | 47125 | 16618 | 198 |
1017146 | 1017146 | 2021-02-10 | Montgomery | Tennessee | 47125 | 16477 | 190 |
1013901 | 1013901 | 2021-02-09 | Montgomery | Tennessee | 47125 | 16374 | 188 |
1010656 | 1010656 | 2021-02-08 | Montgomery | Tennessee | 47125 | 16329 | 188 |
1007410 | 1007410 | 2021-02-07 | Montgomery | Tennessee | 47125 | 16294 | 184 |
1004164 | 1004164 | 2021-02-06 | Montgomery | Tennessee | 47125 | 16210 | 184 |
1000918 | 1000918 | 2021-02-05 | Montgomery | Tennessee | 47125 | 16115 | 182 |
997672 | 997672 | 2021-02-04 | Montgomery | Tennessee | 47125 | 16004 | 173 |
994426 | 994426 | 2021-02-03 | Montgomery | Tennessee | 47125 | 15913 | 171 |
991180 | 991180 | 2021-02-02 | Montgomery | Tennessee | 47125 | 15868 | 166 |
987934 | 987934 | 2021-02-01 | Montgomery | Tennessee | 47125 | 15817 | 165 |
984687 | 984687 | 2021-01-31 | Montgomery | Tennessee | 47125 | 15765 | 164 |
981440 | 981440 | 2021-01-30 | Montgomery | Tennessee | 47125 | 15652 | 164 |
978194 | 978194 | 2021-01-29 | Montgomery | Tennessee | 47125 | 15591 | 162 |
974949 | 974949 | 2021-01-28 | Montgomery | Tennessee | 47125 | 15455 | 160 |
971704 | 971704 | 2021-01-27 | Montgomery | Tennessee | 47125 | 15388 | 158 |
968459 | 968459 | 2021-01-26 | Montgomery | Tennessee | 47125 | 15282 | 156 |
965215 | 965215 | 2021-01-25 | Montgomery | Tennessee | 47125 | 15200 | 153 |
961970 | 961970 | 2021-01-24 | Montgomery | Tennessee | 47125 | 15154 | 149 |
958725 | 958725 | 2021-01-23 | Montgomery | Tennessee | 47125 | 15092 | 149 |
955479 | 955479 | 2021-01-22 | Montgomery | Tennessee | 47125 | 14979 | 149 |
952234 | 952234 | 2021-01-21 | Montgomery | Tennessee | 47125 | 14836 | 149 |
948989 | 948989 | 2021-01-20 | Montgomery | Tennessee | 47125 | 14719 | 149 |
945743 | 945743 | 2021-01-19 | Montgomery | Tennessee | 47125 | 14507 | 149 |
942496 | 942496 | 2021-01-18 | Montgomery | Tennessee | 47125 | 14450 | 149 |
939251 | 939251 | 2021-01-17 | Montgomery | Tennessee | 47125 | 14367 | 149 |
936006 | 936006 | 2021-01-16 | Montgomery | Tennessee | 47125 | 14229 | 148 |
932761 | 932761 | 2021-01-15 | Montgomery | Tennessee | 47125 | 14085 | 148 |
929516 | 929516 | 2021-01-14 | Montgomery | Tennessee | 47125 | 13874 | 145 |
926271 | 926271 | 2021-01-13 | Montgomery | Tennessee | 47125 | 13667 | 145 |
923025 | 923025 | 2021-01-12 | Montgomery | Tennessee | 47125 | 13540 | 142 |
919780 | 919780 | 2021-01-11 | Montgomery | Tennessee | 47125 | 13456 | 140 |
916535 | 916535 | 2021-01-10 | Montgomery | Tennessee | 47125 | 13352 | 138 |
913290 | 913290 | 2021-01-09 | Montgomery | Tennessee | 47125 | 13123 | 136 |
910045 | 910045 | 2021-01-08 | Montgomery | Tennessee | 47125 | 12922 | 133 |
906800 | 906800 | 2021-01-07 | Montgomery | Tennessee | 47125 | 12751 | 132 |
903554 | 903554 | 2021-01-06 | Montgomery | Tennessee | 47125 | 12538 | 131 |
900309 | 900309 | 2021-01-05 | Montgomery | Tennessee | 47125 | 12263 | 129 |
897064 | 897064 | 2021-01-04 | Montgomery | Tennessee | 47125 | 12129 | 129 |
893818 | 893818 | 2021-01-03 | Montgomery | Tennessee | 47125 | 12026 | 128 |
890572 | 890572 | 2021-01-02 | Montgomery | Tennessee | 47125 | 11869 | 126 |
887325 | 887325 | 2021-01-01 | Montgomery | Tennessee | 47125 | 11511 | 126 |
884080 | 884080 | 2020-12-31 | Montgomery | Tennessee | 47125 | 11511 | 126 |
880835 | 880835 | 2020-12-30 | Montgomery | Tennessee | 47125 | 11385 | 124 |
877590 | 877590 | 2020-12-29 | Montgomery | Tennessee | 47125 | 11166 | 123 |
874345 | 874345 | 2020-12-28 | Montgomery | Tennessee | 47125 | 11076 | 121 |
871100 | 871100 | 2020-12-27 | Montgomery | Tennessee | 47125 | 11021 | 118 |
867855 | 867855 | 2020-12-26 | Montgomery | Tennessee | 47125 | 10951 | 116 |
864610 | 864610 | 2020-12-25 | Montgomery | Tennessee | 47125 | 10852 | 116 |
861365 | 861365 | 2020-12-24 | Montgomery | Tennessee | 47125 | 10660 | 116 |
858120 | 858120 | 2020-12-23 | Montgomery | Tennessee | 47125 | 10537 | 115 |
854875 | 854875 | 2020-12-22 | Montgomery | Tennessee | 47125 | 10405 | 112 |
851630 | 851630 | 2020-12-21 | Montgomery | Tennessee | 47125 | 10291 | 109 |
848385 | 848385 | 2020-12-20 | Montgomery | Tennessee | 47125 | 10065 | 106 |
845140 | 845140 | 2020-12-19 | Montgomery | Tennessee | 47125 | 9869 | 106 |
841894 | 841894 | 2020-12-18 | Montgomery | Tennessee | 47125 | 9716 | 106 |
838649 | 838649 | 2020-12-17 | Montgomery | Tennessee | 47125 | 9442 | 103 |
835403 | 835403 | 2020-12-16 | Montgomery | Tennessee | 47125 | 9178 | 102 |
832157 | 832157 | 2020-12-15 | Montgomery | Tennessee | 47125 | 8938 | 102 |
828910 | 828910 | 2020-12-14 | Montgomery | Tennessee | 47125 | 8797 | 102 |
825664 | 825664 | 2020-12-13 | Montgomery | Tennessee | 47125 | 8490 | 102 |
822417 | 822417 | 2020-12-12 | Montgomery | Tennessee | 47125 | 8267 | 99 |
819171 | 819171 | 2020-12-11 | Montgomery | Tennessee | 47125 | 8107 | 97 |
815925 | 815925 | 2020-12-10 | Montgomery | Tennessee | 47125 | 7929 | 97 |
812679 | 812679 | 2020-12-09 | Montgomery | Tennessee | 47125 | 7811 | 97 |
809435 | 809435 | 2020-12-08 | Montgomery | Tennessee | 47125 | 7676 | 97 |
806190 | 806190 | 2020-12-07 | Montgomery | Tennessee | 47125 | 7524 | 95 |
802945 | 802945 | 2020-12-06 | Montgomery | Tennessee | 47125 | 7353 | 87 |
799700 | 799700 | 2020-12-05 | Montgomery | Tennessee | 47125 | 7318 | 87 |
796455 | 796455 | 2020-12-04 | Montgomery | Tennessee | 47125 | 7238 | 87 |
793210 | 793210 | 2020-12-03 | Montgomery | Tennessee | 47125 | 7172 | 86 |
789965 | 789965 | 2020-12-02 | Montgomery | Tennessee | 47125 | 7069 | 85 |
786720 | 786720 | 2020-12-01 | Montgomery | Tennessee | 47125 | 7001 | 85 |
783476 | 783476 | 2020-11-30 | Montgomery | Tennessee | 47125 | 6915 | 85 |
780231 | 780231 | 2020-11-29 | Montgomery | Tennessee | 47125 | 6680 | 83 |
776985 | 776985 | 2020-11-28 | Montgomery | Tennessee | 47125 | 6586 | 83 |
773740 | 773740 | 2020-11-27 | Montgomery | Tennessee | 47125 | 6496 | 83 |
770495 | 770495 | 2020-11-26 | Montgomery | Tennessee | 47125 | 6374 | 83 |
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);