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-03-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 |
---|---|---|---|---|---|---|---|
1076928 | 1076928 | 2021-03-01 | Adams | Indiana | 18001 | 3236 | 50 |
1076929 | 1076929 | 2021-03-01 | Allen | Indiana | 18003 | 35913 | 661 |
1076930 | 1076930 | 2021-03-01 | Bartholomew | Indiana | 18005 | 7477 | 153 |
1076931 | 1076931 | 2021-03-01 | Benton | Indiana | 18007 | 920 | 13 |
1076932 | 1076932 | 2021-03-01 | Blackford | Indiana | 18009 | 1217 | 27 |
1076933 | 1076933 | 2021-03-01 | Boone | Indiana | 18011 | 6110 | 93 |
1076934 | 1076934 | 2021-03-01 | Brown | Indiana | 18013 | 950 | 39 |
1076935 | 1076935 | 2021-03-01 | Carroll | Indiana | 18015 | 1767 | 20 |
1076936 | 1076936 | 2021-03-01 | Cass | Indiana | 18017 | 5449 | 101 |
1076937 | 1076937 | 2021-03-01 | Clark | Indiana | 18019 | 11986 | 189 |
1076938 | 1076938 | 2021-03-01 | Clay | Indiana | 18021 | 2414 | 44 |
1076939 | 1076939 | 2021-03-01 | Clinton | Indiana | 18023 | 3963 | 58 |
1076940 | 1076940 | 2021-03-01 | Crawford | Indiana | 18025 | 909 | 14 |
1076941 | 1076941 | 2021-03-01 | Daviess | Indiana | 18027 | 2855 | 98 |
1076942 | 1076942 | 2021-03-01 | DeKalb | Indiana | 18033 | 3857 | 82 |
1076943 | 1076943 | 2021-03-01 | Dearborn | Indiana | 18029 | 5483 | 70 |
1076944 | 1076944 | 2021-03-01 | Decatur | Indiana | 18031 | 2761 | 92 |
1076945 | 1076945 | 2021-03-01 | Delaware | Indiana | 18035 | 9852 | 185 |
1076946 | 1076946 | 2021-03-01 | Dubois | Indiana | 18037 | 5911 | 112 |
1076947 | 1076947 | 2021-03-01 | Elkhart | Indiana | 18039 | 25487 | 431 |
1076948 | 1076948 | 2021-03-01 | Fayette | Indiana | 18041 | 2853 | 58 |
1076949 | 1076949 | 2021-03-01 | Floyd | Indiana | 18043 | 7218 | 174 |
1076950 | 1076950 | 2021-03-01 | Fountain | Indiana | 18045 | 2017 | 43 |
1076951 | 1076951 | 2021-03-01 | Franklin | Indiana | 18047 | 1612 | 36 |
1076952 | 1076952 | 2021-03-01 | Fulton | Indiana | 18049 | 1783 | 37 |
1076953 | 1076953 | 2021-03-01 | Gibson | Indiana | 18051 | 4017 | 84 |
1076954 | 1076954 | 2021-03-01 | Grant | Indiana | 18053 | 6842 | 164 |
1076955 | 1076955 | 2021-03-01 | Greene | Indiana | 18055 | 2621 | 84 |
1076956 | 1076956 | 2021-03-01 | Hamilton | Indiana | 18057 | 32144 | 415 |
1076957 | 1076957 | 2021-03-01 | Hancock | Indiana | 18059 | 7433 | 135 |
1076958 | 1076958 | 2021-03-01 | Harrison | Indiana | 18061 | 4001 | 66 |
1076959 | 1076959 | 2021-03-01 | Hendricks | Indiana | 18063 | 15883 | 319 |
1076960 | 1076960 | 2021-03-01 | Henry | Indiana | 18065 | 5436 | 94 |
1076961 | 1076961 | 2021-03-01 | Howard | Indiana | 18067 | 9067 | 201 |
1076962 | 1076962 | 2021-03-01 | Huntington | Indiana | 18069 | 3448 | 77 |
1076963 | 1076963 | 2021-03-01 | Jackson | Indiana | 18071 | 4651 | 68 |
1076964 | 1076964 | 2021-03-01 | Jasper | Indiana | 18073 | 3165 | 45 |
1076965 | 1076965 | 2021-03-01 | Jay | Indiana | 18075 | 1787 | 30 |
1076966 | 1076966 | 2021-03-01 | Jefferson | Indiana | 18077 | 2949 | 73 |
1076967 | 1076967 | 2021-03-01 | Jennings | Indiana | 18079 | 2156 | 46 |
1076968 | 1076968 | 2021-03-01 | Johnson | Indiana | 18081 | 16411 | 375 |
1076969 | 1076969 | 2021-03-01 | Knox | Indiana | 18083 | 3576 | 85 |
1076970 | 1076970 | 2021-03-01 | Kosciusko | Indiana | 18085 | 8582 | 114 |
1076971 | 1076971 | 2021-03-01 | LaGrange | Indiana | 18087 | 2414 | 72 |
1076972 | 1076972 | 2021-03-01 | LaPorte | Indiana | 18091 | 9782 | 199 |
1076973 | 1076973 | 2021-03-01 | Lake | Indiana | 18089 | 48502 | 915 |
1076974 | 1076974 | 2021-03-01 | Lawrence | Indiana | 18093 | 4187 | 115 |
1076975 | 1076975 | 2021-03-01 | Madison | Indiana | 18095 | 11779 | 341 |
1076976 | 1076976 | 2021-03-01 | Marion | Indiana | 18097 | 90913 | 1714 |
1076977 | 1076977 | 2021-03-01 | Marshall | Indiana | 18099 | 5428 | 105 |
1076978 | 1076978 | 2021-03-01 | Martin | Indiana | 18101 | 802 | 14 |
1076979 | 1076979 | 2021-03-01 | Miami | Indiana | 18103 | 3580 | 64 |
1076980 | 1076980 | 2021-03-01 | Monroe | Indiana | 18105 | 10338 | 165 |
1076981 | 1076981 | 2021-03-01 | Montgomery | Indiana | 18107 | 3872 | 84 |
1076982 | 1076982 | 2021-03-01 | Morgan | Indiana | 18109 | 6108 | 130 |
1076983 | 1076983 | 2021-03-01 | Newton | Indiana | 18111 | 967 | 33 |
1076984 | 1076984 | 2021-03-01 | Noble | Indiana | 18113 | 5097 | 81 |
1076985 | 1076985 | 2021-03-01 | Ohio | Indiana | 18115 | 537 | 11 |
1076986 | 1076986 | 2021-03-01 | Orange | Indiana | 18117 | 1716 | 53 |
1076987 | 1076987 | 2021-03-01 | Owen | Indiana | 18119 | 1824 | 55 |
1076988 | 1076988 | 2021-03-01 | Parke | Indiana | 18121 | 1407 | 16 |
1076989 | 1076989 | 2021-03-01 | Perry | Indiana | 18123 | 1742 | 36 |
1076990 | 1076990 | 2021-03-01 | Pike | Indiana | 18125 | 1276 | 32 |
1076991 | 1076991 | 2021-03-01 | Porter | Indiana | 18127 | 16001 | 286 |
1076992 | 1076992 | 2021-03-01 | Posey | Indiana | 18129 | 2609 | 31 |
1076993 | 1076993 | 2021-03-01 | Pulaski | Indiana | 18131 | 1065 | 44 |
1076994 | 1076994 | 2021-03-01 | Putnam | Indiana | 18133 | 3314 | 59 |
1076995 | 1076995 | 2021-03-01 | Randolph | Indiana | 18135 | 2297 | 77 |
1076996 | 1076996 | 2021-03-01 | Ripley | Indiana | 18137 | 3273 | 61 |
1076997 | 1076997 | 2021-03-01 | Rush | Indiana | 18139 | 1711 | 22 |
1076998 | 1076998 | 2021-03-01 | Scott | Indiana | 18143 | 2510 | 52 |
1076999 | 1076999 | 2021-03-01 | Shelby | Indiana | 18145 | 5536 | 100 |
1077000 | 1077000 | 2021-03-01 | Spencer | Indiana | 18147 | 2176 | 30 |
1077001 | 1077001 | 2021-03-01 | St. Joseph | Indiana | 18141 | 30029 | 530 |
1077002 | 1077002 | 2021-03-01 | Starke | Indiana | 18149 | 1884 | 53 |
1077003 | 1077003 | 2021-03-01 | Steuben | Indiana | 18151 | 3389 | 57 |
1077004 | 1077004 | 2021-03-01 | Sullivan | Indiana | 18153 | 2037 | 39 |
1077005 | 1077005 | 2021-03-01 | Switzerland | Indiana | 18155 | 755 | 8 |
1077006 | 1077006 | 2021-03-01 | Tippecanoe | Indiana | 18157 | 20031 | 205 |
1077007 | 1077007 | 2021-03-01 | Tipton | Indiana | 18159 | 1469 | 44 |
1077008 | 1077008 | 2021-03-01 | Union | Indiana | 18161 | 699 | 11 |
1077009 | 1077009 | 2021-03-01 | Vanderburgh | Indiana | 18163 | 21257 | 384 |
1077010 | 1077010 | 2021-03-01 | Vermillion | Indiana | 18165 | 1606 | 42 |
1077011 | 1077011 | 2021-03-01 | Vigo | Indiana | 18167 | 11625 | 236 |
1077012 | 1077012 | 2021-03-01 | Wabash | Indiana | 18169 | 3319 | 76 |
1077013 | 1077013 | 2021-03-01 | Warren | Indiana | 18171 | 760 | 15 |
1077014 | 1077014 | 2021-03-01 | Warrick | Indiana | 18173 | 7419 | 154 |
1077015 | 1077015 | 2021-03-01 | Washington | Indiana | 18175 | 2112 | 27 |
1077016 | 1077016 | 2021-03-01 | Wayne | Indiana | 18177 | 7023 | 194 |
1077017 | 1077017 | 2021-03-01 | Wells | Indiana | 18179 | 2608 | 79 |
1077018 | 1077018 | 2021-03-01 | White | Indiana | 18181 | 2974 | 53 |
1077019 | 1077019 | 2021-03-01 | Whitley | Indiana | 18183 | 3494 | 36 |
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);