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-04-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 |
---|---|---|---|---|---|---|---|
1237860 | 1237860 | 2021-04-19 | Anderson | Tennessee | 47001 | 8627 | 171 |
1237861 | 1237861 | 2021-04-19 | Bedford | Tennessee | 47003 | 6426 | 129 |
1237862 | 1237862 | 2021-04-19 | Benton | Tennessee | 47005 | 1632 | 40 |
1237863 | 1237863 | 2021-04-19 | Bledsoe | Tennessee | 47007 | 2097 | 11 |
1237864 | 1237864 | 2021-04-19 | Blount | Tennessee | 47009 | 15180 | 194 |
1237865 | 1237865 | 2021-04-19 | Bradley | Tennessee | 47011 | 14599 | 147 |
1237866 | 1237866 | 2021-04-19 | Campbell | Tennessee | 47013 | 4096 | 62 |
1237867 | 1237867 | 2021-04-19 | Cannon | Tennessee | 47015 | 1889 | 31 |
1237868 | 1237868 | 2021-04-19 | Carroll | Tennessee | 47017 | 3575 | 82 |
1237869 | 1237869 | 2021-04-19 | Carter | Tennessee | 47019 | 6468 | 156 |
1237870 | 1237870 | 2021-04-19 | Cheatham | Tennessee | 47021 | 4444 | 54 |
1237871 | 1237871 | 2021-04-19 | Chester | Tennessee | 47023 | 2094 | 51 |
1237872 | 1237872 | 2021-04-19 | Claiborne | Tennessee | 47025 | 3062 | 73 |
1237873 | 1237873 | 2021-04-19 | Clay | Tennessee | 47027 | 1090 | 31 |
1237874 | 1237874 | 2021-04-19 | Cocke | Tennessee | 47029 | 4437 | 98 |
1237875 | 1237875 | 2021-04-19 | Coffee | Tennessee | 47031 | 6831 | 121 |
1237876 | 1237876 | 2021-04-19 | Crockett | Tennessee | 47033 | 2010 | 48 |
1237877 | 1237877 | 2021-04-19 | Cumberland | Tennessee | 47035 | 6568 | 127 |
1237878 | 1237878 | 2021-04-19 | Davidson | Tennessee | 47037 | 97210 | 924 |
1237879 | 1237879 | 2021-04-19 | DeKalb | Tennessee | 47041 | 2756 | 53 |
1237880 | 1237880 | 2021-04-19 | Decatur | Tennessee | 47039 | 1573 | 38 |
1237881 | 1237881 | 2021-04-19 | Dickson | Tennessee | 47043 | 6734 | 109 |
1237882 | 1237882 | 2021-04-19 | Dyer | Tennessee | 47045 | 5361 | 104 |
1237883 | 1237883 | 2021-04-19 | Fayette | Tennessee | 47047 | 4921 | 78 |
1237884 | 1237884 | 2021-04-19 | Fentress | Tennessee | 47049 | 2385 | 46 |
1237885 | 1237885 | 2021-04-19 | Franklin | Tennessee | 47051 | 5086 | 88 |
1237886 | 1237886 | 2021-04-19 | Gibson | Tennessee | 47053 | 6402 | 144 |
1237887 | 1237887 | 2021-04-19 | Giles | Tennessee | 47055 | 3953 | 99 |
1237888 | 1237888 | 2021-04-19 | Grainger | Tennessee | 47057 | 2591 | 49 |
1237889 | 1237889 | 2021-04-19 | Greene | Tennessee | 47059 | 7739 | 152 |
1237890 | 1237890 | 2021-04-19 | Grundy | Tennessee | 47061 | 1779 | 33 |
1237891 | 1237891 | 2021-04-19 | Hamblen | Tennessee | 47063 | 8498 | 171 |
1237892 | 1237892 | 2021-04-19 | Hamilton | Tennessee | 47065 | 43628 | 485 |
1237893 | 1237893 | 2021-04-19 | Hancock | Tennessee | 47067 | 549 | 12 |
1237894 | 1237894 | 2021-04-19 | Hardeman | Tennessee | 47069 | 3464 | 64 |
1237895 | 1237895 | 2021-04-19 | Hardin | Tennessee | 47071 | 3497 | 66 |
1237896 | 1237896 | 2021-04-19 | Hawkins | Tennessee | 47073 | 5781 | 106 |
1237897 | 1237897 | 2021-04-19 | Haywood | Tennessee | 47075 | 2683 | 61 |
1237898 | 1237898 | 2021-04-19 | Henderson | Tennessee | 47077 | 3729 | 75 |
1237899 | 1237899 | 2021-04-19 | Henry | Tennessee | 47079 | 3124 | 75 |
1237900 | 1237900 | 2021-04-19 | Hickman | Tennessee | 47081 | 2805 | 46 |
1237901 | 1237901 | 2021-04-19 | Houston | Tennessee | 47083 | 1085 | 33 |
1237902 | 1237902 | 2021-04-19 | Humphreys | Tennessee | 47085 | 1742 | 21 |
1237903 | 1237903 | 2021-04-19 | Jackson | Tennessee | 47087 | 1299 | 35 |
1237904 | 1237904 | 2021-04-19 | Jefferson | Tennessee | 47089 | 6073 | 121 |
1237905 | 1237905 | 2021-04-19 | Johnson | Tennessee | 47091 | 2316 | 38 |
1237906 | 1237906 | 2021-04-19 | Knox | Tennessee | 47093 | 50991 | 625 |
1237907 | 1237907 | 2021-04-19 | Lake | Tennessee | 47095 | 1695 | 26 |
1237908 | 1237908 | 2021-04-19 | Lauderdale | Tennessee | 47097 | 3144 | 44 |
1237909 | 1237909 | 2021-04-19 | Lawrence | Tennessee | 47099 | 5806 | 86 |
1237910 | 1237910 | 2021-04-19 | Lewis | Tennessee | 47101 | 1558 | 26 |
1237911 | 1237911 | 2021-04-19 | Lincoln | Tennessee | 47103 | 4306 | 63 |
1237912 | 1237912 | 2021-04-19 | Loudon | Tennessee | 47105 | 6016 | 69 |
1237913 | 1237913 | 2021-04-19 | Macon | Tennessee | 47111 | 3580 | 77 |
1237914 | 1237914 | 2021-04-19 | Madison | Tennessee | 47113 | 10789 | 241 |
1237915 | 1237915 | 2021-04-19 | Marion | Tennessee | 47115 | 3099 | 46 |
1237916 | 1237916 | 2021-04-19 | Marshall | Tennessee | 47117 | 4111 | 58 |
1237917 | 1237917 | 2021-04-19 | Maury | Tennessee | 47119 | 13211 | 169 |
1237918 | 1237918 | 2021-04-19 | McMinn | Tennessee | 47107 | 6365 | 97 |
1237919 | 1237919 | 2021-04-19 | McNairy | Tennessee | 47109 | 2768 | 54 |
1237920 | 1237920 | 2021-04-19 | Meigs | Tennessee | 47121 | 1348 | 23 |
1237921 | 1237921 | 2021-04-19 | Monroe | Tennessee | 47123 | 5709 | 95 |
1237922 | 1237922 | 2021-04-19 | Montgomery | Tennessee | 47125 | 19623 | 224 |
1237923 | 1237923 | 2021-04-19 | Moore | Tennessee | 47127 | 1000 | 17 |
1237924 | 1237924 | 2021-04-19 | Morgan | Tennessee | 47129 | 2460 | 39 |
1237925 | 1237925 | 2021-04-19 | Obion | Tennessee | 47131 | 4502 | 96 |
1237926 | 1237926 | 2021-04-19 | Overton | Tennessee | 47133 | 2969 | 61 |
1237927 | 1237927 | 2021-04-19 | Perry | Tennessee | 47135 | 1057 | 28 |
1237928 | 1237928 | 2021-04-19 | Pickett | Tennessee | 47137 | 756 | 24 |
1237929 | 1237929 | 2021-04-19 | Polk | Tennessee | 47139 | 2000 | 24 |
1237930 | 1237930 | 2021-04-19 | Putnam | Tennessee | 47141 | 11168 | 173 |
1237931 | 1237931 | 2021-04-19 | Rhea | Tennessee | 47143 | 4312 | 75 |
1237932 | 1237932 | 2021-04-19 | Roane | Tennessee | 47145 | 6191 | 102 |
1237933 | 1237933 | 2021-04-19 | Robertson | Tennessee | 47147 | 9607 | 130 |
1237934 | 1237934 | 2021-04-19 | Rutherford | Tennessee | 47149 | 42319 | 420 |
1237935 | 1237935 | 2021-04-19 | Scott | Tennessee | 47151 | 3055 | 45 |
1237936 | 1237936 | 2021-04-19 | Sequatchie | Tennessee | 47153 | 1667 | 28 |
1237937 | 1237937 | 2021-04-19 | Sevier | Tennessee | 47155 | 13166 | 175 |
1237938 | 1237938 | 2021-04-19 | Shelby | Tennessee | 47157 | 93895 | 1599 |
1237939 | 1237939 | 2021-04-19 | Smith | Tennessee | 47159 | 2748 | 38 |
1237940 | 1237940 | 2021-04-19 | Stewart | Tennessee | 47161 | 1308 | 28 |
1237941 | 1237941 | 2021-04-19 | Sullivan | Tennessee | 47163 | 16184 | 287 |
1237942 | 1237942 | 2021-04-19 | Sumner | Tennessee | 47165 | 23492 | 341 |
1237943 | 1237943 | 2021-04-19 | Tipton | Tennessee | 47167 | 7226 | 104 |
1237944 | 1237944 | 2021-04-19 | Trousdale | Tennessee | 47169 | 2490 | 22 |
1237945 | 1237945 | 2021-04-19 | Unicoi | Tennessee | 47171 | 1945 | 49 |
1237946 | 1237946 | 2021-04-19 | Union | Tennessee | 47173 | 1860 | 34 |
1237947 | 1237947 | 2021-04-19 | Unknown | Tennessee | 9094 | 119 | |
1237948 | 1237948 | 2021-04-19 | Van Buren | Tennessee | 47175 | 834 | 21 |
1237949 | 1237949 | 2021-04-19 | Warren | Tennessee | 47177 | 5513 | 81 |
1237950 | 1237950 | 2021-04-19 | Washington | Tennessee | 47179 | 14177 | 242 |
1237951 | 1237951 | 2021-04-19 | Wayne | Tennessee | 47181 | 2943 | 34 |
1237952 | 1237952 | 2021-04-19 | Weakley | Tennessee | 47183 | 4028 | 62 |
1237953 | 1237953 | 2021-04-19 | White | Tennessee | 47185 | 3548 | 68 |
1237954 | 1237954 | 2021-04-19 | Williamson | Tennessee | 47187 | 27545 | 216 |
1237955 | 1237955 | 2021-04-19 | Wilson | Tennessee | 47189 | 18472 | 229 |
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);