ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 188 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378401 | 2378401 | 2022-04-05 | Giles | Tennessee | 47055 | 9399 | 188 |
2375147 | 2375147 | 2022-04-04 | Giles | Tennessee | 47055 | 9399 | 188 |
2371895 | 2371895 | 2022-04-03 | Giles | Tennessee | 47055 | 9399 | 188 |
2368642 | 2368642 | 2022-04-02 | Giles | Tennessee | 47055 | 9399 | 188 |
2365389 | 2365389 | 2022-04-01 | Giles | Tennessee | 47055 | 9399 | 188 |
2362136 | 2362136 | 2022-03-31 | Giles | Tennessee | 47055 | 9399 | 188 |
2358882 | 2358882 | 2022-03-30 | Giles | Tennessee | 47055 | 9399 | 188 |
2355653 | 2355653 | 2022-03-29 | Loudon | Tennessee | 47105 | 14424 | 188 |
2352400 | 2352400 | 2022-03-28 | Loudon | Tennessee | 47105 | 14424 | 188 |
2349148 | 2349148 | 2022-03-27 | Loudon | Tennessee | 47105 | 14424 | 188 |
2345895 | 2345895 | 2022-03-26 | Loudon | Tennessee | 47105 | 14424 | 188 |
2342642 | 2342642 | 2022-03-25 | Loudon | Tennessee | 47105 | 14424 | 188 |
2339389 | 2339389 | 2022-03-24 | Loudon | Tennessee | 47105 | 14424 | 188 |
2336135 | 2336135 | 2022-03-23 | Loudon | Tennessee | 47105 | 14424 | 188 |
2007673 | 2007673 | 2021-12-12 | Hawkins | Tennessee | 47073 | 11040 | 188 |
2004422 | 2004422 | 2021-12-11 | Hawkins | Tennessee | 47073 | 11040 | 188 |
2001171 | 2001171 | 2021-12-10 | Hawkins | Tennessee | 47073 | 11040 | 188 |
1854958 | 1854958 | 2021-10-26 | Robertson | Tennessee | 47147 | 14056 | 188 |
1851709 | 1851709 | 2021-10-25 | Robertson | Tennessee | 47147 | 14025 | 188 |
1848459 | 1848459 | 2021-10-24 | Robertson | Tennessee | 47147 | 14025 | 188 |
1845209 | 1845209 | 2021-10-23 | Robertson | Tennessee | 47147 | 14025 | 188 |
1841959 | 1841959 | 2021-10-22 | Robertson | Tennessee | 47147 | 14025 | 188 |
1835414 | 1835414 | 2021-10-20 | Gibson | Tennessee | 47053 | 10606 | 188 |
1832165 | 1832165 | 2021-10-19 | Gibson | Tennessee | 47053 | 10595 | 188 |
1783435 | 1783435 | 2021-10-04 | Hamblen | Tennessee | 47063 | 12654 | 188 |
1780186 | 1780186 | 2021-10-03 | Hamblen | Tennessee | 47063 | 12585 | 188 |
1776936 | 1776936 | 2021-10-02 | Hamblen | Tennessee | 47063 | 12585 | 188 |
1773686 | 1773686 | 2021-10-01 | Hamblen | Tennessee | 47063 | 12585 | 188 |
1711936 | 1711936 | 2021-09-12 | Carter | Tennessee | 47019 | 9013 | 188 |
1708689 | 1708689 | 2021-09-11 | Carter | Tennessee | 47019 | 9013 | 188 |
1705442 | 1705442 | 2021-09-10 | Carter | Tennessee | 47019 | 9013 | 188 |
1702192 | 1702192 | 2021-09-09 | Carter | Tennessee | 47019 | 8971 | 188 |
1695756 | 1695756 | 2021-09-07 | Putnam | Tennessee | 47141 | 14365 | 188 |
1673000 | 1673000 | 2021-08-31 | Maury | Tennessee | 47119 | 16270 | 188 |
1669752 | 1669752 | 2021-08-30 | Maury | Tennessee | 47119 | 16112 | 188 |
1666505 | 1666505 | 2021-08-29 | Maury | Tennessee | 47119 | 15825 | 188 |
1663257 | 1663257 | 2021-08-28 | Maury | Tennessee | 47119 | 15825 | 188 |
1660009 | 1660009 | 2021-08-27 | Maury | Tennessee | 47119 | 15825 | 188 |
1013901 | 1013901 | 2021-02-09 | Montgomery | Tennessee | 47125 | 16374 | 188 |
1010656 | 1010656 | 2021-02-08 | Montgomery | Tennessee | 47125 | 16329 | 188 |
968451 | 968451 | 2021-01-26 | Madison | Tennessee | 47113 | 9387 | 188 |
923053 | 923053 | 2021-01-12 | Washington | Tennessee | 47179 | 11534 | 188 |
897083 | 897083 | 2021-01-04 | Sullivan | Tennessee | 47163 | 11276 | 188 |
802929 | 802929 | 2020-12-06 | Knox | Tennessee | 47093 | 21280 | 188 |
375590 | 375590 | 2020-07-27 | Davidson | Tennessee | 47037 | 20154 | 188 |
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);