ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 38 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
364192 | 364192 | 2020-07-24 | Martin | Indiana | 18101 | 38 | 0 |
360947 | 360947 | 2020-07-23 | Crawford | Indiana | 18025 | 38 | 1 |
360985 | 360985 | 2020-07-23 | Martin | Indiana | 18101 | 38 | 0 |
361012 | 361012 | 2020-07-23 | Switzerland | Indiana | 18155 | 38 | 0 |
357742 | 357742 | 2020-07-22 | Crawford | Indiana | 18025 | 38 | 1 |
357807 | 357807 | 2020-07-22 | Switzerland | Indiana | 18155 | 38 | 0 |
354540 | 354540 | 2020-07-21 | Crawford | Indiana | 18025 | 38 | 1 |
354588 | 354588 | 2020-07-21 | Parke | Indiana | 18121 | 38 | 0 |
354605 | 354605 | 2020-07-21 | Switzerland | Indiana | 18155 | 38 | 0 |
351338 | 351338 | 2020-07-20 | Crawford | Indiana | 18025 | 38 | 1 |
351403 | 351403 | 2020-07-20 | Switzerland | Indiana | 18155 | 38 | 0 |
341804 | 341804 | 2020-07-17 | Tipton | Indiana | 18159 | 38 | 3 |
335355 | 335355 | 2020-07-15 | Fountain | Indiana | 18045 | 38 | 2 |
332162 | 332162 | 2020-07-14 | Fountain | Indiana | 18045 | 38 | 2 |
300399 | 300399 | 2020-07-04 | Brown | Indiana | 18013 | 38 | 1 |
300457 | 300457 | 2020-07-04 | Posey | Indiana | 18129 | 38 | 0 |
297237 | 297237 | 2020-07-03 | Brown | Indiana | 18013 | 38 | 1 |
297303 | 297303 | 2020-07-03 | Spencer | Indiana | 18147 | 38 | 1 |
294079 | 294079 | 2020-07-02 | Brown | Indiana | 18013 | 38 | 1 |
290925 | 290925 | 2020-07-01 | Brown | Indiana | 18013 | 38 | 1 |
287773 | 287773 | 2020-06-30 | Blackford | Indiana | 18009 | 38 | 2 |
287775 | 287775 | 2020-06-30 | Brown | Indiana | 18013 | 38 | 1 |
284624 | 284624 | 2020-06-29 | Blackford | Indiana | 18009 | 38 | 2 |
284626 | 284626 | 2020-06-29 | Brown | Indiana | 18013 | 38 | 1 |
281479 | 281479 | 2020-06-28 | Blackford | Indiana | 18009 | 38 | 2 |
281481 | 281481 | 2020-06-28 | Brown | Indiana | 18013 | 38 | 1 |
278331 | 278331 | 2020-06-27 | Blackford | Indiana | 18009 | 38 | 2 |
275183 | 275183 | 2020-06-26 | Blackford | Indiana | 18009 | 38 | 2 |
253272 | 253272 | 2020-06-19 | Benton | Indiana | 18007 | 38 | 0 |
250157 | 250157 | 2020-06-18 | Benton | Indiana | 18007 | 38 | 0 |
243932 | 243932 | 2020-06-16 | Benton | Indiana | 18007 | 38 | 0 |
243970 | 243970 | 2020-06-16 | Knox | Indiana | 18083 | 38 | 0 |
212999 | 212999 | 2020-06-06 | Sullivan | Indiana | 18153 | 38 | 1 |
213012 | 213012 | 2020-06-06 | Wells | Indiana | 18179 | 38 | 0 |
209872 | 209872 | 2020-06-05 | Huntington | Indiana | 18069 | 38 | 2 |
209914 | 209914 | 2020-06-05 | Sullivan | Indiana | 18153 | 38 | 1 |
206791 | 206791 | 2020-06-04 | Huntington | Indiana | 18069 | 38 | 2 |
206833 | 206833 | 2020-06-04 | Sullivan | Indiana | 18153 | 38 | 1 |
200615 | 200615 | 2020-06-02 | DeKalb | Indiana | 18033 | 38 | 2 |
197542 | 197542 | 2020-06-01 | DeKalb | Indiana | 18033 | 38 | 2 |
194472 | 194472 | 2020-05-31 | DeKalb | Indiana | 18033 | 38 | 2 |
191405 | 191405 | 2020-05-30 | DeKalb | Indiana | 18033 | 38 | 2 |
185359 | 185359 | 2020-05-28 | Whitley | Indiana | 18183 | 38 | 3 |
176187 | 176187 | 2020-05-25 | Perry | Indiana | 18123 | 38 | 1 |
170051 | 170051 | 2020-05-23 | Clay | Indiana | 18021 | 38 | 1 |
170106 | 170106 | 2020-05-23 | Pulaski | Indiana | 18131 | 38 | 0 |
161008 | 161008 | 2020-05-20 | Pulaski | Indiana | 18131 | 38 | 0 |
127954 | 127954 | 2020-05-09 | Jasper | Indiana | 18073 | 38 | 1 |
127961 | 127961 | 2020-05-09 | LaGrange | Indiana | 18087 | 38 | 2 |
124949 | 124949 | 2020-05-08 | Dubois | Indiana | 18037 | 38 | 0 |
121987 | 121987 | 2020-05-07 | Jasper | Indiana | 18073 | 38 | 1 |
119017 | 119017 | 2020-05-06 | Jasper | Indiana | 18073 | 38 | 1 |
116057 | 116057 | 2020-05-05 | Jasper | Indiana | 18073 | 38 | 1 |
113180 | 113180 | 2020-05-04 | Kosciusko | Indiana | 18085 | 38 | 2 |
104597 | 104597 | 2020-05-01 | Rush | Indiana | 18139 | 38 | 1 |
98853 | 98853 | 2020-04-29 | Henry | Indiana | 18065 | 38 | 1 |
98905 | 98905 | 2020-04-29 | Wabash | Indiana | 18169 | 38 | 1 |
93215 | 93215 | 2020-04-27 | Scott | Indiana | 18143 | 38 | 2 |
93233 | 93233 | 2020-04-27 | Wayne | Indiana | 18177 | 38 | 3 |
79165 | 79165 | 2020-04-22 | Orange | Indiana | 18117 | 38 | 4 |
65291 | 65291 | 2020-04-17 | Greene | Indiana | 18055 | 38 | 4 |
62538 | 62538 | 2020-04-16 | Cass | Indiana | 18017 | 38 | 2 |
57167 | 57167 | 2020-04-14 | Putnam | Indiana | 18133 | 38 | 3 |
54434 | 54434 | 2020-04-13 | Grant | Indiana | 18053 | 38 | 3 |
54494 | 54494 | 2020-04-13 | Warrick | Indiana | 18173 | 38 | 2 |
41326 | 41326 | 2020-04-08 | Tippecanoe | Indiana | 18157 | 38 | 1 |
38737 | 38737 | 2020-04-07 | Howard | Indiana | 18067 | 38 | 5 |
36221 | 36221 | 2020-04-06 | Dearborn | Indiana | 18029 | 38 | 1 |
36236 | 36236 | 2020-04-06 | Harrison | Indiana | 18061 | 38 | 1 |
28982 | 28982 | 2020-04-03 | Boone | Indiana | 18011 | 38 | 0 |
24437 | 24437 | 2020-04-01 | Clark | Indiana | 18019 | 38 | 1 |
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);