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-02-15 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1031489 | 1031489 | 2021-02-15 | Adams | Indiana | 18001 | 3175 | 50 |
1031490 | 1031490 | 2021-02-15 | Allen | Indiana | 18003 | 35106 | 647 |
1031491 | 1031491 | 2021-02-15 | Bartholomew | Indiana | 18005 | 7229 | 150 |
1031492 | 1031492 | 2021-02-15 | Benton | Indiana | 18007 | 907 | 12 |
1031493 | 1031493 | 2021-02-15 | Blackford | Indiana | 18009 | 1206 | 27 |
1031494 | 1031494 | 2021-02-15 | Boone | Indiana | 18011 | 5989 | 92 |
1031495 | 1031495 | 2021-02-15 | Brown | Indiana | 18013 | 935 | 39 |
1031496 | 1031496 | 2021-02-15 | Carroll | Indiana | 18015 | 1739 | 20 |
1031497 | 1031497 | 2021-02-15 | Cass | Indiana | 18017 | 5239 | 96 |
1031498 | 1031498 | 2021-02-15 | Clark | Indiana | 18019 | 11699 | 184 |
1031499 | 1031499 | 2021-02-15 | Clay | Indiana | 18021 | 2364 | 42 |
1031500 | 1031500 | 2021-02-15 | Clinton | Indiana | 18023 | 3895 | 57 |
1031501 | 1031501 | 2021-02-15 | Crawford | Indiana | 18025 | 894 | 14 |
1031502 | 1031502 | 2021-02-15 | Daviess | Indiana | 18027 | 2832 | 94 |
1031503 | 1031503 | 2021-02-15 | DeKalb | Indiana | 18033 | 3768 | 81 |
1031504 | 1031504 | 2021-02-15 | Dearborn | Indiana | 18029 | 5310 | 65 |
1031505 | 1031505 | 2021-02-15 | Decatur | Indiana | 18031 | 2731 | 92 |
1031506 | 1031506 | 2021-02-15 | Delaware | Indiana | 18035 | 9730 | 180 |
1031507 | 1031507 | 2021-02-15 | Dubois | Indiana | 18037 | 5835 | 107 |
1031508 | 1031508 | 2021-02-15 | Elkhart | Indiana | 18039 | 25183 | 422 |
1031509 | 1031509 | 2021-02-15 | Fayette | Indiana | 18041 | 2809 | 55 |
1031510 | 1031510 | 2021-02-15 | Floyd | Indiana | 18043 | 7057 | 165 |
1031511 | 1031511 | 2021-02-15 | Fountain | Indiana | 18045 | 1977 | 40 |
1031512 | 1031512 | 2021-02-15 | Franklin | Indiana | 18047 | 1593 | 36 |
1031513 | 1031513 | 2021-02-15 | Fulton | Indiana | 18049 | 1753 | 38 |
1031514 | 1031514 | 2021-02-15 | Gibson | Indiana | 18051 | 3982 | 84 |
1031515 | 1031515 | 2021-02-15 | Grant | Indiana | 18053 | 6767 | 161 |
1031516 | 1031516 | 2021-02-15 | Greene | Indiana | 18055 | 2583 | 82 |
1031517 | 1031517 | 2021-02-15 | Hamilton | Indiana | 18057 | 31401 | 389 |
1031518 | 1031518 | 2021-02-15 | Hancock | Indiana | 18059 | 7341 | 131 |
1031519 | 1031519 | 2021-02-15 | Harrison | Indiana | 18061 | 3891 | 62 |
1031520 | 1031520 | 2021-02-15 | Hendricks | Indiana | 18063 | 15592 | 308 |
1031521 | 1031521 | 2021-02-15 | Henry | Indiana | 18065 | 5370 | 89 |
1031522 | 1031522 | 2021-02-15 | Howard | Indiana | 18067 | 8969 | 187 |
1031523 | 1031523 | 2021-02-15 | Huntington | Indiana | 18069 | 3329 | 78 |
1031524 | 1031524 | 2021-02-15 | Jackson | Indiana | 18071 | 4589 | 61 |
1031525 | 1031525 | 2021-02-15 | Jasper | Indiana | 18073 | 3101 | 43 |
1031526 | 1031526 | 2021-02-15 | Jay | Indiana | 18075 | 1775 | 30 |
1031527 | 1031527 | 2021-02-15 | Jefferson | Indiana | 18077 | 2891 | 69 |
1031528 | 1031528 | 2021-02-15 | Jennings | Indiana | 18079 | 2119 | 45 |
1031529 | 1031529 | 2021-02-15 | Johnson | Indiana | 18081 | 16164 | 356 |
1031530 | 1031530 | 2021-02-15 | Knox | Indiana | 18083 | 3538 | 82 |
1031531 | 1031531 | 2021-02-15 | Kosciusko | Indiana | 18085 | 8455 | 109 |
1031532 | 1031532 | 2021-02-15 | LaGrange | Indiana | 18087 | 2394 | 71 |
1031533 | 1031533 | 2021-02-15 | LaPorte | Indiana | 18091 | 9601 | 196 |
1031534 | 1031534 | 2021-02-15 | Lake | Indiana | 18089 | 47754 | 880 |
1031535 | 1031535 | 2021-02-15 | Lawrence | Indiana | 18093 | 4124 | 114 |
1031536 | 1031536 | 2021-02-15 | Madison | Indiana | 18095 | 11624 | 325 |
1031537 | 1031537 | 2021-02-15 | Marion | Indiana | 18097 | 89506 | 1676 |
1031538 | 1031538 | 2021-02-15 | Marshall | Indiana | 18099 | 5354 | 104 |
1031539 | 1031539 | 2021-02-15 | Martin | Indiana | 18101 | 798 | 15 |
1031540 | 1031540 | 2021-02-15 | Miami | Indiana | 18103 | 3507 | 61 |
1031541 | 1031541 | 2021-02-15 | Monroe | Indiana | 18105 | 10122 | 160 |
1031542 | 1031542 | 2021-02-15 | Montgomery | Indiana | 18107 | 3756 | 83 |
1031543 | 1031543 | 2021-02-15 | Morgan | Indiana | 18109 | 5960 | 129 |
1031544 | 1031544 | 2021-02-15 | Newton | Indiana | 18111 | 966 | 33 |
1031545 | 1031545 | 2021-02-15 | Noble | Indiana | 18113 | 5008 | 78 |
1031546 | 1031546 | 2021-02-15 | Ohio | Indiana | 18115 | 518 | 11 |
1031547 | 1031547 | 2021-02-15 | Orange | Indiana | 18117 | 1706 | 53 |
1031548 | 1031548 | 2021-02-15 | Owen | Indiana | 18119 | 1813 | 54 |
1031549 | 1031549 | 2021-02-15 | Parke | Indiana | 18121 | 1385 | 15 |
1031550 | 1031550 | 2021-02-15 | Perry | Indiana | 18123 | 1714 | 36 |
1031551 | 1031551 | 2021-02-15 | Pike | Indiana | 18125 | 1264 | 32 |
1031552 | 1031552 | 2021-02-15 | Porter | Indiana | 18127 | 15683 | 273 |
1031553 | 1031553 | 2021-02-15 | Posey | Indiana | 18129 | 2564 | 31 |
1031554 | 1031554 | 2021-02-15 | Pulaski | Indiana | 18131 | 1043 | 41 |
1031555 | 1031555 | 2021-02-15 | Putnam | Indiana | 18133 | 3221 | 58 |
1031556 | 1031556 | 2021-02-15 | Randolph | Indiana | 18135 | 2281 | 72 |
1031557 | 1031557 | 2021-02-15 | Ripley | Indiana | 18137 | 3217 | 58 |
1031558 | 1031558 | 2021-02-15 | Rush | Indiana | 18139 | 1684 | 22 |
1031559 | 1031559 | 2021-02-15 | Scott | Indiana | 18143 | 2439 | 47 |
1031560 | 1031560 | 2021-02-15 | Shelby | Indiana | 18145 | 5455 | 98 |
1031561 | 1031561 | 2021-02-15 | Spencer | Indiana | 18147 | 2131 | 28 |
1031562 | 1031562 | 2021-02-15 | St. Joseph | Indiana | 18141 | 28988 | 517 |
1031563 | 1031563 | 2021-02-15 | Starke | Indiana | 18149 | 1847 | 53 |
1031564 | 1031564 | 2021-02-15 | Steuben | Indiana | 18151 | 3320 | 57 |
1031565 | 1031565 | 2021-02-15 | Sullivan | Indiana | 18153 | 2013 | 38 |
1031566 | 1031566 | 2021-02-15 | Switzerland | Indiana | 18155 | 745 | 7 |
1031567 | 1031567 | 2021-02-15 | Tippecanoe | Indiana | 18157 | 19418 | 193 |
1031568 | 1031568 | 2021-02-15 | Tipton | Indiana | 18159 | 1448 | 43 |
1031569 | 1031569 | 2021-02-15 | Union | Indiana | 18161 | 687 | 10 |
1031570 | 1031570 | 2021-02-15 | Vanderburgh | Indiana | 18163 | 20916 | 375 |
1031571 | 1031571 | 2021-02-15 | Vermillion | Indiana | 18165 | 1571 | 40 |
1031572 | 1031572 | 2021-02-15 | Vigo | Indiana | 18167 | 11411 | 231 |
1031573 | 1031573 | 2021-02-15 | Wabash | Indiana | 18169 | 3256 | 73 |
1031574 | 1031574 | 2021-02-15 | Warren | Indiana | 18171 | 735 | 13 |
1031575 | 1031575 | 2021-02-15 | Warrick | Indiana | 18173 | 7284 | 143 |
1031576 | 1031576 | 2021-02-15 | Washington | Indiana | 18175 | 2034 | 25 |
1031577 | 1031577 | 2021-02-15 | Wayne | Indiana | 18177 | 6923 | 187 |
1031578 | 1031578 | 2021-02-15 | Wells | Indiana | 18179 | 2518 | 75 |
1031579 | 1031579 | 2021-02-15 | White | Indiana | 18181 | 2917 | 51 |
1031580 | 1031580 | 2021-02-15 | Whitley | Indiana | 18183 | 3401 | 35 |
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);