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 |
---|---|---|---|---|---|---|---|
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 |
253022 | 253022 | 2020-06-19 | Fayette | Georgia | 13113 | 278 | 16 |
253192 | 253192 | 2020-06-19 | Fayette | Illinois | 17051 | 23 | 3 |
253289 | 253289 | 2020-06-19 | Fayette | Indiana | 18041 | 133 | 7 |
253393 | 253393 | 2020-06-19 | Fayette | Iowa | 19065 | 28 | 0 |
253585 | 253585 | 2020-06-19 | Fayette | Kentucky | 21067 | 1214 | 21 |
254576 | 254576 | 2020-06-19 | Fayette | Ohio | 39047 | 45 | 0 |
254774 | 254774 | 2020-06-19 | Fayette | Pennsylvania | 42051 | 103 | 4 |
255029 | 255029 | 2020-06-19 | Fayette | Tennessee | 47047 | 193 | 2 |
255172 | 255172 | 2020-06-19 | Fayette | Texas | 48149 | 52 | 2 |
255565 | 255565 | 2020-06-19 | Fayette | West Virginia | 54019 | 56 | 4 |
249500 | 249500 | 2020-06-18 | Fayette | Alabama | 1057 | 52 | 1 |
249907 | 249907 | 2020-06-18 | Fayette | Georgia | 13113 | 271 | 16 |
250077 | 250077 | 2020-06-18 | Fayette | Illinois | 17051 | 23 | 3 |
250174 | 250174 | 2020-06-18 | Fayette | Indiana | 18041 | 133 | 7 |
250278 | 250278 | 2020-06-18 | Fayette | Iowa | 19065 | 28 | 0 |
250470 | 250470 | 2020-06-18 | Fayette | Kentucky | 21067 | 1194 | 21 |
251461 | 251461 | 2020-06-18 | Fayette | Ohio | 39047 | 45 | 0 |
251659 | 251659 | 2020-06-18 | Fayette | Pennsylvania | 42051 | 100 | 4 |
251914 | 251914 | 2020-06-18 | Fayette | Tennessee | 47047 | 189 | 2 |
252057 | 252057 | 2020-06-18 | Fayette | Texas | 48149 | 51 | 2 |
252446 | 252446 | 2020-06-18 | Fayette | West Virginia | 54019 | 56 | 4 |
246388 | 246388 | 2020-06-17 | Fayette | Alabama | 1057 | 52 | 0 |
246795 | 246795 | 2020-06-17 | Fayette | Georgia | 13113 | 271 | 16 |
246965 | 246965 | 2020-06-17 | Fayette | Illinois | 17051 | 23 | 3 |
247062 | 247062 | 2020-06-17 | Fayette | Indiana | 18041 | 131 | 7 |
247166 | 247166 | 2020-06-17 | Fayette | Iowa | 19065 | 28 | 0 |
247358 | 247358 | 2020-06-17 | Fayette | Kentucky | 21067 | 1158 | 20 |
248346 | 248346 | 2020-06-17 | Fayette | Ohio | 39047 | 45 | 0 |
248544 | 248544 | 2020-06-17 | Fayette | Pennsylvania | 42051 | 98 | 4 |
248799 | 248799 | 2020-06-17 | Fayette | Tennessee | 47047 | 186 | 2 |
248942 | 248942 | 2020-06-17 | Fayette | Texas | 48149 | 52 | 2 |
249331 | 249331 | 2020-06-17 | Fayette | West Virginia | 54019 | 54 | 4 |
243275 | 243275 | 2020-06-16 | Fayette | Alabama | 1057 | 50 | 0 |
243682 | 243682 | 2020-06-16 | Fayette | Georgia | 13113 | 270 | 16 |
243852 | 243852 | 2020-06-16 | Fayette | Illinois | 17051 | 22 | 3 |
243949 | 243949 | 2020-06-16 | Fayette | Indiana | 18041 | 130 | 7 |
244053 | 244053 | 2020-06-16 | Fayette | Iowa | 19065 | 28 | 0 |
244245 | 244245 | 2020-06-16 | Fayette | Kentucky | 21067 | 1146 | 20 |
245233 | 245233 | 2020-06-16 | Fayette | Ohio | 39047 | 45 | 0 |
245431 | 245431 | 2020-06-16 | Fayette | Pennsylvania | 42051 | 95 | 4 |
245686 | 245686 | 2020-06-16 | Fayette | Tennessee | 47047 | 183 | 2 |
245829 | 245829 | 2020-06-16 | Fayette | Texas | 48149 | 45 | 2 |
246219 | 246219 | 2020-06-16 | Fayette | West Virginia | 54019 | 54 | 4 |
240164 | 240164 | 2020-06-15 | Fayette | Alabama | 1057 | 48 | 0 |
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);