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 586
- 18063 584
- 18113 583
- 18001 581
- 18011 581
- 18067 581
- 18081 581
- 18141 581
- 18091 578
- 18179 578
- 18057 577
- 18043 576
- 18005 575
- 18047 575
- 18089 575
- 18019 574
- 18041 574
- 18079 574
- 18095 574
- 18119 573
- 18157 573
- 18177 573
- 18053 572
- 18145 572
- 18163 572
- 18167 572
- 18003 571
- 18035 571
- 18039 571
- 18059 571
- …
county >30
- Marion 586
- Hendricks 584
- Noble 583
- Adams 581
- Boone 581
- Howard 581
- Johnson 581
- St. Joseph 581
- LaPorte 578
- Wells 578
- Hamilton 577
- Floyd 576
- Bartholomew 575
- Franklin 575
- Lake 575
- Clark 574
- Fayette 574
- Jennings 574
- Madison 574
- Owen 573
- Tippecanoe 573
- Wayne 573
- Grant 572
- Shelby 572
- Vanderburgh 572
- Vigo 572
- Allen 571
- Delaware 571
- Elkhart 571
- Hancock 571
- …
state 1
- Indiana · 52,282 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1807581 | 1807581 | 2021-10-12 | Cass | Indiana | 18017 | 7417 | 121 |
1807582 | 1807582 | 2021-10-12 | Clark | Indiana | 18019 | 18279 | 256 |
1807583 | 1807583 | 2021-10-12 | Clay | Indiana | 18021 | 4139 | 61 |
1807584 | 1807584 | 2021-10-12 | Clinton | Indiana | 18023 | 5613 | 74 |
1807585 | 1807585 | 2021-10-12 | Crawford | Indiana | 18025 | 1568 | 23 |
1807586 | 1807586 | 2021-10-12 | Daviess | Indiana | 18027 | 4540 | 114 |
1807587 | 1807587 | 2021-10-12 | DeKalb | Indiana | 18033 | 6173 | 99 |
1807588 | 1807588 | 2021-10-12 | Dearborn | Indiana | 18029 | 8106 | 96 |
1807589 | 1807589 | 2021-10-12 | Decatur | Indiana | 18031 | 4135 | 105 |
1807590 | 1807590 | 2021-10-12 | Delaware | Indiana | 18035 | 14873 | 262 |
1807591 | 1807591 | 2021-10-12 | Dubois | Indiana | 18037 | 8160 | 130 |
1807592 | 1807592 | 2021-10-12 | Elkhart | Indiana | 18039 | 35382 | 518 |
1807593 | 1807593 | 2021-10-12 | Fayette | Indiana | 18041 | 4135 | 89 |
1807594 | 1807594 | 2021-10-12 | Floyd | Indiana | 18043 | 10919 | 220 |
1807595 | 1807595 | 2021-10-12 | Fountain | Indiana | 18045 | 3297 | 60 |
1807596 | 1807596 | 2021-10-12 | Franklin | Indiana | 18047 | 2619 | 45 |
1807597 | 1807597 | 2021-10-12 | Fulton | Indiana | 18049 | 3016 | 65 |
1807598 | 1807598 | 2021-10-12 | Gibson | Indiana | 18051 | 6435 | 115 |
1807599 | 1807599 | 2021-10-12 | Grant | Indiana | 18053 | 10180 | 224 |
1807600 | 1807600 | 2021-10-12 | Greene | Indiana | 18055 | 4182 | 100 |
1807601 | 1807601 | 2021-10-12 | Hamilton | Indiana | 18057 | 45745 | 479 |
1807602 | 1807602 | 2021-10-12 | Hancock | Indiana | 18059 | 11559 | 180 |
1807603 | 1807603 | 2021-10-12 | Harrison | Indiana | 18061 | 6375 | 94 |
1807604 | 1807604 | 2021-10-12 | Hendricks | Indiana | 18063 | 23554 | 372 |
1807605 | 1807605 | 2021-10-12 | Henry | Indiana | 18065 | 8070 | 153 |
1807606 | 1807606 | 2021-10-12 | Howard | Indiana | 18067 | 14477 | 290 |
1807607 | 1807607 | 2021-10-12 | Huntington | Indiana | 18069 | 6264 | 99 |
1807608 | 1807608 | 2021-10-12 | Jackson | Indiana | 18071 | 6867 | 88 |
1807609 | 1807609 | 2021-10-12 | Jasper | Indiana | 18073 | 5135 | 77 |
1807610 | 1807610 | 2021-10-12 | Jay | Indiana | 18075 | 2770 | 49 |
1807611 | 1807611 | 2021-10-12 | Jefferson | Indiana | 18077 | 5010 | 98 |
1807612 | 1807612 | 2021-10-12 | Jennings | Indiana | 18079 | 3807 | 61 |
1807613 | 1807613 | 2021-10-12 | Johnson | Indiana | 18081 | 24730 | 456 |
1807614 | 1807614 | 2021-10-12 | Knox | Indiana | 18083 | 6189 | 105 |
1807615 | 1807615 | 2021-10-12 | Kosciusko | Indiana | 18085 | 12020 | 151 |
1807616 | 1807616 | 2021-10-12 | LaGrange | Indiana | 18087 | 3478 | 79 |
1807617 | 1807617 | 2021-10-12 | LaPorte | Indiana | 18091 | 14911 | 251 |
1807618 | 1807618 | 2021-10-12 | Lake | Indiana | 18089 | 65555 | 1189 |
1807619 | 1807619 | 2021-10-12 | Lawrence | Indiana | 18093 | 7339 | 170 |
1807620 | 1807620 | 2021-10-12 | Madison | Indiana | 18095 | 18380 | 423 |
1807621 | 1807621 | 2021-10-12 | Marion | Indiana | 18097 | 133860 | 2164 |
1807622 | 1807622 | 2021-10-12 | Marshall | Indiana | 18099 | 7715 | 137 |
1807623 | 1807623 | 2021-10-12 | Martin | Indiana | 18101 | 1369 | 20 |
1807624 | 1807624 | 2021-10-12 | Miami | Indiana | 18103 | 5819 | 95 |
1807625 | 1807625 | 2021-10-12 | Monroe | Indiana | 18105 | 15039 | 199 |
1807626 | 1807626 | 2021-10-12 | Montgomery | Indiana | 18107 | 6144 | 110 |
1807627 | 1807627 | 2021-10-12 | Morgan | Indiana | 18109 | 9318 | 181 |
1807628 | 1807628 | 2021-10-12 | Newton | Indiana | 18111 | 1540 | 50 |
1807629 | 1807629 | 2021-10-12 | Noble | Indiana | 18113 | 7841 | 107 |
1807630 | 1807630 | 2021-10-12 | Ohio | Indiana | 18115 | 837 | 12 |
1807631 | 1807631 | 2021-10-12 | Orange | Indiana | 18117 | 2880 | 66 |
1807632 | 1807632 | 2021-10-12 | Owen | Indiana | 18119 | 3071 | 69 |
1807633 | 1807633 | 2021-10-12 | Parke | Indiana | 18121 | 2299 | 25 |
1807634 | 1807634 | 2021-10-12 | Perry | Indiana | 18123 | 2638 | 55 |
1807635 | 1807635 | 2021-10-12 | Pike | Indiana | 18125 | 2263 | 44 |
1807636 | 1807636 | 2021-10-12 | Porter | Indiana | 18127 | 22612 | 372 |
1807637 | 1807637 | 2021-10-12 | Posey | Indiana | 18129 | 3715 | 42 |
1807638 | 1807638 | 2021-10-12 | Pulaski | Indiana | 18131 | 1786 | 53 |
1807639 | 1807639 | 2021-10-12 | Putnam | Indiana | 18133 | 5712 | 79 |
1807640 | 1807640 | 2021-10-12 | Randolph | Indiana | 18135 | 3407 | 98 |
1807641 | 1807641 | 2021-10-12 | Ripley | Indiana | 18137 | 4891 | 85 |
1807642 | 1807642 | 2021-10-12 | Rush | Indiana | 18139 | 2614 | 32 |
1807643 | 1807643 | 2021-10-12 | Scott | Indiana | 18143 | 4319 | 70 |
1807644 | 1807644 | 2021-10-12 | Shelby | Indiana | 18145 | 8077 | 125 |
1807645 | 1807645 | 2021-10-12 | Spencer | Indiana | 18147 | 3348 | 41 |
1807646 | 1807646 | 2021-10-12 | St. Joseph | Indiana | 18141 | 43728 | 621 |
1807647 | 1807647 | 2021-10-12 | Starke | Indiana | 18149 | 3081 | 70 |
1807648 | 1807648 | 2021-10-12 | Steuben | Indiana | 18151 | 5417 | 72 |
1807649 | 1807649 | 2021-10-12 | Sullivan | Indiana | 18153 | 3255 | 54 |
1807650 | 1807650 | 2021-10-12 | Switzerland | Indiana | 18155 | 1330 | 11 |
1807651 | 1807651 | 2021-10-12 | Tippecanoe | Indiana | 18157 | 27561 | 258 |
1807652 | 1807652 | 2021-10-12 | Tipton | Indiana | 18159 | 2243 | 59 |
1807653 | 1807653 | 2021-10-12 | Union | Indiana | 18161 | 1080 | 16 |
1807654 | 1807654 | 2021-10-12 | Vanderburgh | Indiana | 18163 | 31672 | 481 |
1807655 | 1807655 | 2021-10-12 | Vermillion | Indiana | 18165 | 2517 | 54 |
1807656 | 1807656 | 2021-10-12 | Vigo | Indiana | 18167 | 17139 | 302 |
1807657 | 1807657 | 2021-10-12 | Wabash | Indiana | 18169 | 5189 | 100 |
1807658 | 1807658 | 2021-10-12 | Warren | Indiana | 18171 | 1193 | 18 |
1807659 | 1807659 | 2021-10-12 | Warrick | Indiana | 18173 | 11120 | 190 |
1807660 | 1807660 | 2021-10-12 | Washington | Indiana | 18175 | 3490 | 49 |
1807661 | 1807661 | 2021-10-12 | Wayne | Indiana | 18177 | 11102 | 250 |
1807662 | 1807662 | 2021-10-12 | Wells | Indiana | 18179 | 4157 | 88 |
1807663 | 1807663 | 2021-10-12 | White | Indiana | 18181 | 4107 | 61 |
1807664 | 1807664 | 2021-10-12 | Whitley | Indiana | 18183 | 5526 | 55 |
1804322 | 1804322 | 2021-10-11 | Adams | Indiana | 18001 | 4731 | 73 |
1804323 | 1804323 | 2021-10-11 | Allen | Indiana | 18003 | 56483 | 813 |
1804324 | 1804324 | 2021-10-11 | Bartholomew | Indiana | 18005 | 11331 | 182 |
1804325 | 1804325 | 2021-10-11 | Benton | Indiana | 18007 | 1494 | 16 |
1804326 | 1804326 | 2021-10-11 | Blackford | Indiana | 18009 | 1859 | 39 |
1804327 | 1804327 | 2021-10-11 | Boone | Indiana | 18011 | 8763 | 121 |
1804328 | 1804328 | 2021-10-11 | Brown | Indiana | 18013 | 1413 | 47 |
1804329 | 1804329 | 2021-10-11 | Carroll | Indiana | 18015 | 2561 | 34 |
1804330 | 1804330 | 2021-10-11 | Cass | Indiana | 18017 | 7407 | 121 |
1804331 | 1804331 | 2021-10-11 | Clark | Indiana | 18019 | 18267 | 254 |
1804332 | 1804332 | 2021-10-11 | Clay | Indiana | 18021 | 4135 | 61 |
1804333 | 1804333 | 2021-10-11 | Clinton | Indiana | 18023 | 5605 | 74 |
1804334 | 1804334 | 2021-10-11 | Crawford | Indiana | 18025 | 1565 | 22 |
1804335 | 1804335 | 2021-10-11 | Daviess | Indiana | 18027 | 4535 | 113 |
1804336 | 1804336 | 2021-10-11 | DeKalb | Indiana | 18033 | 6148 | 99 |
1804337 | 1804337 | 2021-10-11 | Dearborn | Indiana | 18029 | 8102 | 96 |
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);