ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,612 rows where county = "Fayette" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534867 | 534867 | 2020-09-15 | Fayette | Georgia | 13113 | 1693 | 47 |
535046 | 535046 | 2020-09-15 | Fayette | Illinois | 17051 | 266 | 3 |
535144 | 535144 | 2020-09-15 | Fayette | Indiana | 18041 | 508 | 13 |
535248 | 535248 | 2020-09-15 | Fayette | Iowa | 19065 | 173 | 1 |
535454 | 535454 | 2020-09-15 | Fayette | Kentucky | 21067 | 7296 | 70 |
536499 | 536499 | 2020-09-15 | Fayette | Ohio | 39047 | 221 | 5 |
536702 | 536702 | 2020-09-15 | Fayette | Pennsylvania | 42051 | 750 | 7 |
536964 | 536964 | 2020-09-15 | Fayette | Tennessee | 47047 | 1063 | 16 |
537110 | 537110 | 2020-09-15 | Fayette | Texas | 48149 | 426 | 18 |
537518 | 537518 | 2020-09-15 | Fayette | West Virginia | 54019 | 481 | 10 |
531217 | 531217 | 2020-09-14 | Fayette | Alabama | 1057 | 400 | 7 |
531632 | 531632 | 2020-09-14 | Fayette | Georgia | 13113 | 1681 | 45 |
531811 | 531811 | 2020-09-14 | Fayette | Illinois | 17051 | 260 | 3 |
531909 | 531909 | 2020-09-14 | Fayette | Indiana | 18041 | 506 | 13 |
532013 | 532013 | 2020-09-14 | Fayette | Iowa | 19065 | 170 | 1 |
532219 | 532219 | 2020-09-14 | Fayette | Kentucky | 21067 | 7200 | 70 |
533263 | 533263 | 2020-09-14 | Fayette | Ohio | 39047 | 219 | 5 |
533466 | 533466 | 2020-09-14 | Fayette | Pennsylvania | 42051 | 747 | 7 |
533728 | 533728 | 2020-09-14 | Fayette | Tennessee | 47047 | 1063 | 14 |
533874 | 533874 | 2020-09-14 | Fayette | Texas | 48149 | 396 | 18 |
534282 | 534282 | 2020-09-14 | Fayette | West Virginia | 54019 | 475 | 10 |
527980 | 527980 | 2020-09-13 | Fayette | Alabama | 1057 | 396 | 7 |
528395 | 528395 | 2020-09-13 | Fayette | Georgia | 13113 | 1675 | 45 |
528574 | 528574 | 2020-09-13 | Fayette | Illinois | 17051 | 255 | 3 |
528672 | 528672 | 2020-09-13 | Fayette | Indiana | 18041 | 503 | 13 |
528776 | 528776 | 2020-09-13 | Fayette | Iowa | 19065 | 169 | 1 |
528982 | 528982 | 2020-09-13 | Fayette | Kentucky | 21067 | 7000 | 69 |
530028 | 530028 | 2020-09-13 | Fayette | Ohio | 39047 | 217 | 5 |
530231 | 530231 | 2020-09-13 | Fayette | Pennsylvania | 42051 | 740 | 7 |
530493 | 530493 | 2020-09-13 | Fayette | Tennessee | 47047 | 1040 | 14 |
530639 | 530639 | 2020-09-13 | Fayette | Texas | 48149 | 396 | 18 |
531047 | 531047 | 2020-09-13 | Fayette | West Virginia | 54019 | 470 | 10 |
524744 | 524744 | 2020-09-12 | Fayette | Alabama | 1057 | 383 | 7 |
525159 | 525159 | 2020-09-12 | Fayette | Georgia | 13113 | 1667 | 45 |
525338 | 525338 | 2020-09-12 | Fayette | Illinois | 17051 | 246 | 3 |
525436 | 525436 | 2020-09-12 | Fayette | Indiana | 18041 | 503 | 13 |
525540 | 525540 | 2020-09-12 | Fayette | Iowa | 19065 | 168 | 1 |
525746 | 525746 | 2020-09-12 | Fayette | Kentucky | 21067 | 7000 | 69 |
526791 | 526791 | 2020-09-12 | Fayette | Ohio | 39047 | 215 | 5 |
526994 | 526994 | 2020-09-12 | Fayette | Pennsylvania | 42051 | 740 | 7 |
527256 | 527256 | 2020-09-12 | Fayette | Tennessee | 47047 | 1039 | 14 |
527402 | 527402 | 2020-09-12 | Fayette | Texas | 48149 | 396 | 18 |
527810 | 527810 | 2020-09-12 | Fayette | West Virginia | 54019 | 450 | 10 |
521508 | 521508 | 2020-09-11 | Fayette | Alabama | 1057 | 376 | 7 |
521923 | 521923 | 2020-09-11 | Fayette | Georgia | 13113 | 1657 | 44 |
522102 | 522102 | 2020-09-11 | Fayette | Illinois | 17051 | 243 | 3 |
522200 | 522200 | 2020-09-11 | Fayette | Indiana | 18041 | 497 | 13 |
522304 | 522304 | 2020-09-11 | Fayette | Iowa | 19065 | 166 | 1 |
522510 | 522510 | 2020-09-11 | Fayette | Kentucky | 21067 | 6833 | 66 |
523555 | 523555 | 2020-09-11 | Fayette | Ohio | 39047 | 213 | 5 |
523758 | 523758 | 2020-09-11 | Fayette | Pennsylvania | 42051 | 733 | 7 |
524020 | 524020 | 2020-09-11 | Fayette | Tennessee | 47047 | 1030 | 14 |
524166 | 524166 | 2020-09-11 | Fayette | Texas | 48149 | 392 | 18 |
524574 | 524574 | 2020-09-11 | Fayette | West Virginia | 54019 | 439 | 10 |
518271 | 518271 | 2020-09-10 | Fayette | Alabama | 1057 | 367 | 6 |
518686 | 518686 | 2020-09-10 | Fayette | Georgia | 13113 | 1653 | 44 |
518865 | 518865 | 2020-09-10 | Fayette | Illinois | 17051 | 227 | 3 |
518963 | 518963 | 2020-09-10 | Fayette | Indiana | 18041 | 482 | 12 |
519067 | 519067 | 2020-09-10 | Fayette | Iowa | 19065 | 164 | 1 |
519273 | 519273 | 2020-09-10 | Fayette | Kentucky | 21067 | 6684 | 66 |
520319 | 520319 | 2020-09-10 | Fayette | Ohio | 39047 | 210 | 5 |
520522 | 520522 | 2020-09-10 | Fayette | Pennsylvania | 42051 | 728 | 7 |
520784 | 520784 | 2020-09-10 | Fayette | Tennessee | 47047 | 1021 | 13 |
520930 | 520930 | 2020-09-10 | Fayette | Texas | 48149 | 382 | 18 |
521338 | 521338 | 2020-09-10 | Fayette | West Virginia | 54019 | 432 | 9 |
515036 | 515036 | 2020-09-09 | Fayette | Alabama | 1057 | 358 | 6 |
515451 | 515451 | 2020-09-09 | Fayette | Georgia | 13113 | 1644 | 43 |
515630 | 515630 | 2020-09-09 | Fayette | Illinois | 17051 | 217 | 3 |
515728 | 515728 | 2020-09-09 | Fayette | Indiana | 18041 | 482 | 12 |
515832 | 515832 | 2020-09-09 | Fayette | Iowa | 19065 | 164 | 1 |
516038 | 516038 | 2020-09-09 | Fayette | Kentucky | 21067 | 6561 | 63 |
517083 | 517083 | 2020-09-09 | Fayette | Ohio | 39047 | 209 | 5 |
517286 | 517286 | 2020-09-09 | Fayette | Pennsylvania | 42051 | 722 | 7 |
517548 | 517548 | 2020-09-09 | Fayette | Tennessee | 47047 | 1008 | 12 |
517694 | 517694 | 2020-09-09 | Fayette | Texas | 48149 | 382 | 18 |
518101 | 518101 | 2020-09-09 | Fayette | West Virginia | 54019 | 421 | 9 |
511803 | 511803 | 2020-09-08 | Fayette | Alabama | 1057 | 356 | 6 |
512218 | 512218 | 2020-09-08 | Fayette | Georgia | 13113 | 1632 | 43 |
512397 | 512397 | 2020-09-08 | Fayette | Illinois | 17051 | 217 | 3 |
512495 | 512495 | 2020-09-08 | Fayette | Indiana | 18041 | 476 | 10 |
512599 | 512599 | 2020-09-08 | Fayette | Iowa | 19065 | 165 | 1 |
512805 | 512805 | 2020-09-08 | Fayette | Kentucky | 21067 | 6499 | 61 |
513848 | 513848 | 2020-09-08 | Fayette | Ohio | 39047 | 208 | 5 |
514051 | 514051 | 2020-09-08 | Fayette | Pennsylvania | 42051 | 714 | 6 |
514313 | 514313 | 2020-09-08 | Fayette | Tennessee | 47047 | 1008 | 12 |
514459 | 514459 | 2020-09-08 | Fayette | Texas | 48149 | 379 | 18 |
514866 | 514866 | 2020-09-08 | Fayette | West Virginia | 54019 | 420 | 8 |
508570 | 508570 | 2020-09-07 | Fayette | Alabama | 1057 | 350 | 6 |
508985 | 508985 | 2020-09-07 | Fayette | Georgia | 13113 | 1628 | 43 |
509164 | 509164 | 2020-09-07 | Fayette | Illinois | 17051 | 214 | 3 |
509262 | 509262 | 2020-09-07 | Fayette | Indiana | 18041 | 474 | 10 |
509366 | 509366 | 2020-09-07 | Fayette | Iowa | 19065 | 159 | 1 |
509573 | 509573 | 2020-09-07 | Fayette | Kentucky | 21067 | 6450 | 61 |
510615 | 510615 | 2020-09-07 | Fayette | Ohio | 39047 | 207 | 5 |
510818 | 510818 | 2020-09-07 | Fayette | Pennsylvania | 42051 | 715 | 6 |
511080 | 511080 | 2020-09-07 | Fayette | Tennessee | 47047 | 1005 | 11 |
511226 | 511226 | 2020-09-07 | Fayette | Texas | 48149 | 379 | 18 |
511633 | 511633 | 2020-09-07 | Fayette | West Virginia | 54019 | 421 | 9 |
505338 | 505338 | 2020-09-06 | Fayette | Alabama | 1057 | 348 | 6 |
505753 | 505753 | 2020-09-06 | Fayette | Georgia | 13113 | 1628 | 43 |
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);