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 423
- 18063 421
- 18113 420
- 18001 419
- 18011 419
- 18067 418
- 18081 418
- 18141 418
- 18091 415
- 18179 415
- 18057 414
- 18005 413
- 18043 413
- 18047 412
- 18089 412
- 18019 411
- 18041 411
- 18079 411
- 18095 411
- 18119 410
- 18157 410
- 18177 410
- 18003 409
- 18053 409
- 18145 409
- 18163 409
- 18167 409
- 18035 408
- 18039 408
- 18059 408
- …
county >30
- Marion 423
- Hendricks 421
- Noble 420
- Adams 419
- Boone 419
- Howard 418
- Johnson 418
- St. Joseph 418
- LaPorte 415
- Wells 415
- Hamilton 414
- Bartholomew 413
- Floyd 413
- Franklin 412
- Lake 412
- Clark 411
- Fayette 411
- Jennings 411
- Madison 411
- Owen 410
- Tippecanoe 410
- Wayne 410
- Allen 409
- Grant 409
- Shelby 409
- Vanderburgh 409
- Vigo 409
- Delaware 408
- Elkhart 408
- Hancock 408
- …
state 1
- Indiana · 37,294 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278247 | 1278247 | 2021-05-02 | Adams | Indiana | 18001 | 3464 | 55 |
1278248 | 1278248 | 2021-05-02 | Allen | Indiana | 18003 | 40166 | 696 |
1278249 | 1278249 | 2021-05-02 | Bartholomew | Indiana | 18005 | 8045 | 160 |
1278250 | 1278250 | 2021-05-02 | Benton | Indiana | 18007 | 983 | 14 |
1278251 | 1278251 | 2021-05-02 | Blackford | Indiana | 18009 | 1355 | 32 |
1278252 | 1278252 | 2021-05-02 | Boone | Indiana | 18011 | 6664 | 105 |
1278253 | 1278253 | 2021-05-02 | Brown | Indiana | 18013 | 1012 | 41 |
1278254 | 1278254 | 2021-05-02 | Carroll | Indiana | 18015 | 1878 | 22 |
1278255 | 1278255 | 2021-05-02 | Cass | Indiana | 18017 | 5767 | 107 |
1278256 | 1278256 | 2021-05-02 | Clark | Indiana | 18019 | 12868 | 200 |
1278257 | 1278257 | 2021-05-02 | Clay | Indiana | 18021 | 2583 | 45 |
1278258 | 1278258 | 2021-05-02 | Clinton | Indiana | 18023 | 4258 | 58 |
1278259 | 1278259 | 2021-05-02 | Crawford | Indiana | 18025 | 989 | 15 |
1278260 | 1278260 | 2021-05-02 | Daviess | Indiana | 18027 | 2944 | 101 |
1278261 | 1278261 | 2021-05-02 | DeKalb | Indiana | 18033 | 4230 | 87 |
1278262 | 1278262 | 2021-05-02 | Dearborn | Indiana | 18029 | 5774 | 79 |
1278263 | 1278263 | 2021-05-02 | Decatur | Indiana | 18031 | 2881 | 96 |
1278264 | 1278264 | 2021-05-02 | Delaware | Indiana | 18035 | 10563 | 192 |
1278265 | 1278265 | 2021-05-02 | Dubois | Indiana | 18037 | 6138 | 118 |
1278266 | 1278266 | 2021-05-02 | Elkhart | Indiana | 18039 | 28250 | 451 |
1278267 | 1278267 | 2021-05-02 | Fayette | Indiana | 18041 | 2920 | 64 |
1278268 | 1278268 | 2021-05-02 | Floyd | Indiana | 18043 | 7625 | 181 |
1278269 | 1278269 | 2021-05-02 | Fountain | Indiana | 18045 | 2117 | 47 |
1278270 | 1278270 | 2021-05-02 | Franklin | Indiana | 18047 | 1685 | 36 |
1278271 | 1278271 | 2021-05-02 | Fulton | Indiana | 18049 | 1939 | 40 |
1278272 | 1278272 | 2021-05-02 | Gibson | Indiana | 18051 | 4339 | 93 |
1278273 | 1278273 | 2021-05-02 | Grant | Indiana | 18053 | 7382 | 180 |
1278274 | 1278274 | 2021-05-02 | Greene | Indiana | 18055 | 2761 | 89 |
1278275 | 1278275 | 2021-05-02 | Hamilton | Indiana | 18057 | 35334 | 426 |
1278276 | 1278276 | 2021-05-02 | Hancock | Indiana | 18059 | 8214 | 143 |
1278277 | 1278277 | 2021-05-02 | Harrison | Indiana | 18061 | 4322 | 74 |
1278278 | 1278278 | 2021-05-02 | Hendricks | Indiana | 18063 | 17135 | 332 |
1278279 | 1278279 | 2021-05-02 | Henry | Indiana | 18065 | 5666 | 104 |
1278280 | 1278280 | 2021-05-02 | Howard | Indiana | 18067 | 9816 | 219 |
1278281 | 1278281 | 2021-05-02 | Huntington | Indiana | 18069 | 3860 | 82 |
1278282 | 1278282 | 2021-05-02 | Jackson | Indiana | 18071 | 4991 | 73 |
1278283 | 1278283 | 2021-05-02 | Jasper | Indiana | 18073 | 3606 | 49 |
1278284 | 1278284 | 2021-05-02 | Jay | Indiana | 18075 | 1911 | 31 |
1278285 | 1278285 | 2021-05-02 | Jefferson | Indiana | 18077 | 3275 | 81 |
1278286 | 1278286 | 2021-05-02 | Jennings | Indiana | 18079 | 2286 | 50 |
1278287 | 1278287 | 2021-05-02 | Johnson | Indiana | 18081 | 17872 | 391 |
1278288 | 1278288 | 2021-05-02 | Knox | Indiana | 18083 | 3710 | 90 |
1278289 | 1278289 | 2021-05-02 | Kosciusko | Indiana | 18085 | 9353 | 120 |
1278290 | 1278290 | 2021-05-02 | LaGrange | Indiana | 18087 | 2639 | 72 |
1278291 | 1278291 | 2021-05-02 | LaPorte | Indiana | 18091 | 11642 | 211 |
1278292 | 1278292 | 2021-05-02 | Lake | Indiana | 18089 | 53110 | 1000 |
1278293 | 1278293 | 2021-05-02 | Lawrence | Indiana | 18093 | 4453 | 123 |
1278294 | 1278294 | 2021-05-02 | Madison | Indiana | 18095 | 12530 | 358 |
1278295 | 1278295 | 2021-05-02 | Marion | Indiana | 18097 | 98840 | 1801 |
1278296 | 1278296 | 2021-05-02 | Marshall | Indiana | 18099 | 5944 | 112 |
1278297 | 1278297 | 2021-05-02 | Martin | Indiana | 18101 | 874 | 15 |
1278298 | 1278298 | 2021-05-02 | Miami | Indiana | 18103 | 3793 | 66 |
1278299 | 1278299 | 2021-05-02 | Monroe | Indiana | 18105 | 11789 | 170 |
1278300 | 1278300 | 2021-05-02 | Montgomery | Indiana | 18107 | 4225 | 90 |
1278301 | 1278301 | 2021-05-02 | Morgan | Indiana | 18109 | 6537 | 144 |
1278302 | 1278302 | 2021-05-02 | Newton | Indiana | 18111 | 1069 | 36 |
1278303 | 1278303 | 2021-05-02 | Noble | Indiana | 18113 | 5545 | 86 |
1278304 | 1278304 | 2021-05-02 | Ohio | Indiana | 18115 | 562 | 11 |
1278305 | 1278305 | 2021-05-02 | Orange | Indiana | 18117 | 1821 | 57 |
1278306 | 1278306 | 2021-05-02 | Owen | Indiana | 18119 | 1957 | 58 |
1278307 | 1278307 | 2021-05-02 | Parke | Indiana | 18121 | 1468 | 16 |
1278308 | 1278308 | 2021-05-02 | Perry | Indiana | 18123 | 1833 | 38 |
1278309 | 1278309 | 2021-05-02 | Pike | Indiana | 18125 | 1326 | 34 |
1278310 | 1278310 | 2021-05-02 | Porter | Indiana | 18127 | 18512 | 315 |
1278311 | 1278311 | 2021-05-02 | Posey | Indiana | 18129 | 2707 | 33 |
1278312 | 1278312 | 2021-05-02 | Pulaski | Indiana | 18131 | 1160 | 45 |
1278313 | 1278313 | 2021-05-02 | Putnam | Indiana | 18133 | 3580 | 60 |
1278314 | 1278314 | 2021-05-02 | Randolph | Indiana | 18135 | 2434 | 82 |
1278315 | 1278315 | 2021-05-02 | Ripley | Indiana | 18137 | 3381 | 70 |
1278316 | 1278316 | 2021-05-02 | Rush | Indiana | 18139 | 1792 | 24 |
1278317 | 1278317 | 2021-05-02 | Scott | Indiana | 18143 | 2648 | 55 |
1278318 | 1278318 | 2021-05-02 | Shelby | Indiana | 18145 | 5846 | 106 |
1278319 | 1278319 | 2021-05-02 | Spencer | Indiana | 18147 | 2304 | 31 |
1278320 | 1278320 | 2021-05-02 | St. Joseph | Indiana | 18141 | 35183 | 567 |
1278321 | 1278321 | 2021-05-02 | Starke | Indiana | 18149 | 2129 | 54 |
1278322 | 1278322 | 2021-05-02 | Steuben | Indiana | 18151 | 3802 | 59 |
1278323 | 1278323 | 2021-05-02 | Sullivan | Indiana | 18153 | 2106 | 42 |
1278324 | 1278324 | 2021-05-02 | Switzerland | Indiana | 18155 | 779 | 8 |
1278325 | 1278325 | 2021-05-02 | Tippecanoe | Indiana | 18157 | 22253 | 219 |
1278326 | 1278326 | 2021-05-02 | Tipton | Indiana | 18159 | 1623 | 47 |
1278327 | 1278327 | 2021-05-02 | Union | Indiana | 18161 | 733 | 11 |
1278328 | 1278328 | 2021-05-02 | Vanderburgh | Indiana | 18163 | 22230 | 400 |
1278329 | 1278329 | 2021-05-02 | Vermillion | Indiana | 18165 | 1675 | 43 |
1278330 | 1278330 | 2021-05-02 | Vigo | Indiana | 18167 | 12381 | 249 |
1278331 | 1278331 | 2021-05-02 | Wabash | Indiana | 18169 | 3526 | 78 |
1278332 | 1278332 | 2021-05-02 | Warren | Indiana | 18171 | 806 | 16 |
1278333 | 1278333 | 2021-05-02 | Warrick | Indiana | 18173 | 7757 | 158 |
1278334 | 1278334 | 2021-05-02 | Washington | Indiana | 18175 | 2387 | 31 |
1278335 | 1278335 | 2021-05-02 | Wayne | Indiana | 18177 | 7374 | 202 |
1278336 | 1278336 | 2021-05-02 | Wells | Indiana | 18179 | 2927 | 83 |
1278337 | 1278337 | 2021-05-02 | White | Indiana | 18181 | 3119 | 55 |
1278338 | 1278338 | 2021-05-02 | Whitley | Indiana | 18183 | 3922 | 39 |
1275000 | 1275000 | 2021-05-01 | Adams | Indiana | 18001 | 3463 | 55 |
1275001 | 1275001 | 2021-05-01 | Allen | Indiana | 18003 | 40066 | 696 |
1275002 | 1275002 | 2021-05-01 | Bartholomew | Indiana | 18005 | 8035 | 160 |
1275003 | 1275003 | 2021-05-01 | Benton | Indiana | 18007 | 982 | 14 |
1275004 | 1275004 | 2021-05-01 | Blackford | Indiana | 18009 | 1355 | 32 |
1275005 | 1275005 | 2021-05-01 | Boone | Indiana | 18011 | 6657 | 105 |
1275006 | 1275006 | 2021-05-01 | Brown | Indiana | 18013 | 1012 | 41 |
1275007 | 1275007 | 2021-05-01 | Carroll | Indiana | 18015 | 1879 | 22 |
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);