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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
284744 | 284744 | 2020-06-29 | Fayette | Iowa | 19065 | 32 | 0 |
287893 | 287893 | 2020-06-30 | Fayette | Iowa | 19065 | 33 | 0 |
291043 | 291043 | 2020-07-01 | Fayette | Iowa | 19065 | 33 | 0 |
294197 | 294197 | 2020-07-02 | Fayette | Iowa | 19065 | 34 | 0 |
297355 | 297355 | 2020-07-03 | Fayette | Iowa | 19065 | 45 | 0 |
300517 | 300517 | 2020-07-04 | Fayette | Iowa | 19065 | 48 | 0 |
303681 | 303681 | 2020-07-05 | Fayette | Iowa | 19065 | 50 | 0 |
310014 | 310014 | 2020-07-07 | Fayette | Iowa | 19065 | 50 | 0 |
306846 | 306846 | 2020-07-06 | Fayette | Iowa | 19065 | 51 | 0 |
313184 | 313184 | 2020-07-08 | Fayette | Iowa | 19065 | 52 | 0 |
316358 | 316358 | 2020-07-09 | Fayette | Iowa | 19065 | 54 | 0 |
319531 | 319531 | 2020-07-10 | Fayette | Iowa | 19065 | 56 | 0 |
322710 | 322710 | 2020-07-11 | Fayette | Iowa | 19065 | 57 | 0 |
325891 | 325891 | 2020-07-12 | Fayette | Iowa | 19065 | 59 | 0 |
329077 | 329077 | 2020-07-13 | Fayette | Iowa | 19065 | 59 | 0 |
335457 | 335457 | 2020-07-15 | Fayette | Iowa | 19065 | 62 | 0 |
332264 | 332264 | 2020-07-14 | Fayette | Iowa | 19065 | 63 | 0 |
338653 | 338653 | 2020-07-16 | Fayette | Iowa | 19065 | 63 | 0 |
341849 | 341849 | 2020-07-17 | Fayette | Iowa | 19065 | 63 | 0 |
345049 | 345049 | 2020-07-18 | Fayette | Iowa | 19065 | 63 | 0 |
348250 | 348250 | 2020-07-19 | Fayette | Iowa | 19065 | 65 | 0 |
351450 | 351450 | 2020-07-20 | Fayette | Iowa | 19065 | 65 | 0 |
354652 | 354652 | 2020-07-21 | Fayette | Iowa | 19065 | 65 | 0 |
357854 | 357854 | 2020-07-22 | Fayette | Iowa | 19065 | 66 | 0 |
361059 | 361059 | 2020-07-23 | Fayette | Iowa | 19065 | 68 | 0 |
364266 | 364266 | 2020-07-24 | Fayette | Iowa | 19065 | 69 | 0 |
370683 | 370683 | 2020-07-26 | Fayette | Iowa | 19065 | 71 | 0 |
373895 | 373895 | 2020-07-27 | Fayette | Iowa | 19065 | 71 | 0 |
367473 | 367473 | 2020-07-25 | Fayette | Iowa | 19065 | 72 | 0 |
377110 | 377110 | 2020-07-28 | Fayette | Iowa | 19065 | 72 | 0 |
380327 | 380327 | 2020-07-29 | Fayette | Iowa | 19065 | 75 | 0 |
383544 | 383544 | 2020-07-30 | Fayette | Iowa | 19065 | 75 | 0 |
386762 | 386762 | 2020-07-31 | Fayette | Iowa | 19065 | 77 | 0 |
389979 | 389979 | 2020-08-01 | Fayette | Iowa | 19065 | 77 | 0 |
393196 | 393196 | 2020-08-02 | Fayette | Iowa | 19065 | 79 | 0 |
396412 | 396412 | 2020-08-03 | Fayette | Iowa | 19065 | 81 | 0 |
399628 | 399628 | 2020-08-04 | Fayette | Iowa | 19065 | 81 | 0 |
402844 | 402844 | 2020-08-05 | Fayette | Iowa | 19065 | 81 | 0 |
406062 | 406062 | 2020-08-06 | Fayette | Iowa | 19065 | 81 | 0 |
409282 | 409282 | 2020-08-07 | Fayette | Iowa | 19065 | 82 | 0 |
412501 | 412501 | 2020-08-08 | Fayette | Iowa | 19065 | 82 | 0 |
415721 | 415721 | 2020-08-09 | Fayette | Iowa | 19065 | 82 | 0 |
418942 | 418942 | 2020-08-10 | Fayette | Iowa | 19065 | 84 | 0 |
422165 | 422165 | 2020-08-11 | Fayette | Iowa | 19065 | 85 | 0 |
425386 | 425386 | 2020-08-12 | Fayette | Iowa | 19065 | 86 | 0 |
428610 | 428610 | 2020-08-13 | Fayette | Iowa | 19065 | 93 | 0 |
431838 | 431838 | 2020-08-14 | Fayette | Iowa | 19065 | 96 | 0 |
435063 | 435063 | 2020-08-15 | Fayette | Iowa | 19065 | 99 | 0 |
438289 | 438289 | 2020-08-16 | Fayette | Iowa | 19065 | 102 | 0 |
441515 | 441515 | 2020-08-17 | Fayette | Iowa | 19065 | 105 | 0 |
444741 | 444741 | 2020-08-18 | Fayette | Iowa | 19065 | 106 | 0 |
447968 | 447968 | 2020-08-19 | Fayette | Iowa | 19065 | 114 | 0 |
451196 | 451196 | 2020-08-20 | Fayette | Iowa | 19065 | 114 | 0 |
454424 | 454424 | 2020-08-21 | Fayette | Iowa | 19065 | 120 | 0 |
457652 | 457652 | 2020-08-22 | Fayette | Iowa | 19065 | 122 | 0 |
460879 | 460879 | 2020-08-23 | Fayette | Iowa | 19065 | 123 | 0 |
464108 | 464108 | 2020-08-24 | Fayette | Iowa | 19065 | 125 | 1 |
467337 | 467337 | 2020-08-25 | Fayette | Iowa | 19065 | 127 | 1 |
470566 | 470566 | 2020-08-26 | Fayette | Iowa | 19065 | 130 | 1 |
473798 | 473798 | 2020-08-27 | Fayette | Iowa | 19065 | 134 | 1 |
477031 | 477031 | 2020-08-28 | Fayette | Iowa | 19065 | 137 | 1 |
480264 | 480264 | 2020-08-29 | Fayette | Iowa | 19065 | 137 | 1 |
483498 | 483498 | 2020-08-30 | Fayette | Iowa | 19065 | 138 | 1 |
486733 | 486733 | 2020-08-31 | Fayette | Iowa | 19065 | 142 | 1 |
489966 | 489966 | 2020-09-01 | Fayette | Iowa | 19065 | 143 | 1 |
493199 | 493199 | 2020-09-02 | Fayette | Iowa | 19065 | 144 | 1 |
496433 | 496433 | 2020-09-03 | Fayette | Iowa | 19065 | 150 | 1 |
499666 | 499666 | 2020-09-04 | Fayette | Iowa | 19065 | 153 | 1 |
502900 | 502900 | 2020-09-05 | Fayette | Iowa | 19065 | 157 | 1 |
506134 | 506134 | 2020-09-06 | Fayette | Iowa | 19065 | 159 | 1 |
509366 | 509366 | 2020-09-07 | Fayette | Iowa | 19065 | 159 | 1 |
515832 | 515832 | 2020-09-09 | Fayette | Iowa | 19065 | 164 | 1 |
519067 | 519067 | 2020-09-10 | Fayette | Iowa | 19065 | 164 | 1 |
512599 | 512599 | 2020-09-08 | Fayette | Iowa | 19065 | 165 | 1 |
522304 | 522304 | 2020-09-11 | Fayette | Iowa | 19065 | 166 | 1 |
525540 | 525540 | 2020-09-12 | Fayette | Iowa | 19065 | 168 | 1 |
528776 | 528776 | 2020-09-13 | Fayette | Iowa | 19065 | 169 | 1 |
532013 | 532013 | 2020-09-14 | Fayette | Iowa | 19065 | 170 | 1 |
535248 | 535248 | 2020-09-15 | Fayette | Iowa | 19065 | 173 | 1 |
538484 | 538484 | 2020-09-16 | Fayette | Iowa | 19065 | 174 | 1 |
541721 | 541721 | 2020-09-17 | Fayette | Iowa | 19065 | 176 | 1 |
544957 | 544957 | 2020-09-18 | Fayette | Iowa | 19065 | 178 | 1 |
548195 | 548195 | 2020-09-19 | Fayette | Iowa | 19065 | 187 | 1 |
551434 | 551434 | 2020-09-20 | Fayette | Iowa | 19065 | 191 | 1 |
554673 | 554673 | 2020-09-21 | Fayette | Iowa | 19065 | 200 | 2 |
557910 | 557910 | 2020-09-22 | Fayette | Iowa | 19065 | 203 | 2 |
561146 | 561146 | 2020-09-23 | Fayette | Iowa | 19065 | 206 | 2 |
564386 | 564386 | 2020-09-24 | Fayette | Iowa | 19065 | 211 | 2 |
567626 | 567626 | 2020-09-25 | Fayette | Iowa | 19065 | 217 | 2 |
570868 | 570868 | 2020-09-26 | Fayette | Iowa | 19065 | 222 | 2 |
574111 | 574111 | 2020-09-27 | Fayette | Iowa | 19065 | 227 | 2 |
577353 | 577353 | 2020-09-28 | Fayette | Iowa | 19065 | 231 | 2 |
580594 | 580594 | 2020-09-29 | Fayette | Iowa | 19065 | 238 | 2 |
583833 | 583833 | 2020-09-30 | Fayette | Iowa | 19065 | 240 | 2 |
587073 | 587073 | 2020-10-01 | Fayette | Iowa | 19065 | 244 | 2 |
590314 | 590314 | 2020-10-02 | Fayette | Iowa | 19065 | 246 | 2 |
593555 | 593555 | 2020-10-03 | Fayette | Iowa | 19065 | 249 | 2 |
596797 | 596797 | 2020-10-04 | Fayette | Iowa | 19065 | 250 | 2 |
600039 | 600039 | 2020-10-05 | Fayette | Iowa | 19065 | 255 | 2 |
603282 | 603282 | 2020-10-06 | Fayette | Iowa | 19065 | 258 | 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);