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 2020-09-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 |
---|---|---|---|---|---|---|---|
567502 | 567502 | 2020-09-25 | Adams | Indiana | 18001 | 262 | 4 |
567503 | 567503 | 2020-09-25 | Allen | Indiana | 18003 | 6206 | 212 |
567504 | 567504 | 2020-09-25 | Bartholomew | Indiana | 18005 | 1179 | 61 |
567505 | 567505 | 2020-09-25 | Benton | Indiana | 18007 | 88 | 0 |
567506 | 567506 | 2020-09-25 | Blackford | Indiana | 18009 | 127 | 3 |
567507 | 567507 | 2020-09-25 | Boone | Indiana | 18011 | 988 | 49 |
567508 | 567508 | 2020-09-25 | Brown | Indiana | 18013 | 104 | 3 |
567509 | 567509 | 2020-09-25 | Carroll | Indiana | 18015 | 274 | 13 |
567510 | 567510 | 2020-09-25 | Cass | Indiana | 18017 | 1944 | 10 |
567511 | 567511 | 2020-09-25 | Clark | Indiana | 18019 | 2231 | 64 |
567512 | 567512 | 2020-09-25 | Clay | Indiana | 18021 | 300 | 5 |
567513 | 567513 | 2020-09-25 | Clinton | Indiana | 18023 | 603 | 18 |
567514 | 567514 | 2020-09-25 | Crawford | Indiana | 18025 | 106 | 1 |
567515 | 567515 | 2020-09-25 | Daviess | Indiana | 18027 | 665 | 30 |
567516 | 567516 | 2020-09-25 | DeKalb | Indiana | 18033 | 478 | 12 |
567517 | 567517 | 2020-09-25 | Dearborn | Indiana | 18029 | 667 | 30 |
567518 | 567518 | 2020-09-25 | Decatur | Indiana | 18031 | 485 | 42 |
567519 | 567519 | 2020-09-25 | Delaware | Indiana | 18035 | 1947 | 63 |
567520 | 567520 | 2020-09-25 | Dubois | Indiana | 18037 | 969 | 19 |
567521 | 567521 | 2020-09-25 | Elkhart | Indiana | 18039 | 6622 | 114 |
567522 | 567522 | 2020-09-25 | Fayette | Indiana | 18041 | 533 | 13 |
567523 | 567523 | 2020-09-25 | Floyd | Indiana | 18043 | 1364 | 65 |
567524 | 567524 | 2020-09-25 | Fountain | Indiana | 18045 | 124 | 2 |
567525 | 567525 | 2020-09-25 | Franklin | Indiana | 18047 | 317 | 26 |
567526 | 567526 | 2020-09-25 | Fulton | Indiana | 18049 | 240 | 2 |
567527 | 567527 | 2020-09-25 | Gibson | Indiana | 18051 | 513 | 4 |
567528 | 567528 | 2020-09-25 | Grant | Indiana | 18053 | 1262 | 37 |
567529 | 567529 | 2020-09-25 | Greene | Indiana | 18055 | 429 | 38 |
567530 | 567530 | 2020-09-25 | Hamilton | Indiana | 18057 | 4880 | 118 |
567531 | 567531 | 2020-09-25 | Hancock | Indiana | 18059 | 936 | 46 |
567532 | 567532 | 2020-09-25 | Harrison | Indiana | 18061 | 579 | 26 |
567533 | 567533 | 2020-09-25 | Hendricks | Indiana | 18063 | 2749 | 140 |
567534 | 567534 | 2020-09-25 | Henry | Indiana | 18065 | 810 | 26 |
567535 | 567535 | 2020-09-25 | Howard | Indiana | 18067 | 1313 | 66 |
567536 | 567536 | 2020-09-25 | Huntington | Indiana | 18069 | 239 | 3 |
567537 | 567537 | 2020-09-25 | Jackson | Indiana | 18071 | 753 | 10 |
567538 | 567538 | 2020-09-25 | Jasper | Indiana | 18073 | 396 | 3 |
567539 | 567539 | 2020-09-25 | Jay | Indiana | 18075 | 186 | 0 |
567540 | 567540 | 2020-09-25 | Jefferson | Indiana | 18077 | 249 | 3 |
567541 | 567541 | 2020-09-25 | Jennings | Indiana | 18079 | 316 | 14 |
567542 | 567542 | 2020-09-25 | Johnson | Indiana | 18081 | 2344 | 132 |
567543 | 567543 | 2020-09-25 | Knox | Indiana | 18083 | 516 | 9 |
567544 | 567544 | 2020-09-25 | Kosciusko | Indiana | 18085 | 1236 | 19 |
567545 | 567545 | 2020-09-25 | LaGrange | Indiana | 18087 | 636 | 11 |
567546 | 567546 | 2020-09-25 | LaPorte | Indiana | 18091 | 1427 | 40 |
567547 | 567547 | 2020-09-25 | Lake | Indiana | 18089 | 10555 | 341 |
567548 | 567548 | 2020-09-25 | Lawrence | Indiana | 18093 | 513 | 31 |
567549 | 567549 | 2020-09-25 | Madison | Indiana | 18095 | 1659 | 86 |
567550 | 567550 | 2020-09-25 | Marion | Indiana | 18097 | 21367 | 817 |
567551 | 567551 | 2020-09-25 | Marshall | Indiana | 18099 | 1008 | 24 |
567552 | 567552 | 2020-09-25 | Martin | Indiana | 18101 | 165 | 0 |
567553 | 567553 | 2020-09-25 | Miami | Indiana | 18103 | 439 | 3 |
567554 | 567554 | 2020-09-25 | Monroe | Indiana | 18105 | 2565 | 40 |
567555 | 567555 | 2020-09-25 | Montgomery | Indiana | 18107 | 510 | 22 |
567556 | 567556 | 2020-09-25 | Morgan | Indiana | 18109 | 729 | 41 |
567557 | 567557 | 2020-09-25 | Newton | Indiana | 18111 | 174 | 12 |
567558 | 567558 | 2020-09-25 | Noble | Indiana | 18113 | 912 | 33 |
567559 | 567559 | 2020-09-25 | Ohio | Indiana | 18115 | 78 | 7 |
567560 | 567560 | 2020-09-25 | Orange | Indiana | 18117 | 290 | 26 |
567561 | 567561 | 2020-09-25 | Owen | Indiana | 18119 | 169 | 2 |
567562 | 567562 | 2020-09-25 | Parke | Indiana | 18121 | 102 | 2 |
567563 | 567563 | 2020-09-25 | Perry | Indiana | 18123 | 232 | 14 |
567564 | 567564 | 2020-09-25 | Pike | Indiana | 18125 | 147 | 1 |
567565 | 567565 | 2020-09-25 | Porter | Indiana | 18127 | 2147 | 49 |
567566 | 567566 | 2020-09-25 | Posey | Indiana | 18129 | 324 | 0 |
567567 | 567567 | 2020-09-25 | Pulaski | Indiana | 18131 | 115 | 1 |
567568 | 567568 | 2020-09-25 | Putnam | Indiana | 18133 | 569 | 12 |
567569 | 567569 | 2020-09-25 | Randolph | Indiana | 18135 | 252 | 7 |
567570 | 567570 | 2020-09-25 | Ripley | Indiana | 18137 | 297 | 8 |
567571 | 567571 | 2020-09-25 | Rush | Indiana | 18139 | 199 | 4 |
567572 | 567572 | 2020-09-25 | Scott | Indiana | 18143 | 379 | 13 |
567573 | 567573 | 2020-09-25 | Shelby | Indiana | 18145 | 1157 | 37 |
567574 | 567574 | 2020-09-25 | Spencer | Indiana | 18147 | 244 | 3 |
567575 | 567575 | 2020-09-25 | St. Joseph | Indiana | 18141 | 6410 | 112 |
567576 | 567576 | 2020-09-25 | Starke | Indiana | 18149 | 265 | 8 |
567577 | 567577 | 2020-09-25 | Steuben | Indiana | 18151 | 381 | 7 |
567578 | 567578 | 2020-09-25 | Sullivan | Indiana | 18153 | 341 | 12 |
567579 | 567579 | 2020-09-25 | Switzerland | Indiana | 18155 | 71 | 0 |
567580 | 567580 | 2020-09-25 | Tippecanoe | Indiana | 18157 | 2394 | 14 |
567581 | 567581 | 2020-09-25 | Tipton | Indiana | 18159 | 230 | 25 |
567582 | 567582 | 2020-09-25 | Union | Indiana | 18161 | 104 | 0 |
567583 | 567583 | 2020-09-25 | Vanderburgh | Indiana | 18163 | 3612 | 30 |
567584 | 567584 | 2020-09-25 | Vermillion | Indiana | 18165 | 129 | 0 |
567585 | 567585 | 2020-09-25 | Vigo | Indiana | 18167 | 1829 | 27 |
567586 | 567586 | 2020-09-25 | Wabash | Indiana | 18169 | 268 | 8 |
567587 | 567587 | 2020-09-25 | Warren | Indiana | 18171 | 40 | 1 |
567588 | 567588 | 2020-09-25 | Warrick | Indiana | 18173 | 1282 | 40 |
567589 | 567589 | 2020-09-25 | Washington | Indiana | 18175 | 265 | 1 |
567590 | 567590 | 2020-09-25 | Wayne | Indiana | 18177 | 1113 | 14 |
567591 | 567591 | 2020-09-25 | Wells | Indiana | 18179 | 278 | 4 |
567592 | 567592 | 2020-09-25 | White | Indiana | 18181 | 485 | 14 |
567593 | 567593 | 2020-09-25 | Whitley | Indiana | 18183 | 270 | 7 |
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);