ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 195 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502176 | 2502176 | 2022-05-13 | Obion | Tennessee | 47131 | 10786 | 195 |
2498918 | 2498918 | 2022-05-12 | Obion | Tennessee | 47131 | 10786 | 195 |
2495660 | 2495660 | 2022-05-11 | Obion | Tennessee | 47131 | 10786 | 195 |
2492402 | 2492402 | 2022-05-10 | Obion | Tennessee | 47131 | 10780 | 195 |
2489144 | 2489144 | 2022-05-09 | Obion | Tennessee | 47131 | 10780 | 195 |
2485887 | 2485887 | 2022-05-08 | Obion | Tennessee | 47131 | 10780 | 195 |
2482629 | 2482629 | 2022-05-07 | Obion | Tennessee | 47131 | 10780 | 195 |
2479371 | 2479371 | 2022-05-06 | Obion | Tennessee | 47131 | 10780 | 195 |
2476113 | 2476113 | 2022-05-05 | Obion | Tennessee | 47131 | 10780 | 195 |
2472856 | 2472856 | 2022-05-04 | Obion | Tennessee | 47131 | 10780 | 195 |
2469600 | 2469600 | 2022-05-03 | Obion | Tennessee | 47131 | 10770 | 195 |
2466344 | 2466344 | 2022-05-02 | Obion | Tennessee | 47131 | 10770 | 195 |
2463089 | 2463089 | 2022-05-01 | Obion | Tennessee | 47131 | 10770 | 195 |
2459833 | 2459833 | 2022-04-30 | Obion | Tennessee | 47131 | 10770 | 195 |
2456577 | 2456577 | 2022-04-29 | Obion | Tennessee | 47131 | 10770 | 195 |
2453321 | 2453321 | 2022-04-28 | Obion | Tennessee | 47131 | 10770 | 195 |
2450065 | 2450065 | 2022-04-27 | Obion | Tennessee | 47131 | 10770 | 195 |
2401210 | 2401210 | 2022-04-12 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2397955 | 2397955 | 2022-04-11 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2394700 | 2394700 | 2022-04-10 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2391444 | 2391444 | 2022-04-09 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2388188 | 2388188 | 2022-04-08 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2384933 | 2384933 | 2022-04-07 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2381678 | 2381678 | 2022-04-06 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2219095 | 2219095 | 2022-02-15 | Tipton | Tennessee | 47167 | 17164 | 195 |
2215844 | 2215844 | 2022-02-14 | Tipton | Tennessee | 47167 | 17164 | 195 |
2212593 | 2212593 | 2022-02-13 | Tipton | Tennessee | 47167 | 17164 | 195 |
2209340 | 2209340 | 2022-02-12 | Tipton | Tennessee | 47167 | 17164 | 195 |
2206087 | 2206087 | 2022-02-11 | Tipton | Tennessee | 47167 | 17164 | 195 |
2202834 | 2202834 | 2022-02-10 | Tipton | Tennessee | 47167 | 17164 | 195 |
2199580 | 2199580 | 2022-02-09 | Tipton | Tennessee | 47167 | 17164 | 195 |
2062951 | 2062951 | 2021-12-29 | Monroe | Tennessee | 47123 | 10324 | 195 |
2036929 | 2036929 | 2021-12-21 | Hawkins | Tennessee | 47073 | 11223 | 195 |
2033679 | 2033679 | 2021-12-20 | Hawkins | Tennessee | 47073 | 11209 | 195 |
2014165 | 2014165 | 2021-12-14 | Gibson | Tennessee | 47053 | 10933 | 195 |
2010914 | 2010914 | 2021-12-13 | Gibson | Tennessee | 47053 | 10917 | 195 |
2007663 | 2007663 | 2021-12-12 | Gibson | Tennessee | 47053 | 10907 | 195 |
2004412 | 2004412 | 2021-12-11 | Gibson | Tennessee | 47053 | 10907 | 195 |
2001161 | 2001161 | 2021-12-10 | Gibson | Tennessee | 47053 | 10907 | 195 |
1997911 | 1997911 | 2021-12-09 | Gibson | Tennessee | 47053 | 10887 | 195 |
1994660 | 1994660 | 2021-12-08 | Gibson | Tennessee | 47053 | 10887 | 195 |
1991409 | 1991409 | 2021-12-07 | Gibson | Tennessee | 47053 | 10874 | 195 |
1919947 | 1919947 | 2021-11-15 | Robertson | Tennessee | 47147 | 14227 | 195 |
1916697 | 1916697 | 2021-11-14 | Robertson | Tennessee | 47147 | 14201 | 195 |
1913447 | 1913447 | 2021-11-13 | Robertson | Tennessee | 47147 | 14201 | 195 |
1910197 | 1910197 | 2021-11-12 | Robertson | Tennessee | 47147 | 14201 | 195 |
1906948 | 1906948 | 2021-11-11 | Robertson | Tennessee | 47147 | 14179 | 195 |
1903699 | 1903699 | 2021-11-10 | Robertson | Tennessee | 47147 | 14179 | 195 |
1900449 | 1900449 | 2021-11-09 | Robertson | Tennessee | 47147 | 14171 | 195 |
1858139 | 1858139 | 2021-10-27 | Bradley | Tennessee | 47011 | 22113 | 195 |
1854890 | 1854890 | 2021-10-26 | Bradley | Tennessee | 47011 | 22086 | 195 |
1715230 | 1715230 | 2021-09-13 | Maury | Tennessee | 47119 | 17750 | 195 |
1666525 | 1666525 | 2021-08-29 | Sevier | Tennessee | 47155 | 15898 | 195 |
1663277 | 1663277 | 2021-08-28 | Sevier | Tennessee | 47155 | 15898 | 195 |
1660029 | 1660029 | 2021-08-27 | Sevier | Tennessee | 47155 | 15898 | 195 |
1312539 | 1312539 | 2021-05-12 | Blount | Tennessee | 47009 | 15531 | 195 |
1309292 | 1309292 | 2021-05-11 | Blount | Tennessee | 47009 | 15514 | 195 |
1202138 | 1202138 | 2021-04-08 | Blount | Tennessee | 47009 | 14822 | 195 |
981432 | 981432 | 2021-01-30 | Madison | Tennessee | 47113 | 9551 | 195 |
864630 | 864630 | 2020-12-25 | Sumner | Tennessee | 47165 | 14953 | 195 |
861385 | 861385 | 2020-12-24 | Sumner | Tennessee | 47165 | 14760 | 195 |
828922 | 828922 | 2020-12-14 | Rutherford | Tennessee | 47149 | 22904 | 195 |
812663 | 812663 | 2020-12-09 | Knox | Tennessee | 47093 | 22803 | 195 |
385241 | 385241 | 2020-07-30 | Davidson | Tennessee | 47037 | 20928 | 195 |
295911 | 295911 | 2020-07-02 | Shelby | Tennessee | 47157 | 10765 | 195 |
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);