ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-01-31" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
982098 | 982098 | 2021-01-31 | Autauga | Alabama | 1001 | 5669 | 69 |
982099 | 982099 | 2021-01-31 | Baldwin | Alabama | 1003 | 18126 | 224 |
982100 | 982100 | 2021-01-31 | Barbour | Alabama | 1005 | 1951 | 40 |
982101 | 982101 | 2021-01-31 | Bibb | Alabama | 1007 | 2307 | 52 |
982102 | 982102 | 2021-01-31 | Blount | Alabama | 1009 | 5713 | 100 |
982103 | 982103 | 2021-01-31 | Bullock | Alabama | 1011 | 1086 | 29 |
982104 | 982104 | 2021-01-31 | Butler | Alabama | 1013 | 1812 | 60 |
982105 | 982105 | 2021-01-31 | Calhoun | Alabama | 1015 | 12011 | 232 |
982106 | 982106 | 2021-01-31 | Chambers | Alabama | 1017 | 3203 | 76 |
982107 | 982107 | 2021-01-31 | Cherokee | Alabama | 1019 | 1704 | 35 |
982108 | 982108 | 2021-01-31 | Chilton | Alabama | 1021 | 3544 | 79 |
982109 | 982109 | 2021-01-31 | Choctaw | Alabama | 1023 | 535 | 24 |
982110 | 982110 | 2021-01-31 | Clarke | Alabama | 1025 | 3227 | 38 |
982111 | 982111 | 2021-01-31 | Clay | Alabama | 1027 | 1328 | 50 |
982112 | 982112 | 2021-01-31 | Cleburne | Alabama | 1029 | 1281 | 28 |
982113 | 982113 | 2021-01-31 | Coffee | Alabama | 1031 | 4915 | 72 |
982114 | 982114 | 2021-01-31 | Colbert | Alabama | 1033 | 5736 | 104 |
982115 | 982115 | 2021-01-31 | Conecuh | Alabama | 1035 | 1007 | 23 |
982116 | 982116 | 2021-01-31 | Coosa | Alabama | 1037 | 678 | 19 |
982117 | 982117 | 2021-01-31 | Covington | Alabama | 1039 | 3581 | 87 |
982118 | 982118 | 2021-01-31 | Crenshaw | Alabama | 1041 | 1312 | 48 |
982119 | 982119 | 2021-01-31 | Cullman | Alabama | 1043 | 8551 | 149 |
982120 | 982120 | 2021-01-31 | Dale | Alabama | 1045 | 4290 | 98 |
982121 | 982121 | 2021-01-31 | Dallas | Alabama | 1047 | 3224 | 111 |
982122 | 982122 | 2021-01-31 | DeKalb | Alabama | 1049 | 8133 | 137 |
982123 | 982123 | 2021-01-31 | Elmore | Alabama | 1051 | 8602 | 134 |
982124 | 982124 | 2021-01-31 | Escambia | Alabama | 1053 | 3523 | 48 |
982125 | 982125 | 2021-01-31 | Etowah | Alabama | 1055 | 12515 | 246 |
982126 | 982126 | 2021-01-31 | Fayette | Alabama | 1057 | 1856 | 38 |
982127 | 982127 | 2021-01-31 | Franklin | Alabama | 1059 | 3842 | 60 |
982128 | 982128 | 2021-01-31 | Geneva | Alabama | 1061 | 2258 | 52 |
982129 | 982129 | 2021-01-31 | Greene | Alabama | 1063 | 801 | 27 |
982130 | 982130 | 2021-01-31 | Hale | Alabama | 1065 | 1958 | 54 |
982131 | 982131 | 2021-01-31 | Henry | Alabama | 1067 | 1675 | 32 |
982132 | 982132 | 2021-01-31 | Houston | Alabama | 1069 | 9471 | 209 |
982133 | 982133 | 2021-01-31 | Jackson | Alabama | 1071 | 6245 | 70 |
982134 | 982134 | 2021-01-31 | Jefferson | Alabama | 1073 | 66884 | 1128 |
982135 | 982135 | 2021-01-31 | Lamar | Alabama | 1075 | 1248 | 28 |
982136 | 982136 | 2021-01-31 | Lauderdale | Alabama | 1077 | 8180 | 156 |
982137 | 982137 | 2021-01-31 | Lawrence | Alabama | 1079 | 2647 | 70 |
982138 | 982138 | 2021-01-31 | Lee | Alabama | 1081 | 13829 | 128 |
982139 | 982139 | 2021-01-31 | Limestone | Alabama | 1083 | 8676 | 106 |
982140 | 982140 | 2021-01-31 | Lowndes | Alabama | 1085 | 1232 | 39 |
982141 | 982141 | 2021-01-31 | Macon | Alabama | 1087 | 1288 | 38 |
982142 | 982142 | 2021-01-31 | Madison | Alabama | 1089 | 29680 | 287 |
982143 | 982143 | 2021-01-31 | Marengo | Alabama | 1091 | 2188 | 34 |
982144 | 982144 | 2021-01-31 | Marion | Alabama | 1093 | 2613 | 74 |
982145 | 982145 | 2021-01-31 | Marshall | Alabama | 1095 | 10780 | 152 |
982146 | 982146 | 2021-01-31 | Mobile | Alabama | 1097 | 33060 | 611 |
982147 | 982147 | 2021-01-31 | Monroe | Alabama | 1099 | 1569 | 22 |
982148 | 982148 | 2021-01-31 | Montgomery | Alabama | 1101 | 20921 | 370 |
982149 | 982149 | 2021-01-31 | Morgan | Alabama | 1103 | 13001 | 175 |
982150 | 982150 | 2021-01-31 | Perry | Alabama | 1105 | 1027 | 20 |
982151 | 982151 | 2021-01-31 | Pickens | Alabama | 1107 | 2095 | 33 |
982152 | 982152 | 2021-01-31 | Pike | Alabama | 1109 | 2746 | 41 |
982153 | 982153 | 2021-01-31 | Randolph | Alabama | 1111 | 1518 | 37 |
982154 | 982154 | 2021-01-31 | Russell | Alabama | 1113 | 3751 | 19 |
982155 | 982155 | 2021-01-31 | Shelby | Alabama | 1117 | 20216 | 160 |
982156 | 982156 | 2021-01-31 | St. Clair | Alabama | 1115 | 8159 | 155 |
982157 | 982157 | 2021-01-31 | Sumter | Alabama | 1119 | 930 | 28 |
982158 | 982158 | 2021-01-31 | Talladega | Alabama | 1121 | 6837 | 117 |
982159 | 982159 | 2021-01-31 | Tallapoosa | Alabama | 1123 | 3325 | 114 |
982160 | 982160 | 2021-01-31 | Tuscaloosa | Alabama | 1125 | 22421 | 302 |
982161 | 982161 | 2021-01-31 | Walker | Alabama | 1127 | 6158 | 197 |
982162 | 982162 | 2021-01-31 | Washington | Alabama | 1129 | 1474 | 27 |
982163 | 982163 | 2021-01-31 | Wilcox | Alabama | 1131 | 1137 | 22 |
982164 | 982164 | 2021-01-31 | Winston | Alabama | 1133 | 2379 | 44 |
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);