ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-04-21 and state = "Alabama" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
75674 | 75674 | 2020-04-21 | Barbour | Alabama | 1005 | 28 | 0 |
75675 | 75675 | 2020-04-21 | Bibb | Alabama | 1007 | 32 | 0 |
75676 | 75676 | 2020-04-21 | Blount | Alabama | 1009 | 26 | 0 |
75677 | 75677 | 2020-04-21 | Bullock | Alabama | 1011 | 11 | 0 |
75678 | 75678 | 2020-04-21 | Butler | Alabama | 1013 | 15 | 0 |
75681 | 75681 | 2020-04-21 | Cherokee | Alabama | 1019 | 13 | 0 |
75682 | 75682 | 2020-04-21 | Chilton | Alabama | 1021 | 44 | 0 |
75683 | 75683 | 2020-04-21 | Choctaw | Alabama | 1023 | 18 | 0 |
75685 | 75685 | 2020-04-21 | Clay | Alabama | 1027 | 19 | 0 |
75689 | 75689 | 2020-04-21 | Conecuh | Alabama | 1035 | 9 | 0 |
75691 | 75691 | 2020-04-21 | Covington | Alabama | 1039 | 26 | 0 |
75692 | 75692 | 2020-04-21 | Crenshaw | Alabama | 1041 | 6 | 0 |
75693 | 75693 | 2020-04-21 | Cullman | Alabama | 1043 | 45 | 0 |
75694 | 75694 | 2020-04-21 | Dale | Alabama | 1045 | 21 | 0 |
75700 | 75700 | 2020-04-21 | Fayette | Alabama | 1057 | 4 | 0 |
75701 | 75701 | 2020-04-21 | Franklin | Alabama | 1059 | 18 | 0 |
75702 | 75702 | 2020-04-21 | Geneva | Alabama | 1061 | 4 | 0 |
75703 | 75703 | 2020-04-21 | Greene | Alabama | 1063 | 32 | 0 |
75705 | 75705 | 2020-04-21 | Henry | Alabama | 1067 | 20 | 0 |
75709 | 75709 | 2020-04-21 | Lamar | Alabama | 1075 | 9 | 0 |
75711 | 75711 | 2020-04-21 | Lawrence | Alabama | 1079 | 10 | 0 |
75713 | 75713 | 2020-04-21 | Limestone | Alabama | 1083 | 40 | 0 |
75714 | 75714 | 2020-04-21 | Lowndes | Alabama | 1085 | 32 | 0 |
75723 | 75723 | 2020-04-21 | Morgan | Alabama | 1103 | 51 | 0 |
75724 | 75724 | 2020-04-21 | Perry | Alabama | 1105 | 9 | 0 |
75726 | 75726 | 2020-04-21 | Pike | Alabama | 1109 | 46 | 0 |
75728 | 75728 | 2020-04-21 | Russell | Alabama | 1113 | 48 | 0 |
75730 | 75730 | 2020-04-21 | St. Clair | Alabama | 1115 | 59 | 0 |
75731 | 75731 | 2020-04-21 | Sumter | Alabama | 1119 | 44 | 0 |
75735 | 75735 | 2020-04-21 | Walker | Alabama | 1127 | 91 | 0 |
75738 | 75738 | 2020-04-21 | Winston | Alabama | 1133 | 10 | 0 |
75672 | 75672 | 2020-04-21 | Autauga | Alabama | 1001 | 30 | 1 |
75684 | 75684 | 2020-04-21 | Clarke | Alabama | 1025 | 24 | 1 |
75686 | 75686 | 2020-04-21 | Cleburne | Alabama | 1029 | 12 | 1 |
75687 | 75687 | 2020-04-21 | Coffee | Alabama | 1031 | 68 | 1 |
75688 | 75688 | 2020-04-21 | Colbert | Alabama | 1033 | 16 | 1 |
75690 | 75690 | 2020-04-21 | Coosa | Alabama | 1037 | 24 | 1 |
75697 | 75697 | 2020-04-21 | Elmore | Alabama | 1051 | 73 | 1 |
75698 | 75698 | 2020-04-21 | Escambia | Alabama | 1053 | 17 | 1 |
75704 | 75704 | 2020-04-21 | Hale | Alabama | 1065 | 34 | 1 |
75721 | 75721 | 2020-04-21 | Monroe | Alabama | 1099 | 9 | 1 |
75725 | 75725 | 2020-04-21 | Pickens | Alabama | 1107 | 42 | 1 |
75734 | 75734 | 2020-04-21 | Tuscaloosa | Alabama | 1125 | 157 | 1 |
75736 | 75736 | 2020-04-21 | Washington | Alabama | 1129 | 17 | 1 |
75737 | 75737 | 2020-04-21 | Wilcox | Alabama | 1131 | 49 | 1 |
75695 | 75695 | 2020-04-21 | Dallas | Alabama | 1047 | 29 | 2 |
75696 | 75696 | 2020-04-21 | DeKalb | Alabama | 1049 | 51 | 2 |
75707 | 75707 | 2020-04-21 | Jackson | Alabama | 1071 | 41 | 2 |
75715 | 75715 | 2020-04-21 | Macon | Alabama | 1087 | 27 | 2 |
75717 | 75717 | 2020-04-21 | Marengo | Alabama | 1091 | 35 | 2 |
75732 | 75732 | 2020-04-21 | Talladega | Alabama | 1121 | 50 | 2 |
75673 | 75673 | 2020-04-21 | Baldwin | Alabama | 1003 | 123 | 3 |
75679 | 75679 | 2020-04-21 | Calhoun | Alabama | 1015 | 83 | 3 |
75706 | 75706 | 2020-04-21 | Houston | Alabama | 1069 | 73 | 3 |
75722 | 75722 | 2020-04-21 | Montgomery | Alabama | 1101 | 245 | 3 |
75727 | 75727 | 2020-04-21 | Randolph | Alabama | 1111 | 59 | 3 |
75710 | 75710 | 2020-04-21 | Lauderdale | Alabama | 1077 | 25 | 4 |
75716 | 75716 | 2020-04-21 | Madison | Alabama | 1089 | 203 | 4 |
75718 | 75718 | 2020-04-21 | Marion | Alabama | 1093 | 65 | 5 |
75719 | 75719 | 2020-04-21 | Marshall | Alabama | 1095 | 195 | 5 |
75729 | 75729 | 2020-04-21 | Shelby | Alabama | 1117 | 274 | 6 |
75699 | 75699 | 2020-04-21 | Etowah | Alabama | 1055 | 110 | 8 |
75733 | 75733 | 2020-04-21 | Tallapoosa | Alabama | 1123 | 228 | 14 |
75680 | 75680 | 2020-04-21 | Chambers | Alabama | 1017 | 259 | 16 |
75712 | 75712 | 2020-04-21 | Lee | Alabama | 1081 | 319 | 19 |
75708 | 75708 | 2020-04-21 | Jefferson | Alabama | 1073 | 700 | 26 |
75720 | 75720 | 2020-04-21 | Mobile | Alabama | 1097 | 721 | 38 |
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);