ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where "date" is on date 2020-03-23 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9255 | 9255 | 2020-03-23 | Anderson | Tennessee | 47001 | 1 | 0 |
9256 | 9256 | 2020-03-23 | Blount | Tennessee | 47009 | 1 | 0 |
9257 | 9257 | 2020-03-23 | Bradley | Tennessee | 47011 | 2 | 0 |
9258 | 9258 | 2020-03-23 | Campbell | Tennessee | 47013 | 2 | 0 |
9259 | 9259 | 2020-03-23 | Carroll | Tennessee | 47017 | 2 | 0 |
9260 | 9260 | 2020-03-23 | Cheatham | Tennessee | 47021 | 4 | 0 |
9261 | 9261 | 2020-03-23 | Chester | Tennessee | 47023 | 1 | 0 |
9262 | 9262 | 2020-03-23 | Cocke | Tennessee | 47029 | 1 | 0 |
9263 | 9263 | 2020-03-23 | Cumberland | Tennessee | 47035 | 2 | 0 |
9264 | 9264 | 2020-03-23 | Davidson | Tennessee | 47037 | 184 | 2 |
9265 | 9265 | 2020-03-23 | Dickson | Tennessee | 47043 | 4 | 0 |
9266 | 9266 | 2020-03-23 | Dyer | Tennessee | 47045 | 2 | 0 |
9267 | 9267 | 2020-03-23 | Fayette | Tennessee | 47047 | 3 | 0 |
9268 | 9268 | 2020-03-23 | Franklin | Tennessee | 47051 | 1 | 0 |
9269 | 9269 | 2020-03-23 | Gibson | Tennessee | 47053 | 1 | 0 |
9270 | 9270 | 2020-03-23 | Greene | Tennessee | 47059 | 2 | 0 |
9271 | 9271 | 2020-03-23 | Hamblen | Tennessee | 47063 | 2 | 0 |
9272 | 9272 | 2020-03-23 | Hamilton | Tennessee | 47065 | 8 | 0 |
9273 | 9273 | 2020-03-23 | Houston | Tennessee | 47083 | 1 | 0 |
9274 | 9274 | 2020-03-23 | Jefferson | Tennessee | 47089 | 2 | 0 |
9275 | 9275 | 2020-03-23 | Knox | Tennessee | 47093 | 5 | 0 |
9276 | 9276 | 2020-03-23 | Loudon | Tennessee | 47105 | 1 | 0 |
9277 | 9277 | 2020-03-23 | Marion | Tennessee | 47115 | 1 | 0 |
9278 | 9278 | 2020-03-23 | Maury | Tennessee | 47119 | 2 | 0 |
9279 | 9279 | 2020-03-23 | McMinn | Tennessee | 47107 | 1 | 0 |
9280 | 9280 | 2020-03-23 | Monroe | Tennessee | 47123 | 3 | 0 |
9281 | 9281 | 2020-03-23 | Montgomery | Tennessee | 47125 | 3 | 0 |
9282 | 9282 | 2020-03-23 | Perry | Tennessee | 47135 | 1 | 0 |
9283 | 9283 | 2020-03-23 | Putnam | Tennessee | 47141 | 6 | 0 |
9284 | 9284 | 2020-03-23 | Roane | Tennessee | 47145 | 1 | 0 |
9285 | 9285 | 2020-03-23 | Robertson | Tennessee | 47147 | 3 | 0 |
9286 | 9286 | 2020-03-23 | Rutherford | Tennessee | 47149 | 8 | 0 |
9287 | 9287 | 2020-03-23 | Scott | Tennessee | 47151 | 2 | 0 |
9288 | 9288 | 2020-03-23 | Sevier | Tennessee | 47155 | 3 | 0 |
9289 | 9289 | 2020-03-23 | Shelby | Tennessee | 47157 | 66 | 0 |
9290 | 9290 | 2020-03-23 | Sullivan | Tennessee | 47163 | 1 | 0 |
9291 | 9291 | 2020-03-23 | Sumner | Tennessee | 47165 | 22 | 0 |
9292 | 9292 | 2020-03-23 | Tipton | Tennessee | 47167 | 5 | 0 |
9293 | 9293 | 2020-03-23 | Unknown | Tennessee | 109 | 0 | |
9294 | 9294 | 2020-03-23 | Washington | Tennessee | 47179 | 2 | 0 |
9295 | 9295 | 2020-03-23 | Williamson | Tennessee | 47187 | 48 | 0 |
9296 | 9296 | 2020-03-23 | Wilson | Tennessee | 47189 | 3 | 0 |
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);