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 93
- 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
- 18061 783
- 18103 783
- 18175 783
- 18105 782
- 18109 782
- 18133 782
- 18137 782
- 18143 782
- 18159 782
- 18037 781
- 18029 780
- 18031 780
- 18051 780
- 18071 780
- 18093 780
- 18107 780
- 18115 780
- 18127 780
- 18149 780
- 18153 780
- 18173 780
- 18013 779
- 18033 779
- 18073 779
- 18139 779
- 18045 778
- 18099 778
- 18117 778
- 18129 778
- 18171 778
- 18015 777
- 18023 777
- 18049 777
- 18065 777
- 18069 777
- 18085 777
- 18087 777
- 18135 777
- 18183 777
- 18025 776
- 18111 776
- 18155 776
- 18165 776
- 18169 776
- 18181 776
- 18021 775
- 18055 775
- 18083 775
- 18151 775
- 18017 773
- 18077 773
- 18075 772
- 18147 771
- 18009 770
- 18121 770
- 18101 769
- 18161 769
- 18027 768
- 18131 767
- 18123 763
- 18125 761
- 18007 760
- - 39
county 93
- 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
- Harrison 783
- Miami 783
- Washington 783
- Monroe 782
- Morgan 782
- Putnam 782
- Ripley 782
- Scott 782
- Tipton 782
- Dubois 781
- Dearborn 780
- Decatur 780
- Gibson 780
- Jackson 780
- Lawrence 780
- Montgomery 780
- Ohio 780
- Porter 780
- Starke 780
- Sullivan 780
- Warrick 780
- Brown 779
- DeKalb 779
- Jasper 779
- Rush 779
- Fountain 778
- Marshall 778
- Orange 778
- Posey 778
- Warren 778
- Carroll 777
- Clinton 777
- Fulton 777
- Henry 777
- Huntington 777
- Kosciusko 777
- LaGrange 777
- Randolph 777
- Whitley 777
- Crawford 776
- Newton 776
- Switzerland 776
- Vermillion 776
- Wabash 776
- White 776
- Clay 775
- Greene 775
- Knox 775
- Steuben 775
- Cass 773
- Jefferson 773
- Jay 772
- Spencer 771
- Blackford 770
- Parke 770
- Martin 769
- Union 769
- Daviess 768
- Pulaski 767
- Perry 763
- Pike 761
- Benton 760
- Unknown 39
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);