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-10-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
653639 | 653639 | 2020-10-21 | Anderson | Tennessee | 47001 | 1596 | 13 |
653640 | 653640 | 2020-10-21 | Bedford | Tennessee | 47003 | 1606 | 20 |
653641 | 653641 | 2020-10-21 | Benton | Tennessee | 47005 | 396 | 9 |
653642 | 653642 | 2020-10-21 | Bledsoe | Tennessee | 47007 | 994 | 4 |
653643 | 653643 | 2020-10-21 | Blount | Tennessee | 47009 | 3170 | 32 |
653644 | 653644 | 2020-10-21 | Bradley | Tennessee | 47011 | 3447 | 22 |
653645 | 653645 | 2020-10-21 | Campbell | Tennessee | 47013 | 899 | 7 |
653646 | 653646 | 2020-10-21 | Cannon | Tennessee | 47015 | 390 | 2 |
653647 | 653647 | 2020-10-21 | Carroll | Tennessee | 47017 | 1107 | 24 |
653648 | 653648 | 2020-10-21 | Carter | Tennessee | 47019 | 1439 | 32 |
653649 | 653649 | 2020-10-21 | Cheatham | Tennessee | 47021 | 982 | 11 |
653650 | 653650 | 2020-10-21 | Chester | Tennessee | 47023 | 715 | 14 |
653651 | 653651 | 2020-10-21 | Claiborne | Tennessee | 47025 | 506 | 6 |
653652 | 653652 | 2020-10-21 | Clay | Tennessee | 47027 | 379 | 13 |
653653 | 653653 | 2020-10-21 | Cocke | Tennessee | 47029 | 952 | 12 |
653654 | 653654 | 2020-10-21 | Coffee | Tennessee | 47031 | 1783 | 20 |
653655 | 653655 | 2020-10-21 | Crockett | Tennessee | 47033 | 802 | 21 |
653656 | 653656 | 2020-10-21 | Cumberland | Tennessee | 47035 | 1536 | 24 |
653657 | 653657 | 2020-10-21 | Davidson | Tennessee | 47037 | 32310 | 328 |
653658 | 653658 | 2020-10-21 | DeKalb | Tennessee | 47041 | 686 | 16 |
653659 | 653659 | 2020-10-21 | Decatur | Tennessee | 47039 | 645 | 11 |
653660 | 653660 | 2020-10-21 | Dickson | Tennessee | 47043 | 1591 | 19 |
653661 | 653661 | 2020-10-21 | Dyer | Tennessee | 47045 | 2071 | 26 |
653662 | 653662 | 2020-10-21 | Fayette | Tennessee | 47047 | 1596 | 22 |
653663 | 653663 | 2020-10-21 | Fentress | Tennessee | 47049 | 869 | 8 |
653664 | 653664 | 2020-10-21 | Franklin | Tennessee | 47051 | 1234 | 16 |
653665 | 653665 | 2020-10-21 | Gibson | Tennessee | 47053 | 2078 | 38 |
653666 | 653666 | 2020-10-21 | Giles | Tennessee | 47055 | 911 | 34 |
653667 | 653667 | 2020-10-21 | Grainger | Tennessee | 47057 | 546 | 4 |
653668 | 653668 | 2020-10-21 | Greene | Tennessee | 47059 | 1575 | 51 |
653669 | 653669 | 2020-10-21 | Grundy | Tennessee | 47061 | 525 | 10 |
653670 | 653670 | 2020-10-21 | Hamblen | Tennessee | 47063 | 2365 | 43 |
653671 | 653671 | 2020-10-21 | Hamilton | Tennessee | 47065 | 11497 | 106 |
653672 | 653672 | 2020-10-21 | Hancock | Tennessee | 47067 | 112 | 3 |
653673 | 653673 | 2020-10-21 | Hardeman | Tennessee | 47069 | 1804 | 32 |
653674 | 653674 | 2020-10-21 | Hardin | Tennessee | 47071 | 1336 | 19 |
653675 | 653675 | 2020-10-21 | Hawkins | Tennessee | 47073 | 1117 | 24 |
653676 | 653676 | 2020-10-21 | Haywood | Tennessee | 47075 | 1200 | 26 |
653677 | 653677 | 2020-10-21 | Henderson | Tennessee | 47077 | 1373 | 25 |
653678 | 653678 | 2020-10-21 | Henry | Tennessee | 47079 | 753 | 10 |
653679 | 653679 | 2020-10-21 | Hickman | Tennessee | 47081 | 745 | 13 |
653680 | 653680 | 2020-10-21 | Houston | Tennessee | 47083 | 392 | 15 |
653681 | 653681 | 2020-10-21 | Humphreys | Tennessee | 47085 | 419 | 4 |
653682 | 653682 | 2020-10-21 | Jackson | Tennessee | 47087 | 422 | 5 |
653683 | 653683 | 2020-10-21 | Jefferson | Tennessee | 47089 | 1483 | 20 |
653684 | 653684 | 2020-10-21 | Johnson | Tennessee | 47091 | 1115 | 7 |
653685 | 653685 | 2020-10-21 | Knox | Tennessee | 47093 | 12492 | 97 |
653686 | 653686 | 2020-10-21 | Lake | Tennessee | 47095 | 976 | 3 |
653687 | 653687 | 2020-10-21 | Lauderdale | Tennessee | 47097 | 1345 | 17 |
653688 | 653688 | 2020-10-21 | Lawrence | Tennessee | 47099 | 1505 | 18 |
653689 | 653689 | 2020-10-21 | Lewis | Tennessee | 47101 | 358 | 2 |
653690 | 653690 | 2020-10-21 | Lincoln | Tennessee | 47103 | 830 | 2 |
653691 | 653691 | 2020-10-21 | Loudon | Tennessee | 47105 | 1566 | 10 |
653692 | 653692 | 2020-10-21 | Macon | Tennessee | 47111 | 1269 | 24 |
653693 | 653693 | 2020-10-21 | Madison | Tennessee | 47113 | 3665 | 79 |
653694 | 653694 | 2020-10-21 | Marion | Tennessee | 47115 | 715 | 9 |
653695 | 653695 | 2020-10-21 | Marshall | Tennessee | 47117 | 1063 | 8 |
653696 | 653696 | 2020-10-21 | Maury | Tennessee | 47119 | 3112 | 36 |
653697 | 653697 | 2020-10-21 | McMinn | Tennessee | 47107 | 1542 | 32 |
653698 | 653698 | 2020-10-21 | McNairy | Tennessee | 47109 | 1096 | 26 |
653699 | 653699 | 2020-10-21 | Meigs | Tennessee | 47121 | 297 | 5 |
653700 | 653700 | 2020-10-21 | Monroe | Tennessee | 47123 | 1382 | 27 |
653701 | 653701 | 2020-10-21 | Montgomery | Tennessee | 47125 | 3933 | 51 |
653702 | 653702 | 2020-10-21 | Moore | Tennessee | 47127 | 249 | 2 |
653703 | 653703 | 2020-10-21 | Morgan | Tennessee | 47129 | 416 | 7 |
653704 | 653704 | 2020-10-21 | Obion | Tennessee | 47131 | 1664 | 20 |
653705 | 653705 | 2020-10-21 | Overton | Tennessee | 47133 | 1152 | 11 |
653706 | 653706 | 2020-10-21 | Perry | Tennessee | 47135 | 253 | 1 |
653707 | 653707 | 2020-10-21 | Pickett | Tennessee | 47137 | 250 | 5 |
653708 | 653708 | 2020-10-21 | Polk | Tennessee | 47139 | 476 | 13 |
653709 | 653709 | 2020-10-21 | Putnam | Tennessee | 47141 | 4230 | 54 |
653710 | 653710 | 2020-10-21 | Rhea | Tennessee | 47143 | 1059 | 16 |
653711 | 653711 | 2020-10-21 | Roane | Tennessee | 47145 | 1224 | 7 |
653712 | 653712 | 2020-10-21 | Robertson | Tennessee | 47147 | 2510 | 40 |
653713 | 653713 | 2020-10-21 | Rutherford | Tennessee | 47149 | 11165 | 107 |
653714 | 653714 | 2020-10-21 | Scott | Tennessee | 47151 | 344 | 4 |
653715 | 653715 | 2020-10-21 | Sequatchie | Tennessee | 47153 | 330 | 4 |
653716 | 653716 | 2020-10-21 | Sevier | Tennessee | 47155 | 3224 | 21 |
653717 | 653717 | 2020-10-21 | Shelby | Tennessee | 47157 | 35077 | 556 |
653718 | 653718 | 2020-10-21 | Smith | Tennessee | 47159 | 954 | 12 |
653719 | 653719 | 2020-10-21 | Stewart | Tennessee | 47161 | 312 | 8 |
653720 | 653720 | 2020-10-21 | Sullivan | Tennessee | 47163 | 3321 | 46 |
653721 | 653721 | 2020-10-21 | Sumner | Tennessee | 47165 | 5715 | 107 |
653722 | 653722 | 2020-10-21 | Tipton | Tennessee | 47167 | 2235 | 22 |
653723 | 653723 | 2020-10-21 | Trousdale | Tennessee | 47169 | 1744 | 7 |
653724 | 653724 | 2020-10-21 | Unicoi | Tennessee | 47171 | 373 | 2 |
653725 | 653725 | 2020-10-21 | Union | Tennessee | 47173 | 514 | 2 |
653726 | 653726 | 2020-10-21 | Unknown | Tennessee | 643 | 0 | |
653727 | 653727 | 2020-10-21 | Van Buren | Tennessee | 47175 | 195 | 1 |
653728 | 653728 | 2020-10-21 | Warren | Tennessee | 47177 | 1368 | 10 |
653729 | 653729 | 2020-10-21 | Washington | Tennessee | 47179 | 3182 | 44 |
653730 | 653730 | 2020-10-21 | Wayne | Tennessee | 47181 | 1569 | 7 |
653731 | 653731 | 2020-10-21 | Weakley | Tennessee | 47183 | 1453 | 25 |
653732 | 653732 | 2020-10-21 | White | Tennessee | 47185 | 1122 | 14 |
653733 | 653733 | 2020-10-21 | Williamson | Tennessee | 47187 | 6707 | 51 |
653734 | 653734 | 2020-10-21 | Wilson | Tennessee | 47189 | 4455 | 53 |
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);