ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 28 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Crawford 20
- Tipton 5
- Whitley 5
- Blackford 4
- Owen 4
- Parke 4
- Huntington 3
- Perry 3
- Switzerland 3
- Brown 2
- Fountain 2
- Howard 2
- Marshall 2
- Posey 2
- Spencer 2
- Starke 2
- Sullivan 2
- Warren 2
- Washington 2
- Adams 1
- Clay 1
- Fayette 1
- Franklin 1
- Hancock 1
- Harrison 1
- Hendricks 1
- Jackson 1
- Jasper 1
- Kosciusko 1
- LaGrange 1
- …
state 1
- Indiana · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
441476 | 441476 | 2020-08-17 | Warren | Indiana | 18171 | 28 | 1 |
438250 | 438250 | 2020-08-16 | Warren | Indiana | 18171 | 28 | 1 |
377048 | 377048 | 2020-07-28 | Pike | Indiana | 18125 | 28 | 0 |
335383 | 335383 | 2020-07-15 | Martin | Indiana | 18101 | 28 | 0 |
319467 | 319467 | 2020-07-10 | Parke | Indiana | 18121 | 28 | 0 |
309950 | 309950 | 2020-07-07 | Parke | Indiana | 18121 | 28 | 0 |
306782 | 306782 | 2020-07-06 | Parke | Indiana | 18121 | 28 | 0 |
303617 | 303617 | 2020-07-05 | Parke | Indiana | 18121 | 28 | 0 |
300470 | 300470 | 2020-07-04 | Switzerland | Indiana | 18155 | 28 | 0 |
297308 | 297308 | 2020-07-03 | Switzerland | Indiana | 18155 | 28 | 0 |
294150 | 294150 | 2020-07-02 | Switzerland | Indiana | 18155 | 28 | 0 |
287791 | 287791 | 2020-06-30 | Fountain | Indiana | 18045 | 28 | 2 |
284642 | 284642 | 2020-06-29 | Fountain | Indiana | 18045 | 28 | 2 |
278339 | 278339 | 2020-06-27 | Crawford | Indiana | 18025 | 28 | 1 |
278391 | 278391 | 2020-06-27 | Posey | Indiana | 18129 | 28 | 0 |
275191 | 275191 | 2020-06-26 | Crawford | Indiana | 18025 | 28 | 1 |
275243 | 275243 | 2020-06-26 | Posey | Indiana | 18129 | 28 | 0 |
272049 | 272049 | 2020-06-25 | Crawford | Indiana | 18025 | 28 | 1 |
268912 | 268912 | 2020-06-24 | Crawford | Indiana | 18025 | 28 | 1 |
268980 | 268980 | 2020-06-24 | Union | Indiana | 18161 | 28 | 0 |
265782 | 265782 | 2020-06-23 | Crawford | Indiana | 18025 | 28 | 1 |
265842 | 265842 | 2020-06-23 | Spencer | Indiana | 18147 | 28 | 1 |
262654 | 262654 | 2020-06-22 | Crawford | Indiana | 18025 | 28 | 1 |
262714 | 262714 | 2020-06-22 | Spencer | Indiana | 18147 | 28 | 1 |
259527 | 259527 | 2020-06-21 | Crawford | Indiana | 18025 | 28 | 1 |
256401 | 256401 | 2020-06-20 | Crawford | Indiana | 18025 | 28 | 1 |
253281 | 253281 | 2020-06-19 | Crawford | Indiana | 18025 | 28 | 1 |
250166 | 250166 | 2020-06-18 | Crawford | Indiana | 18025 | 28 | 1 |
247054 | 247054 | 2020-06-17 | Crawford | Indiana | 18025 | 28 | 1 |
243929 | 243929 | 2020-06-16 | Adams | Indiana | 18001 | 28 | 1 |
243941 | 243941 | 2020-06-16 | Crawford | Indiana | 18025 | 28 | 1 |
240830 | 240830 | 2020-06-15 | Crawford | Indiana | 18025 | 28 | 1 |
237722 | 237722 | 2020-06-14 | Crawford | Indiana | 18025 | 28 | 1 |
234615 | 234615 | 2020-06-13 | Crawford | Indiana | 18025 | 28 | 1 |
234682 | 234682 | 2020-06-13 | Tipton | Indiana | 18159 | 28 | 2 |
231509 | 231509 | 2020-06-12 | Crawford | Indiana | 18025 | 28 | 1 |
231576 | 231576 | 2020-06-12 | Tipton | Indiana | 18159 | 28 | 2 |
228406 | 228406 | 2020-06-11 | Crawford | Indiana | 18025 | 28 | 1 |
228473 | 228473 | 2020-06-11 | Tipton | Indiana | 18159 | 28 | 2 |
225304 | 225304 | 2020-06-10 | Crawford | Indiana | 18025 | 28 | 1 |
225371 | 225371 | 2020-06-10 | Tipton | Indiana | 18159 | 28 | 2 |
222209 | 222209 | 2020-06-09 | Crawford | Indiana | 18025 | 28 | 1 |
222276 | 222276 | 2020-06-09 | Tipton | Indiana | 18159 | 28 | 2 |
219114 | 219114 | 2020-06-08 | Crawford | Indiana | 18025 | 28 | 1 |
209842 | 209842 | 2020-06-05 | Blackford | Indiana | 18009 | 28 | 2 |
206761 | 206761 | 2020-06-04 | Blackford | Indiana | 18009 | 28 | 2 |
203681 | 203681 | 2020-06-03 | Blackford | Indiana | 18009 | 28 | 2 |
200605 | 200605 | 2020-06-02 | Blackford | Indiana | 18009 | 28 | 2 |
200635 | 200635 | 2020-06-02 | Huntington | Indiana | 18069 | 28 | 2 |
197562 | 197562 | 2020-06-01 | Huntington | Indiana | 18069 | 28 | 2 |
194492 | 194492 | 2020-05-31 | Huntington | Indiana | 18069 | 28 | 2 |
188415 | 188415 | 2020-05-29 | Wells | Indiana | 18179 | 28 | 0 |
161002 | 161002 | 2020-05-20 | Owen | Indiana | 18119 | 28 | 1 |
161034 | 161034 | 2020-05-20 | Whitley | Indiana | 18183 | 28 | 2 |
157991 | 157991 | 2020-05-19 | Starke | Indiana | 18149 | 28 | 2 |
157993 | 157993 | 2020-05-19 | Sullivan | Indiana | 18153 | 28 | 0 |
154977 | 154977 | 2020-05-18 | Sullivan | Indiana | 18153 | 28 | 0 |
154992 | 154992 | 2020-05-18 | Whitley | Indiana | 18183 | 28 | 2 |
151980 | 151980 | 2020-05-17 | Whitley | Indiana | 18183 | 28 | 2 |
148954 | 148954 | 2020-05-16 | Starke | Indiana | 18149 | 28 | 2 |
148971 | 148971 | 2020-05-16 | Whitley | Indiana | 18183 | 28 | 2 |
145886 | 145886 | 2020-05-15 | Clay | Indiana | 18021 | 28 | 1 |
145967 | 145967 | 2020-05-15 | Whitley | Indiana | 18183 | 28 | 2 |
142937 | 142937 | 2020-05-14 | Perry | Indiana | 18123 | 28 | 0 |
139886 | 139886 | 2020-05-13 | Brown | Indiana | 18013 | 28 | 1 |
139941 | 139941 | 2020-05-13 | Perry | Indiana | 18123 | 28 | 0 |
136894 | 136894 | 2020-05-12 | Brown | Indiana | 18013 | 28 | 1 |
133958 | 133958 | 2020-05-11 | Owen | Indiana | 18119 | 28 | 1 |
133960 | 133960 | 2020-05-11 | Perry | Indiana | 18123 | 28 | 0 |
130968 | 130968 | 2020-05-10 | Owen | Indiana | 18119 | 28 | 1 |
127977 | 127977 | 2020-05-09 | Owen | Indiana | 18119 | 28 | 1 |
107436 | 107436 | 2020-05-02 | LaGrange | Indiana | 18087 | 28 | 2 |
98870 | 98870 | 2020-04-29 | Marshall | Indiana | 18099 | 28 | 1 |
96026 | 96026 | 2020-04-28 | Marshall | Indiana | 18099 | 28 | 1 |
96061 | 96061 | 2020-04-28 | Wabash | Indiana | 18169 | 28 | 1 |
87552 | 87552 | 2020-04-25 | Kosciusko | Indiana | 18085 | 28 | 2 |
84720 | 84720 | 2020-04-24 | Fayette | Indiana | 18041 | 28 | 4 |
81936 | 81936 | 2020-04-23 | Jasper | Indiana | 18073 | 28 | 1 |
81970 | 81970 | 2020-04-23 | Scott | Indiana | 18143 | 28 | 2 |
79158 | 79158 | 2020-04-22 | Miami | Indiana | 18103 | 28 | 0 |
73634 | 73634 | 2020-04-20 | Wayne | Indiana | 18177 | 28 | 2 |
68100 | 68100 | 2020-04-18 | Washington | Indiana | 18175 | 28 | 0 |
62617 | 62617 | 2020-04-16 | Washington | Indiana | 18175 | 28 | 0 |
41294 | 41294 | 2020-04-08 | LaPorte | Indiana | 18091 | 28 | 3 |
33786 | 33786 | 2020-04-05 | Howard | Indiana | 18067 | 28 | 3 |
31372 | 31372 | 2020-04-04 | Harrison | Indiana | 18061 | 28 | 1 |
31375 | 31375 | 2020-04-04 | Howard | Indiana | 18067 | 28 | 3 |
31377 | 31377 | 2020-04-04 | Jackson | Indiana | 18071 | 28 | 0 |
31417 | 31417 | 2020-04-04 | Tippecanoe | Indiana | 18157 | 28 | 1 |
20186 | 20186 | 2020-03-30 | Franklin | Indiana | 18047 | 28 | 4 |
20192 | 20192 | 2020-03-30 | Hancock | Indiana | 18059 | 28 | 1 |
14487 | 14487 | 2020-03-27 | Hendricks | Indiana | 18063 | 28 | 2 |
14519 | 14519 | 2020-03-27 | St. Joseph | Indiana | 18141 | 28 | 2 |
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);