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-11-13 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1911549 | 1911549 | 2021-11-13 | Adams | Indiana | 18001 | 5190 | 80 |
1911550 | 1911550 | 2021-11-13 | Allen | Indiana | 18003 | 61277 | 867 |
1911551 | 1911551 | 2021-11-13 | Bartholomew | Indiana | 18005 | 12172 | 191 |
1911552 | 1911552 | 2021-11-13 | Benton | Indiana | 18007 | 1558 | 17 |
1911553 | 1911553 | 2021-11-13 | Blackford | Indiana | 18009 | 2067 | 45 |
1911554 | 1911554 | 2021-11-13 | Boone | Indiana | 18011 | 9320 | 126 |
1911555 | 1911555 | 2021-11-13 | Brown | Indiana | 18013 | 1608 | 50 |
1911556 | 1911556 | 2021-11-13 | Carroll | Indiana | 18015 | 2765 | 39 |
1911557 | 1911557 | 2021-11-13 | Cass | Indiana | 18017 | 7743 | 127 |
1911558 | 1911558 | 2021-11-13 | Clark | Indiana | 18019 | 19311 | 279 |
1911559 | 1911559 | 2021-11-13 | Clay | Indiana | 18021 | 4410 | 61 |
1911560 | 1911560 | 2021-11-13 | Clinton | Indiana | 18023 | 6001 | 80 |
1911561 | 1911561 | 2021-11-13 | Crawford | Indiana | 18025 | 1647 | 30 |
1911562 | 1911562 | 2021-11-13 | Daviess | Indiana | 18027 | 4828 | 118 |
1911563 | 1911563 | 2021-11-13 | DeKalb | Indiana | 18033 | 6869 | 105 |
1911564 | 1911564 | 2021-11-13 | Dearborn | Indiana | 18029 | 8511 | 104 |
1911565 | 1911565 | 2021-11-13 | Decatur | Indiana | 18031 | 4383 | 113 |
1911566 | 1911566 | 2021-11-13 | Delaware | Indiana | 18035 | 15669 | 286 |
1911567 | 1911567 | 2021-11-13 | Dubois | Indiana | 18037 | 8518 | 136 |
1911568 | 1911568 | 2021-11-13 | Elkhart | Indiana | 18039 | 37687 | 546 |
1911569 | 1911569 | 2021-11-13 | Fayette | Indiana | 18041 | 4322 | 94 |
1911570 | 1911570 | 2021-11-13 | Floyd | Indiana | 18043 | 11511 | 233 |
1911571 | 1911571 | 2021-11-13 | Fountain | Indiana | 18045 | 3512 | 64 |
1911572 | 1911572 | 2021-11-13 | Franklin | Indiana | 18047 | 2767 | 48 |
1911573 | 1911573 | 2021-11-13 | Fulton | Indiana | 18049 | 3387 | 69 |
1911574 | 1911574 | 2021-11-13 | Gibson | Indiana | 18051 | 6799 | 120 |
1911575 | 1911575 | 2021-11-13 | Grant | Indiana | 18053 | 11285 | 237 |
1911576 | 1911576 | 2021-11-13 | Greene | Indiana | 18055 | 4446 | 102 |
1911577 | 1911577 | 2021-11-13 | Hamilton | Indiana | 18057 | 48019 | 504 |
1911578 | 1911578 | 2021-11-13 | Hancock | Indiana | 18059 | 12212 | 185 |
1911579 | 1911579 | 2021-11-13 | Harrison | Indiana | 18061 | 6696 | 98 |
1911580 | 1911580 | 2021-11-13 | Hendricks | Indiana | 18063 | 24783 | 390 |
1911581 | 1911581 | 2021-11-13 | Henry | Indiana | 18065 | 8625 | 166 |
1911582 | 1911582 | 2021-11-13 | Howard | Indiana | 18067 | 15547 | 310 |
1911583 | 1911583 | 2021-11-13 | Huntington | Indiana | 18069 | 6847 | 105 |
1911584 | 1911584 | 2021-11-13 | Jackson | Indiana | 18071 | 7243 | 95 |
1911585 | 1911585 | 2021-11-13 | Jasper | Indiana | 18073 | 5699 | 92 |
1911586 | 1911586 | 2021-11-13 | Jay | Indiana | 18075 | 3051 | 52 |
1911587 | 1911587 | 2021-11-13 | Jefferson | Indiana | 18077 | 5352 | 105 |
1911588 | 1911588 | 2021-11-13 | Jennings | Indiana | 18079 | 4140 | 68 |
1911589 | 1911589 | 2021-11-13 | Johnson | Indiana | 18081 | 26073 | 475 |
1911590 | 1911590 | 2021-11-13 | Knox | Indiana | 18083 | 6642 | 113 |
1911591 | 1911591 | 2021-11-13 | Kosciusko | Indiana | 18085 | 13172 | 159 |
1911592 | 1911592 | 2021-11-13 | LaGrange | Indiana | 18087 | 3899 | 90 |
1911593 | 1911593 | 2021-11-13 | LaPorte | Indiana | 18091 | 16018 | 260 |
1911594 | 1911594 | 2021-11-13 | Lake | Indiana | 18089 | 68736 | 1250 |
1911595 | 1911595 | 2021-11-13 | Lawrence | Indiana | 18093 | 7708 | 183 |
1911596 | 1911596 | 2021-11-13 | Madison | Indiana | 18095 | 19681 | 454 |
1911597 | 1911597 | 2021-11-13 | Marion | Indiana | 18097 | 139593 | 2271 |
1911598 | 1911598 | 2021-11-13 | Marshall | Indiana | 18099 | 8472 | 149 |
1911599 | 1911599 | 2021-11-13 | Martin | Indiana | 18101 | 1469 | 20 |
1911600 | 1911600 | 2021-11-13 | Miami | Indiana | 18103 | 6187 | 105 |
1911601 | 1911601 | 2021-11-13 | Monroe | Indiana | 18105 | 15813 | 212 |
1911602 | 1911602 | 2021-11-13 | Montgomery | Indiana | 18107 | 6592 | 119 |
1911603 | 1911603 | 2021-11-13 | Morgan | Indiana | 18109 | 9825 | 195 |
1911604 | 1911604 | 2021-11-13 | Newton | Indiana | 18111 | 1698 | 54 |
1911605 | 1911605 | 2021-11-13 | Noble | Indiana | 18113 | 8521 | 118 |
1911606 | 1911606 | 2021-11-13 | Ohio | Indiana | 18115 | 876 | 13 |
1911607 | 1911607 | 2021-11-13 | Orange | Indiana | 18117 | 3096 | 73 |
1911608 | 1911608 | 2021-11-13 | Owen | Indiana | 18119 | 3315 | 77 |
1911609 | 1911609 | 2021-11-13 | Parke | Indiana | 18121 | 2408 | 31 |
1911610 | 1911610 | 2021-11-13 | Perry | Indiana | 18123 | 2734 | 55 |
1911611 | 1911611 | 2021-11-13 | Pike | Indiana | 18125 | 2351 | 45 |
1911612 | 1911612 | 2021-11-13 | Porter | Indiana | 18127 | 23882 | 387 |
1911613 | 1911613 | 2021-11-13 | Posey | Indiana | 18129 | 3878 | 44 |
1911614 | 1911614 | 2021-11-13 | Pulaski | Indiana | 18131 | 1955 | 58 |
1911615 | 1911615 | 2021-11-13 | Putnam | Indiana | 18133 | 6101 | 85 |
1911616 | 1911616 | 2021-11-13 | Randolph | Indiana | 18135 | 3682 | 106 |
1911617 | 1911617 | 2021-11-13 | Ripley | Indiana | 18137 | 5234 | 93 |
1911618 | 1911618 | 2021-11-13 | Rush | Indiana | 18139 | 2877 | 32 |
1911619 | 1911619 | 2021-11-13 | Scott | Indiana | 18143 | 4603 | 79 |
1911620 | 1911620 | 2021-11-13 | Shelby | Indiana | 18145 | 8681 | 135 |
1911621 | 1911621 | 2021-11-13 | Spencer | Indiana | 18147 | 3478 | 47 |
1911622 | 1911622 | 2021-11-13 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1911623 | 1911623 | 2021-11-13 | Starke | Indiana | 18149 | 3336 | 74 |
1911624 | 1911624 | 2021-11-13 | Steuben | Indiana | 18151 | 6048 | 83 |
1911625 | 1911625 | 2021-11-13 | Sullivan | Indiana | 18153 | 3388 | 55 |
1911626 | 1911626 | 2021-11-13 | Switzerland | Indiana | 18155 | 1390 | 12 |
1911627 | 1911627 | 2021-11-13 | Tippecanoe | Indiana | 18157 | 28966 | 274 |
1911628 | 1911628 | 2021-11-13 | Tipton | Indiana | 18159 | 2372 | 66 |
1911629 | 1911629 | 2021-11-13 | Union | Indiana | 18161 | 1132 | 17 |
1911630 | 1911630 | 2021-11-13 | Vanderburgh | Indiana | 18163 | 33192 | 507 |
1911631 | 1911631 | 2021-11-13 | Vermillion | Indiana | 18165 | 2718 | 56 |
1911632 | 1911632 | 2021-11-13 | Vigo | Indiana | 18167 | 18191 | 313 |
1911633 | 1911633 | 2021-11-13 | Wabash | Indiana | 18169 | 5668 | 107 |
1911634 | 1911634 | 2021-11-13 | Warren | Indiana | 18171 | 1263 | 18 |
1911635 | 1911635 | 2021-11-13 | Warrick | Indiana | 18173 | 11597 | 193 |
1911636 | 1911636 | 2021-11-13 | Washington | Indiana | 18175 | 3694 | 55 |
1911637 | 1911637 | 2021-11-13 | Wayne | Indiana | 18177 | 11843 | 264 |
1911638 | 1911638 | 2021-11-13 | Wells | Indiana | 18179 | 4469 | 94 |
1911639 | 1911639 | 2021-11-13 | White | Indiana | 18181 | 4437 | 68 |
1911640 | 1911640 | 2021-11-13 | Whitley | Indiana | 18183 | 5989 | 60 |
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);