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 266
- 18063 264
- 18113 263
- 18001 262
- 18011 262
- 18067 261
- 18081 261
- 18141 261
- 18091 258
- 18179 258
- 18057 257
- 18005 256
- 18043 256
- 18047 255
- 18089 255
- 18019 254
- 18041 254
- 18079 254
- 18095 254
- 18119 253
- 18157 253
- 18177 253
- 18003 252
- 18053 252
- 18145 252
- 18163 252
- 18167 252
- 18035 251
- 18039 251
- 18059 251
- …
county >30
- Marion 266
- Hendricks 264
- Noble 263
- Adams 262
- Boone 262
- Howard 261
- Johnson 261
- St. Joseph 261
- LaPorte 258
- Wells 258
- Hamilton 257
- Bartholomew 256
- Floyd 256
- Franklin 255
- Lake 255
- Clark 254
- Fayette 254
- Jennings 254
- Madison 254
- Owen 253
- Tippecanoe 253
- Wayne 253
- Allen 252
- Grant 252
- Shelby 252
- Vanderburgh 252
- Vigo 252
- Delaware 251
- Elkhart 251
- Hancock 251
- …
state 1
- Indiana · 22,850 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
768610 | 768610 | 2020-11-26 | Adams | Indiana | 18001 | 1711 | 23 |
768611 | 768611 | 2020-11-26 | Allen | Indiana | 18003 | 18398 | 311 |
768612 | 768612 | 2020-11-26 | Bartholomew | Indiana | 18005 | 3252 | 68 |
768613 | 768613 | 2020-11-26 | Benton | Indiana | 18007 | 355 | 3 |
768614 | 768614 | 2020-11-26 | Blackford | Indiana | 18009 | 551 | 12 |
768615 | 768615 | 2020-11-26 | Boone | Indiana | 18011 | 2505 | 57 |
768616 | 768616 | 2020-11-26 | Brown | Indiana | 18013 | 351 | 4 |
768617 | 768617 | 2020-11-26 | Carroll | Indiana | 18015 | 696 | 13 |
768618 | 768618 | 2020-11-26 | Cass | Indiana | 18017 | 3029 | 32 |
768619 | 768619 | 2020-11-26 | Clark | Indiana | 18019 | 5248 | 84 |
768620 | 768620 | 2020-11-26 | Clay | Indiana | 18021 | 1265 | 23 |
768621 | 768621 | 2020-11-26 | Clinton | Indiana | 18023 | 1825 | 25 |
768622 | 768622 | 2020-11-26 | Crawford | Indiana | 18025 | 304 | 2 |
768623 | 768623 | 2020-11-26 | Daviess | Indiana | 18027 | 1603 | 46 |
768624 | 768624 | 2020-11-26 | DeKalb | Indiana | 18033 | 1818 | 33 |
768625 | 768625 | 2020-11-26 | Dearborn | Indiana | 18029 | 2234 | 33 |
768626 | 768626 | 2020-11-26 | Decatur | Indiana | 18031 | 1324 | 46 |
768627 | 768627 | 2020-11-26 | Delaware | Indiana | 18035 | 5026 | 107 |
768628 | 768628 | 2020-11-26 | Dubois | Indiana | 18037 | 2430 | 32 |
768629 | 768629 | 2020-11-26 | Elkhart | Indiana | 18039 | 17569 | 234 |
768630 | 768630 | 2020-11-26 | Fayette | Indiana | 18041 | 1630 | 35 |
768631 | 768631 | 2020-11-26 | Floyd | Indiana | 18043 | 3257 | 81 |
768632 | 768632 | 2020-11-26 | Fountain | Indiana | 18045 | 808 | 8 |
768633 | 768633 | 2020-11-26 | Franklin | Indiana | 18047 | 727 | 28 |
768634 | 768634 | 2020-11-26 | Fulton | Indiana | 18049 | 866 | 19 |
768635 | 768635 | 2020-11-26 | Gibson | Indiana | 18051 | 1896 | 26 |
768636 | 768636 | 2020-11-26 | Grant | Indiana | 18053 | 3247 | 53 |
768637 | 768637 | 2020-11-26 | Greene | Indiana | 18055 | 1054 | 56 |
768638 | 768638 | 2020-11-26 | Hamilton | Indiana | 18057 | 13412 | 179 |
768639 | 768639 | 2020-11-26 | Hancock | Indiana | 18059 | 2622 | 58 |
768640 | 768640 | 2020-11-26 | Harrison | Indiana | 18061 | 1458 | 26 |
768641 | 768641 | 2020-11-26 | Hendricks | Indiana | 18063 | 6302 | 175 |
768642 | 768642 | 2020-11-26 | Henry | Indiana | 18065 | 2542 | 38 |
768643 | 768643 | 2020-11-26 | Howard | Indiana | 18067 | 3588 | 80 |
768644 | 768644 | 2020-11-26 | Huntington | Indiana | 18069 | 1312 | 10 |
768645 | 768645 | 2020-11-26 | Jackson | Indiana | 18071 | 2230 | 35 |
768646 | 768646 | 2020-11-26 | Jasper | Indiana | 18073 | 1476 | 14 |
768647 | 768647 | 2020-11-26 | Jay | Indiana | 18075 | 1017 | 15 |
768648 | 768648 | 2020-11-26 | Jefferson | Indiana | 18077 | 1230 | 16 |
768649 | 768649 | 2020-11-26 | Jennings | Indiana | 18079 | 891 | 16 |
768650 | 768650 | 2020-11-26 | Johnson | Indiana | 18081 | 6602 | 178 |
768651 | 768651 | 2020-11-26 | Knox | Indiana | 18083 | 1899 | 20 |
768652 | 768652 | 2020-11-26 | Kosciusko | Indiana | 18085 | 4705 | 42 |
768653 | 768653 | 2020-11-26 | LaGrange | Indiana | 18087 | 1454 | 32 |
768654 | 768654 | 2020-11-26 | LaPorte | Indiana | 18091 | 4753 | 96 |
768655 | 768655 | 2020-11-26 | Lake | Indiana | 18089 | 27660 | 481 |
768656 | 768656 | 2020-11-26 | Lawrence | Indiana | 18093 | 1799 | 50 |
768657 | 768657 | 2020-11-26 | Madison | Indiana | 18095 | 5177 | 135 |
768658 | 768658 | 2020-11-26 | Marion | Indiana | 18097 | 43569 | 910 |
768659 | 768659 | 2020-11-26 | Marshall | Indiana | 18099 | 3081 | 46 |
768660 | 768660 | 2020-11-26 | Martin | Indiana | 18101 | 365 | 5 |
768661 | 768661 | 2020-11-26 | Miami | Indiana | 18103 | 1671 | 14 |
768662 | 768662 | 2020-11-26 | Monroe | Indiana | 18105 | 5433 | 54 |
768663 | 768663 | 2020-11-26 | Montgomery | Indiana | 18107 | 1468 | 28 |
768664 | 768664 | 2020-11-26 | Morgan | Indiana | 18109 | 2169 | 47 |
768665 | 768665 | 2020-11-26 | Newton | Indiana | 18111 | 570 | 13 |
768666 | 768666 | 2020-11-26 | Noble | Indiana | 18113 | 2618 | 48 |
768667 | 768667 | 2020-11-26 | Ohio | Indiana | 18115 | 233 | 7 |
768668 | 768668 | 2020-11-26 | Orange | Indiana | 18117 | 692 | 30 |
768669 | 768669 | 2020-11-26 | Owen | Indiana | 18119 | 632 | 8 |
768670 | 768670 | 2020-11-26 | Parke | Indiana | 18121 | 602 | 6 |
768671 | 768671 | 2020-11-26 | Perry | Indiana | 18123 | 847 | 22 |
768672 | 768672 | 2020-11-26 | Pike | Indiana | 18125 | 516 | 19 |
768673 | 768673 | 2020-11-26 | Porter | Indiana | 18127 | 8461 | 89 |
768674 | 768674 | 2020-11-26 | Posey | Indiana | 18129 | 1241 | 16 |
768675 | 768675 | 2020-11-26 | Pulaski | Indiana | 18131 | 413 | 15 |
768676 | 768676 | 2020-11-26 | Putnam | Indiana | 18133 | 1285 | 28 |
768677 | 768677 | 2020-11-26 | Randolph | Indiana | 18135 | 1301 | 21 |
768678 | 768678 | 2020-11-26 | Ripley | Indiana | 18137 | 1387 | 15 |
768679 | 768679 | 2020-11-26 | Rush | Indiana | 18139 | 618 | 8 |
768680 | 768680 | 2020-11-26 | Scott | Indiana | 18143 | 1130 | 22 |
768681 | 768681 | 2020-11-26 | Shelby | Indiana | 18145 | 2538 | 65 |
768682 | 768682 | 2020-11-26 | Spencer | Indiana | 18147 | 861 | 8 |
768683 | 768683 | 2020-11-26 | St. Joseph | Indiana | 18141 | 17098 | 245 |
768684 | 768684 | 2020-11-26 | Starke | Indiana | 18149 | 942 | 22 |
768685 | 768685 | 2020-11-26 | Steuben | Indiana | 18151 | 1511 | 13 |
768686 | 768686 | 2020-11-26 | Sullivan | Indiana | 18153 | 997 | 16 |
768687 | 768687 | 2020-11-26 | Switzerland | Indiana | 18155 | 262 | 5 |
768688 | 768688 | 2020-11-26 | Tippecanoe | Indiana | 18157 | 8809 | 30 |
768689 | 768689 | 2020-11-26 | Tipton | Indiana | 18159 | 594 | 30 |
768690 | 768690 | 2020-11-26 | Union | Indiana | 18161 | 304 | 2 |
768691 | 768691 | 2020-11-26 | Vanderburgh | Indiana | 18163 | 9844 | 122 |
768692 | 768692 | 2020-11-26 | Vermillion | Indiana | 18165 | 645 | 4 |
768693 | 768693 | 2020-11-26 | Vigo | Indiana | 18167 | 6189 | 89 |
768694 | 768694 | 2020-11-26 | Wabash | Indiana | 18169 | 1687 | 21 |
768695 | 768695 | 2020-11-26 | Warren | Indiana | 18171 | 256 | 3 |
768696 | 768696 | 2020-11-26 | Warrick | Indiana | 18173 | 3300 | 74 |
768697 | 768697 | 2020-11-26 | Washington | Indiana | 18175 | 783 | 7 |
768698 | 768698 | 2020-11-26 | Wayne | Indiana | 18177 | 3579 | 76 |
768699 | 768699 | 2020-11-26 | Wells | Indiana | 18179 | 1303 | 32 |
768700 | 768700 | 2020-11-26 | White | Indiana | 18181 | 1275 | 22 |
768701 | 768701 | 2020-11-26 | Whitley | Indiana | 18183 | 1408 | 14 |
765364 | 765364 | 2020-11-25 | Adams | Indiana | 18001 | 1683 | 23 |
765365 | 765365 | 2020-11-25 | Allen | Indiana | 18003 | 18045 | 310 |
765366 | 765366 | 2020-11-25 | Bartholomew | Indiana | 18005 | 3185 | 68 |
765367 | 765367 | 2020-11-25 | Benton | Indiana | 18007 | 340 | 2 |
765368 | 765368 | 2020-11-25 | Blackford | Indiana | 18009 | 545 | 12 |
765369 | 765369 | 2020-11-25 | Boone | Indiana | 18011 | 2463 | 57 |
765370 | 765370 | 2020-11-25 | Brown | Indiana | 18013 | 342 | 4 |
765371 | 765371 | 2020-11-25 | Carroll | Indiana | 18015 | 686 | 13 |
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);