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 790
- 18063 788
- 18113 787
- 18001 786
- 18011 786
- 18067 785
- 18081 785
- 18141 785
- 18091 782
- 18179 782
- 18057 781
- 18005 780
- 18043 780
- 18047 779
- 18089 779
- 18019 778
- 18041 778
- 18079 778
- 18095 778
- 18119 777
- 18157 777
- 18177 777
- 18003 776
- 18053 776
- 18145 776
- 18163 776
- 18167 776
- 18035 775
- 18039 775
- 18059 775
- …
county >30
- Marion 790
- Hendricks 788
- Noble 787
- Adams 786
- Boone 786
- Howard 785
- Johnson 785
- St. Joseph 785
- LaPorte 782
- Wells 782
- Hamilton 781
- Bartholomew 780
- Floyd 780
- Franklin 779
- Lake 779
- Clark 778
- Fayette 778
- Jennings 778
- Madison 778
- Owen 777
- Tippecanoe 777
- Wayne 777
- Allen 776
- Grant 776
- Shelby 776
- Vanderburgh 776
- Vigo 776
- Delaware 775
- Elkhart 775
- Hancock 775
- …
state 1
- Indiana · 71,084 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470960 | 2470960 | 2022-05-04 | Adams | Indiana | 18001 | 7276 | 112 |
2470961 | 2470961 | 2022-05-04 | Allen | Indiana | 18003 | 104305 | 1186 |
2470962 | 2470962 | 2022-05-04 | Bartholomew | Indiana | 18005 | 21442 | 249 |
2470963 | 2470963 | 2022-05-04 | Benton | Indiana | 18007 | 2491 | 21 |
2470964 | 2470964 | 2022-05-04 | Blackford | Indiana | 18009 | 3115 | 69 |
2470965 | 2470965 | 2022-05-04 | Boone | Indiana | 18011 | 15357 | 184 |
2470966 | 2470966 | 2022-05-04 | Brown | Indiana | 18013 | 2593 | 62 |
2470967 | 2470967 | 2022-05-04 | Carroll | Indiana | 18015 | 4258 | 68 |
2470968 | 2470968 | 2022-05-04 | Cass | Indiana | 18017 | 11692 | 163 |
2470969 | 2470969 | 2022-05-04 | Clark | Indiana | 18019 | 31369 | 396 |
2470970 | 2470970 | 2022-05-04 | Clay | Indiana | 18021 | 6840 | 88 |
2470971 | 2470971 | 2022-05-04 | Clinton | Indiana | 18023 | 9227 | 126 |
2470972 | 2470972 | 2022-05-04 | Crawford | Indiana | 18025 | 2558 | 40 |
2470973 | 2470973 | 2022-05-04 | Daviess | Indiana | 18027 | 7489 | 154 |
2470974 | 2470974 | 2022-05-04 | DeKalb | Indiana | 18033 | 11382 | 152 |
2470975 | 2470975 | 2022-05-04 | Dearborn | Indiana | 18029 | 13509 | 140 |
2470976 | 2470976 | 2022-05-04 | Decatur | Indiana | 18031 | 7010 | 145 |
2470977 | 2470977 | 2022-05-04 | Delaware | Indiana | 18035 | 24990 | 443 |
2470978 | 2470978 | 2022-05-04 | Dubois | Indiana | 18037 | 12881 | 165 |
2470979 | 2470979 | 2022-05-04 | Elkhart | Indiana | 18039 | 54248 | 733 |
2470980 | 2470980 | 2022-05-04 | Fayette | Indiana | 18041 | 6745 | 146 |
2470981 | 2470981 | 2022-05-04 | Floyd | Indiana | 18043 | 19087 | 301 |
2470982 | 2470982 | 2022-05-04 | Fountain | Indiana | 18045 | 5462 | 103 |
2470983 | 2470983 | 2022-05-04 | Franklin | Indiana | 18047 | 4380 | 65 |
2470984 | 2470984 | 2022-05-04 | Fulton | Indiana | 18049 | 4929 | 103 |
2470985 | 2470985 | 2022-05-04 | Gibson | Indiana | 18051 | 11695 | 145 |
2470986 | 2470986 | 2022-05-04 | Grant | Indiana | 18053 | 17352 | 352 |
2470987 | 2470987 | 2022-05-04 | Greene | Indiana | 18055 | 7236 | 139 |
2470988 | 2470988 | 2022-05-04 | Hamilton | Indiana | 18057 | 82726 | 661 |
2470989 | 2470989 | 2022-05-04 | Hancock | Indiana | 18059 | 20778 | 258 |
2470990 | 2470990 | 2022-05-04 | Harrison | Indiana | 18061 | 10851 | 138 |
2470991 | 2470991 | 2022-05-04 | Hendricks | Indiana | 18063 | 40913 | 555 |
2470992 | 2470992 | 2022-05-04 | Henry | Indiana | 18065 | 13020 | 231 |
2470993 | 2470993 | 2022-05-04 | Howard | Indiana | 18067 | 25481 | 449 |
2470994 | 2470994 | 2022-05-04 | Huntington | Indiana | 18069 | 11542 | 157 |
2470995 | 2470995 | 2022-05-04 | Jackson | Indiana | 18071 | 12548 | 130 |
2470996 | 2470996 | 2022-05-04 | Jasper | Indiana | 18073 | 9104 | 149 |
2470997 | 2470997 | 2022-05-04 | Jay | Indiana | 18075 | 4856 | 78 |
2470998 | 2470998 | 2022-05-04 | Jefferson | Indiana | 18077 | 9357 | 159 |
2470999 | 2470999 | 2022-05-04 | Jennings | Indiana | 18079 | 6974 | 108 |
2471000 | 2471000 | 2022-05-04 | Johnson | Indiana | 18081 | 42622 | 614 |
2471001 | 2471001 | 2022-05-04 | Knox | Indiana | 18083 | 10770 | 153 |
2471002 | 2471002 | 2022-05-04 | Kosciusko | Indiana | 18085 | 19797 | 237 |
2471003 | 2471003 | 2022-05-04 | LaGrange | Indiana | 18087 | 5860 | 102 |
2471004 | 2471004 | 2022-05-04 | LaPorte | Indiana | 18091 | 25721 | 368 |
2471005 | 2471005 | 2022-05-04 | Lake | Indiana | 18089 | 107616 | 1826 |
2471006 | 2471006 | 2022-05-04 | Lawrence | Indiana | 18093 | 11950 | 260 |
2471007 | 2471007 | 2022-05-04 | Madison | Indiana | 18095 | 32790 | 652 |
2471008 | 2471008 | 2022-05-04 | Marion | Indiana | 18097 | 226560 | 2995 |
2471009 | 2471009 | 2022-05-04 | Marshall | Indiana | 18099 | 12400 | 197 |
2471010 | 2471010 | 2022-05-04 | Martin | Indiana | 18101 | 2169 | 25 |
2471011 | 2471011 | 2022-05-04 | Miami | Indiana | 18103 | 9280 | 159 |
2471012 | 2471012 | 2022-05-04 | Monroe | Indiana | 18105 | 28457 | 280 |
2471013 | 2471013 | 2022-05-04 | Montgomery | Indiana | 18107 | 10706 | 164 |
2471014 | 2471014 | 2022-05-04 | Morgan | Indiana | 18109 | 16529 | 287 |
2471015 | 2471015 | 2022-05-04 | Newton | Indiana | 18111 | 2581 | 68 |
2471016 | 2471016 | 2022-05-04 | Noble | Indiana | 18113 | 13100 | 157 |
2471017 | 2471017 | 2022-05-04 | Ohio | Indiana | 18115 | 1451 | 19 |
2471018 | 2471018 | 2022-05-04 | Orange | Indiana | 18117 | 5049 | 96 |
2471019 | 2471019 | 2022-05-04 | Owen | Indiana | 18119 | 5877 | 121 |
2471020 | 2471020 | 2022-05-04 | Parke | Indiana | 18121 | 3600 | 46 |
2471021 | 2471021 | 2022-05-04 | Perry | Indiana | 18123 | 4659 | 69 |
2471022 | 2471022 | 2022-05-04 | Pike | Indiana | 18125 | 3743 | 49 |
2471023 | 2471023 | 2022-05-04 | Porter | Indiana | 18127 | 38223 | 562 |
2471024 | 2471024 | 2022-05-04 | Posey | Indiana | 18129 | 6559 | 58 |
2471025 | 2471025 | 2022-05-04 | Pulaski | Indiana | 18131 | 3081 | 86 |
2471026 | 2471026 | 2022-05-04 | Putnam | Indiana | 18133 | 9381 | 129 |
2471027 | 2471027 | 2022-05-04 | Randolph | Indiana | 18135 | 5912 | 148 |
2471028 | 2471028 | 2022-05-04 | Ripley | Indiana | 18137 | 8329 | 138 |
2471029 | 2471029 | 2022-05-04 | Rush | Indiana | 18139 | 4849 | 58 |
2471030 | 2471030 | 2022-05-04 | Scott | Indiana | 18143 | 7885 | 106 |
2471031 | 2471031 | 2022-05-04 | Shelby | Indiana | 18145 | 13622 | 182 |
2471032 | 2471032 | 2022-05-04 | Spencer | Indiana | 18147 | 5240 | 61 |
2471033 | 2471033 | 2022-05-04 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2471034 | 2471034 | 2022-05-04 | Starke | Indiana | 18149 | 4765 | 99 |
2471035 | 2471035 | 2022-05-04 | Steuben | Indiana | 18151 | 9642 | 121 |
2471036 | 2471036 | 2022-05-04 | Sullivan | Indiana | 18153 | 5288 | 76 |
2471037 | 2471037 | 2022-05-04 | Switzerland | Indiana | 18155 | 2315 | 20 |
2471038 | 2471038 | 2022-05-04 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2471039 | 2471039 | 2022-05-04 | Tipton | Indiana | 18159 | 3534 | 87 |
2471040 | 2471040 | 2022-05-04 | Union | Indiana | 18161 | 2022 | 21 |
2471041 | 2471041 | 2022-05-04 | Unknown | Indiana | 0 | 21 | |
2471042 | 2471042 | 2022-05-04 | Vanderburgh | Indiana | 18163 | 57582 | 635 |
2471043 | 2471043 | 2022-05-04 | Vermillion | Indiana | 18165 | 4095 | 75 |
2471044 | 2471044 | 2022-05-04 | Vigo | Indiana | 18167 | 28961 | 413 |
2471045 | 2471045 | 2022-05-04 | Wabash | Indiana | 18169 | 8736 | 156 |
2471046 | 2471046 | 2022-05-04 | Warren | Indiana | 18171 | 2107 | 30 |
2471047 | 2471047 | 2022-05-04 | Warrick | Indiana | 18173 | 20343 | 239 |
2471048 | 2471048 | 2022-05-04 | Washington | Indiana | 18175 | 6004 | 85 |
2471049 | 2471049 | 2022-05-04 | Wayne | Indiana | 18177 | 18864 | 337 |
2471050 | 2471050 | 2022-05-04 | Wells | Indiana | 18179 | 6507 | 132 |
2471051 | 2471051 | 2022-05-04 | White | Indiana | 18181 | 6917 | 96 |
2471052 | 2471052 | 2022-05-04 | Whitley | Indiana | 18183 | 9691 | 84 |
2467704 | 2467704 | 2022-05-03 | Adams | Indiana | 18001 | 7275 | 112 |
2467705 | 2467705 | 2022-05-03 | Allen | Indiana | 18003 | 104248 | 1186 |
2467706 | 2467706 | 2022-05-03 | Bartholomew | Indiana | 18005 | 21425 | 249 |
2467707 | 2467707 | 2022-05-03 | Benton | Indiana | 18007 | 2488 | 21 |
2467708 | 2467708 | 2022-05-03 | Blackford | Indiana | 18009 | 3115 | 69 |
2467709 | 2467709 | 2022-05-03 | Boone | Indiana | 18011 | 15345 | 184 |
2467710 | 2467710 | 2022-05-03 | Brown | Indiana | 18013 | 2593 | 62 |
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);