ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where deaths = 217 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502125 | 2502125 | 2022-05-13 | Cocke | Tennessee | 47029 | 11634 | 217 |
2498867 | 2498867 | 2022-05-12 | Cocke | Tennessee | 47029 | 11634 | 217 |
2495609 | 2495609 | 2022-05-11 | Cocke | Tennessee | 47029 | 11634 | 217 |
2492351 | 2492351 | 2022-05-10 | Cocke | Tennessee | 47029 | 11617 | 217 |
2489093 | 2489093 | 2022-05-09 | Cocke | Tennessee | 47029 | 11617 | 217 |
2485836 | 2485836 | 2022-05-08 | Cocke | Tennessee | 47029 | 11617 | 217 |
2482578 | 2482578 | 2022-05-07 | Cocke | Tennessee | 47029 | 11617 | 217 |
2479320 | 2479320 | 2022-05-06 | Cocke | Tennessee | 47029 | 11617 | 217 |
2476062 | 2476062 | 2022-05-05 | Cocke | Tennessee | 47029 | 11617 | 217 |
2472805 | 2472805 | 2022-05-04 | Cocke | Tennessee | 47029 | 11617 | 217 |
2469549 | 2469549 | 2022-05-03 | Cocke | Tennessee | 47029 | 11603 | 217 |
2466293 | 2466293 | 2022-05-02 | Cocke | Tennessee | 47029 | 11603 | 217 |
2463038 | 2463038 | 2022-05-01 | Cocke | Tennessee | 47029 | 11603 | 217 |
2459782 | 2459782 | 2022-04-30 | Cocke | Tennessee | 47029 | 11603 | 217 |
2456526 | 2456526 | 2022-04-29 | Cocke | Tennessee | 47029 | 11603 | 217 |
2453270 | 2453270 | 2022-04-28 | Cocke | Tennessee | 47029 | 11603 | 217 |
2450014 | 2450014 | 2022-04-27 | Cocke | Tennessee | 47029 | 11603 | 217 |
2310118 | 2310118 | 2022-03-15 | Monroe | Tennessee | 47123 | 14442 | 217 |
2306865 | 2306865 | 2022-03-14 | Monroe | Tennessee | 47123 | 14442 | 217 |
2303614 | 2303614 | 2022-03-13 | Monroe | Tennessee | 47123 | 14442 | 217 |
2300362 | 2300362 | 2022-03-12 | Monroe | Tennessee | 47123 | 14442 | 217 |
2297110 | 2297110 | 2022-03-11 | Monroe | Tennessee | 47123 | 14442 | 217 |
2293858 | 2293858 | 2022-03-10 | Monroe | Tennessee | 47123 | 14442 | 217 |
2290606 | 2290606 | 2022-03-09 | Monroe | Tennessee | 47123 | 14442 | 217 |
2287354 | 2287354 | 2022-03-08 | Monroe | Tennessee | 47123 | 14400 | 217 |
2284102 | 2284102 | 2022-03-07 | Monroe | Tennessee | 47123 | 14400 | 217 |
2280850 | 2280850 | 2022-03-06 | Monroe | Tennessee | 47123 | 14400 | 217 |
2277597 | 2277597 | 2022-03-05 | Monroe | Tennessee | 47123 | 14400 | 217 |
2274344 | 2274344 | 2022-03-04 | Monroe | Tennessee | 47123 | 14400 | 217 |
2271091 | 2271091 | 2022-03-03 | Monroe | Tennessee | 47123 | 14400 | 217 |
2267839 | 2267839 | 2022-03-02 | Monroe | Tennessee | 47123 | 14400 | 217 |
2264597 | 2264597 | 2022-03-01 | Roane | Tennessee | 47145 | 15588 | 217 |
2261347 | 2261347 | 2022-02-28 | Roane | Tennessee | 47145 | 15588 | 217 |
2258096 | 2258096 | 2022-02-27 | Roane | Tennessee | 47145 | 15588 | 217 |
2254845 | 2254845 | 2022-02-26 | Roane | Tennessee | 47145 | 15588 | 217 |
2251594 | 2251594 | 2022-02-25 | Roane | Tennessee | 47145 | 15588 | 217 |
2248343 | 2248343 | 2022-02-24 | Roane | Tennessee | 47145 | 15588 | 217 |
2245092 | 2245092 | 2022-02-23 | Roane | Tennessee | 47145 | 15588 | 217 |
2173494 | 2173494 | 2022-02-01 | Dickson | Tennessee | 47043 | 13642 | 217 |
2170242 | 2170242 | 2022-01-31 | Dickson | Tennessee | 47043 | 13642 | 217 |
2166988 | 2166988 | 2022-01-30 | Dickson | Tennessee | 47043 | 13642 | 217 |
2163733 | 2163733 | 2022-01-29 | Dickson | Tennessee | 47043 | 13642 | 217 |
2160478 | 2160478 | 2022-01-28 | Dickson | Tennessee | 47043 | 13642 | 217 |
2157222 | 2157222 | 2022-01-27 | Dickson | Tennessee | 47043 | 13642 | 217 |
2153969 | 2153969 | 2022-01-26 | Dickson | Tennessee | 47043 | 13642 | 217 |
2127963 | 2127963 | 2022-01-18 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2124711 | 2124711 | 2022-01-17 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2121459 | 2121459 | 2022-01-16 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2118207 | 2118207 | 2022-01-15 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2114956 | 2114956 | 2022-01-14 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2111704 | 2111704 | 2022-01-13 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2108452 | 2108452 | 2022-01-12 | Jefferson | Tennessee | 47089 | 11510 | 217 |
1971914 | 1971914 | 2021-12-01 | Hamblen | Tennessee | 47063 | 13357 | 217 |
1962135 | 1962135 | 2021-11-28 | Bradley | Tennessee | 47011 | 22549 | 217 |
1958884 | 1958884 | 2021-11-27 | Bradley | Tennessee | 47011 | 22549 | 217 |
1955633 | 1955633 | 2021-11-26 | Bradley | Tennessee | 47011 | 22549 | 217 |
1952382 | 1952382 | 2021-11-25 | Bradley | Tennessee | 47011 | 22549 | 217 |
1949131 | 1949131 | 2021-11-24 | Bradley | Tennessee | 47011 | 22549 | 217 |
1877637 | 1877637 | 2021-11-02 | Carter | Tennessee | 47019 | 10564 | 217 |
1861383 | 1861383 | 2021-10-28 | Anderson | Tennessee | 47001 | 12976 | 217 |
1806204 | 1806204 | 2021-10-11 | Maury | Tennessee | 47119 | 19055 | 217 |
1802954 | 1802954 | 2021-10-10 | Maury | Tennessee | 47119 | 18975 | 217 |
1799705 | 1799705 | 2021-10-09 | Maury | Tennessee | 47119 | 18975 | 217 |
1796456 | 1796456 | 2021-10-08 | Maury | Tennessee | 47119 | 18975 | 217 |
1793207 | 1793207 | 2021-10-07 | Maury | Tennessee | 47119 | 18922 | 217 |
1789958 | 1789958 | 2021-10-06 | Maury | Tennessee | 47119 | 18903 | 217 |
1715250 | 1715250 | 2021-09-13 | Sevier | Tennessee | 47155 | 17824 | 217 |
1702187 | 1702187 | 2021-09-09 | Blount | Tennessee | 47009 | 20211 | 217 |
1358084 | 1358084 | 2021-05-26 | Williamson | Tennessee | 47187 | 28240 | 217 |
1354838 | 1354838 | 2021-05-25 | Williamson | Tennessee | 47187 | 28228 | 217 |
1351592 | 1351592 | 2021-05-24 | Williamson | Tennessee | 47187 | 28225 | 217 |
1348346 | 1348346 | 2021-05-23 | Williamson | Tennessee | 47187 | 28204 | 217 |
1345098 | 1345098 | 2021-05-22 | Williamson | Tennessee | 47187 | 28204 | 217 |
1341850 | 1341850 | 2021-05-21 | Williamson | Tennessee | 47187 | 28204 | 217 |
1338602 | 1338602 | 2021-05-20 | Williamson | Tennessee | 47187 | 28194 | 217 |
1335355 | 1335355 | 2021-05-19 | Williamson | Tennessee | 47187 | 28179 | 217 |
1332108 | 1332108 | 2021-05-18 | Williamson | Tennessee | 47187 | 28163 | 217 |
1328861 | 1328861 | 2021-05-17 | Williamson | Tennessee | 47187 | 28148 | 217 |
1325615 | 1325615 | 2021-05-16 | Williamson | Tennessee | 47187 | 28116 | 217 |
1322369 | 1322369 | 2021-05-15 | Williamson | Tennessee | 47187 | 28116 | 217 |
1319123 | 1319123 | 2021-05-14 | Williamson | Tennessee | 47187 | 28116 | 217 |
1315875 | 1315875 | 2021-05-13 | Williamson | Tennessee | 47187 | 28104 | 217 |
1312629 | 1312629 | 2021-05-12 | Williamson | Tennessee | 47187 | 28089 | 217 |
1309382 | 1309382 | 2021-05-11 | Williamson | Tennessee | 47187 | 28063 | 217 |
1306136 | 1306136 | 2021-05-10 | Williamson | Tennessee | 47187 | 28040 | 217 |
1302890 | 1302890 | 2021-05-09 | Williamson | Tennessee | 47187 | 28015 | 217 |
1299643 | 1299643 | 2021-05-08 | Williamson | Tennessee | 47187 | 28015 | 217 |
1296396 | 1296396 | 2021-05-07 | Williamson | Tennessee | 47187 | 28015 | 217 |
1293150 | 1293150 | 2021-05-06 | Williamson | Tennessee | 47187 | 27986 | 217 |
1289904 | 1289904 | 2021-05-05 | Williamson | Tennessee | 47187 | 27959 | 217 |
1286658 | 1286658 | 2021-05-04 | Williamson | Tennessee | 47187 | 27935 | 217 |
1283412 | 1283412 | 2021-05-03 | Williamson | Tennessee | 47187 | 27914 | 217 |
1280165 | 1280165 | 2021-05-02 | Williamson | Tennessee | 47187 | 27845 | 217 |
1276918 | 1276918 | 2021-05-01 | Williamson | Tennessee | 47187 | 27845 | 217 |
1273671 | 1273671 | 2021-04-30 | Williamson | Tennessee | 47187 | 27845 | 217 |
1270424 | 1270424 | 2021-04-29 | Williamson | Tennessee | 47187 | 27833 | 217 |
1166471 | 1166471 | 2021-03-28 | Montgomery | Tennessee | 47125 | 18221 | 217 |
1163223 | 1163223 | 2021-03-27 | Montgomery | Tennessee | 47125 | 18221 | 217 |
1159974 | 1159974 | 2021-03-26 | Montgomery | Tennessee | 47125 | 18221 | 217 |
1156727 | 1156727 | 2021-03-25 | Montgomery | Tennessee | 47125 | 18164 | 217 |
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);