ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2022-03-17 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314735 | 2314735 | 2022-03-17 | Adams | Indiana | 18001 | 7329 | 112 |
2314736 | 2314736 | 2022-03-17 | Allen | Indiana | 18003 | 103587 | 1171 |
2314737 | 2314737 | 2022-03-17 | Bartholomew | Indiana | 18005 | 21298 | 248 |
2314738 | 2314738 | 2022-03-17 | Benton | Indiana | 18007 | 2473 | 21 |
2314739 | 2314739 | 2022-03-17 | Blackford | Indiana | 18009 | 3121 | 69 |
2314740 | 2314740 | 2022-03-17 | Boone | Indiana | 18011 | 15149 | 179 |
2314741 | 2314741 | 2022-03-17 | Brown | Indiana | 18013 | 2582 | 62 |
2314742 | 2314742 | 2022-03-17 | Carroll | Indiana | 18015 | 4217 | 65 |
2314743 | 2314743 | 2022-03-17 | Cass | Indiana | 18017 | 11648 | 162 |
2314744 | 2314744 | 2022-03-17 | Clark | Indiana | 18019 | 31001 | 390 |
2314745 | 2314745 | 2022-03-17 | Clay | Indiana | 18021 | 6821 | 87 |
2314746 | 2314746 | 2022-03-17 | Clinton | Indiana | 18023 | 9181 | 122 |
2314747 | 2314747 | 2022-03-17 | Crawford | Indiana | 18025 | 2541 | 37 |
2314748 | 2314748 | 2022-03-17 | Daviess | Indiana | 18027 | 7462 | 151 |
2314749 | 2314749 | 2022-03-17 | DeKalb | Indiana | 18033 | 11321 | 149 |
2314750 | 2314750 | 2022-03-17 | Dearborn | Indiana | 18029 | 13416 | 137 |
2314751 | 2314751 | 2022-03-17 | Decatur | Indiana | 18031 | 7057 | 145 |
2314752 | 2314752 | 2022-03-17 | Delaware | Indiana | 18035 | 24762 | 437 |
2314753 | 2314753 | 2022-03-17 | Dubois | Indiana | 18037 | 12845 | 165 |
2314754 | 2314754 | 2022-03-17 | Elkhart | Indiana | 18039 | 54099 | 727 |
2314755 | 2314755 | 2022-03-17 | Fayette | Indiana | 18041 | 6865 | 146 |
2314756 | 2314756 | 2022-03-17 | Floyd | Indiana | 18043 | 18877 | 292 |
2314757 | 2314757 | 2022-03-17 | Fountain | Indiana | 18045 | 5383 | 100 |
2314758 | 2314758 | 2022-03-17 | Franklin | Indiana | 18047 | 4395 | 65 |
2314759 | 2314759 | 2022-03-17 | Fulton | Indiana | 18049 | 4906 | 102 |
2314760 | 2314760 | 2022-03-17 | Gibson | Indiana | 18051 | 11620 | 144 |
2314761 | 2314761 | 2022-03-17 | Grant | Indiana | 18053 | 17663 | 346 |
2314762 | 2314762 | 2022-03-17 | Greene | Indiana | 18055 | 7195 | 138 |
2314763 | 2314763 | 2022-03-17 | Hamilton | Indiana | 18057 | 81601 | 652 |
2314764 | 2314764 | 2022-03-17 | Hancock | Indiana | 18059 | 20633 | 258 |
2314765 | 2314765 | 2022-03-17 | Harrison | Indiana | 18061 | 10784 | 138 |
2314766 | 2314766 | 2022-03-17 | Hendricks | Indiana | 18063 | 40725 | 550 |
2314767 | 2314767 | 2022-03-17 | Henry | Indiana | 18065 | 12958 | 228 |
2314768 | 2314768 | 2022-03-17 | Howard | Indiana | 18067 | 25375 | 441 |
2314769 | 2314769 | 2022-03-17 | Huntington | Indiana | 18069 | 11480 | 155 |
2314770 | 2314770 | 2022-03-17 | Jackson | Indiana | 18071 | 12502 | 128 |
2314771 | 2314771 | 2022-03-17 | Jasper | Indiana | 18073 | 8993 | 147 |
2314772 | 2314772 | 2022-03-17 | Jay | Indiana | 18075 | 4848 | 78 |
2314773 | 2314773 | 2022-03-17 | Jefferson | Indiana | 18077 | 9345 | 154 |
2314774 | 2314774 | 2022-03-17 | Jennings | Indiana | 18079 | 6942 | 107 |
2314775 | 2314775 | 2022-03-17 | Johnson | Indiana | 18081 | 42277 | 605 |
2314776 | 2314776 | 2022-03-17 | Knox | Indiana | 18083 | 10728 | 151 |
2314777 | 2314777 | 2022-03-17 | Kosciusko | Indiana | 18085 | 19721 | 235 |
2314778 | 2314778 | 2022-03-17 | LaGrange | Indiana | 18087 | 5847 | 102 |
2314779 | 2314779 | 2022-03-17 | LaPorte | Indiana | 18091 | 25367 | 362 |
2314780 | 2314780 | 2022-03-17 | Lake | Indiana | 18089 | 105908 | 1805 |
2314781 | 2314781 | 2022-03-17 | Lawrence | Indiana | 18093 | 11823 | 257 |
2314782 | 2314782 | 2022-03-17 | Madison | Indiana | 18095 | 32625 | 645 |
2314783 | 2314783 | 2022-03-17 | Marion | Indiana | 18097 | 224552 | 2949 |
2314784 | 2314784 | 2022-03-17 | Marshall | Indiana | 18099 | 12312 | 193 |
2314785 | 2314785 | 2022-03-17 | Martin | Indiana | 18101 | 2163 | 25 |
2314786 | 2314786 | 2022-03-17 | Miami | Indiana | 18103 | 9248 | 158 |
2314787 | 2314787 | 2022-03-17 | Monroe | Indiana | 18105 | 27543 | 278 |
2314788 | 2314788 | 2022-03-17 | Montgomery | Indiana | 18107 | 10652 | 163 |
2314789 | 2314789 | 2022-03-17 | Morgan | Indiana | 18109 | 16444 | 279 |
2314790 | 2314790 | 2022-03-17 | Newton | Indiana | 18111 | 2558 | 68 |
2314791 | 2314791 | 2022-03-17 | Noble | Indiana | 18113 | 13050 | 156 |
2314792 | 2314792 | 2022-03-17 | Ohio | Indiana | 18115 | 1443 | 19 |
2314793 | 2314793 | 2022-03-17 | Orange | Indiana | 18117 | 5031 | 96 |
2314794 | 2314794 | 2022-03-17 | Owen | Indiana | 18119 | 5822 | 116 |
2314795 | 2314795 | 2022-03-17 | Parke | Indiana | 18121 | 3607 | 49 |
2314796 | 2314796 | 2022-03-17 | Perry | Indiana | 18123 | 4660 | 68 |
2314797 | 2314797 | 2022-03-17 | Pike | Indiana | 18125 | 3723 | 48 |
2314798 | 2314798 | 2022-03-17 | Porter | Indiana | 18127 | 37475 | 556 |
2314799 | 2314799 | 2022-03-17 | Posey | Indiana | 18129 | 6523 | 56 |
2314800 | 2314800 | 2022-03-17 | Pulaski | Indiana | 18131 | 3068 | 85 |
2314801 | 2314801 | 2022-03-17 | Putnam | Indiana | 18133 | 9305 | 126 |
2314802 | 2314802 | 2022-03-17 | Randolph | Indiana | 18135 | 5932 | 145 |
2314803 | 2314803 | 2022-03-17 | Ripley | Indiana | 18137 | 8279 | 138 |
2314804 | 2314804 | 2022-03-17 | Rush | Indiana | 18139 | 4902 | 58 |
2314805 | 2314805 | 2022-03-17 | Scott | Indiana | 18143 | 7854 | 106 |
2314806 | 2314806 | 2022-03-17 | Shelby | Indiana | 18145 | 14662 | 181 |
2314807 | 2314807 | 2022-03-17 | Spencer | Indiana | 18147 | 5214 | 60 |
2314808 | 2314808 | 2022-03-17 | St. Joseph | Indiana | 18141 | 70426 | 861 |
2314809 | 2314809 | 2022-03-17 | Starke | Indiana | 18149 | 4735 | 96 |
2314810 | 2314810 | 2022-03-17 | Steuben | Indiana | 18151 | 9618 | 120 |
2314811 | 2314811 | 2022-03-17 | Sullivan | Indiana | 18153 | 5269 | 76 |
2314812 | 2314812 | 2022-03-17 | Switzerland | Indiana | 18155 | 2307 | 20 |
2314813 | 2314813 | 2022-03-17 | Tippecanoe | Indiana | 18157 | 49782 | 389 |
2314814 | 2314814 | 2022-03-17 | Tipton | Indiana | 18159 | 3526 | 87 |
2314815 | 2314815 | 2022-03-17 | Union | Indiana | 18161 | 2046 | 21 |
2314816 | 2314816 | 2022-03-17 | Vanderburgh | Indiana | 18163 | 57177 | 621 |
2314817 | 2314817 | 2022-03-17 | Vermillion | Indiana | 18165 | 4062 | 74 |
2314818 | 2314818 | 2022-03-17 | Vigo | Indiana | 18167 | 28810 | 406 |
2314819 | 2314819 | 2022-03-17 | Wabash | Indiana | 18169 | 8709 | 153 |
2314820 | 2314820 | 2022-03-17 | Warren | Indiana | 18171 | 2077 | 29 |
2314821 | 2314821 | 2022-03-17 | Warrick | Indiana | 18173 | 20227 | 237 |
2314822 | 2314822 | 2022-03-17 | Washington | Indiana | 18175 | 5984 | 79 |
2314823 | 2314823 | 2022-03-17 | Wayne | Indiana | 18177 | 19188 | 330 |
2314824 | 2314824 | 2022-03-17 | Wells | Indiana | 18179 | 6519 | 132 |
2314825 | 2314825 | 2022-03-17 | White | Indiana | 18181 | 6835 | 93 |
2314826 | 2314826 | 2022-03-17 | Whitley | Indiana | 18183 | 9640 | 83 |
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);