ny_times_us_counties

⚠️ 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

1,143 rows where county = "Fayette" sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

state

fips

county

  • Fayette · 1,143
Link rowid date ▲ county state fips cases deaths
291788 2020-07-03 Fayette Alabama 1057 70 1
292200 2020-07-03 Fayette Georgia 13113 384 19
292376 2020-07-03 Fayette Illinois 17051 23 3
292474 2020-07-03 Fayette Indiana 18041 148 7
292578 2020-07-03 Fayette Iowa 19065 45 0
292775 2020-07-03 Fayette Kentucky 21067 1637 30
293783 2020-07-03 Fayette Ohio 39047 46 0
293983 2020-07-03 Fayette Pennsylvania 42051 132 4
294161 2020-07-03 Fayette Tennessee 47047 310 2
294306 2020-07-03 Fayette Texas 48149 96 2
294701 2020-07-03 Fayette West Virginia 54019 67 4
288712 2020-07-02 Fayette Alabama 1057 70 1
289123 2020-07-02 Fayette Georgia 13113 363 19
289298 2020-07-02 Fayette Illinois 17051 23 3
289395 2020-07-02 Fayette Indiana 18041 146 7
289499 2020-07-02 Fayette Iowa 19065 34 0
289696 2020-07-02 Fayette Kentucky 21067 1599 29
290702 2020-07-02 Fayette Ohio 39047 46 0
290903 2020-07-02 Fayette Pennsylvania 42051 127 4
291080 2020-07-02 Fayette Tennessee 47047 301 2
291225 2020-07-02 Fayette Texas 48149 95 2
291618 2020-07-02 Fayette West Virginia 54019 67 4
285638 2020-07-01 Fayette Alabama 1057 70 1
286048 2020-07-01 Fayette Georgia 13113 346 19
286223 2020-07-01 Fayette Illinois 17051 23 3
286320 2020-07-01 Fayette Indiana 18041 146 7
286424 2020-07-01 Fayette Iowa 19065 33 0
286621 2020-07-01 Fayette Kentucky 21067 1553 29
287626 2020-07-01 Fayette Ohio 39047 46 0
287826 2020-07-01 Fayette Pennsylvania 42051 117 4
288003 2020-07-01 Fayette Tennessee 47047 292 2
288149 2020-07-01 Fayette Texas 48149 90 2
288542 2020-07-01 Fayette West Virginia 54019 66 4
282565 2020-06-30 Fayette Alabama 1057 69 1
282975 2020-06-30 Fayette Georgia 13113 341 17
283151 2020-06-30 Fayette Illinois 17051 23 3
283248 2020-06-30 Fayette Indiana 18041 145 7
283352 2020-06-30 Fayette Iowa 19065 33 0
283550 2020-06-30 Fayette Kentucky 21067 1514 28
284553 2020-06-30 Fayette Ohio 39047 46 0
284753 2020-06-30 Fayette Pennsylvania 42051 116 4
284930 2020-06-30 Fayette Tennessee 47047 273 2
285075 2020-06-30 Fayette Texas 48149 86 2
285468 2020-06-30 Fayette West Virginia 54019 66 4
279496 2020-06-29 Fayette Alabama 1057 69 1
279906 2020-06-29 Fayette Georgia 13113 326 17
280079 2020-06-29 Fayette Illinois 17051 23 3
280176 2020-06-29 Fayette Indiana 18041 145 7
280280 2020-06-29 Fayette Iowa 19065 32 0
280478 2020-06-29 Fayette Kentucky 21067 1491 27
281480 2020-06-29 Fayette Ohio 39047 46 0
281679 2020-06-29 Fayette Pennsylvania 42051 112 4
281856 2020-06-29 Fayette Tennessee 47047 263 2
282002 2020-06-29 Fayette Texas 48149 86 2
282395 2020-06-29 Fayette West Virginia 54019 66 4
276428 2020-06-28 Fayette Alabama 1057 69 1
276838 2020-06-28 Fayette Georgia 13113 326 17
277012 2020-06-28 Fayette Illinois 17051 23 3
277109 2020-06-28 Fayette Indiana 18041 145 7
277213 2020-06-28 Fayette Iowa 19065 31 0
277409 2020-06-28 Fayette Kentucky 21067 1439 24
278412 2020-06-28 Fayette Ohio 39047 45 0
278611 2020-06-28 Fayette Pennsylvania 42051 111 4
278788 2020-06-28 Fayette Tennessee 47047 244 2
278933 2020-06-28 Fayette Texas 48149 80 2
279326 2020-06-28 Fayette West Virginia 54019 67 4
273359 2020-06-27 Fayette Alabama 1057 68 1
273769 2020-06-27 Fayette Georgia 13113 324 17
273942 2020-06-27 Fayette Illinois 17051 23 3
274039 2020-06-27 Fayette Indiana 18041 144 7
274143 2020-06-27 Fayette Iowa 19065 31 0
274339 2020-06-27 Fayette Kentucky 21067 1439 24
275344 2020-06-27 Fayette Ohio 39047 45 0
275543 2020-06-27 Fayette Pennsylvania 42051 110 4
275720 2020-06-27 Fayette Tennessee 47047 244 2
275865 2020-06-27 Fayette Texas 48149 75 2
276258 2020-06-27 Fayette West Virginia 54019 64 4
270290 2020-06-26 Fayette Alabama 1057 67 1
270700 2020-06-26 Fayette Georgia 13113 322 17
270873 2020-06-26 Fayette Illinois 17051 23 3
270970 2020-06-26 Fayette Indiana 18041 140 7
271074 2020-06-26 Fayette Iowa 19065 30 0
271270 2020-06-26 Fayette Kentucky 21067 1398 24
272275 2020-06-26 Fayette Ohio 39047 45 0
272474 2020-06-26 Fayette Pennsylvania 42051 106 4
272651 2020-06-26 Fayette Tennessee 47047 233 2
272796 2020-06-26 Fayette Texas 48149 75 2
273189 2020-06-26 Fayette West Virginia 54019 62 4
267229 2020-06-25 Fayette Alabama 1057 65 1
267639 2020-06-25 Fayette Georgia 13113 314 17
267810 2020-06-25 Fayette Illinois 17051 23 3
267907 2020-06-25 Fayette Indiana 18041 138 7
268011 2020-06-25 Fayette Iowa 19065 30 0
268206 2020-06-25 Fayette Kentucky 21067 1374 23
269207 2020-06-25 Fayette Ohio 39047 45 0
269406 2020-06-25 Fayette Pennsylvania 42051 104 4
269583 2020-06-25 Fayette Tennessee 47047 229 2
269728 2020-06-25 Fayette Texas 48149 76 2
270120 2020-06-25 Fayette West Virginia 54019 64 4
264174 2020-06-24 Fayette Alabama 1057 63 1

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
);
Powered by Datasette · Query took 913.104ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette