ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1013 and state = "Alabama" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
296544 | 296544 | 2020-07-03 | Butler | Alabama | 1013 | 625 | 28 |
299706 | 299706 | 2020-07-04 | Butler | Alabama | 1013 | 626 | 28 |
302870 | 302870 | 2020-07-05 | Butler | Alabama | 1013 | 635 | 28 |
306034 | 306034 | 2020-07-06 | Butler | Alabama | 1013 | 636 | 28 |
309203 | 309203 | 2020-07-07 | Butler | Alabama | 1013 | 634 | 28 |
312372 | 312372 | 2020-07-08 | Butler | Alabama | 1013 | 639 | 28 |
315547 | 315547 | 2020-07-09 | Butler | Alabama | 1013 | 646 | 28 |
318720 | 318720 | 2020-07-10 | Butler | Alabama | 1013 | 648 | 29 |
321899 | 321899 | 2020-07-11 | Butler | Alabama | 1013 | 654 | 29 |
325080 | 325080 | 2020-07-12 | Butler | Alabama | 1013 | 655 | 29 |
328266 | 328266 | 2020-07-13 | Butler | Alabama | 1013 | 660 | 29 |
331452 | 331452 | 2020-07-14 | Butler | Alabama | 1013 | 661 | 31 |
334645 | 334645 | 2020-07-15 | Butler | Alabama | 1013 | 664 | 31 |
337840 | 337840 | 2020-07-16 | Butler | Alabama | 1013 | 669 | 32 |
341036 | 341036 | 2020-07-17 | Butler | Alabama | 1013 | 672 | 33 |
344235 | 344235 | 2020-07-18 | Butler | Alabama | 1013 | 678 | 33 |
347435 | 347435 | 2020-07-19 | Butler | Alabama | 1013 | 686 | 33 |
350636 | 350636 | 2020-07-20 | Butler | Alabama | 1013 | 689 | 33 |
353838 | 353838 | 2020-07-21 | Butler | Alabama | 1013 | 695 | 34 |
357041 | 357041 | 2020-07-22 | Butler | Alabama | 1013 | 701 | 34 |
360246 | 360246 | 2020-07-23 | Butler | Alabama | 1013 | 706 | 35 |
363452 | 363452 | 2020-07-24 | Butler | Alabama | 1013 | 711 | 35 |
366659 | 366659 | 2020-07-25 | Butler | Alabama | 1013 | 720 | 35 |
369869 | 369869 | 2020-07-26 | Butler | Alabama | 1013 | 724 | 35 |
373081 | 373081 | 2020-07-27 | Butler | Alabama | 1013 | 730 | 36 |
376295 | 376295 | 2020-07-28 | Butler | Alabama | 1013 | 734 | 36 |
379511 | 379511 | 2020-07-29 | Butler | Alabama | 1013 | 742 | 36 |
382728 | 382728 | 2020-07-30 | Butler | Alabama | 1013 | 747 | 36 |
385946 | 385946 | 2020-07-31 | Butler | Alabama | 1013 | 753 | 36 |
389163 | 389163 | 2020-08-01 | Butler | Alabama | 1013 | 757 | 36 |
392380 | 392380 | 2020-08-02 | Butler | Alabama | 1013 | 765 | 36 |
395596 | 395596 | 2020-08-03 | Butler | Alabama | 1013 | 767 | 36 |
398812 | 398812 | 2020-08-04 | Butler | Alabama | 1013 | 766 | 36 |
402028 | 402028 | 2020-08-05 | Butler | Alabama | 1013 | 769 | 36 |
405246 | 405246 | 2020-08-06 | Butler | Alabama | 1013 | 771 | 36 |
408466 | 408466 | 2020-08-07 | Butler | Alabama | 1013 | 774 | 36 |
411685 | 411685 | 2020-08-08 | Butler | Alabama | 1013 | 773 | 37 |
414905 | 414905 | 2020-08-09 | Butler | Alabama | 1013 | 779 | 37 |
418126 | 418126 | 2020-08-10 | Butler | Alabama | 1013 | 782 | 37 |
421347 | 421347 | 2020-08-11 | Butler | Alabama | 1013 | 785 | 37 |
424568 | 424568 | 2020-08-12 | Butler | Alabama | 1013 | 788 | 37 |
427792 | 427792 | 2020-08-13 | Butler | Alabama | 1013 | 790 | 37 |
431020 | 431020 | 2020-08-14 | Butler | Alabama | 1013 | 796 | 37 |
434245 | 434245 | 2020-08-15 | Butler | Alabama | 1013 | 807 | 37 |
437471 | 437471 | 2020-08-16 | Butler | Alabama | 1013 | 811 | 37 |
440697 | 440697 | 2020-08-17 | Butler | Alabama | 1013 | 814 | 37 |
443923 | 443923 | 2020-08-18 | Butler | Alabama | 1013 | 815 | 37 |
447150 | 447150 | 2020-08-19 | Butler | Alabama | 1013 | 815 | 37 |
450378 | 450378 | 2020-08-20 | Butler | Alabama | 1013 | 816 | 37 |
453606 | 453606 | 2020-08-21 | Butler | Alabama | 1013 | 822 | 37 |
456834 | 456834 | 2020-08-22 | Butler | Alabama | 1013 | 822 | 37 |
460061 | 460061 | 2020-08-23 | Butler | Alabama | 1013 | 824 | 37 |
463290 | 463290 | 2020-08-24 | Butler | Alabama | 1013 | 825 | 37 |
466519 | 466519 | 2020-08-25 | Butler | Alabama | 1013 | 826 | 37 |
469748 | 469748 | 2020-08-26 | Butler | Alabama | 1013 | 833 | 37 |
472980 | 472980 | 2020-08-27 | Butler | Alabama | 1013 | 839 | 37 |
476213 | 476213 | 2020-08-28 | Butler | Alabama | 1013 | 840 | 37 |
479446 | 479446 | 2020-08-29 | Butler | Alabama | 1013 | 855 | 37 |
482680 | 482680 | 2020-08-30 | Butler | Alabama | 1013 | 864 | 37 |
485915 | 485915 | 2020-08-31 | Butler | Alabama | 1013 | 866 | 37 |
489148 | 489148 | 2020-09-01 | Butler | Alabama | 1013 | 871 | 37 |
492381 | 492381 | 2020-09-02 | Butler | Alabama | 1013 | 872 | 37 |
495615 | 495615 | 2020-09-03 | Butler | Alabama | 1013 | 874 | 37 |
498848 | 498848 | 2020-09-04 | Butler | Alabama | 1013 | 881 | 38 |
502082 | 502082 | 2020-09-05 | Butler | Alabama | 1013 | 886 | 38 |
505316 | 505316 | 2020-09-06 | Butler | Alabama | 1013 | 890 | 38 |
508548 | 508548 | 2020-09-07 | Butler | Alabama | 1013 | 892 | 38 |
511781 | 511781 | 2020-09-08 | Butler | Alabama | 1013 | 892 | 38 |
515014 | 515014 | 2020-09-09 | Butler | Alabama | 1013 | 895 | 38 |
518249 | 518249 | 2020-09-10 | Butler | Alabama | 1013 | 896 | 38 |
521486 | 521486 | 2020-09-11 | Butler | Alabama | 1013 | 896 | 38 |
524722 | 524722 | 2020-09-12 | Butler | Alabama | 1013 | 898 | 38 |
527958 | 527958 | 2020-09-13 | Butler | Alabama | 1013 | 899 | 38 |
531195 | 531195 | 2020-09-14 | Butler | Alabama | 1013 | 900 | 38 |
534430 | 534430 | 2020-09-15 | Butler | Alabama | 1013 | 901 | 38 |
537666 | 537666 | 2020-09-16 | Butler | Alabama | 1013 | 901 | 38 |
540903 | 540903 | 2020-09-17 | Butler | Alabama | 1013 | 902 | 38 |
544139 | 544139 | 2020-09-18 | Butler | Alabama | 1013 | 906 | 38 |
547376 | 547376 | 2020-09-19 | Butler | Alabama | 1013 | 908 | 38 |
550615 | 550615 | 2020-09-20 | Butler | Alabama | 1013 | 909 | 38 |
553854 | 553854 | 2020-09-21 | Butler | Alabama | 1013 | 911 | 38 |
557091 | 557091 | 2020-09-22 | Butler | Alabama | 1013 | 911 | 38 |
560327 | 560327 | 2020-09-23 | Butler | Alabama | 1013 | 911 | 39 |
563566 | 563566 | 2020-09-24 | Butler | Alabama | 1013 | 913 | 39 |
566807 | 566807 | 2020-09-25 | Butler | Alabama | 1013 | 916 | 39 |
570048 | 570048 | 2020-09-26 | Butler | Alabama | 1013 | 912 | 39 |
573290 | 573290 | 2020-09-27 | Butler | Alabama | 1013 | 913 | 39 |
576534 | 576534 | 2020-09-28 | Butler | Alabama | 1013 | 914 | 39 |
579775 | 579775 | 2020-09-29 | Butler | Alabama | 1013 | 917 | 40 |
583014 | 583014 | 2020-09-30 | Butler | Alabama | 1013 | 917 | 40 |
586254 | 586254 | 2020-10-01 | Butler | Alabama | 1013 | 919 | 40 |
589495 | 589495 | 2020-10-02 | Butler | Alabama | 1013 | 922 | 40 |
592735 | 592735 | 2020-10-03 | Butler | Alabama | 1013 | 924 | 40 |
595977 | 595977 | 2020-10-04 | Butler | Alabama | 1013 | 926 | 40 |
599220 | 599220 | 2020-10-05 | Butler | Alabama | 1013 | 927 | 40 |
602463 | 602463 | 2020-10-06 | Butler | Alabama | 1013 | 928 | 40 |
605705 | 605705 | 2020-10-07 | Butler | Alabama | 1013 | 933 | 40 |
608948 | 608948 | 2020-10-08 | Butler | Alabama | 1013 | 932 | 40 |
612190 | 612190 | 2020-10-09 | Butler | Alabama | 1013 | 943 | 40 |
615431 | 615431 | 2020-10-10 | Butler | Alabama | 1013 | 952 | 40 |
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);