ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where date = "2020-09-30" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
585529 | 585529 | 2020-09-30 | Anderson | Tennessee | 47001 | 1224 | 13 |
585530 | 585530 | 2020-09-30 | Bedford | Tennessee | 47003 | 1380 | 17 |
585531 | 585531 | 2020-09-30 | Benton | Tennessee | 47005 | 342 | 8 |
585532 | 585532 | 2020-09-30 | Bledsoe | Tennessee | 47007 | 864 | 4 |
585533 | 585533 | 2020-09-30 | Blount | Tennessee | 47009 | 2589 | 24 |
585534 | 585534 | 2020-09-30 | Bradley | Tennessee | 47011 | 2988 | 17 |
585535 | 585535 | 2020-09-30 | Campbell | Tennessee | 47013 | 467 | 4 |
585536 | 585536 | 2020-09-30 | Cannon | Tennessee | 47015 | 304 | 1 |
585537 | 585537 | 2020-09-30 | Carroll | Tennessee | 47017 | 917 | 20 |
585538 | 585538 | 2020-09-30 | Carter | Tennessee | 47019 | 1199 | 28 |
585539 | 585539 | 2020-09-30 | Cheatham | Tennessee | 47021 | 828 | 9 |
585540 | 585540 | 2020-09-30 | Chester | Tennessee | 47023 | 653 | 11 |
585541 | 585541 | 2020-09-30 | Claiborne | Tennessee | 47025 | 449 | 5 |
585542 | 585542 | 2020-09-30 | Clay | Tennessee | 47027 | 243 | 5 |
585543 | 585543 | 2020-09-30 | Cocke | Tennessee | 47029 | 759 | 10 |
585544 | 585544 | 2020-09-30 | Coffee | Tennessee | 47031 | 1302 | 14 |
585545 | 585545 | 2020-09-30 | Crockett | Tennessee | 47033 | 558 | 19 |
585546 | 585546 | 2020-09-30 | Cumberland | Tennessee | 47035 | 1223 | 19 |
585547 | 585547 | 2020-09-30 | Davidson | Tennessee | 47037 | 29005 | 312 |
585548 | 585548 | 2020-09-30 | DeKalb | Tennessee | 47041 | 576 | 14 |
585549 | 585549 | 2020-09-30 | Decatur | Tennessee | 47039 | 538 | 7 |
585550 | 585550 | 2020-09-30 | Dickson | Tennessee | 47043 | 1297 | 16 |
585551 | 585551 | 2020-09-30 | Dyer | Tennessee | 47045 | 1430 | 17 |
585552 | 585552 | 2020-09-30 | Fayette | Tennessee | 47047 | 1236 | 21 |
585553 | 585553 | 2020-09-30 | Fentress | Tennessee | 47049 | 588 | 4 |
585554 | 585554 | 2020-09-30 | Franklin | Tennessee | 47051 | 1010 | 10 |
585555 | 585555 | 2020-09-30 | Gibson | Tennessee | 47053 | 1746 | 25 |
585556 | 585556 | 2020-09-30 | Giles | Tennessee | 47055 | 654 | 17 |
585557 | 585557 | 2020-09-30 | Grainger | Tennessee | 47057 | 404 | 3 |
585558 | 585558 | 2020-09-30 | Greene | Tennessee | 47059 | 1185 | 46 |
585559 | 585559 | 2020-09-30 | Grundy | Tennessee | 47061 | 326 | 6 |
585560 | 585560 | 2020-09-30 | Hamblen | Tennessee | 47063 | 1965 | 28 |
585561 | 585561 | 2020-09-30 | Hamilton | Tennessee | 47065 | 9825 | 97 |
585562 | 585562 | 2020-09-30 | Hancock | Tennessee | 47067 | 109 | 3 |
585563 | 585563 | 2020-09-30 | Hardeman | Tennessee | 47069 | 1589 | 26 |
585564 | 585564 | 2020-09-30 | Hardin | Tennessee | 47071 | 1077 | 16 |
585565 | 585565 | 2020-09-30 | Hawkins | Tennessee | 47073 | 843 | 20 |
585566 | 585566 | 2020-09-30 | Haywood | Tennessee | 47075 | 1006 | 23 |
585567 | 585567 | 2020-09-30 | Henderson | Tennessee | 47077 | 1195 | 24 |
585568 | 585568 | 2020-09-30 | Henry | Tennessee | 47079 | 640 | 10 |
585569 | 585569 | 2020-09-30 | Hickman | Tennessee | 47081 | 612 | 8 |
585570 | 585570 | 2020-09-30 | Houston | Tennessee | 47083 | 243 | 2 |
585571 | 585571 | 2020-09-30 | Humphreys | Tennessee | 47085 | 268 | 3 |
585572 | 585572 | 2020-09-30 | Jackson | Tennessee | 47087 | 335 | 5 |
585573 | 585573 | 2020-09-30 | Jefferson | Tennessee | 47089 | 1161 | 14 |
585574 | 585574 | 2020-09-30 | Johnson | Tennessee | 47091 | 752 | 3 |
585575 | 585575 | 2020-09-30 | Knox | Tennessee | 47093 | 10314 | 84 |
585576 | 585576 | 2020-09-30 | Lake | Tennessee | 47095 | 928 | 2 |
585577 | 585577 | 2020-09-30 | Lauderdale | Tennessee | 47097 | 1017 | 16 |
585578 | 585578 | 2020-09-30 | Lawrence | Tennessee | 47099 | 1108 | 14 |
585579 | 585579 | 2020-09-30 | Lewis | Tennessee | 47101 | 211 | 1 |
585580 | 585580 | 2020-09-30 | Lincoln | Tennessee | 47103 | 646 | 1 |
585581 | 585581 | 2020-09-30 | Loudon | Tennessee | 47105 | 1226 | 7 |
585582 | 585582 | 2020-09-30 | Macon | Tennessee | 47111 | 1070 | 21 |
585583 | 585583 | 2020-09-30 | Madison | Tennessee | 47113 | 3063 | 66 |
585584 | 585584 | 2020-09-30 | Marion | Tennessee | 47115 | 555 | 8 |
585585 | 585585 | 2020-09-30 | Marshall | Tennessee | 47117 | 791 | 5 |
585586 | 585586 | 2020-09-30 | Maury | Tennessee | 47119 | 2457 | 26 |
585587 | 585587 | 2020-09-30 | McMinn | Tennessee | 47107 | 1176 | 26 |
585588 | 585588 | 2020-09-30 | McNairy | Tennessee | 47109 | 930 | 18 |
585589 | 585589 | 2020-09-30 | Meigs | Tennessee | 47121 | 231 | 3 |
585590 | 585590 | 2020-09-30 | Monroe | Tennessee | 47123 | 1083 | 19 |
585591 | 585591 | 2020-09-30 | Montgomery | Tennessee | 47125 | 3174 | 46 |
585592 | 585592 | 2020-09-30 | Moore | Tennessee | 47127 | 188 | 1 |
585593 | 585593 | 2020-09-30 | Morgan | Tennessee | 47129 | 325 | 3 |
585594 | 585594 | 2020-09-30 | Obion | Tennessee | 47131 | 1220 | 11 |
585595 | 585595 | 2020-09-30 | Overton | Tennessee | 47133 | 782 | 6 |
585596 | 585596 | 2020-09-30 | Perry | Tennessee | 47135 | 153 | 0 |
585597 | 585597 | 2020-09-30 | Pickett | Tennessee | 47137 | 131 | 2 |
585598 | 585598 | 2020-09-30 | Polk | Tennessee | 47139 | 410 | 10 |
585599 | 585599 | 2020-09-30 | Putnam | Tennessee | 47141 | 3383 | 44 |
585600 | 585600 | 2020-09-30 | Rhea | Tennessee | 47143 | 863 | 15 |
585601 | 585601 | 2020-09-30 | Roane | Tennessee | 47145 | 917 | 6 |
585602 | 585602 | 2020-09-30 | Robertson | Tennessee | 47147 | 2255 | 39 |
585603 | 585603 | 2020-09-30 | Rutherford | Tennessee | 47149 | 9523 | 92 |
585604 | 585604 | 2020-09-30 | Scott | Tennessee | 47151 | 225 | 2 |
585605 | 585605 | 2020-09-30 | Sequatchie | Tennessee | 47153 | 249 | 3 |
585606 | 585606 | 2020-09-30 | Sevier | Tennessee | 47155 | 2677 | 15 |
585607 | 585607 | 2020-09-30 | Shelby | Tennessee | 47157 | 31540 | 472 |
585608 | 585608 | 2020-09-30 | Smith | Tennessee | 47159 | 745 | 11 |
585609 | 585609 | 2020-09-30 | Stewart | Tennessee | 47161 | 223 | 2 |
585610 | 585610 | 2020-09-30 | Sullivan | Tennessee | 47163 | 2265 | 33 |
585611 | 585611 | 2020-09-30 | Sumner | Tennessee | 47165 | 4922 | 98 |
585612 | 585612 | 2020-09-30 | Tipton | Tennessee | 47167 | 1860 | 19 |
585613 | 585613 | 2020-09-30 | Trousdale | Tennessee | 47169 | 1675 | 7 |
585614 | 585614 | 2020-09-30 | Unicoi | Tennessee | 47171 | 292 | 1 |
585615 | 585615 | 2020-09-30 | Union | Tennessee | 47173 | 382 | 2 |
585616 | 585616 | 2020-09-30 | Van Buren | Tennessee | 47175 | 167 | 0 |
585617 | 585617 | 2020-09-30 | Warren | Tennessee | 47177 | 1085 | 7 |
585618 | 585618 | 2020-09-30 | Washington | Tennessee | 47179 | 2393 | 38 |
585619 | 585619 | 2020-09-30 | Wayne | Tennessee | 47181 | 1505 | 5 |
585620 | 585620 | 2020-09-30 | Weakley | Tennessee | 47183 | 1234 | 21 |
585621 | 585621 | 2020-09-30 | White | Tennessee | 47185 | 856 | 10 |
585622 | 585622 | 2020-09-30 | Williamson | Tennessee | 47187 | 5423 | 36 |
585623 | 585623 | 2020-09-30 | Wilson | Tennessee | 47189 | 3605 | 47 |
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);