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-05-27 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1359413 | 1359413 | 2021-05-27 | Adams | Indiana | 18001 | 3503 | 56 |
1359414 | 1359414 | 2021-05-27 | Allen | Indiana | 18003 | 41376 | 706 |
1359415 | 1359415 | 2021-05-27 | Bartholomew | Indiana | 18005 | 8144 | 161 |
1359416 | 1359416 | 2021-05-27 | Benton | Indiana | 18007 | 993 | 14 |
1359417 | 1359417 | 2021-05-27 | Blackford | Indiana | 18009 | 1365 | 32 |
1359418 | 1359418 | 2021-05-27 | Boone | Indiana | 18011 | 6842 | 106 |
1359419 | 1359419 | 2021-05-27 | Brown | Indiana | 18013 | 1031 | 41 |
1359420 | 1359420 | 2021-05-27 | Carroll | Indiana | 18015 | 1921 | 22 |
1359421 | 1359421 | 2021-05-27 | Cass | Indiana | 18017 | 5951 | 109 |
1359422 | 1359422 | 2021-05-27 | Clark | Indiana | 18019 | 13119 | 201 |
1359423 | 1359423 | 2021-05-27 | Clay | Indiana | 18021 | 2625 | 47 |
1359424 | 1359424 | 2021-05-27 | Clinton | Indiana | 18023 | 4328 | 58 |
1359425 | 1359425 | 2021-05-27 | Crawford | Indiana | 18025 | 1017 | 17 |
1359426 | 1359426 | 2021-05-27 | Daviess | Indiana | 18027 | 3003 | 101 |
1359427 | 1359427 | 2021-05-27 | DeKalb | Indiana | 18033 | 4359 | 88 |
1359428 | 1359428 | 2021-05-27 | Dearborn | Indiana | 18029 | 5870 | 81 |
1359429 | 1359429 | 2021-05-27 | Decatur | Indiana | 18031 | 2937 | 96 |
1359430 | 1359430 | 2021-05-27 | Delaware | Indiana | 18035 | 10882 | 196 |
1359431 | 1359431 | 2021-05-27 | Dubois | Indiana | 18037 | 6187 | 118 |
1359432 | 1359432 | 2021-05-27 | Elkhart | Indiana | 18039 | 29229 | 464 |
1359433 | 1359433 | 2021-05-27 | Fayette | Indiana | 18041 | 2974 | 65 |
1359434 | 1359434 | 2021-05-27 | Floyd | Indiana | 18043 | 7723 | 184 |
1359435 | 1359435 | 2021-05-27 | Fountain | Indiana | 18045 | 2160 | 47 |
1359436 | 1359436 | 2021-05-27 | Franklin | Indiana | 18047 | 1712 | 36 |
1359437 | 1359437 | 2021-05-27 | Fulton | Indiana | 18049 | 1979 | 41 |
1359438 | 1359438 | 2021-05-27 | Gibson | Indiana | 18051 | 4420 | 95 |
1359439 | 1359439 | 2021-05-27 | Grant | Indiana | 18053 | 7576 | 182 |
1359440 | 1359440 | 2021-05-27 | Greene | Indiana | 18055 | 2844 | 89 |
1359441 | 1359441 | 2021-05-27 | Hamilton | Indiana | 18057 | 36148 | 428 |
1359442 | 1359442 | 2021-05-27 | Hancock | Indiana | 18059 | 8470 | 146 |
1359443 | 1359443 | 2021-05-27 | Harrison | Indiana | 18061 | 4386 | 75 |
1359444 | 1359444 | 2021-05-27 | Hendricks | Indiana | 18063 | 17520 | 337 |
1359445 | 1359445 | 2021-05-27 | Henry | Indiana | 18065 | 5859 | 108 |
1359446 | 1359446 | 2021-05-27 | Howard | Indiana | 18067 | 10152 | 226 |
1359447 | 1359447 | 2021-05-27 | Huntington | Indiana | 18069 | 3993 | 82 |
1359448 | 1359448 | 2021-05-27 | Jackson | Indiana | 18071 | 5065 | 75 |
1359449 | 1359449 | 2021-05-27 | Jasper | Indiana | 18073 | 3799 | 54 |
1359450 | 1359450 | 2021-05-27 | Jay | Indiana | 18075 | 2003 | 33 |
1359451 | 1359451 | 2021-05-27 | Jefferson | Indiana | 18077 | 3330 | 83 |
1359452 | 1359452 | 2021-05-27 | Jennings | Indiana | 18079 | 2332 | 51 |
1359453 | 1359453 | 2021-05-27 | Johnson | Indiana | 18081 | 18260 | 398 |
1359454 | 1359454 | 2021-05-27 | Knox | Indiana | 18083 | 3747 | 90 |
1359455 | 1359455 | 2021-05-27 | Kosciusko | Indiana | 18085 | 9574 | 121 |
1359456 | 1359456 | 2021-05-27 | LaGrange | Indiana | 18087 | 2714 | 73 |
1359457 | 1359457 | 2021-05-27 | LaPorte | Indiana | 18091 | 12267 | 221 |
1359458 | 1359458 | 2021-05-27 | Lake | Indiana | 18089 | 54945 | 1034 |
1359459 | 1359459 | 2021-05-27 | Lawrence | Indiana | 18093 | 4664 | 124 |
1359460 | 1359460 | 2021-05-27 | Madison | Indiana | 18095 | 12901 | 360 |
1359461 | 1359461 | 2021-05-27 | Marion | Indiana | 18097 | 101891 | 1825 |
1359462 | 1359462 | 2021-05-27 | Marshall | Indiana | 18099 | 6180 | 116 |
1359463 | 1359463 | 2021-05-27 | Martin | Indiana | 18101 | 908 | 15 |
1359464 | 1359464 | 2021-05-27 | Miami | Indiana | 18103 | 3884 | 69 |
1359465 | 1359465 | 2021-05-27 | Monroe | Indiana | 18105 | 12045 | 174 |
1359466 | 1359466 | 2021-05-27 | Montgomery | Indiana | 18107 | 4284 | 91 |
1359467 | 1359467 | 2021-05-27 | Morgan | Indiana | 18109 | 6682 | 145 |
1359468 | 1359468 | 2021-05-27 | Newton | Indiana | 18111 | 1110 | 37 |
1359469 | 1359469 | 2021-05-27 | Noble | Indiana | 18113 | 5736 | 88 |
1359470 | 1359470 | 2021-05-27 | Ohio | Indiana | 18115 | 577 | 11 |
1359471 | 1359471 | 2021-05-27 | Orange | Indiana | 18117 | 1876 | 57 |
1359472 | 1359472 | 2021-05-27 | Owen | Indiana | 18119 | 2076 | 58 |
1359473 | 1359473 | 2021-05-27 | Parke | Indiana | 18121 | 1489 | 16 |
1359474 | 1359474 | 2021-05-27 | Perry | Indiana | 18123 | 1868 | 38 |
1359475 | 1359475 | 2021-05-27 | Pike | Indiana | 18125 | 1364 | 34 |
1359476 | 1359476 | 2021-05-27 | Porter | Indiana | 18127 | 19178 | 331 |
1359477 | 1359477 | 2021-05-27 | Posey | Indiana | 18129 | 2726 | 34 |
1359478 | 1359478 | 2021-05-27 | Pulaski | Indiana | 18131 | 1184 | 46 |
1359479 | 1359479 | 2021-05-27 | Putnam | Indiana | 18133 | 3685 | 60 |
1359480 | 1359480 | 2021-05-27 | Randolph | Indiana | 18135 | 2476 | 83 |
1359481 | 1359481 | 2021-05-27 | Ripley | Indiana | 18137 | 3436 | 70 |
1359482 | 1359482 | 2021-05-27 | Rush | Indiana | 18139 | 1816 | 25 |
1359483 | 1359483 | 2021-05-27 | Scott | Indiana | 18143 | 2690 | 57 |
1359484 | 1359484 | 2021-05-27 | Shelby | Indiana | 18145 | 5967 | 106 |
1359485 | 1359485 | 2021-05-27 | Spencer | Indiana | 18147 | 2336 | 31 |
1359486 | 1359486 | 2021-05-27 | St. Joseph | Indiana | 18141 | 36716 | 575 |
1359487 | 1359487 | 2021-05-27 | Starke | Indiana | 18149 | 2249 | 57 |
1359488 | 1359488 | 2021-05-27 | Steuben | Indiana | 18151 | 3951 | 59 |
1359489 | 1359489 | 2021-05-27 | Sullivan | Indiana | 18153 | 2130 | 42 |
1359490 | 1359490 | 2021-05-27 | Switzerland | Indiana | 18155 | 802 | 8 |
1359491 | 1359491 | 2021-05-27 | Tippecanoe | Indiana | 18157 | 22655 | 224 |
1359492 | 1359492 | 2021-05-27 | Tipton | Indiana | 18159 | 1650 | 47 |
1359493 | 1359493 | 2021-05-27 | Union | Indiana | 18161 | 753 | 11 |
1359494 | 1359494 | 2021-05-27 | Vanderburgh | Indiana | 18163 | 22467 | 403 |
1359495 | 1359495 | 2021-05-27 | Vermillion | Indiana | 18165 | 1715 | 44 |
1359496 | 1359496 | 2021-05-27 | Vigo | Indiana | 18167 | 12550 | 256 |
1359497 | 1359497 | 2021-05-27 | Wabash | Indiana | 18169 | 3587 | 81 |
1359498 | 1359498 | 2021-05-27 | Warren | Indiana | 18171 | 831 | 16 |
1359499 | 1359499 | 2021-05-27 | Warrick | Indiana | 18173 | 7826 | 158 |
1359500 | 1359500 | 2021-05-27 | Washington | Indiana | 18175 | 2432 | 33 |
1359501 | 1359501 | 2021-05-27 | Wayne | Indiana | 18177 | 7498 | 203 |
1359502 | 1359502 | 2021-05-27 | Wells | Indiana | 18179 | 2962 | 83 |
1359503 | 1359503 | 2021-05-27 | White | Indiana | 18181 | 3227 | 54 |
1359504 | 1359504 | 2021-05-27 | Whitley | Indiana | 18183 | 4024 | 40 |
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);