ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Bullock" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917198 | 917198 | 2021-01-11 | Bullock | Alabama | 1011 | 957 | 28 |
913953 | 913953 | 2021-01-10 | Bullock | Alabama | 1011 | 953 | 28 |
910708 | 910708 | 2021-01-09 | Bullock | Alabama | 1011 | 950 | 28 |
907463 | 907463 | 2021-01-08 | Bullock | Alabama | 1011 | 949 | 28 |
904217 | 904217 | 2021-01-07 | Bullock | Alabama | 1011 | 927 | 22 |
900972 | 900972 | 2021-01-06 | Bullock | Alabama | 1011 | 925 | 22 |
897727 | 897727 | 2021-01-05 | Bullock | Alabama | 1011 | 920 | 22 |
894481 | 894481 | 2021-01-04 | Bullock | Alabama | 1011 | 910 | 22 |
891235 | 891235 | 2021-01-03 | Bullock | Alabama | 1011 | 900 | 22 |
887988 | 887988 | 2021-01-02 | Bullock | Alabama | 1011 | 892 | 22 |
884743 | 884743 | 2021-01-01 | Bullock | Alabama | 1011 | 888 | 22 |
881498 | 881498 | 2020-12-31 | Bullock | Alabama | 1011 | 859 | 22 |
878253 | 878253 | 2020-12-30 | Bullock | Alabama | 1011 | 846 | 20 |
875008 | 875008 | 2020-12-29 | Bullock | Alabama | 1011 | 834 | 20 |
871763 | 871763 | 2020-12-28 | Bullock | Alabama | 1011 | 830 | 20 |
868518 | 868518 | 2020-12-27 | Bullock | Alabama | 1011 | 827 | 20 |
865273 | 865273 | 2020-12-26 | Bullock | Alabama | 1011 | 825 | 20 |
862028 | 862028 | 2020-12-25 | Bullock | Alabama | 1011 | 777 | 20 |
858783 | 858783 | 2020-12-24 | Bullock | Alabama | 1011 | 770 | 20 |
855538 | 855538 | 2020-12-23 | Bullock | Alabama | 1011 | 765 | 20 |
852293 | 852293 | 2020-12-22 | Bullock | Alabama | 1011 | 760 | 20 |
849048 | 849048 | 2020-12-21 | Bullock | Alabama | 1011 | 754 | 20 |
845803 | 845803 | 2020-12-20 | Bullock | Alabama | 1011 | 753 | 20 |
842557 | 842557 | 2020-12-19 | Bullock | Alabama | 1011 | 752 | 20 |
839312 | 839312 | 2020-12-18 | Bullock | Alabama | 1011 | 747 | 20 |
836067 | 836067 | 2020-12-17 | Bullock | Alabama | 1011 | 742 | 20 |
832821 | 832821 | 2020-12-16 | Bullock | Alabama | 1011 | 737 | 20 |
829574 | 829574 | 2020-12-15 | Bullock | Alabama | 1011 | 733 | 20 |
826328 | 826328 | 2020-12-14 | Bullock | Alabama | 1011 | 728 | 20 |
823081 | 823081 | 2020-12-13 | Bullock | Alabama | 1011 | 728 | 20 |
819835 | 819835 | 2020-12-12 | Bullock | Alabama | 1011 | 725 | 20 |
816589 | 816589 | 2020-12-11 | Bullock | Alabama | 1011 | 723 | 20 |
813343 | 813343 | 2020-12-10 | Bullock | Alabama | 1011 | 722 | 20 |
810099 | 810099 | 2020-12-09 | Bullock | Alabama | 1011 | 722 | 20 |
806854 | 806854 | 2020-12-08 | Bullock | Alabama | 1011 | 719 | 20 |
803609 | 803609 | 2020-12-07 | Bullock | Alabama | 1011 | 714 | 20 |
800364 | 800364 | 2020-12-06 | Bullock | Alabama | 1011 | 713 | 20 |
797119 | 797119 | 2020-12-05 | Bullock | Alabama | 1011 | 713 | 20 |
793874 | 793874 | 2020-12-04 | Bullock | Alabama | 1011 | 711 | 20 |
790629 | 790629 | 2020-12-03 | Bullock | Alabama | 1011 | 709 | 19 |
787384 | 787384 | 2020-12-02 | Bullock | Alabama | 1011 | 709 | 19 |
784140 | 784140 | 2020-12-01 | Bullock | Alabama | 1011 | 701 | 19 |
780895 | 780895 | 2020-11-30 | Bullock | Alabama | 1011 | 702 | 19 |
777649 | 777649 | 2020-11-29 | Bullock | Alabama | 1011 | 700 | 19 |
774404 | 774404 | 2020-11-28 | Bullock | Alabama | 1011 | 696 | 19 |
771159 | 771159 | 2020-11-27 | Bullock | Alabama | 1011 | 694 | 19 |
767913 | 767913 | 2020-11-26 | Bullock | Alabama | 1011 | 694 | 19 |
764668 | 764668 | 2020-11-25 | Bullock | Alabama | 1011 | 691 | 19 |
761423 | 761423 | 2020-11-24 | Bullock | Alabama | 1011 | 690 | 19 |
758178 | 758178 | 2020-11-23 | Bullock | Alabama | 1011 | 690 | 19 |
754931 | 754931 | 2020-11-22 | Bullock | Alabama | 1011 | 689 | 19 |
751685 | 751685 | 2020-11-21 | Bullock | Alabama | 1011 | 688 | 19 |
748439 | 748439 | 2020-11-20 | Bullock | Alabama | 1011 | 684 | 19 |
745193 | 745193 | 2020-11-19 | Bullock | Alabama | 1011 | 680 | 19 |
741946 | 741946 | 2020-11-18 | Bullock | Alabama | 1011 | 678 | 19 |
738699 | 738699 | 2020-11-17 | Bullock | Alabama | 1011 | 678 | 19 |
735455 | 735455 | 2020-11-16 | Bullock | Alabama | 1011 | 677 | 19 |
732209 | 732209 | 2020-11-15 | Bullock | Alabama | 1011 | 677 | 19 |
728964 | 728964 | 2020-11-14 | Bullock | Alabama | 1011 | 675 | 19 |
725721 | 725721 | 2020-11-13 | Bullock | Alabama | 1011 | 673 | 19 |
722478 | 722478 | 2020-11-12 | Bullock | Alabama | 1011 | 669 | 19 |
719235 | 719235 | 2020-11-11 | Bullock | Alabama | 1011 | 668 | 19 |
715992 | 715992 | 2020-11-10 | Bullock | Alabama | 1011 | 665 | 18 |
712748 | 712748 | 2020-11-09 | Bullock | Alabama | 1011 | 664 | 17 |
709504 | 709504 | 2020-11-08 | Bullock | Alabama | 1011 | 664 | 17 |
706260 | 706260 | 2020-11-07 | Bullock | Alabama | 1011 | 663 | 17 |
703017 | 703017 | 2020-11-06 | Bullock | Alabama | 1011 | 662 | 17 |
699774 | 699774 | 2020-11-05 | Bullock | Alabama | 1011 | 661 | 17 |
696530 | 696530 | 2020-11-04 | Bullock | Alabama | 1011 | 659 | 17 |
693288 | 693288 | 2020-11-03 | Bullock | Alabama | 1011 | 657 | 17 |
690045 | 690045 | 2020-11-02 | Bullock | Alabama | 1011 | 655 | 17 |
686800 | 686800 | 2020-11-01 | Bullock | Alabama | 1011 | 655 | 17 |
683556 | 683556 | 2020-10-31 | Bullock | Alabama | 1011 | 653 | 17 |
680313 | 680313 | 2020-10-30 | Bullock | Alabama | 1011 | 651 | 17 |
677070 | 677070 | 2020-10-29 | Bullock | Alabama | 1011 | 651 | 17 |
673827 | 673827 | 2020-10-28 | Bullock | Alabama | 1011 | 650 | 17 |
670585 | 670585 | 2020-10-27 | Bullock | Alabama | 1011 | 650 | 17 |
667342 | 667342 | 2020-10-26 | Bullock | Alabama | 1011 | 649 | 17 |
664097 | 664097 | 2020-10-25 | Bullock | Alabama | 1011 | 649 | 17 |
660853 | 660853 | 2020-10-24 | Bullock | Alabama | 1011 | 648 | 17 |
657609 | 657609 | 2020-10-23 | Bullock | Alabama | 1011 | 639 | 17 |
654364 | 654364 | 2020-10-22 | Bullock | Alabama | 1011 | 637 | 17 |
651119 | 651119 | 2020-10-21 | Bullock | Alabama | 1011 | 637 | 17 |
647875 | 647875 | 2020-10-20 | Bullock | Alabama | 1011 | 635 | 17 |
644630 | 644630 | 2020-10-19 | Bullock | Alabama | 1011 | 635 | 17 |
641382 | 641382 | 2020-10-18 | Bullock | Alabama | 1011 | 634 | 17 |
638135 | 638135 | 2020-10-17 | Bullock | Alabama | 1011 | 634 | 17 |
634890 | 634890 | 2020-10-16 | Bullock | Alabama | 1011 | 631 | 17 |
631645 | 631645 | 2020-10-15 | Bullock | Alabama | 1011 | 628 | 17 |
628401 | 628401 | 2020-10-14 | Bullock | Alabama | 1011 | 628 | 16 |
625158 | 625158 | 2020-10-13 | Bullock | Alabama | 1011 | 626 | 16 |
621915 | 621915 | 2020-10-12 | Bullock | Alabama | 1011 | 625 | 16 |
618672 | 618672 | 2020-10-11 | Bullock | Alabama | 1011 | 624 | 16 |
615430 | 615430 | 2020-10-10 | Bullock | Alabama | 1011 | 623 | 16 |
612189 | 612189 | 2020-10-09 | Bullock | Alabama | 1011 | 622 | 16 |
608947 | 608947 | 2020-10-08 | Bullock | Alabama | 1011 | 619 | 16 |
605704 | 605704 | 2020-10-07 | Bullock | Alabama | 1011 | 618 | 16 |
602462 | 602462 | 2020-10-06 | Bullock | Alabama | 1011 | 616 | 16 |
599219 | 599219 | 2020-10-05 | Bullock | Alabama | 1011 | 613 | 15 |
595976 | 595976 | 2020-10-04 | Bullock | Alabama | 1011 | 613 | 15 |
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);