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-21 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
554549 | 554549 | 2020-09-21 | Adams | Indiana | 18001 | 245 | 4 |
554550 | 554550 | 2020-09-21 | Allen | Indiana | 18003 | 6026 | 210 |
554551 | 554551 | 2020-09-21 | Bartholomew | Indiana | 18005 | 1166 | 61 |
554552 | 554552 | 2020-09-21 | Benton | Indiana | 18007 | 88 | 0 |
554553 | 554553 | 2020-09-21 | Blackford | Indiana | 18009 | 121 | 3 |
554554 | 554554 | 2020-09-21 | Boone | Indiana | 18011 | 965 | 49 |
554555 | 554555 | 2020-09-21 | Brown | Indiana | 18013 | 102 | 3 |
554556 | 554556 | 2020-09-21 | Carroll | Indiana | 18015 | 270 | 13 |
554557 | 554557 | 2020-09-21 | Cass | Indiana | 18017 | 1935 | 10 |
554558 | 554558 | 2020-09-21 | Clark | Indiana | 18019 | 2152 | 63 |
554559 | 554559 | 2020-09-21 | Clay | Indiana | 18021 | 293 | 5 |
554560 | 554560 | 2020-09-21 | Clinton | Indiana | 18023 | 595 | 16 |
554561 | 554561 | 2020-09-21 | Crawford | Indiana | 18025 | 104 | 1 |
554562 | 554562 | 2020-09-21 | Daviess | Indiana | 18027 | 645 | 29 |
554563 | 554563 | 2020-09-21 | DeKalb | Indiana | 18033 | 453 | 12 |
554564 | 554564 | 2020-09-21 | Dearborn | Indiana | 18029 | 635 | 30 |
554565 | 554565 | 2020-09-21 | Decatur | Indiana | 18031 | 479 | 42 |
554566 | 554566 | 2020-09-21 | Delaware | Indiana | 18035 | 1887 | 62 |
554567 | 554567 | 2020-09-21 | Dubois | Indiana | 18037 | 951 | 18 |
554568 | 554568 | 2020-09-21 | Elkhart | Indiana | 18039 | 6481 | 113 |
554569 | 554569 | 2020-09-21 | Fayette | Indiana | 18041 | 527 | 13 |
554570 | 554570 | 2020-09-21 | Floyd | Indiana | 18043 | 1315 | 64 |
554571 | 554571 | 2020-09-21 | Fountain | Indiana | 18045 | 117 | 2 |
554572 | 554572 | 2020-09-21 | Franklin | Indiana | 18047 | 309 | 26 |
554573 | 554573 | 2020-09-21 | Fulton | Indiana | 18049 | 236 | 2 |
554574 | 554574 | 2020-09-21 | Gibson | Indiana | 18051 | 481 | 4 |
554575 | 554575 | 2020-09-21 | Grant | Indiana | 18053 | 1230 | 36 |
554576 | 554576 | 2020-09-21 | Greene | Indiana | 18055 | 423 | 38 |
554577 | 554577 | 2020-09-21 | Hamilton | Indiana | 18057 | 4727 | 118 |
554578 | 554578 | 2020-09-21 | Hancock | Indiana | 18059 | 922 | 45 |
554579 | 554579 | 2020-09-21 | Harrison | Indiana | 18061 | 564 | 26 |
554580 | 554580 | 2020-09-21 | Hendricks | Indiana | 18063 | 2697 | 139 |
554581 | 554581 | 2020-09-21 | Henry | Indiana | 18065 | 781 | 24 |
554582 | 554582 | 2020-09-21 | Howard | Indiana | 18067 | 1285 | 66 |
554583 | 554583 | 2020-09-21 | Huntington | Indiana | 18069 | 226 | 3 |
554584 | 554584 | 2020-09-21 | Jackson | Indiana | 18071 | 744 | 10 |
554585 | 554585 | 2020-09-21 | Jasper | Indiana | 18073 | 386 | 3 |
554586 | 554586 | 2020-09-21 | Jay | Indiana | 18075 | 178 | 0 |
554587 | 554587 | 2020-09-21 | Jefferson | Indiana | 18077 | 244 | 3 |
554588 | 554588 | 2020-09-21 | Jennings | Indiana | 18079 | 313 | 14 |
554589 | 554589 | 2020-09-21 | Johnson | Indiana | 18081 | 2297 | 131 |
554590 | 554590 | 2020-09-21 | Knox | Indiana | 18083 | 492 | 9 |
554591 | 554591 | 2020-09-21 | Kosciusko | Indiana | 18085 | 1218 | 19 |
554592 | 554592 | 2020-09-21 | LaGrange | Indiana | 18087 | 632 | 11 |
554593 | 554593 | 2020-09-21 | LaPorte | Indiana | 18091 | 1376 | 37 |
554594 | 554594 | 2020-09-21 | Lake | Indiana | 18089 | 10324 | 337 |
554595 | 554595 | 2020-09-21 | Lawrence | Indiana | 18093 | 506 | 30 |
554596 | 554596 | 2020-09-21 | Madison | Indiana | 18095 | 1601 | 86 |
554597 | 554597 | 2020-09-21 | Marion | Indiana | 18097 | 20915 | 809 |
554598 | 554598 | 2020-09-21 | Marshall | Indiana | 18099 | 988 | 24 |
554599 | 554599 | 2020-09-21 | Martin | Indiana | 18101 | 165 | 0 |
554600 | 554600 | 2020-09-21 | Miami | Indiana | 18103 | 429 | 3 |
554601 | 554601 | 2020-09-21 | Monroe | Indiana | 18105 | 2427 | 40 |
554602 | 554602 | 2020-09-21 | Montgomery | Indiana | 18107 | 507 | 22 |
554603 | 554603 | 2020-09-21 | Morgan | Indiana | 18109 | 714 | 41 |
554604 | 554604 | 2020-09-21 | Newton | Indiana | 18111 | 171 | 12 |
554605 | 554605 | 2020-09-21 | Noble | Indiana | 18113 | 890 | 33 |
554606 | 554606 | 2020-09-21 | Ohio | Indiana | 18115 | 76 | 7 |
554607 | 554607 | 2020-09-21 | Orange | Indiana | 18117 | 286 | 26 |
554608 | 554608 | 2020-09-21 | Owen | Indiana | 18119 | 166 | 2 |
554609 | 554609 | 2020-09-21 | Parke | Indiana | 18121 | 100 | 1 |
554610 | 554610 | 2020-09-21 | Perry | Indiana | 18123 | 219 | 14 |
554611 | 554611 | 2020-09-21 | Pike | Indiana | 18125 | 141 | 1 |
554612 | 554612 | 2020-09-21 | Porter | Indiana | 18127 | 2081 | 47 |
554613 | 554613 | 2020-09-21 | Posey | Indiana | 18129 | 302 | 0 |
554614 | 554614 | 2020-09-21 | Pulaski | Indiana | 18131 | 116 | 1 |
554615 | 554615 | 2020-09-21 | Putnam | Indiana | 18133 | 539 | 9 |
554616 | 554616 | 2020-09-21 | Randolph | Indiana | 18135 | 242 | 7 |
554617 | 554617 | 2020-09-21 | Ripley | Indiana | 18137 | 279 | 8 |
554618 | 554618 | 2020-09-21 | Rush | Indiana | 18139 | 194 | 4 |
554619 | 554619 | 2020-09-21 | Scott | Indiana | 18143 | 360 | 12 |
554620 | 554620 | 2020-09-21 | Shelby | Indiana | 18145 | 1140 | 37 |
554621 | 554621 | 2020-09-21 | Spencer | Indiana | 18147 | 224 | 4 |
554622 | 554622 | 2020-09-21 | St. Joseph | Indiana | 18141 | 6127 | 106 |
554623 | 554623 | 2020-09-21 | Starke | Indiana | 18149 | 255 | 8 |
554624 | 554624 | 2020-09-21 | Steuben | Indiana | 18151 | 370 | 7 |
554625 | 554625 | 2020-09-21 | Sullivan | Indiana | 18153 | 334 | 12 |
554626 | 554626 | 2020-09-21 | Switzerland | Indiana | 18155 | 71 | 0 |
554627 | 554627 | 2020-09-21 | Tippecanoe | Indiana | 18157 | 2236 | 14 |
554628 | 554628 | 2020-09-21 | Tipton | Indiana | 18159 | 221 | 25 |
554629 | 554629 | 2020-09-21 | Union | Indiana | 18161 | 101 | 0 |
554630 | 554630 | 2020-09-21 | Vanderburgh | Indiana | 18163 | 3386 | 30 |
554631 | 554631 | 2020-09-21 | Vermillion | Indiana | 18165 | 127 | 0 |
554632 | 554632 | 2020-09-21 | Vigo | Indiana | 18167 | 1773 | 23 |
554633 | 554633 | 2020-09-21 | Wabash | Indiana | 18169 | 266 | 8 |
554634 | 554634 | 2020-09-21 | Warren | Indiana | 18171 | 41 | 1 |
554635 | 554635 | 2020-09-21 | Warrick | Indiana | 18173 | 1172 | 37 |
554636 | 554636 | 2020-09-21 | Washington | Indiana | 18175 | 259 | 1 |
554637 | 554637 | 2020-09-21 | Wayne | Indiana | 18177 | 1099 | 14 |
554638 | 554638 | 2020-09-21 | Wells | Indiana | 18179 | 264 | 2 |
554639 | 554639 | 2020-09-21 | White | Indiana | 18181 | 480 | 14 |
554640 | 554640 | 2020-09-21 | Whitley | Indiana | 18183 | 254 | 6 |
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);