ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2022-04-25 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441657 | 2441657 | 2022-04-25 | Adams | Indiana | 18001 | 7268 | 112 |
2441658 | 2441658 | 2022-04-25 | Allen | Indiana | 18003 | 104042 | 1185 |
2441659 | 2441659 | 2022-04-25 | Bartholomew | Indiana | 18005 | 21378 | 249 |
2441660 | 2441660 | 2022-04-25 | Benton | Indiana | 18007 | 2481 | 21 |
2441661 | 2441661 | 2022-04-25 | Blackford | Indiana | 18009 | 3109 | 69 |
2441662 | 2441662 | 2022-04-25 | Boone | Indiana | 18011 | 15299 | 184 |
2441663 | 2441663 | 2022-04-25 | Brown | Indiana | 18013 | 2590 | 62 |
2441664 | 2441664 | 2022-04-25 | Carroll | Indiana | 18015 | 4238 | 68 |
2441665 | 2441665 | 2022-04-25 | Cass | Indiana | 18017 | 11677 | 163 |
2441666 | 2441666 | 2022-04-25 | Clark | Indiana | 18019 | 31204 | 396 |
2441667 | 2441667 | 2022-04-25 | Clay | Indiana | 18021 | 6834 | 88 |
2441668 | 2441668 | 2022-04-25 | Clinton | Indiana | 18023 | 9212 | 126 |
2441669 | 2441669 | 2022-04-25 | Crawford | Indiana | 18025 | 2552 | 40 |
2441670 | 2441670 | 2022-04-25 | Daviess | Indiana | 18027 | 7476 | 153 |
2441671 | 2441671 | 2022-04-25 | DeKalb | Indiana | 18033 | 11366 | 149 |
2441672 | 2441672 | 2022-04-25 | Dearborn | Indiana | 18029 | 13472 | 140 |
2441673 | 2441673 | 2022-04-25 | Decatur | Indiana | 18031 | 7005 | 145 |
2441674 | 2441674 | 2022-04-25 | Delaware | Indiana | 18035 | 24885 | 443 |
2441675 | 2441675 | 2022-04-25 | Dubois | Indiana | 18037 | 12871 | 165 |
2441676 | 2441676 | 2022-04-25 | Elkhart | Indiana | 18039 | 54156 | 731 |
2441677 | 2441677 | 2022-04-25 | Fayette | Indiana | 18041 | 6744 | 146 |
2441678 | 2441678 | 2022-04-25 | Floyd | Indiana | 18043 | 19006 | 300 |
2441679 | 2441679 | 2022-04-25 | Fountain | Indiana | 18045 | 5432 | 102 |
2441680 | 2441680 | 2022-04-25 | Franklin | Indiana | 18047 | 4374 | 65 |
2441681 | 2441681 | 2022-04-25 | Fulton | Indiana | 18049 | 4927 | 103 |
2441682 | 2441682 | 2022-04-25 | Gibson | Indiana | 18051 | 11656 | 146 |
2441683 | 2441683 | 2022-04-25 | Grant | Indiana | 18053 | 17334 | 350 |
2441684 | 2441684 | 2022-04-25 | Greene | Indiana | 18055 | 7220 | 139 |
2441685 | 2441685 | 2022-04-25 | Hamilton | Indiana | 18057 | 82271 | 661 |
2441686 | 2441686 | 2022-04-25 | Hancock | Indiana | 18059 | 20706 | 258 |
2441687 | 2441687 | 2022-04-25 | Harrison | Indiana | 18061 | 10831 | 138 |
2441688 | 2441688 | 2022-04-25 | Hendricks | Indiana | 18063 | 40808 | 554 |
2441689 | 2441689 | 2022-04-25 | Henry | Indiana | 18065 | 12992 | 231 |
2441690 | 2441690 | 2022-04-25 | Howard | Indiana | 18067 | 25436 | 448 |
2441691 | 2441691 | 2022-04-25 | Huntington | Indiana | 18069 | 11510 | 157 |
2441692 | 2441692 | 2022-04-25 | Jackson | Indiana | 18071 | 12534 | 130 |
2441693 | 2441693 | 2022-04-25 | Jasper | Indiana | 18073 | 9057 | 148 |
2441694 | 2441694 | 2022-04-25 | Jay | Indiana | 18075 | 4853 | 78 |
2441695 | 2441695 | 2022-04-25 | Jefferson | Indiana | 18077 | 9347 | 157 |
2441696 | 2441696 | 2022-04-25 | Jennings | Indiana | 18079 | 6944 | 108 |
2441697 | 2441697 | 2022-04-25 | Johnson | Indiana | 18081 | 42472 | 613 |
2441698 | 2441698 | 2022-04-25 | Knox | Indiana | 18083 | 10755 | 153 |
2441699 | 2441699 | 2022-04-25 | Kosciusko | Indiana | 18085 | 19762 | 237 |
2441700 | 2441700 | 2022-04-25 | LaGrange | Indiana | 18087 | 5846 | 102 |
2441701 | 2441701 | 2022-04-25 | LaPorte | Indiana | 18091 | 25580 | 368 |
2441702 | 2441702 | 2022-04-25 | Lake | Indiana | 18089 | 106872 | 1820 |
2441703 | 2441703 | 2022-04-25 | Lawrence | Indiana | 18093 | 11910 | 259 |
2441704 | 2441704 | 2022-04-25 | Madison | Indiana | 18095 | 32734 | 651 |
2441705 | 2441705 | 2022-04-25 | Marion | Indiana | 18097 | 225832 | 2991 |
2441706 | 2441706 | 2022-04-25 | Marshall | Indiana | 18099 | 12381 | 197 |
2441707 | 2441707 | 2022-04-25 | Martin | Indiana | 18101 | 2165 | 25 |
2441708 | 2441708 | 2022-04-25 | Miami | Indiana | 18103 | 9263 | 159 |
2441709 | 2441709 | 2022-04-25 | Monroe | Indiana | 18105 | 28133 | 280 |
2441710 | 2441710 | 2022-04-25 | Montgomery | Indiana | 18107 | 10678 | 164 |
2441711 | 2441711 | 2022-04-25 | Morgan | Indiana | 18109 | 16486 | 286 |
2441712 | 2441712 | 2022-04-25 | Newton | Indiana | 18111 | 2572 | 68 |
2441713 | 2441713 | 2022-04-25 | Noble | Indiana | 18113 | 13081 | 157 |
2441714 | 2441714 | 2022-04-25 | Ohio | Indiana | 18115 | 1445 | 19 |
2441715 | 2441715 | 2022-04-25 | Orange | Indiana | 18117 | 5038 | 96 |
2441716 | 2441716 | 2022-04-25 | Owen | Indiana | 18119 | 5858 | 121 |
2441717 | 2441717 | 2022-04-25 | Parke | Indiana | 18121 | 3595 | 46 |
2441718 | 2441718 | 2022-04-25 | Perry | Indiana | 18123 | 4656 | 69 |
2441719 | 2441719 | 2022-04-25 | Pike | Indiana | 18125 | 3730 | 49 |
2441720 | 2441720 | 2022-04-25 | Porter | Indiana | 18127 | 37946 | 562 |
2441721 | 2441721 | 2022-04-25 | Posey | Indiana | 18129 | 6545 | 58 |
2441722 | 2441722 | 2022-04-25 | Pulaski | Indiana | 18131 | 3076 | 86 |
2441723 | 2441723 | 2022-04-25 | Putnam | Indiana | 18133 | 9346 | 129 |
2441724 | 2441724 | 2022-04-25 | Randolph | Indiana | 18135 | 5904 | 148 |
2441725 | 2441725 | 2022-04-25 | Ripley | Indiana | 18137 | 8304 | 138 |
2441726 | 2441726 | 2022-04-25 | Rush | Indiana | 18139 | 4844 | 58 |
2441727 | 2441727 | 2022-04-25 | Scott | Indiana | 18143 | 7867 | 106 |
2441728 | 2441728 | 2022-04-25 | Shelby | Indiana | 18145 | 13607 | 182 |
2441729 | 2441729 | 2022-04-25 | Spencer | Indiana | 18147 | 5227 | 61 |
2441730 | 2441730 | 2022-04-25 | St. Joseph | Indiana | 18141 | 71010 | 871 |
2441731 | 2441731 | 2022-04-25 | Starke | Indiana | 18149 | 4758 | 98 |
2441732 | 2441732 | 2022-04-25 | Steuben | Indiana | 18151 | 9620 | 121 |
2441733 | 2441733 | 2022-04-25 | Sullivan | Indiana | 18153 | 5281 | 76 |
2441734 | 2441734 | 2022-04-25 | Switzerland | Indiana | 18155 | 2311 | 20 |
2441735 | 2441735 | 2022-04-25 | Tippecanoe | Indiana | 18157 | 50678 | 394 |
2441736 | 2441736 | 2022-04-25 | Tipton | Indiana | 18159 | 3528 | 87 |
2441737 | 2441737 | 2022-04-25 | Union | Indiana | 18161 | 2020 | 21 |
2441738 | 2441738 | 2022-04-25 | Unknown | Indiana | 0 | 17 | |
2441739 | 2441739 | 2022-04-25 | Vanderburgh | Indiana | 18163 | 57401 | 633 |
2441740 | 2441740 | 2022-04-25 | Vermillion | Indiana | 18165 | 4077 | 75 |
2441741 | 2441741 | 2022-04-25 | Vigo | Indiana | 18167 | 28887 | 413 |
2441742 | 2441742 | 2022-04-25 | Wabash | Indiana | 18169 | 8724 | 156 |
2441743 | 2441743 | 2022-04-25 | Warren | Indiana | 18171 | 2096 | 30 |
2441744 | 2441744 | 2022-04-25 | Warrick | Indiana | 18173 | 20301 | 239 |
2441745 | 2441745 | 2022-04-25 | Washington | Indiana | 18175 | 5995 | 84 |
2441746 | 2441746 | 2022-04-25 | Wayne | Indiana | 18177 | 18846 | 336 |
2441747 | 2441747 | 2022-04-25 | Wells | Indiana | 18179 | 6501 | 132 |
2441748 | 2441748 | 2022-04-25 | White | Indiana | 18181 | 6896 | 96 |
2441749 | 2441749 | 2022-04-25 | Whitley | Indiana | 18183 | 9676 | 84 |
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);