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-18 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1132114 | 1132114 | 2021-03-18 | Adams | Indiana | 18001 | 3361 | 51 |
1132115 | 1132115 | 2021-03-18 | Allen | Indiana | 18003 | 36907 | 679 |
1132116 | 1132116 | 2021-03-18 | Bartholomew | Indiana | 18005 | 7608 | 156 |
1132117 | 1132117 | 2021-03-18 | Benton | Indiana | 18007 | 931 | 13 |
1132118 | 1132118 | 2021-03-18 | Blackford | Indiana | 18009 | 1273 | 28 |
1132119 | 1132119 | 2021-03-18 | Boone | Indiana | 18011 | 6288 | 100 |
1132120 | 1132120 | 2021-03-18 | Brown | Indiana | 18013 | 962 | 40 |
1132121 | 1132121 | 2021-03-18 | Carroll | Indiana | 18015 | 1786 | 21 |
1132122 | 1132122 | 2021-03-18 | Cass | Indiana | 18017 | 5561 | 103 |
1132123 | 1132123 | 2021-03-18 | Clark | Indiana | 18019 | 12273 | 191 |
1132124 | 1132124 | 2021-03-18 | Clay | Indiana | 18021 | 2441 | 44 |
1132125 | 1132125 | 2021-03-18 | Clinton | Indiana | 18023 | 4016 | 58 |
1132126 | 1132126 | 2021-03-18 | Crawford | Indiana | 18025 | 943 | 14 |
1132127 | 1132127 | 2021-03-18 | Daviess | Indiana | 18027 | 2871 | 98 |
1132128 | 1132128 | 2021-03-18 | DeKalb | Indiana | 18033 | 3923 | 83 |
1132129 | 1132129 | 2021-03-18 | Dearborn | Indiana | 18029 | 5552 | 75 |
1132130 | 1132130 | 2021-03-18 | Decatur | Indiana | 18031 | 2788 | 96 |
1132131 | 1132131 | 2021-03-18 | Delaware | Indiana | 18035 | 10015 | 187 |
1132132 | 1132132 | 2021-03-18 | Dubois | Indiana | 18037 | 5984 | 113 |
1132133 | 1132133 | 2021-03-18 | Elkhart | Indiana | 18039 | 25966 | 440 |
1132134 | 1132134 | 2021-03-18 | Fayette | Indiana | 18041 | 2874 | 60 |
1132135 | 1132135 | 2021-03-18 | Floyd | Indiana | 18043 | 7333 | 180 |
1132136 | 1132136 | 2021-03-18 | Fountain | Indiana | 18045 | 2039 | 44 |
1132137 | 1132137 | 2021-03-18 | Franklin | Indiana | 18047 | 1632 | 36 |
1132138 | 1132138 | 2021-03-18 | Fulton | Indiana | 18049 | 1838 | 39 |
1132139 | 1132139 | 2021-03-18 | Gibson | Indiana | 18051 | 4148 | 89 |
1132140 | 1132140 | 2021-03-18 | Grant | Indiana | 18053 | 6950 | 169 |
1132141 | 1132141 | 2021-03-18 | Greene | Indiana | 18055 | 2667 | 85 |
1132142 | 1132142 | 2021-03-18 | Hamilton | Indiana | 18057 | 32916 | 419 |
1132143 | 1132143 | 2021-03-18 | Hancock | Indiana | 18059 | 7582 | 139 |
1132144 | 1132144 | 2021-03-18 | Harrison | Indiana | 18061 | 4127 | 70 |
1132145 | 1132145 | 2021-03-18 | Hendricks | Indiana | 18063 | 16188 | 324 |
1132146 | 1132146 | 2021-03-18 | Henry | Indiana | 18065 | 5476 | 97 |
1132147 | 1132147 | 2021-03-18 | Howard | Indiana | 18067 | 9258 | 211 |
1132148 | 1132148 | 2021-03-18 | Huntington | Indiana | 18069 | 3596 | 80 |
1132149 | 1132149 | 2021-03-18 | Jackson | Indiana | 18071 | 4696 | 68 |
1132150 | 1132150 | 2021-03-18 | Jasper | Indiana | 18073 | 3252 | 48 |
1132151 | 1132151 | 2021-03-18 | Jay | Indiana | 18075 | 1817 | 30 |
1132152 | 1132152 | 2021-03-18 | Jefferson | Indiana | 18077 | 2983 | 76 |
1132153 | 1132153 | 2021-03-18 | Jennings | Indiana | 18079 | 2205 | 47 |
1132154 | 1132154 | 2021-03-18 | Johnson | Indiana | 18081 | 16761 | 382 |
1132155 | 1132155 | 2021-03-18 | Knox | Indiana | 18083 | 3590 | 86 |
1132156 | 1132156 | 2021-03-18 | Kosciusko | Indiana | 18085 | 8705 | 116 |
1132157 | 1132157 | 2021-03-18 | LaGrange | Indiana | 18087 | 2449 | 72 |
1132158 | 1132158 | 2021-03-18 | LaPorte | Indiana | 18091 | 9976 | 205 |
1132159 | 1132159 | 2021-03-18 | Lake | Indiana | 18089 | 49345 | 943 |
1132160 | 1132160 | 2021-03-18 | Lawrence | Indiana | 18093 | 4226 | 119 |
1132161 | 1132161 | 2021-03-18 | Madison | Indiana | 18095 | 11955 | 349 |
1132162 | 1132162 | 2021-03-18 | Marion | Indiana | 18097 | 92429 | 1748 |
1132163 | 1132163 | 2021-03-18 | Marshall | Indiana | 18099 | 5540 | 107 |
1132164 | 1132164 | 2021-03-18 | Martin | Indiana | 18101 | 810 | 14 |
1132165 | 1132165 | 2021-03-18 | Miami | Indiana | 18103 | 3639 | 65 |
1132166 | 1132166 | 2021-03-18 | Monroe | Indiana | 18105 | 10605 | 168 |
1132167 | 1132167 | 2021-03-18 | Montgomery | Indiana | 18107 | 3990 | 85 |
1132168 | 1132168 | 2021-03-18 | Morgan | Indiana | 18109 | 6220 | 136 |
1132169 | 1132169 | 2021-03-18 | Newton | Indiana | 18111 | 984 | 35 |
1132170 | 1132170 | 2021-03-18 | Noble | Indiana | 18113 | 5184 | 82 |
1132171 | 1132171 | 2021-03-18 | Ohio | Indiana | 18115 | 544 | 11 |
1132172 | 1132172 | 2021-03-18 | Orange | Indiana | 18117 | 1728 | 55 |
1132173 | 1132173 | 2021-03-18 | Owen | Indiana | 18119 | 1869 | 56 |
1132174 | 1132174 | 2021-03-18 | Parke | Indiana | 18121 | 1425 | 16 |
1132175 | 1132175 | 2021-03-18 | Perry | Indiana | 18123 | 1764 | 37 |
1132176 | 1132176 | 2021-03-18 | Pike | Indiana | 18125 | 1286 | 33 |
1132177 | 1132177 | 2021-03-18 | Porter | Indiana | 18127 | 16330 | 296 |
1132178 | 1132178 | 2021-03-18 | Posey | Indiana | 18129 | 2639 | 32 |
1132179 | 1132179 | 2021-03-18 | Pulaski | Indiana | 18131 | 1097 | 44 |
1132180 | 1132180 | 2021-03-18 | Putnam | Indiana | 18133 | 3422 | 60 |
1132181 | 1132181 | 2021-03-18 | Randolph | Indiana | 18135 | 2320 | 78 |
1132182 | 1132182 | 2021-03-18 | Ripley | Indiana | 18137 | 3295 | 66 |
1132183 | 1132183 | 2021-03-18 | Rush | Indiana | 18139 | 1733 | 24 |
1132184 | 1132184 | 2021-03-18 | Scott | Indiana | 18143 | 2549 | 54 |
1132185 | 1132185 | 2021-03-18 | Shelby | Indiana | 18145 | 5633 | 103 |
1132186 | 1132186 | 2021-03-18 | Spencer | Indiana | 18147 | 2232 | 30 |
1132187 | 1132187 | 2021-03-18 | St. Joseph | Indiana | 18141 | 31191 | 539 |
1132188 | 1132188 | 2021-03-18 | Starke | Indiana | 18149 | 1916 | 54 |
1132189 | 1132189 | 2021-03-18 | Steuben | Indiana | 18151 | 3453 | 59 |
1132190 | 1132190 | 2021-03-18 | Sullivan | Indiana | 18153 | 2051 | 41 |
1132191 | 1132191 | 2021-03-18 | Switzerland | Indiana | 18155 | 759 | 8 |
1132192 | 1132192 | 2021-03-18 | Tippecanoe | Indiana | 18157 | 20523 | 213 |
1132193 | 1132193 | 2021-03-18 | Tipton | Indiana | 18159 | 1541 | 44 |
1132194 | 1132194 | 2021-03-18 | Union | Indiana | 18161 | 714 | 11 |
1132195 | 1132195 | 2021-03-18 | Vanderburgh | Indiana | 18163 | 21540 | 391 |
1132196 | 1132196 | 2021-03-18 | Vermillion | Indiana | 18165 | 1626 | 43 |
1132197 | 1132197 | 2021-03-18 | Vigo | Indiana | 18167 | 11850 | 244 |
1132198 | 1132198 | 2021-03-18 | Wabash | Indiana | 18169 | 3371 | 77 |
1132199 | 1132199 | 2021-03-18 | Warren | Indiana | 18171 | 765 | 15 |
1132200 | 1132200 | 2021-03-18 | Warrick | Indiana | 18173 | 7521 | 157 |
1132201 | 1132201 | 2021-03-18 | Washington | Indiana | 18175 | 2165 | 29 |
1132202 | 1132202 | 2021-03-18 | Wayne | Indiana | 18177 | 7099 | 200 |
1132203 | 1132203 | 2021-03-18 | Wells | Indiana | 18179 | 2692 | 80 |
1132204 | 1132204 | 2021-03-18 | White | Indiana | 18181 | 3010 | 55 |
1132205 | 1132205 | 2021-03-18 | Whitley | Indiana | 18183 | 3582 | 39 |
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);