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 2021-04-18 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1232085 | 1232085 | 2021-04-18 | Autauga | Alabama | 1001 | 6763 | 106 |
1232086 | 1232086 | 2021-04-18 | Baldwin | Alabama | 1003 | 20723 | 302 |
1232087 | 1232087 | 2021-04-18 | Barbour | Alabama | 1005 | 2271 | 55 |
1232088 | 1232088 | 2021-04-18 | Bibb | Alabama | 1007 | 2563 | 61 |
1232089 | 1232089 | 2021-04-18 | Blount | Alabama | 1009 | 6532 | 133 |
1232090 | 1232090 | 2021-04-18 | Bullock | Alabama | 1011 | 1220 | 40 |
1232091 | 1232091 | 2021-04-18 | Butler | Alabama | 1013 | 2132 | 68 |
1232092 | 1232092 | 2021-04-18 | Calhoun | Alabama | 1015 | 14355 | 311 |
1232093 | 1232093 | 2021-04-18 | Chambers | Alabama | 1017 | 3518 | 122 |
1232094 | 1232094 | 2021-04-18 | Cherokee | Alabama | 1019 | 1827 | 44 |
1232095 | 1232095 | 2021-04-18 | Chilton | Alabama | 1021 | 4129 | 110 |
1232096 | 1232096 | 2021-04-18 | Choctaw | Alabama | 1023 | 588 | 24 |
1232097 | 1232097 | 2021-04-18 | Clarke | Alabama | 1025 | 3473 | 60 |
1232098 | 1232098 | 2021-04-18 | Clay | Alabama | 1027 | 1502 | 55 |
1232099 | 1232099 | 2021-04-18 | Cleburne | Alabama | 1029 | 1470 | 41 |
1232100 | 1232100 | 2021-04-18 | Coffee | Alabama | 1031 | 5434 | 113 |
1232101 | 1232101 | 2021-04-18 | Colbert | Alabama | 1033 | 6235 | 132 |
1232102 | 1232102 | 2021-04-18 | Conecuh | Alabama | 1035 | 1097 | 28 |
1232103 | 1232103 | 2021-04-18 | Coosa | Alabama | 1037 | 994 | 28 |
1232104 | 1232104 | 2021-04-18 | Covington | Alabama | 1039 | 4069 | 115 |
1232105 | 1232105 | 2021-04-18 | Crenshaw | Alabama | 1041 | 1495 | 57 |
1232106 | 1232106 | 2021-04-18 | Cullman | Alabama | 1043 | 9508 | 191 |
1232107 | 1232107 | 2021-04-18 | Dale | Alabama | 1045 | 4781 | 111 |
1232108 | 1232108 | 2021-04-18 | Dallas | Alabama | 1047 | 3528 | 150 |
1232109 | 1232109 | 2021-04-18 | DeKalb | Alabama | 1049 | 8761 | 183 |
1232110 | 1232110 | 2021-04-18 | Elmore | Alabama | 1051 | 10022 | 203 |
1232111 | 1232111 | 2021-04-18 | Escambia | Alabama | 1053 | 3903 | 74 |
1232112 | 1232112 | 2021-04-18 | Etowah | Alabama | 1055 | 13703 | 348 |
1232113 | 1232113 | 2021-04-18 | Fayette | Alabama | 1057 | 2096 | 60 |
1232114 | 1232114 | 2021-04-18 | Franklin | Alabama | 1059 | 4213 | 82 |
1232115 | 1232115 | 2021-04-18 | Geneva | Alabama | 1061 | 2464 | 75 |
1232116 | 1232116 | 2021-04-18 | Greene | Alabama | 1063 | 914 | 34 |
1232117 | 1232117 | 2021-04-18 | Hale | Alabama | 1065 | 2186 | 75 |
1232118 | 1232118 | 2021-04-18 | Henry | Alabama | 1067 | 1883 | 44 |
1232119 | 1232119 | 2021-04-18 | Houston | Alabama | 1069 | 10414 | 279 |
1232120 | 1232120 | 2021-04-18 | Jackson | Alabama | 1071 | 6762 | 110 |
1232121 | 1232121 | 2021-04-18 | Jefferson | Alabama | 1073 | 75517 | 1494 |
1232122 | 1232122 | 2021-04-18 | Lamar | Alabama | 1075 | 1399 | 34 |
1232123 | 1232123 | 2021-04-18 | Lauderdale | Alabama | 1077 | 9276 | 233 |
1232124 | 1232124 | 2021-04-18 | Lawrence | Alabama | 1079 | 2964 | 95 |
1232125 | 1232125 | 2021-04-18 | Lee | Alabama | 1081 | 15631 | 166 |
1232126 | 1232126 | 2021-04-18 | Limestone | Alabama | 1083 | 9859 | 148 |
1232127 | 1232127 | 2021-04-18 | Lowndes | Alabama | 1085 | 1373 | 53 |
1232128 | 1232128 | 2021-04-18 | Macon | Alabama | 1087 | 1564 | 48 |
1232129 | 1232129 | 2021-04-18 | Madison | Alabama | 1089 | 34109 | 500 |
1232130 | 1232130 | 2021-04-18 | Marengo | Alabama | 1091 | 2485 | 61 |
1232131 | 1232131 | 2021-04-18 | Marion | Alabama | 1093 | 3072 | 100 |
1232132 | 1232132 | 2021-04-18 | Marshall | Alabama | 1095 | 12009 | 220 |
1232133 | 1232133 | 2021-04-18 | Mobile | Alabama | 1097 | 39126 | 799 |
1232134 | 1232134 | 2021-04-18 | Monroe | Alabama | 1099 | 1730 | 40 |
1232135 | 1232135 | 2021-04-18 | Montgomery | Alabama | 1101 | 24058 | 573 |
1232136 | 1232136 | 2021-04-18 | Morgan | Alabama | 1103 | 14168 | 273 |
1232137 | 1232137 | 2021-04-18 | Perry | Alabama | 1105 | 1076 | 26 |
1232138 | 1232138 | 2021-04-18 | Pickens | Alabama | 1107 | 2332 | 59 |
1232139 | 1232139 | 2021-04-18 | Pike | Alabama | 1109 | 3065 | 76 |
1232140 | 1232140 | 2021-04-18 | Randolph | Alabama | 1111 | 1777 | 41 |
1232141 | 1232141 | 2021-04-18 | Russell | Alabama | 1113 | 4312 | 39 |
1232142 | 1232142 | 2021-04-18 | Shelby | Alabama | 1117 | 23221 | 242 |
1232143 | 1232143 | 2021-04-18 | St. Clair | Alabama | 1115 | 9485 | 236 |
1232144 | 1232144 | 2021-04-18 | Sumter | Alabama | 1119 | 1033 | 32 |
1232145 | 1232145 | 2021-04-18 | Talladega | Alabama | 1121 | 8126 | 173 |
1232146 | 1232146 | 2021-04-18 | Tallapoosa | Alabama | 1123 | 3919 | 148 |
1232147 | 1232147 | 2021-04-18 | Tuscaloosa | Alabama | 1125 | 25405 | 444 |
1232148 | 1232148 | 2021-04-18 | Walker | Alabama | 1127 | 7149 | 276 |
1232149 | 1232149 | 2021-04-18 | Washington | Alabama | 1129 | 1654 | 38 |
1232150 | 1232150 | 2021-04-18 | Wilcox | Alabama | 1131 | 1247 | 27 |
1232151 | 1232151 | 2021-04-18 | Winston | Alabama | 1133 | 2732 | 72 |
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);