ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-02-01" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2171647 | 2171647 | 2022-02-01 | Adams | Indiana | 18001 | 7144 | 106 |
2171648 | 2171648 | 2022-02-01 | Allen | Indiana | 18003 | 100625 | 1090 |
2171649 | 2171649 | 2022-02-01 | Bartholomew | Indiana | 18005 | 20347 | 228 |
2171650 | 2171650 | 2022-02-01 | Benton | Indiana | 18007 | 2404 | 21 |
2171651 | 2171651 | 2022-02-01 | Blackford | Indiana | 18009 | 3003 | 64 |
2171652 | 2171652 | 2022-02-01 | Boone | Indiana | 18011 | 14513 | 154 |
2171653 | 2171653 | 2022-02-01 | Brown | Indiana | 18013 | 2505 | 60 |
2171654 | 2171654 | 2022-02-01 | Carroll | Indiana | 18015 | 4099 | 58 |
2171655 | 2171655 | 2022-02-01 | Cass | Indiana | 18017 | 11021 | 153 |
2171656 | 2171656 | 2022-02-01 | Clark | Indiana | 18019 | 29016 | 359 |
2171657 | 2171657 | 2022-02-01 | Clay | Indiana | 18021 | 6598 | 80 |
2171658 | 2171658 | 2022-02-01 | Clinton | Indiana | 18023 | 8863 | 109 |
2171659 | 2171659 | 2022-02-01 | Crawford | Indiana | 18025 | 2383 | 35 |
2171660 | 2171660 | 2022-02-01 | Daviess | Indiana | 18027 | 7195 | 135 |
2171661 | 2171661 | 2022-02-01 | DeKalb | Indiana | 18033 | 10989 | 139 |
2171662 | 2171662 | 2022-02-01 | Dearborn | Indiana | 18029 | 12883 | 122 |
2171663 | 2171663 | 2022-02-01 | Decatur | Indiana | 18031 | 6739 | 134 |
2171664 | 2171664 | 2022-02-01 | Delaware | Indiana | 18035 | 23542 | 406 |
2171665 | 2171665 | 2022-02-01 | Dubois | Indiana | 18037 | 12320 | 157 |
2171666 | 2171666 | 2022-02-01 | Elkhart | Indiana | 18039 | 52889 | 679 |
2171667 | 2171667 | 2022-02-01 | Fayette | Indiana | 18041 | 6559 | 131 |
2171668 | 2171668 | 2022-02-01 | Floyd | Indiana | 18043 | 17726 | 272 |
2171669 | 2171669 | 2022-02-01 | Fountain | Indiana | 18045 | 5153 | 89 |
2171670 | 2171670 | 2022-02-01 | Franklin | Indiana | 18047 | 4169 | 58 |
2171671 | 2171671 | 2022-02-01 | Fulton | Indiana | 18049 | 4705 | 100 |
2171672 | 2171672 | 2022-02-01 | Gibson | Indiana | 18051 | 11028 | 133 |
2171673 | 2171673 | 2022-02-01 | Grant | Indiana | 18053 | 17085 | 323 |
2171674 | 2171674 | 2022-02-01 | Greene | Indiana | 18055 | 6752 | 125 |
2171675 | 2171675 | 2022-02-01 | Hamilton | Indiana | 18057 | 78820 | 600 |
2171676 | 2171676 | 2022-02-01 | Hancock | Indiana | 18059 | 20071 | 235 |
2171677 | 2171677 | 2022-02-01 | Harrison | Indiana | 18061 | 10150 | 125 |
2171678 | 2171678 | 2022-02-01 | Hendricks | Indiana | 18063 | 39483 | 510 |
2171679 | 2171679 | 2022-02-01 | Henry | Indiana | 18065 | 12488 | 212 |
2171680 | 2171680 | 2022-02-01 | Howard | Indiana | 18067 | 24530 | 409 |
2171681 | 2171681 | 2022-02-01 | Huntington | Indiana | 18069 | 11082 | 146 |
2171682 | 2171682 | 2022-02-01 | Jackson | Indiana | 18071 | 11867 | 108 |
2171683 | 2171683 | 2022-02-01 | Jasper | Indiana | 18073 | 8749 | 129 |
2171684 | 2171684 | 2022-02-01 | Jay | Indiana | 18075 | 4624 | 74 |
2171685 | 2171685 | 2022-02-01 | Jefferson | Indiana | 18077 | 8919 | 138 |
2171686 | 2171686 | 2022-02-01 | Jennings | Indiana | 18079 | 6640 | 95 |
2171687 | 2171687 | 2022-02-01 | Johnson | Indiana | 18081 | 41133 | 572 |
2171688 | 2171688 | 2022-02-01 | Knox | Indiana | 18083 | 10150 | 131 |
2171689 | 2171689 | 2022-02-01 | Kosciusko | Indiana | 18085 | 19063 | 215 |
2171690 | 2171690 | 2022-02-01 | LaGrange | Indiana | 18087 | 5724 | 99 |
2171691 | 2171691 | 2022-02-01 | LaPorte | Indiana | 18091 | 24666 | 329 |
2171692 | 2171692 | 2022-02-01 | Lake | Indiana | 18089 | 103867 | 1671 |
2171693 | 2171693 | 2022-02-01 | Lawrence | Indiana | 18093 | 11224 | 231 |
2171694 | 2171694 | 2022-02-01 | Madison | Indiana | 18095 | 31549 | 599 |
2171695 | 2171695 | 2022-02-01 | Marion | Indiana | 18097 | 218675 | 2760 |
2171696 | 2171696 | 2022-02-01 | Marshall | Indiana | 18099 | 12003 | 185 |
2171697 | 2171697 | 2022-02-01 | Martin | Indiana | 18101 | 2098 | 23 |
2171698 | 2171698 | 2022-02-01 | Miami | Indiana | 18103 | 8889 | 144 |
2171699 | 2171699 | 2022-02-01 | Monroe | Indiana | 18105 | 26005 | 254 |
2171700 | 2171700 | 2022-02-01 | Montgomery | Indiana | 18107 | 10163 | 150 |
2171701 | 2171701 | 2022-02-01 | Morgan | Indiana | 18109 | 15867 | 259 |
2171702 | 2171702 | 2022-02-01 | Newton | Indiana | 18111 | 2482 | 64 |
2171703 | 2171703 | 2022-02-01 | Noble | Indiana | 18113 | 12696 | 147 |
2171704 | 2171704 | 2022-02-01 | Ohio | Indiana | 18115 | 1388 | 17 |
2171705 | 2171705 | 2022-02-01 | Orange | Indiana | 18117 | 4796 | 90 |
2171706 | 2171706 | 2022-02-01 | Owen | Indiana | 18119 | 5541 | 107 |
2171707 | 2171707 | 2022-02-01 | Parke | Indiana | 18121 | 3478 | 43 |
2171708 | 2171708 | 2022-02-01 | Perry | Indiana | 18123 | 4418 | 63 |
2171709 | 2171709 | 2022-02-01 | Pike | Indiana | 18125 | 3554 | 48 |
2171710 | 2171710 | 2022-02-01 | Porter | Indiana | 18127 | 35945 | 519 |
2171711 | 2171711 | 2022-02-01 | Posey | Indiana | 18129 | 6208 | 49 |
2171712 | 2171712 | 2022-02-01 | Pulaski | Indiana | 18131 | 2936 | 81 |
2171713 | 2171713 | 2022-02-01 | Putnam | Indiana | 18133 | 8938 | 108 |
2171714 | 2171714 | 2022-02-01 | Randolph | Indiana | 18135 | 5700 | 137 |
2171715 | 2171715 | 2022-02-01 | Ripley | Indiana | 18137 | 7965 | 124 |
2171716 | 2171716 | 2022-02-01 | Rush | Indiana | 18139 | 4674 | 46 |
2171717 | 2171717 | 2022-02-01 | Scott | Indiana | 18143 | 7415 | 91 |
2171718 | 2171718 | 2022-02-01 | Shelby | Indiana | 18145 | 14067 | 167 |
2171719 | 2171719 | 2022-02-01 | Spencer | Indiana | 18147 | 4963 | 58 |
2171720 | 2171720 | 2022-02-01 | St. Joseph | Indiana | 18141 | 68567 | 803 |
2171721 | 2171721 | 2022-02-01 | Starke | Indiana | 18149 | 4599 | 92 |
2171722 | 2171722 | 2022-02-01 | Steuben | Indiana | 18151 | 9328 | 111 |
2171723 | 2171723 | 2022-02-01 | Sullivan | Indiana | 18153 | 5000 | 69 |
2171724 | 2171724 | 2022-02-01 | Switzerland | Indiana | 18155 | 2207 | 15 |
2171725 | 2171725 | 2022-02-01 | Tippecanoe | Indiana | 18157 | 48030 | 353 |
2171726 | 2171726 | 2022-02-01 | Tipton | Indiana | 18159 | 3419 | 81 |
2171727 | 2171727 | 2022-02-01 | Union | Indiana | 18161 | 1933 | 21 |
2171728 | 2171728 | 2022-02-01 | Vanderburgh | Indiana | 18163 | 54373 | 557 |
2171729 | 2171729 | 2022-02-01 | Vermillion | Indiana | 18165 | 3903 | 67 |
2171730 | 2171730 | 2022-02-01 | Vigo | Indiana | 18167 | 27838 | 366 |
2171731 | 2171731 | 2022-02-01 | Wabash | Indiana | 18169 | 8355 | 143 |
2171732 | 2171732 | 2022-02-01 | Warren | Indiana | 18171 | 1963 | 24 |
2171733 | 2171733 | 2022-02-01 | Warrick | Indiana | 18173 | 19151 | 225 |
2171734 | 2171734 | 2022-02-01 | Washington | Indiana | 18175 | 5671 | 74 |
2171735 | 2171735 | 2022-02-01 | Wayne | Indiana | 18177 | 18375 | 316 |
2171736 | 2171736 | 2022-02-01 | Wells | Indiana | 18179 | 6340 | 126 |
2171737 | 2171737 | 2022-02-01 | White | Indiana | 18181 | 6604 | 86 |
2171738 | 2171738 | 2022-02-01 | Whitley | Indiana | 18183 | 9419 | 76 |
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);