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-10-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 |
---|---|---|---|---|---|---|---|
598494 | 598494 | 2020-10-04 | Anderson | Tennessee | 47001 | 1278 | 13 |
598495 | 598495 | 2020-10-04 | Bedford | Tennessee | 47003 | 1402 | 18 |
598496 | 598496 | 2020-10-04 | Benton | Tennessee | 47005 | 343 | 8 |
598497 | 598497 | 2020-10-04 | Bledsoe | Tennessee | 47007 | 871 | 4 |
598498 | 598498 | 2020-10-04 | Blount | Tennessee | 47009 | 2678 | 27 |
598499 | 598499 | 2020-10-04 | Bradley | Tennessee | 47011 | 3060 | 19 |
598500 | 598500 | 2020-10-04 | Campbell | Tennessee | 47013 | 509 | 4 |
598501 | 598501 | 2020-10-04 | Cannon | Tennessee | 47015 | 317 | 1 |
598502 | 598502 | 2020-10-04 | Carroll | Tennessee | 47017 | 974 | 20 |
598503 | 598503 | 2020-10-04 | Carter | Tennessee | 47019 | 1217 | 29 |
598504 | 598504 | 2020-10-04 | Cheatham | Tennessee | 47021 | 841 | 10 |
598505 | 598505 | 2020-10-04 | Chester | Tennessee | 47023 | 661 | 13 |
598506 | 598506 | 2020-10-04 | Claiborne | Tennessee | 47025 | 453 | 5 |
598507 | 598507 | 2020-10-04 | Clay | Tennessee | 47027 | 259 | 6 |
598508 | 598508 | 2020-10-04 | Cocke | Tennessee | 47029 | 781 | 11 |
598509 | 598509 | 2020-10-04 | Coffee | Tennessee | 47031 | 1372 | 15 |
598510 | 598510 | 2020-10-04 | Crockett | Tennessee | 47033 | 581 | 20 |
598511 | 598511 | 2020-10-04 | Cumberland | Tennessee | 47035 | 1278 | 20 |
598512 | 598512 | 2020-10-04 | Davidson | Tennessee | 47037 | 29225 | 316 |
598513 | 598513 | 2020-10-04 | DeKalb | Tennessee | 47041 | 595 | 16 |
598514 | 598514 | 2020-10-04 | Decatur | Tennessee | 47039 | 560 | 9 |
598515 | 598515 | 2020-10-04 | Dickson | Tennessee | 47043 | 1329 | 17 |
598516 | 598516 | 2020-10-04 | Dyer | Tennessee | 47045 | 1520 | 18 |
598517 | 598517 | 2020-10-04 | Fayette | Tennessee | 47047 | 1282 | 21 |
598518 | 598518 | 2020-10-04 | Fentress | Tennessee | 47049 | 653 | 4 |
598519 | 598519 | 2020-10-04 | Franklin | Tennessee | 47051 | 1038 | 10 |
598520 | 598520 | 2020-10-04 | Gibson | Tennessee | 47053 | 1821 | 26 |
598521 | 598521 | 2020-10-04 | Giles | Tennessee | 47055 | 687 | 19 |
598522 | 598522 | 2020-10-04 | Grainger | Tennessee | 47057 | 430 | 3 |
598523 | 598523 | 2020-10-04 | Greene | Tennessee | 47059 | 1214 | 48 |
598524 | 598524 | 2020-10-04 | Grundy | Tennessee | 47061 | 381 | 7 |
598525 | 598525 | 2020-10-04 | Hamblen | Tennessee | 47063 | 2032 | 31 |
598526 | 598526 | 2020-10-04 | Hamilton | Tennessee | 47065 | 10078 | 98 |
598527 | 598527 | 2020-10-04 | Hancock | Tennessee | 47067 | 111 | 3 |
598528 | 598528 | 2020-10-04 | Hardeman | Tennessee | 47069 | 1623 | 28 |
598529 | 598529 | 2020-10-04 | Hardin | Tennessee | 47071 | 1112 | 16 |
598530 | 598530 | 2020-10-04 | Hawkins | Tennessee | 47073 | 870 | 22 |
598531 | 598531 | 2020-10-04 | Haywood | Tennessee | 47075 | 1058 | 23 |
598532 | 598532 | 2020-10-04 | Henderson | Tennessee | 47077 | 1234 | 24 |
598533 | 598533 | 2020-10-04 | Henry | Tennessee | 47079 | 657 | 10 |
598534 | 598534 | 2020-10-04 | Hickman | Tennessee | 47081 | 641 | 11 |
598535 | 598535 | 2020-10-04 | Houston | Tennessee | 47083 | 290 | 9 |
598536 | 598536 | 2020-10-04 | Humphreys | Tennessee | 47085 | 293 | 3 |
598537 | 598537 | 2020-10-04 | Jackson | Tennessee | 47087 | 359 | 5 |
598538 | 598538 | 2020-10-04 | Jefferson | Tennessee | 47089 | 1216 | 14 |
598539 | 598539 | 2020-10-04 | Johnson | Tennessee | 47091 | 771 | 3 |
598540 | 598540 | 2020-10-04 | Knox | Tennessee | 47093 | 10610 | 85 |
598541 | 598541 | 2020-10-04 | Lake | Tennessee | 47095 | 935 | 2 |
598542 | 598542 | 2020-10-04 | Lauderdale | Tennessee | 47097 | 1046 | 16 |
598543 | 598543 | 2020-10-04 | Lawrence | Tennessee | 47099 | 1140 | 14 |
598544 | 598544 | 2020-10-04 | Lewis | Tennessee | 47101 | 227 | 1 |
598545 | 598545 | 2020-10-04 | Lincoln | Tennessee | 47103 | 659 | 1 |
598546 | 598546 | 2020-10-04 | Loudon | Tennessee | 47105 | 1277 | 8 |
598547 | 598547 | 2020-10-04 | Macon | Tennessee | 47111 | 1107 | 22 |
598548 | 598548 | 2020-10-04 | Madison | Tennessee | 47113 | 3154 | 71 |
598549 | 598549 | 2020-10-04 | Marion | Tennessee | 47115 | 576 | 9 |
598550 | 598550 | 2020-10-04 | Marshall | Tennessee | 47117 | 824 | 5 |
598551 | 598551 | 2020-10-04 | Maury | Tennessee | 47119 | 2528 | 29 |
598552 | 598552 | 2020-10-04 | McMinn | Tennessee | 47107 | 1200 | 28 |
598553 | 598553 | 2020-10-04 | McNairy | Tennessee | 47109 | 960 | 19 |
598554 | 598554 | 2020-10-04 | Meigs | Tennessee | 47121 | 239 | 3 |
598555 | 598555 | 2020-10-04 | Monroe | Tennessee | 47123 | 1123 | 20 |
598556 | 598556 | 2020-10-04 | Montgomery | Tennessee | 47125 | 3235 | 46 |
598557 | 598557 | 2020-10-04 | Moore | Tennessee | 47127 | 193 | 1 |
598558 | 598558 | 2020-10-04 | Morgan | Tennessee | 47129 | 333 | 4 |
598559 | 598559 | 2020-10-04 | Obion | Tennessee | 47131 | 1315 | 15 |
598560 | 598560 | 2020-10-04 | Overton | Tennessee | 47133 | 835 | 7 |
598561 | 598561 | 2020-10-04 | Perry | Tennessee | 47135 | 157 | 0 |
598562 | 598562 | 2020-10-04 | Pickett | Tennessee | 47137 | 145 | 2 |
598563 | 598563 | 2020-10-04 | Polk | Tennessee | 47139 | 423 | 12 |
598564 | 598564 | 2020-10-04 | Putnam | Tennessee | 47141 | 3521 | 48 |
598565 | 598565 | 2020-10-04 | Rhea | Tennessee | 47143 | 896 | 15 |
598566 | 598566 | 2020-10-04 | Roane | Tennessee | 47145 | 954 | 6 |
598567 | 598567 | 2020-10-04 | Robertson | Tennessee | 47147 | 2285 | 38 |
598568 | 598568 | 2020-10-04 | Rutherford | Tennessee | 47149 | 9709 | 98 |
598569 | 598569 | 2020-10-04 | Scott | Tennessee | 47151 | 240 | 2 |
598570 | 598570 | 2020-10-04 | Sequatchie | Tennessee | 47153 | 252 | 3 |
598571 | 598571 | 2020-10-04 | Sevier | Tennessee | 47155 | 2747 | 17 |
598572 | 598572 | 2020-10-04 | Shelby | Tennessee | 47157 | 31953 | 487 |
598573 | 598573 | 2020-10-04 | Smith | Tennessee | 47159 | 797 | 11 |
598574 | 598574 | 2020-10-04 | Stewart | Tennessee | 47161 | 245 | 3 |
598575 | 598575 | 2020-10-04 | Sullivan | Tennessee | 47163 | 2367 | 35 |
598576 | 598576 | 2020-10-04 | Sumner | Tennessee | 47165 | 5044 | 103 |
598577 | 598577 | 2020-10-04 | Tipton | Tennessee | 47167 | 1897 | 22 |
598578 | 598578 | 2020-10-04 | Trousdale | Tennessee | 47169 | 1687 | 7 |
598579 | 598579 | 2020-10-04 | Unicoi | Tennessee | 47171 | 295 | 1 |
598580 | 598580 | 2020-10-04 | Union | Tennessee | 47173 | 412 | 2 |
598581 | 598581 | 2020-10-04 | Unknown | Tennessee | 0 | 3 | |
598582 | 598582 | 2020-10-04 | Van Buren | Tennessee | 47175 | 170 | 0 |
598583 | 598583 | 2020-10-04 | Warren | Tennessee | 47177 | 1120 | 8 |
598584 | 598584 | 2020-10-04 | Washington | Tennessee | 47179 | 2488 | 38 |
598585 | 598585 | 2020-10-04 | Wayne | Tennessee | 47181 | 1519 | 6 |
598586 | 598586 | 2020-10-04 | Weakley | Tennessee | 47183 | 1269 | 21 |
598587 | 598587 | 2020-10-04 | White | Tennessee | 47185 | 910 | 10 |
598588 | 598588 | 2020-10-04 | Williamson | Tennessee | 47187 | 5572 | 40 |
598589 | 598589 | 2020-10-04 | Wilson | Tennessee | 47189 | 3717 | 49 |
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);