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-05-24 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1351498 | 1351498 | 2021-05-24 | Anderson | Tennessee | 47001 | 8822 | 172 |
1351499 | 1351499 | 2021-05-24 | Bedford | Tennessee | 47003 | 6545 | 130 |
1351500 | 1351500 | 2021-05-24 | Benton | Tennessee | 47005 | 1682 | 40 |
1351501 | 1351501 | 2021-05-24 | Bledsoe | Tennessee | 47007 | 2178 | 11 |
1351502 | 1351502 | 2021-05-24 | Blount | Tennessee | 47009 | 15609 | 196 |
1351503 | 1351503 | 2021-05-24 | Bradley | Tennessee | 47011 | 15176 | 152 |
1351504 | 1351504 | 2021-05-24 | Campbell | Tennessee | 47013 | 4193 | 63 |
1351505 | 1351505 | 2021-05-24 | Cannon | Tennessee | 47015 | 1933 | 31 |
1351506 | 1351506 | 2021-05-24 | Carroll | Tennessee | 47017 | 3645 | 84 |
1351507 | 1351507 | 2021-05-24 | Carter | Tennessee | 47019 | 6691 | 158 |
1351508 | 1351508 | 2021-05-24 | Cheatham | Tennessee | 47021 | 4600 | 56 |
1351509 | 1351509 | 2021-05-24 | Chester | Tennessee | 47023 | 2169 | 51 |
1351510 | 1351510 | 2021-05-24 | Claiborne | Tennessee | 47025 | 3192 | 74 |
1351511 | 1351511 | 2021-05-24 | Clay | Tennessee | 47027 | 1104 | 30 |
1351512 | 1351512 | 2021-05-24 | Cocke | Tennessee | 47029 | 4534 | 100 |
1351513 | 1351513 | 2021-05-24 | Coffee | Tennessee | 47031 | 6934 | 124 |
1351514 | 1351514 | 2021-05-24 | Crockett | Tennessee | 47033 | 2041 | 49 |
1351515 | 1351515 | 2021-05-24 | Cumberland | Tennessee | 47035 | 6811 | 133 |
1351516 | 1351516 | 2021-05-24 | Davidson | Tennessee | 47037 | 99166 | 947 |
1351517 | 1351517 | 2021-05-24 | DeKalb | Tennessee | 47041 | 2816 | 54 |
1351518 | 1351518 | 2021-05-24 | Decatur | Tennessee | 47039 | 1601 | 39 |
1351519 | 1351519 | 2021-05-24 | Dickson | Tennessee | 47043 | 6884 | 114 |
1351520 | 1351520 | 2021-05-24 | Dyer | Tennessee | 47045 | 5452 | 106 |
1351521 | 1351521 | 2021-05-24 | Fayette | Tennessee | 47047 | 5144 | 79 |
1351522 | 1351522 | 2021-05-24 | Fentress | Tennessee | 47049 | 2440 | 47 |
1351523 | 1351523 | 2021-05-24 | Franklin | Tennessee | 47051 | 5170 | 90 |
1351524 | 1351524 | 2021-05-24 | Gibson | Tennessee | 47053 | 6595 | 147 |
1351525 | 1351525 | 2021-05-24 | Giles | Tennessee | 47055 | 4020 | 101 |
1351526 | 1351526 | 2021-05-24 | Grainger | Tennessee | 47057 | 2651 | 50 |
1351527 | 1351527 | 2021-05-24 | Greene | Tennessee | 47059 | 7954 | 157 |
1351528 | 1351528 | 2021-05-24 | Grundy | Tennessee | 47061 | 1794 | 35 |
1351529 | 1351529 | 2021-05-24 | Hamblen | Tennessee | 47063 | 8636 | 174 |
1351530 | 1351530 | 2021-05-24 | Hamilton | Tennessee | 47065 | 45004 | 499 |
1351531 | 1351531 | 2021-05-24 | Hancock | Tennessee | 47067 | 601 | 12 |
1351532 | 1351532 | 2021-05-24 | Hardeman | Tennessee | 47069 | 3550 | 64 |
1351533 | 1351533 | 2021-05-24 | Hardin | Tennessee | 47071 | 3589 | 68 |
1351534 | 1351534 | 2021-05-24 | Hawkins | Tennessee | 47073 | 6232 | 110 |
1351535 | 1351535 | 2021-05-24 | Haywood | Tennessee | 47075 | 2716 | 62 |
1351536 | 1351536 | 2021-05-24 | Henderson | Tennessee | 47077 | 3819 | 76 |
1351537 | 1351537 | 2021-05-24 | Henry | Tennessee | 47079 | 3226 | 76 |
1351538 | 1351538 | 2021-05-24 | Hickman | Tennessee | 47081 | 2860 | 46 |
1351539 | 1351539 | 2021-05-24 | Houston | Tennessee | 47083 | 1102 | 33 |
1351540 | 1351540 | 2021-05-24 | Humphreys | Tennessee | 47085 | 1845 | 28 |
1351541 | 1351541 | 2021-05-24 | Jackson | Tennessee | 47087 | 1327 | 36 |
1351542 | 1351542 | 2021-05-24 | Jefferson | Tennessee | 47089 | 6275 | 125 |
1351543 | 1351543 | 2021-05-24 | Johnson | Tennessee | 47091 | 2431 | 39 |
1351544 | 1351544 | 2021-05-24 | Knox | Tennessee | 47093 | 52016 | 639 |
1351545 | 1351545 | 2021-05-24 | Lake | Tennessee | 47095 | 1710 | 26 |
1351546 | 1351546 | 2021-05-24 | Lauderdale | Tennessee | 47097 | 3225 | 46 |
1351547 | 1351547 | 2021-05-24 | Lawrence | Tennessee | 47099 | 6012 | 92 |
1351548 | 1351548 | 2021-05-24 | Lewis | Tennessee | 47101 | 1589 | 26 |
1351549 | 1351549 | 2021-05-24 | Lincoln | Tennessee | 47103 | 4372 | 63 |
1351550 | 1351550 | 2021-05-24 | Loudon | Tennessee | 47105 | 6214 | 70 |
1351551 | 1351551 | 2021-05-24 | Macon | Tennessee | 47111 | 3639 | 78 |
1351552 | 1351552 | 2021-05-24 | Madison | Tennessee | 47113 | 11332 | 241 |
1351553 | 1351553 | 2021-05-24 | Marion | Tennessee | 47115 | 3145 | 47 |
1351554 | 1351554 | 2021-05-24 | Marshall | Tennessee | 47117 | 4211 | 58 |
1351555 | 1351555 | 2021-05-24 | Maury | Tennessee | 47119 | 13593 | 173 |
1351556 | 1351556 | 2021-05-24 | McMinn | Tennessee | 47107 | 6572 | 99 |
1351557 | 1351557 | 2021-05-24 | McNairy | Tennessee | 47109 | 2856 | 54 |
1351558 | 1351558 | 2021-05-24 | Meigs | Tennessee | 47121 | 1400 | 25 |
1351559 | 1351559 | 2021-05-24 | Monroe | Tennessee | 47123 | 5911 | 96 |
1351560 | 1351560 | 2021-05-24 | Montgomery | Tennessee | 47125 | 20646 | 228 |
1351561 | 1351561 | 2021-05-24 | Moore | Tennessee | 47127 | 1019 | 17 |
1351562 | 1351562 | 2021-05-24 | Morgan | Tennessee | 47129 | 2524 | 39 |
1351563 | 1351563 | 2021-05-24 | Obion | Tennessee | 47131 | 4574 | 96 |
1351564 | 1351564 | 2021-05-24 | Overton | Tennessee | 47133 | 3030 | 61 |
1351565 | 1351565 | 2021-05-24 | Perry | Tennessee | 47135 | 1073 | 28 |
1351566 | 1351566 | 2021-05-24 | Pickett | Tennessee | 47137 | 764 | 24 |
1351567 | 1351567 | 2021-05-24 | Polk | Tennessee | 47139 | 2102 | 25 |
1351568 | 1351568 | 2021-05-24 | Putnam | Tennessee | 47141 | 11463 | 175 |
1351569 | 1351569 | 2021-05-24 | Rhea | Tennessee | 47143 | 4374 | 75 |
1351570 | 1351570 | 2021-05-24 | Roane | Tennessee | 47145 | 6343 | 105 |
1351571 | 1351571 | 2021-05-24 | Robertson | Tennessee | 47147 | 9830 | 132 |
1351572 | 1351572 | 2021-05-24 | Rutherford | Tennessee | 47149 | 43401 | 440 |
1351573 | 1351573 | 2021-05-24 | Scott | Tennessee | 47151 | 3181 | 45 |
1351574 | 1351574 | 2021-05-24 | Sequatchie | Tennessee | 47153 | 1731 | 29 |
1351575 | 1351575 | 2021-05-24 | Sevier | Tennessee | 47155 | 13480 | 176 |
1351576 | 1351576 | 2021-05-24 | Shelby | Tennessee | 47157 | 98298 | 1668 |
1351577 | 1351577 | 2021-05-24 | Smith | Tennessee | 47159 | 2787 | 39 |
1351578 | 1351578 | 2021-05-24 | Stewart | Tennessee | 47161 | 1353 | 28 |
1351579 | 1351579 | 2021-05-24 | Sullivan | Tennessee | 47163 | 17111 | 302 |
1351580 | 1351580 | 2021-05-24 | Sumner | Tennessee | 47165 | 24257 | 349 |
1351581 | 1351581 | 2021-05-24 | Tipton | Tennessee | 47167 | 7441 | 104 |
1351582 | 1351582 | 2021-05-24 | Trousdale | Tennessee | 47169 | 2509 | 22 |
1351583 | 1351583 | 2021-05-24 | Unicoi | Tennessee | 47171 | 2051 | 49 |
1351584 | 1351584 | 2021-05-24 | Union | Tennessee | 47173 | 1935 | 34 |
1351585 | 1351585 | 2021-05-24 | Unknown | Tennessee | 9399 | 122 | |
1351586 | 1351586 | 2021-05-24 | Van Buren | Tennessee | 47175 | 858 | 23 |
1351587 | 1351587 | 2021-05-24 | Warren | Tennessee | 47177 | 5550 | 82 |
1351588 | 1351588 | 2021-05-24 | Washington | Tennessee | 47179 | 14764 | 248 |
1351589 | 1351589 | 2021-05-24 | Wayne | Tennessee | 47181 | 2975 | 34 |
1351590 | 1351590 | 2021-05-24 | Weakley | Tennessee | 47183 | 4187 | 67 |
1351591 | 1351591 | 2021-05-24 | White | Tennessee | 47185 | 3705 | 71 |
1351592 | 1351592 | 2021-05-24 | Williamson | Tennessee | 47187 | 28225 | 217 |
1351593 | 1351593 | 2021-05-24 | Wilson | Tennessee | 47189 | 18982 | 238 |
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);