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
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 18097 787
- 18113 787
- 18141 787
- 18179 787
- 18001 786
- 18005 786
- 18011 786
- 18019 786
- 18041 786
- 18043 786
- 18047 786
- 18057 786
- 18063 786
- 18067 786
- 18079 786
- 18081 786
- 18089 786
- 18091 786
- 18095 786
- 18119 786
- 18157 786
- 18177 786
- 18003 785
- 18053 785
- 18145 785
- 18163 785
- 18167 785
- 18035 784
- 18039 784
- 18059 784
- …
county >30
- Marion 787
- Noble 787
- St. Joseph 787
- Wells 787
- Adams 786
- Bartholomew 786
- Boone 786
- Clark 786
- Fayette 786
- Floyd 786
- Franklin 786
- Hamilton 786
- Hendricks 786
- Howard 786
- Jennings 786
- Johnson 786
- LaPorte 786
- Lake 786
- Madison 786
- Owen 786
- Tippecanoe 786
- Wayne 786
- Allen 785
- Grant 785
- Shelby 785
- Vanderburgh 785
- Vigo 785
- Delaware 784
- Elkhart 784
- Hancock 784
- …
state 1
- Indiana · 71,821 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3959 | 3959 | 2020-03-18 | Marion | Indiana | 18097 | 11 | 1 |
3960 | 3960 | 2020-03-18 | Noble | Indiana | 18113 | 1 | 0 |
3961 | 3961 | 2020-03-18 | St. Joseph | Indiana | 18141 | 1 | 0 |
3962 | 3962 | 2020-03-18 | Wells | Indiana | 18179 | 1 | 0 |
4620 | 4620 | 2020-03-19 | Adams | Indiana | 18001 | 1 | 0 |
4621 | 4621 | 2020-03-19 | Bartholomew | Indiana | 18005 | 1 | 0 |
4622 | 4622 | 2020-03-19 | Boone | Indiana | 18011 | 1 | 0 |
4623 | 4623 | 2020-03-19 | Clark | Indiana | 18019 | 1 | 0 |
4624 | 4624 | 2020-03-19 | Fayette | Indiana | 18041 | 1 | 0 |
4625 | 4625 | 2020-03-19 | Floyd | Indiana | 18043 | 1 | 0 |
4626 | 4626 | 2020-03-19 | Franklin | Indiana | 18047 | 2 | 0 |
4627 | 4627 | 2020-03-19 | Hamilton | Indiana | 18057 | 2 | 0 |
4628 | 4628 | 2020-03-19 | Hendricks | Indiana | 18063 | 4 | 0 |
4629 | 4629 | 2020-03-19 | Howard | Indiana | 18067 | 5 | 0 |
4630 | 4630 | 2020-03-19 | Jennings | Indiana | 18079 | 1 | 0 |
4631 | 4631 | 2020-03-19 | Johnson | Indiana | 18081 | 3 | 1 |
4632 | 4632 | 2020-03-19 | LaPorte | Indiana | 18091 | 1 | 0 |
4633 | 4633 | 2020-03-19 | Lake | Indiana | 18089 | 4 | 0 |
4634 | 4634 | 2020-03-19 | Madison | Indiana | 18095 | 1 | 0 |
4635 | 4635 | 2020-03-19 | Marion | Indiana | 18097 | 19 | 1 |
4636 | 4636 | 2020-03-19 | Noble | Indiana | 18113 | 1 | 0 |
4637 | 4637 | 2020-03-19 | Owen | Indiana | 18119 | 1 | 0 |
4638 | 4638 | 2020-03-19 | St. Joseph | Indiana | 18141 | 3 | 0 |
4639 | 4639 | 2020-03-19 | Tippecanoe | Indiana | 18157 | 1 | 0 |
4640 | 4640 | 2020-03-19 | Wayne | Indiana | 18177 | 1 | 0 |
4641 | 4641 | 2020-03-19 | Wells | Indiana | 18179 | 1 | 0 |
5426 | 5426 | 2020-03-20 | Adams | Indiana | 18001 | 1 | 0 |
5427 | 5427 | 2020-03-20 | Allen | Indiana | 18003 | 1 | 0 |
5428 | 5428 | 2020-03-20 | Bartholomew | Indiana | 18005 | 1 | 0 |
5429 | 5429 | 2020-03-20 | Boone | Indiana | 18011 | 2 | 0 |
5430 | 5430 | 2020-03-20 | Clark | Indiana | 18019 | 1 | 0 |
5431 | 5431 | 2020-03-20 | Fayette | Indiana | 18041 | 1 | 0 |
5432 | 5432 | 2020-03-20 | Floyd | Indiana | 18043 | 2 | 0 |
5433 | 5433 | 2020-03-20 | Franklin | Indiana | 18047 | 2 | 0 |
5434 | 5434 | 2020-03-20 | Grant | Indiana | 18053 | 1 | 0 |
5435 | 5435 | 2020-03-20 | Hamilton | Indiana | 18057 | 5 | 0 |
5436 | 5436 | 2020-03-20 | Hendricks | Indiana | 18063 | 4 | 0 |
5437 | 5437 | 2020-03-20 | Howard | Indiana | 18067 | 5 | 0 |
5438 | 5438 | 2020-03-20 | Jennings | Indiana | 18079 | 2 | 1 |
5439 | 5439 | 2020-03-20 | Johnson | Indiana | 18081 | 4 | 1 |
5440 | 5440 | 2020-03-20 | LaPorte | Indiana | 18091 | 1 | 0 |
5441 | 5441 | 2020-03-20 | Lake | Indiana | 18089 | 6 | 0 |
5442 | 5442 | 2020-03-20 | Madison | Indiana | 18095 | 1 | 0 |
5443 | 5443 | 2020-03-20 | Marion | Indiana | 18097 | 26 | 3 |
5444 | 5444 | 2020-03-20 | Noble | Indiana | 18113 | 1 | 0 |
5445 | 5445 | 2020-03-20 | Owen | Indiana | 18119 | 1 | 0 |
5446 | 5446 | 2020-03-20 | Shelby | Indiana | 18145 | 1 | 0 |
5447 | 5447 | 2020-03-20 | St. Joseph | Indiana | 18141 | 6 | 0 |
5448 | 5448 | 2020-03-20 | Tippecanoe | Indiana | 18157 | 2 | 0 |
5449 | 5449 | 2020-03-20 | Vanderburgh | Indiana | 18163 | 1 | 0 |
5450 | 5450 | 2020-03-20 | Vigo | Indiana | 18167 | 1 | 0 |
5451 | 5451 | 2020-03-20 | Wayne | Indiana | 18177 | 1 | 0 |
5452 | 5452 | 2020-03-20 | Wells | Indiana | 18179 | 1 | 0 |
6361 | 6361 | 2020-03-21 | Adams | Indiana | 18001 | 1 | 0 |
6362 | 6362 | 2020-03-21 | Allen | Indiana | 18003 | 4 | 0 |
6363 | 6363 | 2020-03-21 | Bartholomew | Indiana | 18005 | 2 | 0 |
6364 | 6364 | 2020-03-21 | Boone | Indiana | 18011 | 2 | 0 |
6365 | 6365 | 2020-03-21 | Clark | Indiana | 18019 | 4 | 0 |
6366 | 6366 | 2020-03-21 | Delaware | Indiana | 18035 | 1 | 1 |
6367 | 6367 | 2020-03-21 | Elkhart | Indiana | 18039 | 1 | 0 |
6368 | 6368 | 2020-03-21 | Fayette | Indiana | 18041 | 1 | 0 |
6369 | 6369 | 2020-03-21 | Floyd | Indiana | 18043 | 2 | 0 |
6370 | 6370 | 2020-03-21 | Franklin | Indiana | 18047 | 2 | 0 |
6371 | 6371 | 2020-03-21 | Grant | Indiana | 18053 | 1 | 0 |
6372 | 6372 | 2020-03-21 | Hamilton | Indiana | 18057 | 10 | 0 |
6373 | 6373 | 2020-03-21 | Hancock | Indiana | 18059 | 1 | 0 |
6374 | 6374 | 2020-03-21 | Harrison | Indiana | 18061 | 1 | 0 |
6375 | 6375 | 2020-03-21 | Hendricks | Indiana | 18063 | 6 | 0 |
6376 | 6376 | 2020-03-21 | Howard | Indiana | 18067 | 5 | 0 |
6377 | 6377 | 2020-03-21 | Jennings | Indiana | 18079 | 2 | 1 |
6378 | 6378 | 2020-03-21 | Johnson | Indiana | 18081 | 7 | 1 |
6379 | 6379 | 2020-03-21 | LaPorte | Indiana | 18091 | 2 | 0 |
6380 | 6380 | 2020-03-21 | Lake | Indiana | 18089 | 7 | 0 |
6381 | 6381 | 2020-03-21 | Madison | Indiana | 18095 | 1 | 0 |
6382 | 6382 | 2020-03-21 | Marion | Indiana | 18097 | 47 | 3 |
6383 | 6383 | 2020-03-21 | Miami | Indiana | 18103 | 1 | 0 |
6384 | 6384 | 2020-03-21 | Noble | Indiana | 18113 | 1 | 0 |
6385 | 6385 | 2020-03-21 | Owen | Indiana | 18119 | 1 | 0 |
6386 | 6386 | 2020-03-21 | Shelby | Indiana | 18145 | 1 | 0 |
6387 | 6387 | 2020-03-21 | St. Joseph | Indiana | 18141 | 6 | 0 |
6388 | 6388 | 2020-03-21 | Tippecanoe | Indiana | 18157 | 2 | 0 |
6389 | 6389 | 2020-03-21 | Vanderburgh | Indiana | 18163 | 1 | 0 |
6390 | 6390 | 2020-03-21 | Vigo | Indiana | 18167 | 2 | 0 |
6391 | 6391 | 2020-03-21 | Washington | Indiana | 18175 | 1 | 0 |
6392 | 6392 | 2020-03-21 | Wayne | Indiana | 18177 | 1 | 0 |
6393 | 6393 | 2020-03-21 | Wells | Indiana | 18179 | 1 | 0 |
7415 | 7415 | 2020-03-22 | Adams | Indiana | 18001 | 1 | 0 |
7416 | 7416 | 2020-03-22 | Allen | Indiana | 18003 | 4 | 0 |
7417 | 7417 | 2020-03-22 | Bartholomew | Indiana | 18005 | 5 | 0 |
7418 | 7418 | 2020-03-22 | Boone | Indiana | 18011 | 3 | 0 |
7419 | 7419 | 2020-03-22 | Clark | Indiana | 18019 | 4 | 0 |
7420 | 7420 | 2020-03-22 | Delaware | Indiana | 18035 | 2 | 1 |
7421 | 7421 | 2020-03-22 | Elkhart | Indiana | 18039 | 1 | 0 |
7422 | 7422 | 2020-03-22 | Fayette | Indiana | 18041 | 1 | 0 |
7423 | 7423 | 2020-03-22 | Floyd | Indiana | 18043 | 3 | 0 |
7424 | 7424 | 2020-03-22 | Franklin | Indiana | 18047 | 4 | 0 |
7425 | 7425 | 2020-03-22 | Grant | Indiana | 18053 | 2 | 0 |
7426 | 7426 | 2020-03-22 | Hamilton | Indiana | 18057 | 18 | 0 |
7427 | 7427 | 2020-03-22 | Hancock | Indiana | 18059 | 2 | 0 |
7428 | 7428 | 2020-03-22 | Harrison | Indiana | 18061 | 1 | 0 |
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);