ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71,921 rows where state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 18097 349
- 18063 347
- 18113 346
- 18001 345
- 18011 345
- 18067 344
- 18081 344
- 18141 344
- 18091 341
- 18179 341
- 18057 340
- 18005 339
- 18043 339
- 18047 338
- 18089 338
- 18019 337
- 18041 337
- 18079 337
- 18095 337
- 18119 336
- 18157 336
- 18177 336
- 18003 335
- 18053 335
- 18145 335
- 18163 335
- 18167 335
- 18035 334
- 18039 334
- 18059 334
- …
county >30
- Marion 349
- Hendricks 347
- Noble 346
- Adams 345
- Boone 345
- Howard 344
- Johnson 344
- St. Joseph 344
- LaPorte 341
- Wells 341
- Hamilton 340
- Bartholomew 339
- Floyd 339
- Franklin 338
- Lake 338
- Clark 337
- Fayette 337
- Jennings 337
- Madison 337
- Owen 336
- Tippecanoe 336
- Wayne 336
- Allen 335
- Grant 335
- Shelby 335
- Vanderburgh 335
- Vigo 335
- Delaware 334
- Elkhart 334
- Hancock 334
- …
state 1
- Indiana · 30,486 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1037980 | 1037980 | 2021-02-17 | Adams | Indiana | 18001 | 3177 | 50 |
1037981 | 1037981 | 2021-02-17 | Allen | Indiana | 18003 | 35256 | 651 |
1037982 | 1037982 | 2021-02-17 | Bartholomew | Indiana | 18005 | 7267 | 151 |
1037983 | 1037983 | 2021-02-17 | Benton | Indiana | 18007 | 906 | 12 |
1037984 | 1037984 | 2021-02-17 | Blackford | Indiana | 18009 | 1207 | 27 |
1037985 | 1037985 | 2021-02-17 | Boone | Indiana | 18011 | 6005 | 93 |
1037986 | 1037986 | 2021-02-17 | Brown | Indiana | 18013 | 937 | 39 |
1037987 | 1037987 | 2021-02-17 | Carroll | Indiana | 18015 | 1744 | 20 |
1037988 | 1037988 | 2021-02-17 | Cass | Indiana | 18017 | 5249 | 96 |
1037989 | 1037989 | 2021-02-17 | Clark | Indiana | 18019 | 11747 | 187 |
1037990 | 1037990 | 2021-02-17 | Clay | Indiana | 18021 | 2372 | 42 |
1037991 | 1037991 | 2021-02-17 | Clinton | Indiana | 18023 | 3899 | 57 |
1037992 | 1037992 | 2021-02-17 | Crawford | Indiana | 18025 | 895 | 14 |
1037993 | 1037993 | 2021-02-17 | Daviess | Indiana | 18027 | 2833 | 95 |
1037994 | 1037994 | 2021-02-17 | DeKalb | Indiana | 18033 | 3790 | 81 |
1037995 | 1037995 | 2021-02-17 | Dearborn | Indiana | 18029 | 5330 | 66 |
1037996 | 1037996 | 2021-02-17 | Decatur | Indiana | 18031 | 2735 | 92 |
1037997 | 1037997 | 2021-02-17 | Delaware | Indiana | 18035 | 9755 | 181 |
1037998 | 1037998 | 2021-02-17 | Dubois | Indiana | 18037 | 5840 | 107 |
1037999 | 1037999 | 2021-02-17 | Elkhart | Indiana | 18039 | 25223 | 423 |
1038000 | 1038000 | 2021-02-17 | Fayette | Indiana | 18041 | 2817 | 55 |
1038001 | 1038001 | 2021-02-17 | Floyd | Indiana | 18043 | 7078 | 166 |
1038002 | 1038002 | 2021-02-17 | Fountain | Indiana | 18045 | 1980 | 40 |
1038003 | 1038003 | 2021-02-17 | Franklin | Indiana | 18047 | 1597 | 36 |
1038004 | 1038004 | 2021-02-17 | Fulton | Indiana | 18049 | 1752 | 38 |
1038005 | 1038005 | 2021-02-17 | Gibson | Indiana | 18051 | 3984 | 84 |
1038006 | 1038006 | 2021-02-17 | Grant | Indiana | 18053 | 6773 | 161 |
1038007 | 1038007 | 2021-02-17 | Greene | Indiana | 18055 | 2592 | 82 |
1038008 | 1038008 | 2021-02-17 | Hamilton | Indiana | 18057 | 31504 | 391 |
1038009 | 1038009 | 2021-02-17 | Hancock | Indiana | 18059 | 7359 | 132 |
1038010 | 1038010 | 2021-02-17 | Harrison | Indiana | 18061 | 3904 | 62 |
1038011 | 1038011 | 2021-02-17 | Hendricks | Indiana | 18063 | 15637 | 310 |
1038012 | 1038012 | 2021-02-17 | Henry | Indiana | 18065 | 5376 | 90 |
1038013 | 1038013 | 2021-02-17 | Howard | Indiana | 18067 | 8994 | 191 |
1038014 | 1038014 | 2021-02-17 | Huntington | Indiana | 18069 | 3315 | 77 |
1038015 | 1038015 | 2021-02-17 | Jackson | Indiana | 18071 | 4595 | 61 |
1038016 | 1038016 | 2021-02-17 | Jasper | Indiana | 18073 | 3104 | 44 |
1038017 | 1038017 | 2021-02-17 | Jay | Indiana | 18075 | 1777 | 30 |
1038018 | 1038018 | 2021-02-17 | Jefferson | Indiana | 18077 | 2907 | 69 |
1038019 | 1038019 | 2021-02-17 | Jennings | Indiana | 18079 | 2123 | 46 |
1038020 | 1038020 | 2021-02-17 | Johnson | Indiana | 18081 | 16197 | 358 |
1038021 | 1038021 | 2021-02-17 | Knox | Indiana | 18083 | 3539 | 82 |
1038022 | 1038022 | 2021-02-17 | Kosciusko | Indiana | 18085 | 8479 | 111 |
1038023 | 1038023 | 2021-02-17 | LaGrange | Indiana | 18087 | 2396 | 71 |
1038024 | 1038024 | 2021-02-17 | LaPorte | Indiana | 18091 | 9651 | 196 |
1038025 | 1038025 | 2021-02-17 | Lake | Indiana | 18089 | 47874 | 883 |
1038026 | 1038026 | 2021-02-17 | Lawrence | Indiana | 18093 | 4131 | 114 |
1038027 | 1038027 | 2021-02-17 | Madison | Indiana | 18095 | 11652 | 327 |
1038028 | 1038028 | 2021-02-17 | Marion | Indiana | 18097 | 89705 | 1681 |
1038029 | 1038029 | 2021-02-17 | Marshall | Indiana | 18099 | 5367 | 104 |
1038030 | 1038030 | 2021-02-17 | Martin | Indiana | 18101 | 799 | 15 |
1038031 | 1038031 | 2021-02-17 | Miami | Indiana | 18103 | 3515 | 62 |
1038032 | 1038032 | 2021-02-17 | Monroe | Indiana | 18105 | 10147 | 160 |
1038033 | 1038033 | 2021-02-17 | Montgomery | Indiana | 18107 | 3763 | 83 |
1038034 | 1038034 | 2021-02-17 | Morgan | Indiana | 18109 | 5988 | 129 |
1038035 | 1038035 | 2021-02-17 | Newton | Indiana | 18111 | 966 | 33 |
1038036 | 1038036 | 2021-02-17 | Noble | Indiana | 18113 | 5031 | 78 |
1038037 | 1038037 | 2021-02-17 | Ohio | Indiana | 18115 | 522 | 11 |
1038038 | 1038038 | 2021-02-17 | Orange | Indiana | 18117 | 1708 | 53 |
1038039 | 1038039 | 2021-02-17 | Owen | Indiana | 18119 | 1814 | 54 |
1038040 | 1038040 | 2021-02-17 | Parke | Indiana | 18121 | 1387 | 15 |
1038041 | 1038041 | 2021-02-17 | Perry | Indiana | 18123 | 1721 | 36 |
1038042 | 1038042 | 2021-02-17 | Pike | Indiana | 18125 | 1264 | 32 |
1038043 | 1038043 | 2021-02-17 | Porter | Indiana | 18127 | 15721 | 274 |
1038044 | 1038044 | 2021-02-17 | Posey | Indiana | 18129 | 2571 | 31 |
1038045 | 1038045 | 2021-02-17 | Pulaski | Indiana | 18131 | 1047 | 41 |
1038046 | 1038046 | 2021-02-17 | Putnam | Indiana | 18133 | 3232 | 58 |
1038047 | 1038047 | 2021-02-17 | Randolph | Indiana | 18135 | 2284 | 75 |
1038048 | 1038048 | 2021-02-17 | Ripley | Indiana | 18137 | 3224 | 60 |
1038049 | 1038049 | 2021-02-17 | Rush | Indiana | 18139 | 1686 | 22 |
1038050 | 1038050 | 2021-02-17 | Scott | Indiana | 18143 | 2453 | 48 |
1038051 | 1038051 | 2021-02-17 | Shelby | Indiana | 18145 | 5464 | 98 |
1038052 | 1038052 | 2021-02-17 | Spencer | Indiana | 18147 | 2138 | 28 |
1038053 | 1038053 | 2021-02-17 | St. Joseph | Indiana | 18141 | 29133 | 519 |
1038054 | 1038054 | 2021-02-17 | Starke | Indiana | 18149 | 1849 | 53 |
1038055 | 1038055 | 2021-02-17 | Steuben | Indiana | 18151 | 3331 | 57 |
1038056 | 1038056 | 2021-02-17 | Sullivan | Indiana | 18153 | 2017 | 38 |
1038057 | 1038057 | 2021-02-17 | Switzerland | Indiana | 18155 | 746 | 7 |
1038058 | 1038058 | 2021-02-17 | Tippecanoe | Indiana | 18157 | 19489 | 195 |
1038059 | 1038059 | 2021-02-17 | Tipton | Indiana | 18159 | 1454 | 43 |
1038060 | 1038060 | 2021-02-17 | Union | Indiana | 18161 | 690 | 10 |
1038061 | 1038061 | 2021-02-17 | Vanderburgh | Indiana | 18163 | 20968 | 375 |
1038062 | 1038062 | 2021-02-17 | Vermillion | Indiana | 18165 | 1575 | 40 |
1038063 | 1038063 | 2021-02-17 | Vigo | Indiana | 18167 | 11433 | 232 |
1038064 | 1038064 | 2021-02-17 | Wabash | Indiana | 18169 | 3265 | 74 |
1038065 | 1038065 | 2021-02-17 | Warren | Indiana | 18171 | 738 | 13 |
1038066 | 1038066 | 2021-02-17 | Warrick | Indiana | 18173 | 7312 | 144 |
1038067 | 1038067 | 2021-02-17 | Washington | Indiana | 18175 | 2043 | 26 |
1038068 | 1038068 | 2021-02-17 | Wayne | Indiana | 18177 | 6943 | 189 |
1038069 | 1038069 | 2021-02-17 | Wells | Indiana | 18179 | 2538 | 77 |
1038070 | 1038070 | 2021-02-17 | White | Indiana | 18181 | 2922 | 51 |
1038071 | 1038071 | 2021-02-17 | Whitley | Indiana | 18183 | 3419 | 35 |
1034735 | 1034735 | 2021-02-16 | Adams | Indiana | 18001 | 3177 | 50 |
1034736 | 1034736 | 2021-02-16 | Allen | Indiana | 18003 | 35181 | 649 |
1034737 | 1034737 | 2021-02-16 | Bartholomew | Indiana | 18005 | 7247 | 151 |
1034738 | 1034738 | 2021-02-16 | Benton | Indiana | 18007 | 907 | 12 |
1034739 | 1034739 | 2021-02-16 | Blackford | Indiana | 18009 | 1207 | 27 |
1034740 | 1034740 | 2021-02-16 | Boone | Indiana | 18011 | 5997 | 93 |
1034741 | 1034741 | 2021-02-16 | Brown | Indiana | 18013 | 936 | 39 |
1034742 | 1034742 | 2021-02-16 | Carroll | Indiana | 18015 | 1742 | 20 |
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);