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-01-08 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2093578 | 2093578 | 2022-01-08 | Adams | Indiana | 18001 | 6164 | 97 |
2093579 | 2093579 | 2022-01-08 | Allen | Indiana | 18003 | 80867 | 1009 |
2093580 | 2093580 | 2022-01-08 | Bartholomew | Indiana | 18005 | 15460 | 214 |
2093581 | 2093581 | 2022-01-08 | Benton | Indiana | 18007 | 1976 | 21 |
2093582 | 2093582 | 2022-01-08 | Blackford | Indiana | 18009 | 2526 | 56 |
2093583 | 2093583 | 2022-01-08 | Boone | Indiana | 18011 | 11928 | 140 |
2093584 | 2093584 | 2022-01-08 | Brown | Indiana | 18013 | 2069 | 53 |
2093585 | 2093585 | 2022-01-08 | Carroll | Indiana | 18015 | 3402 | 49 |
2093586 | 2093586 | 2022-01-08 | Cass | Indiana | 18017 | 9137 | 143 |
2093587 | 2093587 | 2022-01-08 | Clark | Indiana | 18019 | 23171 | 319 |
2093588 | 2093588 | 2022-01-08 | Clay | Indiana | 18021 | 5399 | 72 |
2093589 | 2093589 | 2022-01-08 | Clinton | Indiana | 18023 | 7330 | 97 |
2093590 | 2093590 | 2022-01-08 | Crawford | Indiana | 18025 | 1927 | 32 |
2093591 | 2093591 | 2022-01-08 | Daviess | Indiana | 18027 | 5698 | 126 |
2093592 | 2093592 | 2022-01-08 | DeKalb | Indiana | 18033 | 9191 | 127 |
2093593 | 2093593 | 2022-01-08 | Dearborn | Indiana | 18029 | 10321 | 117 |
2093594 | 2093594 | 2022-01-08 | Decatur | Indiana | 18031 | 5416 | 121 |
2093595 | 2093595 | 2022-01-08 | Delaware | Indiana | 18035 | 19479 | 363 |
2093596 | 2093596 | 2022-01-08 | Dubois | Indiana | 18037 | 9846 | 153 |
2093597 | 2093597 | 2022-01-08 | Elkhart | Indiana | 18039 | 45106 | 637 |
2093598 | 2093598 | 2022-01-08 | Fayette | Indiana | 18041 | 5464 | 120 |
2093599 | 2093599 | 2022-01-08 | Floyd | Indiana | 18043 | 13952 | 252 |
2093600 | 2093600 | 2022-01-08 | Fountain | Indiana | 18045 | 4353 | 81 |
2093601 | 2093601 | 2022-01-08 | Franklin | Indiana | 18047 | 3492 | 54 |
2093602 | 2093602 | 2022-01-08 | Fulton | Indiana | 18049 | 4048 | 91 |
2093603 | 2093603 | 2022-01-08 | Gibson | Indiana | 18051 | 8179 | 129 |
2093604 | 2093604 | 2022-01-08 | Grant | Indiana | 18053 | 14231 | 291 |
2093605 | 2093605 | 2022-01-08 | Greene | Indiana | 18055 | 5440 | 114 |
2093606 | 2093606 | 2022-01-08 | Hamilton | Indiana | 18057 | 63192 | 551 |
2093607 | 2093607 | 2022-01-08 | Hancock | Indiana | 18059 | 16204 | 209 |
2093608 | 2093608 | 2022-01-08 | Harrison | Indiana | 18061 | 7951 | 114 |
2093609 | 2093609 | 2022-01-08 | Hendricks | Indiana | 18063 | 31375 | 457 |
2093610 | 2093610 | 2022-01-08 | Henry | Indiana | 18065 | 10511 | 192 |
2093611 | 2093611 | 2022-01-08 | Howard | Indiana | 18067 | 19527 | 369 |
2093612 | 2093612 | 2022-01-08 | Huntington | Indiana | 18069 | 9006 | 138 |
2093613 | 2093613 | 2022-01-08 | Jackson | Indiana | 18071 | 9148 | 104 |
2093614 | 2093614 | 2022-01-08 | Jasper | Indiana | 18073 | 7486 | 113 |
2093615 | 2093615 | 2022-01-08 | Jay | Indiana | 18075 | 3791 | 67 |
2093616 | 2093616 | 2022-01-08 | Jefferson | Indiana | 18077 | 7004 | 124 |
2093617 | 2093617 | 2022-01-08 | Jennings | Indiana | 18079 | 5268 | 76 |
2093618 | 2093618 | 2022-01-08 | Johnson | Indiana | 18081 | 33159 | 522 |
2093619 | 2093619 | 2022-01-08 | Knox | Indiana | 18083 | 7972 | 124 |
2093620 | 2093620 | 2022-01-08 | Kosciusko | Indiana | 18085 | 16457 | 197 |
2093621 | 2093621 | 2022-01-08 | LaGrange | Indiana | 18087 | 4786 | 97 |
2093622 | 2093622 | 2022-01-08 | LaPorte | Indiana | 18091 | 21042 | 300 |
2093623 | 2093623 | 2022-01-08 | Lake | Indiana | 18089 | 92404 | 1451 |
2093624 | 2093624 | 2022-01-08 | Lawrence | Indiana | 18093 | 9161 | 213 |
2093625 | 2093625 | 2022-01-08 | Madison | Indiana | 18095 | 25534 | 538 |
2093626 | 2093626 | 2022-01-08 | Marion | Indiana | 18097 | 179388 | 2510 |
2093627 | 2093627 | 2022-01-08 | Marshall | Indiana | 18099 | 10435 | 173 |
2093628 | 2093628 | 2022-01-08 | Martin | Indiana | 18101 | 1687 | 21 |
2093629 | 2093629 | 2022-01-08 | Miami | Indiana | 18103 | 7384 | 131 |
2093630 | 2093630 | 2022-01-08 | Monroe | Indiana | 18105 | 19393 | 240 |
2093631 | 2093631 | 2022-01-08 | Montgomery | Indiana | 18107 | 8250 | 140 |
2093632 | 2093632 | 2022-01-08 | Morgan | Indiana | 18109 | 12457 | 230 |
2093633 | 2093633 | 2022-01-08 | Newton | Indiana | 18111 | 2130 | 60 |
2093634 | 2093634 | 2022-01-08 | Noble | Indiana | 18113 | 10562 | 141 |
2093635 | 2093635 | 2022-01-08 | Ohio | Indiana | 18115 | 1044 | 16 |
2093636 | 2093636 | 2022-01-08 | Orange | Indiana | 18117 | 3817 | 84 |
2093637 | 2093637 | 2022-01-08 | Owen | Indiana | 18119 | 4219 | 90 |
2093638 | 2093638 | 2022-01-08 | Parke | Indiana | 18121 | 2833 | 39 |
2093639 | 2093639 | 2022-01-08 | Perry | Indiana | 18123 | 3374 | 59 |
2093640 | 2093640 | 2022-01-08 | Pike | Indiana | 18125 | 2856 | 46 |
2093641 | 2093641 | 2022-01-08 | Porter | Indiana | 18127 | 31667 | 462 |
2093642 | 2093642 | 2022-01-08 | Posey | Indiana | 18129 | 4712 | 46 |
2093643 | 2093643 | 2022-01-08 | Pulaski | Indiana | 18131 | 2491 | 72 |
2093644 | 2093644 | 2022-01-08 | Putnam | Indiana | 18133 | 7390 | 95 |
2093645 | 2093645 | 2022-01-08 | Randolph | Indiana | 18135 | 4663 | 123 |
2093646 | 2093646 | 2022-01-08 | Ripley | Indiana | 18137 | 6507 | 107 |
2093647 | 2093647 | 2022-01-08 | Rush | Indiana | 18139 | 3718 | 36 |
2093648 | 2093648 | 2022-01-08 | Scott | Indiana | 18143 | 5770 | 88 |
2093649 | 2093649 | 2022-01-08 | Shelby | Indiana | 18145 | 11217 | 159 |
2093650 | 2093650 | 2022-01-08 | Spencer | Indiana | 18147 | 4109 | 58 |
2093651 | 2093651 | 2022-01-08 | St. Joseph | Indiana | 18141 | 58613 | 745 |
2093652 | 2093652 | 2022-01-08 | Starke | Indiana | 18149 | 4142 | 85 |
2093653 | 2093653 | 2022-01-08 | Steuben | Indiana | 18151 | 7773 | 101 |
2093654 | 2093654 | 2022-01-08 | Sullivan | Indiana | 18153 | 3987 | 62 |
2093655 | 2093655 | 2022-01-08 | Switzerland | Indiana | 18155 | 1728 | 14 |
2093656 | 2093656 | 2022-01-08 | Tippecanoe | Indiana | 18157 | 37079 | 321 |
2093657 | 2093657 | 2022-01-08 | Tipton | Indiana | 18159 | 2853 | 75 |
2093658 | 2093658 | 2022-01-08 | Union | Indiana | 18161 | 1505 | 19 |
2093659 | 2093659 | 2022-01-08 | Vanderburgh | Indiana | 18163 | 40423 | 534 |
2093660 | 2093660 | 2022-01-08 | Vermillion | Indiana | 18165 | 3244 | 61 |
2093661 | 2093661 | 2022-01-08 | Vigo | Indiana | 18167 | 22525 | 339 |
2093662 | 2093662 | 2022-01-08 | Wabash | Indiana | 18169 | 7132 | 134 |
2093663 | 2093663 | 2022-01-08 | Warren | Indiana | 18171 | 1585 | 22 |
2093664 | 2093664 | 2022-01-08 | Warrick | Indiana | 18173 | 14268 | 212 |
2093665 | 2093665 | 2022-01-08 | Washington | Indiana | 18175 | 4422 | 63 |
2093666 | 2093666 | 2022-01-08 | Wayne | Indiana | 18177 | 14528 | 298 |
2093667 | 2093667 | 2022-01-08 | Wells | Indiana | 18179 | 5493 | 120 |
2093668 | 2093668 | 2022-01-08 | White | Indiana | 18181 | 5548 | 78 |
2093669 | 2093669 | 2022-01-08 | Whitley | Indiana | 18183 | 7676 | 71 |
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);