ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-03-31" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23427 | 23427 | 2020-03-31 | Anderson | Tennessee | 47001 | 10 | 0 |
23428 | 23428 | 2020-03-31 | Bedford | Tennessee | 47003 | 2 | 0 |
23429 | 23429 | 2020-03-31 | Benton | Tennessee | 47005 | 4 | 0 |
23430 | 23430 | 2020-03-31 | Bledsoe | Tennessee | 47007 | 2 | 0 |
23431 | 23431 | 2020-03-31 | Blount | Tennessee | 47009 | 25 | 0 |
23432 | 23432 | 2020-03-31 | Bradley | Tennessee | 47011 | 10 | 0 |
23433 | 23433 | 2020-03-31 | Campbell | Tennessee | 47013 | 4 | 0 |
23434 | 23434 | 2020-03-31 | Cannon | Tennessee | 47015 | 3 | 0 |
23435 | 23435 | 2020-03-31 | Carroll | Tennessee | 47017 | 5 | 0 |
23436 | 23436 | 2020-03-31 | Carter | Tennessee | 47019 | 1 | 0 |
23437 | 23437 | 2020-03-31 | Cheatham | Tennessee | 47021 | 10 | 0 |
23438 | 23438 | 2020-03-31 | Chester | Tennessee | 47023 | 3 | 0 |
23439 | 23439 | 2020-03-31 | Claiborne | Tennessee | 47025 | 2 | 0 |
23440 | 23440 | 2020-03-31 | Cocke | Tennessee | 47029 | 1 | 0 |
23441 | 23441 | 2020-03-31 | Coffee | Tennessee | 47031 | 1 | 0 |
23442 | 23442 | 2020-03-31 | Cumberland | Tennessee | 47035 | 11 | 0 |
23443 | 23443 | 2020-03-31 | Davidson | Tennessee | 47037 | 541 | 3 |
23444 | 23444 | 2020-03-31 | DeKalb | Tennessee | 47041 | 4 | 0 |
23445 | 23445 | 2020-03-31 | Dickson | Tennessee | 47043 | 17 | 0 |
23446 | 23446 | 2020-03-31 | Dyer | Tennessee | 47045 | 3 | 0 |
23447 | 23447 | 2020-03-31 | Fayette | Tennessee | 47047 | 12 | 0 |
23448 | 23448 | 2020-03-31 | Fentress | Tennessee | 47049 | 1 | 0 |
23449 | 23449 | 2020-03-31 | Franklin | Tennessee | 47051 | 5 | 0 |
23450 | 23450 | 2020-03-31 | Gibson | Tennessee | 47053 | 6 | 0 |
23451 | 23451 | 2020-03-31 | Giles | Tennessee | 47055 | 3 | 0 |
23452 | 23452 | 2020-03-31 | Greene | Tennessee | 47059 | 12 | 0 |
23453 | 23453 | 2020-03-31 | Grundy | Tennessee | 47061 | 4 | 0 |
23454 | 23454 | 2020-03-31 | Hamblen | Tennessee | 47063 | 2 | 0 |
23455 | 23455 | 2020-03-31 | Hamilton | Tennessee | 47065 | 48 | 0 |
23456 | 23456 | 2020-03-31 | Hardeman | Tennessee | 47069 | 1 | 0 |
23457 | 23457 | 2020-03-31 | Hardin | Tennessee | 47071 | 1 | 0 |
23458 | 23458 | 2020-03-31 | Hawkins | Tennessee | 47073 | 4 | 0 |
23459 | 23459 | 2020-03-31 | Haywood | Tennessee | 47075 | 2 | 0 |
23460 | 23460 | 2020-03-31 | Henry | Tennessee | 47079 | 1 | 0 |
23461 | 23461 | 2020-03-31 | Houston | Tennessee | 47083 | 1 | 0 |
23462 | 23462 | 2020-03-31 | Humphreys | Tennessee | 47085 | 2 | 0 |
23463 | 23463 | 2020-03-31 | Jefferson | Tennessee | 47089 | 6 | 0 |
23464 | 23464 | 2020-03-31 | Johnson | Tennessee | 47091 | 2 | 0 |
23465 | 23465 | 2020-03-31 | Knox | Tennessee | 47093 | 66 | 1 |
23466 | 23466 | 2020-03-31 | Lawrence | Tennessee | 47099 | 2 | 0 |
23467 | 23467 | 2020-03-31 | Lewis | Tennessee | 47101 | 2 | 0 |
23468 | 23468 | 2020-03-31 | Lincoln | Tennessee | 47103 | 1 | 0 |
23469 | 23469 | 2020-03-31 | Loudon | Tennessee | 47105 | 8 | 0 |
23470 | 23470 | 2020-03-31 | Macon | Tennessee | 47111 | 4 | 0 |
23471 | 23471 | 2020-03-31 | Madison | Tennessee | 47113 | 5 | 0 |
23472 | 23472 | 2020-03-31 | Marion | Tennessee | 47115 | 6 | 0 |
23473 | 23473 | 2020-03-31 | Marshall | Tennessee | 47117 | 1 | 0 |
23474 | 23474 | 2020-03-31 | Maury | Tennessee | 47119 | 15 | 0 |
23475 | 23475 | 2020-03-31 | McMinn | Tennessee | 47107 | 3 | 0 |
23476 | 23476 | 2020-03-31 | McNairy | Tennessee | 47109 | 1 | 0 |
23477 | 23477 | 2020-03-31 | Meigs | Tennessee | 47121 | 1 | 0 |
23478 | 23478 | 2020-03-31 | Monroe | Tennessee | 47123 | 5 | 0 |
23479 | 23479 | 2020-03-31 | Montgomery | Tennessee | 47125 | 19 | 0 |
23480 | 23480 | 2020-03-31 | Morgan | Tennessee | 47129 | 1 | 0 |
23481 | 23481 | 2020-03-31 | Obion | Tennessee | 47131 | 1 | 0 |
23482 | 23482 | 2020-03-31 | Overton | Tennessee | 47133 | 2 | 0 |
23483 | 23483 | 2020-03-31 | Perry | Tennessee | 47135 | 2 | 0 |
23484 | 23484 | 2020-03-31 | Putnam | Tennessee | 47141 | 24 | 0 |
23485 | 23485 | 2020-03-31 | Roane | Tennessee | 47145 | 2 | 0 |
23486 | 23486 | 2020-03-31 | Robertson | Tennessee | 47147 | 27 | 0 |
23487 | 23487 | 2020-03-31 | Rutherford | Tennessee | 47149 | 57 | 0 |
23488 | 23488 | 2020-03-31 | Scott | Tennessee | 47151 | 2 | 0 |
23489 | 23489 | 2020-03-31 | Sevier | Tennessee | 47155 | 7 | 0 |
23490 | 23490 | 2020-03-31 | Shelby | Tennessee | 47157 | 396 | 1 |
23491 | 23491 | 2020-03-31 | Smith | Tennessee | 47159 | 1 | 0 |
23492 | 23492 | 2020-03-31 | Sullivan | Tennessee | 47163 | 11 | 0 |
23493 | 23493 | 2020-03-31 | Sumner | Tennessee | 47165 | 164 | 0 |
23494 | 23494 | 2020-03-31 | Tipton | Tennessee | 47167 | 16 | 0 |
23495 | 23495 | 2020-03-31 | Trousdale | Tennessee | 47169 | 3 | 0 |
23496 | 23496 | 2020-03-31 | Unicoi | Tennessee | 47171 | 1 | 0 |
23497 | 23497 | 2020-03-31 | Union | Tennessee | 47173 | 1 | 0 |
23498 | 23498 | 2020-03-31 | Unknown | Tennessee | 259 | 8 | |
23499 | 23499 | 2020-03-31 | Warren | Tennessee | 47177 | 1 | 0 |
23500 | 23500 | 2020-03-31 | Washington | Tennessee | 47179 | 14 | 0 |
23501 | 23501 | 2020-03-31 | Wayne | Tennessee | 47181 | 1 | 0 |
23502 | 23502 | 2020-03-31 | Weakley | Tennessee | 47183 | 1 | 0 |
23503 | 23503 | 2020-03-31 | White | Tennessee | 47185 | 1 | 0 |
23504 | 23504 | 2020-03-31 | Williamson | Tennessee | 47187 | 111 | 0 |
23505 | 23505 | 2020-03-31 | Wilson | Tennessee | 47189 | 32 | 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);