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 |
---|---|---|---|---|---|---|---|
2470701 | 2470701 | 2022-05-04 | Fayette | Georgia | 13113 | 22689 | 319 |
2470882 | 2470882 | 2022-05-04 | Fayette | Illinois | 17051 | 7130 | 104 |
2470980 | 2470980 | 2022-05-04 | Fayette | Indiana | 18041 | 6745 | 146 |
2471085 | 2471085 | 2022-05-04 | Fayette | Iowa | 19065 | 4110 | 74 |
2471292 | 2471292 | 2022-05-04 | Fayette | Kentucky | 21067 | 95539 | 602 |
2472347 | 2472347 | 2022-05-04 | Fayette | Ohio | 39047 | 7804 | 121 |
2472552 | 2472552 | 2022-05-04 | Fayette | Pennsylvania | 42051 | 31216 | 674 |
2472814 | 2472814 | 2022-05-04 | Fayette | Tennessee | 47047 | 11455 | 185 |
2472961 | 2472961 | 2022-05-04 | Fayette | Texas | 48149 | 4789 | 105 |
2473371 | 2473371 | 2022-05-04 | Fayette | West Virginia | 54019 | 13125 | 204 |
2467027 | 2467027 | 2022-05-03 | Fayette | Alabama | 1057 | 4983 | 96 |
2467445 | 2467445 | 2022-05-03 | Fayette | Georgia | 13113 | 22592 | 319 |
2467626 | 2467626 | 2022-05-03 | Fayette | Illinois | 17051 | 7126 | 104 |
2467724 | 2467724 | 2022-05-03 | Fayette | Indiana | 18041 | 6744 | 146 |
2467829 | 2467829 | 2022-05-03 | Fayette | Iowa | 19065 | 4097 | 74 |
2468036 | 2468036 | 2022-05-03 | Fayette | Kentucky | 21067 | 95539 | 602 |
2469091 | 2469091 | 2022-05-03 | Fayette | Ohio | 39047 | 7804 | 121 |
2469296 | 2469296 | 2022-05-03 | Fayette | Pennsylvania | 42051 | 31206 | 674 |
2469558 | 2469558 | 2022-05-03 | Fayette | Tennessee | 47047 | 11437 | 185 |
2469705 | 2469705 | 2022-05-03 | Fayette | Texas | 48149 | 4788 | 105 |
2470114 | 2470114 | 2022-05-03 | Fayette | West Virginia | 54019 | 13123 | 204 |
2463772 | 2463772 | 2022-05-02 | Fayette | Alabama | 1057 | 4984 | 96 |
2464190 | 2464190 | 2022-05-02 | Fayette | Georgia | 13113 | 22592 | 319 |
2464371 | 2464371 | 2022-05-02 | Fayette | Illinois | 17051 | 7126 | 104 |
2464469 | 2464469 | 2022-05-02 | Fayette | Indiana | 18041 | 6744 | 146 |
2464574 | 2464574 | 2022-05-02 | Fayette | Iowa | 19065 | 4097 | 74 |
2464781 | 2464781 | 2022-05-02 | Fayette | Kentucky | 21067 | 95539 | 602 |
2465835 | 2465835 | 2022-05-02 | Fayette | Ohio | 39047 | 7804 | 121 |
2466040 | 2466040 | 2022-05-02 | Fayette | Pennsylvania | 42051 | 31194 | 671 |
2466302 | 2466302 | 2022-05-02 | Fayette | Tennessee | 47047 | 11437 | 185 |
2466449 | 2466449 | 2022-05-02 | Fayette | Texas | 48149 | 4787 | 105 |
2466858 | 2466858 | 2022-05-02 | Fayette | West Virginia | 54019 | 13117 | 203 |
2460516 | 2460516 | 2022-05-01 | Fayette | Alabama | 1057 | 4984 | 96 |
2460934 | 2460934 | 2022-05-01 | Fayette | Georgia | 13113 | 22592 | 319 |
2461115 | 2461115 | 2022-05-01 | Fayette | Illinois | 17051 | 7123 | 104 |
2461213 | 2461213 | 2022-05-01 | Fayette | Indiana | 18041 | 6744 | 146 |
2461318 | 2461318 | 2022-05-01 | Fayette | Iowa | 19065 | 4097 | 74 |
2461525 | 2461525 | 2022-05-01 | Fayette | Kentucky | 21067 | 95168 | 599 |
2462580 | 2462580 | 2022-05-01 | Fayette | Ohio | 39047 | 7804 | 121 |
2462785 | 2462785 | 2022-05-01 | Fayette | Pennsylvania | 42051 | 31190 | 671 |
2463047 | 2463047 | 2022-05-01 | Fayette | Tennessee | 47047 | 11437 | 185 |
2463194 | 2463194 | 2022-05-01 | Fayette | Texas | 48149 | 4785 | 105 |
2463603 | 2463603 | 2022-05-01 | Fayette | West Virginia | 54019 | 13099 | 202 |
2457260 | 2457260 | 2022-04-30 | Fayette | Alabama | 1057 | 4984 | 96 |
2457678 | 2457678 | 2022-04-30 | Fayette | Georgia | 13113 | 22592 | 319 |
2457859 | 2457859 | 2022-04-30 | Fayette | Illinois | 17051 | 7123 | 104 |
2457957 | 2457957 | 2022-04-30 | Fayette | Indiana | 18041 | 6744 | 146 |
2458062 | 2458062 | 2022-04-30 | Fayette | Iowa | 19065 | 4097 | 74 |
2458269 | 2458269 | 2022-04-30 | Fayette | Kentucky | 21067 | 95168 | 599 |
2459324 | 2459324 | 2022-04-30 | Fayette | Ohio | 39047 | 7804 | 121 |
2459529 | 2459529 | 2022-04-30 | Fayette | Pennsylvania | 42051 | 31182 | 671 |
2459791 | 2459791 | 2022-04-30 | Fayette | Tennessee | 47047 | 11437 | 185 |
2459938 | 2459938 | 2022-04-30 | Fayette | Texas | 48149 | 4785 | 105 |
2460347 | 2460347 | 2022-04-30 | Fayette | West Virginia | 54019 | 13099 | 202 |
2454004 | 2454004 | 2022-04-29 | Fayette | Alabama | 1057 | 4984 | 96 |
2454422 | 2454422 | 2022-04-29 | Fayette | Georgia | 13113 | 22592 | 319 |
2454603 | 2454603 | 2022-04-29 | Fayette | Illinois | 17051 | 7123 | 104 |
2454701 | 2454701 | 2022-04-29 | Fayette | Indiana | 18041 | 6744 | 146 |
2454806 | 2454806 | 2022-04-29 | Fayette | Iowa | 19065 | 4097 | 74 |
2455013 | 2455013 | 2022-04-29 | Fayette | Kentucky | 21067 | 95168 | 599 |
2456068 | 2456068 | 2022-04-29 | Fayette | Ohio | 39047 | 7804 | 121 |
2456273 | 2456273 | 2022-04-29 | Fayette | Pennsylvania | 42051 | 31174 | 671 |
2456535 | 2456535 | 2022-04-29 | Fayette | Tennessee | 47047 | 11437 | 185 |
2456682 | 2456682 | 2022-04-29 | Fayette | Texas | 48149 | 4784 | 105 |
2457091 | 2457091 | 2022-04-29 | Fayette | West Virginia | 54019 | 13099 | 202 |
2450748 | 2450748 | 2022-04-28 | Fayette | Alabama | 1057 | 4984 | 96 |
2451166 | 2451166 | 2022-04-28 | Fayette | Georgia | 13113 | 22592 | 319 |
2451347 | 2451347 | 2022-04-28 | Fayette | Illinois | 17051 | 7120 | 104 |
2451445 | 2451445 | 2022-04-28 | Fayette | Indiana | 18041 | 6745 | 146 |
2451550 | 2451550 | 2022-04-28 | Fayette | Iowa | 19065 | 4097 | 74 |
2451757 | 2451757 | 2022-04-28 | Fayette | Kentucky | 21067 | 95168 | 599 |
2452812 | 2452812 | 2022-04-28 | Fayette | Ohio | 39047 | 7804 | 121 |
2453017 | 2453017 | 2022-04-28 | Fayette | Pennsylvania | 42051 | 31160 | 670 |
2453279 | 2453279 | 2022-04-28 | Fayette | Tennessee | 47047 | 11437 | 185 |
2453426 | 2453426 | 2022-04-28 | Fayette | Texas | 48149 | 4781 | 105 |
2453835 | 2453835 | 2022-04-28 | Fayette | West Virginia | 54019 | 13094 | 202 |
2447492 | 2447492 | 2022-04-27 | Fayette | Alabama | 1057 | 4984 | 96 |
2447910 | 2447910 | 2022-04-27 | Fayette | Georgia | 13113 | 22592 | 319 |
2448091 | 2448091 | 2022-04-27 | Fayette | Illinois | 17051 | 7119 | 104 |
2448189 | 2448189 | 2022-04-27 | Fayette | Indiana | 18041 | 6745 | 146 |
2448294 | 2448294 | 2022-04-27 | Fayette | Iowa | 19065 | 4097 | 74 |
2448501 | 2448501 | 2022-04-27 | Fayette | Kentucky | 21067 | 95168 | 599 |
2449556 | 2449556 | 2022-04-27 | Fayette | Ohio | 39047 | 7788 | 121 |
2449761 | 2449761 | 2022-04-27 | Fayette | Pennsylvania | 42051 | 31144 | 670 |
2450023 | 2450023 | 2022-04-27 | Fayette | Tennessee | 47047 | 11437 | 185 |
2450170 | 2450170 | 2022-04-27 | Fayette | Texas | 48149 | 4777 | 105 |
2450579 | 2450579 | 2022-04-27 | Fayette | West Virginia | 54019 | 13088 | 202 |
2444236 | 2444236 | 2022-04-26 | Fayette | Alabama | 1057 | 4984 | 96 |
2444654 | 2444654 | 2022-04-26 | Fayette | Georgia | 13113 | 22500 | 318 |
2444835 | 2444835 | 2022-04-26 | Fayette | Illinois | 17051 | 7118 | 104 |
2444933 | 2444933 | 2022-04-26 | Fayette | Indiana | 18041 | 6744 | 146 |
2445038 | 2445038 | 2022-04-26 | Fayette | Iowa | 19065 | 4093 | 74 |
2445245 | 2445245 | 2022-04-26 | Fayette | Kentucky | 21067 | 95168 | 599 |
2446299 | 2446299 | 2022-04-26 | Fayette | Ohio | 39047 | 7788 | 121 |
2446504 | 2446504 | 2022-04-26 | Fayette | Pennsylvania | 42051 | 31129 | 670 |
2446766 | 2446766 | 2022-04-26 | Fayette | Tennessee | 47047 | 11430 | 185 |
2446913 | 2446913 | 2022-04-26 | Fayette | Texas | 48149 | 4774 | 105 |
2447323 | 2447323 | 2022-04-26 | Fayette | West Virginia | 54019 | 13080 | 201 |
2440980 | 2440980 | 2022-04-25 | Fayette | Alabama | 1057 | 4984 | 96 |
2441398 | 2441398 | 2022-04-25 | Fayette | Georgia | 13113 | 22500 | 318 |
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);