ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where deaths = 170 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502162 | 2502162 | 2022-05-13 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2498904 | 2498904 | 2022-05-12 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2495646 | 2495646 | 2022-05-11 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2492388 | 2492388 | 2022-05-10 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2489130 | 2489130 | 2022-05-09 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2485873 | 2485873 | 2022-05-08 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2482615 | 2482615 | 2022-05-07 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2479357 | 2479357 | 2022-05-06 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2476099 | 2476099 | 2022-05-05 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2472842 | 2472842 | 2022-05-04 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2469586 | 2469586 | 2022-05-03 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2466330 | 2466330 | 2022-05-02 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2463075 | 2463075 | 2022-05-01 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2459819 | 2459819 | 2022-04-30 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2456563 | 2456563 | 2022-04-29 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2453307 | 2453307 | 2022-04-28 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2450051 | 2450051 | 2022-04-27 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2446794 | 2446794 | 2022-04-26 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2443539 | 2443539 | 2022-04-25 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2440283 | 2440283 | 2022-04-24 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2437027 | 2437027 | 2022-04-23 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2433771 | 2433771 | 2022-04-22 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2430515 | 2430515 | 2022-04-21 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2427259 | 2427259 | 2022-04-20 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2424003 | 2424003 | 2022-04-19 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2420747 | 2420747 | 2022-04-18 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2417491 | 2417491 | 2022-04-17 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2414235 | 2414235 | 2022-04-16 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2410979 | 2410979 | 2022-04-15 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2407723 | 2407723 | 2022-04-14 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2404467 | 2404467 | 2022-04-13 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2219061 | 2219061 | 2022-02-15 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2219064 | 2219064 | 2022-02-15 | Loudon | Tennessee | 47105 | 13836 | 170 |
2215810 | 2215810 | 2022-02-14 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2215813 | 2215813 | 2022-02-14 | Loudon | Tennessee | 47105 | 13836 | 170 |
2212559 | 2212559 | 2022-02-13 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2212562 | 2212562 | 2022-02-13 | Loudon | Tennessee | 47105 | 13836 | 170 |
2209306 | 2209306 | 2022-02-12 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2209309 | 2209309 | 2022-02-12 | Loudon | Tennessee | 47105 | 13836 | 170 |
2206053 | 2206053 | 2022-02-11 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2206056 | 2206056 | 2022-02-11 | Loudon | Tennessee | 47105 | 13836 | 170 |
2202800 | 2202800 | 2022-02-10 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2202803 | 2202803 | 2022-02-10 | Loudon | Tennessee | 47105 | 13836 | 170 |
2199546 | 2199546 | 2022-02-09 | Lawrence | Tennessee | 47099 | 13789 | 170 |
2199549 | 2199549 | 2022-02-09 | Loudon | Tennessee | 47105 | 13836 | 170 |
2040187 | 2040187 | 2021-12-22 | Jefferson | Tennessee | 47089 | 10585 | 170 |
2036937 | 2036937 | 2021-12-21 | Jefferson | Tennessee | 47089 | 10557 | 170 |
2020712 | 2020712 | 2021-12-16 | Roane | Tennessee | 47145 | 10537 | 170 |
1988133 | 1988133 | 2021-12-06 | Bedford | Tennessee | 47003 | 9610 | 170 |
1968654 | 1968654 | 2021-11-30 | Dickson | Tennessee | 47043 | 10751 | 170 |
1965403 | 1965403 | 2021-11-29 | Dickson | Tennessee | 47043 | 10741 | 170 |
1897162 | 1897162 | 2021-11-08 | Hawkins | Tennessee | 47073 | 10321 | 170 |
1893912 | 1893912 | 2021-11-07 | Hawkins | Tennessee | 47073 | 10321 | 170 |
1890662 | 1890662 | 2021-11-06 | Hawkins | Tennessee | 47073 | 10321 | 170 |
1887412 | 1887412 | 2021-11-05 | Hawkins | Tennessee | 47073 | 10321 | 170 |
1763912 | 1763912 | 2021-09-28 | Bradley | Tennessee | 47011 | 21316 | 170 |
1763980 | 1763980 | 2021-09-28 | Robertson | Tennessee | 47147 | 13554 | 170 |
1760663 | 1760663 | 2021-09-27 | Bradley | Tennessee | 47011 | 21268 | 170 |
1760731 | 1760731 | 2021-09-27 | Robertson | Tennessee | 47147 | 13524 | 170 |
1757483 | 1757483 | 2021-09-26 | Robertson | Tennessee | 47147 | 13440 | 170 |
1754235 | 1754235 | 2021-09-25 | Robertson | Tennessee | 47147 | 13440 | 170 |
1750987 | 1750987 | 2021-09-24 | Robertson | Tennessee | 47147 | 13440 | 170 |
1747738 | 1747738 | 2021-09-23 | Robertson | Tennessee | 47147 | 13394 | 170 |
1744488 | 1744488 | 2021-09-22 | Robertson | Tennessee | 47147 | 13336 | 170 |
1715199 | 1715199 | 2021-09-13 | Gibson | Tennessee | 47053 | 9690 | 170 |
1646989 | 1646989 | 2021-08-23 | Greene | Tennessee | 47059 | 9361 | 170 |
1643740 | 1643740 | 2021-08-22 | Greene | Tennessee | 47059 | 9129 | 170 |
1640490 | 1640490 | 2021-08-21 | Greene | Tennessee | 47059 | 9129 | 170 |
1637240 | 1637240 | 2021-08-20 | Greene | Tennessee | 47059 | 9129 | 170 |
1247658 | 1247658 | 2021-04-22 | Maury | Tennessee | 47119 | 13286 | 170 |
1244411 | 1244411 | 2021-04-21 | Maury | Tennessee | 47119 | 13261 | 170 |
1234644 | 1234644 | 2021-04-18 | Hamblen | Tennessee | 47063 | 8478 | 170 |
1231396 | 1231396 | 2021-04-17 | Hamblen | Tennessee | 47063 | 8478 | 170 |
1228148 | 1228148 | 2021-04-16 | Hamblen | Tennessee | 47063 | 8478 | 170 |
1224900 | 1224900 | 2021-04-15 | Hamblen | Tennessee | 47063 | 8465 | 170 |
1221653 | 1221653 | 2021-04-14 | Hamblen | Tennessee | 47063 | 8460 | 170 |
1202165 | 1202165 | 2021-04-08 | Hamblen | Tennessee | 47063 | 8405 | 170 |
1198916 | 1198916 | 2021-04-07 | Hamblen | Tennessee | 47063 | 8394 | 170 |
1195667 | 1195667 | 2021-04-06 | Hamblen | Tennessee | 47063 | 8387 | 170 |
1192419 | 1192419 | 2021-04-05 | Hamblen | Tennessee | 47063 | 8387 | 170 |
1189170 | 1189170 | 2021-04-04 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1185923 | 1185923 | 2021-04-03 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1182676 | 1182676 | 2021-04-02 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1179429 | 1179429 | 2021-04-01 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1176182 | 1176182 | 2021-03-31 | Hamblen | Tennessee | 47063 | 8355 | 170 |
1172935 | 1172935 | 2021-03-30 | Hamblen | Tennessee | 47063 | 8348 | 170 |
1169688 | 1169688 | 2021-03-29 | Hamblen | Tennessee | 47063 | 8338 | 170 |
1166440 | 1166440 | 2021-03-28 | Hamblen | Tennessee | 47063 | 8326 | 170 |
1163192 | 1163192 | 2021-03-27 | Hamblen | Tennessee | 47063 | 8326 | 170 |
1159943 | 1159943 | 2021-03-26 | Hamblen | Tennessee | 47063 | 8326 | 170 |
1156696 | 1156696 | 2021-03-25 | Hamblen | Tennessee | 47063 | 8307 | 170 |
1156742 | 1156742 | 2021-03-25 | Sevier | Tennessee | 47155 | 12728 | 170 |
1153449 | 1153449 | 2021-03-24 | Hamblen | Tennessee | 47063 | 8298 | 170 |
1150202 | 1150202 | 2021-03-23 | Hamblen | Tennessee | 47063 | 8293 | 170 |
1104789 | 1104789 | 2021-03-09 | Putnam | Tennessee | 47141 | 10685 | 170 |
1101543 | 1101543 | 2021-03-08 | Putnam | Tennessee | 47141 | 10675 | 170 |
1098297 | 1098297 | 2021-03-07 | Putnam | Tennessee | 47141 | 10671 | 170 |
1095049 | 1095049 | 2021-03-06 | Putnam | Tennessee | 47141 | 10660 | 170 |
1091803 | 1091803 | 2021-03-05 | Putnam | Tennessee | 47141 | 10647 | 170 |
1088557 | 1088557 | 2021-03-04 | Putnam | Tennessee | 47141 | 10635 | 170 |
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);