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-09-09 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
517525 | 517525 | 2020-09-09 | Anderson | Tennessee | 47001 | 963 | 9 |
517526 | 517526 | 2020-09-09 | Bedford | Tennessee | 47003 | 1172 | 14 |
517527 | 517527 | 2020-09-09 | Benton | Tennessee | 47005 | 289 | 8 |
517528 | 517528 | 2020-09-09 | Bledsoe | Tennessee | 47007 | 808 | 4 |
517529 | 517529 | 2020-09-09 | Blount | Tennessee | 47009 | 2168 | 18 |
517530 | 517530 | 2020-09-09 | Bradley | Tennessee | 47011 | 2606 | 16 |
517531 | 517531 | 2020-09-09 | Campbell | Tennessee | 47013 | 370 | 3 |
517532 | 517532 | 2020-09-09 | Cannon | Tennessee | 47015 | 233 | 0 |
517533 | 517533 | 2020-09-09 | Carroll | Tennessee | 47017 | 703 | 10 |
517534 | 517534 | 2020-09-09 | Carter | Tennessee | 47019 | 1011 | 24 |
517535 | 517535 | 2020-09-09 | Cheatham | Tennessee | 47021 | 731 | 10 |
517536 | 517536 | 2020-09-09 | Chester | Tennessee | 47023 | 470 | 7 |
517537 | 517537 | 2020-09-09 | Claiborne | Tennessee | 47025 | 383 | 3 |
517538 | 517538 | 2020-09-09 | Clay | Tennessee | 47027 | 131 | 3 |
517539 | 517539 | 2020-09-09 | Cocke | Tennessee | 47029 | 672 | 7 |
517540 | 517540 | 2020-09-09 | Coffee | Tennessee | 47031 | 848 | 8 |
517541 | 517541 | 2020-09-09 | Crockett | Tennessee | 47033 | 436 | 15 |
517542 | 517542 | 2020-09-09 | Cumberland | Tennessee | 47035 | 992 | 10 |
517543 | 517543 | 2020-09-09 | Davidson | Tennessee | 47037 | 26889 | 269 |
517544 | 517544 | 2020-09-09 | DeKalb | Tennessee | 47041 | 509 | 7 |
517545 | 517545 | 2020-09-09 | Decatur | Tennessee | 47039 | 366 | 5 |
517546 | 517546 | 2020-09-09 | Dickson | Tennessee | 47043 | 1090 | 10 |
517547 | 517547 | 2020-09-09 | Dyer | Tennessee | 47045 | 1061 | 11 |
517548 | 517548 | 2020-09-09 | Fayette | Tennessee | 47047 | 1008 | 12 |
517549 | 517549 | 2020-09-09 | Fentress | Tennessee | 47049 | 301 | 0 |
517550 | 517550 | 2020-09-09 | Franklin | Tennessee | 47051 | 653 | 5 |
517551 | 517551 | 2020-09-09 | Gibson | Tennessee | 47053 | 1256 | 18 |
517552 | 517552 | 2020-09-09 | Giles | Tennessee | 47055 | 493 | 15 |
517553 | 517553 | 2020-09-09 | Grainger | Tennessee | 47057 | 298 | 1 |
517554 | 517554 | 2020-09-09 | Greene | Tennessee | 47059 | 948 | 22 |
517555 | 517555 | 2020-09-09 | Grundy | Tennessee | 47061 | 160 | 3 |
517556 | 517556 | 2020-09-09 | Hamblen | Tennessee | 47063 | 1698 | 21 |
517557 | 517557 | 2020-09-09 | Hamilton | Tennessee | 47065 | 8640 | 82 |
517558 | 517558 | 2020-09-09 | Hancock | Tennessee | 47067 | 100 | 2 |
517559 | 517559 | 2020-09-09 | Hardeman | Tennessee | 47069 | 1288 | 24 |
517560 | 517560 | 2020-09-09 | Hardin | Tennessee | 47071 | 819 | 12 |
517561 | 517561 | 2020-09-09 | Hawkins | Tennessee | 47073 | 702 | 13 |
517562 | 517562 | 2020-09-09 | Haywood | Tennessee | 47075 | 824 | 13 |
517563 | 517563 | 2020-09-09 | Henderson | Tennessee | 47077 | 989 | 14 |
517564 | 517564 | 2020-09-09 | Henry | Tennessee | 47079 | 527 | 8 |
517565 | 517565 | 2020-09-09 | Hickman | Tennessee | 47081 | 420 | 4 |
517566 | 517566 | 2020-09-09 | Houston | Tennessee | 47083 | 119 | 0 |
517567 | 517567 | 2020-09-09 | Humphreys | Tennessee | 47085 | 187 | 3 |
517568 | 517568 | 2020-09-09 | Jackson | Tennessee | 47087 | 264 | 2 |
517569 | 517569 | 2020-09-09 | Jefferson | Tennessee | 47089 | 926 | 9 |
517570 | 517570 | 2020-09-09 | Johnson | Tennessee | 47091 | 514 | 1 |
517571 | 517571 | 2020-09-09 | Knox | Tennessee | 47093 | 8033 | 66 |
517572 | 517572 | 2020-09-09 | Lake | Tennessee | 47095 | 850 | 2 |
517573 | 517573 | 2020-09-09 | Lauderdale | Tennessee | 47097 | 831 | 14 |
517574 | 517574 | 2020-09-09 | Lawrence | Tennessee | 47099 | 808 | 11 |
517575 | 517575 | 2020-09-09 | Lewis | Tennessee | 47101 | 149 | 1 |
517576 | 517576 | 2020-09-09 | Lincoln | Tennessee | 47103 | 467 | 1 |
517577 | 517577 | 2020-09-09 | Loudon | Tennessee | 47105 | 986 | 4 |
517578 | 517578 | 2020-09-09 | Macon | Tennessee | 47111 | 952 | 18 |
517579 | 517579 | 2020-09-09 | Madison | Tennessee | 47113 | 2152 | 50 |
517580 | 517580 | 2020-09-09 | Marion | Tennessee | 47115 | 400 | 7 |
517581 | 517581 | 2020-09-09 | Marshall | Tennessee | 47117 | 601 | 4 |
517582 | 517582 | 2020-09-09 | Maury | Tennessee | 47119 | 1902 | 18 |
517583 | 517583 | 2020-09-09 | McMinn | Tennessee | 47107 | 894 | 24 |
517584 | 517584 | 2020-09-09 | McNairy | Tennessee | 47109 | 648 | 14 |
517585 | 517585 | 2020-09-09 | Meigs | Tennessee | 47121 | 186 | 3 |
517586 | 517586 | 2020-09-09 | Monroe | Tennessee | 47123 | 879 | 16 |
517587 | 517587 | 2020-09-09 | Montgomery | Tennessee | 47125 | 2661 | 35 |
517588 | 517588 | 2020-09-09 | Moore | Tennessee | 47127 | 118 | 1 |
517589 | 517589 | 2020-09-09 | Morgan | Tennessee | 47129 | 268 | 2 |
517590 | 517590 | 2020-09-09 | Obion | Tennessee | 47131 | 940 | 8 |
517591 | 517591 | 2020-09-09 | Overton | Tennessee | 47133 | 538 | 2 |
517592 | 517592 | 2020-09-09 | Perry | Tennessee | 47135 | 123 | 0 |
517593 | 517593 | 2020-09-09 | Pickett | Tennessee | 47137 | 83 | 1 |
517594 | 517594 | 2020-09-09 | Polk | Tennessee | 47139 | 353 | 11 |
517595 | 517595 | 2020-09-09 | Putnam | Tennessee | 47141 | 2518 | 33 |
517596 | 517596 | 2020-09-09 | Rhea | Tennessee | 47143 | 698 | 5 |
517597 | 517597 | 2020-09-09 | Roane | Tennessee | 47145 | 704 | 2 |
517598 | 517598 | 2020-09-09 | Robertson | Tennessee | 47147 | 2015 | 31 |
517599 | 517599 | 2020-09-09 | Rutherford | Tennessee | 47149 | 8270 | 81 |
517600 | 517600 | 2020-09-09 | Scott | Tennessee | 47151 | 170 | 2 |
517601 | 517601 | 2020-09-09 | Sequatchie | Tennessee | 47153 | 176 | 2 |
517602 | 517602 | 2020-09-09 | Sevier | Tennessee | 47155 | 2342 | 13 |
517603 | 517603 | 2020-09-09 | Shelby | Tennessee | 47157 | 28547 | 406 |
517604 | 517604 | 2020-09-09 | Smith | Tennessee | 47159 | 587 | 9 |
517605 | 517605 | 2020-09-09 | Stewart | Tennessee | 47161 | 112 | 1 |
517606 | 517606 | 2020-09-09 | Sullivan | Tennessee | 47163 | 1896 | 27 |
517607 | 517607 | 2020-09-09 | Sumner | Tennessee | 47165 | 4318 | 88 |
517608 | 517608 | 2020-09-09 | Tipton | Tennessee | 47167 | 1572 | 15 |
517609 | 517609 | 2020-09-09 | Trousdale | Tennessee | 47169 | 1631 | 7 |
517610 | 517610 | 2020-09-09 | Unicoi | Tennessee | 47171 | 244 | 1 |
517611 | 517611 | 2020-09-09 | Union | Tennessee | 47173 | 250 | 1 |
517612 | 517612 | 2020-09-09 | Unknown | Tennessee | 472 | 5 | |
517613 | 517613 | 2020-09-09 | Van Buren | Tennessee | 47175 | 114 | 0 |
517614 | 517614 | 2020-09-09 | Warren | Tennessee | 47177 | 914 | 7 |
517615 | 517615 | 2020-09-09 | Washington | Tennessee | 47179 | 1876 | 16 |
517616 | 517616 | 2020-09-09 | Wayne | Tennessee | 47181 | 1460 | 4 |
517617 | 517617 | 2020-09-09 | Weakley | Tennessee | 47183 | 977 | 14 |
517618 | 517618 | 2020-09-09 | White | Tennessee | 47185 | 629 | 7 |
517619 | 517619 | 2020-09-09 | Williamson | Tennessee | 47187 | 4609 | 32 |
517620 | 517620 | 2020-09-09 | Wilson | Tennessee | 47189 | 3074 | 31 |
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);