ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

8,612 rows where county = "Fayette" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 11

fips 11

county 1

  • Fayette · 8,612 ✖
Link rowid date ▲ county state fips cases deaths
2499603 2499603 2022-05-13 Fayette Alabama 1057 4986 96
2500021 2500021 2022-05-13 Fayette Georgia 13113 22818 321
2500202 2500202 2022-05-13 Fayette Illinois 17051 7155 104
2500300 2500300 2022-05-13 Fayette Indiana 18041 6751 146
2500405 2500405 2022-05-13 Fayette Iowa 19065 4123 74
2500612 2500612 2022-05-13 Fayette Kentucky 21067 95993 609
2501667 2501667 2022-05-13 Fayette Ohio 39047 7846 121
2501872 2501872 2022-05-13 Fayette Pennsylvania 42051 31332 674
2502134 2502134 2022-05-13 Fayette Tennessee 47047 11475 186
2502281 2502281 2022-05-13 Fayette Texas 48149 4796 105
2502692 2502692 2022-05-13 Fayette West Virginia 54019 13217 205
2496345 2496345 2022-05-12 Fayette Alabama 1057 4983 96
2496763 2496763 2022-05-12 Fayette Georgia 13113 22818 321
2496944 2496944 2022-05-12 Fayette Illinois 17051 7151 104
2497042 2497042 2022-05-12 Fayette Indiana 18041 6750 146
2497147 2497147 2022-05-12 Fayette Iowa 19065 4123 74
2497354 2497354 2022-05-12 Fayette Kentucky 21067 95993 609
2498409 2498409 2022-05-12 Fayette Ohio 39047 7846 121
2498614 2498614 2022-05-12 Fayette Pennsylvania 42051 31332 674
2498876 2498876 2022-05-12 Fayette Tennessee 47047 11475 186
2499023 2499023 2022-05-12 Fayette Texas 48149 4796 105
2499434 2499434 2022-05-12 Fayette West Virginia 54019 13207 205
2493087 2493087 2022-05-11 Fayette Alabama 1057 4983 96
2493505 2493505 2022-05-11 Fayette Georgia 13113 22818 321
2493686 2493686 2022-05-11 Fayette Illinois 17051 7150 104
2493784 2493784 2022-05-11 Fayette Indiana 18041 6750 146
2493889 2493889 2022-05-11 Fayette Iowa 19065 4123 74
2494096 2494096 2022-05-11 Fayette Kentucky 21067 95993 609
2495151 2495151 2022-05-11 Fayette Ohio 39047 7822 121
2495356 2495356 2022-05-11 Fayette Pennsylvania 42051 31332 674
2495618 2495618 2022-05-11 Fayette Tennessee 47047 11475 186
2495765 2495765 2022-05-11 Fayette Texas 48149 4795 105
2496176 2496176 2022-05-11 Fayette West Virginia 54019 13189 205
2489829 2489829 2022-05-10 Fayette Alabama 1057 4983 96
2490247 2490247 2022-05-10 Fayette Georgia 13113 22691 319
2490428 2490428 2022-05-10 Fayette Illinois 17051 7146 104
2490526 2490526 2022-05-10 Fayette Indiana 18041 6747 146
2490631 2490631 2022-05-10 Fayette Iowa 19065 4110 74
2490838 2490838 2022-05-10 Fayette Kentucky 21067 95993 609
2491893 2491893 2022-05-10 Fayette Ohio 39047 7822 121
2492098 2492098 2022-05-10 Fayette Pennsylvania 42051 31216 674
2492360 2492360 2022-05-10 Fayette Tennessee 47047 11455 185
2492507 2492507 2022-05-10 Fayette Texas 48149 4794 105
2492918 2492918 2022-05-10 Fayette West Virginia 54019 13178 204
2486572 2486572 2022-05-09 Fayette Alabama 1057 4983 96
2486990 2486990 2022-05-09 Fayette Georgia 13113 22691 319
2487171 2487171 2022-05-09 Fayette Illinois 17051 7142 104
2487269 2487269 2022-05-09 Fayette Indiana 18041 6747 146
2487374 2487374 2022-05-09 Fayette Iowa 19065 4110 74
2487581 2487581 2022-05-09 Fayette Kentucky 21067 95993 609
2488635 2488635 2022-05-09 Fayette Ohio 39047 7822 121
2488840 2488840 2022-05-09 Fayette Pennsylvania 42051 31216 674
2489102 2489102 2022-05-09 Fayette Tennessee 47047 11455 185
2489249 2489249 2022-05-09 Fayette Texas 48149 4794 105
2489660 2489660 2022-05-09 Fayette West Virginia 54019 13178 204
2483314 2483314 2022-05-08 Fayette Alabama 1057 4983 96
2483732 2483732 2022-05-08 Fayette Georgia 13113 22689 319
2483913 2483913 2022-05-08 Fayette Illinois 17051 7137 104
2484011 2484011 2022-05-08 Fayette Indiana 18041 6745 146
2484116 2484116 2022-05-08 Fayette Iowa 19065 4110 74
2484323 2484323 2022-05-08 Fayette Kentucky 21067 95539 602
2485378 2485378 2022-05-08 Fayette Ohio 39047 7822 121
2485583 2485583 2022-05-08 Fayette Pennsylvania 42051 31216 674
2485845 2485845 2022-05-08 Fayette Tennessee 47047 11455 185
2485992 2485992 2022-05-08 Fayette Texas 48149 4794 105
2486403 2486403 2022-05-08 Fayette West Virginia 54019 13152 204
2480056 2480056 2022-05-07 Fayette Alabama 1057 4983 96
2480474 2480474 2022-05-07 Fayette Georgia 13113 22689 319
2480655 2480655 2022-05-07 Fayette Illinois 17051 7137 104
2480753 2480753 2022-05-07 Fayette Indiana 18041 6745 146
2480858 2480858 2022-05-07 Fayette Iowa 19065 4110 74
2481065 2481065 2022-05-07 Fayette Kentucky 21067 95539 602
2482120 2482120 2022-05-07 Fayette Ohio 39047 7822 121
2482325 2482325 2022-05-07 Fayette Pennsylvania 42051 31216 674
2482587 2482587 2022-05-07 Fayette Tennessee 47047 11455 185
2482734 2482734 2022-05-07 Fayette Texas 48149 4792 105
2483145 2483145 2022-05-07 Fayette West Virginia 54019 13152 204
2476798 2476798 2022-05-06 Fayette Alabama 1057 4983 96
2477216 2477216 2022-05-06 Fayette Georgia 13113 22689 319
2477397 2477397 2022-05-06 Fayette Illinois 17051 7137 104
2477495 2477495 2022-05-06 Fayette Indiana 18041 6745 146
2477600 2477600 2022-05-06 Fayette Iowa 19065 4110 74
2477807 2477807 2022-05-06 Fayette Kentucky 21067 95539 602
2478862 2478862 2022-05-06 Fayette Ohio 39047 7822 121
2479067 2479067 2022-05-06 Fayette Pennsylvania 42051 31216 674
2479329 2479329 2022-05-06 Fayette Tennessee 47047 11455 185
2479476 2479476 2022-05-06 Fayette Texas 48149 4790 105
2479887 2479887 2022-05-06 Fayette West Virginia 54019 13152 204
2473540 2473540 2022-05-05 Fayette Alabama 1057 4983 96
2473958 2473958 2022-05-05 Fayette Georgia 13113 22689 319
2474139 2474139 2022-05-05 Fayette Illinois 17051 7137 104
2474237 2474237 2022-05-05 Fayette Indiana 18041 6745 146
2474342 2474342 2022-05-05 Fayette Iowa 19065 4110 74
2474549 2474549 2022-05-05 Fayette Kentucky 21067 95539 602
2475604 2475604 2022-05-05 Fayette Ohio 39047 7822 121
2475809 2475809 2022-05-05 Fayette Pennsylvania 42051 31216 674
2476071 2476071 2022-05-05 Fayette Tennessee 47047 11455 185
2476218 2476218 2022-05-05 Fayette Texas 48149 4789 105
2476629 2476629 2022-05-05 Fayette West Virginia 54019 13139 204
2470283 2470283 2022-05-04 Fayette Alabama 1057 4983 96

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);