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-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 |
---|---|---|---|---|---|---|---|
512475 | 512475 | 2020-09-08 | Adams | Indiana | 18001 | 200 | 4 |
512476 | 512476 | 2020-09-08 | Allen | Indiana | 18003 | 5400 | 195 |
512477 | 512477 | 2020-09-08 | Bartholomew | Indiana | 18005 | 1107 | 58 |
512478 | 512478 | 2020-09-08 | Benton | Indiana | 18007 | 84 | 0 |
512479 | 512479 | 2020-09-08 | Blackford | Indiana | 18009 | 94 | 2 |
512480 | 512480 | 2020-09-08 | Boone | Indiana | 18011 | 912 | 49 |
512481 | 512481 | 2020-09-08 | Brown | Indiana | 18013 | 91 | 2 |
512482 | 512482 | 2020-09-08 | Carroll | Indiana | 18015 | 260 | 13 |
512483 | 512483 | 2020-09-08 | Cass | Indiana | 18017 | 1900 | 10 |
512484 | 512484 | 2020-09-08 | Clark | Indiana | 18019 | 1907 | 60 |
512485 | 512485 | 2020-09-08 | Clay | Indiana | 18021 | 253 | 5 |
512486 | 512486 | 2020-09-08 | Clinton | Indiana | 18023 | 579 | 15 |
512487 | 512487 | 2020-09-08 | Crawford | Indiana | 18025 | 77 | 1 |
512488 | 512488 | 2020-09-08 | Daviess | Indiana | 18027 | 556 | 26 |
512489 | 512489 | 2020-09-08 | DeKalb | Indiana | 18033 | 379 | 8 |
512490 | 512490 | 2020-09-08 | Dearborn | Indiana | 18029 | 600 | 30 |
512491 | 512491 | 2020-09-08 | Decatur | Indiana | 18031 | 456 | 41 |
512492 | 512492 | 2020-09-08 | Delaware | Indiana | 18035 | 1599 | 59 |
512493 | 512493 | 2020-09-08 | Dubois | Indiana | 18037 | 877 | 17 |
512494 | 512494 | 2020-09-08 | Elkhart | Indiana | 18039 | 5929 | 105 |
512495 | 512495 | 2020-09-08 | Fayette | Indiana | 18041 | 476 | 10 |
512496 | 512496 | 2020-09-08 | Floyd | Indiana | 18043 | 1162 | 61 |
512497 | 512497 | 2020-09-08 | Fountain | Indiana | 18045 | 103 | 2 |
512498 | 512498 | 2020-09-08 | Franklin | Indiana | 18047 | 292 | 26 |
512499 | 512499 | 2020-09-08 | Fulton | Indiana | 18049 | 212 | 2 |
512500 | 512500 | 2020-09-08 | Gibson | Indiana | 18051 | 353 | 4 |
512501 | 512501 | 2020-09-08 | Grant | Indiana | 18053 | 1069 | 35 |
512502 | 512502 | 2020-09-08 | Greene | Indiana | 18055 | 387 | 38 |
512503 | 512503 | 2020-09-08 | Hamilton | Indiana | 18057 | 4272 | 116 |
512504 | 512504 | 2020-09-08 | Hancock | Indiana | 18059 | 864 | 45 |
512505 | 512505 | 2020-09-08 | Harrison | Indiana | 18061 | 516 | 26 |
512506 | 512506 | 2020-09-08 | Hendricks | Indiana | 18063 | 2500 | 135 |
512507 | 512507 | 2020-09-08 | Henry | Indiana | 18065 | 670 | 22 |
512508 | 512508 | 2020-09-08 | Howard | Indiana | 18067 | 1167 | 65 |
512509 | 512509 | 2020-09-08 | Huntington | Indiana | 18069 | 188 | 3 |
512510 | 512510 | 2020-09-08 | Jackson | Indiana | 18071 | 717 | 10 |
512511 | 512511 | 2020-09-08 | Jasper | Indiana | 18073 | 350 | 2 |
512512 | 512512 | 2020-09-08 | Jay | Indiana | 18075 | 149 | 0 |
512513 | 512513 | 2020-09-08 | Jefferson | Indiana | 18077 | 224 | 3 |
512514 | 512514 | 2020-09-08 | Jennings | Indiana | 18079 | 286 | 14 |
512515 | 512515 | 2020-09-08 | Johnson | Indiana | 18081 | 2134 | 131 |
512516 | 512516 | 2020-09-08 | Knox | Indiana | 18083 | 395 | 6 |
512517 | 512517 | 2020-09-08 | Kosciusko | Indiana | 18085 | 1118 | 19 |
512518 | 512518 | 2020-09-08 | LaGrange | Indiana | 18087 | 620 | 11 |
512519 | 512519 | 2020-09-08 | LaPorte | Indiana | 18091 | 1254 | 37 |
512520 | 512520 | 2020-09-08 | Lake | Indiana | 18089 | 9628 | 317 |
512521 | 512521 | 2020-09-08 | Lawrence | Indiana | 18093 | 483 | 29 |
512522 | 512522 | 2020-09-08 | Madison | Indiana | 18095 | 1434 | 85 |
512523 | 512523 | 2020-09-08 | Marion | Indiana | 18097 | 19474 | 801 |
512524 | 512524 | 2020-09-08 | Marshall | Indiana | 18099 | 934 | 23 |
512525 | 512525 | 2020-09-08 | Martin | Indiana | 18101 | 130 | 0 |
512526 | 512526 | 2020-09-08 | Miami | Indiana | 18103 | 359 | 2 |
512527 | 512527 | 2020-09-08 | Monroe | Indiana | 18105 | 1526 | 40 |
512528 | 512528 | 2020-09-08 | Montgomery | Indiana | 18107 | 471 | 22 |
512529 | 512529 | 2020-09-08 | Morgan | Indiana | 18109 | 638 | 38 |
512530 | 512530 | 2020-09-08 | Newton | Indiana | 18111 | 152 | 11 |
512531 | 512531 | 2020-09-08 | Noble | Indiana | 18113 | 845 | 32 |
512532 | 512532 | 2020-09-08 | Ohio | Indiana | 18115 | 74 | 7 |
512533 | 512533 | 2020-09-08 | Orange | Indiana | 18117 | 262 | 26 |
512534 | 512534 | 2020-09-08 | Owen | Indiana | 18119 | 157 | 2 |
512535 | 512535 | 2020-09-08 | Parke | Indiana | 18121 | 88 | 2 |
512536 | 512536 | 2020-09-08 | Perry | Indiana | 18123 | 209 | 15 |
512537 | 512537 | 2020-09-08 | Pike | Indiana | 18125 | 113 | 1 |
512538 | 512538 | 2020-09-08 | Porter | Indiana | 18127 | 1867 | 45 |
512539 | 512539 | 2020-09-08 | Posey | Indiana | 18129 | 236 | 0 |
512540 | 512540 | 2020-09-08 | Pulaski | Indiana | 18131 | 106 | 1 |
512541 | 512541 | 2020-09-08 | Putnam | Indiana | 18133 | 466 | 8 |
512542 | 512542 | 2020-09-08 | Randolph | Indiana | 18135 | 227 | 7 |
512543 | 512543 | 2020-09-08 | Ripley | Indiana | 18137 | 253 | 8 |
512544 | 512544 | 2020-09-08 | Rush | Indiana | 18139 | 182 | 4 |
512545 | 512545 | 2020-09-08 | Scott | Indiana | 18143 | 332 | 12 |
512546 | 512546 | 2020-09-08 | Shelby | Indiana | 18145 | 1102 | 36 |
512547 | 512547 | 2020-09-08 | Spencer | Indiana | 18147 | 179 | 3 |
512548 | 512548 | 2020-09-08 | St. Joseph | Indiana | 18141 | 5488 | 101 |
512549 | 512549 | 2020-09-08 | Starke | Indiana | 18149 | 221 | 8 |
512550 | 512550 | 2020-09-08 | Steuben | Indiana | 18151 | 319 | 6 |
512551 | 512551 | 2020-09-08 | Sullivan | Indiana | 18153 | 312 | 11 |
512552 | 512552 | 2020-09-08 | Switzerland | Indiana | 18155 | 67 | 0 |
512553 | 512553 | 2020-09-08 | Tippecanoe | Indiana | 18157 | 1764 | 14 |
512554 | 512554 | 2020-09-08 | Tipton | Indiana | 18159 | 205 | 25 |
512555 | 512555 | 2020-09-08 | Union | Indiana | 18161 | 92 | 0 |
512556 | 512556 | 2020-09-08 | Vanderburgh | Indiana | 18163 | 2809 | 23 |
512557 | 512557 | 2020-09-08 | Vermillion | Indiana | 18165 | 112 | 0 |
512558 | 512558 | 2020-09-08 | Vigo | Indiana | 18167 | 1543 | 18 |
512559 | 512559 | 2020-09-08 | Wabash | Indiana | 18169 | 235 | 7 |
512560 | 512560 | 2020-09-08 | Warren | Indiana | 18171 | 39 | 1 |
512561 | 512561 | 2020-09-08 | Warrick | Indiana | 18173 | 876 | 33 |
512562 | 512562 | 2020-09-08 | Washington | Indiana | 18175 | 240 | 1 |
512563 | 512563 | 2020-09-08 | Wayne | Indiana | 18177 | 995 | 11 |
512564 | 512564 | 2020-09-08 | Wells | Indiana | 18179 | 239 | 2 |
512565 | 512565 | 2020-09-08 | White | Indiana | 18181 | 463 | 13 |
512566 | 512566 | 2020-09-08 | Whitley | Indiana | 18183 | 233 | 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);