ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
455 rows where deaths = 11 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wilcox 46
- Conecuh 42
- Monroe 39
- Winston 38
- Marengo 36
- Randolph 25
- Bullock 23
- Greene 21
- Pickens 20
- Coffee 15
- Marion 15
- Jackson 11
- Choctaw 10
- Cleburne 10
- Colbert 7
- Cullman 7
- Etowah 7
- Sumter 7
- Hale 6
- Marshall 6
- Butler 5
- Franklin 5
- Blount 4
- Elmore 4
- Autauga 3
- Barbour 3
- Chambers 3
- Clarke 3
- Fayette 3
- Washington 3
- …
state 1
- Alabama · 455 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946457 | 946457 | 2021-01-20 | Russell | Alabama | 1113 | 3407 | 11 |
920456 | 920456 | 2021-01-12 | Coosa | Alabama | 1037 | 591 | 11 |
917226 | 917226 | 2021-01-11 | Henry | Alabama | 1067 | 1442 | 11 |
913981 | 913981 | 2021-01-10 | Henry | Alabama | 1067 | 1433 | 11 |
901019 | 901019 | 2021-01-06 | Perry | Alabama | 1105 | 899 | 11 |
897771 | 897771 | 2021-01-05 | Monroe | Alabama | 1099 | 1271 | 11 |
894525 | 894525 | 2021-01-04 | Monroe | Alabama | 1099 | 1238 | 11 |
891279 | 891279 | 2021-01-03 | Monroe | Alabama | 1099 | 1233 | 11 |
888032 | 888032 | 2021-01-02 | Monroe | Alabama | 1099 | 1231 | 11 |
884787 | 884787 | 2021-01-01 | Monroe | Alabama | 1099 | 1226 | 11 |
881542 | 881542 | 2020-12-31 | Monroe | Alabama | 1099 | 1215 | 11 |
878297 | 878297 | 2020-12-30 | Monroe | Alabama | 1099 | 1195 | 11 |
875052 | 875052 | 2020-12-29 | Monroe | Alabama | 1099 | 1155 | 11 |
871807 | 871807 | 2020-12-28 | Monroe | Alabama | 1099 | 1112 | 11 |
868562 | 868562 | 2020-12-27 | Monroe | Alabama | 1099 | 1109 | 11 |
865317 | 865317 | 2020-12-26 | Monroe | Alabama | 1099 | 1104 | 11 |
862072 | 862072 | 2020-12-25 | Monroe | Alabama | 1099 | 1101 | 11 |
858827 | 858827 | 2020-12-24 | Monroe | Alabama | 1099 | 1090 | 11 |
855582 | 855582 | 2020-12-23 | Monroe | Alabama | 1099 | 1086 | 11 |
836099 | 836099 | 2020-12-17 | Lamar | Alabama | 1075 | 912 | 11 |
816633 | 816633 | 2020-12-11 | Monroe | Alabama | 1099 | 908 | 11 |
813387 | 813387 | 2020-12-10 | Monroe | Alabama | 1099 | 895 | 11 |
810143 | 810143 | 2020-12-09 | Monroe | Alabama | 1099 | 885 | 11 |
806898 | 806898 | 2020-12-08 | Monroe | Alabama | 1099 | 881 | 11 |
803634 | 803634 | 2020-12-07 | Geneva | Alabama | 1061 | 1321 | 11 |
803653 | 803653 | 2020-12-07 | Monroe | Alabama | 1099 | 858 | 11 |
800389 | 800389 | 2020-12-06 | Geneva | Alabama | 1061 | 1316 | 11 |
800408 | 800408 | 2020-12-06 | Monroe | Alabama | 1099 | 855 | 11 |
797163 | 797163 | 2020-12-05 | Monroe | Alabama | 1099 | 855 | 11 |
793918 | 793918 | 2020-12-04 | Monroe | Alabama | 1099 | 853 | 11 |
790673 | 790673 | 2020-12-03 | Monroe | Alabama | 1099 | 846 | 11 |
787428 | 787428 | 2020-12-02 | Monroe | Alabama | 1099 | 838 | 11 |
784137 | 784137 | 2020-12-01 | Barbour | Alabama | 1005 | 1189 | 11 |
784184 | 784184 | 2020-12-01 | Monroe | Alabama | 1099 | 830 | 11 |
780892 | 780892 | 2020-11-30 | Barbour | Alabama | 1005 | 1178 | 11 |
780939 | 780939 | 2020-11-30 | Monroe | Alabama | 1099 | 790 | 11 |
777646 | 777646 | 2020-11-29 | Barbour | Alabama | 1005 | 1175 | 11 |
777693 | 777693 | 2020-11-29 | Monroe | Alabama | 1099 | 790 | 11 |
774448 | 774448 | 2020-11-28 | Monroe | Alabama | 1099 | 789 | 11 |
771203 | 771203 | 2020-11-27 | Monroe | Alabama | 1099 | 787 | 11 |
767957 | 767957 | 2020-11-26 | Monroe | Alabama | 1099 | 783 | 11 |
764712 | 764712 | 2020-11-25 | Monroe | Alabama | 1099 | 781 | 11 |
761467 | 761467 | 2020-11-24 | Monroe | Alabama | 1099 | 779 | 11 |
758222 | 758222 | 2020-11-23 | Monroe | Alabama | 1099 | 768 | 11 |
754975 | 754975 | 2020-11-22 | Monroe | Alabama | 1099 | 768 | 11 |
751729 | 751729 | 2020-11-21 | Monroe | Alabama | 1099 | 765 | 11 |
748483 | 748483 | 2020-11-20 | Monroe | Alabama | 1099 | 758 | 11 |
745237 | 745237 | 2020-11-19 | Monroe | Alabama | 1099 | 752 | 11 |
741990 | 741990 | 2020-11-18 | Monroe | Alabama | 1099 | 743 | 11 |
738743 | 738743 | 2020-11-17 | Monroe | Alabama | 1099 | 733 | 11 |
735464 | 735464 | 2020-11-16 | Cleburne | Alabama | 1029 | 678 | 11 |
732218 | 732218 | 2020-11-15 | Cleburne | Alabama | 1029 | 669 | 11 |
728973 | 728973 | 2020-11-14 | Cleburne | Alabama | 1029 | 659 | 11 |
725730 | 725730 | 2020-11-13 | Cleburne | Alabama | 1029 | 655 | 11 |
722487 | 722487 | 2020-11-12 | Cleburne | Alabama | 1029 | 646 | 11 |
719244 | 719244 | 2020-11-11 | Cleburne | Alabama | 1029 | 638 | 11 |
716001 | 716001 | 2020-11-10 | Cleburne | Alabama | 1029 | 630 | 11 |
712757 | 712757 | 2020-11-09 | Cleburne | Alabama | 1029 | 629 | 11 |
709513 | 709513 | 2020-11-08 | Cleburne | Alabama | 1029 | 627 | 11 |
706269 | 706269 | 2020-11-07 | Cleburne | Alabama | 1029 | 622 | 11 |
703027 | 703027 | 2020-11-06 | Coffee | Alabama | 1031 | 1947 | 11 |
699784 | 699784 | 2020-11-05 | Coffee | Alabama | 1031 | 1920 | 11 |
696540 | 696540 | 2020-11-04 | Coffee | Alabama | 1031 | 1909 | 11 |
693298 | 693298 | 2020-11-03 | Coffee | Alabama | 1031 | 1893 | 11 |
690055 | 690055 | 2020-11-02 | Coffee | Alabama | 1031 | 1885 | 11 |
686810 | 686810 | 2020-11-01 | Coffee | Alabama | 1031 | 1878 | 11 |
683566 | 683566 | 2020-10-31 | Coffee | Alabama | 1031 | 1865 | 11 |
680323 | 680323 | 2020-10-30 | Coffee | Alabama | 1031 | 1851 | 11 |
677080 | 677080 | 2020-10-29 | Coffee | Alabama | 1031 | 1836 | 11 |
673837 | 673837 | 2020-10-28 | Coffee | Alabama | 1031 | 1826 | 11 |
670595 | 670595 | 2020-10-27 | Coffee | Alabama | 1031 | 1807 | 11 |
667352 | 667352 | 2020-10-26 | Coffee | Alabama | 1031 | 1795 | 11 |
664107 | 664107 | 2020-10-25 | Coffee | Alabama | 1031 | 1771 | 11 |
660863 | 660863 | 2020-10-24 | Coffee | Alabama | 1031 | 1763 | 11 |
657619 | 657619 | 2020-10-23 | Coffee | Alabama | 1031 | 1732 | 11 |
631668 | 631668 | 2020-10-15 | Fayette | Alabama | 1057 | 525 | 11 |
628409 | 628409 | 2020-10-14 | Clay | Alabama | 1027 | 667 | 11 |
628461 | 628461 | 2020-10-14 | Wilcox | Alabama | 1131 | 554 | 11 |
625218 | 625218 | 2020-10-13 | Wilcox | Alabama | 1131 | 554 | 11 |
621975 | 621975 | 2020-10-12 | Wilcox | Alabama | 1131 | 553 | 11 |
618732 | 618732 | 2020-10-11 | Wilcox | Alabama | 1131 | 553 | 11 |
615490 | 615490 | 2020-10-10 | Wilcox | Alabama | 1131 | 551 | 11 |
612249 | 612249 | 2020-10-09 | Wilcox | Alabama | 1131 | 550 | 11 |
609007 | 609007 | 2020-10-08 | Wilcox | Alabama | 1131 | 548 | 11 |
605764 | 605764 | 2020-10-07 | Wilcox | Alabama | 1131 | 540 | 11 |
602522 | 602522 | 2020-10-06 | Wilcox | Alabama | 1131 | 539 | 11 |
599279 | 599279 | 2020-10-05 | Wilcox | Alabama | 1131 | 538 | 11 |
596036 | 596036 | 2020-10-04 | Wilcox | Alabama | 1131 | 538 | 11 |
592794 | 592794 | 2020-10-03 | Wilcox | Alabama | 1131 | 537 | 11 |
589554 | 589554 | 2020-10-02 | Wilcox | Alabama | 1131 | 535 | 11 |
586276 | 586276 | 2020-10-01 | Fayette | Alabama | 1057 | 473 | 11 |
586313 | 586313 | 2020-10-01 | Wilcox | Alabama | 1131 | 534 | 11 |
583011 | 583011 | 2020-09-30 | Bibb | Alabama | 1007 | 664 | 11 |
583025 | 583025 | 2020-09-30 | Conecuh | Alabama | 1035 | 538 | 11 |
583036 | 583036 | 2020-09-30 | Fayette | Alabama | 1057 | 473 | 11 |
583062 | 583062 | 2020-09-30 | Pike | Alabama | 1109 | 1220 | 11 |
583073 | 583073 | 2020-09-30 | Wilcox | Alabama | 1131 | 532 | 11 |
579786 | 579786 | 2020-09-29 | Conecuh | Alabama | 1035 | 539 | 11 |
579823 | 579823 | 2020-09-29 | Pike | Alabama | 1109 | 1216 | 11 |
579834 | 579834 | 2020-09-29 | Wilcox | Alabama | 1131 | 532 | 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);