ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-10-05" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599915 | 599915 | 2020-10-05 | Adams | Indiana | 18001 | 306 | 5 |
599916 | 599916 | 2020-10-05 | Allen | Indiana | 18003 | 6692 | 219 |
599917 | 599917 | 2020-10-05 | Bartholomew | Indiana | 18005 | 1243 | 61 |
599918 | 599918 | 2020-10-05 | Benton | Indiana | 18007 | 90 | 0 |
599919 | 599919 | 2020-10-05 | Blackford | Indiana | 18009 | 149 | 3 |
599920 | 599920 | 2020-10-05 | Boone | Indiana | 18011 | 1064 | 49 |
599921 | 599921 | 2020-10-05 | Brown | Indiana | 18013 | 105 | 3 |
599922 | 599922 | 2020-10-05 | Carroll | Indiana | 18015 | 289 | 13 |
599923 | 599923 | 2020-10-05 | Cass | Indiana | 18017 | 2022 | 11 |
599924 | 599924 | 2020-10-05 | Clark | Indiana | 18019 | 2418 | 64 |
599925 | 599925 | 2020-10-05 | Clay | Indiana | 18021 | 334 | 5 |
599926 | 599926 | 2020-10-05 | Clinton | Indiana | 18023 | 696 | 18 |
599927 | 599927 | 2020-10-05 | Crawford | Indiana | 18025 | 123 | 2 |
599928 | 599928 | 2020-10-05 | Daviess | Indiana | 18027 | 719 | 32 |
599929 | 599929 | 2020-10-05 | DeKalb | Indiana | 18033 | 533 | 12 |
599930 | 599930 | 2020-10-05 | Dearborn | Indiana | 18029 | 723 | 30 |
599931 | 599931 | 2020-10-05 | Decatur | Indiana | 18031 | 493 | 42 |
599932 | 599932 | 2020-10-05 | Delaware | Indiana | 18035 | 2179 | 67 |
599933 | 599933 | 2020-10-05 | Dubois | Indiana | 18037 | 1078 | 19 |
599934 | 599934 | 2020-10-05 | Elkhart | Indiana | 18039 | 7134 | 120 |
599935 | 599935 | 2020-10-05 | Fayette | Indiana | 18041 | 545 | 14 |
599936 | 599936 | 2020-10-05 | Floyd | Indiana | 18043 | 1496 | 67 |
599937 | 599937 | 2020-10-05 | Fountain | Indiana | 18045 | 140 | 2 |
599938 | 599938 | 2020-10-05 | Franklin | Indiana | 18047 | 329 | 26 |
599939 | 599939 | 2020-10-05 | Fulton | Indiana | 18049 | 265 | 2 |
599940 | 599940 | 2020-10-05 | Gibson | Indiana | 18051 | 625 | 6 |
599941 | 599941 | 2020-10-05 | Grant | Indiana | 18053 | 1376 | 40 |
599942 | 599942 | 2020-10-05 | Greene | Indiana | 18055 | 446 | 39 |
599943 | 599943 | 2020-10-05 | Hamilton | Indiana | 18057 | 5257 | 119 |
599944 | 599944 | 2020-10-05 | Hancock | Indiana | 18059 | 990 | 46 |
599945 | 599945 | 2020-10-05 | Harrison | Indiana | 18061 | 639 | 26 |
599946 | 599946 | 2020-10-05 | Hendricks | Indiana | 18063 | 2881 | 144 |
599947 | 599947 | 2020-10-05 | Henry | Indiana | 18065 | 936 | 27 |
599948 | 599948 | 2020-10-05 | Howard | Indiana | 18067 | 1425 | 67 |
599949 | 599949 | 2020-10-05 | Huntington | Indiana | 18069 | 293 | 3 |
599950 | 599950 | 2020-10-05 | Jackson | Indiana | 18071 | 835 | 11 |
599951 | 599951 | 2020-10-05 | Jasper | Indiana | 18073 | 420 | 4 |
599952 | 599952 | 2020-10-05 | Jay | Indiana | 18075 | 229 | 1 |
599953 | 599953 | 2020-10-05 | Jefferson | Indiana | 18077 | 269 | 3 |
599954 | 599954 | 2020-10-05 | Jennings | Indiana | 18079 | 330 | 15 |
599955 | 599955 | 2020-10-05 | Johnson | Indiana | 18081 | 2526 | 133 |
599956 | 599956 | 2020-10-05 | Knox | Indiana | 18083 | 580 | 10 |
599957 | 599957 | 2020-10-05 | Kosciusko | Indiana | 18085 | 1384 | 19 |
599958 | 599958 | 2020-10-05 | LaGrange | Indiana | 18087 | 669 | 11 |
599959 | 599959 | 2020-10-05 | LaPorte | Indiana | 18091 | 1691 | 43 |
599960 | 599960 | 2020-10-05 | Lake | Indiana | 18089 | 11295 | 348 |
599961 | 599961 | 2020-10-05 | Lawrence | Indiana | 18093 | 570 | 31 |
599962 | 599962 | 2020-10-05 | Madison | Indiana | 18095 | 1875 | 86 |
599963 | 599963 | 2020-10-05 | Marion | Indiana | 18097 | 22512 | 822 |
599964 | 599964 | 2020-10-05 | Marshall | Indiana | 18099 | 1072 | 25 |
599965 | 599965 | 2020-10-05 | Martin | Indiana | 18101 | 175 | 0 |
599966 | 599966 | 2020-10-05 | Miami | Indiana | 18103 | 455 | 4 |
599967 | 599967 | 2020-10-05 | Monroe | Indiana | 18105 | 2827 | 41 |
599968 | 599968 | 2020-10-05 | Montgomery | Indiana | 18107 | 515 | 23 |
599969 | 599969 | 2020-10-05 | Morgan | Indiana | 18109 | 784 | 43 |
599970 | 599970 | 2020-10-05 | Newton | Indiana | 18111 | 179 | 12 |
599971 | 599971 | 2020-10-05 | Noble | Indiana | 18113 | 959 | 33 |
599972 | 599972 | 2020-10-05 | Ohio | Indiana | 18115 | 82 | 7 |
599973 | 599973 | 2020-10-05 | Orange | Indiana | 18117 | 300 | 26 |
599974 | 599974 | 2020-10-05 | Owen | Indiana | 18119 | 178 | 2 |
599975 | 599975 | 2020-10-05 | Parke | Indiana | 18121 | 137 | 2 |
599976 | 599976 | 2020-10-05 | Perry | Indiana | 18123 | 251 | 14 |
599977 | 599977 | 2020-10-05 | Pike | Indiana | 18125 | 244 | 4 |
599978 | 599978 | 2020-10-05 | Porter | Indiana | 18127 | 2389 | 49 |
599979 | 599979 | 2020-10-05 | Posey | Indiana | 18129 | 438 | 2 |
599980 | 599980 | 2020-10-05 | Pulaski | Indiana | 18131 | 118 | 1 |
599981 | 599981 | 2020-10-05 | Putnam | Indiana | 18133 | 620 | 11 |
599982 | 599982 | 2020-10-05 | Randolph | Indiana | 18135 | 285 | 8 |
599983 | 599983 | 2020-10-05 | Ripley | Indiana | 18137 | 331 | 8 |
599984 | 599984 | 2020-10-05 | Rush | Indiana | 18139 | 206 | 4 |
599985 | 599985 | 2020-10-05 | Scott | Indiana | 18143 | 439 | 13 |
599986 | 599986 | 2020-10-05 | Shelby | Indiana | 18145 | 1192 | 37 |
599987 | 599987 | 2020-10-05 | Spencer | Indiana | 18147 | 306 | 3 |
599988 | 599988 | 2020-10-05 | St. Joseph | Indiana | 18141 | 7252 | 131 |
599989 | 599989 | 2020-10-05 | Starke | Indiana | 18149 | 291 | 8 |
599990 | 599990 | 2020-10-05 | Steuben | Indiana | 18151 | 434 | 8 |
599991 | 599991 | 2020-10-05 | Sullivan | Indiana | 18153 | 356 | 12 |
599992 | 599992 | 2020-10-05 | Switzerland | Indiana | 18155 | 73 | 0 |
599993 | 599993 | 2020-10-05 | Tippecanoe | Indiana | 18157 | 2846 | 14 |
599994 | 599994 | 2020-10-05 | Tipton | Indiana | 18159 | 247 | 26 |
599995 | 599995 | 2020-10-05 | Union | Indiana | 18161 | 107 | 0 |
599996 | 599996 | 2020-10-05 | Vanderburgh | Indiana | 18163 | 4301 | 32 |
599997 | 599997 | 2020-10-05 | Vermillion | Indiana | 18165 | 142 | 0 |
599998 | 599998 | 2020-10-05 | Vigo | Indiana | 18167 | 2022 | 29 |
599999 | 599999 | 2020-10-05 | Wabash | Indiana | 18169 | 294 | 8 |
600000 | 600000 | 2020-10-05 | Warren | Indiana | 18171 | 44 | 1 |
600001 | 600001 | 2020-10-05 | Warrick | Indiana | 18173 | 1549 | 56 |
600002 | 600002 | 2020-10-05 | Washington | Indiana | 18175 | 288 | 2 |
600003 | 600003 | 2020-10-05 | Wayne | Indiana | 18177 | 1211 | 16 |
600004 | 600004 | 2020-10-05 | Wells | Indiana | 18179 | 304 | 4 |
600005 | 600005 | 2020-10-05 | White | Indiana | 18181 | 505 | 15 |
600006 | 600006 | 2020-10-05 | Whitley | Indiana | 18183 | 319 | 7 |
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);