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 323
- 18063 321
- 18113 320
- 18001 319
- 18011 319
- 18067 318
- 18081 318
- 18141 318
- 18179 316
- 18091 315
- 18057 314
- 18005 313
- 18043 313
- 18047 312
- 18089 312
- 18019 311
- 18041 311
- 18079 311
- 18095 311
- 18177 311
- 18119 310
- 18157 310
- 18003 309
- 18053 309
- 18145 309
- 18163 309
- 18167 309
- 18035 308
- 18039 308
- 18059 308
- …
county >30
- Marion 323
- Hendricks 321
- Noble 320
- Adams 319
- Boone 319
- Howard 318
- Johnson 318
- St. Joseph 318
- Wells 316
- LaPorte 315
- Hamilton 314
- Bartholomew 313
- Floyd 313
- Franklin 312
- Lake 312
- Clark 311
- Fayette 311
- Jennings 311
- Madison 311
- Wayne 311
- Owen 310
- Tippecanoe 310
- Allen 309
- Grant 309
- Shelby 309
- Vanderburgh 309
- Vigo 309
- Delaware 308
- Elkhart 308
- Hancock 308
- …
state 1
- Indiana · 28,098 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
956927 | 956927 | 2021-01-23 | Wayne | Indiana | 18177 | 6528 | 165 |
956928 | 956928 | 2021-01-23 | Wells | Indiana | 18179 | 2385 | 54 |
956929 | 956929 | 2021-01-23 | White | Indiana | 18181 | 2732 | 43 |
956930 | 956930 | 2021-01-23 | Whitley | Indiana | 18183 | 3073 | 26 |
953594 | 953594 | 2021-01-22 | Adams | Indiana | 18001 | 2997 | 36 |
953595 | 953595 | 2021-01-22 | Allen | Indiana | 18003 | 32695 | 570 |
953596 | 953596 | 2021-01-22 | Bartholomew | Indiana | 18005 | 6462 | 106 |
953597 | 953597 | 2021-01-22 | Benton | Indiana | 18007 | 865 | 10 |
953598 | 953598 | 2021-01-22 | Blackford | Indiana | 18009 | 1120 | 22 |
953599 | 953599 | 2021-01-22 | Boone | Indiana | 18011 | 5513 | 71 |
953600 | 953600 | 2021-01-22 | Brown | Indiana | 18013 | 875 | 34 |
953601 | 953601 | 2021-01-22 | Carroll | Indiana | 18015 | 1565 | 16 |
953602 | 953602 | 2021-01-22 | Cass | Indiana | 18017 | 4829 | 64 |
953603 | 953603 | 2021-01-22 | Clark | Indiana | 18019 | 10602 | 147 |
953604 | 953604 | 2021-01-22 | Clay | Indiana | 18021 | 2218 | 32 |
953605 | 953605 | 2021-01-22 | Clinton | Indiana | 18023 | 3724 | 47 |
953606 | 953606 | 2021-01-22 | Crawford | Indiana | 18025 | 794 | 10 |
953607 | 953607 | 2021-01-22 | Daviess | Indiana | 18027 | 2670 | 77 |
953608 | 953608 | 2021-01-22 | DeKalb | Indiana | 18033 | 3464 | 68 |
953609 | 953609 | 2021-01-22 | Dearborn | Indiana | 18029 | 4770 | 47 |
953610 | 953610 | 2021-01-22 | Decatur | Indiana | 18031 | 2517 | 87 |
953611 | 953611 | 2021-01-22 | Delaware | Indiana | 18035 | 9101 | 138 |
953612 | 953612 | 2021-01-22 | Dubois | Indiana | 18037 | 5541 | 80 |
953613 | 953613 | 2021-01-22 | Elkhart | Indiana | 18039 | 24452 | 356 |
953614 | 953614 | 2021-01-22 | Fayette | Indiana | 18041 | 2597 | 49 |
953615 | 953615 | 2021-01-22 | Floyd | Indiana | 18043 | 6388 | 114 |
953616 | 953616 | 2021-01-22 | Fountain | Indiana | 18045 | 1833 | 28 |
953617 | 953617 | 2021-01-22 | Franklin | Indiana | 18047 | 1495 | 34 |
953618 | 953618 | 2021-01-22 | Fulton | Indiana | 18049 | 1632 | 30 |
953619 | 953619 | 2021-01-22 | Gibson | Indiana | 18051 | 3695 | 61 |
953620 | 953620 | 2021-01-22 | Grant | Indiana | 18053 | 6375 | 120 |
953621 | 953621 | 2021-01-22 | Greene | Indiana | 18055 | 2400 | 65 |
953622 | 953622 | 2021-01-22 | Hamilton | Indiana | 18057 | 29282 | 330 |
953623 | 953623 | 2021-01-22 | Hancock | Indiana | 18059 | 6661 | 107 |
953624 | 953624 | 2021-01-22 | Harrison | Indiana | 18061 | 3459 | 46 |
953625 | 953625 | 2021-01-22 | Hendricks | Indiana | 18063 | 14347 | 267 |
953626 | 953626 | 2021-01-22 | Henry | Indiana | 18065 | 5068 | 65 |
953627 | 953627 | 2021-01-22 | Howard | Indiana | 18067 | 8187 | 146 |
953628 | 953628 | 2021-01-22 | Huntington | Indiana | 18069 | 2909 | 59 |
953629 | 953629 | 2021-01-22 | Jackson | Indiana | 18071 | 4223 | 48 |
953630 | 953630 | 2021-01-22 | Jasper | Indiana | 18073 | 2885 | 36 |
953631 | 953631 | 2021-01-22 | Jay | Indiana | 18075 | 1679 | 24 |
953632 | 953632 | 2021-01-22 | Jefferson | Indiana | 18077 | 2629 | 42 |
953633 | 953633 | 2021-01-22 | Jennings | Indiana | 18079 | 1981 | 38 |
953634 | 953634 | 2021-01-22 | Johnson | Indiana | 18081 | 15030 | 304 |
953635 | 953635 | 2021-01-22 | Knox | Indiana | 18083 | 3346 | 39 |
953636 | 953636 | 2021-01-22 | Kosciusko | Indiana | 18085 | 8050 | 85 |
953637 | 953637 | 2021-01-22 | LaGrange | Indiana | 18087 | 2281 | 63 |
953638 | 953638 | 2021-01-22 | LaPorte | Indiana | 18091 | 9016 | 165 |
953639 | 953639 | 2021-01-22 | Lake | Indiana | 18089 | 45259 | 708 |
953640 | 953640 | 2021-01-22 | Lawrence | Indiana | 18093 | 3894 | 82 |
953641 | 953641 | 2021-01-22 | Madison | Indiana | 18095 | 10937 | 237 |
953642 | 953642 | 2021-01-22 | Marion | Indiana | 18097 | 83820 | 1394 |
953643 | 953643 | 2021-01-22 | Marshall | Indiana | 18099 | 5028 | 84 |
953644 | 953644 | 2021-01-22 | Martin | Indiana | 18101 | 731 | 13 |
953645 | 953645 | 2021-01-22 | Miami | Indiana | 18103 | 3204 | 45 |
953646 | 953646 | 2021-01-22 | Monroe | Indiana | 18105 | 9343 | 114 |
953647 | 953647 | 2021-01-22 | Montgomery | Indiana | 18107 | 3435 | 55 |
953648 | 953648 | 2021-01-22 | Morgan | Indiana | 18109 | 5370 | 100 |
953649 | 953649 | 2021-01-22 | Newton | Indiana | 18111 | 909 | 23 |
953650 | 953650 | 2021-01-22 | Noble | Indiana | 18113 | 4716 | 60 |
953651 | 953651 | 2021-01-22 | Ohio | Indiana | 18115 | 486 | 7 |
953652 | 953652 | 2021-01-22 | Orange | Indiana | 18117 | 1575 | 36 |
953653 | 953653 | 2021-01-22 | Owen | Indiana | 18119 | 1639 | 39 |
953654 | 953654 | 2021-01-22 | Parke | Indiana | 18121 | 1317 | 8 |
953655 | 953655 | 2021-01-22 | Perry | Indiana | 18123 | 1537 | 28 |
953656 | 953656 | 2021-01-22 | Pike | Indiana | 18125 | 1164 | 28 |
953657 | 953657 | 2021-01-22 | Porter | Indiana | 18127 | 14730 | 181 |
953658 | 953658 | 2021-01-22 | Posey | Indiana | 18129 | 2381 | 28 |
953659 | 953659 | 2021-01-22 | Pulaski | Indiana | 18131 | 969 | 37 |
953660 | 953660 | 2021-01-22 | Putnam | Indiana | 18133 | 2950 | 49 |
953661 | 953661 | 2021-01-22 | Randolph | Indiana | 18135 | 2170 | 49 |
953662 | 953662 | 2021-01-22 | Ripley | Indiana | 18137 | 2977 | 45 |
953663 | 953663 | 2021-01-22 | Rush | Indiana | 18139 | 1606 | 18 |
953664 | 953664 | 2021-01-22 | Scott | Indiana | 18143 | 2241 | 41 |
953665 | 953665 | 2021-01-22 | Shelby | Indiana | 18145 | 5003 | 91 |
953666 | 953666 | 2021-01-22 | Spencer | Indiana | 18147 | 1904 | 21 |
953667 | 953667 | 2021-01-22 | St. Joseph | Indiana | 18141 | 27295 | 400 |
953668 | 953668 | 2021-01-22 | Starke | Indiana | 18149 | 1752 | 46 |
953669 | 953669 | 2021-01-22 | Steuben | Indiana | 18151 | 3135 | 46 |
953670 | 953670 | 2021-01-22 | Sullivan | Indiana | 18153 | 1915 | 33 |
953671 | 953671 | 2021-01-22 | Switzerland | Indiana | 18155 | 658 | 5 |
953672 | 953672 | 2021-01-22 | Tippecanoe | Indiana | 18157 | 17909 | 134 |
953673 | 953673 | 2021-01-22 | Tipton | Indiana | 18159 | 1323 | 35 |
953674 | 953674 | 2021-01-22 | Union | Indiana | 18161 | 653 | 7 |
953675 | 953675 | 2021-01-22 | Vanderburgh | Indiana | 18163 | 19300 | 252 |
953676 | 953676 | 2021-01-22 | Vermillion | Indiana | 18165 | 1487 | 34 |
953677 | 953677 | 2021-01-22 | Vigo | Indiana | 18167 | 10700 | 184 |
953678 | 953678 | 2021-01-22 | Wabash | Indiana | 18169 | 3019 | 47 |
953679 | 953679 | 2021-01-22 | Warren | Indiana | 18171 | 679 | 8 |
953680 | 953680 | 2021-01-22 | Warrick | Indiana | 18173 | 6689 | 100 |
953681 | 953681 | 2021-01-22 | Washington | Indiana | 18175 | 1837 | 22 |
953682 | 953682 | 2021-01-22 | Wayne | Indiana | 18177 | 6498 | 164 |
953683 | 953683 | 2021-01-22 | Wells | Indiana | 18179 | 2365 | 53 |
953684 | 953684 | 2021-01-22 | White | Indiana | 18181 | 2722 | 42 |
953685 | 953685 | 2021-01-22 | Whitley | Indiana | 18183 | 3045 | 26 |
950349 | 950349 | 2021-01-21 | Adams | Indiana | 18001 | 2991 | 36 |
950350 | 950350 | 2021-01-21 | Allen | Indiana | 18003 | 32547 | 568 |
950351 | 950351 | 2021-01-21 | Bartholomew | Indiana | 18005 | 6398 | 105 |
950352 | 950352 | 2021-01-21 | Benton | Indiana | 18007 | 859 | 10 |
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);