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 2021-01-10 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
916473 | 916473 | 2021-01-10 | Anderson | Tennessee | 47001 | 6433 | 90 |
916474 | 916474 | 2021-01-10 | Bedford | Tennessee | 47003 | 5084 | 76 |
916475 | 916475 | 2021-01-10 | Benton | Tennessee | 47005 | 1269 | 32 |
916476 | 916476 | 2021-01-10 | Bledsoe | Tennessee | 47007 | 1695 | 10 |
916477 | 916477 | 2021-01-10 | Blount | Tennessee | 47009 | 11127 | 110 |
916478 | 916478 | 2021-01-10 | Bradley | Tennessee | 47011 | 10117 | 86 |
916479 | 916479 | 2021-01-10 | Campbell | Tennessee | 47013 | 3062 | 39 |
916480 | 916480 | 2021-01-10 | Cannon | Tennessee | 47015 | 1494 | 16 |
916481 | 916481 | 2021-01-10 | Carroll | Tennessee | 47017 | 2943 | 56 |
916482 | 916482 | 2021-01-10 | Carter | Tennessee | 47019 | 4918 | 103 |
916483 | 916483 | 2021-01-10 | Cheatham | Tennessee | 47021 | 3199 | 28 |
916484 | 916484 | 2021-01-10 | Chester | Tennessee | 47023 | 1668 | 36 |
916485 | 916485 | 2021-01-10 | Claiborne | Tennessee | 47025 | 1885 | 20 |
916486 | 916486 | 2021-01-10 | Clay | Tennessee | 47027 | 894 | 25 |
916487 | 916487 | 2021-01-10 | Cocke | Tennessee | 47029 | 3270 | 52 |
916488 | 916488 | 2021-01-10 | Coffee | Tennessee | 47031 | 5401 | 76 |
916489 | 916489 | 2021-01-10 | Crockett | Tennessee | 47033 | 1774 | 37 |
916490 | 916490 | 2021-01-10 | Cumberland | Tennessee | 47035 | 5122 | 58 |
916491 | 916491 | 2021-01-10 | Davidson | Tennessee | 47037 | 75879 | 626 |
916492 | 916492 | 2021-01-10 | DeKalb | Tennessee | 47041 | 2338 | 37 |
916493 | 916493 | 2021-01-10 | Decatur | Tennessee | 47039 | 1428 | 23 |
916494 | 916494 | 2021-01-10 | Dickson | Tennessee | 47043 | 5120 | 74 |
916495 | 916495 | 2021-01-10 | Dyer | Tennessee | 47045 | 4571 | 79 |
916496 | 916496 | 2021-01-10 | Fayette | Tennessee | 47047 | 3761 | 51 |
916497 | 916497 | 2021-01-10 | Fentress | Tennessee | 47049 | 2054 | 30 |
916498 | 916498 | 2021-01-10 | Franklin | Tennessee | 47051 | 3913 | 51 |
916499 | 916499 | 2021-01-10 | Gibson | Tennessee | 47053 | 5441 | 102 |
916500 | 916500 | 2021-01-10 | Giles | Tennessee | 47055 | 3073 | 68 |
916501 | 916501 | 2021-01-10 | Grainger | Tennessee | 47057 | 1980 | 28 |
916502 | 916502 | 2021-01-10 | Greene | Tennessee | 47059 | 6294 | 103 |
916503 | 916503 | 2021-01-10 | Grundy | Tennessee | 47061 | 1348 | 20 |
916504 | 916504 | 2021-01-10 | Hamblen | Tennessee | 47063 | 6576 | 96 |
916505 | 916505 | 2021-01-10 | Hamilton | Tennessee | 47065 | 33829 | 305 |
916506 | 916506 | 2021-01-10 | Hancock | Tennessee | 47067 | 381 | 6 |
916507 | 916507 | 2021-01-10 | Hardeman | Tennessee | 47069 | 3019 | 49 |
916508 | 916508 | 2021-01-10 | Hardin | Tennessee | 47071 | 2896 | 38 |
916509 | 916509 | 2021-01-10 | Hawkins | Tennessee | 47073 | 4242 | 63 |
916510 | 916510 | 2021-01-10 | Haywood | Tennessee | 47075 | 2327 | 41 |
916511 | 916511 | 2021-01-10 | Henderson | Tennessee | 47077 | 3229 | 51 |
916512 | 916512 | 2021-01-10 | Henry | Tennessee | 47079 | 2487 | 48 |
916513 | 916513 | 2021-01-10 | Hickman | Tennessee | 47081 | 2137 | 30 |
916514 | 916514 | 2021-01-10 | Houston | Tennessee | 47083 | 908 | 22 |
916515 | 916515 | 2021-01-10 | Humphreys | Tennessee | 47085 | 1254 | 16 |
916516 | 916516 | 2021-01-10 | Jackson | Tennessee | 47087 | 1017 | 20 |
916517 | 916517 | 2021-01-10 | Jefferson | Tennessee | 47089 | 4406 | 73 |
916518 | 916518 | 2021-01-10 | Johnson | Tennessee | 47091 | 1915 | 30 |
916519 | 916519 | 2021-01-10 | Knox | Tennessee | 47093 | 37780 | 370 |
916520 | 916520 | 2021-01-10 | Lake | Tennessee | 47095 | 1514 | 19 |
916521 | 916521 | 2021-01-10 | Lauderdale | Tennessee | 47097 | 2849 | 31 |
916522 | 916522 | 2021-01-10 | Lawrence | Tennessee | 47099 | 4885 | 66 |
916523 | 916523 | 2021-01-10 | Lewis | Tennessee | 47101 | 1237 | 20 |
916524 | 916524 | 2021-01-10 | Lincoln | Tennessee | 47103 | 3639 | 39 |
916525 | 916525 | 2021-01-10 | Loudon | Tennessee | 47105 | 4713 | 46 |
916526 | 916526 | 2021-01-10 | Macon | Tennessee | 47111 | 2773 | 48 |
916527 | 916527 | 2021-01-10 | Madison | Tennessee | 47113 | 8769 | 162 |
916528 | 916528 | 2021-01-10 | Marion | Tennessee | 47115 | 2120 | 27 |
916529 | 916529 | 2021-01-10 | Marshall | Tennessee | 47117 | 3209 | 33 |
916530 | 916530 | 2021-01-10 | Maury | Tennessee | 47119 | 10442 | 116 |
916531 | 916531 | 2021-01-10 | McMinn | Tennessee | 47107 | 4853 | 71 |
916532 | 916532 | 2021-01-10 | McNairy | Tennessee | 47109 | 2257 | 42 |
916533 | 916533 | 2021-01-10 | Meigs | Tennessee | 47121 | 1070 | 16 |
916534 | 916534 | 2021-01-10 | Monroe | Tennessee | 47123 | 4328 | 62 |
916535 | 916535 | 2021-01-10 | Montgomery | Tennessee | 47125 | 13352 | 138 |
916536 | 916536 | 2021-01-10 | Moore | Tennessee | 47127 | 770 | 6 |
916537 | 916537 | 2021-01-10 | Morgan | Tennessee | 47129 | 1777 | 12 |
916538 | 916538 | 2021-01-10 | Obion | Tennessee | 47131 | 3891 | 74 |
916539 | 916539 | 2021-01-10 | Overton | Tennessee | 47133 | 2428 | 41 |
916540 | 916540 | 2021-01-10 | Perry | Tennessee | 47135 | 916 | 24 |
916541 | 916541 | 2021-01-10 | Pickett | Tennessee | 47137 | 633 | 18 |
916542 | 916542 | 2021-01-10 | Polk | Tennessee | 47139 | 1338 | 17 |
916543 | 916543 | 2021-01-10 | Putnam | Tennessee | 47141 | 9566 | 128 |
916544 | 916544 | 2021-01-10 | Rhea | Tennessee | 47143 | 3627 | 53 |
916545 | 916545 | 2021-01-10 | Roane | Tennessee | 47145 | 4940 | 70 |
916546 | 916546 | 2021-01-10 | Robertson | Tennessee | 47147 | 7271 | 80 |
916547 | 916547 | 2021-01-10 | Rutherford | Tennessee | 47149 | 31563 | 267 |
916548 | 916548 | 2021-01-10 | Scott | Tennessee | 47151 | 2168 | 28 |
916549 | 916549 | 2021-01-10 | Sequatchie | Tennessee | 47153 | 1308 | 18 |
916550 | 916550 | 2021-01-10 | Sevier | Tennessee | 47155 | 9947 | 88 |
916551 | 916551 | 2021-01-10 | Shelby | Tennessee | 47157 | 73817 | 1029 |
916552 | 916552 | 2021-01-10 | Smith | Tennessee | 47159 | 2229 | 24 |
916553 | 916553 | 2021-01-10 | Stewart | Tennessee | 47161 | 1001 | 20 |
916554 | 916554 | 2021-01-10 | Sullivan | Tennessee | 47163 | 12010 | 200 |
916555 | 916555 | 2021-01-10 | Sumner | Tennessee | 47165 | 17405 | 223 |
916556 | 916556 | 2021-01-10 | Tipton | Tennessee | 47167 | 5923 | 60 |
916557 | 916557 | 2021-01-10 | Trousdale | Tennessee | 47169 | 2260 | 13 |
916558 | 916558 | 2021-01-10 | Unicoi | Tennessee | 47171 | 1587 | 41 |
916559 | 916559 | 2021-01-10 | Union | Tennessee | 47173 | 1334 | 20 |
916560 | 916560 | 2021-01-10 | Unknown | Tennessee | 12618 | 99 | |
916561 | 916561 | 2021-01-10 | Van Buren | Tennessee | 47175 | 617 | 7 |
916562 | 916562 | 2021-01-10 | Warren | Tennessee | 47177 | 4801 | 51 |
916563 | 916563 | 2021-01-10 | Washington | Tennessee | 47179 | 11414 | 186 |
916564 | 916564 | 2021-01-10 | Wayne | Tennessee | 47181 | 2561 | 18 |
916565 | 916565 | 2021-01-10 | Weakley | Tennessee | 47183 | 3321 | 47 |
916566 | 916566 | 2021-01-10 | White | Tennessee | 47185 | 2976 | 41 |
916567 | 916567 | 2021-01-10 | Williamson | Tennessee | 47187 | 20319 | 135 |
916568 | 916568 | 2021-01-10 | Wilson | Tennessee | 47189 | 13819 | 141 |
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);