ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Rutherford" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1192462 | 1192462 | 2021-04-05 | Rutherford | Tennessee | 47149 | 41160 | 411 |
1189213 | 1189213 | 2021-04-04 | Rutherford | Tennessee | 47149 | 40924 | 409 |
1185966 | 1185966 | 2021-04-03 | Rutherford | Tennessee | 47149 | 40924 | 409 |
1182719 | 1182719 | 2021-04-02 | Rutherford | Tennessee | 47149 | 40924 | 409 |
1179472 | 1179472 | 2021-04-01 | Rutherford | Tennessee | 47149 | 40924 | 409 |
1176225 | 1176225 | 2021-03-31 | Rutherford | Tennessee | 47149 | 40844 | 409 |
1172978 | 1172978 | 2021-03-30 | Rutherford | Tennessee | 47149 | 40739 | 408 |
1169731 | 1169731 | 2021-03-29 | Rutherford | Tennessee | 47149 | 40685 | 407 |
1166483 | 1166483 | 2021-03-28 | Rutherford | Tennessee | 47149 | 40502 | 405 |
1163235 | 1163235 | 2021-03-27 | Rutherford | Tennessee | 47149 | 40502 | 405 |
1159986 | 1159986 | 2021-03-26 | Rutherford | Tennessee | 47149 | 40502 | 405 |
1156739 | 1156739 | 2021-03-25 | Rutherford | Tennessee | 47149 | 40386 | 402 |
1153492 | 1153492 | 2021-03-24 | Rutherford | Tennessee | 47149 | 40287 | 402 |
1150245 | 1150245 | 2021-03-23 | Rutherford | Tennessee | 47149 | 40196 | 400 |
1146998 | 1146998 | 2021-03-22 | Rutherford | Tennessee | 47149 | 40107 | 398 |
1143751 | 1143751 | 2021-03-21 | Rutherford | Tennessee | 47149 | 39910 | 398 |
1140504 | 1140504 | 2021-03-20 | Rutherford | Tennessee | 47149 | 39910 | 398 |
1137258 | 1137258 | 2021-03-19 | Rutherford | Tennessee | 47149 | 39910 | 398 |
1134012 | 1134012 | 2021-03-18 | Rutherford | Tennessee | 47149 | 39787 | 398 |
1130764 | 1130764 | 2021-03-17 | Rutherford | Tennessee | 47149 | 39754 | 397 |
1127517 | 1127517 | 2021-03-16 | Rutherford | Tennessee | 47149 | 39622 | 396 |
1124271 | 1124271 | 2021-03-15 | Rutherford | Tennessee | 47149 | 39529 | 393 |
1121025 | 1121025 | 2021-03-14 | Rutherford | Tennessee | 47149 | 39274 | 393 |
1117778 | 1117778 | 2021-03-13 | Rutherford | Tennessee | 47149 | 39274 | 393 |
1114531 | 1114531 | 2021-03-12 | Rutherford | Tennessee | 47149 | 39274 | 393 |
1111285 | 1111285 | 2021-03-11 | Rutherford | Tennessee | 47149 | 39183 | 392 |
1108039 | 1108039 | 2021-03-10 | Rutherford | Tennessee | 47149 | 39067 | 391 |
1104793 | 1104793 | 2021-03-09 | Rutherford | Tennessee | 47149 | 38972 | 391 |
1101547 | 1101547 | 2021-03-08 | Rutherford | Tennessee | 47149 | 38878 | 389 |
1098301 | 1098301 | 2021-03-07 | Rutherford | Tennessee | 47149 | 38847 | 388 |
1095053 | 1095053 | 2021-03-06 | Rutherford | Tennessee | 47149 | 38749 | 388 |
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 |
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);