ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where deaths = 154 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401232 | 2401232 | 2022-04-12 | Rhea | Tennessee | 47143 | 9970 | 154 |
2397977 | 2397977 | 2022-04-11 | Rhea | Tennessee | 47143 | 9970 | 154 |
2394722 | 2394722 | 2022-04-10 | Rhea | Tennessee | 47143 | 9970 | 154 |
2391466 | 2391466 | 2022-04-09 | Rhea | Tennessee | 47143 | 9970 | 154 |
2388210 | 2388210 | 2022-04-08 | Rhea | Tennessee | 47143 | 9970 | 154 |
2384955 | 2384955 | 2022-04-07 | Rhea | Tennessee | 47143 | 9970 | 154 |
2381700 | 2381700 | 2022-04-06 | Rhea | Tennessee | 47143 | 9970 | 154 |
2378412 | 2378412 | 2022-04-05 | Henderson | Tennessee | 47077 | 9107 | 154 |
2378413 | 2378413 | 2022-04-05 | Henry | Tennessee | 47079 | 8252 | 154 |
2378445 | 2378445 | 2022-04-05 | Rhea | Tennessee | 47143 | 9967 | 154 |
2375158 | 2375158 | 2022-04-04 | Henderson | Tennessee | 47077 | 9107 | 154 |
2375159 | 2375159 | 2022-04-04 | Henry | Tennessee | 47079 | 8252 | 154 |
2375191 | 2375191 | 2022-04-04 | Rhea | Tennessee | 47143 | 9967 | 154 |
2371906 | 2371906 | 2022-04-03 | Henderson | Tennessee | 47077 | 9107 | 154 |
2371907 | 2371907 | 2022-04-03 | Henry | Tennessee | 47079 | 8252 | 154 |
2371939 | 2371939 | 2022-04-03 | Rhea | Tennessee | 47143 | 9967 | 154 |
2368653 | 2368653 | 2022-04-02 | Henderson | Tennessee | 47077 | 9107 | 154 |
2368654 | 2368654 | 2022-04-02 | Henry | Tennessee | 47079 | 8252 | 154 |
2368686 | 2368686 | 2022-04-02 | Rhea | Tennessee | 47143 | 9967 | 154 |
2365400 | 2365400 | 2022-04-01 | Henderson | Tennessee | 47077 | 9107 | 154 |
2365401 | 2365401 | 2022-04-01 | Henry | Tennessee | 47079 | 8252 | 154 |
2365433 | 2365433 | 2022-04-01 | Rhea | Tennessee | 47143 | 9967 | 154 |
2362147 | 2362147 | 2022-03-31 | Henderson | Tennessee | 47077 | 9107 | 154 |
2362148 | 2362148 | 2022-03-31 | Henry | Tennessee | 47079 | 8252 | 154 |
2362180 | 2362180 | 2022-03-31 | Rhea | Tennessee | 47143 | 9967 | 154 |
2358893 | 2358893 | 2022-03-30 | Henderson | Tennessee | 47077 | 9107 | 154 |
2358894 | 2358894 | 2022-03-30 | Henry | Tennessee | 47079 | 8252 | 154 |
2358926 | 2358926 | 2022-03-30 | Rhea | Tennessee | 47143 | 9967 | 154 |
2355639 | 2355639 | 2022-03-29 | Henderson | Tennessee | 47077 | 9094 | 154 |
2355640 | 2355640 | 2022-03-29 | Henry | Tennessee | 47079 | 8244 | 154 |
2355672 | 2355672 | 2022-03-29 | Rhea | Tennessee | 47143 | 9959 | 154 |
2352386 | 2352386 | 2022-03-28 | Henderson | Tennessee | 47077 | 9094 | 154 |
2352387 | 2352387 | 2022-03-28 | Henry | Tennessee | 47079 | 8244 | 154 |
2352419 | 2352419 | 2022-03-28 | Rhea | Tennessee | 47143 | 9959 | 154 |
2349134 | 2349134 | 2022-03-27 | Henderson | Tennessee | 47077 | 9094 | 154 |
2349135 | 2349135 | 2022-03-27 | Henry | Tennessee | 47079 | 8244 | 154 |
2349167 | 2349167 | 2022-03-27 | Rhea | Tennessee | 47143 | 9959 | 154 |
2345881 | 2345881 | 2022-03-26 | Henderson | Tennessee | 47077 | 9094 | 154 |
2345882 | 2345882 | 2022-03-26 | Henry | Tennessee | 47079 | 8244 | 154 |
2345914 | 2345914 | 2022-03-26 | Rhea | Tennessee | 47143 | 9959 | 154 |
2342628 | 2342628 | 2022-03-25 | Henderson | Tennessee | 47077 | 9094 | 154 |
2342629 | 2342629 | 2022-03-25 | Henry | Tennessee | 47079 | 8244 | 154 |
2342661 | 2342661 | 2022-03-25 | Rhea | Tennessee | 47143 | 9959 | 154 |
2339375 | 2339375 | 2022-03-24 | Henderson | Tennessee | 47077 | 9094 | 154 |
2339376 | 2339376 | 2022-03-24 | Henry | Tennessee | 47079 | 8244 | 154 |
2339408 | 2339408 | 2022-03-24 | Rhea | Tennessee | 47143 | 9959 | 154 |
2336121 | 2336121 | 2022-03-23 | Henderson | Tennessee | 47077 | 9094 | 154 |
2336122 | 2336122 | 2022-03-23 | Henry | Tennessee | 47079 | 8244 | 154 |
2336154 | 2336154 | 2022-03-23 | Rhea | Tennessee | 47143 | 9959 | 154 |
2332868 | 2332868 | 2022-03-22 | Henry | Tennessee | 47079 | 8237 | 154 |
2329615 | 2329615 | 2022-03-21 | Henry | Tennessee | 47079 | 8237 | 154 |
2326363 | 2326363 | 2022-03-20 | Henry | Tennessee | 47079 | 8237 | 154 |
2323110 | 2323110 | 2022-03-19 | Henry | Tennessee | 47079 | 8237 | 154 |
2319856 | 2319856 | 2022-03-18 | Henry | Tennessee | 47079 | 8237 | 154 |
2316602 | 2316602 | 2022-03-17 | Henry | Tennessee | 47079 | 8237 | 154 |
2313349 | 2313349 | 2022-03-16 | Henry | Tennessee | 47079 | 8237 | 154 |
2287344 | 2287344 | 2022-03-08 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2284092 | 2284092 | 2022-03-07 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2280840 | 2280840 | 2022-03-06 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2277587 | 2277587 | 2022-03-05 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2274334 | 2274334 | 2022-03-04 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2271081 | 2271081 | 2022-03-03 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2267829 | 2267829 | 2022-03-02 | Lincoln | Tennessee | 47103 | 9923 | 154 |
2196332 | 2196332 | 2022-02-08 | Warren | Tennessee | 47177 | 11735 | 154 |
2193078 | 2193078 | 2022-02-07 | Warren | Tennessee | 47177 | 11735 | 154 |
2189824 | 2189824 | 2022-02-06 | Warren | Tennessee | 47177 | 11735 | 154 |
2186571 | 2186571 | 2022-02-05 | Warren | Tennessee | 47177 | 11735 | 154 |
2183319 | 2183319 | 2022-02-04 | Warren | Tennessee | 47177 | 11735 | 154 |
2180067 | 2180067 | 2022-02-03 | Warren | Tennessee | 47177 | 11735 | 154 |
2176816 | 2176816 | 2022-02-02 | Warren | Tennessee | 47177 | 11735 | 154 |
2173538 | 2173538 | 2022-02-01 | Obion | Tennessee | 47131 | 9614 | 154 |
2173562 | 2173562 | 2022-02-01 | Warren | Tennessee | 47177 | 10915 | 154 |
2170286 | 2170286 | 2022-01-31 | Obion | Tennessee | 47131 | 9614 | 154 |
2170310 | 2170310 | 2022-01-31 | Warren | Tennessee | 47177 | 10915 | 154 |
2167032 | 2167032 | 2022-01-30 | Obion | Tennessee | 47131 | 9614 | 154 |
2167056 | 2167056 | 2022-01-30 | Warren | Tennessee | 47177 | 10915 | 154 |
2163777 | 2163777 | 2022-01-29 | Obion | Tennessee | 47131 | 9614 | 154 |
2163801 | 2163801 | 2022-01-29 | Warren | Tennessee | 47177 | 10915 | 154 |
2160522 | 2160522 | 2022-01-28 | Obion | Tennessee | 47131 | 9614 | 154 |
2160546 | 2160546 | 2022-01-28 | Warren | Tennessee | 47177 | 10915 | 154 |
2157266 | 2157266 | 2022-01-27 | Obion | Tennessee | 47131 | 9614 | 154 |
2157290 | 2157290 | 2022-01-27 | Warren | Tennessee | 47177 | 10915 | 154 |
2154013 | 2154013 | 2022-01-26 | Obion | Tennessee | 47131 | 9614 | 154 |
2154037 | 2154037 | 2022-01-26 | Warren | Tennessee | 47177 | 10915 | 154 |
2150723 | 2150723 | 2022-01-25 | Giles | Tennessee | 47055 | 7460 | 154 |
2150785 | 2150785 | 2022-01-25 | Warren | Tennessee | 47177 | 9973 | 154 |
2147471 | 2147471 | 2022-01-24 | Giles | Tennessee | 47055 | 7460 | 154 |
2147533 | 2147533 | 2022-01-24 | Warren | Tennessee | 47177 | 9973 | 154 |
2144217 | 2144217 | 2022-01-23 | Giles | Tennessee | 47055 | 7460 | 154 |
2144279 | 2144279 | 2022-01-23 | Warren | Tennessee | 47177 | 9973 | 154 |
2140962 | 2140962 | 2022-01-22 | Giles | Tennessee | 47055 | 7460 | 154 |
2141024 | 2141024 | 2022-01-22 | Warren | Tennessee | 47177 | 9973 | 154 |
2137706 | 2137706 | 2022-01-21 | Giles | Tennessee | 47055 | 7460 | 154 |
2137768 | 2137768 | 2022-01-21 | Warren | Tennessee | 47177 | 9973 | 154 |
2134452 | 2134452 | 2022-01-20 | Giles | Tennessee | 47055 | 7460 | 154 |
2134514 | 2134514 | 2022-01-20 | Warren | Tennessee | 47177 | 9973 | 154 |
2131200 | 2131200 | 2022-01-19 | Giles | Tennessee | 47055 | 7460 | 154 |
2131262 | 2131262 | 2022-01-19 | Warren | Tennessee | 47177 | 9973 | 154 |
2040226 | 2040226 | 2021-12-22 | Tipton | Tennessee | 47167 | 12072 | 154 |
2036976 | 2036976 | 2021-12-21 | Tipton | Tennessee | 47167 | 12034 | 154 |
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);