ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71,921 rows where state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 18097 796
- 18063 794
- 18113 793
- 18001 791
- 18011 791
- 18067 791
- 18081 791
- 18141 791
- 18091 788
- 18179 788
- 18057 787
- 18043 786
- 18005 785
- 18047 785
- 18089 785
- 18079 784
- 18095 784
- 18019 783
- 18041 783
- 18119 783
- 18157 783
- 18177 783
- 18053 782
- 18145 782
- 18163 782
- 18167 782
- 18003 781
- 18059 781
- 18061 781
- 18103 781
- …
county >30
- Marion 796
- Hendricks 794
- Noble 793
- Adams 791
- Boone 791
- Howard 791
- Johnson 791
- St. Joseph 791
- LaPorte 788
- Wells 788
- Hamilton 787
- Floyd 786
- Bartholomew 785
- Franklin 785
- Lake 785
- Jennings 784
- Madison 784
- Clark 783
- Fayette 783
- Owen 783
- Tippecanoe 783
- Wayne 783
- Grant 782
- Shelby 782
- Vanderburgh 782
- Vigo 782
- Allen 781
- Hancock 781
- Harrison 781
- Miami 781
- …
state 1
- Indiana · 71,621 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490527 | 2490527 | 2022-05-10 | Floyd | Indiana | 18043 | 19137 | 302 |
2490528 | 2490528 | 2022-05-10 | Fountain | Indiana | 18045 | 5466 | 103 |
2490529 | 2490529 | 2022-05-10 | Franklin | Indiana | 18047 | 4378 | 65 |
2490530 | 2490530 | 2022-05-10 | Fulton | Indiana | 18049 | 4933 | 103 |
2490531 | 2490531 | 2022-05-10 | Gibson | Indiana | 18051 | 11720 | 145 |
2490532 | 2490532 | 2022-05-10 | Grant | Indiana | 18053 | 17366 | 352 |
2490533 | 2490533 | 2022-05-10 | Greene | Indiana | 18055 | 7245 | 139 |
2490534 | 2490534 | 2022-05-10 | Hamilton | Indiana | 18057 | 83088 | 661 |
2490535 | 2490535 | 2022-05-10 | Hancock | Indiana | 18059 | 20831 | 258 |
2490536 | 2490536 | 2022-05-10 | Harrison | Indiana | 18061 | 10865 | 138 |
2490537 | 2490537 | 2022-05-10 | Hendricks | Indiana | 18063 | 40964 | 554 |
2490538 | 2490538 | 2022-05-10 | Henry | Indiana | 18065 | 13037 | 231 |
2490539 | 2490539 | 2022-05-10 | Howard | Indiana | 18067 | 25523 | 449 |
2490540 | 2490540 | 2022-05-10 | Huntington | Indiana | 18069 | 11554 | 157 |
2490541 | 2490541 | 2022-05-10 | Jackson | Indiana | 18071 | 12560 | 130 |
2490542 | 2490542 | 2022-05-10 | Jasper | Indiana | 18073 | 9126 | 149 |
2490543 | 2490543 | 2022-05-10 | Jay | Indiana | 18075 | 4860 | 78 |
2490544 | 2490544 | 2022-05-10 | Jefferson | Indiana | 18077 | 9368 | 159 |
2490545 | 2490545 | 2022-05-10 | Jennings | Indiana | 18079 | 6987 | 108 |
2490546 | 2490546 | 2022-05-10 | Johnson | Indiana | 18081 | 42702 | 615 |
2490547 | 2490547 | 2022-05-10 | Knox | Indiana | 18083 | 10785 | 153 |
2490548 | 2490548 | 2022-05-10 | Kosciusko | Indiana | 18085 | 19829 | 237 |
2490549 | 2490549 | 2022-05-10 | LaGrange | Indiana | 18087 | 5869 | 102 |
2490550 | 2490550 | 2022-05-10 | LaPorte | Indiana | 18091 | 25800 | 367 |
2490551 | 2490551 | 2022-05-10 | Lake | Indiana | 18089 | 108094 | 1830 |
2490552 | 2490552 | 2022-05-10 | Lawrence | Indiana | 18093 | 11993 | 261 |
2490553 | 2490553 | 2022-05-10 | Madison | Indiana | 18095 | 32835 | 653 |
2490554 | 2490554 | 2022-05-10 | Marion | Indiana | 18097 | 227007 | 3000 |
2490555 | 2490555 | 2022-05-10 | Marshall | Indiana | 18099 | 12415 | 197 |
2490556 | 2490556 | 2022-05-10 | Martin | Indiana | 18101 | 2173 | 25 |
2490557 | 2490557 | 2022-05-10 | Miami | Indiana | 18103 | 9285 | 159 |
2490558 | 2490558 | 2022-05-10 | Monroe | Indiana | 18105 | 28636 | 280 |
2490559 | 2490559 | 2022-05-10 | Montgomery | Indiana | 18107 | 10726 | 164 |
2490560 | 2490560 | 2022-05-10 | Morgan | Indiana | 18109 | 16553 | 287 |
2490561 | 2490561 | 2022-05-10 | Newton | Indiana | 18111 | 2587 | 68 |
2490562 | 2490562 | 2022-05-10 | Noble | Indiana | 18113 | 13118 | 157 |
2490563 | 2490563 | 2022-05-10 | Ohio | Indiana | 18115 | 1455 | 19 |
2490564 | 2490564 | 2022-05-10 | Orange | Indiana | 18117 | 5048 | 96 |
2490565 | 2490565 | 2022-05-10 | Owen | Indiana | 18119 | 5897 | 121 |
2490566 | 2490566 | 2022-05-10 | Parke | Indiana | 18121 | 3603 | 46 |
2490567 | 2490567 | 2022-05-10 | Perry | Indiana | 18123 | 4666 | 69 |
2490568 | 2490568 | 2022-05-10 | Pike | Indiana | 18125 | 3747 | 49 |
2490569 | 2490569 | 2022-05-10 | Porter | Indiana | 18127 | 38400 | 564 |
2490570 | 2490570 | 2022-05-10 | Posey | Indiana | 18129 | 6565 | 58 |
2490571 | 2490571 | 2022-05-10 | Pulaski | Indiana | 18131 | 3083 | 86 |
2490572 | 2490572 | 2022-05-10 | Putnam | Indiana | 18133 | 9397 | 129 |
2490573 | 2490573 | 2022-05-10 | Randolph | Indiana | 18135 | 5911 | 148 |
2490574 | 2490574 | 2022-05-10 | Ripley | Indiana | 18137 | 8341 | 138 |
2490575 | 2490575 | 2022-05-10 | Rush | Indiana | 18139 | 4854 | 58 |
2490576 | 2490576 | 2022-05-10 | Scott | Indiana | 18143 | 7914 | 106 |
2490577 | 2490577 | 2022-05-10 | Shelby | Indiana | 18145 | 13635 | 182 |
2490578 | 2490578 | 2022-05-10 | Spencer | Indiana | 18147 | 5246 | 61 |
2490579 | 2490579 | 2022-05-10 | St. Joseph | Indiana | 18141 | 71550 | 874 |
2490580 | 2490580 | 2022-05-10 | Starke | Indiana | 18149 | 4773 | 99 |
2490581 | 2490581 | 2022-05-10 | Steuben | Indiana | 18151 | 9667 | 121 |
2490582 | 2490582 | 2022-05-10 | Sullivan | Indiana | 18153 | 5291 | 76 |
2490583 | 2490583 | 2022-05-10 | Switzerland | Indiana | 18155 | 2319 | 20 |
2490584 | 2490584 | 2022-05-10 | Tippecanoe | Indiana | 18157 | 51554 | 396 |
2490585 | 2490585 | 2022-05-10 | Tipton | Indiana | 18159 | 3539 | 87 |
2490586 | 2490586 | 2022-05-10 | Union | Indiana | 18161 | 2023 | 21 |
2490587 | 2490587 | 2022-05-10 | Unknown | Indiana | 0 | 26 | |
2490588 | 2490588 | 2022-05-10 | Vanderburgh | Indiana | 18163 | 57701 | 639 |
2490589 | 2490589 | 2022-05-10 | Vermillion | Indiana | 18165 | 4101 | 75 |
2490590 | 2490590 | 2022-05-10 | Vigo | Indiana | 18167 | 28988 | 413 |
2490591 | 2490591 | 2022-05-10 | Wabash | Indiana | 18169 | 8745 | 156 |
2490592 | 2490592 | 2022-05-10 | Warren | Indiana | 18171 | 2107 | 30 |
2490593 | 2490593 | 2022-05-10 | Warrick | Indiana | 18173 | 20368 | 239 |
2490594 | 2490594 | 2022-05-10 | Washington | Indiana | 18175 | 6006 | 85 |
2490595 | 2490595 | 2022-05-10 | Wayne | Indiana | 18177 | 18877 | 337 |
2490596 | 2490596 | 2022-05-10 | Wells | Indiana | 18179 | 6508 | 132 |
2490597 | 2490597 | 2022-05-10 | White | Indiana | 18181 | 6926 | 96 |
2490598 | 2490598 | 2022-05-10 | Whitley | Indiana | 18183 | 9720 | 84 |
2487249 | 2487249 | 2022-05-09 | Adams | Indiana | 18001 | 7281 | 112 |
2487250 | 2487250 | 2022-05-09 | Allen | Indiana | 18003 | 104497 | 1187 |
2487251 | 2487251 | 2022-05-09 | Bartholomew | Indiana | 18005 | 21510 | 249 |
2487252 | 2487252 | 2022-05-09 | Benton | Indiana | 18007 | 2498 | 21 |
2487253 | 2487253 | 2022-05-09 | Blackford | Indiana | 18009 | 3118 | 69 |
2487254 | 2487254 | 2022-05-09 | Boone | Indiana | 18011 | 15404 | 185 |
2487255 | 2487255 | 2022-05-09 | Brown | Indiana | 18013 | 2603 | 62 |
2487256 | 2487256 | 2022-05-09 | Carroll | Indiana | 18015 | 4261 | 68 |
2487257 | 2487257 | 2022-05-09 | Cass | Indiana | 18017 | 11699 | 164 |
2487258 | 2487258 | 2022-05-09 | Clark | Indiana | 18019 | 31461 | 396 |
2487259 | 2487259 | 2022-05-09 | Clay | Indiana | 18021 | 6849 | 88 |
2487260 | 2487260 | 2022-05-09 | Clinton | Indiana | 18023 | 9245 | 127 |
2487261 | 2487261 | 2022-05-09 | Crawford | Indiana | 18025 | 2559 | 40 |
2487262 | 2487262 | 2022-05-09 | Daviess | Indiana | 18027 | 7495 | 154 |
2487263 | 2487263 | 2022-05-09 | DeKalb | Indiana | 18033 | 11393 | 152 |
2487264 | 2487264 | 2022-05-09 | Dearborn | Indiana | 18029 | 13536 | 140 |
2487265 | 2487265 | 2022-05-09 | Decatur | Indiana | 18031 | 7011 | 146 |
2487266 | 2487266 | 2022-05-09 | Delaware | Indiana | 18035 | 25046 | 443 |
2487267 | 2487267 | 2022-05-09 | Dubois | Indiana | 18037 | 12889 | 165 |
2487268 | 2487268 | 2022-05-09 | Elkhart | Indiana | 18039 | 54308 | 733 |
2487269 | 2487269 | 2022-05-09 | Fayette | Indiana | 18041 | 6747 | 146 |
2487270 | 2487270 | 2022-05-09 | Floyd | Indiana | 18043 | 19137 | 302 |
2487271 | 2487271 | 2022-05-09 | Fountain | Indiana | 18045 | 5466 | 103 |
2487272 | 2487272 | 2022-05-09 | Franklin | Indiana | 18047 | 4378 | 65 |
2487273 | 2487273 | 2022-05-09 | Fulton | Indiana | 18049 | 4933 | 103 |
2487274 | 2487274 | 2022-05-09 | Gibson | Indiana | 18051 | 11720 | 145 |
2487275 | 2487275 | 2022-05-09 | Grant | Indiana | 18053 | 17366 | 352 |
2487276 | 2487276 | 2022-05-09 | Greene | Indiana | 18055 | 7245 | 139 |
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);