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 |
---|---|---|---|---|---|---|---|
924128 | 924128 | 2021-01-13 | Fayette | Georgia | 13113 | 5707 | 86 |
924308 | 924308 | 2021-01-13 | Fayette | Illinois | 17051 | 2857 | 53 |
924405 | 924405 | 2021-01-13 | Fayette | Indiana | 18041 | 2506 | 49 |
924509 | 924509 | 2021-01-13 | Fayette | Iowa | 19065 | 1556 | 22 |
924716 | 924716 | 2021-01-13 | Fayette | Kentucky | 21067 | 26282 | 168 |
925766 | 925766 | 2021-01-13 | Fayette | Ohio | 39047 | 2162 | 29 |
925970 | 925970 | 2021-01-13 | Fayette | Pennsylvania | 42051 | 8704 | 160 |
926232 | 926232 | 2021-01-13 | Fayette | Tennessee | 47047 | 3835 | 51 |
926379 | 926379 | 2021-01-13 | Fayette | Texas | 48149 | 1372 | 40 |
926788 | 926788 | 2021-01-13 | Fayette | West Virginia | 54019 | 2079 | 55 |
920466 | 920466 | 2021-01-12 | Fayette | Alabama | 1057 | 1613 | 21 |
920883 | 920883 | 2021-01-12 | Fayette | Georgia | 13113 | 5645 | 82 |
921063 | 921063 | 2021-01-12 | Fayette | Illinois | 17051 | 2842 | 53 |
921160 | 921160 | 2021-01-12 | Fayette | Indiana | 18041 | 2494 | 49 |
921264 | 921264 | 2021-01-12 | Fayette | Iowa | 19065 | 1535 | 22 |
921471 | 921471 | 2021-01-12 | Fayette | Kentucky | 21067 | 26045 | 167 |
922520 | 922520 | 2021-01-12 | Fayette | Ohio | 39047 | 2134 | 29 |
922724 | 922724 | 2021-01-12 | Fayette | Pennsylvania | 42051 | 8590 | 152 |
922986 | 922986 | 2021-01-12 | Fayette | Tennessee | 47047 | 3806 | 51 |
923133 | 923133 | 2021-01-12 | Fayette | Texas | 48149 | 1370 | 39 |
923542 | 923542 | 2021-01-12 | Fayette | West Virginia | 54019 | 2063 | 55 |
917221 | 917221 | 2021-01-11 | Fayette | Alabama | 1057 | 1585 | 21 |
917638 | 917638 | 2021-01-11 | Fayette | Georgia | 13113 | 5576 | 79 |
917818 | 917818 | 2021-01-11 | Fayette | Illinois | 17051 | 2829 | 52 |
917915 | 917915 | 2021-01-11 | Fayette | Indiana | 18041 | 2486 | 47 |
918019 | 918019 | 2021-01-11 | Fayette | Iowa | 19065 | 1530 | 22 |
918226 | 918226 | 2021-01-11 | Fayette | Kentucky | 21067 | 25905 | 167 |
919275 | 919275 | 2021-01-11 | Fayette | Ohio | 39047 | 2101 | 29 |
919479 | 919479 | 2021-01-11 | Fayette | Pennsylvania | 42051 | 8514 | 147 |
919741 | 919741 | 2021-01-11 | Fayette | Tennessee | 47047 | 3778 | 51 |
919888 | 919888 | 2021-01-11 | Fayette | Texas | 48149 | 1367 | 39 |
920297 | 920297 | 2021-01-11 | Fayette | West Virginia | 54019 | 2052 | 55 |
913976 | 913976 | 2021-01-10 | Fayette | Alabama | 1057 | 1570 | 21 |
914393 | 914393 | 2021-01-10 | Fayette | Georgia | 13113 | 5501 | 79 |
914573 | 914573 | 2021-01-10 | Fayette | Illinois | 17051 | 2816 | 52 |
914670 | 914670 | 2021-01-10 | Fayette | Indiana | 18041 | 2478 | 47 |
914774 | 914774 | 2021-01-10 | Fayette | Iowa | 19065 | 1519 | 22 |
914981 | 914981 | 2021-01-10 | Fayette | Kentucky | 21067 | 25725 | 166 |
916030 | 916030 | 2021-01-10 | Fayette | Ohio | 39047 | 2075 | 29 |
916234 | 916234 | 2021-01-10 | Fayette | Pennsylvania | 42051 | 8472 | 146 |
916496 | 916496 | 2021-01-10 | Fayette | Tennessee | 47047 | 3761 | 51 |
916643 | 916643 | 2021-01-10 | Fayette | Texas | 48149 | 1367 | 39 |
917052 | 917052 | 2021-01-10 | Fayette | West Virginia | 54019 | 2031 | 53 |
910731 | 910731 | 2021-01-09 | Fayette | Alabama | 1057 | 1561 | 21 |
911148 | 911148 | 2021-01-09 | Fayette | Georgia | 13113 | 5435 | 79 |
911328 | 911328 | 2021-01-09 | Fayette | Illinois | 17051 | 2810 | 52 |
911425 | 911425 | 2021-01-09 | Fayette | Indiana | 18041 | 2463 | 47 |
911529 | 911529 | 2021-01-09 | Fayette | Iowa | 19065 | 1513 | 22 |
911736 | 911736 | 2021-01-09 | Fayette | Kentucky | 21067 | 25502 | 166 |
912785 | 912785 | 2021-01-09 | Fayette | Ohio | 39047 | 2067 | 29 |
912989 | 912989 | 2021-01-09 | Fayette | Pennsylvania | 42051 | 8394 | 141 |
913251 | 913251 | 2021-01-09 | Fayette | Tennessee | 47047 | 3714 | 50 |
913398 | 913398 | 2021-01-09 | Fayette | Texas | 48149 | 1360 | 39 |
913807 | 913807 | 2021-01-09 | Fayette | West Virginia | 54019 | 2008 | 53 |
907486 | 907486 | 2021-01-08 | Fayette | Alabama | 1057 | 1534 | 21 |
907903 | 907903 | 2021-01-08 | Fayette | Georgia | 13113 | 5349 | 79 |
908083 | 908083 | 2021-01-08 | Fayette | Illinois | 17051 | 2804 | 52 |
908180 | 908180 | 2021-01-08 | Fayette | Indiana | 18041 | 2447 | 46 |
908284 | 908284 | 2021-01-08 | Fayette | Iowa | 19065 | 1505 | 22 |
908491 | 908491 | 2021-01-08 | Fayette | Kentucky | 21067 | 25219 | 165 |
909540 | 909540 | 2021-01-08 | Fayette | Ohio | 39047 | 2035 | 29 |
909744 | 909744 | 2021-01-08 | Fayette | Pennsylvania | 42051 | 8256 | 136 |
910006 | 910006 | 2021-01-08 | Fayette | Tennessee | 47047 | 3681 | 50 |
910153 | 910153 | 2021-01-08 | Fayette | Texas | 48149 | 1354 | 37 |
910562 | 910562 | 2021-01-08 | Fayette | West Virginia | 54019 | 1970 | 53 |
904240 | 904240 | 2021-01-07 | Fayette | Alabama | 1057 | 1517 | 21 |
904657 | 904657 | 2021-01-07 | Fayette | Georgia | 13113 | 5227 | 78 |
904837 | 904837 | 2021-01-07 | Fayette | Illinois | 17051 | 2777 | 51 |
904934 | 904934 | 2021-01-07 | Fayette | Indiana | 18041 | 2433 | 45 |
905038 | 905038 | 2021-01-07 | Fayette | Iowa | 19065 | 1494 | 21 |
905245 | 905245 | 2021-01-07 | Fayette | Kentucky | 21067 | 24924 | 165 |
906295 | 906295 | 2021-01-07 | Fayette | Ohio | 39047 | 2008 | 29 |
906499 | 906499 | 2021-01-07 | Fayette | Pennsylvania | 42051 | 8096 | 133 |
906761 | 906761 | 2021-01-07 | Fayette | Tennessee | 47047 | 3646 | 50 |
906908 | 906908 | 2021-01-07 | Fayette | Texas | 48149 | 1339 | 37 |
907317 | 907317 | 2021-01-07 | Fayette | West Virginia | 54019 | 1941 | 53 |
900995 | 900995 | 2021-01-06 | Fayette | Alabama | 1057 | 1499 | 21 |
901412 | 901412 | 2021-01-06 | Fayette | Georgia | 13113 | 5140 | 77 |
901592 | 901592 | 2021-01-06 | Fayette | Illinois | 17051 | 2756 | 50 |
901689 | 901689 | 2021-01-06 | Fayette | Indiana | 18041 | 2410 | 45 |
901793 | 901793 | 2021-01-06 | Fayette | Iowa | 19065 | 1481 | 21 |
902000 | 902000 | 2021-01-06 | Fayette | Kentucky | 21067 | 24660 | 165 |
903049 | 903049 | 2021-01-06 | Fayette | Ohio | 39047 | 1973 | 29 |
903253 | 903253 | 2021-01-06 | Fayette | Pennsylvania | 42051 | 7993 | 130 |
903515 | 903515 | 2021-01-06 | Fayette | Tennessee | 47047 | 3592 | 49 |
903662 | 903662 | 2021-01-06 | Fayette | Texas | 48149 | 1324 | 36 |
904071 | 904071 | 2021-01-06 | Fayette | West Virginia | 54019 | 1913 | 51 |
897750 | 897750 | 2021-01-05 | Fayette | Alabama | 1057 | 1487 | 20 |
898167 | 898167 | 2021-01-05 | Fayette | Georgia | 13113 | 5118 | 77 |
898347 | 898347 | 2021-01-05 | Fayette | Illinois | 17051 | 2706 | 50 |
898444 | 898444 | 2021-01-05 | Fayette | Indiana | 18041 | 2389 | 45 |
898548 | 898548 | 2021-01-05 | Fayette | Iowa | 19065 | 1460 | 21 |
898755 | 898755 | 2021-01-05 | Fayette | Kentucky | 21067 | 24285 | 163 |
899804 | 899804 | 2021-01-05 | Fayette | Ohio | 39047 | 1946 | 29 |
900008 | 900008 | 2021-01-05 | Fayette | Pennsylvania | 42051 | 7691 | 119 |
900270 | 900270 | 2021-01-05 | Fayette | Tennessee | 47047 | 3559 | 49 |
900417 | 900417 | 2021-01-05 | Fayette | Texas | 48149 | 1313 | 36 |
900826 | 900826 | 2021-01-05 | Fayette | West Virginia | 54019 | 1904 | 50 |
894504 | 894504 | 2021-01-04 | Fayette | Alabama | 1057 | 1470 | 19 |
894922 | 894922 | 2021-01-04 | Fayette | Georgia | 13113 | 5035 | 77 |
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);