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-09-13 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
530470 | 530470 | 2020-09-13 | Anderson | Tennessee | 47001 | 1015 | 10 |
530471 | 530471 | 2020-09-13 | Bedford | Tennessee | 47003 | 1231 | 14 |
530472 | 530472 | 2020-09-13 | Benton | Tennessee | 47005 | 303 | 9 |
530473 | 530473 | 2020-09-13 | Bledsoe | Tennessee | 47007 | 826 | 4 |
530474 | 530474 | 2020-09-13 | Blount | Tennessee | 47009 | 2314 | 21 |
530475 | 530475 | 2020-09-13 | Bradley | Tennessee | 47011 | 2710 | 16 |
530476 | 530476 | 2020-09-13 | Campbell | Tennessee | 47013 | 391 | 3 |
530477 | 530477 | 2020-09-13 | Cannon | Tennessee | 47015 | 241 | 0 |
530478 | 530478 | 2020-09-13 | Carroll | Tennessee | 47017 | 739 | 15 |
530479 | 530479 | 2020-09-13 | Carter | Tennessee | 47019 | 1053 | 26 |
530480 | 530480 | 2020-09-13 | Cheatham | Tennessee | 47021 | 751 | 10 |
530481 | 530481 | 2020-09-13 | Chester | Tennessee | 47023 | 512 | 8 |
530482 | 530482 | 2020-09-13 | Claiborne | Tennessee | 47025 | 399 | 4 |
530483 | 530483 | 2020-09-13 | Clay | Tennessee | 47027 | 142 | 4 |
530484 | 530484 | 2020-09-13 | Cocke | Tennessee | 47029 | 709 | 9 |
530485 | 530485 | 2020-09-13 | Coffee | Tennessee | 47031 | 925 | 9 |
530486 | 530486 | 2020-09-13 | Crockett | Tennessee | 47033 | 460 | 19 |
530487 | 530487 | 2020-09-13 | Cumberland | Tennessee | 47035 | 1057 | 10 |
530488 | 530488 | 2020-09-13 | Davidson | Tennessee | 47037 | 27189 | 279 |
530489 | 530489 | 2020-09-13 | DeKalb | Tennessee | 47041 | 522 | 9 |
530490 | 530490 | 2020-09-13 | Decatur | Tennessee | 47039 | 399 | 5 |
530491 | 530491 | 2020-09-13 | Dickson | Tennessee | 47043 | 1111 | 12 |
530492 | 530492 | 2020-09-13 | Dyer | Tennessee | 47045 | 1129 | 12 |
530493 | 530493 | 2020-09-13 | Fayette | Tennessee | 47047 | 1040 | 14 |
530494 | 530494 | 2020-09-13 | Fentress | Tennessee | 47049 | 339 | 3 |
530495 | 530495 | 2020-09-13 | Franklin | Tennessee | 47051 | 746 | 7 |
530496 | 530496 | 2020-09-13 | Gibson | Tennessee | 47053 | 1338 | 19 |
530497 | 530497 | 2020-09-13 | Giles | Tennessee | 47055 | 516 | 16 |
530498 | 530498 | 2020-09-13 | Grainger | Tennessee | 47057 | 311 | 1 |
530499 | 530499 | 2020-09-13 | Greene | Tennessee | 47059 | 979 | 28 |
530500 | 530500 | 2020-09-13 | Grundy | Tennessee | 47061 | 182 | 4 |
530501 | 530501 | 2020-09-13 | Hamblen | Tennessee | 47063 | 1760 | 22 |
530502 | 530502 | 2020-09-13 | Hamilton | Tennessee | 47065 | 8830 | 85 |
530503 | 530503 | 2020-09-13 | Hancock | Tennessee | 47067 | 103 | 2 |
530504 | 530504 | 2020-09-13 | Hardeman | Tennessee | 47069 | 1450 | 25 |
530505 | 530505 | 2020-09-13 | Hardin | Tennessee | 47071 | 877 | 14 |
530506 | 530506 | 2020-09-13 | Hawkins | Tennessee | 47073 | 713 | 14 |
530507 | 530507 | 2020-09-13 | Haywood | Tennessee | 47075 | 848 | 15 |
530508 | 530508 | 2020-09-13 | Henderson | Tennessee | 47077 | 1035 | 18 |
530509 | 530509 | 2020-09-13 | Henry | Tennessee | 47079 | 546 | 8 |
530510 | 530510 | 2020-09-13 | Hickman | Tennessee | 47081 | 465 | 4 |
530511 | 530511 | 2020-09-13 | Houston | Tennessee | 47083 | 132 | 0 |
530512 | 530512 | 2020-09-13 | Humphreys | Tennessee | 47085 | 200 | 3 |
530513 | 530513 | 2020-09-13 | Jackson | Tennessee | 47087 | 279 | 2 |
530514 | 530514 | 2020-09-13 | Jefferson | Tennessee | 47089 | 1004 | 13 |
530515 | 530515 | 2020-09-13 | Johnson | Tennessee | 47091 | 539 | 2 |
530516 | 530516 | 2020-09-13 | Knox | Tennessee | 47093 | 8612 | 67 |
530517 | 530517 | 2020-09-13 | Lake | Tennessee | 47095 | 857 | 2 |
530518 | 530518 | 2020-09-13 | Lauderdale | Tennessee | 47097 | 867 | 14 |
530519 | 530519 | 2020-09-13 | Lawrence | Tennessee | 47099 | 857 | 11 |
530520 | 530520 | 2020-09-13 | Lewis | Tennessee | 47101 | 157 | 1 |
530521 | 530521 | 2020-09-13 | Lincoln | Tennessee | 47103 | 517 | 1 |
530522 | 530522 | 2020-09-13 | Loudon | Tennessee | 47105 | 1032 | 4 |
530523 | 530523 | 2020-09-13 | Macon | Tennessee | 47111 | 974 | 19 |
530524 | 530524 | 2020-09-13 | Madison | Tennessee | 47113 | 2301 | 54 |
530525 | 530525 | 2020-09-13 | Marion | Tennessee | 47115 | 434 | 7 |
530526 | 530526 | 2020-09-13 | Marshall | Tennessee | 47117 | 639 | 4 |
530527 | 530527 | 2020-09-13 | Maury | Tennessee | 47119 | 2027 | 20 |
530528 | 530528 | 2020-09-13 | McMinn | Tennessee | 47107 | 945 | 24 |
530529 | 530529 | 2020-09-13 | McNairy | Tennessee | 47109 | 702 | 15 |
530530 | 530530 | 2020-09-13 | Meigs | Tennessee | 47121 | 202 | 3 |
530531 | 530531 | 2020-09-13 | Monroe | Tennessee | 47123 | 944 | 17 |
530532 | 530532 | 2020-09-13 | Montgomery | Tennessee | 47125 | 2790 | 39 |
530533 | 530533 | 2020-09-13 | Moore | Tennessee | 47127 | 126 | 1 |
530534 | 530534 | 2020-09-13 | Morgan | Tennessee | 47129 | 281 | 2 |
530535 | 530535 | 2020-09-13 | Obion | Tennessee | 47131 | 974 | 8 |
530536 | 530536 | 2020-09-13 | Overton | Tennessee | 47133 | 593 | 3 |
530537 | 530537 | 2020-09-13 | Perry | Tennessee | 47135 | 132 | 0 |
530538 | 530538 | 2020-09-13 | Pickett | Tennessee | 47137 | 88 | 1 |
530539 | 530539 | 2020-09-13 | Polk | Tennessee | 47139 | 366 | 11 |
530540 | 530540 | 2020-09-13 | Putnam | Tennessee | 47141 | 2695 | 36 |
530541 | 530541 | 2020-09-13 | Rhea | Tennessee | 47143 | 723 | 8 |
530542 | 530542 | 2020-09-13 | Roane | Tennessee | 47145 | 747 | 4 |
530543 | 530543 | 2020-09-13 | Robertson | Tennessee | 47147 | 2070 | 31 |
530544 | 530544 | 2020-09-13 | Rutherford | Tennessee | 47149 | 8530 | 84 |
530545 | 530545 | 2020-09-13 | Scott | Tennessee | 47151 | 182 | 2 |
530546 | 530546 | 2020-09-13 | Sequatchie | Tennessee | 47153 | 195 | 2 |
530547 | 530547 | 2020-09-13 | Sevier | Tennessee | 47155 | 2420 | 13 |
530548 | 530548 | 2020-09-13 | Shelby | Tennessee | 47157 | 28890 | 427 |
530549 | 530549 | 2020-09-13 | Smith | Tennessee | 47159 | 616 | 10 |
530550 | 530550 | 2020-09-13 | Stewart | Tennessee | 47161 | 121 | 2 |
530551 | 530551 | 2020-09-13 | Sullivan | Tennessee | 47163 | 1939 | 31 |
530552 | 530552 | 2020-09-13 | Sumner | Tennessee | 47165 | 4469 | 91 |
530553 | 530553 | 2020-09-13 | Tipton | Tennessee | 47167 | 1614 | 16 |
530554 | 530554 | 2020-09-13 | Trousdale | Tennessee | 47169 | 1638 | 7 |
530555 | 530555 | 2020-09-13 | Unicoi | Tennessee | 47171 | 252 | 1 |
530556 | 530556 | 2020-09-13 | Union | Tennessee | 47173 | 272 | 1 |
530557 | 530557 | 2020-09-13 | Unknown | Tennessee | 0 | 4 | |
530558 | 530558 | 2020-09-13 | Van Buren | Tennessee | 47175 | 129 | 0 |
530559 | 530559 | 2020-09-13 | Warren | Tennessee | 47177 | 953 | 8 |
530560 | 530560 | 2020-09-13 | Washington | Tennessee | 47179 | 1964 | 24 |
530561 | 530561 | 2020-09-13 | Wayne | Tennessee | 47181 | 1473 | 4 |
530562 | 530562 | 2020-09-13 | Weakley | Tennessee | 47183 | 1010 | 15 |
530563 | 530563 | 2020-09-13 | White | Tennessee | 47185 | 670 | 8 |
530564 | 530564 | 2020-09-13 | Williamson | Tennessee | 47187 | 4788 | 35 |
530565 | 530565 | 2020-09-13 | Wilson | Tennessee | 47189 | 3173 | 36 |
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);