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-12-04 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 96
- 47001 1
- 47003 1
- 47005 1
- 47007 1
- 47009 1
- 47011 1
- 47013 1
- 47015 1
- 47017 1
- 47019 1
- 47021 1
- 47023 1
- 47025 1
- 47027 1
- 47029 1
- 47031 1
- 47033 1
- 47035 1
- 47037 1
- 47039 1
- 47041 1
- 47043 1
- 47045 1
- 47047 1
- 47049 1
- 47051 1
- 47053 1
- 47055 1
- 47057 1
- 47059 1
- 47061 1
- 47063 1
- 47065 1
- 47067 1
- 47069 1
- 47071 1
- 47073 1
- 47075 1
- 47077 1
- 47079 1
- 47081 1
- 47083 1
- 47085 1
- 47087 1
- 47089 1
- 47091 1
- 47093 1
- 47095 1
- 47097 1
- 47099 1
- 47101 1
- 47103 1
- 47105 1
- 47107 1
- 47109 1
- 47111 1
- 47113 1
- 47115 1
- 47117 1
- 47119 1
- 47121 1
- 47123 1
- 47125 1
- 47127 1
- 47129 1
- 47131 1
- 47133 1
- 47135 1
- 47137 1
- 47139 1
- 47141 1
- 47143 1
- 47145 1
- 47147 1
- 47149 1
- 47151 1
- 47153 1
- 47155 1
- 47157 1
- 47159 1
- 47161 1
- 47163 1
- 47165 1
- 47167 1
- 47169 1
- 47171 1
- 47173 1
- 47175 1
- 47177 1
- 47179 1
- 47181 1
- 47183 1
- 47185 1
- 47187 1
- 47189 1
- - 1
county 96
- Anderson 1
- Bedford 1
- Benton 1
- Bledsoe 1
- Blount 1
- Bradley 1
- Campbell 1
- Cannon 1
- Carroll 1
- Carter 1
- Cheatham 1
- Chester 1
- Claiborne 1
- Clay 1
- Cocke 1
- Coffee 1
- Crockett 1
- Cumberland 1
- Davidson 1
- DeKalb 1
- Decatur 1
- Dickson 1
- Dyer 1
- Fayette 1
- Fentress 1
- Franklin 1
- Gibson 1
- Giles 1
- Grainger 1
- Greene 1
- Grundy 1
- Hamblen 1
- Hamilton 1
- Hancock 1
- Hardeman 1
- Hardin 1
- Hawkins 1
- Haywood 1
- Henderson 1
- Henry 1
- Hickman 1
- Houston 1
- Humphreys 1
- Jackson 1
- Jefferson 1
- Johnson 1
- Knox 1
- Lake 1
- Lauderdale 1
- Lawrence 1
- Lewis 1
- Lincoln 1
- Loudon 1
- Macon 1
- Madison 1
- Marion 1
- Marshall 1
- Maury 1
- McMinn 1
- McNairy 1
- Meigs 1
- Monroe 1
- Montgomery 1
- Moore 1
- Morgan 1
- Obion 1
- Overton 1
- Perry 1
- Pickett 1
- Polk 1
- Putnam 1
- Rhea 1
- Roane 1
- Robertson 1
- Rutherford 1
- Scott 1
- Sequatchie 1
- Sevier 1
- Shelby 1
- Smith 1
- Stewart 1
- Sullivan 1
- Sumner 1
- Tipton 1
- Trousdale 1
- Unicoi 1
- Union 1
- Unknown 1
- Van Buren 1
- Warren 1
- Washington 1
- Wayne 1
- Weakley 1
- White 1
- Williamson 1
- Wilson 1
state 1
- Tennessee · 96 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
796393 | 796393 | 2020-12-04 | Anderson | Tennessee | 47001 | 3272 | 32 |
796394 | 796394 | 2020-12-04 | Bedford | Tennessee | 47003 | 2981 | 34 |
796395 | 796395 | 2020-12-04 | Benton | Tennessee | 47005 | 888 | 16 |
796396 | 796396 | 2020-12-04 | Bledsoe | Tennessee | 47007 | 1227 | 5 |
796397 | 796397 | 2020-12-04 | Blount | Tennessee | 47009 | 6176 | 65 |
796398 | 796398 | 2020-12-04 | Bradley | Tennessee | 47011 | 5775 | 38 |
796399 | 796399 | 2020-12-04 | Campbell | Tennessee | 47013 | 1685 | 24 |
796400 | 796400 | 2020-12-04 | Cannon | Tennessee | 47015 | 825 | 4 |
796401 | 796401 | 2020-12-04 | Carroll | Tennessee | 47017 | 1873 | 36 |
796402 | 796402 | 2020-12-04 | Carter | Tennessee | 47019 | 3007 | 63 |
796403 | 796403 | 2020-12-04 | Cheatham | Tennessee | 47021 | 1720 | 17 |
796404 | 796404 | 2020-12-04 | Chester | Tennessee | 47023 | 1069 | 23 |
796405 | 796405 | 2020-12-04 | Claiborne | Tennessee | 47025 | 995 | 10 |
796406 | 796406 | 2020-12-04 | Clay | Tennessee | 47027 | 578 | 19 |
796407 | 796407 | 2020-12-04 | Cocke | Tennessee | 47029 | 1744 | 30 |
796408 | 796408 | 2020-12-04 | Coffee | Tennessee | 47031 | 3079 | 43 |
796409 | 796409 | 2020-12-04 | Crockett | Tennessee | 47033 | 1193 | 29 |
796410 | 796410 | 2020-12-04 | Cumberland | Tennessee | 47035 | 2741 | 38 |
796411 | 796411 | 2020-12-04 | Davidson | Tennessee | 47037 | 49027 | 434 |
796412 | 796412 | 2020-12-04 | DeKalb | Tennessee | 47041 | 1267 | 25 |
796413 | 796413 | 2020-12-04 | Decatur | Tennessee | 47039 | 983 | 13 |
796414 | 796414 | 2020-12-04 | Dickson | Tennessee | 47043 | 3078 | 39 |
796415 | 796415 | 2020-12-04 | Dyer | Tennessee | 47045 | 3335 | 52 |
796416 | 796416 | 2020-12-04 | Fayette | Tennessee | 47047 | 2388 | 40 |
796417 | 796417 | 2020-12-04 | Fentress | Tennessee | 47049 | 1275 | 24 |
796418 | 796418 | 2020-12-04 | Franklin | Tennessee | 47051 | 2283 | 40 |
796419 | 796419 | 2020-12-04 | Gibson | Tennessee | 47053 | 3446 | 72 |
796420 | 796420 | 2020-12-04 | Giles | Tennessee | 47055 | 1589 | 51 |
796421 | 796421 | 2020-12-04 | Grainger | Tennessee | 47057 | 1099 | 18 |
796422 | 796422 | 2020-12-04 | Greene | Tennessee | 47059 | 3380 | 74 |
796423 | 796423 | 2020-12-04 | Grundy | Tennessee | 47061 | 815 | 14 |
796424 | 796424 | 2020-12-04 | Hamblen | Tennessee | 47063 | 3752 | 63 |
796425 | 796425 | 2020-12-04 | Hamilton | Tennessee | 47065 | 19863 | 173 |
796426 | 796426 | 2020-12-04 | Hancock | Tennessee | 47067 | 200 | 4 |
796427 | 796427 | 2020-12-04 | Hardeman | Tennessee | 47069 | 2309 | 38 |
796428 | 796428 | 2020-12-04 | Hardin | Tennessee | 47071 | 1865 | 29 |
796429 | 796429 | 2020-12-04 | Hawkins | Tennessee | 47073 | 2159 | 36 |
796430 | 796430 | 2020-12-04 | Haywood | Tennessee | 47075 | 1695 | 30 |
796431 | 796431 | 2020-12-04 | Henderson | Tennessee | 47077 | 1983 | 34 |
796432 | 796432 | 2020-12-04 | Henry | Tennessee | 47079 | 1653 | 22 |
796433 | 796433 | 2020-12-04 | Hickman | Tennessee | 47081 | 1258 | 19 |
796434 | 796434 | 2020-12-04 | Houston | Tennessee | 47083 | 607 | 20 |
796435 | 796435 | 2020-12-04 | Humphreys | Tennessee | 47085 | 770 | 9 |
796436 | 796436 | 2020-12-04 | Jackson | Tennessee | 47087 | 728 | 11 |
796437 | 796437 | 2020-12-04 | Jefferson | Tennessee | 47089 | 2495 | 35 |
796438 | 796438 | 2020-12-04 | Johnson | Tennessee | 47091 | 1479 | 23 |
796439 | 796439 | 2020-12-04 | Knox | Tennessee | 47093 | 20958 | 183 |
796440 | 796440 | 2020-12-04 | Lake | Tennessee | 47095 | 1207 | 7 |
796441 | 796441 | 2020-12-04 | Lauderdale | Tennessee | 47097 | 2144 | 23 |
796442 | 796442 | 2020-12-04 | Lawrence | Tennessee | 47099 | 2937 | 38 |
796443 | 796443 | 2020-12-04 | Lewis | Tennessee | 47101 | 819 | 16 |
796444 | 796444 | 2020-12-04 | Lincoln | Tennessee | 47103 | 1786 | 20 |
796445 | 796445 | 2020-12-04 | Loudon | Tennessee | 47105 | 2469 | 21 |
796446 | 796446 | 2020-12-04 | Macon | Tennessee | 47111 | 1936 | 30 |
796447 | 796447 | 2020-12-04 | Madison | Tennessee | 47113 | 5671 | 116 |
796448 | 796448 | 2020-12-04 | Marion | Tennessee | 47115 | 1212 | 19 |
796449 | 796449 | 2020-12-04 | Marshall | Tennessee | 47117 | 1861 | 22 |
796450 | 796450 | 2020-12-04 | Maury | Tennessee | 47119 | 6396 | 75 |
796451 | 796451 | 2020-12-04 | McMinn | Tennessee | 47107 | 2842 | 57 |
796452 | 796452 | 2020-12-04 | McNairy | Tennessee | 47109 | 1444 | 34 |
796453 | 796453 | 2020-12-04 | Meigs | Tennessee | 47121 | 539 | 12 |
796454 | 796454 | 2020-12-04 | Monroe | Tennessee | 47123 | 2350 | 46 |
796455 | 796455 | 2020-12-04 | Montgomery | Tennessee | 47125 | 7238 | 87 |
796456 | 796456 | 2020-12-04 | Moore | Tennessee | 47127 | 421 | 2 |
796457 | 796457 | 2020-12-04 | Morgan | Tennessee | 47129 | 809 | 7 |
796458 | 796458 | 2020-12-04 | Obion | Tennessee | 47131 | 2798 | 55 |
796459 | 796459 | 2020-12-04 | Overton | Tennessee | 47133 | 1582 | 37 |
796460 | 796460 | 2020-12-04 | Perry | Tennessee | 47135 | 515 | 22 |
796461 | 796461 | 2020-12-04 | Pickett | Tennessee | 47137 | 407 | 14 |
796462 | 796462 | 2020-12-04 | Polk | Tennessee | 47139 | 715 | 15 |
796463 | 796463 | 2020-12-04 | Putnam | Tennessee | 47141 | 6162 | 85 |
796464 | 796464 | 2020-12-04 | Rhea | Tennessee | 47143 | 1888 | 36 |
796465 | 796465 | 2020-12-04 | Roane | Tennessee | 47145 | 2578 | 33 |
796466 | 796466 | 2020-12-04 | Robertson | Tennessee | 47147 | 4109 | 57 |
796467 | 796467 | 2020-12-04 | Rutherford | Tennessee | 47149 | 19202 | 173 |
796468 | 796468 | 2020-12-04 | Scott | Tennessee | 47151 | 1177 | 8 |
796469 | 796469 | 2020-12-04 | Sequatchie | Tennessee | 47153 | 596 | 5 |
796470 | 796470 | 2020-12-04 | Sevier | Tennessee | 47155 | 5317 | 38 |
796471 | 796471 | 2020-12-04 | Shelby | Tennessee | 47157 | 50470 | 696 |
796472 | 796472 | 2020-12-04 | Smith | Tennessee | 47159 | 1518 | 20 |
796473 | 796473 | 2020-12-04 | Stewart | Tennessee | 47161 | 636 | 18 |
796474 | 796474 | 2020-12-04 | Sullivan | Tennessee | 47163 | 7128 | 114 |
796475 | 796475 | 2020-12-04 | Sumner | Tennessee | 47165 | 10700 | 144 |
796476 | 796476 | 2020-12-04 | Tipton | Tennessee | 47167 | 3899 | 39 |
796477 | 796477 | 2020-12-04 | Trousdale | Tennessee | 47169 | 1929 | 12 |
796478 | 796478 | 2020-12-04 | Unicoi | Tennessee | 47171 | 969 | 28 |
796479 | 796479 | 2020-12-04 | Union | Tennessee | 47173 | 771 | 5 |
796480 | 796480 | 2020-12-04 | Unknown | Tennessee | 166 | 4 | |
796481 | 796481 | 2020-12-04 | Van Buren | Tennessee | 47175 | 389 | 3 |
796482 | 796482 | 2020-12-04 | Warren | Tennessee | 47177 | 2539 | 19 |
796483 | 796483 | 2020-12-04 | Washington | Tennessee | 47179 | 6651 | 118 |
796484 | 796484 | 2020-12-04 | Wayne | Tennessee | 47181 | 1986 | 11 |
796485 | 796485 | 2020-12-04 | Weakley | Tennessee | 47183 | 2278 | 36 |
796486 | 796486 | 2020-12-04 | White | Tennessee | 47185 | 1909 | 19 |
796487 | 796487 | 2020-12-04 | Williamson | Tennessee | 47187 | 12236 | 87 |
796488 | 796488 | 2020-12-04 | Wilson | Tennessee | 47189 | 8127 | 88 |
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);