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 148
- 18063 146
- 18113 145
- 18001 144
- 18011 144
- 18067 143
- 18081 143
- 18141 143
- 18091 140
- 18179 140
- 18057 139
- 18005 138
- 18043 138
- 18047 137
- 18089 137
- 18019 136
- 18041 136
- 18079 136
- 18095 136
- 18119 135
- 18157 135
- 18177 135
- 18003 134
- 18053 134
- 18145 134
- 18163 134
- 18167 134
- 18035 133
- 18039 133
- 18059 133
- …
county >30
- Marion 148
- Hendricks 146
- Noble 145
- Adams 144
- Boone 144
- Howard 143
- Johnson 143
- St. Joseph 143
- LaPorte 140
- Wells 140
- Hamilton 139
- Bartholomew 138
- Floyd 138
- Franklin 137
- Lake 137
- Clark 136
- Fayette 136
- Jennings 136
- Madison 136
- Owen 135
- Tippecanoe 135
- Wayne 135
- Allen 134
- Grant 134
- Shelby 134
- Vanderburgh 134
- Vigo 134
- Delaware 133
- Elkhart 133
- Hancock 133
- …
state 1
- Indiana · 11,994 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386638 | 386638 | 2020-07-31 | Adams | Indiana | 18001 | 75 | 3 |
386639 | 386639 | 2020-07-31 | Allen | Indiana | 18003 | 3535 | 167 |
386640 | 386640 | 2020-07-31 | Bartholomew | Indiana | 18005 | 731 | 50 |
386641 | 386641 | 2020-07-31 | Benton | Indiana | 18007 | 59 | 0 |
386642 | 386642 | 2020-07-31 | Blackford | Indiana | 18009 | 56 | 2 |
386643 | 386643 | 2020-07-31 | Boone | Indiana | 18011 | 632 | 49 |
386644 | 386644 | 2020-07-31 | Brown | Indiana | 18013 | 68 | 1 |
386645 | 386645 | 2020-07-31 | Carroll | Indiana | 18015 | 128 | 2 |
386646 | 386646 | 2020-07-31 | Cass | Indiana | 18017 | 1743 | 10 |
386647 | 386647 | 2020-07-31 | Clark | Indiana | 18019 | 1038 | 52 |
386648 | 386648 | 2020-07-31 | Clay | Indiana | 18021 | 94 | 5 |
386649 | 386649 | 2020-07-31 | Clinton | Indiana | 18023 | 342 | 4 |
386650 | 386650 | 2020-07-31 | Crawford | Indiana | 18025 | 41 | 1 |
386651 | 386651 | 2020-07-31 | Daviess | Indiana | 18027 | 237 | 21 |
386652 | 386652 | 2020-07-31 | DeKalb | Indiana | 18033 | 213 | 5 |
386653 | 386653 | 2020-07-31 | Dearborn | Indiana | 18029 | 449 | 29 |
386654 | 386654 | 2020-07-31 | Decatur | Indiana | 18031 | 328 | 35 |
386655 | 386655 | 2020-07-31 | Delaware | Indiana | 18035 | 616 | 53 |
386656 | 386656 | 2020-07-31 | Dubois | Indiana | 18037 | 605 | 12 |
386657 | 386657 | 2020-07-31 | Elkhart | Indiana | 18039 | 4609 | 80 |
386658 | 386658 | 2020-07-31 | Fayette | Indiana | 18041 | 217 | 7 |
386659 | 386659 | 2020-07-31 | Floyd | Indiana | 18043 | 661 | 46 |
386660 | 386660 | 2020-07-31 | Fountain | Indiana | 18045 | 61 | 2 |
386661 | 386661 | 2020-07-31 | Franklin | Indiana | 18047 | 202 | 10 |
386662 | 386662 | 2020-07-31 | Fulton | Indiana | 18049 | 135 | 1 |
386663 | 386663 | 2020-07-31 | Gibson | Indiana | 18051 | 195 | 3 |
386664 | 386664 | 2020-07-31 | Grant | Indiana | 18053 | 707 | 32 |
386665 | 386665 | 2020-07-31 | Greene | Indiana | 18055 | 238 | 37 |
386666 | 386666 | 2020-07-31 | Hamilton | Indiana | 18057 | 2439 | 112 |
386667 | 386667 | 2020-07-31 | Hancock | Indiana | 18059 | 603 | 38 |
386668 | 386668 | 2020-07-31 | Harrison | Indiana | 18061 | 271 | 24 |
386669 | 386669 | 2020-07-31 | Hendricks | Indiana | 18063 | 1735 | 121 |
386670 | 386670 | 2020-07-31 | Henry | Indiana | 18065 | 362 | 18 |
386671 | 386671 | 2020-07-31 | Howard | Indiana | 18067 | 793 | 67 |
386672 | 386672 | 2020-07-31 | Huntington | Indiana | 18069 | 120 | 3 |
386673 | 386673 | 2020-07-31 | Jackson | Indiana | 18071 | 547 | 5 |
386674 | 386674 | 2020-07-31 | Jasper | Indiana | 18073 | 198 | 2 |
386675 | 386675 | 2020-07-31 | Jay | Indiana | 18075 | 85 | 0 |
386676 | 386676 | 2020-07-31 | Jefferson | Indiana | 18077 | 146 | 2 |
386677 | 386677 | 2020-07-31 | Jennings | Indiana | 18079 | 208 | 14 |
386678 | 386678 | 2020-07-31 | Johnson | Indiana | 18081 | 1650 | 126 |
386679 | 386679 | 2020-07-31 | Knox | Indiana | 18083 | 126 | 0 |
386680 | 386680 | 2020-07-31 | Kosciusko | Indiana | 18085 | 815 | 13 |
386681 | 386681 | 2020-07-31 | LaGrange | Indiana | 18087 | 538 | 10 |
386682 | 386682 | 2020-07-31 | LaPorte | Indiana | 18091 | 803 | 29 |
386683 | 386683 | 2020-07-31 | Lake | Indiana | 18089 | 6977 | 283 |
386684 | 386684 | 2020-07-31 | Lawrence | Indiana | 18093 | 318 | 28 |
386685 | 386685 | 2020-07-31 | Madison | Indiana | 18095 | 827 | 75 |
386686 | 386686 | 2020-07-31 | Marion | Indiana | 18097 | 14575 | 766 |
386687 | 386687 | 2020-07-31 | Marshall | Indiana | 18099 | 732 | 22 |
386688 | 386688 | 2020-07-31 | Martin | Indiana | 18101 | 42 | 0 |
386689 | 386689 | 2020-07-31 | Miami | Indiana | 18103 | 250 | 2 |
386690 | 386690 | 2020-07-31 | Monroe | Indiana | 18105 | 665 | 33 |
386691 | 386691 | 2020-07-31 | Montgomery | Indiana | 18107 | 336 | 22 |
386692 | 386692 | 2020-07-31 | Morgan | Indiana | 18109 | 422 | 35 |
386693 | 386693 | 2020-07-31 | Newton | Indiana | 18111 | 109 | 11 |
386694 | 386694 | 2020-07-31 | Noble | Indiana | 18113 | 621 | 29 |
386695 | 386695 | 2020-07-31 | Ohio | Indiana | 18115 | 43 | 4 |
386696 | 386696 | 2020-07-31 | Orange | Indiana | 18117 | 160 | 26 |
386697 | 386697 | 2020-07-31 | Owen | Indiana | 18119 | 73 | 1 |
386698 | 386698 | 2020-07-31 | Parke | Indiana | 18121 | 50 | 1 |
386699 | 386699 | 2020-07-31 | Perry | Indiana | 18123 | 181 | 13 |
386700 | 386700 | 2020-07-31 | Pike | Indiana | 18125 | 37 | 0 |
386701 | 386701 | 2020-07-31 | Porter | Indiana | 18127 | 1140 | 41 |
386702 | 386702 | 2020-07-31 | Posey | Indiana | 18129 | 155 | 0 |
386703 | 386703 | 2020-07-31 | Pulaski | Indiana | 18131 | 73 | 1 |
386704 | 386704 | 2020-07-31 | Putnam | Indiana | 18133 | 222 | 8 |
386705 | 386705 | 2020-07-31 | Randolph | Indiana | 18135 | 131 | 4 |
386706 | 386706 | 2020-07-31 | Ripley | Indiana | 18137 | 185 | 7 |
386707 | 386707 | 2020-07-31 | Rush | Indiana | 18139 | 112 | 4 |
386708 | 386708 | 2020-07-31 | Scott | Indiana | 18143 | 247 | 11 |
386709 | 386709 | 2020-07-31 | Shelby | Indiana | 18145 | 818 | 34 |
386710 | 386710 | 2020-07-31 | Spencer | Indiana | 18147 | 113 | 3 |
386711 | 386711 | 2020-07-31 | St. Joseph | Indiana | 18141 | 3026 | 84 |
386712 | 386712 | 2020-07-31 | Starke | Indiana | 18149 | 158 | 8 |
386713 | 386713 | 2020-07-31 | Steuben | Indiana | 18151 | 193 | 3 |
386714 | 386714 | 2020-07-31 | Sullivan | Indiana | 18153 | 72 | 1 |
386715 | 386715 | 2020-07-31 | Switzerland | Indiana | 18155 | 42 | 0 |
386716 | 386716 | 2020-07-31 | Tippecanoe | Indiana | 18157 | 1056 | 12 |
386717 | 386717 | 2020-07-31 | Tipton | Indiana | 18159 | 98 | 6 |
386718 | 386718 | 2020-07-31 | Union | Indiana | 18161 | 50 | 0 |
386719 | 386719 | 2020-07-31 | Vanderburgh | Indiana | 18163 | 1624 | 10 |
386720 | 386720 | 2020-07-31 | Vermillion | Indiana | 18165 | 31 | 0 |
386721 | 386721 | 2020-07-31 | Vigo | Indiana | 18167 | 426 | 11 |
386722 | 386722 | 2020-07-31 | Wabash | Indiana | 18169 | 155 | 3 |
386723 | 386723 | 2020-07-31 | Warren | Indiana | 18171 | 20 | 1 |
386724 | 386724 | 2020-07-31 | Warrick | Indiana | 18173 | 473 | 31 |
386725 | 386725 | 2020-07-31 | Washington | Indiana | 18175 | 104 | 1 |
386726 | 386726 | 2020-07-31 | Wayne | Indiana | 18177 | 579 | 9 |
386727 | 386727 | 2020-07-31 | Wells | Indiana | 18179 | 141 | 2 |
386728 | 386728 | 2020-07-31 | White | Indiana | 18181 | 341 | 10 |
386729 | 386729 | 2020-07-31 | Whitley | Indiana | 18183 | 143 | 6 |
383420 | 383420 | 2020-07-30 | Adams | Indiana | 18001 | 74 | 2 |
383421 | 383421 | 2020-07-30 | Allen | Indiana | 18003 | 3506 | 165 |
383422 | 383422 | 2020-07-30 | Bartholomew | Indiana | 18005 | 723 | 50 |
383423 | 383423 | 2020-07-30 | Benton | Indiana | 18007 | 56 | 0 |
383424 | 383424 | 2020-07-30 | Blackford | Indiana | 18009 | 56 | 2 |
383425 | 383425 | 2020-07-30 | Boone | Indiana | 18011 | 627 | 48 |
383426 | 383426 | 2020-07-30 | Brown | Indiana | 18013 | 67 | 1 |
383427 | 383427 | 2020-07-30 | Carroll | Indiana | 18015 | 125 | 2 |
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);