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-11-18 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
744467 | 744467 | 2020-11-18 | Anderson | Tennessee | 47001 | 2510 | 25 |
744468 | 744468 | 2020-11-18 | Bedford | Tennessee | 47003 | 2368 | 28 |
744469 | 744469 | 2020-11-18 | Benton | Tennessee | 47005 | 689 | 13 |
744470 | 744470 | 2020-11-18 | Bledsoe | Tennessee | 47007 | 1118 | 4 |
744471 | 744471 | 2020-11-18 | Blount | Tennessee | 47009 | 4727 | 49 |
744472 | 744472 | 2020-11-18 | Bradley | Tennessee | 47011 | 4567 | 30 |
744473 | 744473 | 2020-11-18 | Campbell | Tennessee | 47013 | 1377 | 20 |
744474 | 744474 | 2020-11-18 | Cannon | Tennessee | 47015 | 639 | 2 |
744475 | 744475 | 2020-11-18 | Carroll | Tennessee | 47017 | 1512 | 30 |
744476 | 744476 | 2020-11-18 | Carter | Tennessee | 47019 | 2363 | 46 |
744477 | 744477 | 2020-11-18 | Cheatham | Tennessee | 47021 | 1399 | 16 |
744478 | 744478 | 2020-11-18 | Chester | Tennessee | 47023 | 923 | 19 |
744479 | 744479 | 2020-11-18 | Claiborne | Tennessee | 47025 | 690 | 9 |
744480 | 744480 | 2020-11-18 | Clay | Tennessee | 47027 | 497 | 17 |
744481 | 744481 | 2020-11-18 | Cocke | Tennessee | 47029 | 1488 | 26 |
744482 | 744482 | 2020-11-18 | Coffee | Tennessee | 47031 | 2501 | 36 |
744483 | 744483 | 2020-11-18 | Crockett | Tennessee | 47033 | 1084 | 25 |
744484 | 744484 | 2020-11-18 | Cumberland | Tennessee | 47035 | 2254 | 34 |
744485 | 744485 | 2020-11-18 | Davidson | Tennessee | 47037 | 41553 | 391 |
744486 | 744486 | 2020-11-18 | DeKalb | Tennessee | 47041 | 1017 | 20 |
744487 | 744487 | 2020-11-18 | Decatur | Tennessee | 47039 | 860 | 11 |
744488 | 744488 | 2020-11-18 | Dickson | Tennessee | 47043 | 2519 | 26 |
744489 | 744489 | 2020-11-18 | Dyer | Tennessee | 47045 | 2921 | 48 |
744490 | 744490 | 2020-11-18 | Fayette | Tennessee | 47047 | 2047 | 37 |
744491 | 744491 | 2020-11-18 | Fentress | Tennessee | 47049 | 1110 | 19 |
744492 | 744492 | 2020-11-18 | Franklin | Tennessee | 47051 | 1793 | 29 |
744493 | 744493 | 2020-11-18 | Gibson | Tennessee | 47053 | 2830 | 60 |
744494 | 744494 | 2020-11-18 | Giles | Tennessee | 47055 | 1300 | 40 |
744495 | 744495 | 2020-11-18 | Grainger | Tennessee | 47057 | 837 | 11 |
744496 | 744496 | 2020-11-18 | Greene | Tennessee | 47059 | 2663 | 67 |
744497 | 744497 | 2020-11-18 | Grundy | Tennessee | 47061 | 708 | 14 |
744498 | 744498 | 2020-11-18 | Hamblen | Tennessee | 47063 | 3109 | 56 |
744499 | 744499 | 2020-11-18 | Hamilton | Tennessee | 47065 | 15610 | 129 |
744500 | 744500 | 2020-11-18 | Hancock | Tennessee | 47067 | 135 | 3 |
744501 | 744501 | 2020-11-18 | Hardeman | Tennessee | 47069 | 2151 | 36 |
744502 | 744502 | 2020-11-18 | Hardin | Tennessee | 47071 | 1644 | 25 |
744503 | 744503 | 2020-11-18 | Hawkins | Tennessee | 47073 | 1696 | 32 |
744504 | 744504 | 2020-11-18 | Haywood | Tennessee | 47075 | 1527 | 29 |
744505 | 744505 | 2020-11-18 | Henderson | Tennessee | 47077 | 1694 | 30 |
744506 | 744506 | 2020-11-18 | Henry | Tennessee | 47079 | 1289 | 15 |
744507 | 744507 | 2020-11-18 | Hickman | Tennessee | 47081 | 1047 | 17 |
744508 | 744508 | 2020-11-18 | Houston | Tennessee | 47083 | 554 | 19 |
744509 | 744509 | 2020-11-18 | Humphreys | Tennessee | 47085 | 619 | 7 |
744510 | 744510 | 2020-11-18 | Jackson | Tennessee | 47087 | 634 | 9 |
744511 | 744511 | 2020-11-18 | Jefferson | Tennessee | 47089 | 1999 | 28 |
744512 | 744512 | 2020-11-18 | Johnson | Tennessee | 47091 | 1346 | 18 |
744513 | 744513 | 2020-11-18 | Knox | Tennessee | 47093 | 17054 | 138 |
744514 | 744514 | 2020-11-18 | Lake | Tennessee | 47095 | 1122 | 5 |
744515 | 744515 | 2020-11-18 | Lauderdale | Tennessee | 47097 | 1909 | 20 |
744516 | 744516 | 2020-11-18 | Lawrence | Tennessee | 47099 | 2364 | 28 |
744517 | 744517 | 2020-11-18 | Lewis | Tennessee | 47101 | 681 | 10 |
744518 | 744518 | 2020-11-18 | Lincoln | Tennessee | 47103 | 1322 | 11 |
744519 | 744519 | 2020-11-18 | Loudon | Tennessee | 47105 | 2079 | 16 |
744520 | 744520 | 2020-11-18 | Macon | Tennessee | 47111 | 1671 | 27 |
744521 | 744521 | 2020-11-18 | Madison | Tennessee | 47113 | 4865 | 98 |
744522 | 744522 | 2020-11-18 | Marion | Tennessee | 47115 | 1001 | 15 |
744523 | 744523 | 2020-11-18 | Marshall | Tennessee | 47117 | 1549 | 15 |
744524 | 744524 | 2020-11-18 | Maury | Tennessee | 47119 | 5158 | 50 |
744525 | 744525 | 2020-11-18 | McMinn | Tennessee | 47107 | 2219 | 50 |
744526 | 744526 | 2020-11-18 | McNairy | Tennessee | 47109 | 1351 | 31 |
744527 | 744527 | 2020-11-18 | Meigs | Tennessee | 47121 | 431 | 10 |
744528 | 744528 | 2020-11-18 | Monroe | Tennessee | 47123 | 1870 | 42 |
744529 | 744529 | 2020-11-18 | Montgomery | Tennessee | 47125 | 5759 | 77 |
744530 | 744530 | 2020-11-18 | Moore | Tennessee | 47127 | 348 | 2 |
744531 | 744531 | 2020-11-18 | Morgan | Tennessee | 47129 | 594 | 6 |
744532 | 744532 | 2020-11-18 | Obion | Tennessee | 47131 | 2350 | 39 |
744533 | 744533 | 2020-11-18 | Overton | Tennessee | 47133 | 1440 | 34 |
744534 | 744534 | 2020-11-18 | Perry | Tennessee | 47135 | 445 | 18 |
744535 | 744535 | 2020-11-18 | Pickett | Tennessee | 47137 | 347 | 12 |
744536 | 744536 | 2020-11-18 | Polk | Tennessee | 47139 | 607 | 14 |
744537 | 744537 | 2020-11-18 | Putnam | Tennessee | 47141 | 5505 | 74 |
744538 | 744538 | 2020-11-18 | Rhea | Tennessee | 47143 | 1477 | 28 |
744539 | 744539 | 2020-11-18 | Roane | Tennessee | 47145 | 2084 | 19 |
744540 | 744540 | 2020-11-18 | Robertson | Tennessee | 47147 | 3319 | 49 |
744541 | 744541 | 2020-11-18 | Rutherford | Tennessee | 47149 | 15857 | 139 |
744542 | 744542 | 2020-11-18 | Scott | Tennessee | 47151 | 802 | 6 |
744543 | 744543 | 2020-11-18 | Sequatchie | Tennessee | 47153 | 470 | 5 |
744544 | 744544 | 2020-11-18 | Sevier | Tennessee | 47155 | 4337 | 27 |
744545 | 744545 | 2020-11-18 | Shelby | Tennessee | 47157 | 44102 | 623 |
744546 | 744546 | 2020-11-18 | Smith | Tennessee | 47159 | 1304 | 17 |
744547 | 744547 | 2020-11-18 | Stewart | Tennessee | 47161 | 525 | 14 |
744548 | 744548 | 2020-11-18 | Sullivan | Tennessee | 47163 | 5504 | 79 |
744549 | 744549 | 2020-11-18 | Sumner | Tennessee | 47165 | 8422 | 128 |
744550 | 744550 | 2020-11-18 | Tipton | Tennessee | 47167 | 3204 | 34 |
744551 | 744551 | 2020-11-18 | Trousdale | Tennessee | 47169 | 1877 | 11 |
744552 | 744552 | 2020-11-18 | Unicoi | Tennessee | 47171 | 713 | 18 |
744553 | 744553 | 2020-11-18 | Union | Tennessee | 47173 | 662 | 5 |
744554 | 744554 | 2020-11-18 | Unknown | Tennessee | 994 | 0 | |
744555 | 744555 | 2020-11-18 | Van Buren | Tennessee | 47175 | 301 | 2 |
744556 | 744556 | 2020-11-18 | Warren | Tennessee | 47177 | 2120 | 16 |
744557 | 744557 | 2020-11-18 | Washington | Tennessee | 47179 | 5197 | 89 |
744558 | 744558 | 2020-11-18 | Wayne | Tennessee | 47181 | 1738 | 9 |
744559 | 744559 | 2020-11-18 | Weakley | Tennessee | 47183 | 1985 | 34 |
744560 | 744560 | 2020-11-18 | White | Tennessee | 47185 | 1599 | 17 |
744561 | 744561 | 2020-11-18 | Williamson | Tennessee | 47187 | 9993 | 69 |
744562 | 744562 | 2020-11-18 | Wilson | Tennessee | 47189 | 6476 | 70 |
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);