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 |
---|---|---|---|---|---|---|---|
2441579 | 2441579 | 2022-04-25 | Fayette | Illinois | 17051 | 7114 | 104 |
2441677 | 2441677 | 2022-04-25 | Fayette | Indiana | 18041 | 6744 | 146 |
2441782 | 2441782 | 2022-04-25 | Fayette | Iowa | 19065 | 4093 | 74 |
2441989 | 2441989 | 2022-04-25 | Fayette | Kentucky | 21067 | 95168 | 599 |
2443044 | 2443044 | 2022-04-25 | Fayette | Ohio | 39047 | 7788 | 121 |
2443249 | 2443249 | 2022-04-25 | Fayette | Pennsylvania | 42051 | 31122 | 670 |
2443511 | 2443511 | 2022-04-25 | Fayette | Tennessee | 47047 | 11430 | 185 |
2443658 | 2443658 | 2022-04-25 | Fayette | Texas | 48149 | 4773 | 105 |
2444067 | 2444067 | 2022-04-25 | Fayette | West Virginia | 54019 | 13077 | 199 |
2437724 | 2437724 | 2022-04-24 | Fayette | Alabama | 1057 | 4983 | 96 |
2438142 | 2438142 | 2022-04-24 | Fayette | Georgia | 13113 | 22499 | 318 |
2438323 | 2438323 | 2022-04-24 | Fayette | Illinois | 17051 | 7107 | 104 |
2438421 | 2438421 | 2022-04-24 | Fayette | Indiana | 18041 | 6743 | 146 |
2438526 | 2438526 | 2022-04-24 | Fayette | Iowa | 19065 | 4093 | 74 |
2438733 | 2438733 | 2022-04-24 | Fayette | Kentucky | 21067 | 94932 | 594 |
2439788 | 2439788 | 2022-04-24 | Fayette | Ohio | 39047 | 7788 | 121 |
2439993 | 2439993 | 2022-04-24 | Fayette | Pennsylvania | 42051 | 31117 | 670 |
2440255 | 2440255 | 2022-04-24 | Fayette | Tennessee | 47047 | 11430 | 185 |
2440402 | 2440402 | 2022-04-24 | Fayette | Texas | 48149 | 4773 | 105 |
2440811 | 2440811 | 2022-04-24 | Fayette | West Virginia | 54019 | 13072 | 199 |
2434468 | 2434468 | 2022-04-23 | Fayette | Alabama | 1057 | 4983 | 96 |
2434886 | 2434886 | 2022-04-23 | Fayette | Georgia | 13113 | 22499 | 318 |
2435067 | 2435067 | 2022-04-23 | Fayette | Illinois | 17051 | 7107 | 104 |
2435165 | 2435165 | 2022-04-23 | Fayette | Indiana | 18041 | 6743 | 146 |
2435270 | 2435270 | 2022-04-23 | Fayette | Iowa | 19065 | 4093 | 74 |
2435477 | 2435477 | 2022-04-23 | Fayette | Kentucky | 21067 | 94932 | 594 |
2436532 | 2436532 | 2022-04-23 | Fayette | Ohio | 39047 | 7788 | 121 |
2436737 | 2436737 | 2022-04-23 | Fayette | Pennsylvania | 42051 | 31113 | 670 |
2436999 | 2436999 | 2022-04-23 | Fayette | Tennessee | 47047 | 11430 | 185 |
2437146 | 2437146 | 2022-04-23 | Fayette | Texas | 48149 | 4773 | 105 |
2437555 | 2437555 | 2022-04-23 | Fayette | West Virginia | 54019 | 13072 | 199 |
2431212 | 2431212 | 2022-04-22 | Fayette | Alabama | 1057 | 4983 | 96 |
2431630 | 2431630 | 2022-04-22 | Fayette | Georgia | 13113 | 22499 | 318 |
2431811 | 2431811 | 2022-04-22 | Fayette | Illinois | 17051 | 7107 | 104 |
2431909 | 2431909 | 2022-04-22 | Fayette | Indiana | 18041 | 6743 | 146 |
2432014 | 2432014 | 2022-04-22 | Fayette | Iowa | 19065 | 4093 | 74 |
2432221 | 2432221 | 2022-04-22 | Fayette | Kentucky | 21067 | 94932 | 594 |
2433276 | 2433276 | 2022-04-22 | Fayette | Ohio | 39047 | 7788 | 121 |
2433481 | 2433481 | 2022-04-22 | Fayette | Pennsylvania | 42051 | 31104 | 669 |
2433743 | 2433743 | 2022-04-22 | Fayette | Tennessee | 47047 | 11430 | 185 |
2433890 | 2433890 | 2022-04-22 | Fayette | Texas | 48149 | 4771 | 105 |
2434299 | 2434299 | 2022-04-22 | Fayette | West Virginia | 54019 | 13072 | 199 |
2427956 | 2427956 | 2022-04-21 | Fayette | Alabama | 1057 | 4983 | 96 |
2428374 | 2428374 | 2022-04-21 | Fayette | Georgia | 13113 | 22499 | 318 |
2428555 | 2428555 | 2022-04-21 | Fayette | Illinois | 17051 | 7103 | 104 |
2428653 | 2428653 | 2022-04-21 | Fayette | Indiana | 18041 | 6739 | 146 |
2428758 | 2428758 | 2022-04-21 | Fayette | Iowa | 19065 | 4093 | 74 |
2428965 | 2428965 | 2022-04-21 | Fayette | Kentucky | 21067 | 94932 | 594 |
2430020 | 2430020 | 2022-04-21 | Fayette | Ohio | 39047 | 7788 | 121 |
2430225 | 2430225 | 2022-04-21 | Fayette | Pennsylvania | 42051 | 31098 | 669 |
2430487 | 2430487 | 2022-04-21 | Fayette | Tennessee | 47047 | 11430 | 185 |
2430634 | 2430634 | 2022-04-21 | Fayette | Texas | 48149 | 4771 | 105 |
2431043 | 2431043 | 2022-04-21 | Fayette | West Virginia | 54019 | 13069 | 199 |
2424700 | 2424700 | 2022-04-20 | Fayette | Alabama | 1057 | 4983 | 96 |
2425118 | 2425118 | 2022-04-20 | Fayette | Georgia | 13113 | 22499 | 318 |
2425299 | 2425299 | 2022-04-20 | Fayette | Illinois | 17051 | 7100 | 104 |
2425397 | 2425397 | 2022-04-20 | Fayette | Indiana | 18041 | 6739 | 146 |
2425502 | 2425502 | 2022-04-20 | Fayette | Iowa | 19065 | 4093 | 74 |
2425709 | 2425709 | 2022-04-20 | Fayette | Kentucky | 21067 | 94932 | 594 |
2426764 | 2426764 | 2022-04-20 | Fayette | Ohio | 39047 | 7783 | 121 |
2426969 | 2426969 | 2022-04-20 | Fayette | Pennsylvania | 42051 | 31089 | 670 |
2427231 | 2427231 | 2022-04-20 | Fayette | Tennessee | 47047 | 11430 | 185 |
2427378 | 2427378 | 2022-04-20 | Fayette | Texas | 48149 | 4771 | 105 |
2427787 | 2427787 | 2022-04-20 | Fayette | West Virginia | 54019 | 13066 | 198 |
2421444 | 2421444 | 2022-04-19 | Fayette | Alabama | 1057 | 4983 | 96 |
2421862 | 2421862 | 2022-04-19 | Fayette | Georgia | 13113 | 22466 | 318 |
2422043 | 2422043 | 2022-04-19 | Fayette | Illinois | 17051 | 7096 | 104 |
2422141 | 2422141 | 2022-04-19 | Fayette | Indiana | 18041 | 6739 | 146 |
2422246 | 2422246 | 2022-04-19 | Fayette | Iowa | 19065 | 4093 | 72 |
2422453 | 2422453 | 2022-04-19 | Fayette | Kentucky | 21067 | 94932 | 594 |
2423508 | 2423508 | 2022-04-19 | Fayette | Ohio | 39047 | 7783 | 121 |
2423713 | 2423713 | 2022-04-19 | Fayette | Pennsylvania | 42051 | 31076 | 670 |
2423975 | 2423975 | 2022-04-19 | Fayette | Tennessee | 47047 | 11421 | 185 |
2424122 | 2424122 | 2022-04-19 | Fayette | Texas | 48149 | 4771 | 105 |
2424531 | 2424531 | 2022-04-19 | Fayette | West Virginia | 54019 | 13066 | 198 |
2418188 | 2418188 | 2022-04-18 | Fayette | Alabama | 1057 | 4981 | 96 |
2418606 | 2418606 | 2022-04-18 | Fayette | Georgia | 13113 | 22466 | 318 |
2418787 | 2418787 | 2022-04-18 | Fayette | Illinois | 17051 | 7095 | 104 |
2418885 | 2418885 | 2022-04-18 | Fayette | Indiana | 18041 | 6739 | 146 |
2418990 | 2418990 | 2022-04-18 | Fayette | Iowa | 19065 | 4093 | 72 |
2419197 | 2419197 | 2022-04-18 | Fayette | Kentucky | 21067 | 94932 | 594 |
2420251 | 2420251 | 2022-04-18 | Fayette | Ohio | 39047 | 7783 | 121 |
2420457 | 2420457 | 2022-04-18 | Fayette | Pennsylvania | 42051 | 31071 | 669 |
2420719 | 2420719 | 2022-04-18 | Fayette | Tennessee | 47047 | 11421 | 185 |
2420866 | 2420866 | 2022-04-18 | Fayette | Texas | 48149 | 4771 | 105 |
2421275 | 2421275 | 2022-04-18 | Fayette | West Virginia | 54019 | 13065 | 198 |
2414932 | 2414932 | 2022-04-17 | Fayette | Alabama | 1057 | 4981 | 96 |
2415350 | 2415350 | 2022-04-17 | Fayette | Georgia | 13113 | 22465 | 318 |
2415531 | 2415531 | 2022-04-17 | Fayette | Illinois | 17051 | 7092 | 104 |
2415629 | 2415629 | 2022-04-17 | Fayette | Indiana | 18041 | 6738 | 146 |
2415734 | 2415734 | 2022-04-17 | Fayette | Iowa | 19065 | 4093 | 72 |
2415941 | 2415941 | 2022-04-17 | Fayette | Kentucky | 21067 | 94706 | 588 |
2416996 | 2416996 | 2022-04-17 | Fayette | Ohio | 39047 | 7783 | 121 |
2417201 | 2417201 | 2022-04-17 | Fayette | Pennsylvania | 42051 | 31069 | 669 |
2417463 | 2417463 | 2022-04-17 | Fayette | Tennessee | 47047 | 11421 | 185 |
2417610 | 2417610 | 2022-04-17 | Fayette | Texas | 48149 | 4770 | 105 |
2418019 | 2418019 | 2022-04-17 | Fayette | West Virginia | 54019 | 13055 | 198 |
2411676 | 2411676 | 2022-04-16 | Fayette | Alabama | 1057 | 4981 | 96 |
2412094 | 2412094 | 2022-04-16 | Fayette | Georgia | 13113 | 22465 | 318 |
2412275 | 2412275 | 2022-04-16 | Fayette | Illinois | 17051 | 7092 | 104 |
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);