ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Fayette" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535248 | 535248 | 2020-09-15 | Fayette | Iowa | 19065 | 173 | 1 |
532013 | 532013 | 2020-09-14 | Fayette | Iowa | 19065 | 170 | 1 |
528776 | 528776 | 2020-09-13 | Fayette | Iowa | 19065 | 169 | 1 |
525540 | 525540 | 2020-09-12 | Fayette | Iowa | 19065 | 168 | 1 |
522304 | 522304 | 2020-09-11 | Fayette | Iowa | 19065 | 166 | 1 |
519067 | 519067 | 2020-09-10 | Fayette | Iowa | 19065 | 164 | 1 |
515832 | 515832 | 2020-09-09 | Fayette | Iowa | 19065 | 164 | 1 |
512599 | 512599 | 2020-09-08 | Fayette | Iowa | 19065 | 165 | 1 |
509366 | 509366 | 2020-09-07 | Fayette | Iowa | 19065 | 159 | 1 |
506134 | 506134 | 2020-09-06 | Fayette | Iowa | 19065 | 159 | 1 |
502900 | 502900 | 2020-09-05 | Fayette | Iowa | 19065 | 157 | 1 |
499666 | 499666 | 2020-09-04 | Fayette | Iowa | 19065 | 153 | 1 |
496433 | 496433 | 2020-09-03 | Fayette | Iowa | 19065 | 150 | 1 |
493199 | 493199 | 2020-09-02 | Fayette | Iowa | 19065 | 144 | 1 |
489966 | 489966 | 2020-09-01 | Fayette | Iowa | 19065 | 143 | 1 |
486733 | 486733 | 2020-08-31 | Fayette | Iowa | 19065 | 142 | 1 |
483498 | 483498 | 2020-08-30 | Fayette | Iowa | 19065 | 138 | 1 |
480264 | 480264 | 2020-08-29 | Fayette | Iowa | 19065 | 137 | 1 |
477031 | 477031 | 2020-08-28 | Fayette | Iowa | 19065 | 137 | 1 |
473798 | 473798 | 2020-08-27 | Fayette | Iowa | 19065 | 134 | 1 |
470566 | 470566 | 2020-08-26 | Fayette | Iowa | 19065 | 130 | 1 |
467337 | 467337 | 2020-08-25 | Fayette | Iowa | 19065 | 127 | 1 |
464108 | 464108 | 2020-08-24 | Fayette | Iowa | 19065 | 125 | 1 |
460879 | 460879 | 2020-08-23 | Fayette | Iowa | 19065 | 123 | 0 |
457652 | 457652 | 2020-08-22 | Fayette | Iowa | 19065 | 122 | 0 |
454424 | 454424 | 2020-08-21 | Fayette | Iowa | 19065 | 120 | 0 |
451196 | 451196 | 2020-08-20 | Fayette | Iowa | 19065 | 114 | 0 |
447968 | 447968 | 2020-08-19 | Fayette | Iowa | 19065 | 114 | 0 |
444741 | 444741 | 2020-08-18 | Fayette | Iowa | 19065 | 106 | 0 |
441515 | 441515 | 2020-08-17 | Fayette | Iowa | 19065 | 105 | 0 |
438289 | 438289 | 2020-08-16 | Fayette | Iowa | 19065 | 102 | 0 |
435063 | 435063 | 2020-08-15 | Fayette | Iowa | 19065 | 99 | 0 |
431838 | 431838 | 2020-08-14 | Fayette | Iowa | 19065 | 96 | 0 |
428610 | 428610 | 2020-08-13 | Fayette | Iowa | 19065 | 93 | 0 |
425386 | 425386 | 2020-08-12 | Fayette | Iowa | 19065 | 86 | 0 |
422165 | 422165 | 2020-08-11 | Fayette | Iowa | 19065 | 85 | 0 |
418942 | 418942 | 2020-08-10 | Fayette | Iowa | 19065 | 84 | 0 |
415721 | 415721 | 2020-08-09 | Fayette | Iowa | 19065 | 82 | 0 |
412501 | 412501 | 2020-08-08 | Fayette | Iowa | 19065 | 82 | 0 |
409282 | 409282 | 2020-08-07 | Fayette | Iowa | 19065 | 82 | 0 |
406062 | 406062 | 2020-08-06 | Fayette | Iowa | 19065 | 81 | 0 |
402844 | 402844 | 2020-08-05 | Fayette | Iowa | 19065 | 81 | 0 |
399628 | 399628 | 2020-08-04 | Fayette | Iowa | 19065 | 81 | 0 |
396412 | 396412 | 2020-08-03 | Fayette | Iowa | 19065 | 81 | 0 |
393196 | 393196 | 2020-08-02 | Fayette | Iowa | 19065 | 79 | 0 |
389979 | 389979 | 2020-08-01 | Fayette | Iowa | 19065 | 77 | 0 |
386762 | 386762 | 2020-07-31 | Fayette | Iowa | 19065 | 77 | 0 |
383544 | 383544 | 2020-07-30 | Fayette | Iowa | 19065 | 75 | 0 |
380327 | 380327 | 2020-07-29 | Fayette | Iowa | 19065 | 75 | 0 |
377110 | 377110 | 2020-07-28 | Fayette | Iowa | 19065 | 72 | 0 |
373895 | 373895 | 2020-07-27 | Fayette | Iowa | 19065 | 71 | 0 |
370683 | 370683 | 2020-07-26 | Fayette | Iowa | 19065 | 71 | 0 |
367473 | 367473 | 2020-07-25 | Fayette | Iowa | 19065 | 72 | 0 |
364266 | 364266 | 2020-07-24 | Fayette | Iowa | 19065 | 69 | 0 |
361059 | 361059 | 2020-07-23 | Fayette | Iowa | 19065 | 68 | 0 |
357854 | 357854 | 2020-07-22 | Fayette | Iowa | 19065 | 66 | 0 |
354652 | 354652 | 2020-07-21 | Fayette | Iowa | 19065 | 65 | 0 |
351450 | 351450 | 2020-07-20 | Fayette | Iowa | 19065 | 65 | 0 |
348250 | 348250 | 2020-07-19 | Fayette | Iowa | 19065 | 65 | 0 |
345049 | 345049 | 2020-07-18 | Fayette | Iowa | 19065 | 63 | 0 |
341849 | 341849 | 2020-07-17 | Fayette | Iowa | 19065 | 63 | 0 |
338653 | 338653 | 2020-07-16 | Fayette | Iowa | 19065 | 63 | 0 |
335457 | 335457 | 2020-07-15 | Fayette | Iowa | 19065 | 62 | 0 |
332264 | 332264 | 2020-07-14 | Fayette | Iowa | 19065 | 63 | 0 |
329077 | 329077 | 2020-07-13 | Fayette | Iowa | 19065 | 59 | 0 |
325891 | 325891 | 2020-07-12 | Fayette | Iowa | 19065 | 59 | 0 |
322710 | 322710 | 2020-07-11 | Fayette | Iowa | 19065 | 57 | 0 |
319531 | 319531 | 2020-07-10 | Fayette | Iowa | 19065 | 56 | 0 |
316358 | 316358 | 2020-07-09 | Fayette | Iowa | 19065 | 54 | 0 |
313184 | 313184 | 2020-07-08 | Fayette | Iowa | 19065 | 52 | 0 |
310014 | 310014 | 2020-07-07 | Fayette | Iowa | 19065 | 50 | 0 |
306846 | 306846 | 2020-07-06 | Fayette | Iowa | 19065 | 51 | 0 |
303681 | 303681 | 2020-07-05 | Fayette | Iowa | 19065 | 50 | 0 |
300517 | 300517 | 2020-07-04 | Fayette | Iowa | 19065 | 48 | 0 |
297355 | 297355 | 2020-07-03 | Fayette | Iowa | 19065 | 45 | 0 |
294197 | 294197 | 2020-07-02 | Fayette | Iowa | 19065 | 34 | 0 |
291043 | 291043 | 2020-07-01 | Fayette | Iowa | 19065 | 33 | 0 |
287893 | 287893 | 2020-06-30 | Fayette | Iowa | 19065 | 33 | 0 |
284744 | 284744 | 2020-06-29 | Fayette | Iowa | 19065 | 32 | 0 |
281599 | 281599 | 2020-06-28 | Fayette | Iowa | 19065 | 31 | 0 |
278451 | 278451 | 2020-06-27 | Fayette | Iowa | 19065 | 31 | 0 |
275303 | 275303 | 2020-06-26 | Fayette | Iowa | 19065 | 30 | 0 |
272161 | 272161 | 2020-06-25 | Fayette | Iowa | 19065 | 30 | 0 |
269024 | 269024 | 2020-06-24 | Fayette | Iowa | 19065 | 30 | 0 |
265894 | 265894 | 2020-06-23 | Fayette | Iowa | 19065 | 30 | 0 |
262766 | 262766 | 2020-06-22 | Fayette | Iowa | 19065 | 29 | 0 |
259639 | 259639 | 2020-06-21 | Fayette | Iowa | 19065 | 29 | 0 |
256513 | 256513 | 2020-06-20 | Fayette | Iowa | 19065 | 28 | 0 |
253393 | 253393 | 2020-06-19 | Fayette | Iowa | 19065 | 28 | 0 |
250278 | 250278 | 2020-06-18 | Fayette | Iowa | 19065 | 28 | 0 |
247166 | 247166 | 2020-06-17 | Fayette | Iowa | 19065 | 28 | 0 |
244053 | 244053 | 2020-06-16 | Fayette | Iowa | 19065 | 28 | 0 |
240942 | 240942 | 2020-06-15 | Fayette | Iowa | 19065 | 28 | 0 |
237834 | 237834 | 2020-06-14 | Fayette | Iowa | 19065 | 28 | 0 |
234727 | 234727 | 2020-06-13 | Fayette | Iowa | 19065 | 28 | 0 |
231621 | 231621 | 2020-06-12 | Fayette | Iowa | 19065 | 28 | 0 |
228518 | 228518 | 2020-06-11 | Fayette | Iowa | 19065 | 28 | 0 |
225416 | 225416 | 2020-06-10 | Fayette | Iowa | 19065 | 28 | 0 |
222321 | 222321 | 2020-06-09 | Fayette | Iowa | 19065 | 28 | 0 |
219226 | 219226 | 2020-06-08 | Fayette | Iowa | 19065 | 28 | 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);