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 |
---|---|---|---|---|---|---|---|
386383 | 386383 | 2020-07-31 | Fayette | Georgia | 13113 | 918 | 24 |
386560 | 386560 | 2020-07-31 | Fayette | Illinois | 17051 | 53 | 3 |
386658 | 386658 | 2020-07-31 | Fayette | Indiana | 18041 | 217 | 7 |
386762 | 386762 | 2020-07-31 | Fayette | Iowa | 19065 | 77 | 0 |
386966 | 386966 | 2020-07-31 | Fayette | Kentucky | 21067 | 3164 | 46 |
388000 | 388000 | 2020-07-31 | Fayette | Ohio | 39047 | 88 | 0 |
388202 | 388202 | 2020-07-31 | Fayette | Pennsylvania | 42051 | 387 | 4 |
388463 | 388463 | 2020-07-31 | Fayette | Tennessee | 47047 | 596 | 8 |
388609 | 388609 | 2020-07-31 | Fayette | Texas | 48149 | 299 | 13 |
389015 | 389015 | 2020-07-31 | Fayette | West Virginia | 54019 | 126 | 5 |
382750 | 382750 | 2020-07-30 | Fayette | Alabama | 1057 | 170 | 5 |
383165 | 383165 | 2020-07-30 | Fayette | Georgia | 13113 | 898 | 24 |
383342 | 383342 | 2020-07-30 | Fayette | Illinois | 17051 | 52 | 3 |
383440 | 383440 | 2020-07-30 | Fayette | Indiana | 18041 | 210 | 7 |
383544 | 383544 | 2020-07-30 | Fayette | Iowa | 19065 | 75 | 0 |
383748 | 383748 | 2020-07-30 | Fayette | Kentucky | 21067 | 3075 | 45 |
384783 | 384783 | 2020-07-30 | Fayette | Ohio | 39047 | 80 | 0 |
384985 | 384985 | 2020-07-30 | Fayette | Pennsylvania | 42051 | 363 | 4 |
385246 | 385246 | 2020-07-30 | Fayette | Tennessee | 47047 | 584 | 8 |
385392 | 385392 | 2020-07-30 | Fayette | Texas | 48149 | 297 | 13 |
385798 | 385798 | 2020-07-30 | Fayette | West Virginia | 54019 | 124 | 5 |
379533 | 379533 | 2020-07-29 | Fayette | Alabama | 1057 | 163 | 5 |
379948 | 379948 | 2020-07-29 | Fayette | Georgia | 13113 | 873 | 24 |
380125 | 380125 | 2020-07-29 | Fayette | Illinois | 17051 | 51 | 3 |
380223 | 380223 | 2020-07-29 | Fayette | Indiana | 18041 | 205 | 7 |
380327 | 380327 | 2020-07-29 | Fayette | Iowa | 19065 | 75 | 0 |
380531 | 380531 | 2020-07-29 | Fayette | Kentucky | 21067 | 3026 | 45 |
381565 | 381565 | 2020-07-29 | Fayette | Ohio | 39047 | 76 | 0 |
381767 | 381767 | 2020-07-29 | Fayette | Pennsylvania | 42051 | 352 | 4 |
382028 | 382028 | 2020-07-29 | Fayette | Tennessee | 47047 | 574 | 8 |
382174 | 382174 | 2020-07-29 | Fayette | Texas | 48149 | 296 | 13 |
382580 | 382580 | 2020-07-29 | Fayette | West Virginia | 54019 | 124 | 5 |
376317 | 376317 | 2020-07-28 | Fayette | Alabama | 1057 | 158 | 5 |
376731 | 376731 | 2020-07-28 | Fayette | Georgia | 13113 | 855 | 23 |
376908 | 376908 | 2020-07-28 | Fayette | Illinois | 17051 | 44 | 3 |
377006 | 377006 | 2020-07-28 | Fayette | Indiana | 18041 | 198 | 7 |
377110 | 377110 | 2020-07-28 | Fayette | Iowa | 19065 | 72 | 0 |
377314 | 377314 | 2020-07-28 | Fayette | Kentucky | 21067 | 2972 | 45 |
378348 | 378348 | 2020-07-28 | Fayette | Ohio | 39047 | 73 | 0 |
378550 | 378550 | 2020-07-28 | Fayette | Pennsylvania | 42051 | 336 | 4 |
378811 | 378811 | 2020-07-28 | Fayette | Tennessee | 47047 | 567 | 8 |
378957 | 378957 | 2020-07-28 | Fayette | Texas | 48149 | 291 | 13 |
379363 | 379363 | 2020-07-28 | Fayette | West Virginia | 54019 | 122 | 5 |
373103 | 373103 | 2020-07-27 | Fayette | Alabama | 1057 | 151 | 5 |
373517 | 373517 | 2020-07-27 | Fayette | Georgia | 13113 | 825 | 23 |
373693 | 373693 | 2020-07-27 | Fayette | Illinois | 17051 | 43 | 3 |
373791 | 373791 | 2020-07-27 | Fayette | Indiana | 18041 | 195 | 7 |
373895 | 373895 | 2020-07-27 | Fayette | Iowa | 19065 | 71 | 0 |
374099 | 374099 | 2020-07-27 | Fayette | Kentucky | 21067 | 2856 | 45 |
375131 | 375131 | 2020-07-27 | Fayette | Ohio | 39047 | 71 | 0 |
375334 | 375334 | 2020-07-27 | Fayette | Pennsylvania | 42051 | 314 | 4 |
375595 | 375595 | 2020-07-27 | Fayette | Tennessee | 47047 | 541 | 8 |
375741 | 375741 | 2020-07-27 | Fayette | Texas | 48149 | 281 | 12 |
376147 | 376147 | 2020-07-27 | Fayette | West Virginia | 54019 | 118 | 5 |
369891 | 369891 | 2020-07-26 | Fayette | Alabama | 1057 | 144 | 5 |
370305 | 370305 | 2020-07-26 | Fayette | Georgia | 13113 | 805 | 23 |
370481 | 370481 | 2020-07-26 | Fayette | Illinois | 17051 | 43 | 3 |
370579 | 370579 | 2020-07-26 | Fayette | Indiana | 18041 | 195 | 7 |
370683 | 370683 | 2020-07-26 | Fayette | Iowa | 19065 | 71 | 0 |
370887 | 370887 | 2020-07-26 | Fayette | Kentucky | 21067 | 2758 | 44 |
371919 | 371919 | 2020-07-26 | Fayette | Ohio | 39047 | 68 | 0 |
372121 | 372121 | 2020-07-26 | Fayette | Pennsylvania | 42051 | 311 | 4 |
372382 | 372382 | 2020-07-26 | Fayette | Tennessee | 47047 | 525 | 8 |
372528 | 372528 | 2020-07-26 | Fayette | Texas | 48149 | 281 | 5 |
372933 | 372933 | 2020-07-26 | Fayette | West Virginia | 54019 | 117 | 5 |
366681 | 366681 | 2020-07-25 | Fayette | Alabama | 1057 | 139 | 5 |
367095 | 367095 | 2020-07-25 | Fayette | Georgia | 13113 | 788 | 23 |
367271 | 367271 | 2020-07-25 | Fayette | Illinois | 17051 | 41 | 3 |
367369 | 367369 | 2020-07-25 | Fayette | Indiana | 18041 | 192 | 7 |
367473 | 367473 | 2020-07-25 | Fayette | Iowa | 19065 | 72 | 0 |
367677 | 367677 | 2020-07-25 | Fayette | Kentucky | 21067 | 2758 | 44 |
368707 | 368707 | 2020-07-25 | Fayette | Ohio | 39047 | 66 | 0 |
368909 | 368909 | 2020-07-25 | Fayette | Pennsylvania | 42051 | 307 | 4 |
369170 | 369170 | 2020-07-25 | Fayette | Tennessee | 47047 | 519 | 8 |
369316 | 369316 | 2020-07-25 | Fayette | Texas | 48149 | 281 | 5 |
369721 | 369721 | 2020-07-25 | Fayette | West Virginia | 54019 | 114 | 5 |
363474 | 363474 | 2020-07-24 | Fayette | Alabama | 1057 | 137 | 5 |
363888 | 363888 | 2020-07-24 | Fayette | Georgia | 13113 | 764 | 23 |
364064 | 364064 | 2020-07-24 | Fayette | Illinois | 17051 | 41 | 3 |
364162 | 364162 | 2020-07-24 | Fayette | Indiana | 18041 | 187 | 7 |
364266 | 364266 | 2020-07-24 | Fayette | Iowa | 19065 | 69 | 0 |
364470 | 364470 | 2020-07-24 | Fayette | Kentucky | 21067 | 2711 | 42 |
365498 | 365498 | 2020-07-24 | Fayette | Ohio | 39047 | 65 | 0 |
365700 | 365700 | 2020-07-24 | Fayette | Pennsylvania | 42051 | 301 | 4 |
365961 | 365961 | 2020-07-24 | Fayette | Tennessee | 47047 | 512 | 8 |
366107 | 366107 | 2020-07-24 | Fayette | Texas | 48149 | 275 | 5 |
366511 | 366511 | 2020-07-24 | Fayette | West Virginia | 54019 | 111 | 5 |
360268 | 360268 | 2020-07-23 | Fayette | Alabama | 1057 | 133 | 5 |
360681 | 360681 | 2020-07-23 | Fayette | Georgia | 13113 | 742 | 21 |
360857 | 360857 | 2020-07-23 | Fayette | Illinois | 17051 | 40 | 3 |
360955 | 360955 | 2020-07-23 | Fayette | Indiana | 18041 | 186 | 7 |
361059 | 361059 | 2020-07-23 | Fayette | Iowa | 19065 | 68 | 0 |
361263 | 361263 | 2020-07-23 | Fayette | Kentucky | 21067 | 2611 | 42 |
362292 | 362292 | 2020-07-23 | Fayette | Ohio | 39047 | 64 | 0 |
362494 | 362494 | 2020-07-23 | Fayette | Pennsylvania | 42051 | 294 | 4 |
362755 | 362755 | 2020-07-23 | Fayette | Tennessee | 47047 | 510 | 8 |
362901 | 362901 | 2020-07-23 | Fayette | Texas | 48149 | 270 | 5 |
363304 | 363304 | 2020-07-23 | Fayette | West Virginia | 54019 | 107 | 5 |
357063 | 357063 | 2020-07-22 | Fayette | Alabama | 1057 | 129 | 5 |
357476 | 357476 | 2020-07-22 | Fayette | Georgia | 13113 | 702 | 21 |
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);