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-05-08 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 |
---|---|---|---|---|---|---|---|
1297022 | 1297022 | 2021-05-08 | Autauga | Alabama | 1001 | 6918 | 108 |
1297023 | 1297023 | 2021-05-08 | Baldwin | Alabama | 1003 | 21123 | 308 |
1297024 | 1297024 | 2021-05-08 | Barbour | Alabama | 1005 | 2307 | 57 |
1297025 | 1297025 | 2021-05-08 | Bibb | Alabama | 1007 | 2605 | 64 |
1297026 | 1297026 | 2021-05-08 | Blount | Alabama | 1009 | 6656 | 137 |
1297027 | 1297027 | 2021-05-08 | Bullock | Alabama | 1011 | 1230 | 41 |
1297028 | 1297028 | 2021-05-08 | Butler | Alabama | 1013 | 2159 | 69 |
1297029 | 1297029 | 2021-05-08 | Calhoun | Alabama | 1015 | 14496 | 314 |
1297030 | 1297030 | 2021-05-08 | Chambers | Alabama | 1017 | 3560 | 123 |
1297031 | 1297031 | 2021-05-08 | Cherokee | Alabama | 1019 | 1846 | 45 |
1297032 | 1297032 | 2021-05-08 | Chilton | Alabama | 1021 | 4284 | 112 |
1297033 | 1297033 | 2021-05-08 | Choctaw | Alabama | 1023 | 606 | 24 |
1297034 | 1297034 | 2021-05-08 | Clarke | Alabama | 1025 | 3510 | 61 |
1297035 | 1297035 | 2021-05-08 | Clay | Alabama | 1027 | 1561 | 56 |
1297036 | 1297036 | 2021-05-08 | Cleburne | Alabama | 1029 | 1489 | 41 |
1297037 | 1297037 | 2021-05-08 | Coffee | Alabama | 1031 | 5509 | 119 |
1297038 | 1297038 | 2021-05-08 | Colbert | Alabama | 1033 | 6296 | 134 |
1297039 | 1297039 | 2021-05-08 | Conecuh | Alabama | 1035 | 1103 | 29 |
1297040 | 1297040 | 2021-05-08 | Coosa | Alabama | 1037 | 1072 | 28 |
1297041 | 1297041 | 2021-05-08 | Covington | Alabama | 1039 | 4118 | 118 |
1297042 | 1297042 | 2021-05-08 | Crenshaw | Alabama | 1041 | 1522 | 57 |
1297043 | 1297043 | 2021-05-08 | Cullman | Alabama | 1043 | 9659 | 193 |
1297044 | 1297044 | 2021-05-08 | Dale | Alabama | 1045 | 4830 | 111 |
1297045 | 1297045 | 2021-05-08 | Dallas | Alabama | 1047 | 3547 | 151 |
1297046 | 1297046 | 2021-05-08 | DeKalb | Alabama | 1049 | 8828 | 186 |
1297047 | 1297047 | 2021-05-08 | Elmore | Alabama | 1051 | 10052 | 205 |
1297048 | 1297048 | 2021-05-08 | Escambia | Alabama | 1053 | 3933 | 76 |
1297049 | 1297049 | 2021-05-08 | Etowah | Alabama | 1055 | 13826 | 353 |
1297050 | 1297050 | 2021-05-08 | Fayette | Alabama | 1057 | 2122 | 62 |
1297051 | 1297051 | 2021-05-08 | Franklin | Alabama | 1059 | 4256 | 82 |
1297052 | 1297052 | 2021-05-08 | Geneva | Alabama | 1061 | 2494 | 77 |
1297053 | 1297053 | 2021-05-08 | Greene | Alabama | 1063 | 923 | 34 |
1297054 | 1297054 | 2021-05-08 | Hale | Alabama | 1065 | 2228 | 77 |
1297055 | 1297055 | 2021-05-08 | Henry | Alabama | 1067 | 1887 | 44 |
1297056 | 1297056 | 2021-05-08 | Houston | Alabama | 1069 | 10561 | 281 |
1297057 | 1297057 | 2021-05-08 | Jackson | Alabama | 1071 | 6809 | 112 |
1297058 | 1297058 | 2021-05-08 | Jefferson | Alabama | 1073 | 76493 | 1522 |
1297059 | 1297059 | 2021-05-08 | Lamar | Alabama | 1075 | 1425 | 35 |
1297060 | 1297060 | 2021-05-08 | Lauderdale | Alabama | 1077 | 9420 | 241 |
1297061 | 1297061 | 2021-05-08 | Lawrence | Alabama | 1079 | 3002 | 98 |
1297062 | 1297062 | 2021-05-08 | Lee | Alabama | 1081 | 15873 | 171 |
1297063 | 1297063 | 2021-05-08 | Limestone | Alabama | 1083 | 9958 | 151 |
1297064 | 1297064 | 2021-05-08 | Lowndes | Alabama | 1085 | 1387 | 53 |
1297065 | 1297065 | 2021-05-08 | Macon | Alabama | 1087 | 1589 | 50 |
1297066 | 1297066 | 2021-05-08 | Madison | Alabama | 1089 | 34735 | 503 |
1297067 | 1297067 | 2021-05-08 | Marengo | Alabama | 1091 | 2496 | 64 |
1297068 | 1297068 | 2021-05-08 | Marion | Alabama | 1093 | 3116 | 101 |
1297069 | 1297069 | 2021-05-08 | Marshall | Alabama | 1095 | 12213 | 223 |
1297070 | 1297070 | 2021-05-08 | Mobile | Alabama | 1097 | 40959 | 804 |
1297071 | 1297071 | 2021-05-08 | Monroe | Alabama | 1099 | 1773 | 40 |
1297072 | 1297072 | 2021-05-08 | Montgomery | Alabama | 1101 | 24327 | 589 |
1297073 | 1297073 | 2021-05-08 | Morgan | Alabama | 1103 | 14288 | 279 |
1297074 | 1297074 | 2021-05-08 | Perry | Alabama | 1105 | 1075 | 26 |
1297075 | 1297075 | 2021-05-08 | Pickens | Alabama | 1107 | 2343 | 61 |
1297076 | 1297076 | 2021-05-08 | Pike | Alabama | 1109 | 3108 | 77 |
1297077 | 1297077 | 2021-05-08 | Randolph | Alabama | 1111 | 1801 | 41 |
1297078 | 1297078 | 2021-05-08 | Russell | Alabama | 1113 | 4407 | 38 |
1297079 | 1297079 | 2021-05-08 | Shelby | Alabama | 1117 | 23425 | 249 |
1297080 | 1297080 | 2021-05-08 | St. Clair | Alabama | 1115 | 9652 | 243 |
1297081 | 1297081 | 2021-05-08 | Sumter | Alabama | 1119 | 1044 | 32 |
1297082 | 1297082 | 2021-05-08 | Talladega | Alabama | 1121 | 8220 | 176 |
1297083 | 1297083 | 2021-05-08 | Tallapoosa | Alabama | 1123 | 4026 | 152 |
1297084 | 1297084 | 2021-05-08 | Tuscaloosa | Alabama | 1125 | 25749 | 452 |
1297085 | 1297085 | 2021-05-08 | Walker | Alabama | 1127 | 7231 | 277 |
1297086 | 1297086 | 2021-05-08 | Washington | Alabama | 1129 | 1672 | 39 |
1297087 | 1297087 | 2021-05-08 | Wilcox | Alabama | 1131 | 1270 | 30 |
1297088 | 1297088 | 2021-05-08 | Winston | Alabama | 1133 | 2742 | 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);