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-05 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2275003 | 2275003 | 2022-03-05 | Autauga | Alabama | 1001 | 15530 | 199 |
2275004 | 2275004 | 2022-03-05 | Baldwin | Alabama | 1003 | 55079 | 650 |
2275005 | 2275005 | 2022-03-05 | Barbour | Alabama | 1005 | 5447 | 94 |
2275006 | 2275006 | 2022-03-05 | Bibb | Alabama | 1007 | 6381 | 99 |
2275007 | 2275007 | 2022-03-05 | Blount | Alabama | 1009 | 14803 | 221 |
2275008 | 2275008 | 2022-03-05 | Bullock | Alabama | 1011 | 2281 | 49 |
2275009 | 2275009 | 2022-03-05 | Butler | Alabama | 1013 | 5037 | 122 |
2275010 | 2275010 | 2022-03-05 | Calhoun | Alabama | 1015 | 31887 | 590 |
2275011 | 2275011 | 2022-03-05 | Chambers | Alabama | 1017 | 8437 | 153 |
2275012 | 2275012 | 2022-03-05 | Cherokee | Alabama | 1019 | 5090 | 79 |
2275013 | 2275013 | 2022-03-05 | Chilton | Alabama | 1021 | 10656 | 192 |
2275014 | 2275014 | 2022-03-05 | Choctaw | Alabama | 1023 | 2033 | 35 |
2275015 | 2275015 | 2022-03-05 | Clarke | Alabama | 1025 | 7053 | 97 |
2275016 | 2275016 | 2022-03-05 | Clay | Alabama | 1027 | 4078 | 78 |
2275017 | 2275017 | 2022-03-05 | Cleburne | Alabama | 1029 | 3542 | 68 |
2275018 | 2275018 | 2022-03-05 | Coffee | Alabama | 1031 | 13312 | 224 |
2275019 | 2275019 | 2022-03-05 | Colbert | Alabama | 1033 | 16179 | 244 |
2275020 | 2275020 | 2022-03-05 | Conecuh | Alabama | 1035 | 2839 | 66 |
2275021 | 2275021 | 2022-03-05 | Coosa | Alabama | 1037 | 2921 | 55 |
2275022 | 2275022 | 2022-03-05 | Covington | Alabama | 1039 | 9246 | 220 |
2275023 | 2275023 | 2022-03-05 | Crenshaw | Alabama | 1041 | 3776 | 94 |
2275024 | 2275024 | 2022-03-05 | Cullman | Alabama | 1043 | 24427 | 354 |
2275025 | 2275025 | 2022-03-05 | Dale | Alabama | 1045 | 12430 | 219 |
2275026 | 2275026 | 2022-03-05 | Dallas | Alabama | 1047 | 8330 | 231 |
2275027 | 2275027 | 2022-03-05 | DeKalb | Alabama | 1049 | 18579 | 313 |
2275028 | 2275028 | 2022-03-05 | Elmore | Alabama | 1051 | 22898 | 330 |
2275029 | 2275029 | 2022-03-05 | Escambia | Alabama | 1053 | 9964 | 159 |
2275030 | 2275030 | 2022-03-05 | Etowah | Alabama | 1055 | 28693 | 607 |
2275031 | 2275031 | 2022-03-05 | Fayette | Alabama | 1057 | 4927 | 93 |
2275032 | 2275032 | 2022-03-05 | Franklin | Alabama | 1059 | 9815 | 135 |
2275033 | 2275033 | 2022-03-05 | Geneva | Alabama | 1061 | 6195 | 155 |
2275034 | 2275034 | 2022-03-05 | Greene | Alabama | 1063 | 1856 | 48 |
2275035 | 2275035 | 2022-03-05 | Hale | Alabama | 1065 | 4668 | 101 |
2275036 | 2275036 | 2022-03-05 | Henry | Alabama | 1067 | 4445 | 70 |
2275037 | 2275037 | 2022-03-05 | Houston | Alabama | 1069 | 24917 | 479 |
2275038 | 2275038 | 2022-03-05 | Jackson | Alabama | 1071 | 14938 | 229 |
2275039 | 2275039 | 2022-03-05 | Jefferson | Alabama | 1073 | 182156 | 2234 |
2275040 | 2275040 | 2022-03-05 | Lamar | Alabama | 1075 | 3665 | 62 |
2275041 | 2275041 | 2022-03-05 | Lauderdale | Alabama | 1077 | 23953 | 372 |
2275042 | 2275042 | 2022-03-05 | Lawrence | Alabama | 1079 | 7590 | 152 |
2275043 | 2275043 | 2022-03-05 | Lee | Alabama | 1081 | 37544 | 317 |
2275044 | 2275044 | 2022-03-05 | Limestone | Alabama | 1083 | 24715 | 273 |
2275045 | 2275045 | 2022-03-05 | Lowndes | Alabama | 1085 | 2601 | 73 |
2275046 | 2275046 | 2022-03-05 | Macon | Alabama | 1087 | 3835 | 77 |
2275047 | 2275047 | 2022-03-05 | Madison | Alabama | 1089 | 88436 | 897 |
2275048 | 2275048 | 2022-03-05 | Marengo | Alabama | 1091 | 5150 | 103 |
2275049 | 2275049 | 2022-03-05 | Marion | Alabama | 1093 | 7996 | 147 |
2275050 | 2275050 | 2022-03-05 | Marshall | Alabama | 1095 | 27126 | 371 |
2275051 | 2275051 | 2022-03-05 | Mobile | Alabama | 1097 | 112704 | 1577 |
2275052 | 2275052 | 2022-03-05 | Monroe | Alabama | 1099 | 5256 | 78 |
2275053 | 2275053 | 2022-03-05 | Montgomery | Alabama | 1101 | 54452 | 874 |
2275054 | 2275054 | 2022-03-05 | Morgan | Alabama | 1103 | 35874 | 482 |
2275055 | 2275055 | 2022-03-05 | Perry | Alabama | 1105 | 2090 | 43 |
2275056 | 2275056 | 2022-03-05 | Pickens | Alabama | 1107 | 5167 | 97 |
2275057 | 2275057 | 2022-03-05 | Pike | Alabama | 1109 | 7417 | 127 |
2275058 | 2275058 | 2022-03-05 | Randolph | Alabama | 1111 | 5047 | 74 |
2275059 | 2275059 | 2022-03-05 | Russell | Alabama | 1113 | 10001 | 81 |
2275060 | 2275060 | 2022-03-05 | Shelby | Alabama | 1117 | 58902 | 423 |
2275061 | 2275061 | 2022-03-05 | St. Clair | Alabama | 1115 | 24999 | 402 |
2275062 | 2275062 | 2022-03-05 | Sumter | Alabama | 1119 | 2561 | 46 |
2275063 | 2275063 | 2022-03-05 | Talladega | Alabama | 1121 | 22132 | 353 |
2275064 | 2275064 | 2022-03-05 | Tallapoosa | Alabama | 1123 | 11312 | 223 |
2275065 | 2275065 | 2022-03-05 | Tuscaloosa | Alabama | 1125 | 54966 | 733 |
2275066 | 2275066 | 2022-03-05 | Walker | Alabama | 1127 | 18484 | 419 |
2275067 | 2275067 | 2022-03-05 | Washington | Alabama | 1129 | 3717 | 56 |
2275068 | 2275068 | 2022-03-05 | Wilcox | Alabama | 1131 | 2864 | 42 |
2275069 | 2275069 | 2022-03-05 | Winston | Alabama | 1133 | 7544 | 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);