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 678
- 18063 676
- 18113 675
- 18001 673
- 18011 673
- 18067 673
- 18081 673
- 18141 673
- 18091 670
- 18179 670
- 18057 669
- 18043 668
- 18005 667
- 18047 667
- 18089 667
- 18019 666
- 18041 666
- 18079 666
- 18095 666
- 18119 665
- 18157 665
- 18177 665
- 18053 664
- 18145 664
- 18163 664
- 18167 664
- 18003 663
- 18035 663
- 18039 663
- 18059 663
- …
county >30
- Marion 678
- Hendricks 676
- Noble 675
- Adams 673
- Boone 673
- Howard 673
- Johnson 673
- St. Joseph 673
- LaPorte 670
- Wells 670
- Hamilton 669
- Floyd 668
- Bartholomew 667
- Franklin 667
- Lake 667
- Clark 666
- Fayette 666
- Jennings 666
- Madison 666
- Owen 665
- Tippecanoe 665
- Wayne 665
- Grant 664
- Shelby 664
- Vanderburgh 664
- Vigo 664
- Allen 663
- Delaware 663
- Elkhart 663
- Hancock 663
- …
state 1
- Indiana · 60,746 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2106591 | 2106591 | 2022-01-12 | Cass | Indiana | 18017 | 9440 | 146 |
2106592 | 2106592 | 2022-01-12 | Clark | Indiana | 18019 | 24048 | 329 |
2106593 | 2106593 | 2022-01-12 | Clay | Indiana | 18021 | 5610 | 74 |
2106594 | 2106594 | 2022-01-12 | Clinton | Indiana | 18023 | 7618 | 100 |
2106595 | 2106595 | 2022-01-12 | Crawford | Indiana | 18025 | 2010 | 32 |
2106596 | 2106596 | 2022-01-12 | Daviess | Indiana | 18027 | 5988 | 128 |
2106597 | 2106597 | 2022-01-12 | DeKalb | Indiana | 18033 | 9509 | 130 |
2106598 | 2106598 | 2022-01-12 | Dearborn | Indiana | 18029 | 10848 | 119 |
2106599 | 2106599 | 2022-01-12 | Decatur | Indiana | 18031 | 5609 | 125 |
2106600 | 2106600 | 2022-01-12 | Delaware | Indiana | 18035 | 20151 | 374 |
2106601 | 2106601 | 2022-01-12 | Dubois | Indiana | 18037 | 10282 | 153 |
2106602 | 2106602 | 2022-01-12 | Elkhart | Indiana | 18039 | 46668 | 652 |
2106603 | 2106603 | 2022-01-12 | Fayette | Indiana | 18041 | 5607 | 122 |
2106604 | 2106604 | 2022-01-12 | Floyd | Indiana | 18043 | 14607 | 259 |
2106605 | 2106605 | 2022-01-12 | Fountain | Indiana | 18045 | 4479 | 82 |
2106606 | 2106606 | 2022-01-12 | Franklin | Indiana | 18047 | 3615 | 55 |
2106607 | 2106607 | 2022-01-12 | Fulton | Indiana | 18049 | 4152 | 91 |
2106608 | 2106608 | 2022-01-12 | Gibson | Indiana | 18051 | 8599 | 130 |
2106609 | 2106609 | 2022-01-12 | Grant | Indiana | 18053 | 14800 | 298 |
2106610 | 2106610 | 2022-01-12 | Greene | Indiana | 18055 | 5648 | 115 |
2106611 | 2106611 | 2022-01-12 | Hamilton | Indiana | 18057 | 67077 | 561 |
2106612 | 2106612 | 2022-01-12 | Hancock | Indiana | 18059 | 17122 | 217 |
2106613 | 2106613 | 2022-01-12 | Harrison | Indiana | 18061 | 8260 | 115 |
2106614 | 2106614 | 2022-01-12 | Hendricks | Indiana | 18063 | 33099 | 471 |
2106615 | 2106615 | 2022-01-12 | Henry | Indiana | 18065 | 10912 | 199 |
2106616 | 2106616 | 2022-01-12 | Howard | Indiana | 18067 | 20342 | 376 |
2106617 | 2106617 | 2022-01-12 | Huntington | Indiana | 18069 | 9374 | 140 |
2106618 | 2106618 | 2022-01-12 | Jackson | Indiana | 18071 | 9557 | 106 |
2106619 | 2106619 | 2022-01-12 | Jasper | Indiana | 18073 | 7783 | 117 |
2106620 | 2106620 | 2022-01-12 | Jay | Indiana | 18075 | 3881 | 69 |
2106621 | 2106621 | 2022-01-12 | Jefferson | Indiana | 18077 | 7298 | 127 |
2106622 | 2106622 | 2022-01-12 | Jennings | Indiana | 18079 | 5470 | 80 |
2106623 | 2106623 | 2022-01-12 | Johnson | Indiana | 18081 | 35117 | 535 |
2106624 | 2106624 | 2022-01-12 | Knox | Indiana | 18083 | 8297 | 127 |
2106625 | 2106625 | 2022-01-12 | Kosciusko | Indiana | 18085 | 16993 | 203 |
2106626 | 2106626 | 2022-01-12 | LaGrange | Indiana | 18087 | 4934 | 97 |
2106627 | 2106627 | 2022-01-12 | LaPorte | Indiana | 18091 | 21987 | 305 |
2106628 | 2106628 | 2022-01-12 | Lake | Indiana | 18089 | 96314 | 1490 |
2106629 | 2106629 | 2022-01-12 | Lawrence | Indiana | 18093 | 9462 | 219 |
2106630 | 2106630 | 2022-01-12 | Madison | Indiana | 18095 | 26803 | 549 |
2106631 | 2106631 | 2022-01-12 | Marion | Indiana | 18097 | 190626 | 2556 |
2106632 | 2106632 | 2022-01-12 | Marshall | Indiana | 18099 | 10760 | 173 |
2106633 | 2106633 | 2022-01-12 | Martin | Indiana | 18101 | 1735 | 21 |
2106634 | 2106634 | 2022-01-12 | Miami | Indiana | 18103 | 7612 | 135 |
2106635 | 2106635 | 2022-01-12 | Monroe | Indiana | 18105 | 20765 | 242 |
2106636 | 2106636 | 2022-01-12 | Montgomery | Indiana | 18107 | 8555 | 141 |
2106637 | 2106637 | 2022-01-12 | Morgan | Indiana | 18109 | 13105 | 238 |
2106638 | 2106638 | 2022-01-12 | Newton | Indiana | 18111 | 2203 | 61 |
2106639 | 2106639 | 2022-01-12 | Noble | Indiana | 18113 | 10917 | 142 |
2106640 | 2106640 | 2022-01-12 | Ohio | Indiana | 18115 | 1105 | 16 |
2106641 | 2106641 | 2022-01-12 | Orange | Indiana | 18117 | 3928 | 86 |
2106642 | 2106642 | 2022-01-12 | Owen | Indiana | 18119 | 4454 | 95 |
2106643 | 2106643 | 2022-01-12 | Parke | Indiana | 18121 | 2921 | 39 |
2106644 | 2106644 | 2022-01-12 | Perry | Indiana | 18123 | 3506 | 61 |
2106645 | 2106645 | 2022-01-12 | Pike | Indiana | 18125 | 2951 | 46 |
2106646 | 2106646 | 2022-01-12 | Porter | Indiana | 18127 | 32895 | 470 |
2106647 | 2106647 | 2022-01-12 | Posey | Indiana | 18129 | 4923 | 46 |
2106648 | 2106648 | 2022-01-12 | Pulaski | Indiana | 18131 | 2570 | 74 |
2106649 | 2106649 | 2022-01-12 | Putnam | Indiana | 18133 | 7653 | 100 |
2106650 | 2106650 | 2022-01-12 | Randolph | Indiana | 18135 | 4794 | 128 |
2106651 | 2106651 | 2022-01-12 | Ripley | Indiana | 18137 | 6723 | 112 |
2106652 | 2106652 | 2022-01-12 | Rush | Indiana | 18139 | 3839 | 36 |
2106653 | 2106653 | 2022-01-12 | Scott | Indiana | 18143 | 5984 | 88 |
2106654 | 2106654 | 2022-01-12 | Shelby | Indiana | 18145 | 11817 | 162 |
2106655 | 2106655 | 2022-01-12 | Spencer | Indiana | 18147 | 4232 | 58 |
2106656 | 2106656 | 2022-01-12 | St. Joseph | Indiana | 18141 | 60802 | 763 |
2106657 | 2106657 | 2022-01-12 | Starke | Indiana | 18149 | 4235 | 88 |
2106658 | 2106658 | 2022-01-12 | Steuben | Indiana | 18151 | 7994 | 104 |
2106659 | 2106659 | 2022-01-12 | Sullivan | Indiana | 18153 | 4157 | 65 |
2106660 | 2106660 | 2022-01-12 | Switzerland | Indiana | 18155 | 1795 | 14 |
2106661 | 2106661 | 2022-01-12 | Tippecanoe | Indiana | 18157 | 39428 | 331 |
2106662 | 2106662 | 2022-01-12 | Tipton | Indiana | 18159 | 2964 | 76 |
2106663 | 2106663 | 2022-01-12 | Union | Indiana | 18161 | 1565 | 20 |
2106664 | 2106664 | 2022-01-12 | Vanderburgh | Indiana | 18163 | 42969 | 537 |
2106665 | 2106665 | 2022-01-12 | Vermillion | Indiana | 18165 | 3343 | 62 |
2106666 | 2106666 | 2022-01-12 | Vigo | Indiana | 18167 | 23685 | 345 |
2106667 | 2106667 | 2022-01-12 | Wabash | Indiana | 18169 | 7321 | 137 |
2106668 | 2106668 | 2022-01-12 | Warren | Indiana | 18171 | 1642 | 22 |
2106669 | 2106669 | 2022-01-12 | Warrick | Indiana | 18173 | 15007 | 214 |
2106670 | 2106670 | 2022-01-12 | Washington | Indiana | 18175 | 4551 | 66 |
2106671 | 2106671 | 2022-01-12 | Wayne | Indiana | 18177 | 15333 | 302 |
2106672 | 2106672 | 2022-01-12 | Wells | Indiana | 18179 | 5664 | 122 |
2106673 | 2106673 | 2022-01-12 | White | Indiana | 18181 | 5760 | 80 |
2106674 | 2106674 | 2022-01-12 | Whitley | Indiana | 18183 | 7999 | 72 |
2103332 | 2103332 | 2022-01-11 | Adams | Indiana | 18001 | 6304 | 100 |
2103333 | 2103333 | 2022-01-11 | Allen | Indiana | 18003 | 84384 | 1018 |
2103334 | 2103334 | 2022-01-11 | Bartholomew | Indiana | 18005 | 16136 | 215 |
2103335 | 2103335 | 2022-01-11 | Benton | Indiana | 18007 | 1999 | 21 |
2103336 | 2103336 | 2022-01-11 | Blackford | Indiana | 18009 | 2584 | 57 |
2103337 | 2103337 | 2022-01-11 | Boone | Indiana | 18011 | 12388 | 142 |
2103338 | 2103338 | 2022-01-11 | Brown | Indiana | 18013 | 2127 | 55 |
2103339 | 2103339 | 2022-01-11 | Carroll | Indiana | 18015 | 3501 | 52 |
2103340 | 2103340 | 2022-01-11 | Cass | Indiana | 18017 | 9379 | 146 |
2103341 | 2103341 | 2022-01-11 | Clark | Indiana | 18019 | 23836 | 326 |
2103342 | 2103342 | 2022-01-11 | Clay | Indiana | 18021 | 5574 | 73 |
2103343 | 2103343 | 2022-01-11 | Clinton | Indiana | 18023 | 7537 | 100 |
2103344 | 2103344 | 2022-01-11 | Crawford | Indiana | 18025 | 1992 | 32 |
2103345 | 2103345 | 2022-01-11 | Daviess | Indiana | 18027 | 5894 | 126 |
2103346 | 2103346 | 2022-01-11 | DeKalb | Indiana | 18033 | 9410 | 130 |
2103347 | 2103347 | 2022-01-11 | Dearborn | Indiana | 18029 | 10706 | 119 |
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);