ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-06-04 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
208472 | 208472 | 2020-06-04 | Anderson | Tennessee | 47001 | 42 | 2 |
208473 | 208473 | 2020-06-04 | Bedford | Tennessee | 47003 | 297 | 4 |
208474 | 208474 | 2020-06-04 | Benton | Tennessee | 47005 | 7 | 1 |
208475 | 208475 | 2020-06-04 | Bledsoe | Tennessee | 47007 | 610 | 1 |
208476 | 208476 | 2020-06-04 | Blount | Tennessee | 47009 | 93 | 3 |
208477 | 208477 | 2020-06-04 | Bradley | Tennessee | 47011 | 166 | 1 |
208478 | 208478 | 2020-06-04 | Campbell | Tennessee | 47013 | 18 | 1 |
208479 | 208479 | 2020-06-04 | Cannon | Tennessee | 47015 | 32 | 0 |
208480 | 208480 | 2020-06-04 | Carroll | Tennessee | 47017 | 28 | 1 |
208481 | 208481 | 2020-06-04 | Carter | Tennessee | 47019 | 19 | 1 |
208482 | 208482 | 2020-06-04 | Cheatham | Tennessee | 47021 | 135 | 0 |
208483 | 208483 | 2020-06-04 | Chester | Tennessee | 47023 | 12 | 0 |
208484 | 208484 | 2020-06-04 | Claiborne | Tennessee | 47025 | 12 | 0 |
208485 | 208485 | 2020-06-04 | Clay | Tennessee | 47027 | 8 | 0 |
208486 | 208486 | 2020-06-04 | Cocke | Tennessee | 47029 | 21 | 0 |
208487 | 208487 | 2020-06-04 | Coffee | Tennessee | 47031 | 78 | 0 |
208488 | 208488 | 2020-06-04 | Crockett | Tennessee | 47033 | 16 | 2 |
208489 | 208489 | 2020-06-04 | Cumberland | Tennessee | 47035 | 120 | 2 |
208490 | 208490 | 2020-06-04 | Davidson | Tennessee | 47037 | 5831 | 66 |
208491 | 208491 | 2020-06-04 | DeKalb | Tennessee | 47041 | 38 | 0 |
208492 | 208492 | 2020-06-04 | Decatur | Tennessee | 47039 | 5 | 0 |
208493 | 208493 | 2020-06-04 | Dickson | Tennessee | 47043 | 120 | 0 |
208494 | 208494 | 2020-06-04 | Dyer | Tennessee | 47045 | 57 | 0 |
208495 | 208495 | 2020-06-04 | Fayette | Tennessee | 47047 | 136 | 2 |
208496 | 208496 | 2020-06-04 | Fentress | Tennessee | 47049 | 12 | 0 |
208497 | 208497 | 2020-06-04 | Franklin | Tennessee | 47051 | 54 | 1 |
208498 | 208498 | 2020-06-04 | Gibson | Tennessee | 47053 | 63 | 1 |
208499 | 208499 | 2020-06-04 | Giles | Tennessee | 47055 | 13 | 0 |
208500 | 208500 | 2020-06-04 | Grainger | Tennessee | 47057 | 13 | 0 |
208501 | 208501 | 2020-06-04 | Greene | Tennessee | 47059 | 52 | 2 |
208502 | 208502 | 2020-06-04 | Grundy | Tennessee | 47061 | 31 | 1 |
208503 | 208503 | 2020-06-04 | Hamblen | Tennessee | 47063 | 42 | 2 |
208504 | 208504 | 2020-06-04 | Hamilton | Tennessee | 47065 | 1275 | 19 |
208505 | 208505 | 2020-06-04 | Hancock | Tennessee | 47067 | 1 | 0 |
208506 | 208506 | 2020-06-04 | Hardeman | Tennessee | 47069 | 202 | 0 |
208507 | 208507 | 2020-06-04 | Hardin | Tennessee | 47071 | 22 | 2 |
208508 | 208508 | 2020-06-04 | Hawkins | Tennessee | 47073 | 34 | 2 |
208509 | 208509 | 2020-06-04 | Haywood | Tennessee | 47075 | 33 | 2 |
208510 | 208510 | 2020-06-04 | Henderson | Tennessee | 47077 | 15 | 0 |
208511 | 208511 | 2020-06-04 | Henry | Tennessee | 47079 | 32 | 0 |
208512 | 208512 | 2020-06-04 | Hickman | Tennessee | 47081 | 58 | 0 |
208513 | 208513 | 2020-06-04 | Houston | Tennessee | 47083 | 8 | 0 |
208514 | 208514 | 2020-06-04 | Humphreys | Tennessee | 47085 | 15 | 1 |
208515 | 208515 | 2020-06-04 | Jackson | Tennessee | 47087 | 19 | 0 |
208516 | 208516 | 2020-06-04 | Jefferson | Tennessee | 47089 | 29 | 0 |
208517 | 208517 | 2020-06-04 | Johnson | Tennessee | 47091 | 19 | 0 |
208518 | 208518 | 2020-06-04 | Knox | Tennessee | 47093 | 463 | 5 |
208519 | 208519 | 2020-06-04 | Lake | Tennessee | 47095 | 794 | 0 |
208520 | 208520 | 2020-06-04 | Lauderdale | Tennessee | 47097 | 59 | 1 |
208521 | 208521 | 2020-06-04 | Lawrence | Tennessee | 47099 | 33 | 0 |
208522 | 208522 | 2020-06-04 | Lewis | Tennessee | 47101 | 3 | 0 |
208523 | 208523 | 2020-06-04 | Lincoln | Tennessee | 47103 | 29 | 0 |
208524 | 208524 | 2020-06-04 | Loudon | Tennessee | 47105 | 161 | 0 |
208525 | 208525 | 2020-06-04 | Macon | Tennessee | 47111 | 166 | 3 |
208526 | 208526 | 2020-06-04 | Madison | Tennessee | 47113 | 173 | 2 |
208527 | 208527 | 2020-06-04 | Marion | Tennessee | 47115 | 44 | 1 |
208528 | 208528 | 2020-06-04 | Marshall | Tennessee | 47117 | 33 | 1 |
208529 | 208529 | 2020-06-04 | Maury | Tennessee | 47119 | 107 | 1 |
208530 | 208530 | 2020-06-04 | McMinn | Tennessee | 47107 | 146 | 14 |
208531 | 208531 | 2020-06-04 | McNairy | Tennessee | 47109 | 15 | 0 |
208532 | 208532 | 2020-06-04 | Meigs | Tennessee | 47121 | 27 | 0 |
208533 | 208533 | 2020-06-04 | Monroe | Tennessee | 47123 | 71 | 3 |
208534 | 208534 | 2020-06-04 | Montgomery | Tennessee | 47125 | 286 | 3 |
208535 | 208535 | 2020-06-04 | Moore | Tennessee | 47127 | 5 | 0 |
208536 | 208536 | 2020-06-04 | Morgan | Tennessee | 47129 | 17 | 0 |
208537 | 208537 | 2020-06-04 | Obion | Tennessee | 47131 | 45 | 3 |
208538 | 208538 | 2020-06-04 | Overton | Tennessee | 47133 | 32 | 0 |
208539 | 208539 | 2020-06-04 | Perry | Tennessee | 47135 | 24 | 0 |
208540 | 208540 | 2020-06-04 | Pickett | Tennessee | 47137 | 3 | 0 |
208541 | 208541 | 2020-06-04 | Polk | Tennessee | 47139 | 19 | 0 |
208542 | 208542 | 2020-06-04 | Putnam | Tennessee | 47141 | 524 | 6 |
208543 | 208543 | 2020-06-04 | Rhea | Tennessee | 47143 | 217 | 0 |
208544 | 208544 | 2020-06-04 | Roane | Tennessee | 47145 | 16 | 0 |
208545 | 208545 | 2020-06-04 | Robertson | Tennessee | 47147 | 523 | 5 |
208546 | 208546 | 2020-06-04 | Rutherford | Tennessee | 47149 | 1343 | 28 |
208547 | 208547 | 2020-06-04 | Scott | Tennessee | 47151 | 12 | 0 |
208548 | 208548 | 2020-06-04 | Sequatchie | Tennessee | 47153 | 20 | 0 |
208549 | 208549 | 2020-06-04 | Sevier | Tennessee | 47155 | 97 | 2 |
208550 | 208550 | 2020-06-04 | Shelby | Tennessee | 47157 | 5546 | 124 |
208551 | 208551 | 2020-06-04 | Smith | Tennessee | 47159 | 36 | 1 |
208552 | 208552 | 2020-06-04 | Stewart | Tennessee | 47161 | 13 | 0 |
208553 | 208553 | 2020-06-04 | Sullivan | Tennessee | 47163 | 60 | 2 |
208554 | 208554 | 2020-06-04 | Sumner | Tennessee | 47165 | 938 | 46 |
208555 | 208555 | 2020-06-04 | Tipton | Tennessee | 47167 | 461 | 3 |
208556 | 208556 | 2020-06-04 | Trousdale | Tennessee | 47169 | 1394 | 4 |
208557 | 208557 | 2020-06-04 | Unicoi | Tennessee | 47171 | 48 | 0 |
208558 | 208558 | 2020-06-04 | Union | Tennessee | 47173 | 4 | 0 |
208559 | 208559 | 2020-06-04 | Unknown | Tennessee | 158 | 4 | |
208560 | 208560 | 2020-06-04 | Van Buren | Tennessee | 47175 | 4 | 0 |
208561 | 208561 | 2020-06-04 | Warren | Tennessee | 47177 | 26 | 0 |
208562 | 208562 | 2020-06-04 | Washington | Tennessee | 47179 | 75 | 0 |
208563 | 208563 | 2020-06-04 | Wayne | Tennessee | 47181 | 64 | 0 |
208564 | 208564 | 2020-06-04 | Weakley | Tennessee | 47183 | 26 | 0 |
208565 | 208565 | 2020-06-04 | White | Tennessee | 47185 | 33 | 0 |
208566 | 208566 | 2020-06-04 | Williamson | Tennessee | 47187 | 589 | 11 |
208567 | 208567 | 2020-06-04 | Wilson | Tennessee | 47189 | 449 | 8 |
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);