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 798
- 18063 796
- 18113 795
- 18001 793
- 18011 793
- 18067 793
- 18081 793
- 18141 793
- 18091 790
- 18179 790
- 18057 789
- 18043 788
- 18005 787
- 18047 787
- 18089 787
- 18019 786
- 18041 786
- 18079 786
- 18095 786
- 18119 785
- 18157 785
- 18177 785
- 18053 784
- 18145 784
- 18163 784
- 18167 784
- 18003 783
- 18035 783
- 18039 783
- 18059 783
- …
county >30
- Marion 798
- Hendricks 796
- Noble 795
- Adams 793
- Boone 793
- Howard 793
- Johnson 793
- St. Joseph 793
- LaPorte 790
- Wells 790
- Hamilton 789
- Floyd 788
- Bartholomew 787
- Franklin 787
- Lake 787
- Clark 786
- Fayette 786
- Jennings 786
- Madison 786
- Owen 785
- Tippecanoe 785
- Wayne 785
- Grant 784
- Shelby 784
- Vanderburgh 784
- Vigo 784
- Allen 783
- Delaware 783
- Elkhart 783
- Hancock 783
- …
state 1
- Indiana · 71,821 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497029 | 2497029 | 2022-05-12 | Carroll | Indiana | 18015 | 4265 | 68 |
2497030 | 2497030 | 2022-05-12 | Cass | Indiana | 18017 | 11701 | 164 |
2497031 | 2497031 | 2022-05-12 | Clark | Indiana | 18019 | 31527 | 396 |
2497032 | 2497032 | 2022-05-12 | Clay | Indiana | 18021 | 6852 | 88 |
2497033 | 2497033 | 2022-05-12 | Clinton | Indiana | 18023 | 9247 | 127 |
2497034 | 2497034 | 2022-05-12 | Crawford | Indiana | 18025 | 2560 | 40 |
2497035 | 2497035 | 2022-05-12 | Daviess | Indiana | 18027 | 7493 | 154 |
2497036 | 2497036 | 2022-05-12 | DeKalb | Indiana | 18033 | 11400 | 152 |
2497037 | 2497037 | 2022-05-12 | Dearborn | Indiana | 18029 | 13541 | 140 |
2497038 | 2497038 | 2022-05-12 | Decatur | Indiana | 18031 | 7013 | 147 |
2497039 | 2497039 | 2022-05-12 | Delaware | Indiana | 18035 | 25067 | 444 |
2497040 | 2497040 | 2022-05-12 | Dubois | Indiana | 18037 | 12895 | 165 |
2497041 | 2497041 | 2022-05-12 | Elkhart | Indiana | 18039 | 54339 | 734 |
2497042 | 2497042 | 2022-05-12 | Fayette | Indiana | 18041 | 6750 | 146 |
2497043 | 2497043 | 2022-05-12 | Floyd | Indiana | 18043 | 19167 | 302 |
2497044 | 2497044 | 2022-05-12 | Fountain | Indiana | 18045 | 5481 | 103 |
2497045 | 2497045 | 2022-05-12 | Franklin | Indiana | 18047 | 4385 | 65 |
2497046 | 2497046 | 2022-05-12 | Fulton | Indiana | 18049 | 4934 | 103 |
2497047 | 2497047 | 2022-05-12 | Gibson | Indiana | 18051 | 11734 | 145 |
2497048 | 2497048 | 2022-05-12 | Grant | Indiana | 18053 | 17369 | 353 |
2497049 | 2497049 | 2022-05-12 | Greene | Indiana | 18055 | 7252 | 139 |
2497050 | 2497050 | 2022-05-12 | Hamilton | Indiana | 18057 | 83231 | 661 |
2497051 | 2497051 | 2022-05-12 | Hancock | Indiana | 18059 | 20849 | 258 |
2497052 | 2497052 | 2022-05-12 | Harrison | Indiana | 18061 | 10880 | 138 |
2497053 | 2497053 | 2022-05-12 | Hendricks | Indiana | 18063 | 41000 | 554 |
2497054 | 2497054 | 2022-05-12 | Henry | Indiana | 18065 | 13044 | 231 |
2497055 | 2497055 | 2022-05-12 | Howard | Indiana | 18067 | 25538 | 449 |
2497056 | 2497056 | 2022-05-12 | Huntington | Indiana | 18069 | 11562 | 157 |
2497057 | 2497057 | 2022-05-12 | Jackson | Indiana | 18071 | 12561 | 130 |
2497058 | 2497058 | 2022-05-12 | Jasper | Indiana | 18073 | 9141 | 149 |
2497059 | 2497059 | 2022-05-12 | Jay | Indiana | 18075 | 4862 | 78 |
2497060 | 2497060 | 2022-05-12 | Jefferson | Indiana | 18077 | 9373 | 159 |
2497061 | 2497061 | 2022-05-12 | Jennings | Indiana | 18079 | 6990 | 108 |
2497062 | 2497062 | 2022-05-12 | Johnson | Indiana | 18081 | 42751 | 615 |
2497063 | 2497063 | 2022-05-12 | Knox | Indiana | 18083 | 10792 | 153 |
2497064 | 2497064 | 2022-05-12 | Kosciusko | Indiana | 18085 | 19838 | 237 |
2497065 | 2497065 | 2022-05-12 | LaGrange | Indiana | 18087 | 5871 | 102 |
2497066 | 2497066 | 2022-05-12 | LaPorte | Indiana | 18091 | 25842 | 367 |
2497067 | 2497067 | 2022-05-12 | Lake | Indiana | 18089 | 108373 | 1833 |
2497068 | 2497068 | 2022-05-12 | Lawrence | Indiana | 18093 | 12000 | 261 |
2497069 | 2497069 | 2022-05-12 | Madison | Indiana | 18095 | 32850 | 653 |
2497070 | 2497070 | 2022-05-12 | Marion | Indiana | 18097 | 227159 | 3000 |
2497071 | 2497071 | 2022-05-12 | Marshall | Indiana | 18099 | 12427 | 197 |
2497072 | 2497072 | 2022-05-12 | Martin | Indiana | 18101 | 2172 | 25 |
2497073 | 2497073 | 2022-05-12 | Miami | Indiana | 18103 | 9285 | 159 |
2497074 | 2497074 | 2022-05-12 | Monroe | Indiana | 18105 | 28724 | 280 |
2497075 | 2497075 | 2022-05-12 | Montgomery | Indiana | 18107 | 10733 | 164 |
2497076 | 2497076 | 2022-05-12 | Morgan | Indiana | 18109 | 16575 | 287 |
2497077 | 2497077 | 2022-05-12 | Newton | Indiana | 18111 | 2589 | 68 |
2497078 | 2497078 | 2022-05-12 | Noble | Indiana | 18113 | 13126 | 157 |
2497079 | 2497079 | 2022-05-12 | Ohio | Indiana | 18115 | 1456 | 19 |
2497080 | 2497080 | 2022-05-12 | Orange | Indiana | 18117 | 5051 | 96 |
2497081 | 2497081 | 2022-05-12 | Owen | Indiana | 18119 | 5901 | 121 |
2497082 | 2497082 | 2022-05-12 | Parke | Indiana | 18121 | 3606 | 46 |
2497083 | 2497083 | 2022-05-12 | Perry | Indiana | 18123 | 4670 | 69 |
2497084 | 2497084 | 2022-05-12 | Pike | Indiana | 18125 | 3752 | 49 |
2497085 | 2497085 | 2022-05-12 | Porter | Indiana | 18127 | 38507 | 564 |
2497086 | 2497086 | 2022-05-12 | Posey | Indiana | 18129 | 6574 | 58 |
2497087 | 2497087 | 2022-05-12 | Pulaski | Indiana | 18131 | 3084 | 86 |
2497088 | 2497088 | 2022-05-12 | Putnam | Indiana | 18133 | 9414 | 129 |
2497089 | 2497089 | 2022-05-12 | Randolph | Indiana | 18135 | 5912 | 148 |
2497090 | 2497090 | 2022-05-12 | Ripley | Indiana | 18137 | 8352 | 138 |
2497091 | 2497091 | 2022-05-12 | Rush | Indiana | 18139 | 4857 | 58 |
2497092 | 2497092 | 2022-05-12 | Scott | Indiana | 18143 | 7929 | 106 |
2497093 | 2497093 | 2022-05-12 | Shelby | Indiana | 18145 | 13640 | 182 |
2497094 | 2497094 | 2022-05-12 | Spencer | Indiana | 18147 | 5248 | 61 |
2497095 | 2497095 | 2022-05-12 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2497096 | 2497096 | 2022-05-12 | Starke | Indiana | 18149 | 4779 | 99 |
2497097 | 2497097 | 2022-05-12 | Steuben | Indiana | 18151 | 9677 | 121 |
2497098 | 2497098 | 2022-05-12 | Sullivan | Indiana | 18153 | 5292 | 76 |
2497099 | 2497099 | 2022-05-12 | Switzerland | Indiana | 18155 | 2320 | 20 |
2497100 | 2497100 | 2022-05-12 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2497101 | 2497101 | 2022-05-12 | Tipton | Indiana | 18159 | 3541 | 87 |
2497102 | 2497102 | 2022-05-12 | Union | Indiana | 18161 | 2025 | 21 |
2497103 | 2497103 | 2022-05-12 | Unknown | Indiana | 0 | 26 | |
2497104 | 2497104 | 2022-05-12 | Vanderburgh | Indiana | 18163 | 57756 | 640 |
2497105 | 2497105 | 2022-05-12 | Vermillion | Indiana | 18165 | 4116 | 75 |
2497106 | 2497106 | 2022-05-12 | Vigo | Indiana | 18167 | 29022 | 414 |
2497107 | 2497107 | 2022-05-12 | Wabash | Indiana | 18169 | 8749 | 157 |
2497108 | 2497108 | 2022-05-12 | Warren | Indiana | 18171 | 2109 | 30 |
2497109 | 2497109 | 2022-05-12 | Warrick | Indiana | 18173 | 20393 | 239 |
2497110 | 2497110 | 2022-05-12 | Washington | Indiana | 18175 | 6007 | 85 |
2497111 | 2497111 | 2022-05-12 | Wayne | Indiana | 18177 | 18886 | 337 |
2497112 | 2497112 | 2022-05-12 | Wells | Indiana | 18179 | 6509 | 132 |
2497113 | 2497113 | 2022-05-12 | White | Indiana | 18181 | 6928 | 96 |
2497114 | 2497114 | 2022-05-12 | Whitley | Indiana | 18183 | 9732 | 84 |
2493764 | 2493764 | 2022-05-11 | Adams | Indiana | 18001 | 7284 | 112 |
2493765 | 2493765 | 2022-05-11 | Allen | Indiana | 18003 | 104575 | 1187 |
2493766 | 2493766 | 2022-05-11 | Bartholomew | Indiana | 18005 | 21537 | 249 |
2493767 | 2493767 | 2022-05-11 | Benton | Indiana | 18007 | 2503 | 21 |
2493768 | 2493768 | 2022-05-11 | Blackford | Indiana | 18009 | 3116 | 69 |
2493769 | 2493769 | 2022-05-11 | Boone | Indiana | 18011 | 15430 | 186 |
2493770 | 2493770 | 2022-05-11 | Brown | Indiana | 18013 | 2607 | 62 |
2493771 | 2493771 | 2022-05-11 | Carroll | Indiana | 18015 | 4265 | 68 |
2493772 | 2493772 | 2022-05-11 | Cass | Indiana | 18017 | 11701 | 164 |
2493773 | 2493773 | 2022-05-11 | Clark | Indiana | 18019 | 31527 | 396 |
2493774 | 2493774 | 2022-05-11 | Clay | Indiana | 18021 | 6852 | 88 |
2493775 | 2493775 | 2022-05-11 | Clinton | Indiana | 18023 | 9247 | 127 |
2493776 | 2493776 | 2022-05-11 | Crawford | Indiana | 18025 | 2560 | 40 |
2493777 | 2493777 | 2022-05-11 | Daviess | Indiana | 18027 | 7493 | 154 |
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);