ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2020-04-18" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
69498 | 69498 | 2020-04-18 | Anderson | Tennessee | 47001 | 15 | 1 |
69499 | 69499 | 2020-04-18 | Bedford | Tennessee | 47003 | 62 | 2 |
69500 | 69500 | 2020-04-18 | Benton | Tennessee | 47005 | 4 | 0 |
69501 | 69501 | 2020-04-18 | Bledsoe | Tennessee | 47007 | 9 | 0 |
69502 | 69502 | 2020-04-18 | Blount | Tennessee | 47009 | 46 | 3 |
69503 | 69503 | 2020-04-18 | Bradley | Tennessee | 47011 | 38 | 1 |
69504 | 69504 | 2020-04-18 | Campbell | Tennessee | 47013 | 13 | 1 |
69505 | 69505 | 2020-04-18 | Cannon | Tennessee | 47015 | 9 | 0 |
69506 | 69506 | 2020-04-18 | Carroll | Tennessee | 47017 | 13 | 0 |
69507 | 69507 | 2020-04-18 | Carter | Tennessee | 47019 | 5 | 1 |
69508 | 69508 | 2020-04-18 | Cheatham | Tennessee | 47021 | 22 | 0 |
69509 | 69509 | 2020-04-18 | Chester | Tennessee | 47023 | 6 | 0 |
69510 | 69510 | 2020-04-18 | Claiborne | Tennessee | 47025 | 5 | 0 |
69511 | 69511 | 2020-04-18 | Clay | Tennessee | 47027 | 5 | 0 |
69512 | 69512 | 2020-04-18 | Cocke | Tennessee | 47029 | 11 | 0 |
69513 | 69513 | 2020-04-18 | Coffee | Tennessee | 47031 | 19 | 0 |
69514 | 69514 | 2020-04-18 | Crockett | Tennessee | 47033 | 3 | 0 |
69515 | 69515 | 2020-04-18 | Cumberland | Tennessee | 47035 | 57 | 0 |
69516 | 69516 | 2020-04-18 | Davidson | Tennessee | 47037 | 1680 | 20 |
69517 | 69517 | 2020-04-18 | DeKalb | Tennessee | 47041 | 10 | 0 |
69518 | 69518 | 2020-04-18 | Decatur | Tennessee | 47039 | 5 | 0 |
69519 | 69519 | 2020-04-18 | Dickson | Tennessee | 47043 | 43 | 0 |
69520 | 69520 | 2020-04-18 | Dyer | Tennessee | 47045 | 25 | 0 |
69521 | 69521 | 2020-04-18 | Fayette | Tennessee | 47047 | 45 | 1 |
69522 | 69522 | 2020-04-18 | Fentress | Tennessee | 47049 | 4 | 0 |
69523 | 69523 | 2020-04-18 | Franklin | Tennessee | 47051 | 23 | 1 |
69524 | 69524 | 2020-04-18 | Gibson | Tennessee | 47053 | 28 | 0 |
69525 | 69525 | 2020-04-18 | Giles | Tennessee | 47055 | 5 | 0 |
69526 | 69526 | 2020-04-18 | Grainger | Tennessee | 47057 | 4 | 0 |
69527 | 69527 | 2020-04-18 | Greene | Tennessee | 47059 | 30 | 2 |
69528 | 69528 | 2020-04-18 | Grundy | Tennessee | 47061 | 25 | 1 |
69529 | 69529 | 2020-04-18 | Hamblen | Tennessee | 47063 | 7 | 1 |
69530 | 69530 | 2020-04-18 | Hamilton | Tennessee | 47065 | 116 | 12 |
69531 | 69531 | 2020-04-18 | Hardeman | Tennessee | 47069 | 7 | 0 |
69532 | 69532 | 2020-04-18 | Hardin | Tennessee | 47071 | 4 | 0 |
69533 | 69533 | 2020-04-18 | Hawkins | Tennessee | 47073 | 27 | 2 |
69534 | 69534 | 2020-04-18 | Haywood | Tennessee | 47075 | 13 | 1 |
69535 | 69535 | 2020-04-18 | Henderson | Tennessee | 47077 | 4 | 0 |
69536 | 69536 | 2020-04-18 | Henry | Tennessee | 47079 | 9 | 0 |
69537 | 69537 | 2020-04-18 | Hickman | Tennessee | 47081 | 2 | 0 |
69538 | 69538 | 2020-04-18 | Houston | Tennessee | 47083 | 4 | 0 |
69539 | 69539 | 2020-04-18 | Humphreys | Tennessee | 47085 | 4 | 0 |
69540 | 69540 | 2020-04-18 | Jackson | Tennessee | 47087 | 11 | 0 |
69541 | 69541 | 2020-04-18 | Jefferson | Tennessee | 47089 | 15 | 0 |
69542 | 69542 | 2020-04-18 | Johnson | Tennessee | 47091 | 2 | 0 |
69543 | 69543 | 2020-04-18 | Knox | Tennessee | 47093 | 194 | 4 |
69544 | 69544 | 2020-04-18 | Lake | Tennessee | 47095 | 4 | 0 |
69545 | 69545 | 2020-04-18 | Lauderdale | Tennessee | 47097 | 13 | 0 |
69546 | 69546 | 2020-04-18 | Lawrence | Tennessee | 47099 | 15 | 0 |
69547 | 69547 | 2020-04-18 | Lewis | Tennessee | 47101 | 2 | 0 |
69548 | 69548 | 2020-04-18 | Lincoln | Tennessee | 47103 | 9 | 0 |
69549 | 69549 | 2020-04-18 | Loudon | Tennessee | 47105 | 21 | 0 |
69550 | 69550 | 2020-04-18 | Macon | Tennessee | 47111 | 33 | 3 |
69551 | 69551 | 2020-04-18 | Madison | Tennessee | 47113 | 83 | 0 |
69552 | 69552 | 2020-04-18 | Marion | Tennessee | 47115 | 28 | 1 |
69553 | 69553 | 2020-04-18 | Marshall | Tennessee | 47117 | 16 | 1 |
69554 | 69554 | 2020-04-18 | Maury | Tennessee | 47119 | 34 | 1 |
69555 | 69555 | 2020-04-18 | McMinn | Tennessee | 47107 | 6 | 0 |
69556 | 69556 | 2020-04-18 | McNairy | Tennessee | 47109 | 9 | 0 |
69557 | 69557 | 2020-04-18 | Meigs | Tennessee | 47121 | 3 | 0 |
69558 | 69558 | 2020-04-18 | Monroe | Tennessee | 47123 | 10 | 1 |
69559 | 69559 | 2020-04-18 | Montgomery | Tennessee | 47125 | 113 | 2 |
69560 | 69560 | 2020-04-18 | Moore | Tennessee | 47127 | 2 | 0 |
69561 | 69561 | 2020-04-18 | Morgan | Tennessee | 47129 | 5 | 0 |
69562 | 69562 | 2020-04-18 | Obion | Tennessee | 47131 | 9 | 1 |
69563 | 69563 | 2020-04-18 | Overton | Tennessee | 47133 | 7 | 0 |
69564 | 69564 | 2020-04-18 | Perry | Tennessee | 47135 | 6 | 0 |
69565 | 69565 | 2020-04-18 | Polk | Tennessee | 47139 | 5 | 0 |
69566 | 69566 | 2020-04-18 | Putnam | Tennessee | 47141 | 95 | 2 |
69567 | 69567 | 2020-04-18 | Rhea | Tennessee | 47143 | 1 | 0 |
69568 | 69568 | 2020-04-18 | Roane | Tennessee | 47145 | 8 | 0 |
69569 | 69569 | 2020-04-18 | Robertson | Tennessee | 47147 | 105 | 0 |
69570 | 69570 | 2020-04-18 | Rutherford | Tennessee | 47149 | 302 | 6 |
69571 | 69571 | 2020-04-18 | Scott | Tennessee | 47151 | 11 | 0 |
69572 | 69572 | 2020-04-18 | Sequatchie | Tennessee | 47153 | 3 | 0 |
69573 | 69573 | 2020-04-18 | Sevier | Tennessee | 47155 | 24 | 1 |
69574 | 69574 | 2020-04-18 | Shelby | Tennessee | 47157 | 1730 | 35 |
69575 | 69575 | 2020-04-18 | Smith | Tennessee | 47159 | 12 | 1 |
69576 | 69576 | 2020-04-18 | Stewart | Tennessee | 47161 | 5 | 0 |
69577 | 69577 | 2020-04-18 | Sullivan | Tennessee | 47163 | 45 | 1 |
69578 | 69578 | 2020-04-18 | Sumner | Tennessee | 47165 | 503 | 30 |
69579 | 69579 | 2020-04-18 | Tipton | Tennessee | 47167 | 57 | 0 |
69580 | 69580 | 2020-04-18 | Trousdale | Tennessee | 47169 | 20 | 1 |
69581 | 69581 | 2020-04-18 | Unicoi | Tennessee | 47171 | 1 | 0 |
69582 | 69582 | 2020-04-18 | Union | Tennessee | 47173 | 3 | 0 |
69583 | 69583 | 2020-04-18 | Van Buren | Tennessee | 47175 | 1 | 0 |
69584 | 69584 | 2020-04-18 | Warren | Tennessee | 47177 | 4 | 0 |
69585 | 69585 | 2020-04-18 | Washington | Tennessee | 47179 | 46 | 0 |
69586 | 69586 | 2020-04-18 | Wayne | Tennessee | 47181 | 2 | 0 |
69587 | 69587 | 2020-04-18 | Weakley | Tennessee | 47183 | 6 | 0 |
69588 | 69588 | 2020-04-18 | White | Tennessee | 47185 | 4 | 0 |
69589 | 69589 | 2020-04-18 | Williamson | Tennessee | 47187 | 342 | 6 |
69590 | 69590 | 2020-04-18 | Wilson | Tennessee | 47189 | 173 | 1 |
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);