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-03-01 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2261995 | 2261995 | 2022-03-01 | Autauga | Alabama | 1001 | 15520 | 195 |
2261996 | 2261996 | 2022-03-01 | Baldwin | Alabama | 1003 | 54987 | 641 |
2261997 | 2261997 | 2022-03-01 | Barbour | Alabama | 1005 | 5445 | 93 |
2261998 | 2261998 | 2022-03-01 | Bibb | Alabama | 1007 | 6375 | 99 |
2261999 | 2261999 | 2022-03-01 | Blount | Alabama | 1009 | 14772 | 219 |
2262000 | 2262000 | 2022-03-01 | Bullock | Alabama | 1011 | 2279 | 49 |
2262001 | 2262001 | 2022-03-01 | Butler | Alabama | 1013 | 5037 | 119 |
2262002 | 2262002 | 2022-03-01 | Calhoun | Alabama | 1015 | 31753 | 588 |
2262003 | 2262003 | 2022-03-01 | Chambers | Alabama | 1017 | 8433 | 153 |
2262004 | 2262004 | 2022-03-01 | Cherokee | Alabama | 1019 | 5086 | 78 |
2262005 | 2262005 | 2022-03-01 | Chilton | Alabama | 1021 | 10620 | 187 |
2262006 | 2262006 | 2022-03-01 | Choctaw | Alabama | 1023 | 2033 | 34 |
2262007 | 2262007 | 2022-03-01 | Clarke | Alabama | 1025 | 7044 | 96 |
2262008 | 2262008 | 2022-03-01 | Clay | Alabama | 1027 | 4066 | 76 |
2262009 | 2262009 | 2022-03-01 | Cleburne | Alabama | 1029 | 3533 | 68 |
2262010 | 2262010 | 2022-03-01 | Coffee | Alabama | 1031 | 13301 | 221 |
2262011 | 2262011 | 2022-03-01 | Colbert | Alabama | 1033 | 16149 | 238 |
2262012 | 2262012 | 2022-03-01 | Conecuh | Alabama | 1035 | 2838 | 66 |
2262013 | 2262013 | 2022-03-01 | Coosa | Alabama | 1037 | 2916 | 54 |
2262014 | 2262014 | 2022-03-01 | Covington | Alabama | 1039 | 9235 | 217 |
2262015 | 2262015 | 2022-03-01 | Crenshaw | Alabama | 1041 | 3770 | 92 |
2262016 | 2262016 | 2022-03-01 | Cullman | Alabama | 1043 | 24378 | 349 |
2262017 | 2262017 | 2022-03-01 | Dale | Alabama | 1045 | 12430 | 217 |
2262018 | 2262018 | 2022-03-01 | Dallas | Alabama | 1047 | 8307 | 229 |
2262019 | 2262019 | 2022-03-01 | DeKalb | Alabama | 1049 | 18564 | 310 |
2262020 | 2262020 | 2022-03-01 | Elmore | Alabama | 1051 | 22872 | 327 |
2262021 | 2262021 | 2022-03-01 | Escambia | Alabama | 1053 | 9956 | 157 |
2262022 | 2262022 | 2022-03-01 | Etowah | Alabama | 1055 | 28679 | 599 |
2262023 | 2262023 | 2022-03-01 | Fayette | Alabama | 1057 | 4904 | 92 |
2262024 | 2262024 | 2022-03-01 | Franklin | Alabama | 1059 | 9812 | 133 |
2262025 | 2262025 | 2022-03-01 | Geneva | Alabama | 1061 | 6181 | 154 |
2262026 | 2262026 | 2022-03-01 | Greene | Alabama | 1063 | 1853 | 48 |
2262027 | 2262027 | 2022-03-01 | Hale | Alabama | 1065 | 4669 | 99 |
2262028 | 2262028 | 2022-03-01 | Henry | Alabama | 1067 | 4439 | 70 |
2262029 | 2262029 | 2022-03-01 | Houston | Alabama | 1069 | 24883 | 474 |
2262030 | 2262030 | 2022-03-01 | Jackson | Alabama | 1071 | 14906 | 225 |
2262031 | 2262031 | 2022-03-01 | Jefferson | Alabama | 1073 | 181887 | 2224 |
2262032 | 2262032 | 2022-03-01 | Lamar | Alabama | 1075 | 3657 | 63 |
2262033 | 2262033 | 2022-03-01 | Lauderdale | Alabama | 1077 | 23923 | 368 |
2262034 | 2262034 | 2022-03-01 | Lawrence | Alabama | 1079 | 7566 | 150 |
2262035 | 2262035 | 2022-03-01 | Lee | Alabama | 1081 | 37525 | 315 |
2262036 | 2262036 | 2022-03-01 | Limestone | Alabama | 1083 | 24666 | 268 |
2262037 | 2262037 | 2022-03-01 | Lowndes | Alabama | 1085 | 2597 | 72 |
2262038 | 2262038 | 2022-03-01 | Macon | Alabama | 1087 | 3832 | 75 |
2262039 | 2262039 | 2022-03-01 | Madison | Alabama | 1089 | 88260 | 883 |
2262040 | 2262040 | 2022-03-01 | Marengo | Alabama | 1091 | 5150 | 103 |
2262041 | 2262041 | 2022-03-01 | Marion | Alabama | 1093 | 7973 | 144 |
2262042 | 2262042 | 2022-03-01 | Marshall | Alabama | 1095 | 27107 | 367 |
2262043 | 2262043 | 2022-03-01 | Mobile | Alabama | 1097 | 112171 | 1564 |
2262044 | 2262044 | 2022-03-01 | Monroe | Alabama | 1099 | 5253 | 77 |
2262045 | 2262045 | 2022-03-01 | Montgomery | Alabama | 1101 | 54384 | 866 |
2262046 | 2262046 | 2022-03-01 | Morgan | Alabama | 1103 | 35840 | 479 |
2262047 | 2262047 | 2022-03-01 | Perry | Alabama | 1105 | 2084 | 43 |
2262048 | 2262048 | 2022-03-01 | Pickens | Alabama | 1107 | 5162 | 96 |
2262049 | 2262049 | 2022-03-01 | Pike | Alabama | 1109 | 7418 | 127 |
2262050 | 2262050 | 2022-03-01 | Randolph | Alabama | 1111 | 5043 | 74 |
2262051 | 2262051 | 2022-03-01 | Russell | Alabama | 1113 | 9992 | 79 |
2262052 | 2262052 | 2022-03-01 | Shelby | Alabama | 1117 | 58791 | 417 |
2262053 | 2262053 | 2022-03-01 | St. Clair | Alabama | 1115 | 24952 | 397 |
2262054 | 2262054 | 2022-03-01 | Sumter | Alabama | 1119 | 2555 | 45 |
2262055 | 2262055 | 2022-03-01 | Talladega | Alabama | 1121 | 22059 | 350 |
2262056 | 2262056 | 2022-03-01 | Tallapoosa | Alabama | 1123 | 11299 | 222 |
2262057 | 2262057 | 2022-03-01 | Tuscaloosa | Alabama | 1125 | 54630 | 723 |
2262058 | 2262058 | 2022-03-01 | Walker | Alabama | 1127 | 18469 | 413 |
2262059 | 2262059 | 2022-03-01 | Washington | Alabama | 1129 | 3689 | 55 |
2262060 | 2262060 | 2022-03-01 | Wilcox | Alabama | 1131 | 2856 | 42 |
2262061 | 2262061 | 2022-03-01 | Winston | Alabama | 1133 | 7536 | 120 |
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);