ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Decatur" and state = "Iowa" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
182332 | 182332 | 2020-05-27 | Decatur | Iowa | 19053 | 1 | 0 |
185386 | 185386 | 2020-05-28 | Decatur | Iowa | 19053 | 1 | 0 |
188444 | 188444 | 2020-05-29 | Decatur | Iowa | 19053 | 1 | 0 |
191509 | 191509 | 2020-05-30 | Decatur | Iowa | 19053 | 1 | 0 |
194576 | 194576 | 2020-05-31 | Decatur | Iowa | 19053 | 1 | 0 |
197646 | 197646 | 2020-06-01 | Decatur | Iowa | 19053 | 1 | 0 |
200719 | 200719 | 2020-06-02 | Decatur | Iowa | 19053 | 1 | 0 |
203795 | 203795 | 2020-06-03 | Decatur | Iowa | 19053 | 1 | 0 |
206875 | 206875 | 2020-06-04 | Decatur | Iowa | 19053 | 1 | 0 |
209956 | 209956 | 2020-06-05 | Decatur | Iowa | 19053 | 2 | 0 |
213041 | 213041 | 2020-06-06 | Decatur | Iowa | 19053 | 2 | 0 |
216128 | 216128 | 2020-06-07 | Decatur | Iowa | 19053 | 2 | 0 |
219220 | 219220 | 2020-06-08 | Decatur | Iowa | 19053 | 3 | 0 |
222315 | 222315 | 2020-06-09 | Decatur | Iowa | 19053 | 3 | 0 |
225410 | 225410 | 2020-06-10 | Decatur | Iowa | 19053 | 3 | 0 |
228512 | 228512 | 2020-06-11 | Decatur | Iowa | 19053 | 3 | 0 |
231615 | 231615 | 2020-06-12 | Decatur | Iowa | 19053 | 4 | 0 |
234721 | 234721 | 2020-06-13 | Decatur | Iowa | 19053 | 4 | 0 |
237828 | 237828 | 2020-06-14 | Decatur | Iowa | 19053 | 4 | 0 |
240936 | 240936 | 2020-06-15 | Decatur | Iowa | 19053 | 8 | 0 |
244047 | 244047 | 2020-06-16 | Decatur | Iowa | 19053 | 9 | 0 |
247160 | 247160 | 2020-06-17 | Decatur | Iowa | 19053 | 8 | 0 |
250272 | 250272 | 2020-06-18 | Decatur | Iowa | 19053 | 8 | 0 |
253387 | 253387 | 2020-06-19 | Decatur | Iowa | 19053 | 9 | 0 |
256507 | 256507 | 2020-06-20 | Decatur | Iowa | 19053 | 9 | 0 |
259633 | 259633 | 2020-06-21 | Decatur | Iowa | 19053 | 9 | 0 |
262760 | 262760 | 2020-06-22 | Decatur | Iowa | 19053 | 9 | 0 |
265888 | 265888 | 2020-06-23 | Decatur | Iowa | 19053 | 9 | 0 |
269018 | 269018 | 2020-06-24 | Decatur | Iowa | 19053 | 9 | 0 |
272155 | 272155 | 2020-06-25 | Decatur | Iowa | 19053 | 9 | 0 |
275297 | 275297 | 2020-06-26 | Decatur | Iowa | 19053 | 9 | 0 |
278445 | 278445 | 2020-06-27 | Decatur | Iowa | 19053 | 9 | 0 |
281593 | 281593 | 2020-06-28 | Decatur | Iowa | 19053 | 9 | 0 |
284738 | 284738 | 2020-06-29 | Decatur | Iowa | 19053 | 9 | 0 |
287887 | 287887 | 2020-06-30 | Decatur | Iowa | 19053 | 10 | 0 |
291037 | 291037 | 2020-07-01 | Decatur | Iowa | 19053 | 10 | 0 |
294191 | 294191 | 2020-07-02 | Decatur | Iowa | 19053 | 11 | 0 |
297349 | 297349 | 2020-07-03 | Decatur | Iowa | 19053 | 11 | 0 |
300511 | 300511 | 2020-07-04 | Decatur | Iowa | 19053 | 11 | 0 |
303675 | 303675 | 2020-07-05 | Decatur | Iowa | 19053 | 11 | 0 |
306840 | 306840 | 2020-07-06 | Decatur | Iowa | 19053 | 12 | 0 |
310008 | 310008 | 2020-07-07 | Decatur | Iowa | 19053 | 12 | 0 |
313178 | 313178 | 2020-07-08 | Decatur | Iowa | 19053 | 12 | 0 |
316352 | 316352 | 2020-07-09 | Decatur | Iowa | 19053 | 12 | 0 |
319525 | 319525 | 2020-07-10 | Decatur | Iowa | 19053 | 13 | 0 |
322704 | 322704 | 2020-07-11 | Decatur | Iowa | 19053 | 13 | 0 |
325885 | 325885 | 2020-07-12 | Decatur | Iowa | 19053 | 13 | 0 |
329071 | 329071 | 2020-07-13 | Decatur | Iowa | 19053 | 13 | 0 |
332258 | 332258 | 2020-07-14 | Decatur | Iowa | 19053 | 13 | 0 |
335451 | 335451 | 2020-07-15 | Decatur | Iowa | 19053 | 14 | 0 |
338647 | 338647 | 2020-07-16 | Decatur | Iowa | 19053 | 15 | 0 |
341843 | 341843 | 2020-07-17 | Decatur | Iowa | 19053 | 15 | 0 |
345043 | 345043 | 2020-07-18 | Decatur | Iowa | 19053 | 15 | 0 |
348244 | 348244 | 2020-07-19 | Decatur | Iowa | 19053 | 15 | 0 |
351444 | 351444 | 2020-07-20 | Decatur | Iowa | 19053 | 16 | 0 |
354646 | 354646 | 2020-07-21 | Decatur | Iowa | 19053 | 15 | 0 |
357848 | 357848 | 2020-07-22 | Decatur | Iowa | 19053 | 15 | 0 |
361053 | 361053 | 2020-07-23 | Decatur | Iowa | 19053 | 17 | 0 |
364260 | 364260 | 2020-07-24 | Decatur | Iowa | 19053 | 17 | 0 |
367467 | 367467 | 2020-07-25 | Decatur | Iowa | 19053 | 17 | 0 |
370677 | 370677 | 2020-07-26 | Decatur | Iowa | 19053 | 17 | 0 |
373889 | 373889 | 2020-07-27 | Decatur | Iowa | 19053 | 17 | 0 |
377104 | 377104 | 2020-07-28 | Decatur | Iowa | 19053 | 17 | 0 |
380321 | 380321 | 2020-07-29 | Decatur | Iowa | 19053 | 17 | 0 |
383538 | 383538 | 2020-07-30 | Decatur | Iowa | 19053 | 20 | 0 |
386756 | 386756 | 2020-07-31 | Decatur | Iowa | 19053 | 21 | 0 |
389973 | 389973 | 2020-08-01 | Decatur | Iowa | 19053 | 21 | 0 |
393190 | 393190 | 2020-08-02 | Decatur | Iowa | 19053 | 21 | 0 |
396406 | 396406 | 2020-08-03 | Decatur | Iowa | 19053 | 22 | 0 |
399622 | 399622 | 2020-08-04 | Decatur | Iowa | 19053 | 22 | 0 |
402838 | 402838 | 2020-08-05 | Decatur | Iowa | 19053 | 23 | 0 |
406056 | 406056 | 2020-08-06 | Decatur | Iowa | 19053 | 23 | 0 |
409276 | 409276 | 2020-08-07 | Decatur | Iowa | 19053 | 23 | 0 |
412495 | 412495 | 2020-08-08 | Decatur | Iowa | 19053 | 23 | 0 |
415715 | 415715 | 2020-08-09 | Decatur | Iowa | 19053 | 23 | 0 |
418936 | 418936 | 2020-08-10 | Decatur | Iowa | 19053 | 23 | 0 |
422159 | 422159 | 2020-08-11 | Decatur | Iowa | 19053 | 25 | 0 |
425380 | 425380 | 2020-08-12 | Decatur | Iowa | 19053 | 26 | 0 |
428604 | 428604 | 2020-08-13 | Decatur | Iowa | 19053 | 27 | 0 |
431832 | 431832 | 2020-08-14 | Decatur | Iowa | 19053 | 28 | 0 |
435057 | 435057 | 2020-08-15 | Decatur | Iowa | 19053 | 29 | 0 |
438283 | 438283 | 2020-08-16 | Decatur | Iowa | 19053 | 29 | 0 |
441509 | 441509 | 2020-08-17 | Decatur | Iowa | 19053 | 30 | 0 |
444735 | 444735 | 2020-08-18 | Decatur | Iowa | 19053 | 31 | 0 |
447962 | 447962 | 2020-08-19 | Decatur | Iowa | 19053 | 31 | 0 |
451190 | 451190 | 2020-08-20 | Decatur | Iowa | 19053 | 32 | 0 |
454418 | 454418 | 2020-08-21 | Decatur | Iowa | 19053 | 32 | 0 |
457646 | 457646 | 2020-08-22 | Decatur | Iowa | 19053 | 32 | 0 |
460873 | 460873 | 2020-08-23 | Decatur | Iowa | 19053 | 33 | 0 |
464102 | 464102 | 2020-08-24 | Decatur | Iowa | 19053 | 36 | 0 |
467331 | 467331 | 2020-08-25 | Decatur | Iowa | 19053 | 37 | 0 |
470560 | 470560 | 2020-08-26 | Decatur | Iowa | 19053 | 38 | 0 |
473792 | 473792 | 2020-08-27 | Decatur | Iowa | 19053 | 43 | 0 |
477025 | 477025 | 2020-08-28 | Decatur | Iowa | 19053 | 43 | 0 |
480258 | 480258 | 2020-08-29 | Decatur | Iowa | 19053 | 43 | 0 |
483492 | 483492 | 2020-08-30 | Decatur | Iowa | 19053 | 44 | 0 |
486727 | 486727 | 2020-08-31 | Decatur | Iowa | 19053 | 44 | 0 |
489960 | 489960 | 2020-09-01 | Decatur | Iowa | 19053 | 46 | 0 |
493193 | 493193 | 2020-09-02 | Decatur | Iowa | 19053 | 47 | 0 |
496427 | 496427 | 2020-09-03 | Decatur | Iowa | 19053 | 48 | 0 |
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);