ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47149 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091807 | 1091807 | 2021-03-05 | Rutherford | Tennessee | 47149 | 38663 | 387 |
1088561 | 1088561 | 2021-03-04 | Rutherford | Tennessee | 47149 | 38563 | 386 |
1085316 | 1085316 | 2021-03-03 | Rutherford | Tennessee | 47149 | 38479 | 384 |
1082070 | 1082070 | 2021-03-02 | Rutherford | Tennessee | 47149 | 38385 | 382 |
1078824 | 1078824 | 2021-03-01 | Rutherford | Tennessee | 47149 | 38346 | 382 |
1075579 | 1075579 | 2021-02-28 | Rutherford | Tennessee | 47149 | 38301 | 383 |
1072333 | 1072333 | 2021-02-27 | Rutherford | Tennessee | 47149 | 38186 | 382 |
1069087 | 1069087 | 2021-02-26 | Rutherford | Tennessee | 47149 | 38104 | 382 |
1065842 | 1065842 | 2021-02-25 | Rutherford | Tennessee | 47149 | 38014 | 377 |
1062597 | 1062597 | 2021-02-24 | Rutherford | Tennessee | 47149 | 37906 | 375 |
1059352 | 1059352 | 2021-02-23 | Rutherford | Tennessee | 47149 | 37781 | 371 |
1056106 | 1056106 | 2021-02-22 | Rutherford | Tennessee | 47149 | 37705 | 370 |
1052860 | 1052860 | 2021-02-21 | Rutherford | Tennessee | 47149 | 37626 | 368 |
1049613 | 1049613 | 2021-02-20 | Rutherford | Tennessee | 47149 | 37552 | 366 |
1046366 | 1046366 | 2021-02-19 | Rutherford | Tennessee | 47149 | 37478 | 366 |
1043121 | 1043121 | 2021-02-18 | Rutherford | Tennessee | 47149 | 37417 | 366 |
1039876 | 1039876 | 2021-02-17 | Rutherford | Tennessee | 47149 | 37397 | 365 |
1036631 | 1036631 | 2021-02-16 | Rutherford | Tennessee | 47149 | 37335 | 365 |
1033386 | 1033386 | 2021-02-15 | Rutherford | Tennessee | 47149 | 37217 | 363 |
1030140 | 1030140 | 2021-02-14 | Rutherford | Tennessee | 47149 | 37063 | 362 |
1026893 | 1026893 | 2021-02-13 | Rutherford | Tennessee | 47149 | 36863 | 361 |
1023648 | 1023648 | 2021-02-12 | Rutherford | Tennessee | 47149 | 36689 | 361 |
1020403 | 1020403 | 2021-02-11 | Rutherford | Tennessee | 47149 | 36557 | 356 |
1017158 | 1017158 | 2021-02-10 | Rutherford | Tennessee | 47149 | 36273 | 352 |
1013913 | 1013913 | 2021-02-09 | Rutherford | Tennessee | 47149 | 36115 | 347 |
1010668 | 1010668 | 2021-02-08 | Rutherford | Tennessee | 47149 | 36036 | 344 |
1007422 | 1007422 | 2021-02-07 | Rutherford | Tennessee | 47149 | 35950 | 337 |
1004176 | 1004176 | 2021-02-06 | Rutherford | Tennessee | 47149 | 35838 | 336 |
1000930 | 1000930 | 2021-02-05 | Rutherford | Tennessee | 47149 | 35681 | 336 |
997684 | 997684 | 2021-02-04 | Rutherford | Tennessee | 47149 | 35561 | 333 |
994438 | 994438 | 2021-02-03 | Rutherford | Tennessee | 47149 | 35394 | 327 |
991192 | 991192 | 2021-02-02 | Rutherford | Tennessee | 47149 | 35299 | 323 |
987946 | 987946 | 2021-02-01 | Rutherford | Tennessee | 47149 | 35188 | 317 |
984699 | 984699 | 2021-01-31 | Rutherford | Tennessee | 47149 | 35110 | 315 |
981452 | 981452 | 2021-01-30 | Rutherford | Tennessee | 47149 | 34951 | 314 |
978206 | 978206 | 2021-01-29 | Rutherford | Tennessee | 47149 | 34818 | 312 |
974961 | 974961 | 2021-01-28 | Rutherford | Tennessee | 47149 | 34645 | 310 |
971716 | 971716 | 2021-01-27 | Rutherford | Tennessee | 47149 | 34539 | 307 |
968471 | 968471 | 2021-01-26 | Rutherford | Tennessee | 47149 | 34354 | 299 |
965227 | 965227 | 2021-01-25 | Rutherford | Tennessee | 47149 | 34271 | 298 |
961982 | 961982 | 2021-01-24 | Rutherford | Tennessee | 47149 | 34166 | 296 |
958737 | 958737 | 2021-01-23 | Rutherford | Tennessee | 47149 | 34042 | 295 |
955491 | 955491 | 2021-01-22 | Rutherford | Tennessee | 47149 | 33860 | 294 |
952246 | 952246 | 2021-01-21 | Rutherford | Tennessee | 47149 | 33687 | 294 |
949001 | 949001 | 2021-01-20 | Rutherford | Tennessee | 47149 | 33516 | 288 |
945755 | 945755 | 2021-01-19 | Rutherford | Tennessee | 47149 | 33298 | 287 |
942508 | 942508 | 2021-01-18 | Rutherford | Tennessee | 47149 | 33228 | 285 |
939263 | 939263 | 2021-01-17 | Rutherford | Tennessee | 47149 | 33114 | 283 |
936018 | 936018 | 2021-01-16 | Rutherford | Tennessee | 47149 | 32907 | 282 |
932773 | 932773 | 2021-01-15 | Rutherford | Tennessee | 47149 | 32696 | 282 |
929528 | 929528 | 2021-01-14 | Rutherford | Tennessee | 47149 | 32471 | 281 |
926283 | 926283 | 2021-01-13 | Rutherford | Tennessee | 47149 | 32214 | 279 |
923037 | 923037 | 2021-01-12 | Rutherford | Tennessee | 47149 | 31972 | 271 |
919792 | 919792 | 2021-01-11 | Rutherford | Tennessee | 47149 | 31744 | 268 |
916547 | 916547 | 2021-01-10 | Rutherford | Tennessee | 47149 | 31563 | 267 |
913302 | 913302 | 2021-01-09 | Rutherford | Tennessee | 47149 | 31214 | 266 |
910057 | 910057 | 2021-01-08 | Rutherford | Tennessee | 47149 | 30893 | 263 |
906812 | 906812 | 2021-01-07 | Rutherford | Tennessee | 47149 | 30617 | 259 |
903566 | 903566 | 2021-01-06 | Rutherford | Tennessee | 47149 | 30200 | 254 |
900321 | 900321 | 2021-01-05 | Rutherford | Tennessee | 47149 | 29823 | 252 |
897076 | 897076 | 2021-01-04 | Rutherford | Tennessee | 47149 | 29609 | 248 |
893830 | 893830 | 2021-01-03 | Rutherford | Tennessee | 47149 | 29378 | 245 |
890584 | 890584 | 2021-01-02 | Rutherford | Tennessee | 47149 | 29250 | 244 |
887337 | 887337 | 2021-01-01 | Rutherford | Tennessee | 47149 | 28618 | 242 |
884092 | 884092 | 2020-12-31 | Rutherford | Tennessee | 47149 | 28618 | 242 |
880847 | 880847 | 2020-12-30 | Rutherford | Tennessee | 47149 | 28272 | 241 |
877602 | 877602 | 2020-12-29 | Rutherford | Tennessee | 47149 | 27864 | 238 |
874357 | 874357 | 2020-12-28 | Rutherford | Tennessee | 47149 | 27679 | 235 |
871112 | 871112 | 2020-12-27 | Rutherford | Tennessee | 47149 | 27519 | 234 |
867867 | 867867 | 2020-12-26 | Rutherford | Tennessee | 47149 | 27407 | 232 |
864622 | 864622 | 2020-12-25 | Rutherford | Tennessee | 47149 | 27173 | 228 |
861377 | 861377 | 2020-12-24 | Rutherford | Tennessee | 47149 | 26681 | 228 |
858132 | 858132 | 2020-12-23 | Rutherford | Tennessee | 47149 | 26488 | 227 |
854887 | 854887 | 2020-12-22 | Rutherford | Tennessee | 47149 | 26161 | 222 |
851642 | 851642 | 2020-12-21 | Rutherford | Tennessee | 47149 | 25953 | 215 |
848397 | 848397 | 2020-12-20 | Rutherford | Tennessee | 47149 | 25529 | 214 |
845152 | 845152 | 2020-12-19 | Rutherford | Tennessee | 47149 | 25081 | 213 |
841906 | 841906 | 2020-12-18 | Rutherford | Tennessee | 47149 | 24821 | 212 |
838661 | 838661 | 2020-12-17 | Rutherford | Tennessee | 47149 | 24221 | 208 |
835415 | 835415 | 2020-12-16 | Rutherford | Tennessee | 47149 | 23828 | 201 |
832169 | 832169 | 2020-12-15 | Rutherford | Tennessee | 47149 | 23272 | 198 |
828922 | 828922 | 2020-12-14 | Rutherford | Tennessee | 47149 | 22904 | 195 |
825676 | 825676 | 2020-12-13 | Rutherford | Tennessee | 47149 | 22336 | 193 |
822429 | 822429 | 2020-12-12 | Rutherford | Tennessee | 47149 | 21809 | 191 |
819183 | 819183 | 2020-12-11 | Rutherford | Tennessee | 47149 | 21504 | 191 |
815937 | 815937 | 2020-12-10 | Rutherford | Tennessee | 47149 | 21014 | 189 |
812691 | 812691 | 2020-12-09 | Rutherford | Tennessee | 47149 | 20721 | 185 |
809447 | 809447 | 2020-12-08 | Rutherford | Tennessee | 47149 | 20346 | 185 |
806202 | 806202 | 2020-12-07 | Rutherford | Tennessee | 47149 | 20061 | 177 |
802957 | 802957 | 2020-12-06 | Rutherford | Tennessee | 47149 | 19594 | 175 |
799712 | 799712 | 2020-12-05 | Rutherford | Tennessee | 47149 | 19456 | 174 |
796467 | 796467 | 2020-12-04 | Rutherford | Tennessee | 47149 | 19202 | 173 |
793222 | 793222 | 2020-12-03 | Rutherford | Tennessee | 47149 | 18968 | 169 |
789977 | 789977 | 2020-12-02 | Rutherford | Tennessee | 47149 | 18788 | 164 |
786732 | 786732 | 2020-12-01 | Rutherford | Tennessee | 47149 | 18613 | 164 |
783488 | 783488 | 2020-11-30 | Rutherford | Tennessee | 47149 | 18248 | 163 |
780243 | 780243 | 2020-11-29 | Rutherford | Tennessee | 47149 | 17930 | 161 |
776997 | 776997 | 2020-11-28 | Rutherford | Tennessee | 47149 | 17749 | 161 |
773752 | 773752 | 2020-11-27 | Rutherford | Tennessee | 47149 | 17439 | 160 |
770507 | 770507 | 2020-11-26 | Rutherford | Tennessee | 47149 | 17212 | 159 |
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);