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 2021-11-01 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1872555 | 1872555 | 2021-11-01 | Adams | Indiana | 18001 | 4994 | 79 |
1872556 | 1872556 | 2021-11-01 | Allen | Indiana | 18003 | 59175 | 840 |
1872557 | 1872557 | 2021-11-01 | Bartholomew | Indiana | 18005 | 11852 | 187 |
1872558 | 1872558 | 2021-11-01 | Benton | Indiana | 18007 | 1523 | 17 |
1872559 | 1872559 | 2021-11-01 | Blackford | Indiana | 18009 | 2000 | 45 |
1872560 | 1872560 | 2021-11-01 | Boone | Indiana | 18011 | 9076 | 125 |
1872561 | 1872561 | 2021-11-01 | Brown | Indiana | 18013 | 1504 | 49 |
1872562 | 1872562 | 2021-11-01 | Carroll | Indiana | 18015 | 2663 | 38 |
1872563 | 1872563 | 2021-11-01 | Cass | Indiana | 18017 | 7624 | 126 |
1872564 | 1872564 | 2021-11-01 | Clark | Indiana | 18019 | 18963 | 270 |
1872565 | 1872565 | 2021-11-01 | Clay | Indiana | 18021 | 4322 | 61 |
1872566 | 1872566 | 2021-11-01 | Clinton | Indiana | 18023 | 5857 | 78 |
1872567 | 1872567 | 2021-11-01 | Crawford | Indiana | 18025 | 1624 | 27 |
1872568 | 1872568 | 2021-11-01 | Daviess | Indiana | 18027 | 4725 | 118 |
1872569 | 1872569 | 2021-11-01 | DeKalb | Indiana | 18033 | 6512 | 105 |
1872570 | 1872570 | 2021-11-01 | Dearborn | Indiana | 18029 | 8329 | 102 |
1872571 | 1872571 | 2021-11-01 | Decatur | Indiana | 18031 | 4269 | 110 |
1872572 | 1872572 | 2021-11-01 | Delaware | Indiana | 18035 | 15279 | 278 |
1872573 | 1872573 | 2021-11-01 | Dubois | Indiana | 18037 | 8342 | 135 |
1872574 | 1872574 | 2021-11-01 | Elkhart | Indiana | 18039 | 36540 | 536 |
1872575 | 1872575 | 2021-11-01 | Fayette | Indiana | 18041 | 4232 | 92 |
1872576 | 1872576 | 2021-11-01 | Floyd | Indiana | 18043 | 11259 | 226 |
1872577 | 1872577 | 2021-11-01 | Fountain | Indiana | 18045 | 3403 | 62 |
1872578 | 1872578 | 2021-11-01 | Franklin | Indiana | 18047 | 2703 | 46 |
1872579 | 1872579 | 2021-11-01 | Fulton | Indiana | 18049 | 3228 | 69 |
1872580 | 1872580 | 2021-11-01 | Gibson | Indiana | 18051 | 6689 | 119 |
1872581 | 1872581 | 2021-11-01 | Grant | Indiana | 18053 | 10770 | 232 |
1872582 | 1872582 | 2021-11-01 | Greene | Indiana | 18055 | 4335 | 101 |
1872583 | 1872583 | 2021-11-01 | Hamilton | Indiana | 18057 | 46977 | 500 |
1872584 | 1872584 | 2021-11-01 | Hancock | Indiana | 18059 | 11905 | 184 |
1872585 | 1872585 | 2021-11-01 | Harrison | Indiana | 18061 | 6583 | 98 |
1872586 | 1872586 | 2021-11-01 | Hendricks | Indiana | 18063 | 24259 | 386 |
1872587 | 1872587 | 2021-11-01 | Henry | Indiana | 18065 | 8361 | 160 |
1872588 | 1872588 | 2021-11-01 | Howard | Indiana | 18067 | 15058 | 303 |
1872589 | 1872589 | 2021-11-01 | Huntington | Indiana | 18069 | 6548 | 102 |
1872590 | 1872590 | 2021-11-01 | Jackson | Indiana | 18071 | 7096 | 95 |
1872591 | 1872591 | 2021-11-01 | Jasper | Indiana | 18073 | 5490 | 91 |
1872592 | 1872592 | 2021-11-01 | Jay | Indiana | 18075 | 2914 | 52 |
1872593 | 1872593 | 2021-11-01 | Jefferson | Indiana | 18077 | 5195 | 100 |
1872594 | 1872594 | 2021-11-01 | Jennings | Indiana | 18079 | 3981 | 66 |
1872595 | 1872595 | 2021-11-01 | Johnson | Indiana | 18081 | 25513 | 469 |
1872596 | 1872596 | 2021-11-01 | Knox | Indiana | 18083 | 6473 | 111 |
1872597 | 1872597 | 2021-11-01 | Kosciusko | Indiana | 18085 | 12636 | 154 |
1872598 | 1872598 | 2021-11-01 | LaGrange | Indiana | 18087 | 3715 | 82 |
1872599 | 1872599 | 2021-11-01 | LaPorte | Indiana | 18091 | 15465 | 256 |
1872600 | 1872600 | 2021-11-01 | Lake | Indiana | 18089 | 67380 | 1229 |
1872601 | 1872601 | 2021-11-01 | Lawrence | Indiana | 18093 | 7548 | 178 |
1872602 | 1872602 | 2021-11-01 | Madison | Indiana | 18095 | 19102 | 439 |
1872603 | 1872603 | 2021-11-01 | Marion | Indiana | 18097 | 137189 | 2231 |
1872604 | 1872604 | 2021-11-01 | Marshall | Indiana | 18099 | 8145 | 142 |
1872605 | 1872605 | 2021-11-01 | Martin | Indiana | 18101 | 1415 | 20 |
1872606 | 1872606 | 2021-11-01 | Miami | Indiana | 18103 | 6028 | 103 |
1872607 | 1872607 | 2021-11-01 | Monroe | Indiana | 18105 | 15502 | 204 |
1872608 | 1872608 | 2021-11-01 | Montgomery | Indiana | 18107 | 6381 | 115 |
1872609 | 1872609 | 2021-11-01 | Morgan | Indiana | 18109 | 9607 | 190 |
1872610 | 1872610 | 2021-11-01 | Newton | Indiana | 18111 | 1643 | 51 |
1872611 | 1872611 | 2021-11-01 | Noble | Indiana | 18113 | 8205 | 111 |
1872612 | 1872612 | 2021-11-01 | Ohio | Indiana | 18115 | 859 | 13 |
1872613 | 1872613 | 2021-11-01 | Orange | Indiana | 18117 | 2999 | 69 |
1872614 | 1872614 | 2021-11-01 | Owen | Indiana | 18119 | 3203 | 74 |
1872615 | 1872615 | 2021-11-01 | Parke | Indiana | 18121 | 2355 | 30 |
1872616 | 1872616 | 2021-11-01 | Perry | Indiana | 18123 | 2683 | 55 |
1872617 | 1872617 | 2021-11-01 | Pike | Indiana | 18125 | 2313 | 45 |
1872618 | 1872618 | 2021-11-01 | Porter | Indiana | 18127 | 23258 | 383 |
1872619 | 1872619 | 2021-11-01 | Posey | Indiana | 18129 | 3800 | 44 |
1872620 | 1872620 | 2021-11-01 | Pulaski | Indiana | 18131 | 1878 | 57 |
1872621 | 1872621 | 2021-11-01 | Putnam | Indiana | 18133 | 5910 | 83 |
1872622 | 1872622 | 2021-11-01 | Randolph | Indiana | 18135 | 3574 | 101 |
1872623 | 1872623 | 2021-11-01 | Ripley | Indiana | 18137 | 5078 | 91 |
1872624 | 1872624 | 2021-11-01 | Rush | Indiana | 18139 | 2759 | 32 |
1872625 | 1872625 | 2021-11-01 | Scott | Indiana | 18143 | 4460 | 78 |
1872626 | 1872626 | 2021-11-01 | Shelby | Indiana | 18145 | 8332 | 132 |
1872627 | 1872627 | 2021-11-01 | Spencer | Indiana | 18147 | 3427 | 43 |
1872628 | 1872628 | 2021-11-01 | St. Joseph | Indiana | 18141 | 45162 | 640 |
1872629 | 1872629 | 2021-11-01 | Starke | Indiana | 18149 | 3252 | 73 |
1872630 | 1872630 | 2021-11-01 | Steuben | Indiana | 18151 | 5794 | 80 |
1872631 | 1872631 | 2021-11-01 | Sullivan | Indiana | 18153 | 3334 | 54 |
1872632 | 1872632 | 2021-11-01 | Switzerland | Indiana | 18155 | 1367 | 11 |
1872633 | 1872633 | 2021-11-01 | Tippecanoe | Indiana | 18157 | 28317 | 270 |
1872634 | 1872634 | 2021-11-01 | Tipton | Indiana | 18159 | 2316 | 61 |
1872635 | 1872635 | 2021-11-01 | Union | Indiana | 18161 | 1109 | 17 |
1872636 | 1872636 | 2021-11-01 | Vanderburgh | Indiana | 18163 | 32558 | 497 |
1872637 | 1872637 | 2021-11-01 | Vermillion | Indiana | 18165 | 2632 | 54 |
1872638 | 1872638 | 2021-11-01 | Vigo | Indiana | 18167 | 17733 | 311 |
1872639 | 1872639 | 2021-11-01 | Wabash | Indiana | 18169 | 5452 | 105 |
1872640 | 1872640 | 2021-11-01 | Warren | Indiana | 18171 | 1227 | 18 |
1872641 | 1872641 | 2021-11-01 | Warrick | Indiana | 18173 | 11370 | 193 |
1872642 | 1872642 | 2021-11-01 | Washington | Indiana | 18175 | 3638 | 53 |
1872643 | 1872643 | 2021-11-01 | Wayne | Indiana | 18177 | 11520 | 260 |
1872644 | 1872644 | 2021-11-01 | Wells | Indiana | 18179 | 4322 | 91 |
1872645 | 1872645 | 2021-11-01 | White | Indiana | 18181 | 4304 | 67 |
1872646 | 1872646 | 2021-11-01 | Whitley | Indiana | 18183 | 5776 | 57 |
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);