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-17 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
640656 | 640656 | 2020-10-17 | Anderson | Tennessee | 47001 | 1526 | 13 |
640657 | 640657 | 2020-10-17 | Bedford | Tennessee | 47003 | 1562 | 20 |
640658 | 640658 | 2020-10-17 | Benton | Tennessee | 47005 | 379 | 9 |
640659 | 640659 | 2020-10-17 | Bledsoe | Tennessee | 47007 | 913 | 4 |
640660 | 640660 | 2020-10-17 | Blount | Tennessee | 47009 | 3041 | 31 |
640661 | 640661 | 2020-10-17 | Bradley | Tennessee | 47011 | 3341 | 21 |
640662 | 640662 | 2020-10-17 | Campbell | Tennessee | 47013 | 824 | 6 |
640663 | 640663 | 2020-10-17 | Cannon | Tennessee | 47015 | 375 | 2 |
640664 | 640664 | 2020-10-17 | Carroll | Tennessee | 47017 | 1076 | 24 |
640665 | 640665 | 2020-10-17 | Carter | Tennessee | 47019 | 1388 | 32 |
640666 | 640666 | 2020-10-17 | Cheatham | Tennessee | 47021 | 942 | 11 |
640667 | 640667 | 2020-10-17 | Chester | Tennessee | 47023 | 708 | 14 |
640668 | 640668 | 2020-10-17 | Claiborne | Tennessee | 47025 | 489 | 6 |
640669 | 640669 | 2020-10-17 | Clay | Tennessee | 47027 | 355 | 9 |
640670 | 640670 | 2020-10-17 | Cocke | Tennessee | 47029 | 895 | 12 |
640671 | 640671 | 2020-10-17 | Coffee | Tennessee | 47031 | 1696 | 20 |
640672 | 640672 | 2020-10-17 | Crockett | Tennessee | 47033 | 735 | 20 |
640673 | 640673 | 2020-10-17 | Cumberland | Tennessee | 47035 | 1467 | 24 |
640674 | 640674 | 2020-10-17 | Davidson | Tennessee | 47037 | 31200 | 325 |
640675 | 640675 | 2020-10-17 | DeKalb | Tennessee | 47041 | 661 | 16 |
640676 | 640676 | 2020-10-17 | Decatur | Tennessee | 47039 | 612 | 11 |
640677 | 640677 | 2020-10-17 | Dickson | Tennessee | 47043 | 1519 | 18 |
640678 | 640678 | 2020-10-17 | Dyer | Tennessee | 47045 | 1909 | 26 |
640679 | 640679 | 2020-10-17 | Fayette | Tennessee | 47047 | 1479 | 21 |
640680 | 640680 | 2020-10-17 | Fentress | Tennessee | 47049 | 828 | 7 |
640681 | 640681 | 2020-10-17 | Franklin | Tennessee | 47051 | 1181 | 15 |
640682 | 640682 | 2020-10-17 | Gibson | Tennessee | 47053 | 2018 | 37 |
640683 | 640683 | 2020-10-17 | Giles | Tennessee | 47055 | 869 | 31 |
640684 | 640684 | 2020-10-17 | Grainger | Tennessee | 47057 | 517 | 4 |
640685 | 640685 | 2020-10-17 | Greene | Tennessee | 47059 | 1464 | 48 |
640686 | 640686 | 2020-10-17 | Grundy | Tennessee | 47061 | 498 | 8 |
640687 | 640687 | 2020-10-17 | Hamblen | Tennessee | 47063 | 2292 | 43 |
640688 | 640688 | 2020-10-17 | Hamilton | Tennessee | 47065 | 11136 | 104 |
640689 | 640689 | 2020-10-17 | Hancock | Tennessee | 47067 | 113 | 3 |
640690 | 640690 | 2020-10-17 | Hardeman | Tennessee | 47069 | 1753 | 32 |
640691 | 640691 | 2020-10-17 | Hardin | Tennessee | 47071 | 1278 | 19 |
640692 | 640692 | 2020-10-17 | Hawkins | Tennessee | 47073 | 1057 | 23 |
640693 | 640693 | 2020-10-17 | Haywood | Tennessee | 47075 | 1179 | 25 |
640694 | 640694 | 2020-10-17 | Henderson | Tennessee | 47077 | 1341 | 25 |
640695 | 640695 | 2020-10-17 | Henry | Tennessee | 47079 | 723 | 10 |
640696 | 640696 | 2020-10-17 | Hickman | Tennessee | 47081 | 720 | 13 |
640697 | 640697 | 2020-10-17 | Houston | Tennessee | 47083 | 375 | 14 |
640698 | 640698 | 2020-10-17 | Humphreys | Tennessee | 47085 | 388 | 4 |
640699 | 640699 | 2020-10-17 | Jackson | Tennessee | 47087 | 413 | 5 |
640700 | 640700 | 2020-10-17 | Jefferson | Tennessee | 47089 | 1425 | 18 |
640701 | 640701 | 2020-10-17 | Johnson | Tennessee | 47091 | 1066 | 6 |
640702 | 640702 | 2020-10-17 | Knox | Tennessee | 47093 | 12029 | 93 |
640703 | 640703 | 2020-10-17 | Lake | Tennessee | 47095 | 957 | 3 |
640704 | 640704 | 2020-10-17 | Lauderdale | Tennessee | 47097 | 1254 | 18 |
640705 | 640705 | 2020-10-17 | Lawrence | Tennessee | 47099 | 1405 | 17 |
640706 | 640706 | 2020-10-17 | Lewis | Tennessee | 47101 | 323 | 2 |
640707 | 640707 | 2020-10-17 | Lincoln | Tennessee | 47103 | 781 | 2 |
640708 | 640708 | 2020-10-17 | Loudon | Tennessee | 47105 | 1513 | 10 |
640709 | 640709 | 2020-10-17 | Macon | Tennessee | 47111 | 1252 | 24 |
640710 | 640710 | 2020-10-17 | Madison | Tennessee | 47113 | 3571 | 78 |
640711 | 640711 | 2020-10-17 | Marion | Tennessee | 47115 | 670 | 9 |
640712 | 640712 | 2020-10-17 | Marshall | Tennessee | 47117 | 1012 | 8 |
640713 | 640713 | 2020-10-17 | Maury | Tennessee | 47119 | 2910 | 35 |
640714 | 640714 | 2020-10-17 | McMinn | Tennessee | 47107 | 1448 | 32 |
640715 | 640715 | 2020-10-17 | McNairy | Tennessee | 47109 | 1067 | 25 |
640716 | 640716 | 2020-10-17 | Meigs | Tennessee | 47121 | 276 | 4 |
640717 | 640717 | 2020-10-17 | Monroe | Tennessee | 47123 | 1283 | 23 |
640718 | 640718 | 2020-10-17 | Montgomery | Tennessee | 47125 | 3740 | 51 |
640719 | 640719 | 2020-10-17 | Moore | Tennessee | 47127 | 239 | 2 |
640720 | 640720 | 2020-10-17 | Morgan | Tennessee | 47129 | 399 | 6 |
640721 | 640721 | 2020-10-17 | Obion | Tennessee | 47131 | 1611 | 17 |
640722 | 640722 | 2020-10-17 | Overton | Tennessee | 47133 | 1094 | 11 |
640723 | 640723 | 2020-10-17 | Perry | Tennessee | 47135 | 190 | 1 |
640724 | 640724 | 2020-10-17 | Pickett | Tennessee | 47137 | 229 | 5 |
640725 | 640725 | 2020-10-17 | Polk | Tennessee | 47139 | 458 | 13 |
640726 | 640726 | 2020-10-17 | Putnam | Tennessee | 47141 | 4009 | 52 |
640727 | 640727 | 2020-10-17 | Rhea | Tennessee | 47143 | 1014 | 16 |
640728 | 640728 | 2020-10-17 | Roane | Tennessee | 47145 | 1146 | 6 |
640729 | 640729 | 2020-10-17 | Robertson | Tennessee | 47147 | 2450 | 39 |
640730 | 640730 | 2020-10-17 | Rutherford | Tennessee | 47149 | 10770 | 106 |
640731 | 640731 | 2020-10-17 | Scott | Tennessee | 47151 | 311 | 4 |
640732 | 640732 | 2020-10-17 | Sequatchie | Tennessee | 47153 | 314 | 4 |
640733 | 640733 | 2020-10-17 | Sevier | Tennessee | 47155 | 3109 | 20 |
640734 | 640734 | 2020-10-17 | Shelby | Tennessee | 47157 | 34009 | 549 |
640735 | 640735 | 2020-10-17 | Smith | Tennessee | 47159 | 920 | 13 |
640736 | 640736 | 2020-10-17 | Stewart | Tennessee | 47161 | 301 | 7 |
640737 | 640737 | 2020-10-17 | Sullivan | Tennessee | 47163 | 3072 | 44 |
640738 | 640738 | 2020-10-17 | Sumner | Tennessee | 47165 | 5486 | 106 |
640739 | 640739 | 2020-10-17 | Tipton | Tennessee | 47167 | 2151 | 22 |
640740 | 640740 | 2020-10-17 | Trousdale | Tennessee | 47169 | 1720 | 7 |
640741 | 640741 | 2020-10-17 | Unicoi | Tennessee | 47171 | 340 | 1 |
640742 | 640742 | 2020-10-17 | Union | Tennessee | 47173 | 487 | 2 |
640743 | 640743 | 2020-10-17 | Unknown | Tennessee | 503 | 0 | |
640744 | 640744 | 2020-10-17 | Van Buren | Tennessee | 47175 | 190 | 1 |
640745 | 640745 | 2020-10-17 | Warren | Tennessee | 47177 | 1293 | 9 |
640746 | 640746 | 2020-10-17 | Washington | Tennessee | 47179 | 2933 | 42 |
640747 | 640747 | 2020-10-17 | Wayne | Tennessee | 47181 | 1552 | 7 |
640748 | 640748 | 2020-10-17 | Weakley | Tennessee | 47183 | 1416 | 25 |
640749 | 640749 | 2020-10-17 | White | Tennessee | 47185 | 1047 | 14 |
640750 | 640750 | 2020-10-17 | Williamson | Tennessee | 47187 | 6374 | 48 |
640751 | 640751 | 2020-10-17 | Wilson | Tennessee | 47189 | 4254 | 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);