ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-11-14" 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 |
---|---|---|---|---|---|---|---|
731484 | 731484 | 2020-11-14 | Anderson | Tennessee | 47001 | 2311 | 22 |
731485 | 731485 | 2020-11-14 | Bedford | Tennessee | 47003 | 2201 | 24 |
731486 | 731486 | 2020-11-14 | Benton | Tennessee | 47005 | 632 | 13 |
731487 | 731487 | 2020-11-14 | Bledsoe | Tennessee | 47007 | 1098 | 4 |
731488 | 731488 | 2020-11-14 | Blount | Tennessee | 47009 | 4239 | 47 |
731489 | 731489 | 2020-11-14 | Bradley | Tennessee | 47011 | 4304 | 27 |
731490 | 731490 | 2020-11-14 | Campbell | Tennessee | 47013 | 1319 | 19 |
731491 | 731491 | 2020-11-14 | Cannon | Tennessee | 47015 | 588 | 2 |
731492 | 731492 | 2020-11-14 | Carroll | Tennessee | 47017 | 1408 | 30 |
731493 | 731493 | 2020-11-14 | Carter | Tennessee | 47019 | 2202 | 43 |
731494 | 731494 | 2020-11-14 | Cheatham | Tennessee | 47021 | 1319 | 13 |
731495 | 731495 | 2020-11-14 | Chester | Tennessee | 47023 | 857 | 19 |
731496 | 731496 | 2020-11-14 | Claiborne | Tennessee | 47025 | 634 | 9 |
731497 | 731497 | 2020-11-14 | Clay | Tennessee | 47027 | 470 | 16 |
731498 | 731498 | 2020-11-14 | Cocke | Tennessee | 47029 | 1405 | 26 |
731499 | 731499 | 2020-11-14 | Coffee | Tennessee | 47031 | 2346 | 36 |
731500 | 731500 | 2020-11-14 | Crockett | Tennessee | 47033 | 1045 | 25 |
731501 | 731501 | 2020-11-14 | Cumberland | Tennessee | 47035 | 2130 | 31 |
731502 | 731502 | 2020-11-14 | Davidson | Tennessee | 47037 | 39411 | 380 |
731503 | 731503 | 2020-11-14 | DeKalb | Tennessee | 47041 | 953 | 19 |
731504 | 731504 | 2020-11-14 | Decatur | Tennessee | 47039 | 804 | 11 |
731505 | 731505 | 2020-11-14 | Dickson | Tennessee | 47043 | 2275 | 23 |
731506 | 731506 | 2020-11-14 | Dyer | Tennessee | 47045 | 2803 | 47 |
731507 | 731507 | 2020-11-14 | Fayette | Tennessee | 47047 | 1973 | 36 |
731508 | 731508 | 2020-11-14 | Fentress | Tennessee | 47049 | 1063 | 16 |
731509 | 731509 | 2020-11-14 | Franklin | Tennessee | 47051 | 1647 | 29 |
731510 | 731510 | 2020-11-14 | Gibson | Tennessee | 47053 | 2611 | 59 |
731511 | 731511 | 2020-11-14 | Giles | Tennessee | 47055 | 1241 | 39 |
731512 | 731512 | 2020-11-14 | Grainger | Tennessee | 47057 | 790 | 9 |
731513 | 731513 | 2020-11-14 | Greene | Tennessee | 47059 | 2451 | 63 |
731514 | 731514 | 2020-11-14 | Grundy | Tennessee | 47061 | 682 | 14 |
731515 | 731515 | 2020-11-14 | Hamblen | Tennessee | 47063 | 2961 | 56 |
731516 | 731516 | 2020-11-14 | Hamilton | Tennessee | 47065 | 14790 | 123 |
731517 | 731517 | 2020-11-14 | Hancock | Tennessee | 47067 | 129 | 3 |
731518 | 731518 | 2020-11-14 | Hardeman | Tennessee | 47069 | 2100 | 35 |
731519 | 731519 | 2020-11-14 | Hardin | Tennessee | 47071 | 1588 | 25 |
731520 | 731520 | 2020-11-14 | Hawkins | Tennessee | 47073 | 1575 | 31 |
731521 | 731521 | 2020-11-14 | Haywood | Tennessee | 47075 | 1474 | 28 |
731522 | 731522 | 2020-11-14 | Henderson | Tennessee | 47077 | 1603 | 30 |
731523 | 731523 | 2020-11-14 | Henry | Tennessee | 47079 | 1159 | 15 |
731524 | 731524 | 2020-11-14 | Hickman | Tennessee | 47081 | 969 | 16 |
731525 | 731525 | 2020-11-14 | Houston | Tennessee | 47083 | 530 | 19 |
731526 | 731526 | 2020-11-14 | Humphreys | Tennessee | 47085 | 578 | 6 |
731527 | 731527 | 2020-11-14 | Jackson | Tennessee | 47087 | 598 | 7 |
731528 | 731528 | 2020-11-14 | Jefferson | Tennessee | 47089 | 1892 | 27 |
731529 | 731529 | 2020-11-14 | Johnson | Tennessee | 47091 | 1311 | 17 |
731530 | 731530 | 2020-11-14 | Knox | Tennessee | 47093 | 15909 | 128 |
731531 | 731531 | 2020-11-14 | Lake | Tennessee | 47095 | 1093 | 5 |
731532 | 731532 | 2020-11-14 | Lauderdale | Tennessee | 47097 | 1836 | 20 |
731533 | 731533 | 2020-11-14 | Lawrence | Tennessee | 47099 | 2217 | 25 |
731534 | 731534 | 2020-11-14 | Lewis | Tennessee | 47101 | 640 | 9 |
731535 | 731535 | 2020-11-14 | Lincoln | Tennessee | 47103 | 1257 | 8 |
731536 | 731536 | 2020-11-14 | Loudon | Tennessee | 47105 | 1969 | 15 |
731537 | 731537 | 2020-11-14 | Macon | Tennessee | 47111 | 1612 | 26 |
731538 | 731538 | 2020-11-14 | Madison | Tennessee | 47113 | 4530 | 94 |
731539 | 731539 | 2020-11-14 | Marion | Tennessee | 47115 | 959 | 15 |
731540 | 731540 | 2020-11-14 | Marshall | Tennessee | 47117 | 1457 | 15 |
731541 | 731541 | 2020-11-14 | Maury | Tennessee | 47119 | 4741 | 46 |
731542 | 731542 | 2020-11-14 | McMinn | Tennessee | 47107 | 2075 | 48 |
731543 | 731543 | 2020-11-14 | McNairy | Tennessee | 47109 | 1302 | 31 |
731544 | 731544 | 2020-11-14 | Meigs | Tennessee | 47121 | 404 | 10 |
731545 | 731545 | 2020-11-14 | Monroe | Tennessee | 47123 | 1753 | 40 |
731546 | 731546 | 2020-11-14 | Montgomery | Tennessee | 47125 | 5374 | 75 |
731547 | 731547 | 2020-11-14 | Moore | Tennessee | 47127 | 329 | 2 |
731548 | 731548 | 2020-11-14 | Morgan | Tennessee | 47129 | 557 | 6 |
731549 | 731549 | 2020-11-14 | Obion | Tennessee | 47131 | 2217 | 35 |
731550 | 731550 | 2020-11-14 | Overton | Tennessee | 47133 | 1398 | 33 |
731551 | 731551 | 2020-11-14 | Perry | Tennessee | 47135 | 424 | 18 |
731552 | 731552 | 2020-11-14 | Pickett | Tennessee | 47137 | 334 | 11 |
731553 | 731553 | 2020-11-14 | Polk | Tennessee | 47139 | 596 | 13 |
731554 | 731554 | 2020-11-14 | Putnam | Tennessee | 47141 | 5271 | 70 |
731555 | 731555 | 2020-11-14 | Rhea | Tennessee | 47143 | 1370 | 27 |
731556 | 731556 | 2020-11-14 | Roane | Tennessee | 47145 | 1900 | 14 |
731557 | 731557 | 2020-11-14 | Robertson | Tennessee | 47147 | 3078 | 46 |
731558 | 731558 | 2020-11-14 | Rutherford | Tennessee | 47149 | 14883 | 129 |
731559 | 731559 | 2020-11-14 | Scott | Tennessee | 47151 | 692 | 6 |
731560 | 731560 | 2020-11-14 | Sequatchie | Tennessee | 47153 | 445 | 5 |
731561 | 731561 | 2020-11-14 | Sevier | Tennessee | 47155 | 4082 | 27 |
731562 | 731562 | 2020-11-14 | Shelby | Tennessee | 47157 | 42120 | 612 |
731563 | 731563 | 2020-11-14 | Smith | Tennessee | 47159 | 1225 | 17 |
731564 | 731564 | 2020-11-14 | Stewart | Tennessee | 47161 | 474 | 13 |
731565 | 731565 | 2020-11-14 | Sullivan | Tennessee | 47163 | 5059 | 77 |
731566 | 731566 | 2020-11-14 | Sumner | Tennessee | 47165 | 7776 | 122 |
731567 | 731567 | 2020-11-14 | Tipton | Tennessee | 47167 | 2994 | 32 |
731568 | 731568 | 2020-11-14 | Trousdale | Tennessee | 47169 | 1857 | 10 |
731569 | 731569 | 2020-11-14 | Unicoi | Tennessee | 47171 | 644 | 17 |
731570 | 731570 | 2020-11-14 | Union | Tennessee | 47173 | 628 | 5 |
731571 | 731571 | 2020-11-14 | Unknown | Tennessee | 272 | 0 | |
731572 | 731572 | 2020-11-14 | Van Buren | Tennessee | 47175 | 274 | 2 |
731573 | 731573 | 2020-11-14 | Warren | Tennessee | 47177 | 1978 | 14 |
731574 | 731574 | 2020-11-14 | Washington | Tennessee | 47179 | 4811 | 85 |
731575 | 731575 | 2020-11-14 | Wayne | Tennessee | 47181 | 1687 | 8 |
731576 | 731576 | 2020-11-14 | Weakley | Tennessee | 47183 | 1851 | 33 |
731577 | 731577 | 2020-11-14 | White | Tennessee | 47185 | 1499 | 17 |
731578 | 731578 | 2020-11-14 | Williamson | Tennessee | 47187 | 9218 | 66 |
731579 | 731579 | 2020-11-14 | Wilson | Tennessee | 47189 | 6057 | 68 |
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);