ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2020-10-01 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
586949 | 586949 | 2020-10-01 | Adams | Indiana | 18001 | 288 | 4 |
586950 | 586950 | 2020-10-01 | Allen | Indiana | 18003 | 6488 | 217 |
586951 | 586951 | 2020-10-01 | Bartholomew | Indiana | 18005 | 1224 | 61 |
586952 | 586952 | 2020-10-01 | Benton | Indiana | 18007 | 87 | 0 |
586953 | 586953 | 2020-10-01 | Blackford | Indiana | 18009 | 134 | 3 |
586954 | 586954 | 2020-10-01 | Boone | Indiana | 18011 | 1031 | 49 |
586955 | 586955 | 2020-10-01 | Brown | Indiana | 18013 | 103 | 3 |
586956 | 586956 | 2020-10-01 | Carroll | Indiana | 18015 | 285 | 13 |
586957 | 586957 | 2020-10-01 | Cass | Indiana | 18017 | 1987 | 10 |
586958 | 586958 | 2020-10-01 | Clark | Indiana | 18019 | 2334 | 64 |
586959 | 586959 | 2020-10-01 | Clay | Indiana | 18021 | 317 | 5 |
586960 | 586960 | 2020-10-01 | Clinton | Indiana | 18023 | 655 | 18 |
586961 | 586961 | 2020-10-01 | Crawford | Indiana | 18025 | 115 | 2 |
586962 | 586962 | 2020-10-01 | Daviess | Indiana | 18027 | 691 | 32 |
586963 | 586963 | 2020-10-01 | DeKalb | Indiana | 18033 | 504 | 12 |
586964 | 586964 | 2020-10-01 | Dearborn | Indiana | 18029 | 695 | 30 |
586965 | 586965 | 2020-10-01 | Decatur | Indiana | 18031 | 490 | 42 |
586966 | 586966 | 2020-10-01 | Delaware | Indiana | 18035 | 2069 | 64 |
586967 | 586967 | 2020-10-01 | Dubois | Indiana | 18037 | 1043 | 19 |
586968 | 586968 | 2020-10-01 | Elkhart | Indiana | 18039 | 6894 | 118 |
586969 | 586969 | 2020-10-01 | Fayette | Indiana | 18041 | 539 | 14 |
586970 | 586970 | 2020-10-01 | Floyd | Indiana | 18043 | 1439 | 67 |
586971 | 586971 | 2020-10-01 | Fountain | Indiana | 18045 | 134 | 2 |
586972 | 586972 | 2020-10-01 | Franklin | Indiana | 18047 | 326 | 26 |
586973 | 586973 | 2020-10-01 | Fulton | Indiana | 18049 | 250 | 2 |
586974 | 586974 | 2020-10-01 | Gibson | Indiana | 18051 | 575 | 6 |
586975 | 586975 | 2020-10-01 | Grant | Indiana | 18053 | 1334 | 40 |
586976 | 586976 | 2020-10-01 | Greene | Indiana | 18055 | 441 | 39 |
586977 | 586977 | 2020-10-01 | Hamilton | Indiana | 18057 | 5062 | 118 |
586978 | 586978 | 2020-10-01 | Hancock | Indiana | 18059 | 971 | 46 |
586979 | 586979 | 2020-10-01 | Harrison | Indiana | 18061 | 609 | 26 |
586980 | 586980 | 2020-10-01 | Hendricks | Indiana | 18063 | 2836 | 143 |
586981 | 586981 | 2020-10-01 | Henry | Indiana | 18065 | 856 | 27 |
586982 | 586982 | 2020-10-01 | Howard | Indiana | 18067 | 1371 | 67 |
586983 | 586983 | 2020-10-01 | Huntington | Indiana | 18069 | 263 | 3 |
586984 | 586984 | 2020-10-01 | Jackson | Indiana | 18071 | 789 | 11 |
586985 | 586985 | 2020-10-01 | Jasper | Indiana | 18073 | 408 | 3 |
586986 | 586986 | 2020-10-01 | Jay | Indiana | 18075 | 205 | 1 |
586987 | 586987 | 2020-10-01 | Jefferson | Indiana | 18077 | 255 | 3 |
586988 | 586988 | 2020-10-01 | Jennings | Indiana | 18079 | 322 | 14 |
586989 | 586989 | 2020-10-01 | Johnson | Indiana | 18081 | 2448 | 135 |
586990 | 586990 | 2020-10-01 | Knox | Indiana | 18083 | 553 | 10 |
586991 | 586991 | 2020-10-01 | Kosciusko | Indiana | 18085 | 1327 | 19 |
586992 | 586992 | 2020-10-01 | LaGrange | Indiana | 18087 | 660 | 11 |
586993 | 586993 | 2020-10-01 | LaPorte | Indiana | 18091 | 1562 | 42 |
586994 | 586994 | 2020-10-01 | Lake | Indiana | 18089 | 10931 | 345 |
586995 | 586995 | 2020-10-01 | Lawrence | Indiana | 18093 | 537 | 31 |
586996 | 586996 | 2020-10-01 | Madison | Indiana | 18095 | 1785 | 86 |
586997 | 586997 | 2020-10-01 | Marion | Indiana | 18097 | 21953 | 822 |
586998 | 586998 | 2020-10-01 | Marshall | Indiana | 18099 | 1030 | 24 |
586999 | 586999 | 2020-10-01 | Martin | Indiana | 18101 | 172 | 0 |
587000 | 587000 | 2020-10-01 | Miami | Indiana | 18103 | 447 | 4 |
587001 | 587001 | 2020-10-01 | Monroe | Indiana | 18105 | 2730 | 41 |
587002 | 587002 | 2020-10-01 | Montgomery | Indiana | 18107 | 515 | 23 |
587003 | 587003 | 2020-10-01 | Morgan | Indiana | 18109 | 760 | 43 |
587004 | 587004 | 2020-10-01 | Newton | Indiana | 18111 | 176 | 12 |
587005 | 587005 | 2020-10-01 | Noble | Indiana | 18113 | 940 | 33 |
587006 | 587006 | 2020-10-01 | Ohio | Indiana | 18115 | 79 | 7 |
587007 | 587007 | 2020-10-01 | Orange | Indiana | 18117 | 292 | 26 |
587008 | 587008 | 2020-10-01 | Owen | Indiana | 18119 | 175 | 2 |
587009 | 587009 | 2020-10-01 | Parke | Indiana | 18121 | 120 | 2 |
587010 | 587010 | 2020-10-01 | Perry | Indiana | 18123 | 240 | 14 |
587011 | 587011 | 2020-10-01 | Pike | Indiana | 18125 | 219 | 1 |
587012 | 587012 | 2020-10-01 | Porter | Indiana | 18127 | 2275 | 49 |
587013 | 587013 | 2020-10-01 | Posey | Indiana | 18129 | 381 | 2 |
587014 | 587014 | 2020-10-01 | Pulaski | Indiana | 18131 | 116 | 1 |
587015 | 587015 | 2020-10-01 | Putnam | Indiana | 18133 | 606 | 11 |
587016 | 587016 | 2020-10-01 | Randolph | Indiana | 18135 | 268 | 8 |
587017 | 587017 | 2020-10-01 | Ripley | Indiana | 18137 | 314 | 8 |
587018 | 587018 | 2020-10-01 | Rush | Indiana | 18139 | 204 | 4 |
587019 | 587019 | 2020-10-01 | Scott | Indiana | 18143 | 406 | 13 |
587020 | 587020 | 2020-10-01 | Shelby | Indiana | 18145 | 1182 | 37 |
587021 | 587021 | 2020-10-01 | Spencer | Indiana | 18147 | 288 | 3 |
587022 | 587022 | 2020-10-01 | St. Joseph | Indiana | 18141 | 6876 | 123 |
587023 | 587023 | 2020-10-01 | Starke | Indiana | 18149 | 280 | 8 |
587024 | 587024 | 2020-10-01 | Steuben | Indiana | 18151 | 414 | 7 |
587025 | 587025 | 2020-10-01 | Sullivan | Indiana | 18153 | 347 | 12 |
587026 | 587026 | 2020-10-01 | Switzerland | Indiana | 18155 | 71 | 0 |
587027 | 587027 | 2020-10-01 | Tippecanoe | Indiana | 18157 | 2690 | 14 |
587028 | 587028 | 2020-10-01 | Tipton | Indiana | 18159 | 239 | 26 |
587029 | 587029 | 2020-10-01 | Union | Indiana | 18161 | 105 | 0 |
587030 | 587030 | 2020-10-01 | Vanderburgh | Indiana | 18163 | 3970 | 32 |
587031 | 587031 | 2020-10-01 | Vermillion | Indiana | 18165 | 137 | 0 |
587032 | 587032 | 2020-10-01 | Vigo | Indiana | 18167 | 1938 | 29 |
587033 | 587033 | 2020-10-01 | Wabash | Indiana | 18169 | 280 | 8 |
587034 | 587034 | 2020-10-01 | Warren | Indiana | 18171 | 43 | 1 |
587035 | 587035 | 2020-10-01 | Warrick | Indiana | 18173 | 1449 | 50 |
587036 | 587036 | 2020-10-01 | Washington | Indiana | 18175 | 273 | 2 |
587037 | 587037 | 2020-10-01 | Wayne | Indiana | 18177 | 1153 | 15 |
587038 | 587038 | 2020-10-01 | Wells | Indiana | 18179 | 296 | 4 |
587039 | 587039 | 2020-10-01 | White | Indiana | 18181 | 493 | 15 |
587040 | 587040 | 2020-10-01 | Whitley | Indiana | 18183 | 295 | 6 |
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);