ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where deaths = 6, fips = 18137 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
250222 | 250222 | 2020-06-18 | Ripley | Indiana | 18137 | 111 | 6 |
247110 | 247110 | 2020-06-17 | Ripley | Indiana | 18137 | 111 | 6 |
243997 | 243997 | 2020-06-16 | Ripley | Indiana | 18137 | 111 | 6 |
240886 | 240886 | 2020-06-15 | Ripley | Indiana | 18137 | 109 | 6 |
237778 | 237778 | 2020-06-14 | Ripley | Indiana | 18137 | 109 | 6 |
234671 | 234671 | 2020-06-13 | Ripley | Indiana | 18137 | 109 | 6 |
231565 | 231565 | 2020-06-12 | Ripley | Indiana | 18137 | 109 | 6 |
228462 | 228462 | 2020-06-11 | Ripley | Indiana | 18137 | 109 | 6 |
225360 | 225360 | 2020-06-10 | Ripley | Indiana | 18137 | 109 | 6 |
222265 | 222265 | 2020-06-09 | Ripley | Indiana | 18137 | 110 | 6 |
219170 | 219170 | 2020-06-08 | Ripley | Indiana | 18137 | 109 | 6 |
216078 | 216078 | 2020-06-07 | Ripley | Indiana | 18137 | 108 | 6 |
212991 | 212991 | 2020-06-06 | Ripley | Indiana | 18137 | 108 | 6 |
209906 | 209906 | 2020-06-05 | Ripley | Indiana | 18137 | 108 | 6 |
206825 | 206825 | 2020-06-04 | Ripley | Indiana | 18137 | 108 | 6 |
203745 | 203745 | 2020-06-03 | Ripley | Indiana | 18137 | 108 | 6 |
200669 | 200669 | 2020-06-02 | Ripley | Indiana | 18137 | 108 | 6 |
197596 | 197596 | 2020-06-01 | Ripley | Indiana | 18137 | 109 | 6 |
194526 | 194526 | 2020-05-31 | Ripley | Indiana | 18137 | 109 | 6 |
191459 | 191459 | 2020-05-30 | Ripley | Indiana | 18137 | 108 | 6 |
188394 | 188394 | 2020-05-29 | Ripley | Indiana | 18137 | 108 | 6 |
185336 | 185336 | 2020-05-28 | Ripley | Indiana | 18137 | 110 | 6 |
182282 | 182282 | 2020-05-27 | Ripley | Indiana | 18137 | 113 | 6 |
179238 | 179238 | 2020-05-26 | Ripley | Indiana | 18137 | 112 | 6 |
176194 | 176194 | 2020-05-25 | Ripley | Indiana | 18137 | 112 | 6 |
173150 | 173150 | 2020-05-24 | Ripley | Indiana | 18137 | 112 | 6 |
170109 | 170109 | 2020-05-23 | Ripley | Indiana | 18137 | 112 | 6 |
167072 | 167072 | 2020-05-22 | Ripley | Indiana | 18137 | 110 | 6 |
164039 | 164039 | 2020-05-21 | Ripley | Indiana | 18137 | 110 | 6 |
161011 | 161011 | 2020-05-20 | Ripley | Indiana | 18137 | 107 | 6 |
157985 | 157985 | 2020-05-19 | Ripley | Indiana | 18137 | 107 | 6 |
154969 | 154969 | 2020-05-18 | Ripley | Indiana | 18137 | 108 | 6 |
151957 | 151957 | 2020-05-17 | Ripley | Indiana | 18137 | 107 | 6 |
148948 | 148948 | 2020-05-16 | Ripley | Indiana | 18137 | 107 | 6 |
145944 | 145944 | 2020-05-15 | Ripley | Indiana | 18137 | 106 | 6 |
142944 | 142944 | 2020-05-14 | Ripley | Indiana | 18137 | 105 | 6 |
139948 | 139948 | 2020-05-13 | Ripley | Indiana | 18137 | 105 | 6 |
136956 | 136956 | 2020-05-12 | Ripley | Indiana | 18137 | 104 | 6 |
133967 | 133967 | 2020-05-11 | Ripley | Indiana | 18137 | 101 | 6 |
130977 | 130977 | 2020-05-10 | Ripley | Indiana | 18137 | 101 | 6 |
127986 | 127986 | 2020-05-09 | Ripley | Indiana | 18137 | 98 | 6 |
124999 | 124999 | 2020-05-08 | Ripley | Indiana | 18137 | 98 | 6 |
122019 | 122019 | 2020-05-07 | Ripley | Indiana | 18137 | 98 | 6 |
119049 | 119049 | 2020-05-06 | Ripley | Indiana | 18137 | 99 | 6 |
116089 | 116089 | 2020-05-05 | Ripley | Indiana | 18137 | 98 | 6 |
113206 | 113206 | 2020-05-04 | Ripley | Indiana | 18137 | 97 | 6 |
110331 | 110331 | 2020-05-03 | Ripley | Indiana | 18137 | 94 | 6 |
107461 | 107461 | 2020-05-02 | Ripley | Indiana | 18137 | 94 | 6 |
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);