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 2021-07-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1562498 | 1562498 | 2021-07-28 | Anderson | Tennessee | 47001 | 8959 | 179 |
1562499 | 1562499 | 2021-07-28 | Bedford | Tennessee | 47003 | 6808 | 134 |
1562500 | 1562500 | 2021-07-28 | Benton | Tennessee | 47005 | 1729 | 41 |
1562501 | 1562501 | 2021-07-28 | Bledsoe | Tennessee | 47007 | 2280 | 12 |
1562502 | 1562502 | 2021-07-28 | Blount | Tennessee | 47009 | 16275 | 202 |
1562503 | 1562503 | 2021-07-28 | Bradley | Tennessee | 47011 | 15554 | 156 |
1562504 | 1562504 | 2021-07-28 | Campbell | Tennessee | 47013 | 4264 | 62 |
1562505 | 1562505 | 2021-07-28 | Cannon | Tennessee | 47015 | 1987 | 32 |
1562506 | 1562506 | 2021-07-28 | Carroll | Tennessee | 47017 | 3762 | 84 |
1562507 | 1562507 | 2021-07-28 | Carter | Tennessee | 47019 | 6880 | 163 |
1562508 | 1562508 | 2021-07-28 | Cheatham | Tennessee | 47021 | 4749 | 56 |
1562509 | 1562509 | 2021-07-28 | Chester | Tennessee | 47023 | 2270 | 51 |
1562510 | 1562510 | 2021-07-28 | Claiborne | Tennessee | 47025 | 3284 | 75 |
1562511 | 1562511 | 2021-07-28 | Clay | Tennessee | 47027 | 1127 | 30 |
1562512 | 1562512 | 2021-07-28 | Cocke | Tennessee | 47029 | 4618 | 101 |
1562513 | 1562513 | 2021-07-28 | Coffee | Tennessee | 47031 | 7061 | 123 |
1562514 | 1562514 | 2021-07-28 | Crockett | Tennessee | 47033 | 2133 | 50 |
1562515 | 1562515 | 2021-07-28 | Cumberland | Tennessee | 47035 | 7040 | 143 |
1562516 | 1562516 | 2021-07-28 | Davidson | Tennessee | 47037 | 101428 | 962 |
1562517 | 1562517 | 2021-07-28 | DeKalb | Tennessee | 47041 | 2907 | 57 |
1562518 | 1562518 | 2021-07-28 | Decatur | Tennessee | 47039 | 1650 | 39 |
1562519 | 1562519 | 2021-07-28 | Dickson | Tennessee | 47043 | 7243 | 115 |
1562520 | 1562520 | 2021-07-28 | Dyer | Tennessee | 47045 | 5629 | 108 |
1562521 | 1562521 | 2021-07-28 | Fayette | Tennessee | 47047 | 5381 | 83 |
1562522 | 1562522 | 2021-07-28 | Fentress | Tennessee | 47049 | 2551 | 49 |
1562523 | 1562523 | 2021-07-28 | Franklin | Tennessee | 47051 | 5422 | 92 |
1562524 | 1562524 | 2021-07-28 | Gibson | Tennessee | 47053 | 6889 | 152 |
1562525 | 1562525 | 2021-07-28 | Giles | Tennessee | 47055 | 4115 | 99 |
1562526 | 1562526 | 2021-07-28 | Grainger | Tennessee | 47057 | 2720 | 50 |
1562527 | 1562527 | 2021-07-28 | Greene | Tennessee | 47059 | 8199 | 159 |
1562528 | 1562528 | 2021-07-28 | Grundy | Tennessee | 47061 | 1841 | 35 |
1562529 | 1562529 | 2021-07-28 | Hamblen | Tennessee | 47063 | 8905 | 175 |
1562530 | 1562530 | 2021-07-28 | Hamilton | Tennessee | 47065 | 46863 | 514 |
1562531 | 1562531 | 2021-07-28 | Hancock | Tennessee | 47067 | 643 | 13 |
1562532 | 1562532 | 2021-07-28 | Hardeman | Tennessee | 47069 | 3616 | 64 |
1562533 | 1562533 | 2021-07-28 | Hardin | Tennessee | 47071 | 3686 | 69 |
1562534 | 1562534 | 2021-07-28 | Hawkins | Tennessee | 47073 | 6476 | 115 |
1562535 | 1562535 | 2021-07-28 | Haywood | Tennessee | 47075 | 2765 | 62 |
1562536 | 1562536 | 2021-07-28 | Henderson | Tennessee | 47077 | 3940 | 78 |
1562537 | 1562537 | 2021-07-28 | Henry | Tennessee | 47079 | 3541 | 76 |
1562538 | 1562538 | 2021-07-28 | Hickman | Tennessee | 47081 | 2931 | 47 |
1562539 | 1562539 | 2021-07-28 | Houston | Tennessee | 47083 | 1143 | 34 |
1562540 | 1562540 | 2021-07-28 | Humphreys | Tennessee | 47085 | 2005 | 32 |
1562541 | 1562541 | 2021-07-28 | Jackson | Tennessee | 47087 | 1381 | 37 |
1562542 | 1562542 | 2021-07-28 | Jefferson | Tennessee | 47089 | 6469 | 126 |
1562543 | 1562543 | 2021-07-28 | Johnson | Tennessee | 47091 | 2478 | 39 |
1562544 | 1562544 | 2021-07-28 | Knox | Tennessee | 47093 | 53103 | 656 |
1562545 | 1562545 | 2021-07-28 | Lake | Tennessee | 47095 | 1732 | 31 |
1562546 | 1562546 | 2021-07-28 | Lauderdale | Tennessee | 47097 | 3306 | 50 |
1562547 | 1562547 | 2021-07-28 | Lawrence | Tennessee | 47099 | 6237 | 97 |
1562548 | 1562548 | 2021-07-28 | Lewis | Tennessee | 47101 | 1666 | 26 |
1562549 | 1562549 | 2021-07-28 | Lincoln | Tennessee | 47103 | 4504 | 67 |
1562550 | 1562550 | 2021-07-28 | Loudon | Tennessee | 47105 | 6348 | 71 |
1562551 | 1562551 | 2021-07-28 | Macon | Tennessee | 47111 | 3706 | 78 |
1562552 | 1562552 | 2021-07-28 | Madison | Tennessee | 47113 | 11877 | 246 |
1562553 | 1562553 | 2021-07-28 | Marion | Tennessee | 47115 | 3385 | 50 |
1562554 | 1562554 | 2021-07-28 | Marshall | Tennessee | 47117 | 4479 | 64 |
1562555 | 1562555 | 2021-07-28 | Maury | Tennessee | 47119 | 14029 | 178 |
1562556 | 1562556 | 2021-07-28 | McMinn | Tennessee | 47107 | 6804 | 105 |
1562557 | 1562557 | 2021-07-28 | McNairy | Tennessee | 47109 | 2960 | 57 |
1562558 | 1562558 | 2021-07-28 | Meigs | Tennessee | 47121 | 1448 | 24 |
1562559 | 1562559 | 2021-07-28 | Monroe | Tennessee | 47123 | 6085 | 98 |
1562560 | 1562560 | 2021-07-28 | Montgomery | Tennessee | 47125 | 21622 | 235 |
1562561 | 1562561 | 2021-07-28 | Moore | Tennessee | 47127 | 1064 | 17 |
1562562 | 1562562 | 2021-07-28 | Morgan | Tennessee | 47129 | 2628 | 38 |
1562563 | 1562563 | 2021-07-28 | Obion | Tennessee | 47131 | 4669 | 98 |
1562564 | 1562564 | 2021-07-28 | Overton | Tennessee | 47133 | 3115 | 62 |
1562565 | 1562565 | 2021-07-28 | Perry | Tennessee | 47135 | 1093 | 29 |
1562566 | 1562566 | 2021-07-28 | Pickett | Tennessee | 47137 | 780 | 24 |
1562567 | 1562567 | 2021-07-28 | Polk | Tennessee | 47139 | 2138 | 24 |
1562568 | 1562568 | 2021-07-28 | Putnam | Tennessee | 47141 | 12003 | 183 |
1562569 | 1562569 | 2021-07-28 | Rhea | Tennessee | 47143 | 4463 | 82 |
1562570 | 1562570 | 2021-07-28 | Roane | Tennessee | 47145 | 6514 | 109 |
1562571 | 1562571 | 2021-07-28 | Robertson | Tennessee | 47147 | 10164 | 142 |
1562572 | 1562572 | 2021-07-28 | Rutherford | Tennessee | 47149 | 44636 | 453 |
1562573 | 1562573 | 2021-07-28 | Scott | Tennessee | 47151 | 3239 | 48 |
1562574 | 1562574 | 2021-07-28 | Sequatchie | Tennessee | 47153 | 1817 | 30 |
1562575 | 1562575 | 2021-07-28 | Sevier | Tennessee | 47155 | 13940 | 179 |
1562576 | 1562576 | 2021-07-28 | Shelby | Tennessee | 47157 | 104160 | 1735 |
1562577 | 1562577 | 2021-07-28 | Smith | Tennessee | 47159 | 2857 | 40 |
1562578 | 1562578 | 2021-07-28 | Stewart | Tennessee | 47161 | 1394 | 28 |
1562579 | 1562579 | 2021-07-28 | Sullivan | Tennessee | 47163 | 17700 | 315 |
1562580 | 1562580 | 2021-07-28 | Sumner | Tennessee | 47165 | 25292 | 362 |
1562581 | 1562581 | 2021-07-28 | Tipton | Tennessee | 47167 | 7826 | 104 |
1562582 | 1562582 | 2021-07-28 | Trousdale | Tennessee | 47169 | 2558 | 21 |
1562583 | 1562583 | 2021-07-28 | Unicoi | Tennessee | 47171 | 2092 | 50 |
1562584 | 1562584 | 2021-07-28 | Union | Tennessee | 47173 | 1983 | 34 |
1562585 | 1562585 | 2021-07-28 | Unknown | Tennessee | 8003 | 95 | |
1562586 | 1562586 | 2021-07-28 | Van Buren | Tennessee | 47175 | 879 | 23 |
1562587 | 1562587 | 2021-07-28 | Warren | Tennessee | 47177 | 5659 | 85 |
1562588 | 1562588 | 2021-07-28 | Washington | Tennessee | 47179 | 15146 | 255 |
1562589 | 1562589 | 2021-07-28 | Wayne | Tennessee | 47181 | 3041 | 36 |
1562590 | 1562590 | 2021-07-28 | Weakley | Tennessee | 47183 | 4307 | 69 |
1562591 | 1562591 | 2021-07-28 | White | Tennessee | 47185 | 3812 | 74 |
1562592 | 1562592 | 2021-07-28 | Williamson | Tennessee | 47187 | 29452 | 220 |
1562593 | 1562593 | 2021-07-28 | Wilson | Tennessee | 47189 | 19802 | 256 |
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);