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
county >30
- Marion 33
- Hendricks 31
- Noble 30
- Adams 29
- Boone 29
- Howard 28
- Johnson 28
- St. Joseph 28
- LaPorte 25
- Wells 25
- Hamilton 24
- Bartholomew 23
- Floyd 23
- Franklin 22
- Lake 22
- Clark 21
- Fayette 21
- Jennings 21
- Madison 21
- Owen 20
- Tippecanoe 20
- Wayne 20
- Allen 19
- Grant 19
- Shelby 19
- Vanderburgh 19
- Vigo 19
- Delaware 18
- Elkhart 18
- Hancock 18
- …
state 1
- Indiana · 1,424 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
38705 | 38705 | 2020-04-07 | Adams | Indiana | 18001 | 2 | 0 |
38706 | 38706 | 2020-04-07 | Allen | Indiana | 18003 | 89 | 8 |
38707 | 38707 | 2020-04-07 | Bartholomew | Indiana | 18005 | 56 | 5 |
38708 | 38708 | 2020-04-07 | Blackford | Indiana | 18009 | 4 | 0 |
38709 | 38709 | 2020-04-07 | Boone | Indiana | 18011 | 75 | 2 |
38710 | 38710 | 2020-04-07 | Brown | Indiana | 18013 | 8 | 1 |
38711 | 38711 | 2020-04-07 | Carroll | Indiana | 18015 | 3 | 0 |
38712 | 38712 | 2020-04-07 | Cass | Indiana | 18017 | 13 | 1 |
38713 | 38713 | 2020-04-07 | Clark | Indiana | 18019 | 83 | 8 |
38714 | 38714 | 2020-04-07 | Clay | Indiana | 18021 | 7 | 0 |
38715 | 38715 | 2020-04-07 | Clinton | Indiana | 18023 | 6 | 1 |
38716 | 38716 | 2020-04-07 | Crawford | Indiana | 18025 | 9 | 0 |
38717 | 38717 | 2020-04-07 | Daviess | Indiana | 18027 | 4 | 0 |
38718 | 38718 | 2020-04-07 | DeKalb | Indiana | 18033 | 4 | 0 |
38719 | 38719 | 2020-04-07 | Dearborn | Indiana | 18029 | 41 | 1 |
38720 | 38720 | 2020-04-07 | Decatur | Indiana | 18031 | 92 | 8 |
38721 | 38721 | 2020-04-07 | Delaware | Indiana | 18035 | 40 | 1 |
38722 | 38722 | 2020-04-07 | Dubois | Indiana | 18037 | 7 | 0 |
38723 | 38723 | 2020-04-07 | Elkhart | Indiana | 18039 | 43 | 3 |
38724 | 38724 | 2020-04-07 | Fayette | Indiana | 18041 | 18 | 3 |
38725 | 38725 | 2020-04-07 | Floyd | Indiana | 18043 | 74 | 1 |
38726 | 38726 | 2020-04-07 | Fountain | Indiana | 18045 | 2 | 1 |
38727 | 38727 | 2020-04-07 | Franklin | Indiana | 18047 | 60 | 7 |
38728 | 38728 | 2020-04-07 | Fulton | Indiana | 18049 | 3 | 0 |
38729 | 38729 | 2020-04-07 | Gibson | Indiana | 18051 | 4 | 0 |
38730 | 38730 | 2020-04-07 | Grant | Indiana | 18053 | 21 | 3 |
38731 | 38731 | 2020-04-07 | Greene | Indiana | 18055 | 11 | 0 |
38732 | 38732 | 2020-04-07 | Hamilton | Indiana | 18057 | 363 | 10 |
38733 | 38733 | 2020-04-07 | Hancock | Indiana | 18059 | 89 | 2 |
38734 | 38734 | 2020-04-07 | Harrison | Indiana | 18061 | 48 | 1 |
38735 | 38735 | 2020-04-07 | Hendricks | Indiana | 18063 | 226 | 6 |
38736 | 38736 | 2020-04-07 | Henry | Indiana | 18065 | 16 | 0 |
38737 | 38737 | 2020-04-07 | Howard | Indiana | 18067 | 38 | 5 |
38738 | 38738 | 2020-04-07 | Huntington | Indiana | 18069 | 6 | 1 |
38739 | 38739 | 2020-04-07 | Jackson | Indiana | 18071 | 40 | 0 |
38740 | 38740 | 2020-04-07 | Jasper | Indiana | 18073 | 15 | 1 |
38741 | 38741 | 2020-04-07 | Jay | Indiana | 18075 | 3 | 0 |
38742 | 38742 | 2020-04-07 | Jefferson | Indiana | 18077 | 6 | 0 |
38743 | 38743 | 2020-04-07 | Jennings | Indiana | 18079 | 43 | 2 |
38744 | 38744 | 2020-04-07 | Johnson | Indiana | 18081 | 212 | 7 |
38745 | 38745 | 2020-04-07 | Knox | Indiana | 18083 | 9 | 0 |
38746 | 38746 | 2020-04-07 | Kosciusko | Indiana | 18085 | 14 | 0 |
38747 | 38747 | 2020-04-07 | LaGrange | Indiana | 18087 | 6 | 1 |
38748 | 38748 | 2020-04-07 | LaPorte | Indiana | 18091 | 25 | 3 |
38749 | 38749 | 2020-04-07 | Lake | Indiana | 18089 | 419 | 12 |
38750 | 38750 | 2020-04-07 | Lawrence | Indiana | 18093 | 45 | 6 |
38751 | 38751 | 2020-04-07 | Madison | Indiana | 18095 | 145 | 19 |
38752 | 38752 | 2020-04-07 | Marion | Indiana | 18097 | 2147 | 54 |
38753 | 38753 | 2020-04-07 | Marshall | Indiana | 18099 | 10 | 0 |
38754 | 38754 | 2020-04-07 | Martin | Indiana | 18101 | 2 | 0 |
38755 | 38755 | 2020-04-07 | Miami | Indiana | 18103 | 9 | 0 |
38756 | 38756 | 2020-04-07 | Monroe | Indiana | 18105 | 54 | 0 |
38757 | 38757 | 2020-04-07 | Montgomery | Indiana | 18107 | 16 | 0 |
38758 | 38758 | 2020-04-07 | Morgan | Indiana | 18109 | 79 | 1 |
38759 | 38759 | 2020-04-07 | Newton | Indiana | 18111 | 6 | 1 |
38760 | 38760 | 2020-04-07 | Noble | Indiana | 18113 | 11 | 1 |
38761 | 38761 | 2020-04-07 | Ohio | Indiana | 18115 | 1 | 0 |
38762 | 38762 | 2020-04-07 | Orange | Indiana | 18117 | 14 | 2 |
38763 | 38763 | 2020-04-07 | Owen | Indiana | 18119 | 17 | 0 |
38764 | 38764 | 2020-04-07 | Parke | Indiana | 18121 | 6 | 0 |
38765 | 38765 | 2020-04-07 | Porter | Indiana | 18127 | 84 | 0 |
38766 | 38766 | 2020-04-07 | Posey | Indiana | 18129 | 5 | 0 |
38767 | 38767 | 2020-04-07 | Pulaski | Indiana | 18131 | 1 | 0 |
38768 | 38768 | 2020-04-07 | Putnam | Indiana | 18133 | 25 | 1 |
38769 | 38769 | 2020-04-07 | Randolph | Indiana | 18135 | 7 | 1 |
38770 | 38770 | 2020-04-07 | Ripley | Indiana | 18137 | 76 | 2 |
38771 | 38771 | 2020-04-07 | Rush | Indiana | 18139 | 14 | 1 |
38772 | 38772 | 2020-04-07 | Scott | Indiana | 18143 | 8 | 1 |
38773 | 38773 | 2020-04-07 | Shelby | Indiana | 18145 | 52 | 1 |
38774 | 38774 | 2020-04-07 | Spencer | Indiana | 18147 | 1 | 0 |
38775 | 38775 | 2020-04-07 | St. Joseph | Indiana | 18141 | 132 | 4 |
38776 | 38776 | 2020-04-07 | Starke | Indiana | 18149 | 5 | 0 |
38777 | 38777 | 2020-04-07 | Steuben | Indiana | 18151 | 9 | 0 |
38778 | 38778 | 2020-04-07 | Sullivan | Indiana | 18153 | 3 | 0 |
38779 | 38779 | 2020-04-07 | Switzerland | Indiana | 18155 | 11 | 0 |
38780 | 38780 | 2020-04-07 | Tippecanoe | Indiana | 18157 | 36 | 1 |
38781 | 38781 | 2020-04-07 | Tipton | Indiana | 18159 | 8 | 0 |
38782 | 38782 | 2020-04-07 | Union | Indiana | 18161 | 3 | 0 |
38783 | 38783 | 2020-04-07 | Vanderburgh | Indiana | 18163 | 41 | 1 |
38784 | 38784 | 2020-04-07 | Vermillion | Indiana | 18165 | 2 | 0 |
38785 | 38785 | 2020-04-07 | Vigo | Indiana | 18167 | 26 | 3 |
38786 | 38786 | 2020-04-07 | Wabash | Indiana | 18169 | 5 | 0 |
38787 | 38787 | 2020-04-07 | Warren | Indiana | 18171 | 2 | 1 |
38788 | 38788 | 2020-04-07 | Warrick | Indiana | 18173 | 23 | 0 |
38789 | 38789 | 2020-04-07 | Washington | Indiana | 18175 | 20 | 0 |
38790 | 38790 | 2020-04-07 | Wayne | Indiana | 18177 | 13 | 1 |
38791 | 38791 | 2020-04-07 | Wells | Indiana | 18179 | 2 | 0 |
38792 | 38792 | 2020-04-07 | White | Indiana | 18181 | 3 | 0 |
38793 | 38793 | 2020-04-07 | Whitley | Indiana | 18183 | 8 | 1 |
36207 | 36207 | 2020-04-06 | Adams | Indiana | 18001 | 2 | 0 |
36208 | 36208 | 2020-04-06 | Allen | Indiana | 18003 | 89 | 8 |
36209 | 36209 | 2020-04-06 | Bartholomew | Indiana | 18005 | 55 | 2 |
36210 | 36210 | 2020-04-06 | Blackford | Indiana | 18009 | 4 | 0 |
36211 | 36211 | 2020-04-06 | Boone | Indiana | 18011 | 65 | 2 |
36212 | 36212 | 2020-04-06 | Brown | Indiana | 18013 | 7 | 0 |
36213 | 36213 | 2020-04-06 | Carroll | Indiana | 18015 | 3 | 0 |
36214 | 36214 | 2020-04-06 | Cass | Indiana | 18017 | 4 | 0 |
36215 | 36215 | 2020-04-06 | Clark | Indiana | 18019 | 72 | 5 |
36216 | 36216 | 2020-04-06 | Clay | Indiana | 18021 | 5 | 0 |
36217 | 36217 | 2020-04-06 | Clinton | Indiana | 18023 | 4 | 0 |
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);