ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
665 rows where deaths = 6 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Perry 77
- Henry 50
- Pickens 39
- Washington 35
- Russell 28
- Cleburne 27
- Coffee 27
- Marengo 26
- Fayette 24
- Clay 20
- Bibb 18
- Calhoun 16
- Clarke 16
- Escambia 16
- Dallas 14
- Talladega 14
- Geneva 13
- Lauderdale 13
- Colbert 12
- Jackson 11
- Houston 10
- Macon 10
- Madison 10
- Sumter 9
- Walker 9
- Barbour 8
- Marion 8
- Pike 8
- Cullman 7
- Autauga 6
- …
state 1
- Alabama · 665 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
897778 | 897778 | 2021-01-05 | Russell | Alabama | 1113 | 2903 | 6 |
894532 | 894532 | 2021-01-04 | Russell | Alabama | 1113 | 2880 | 6 |
891286 | 891286 | 2021-01-03 | Russell | Alabama | 1113 | 2866 | 6 |
888039 | 888039 | 2021-01-02 | Russell | Alabama | 1113 | 2842 | 6 |
884794 | 884794 | 2021-01-01 | Russell | Alabama | 1113 | 2824 | 6 |
881549 | 881549 | 2020-12-31 | Russell | Alabama | 1113 | 2793 | 6 |
878304 | 878304 | 2020-12-30 | Russell | Alabama | 1113 | 2775 | 6 |
875059 | 875059 | 2020-12-29 | Russell | Alabama | 1113 | 2728 | 6 |
871814 | 871814 | 2020-12-28 | Russell | Alabama | 1113 | 2694 | 6 |
868569 | 868569 | 2020-12-27 | Russell | Alabama | 1113 | 2697 | 6 |
865324 | 865324 | 2020-12-26 | Russell | Alabama | 1113 | 2682 | 6 |
862079 | 862079 | 2020-12-25 | Russell | Alabama | 1113 | 2662 | 6 |
858834 | 858834 | 2020-12-24 | Russell | Alabama | 1113 | 2641 | 6 |
855551 | 855551 | 2020-12-23 | Coosa | Alabama | 1037 | 472 | 6 |
855589 | 855589 | 2020-12-23 | Russell | Alabama | 1113 | 2629 | 6 |
852306 | 852306 | 2020-12-22 | Coosa | Alabama | 1037 | 467 | 6 |
852344 | 852344 | 2020-12-22 | Russell | Alabama | 1113 | 2610 | 6 |
849061 | 849061 | 2020-12-21 | Coosa | Alabama | 1037 | 457 | 6 |
849099 | 849099 | 2020-12-21 | Russell | Alabama | 1113 | 2594 | 6 |
845816 | 845816 | 2020-12-20 | Coosa | Alabama | 1037 | 454 | 6 |
845854 | 845854 | 2020-12-20 | Russell | Alabama | 1113 | 2595 | 6 |
842570 | 842570 | 2020-12-19 | Coosa | Alabama | 1037 | 454 | 6 |
842608 | 842608 | 2020-12-19 | Russell | Alabama | 1113 | 2580 | 6 |
839325 | 839325 | 2020-12-18 | Coosa | Alabama | 1037 | 451 | 6 |
839363 | 839363 | 2020-12-18 | Russell | Alabama | 1113 | 2561 | 6 |
836118 | 836118 | 2020-12-17 | Russell | Alabama | 1113 | 2539 | 6 |
832872 | 832872 | 2020-12-16 | Russell | Alabama | 1113 | 2511 | 6 |
829625 | 829625 | 2020-12-15 | Russell | Alabama | 1113 | 2494 | 6 |
826379 | 826379 | 2020-12-14 | Russell | Alabama | 1113 | 2470 | 6 |
823132 | 823132 | 2020-12-13 | Russell | Alabama | 1113 | 2463 | 6 |
819886 | 819886 | 2020-12-12 | Russell | Alabama | 1113 | 2458 | 6 |
816640 | 816640 | 2020-12-11 | Russell | Alabama | 1113 | 2446 | 6 |
813394 | 813394 | 2020-12-10 | Russell | Alabama | 1113 | 2430 | 6 |
810150 | 810150 | 2020-12-09 | Russell | Alabama | 1113 | 2409 | 6 |
790657 | 790657 | 2020-12-03 | Henry | Alabama | 1067 | 899 | 6 |
787412 | 787412 | 2020-12-02 | Henry | Alabama | 1067 | 894 | 6 |
784168 | 784168 | 2020-12-01 | Henry | Alabama | 1067 | 889 | 6 |
784187 | 784187 | 2020-12-01 | Perry | Alabama | 1105 | 691 | 6 |
780923 | 780923 | 2020-11-30 | Henry | Alabama | 1067 | 875 | 6 |
780942 | 780942 | 2020-11-30 | Perry | Alabama | 1105 | 690 | 6 |
777677 | 777677 | 2020-11-29 | Henry | Alabama | 1067 | 867 | 6 |
777696 | 777696 | 2020-11-29 | Perry | Alabama | 1105 | 689 | 6 |
774432 | 774432 | 2020-11-28 | Henry | Alabama | 1067 | 854 | 6 |
774451 | 774451 | 2020-11-28 | Perry | Alabama | 1105 | 688 | 6 |
771187 | 771187 | 2020-11-27 | Henry | Alabama | 1067 | 852 | 6 |
771206 | 771206 | 2020-11-27 | Perry | Alabama | 1105 | 684 | 6 |
767941 | 767941 | 2020-11-26 | Henry | Alabama | 1067 | 852 | 6 |
767960 | 767960 | 2020-11-26 | Perry | Alabama | 1105 | 683 | 6 |
764696 | 764696 | 2020-11-25 | Henry | Alabama | 1067 | 849 | 6 |
764715 | 764715 | 2020-11-25 | Perry | Alabama | 1105 | 675 | 6 |
761451 | 761451 | 2020-11-24 | Henry | Alabama | 1067 | 843 | 6 |
761470 | 761470 | 2020-11-24 | Perry | Alabama | 1105 | 672 | 6 |
758206 | 758206 | 2020-11-23 | Henry | Alabama | 1067 | 842 | 6 |
758225 | 758225 | 2020-11-23 | Perry | Alabama | 1105 | 668 | 6 |
754959 | 754959 | 2020-11-22 | Henry | Alabama | 1067 | 838 | 6 |
754978 | 754978 | 2020-11-22 | Perry | Alabama | 1105 | 668 | 6 |
751713 | 751713 | 2020-11-21 | Henry | Alabama | 1067 | 836 | 6 |
751732 | 751732 | 2020-11-21 | Perry | Alabama | 1105 | 666 | 6 |
748467 | 748467 | 2020-11-20 | Henry | Alabama | 1067 | 833 | 6 |
748486 | 748486 | 2020-11-20 | Perry | Alabama | 1105 | 656 | 6 |
745221 | 745221 | 2020-11-19 | Henry | Alabama | 1067 | 823 | 6 |
745240 | 745240 | 2020-11-19 | Perry | Alabama | 1105 | 651 | 6 |
741974 | 741974 | 2020-11-18 | Henry | Alabama | 1067 | 819 | 6 |
741993 | 741993 | 2020-11-18 | Perry | Alabama | 1105 | 645 | 6 |
738727 | 738727 | 2020-11-17 | Henry | Alabama | 1067 | 817 | 6 |
738746 | 738746 | 2020-11-17 | Perry | Alabama | 1105 | 642 | 6 |
735483 | 735483 | 2020-11-16 | Henry | Alabama | 1067 | 816 | 6 |
735502 | 735502 | 2020-11-16 | Perry | Alabama | 1105 | 641 | 6 |
732237 | 732237 | 2020-11-15 | Henry | Alabama | 1067 | 815 | 6 |
732256 | 732256 | 2020-11-15 | Perry | Alabama | 1105 | 639 | 6 |
728992 | 728992 | 2020-11-14 | Henry | Alabama | 1067 | 810 | 6 |
729011 | 729011 | 2020-11-14 | Perry | Alabama | 1105 | 639 | 6 |
725749 | 725749 | 2020-11-13 | Henry | Alabama | 1067 | 807 | 6 |
725768 | 725768 | 2020-11-13 | Perry | Alabama | 1105 | 634 | 6 |
722506 | 722506 | 2020-11-12 | Henry | Alabama | 1067 | 799 | 6 |
722525 | 722525 | 2020-11-12 | Perry | Alabama | 1105 | 631 | 6 |
719263 | 719263 | 2020-11-11 | Henry | Alabama | 1067 | 797 | 6 |
719282 | 719282 | 2020-11-11 | Perry | Alabama | 1105 | 626 | 6 |
716020 | 716020 | 2020-11-10 | Henry | Alabama | 1067 | 787 | 6 |
716039 | 716039 | 2020-11-10 | Perry | Alabama | 1105 | 626 | 6 |
712776 | 712776 | 2020-11-09 | Henry | Alabama | 1067 | 782 | 6 |
712795 | 712795 | 2020-11-09 | Perry | Alabama | 1105 | 619 | 6 |
709532 | 709532 | 2020-11-08 | Henry | Alabama | 1067 | 777 | 6 |
709551 | 709551 | 2020-11-08 | Perry | Alabama | 1105 | 618 | 6 |
706288 | 706288 | 2020-11-07 | Henry | Alabama | 1067 | 776 | 6 |
706307 | 706307 | 2020-11-07 | Perry | Alabama | 1105 | 618 | 6 |
703045 | 703045 | 2020-11-06 | Henry | Alabama | 1067 | 770 | 6 |
703064 | 703064 | 2020-11-06 | Perry | Alabama | 1105 | 615 | 6 |
699802 | 699802 | 2020-11-05 | Henry | Alabama | 1067 | 766 | 6 |
699821 | 699821 | 2020-11-05 | Perry | Alabama | 1105 | 614 | 6 |
696558 | 696558 | 2020-11-04 | Henry | Alabama | 1067 | 762 | 6 |
696577 | 696577 | 2020-11-04 | Perry | Alabama | 1105 | 609 | 6 |
693316 | 693316 | 2020-11-03 | Henry | Alabama | 1067 | 757 | 6 |
693335 | 693335 | 2020-11-03 | Perry | Alabama | 1105 | 606 | 6 |
690073 | 690073 | 2020-11-02 | Henry | Alabama | 1067 | 752 | 6 |
690077 | 690077 | 2020-11-02 | Lamar | Alabama | 1075 | 535 | 6 |
690092 | 690092 | 2020-11-02 | Perry | Alabama | 1105 | 606 | 6 |
686828 | 686828 | 2020-11-01 | Henry | Alabama | 1067 | 747 | 6 |
686832 | 686832 | 2020-11-01 | Lamar | Alabama | 1075 | 534 | 6 |
686847 | 686847 | 2020-11-01 | Perry | Alabama | 1105 | 606 | 6 |
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);