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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
312394 | 312394 | 2020-07-08 | Fayette | Alabama | 1057 | 75 | 1 |
315569 | 315569 | 2020-07-09 | Fayette | Alabama | 1057 | 81 | 1 |
318742 | 318742 | 2020-07-10 | Fayette | Alabama | 1057 | 84 | 1 |
321921 | 321921 | 2020-07-11 | Fayette | Alabama | 1057 | 85 | 1 |
325102 | 325102 | 2020-07-12 | Fayette | Alabama | 1057 | 88 | 1 |
328288 | 328288 | 2020-07-13 | Fayette | Alabama | 1057 | 93 | 1 |
331474 | 331474 | 2020-07-14 | Fayette | Alabama | 1057 | 93 | 2 |
334667 | 334667 | 2020-07-15 | Fayette | Alabama | 1057 | 96 | 3 |
337862 | 337862 | 2020-07-16 | Fayette | Alabama | 1057 | 108 | 3 |
341058 | 341058 | 2020-07-17 | Fayette | Alabama | 1057 | 115 | 3 |
344257 | 344257 | 2020-07-18 | Fayette | Alabama | 1057 | 121 | 5 |
347457 | 347457 | 2020-07-19 | Fayette | Alabama | 1057 | 123 | 5 |
350658 | 350658 | 2020-07-20 | Fayette | Alabama | 1057 | 125 | 5 |
353860 | 353860 | 2020-07-21 | Fayette | Alabama | 1057 | 127 | 5 |
357063 | 357063 | 2020-07-22 | Fayette | Alabama | 1057 | 129 | 5 |
360268 | 360268 | 2020-07-23 | Fayette | Alabama | 1057 | 133 | 5 |
363474 | 363474 | 2020-07-24 | Fayette | Alabama | 1057 | 137 | 5 |
366681 | 366681 | 2020-07-25 | Fayette | Alabama | 1057 | 139 | 5 |
369891 | 369891 | 2020-07-26 | Fayette | Alabama | 1057 | 144 | 5 |
373103 | 373103 | 2020-07-27 | Fayette | Alabama | 1057 | 151 | 5 |
376317 | 376317 | 2020-07-28 | Fayette | Alabama | 1057 | 158 | 5 |
379533 | 379533 | 2020-07-29 | Fayette | Alabama | 1057 | 163 | 5 |
382750 | 382750 | 2020-07-30 | Fayette | Alabama | 1057 | 170 | 5 |
385968 | 385968 | 2020-07-31 | Fayette | Alabama | 1057 | 171 | 5 |
389185 | 389185 | 2020-08-01 | Fayette | Alabama | 1057 | 175 | 5 |
392402 | 392402 | 2020-08-02 | Fayette | Alabama | 1057 | 177 | 5 |
395618 | 395618 | 2020-08-03 | Fayette | Alabama | 1057 | 182 | 5 |
398834 | 398834 | 2020-08-04 | Fayette | Alabama | 1057 | 186 | 5 |
402050 | 402050 | 2020-08-05 | Fayette | Alabama | 1057 | 188 | 5 |
405268 | 405268 | 2020-08-06 | Fayette | Alabama | 1057 | 198 | 5 |
408488 | 408488 | 2020-08-07 | Fayette | Alabama | 1057 | 212 | 5 |
411707 | 411707 | 2020-08-08 | Fayette | Alabama | 1057 | 218 | 5 |
414927 | 414927 | 2020-08-09 | Fayette | Alabama | 1057 | 221 | 5 |
418148 | 418148 | 2020-08-10 | Fayette | Alabama | 1057 | 226 | 5 |
421369 | 421369 | 2020-08-11 | Fayette | Alabama | 1057 | 237 | 5 |
424590 | 424590 | 2020-08-12 | Fayette | Alabama | 1057 | 237 | 5 |
427814 | 427814 | 2020-08-13 | Fayette | Alabama | 1057 | 244 | 5 |
431042 | 431042 | 2020-08-14 | Fayette | Alabama | 1057 | 251 | 5 |
434267 | 434267 | 2020-08-15 | Fayette | Alabama | 1057 | 254 | 5 |
437493 | 437493 | 2020-08-16 | Fayette | Alabama | 1057 | 258 | 5 |
440719 | 440719 | 2020-08-17 | Fayette | Alabama | 1057 | 264 | 5 |
443945 | 443945 | 2020-08-18 | Fayette | Alabama | 1057 | 267 | 6 |
447172 | 447172 | 2020-08-19 | Fayette | Alabama | 1057 | 274 | 6 |
450400 | 450400 | 2020-08-20 | Fayette | Alabama | 1057 | 277 | 6 |
453628 | 453628 | 2020-08-21 | Fayette | Alabama | 1057 | 281 | 6 |
456856 | 456856 | 2020-08-22 | Fayette | Alabama | 1057 | 286 | 6 |
460083 | 460083 | 2020-08-23 | Fayette | Alabama | 1057 | 291 | 6 |
463312 | 463312 | 2020-08-24 | Fayette | Alabama | 1057 | 293 | 6 |
466541 | 466541 | 2020-08-25 | Fayette | Alabama | 1057 | 293 | 6 |
469770 | 469770 | 2020-08-26 | Fayette | Alabama | 1057 | 297 | 6 |
473002 | 473002 | 2020-08-27 | Fayette | Alabama | 1057 | 301 | 6 |
476235 | 476235 | 2020-08-28 | Fayette | Alabama | 1057 | 307 | 6 |
479468 | 479468 | 2020-08-29 | Fayette | Alabama | 1057 | 311 | 6 |
482702 | 482702 | 2020-08-30 | Fayette | Alabama | 1057 | 313 | 6 |
485937 | 485937 | 2020-08-31 | Fayette | Alabama | 1057 | 315 | 6 |
489170 | 489170 | 2020-09-01 | Fayette | Alabama | 1057 | 323 | 6 |
492403 | 492403 | 2020-09-02 | Fayette | Alabama | 1057 | 327 | 6 |
495637 | 495637 | 2020-09-03 | Fayette | Alabama | 1057 | 334 | 6 |
498870 | 498870 | 2020-09-04 | Fayette | Alabama | 1057 | 341 | 6 |
502104 | 502104 | 2020-09-05 | Fayette | Alabama | 1057 | 345 | 6 |
505338 | 505338 | 2020-09-06 | Fayette | Alabama | 1057 | 348 | 6 |
508570 | 508570 | 2020-09-07 | Fayette | Alabama | 1057 | 350 | 6 |
511803 | 511803 | 2020-09-08 | Fayette | Alabama | 1057 | 356 | 6 |
515036 | 515036 | 2020-09-09 | Fayette | Alabama | 1057 | 358 | 6 |
518271 | 518271 | 2020-09-10 | Fayette | Alabama | 1057 | 367 | 6 |
521508 | 521508 | 2020-09-11 | Fayette | Alabama | 1057 | 376 | 7 |
524744 | 524744 | 2020-09-12 | Fayette | Alabama | 1057 | 383 | 7 |
527980 | 527980 | 2020-09-13 | Fayette | Alabama | 1057 | 396 | 7 |
531217 | 531217 | 2020-09-14 | Fayette | Alabama | 1057 | 400 | 7 |
534452 | 534452 | 2020-09-15 | Fayette | Alabama | 1057 | 404 | 8 |
537688 | 537688 | 2020-09-16 | Fayette | Alabama | 1057 | 408 | 8 |
540925 | 540925 | 2020-09-17 | Fayette | Alabama | 1057 | 412 | 8 |
544161 | 544161 | 2020-09-18 | Fayette | Alabama | 1057 | 415 | 9 |
547398 | 547398 | 2020-09-19 | Fayette | Alabama | 1057 | 418 | 9 |
550637 | 550637 | 2020-09-20 | Fayette | Alabama | 1057 | 421 | 9 |
553876 | 553876 | 2020-09-21 | Fayette | Alabama | 1057 | 426 | 9 |
557113 | 557113 | 2020-09-22 | Fayette | Alabama | 1057 | 429 | 9 |
560349 | 560349 | 2020-09-23 | Fayette | Alabama | 1057 | 435 | 8 |
563588 | 563588 | 2020-09-24 | Fayette | Alabama | 1057 | 443 | 8 |
566829 | 566829 | 2020-09-25 | Fayette | Alabama | 1057 | 450 | 8 |
570070 | 570070 | 2020-09-26 | Fayette | Alabama | 1057 | 457 | 8 |
573312 | 573312 | 2020-09-27 | Fayette | Alabama | 1057 | 462 | 8 |
576556 | 576556 | 2020-09-28 | Fayette | Alabama | 1057 | 467 | 8 |
579797 | 579797 | 2020-09-29 | Fayette | Alabama | 1057 | 468 | 9 |
583036 | 583036 | 2020-09-30 | Fayette | Alabama | 1057 | 473 | 11 |
586276 | 586276 | 2020-10-01 | Fayette | Alabama | 1057 | 473 | 11 |
589517 | 589517 | 2020-10-02 | Fayette | Alabama | 1057 | 474 | 10 |
592757 | 592757 | 2020-10-03 | Fayette | Alabama | 1057 | 476 | 10 |
595999 | 595999 | 2020-10-04 | Fayette | Alabama | 1057 | 485 | 10 |
599242 | 599242 | 2020-10-05 | Fayette | Alabama | 1057 | 485 | 10 |
602485 | 602485 | 2020-10-06 | Fayette | Alabama | 1057 | 490 | 10 |
605727 | 605727 | 2020-10-07 | Fayette | Alabama | 1057 | 490 | 10 |
608970 | 608970 | 2020-10-08 | Fayette | Alabama | 1057 | 490 | 10 |
612212 | 612212 | 2020-10-09 | Fayette | Alabama | 1057 | 491 | 10 |
615453 | 615453 | 2020-10-10 | Fayette | Alabama | 1057 | 497 | 10 |
618695 | 618695 | 2020-10-11 | Fayette | Alabama | 1057 | 511 | 10 |
621938 | 621938 | 2020-10-12 | Fayette | Alabama | 1057 | 515 | 10 |
625181 | 625181 | 2020-10-13 | Fayette | Alabama | 1057 | 518 | 10 |
628424 | 628424 | 2020-10-14 | Fayette | Alabama | 1057 | 520 | 10 |
631668 | 631668 | 2020-10-15 | Fayette | Alabama | 1057 | 525 | 11 |
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);