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 797
- 18063 795
- 18113 794
- 18001 792
- 18011 792
- 18067 792
- 18081 792
- 18141 792
- 18091 789
- 18179 789
- 18057 788
- 18043 787
- 18005 786
- 18047 786
- 18089 786
- 18041 785
- 18079 785
- 18095 785
- 18019 784
- 18119 784
- 18157 784
- 18177 784
- 18053 783
- 18145 783
- 18163 783
- 18167 783
- 18003 782
- 18035 782
- 18039 782
- 18059 782
- …
county >30
- Marion 797
- Hendricks 795
- Noble 794
- Adams 792
- Boone 792
- Howard 792
- Johnson 792
- St. Joseph 792
- LaPorte 789
- Wells 789
- Hamilton 788
- Floyd 787
- Bartholomew 786
- Franklin 786
- Lake 786
- Fayette 785
- Jennings 785
- Madison 785
- Clark 784
- Owen 784
- Tippecanoe 784
- Wayne 784
- Grant 783
- Shelby 783
- Vanderburgh 783
- Vigo 783
- Allen 782
- Delaware 782
- Elkhart 782
- Hancock 782
- …
state 1
- Indiana · 71,721 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493778 | 2493778 | 2022-05-11 | DeKalb | Indiana | 18033 | 11400 | 152 |
2493779 | 2493779 | 2022-05-11 | Dearborn | Indiana | 18029 | 13541 | 140 |
2493780 | 2493780 | 2022-05-11 | Decatur | Indiana | 18031 | 7013 | 147 |
2493781 | 2493781 | 2022-05-11 | Delaware | Indiana | 18035 | 25067 | 444 |
2493782 | 2493782 | 2022-05-11 | Dubois | Indiana | 18037 | 12895 | 165 |
2493783 | 2493783 | 2022-05-11 | Elkhart | Indiana | 18039 | 54339 | 734 |
2493784 | 2493784 | 2022-05-11 | Fayette | Indiana | 18041 | 6750 | 146 |
2493785 | 2493785 | 2022-05-11 | Floyd | Indiana | 18043 | 19167 | 302 |
2493786 | 2493786 | 2022-05-11 | Fountain | Indiana | 18045 | 5481 | 103 |
2493787 | 2493787 | 2022-05-11 | Franklin | Indiana | 18047 | 4385 | 65 |
2493788 | 2493788 | 2022-05-11 | Fulton | Indiana | 18049 | 4934 | 103 |
2493789 | 2493789 | 2022-05-11 | Gibson | Indiana | 18051 | 11734 | 145 |
2493790 | 2493790 | 2022-05-11 | Grant | Indiana | 18053 | 17369 | 353 |
2493791 | 2493791 | 2022-05-11 | Greene | Indiana | 18055 | 7252 | 139 |
2493792 | 2493792 | 2022-05-11 | Hamilton | Indiana | 18057 | 83231 | 661 |
2493793 | 2493793 | 2022-05-11 | Hancock | Indiana | 18059 | 20849 | 258 |
2493794 | 2493794 | 2022-05-11 | Harrison | Indiana | 18061 | 10880 | 138 |
2493795 | 2493795 | 2022-05-11 | Hendricks | Indiana | 18063 | 41000 | 554 |
2493796 | 2493796 | 2022-05-11 | Henry | Indiana | 18065 | 13044 | 231 |
2493797 | 2493797 | 2022-05-11 | Howard | Indiana | 18067 | 25538 | 449 |
2493798 | 2493798 | 2022-05-11 | Huntington | Indiana | 18069 | 11562 | 157 |
2493799 | 2493799 | 2022-05-11 | Jackson | Indiana | 18071 | 12561 | 130 |
2493800 | 2493800 | 2022-05-11 | Jasper | Indiana | 18073 | 9141 | 149 |
2493801 | 2493801 | 2022-05-11 | Jay | Indiana | 18075 | 4862 | 78 |
2493802 | 2493802 | 2022-05-11 | Jefferson | Indiana | 18077 | 9373 | 159 |
2493803 | 2493803 | 2022-05-11 | Jennings | Indiana | 18079 | 6990 | 108 |
2493804 | 2493804 | 2022-05-11 | Johnson | Indiana | 18081 | 42751 | 615 |
2493805 | 2493805 | 2022-05-11 | Knox | Indiana | 18083 | 10792 | 153 |
2493806 | 2493806 | 2022-05-11 | Kosciusko | Indiana | 18085 | 19838 | 237 |
2493807 | 2493807 | 2022-05-11 | LaGrange | Indiana | 18087 | 5871 | 102 |
2493808 | 2493808 | 2022-05-11 | LaPorte | Indiana | 18091 | 25842 | 367 |
2493809 | 2493809 | 2022-05-11 | Lake | Indiana | 18089 | 108373 | 1833 |
2493810 | 2493810 | 2022-05-11 | Lawrence | Indiana | 18093 | 12000 | 261 |
2493811 | 2493811 | 2022-05-11 | Madison | Indiana | 18095 | 32850 | 653 |
2493812 | 2493812 | 2022-05-11 | Marion | Indiana | 18097 | 227159 | 3000 |
2493813 | 2493813 | 2022-05-11 | Marshall | Indiana | 18099 | 12427 | 197 |
2493814 | 2493814 | 2022-05-11 | Martin | Indiana | 18101 | 2172 | 25 |
2493815 | 2493815 | 2022-05-11 | Miami | Indiana | 18103 | 9285 | 159 |
2493816 | 2493816 | 2022-05-11 | Monroe | Indiana | 18105 | 28724 | 280 |
2493817 | 2493817 | 2022-05-11 | Montgomery | Indiana | 18107 | 10733 | 164 |
2493818 | 2493818 | 2022-05-11 | Morgan | Indiana | 18109 | 16575 | 287 |
2493819 | 2493819 | 2022-05-11 | Newton | Indiana | 18111 | 2589 | 68 |
2493820 | 2493820 | 2022-05-11 | Noble | Indiana | 18113 | 13126 | 157 |
2493821 | 2493821 | 2022-05-11 | Ohio | Indiana | 18115 | 1456 | 19 |
2493822 | 2493822 | 2022-05-11 | Orange | Indiana | 18117 | 5051 | 96 |
2493823 | 2493823 | 2022-05-11 | Owen | Indiana | 18119 | 5901 | 121 |
2493824 | 2493824 | 2022-05-11 | Parke | Indiana | 18121 | 3606 | 46 |
2493825 | 2493825 | 2022-05-11 | Perry | Indiana | 18123 | 4670 | 69 |
2493826 | 2493826 | 2022-05-11 | Pike | Indiana | 18125 | 3752 | 49 |
2493827 | 2493827 | 2022-05-11 | Porter | Indiana | 18127 | 38507 | 564 |
2493828 | 2493828 | 2022-05-11 | Posey | Indiana | 18129 | 6574 | 58 |
2493829 | 2493829 | 2022-05-11 | Pulaski | Indiana | 18131 | 3084 | 86 |
2493830 | 2493830 | 2022-05-11 | Putnam | Indiana | 18133 | 9414 | 129 |
2493831 | 2493831 | 2022-05-11 | Randolph | Indiana | 18135 | 5912 | 148 |
2493832 | 2493832 | 2022-05-11 | Ripley | Indiana | 18137 | 8352 | 138 |
2493833 | 2493833 | 2022-05-11 | Rush | Indiana | 18139 | 4857 | 58 |
2493834 | 2493834 | 2022-05-11 | Scott | Indiana | 18143 | 7929 | 106 |
2493835 | 2493835 | 2022-05-11 | Shelby | Indiana | 18145 | 13640 | 182 |
2493836 | 2493836 | 2022-05-11 | Spencer | Indiana | 18147 | 5248 | 61 |
2493837 | 2493837 | 2022-05-11 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2493838 | 2493838 | 2022-05-11 | Starke | Indiana | 18149 | 4779 | 99 |
2493839 | 2493839 | 2022-05-11 | Steuben | Indiana | 18151 | 9677 | 121 |
2493840 | 2493840 | 2022-05-11 | Sullivan | Indiana | 18153 | 5292 | 76 |
2493841 | 2493841 | 2022-05-11 | Switzerland | Indiana | 18155 | 2320 | 20 |
2493842 | 2493842 | 2022-05-11 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2493843 | 2493843 | 2022-05-11 | Tipton | Indiana | 18159 | 3541 | 87 |
2493844 | 2493844 | 2022-05-11 | Union | Indiana | 18161 | 2025 | 21 |
2493845 | 2493845 | 2022-05-11 | Unknown | Indiana | 0 | 15 | |
2493846 | 2493846 | 2022-05-11 | Vanderburgh | Indiana | 18163 | 57756 | 640 |
2493847 | 2493847 | 2022-05-11 | Vermillion | Indiana | 18165 | 4116 | 75 |
2493848 | 2493848 | 2022-05-11 | Vigo | Indiana | 18167 | 29022 | 414 |
2493849 | 2493849 | 2022-05-11 | Wabash | Indiana | 18169 | 8749 | 157 |
2493850 | 2493850 | 2022-05-11 | Warren | Indiana | 18171 | 2109 | 30 |
2493851 | 2493851 | 2022-05-11 | Warrick | Indiana | 18173 | 20393 | 239 |
2493852 | 2493852 | 2022-05-11 | Washington | Indiana | 18175 | 6007 | 85 |
2493853 | 2493853 | 2022-05-11 | Wayne | Indiana | 18177 | 18886 | 337 |
2493854 | 2493854 | 2022-05-11 | Wells | Indiana | 18179 | 6509 | 132 |
2493855 | 2493855 | 2022-05-11 | White | Indiana | 18181 | 6928 | 96 |
2493856 | 2493856 | 2022-05-11 | Whitley | Indiana | 18183 | 9732 | 84 |
2490506 | 2490506 | 2022-05-10 | Adams | Indiana | 18001 | 7281 | 112 |
2490507 | 2490507 | 2022-05-10 | Allen | Indiana | 18003 | 104497 | 1187 |
2490508 | 2490508 | 2022-05-10 | Bartholomew | Indiana | 18005 | 21510 | 249 |
2490509 | 2490509 | 2022-05-10 | Benton | Indiana | 18007 | 2498 | 21 |
2490510 | 2490510 | 2022-05-10 | Blackford | Indiana | 18009 | 3118 | 69 |
2490511 | 2490511 | 2022-05-10 | Boone | Indiana | 18011 | 15404 | 185 |
2490512 | 2490512 | 2022-05-10 | Brown | Indiana | 18013 | 2603 | 62 |
2490513 | 2490513 | 2022-05-10 | Carroll | Indiana | 18015 | 4261 | 68 |
2490514 | 2490514 | 2022-05-10 | Cass | Indiana | 18017 | 11699 | 164 |
2490515 | 2490515 | 2022-05-10 | Clark | Indiana | 18019 | 31461 | 396 |
2490516 | 2490516 | 2022-05-10 | Clay | Indiana | 18021 | 6849 | 88 |
2490517 | 2490517 | 2022-05-10 | Clinton | Indiana | 18023 | 9245 | 127 |
2490518 | 2490518 | 2022-05-10 | Crawford | Indiana | 18025 | 2559 | 40 |
2490519 | 2490519 | 2022-05-10 | Daviess | Indiana | 18027 | 7495 | 154 |
2490520 | 2490520 | 2022-05-10 | DeKalb | Indiana | 18033 | 11393 | 152 |
2490521 | 2490521 | 2022-05-10 | Dearborn | Indiana | 18029 | 13536 | 140 |
2490522 | 2490522 | 2022-05-10 | Decatur | Indiana | 18031 | 7011 | 146 |
2490523 | 2490523 | 2022-05-10 | Delaware | Indiana | 18035 | 25046 | 443 |
2490524 | 2490524 | 2022-05-10 | Dubois | Indiana | 18037 | 12889 | 165 |
2490525 | 2490525 | 2022-05-10 | Elkhart | Indiana | 18039 | 54308 | 733 |
2490526 | 2490526 | 2022-05-10 | Fayette | Indiana | 18041 | 6747 | 146 |
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);