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 |
---|---|---|---|---|---|---|---|
280816 | 280816 | 2020-06-28 | Fayette | Alabama | 1057 | 69 | 1 |
281224 | 281224 | 2020-06-28 | Fayette | Georgia | 13113 | 326 | 17 |
281398 | 281398 | 2020-06-28 | Fayette | Illinois | 17051 | 23 | 3 |
281495 | 281495 | 2020-06-28 | Fayette | Indiana | 18041 | 145 | 7 |
281599 | 281599 | 2020-06-28 | Fayette | Iowa | 19065 | 31 | 0 |
281795 | 281795 | 2020-06-28 | Fayette | Kentucky | 21067 | 1439 | 24 |
282798 | 282798 | 2020-06-28 | Fayette | Ohio | 39047 | 45 | 0 |
282997 | 282997 | 2020-06-28 | Fayette | Pennsylvania | 42051 | 111 | 4 |
283252 | 283252 | 2020-06-28 | Fayette | Tennessee | 47047 | 244 | 2 |
283397 | 283397 | 2020-06-28 | Fayette | Texas | 48149 | 80 | 2 |
283793 | 283793 | 2020-06-28 | Fayette | West Virginia | 54019 | 67 | 4 |
277668 | 277668 | 2020-06-27 | Fayette | Alabama | 1057 | 68 | 1 |
278077 | 278077 | 2020-06-27 | Fayette | Georgia | 13113 | 324 | 17 |
278250 | 278250 | 2020-06-27 | Fayette | Illinois | 17051 | 23 | 3 |
278347 | 278347 | 2020-06-27 | Fayette | Indiana | 18041 | 144 | 7 |
278451 | 278451 | 2020-06-27 | Fayette | Iowa | 19065 | 31 | 0 |
278647 | 278647 | 2020-06-27 | Fayette | Kentucky | 21067 | 1439 | 24 |
279652 | 279652 | 2020-06-27 | Fayette | Ohio | 39047 | 45 | 0 |
279851 | 279851 | 2020-06-27 | Fayette | Pennsylvania | 42051 | 110 | 4 |
280106 | 280106 | 2020-06-27 | Fayette | Tennessee | 47047 | 244 | 2 |
280251 | 280251 | 2020-06-27 | Fayette | Texas | 48149 | 75 | 2 |
280647 | 280647 | 2020-06-27 | Fayette | West Virginia | 54019 | 64 | 4 |
274520 | 274520 | 2020-06-26 | Fayette | Alabama | 1057 | 67 | 1 |
274929 | 274929 | 2020-06-26 | Fayette | Georgia | 13113 | 322 | 17 |
275102 | 275102 | 2020-06-26 | Fayette | Illinois | 17051 | 23 | 3 |
275199 | 275199 | 2020-06-26 | Fayette | Indiana | 18041 | 140 | 7 |
275303 | 275303 | 2020-06-26 | Fayette | Iowa | 19065 | 30 | 0 |
275499 | 275499 | 2020-06-26 | Fayette | Kentucky | 21067 | 1398 | 24 |
276504 | 276504 | 2020-06-26 | Fayette | Ohio | 39047 | 45 | 0 |
276703 | 276703 | 2020-06-26 | Fayette | Pennsylvania | 42051 | 106 | 4 |
276958 | 276958 | 2020-06-26 | Fayette | Tennessee | 47047 | 233 | 2 |
277103 | 277103 | 2020-06-26 | Fayette | Texas | 48149 | 75 | 2 |
277499 | 277499 | 2020-06-26 | Fayette | West Virginia | 54019 | 62 | 4 |
271380 | 271380 | 2020-06-25 | Fayette | Alabama | 1057 | 65 | 1 |
271789 | 271789 | 2020-06-25 | Fayette | Georgia | 13113 | 314 | 17 |
271960 | 271960 | 2020-06-25 | Fayette | Illinois | 17051 | 23 | 3 |
272057 | 272057 | 2020-06-25 | Fayette | Indiana | 18041 | 138 | 7 |
272161 | 272161 | 2020-06-25 | Fayette | Iowa | 19065 | 30 | 0 |
272356 | 272356 | 2020-06-25 | Fayette | Kentucky | 21067 | 1374 | 23 |
273357 | 273357 | 2020-06-25 | Fayette | Ohio | 39047 | 45 | 0 |
273556 | 273556 | 2020-06-25 | Fayette | Pennsylvania | 42051 | 104 | 4 |
273811 | 273811 | 2020-06-25 | Fayette | Tennessee | 47047 | 229 | 2 |
273956 | 273956 | 2020-06-25 | Fayette | Texas | 48149 | 76 | 2 |
274351 | 274351 | 2020-06-25 | Fayette | West Virginia | 54019 | 64 | 4 |
268246 | 268246 | 2020-06-24 | Fayette | Alabama | 1057 | 63 | 1 |
268653 | 268653 | 2020-06-24 | Fayette | Georgia | 13113 | 305 | 16 |
268823 | 268823 | 2020-06-24 | Fayette | Illinois | 17051 | 23 | 3 |
268920 | 268920 | 2020-06-24 | Fayette | Indiana | 18041 | 136 | 7 |
269024 | 269024 | 2020-06-24 | Fayette | Iowa | 19065 | 30 | 0 |
269220 | 269220 | 2020-06-24 | Fayette | Kentucky | 21067 | 1334 | 22 |
270218 | 270218 | 2020-06-24 | Fayette | Ohio | 39047 | 45 | 0 |
270417 | 270417 | 2020-06-24 | Fayette | Pennsylvania | 42051 | 104 | 4 |
270672 | 270672 | 2020-06-24 | Fayette | Tennessee | 47047 | 224 | 2 |
270816 | 270816 | 2020-06-24 | Fayette | Texas | 48149 | 75 | 2 |
271211 | 271211 | 2020-06-24 | Fayette | West Virginia | 54019 | 62 | 4 |
265117 | 265117 | 2020-06-23 | Fayette | Alabama | 1057 | 62 | 1 |
265523 | 265523 | 2020-06-23 | Fayette | Georgia | 13113 | 299 | 16 |
265693 | 265693 | 2020-06-23 | Fayette | Illinois | 17051 | 23 | 3 |
265790 | 265790 | 2020-06-23 | Fayette | Indiana | 18041 | 134 | 7 |
265894 | 265894 | 2020-06-23 | Fayette | Iowa | 19065 | 30 | 0 |
266087 | 266087 | 2020-06-23 | Fayette | Kentucky | 21067 | 1307 | 22 |
267084 | 267084 | 2020-06-23 | Fayette | Ohio | 39047 | 45 | 0 |
267283 | 267283 | 2020-06-23 | Fayette | Pennsylvania | 42051 | 104 | 4 |
267538 | 267538 | 2020-06-23 | Fayette | Tennessee | 47047 | 213 | 2 |
267682 | 267682 | 2020-06-23 | Fayette | Texas | 48149 | 71 | 2 |
268077 | 268077 | 2020-06-23 | Fayette | West Virginia | 54019 | 59 | 4 |
261988 | 261988 | 2020-06-22 | Fayette | Alabama | 1057 | 61 | 1 |
262395 | 262395 | 2020-06-22 | Fayette | Georgia | 13113 | 292 | 16 |
262565 | 262565 | 2020-06-22 | Fayette | Illinois | 17051 | 23 | 3 |
262662 | 262662 | 2020-06-22 | Fayette | Indiana | 18041 | 133 | 7 |
262766 | 262766 | 2020-06-22 | Fayette | Iowa | 19065 | 29 | 0 |
262960 | 262960 | 2020-06-22 | Fayette | Kentucky | 21067 | 1284 | 21 |
263956 | 263956 | 2020-06-22 | Fayette | Ohio | 39047 | 45 | 0 |
264155 | 264155 | 2020-06-22 | Fayette | Pennsylvania | 42051 | 104 | 4 |
264410 | 264410 | 2020-06-22 | Fayette | Tennessee | 47047 | 203 | 2 |
264554 | 264554 | 2020-06-22 | Fayette | Texas | 48149 | 66 | 2 |
264948 | 264948 | 2020-06-22 | Fayette | West Virginia | 54019 | 59 | 4 |
258861 | 258861 | 2020-06-21 | Fayette | Alabama | 1057 | 61 | 1 |
259268 | 259268 | 2020-06-21 | Fayette | Georgia | 13113 | 280 | 16 |
259438 | 259438 | 2020-06-21 | Fayette | Illinois | 17051 | 23 | 3 |
259535 | 259535 | 2020-06-21 | Fayette | Indiana | 18041 | 133 | 7 |
259639 | 259639 | 2020-06-21 | Fayette | Iowa | 19065 | 29 | 0 |
259831 | 259831 | 2020-06-21 | Fayette | Kentucky | 21067 | 1235 | 21 |
260828 | 260828 | 2020-06-21 | Fayette | Ohio | 39047 | 45 | 0 |
261027 | 261027 | 2020-06-21 | Fayette | Pennsylvania | 42051 | 104 | 4 |
261282 | 261282 | 2020-06-21 | Fayette | Tennessee | 47047 | 195 | 2 |
261426 | 261426 | 2020-06-21 | Fayette | Texas | 48149 | 60 | 2 |
261819 | 261819 | 2020-06-21 | Fayette | West Virginia | 54019 | 58 | 4 |
255734 | 255734 | 2020-06-20 | Fayette | Alabama | 1057 | 61 | 1 |
256141 | 256141 | 2020-06-20 | Fayette | Georgia | 13113 | 279 | 16 |
256312 | 256312 | 2020-06-20 | Fayette | Illinois | 17051 | 23 | 3 |
256409 | 256409 | 2020-06-20 | Fayette | Indiana | 18041 | 133 | 7 |
256513 | 256513 | 2020-06-20 | Fayette | Iowa | 19065 | 28 | 0 |
256705 | 256705 | 2020-06-20 | Fayette | Kentucky | 21067 | 1235 | 21 |
257701 | 257701 | 2020-06-20 | Fayette | Ohio | 39047 | 45 | 0 |
257900 | 257900 | 2020-06-20 | Fayette | Pennsylvania | 42051 | 103 | 4 |
258155 | 258155 | 2020-06-20 | Fayette | Tennessee | 47047 | 193 | 2 |
258299 | 258299 | 2020-06-20 | Fayette | Texas | 48149 | 58 | 2 |
258692 | 258692 | 2020-06-20 | Fayette | West Virginia | 54019 | 57 | 4 |
252615 | 252615 | 2020-06-19 | Fayette | Alabama | 1057 | 60 | 1 |
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);