ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 223 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2196258 | 2196258 | 2022-02-08 | Coffee | Tennessee | 47031 | 15417 | 223 |
2193004 | 2193004 | 2022-02-07 | Coffee | Tennessee | 47031 | 15417 | 223 |
2189750 | 2189750 | 2022-02-06 | Coffee | Tennessee | 47031 | 15417 | 223 |
2186497 | 2186497 | 2022-02-05 | Coffee | Tennessee | 47031 | 15417 | 223 |
2183245 | 2183245 | 2022-02-04 | Coffee | Tennessee | 47031 | 15417 | 223 |
2179993 | 2179993 | 2022-02-03 | Coffee | Tennessee | 47031 | 15417 | 223 |
2176742 | 2176742 | 2022-02-02 | Coffee | Tennessee | 47031 | 15417 | 223 |
2173499 | 2173499 | 2022-02-01 | Gibson | Tennessee | 47053 | 15018 | 223 |
2170247 | 2170247 | 2022-01-31 | Gibson | Tennessee | 47053 | 15018 | 223 |
2166993 | 2166993 | 2022-01-30 | Gibson | Tennessee | 47053 | 15018 | 223 |
2163738 | 2163738 | 2022-01-29 | Gibson | Tennessee | 47053 | 15018 | 223 |
2160483 | 2160483 | 2022-01-28 | Gibson | Tennessee | 47053 | 15018 | 223 |
2157227 | 2157227 | 2022-01-27 | Gibson | Tennessee | 47053 | 15018 | 223 |
2153974 | 2153974 | 2022-01-26 | Gibson | Tennessee | 47053 | 15018 | 223 |
2053178 | 2053178 | 2021-12-26 | Hawkins | Tennessee | 47073 | 11303 | 223 |
2049928 | 2049928 | 2021-12-25 | Hawkins | Tennessee | 47073 | 11303 | 223 |
2046678 | 2046678 | 2021-12-24 | Hawkins | Tennessee | 47073 | 11303 | 223 |
2043428 | 2043428 | 2021-12-23 | Hawkins | Tennessee | 47073 | 11303 | 223 |
2007668 | 2007668 | 2021-12-12 | Hamblen | Tennessee | 47063 | 13537 | 223 |
2004417 | 2004417 | 2021-12-11 | Hamblen | Tennessee | 47063 | 13537 | 223 |
2001166 | 2001166 | 2021-12-10 | Hamblen | Tennessee | 47063 | 13537 | 223 |
1997916 | 1997916 | 2021-12-09 | Hamblen | Tennessee | 47063 | 13488 | 223 |
1994665 | 1994665 | 2021-12-08 | Hamblen | Tennessee | 47063 | 13488 | 223 |
1991414 | 1991414 | 2021-12-07 | Hamblen | Tennessee | 47063 | 13473 | 223 |
1942694 | 1942694 | 2021-11-22 | Putnam | Tennessee | 47141 | 16984 | 223 |
1939383 | 1939383 | 2021-11-21 | Carter | Tennessee | 47019 | 10760 | 223 |
1939444 | 1939444 | 2021-11-21 | Putnam | Tennessee | 47141 | 16957 | 223 |
1936133 | 1936133 | 2021-11-20 | Carter | Tennessee | 47019 | 10760 | 223 |
1936194 | 1936194 | 2021-11-20 | Putnam | Tennessee | 47141 | 16957 | 223 |
1932883 | 1932883 | 2021-11-19 | Carter | Tennessee | 47019 | 10760 | 223 |
1932944 | 1932944 | 2021-11-19 | Putnam | Tennessee | 47141 | 16957 | 223 |
1900376 | 1900376 | 2021-11-09 | Anderson | Tennessee | 47001 | 13180 | 223 |
1815951 | 1815951 | 2021-10-14 | Maury | Tennessee | 47119 | 19138 | 223 |
1812703 | 1812703 | 2021-10-13 | Maury | Tennessee | 47119 | 19112 | 223 |
1802926 | 1802926 | 2021-10-10 | Greene | Tennessee | 47059 | 13035 | 223 |
1799677 | 1799677 | 2021-10-09 | Greene | Tennessee | 47059 | 13035 | 223 |
1796428 | 1796428 | 2021-10-08 | Greene | Tennessee | 47059 | 13035 | 223 |
1724995 | 1724995 | 2021-09-16 | Sevier | Tennessee | 47155 | 18109 | 223 |
1721746 | 1721746 | 2021-09-15 | Sevier | Tennessee | 47155 | 18033 | 223 |
1224964 | 1224964 | 2021-04-15 | Wilson | Tennessee | 47189 | 17930 | 223 |
1221717 | 1221717 | 2021-04-14 | Wilson | Tennessee | 47189 | 17885 | 223 |
1218436 | 1218436 | 2021-04-13 | Montgomery | Tennessee | 47125 | 18939 | 223 |
1218469 | 1218469 | 2021-04-13 | Wilson | Tennessee | 47189 | 17854 | 223 |
1215188 | 1215188 | 2021-04-12 | Montgomery | Tennessee | 47125 | 18880 | 223 |
1215221 | 1215221 | 2021-04-12 | Wilson | Tennessee | 47189 | 17815 | 223 |
1211941 | 1211941 | 2021-04-11 | Montgomery | Tennessee | 47125 | 18780 | 223 |
1211974 | 1211974 | 2021-04-11 | Wilson | Tennessee | 47189 | 17747 | 223 |
1208692 | 1208692 | 2021-04-10 | Montgomery | Tennessee | 47125 | 18780 | 223 |
1208725 | 1208725 | 2021-04-10 | Wilson | Tennessee | 47189 | 17747 | 223 |
1205444 | 1205444 | 2021-04-09 | Montgomery | Tennessee | 47125 | 18780 | 223 |
1205477 | 1205477 | 2021-04-09 | Wilson | Tennessee | 47189 | 17747 | 223 |
1202196 | 1202196 | 2021-04-08 | Montgomery | Tennessee | 47125 | 18738 | 223 |
1202229 | 1202229 | 2021-04-08 | Wilson | Tennessee | 47189 | 17736 | 223 |
1198947 | 1198947 | 2021-04-07 | Montgomery | Tennessee | 47125 | 18695 | 223 |
1198980 | 1198980 | 2021-04-07 | Wilson | Tennessee | 47189 | 17695 | 223 |
1195698 | 1195698 | 2021-04-06 | Montgomery | Tennessee | 47125 | 18652 | 223 |
1039856 | 1039856 | 2021-02-17 | Madison | Tennessee | 47113 | 9970 | 223 |
1036611 | 1036611 | 2021-02-16 | Madison | Tennessee | 47113 | 9966 | 223 |
1026909 | 1026909 | 2021-02-13 | Washington | Tennessee | 47179 | 12505 | 223 |
916555 | 916555 | 2021-01-10 | Sumner | Tennessee | 47165 | 17405 | 223 |
835373 | 835373 | 2020-12-16 | Hamilton | Tennessee | 47065 | 24010 | 223 |
832141 | 832141 | 2020-12-15 | Knox | Tennessee | 47093 | 25843 | 223 |
324441 | 324441 | 2020-07-11 | Shelby | Tennessee | 47157 | 13452 | 223 |
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);