ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-11-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 |
---|---|---|---|---|---|---|---|
783414 | 783414 | 2020-11-30 | Anderson | Tennessee | 47001 | 3107 | 29 |
783415 | 783415 | 2020-11-30 | Bedford | Tennessee | 47003 | 2851 | 32 |
783416 | 783416 | 2020-11-30 | Benton | Tennessee | 47005 | 842 | 14 |
783417 | 783417 | 2020-11-30 | Bledsoe | Tennessee | 47007 | 1189 | 5 |
783418 | 783418 | 2020-11-30 | Blount | Tennessee | 47009 | 5752 | 61 |
783419 | 783419 | 2020-11-30 | Bradley | Tennessee | 47011 | 5469 | 35 |
783420 | 783420 | 2020-11-30 | Campbell | Tennessee | 47013 | 1603 | 23 |
783421 | 783421 | 2020-11-30 | Cannon | Tennessee | 47015 | 786 | 4 |
783422 | 783422 | 2020-11-30 | Carroll | Tennessee | 47017 | 1785 | 34 |
783423 | 783423 | 2020-11-30 | Carter | Tennessee | 47019 | 2860 | 57 |
783424 | 783424 | 2020-11-30 | Cheatham | Tennessee | 47021 | 1653 | 17 |
783425 | 783425 | 2020-11-30 | Chester | Tennessee | 47023 | 1042 | 21 |
783426 | 783426 | 2020-11-30 | Claiborne | Tennessee | 47025 | 897 | 9 |
783427 | 783427 | 2020-11-30 | Clay | Tennessee | 47027 | 560 | 18 |
783428 | 783428 | 2020-11-30 | Cocke | Tennessee | 47029 | 1653 | 30 |
783429 | 783429 | 2020-11-30 | Coffee | Tennessee | 47031 | 2886 | 42 |
783430 | 783430 | 2020-11-30 | Crockett | Tennessee | 47033 | 1171 | 26 |
783431 | 783431 | 2020-11-30 | Cumberland | Tennessee | 47035 | 2665 | 36 |
783432 | 783432 | 2020-11-30 | Davidson | Tennessee | 47037 | 46309 | 421 |
783433 | 783433 | 2020-11-30 | DeKalb | Tennessee | 47041 | 1204 | 22 |
783434 | 783434 | 2020-11-30 | Decatur | Tennessee | 47039 | 961 | 12 |
783435 | 783435 | 2020-11-30 | Dickson | Tennessee | 47043 | 3004 | 34 |
783436 | 783436 | 2020-11-30 | Dyer | Tennessee | 47045 | 3254 | 51 |
783437 | 783437 | 2020-11-30 | Fayette | Tennessee | 47047 | 2302 | 39 |
783438 | 783438 | 2020-11-30 | Fentress | Tennessee | 47049 | 1244 | 20 |
783439 | 783439 | 2020-11-30 | Franklin | Tennessee | 47051 | 2179 | 35 |
783440 | 783440 | 2020-11-30 | Gibson | Tennessee | 47053 | 3320 | 65 |
783441 | 783441 | 2020-11-30 | Giles | Tennessee | 47055 | 1502 | 49 |
783442 | 783442 | 2020-11-30 | Grainger | Tennessee | 47057 | 1050 | 17 |
783443 | 783443 | 2020-11-30 | Greene | Tennessee | 47059 | 3248 | 72 |
783444 | 783444 | 2020-11-30 | Grundy | Tennessee | 47061 | 792 | 14 |
783445 | 783445 | 2020-11-30 | Hamblen | Tennessee | 47063 | 3607 | 61 |
783446 | 783446 | 2020-11-30 | Hamilton | Tennessee | 47065 | 18136 | 155 |
783447 | 783447 | 2020-11-30 | Hancock | Tennessee | 47067 | 183 | 3 |
783448 | 783448 | 2020-11-30 | Hardeman | Tennessee | 47069 | 2278 | 37 |
783449 | 783449 | 2020-11-30 | Hardin | Tennessee | 47071 | 1800 | 25 |
783450 | 783450 | 2020-11-30 | Hawkins | Tennessee | 47073 | 2040 | 34 |
783451 | 783451 | 2020-11-30 | Haywood | Tennessee | 47075 | 1658 | 30 |
783452 | 783452 | 2020-11-30 | Henderson | Tennessee | 47077 | 1901 | 34 |
783453 | 783453 | 2020-11-30 | Henry | Tennessee | 47079 | 1593 | 19 |
783454 | 783454 | 2020-11-30 | Hickman | Tennessee | 47081 | 1216 | 19 |
783455 | 783455 | 2020-11-30 | Houston | Tennessee | 47083 | 592 | 20 |
783456 | 783456 | 2020-11-30 | Humphreys | Tennessee | 47085 | 741 | 8 |
783457 | 783457 | 2020-11-30 | Jackson | Tennessee | 47087 | 694 | 10 |
783458 | 783458 | 2020-11-30 | Jefferson | Tennessee | 47089 | 2365 | 33 |
783459 | 783459 | 2020-11-30 | Johnson | Tennessee | 47091 | 1449 | 23 |
783460 | 783460 | 2020-11-30 | Knox | Tennessee | 47093 | 19579 | 167 |
783461 | 783461 | 2020-11-30 | Lake | Tennessee | 47095 | 1178 | 6 |
783462 | 783462 | 2020-11-30 | Lauderdale | Tennessee | 47097 | 2080 | 23 |
783463 | 783463 | 2020-11-30 | Lawrence | Tennessee | 47099 | 2761 | 34 |
783464 | 783464 | 2020-11-30 | Lewis | Tennessee | 47101 | 777 | 14 |
783465 | 783465 | 2020-11-30 | Lincoln | Tennessee | 47103 | 1662 | 17 |
783466 | 783466 | 2020-11-30 | Loudon | Tennessee | 47105 | 2348 | 19 |
783467 | 783467 | 2020-11-30 | Macon | Tennessee | 47111 | 1860 | 28 |
783468 | 783468 | 2020-11-30 | Madison | Tennessee | 47113 | 5445 | 111 |
783469 | 783469 | 2020-11-30 | Marion | Tennessee | 47115 | 1122 | 19 |
783470 | 783470 | 2020-11-30 | Marshall | Tennessee | 47117 | 1796 | 22 |
783471 | 783471 | 2020-11-30 | Maury | Tennessee | 47119 | 6106 | 67 |
783472 | 783472 | 2020-11-30 | McMinn | Tennessee | 47107 | 2679 | 55 |
783473 | 783473 | 2020-11-30 | McNairy | Tennessee | 47109 | 1424 | 33 |
783474 | 783474 | 2020-11-30 | Meigs | Tennessee | 47121 | 510 | 13 |
783475 | 783475 | 2020-11-30 | Monroe | Tennessee | 47123 | 2232 | 44 |
783476 | 783476 | 2020-11-30 | Montgomery | Tennessee | 47125 | 6915 | 85 |
783477 | 783477 | 2020-11-30 | Moore | Tennessee | 47127 | 404 | 3 |
783478 | 783478 | 2020-11-30 | Morgan | Tennessee | 47129 | 762 | 6 |
783479 | 783479 | 2020-11-30 | Obion | Tennessee | 47131 | 2717 | 51 |
783480 | 783480 | 2020-11-30 | Overton | Tennessee | 47133 | 1564 | 35 |
783481 | 783481 | 2020-11-30 | Perry | Tennessee | 47135 | 492 | 21 |
783482 | 783482 | 2020-11-30 | Pickett | Tennessee | 47137 | 395 | 13 |
783483 | 783483 | 2020-11-30 | Polk | Tennessee | 47139 | 694 | 15 |
783484 | 783484 | 2020-11-30 | Putnam | Tennessee | 47141 | 6009 | 82 |
783485 | 783485 | 2020-11-30 | Rhea | Tennessee | 47143 | 1801 | 32 |
783486 | 783486 | 2020-11-30 | Roane | Tennessee | 47145 | 2439 | 29 |
783487 | 783487 | 2020-11-30 | Robertson | Tennessee | 47147 | 3895 | 53 |
783488 | 783488 | 2020-11-30 | Rutherford | Tennessee | 47149 | 18248 | 163 |
783489 | 783489 | 2020-11-30 | Scott | Tennessee | 47151 | 1119 | 7 |
783490 | 783490 | 2020-11-30 | Sequatchie | Tennessee | 47153 | 546 | 5 |
783491 | 783491 | 2020-11-30 | Sevier | Tennessee | 47155 | 5121 | 33 |
783492 | 783492 | 2020-11-30 | Shelby | Tennessee | 47157 | 48561 | 673 |
783493 | 783493 | 2020-11-30 | Smith | Tennessee | 47159 | 1477 | 20 |
783494 | 783494 | 2020-11-30 | Stewart | Tennessee | 47161 | 610 | 15 |
783495 | 783495 | 2020-11-30 | Sullivan | Tennessee | 47163 | 6641 | 101 |
783496 | 783496 | 2020-11-30 | Sumner | Tennessee | 47165 | 10123 | 137 |
783497 | 783497 | 2020-11-30 | Tipton | Tennessee | 47167 | 3753 | 39 |
783498 | 783498 | 2020-11-30 | Trousdale | Tennessee | 47169 | 1915 | 12 |
783499 | 783499 | 2020-11-30 | Unicoi | Tennessee | 47171 | 902 | 26 |
783500 | 783500 | 2020-11-30 | Union | Tennessee | 47173 | 737 | 5 |
783501 | 783501 | 2020-11-30 | Unknown | Tennessee | 1108 | 3 | |
783502 | 783502 | 2020-11-30 | Van Buren | Tennessee | 47175 | 379 | 2 |
783503 | 783503 | 2020-11-30 | Warren | Tennessee | 47177 | 2431 | 20 |
783504 | 783504 | 2020-11-30 | Washington | Tennessee | 47179 | 6272 | 108 |
783505 | 783505 | 2020-11-30 | Wayne | Tennessee | 47181 | 1946 | 10 |
783506 | 783506 | 2020-11-30 | Weakley | Tennessee | 47183 | 2217 | 37 |
783507 | 783507 | 2020-11-30 | White | Tennessee | 47185 | 1808 | 18 |
783508 | 783508 | 2020-11-30 | Williamson | Tennessee | 47187 | 11680 | 80 |
783509 | 783509 | 2020-11-30 | Wilson | Tennessee | 47189 | 7779 | 80 |
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);