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-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
945681 | 945681 | 2021-01-19 | Anderson | Tennessee | 47001 | 6818 | 104 |
945682 | 945682 | 2021-01-19 | Bedford | Tennessee | 47003 | 5328 | 89 |
945683 | 945683 | 2021-01-19 | Benton | Tennessee | 47005 | 1324 | 35 |
945684 | 945684 | 2021-01-19 | Bledsoe | Tennessee | 47007 | 1749 | 10 |
945685 | 945685 | 2021-01-19 | Blount | Tennessee | 47009 | 12029 | 126 |
945686 | 945686 | 2021-01-19 | Bradley | Tennessee | 47011 | 10838 | 91 |
945687 | 945687 | 2021-01-19 | Campbell | Tennessee | 47013 | 3258 | 40 |
945688 | 945688 | 2021-01-19 | Cannon | Tennessee | 47015 | 1581 | 19 |
945689 | 945689 | 2021-01-19 | Carroll | Tennessee | 47017 | 3127 | 59 |
945690 | 945690 | 2021-01-19 | Carter | Tennessee | 47019 | 5115 | 114 |
945691 | 945691 | 2021-01-19 | Cheatham | Tennessee | 47021 | 3381 | 30 |
945692 | 945692 | 2021-01-19 | Chester | Tennessee | 47023 | 1748 | 37 |
945693 | 945693 | 2021-01-19 | Claiborne | Tennessee | 47025 | 2159 | 29 |
945694 | 945694 | 2021-01-19 | Clay | Tennessee | 47027 | 940 | 26 |
945695 | 945695 | 2021-01-19 | Cocke | Tennessee | 47029 | 3456 | 56 |
945696 | 945696 | 2021-01-19 | Coffee | Tennessee | 47031 | 5648 | 82 |
945697 | 945697 | 2021-01-19 | Crockett | Tennessee | 47033 | 1809 | 38 |
945698 | 945698 | 2021-01-19 | Cumberland | Tennessee | 47035 | 5421 | 73 |
945699 | 945699 | 2021-01-19 | Davidson | Tennessee | 47037 | 80415 | 672 |
945700 | 945700 | 2021-01-19 | DeKalb | Tennessee | 47041 | 2427 | 41 |
945701 | 945701 | 2021-01-19 | Decatur | Tennessee | 47039 | 1477 | 26 |
945702 | 945702 | 2021-01-19 | Dickson | Tennessee | 47043 | 5404 | 79 |
945703 | 945703 | 2021-01-19 | Dyer | Tennessee | 47045 | 4772 | 82 |
945704 | 945704 | 2021-01-19 | Fayette | Tennessee | 47047 | 3993 | 51 |
945705 | 945705 | 2021-01-19 | Fentress | Tennessee | 47049 | 2132 | 31 |
945706 | 945706 | 2021-01-19 | Franklin | Tennessee | 47051 | 4130 | 62 |
945707 | 945707 | 2021-01-19 | Gibson | Tennessee | 47053 | 5656 | 111 |
945708 | 945708 | 2021-01-19 | Giles | Tennessee | 47055 | 3230 | 72 |
945709 | 945709 | 2021-01-19 | Grainger | Tennessee | 47057 | 2096 | 36 |
945710 | 945710 | 2021-01-19 | Greene | Tennessee | 47059 | 6615 | 108 |
945711 | 945711 | 2021-01-19 | Grundy | Tennessee | 47061 | 1393 | 21 |
945712 | 945712 | 2021-01-19 | Hamblen | Tennessee | 47063 | 7018 | 109 |
945713 | 945713 | 2021-01-19 | Hamilton | Tennessee | 47065 | 36233 | 330 |
945714 | 945714 | 2021-01-19 | Hancock | Tennessee | 47067 | 405 | 6 |
945715 | 945715 | 2021-01-19 | Hardeman | Tennessee | 47069 | 3104 | 52 |
945716 | 945716 | 2021-01-19 | Hardin | Tennessee | 47071 | 2989 | 47 |
945717 | 945717 | 2021-01-19 | Hawkins | Tennessee | 47073 | 4481 | 70 |
945718 | 945718 | 2021-01-19 | Haywood | Tennessee | 47075 | 2406 | 45 |
945719 | 945719 | 2021-01-19 | Henderson | Tennessee | 47077 | 3338 | 57 |
945720 | 945720 | 2021-01-19 | Henry | Tennessee | 47079 | 2619 | 58 |
945721 | 945721 | 2021-01-19 | Hickman | Tennessee | 47081 | 2249 | 34 |
945722 | 945722 | 2021-01-19 | Houston | Tennessee | 47083 | 939 | 22 |
945723 | 945723 | 2021-01-19 | Humphreys | Tennessee | 47085 | 1335 | 17 |
945724 | 945724 | 2021-01-19 | Jackson | Tennessee | 47087 | 1043 | 22 |
945725 | 945725 | 2021-01-19 | Jefferson | Tennessee | 47089 | 4808 | 75 |
945726 | 945726 | 2021-01-19 | Johnson | Tennessee | 47091 | 2022 | 32 |
945727 | 945727 | 2021-01-19 | Knox | Tennessee | 47093 | 40335 | 409 |
945728 | 945728 | 2021-01-19 | Lake | Tennessee | 47095 | 1560 | 19 |
945729 | 945729 | 2021-01-19 | Lauderdale | Tennessee | 47097 | 2943 | 31 |
945730 | 945730 | 2021-01-19 | Lawrence | Tennessee | 47099 | 5114 | 69 |
945731 | 945731 | 2021-01-19 | Lewis | Tennessee | 47101 | 1277 | 20 |
945732 | 945732 | 2021-01-19 | Lincoln | Tennessee | 47103 | 3798 | 44 |
945733 | 945733 | 2021-01-19 | Loudon | Tennessee | 47105 | 4974 | 50 |
945734 | 945734 | 2021-01-19 | Macon | Tennessee | 47111 | 2893 | 50 |
945735 | 945735 | 2021-01-19 | Madison | Tennessee | 47113 | 9163 | 179 |
945736 | 945736 | 2021-01-19 | Marion | Tennessee | 47115 | 2292 | 31 |
945737 | 945737 | 2021-01-19 | Marshall | Tennessee | 47117 | 3463 | 36 |
945738 | 945738 | 2021-01-19 | Maury | Tennessee | 47119 | 11003 | 123 |
945739 | 945739 | 2021-01-19 | McMinn | Tennessee | 47107 | 5100 | 73 |
945740 | 945740 | 2021-01-19 | McNairy | Tennessee | 47109 | 2410 | 42 |
945741 | 945741 | 2021-01-19 | Meigs | Tennessee | 47121 | 1149 | 16 |
945742 | 945742 | 2021-01-19 | Monroe | Tennessee | 47123 | 4594 | 62 |
945743 | 945743 | 2021-01-19 | Montgomery | Tennessee | 47125 | 14507 | 149 |
945744 | 945744 | 2021-01-19 | Moore | Tennessee | 47127 | 808 | 9 |
945745 | 945745 | 2021-01-19 | Morgan | Tennessee | 47129 | 1898 | 15 |
945746 | 945746 | 2021-01-19 | Obion | Tennessee | 47131 | 4005 | 80 |
945747 | 945747 | 2021-01-19 | Overton | Tennessee | 47133 | 2546 | 43 |
945748 | 945748 | 2021-01-19 | Perry | Tennessee | 47135 | 948 | 25 |
945749 | 945749 | 2021-01-19 | Pickett | Tennessee | 47137 | 680 | 20 |
945750 | 945750 | 2021-01-19 | Polk | Tennessee | 47139 | 1438 | 17 |
945751 | 945751 | 2021-01-19 | Putnam | Tennessee | 47141 | 9968 | 140 |
945752 | 945752 | 2021-01-19 | Rhea | Tennessee | 47143 | 3828 | 56 |
945753 | 945753 | 2021-01-19 | Roane | Tennessee | 47145 | 5229 | 79 |
945754 | 945754 | 2021-01-19 | Robertson | Tennessee | 47147 | 7666 | 85 |
945755 | 945755 | 2021-01-19 | Rutherford | Tennessee | 47149 | 33298 | 287 |
945756 | 945756 | 2021-01-19 | Scott | Tennessee | 47151 | 2262 | 31 |
945757 | 945757 | 2021-01-19 | Sequatchie | Tennessee | 47153 | 1376 | 18 |
945758 | 945758 | 2021-01-19 | Sevier | Tennessee | 47155 | 10534 | 108 |
945759 | 945759 | 2021-01-19 | Shelby | Tennessee | 47157 | 78619 | 1140 |
945760 | 945760 | 2021-01-19 | Smith | Tennessee | 47159 | 2317 | 27 |
945761 | 945761 | 2021-01-19 | Stewart | Tennessee | 47161 | 1058 | 20 |
945762 | 945762 | 2021-01-19 | Sullivan | Tennessee | 47163 | 12634 | 211 |
945763 | 945763 | 2021-01-19 | Sumner | Tennessee | 47165 | 18322 | 232 |
945764 | 945764 | 2021-01-19 | Tipton | Tennessee | 47167 | 6226 | 65 |
945765 | 945765 | 2021-01-19 | Trousdale | Tennessee | 47169 | 2289 | 14 |
945766 | 945766 | 2021-01-19 | Unicoi | Tennessee | 47171 | 1679 | 44 |
945767 | 945767 | 2021-01-19 | Union | Tennessee | 47173 | 1399 | 23 |
945768 | 945768 | 2021-01-19 | Unknown | Tennessee | 12584 | 113 | |
945769 | 945769 | 2021-01-19 | Van Buren | Tennessee | 47175 | 663 | 7 |
945770 | 945770 | 2021-01-19 | Warren | Tennessee | 47177 | 5000 | 53 |
945771 | 945771 | 2021-01-19 | Washington | Tennessee | 47179 | 11949 | 192 |
945772 | 945772 | 2021-01-19 | Wayne | Tennessee | 47181 | 2622 | 19 |
945773 | 945773 | 2021-01-19 | Weakley | Tennessee | 47183 | 3412 | 48 |
945774 | 945774 | 2021-01-19 | White | Tennessee | 47185 | 3117 | 43 |
945775 | 945775 | 2021-01-19 | Williamson | Tennessee | 47187 | 21507 | 140 |
945776 | 945776 | 2021-01-19 | Wilson | Tennessee | 47189 | 14511 | 158 |
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);