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-17 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
541597 | 541597 | 2020-09-17 | Adams | Indiana | 18001 | 231 | 4 |
541598 | 541598 | 2020-09-17 | Allen | Indiana | 18003 | 5813 | 208 |
541599 | 541599 | 2020-09-17 | Bartholomew | Indiana | 18005 | 1147 | 61 |
541600 | 541600 | 2020-09-17 | Benton | Indiana | 18007 | 88 | 0 |
541601 | 541601 | 2020-09-17 | Blackford | Indiana | 18009 | 115 | 2 |
541602 | 541602 | 2020-09-17 | Boone | Indiana | 18011 | 958 | 49 |
541603 | 541603 | 2020-09-17 | Brown | Indiana | 18013 | 93 | 3 |
541604 | 541604 | 2020-09-17 | Carroll | Indiana | 18015 | 267 | 13 |
541605 | 541605 | 2020-09-17 | Cass | Indiana | 18017 | 1923 | 10 |
541606 | 541606 | 2020-09-17 | Clark | Indiana | 18019 | 2066 | 63 |
541607 | 541607 | 2020-09-17 | Clay | Indiana | 18021 | 285 | 5 |
541608 | 541608 | 2020-09-17 | Clinton | Indiana | 18023 | 595 | 15 |
541609 | 541609 | 2020-09-17 | Crawford | Indiana | 18025 | 99 | 1 |
541610 | 541610 | 2020-09-17 | Daviess | Indiana | 18027 | 618 | 29 |
541611 | 541611 | 2020-09-17 | DeKalb | Indiana | 18033 | 427 | 12 |
541612 | 541612 | 2020-09-17 | Dearborn | Indiana | 18029 | 621 | 30 |
541613 | 541613 | 2020-09-17 | Decatur | Indiana | 18031 | 473 | 42 |
541614 | 541614 | 2020-09-17 | Delaware | Indiana | 18035 | 1806 | 60 |
541615 | 541615 | 2020-09-17 | Dubois | Indiana | 18037 | 921 | 18 |
541616 | 541616 | 2020-09-17 | Elkhart | Indiana | 18039 | 6293 | 110 |
541617 | 541617 | 2020-09-17 | Fayette | Indiana | 18041 | 513 | 13 |
541618 | 541618 | 2020-09-17 | Floyd | Indiana | 18043 | 1285 | 64 |
541619 | 541619 | 2020-09-17 | Fountain | Indiana | 18045 | 116 | 2 |
541620 | 541620 | 2020-09-17 | Franklin | Indiana | 18047 | 302 | 26 |
541621 | 541621 | 2020-09-17 | Fulton | Indiana | 18049 | 231 | 2 |
541622 | 541622 | 2020-09-17 | Gibson | Indiana | 18051 | 436 | 4 |
541623 | 541623 | 2020-09-17 | Grant | Indiana | 18053 | 1193 | 35 |
541624 | 541624 | 2020-09-17 | Greene | Indiana | 18055 | 414 | 38 |
541625 | 541625 | 2020-09-17 | Hamilton | Indiana | 18057 | 4632 | 118 |
541626 | 541626 | 2020-09-17 | Hancock | Indiana | 18059 | 907 | 45 |
541627 | 541627 | 2020-09-17 | Harrison | Indiana | 18061 | 551 | 26 |
541628 | 541628 | 2020-09-17 | Hendricks | Indiana | 18063 | 2640 | 137 |
541629 | 541629 | 2020-09-17 | Henry | Indiana | 18065 | 746 | 24 |
541630 | 541630 | 2020-09-17 | Howard | Indiana | 18067 | 1259 | 66 |
541631 | 541631 | 2020-09-17 | Huntington | Indiana | 18069 | 210 | 3 |
541632 | 541632 | 2020-09-17 | Jackson | Indiana | 18071 | 729 | 10 |
541633 | 541633 | 2020-09-17 | Jasper | Indiana | 18073 | 375 | 3 |
541634 | 541634 | 2020-09-17 | Jay | Indiana | 18075 | 170 | 0 |
541635 | 541635 | 2020-09-17 | Jefferson | Indiana | 18077 | 237 | 3 |
541636 | 541636 | 2020-09-17 | Jennings | Indiana | 18079 | 308 | 14 |
541637 | 541637 | 2020-09-17 | Johnson | Indiana | 18081 | 2280 | 131 |
541638 | 541638 | 2020-09-17 | Knox | Indiana | 18083 | 466 | 9 |
541639 | 541639 | 2020-09-17 | Kosciusko | Indiana | 18085 | 1186 | 19 |
541640 | 541640 | 2020-09-17 | LaGrange | Indiana | 18087 | 630 | 11 |
541641 | 541641 | 2020-09-17 | LaPorte | Indiana | 18091 | 1352 | 37 |
541642 | 541642 | 2020-09-17 | Lake | Indiana | 18089 | 10074 | 330 |
541643 | 541643 | 2020-09-17 | Lawrence | Indiana | 18093 | 501 | 30 |
541644 | 541644 | 2020-09-17 | Madison | Indiana | 18095 | 1546 | 86 |
541645 | 541645 | 2020-09-17 | Marion | Indiana | 18097 | 20508 | 808 |
541646 | 541646 | 2020-09-17 | Marshall | Indiana | 18099 | 974 | 23 |
541647 | 541647 | 2020-09-17 | Martin | Indiana | 18101 | 157 | 0 |
541648 | 541648 | 2020-09-17 | Miami | Indiana | 18103 | 424 | 2 |
541649 | 541649 | 2020-09-17 | Monroe | Indiana | 18105 | 2248 | 40 |
541650 | 541650 | 2020-09-17 | Montgomery | Indiana | 18107 | 496 | 22 |
541651 | 541651 | 2020-09-17 | Morgan | Indiana | 18109 | 693 | 41 |
541652 | 541652 | 2020-09-17 | Newton | Indiana | 18111 | 165 | 12 |
541653 | 541653 | 2020-09-17 | Noble | Indiana | 18113 | 868 | 33 |
541654 | 541654 | 2020-09-17 | Ohio | Indiana | 18115 | 75 | 7 |
541655 | 541655 | 2020-09-17 | Orange | Indiana | 18117 | 281 | 26 |
541656 | 541656 | 2020-09-17 | Owen | Indiana | 18119 | 163 | 2 |
541657 | 541657 | 2020-09-17 | Parke | Indiana | 18121 | 96 | 2 |
541658 | 541658 | 2020-09-17 | Perry | Indiana | 18123 | 211 | 15 |
541659 | 541659 | 2020-09-17 | Pike | Indiana | 18125 | 133 | 1 |
541660 | 541660 | 2020-09-17 | Porter | Indiana | 18127 | 1989 | 45 |
541661 | 541661 | 2020-09-17 | Posey | Indiana | 18129 | 290 | 0 |
541662 | 541662 | 2020-09-17 | Pulaski | Indiana | 18131 | 114 | 1 |
541663 | 541663 | 2020-09-17 | Putnam | Indiana | 18133 | 514 | 8 |
541664 | 541664 | 2020-09-17 | Randolph | Indiana | 18135 | 239 | 7 |
541665 | 541665 | 2020-09-17 | Ripley | Indiana | 18137 | 276 | 8 |
541666 | 541666 | 2020-09-17 | Rush | Indiana | 18139 | 191 | 4 |
541667 | 541667 | 2020-09-17 | Scott | Indiana | 18143 | 350 | 12 |
541668 | 541668 | 2020-09-17 | Shelby | Indiana | 18145 | 1128 | 37 |
541669 | 541669 | 2020-09-17 | Spencer | Indiana | 18147 | 201 | 4 |
541670 | 541670 | 2020-09-17 | St. Joseph | Indiana | 18141 | 5885 | 102 |
541671 | 541671 | 2020-09-17 | Starke | Indiana | 18149 | 240 | 8 |
541672 | 541672 | 2020-09-17 | Steuben | Indiana | 18151 | 345 | 7 |
541673 | 541673 | 2020-09-17 | Sullivan | Indiana | 18153 | 330 | 12 |
541674 | 541674 | 2020-09-17 | Switzerland | Indiana | 18155 | 68 | 0 |
541675 | 541675 | 2020-09-17 | Tippecanoe | Indiana | 18157 | 2116 | 14 |
541676 | 541676 | 2020-09-17 | Tipton | Indiana | 18159 | 219 | 25 |
541677 | 541677 | 2020-09-17 | Union | Indiana | 18161 | 100 | 0 |
541678 | 541678 | 2020-09-17 | Vanderburgh | Indiana | 18163 | 3184 | 26 |
541679 | 541679 | 2020-09-17 | Vermillion | Indiana | 18165 | 122 | 0 |
541680 | 541680 | 2020-09-17 | Vigo | Indiana | 18167 | 1700 | 22 |
541681 | 541681 | 2020-09-17 | Wabash | Indiana | 18169 | 258 | 7 |
541682 | 541682 | 2020-09-17 | Warren | Indiana | 18171 | 39 | 1 |
541683 | 541683 | 2020-09-17 | Warrick | Indiana | 18173 | 1043 | 36 |
541684 | 541684 | 2020-09-17 | Washington | Indiana | 18175 | 249 | 1 |
541685 | 541685 | 2020-09-17 | Wayne | Indiana | 18177 | 1078 | 14 |
541686 | 541686 | 2020-09-17 | Wells | Indiana | 18179 | 259 | 2 |
541687 | 541687 | 2020-09-17 | White | Indiana | 18181 | 471 | 14 |
541688 | 541688 | 2020-09-17 | Whitley | Indiana | 18183 | 245 | 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);