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-04-05 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2376545 | 2376545 | 2022-04-05 | Adams | Indiana | 18001 | 7259 | 112 |
2376546 | 2376546 | 2022-04-05 | Allen | Indiana | 18003 | 103696 | 1174 |
2376547 | 2376547 | 2022-04-05 | Bartholomew | Indiana | 18005 | 21306 | 249 |
2376548 | 2376548 | 2022-04-05 | Benton | Indiana | 18007 | 2477 | 21 |
2376549 | 2376549 | 2022-04-05 | Blackford | Indiana | 18009 | 3107 | 69 |
2376550 | 2376550 | 2022-04-05 | Boone | Indiana | 18011 | 15182 | 181 |
2376551 | 2376551 | 2022-04-05 | Brown | Indiana | 18013 | 2585 | 62 |
2376552 | 2376552 | 2022-04-05 | Carroll | Indiana | 18015 | 4217 | 68 |
2376553 | 2376553 | 2022-04-05 | Cass | Indiana | 18017 | 11659 | 163 |
2376554 | 2376554 | 2022-04-05 | Clark | Indiana | 18019 | 31049 | 396 |
2376555 | 2376555 | 2022-04-05 | Clay | Indiana | 18021 | 6824 | 88 |
2376556 | 2376556 | 2022-04-05 | Clinton | Indiana | 18023 | 9182 | 125 |
2376557 | 2376557 | 2022-04-05 | Crawford | Indiana | 18025 | 2546 | 39 |
2376558 | 2376558 | 2022-04-05 | Daviess | Indiana | 18027 | 7467 | 153 |
2376559 | 2376559 | 2022-04-05 | DeKalb | Indiana | 18033 | 11342 | 149 |
2376560 | 2376560 | 2022-04-05 | Dearborn | Indiana | 18029 | 13420 | 139 |
2376561 | 2376561 | 2022-04-05 | Decatur | Indiana | 18031 | 6992 | 145 |
2376562 | 2376562 | 2022-04-05 | Delaware | Indiana | 18035 | 24803 | 440 |
2376563 | 2376563 | 2022-04-05 | Dubois | Indiana | 18037 | 12855 | 165 |
2376564 | 2376564 | 2022-04-05 | Elkhart | Indiana | 18039 | 54055 | 728 |
2376565 | 2376565 | 2022-04-05 | Fayette | Indiana | 18041 | 6731 | 146 |
2376566 | 2376566 | 2022-04-05 | Floyd | Indiana | 18043 | 18910 | 299 |
2376567 | 2376567 | 2022-04-05 | Fountain | Indiana | 18045 | 5408 | 102 |
2376568 | 2376568 | 2022-04-05 | Franklin | Indiana | 18047 | 4371 | 65 |
2376569 | 2376569 | 2022-04-05 | Fulton | Indiana | 18049 | 4913 | 102 |
2376570 | 2376570 | 2022-04-05 | Gibson | Indiana | 18051 | 11630 | 145 |
2376571 | 2376571 | 2022-04-05 | Grant | Indiana | 18053 | 17284 | 347 |
2376572 | 2376572 | 2022-04-05 | Greene | Indiana | 18055 | 7193 | 139 |
2376573 | 2376573 | 2022-04-05 | Hamilton | Indiana | 18057 | 81784 | 657 |
2376574 | 2376574 | 2022-04-05 | Hancock | Indiana | 18059 | 20643 | 258 |
2376575 | 2376575 | 2022-04-05 | Harrison | Indiana | 18061 | 10803 | 138 |
2376576 | 2376576 | 2022-04-05 | Hendricks | Indiana | 18063 | 40698 | 553 |
2376577 | 2376577 | 2022-04-05 | Henry | Indiana | 18065 | 12965 | 230 |
2376578 | 2376578 | 2022-04-05 | Howard | Indiana | 18067 | 25391 | 446 |
2376579 | 2376579 | 2022-04-05 | Huntington | Indiana | 18069 | 11490 | 155 |
2376580 | 2376580 | 2022-04-05 | Jackson | Indiana | 18071 | 12509 | 130 |
2376581 | 2376581 | 2022-04-05 | Jasper | Indiana | 18073 | 9010 | 148 |
2376582 | 2376582 | 2022-04-05 | Jay | Indiana | 18075 | 4837 | 78 |
2376583 | 2376583 | 2022-04-05 | Jefferson | Indiana | 18077 | 9338 | 156 |
2376584 | 2376584 | 2022-04-05 | Jennings | Indiana | 18079 | 6935 | 108 |
2376585 | 2376585 | 2022-04-05 | Johnson | Indiana | 18081 | 42241 | 612 |
2376586 | 2376586 | 2022-04-05 | Knox | Indiana | 18083 | 10739 | 153 |
2376587 | 2376587 | 2022-04-05 | Kosciusko | Indiana | 18085 | 19726 | 237 |
2376588 | 2376588 | 2022-04-05 | LaGrange | Indiana | 18087 | 5843 | 102 |
2376589 | 2376589 | 2022-04-05 | LaPorte | Indiana | 18091 | 25422 | 367 |
2376590 | 2376590 | 2022-04-05 | Lake | Indiana | 18089 | 106124 | 1816 |
2376591 | 2376591 | 2022-04-05 | Lawrence | Indiana | 18093 | 11843 | 259 |
2376592 | 2376592 | 2022-04-05 | Madison | Indiana | 18095 | 32642 | 648 |
2376593 | 2376593 | 2022-04-05 | Marion | Indiana | 18097 | 224820 | 2979 |
2376594 | 2376594 | 2022-04-05 | Marshall | Indiana | 18099 | 12317 | 195 |
2376595 | 2376595 | 2022-04-05 | Martin | Indiana | 18101 | 2162 | 25 |
2376596 | 2376596 | 2022-04-05 | Miami | Indiana | 18103 | 9251 | 159 |
2376597 | 2376597 | 2022-04-05 | Monroe | Indiana | 18105 | 27659 | 279 |
2376598 | 2376598 | 2022-04-05 | Montgomery | Indiana | 18107 | 10662 | 164 |
2376599 | 2376599 | 2022-04-05 | Morgan | Indiana | 18109 | 16441 | 286 |
2376600 | 2376600 | 2022-04-05 | Newton | Indiana | 18111 | 2562 | 68 |
2376601 | 2376601 | 2022-04-05 | Noble | Indiana | 18113 | 13066 | 156 |
2376602 | 2376602 | 2022-04-05 | Ohio | Indiana | 18115 | 1443 | 19 |
2376603 | 2376603 | 2022-04-05 | Orange | Indiana | 18117 | 5030 | 96 |
2376604 | 2376604 | 2022-04-05 | Owen | Indiana | 18119 | 5832 | 120 |
2376605 | 2376605 | 2022-04-05 | Parke | Indiana | 18121 | 3588 | 49 |
2376606 | 2376606 | 2022-04-05 | Perry | Indiana | 18123 | 4650 | 68 |
2376607 | 2376607 | 2022-04-05 | Pike | Indiana | 18125 | 3726 | 49 |
2376608 | 2376608 | 2022-04-05 | Porter | Indiana | 18127 | 37607 | 558 |
2376609 | 2376609 | 2022-04-05 | Posey | Indiana | 18129 | 6531 | 58 |
2376610 | 2376610 | 2022-04-05 | Pulaski | Indiana | 18131 | 3067 | 86 |
2376611 | 2376611 | 2022-04-05 | Putnam | Indiana | 18133 | 9310 | 128 |
2376612 | 2376612 | 2022-04-05 | Randolph | Indiana | 18135 | 5895 | 147 |
2376613 | 2376613 | 2022-04-05 | Ripley | Indiana | 18137 | 8280 | 138 |
2376614 | 2376614 | 2022-04-05 | Rush | Indiana | 18139 | 4835 | 58 |
2376615 | 2376615 | 2022-04-05 | Scott | Indiana | 18143 | 7855 | 106 |
2376616 | 2376616 | 2022-04-05 | Shelby | Indiana | 18145 | 13584 | 181 |
2376617 | 2376617 | 2022-04-05 | Spencer | Indiana | 18147 | 5217 | 60 |
2376618 | 2376618 | 2022-04-05 | St. Joseph | Indiana | 18141 | 70568 | 866 |
2376619 | 2376619 | 2022-04-05 | Starke | Indiana | 18149 | 4746 | 96 |
2376620 | 2376620 | 2022-04-05 | Steuben | Indiana | 18151 | 9615 | 120 |
2376621 | 2376621 | 2022-04-05 | Sullivan | Indiana | 18153 | 5270 | 76 |
2376622 | 2376622 | 2022-04-05 | Switzerland | Indiana | 18155 | 2311 | 20 |
2376623 | 2376623 | 2022-04-05 | Tippecanoe | Indiana | 18157 | 49970 | 394 |
2376624 | 2376624 | 2022-04-05 | Tipton | Indiana | 18159 | 3520 | 87 |
2376625 | 2376625 | 2022-04-05 | Union | Indiana | 18161 | 2016 | 21 |
2376626 | 2376626 | 2022-04-05 | Vanderburgh | Indiana | 18163 | 57239 | 624 |
2376627 | 2376627 | 2022-04-05 | Vermillion | Indiana | 18165 | 4071 | 75 |
2376628 | 2376628 | 2022-04-05 | Vigo | Indiana | 18167 | 28825 | 411 |
2376629 | 2376629 | 2022-04-05 | Wabash | Indiana | 18169 | 8717 | 155 |
2376630 | 2376630 | 2022-04-05 | Warren | Indiana | 18171 | 2090 | 30 |
2376631 | 2376631 | 2022-04-05 | Warrick | Indiana | 18173 | 20258 | 238 |
2376632 | 2376632 | 2022-04-05 | Washington | Indiana | 18175 | 5993 | 82 |
2376633 | 2376633 | 2022-04-05 | Wayne | Indiana | 18177 | 18826 | 334 |
2376634 | 2376634 | 2022-04-05 | Wells | Indiana | 18179 | 6496 | 132 |
2376635 | 2376635 | 2022-04-05 | White | Indiana | 18181 | 6857 | 94 |
2376636 | 2376636 | 2022-04-05 | Whitley | Indiana | 18183 | 9650 | 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);