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-08-05 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1588487 | 1588487 | 2021-08-05 | Anderson | Tennessee | 47001 | 9107 | 179 |
1588488 | 1588488 | 2021-08-05 | Bedford | Tennessee | 47003 | 6891 | 135 |
1588489 | 1588489 | 2021-08-05 | Benton | Tennessee | 47005 | 1776 | 41 |
1588490 | 1588490 | 2021-08-05 | Bledsoe | Tennessee | 47007 | 2347 | 12 |
1588491 | 1588491 | 2021-08-05 | Blount | Tennessee | 47009 | 16634 | 204 |
1588492 | 1588492 | 2021-08-05 | Bradley | Tennessee | 47011 | 15896 | 157 |
1588493 | 1588493 | 2021-08-05 | Campbell | Tennessee | 47013 | 4326 | 62 |
1588494 | 1588494 | 2021-08-05 | Cannon | Tennessee | 47015 | 2010 | 32 |
1588495 | 1588495 | 2021-08-05 | Carroll | Tennessee | 47017 | 3838 | 84 |
1588496 | 1588496 | 2021-08-05 | Carter | Tennessee | 47019 | 6990 | 164 |
1588497 | 1588497 | 2021-08-05 | Cheatham | Tennessee | 47021 | 4842 | 56 |
1588498 | 1588498 | 2021-08-05 | Chester | Tennessee | 47023 | 2350 | 51 |
1588499 | 1588499 | 2021-08-05 | Claiborne | Tennessee | 47025 | 3336 | 76 |
1588500 | 1588500 | 2021-08-05 | Clay | Tennessee | 47027 | 1132 | 30 |
1588501 | 1588501 | 2021-08-05 | Cocke | Tennessee | 47029 | 4748 | 102 |
1588502 | 1588502 | 2021-08-05 | Coffee | Tennessee | 47031 | 7165 | 123 |
1588503 | 1588503 | 2021-08-05 | Crockett | Tennessee | 47033 | 2222 | 51 |
1588504 | 1588504 | 2021-08-05 | Cumberland | Tennessee | 47035 | 7258 | 143 |
1588505 | 1588505 | 2021-08-05 | Davidson | Tennessee | 47037 | 103074 | 969 |
1588506 | 1588506 | 2021-08-05 | DeKalb | Tennessee | 47041 | 2939 | 57 |
1588507 | 1588507 | 2021-08-05 | Decatur | Tennessee | 47039 | 1675 | 39 |
1588508 | 1588508 | 2021-08-05 | Dickson | Tennessee | 47043 | 7363 | 116 |
1588509 | 1588509 | 2021-08-05 | Dyer | Tennessee | 47045 | 5732 | 108 |
1588510 | 1588510 | 2021-08-05 | Fayette | Tennessee | 47047 | 5519 | 83 |
1588511 | 1588511 | 2021-08-05 | Fentress | Tennessee | 47049 | 2590 | 49 |
1588512 | 1588512 | 2021-08-05 | Franklin | Tennessee | 47051 | 5515 | 92 |
1588513 | 1588513 | 2021-08-05 | Gibson | Tennessee | 47053 | 7119 | 152 |
1588514 | 1588514 | 2021-08-05 | Giles | Tennessee | 47055 | 4210 | 99 |
1588515 | 1588515 | 2021-08-05 | Grainger | Tennessee | 47057 | 2770 | 51 |
1588516 | 1588516 | 2021-08-05 | Greene | Tennessee | 47059 | 8393 | 160 |
1588517 | 1588517 | 2021-08-05 | Grundy | Tennessee | 47061 | 1897 | 35 |
1588518 | 1588518 | 2021-08-05 | Hamblen | Tennessee | 47063 | 9193 | 176 |
1588519 | 1588519 | 2021-08-05 | Hamilton | Tennessee | 47065 | 48188 | 520 |
1588520 | 1588520 | 2021-08-05 | Hancock | Tennessee | 47067 | 666 | 13 |
1588521 | 1588521 | 2021-08-05 | Hardeman | Tennessee | 47069 | 3709 | 64 |
1588522 | 1588522 | 2021-08-05 | Hardin | Tennessee | 47071 | 3776 | 69 |
1588523 | 1588523 | 2021-08-05 | Hawkins | Tennessee | 47073 | 6624 | 118 |
1588524 | 1588524 | 2021-08-05 | Haywood | Tennessee | 47075 | 2824 | 62 |
1588525 | 1588525 | 2021-08-05 | Henderson | Tennessee | 47077 | 4017 | 79 |
1588526 | 1588526 | 2021-08-05 | Henry | Tennessee | 47079 | 3641 | 76 |
1588527 | 1588527 | 2021-08-05 | Hickman | Tennessee | 47081 | 3014 | 48 |
1588528 | 1588528 | 2021-08-05 | Houston | Tennessee | 47083 | 1181 | 34 |
1588529 | 1588529 | 2021-08-05 | Humphreys | Tennessee | 47085 | 2067 | 32 |
1588530 | 1588530 | 2021-08-05 | Jackson | Tennessee | 47087 | 1397 | 37 |
1588531 | 1588531 | 2021-08-05 | Jefferson | Tennessee | 47089 | 6626 | 128 |
1588532 | 1588532 | 2021-08-05 | Johnson | Tennessee | 47091 | 2514 | 39 |
1588533 | 1588533 | 2021-08-05 | Knox | Tennessee | 47093 | 54141 | 661 |
1588534 | 1588534 | 2021-08-05 | Lake | Tennessee | 47095 | 1736 | 31 |
1588535 | 1588535 | 2021-08-05 | Lauderdale | Tennessee | 47097 | 3389 | 50 |
1588536 | 1588536 | 2021-08-05 | Lawrence | Tennessee | 47099 | 6380 | 98 |
1588537 | 1588537 | 2021-08-05 | Lewis | Tennessee | 47101 | 1725 | 26 |
1588538 | 1588538 | 2021-08-05 | Lincoln | Tennessee | 47103 | 4626 | 67 |
1588539 | 1588539 | 2021-08-05 | Loudon | Tennessee | 47105 | 6478 | 71 |
1588540 | 1588540 | 2021-08-05 | Macon | Tennessee | 47111 | 3777 | 78 |
1588541 | 1588541 | 2021-08-05 | Madison | Tennessee | 47113 | 12252 | 248 |
1588542 | 1588542 | 2021-08-05 | Marion | Tennessee | 47115 | 3474 | 50 |
1588543 | 1588543 | 2021-08-05 | Marshall | Tennessee | 47117 | 4553 | 65 |
1588544 | 1588544 | 2021-08-05 | Maury | Tennessee | 47119 | 14259 | 180 |
1588545 | 1588545 | 2021-08-05 | McMinn | Tennessee | 47107 | 6990 | 106 |
1588546 | 1588546 | 2021-08-05 | McNairy | Tennessee | 47109 | 3045 | 57 |
1588547 | 1588547 | 2021-08-05 | Meigs | Tennessee | 47121 | 1480 | 24 |
1588548 | 1588548 | 2021-08-05 | Monroe | Tennessee | 47123 | 6199 | 98 |
1588549 | 1588549 | 2021-08-05 | Montgomery | Tennessee | 47125 | 22204 | 236 |
1588550 | 1588550 | 2021-08-05 | Moore | Tennessee | 47127 | 1086 | 17 |
1588551 | 1588551 | 2021-08-05 | Morgan | Tennessee | 47129 | 2690 | 39 |
1588552 | 1588552 | 2021-08-05 | Obion | Tennessee | 47131 | 4739 | 98 |
1588553 | 1588553 | 2021-08-05 | Overton | Tennessee | 47133 | 3143 | 62 |
1588554 | 1588554 | 2021-08-05 | Perry | Tennessee | 47135 | 1111 | 29 |
1588555 | 1588555 | 2021-08-05 | Pickett | Tennessee | 47137 | 788 | 24 |
1588556 | 1588556 | 2021-08-05 | Polk | Tennessee | 47139 | 2193 | 24 |
1588557 | 1588557 | 2021-08-05 | Putnam | Tennessee | 47141 | 12160 | 183 |
1588558 | 1588558 | 2021-08-05 | Rhea | Tennessee | 47143 | 4552 | 83 |
1588559 | 1588559 | 2021-08-05 | Roane | Tennessee | 47145 | 6698 | 110 |
1588560 | 1588560 | 2021-08-05 | Robertson | Tennessee | 47147 | 10329 | 144 |
1588561 | 1588561 | 2021-08-05 | Rutherford | Tennessee | 47149 | 45554 | 452 |
1588562 | 1588562 | 2021-08-05 | Scott | Tennessee | 47151 | 3290 | 48 |
1588563 | 1588563 | 2021-08-05 | Sequatchie | Tennessee | 47153 | 1875 | 30 |
1588564 | 1588564 | 2021-08-05 | Sevier | Tennessee | 47155 | 14341 | 181 |
1588565 | 1588565 | 2021-08-05 | Shelby | Tennessee | 47157 | 107909 | 1744 |
1588566 | 1588566 | 2021-08-05 | Smith | Tennessee | 47159 | 2903 | 40 |
1588567 | 1588567 | 2021-08-05 | Stewart | Tennessee | 47161 | 1422 | 28 |
1588568 | 1588568 | 2021-08-05 | Sullivan | Tennessee | 47163 | 18075 | 318 |
1588569 | 1588569 | 2021-08-05 | Sumner | Tennessee | 47165 | 25814 | 364 |
1588570 | 1588570 | 2021-08-05 | Tipton | Tennessee | 47167 | 8079 | 106 |
1588571 | 1588571 | 2021-08-05 | Trousdale | Tennessee | 47169 | 2580 | 22 |
1588572 | 1588572 | 2021-08-05 | Unicoi | Tennessee | 47171 | 2141 | 50 |
1588573 | 1588573 | 2021-08-05 | Union | Tennessee | 47173 | 2002 | 34 |
1588574 | 1588574 | 2021-08-05 | Unknown | Tennessee | 8478 | 95 | |
1588575 | 1588575 | 2021-08-05 | Van Buren | Tennessee | 47175 | 888 | 23 |
1588576 | 1588576 | 2021-08-05 | Warren | Tennessee | 47177 | 5720 | 85 |
1588577 | 1588577 | 2021-08-05 | Washington | Tennessee | 47179 | 15447 | 256 |
1588578 | 1588578 | 2021-08-05 | Wayne | Tennessee | 47181 | 3064 | 36 |
1588579 | 1588579 | 2021-08-05 | Weakley | Tennessee | 47183 | 4375 | 69 |
1588580 | 1588580 | 2021-08-05 | White | Tennessee | 47185 | 3860 | 75 |
1588581 | 1588581 | 2021-08-05 | Williamson | Tennessee | 47187 | 30217 | 221 |
1588582 | 1588582 | 2021-08-05 | Wilson | Tennessee | 47189 | 20245 | 260 |
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);