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 2022-02-09 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2196964 | 2196964 | 2022-02-09 | Autauga | Alabama | 1001 | 15121 | 173 |
2196965 | 2196965 | 2022-02-09 | Baldwin | Alabama | 1003 | 54095 | 626 |
2196966 | 2196966 | 2022-02-09 | Barbour | Alabama | 1005 | 5380 | 85 |
2196967 | 2196967 | 2022-02-09 | Bibb | Alabama | 1007 | 6267 | 96 |
2196968 | 2196968 | 2022-02-09 | Blount | Alabama | 1009 | 14447 | 212 |
2196969 | 2196969 | 2022-02-09 | Bullock | Alabama | 1011 | 2261 | 49 |
2196970 | 2196970 | 2022-02-09 | Butler | Alabama | 1013 | 4962 | 110 |
2196971 | 2196971 | 2022-02-09 | Calhoun | Alabama | 1015 | 30989 | 565 |
2196972 | 2196972 | 2022-02-09 | Chambers | Alabama | 1017 | 8332 | 149 |
2196973 | 2196973 | 2022-02-09 | Cherokee | Alabama | 1019 | 4969 | 70 |
2196974 | 2196974 | 2022-02-09 | Chilton | Alabama | 1021 | 10280 | 184 |
2196975 | 2196975 | 2022-02-09 | Choctaw | Alabama | 1023 | 1904 | 33 |
2196976 | 2196976 | 2022-02-09 | Clarke | Alabama | 1025 | 6921 | 93 |
2196977 | 2196977 | 2022-02-09 | Clay | Alabama | 1027 | 4012 | 73 |
2196978 | 2196978 | 2022-02-09 | Cleburne | Alabama | 1029 | 3488 | 65 |
2196979 | 2196979 | 2022-02-09 | Coffee | Alabama | 1031 | 13141 | 212 |
2196980 | 2196980 | 2022-02-09 | Colbert | Alabama | 1033 | 15805 | 222 |
2196981 | 2196981 | 2022-02-09 | Conecuh | Alabama | 1035 | 2805 | 63 |
2196982 | 2196982 | 2022-02-09 | Coosa | Alabama | 1037 | 2848 | 53 |
2196983 | 2196983 | 2022-02-09 | Covington | Alabama | 1039 | 9087 | 212 |
2196984 | 2196984 | 2022-02-09 | Crenshaw | Alabama | 1041 | 3712 | 84 |
2196985 | 2196985 | 2022-02-09 | Cullman | Alabama | 1043 | 23848 | 331 |
2196986 | 2196986 | 2022-02-09 | Dale | Alabama | 1045 | 12226 | 207 |
2196987 | 2196987 | 2022-02-09 | Dallas | Alabama | 1047 | 8118 | 226 |
2196988 | 2196988 | 2022-02-09 | DeKalb | Alabama | 1049 | 18214 | 296 |
2196989 | 2196989 | 2022-02-09 | Elmore | Alabama | 1051 | 22591 | 315 |
2196990 | 2196990 | 2022-02-09 | Escambia | Alabama | 1053 | 9845 | 153 |
2196991 | 2196991 | 2022-02-09 | Etowah | Alabama | 1055 | 28009 | 556 |
2196992 | 2196992 | 2022-02-09 | Fayette | Alabama | 1057 | 4505 | 87 |
2196993 | 2196993 | 2022-02-09 | Franklin | Alabama | 1059 | 9607 | 123 |
2196994 | 2196994 | 2022-02-09 | Geneva | Alabama | 1061 | 6032 | 146 |
2196995 | 2196995 | 2022-02-09 | Greene | Alabama | 1063 | 1772 | 48 |
2196996 | 2196996 | 2022-02-09 | Hale | Alabama | 1065 | 4484 | 96 |
2196997 | 2196997 | 2022-02-09 | Henry | Alabama | 1067 | 4355 | 67 |
2196998 | 2196998 | 2022-02-09 | Houston | Alabama | 1069 | 24432 | 457 |
2196999 | 2196999 | 2022-02-09 | Jackson | Alabama | 1071 | 14640 | 214 |
2197000 | 2197000 | 2022-02-09 | Jefferson | Alabama | 1073 | 179326 | 2122 |
2197001 | 2197001 | 2022-02-09 | Lamar | Alabama | 1075 | 3514 | 62 |
2197002 | 2197002 | 2022-02-09 | Lauderdale | Alabama | 1077 | 23366 | 343 |
2197003 | 2197003 | 2022-02-09 | Lawrence | Alabama | 1079 | 7327 | 144 |
2197004 | 2197004 | 2022-02-09 | Lee | Alabama | 1081 | 37018 | 289 |
2197005 | 2197005 | 2022-02-09 | Limestone | Alabama | 1083 | 24085 | 248 |
2197006 | 2197006 | 2022-02-09 | Lowndes | Alabama | 1085 | 2577 | 69 |
2197007 | 2197007 | 2022-02-09 | Macon | Alabama | 1087 | 3782 | 71 |
2197008 | 2197008 | 2022-02-09 | Madison | Alabama | 1089 | 85863 | 834 |
2197009 | 2197009 | 2022-02-09 | Marengo | Alabama | 1091 | 4632 | 97 |
2197010 | 2197010 | 2022-02-09 | Marion | Alabama | 1093 | 7796 | 139 |
2197011 | 2197011 | 2022-02-09 | Marshall | Alabama | 1095 | 26789 | 346 |
2197012 | 2197012 | 2022-02-09 | Mobile | Alabama | 1097 | 110014 | 1504 |
2197013 | 2197013 | 2022-02-09 | Monroe | Alabama | 1099 | 5182 | 71 |
2197014 | 2197014 | 2022-02-09 | Montgomery | Alabama | 1101 | 53528 | 827 |
2197015 | 2197015 | 2022-02-09 | Morgan | Alabama | 1103 | 34951 | 456 |
2197016 | 2197016 | 2022-02-09 | Perry | Alabama | 1105 | 2000 | 41 |
2197017 | 2197017 | 2022-02-09 | Pickens | Alabama | 1107 | 4980 | 95 |
2197018 | 2197018 | 2022-02-09 | Pike | Alabama | 1109 | 7242 | 119 |
2197019 | 2197019 | 2022-02-09 | Randolph | Alabama | 1111 | 4983 | 71 |
2197020 | 2197020 | 2022-02-09 | Russell | Alabama | 1113 | 9691 | 75 |
2197021 | 2197021 | 2022-02-09 | Shelby | Alabama | 1117 | 57763 | 404 |
2197022 | 2197022 | 2022-02-09 | St. Clair | Alabama | 1115 | 24514 | 382 |
2197023 | 2197023 | 2022-02-09 | Sumter | Alabama | 1119 | 2337 | 43 |
2197024 | 2197024 | 2022-02-09 | Talladega | Alabama | 1121 | 21480 | 330 |
2197025 | 2197025 | 2022-02-09 | Tallapoosa | Alabama | 1123 | 11126 | 213 |
2197026 | 2197026 | 2022-02-09 | Tuscaloosa | Alabama | 1125 | 53002 | 697 |
2197027 | 2197027 | 2022-02-09 | Walker | Alabama | 1127 | 18014 | 400 |
2197028 | 2197028 | 2022-02-09 | Washington | Alabama | 1129 | 3574 | 53 |
2197029 | 2197029 | 2022-02-09 | Wilcox | Alabama | 1131 | 2786 | 40 |
2197030 | 2197030 | 2022-02-09 | Winston | Alabama | 1133 | 7286 | 116 |
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);