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 |
---|---|---|---|---|---|---|---|
635330 | 635330 | 2020-10-16 | Fayette | Georgia | 13113 | 2288 | 52 |
635509 | 635509 | 2020-10-16 | Fayette | Illinois | 17051 | 597 | 17 |
635607 | 635607 | 2020-10-16 | Fayette | Indiana | 18041 | 650 | 15 |
635711 | 635711 | 2020-10-16 | Fayette | Iowa | 19065 | 329 | 2 |
635918 | 635918 | 2020-10-16 | Fayette | Kentucky | 21067 | 9722 | 86 |
636967 | 636967 | 2020-10-16 | Fayette | Ohio | 39047 | 407 | 8 |
637171 | 637171 | 2020-10-16 | Fayette | Pennsylvania | 42051 | 911 | 10 |
637433 | 637433 | 2020-10-16 | Fayette | Tennessee | 47047 | 1456 | 21 |
637579 | 637579 | 2020-10-16 | Fayette | Texas | 48149 | 509 | 22 |
637988 | 637988 | 2020-10-16 | Fayette | West Virginia | 54019 | 705 | 19 |
631668 | 631668 | 2020-10-15 | Fayette | Alabama | 1057 | 525 | 11 |
632084 | 632084 | 2020-10-15 | Fayette | Georgia | 13113 | 2281 | 52 |
632263 | 632263 | 2020-10-15 | Fayette | Illinois | 17051 | 589 | 16 |
632361 | 632361 | 2020-10-15 | Fayette | Indiana | 18041 | 642 | 15 |
632465 | 632465 | 2020-10-15 | Fayette | Iowa | 19065 | 321 | 2 |
632672 | 632672 | 2020-10-15 | Fayette | Kentucky | 21067 | 9589 | 85 |
633721 | 633721 | 2020-10-15 | Fayette | Ohio | 39047 | 397 | 8 |
633925 | 633925 | 2020-10-15 | Fayette | Pennsylvania | 42051 | 899 | 10 |
634187 | 634187 | 2020-10-15 | Fayette | Tennessee | 47047 | 1453 | 21 |
634334 | 634334 | 2020-10-15 | Fayette | Texas | 48149 | 505 | 21 |
634743 | 634743 | 2020-10-15 | Fayette | West Virginia | 54019 | 697 | 18 |
628424 | 628424 | 2020-10-14 | Fayette | Alabama | 1057 | 520 | 10 |
628840 | 628840 | 2020-10-14 | Fayette | Georgia | 13113 | 2263 | 51 |
629019 | 629019 | 2020-10-14 | Fayette | Illinois | 17051 | 574 | 15 |
629117 | 629117 | 2020-10-14 | Fayette | Indiana | 18041 | 635 | 14 |
629221 | 629221 | 2020-10-14 | Fayette | Iowa | 19065 | 309 | 2 |
629428 | 629428 | 2020-10-14 | Fayette | Kentucky | 21067 | 9518 | 84 |
630476 | 630476 | 2020-10-14 | Fayette | Ohio | 39047 | 386 | 7 |
630680 | 630680 | 2020-10-14 | Fayette | Pennsylvania | 42051 | 886 | 9 |
630942 | 630942 | 2020-10-14 | Fayette | Tennessee | 47047 | 1432 | 21 |
631089 | 631089 | 2020-10-14 | Fayette | Texas | 48149 | 504 | 21 |
631498 | 631498 | 2020-10-14 | Fayette | West Virginia | 54019 | 695 | 18 |
625181 | 625181 | 2020-10-13 | Fayette | Alabama | 1057 | 518 | 10 |
625597 | 625597 | 2020-10-13 | Fayette | Georgia | 13113 | 2255 | 52 |
625776 | 625776 | 2020-10-13 | Fayette | Illinois | 17051 | 550 | 15 |
625874 | 625874 | 2020-10-13 | Fayette | Indiana | 18041 | 629 | 14 |
625978 | 625978 | 2020-10-13 | Fayette | Iowa | 19065 | 301 | 2 |
626184 | 626184 | 2020-10-13 | Fayette | Kentucky | 21067 | 9445 | 84 |
627232 | 627232 | 2020-10-13 | Fayette | Ohio | 39047 | 371 | 7 |
627436 | 627436 | 2020-10-13 | Fayette | Pennsylvania | 42051 | 883 | 9 |
627698 | 627698 | 2020-10-13 | Fayette | Tennessee | 47047 | 1414 | 23 |
627845 | 627845 | 2020-10-13 | Fayette | Texas | 48149 | 499 | 21 |
628254 | 628254 | 2020-10-13 | Fayette | West Virginia | 54019 | 694 | 18 |
621938 | 621938 | 2020-10-12 | Fayette | Alabama | 1057 | 515 | 10 |
622354 | 622354 | 2020-10-12 | Fayette | Georgia | 13113 | 2242 | 51 |
622534 | 622534 | 2020-10-12 | Fayette | Illinois | 17051 | 547 | 14 |
622632 | 622632 | 2020-10-12 | Fayette | Indiana | 18041 | 623 | 14 |
622736 | 622736 | 2020-10-12 | Fayette | Iowa | 19065 | 290 | 2 |
622942 | 622942 | 2020-10-12 | Fayette | Kentucky | 21067 | 9385 | 82 |
623990 | 623990 | 2020-10-12 | Fayette | Ohio | 39047 | 360 | 7 |
624194 | 624194 | 2020-10-12 | Fayette | Pennsylvania | 42051 | 869 | 9 |
624456 | 624456 | 2020-10-12 | Fayette | Tennessee | 47047 | 1404 | 23 |
624603 | 624603 | 2020-10-12 | Fayette | Texas | 48149 | 496 | 21 |
625011 | 625011 | 2020-10-12 | Fayette | West Virginia | 54019 | 691 | 18 |
618695 | 618695 | 2020-10-11 | Fayette | Alabama | 1057 | 511 | 10 |
619111 | 619111 | 2020-10-11 | Fayette | Georgia | 13113 | 2233 | 51 |
619290 | 619290 | 2020-10-11 | Fayette | Illinois | 17051 | 525 | 13 |
619388 | 619388 | 2020-10-11 | Fayette | Indiana | 18041 | 615 | 14 |
619492 | 619492 | 2020-10-11 | Fayette | Iowa | 19065 | 286 | 2 |
619698 | 619698 | 2020-10-11 | Fayette | Kentucky | 21067 | 9279 | 81 |
620747 | 620747 | 2020-10-11 | Fayette | Ohio | 39047 | 357 | 7 |
620951 | 620951 | 2020-10-11 | Fayette | Pennsylvania | 42051 | 866 | 9 |
621213 | 621213 | 2020-10-11 | Fayette | Tennessee | 47047 | 1369 | 23 |
621360 | 621360 | 2020-10-11 | Fayette | Texas | 48149 | 496 | 21 |
621768 | 621768 | 2020-10-11 | Fayette | West Virginia | 54019 | 691 | 18 |
615453 | 615453 | 2020-10-10 | Fayette | Alabama | 1057 | 497 | 10 |
615869 | 615869 | 2020-10-10 | Fayette | Georgia | 13113 | 2224 | 51 |
616048 | 616048 | 2020-10-10 | Fayette | Illinois | 17051 | 507 | 12 |
616146 | 616146 | 2020-10-10 | Fayette | Indiana | 18041 | 605 | 14 |
616250 | 616250 | 2020-10-10 | Fayette | Iowa | 19065 | 285 | 2 |
616456 | 616456 | 2020-10-10 | Fayette | Kentucky | 21067 | 9279 | 81 |
617505 | 617505 | 2020-10-10 | Fayette | Ohio | 39047 | 349 | 7 |
617708 | 617708 | 2020-10-10 | Fayette | Pennsylvania | 42051 | 859 | 9 |
617970 | 617970 | 2020-10-10 | Fayette | Tennessee | 47047 | 1362 | 23 |
618117 | 618117 | 2020-10-10 | Fayette | Texas | 48149 | 496 | 21 |
618525 | 618525 | 2020-10-10 | Fayette | West Virginia | 54019 | 687 | 18 |
612212 | 612212 | 2020-10-09 | Fayette | Alabama | 1057 | 491 | 10 |
612628 | 612628 | 2020-10-09 | Fayette | Georgia | 13113 | 2225 | 51 |
612807 | 612807 | 2020-10-09 | Fayette | Illinois | 17051 | 501 | 10 |
612905 | 612905 | 2020-10-09 | Fayette | Indiana | 18041 | 600 | 14 |
613009 | 613009 | 2020-10-09 | Fayette | Iowa | 19065 | 281 | 2 |
613215 | 613215 | 2020-10-09 | Fayette | Kentucky | 21067 | 9153 | 80 |
614263 | 614263 | 2020-10-09 | Fayette | Ohio | 39047 | 334 | 7 |
614466 | 614466 | 2020-10-09 | Fayette | Pennsylvania | 42051 | 855 | 8 |
614728 | 614728 | 2020-10-09 | Fayette | Tennessee | 47047 | 1354 | 23 |
614875 | 614875 | 2020-10-09 | Fayette | Texas | 48149 | 496 | 21 |
615283 | 615283 | 2020-10-09 | Fayette | West Virginia | 54019 | 678 | 17 |
608970 | 608970 | 2020-10-08 | Fayette | Alabama | 1057 | 490 | 10 |
609386 | 609386 | 2020-10-08 | Fayette | Georgia | 13113 | 2218 | 52 |
609565 | 609565 | 2020-10-08 | Fayette | Illinois | 17051 | 489 | 10 |
609663 | 609663 | 2020-10-08 | Fayette | Indiana | 18041 | 594 | 14 |
609767 | 609767 | 2020-10-08 | Fayette | Iowa | 19065 | 275 | 2 |
609973 | 609973 | 2020-10-08 | Fayette | Kentucky | 21067 | 9076 | 80 |
611022 | 611022 | 2020-10-08 | Fayette | Ohio | 39047 | 324 | 7 |
611225 | 611225 | 2020-10-08 | Fayette | Pennsylvania | 42051 | 850 | 8 |
611487 | 611487 | 2020-10-08 | Fayette | Tennessee | 47047 | 1340 | 23 |
611634 | 611634 | 2020-10-08 | Fayette | Texas | 48149 | 496 | 21 |
612042 | 612042 | 2020-10-08 | Fayette | West Virginia | 54019 | 670 | 16 |
605727 | 605727 | 2020-10-07 | Fayette | Alabama | 1057 | 490 | 10 |
606143 | 606143 | 2020-10-07 | Fayette | Georgia | 13113 | 2208 | 52 |
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);