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-01-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 |
---|---|---|---|---|---|---|---|
885440 | 885440 | 2021-01-01 | Adams | Indiana | 18001 | 2646 | 35 |
885441 | 885441 | 2021-01-01 | Allen | Indiana | 18003 | 28321 | 509 |
885442 | 885442 | 2021-01-01 | Bartholomew | Indiana | 18005 | 5541 | 93 |
885443 | 885443 | 2021-01-01 | Benton | Indiana | 18007 | 753 | 9 |
885444 | 885444 | 2021-01-01 | Blackford | Indiana | 18009 | 906 | 22 |
885445 | 885445 | 2021-01-01 | Boone | Indiana | 18011 | 4560 | 65 |
885446 | 885446 | 2021-01-01 | Brown | Indiana | 18013 | 752 | 9 |
885447 | 885447 | 2021-01-01 | Carroll | Indiana | 18015 | 1355 | 15 |
885448 | 885448 | 2021-01-01 | Cass | Indiana | 18017 | 4248 | 44 |
885449 | 885449 | 2021-01-01 | Clark | Indiana | 18019 | 8566 | 121 |
885450 | 885450 | 2021-01-01 | Clay | Indiana | 18021 | 1887 | 31 |
885451 | 885451 | 2021-01-01 | Clinton | Indiana | 18023 | 3244 | 39 |
885452 | 885452 | 2021-01-01 | Crawford | Indiana | 18025 | 604 | 8 |
885453 | 885453 | 2021-01-01 | Daviess | Indiana | 18027 | 2303 | 72 |
885454 | 885454 | 2021-01-01 | DeKalb | Indiana | 18033 | 3018 | 63 |
885455 | 885455 | 2021-01-01 | Dearborn | Indiana | 18029 | 3885 | 42 |
885456 | 885456 | 2021-01-01 | Decatur | Indiana | 18031 | 2181 | 78 |
885457 | 885457 | 2021-01-01 | Delaware | Indiana | 18035 | 7724 | 128 |
885458 | 885458 | 2021-01-01 | Dubois | Indiana | 18037 | 4705 | 53 |
885459 | 885459 | 2021-01-01 | Elkhart | Indiana | 18039 | 22888 | 328 |
885460 | 885460 | 2021-01-01 | Fayette | Indiana | 18041 | 2350 | 43 |
885461 | 885461 | 2021-01-01 | Floyd | Indiana | 18043 | 5207 | 104 |
885462 | 885462 | 2021-01-01 | Fountain | Indiana | 18045 | 1547 | 24 |
885463 | 885463 | 2021-01-01 | Franklin | Indiana | 18047 | 1261 | 30 |
885464 | 885464 | 2021-01-01 | Fulton | Indiana | 18049 | 1413 | 26 |
885465 | 885465 | 2021-01-01 | Gibson | Indiana | 18051 | 3062 | 56 |
885466 | 885466 | 2021-01-01 | Grant | Indiana | 18053 | 5462 | 105 |
885467 | 885467 | 2021-01-01 | Greene | Indiana | 18055 | 1974 | 59 |
885468 | 885468 | 2021-01-01 | Hamilton | Indiana | 18057 | 24289 | 295 |
885469 | 885469 | 2021-01-01 | Hancock | Indiana | 18059 | 5268 | 86 |
885470 | 885470 | 2021-01-01 | Harrison | Indiana | 18061 | 2696 | 37 |
885471 | 885471 | 2021-01-01 | Hendricks | Indiana | 18063 | 11709 | 235 |
885472 | 885472 | 2021-01-01 | Henry | Indiana | 18065 | 4310 | 55 |
885473 | 885473 | 2021-01-01 | Howard | Indiana | 18067 | 6733 | 124 |
885474 | 885474 | 2021-01-01 | Huntington | Indiana | 18069 | 2480 | 45 |
885475 | 885475 | 2021-01-01 | Jackson | Indiana | 18071 | 3792 | 44 |
885476 | 885476 | 2021-01-01 | Jasper | Indiana | 18073 | 2495 | 33 |
885477 | 885477 | 2021-01-01 | Jay | Indiana | 18075 | 1520 | 23 |
885478 | 885478 | 2021-01-01 | Jefferson | Indiana | 18077 | 2188 | 39 |
885479 | 885479 | 2021-01-01 | Jennings | Indiana | 18079 | 1712 | 34 |
885480 | 885480 | 2021-01-01 | Johnson | Indiana | 18081 | 12366 | 252 |
885481 | 885481 | 2021-01-01 | Knox | Indiana | 18083 | 2941 | 38 |
885482 | 885482 | 2021-01-01 | Kosciusko | Indiana | 18085 | 6903 | 73 |
885483 | 885483 | 2021-01-01 | LaGrange | Indiana | 18087 | 2063 | 57 |
885484 | 885484 | 2021-01-01 | LaPorte | Indiana | 18091 | 7658 | 140 |
885485 | 885485 | 2021-01-01 | Lake | Indiana | 18089 | 40299 | 636 |
885486 | 885486 | 2021-01-01 | Lawrence | Indiana | 18093 | 3340 | 65 |
885487 | 885487 | 2021-01-01 | Madison | Indiana | 18095 | 9097 | 195 |
885488 | 885488 | 2021-01-01 | Marion | Indiana | 18097 | 71677 | 1218 |
885489 | 885489 | 2021-01-01 | Marshall | Indiana | 18099 | 4521 | 77 |
885490 | 885490 | 2021-01-01 | Martin | Indiana | 18101 | 602 | 12 |
885491 | 885491 | 2021-01-01 | Miami | Indiana | 18103 | 2764 | 32 |
885492 | 885492 | 2021-01-01 | Monroe | Indiana | 18105 | 8080 | 99 |
885493 | 885493 | 2021-01-01 | Montgomery | Indiana | 18107 | 2891 | 50 |
885494 | 885494 | 2021-01-01 | Morgan | Indiana | 18109 | 4368 | 83 |
885495 | 885495 | 2021-01-01 | Newton | Indiana | 18111 | 833 | 20 |
885496 | 885496 | 2021-01-01 | Noble | Indiana | 18113 | 4084 | 57 |
885497 | 885497 | 2021-01-01 | Ohio | Indiana | 18115 | 400 | 7 |
885498 | 885498 | 2021-01-01 | Orange | Indiana | 18117 | 1248 | 34 |
885499 | 885499 | 2021-01-01 | Owen | Indiana | 18119 | 1346 | 33 |
885500 | 885500 | 2021-01-01 | Parke | Indiana | 18121 | 1189 | 8 |
885501 | 885501 | 2021-01-01 | Perry | Indiana | 18123 | 1223 | 24 |
885502 | 885502 | 2021-01-01 | Pike | Indiana | 18125 | 949 | 27 |
885503 | 885503 | 2021-01-01 | Porter | Indiana | 18127 | 12969 | 157 |
885504 | 885504 | 2021-01-01 | Posey | Indiana | 18129 | 1941 | 26 |
885505 | 885505 | 2021-01-01 | Pulaski | Indiana | 18131 | 859 | 33 |
885506 | 885506 | 2021-01-01 | Putnam | Indiana | 18133 | 2496 | 39 |
885507 | 885507 | 2021-01-01 | Randolph | Indiana | 18135 | 1901 | 36 |
885508 | 885508 | 2021-01-01 | Ripley | Indiana | 18137 | 2515 | 40 |
885509 | 885509 | 2021-01-01 | Rush | Indiana | 18139 | 1283 | 14 |
885510 | 885510 | 2021-01-01 | Scott | Indiana | 18143 | 1940 | 38 |
885511 | 885511 | 2021-01-01 | Shelby | Indiana | 18145 | 4250 | 82 |
885512 | 885512 | 2021-01-01 | Spencer | Indiana | 18147 | 1523 | 14 |
885513 | 885513 | 2021-01-01 | St. Joseph | Indiana | 18141 | 24478 | 367 |
885514 | 885514 | 2021-01-01 | Starke | Indiana | 18149 | 1564 | 43 |
885515 | 885515 | 2021-01-01 | Steuben | Indiana | 18151 | 2685 | 25 |
885516 | 885516 | 2021-01-01 | Sullivan | Indiana | 18153 | 1694 | 26 |
885517 | 885517 | 2021-01-01 | Switzerland | Indiana | 18155 | 509 | 5 |
885518 | 885518 | 2021-01-01 | Tippecanoe | Indiana | 18157 | 15179 | 91 |
885519 | 885519 | 2021-01-01 | Tipton | Indiana | 18159 | 1105 | 33 |
885520 | 885520 | 2021-01-01 | Union | Indiana | 18161 | 537 | 2 |
885521 | 885521 | 2021-01-01 | Vanderburgh | Indiana | 18163 | 15793 | 204 |
885522 | 885522 | 2021-01-01 | Vermillion | Indiana | 18165 | 1275 | 31 |
885523 | 885523 | 2021-01-01 | Vigo | Indiana | 18167 | 9402 | 163 |
885524 | 885524 | 2021-01-01 | Wabash | Indiana | 18169 | 2635 | 43 |
885525 | 885525 | 2021-01-01 | Warren | Indiana | 18171 | 547 | 8 |
885526 | 885526 | 2021-01-01 | Warrick | Indiana | 18173 | 5328 | 89 |
885527 | 885527 | 2021-01-01 | Washington | Indiana | 18175 | 1450 | 16 |
885528 | 885528 | 2021-01-01 | Wayne | Indiana | 18177 | 5684 | 148 |
885529 | 885529 | 2021-01-01 | Wells | Indiana | 18179 | 1960 | 48 |
885530 | 885530 | 2021-01-01 | White | Indiana | 18181 | 2351 | 32 |
885531 | 885531 | 2021-01-01 | Whitley | Indiana | 18183 | 2500 | 20 |
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);