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 |
---|---|---|---|---|---|---|---|
505932 | 505932 | 2020-09-06 | Fayette | Illinois | 17051 | 212 | 3 |
506030 | 506030 | 2020-09-06 | Fayette | Indiana | 18041 | 473 | 10 |
506134 | 506134 | 2020-09-06 | Fayette | Iowa | 19065 | 159 | 1 |
506340 | 506340 | 2020-09-06 | Fayette | Kentucky | 21067 | 6256 | 60 |
507382 | 507382 | 2020-09-06 | Fayette | Ohio | 39047 | 206 | 5 |
507585 | 507585 | 2020-09-06 | Fayette | Pennsylvania | 42051 | 711 | 6 |
507847 | 507847 | 2020-09-06 | Fayette | Tennessee | 47047 | 997 | 11 |
507993 | 507993 | 2020-09-06 | Fayette | Texas | 48149 | 379 | 18 |
508400 | 508400 | 2020-09-06 | Fayette | West Virginia | 54019 | 412 | 9 |
502104 | 502104 | 2020-09-05 | Fayette | Alabama | 1057 | 345 | 6 |
502519 | 502519 | 2020-09-05 | Fayette | Georgia | 13113 | 1624 | 41 |
502698 | 502698 | 2020-09-05 | Fayette | Illinois | 17051 | 202 | 3 |
502796 | 502796 | 2020-09-05 | Fayette | Indiana | 18041 | 459 | 10 |
502900 | 502900 | 2020-09-05 | Fayette | Iowa | 19065 | 157 | 1 |
503106 | 503106 | 2020-09-05 | Fayette | Kentucky | 21067 | 6256 | 60 |
504150 | 504150 | 2020-09-05 | Fayette | Ohio | 39047 | 202 | 5 |
504353 | 504353 | 2020-09-05 | Fayette | Pennsylvania | 42051 | 708 | 6 |
504615 | 504615 | 2020-09-05 | Fayette | Tennessee | 47047 | 983 | 11 |
504761 | 504761 | 2020-09-05 | Fayette | Texas | 48149 | 379 | 18 |
505168 | 505168 | 2020-09-05 | Fayette | West Virginia | 54019 | 398 | 9 |
498870 | 498870 | 2020-09-04 | Fayette | Alabama | 1057 | 341 | 6 |
499285 | 499285 | 2020-09-04 | Fayette | Georgia | 13113 | 1613 | 40 |
499464 | 499464 | 2020-09-04 | Fayette | Illinois | 17051 | 196 | 3 |
499562 | 499562 | 2020-09-04 | Fayette | Indiana | 18041 | 447 | 10 |
499666 | 499666 | 2020-09-04 | Fayette | Iowa | 19065 | 153 | 1 |
499873 | 499873 | 2020-09-04 | Fayette | Kentucky | 21067 | 6146 | 59 |
500916 | 500916 | 2020-09-04 | Fayette | Ohio | 39047 | 201 | 5 |
501119 | 501119 | 2020-09-04 | Fayette | Pennsylvania | 42051 | 705 | 6 |
501381 | 501381 | 2020-09-04 | Fayette | Tennessee | 47047 | 976 | 11 |
501527 | 501527 | 2020-09-04 | Fayette | Texas | 48149 | 379 | 17 |
501934 | 501934 | 2020-09-04 | Fayette | West Virginia | 54019 | 377 | 10 |
495637 | 495637 | 2020-09-03 | Fayette | Alabama | 1057 | 334 | 6 |
496052 | 496052 | 2020-09-03 | Fayette | Georgia | 13113 | 1606 | 39 |
496231 | 496231 | 2020-09-03 | Fayette | Illinois | 17051 | 183 | 3 |
496329 | 496329 | 2020-09-03 | Fayette | Indiana | 18041 | 441 | 10 |
496433 | 496433 | 2020-09-03 | Fayette | Iowa | 19065 | 150 | 1 |
496639 | 496639 | 2020-09-03 | Fayette | Kentucky | 21067 | 6035 | 58 |
497682 | 497682 | 2020-09-03 | Fayette | Ohio | 39047 | 198 | 5 |
497885 | 497885 | 2020-09-03 | Fayette | Pennsylvania | 42051 | 703 | 6 |
498147 | 498147 | 2020-09-03 | Fayette | Tennessee | 47047 | 973 | 11 |
498293 | 498293 | 2020-09-03 | Fayette | Texas | 48149 | 378 | 17 |
498700 | 498700 | 2020-09-03 | Fayette | West Virginia | 54019 | 369 | 9 |
492403 | 492403 | 2020-09-02 | Fayette | Alabama | 1057 | 327 | 6 |
492818 | 492818 | 2020-09-02 | Fayette | Georgia | 13113 | 1595 | 39 |
492997 | 492997 | 2020-09-02 | Fayette | Illinois | 17051 | 176 | 3 |
493095 | 493095 | 2020-09-02 | Fayette | Indiana | 18041 | 435 | 10 |
493199 | 493199 | 2020-09-02 | Fayette | Iowa | 19065 | 144 | 1 |
493406 | 493406 | 2020-09-02 | Fayette | Kentucky | 21067 | 5915 | 58 |
494449 | 494449 | 2020-09-02 | Fayette | Ohio | 39047 | 193 | 5 |
494652 | 494652 | 2020-09-02 | Fayette | Pennsylvania | 42051 | 699 | 6 |
494914 | 494914 | 2020-09-02 | Fayette | Tennessee | 47047 | 909 | 10 |
495060 | 495060 | 2020-09-02 | Fayette | Texas | 48149 | 375 | 16 |
495467 | 495467 | 2020-09-02 | Fayette | West Virginia | 54019 | 365 | 10 |
489170 | 489170 | 2020-09-01 | Fayette | Alabama | 1057 | 323 | 6 |
489585 | 489585 | 2020-09-01 | Fayette | Georgia | 13113 | 1585 | 38 |
489764 | 489764 | 2020-09-01 | Fayette | Illinois | 17051 | 172 | 3 |
489862 | 489862 | 2020-09-01 | Fayette | Indiana | 18041 | 427 | 9 |
489966 | 489966 | 2020-09-01 | Fayette | Iowa | 19065 | 143 | 1 |
490172 | 490172 | 2020-09-01 | Fayette | Kentucky | 21067 | 5793 | 58 |
491215 | 491215 | 2020-09-01 | Fayette | Ohio | 39047 | 192 | 5 |
491418 | 491418 | 2020-09-01 | Fayette | Pennsylvania | 42051 | 694 | 6 |
491680 | 491680 | 2020-09-01 | Fayette | Tennessee | 47047 | 888 | 10 |
491826 | 491826 | 2020-09-01 | Fayette | Texas | 48149 | 374 | 16 |
492233 | 492233 | 2020-09-01 | Fayette | West Virginia | 54019 | 360 | 10 |
485937 | 485937 | 2020-08-31 | Fayette | Alabama | 1057 | 315 | 6 |
486352 | 486352 | 2020-08-31 | Fayette | Georgia | 13113 | 1573 | 38 |
486531 | 486531 | 2020-08-31 | Fayette | Illinois | 17051 | 169 | 3 |
486629 | 486629 | 2020-08-31 | Fayette | Indiana | 18041 | 422 | 8 |
486733 | 486733 | 2020-08-31 | Fayette | Iowa | 19065 | 142 | 1 |
486939 | 486939 | 2020-08-31 | Fayette | Kentucky | 21067 | 5726 | 56 |
487982 | 487982 | 2020-08-31 | Fayette | Ohio | 39047 | 189 | 5 |
488185 | 488185 | 2020-08-31 | Fayette | Pennsylvania | 42051 | 692 | 6 |
488447 | 488447 | 2020-08-31 | Fayette | Tennessee | 47047 | 886 | 10 |
488593 | 488593 | 2020-08-31 | Fayette | Texas | 48149 | 370 | 16 |
489000 | 489000 | 2020-08-31 | Fayette | West Virginia | 54019 | 292 | 9 |
482702 | 482702 | 2020-08-30 | Fayette | Alabama | 1057 | 313 | 6 |
483117 | 483117 | 2020-08-30 | Fayette | Georgia | 13113 | 1568 | 38 |
483296 | 483296 | 2020-08-30 | Fayette | Illinois | 17051 | 165 | 3 |
483394 | 483394 | 2020-08-30 | Fayette | Indiana | 18041 | 418 | 8 |
483498 | 483498 | 2020-08-30 | Fayette | Iowa | 19065 | 138 | 1 |
483704 | 483704 | 2020-08-30 | Fayette | Kentucky | 21067 | 5520 | 55 |
484749 | 484749 | 2020-08-30 | Fayette | Ohio | 39047 | 189 | 5 |
484952 | 484952 | 2020-08-30 | Fayette | Pennsylvania | 42051 | 689 | 6 |
485214 | 485214 | 2020-08-30 | Fayette | Tennessee | 47047 | 882 | 10 |
485360 | 485360 | 2020-08-30 | Fayette | Texas | 48149 | 368 | 16 |
485767 | 485767 | 2020-08-30 | Fayette | West Virginia | 54019 | 268 | 9 |
479468 | 479468 | 2020-08-29 | Fayette | Alabama | 1057 | 311 | 6 |
479883 | 479883 | 2020-08-29 | Fayette | Georgia | 13113 | 1564 | 38 |
480062 | 480062 | 2020-08-29 | Fayette | Illinois | 17051 | 163 | 3 |
480160 | 480160 | 2020-08-29 | Fayette | Indiana | 18041 | 403 | 8 |
480264 | 480264 | 2020-08-29 | Fayette | Iowa | 19065 | 137 | 1 |
480470 | 480470 | 2020-08-29 | Fayette | Kentucky | 21067 | 5520 | 55 |
481514 | 481514 | 2020-08-29 | Fayette | Ohio | 39047 | 189 | 5 |
481717 | 481717 | 2020-08-29 | Fayette | Pennsylvania | 42051 | 683 | 6 |
481979 | 481979 | 2020-08-29 | Fayette | Tennessee | 47047 | 875 | 10 |
482125 | 482125 | 2020-08-29 | Fayette | Texas | 48149 | 368 | 16 |
482532 | 482532 | 2020-08-29 | Fayette | West Virginia | 54019 | 247 | 9 |
476235 | 476235 | 2020-08-28 | Fayette | Alabama | 1057 | 307 | 6 |
476650 | 476650 | 2020-08-28 | Fayette | Georgia | 13113 | 1539 | 38 |
476829 | 476829 | 2020-08-28 | Fayette | Illinois | 17051 | 153 | 3 |
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);