ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Elmore" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293408 | 293408 | 2020-07-02 | Elmore | Alabama | 1051 | 849 | 14 |
293948 | 293948 | 2020-07-02 | Elmore | Idaho | 16039 | 63 | 2 |
290255 | 290255 | 2020-07-01 | Elmore | Alabama | 1051 | 829 | 14 |
290794 | 290794 | 2020-07-01 | Elmore | Idaho | 16039 | 62 | 2 |
287105 | 287105 | 2020-06-30 | Elmore | Alabama | 1051 | 822 | 14 |
287644 | 287644 | 2020-06-30 | Elmore | Idaho | 16039 | 60 | 2 |
283959 | 283959 | 2020-06-29 | Elmore | Alabama | 1051 | 811 | 14 |
284496 | 284496 | 2020-06-29 | Elmore | Idaho | 16039 | 54 | 2 |
280813 | 280813 | 2020-06-28 | Elmore | Alabama | 1051 | 789 | 13 |
281350 | 281350 | 2020-06-28 | Elmore | Idaho | 16039 | 52 | 2 |
277665 | 277665 | 2020-06-27 | Elmore | Alabama | 1051 | 786 | 13 |
278203 | 278203 | 2020-06-27 | Elmore | Idaho | 16039 | 52 | 2 |
274517 | 274517 | 2020-06-26 | Elmore | Alabama | 1051 | 758 | 13 |
275055 | 275055 | 2020-06-26 | Elmore | Idaho | 16039 | 50 | 2 |
271377 | 271377 | 2020-06-25 | Elmore | Alabama | 1051 | 744 | 12 |
271913 | 271913 | 2020-06-25 | Elmore | Idaho | 16039 | 47 | 2 |
268243 | 268243 | 2020-06-24 | Elmore | Alabama | 1051 | 720 | 12 |
268776 | 268776 | 2020-06-24 | Elmore | Idaho | 16039 | 47 | 2 |
265114 | 265114 | 2020-06-23 | Elmore | Alabama | 1051 | 702 | 12 |
265646 | 265646 | 2020-06-23 | Elmore | Idaho | 16039 | 43 | 2 |
261985 | 261985 | 2020-06-22 | Elmore | Alabama | 1051 | 690 | 11 |
262518 | 262518 | 2020-06-22 | Elmore | Idaho | 16039 | 42 | 2 |
258858 | 258858 | 2020-06-21 | Elmore | Alabama | 1051 | 673 | 11 |
259391 | 259391 | 2020-06-21 | Elmore | Idaho | 16039 | 39 | 2 |
255731 | 255731 | 2020-06-20 | Elmore | Alabama | 1051 | 663 | 11 |
256264 | 256264 | 2020-06-20 | Elmore | Idaho | 16039 | 39 | 2 |
252612 | 252612 | 2020-06-19 | Elmore | Alabama | 1051 | 646 | 11 |
253145 | 253145 | 2020-06-19 | Elmore | Idaho | 16039 | 38 | 2 |
249497 | 249497 | 2020-06-18 | Elmore | Alabama | 1051 | 616 | 10 |
250030 | 250030 | 2020-06-18 | Elmore | Idaho | 16039 | 37 | 2 |
246385 | 246385 | 2020-06-17 | Elmore | Alabama | 1051 | 589 | 10 |
246918 | 246918 | 2020-06-17 | Elmore | Idaho | 16039 | 37 | 2 |
243272 | 243272 | 2020-06-16 | Elmore | Alabama | 1051 | 581 | 10 |
243805 | 243805 | 2020-06-16 | Elmore | Idaho | 16039 | 37 | 2 |
240161 | 240161 | 2020-06-15 | Elmore | Alabama | 1051 | 560 | 9 |
240694 | 240694 | 2020-06-15 | Elmore | Idaho | 16039 | 35 | 2 |
237053 | 237053 | 2020-06-14 | Elmore | Alabama | 1051 | 541 | 9 |
237586 | 237586 | 2020-06-14 | Elmore | Idaho | 16039 | 34 | 2 |
233946 | 233946 | 2020-06-13 | Elmore | Alabama | 1051 | 515 | 9 |
234479 | 234479 | 2020-06-13 | Elmore | Idaho | 16039 | 34 | 2 |
230841 | 230841 | 2020-06-12 | Elmore | Alabama | 1051 | 498 | 9 |
231373 | 231373 | 2020-06-12 | Elmore | Idaho | 16039 | 34 | 2 |
227737 | 227737 | 2020-06-11 | Elmore | Alabama | 1051 | 483 | 9 |
228270 | 228270 | 2020-06-11 | Elmore | Idaho | 16039 | 34 | 2 |
224636 | 224636 | 2020-06-10 | Elmore | Alabama | 1051 | 459 | 9 |
225168 | 225168 | 2020-06-10 | Elmore | Idaho | 16039 | 33 | 2 |
221540 | 221540 | 2020-06-09 | Elmore | Alabama | 1051 | 449 | 10 |
222073 | 222073 | 2020-06-09 | Elmore | Idaho | 16039 | 33 | 2 |
218448 | 218448 | 2020-06-08 | Elmore | Alabama | 1051 | 438 | 10 |
218978 | 218978 | 2020-06-08 | Elmore | Idaho | 16039 | 32 | 2 |
215358 | 215358 | 2020-06-07 | Elmore | Alabama | 1051 | 422 | 10 |
215887 | 215887 | 2020-06-07 | Elmore | Idaho | 16039 | 32 | 2 |
212271 | 212271 | 2020-06-06 | Elmore | Alabama | 1051 | 412 | 10 |
212800 | 212800 | 2020-06-06 | Elmore | Idaho | 16039 | 32 | 2 |
209186 | 209186 | 2020-06-05 | Elmore | Alabama | 1051 | 392 | 10 |
209715 | 209715 | 2020-06-05 | Elmore | Idaho | 16039 | 32 | 2 |
206104 | 206104 | 2020-06-04 | Elmore | Alabama | 1051 | 385 | 9 |
206634 | 206634 | 2020-06-04 | Elmore | Idaho | 16039 | 32 | 2 |
203025 | 203025 | 2020-06-03 | Elmore | Alabama | 1051 | 383 | 9 |
203554 | 203554 | 2020-06-03 | Elmore | Idaho | 16039 | 32 | 2 |
199949 | 199949 | 2020-06-02 | Elmore | Alabama | 1051 | 384 | 9 |
200478 | 200478 | 2020-06-02 | Elmore | Idaho | 16039 | 31 | 2 |
196876 | 196876 | 2020-06-01 | Elmore | Alabama | 1051 | 373 | 8 |
197405 | 197405 | 2020-06-01 | Elmore | Idaho | 16039 | 31 | 2 |
193806 | 193806 | 2020-05-31 | Elmore | Alabama | 1051 | 354 | 8 |
194335 | 194335 | 2020-05-31 | Elmore | Idaho | 16039 | 31 | 2 |
190740 | 190740 | 2020-05-30 | Elmore | Alabama | 1051 | 339 | 8 |
191268 | 191268 | 2020-05-30 | Elmore | Idaho | 16039 | 31 | 2 |
187676 | 187676 | 2020-05-29 | Elmore | Alabama | 1051 | 323 | 7 |
188203 | 188203 | 2020-05-29 | Elmore | Idaho | 16039 | 31 | 2 |
184619 | 184619 | 2020-05-28 | Elmore | Alabama | 1051 | 313 | 7 |
185147 | 185147 | 2020-05-28 | Elmore | Idaho | 16039 | 31 | 2 |
181567 | 181567 | 2020-05-27 | Elmore | Alabama | 1051 | 300 | 7 |
182093 | 182093 | 2020-05-27 | Elmore | Idaho | 16039 | 31 | 2 |
178523 | 178523 | 2020-05-26 | Elmore | Alabama | 1051 | 292 | 7 |
179049 | 179049 | 2020-05-26 | Elmore | Idaho | 16039 | 31 | 2 |
175478 | 175478 | 2020-05-25 | Elmore | Alabama | 1051 | 270 | 7 |
176005 | 176005 | 2020-05-25 | Elmore | Idaho | 16039 | 31 | 2 |
172435 | 172435 | 2020-05-24 | Elmore | Alabama | 1051 | 263 | 7 |
172961 | 172961 | 2020-05-24 | Elmore | Idaho | 16039 | 31 | 2 |
169394 | 169394 | 2020-05-23 | Elmore | Alabama | 1051 | 255 | 7 |
169920 | 169920 | 2020-05-23 | Elmore | Idaho | 16039 | 31 | 2 |
166358 | 166358 | 2020-05-22 | Elmore | Alabama | 1051 | 242 | 7 |
166883 | 166883 | 2020-05-22 | Elmore | Idaho | 16039 | 31 | 2 |
163326 | 163326 | 2020-05-21 | Elmore | Alabama | 1051 | 238 | 7 |
163850 | 163850 | 2020-05-21 | Elmore | Idaho | 16039 | 31 | 2 |
160298 | 160298 | 2020-05-20 | Elmore | Alabama | 1051 | 226 | 7 |
160822 | 160822 | 2020-05-20 | Elmore | Idaho | 16039 | 31 | 2 |
157274 | 157274 | 2020-05-19 | Elmore | Alabama | 1051 | 207 | 6 |
157796 | 157796 | 2020-05-19 | Elmore | Idaho | 16039 | 31 | 2 |
154258 | 154258 | 2020-05-18 | Elmore | Alabama | 1051 | 197 | 6 |
154780 | 154780 | 2020-05-18 | Elmore | Idaho | 16039 | 31 | 2 |
151246 | 151246 | 2020-05-17 | Elmore | Alabama | 1051 | 192 | 6 |
151768 | 151768 | 2020-05-17 | Elmore | Idaho | 16039 | 31 | 2 |
148237 | 148237 | 2020-05-16 | Elmore | Alabama | 1051 | 188 | 6 |
148759 | 148759 | 2020-05-16 | Elmore | Idaho | 16039 | 31 | 2 |
145234 | 145234 | 2020-05-15 | Elmore | Alabama | 1051 | 178 | 6 |
145756 | 145756 | 2020-05-15 | Elmore | Idaho | 16039 | 31 | 2 |
142235 | 142235 | 2020-05-14 | Elmore | Alabama | 1051 | 169 | 6 |
142756 | 142756 | 2020-05-14 | Elmore | Idaho | 16039 | 31 | 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);