ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where county = "Fayette" and deaths = 6 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Fayette · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
716812 | 716812 | 2020-11-10 | Fayette | Iowa | 19065 | 672 | 6 |
713568 | 713568 | 2020-11-09 | Fayette | Iowa | 19065 | 635 | 6 |
710324 | 710324 | 2020-11-08 | Fayette | Iowa | 19065 | 594 | 6 |
707080 | 707080 | 2020-11-07 | Fayette | Iowa | 19065 | 560 | 6 |
703837 | 703837 | 2020-11-06 | Fayette | Iowa | 19065 | 544 | 6 |
700595 | 700595 | 2020-11-05 | Fayette | Iowa | 19065 | 527 | 6 |
697351 | 697351 | 2020-11-04 | Fayette | Iowa | 19065 | 511 | 6 |
694109 | 694109 | 2020-11-03 | Fayette | Iowa | 19065 | 489 | 6 |
607780 | 607780 | 2020-10-07 | Fayette | Ohio | 39047 | 318 | 6 |
604537 | 604537 | 2020-10-06 | Fayette | Ohio | 39047 | 301 | 6 |
601295 | 601295 | 2020-10-05 | Fayette | Ohio | 39047 | 293 | 6 |
598052 | 598052 | 2020-10-04 | Fayette | Ohio | 39047 | 279 | 6 |
594809 | 594809 | 2020-10-03 | Fayette | Ohio | 39047 | 271 | 6 |
591568 | 591568 | 2020-10-02 | Fayette | Ohio | 39047 | 259 | 6 |
588327 | 588327 | 2020-10-01 | Fayette | Ohio | 39047 | 256 | 6 |
583631 | 583631 | 2020-09-30 | Fayette | Illinois | 17051 | 437 | 6 |
585087 | 585087 | 2020-09-30 | Fayette | Ohio | 39047 | 245 | 6 |
581847 | 581847 | 2020-09-29 | Fayette | Ohio | 39047 | 234 | 6 |
578607 | 578607 | 2020-09-28 | Fayette | Ohio | 39047 | 233 | 6 |
575366 | 575366 | 2020-09-27 | Fayette | Ohio | 39047 | 232 | 6 |
572122 | 572122 | 2020-09-26 | Fayette | Ohio | 39047 | 231 | 6 |
568880 | 568880 | 2020-09-25 | Fayette | Ohio | 39047 | 230 | 6 |
565639 | 565639 | 2020-09-24 | Fayette | Ohio | 39047 | 228 | 6 |
562398 | 562398 | 2020-09-23 | Fayette | Ohio | 39047 | 227 | 6 |
559161 | 559161 | 2020-09-22 | Fayette | Ohio | 39047 | 226 | 6 |
555924 | 555924 | 2020-09-21 | Fayette | Ohio | 39047 | 226 | 6 |
552687 | 552687 | 2020-09-20 | Fayette | Ohio | 39047 | 225 | 6 |
549448 | 549448 | 2020-09-19 | Fayette | Ohio | 39047 | 225 | 6 |
546209 | 546209 | 2020-09-18 | Fayette | Ohio | 39047 | 223 | 6 |
542972 | 542972 | 2020-09-17 | Fayette | Ohio | 39047 | 223 | 6 |
539736 | 539736 | 2020-09-16 | Fayette | Ohio | 39047 | 221 | 6 |
518271 | 518271 | 2020-09-10 | Fayette | Alabama | 1057 | 367 | 6 |
515036 | 515036 | 2020-09-09 | Fayette | Alabama | 1057 | 358 | 6 |
511803 | 511803 | 2020-09-08 | Fayette | Alabama | 1057 | 356 | 6 |
514051 | 514051 | 2020-09-08 | Fayette | Pennsylvania | 42051 | 714 | 6 |
508570 | 508570 | 2020-09-07 | Fayette | Alabama | 1057 | 350 | 6 |
510818 | 510818 | 2020-09-07 | Fayette | Pennsylvania | 42051 | 715 | 6 |
505338 | 505338 | 2020-09-06 | Fayette | Alabama | 1057 | 348 | 6 |
507585 | 507585 | 2020-09-06 | Fayette | Pennsylvania | 42051 | 711 | 6 |
502104 | 502104 | 2020-09-05 | Fayette | Alabama | 1057 | 345 | 6 |
504353 | 504353 | 2020-09-05 | Fayette | Pennsylvania | 42051 | 708 | 6 |
498870 | 498870 | 2020-09-04 | Fayette | Alabama | 1057 | 341 | 6 |
501119 | 501119 | 2020-09-04 | Fayette | Pennsylvania | 42051 | 705 | 6 |
495637 | 495637 | 2020-09-03 | Fayette | Alabama | 1057 | 334 | 6 |
497885 | 497885 | 2020-09-03 | Fayette | Pennsylvania | 42051 | 703 | 6 |
492403 | 492403 | 2020-09-02 | Fayette | Alabama | 1057 | 327 | 6 |
494652 | 494652 | 2020-09-02 | Fayette | Pennsylvania | 42051 | 699 | 6 |
489170 | 489170 | 2020-09-01 | Fayette | Alabama | 1057 | 323 | 6 |
491418 | 491418 | 2020-09-01 | Fayette | Pennsylvania | 42051 | 694 | 6 |
485937 | 485937 | 2020-08-31 | Fayette | Alabama | 1057 | 315 | 6 |
488185 | 488185 | 2020-08-31 | Fayette | Pennsylvania | 42051 | 692 | 6 |
482702 | 482702 | 2020-08-30 | Fayette | Alabama | 1057 | 313 | 6 |
484952 | 484952 | 2020-08-30 | Fayette | Pennsylvania | 42051 | 689 | 6 |
479468 | 479468 | 2020-08-29 | Fayette | Alabama | 1057 | 311 | 6 |
481717 | 481717 | 2020-08-29 | Fayette | Pennsylvania | 42051 | 683 | 6 |
476235 | 476235 | 2020-08-28 | Fayette | Alabama | 1057 | 307 | 6 |
478483 | 478483 | 2020-08-28 | Fayette | Pennsylvania | 42051 | 681 | 6 |
473002 | 473002 | 2020-08-27 | Fayette | Alabama | 1057 | 301 | 6 |
475250 | 475250 | 2020-08-27 | Fayette | Pennsylvania | 42051 | 674 | 6 |
469770 | 469770 | 2020-08-26 | Fayette | Alabama | 1057 | 297 | 6 |
472016 | 472016 | 2020-08-26 | Fayette | Pennsylvania | 42051 | 665 | 6 |
466541 | 466541 | 2020-08-25 | Fayette | Alabama | 1057 | 293 | 6 |
468784 | 468784 | 2020-08-25 | Fayette | Pennsylvania | 42051 | 663 | 6 |
463312 | 463312 | 2020-08-24 | Fayette | Alabama | 1057 | 293 | 6 |
465556 | 465556 | 2020-08-24 | Fayette | Pennsylvania | 42051 | 661 | 6 |
460083 | 460083 | 2020-08-23 | Fayette | Alabama | 1057 | 291 | 6 |
462327 | 462327 | 2020-08-23 | Fayette | Pennsylvania | 42051 | 658 | 6 |
456856 | 456856 | 2020-08-22 | Fayette | Alabama | 1057 | 286 | 6 |
459099 | 459099 | 2020-08-22 | Fayette | Pennsylvania | 42051 | 656 | 6 |
453628 | 453628 | 2020-08-21 | Fayette | Alabama | 1057 | 281 | 6 |
455871 | 455871 | 2020-08-21 | Fayette | Pennsylvania | 42051 | 653 | 6 |
450400 | 450400 | 2020-08-20 | Fayette | Alabama | 1057 | 277 | 6 |
452643 | 452643 | 2020-08-20 | Fayette | Pennsylvania | 42051 | 644 | 6 |
447172 | 447172 | 2020-08-19 | Fayette | Alabama | 1057 | 274 | 6 |
449415 | 449415 | 2020-08-19 | Fayette | Pennsylvania | 42051 | 639 | 6 |
443945 | 443945 | 2020-08-18 | Fayette | Alabama | 1057 | 267 | 6 |
446187 | 446187 | 2020-08-18 | Fayette | Pennsylvania | 42051 | 631 | 6 |
442961 | 442961 | 2020-08-17 | Fayette | Pennsylvania | 42051 | 628 | 6 |
439734 | 439734 | 2020-08-16 | Fayette | Pennsylvania | 42051 | 624 | 6 |
436509 | 436509 | 2020-08-15 | Fayette | Pennsylvania | 42051 | 613 | 6 |
433282 | 433282 | 2020-08-14 | Fayette | Pennsylvania | 42051 | 609 | 6 |
430056 | 430056 | 2020-08-13 | Fayette | Pennsylvania | 42051 | 595 | 6 |
426831 | 426831 | 2020-08-12 | Fayette | Pennsylvania | 42051 | 582 | 6 |
423608 | 423608 | 2020-08-11 | Fayette | Pennsylvania | 42051 | 562 | 6 |
340340 | 340340 | 2020-07-16 | Fayette | Tennessee | 47047 | 424 | 6 |
337143 | 337143 | 2020-07-15 | Fayette | Tennessee | 47047 | 404 | 6 |
333949 | 333949 | 2020-07-14 | Fayette | Tennessee | 47047 | 393 | 6 |
36450 | 36450 | 2020-04-06 | Fayette | Kentucky | 21067 | 153 | 6 |
33992 | 33992 | 2020-04-05 | Fayette | Kentucky | 21067 | 153 | 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);