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-07-08 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1495030 | 1495030 | 2021-07-08 | Autauga | Alabama | 1001 | 7277 | 113 |
1495031 | 1495031 | 2021-07-08 | Baldwin | Alabama | 1003 | 22154 | 316 |
1495032 | 1495032 | 2021-07-08 | Barbour | Alabama | 1005 | 2354 | 60 |
1495033 | 1495033 | 2021-07-08 | Bibb | Alabama | 1007 | 2699 | 65 |
1495034 | 1495034 | 2021-07-08 | Blount | Alabama | 1009 | 7013 | 139 |
1495035 | 1495035 | 2021-07-08 | Bullock | Alabama | 1011 | 1250 | 42 |
1495036 | 1495036 | 2021-07-08 | Butler | Alabama | 1013 | 2270 | 71 |
1495037 | 1495037 | 2021-07-08 | Calhoun | Alabama | 1015 | 14795 | 331 |
1495038 | 1495038 | 2021-07-08 | Chambers | Alabama | 1017 | 3751 | 123 |
1495039 | 1495039 | 2021-07-08 | Cherokee | Alabama | 1019 | 1885 | 45 |
1495040 | 1495040 | 2021-07-08 | Chilton | Alabama | 1021 | 4500 | 116 |
1495041 | 1495041 | 2021-07-08 | Choctaw | Alabama | 1023 | 624 | 25 |
1495042 | 1495042 | 2021-07-08 | Clarke | Alabama | 1025 | 3540 | 61 |
1495043 | 1495043 | 2021-07-08 | Clay | Alabama | 1027 | 1603 | 59 |
1495044 | 1495044 | 2021-07-08 | Cleburne | Alabama | 1029 | 1547 | 43 |
1495045 | 1495045 | 2021-07-08 | Coffee | Alabama | 1031 | 5720 | 130 |
1495046 | 1495046 | 2021-07-08 | Colbert | Alabama | 1033 | 6445 | 140 |
1495047 | 1495047 | 2021-07-08 | Conecuh | Alabama | 1035 | 1153 | 30 |
1495048 | 1495048 | 2021-07-08 | Coosa | Alabama | 1037 | 1126 | 29 |
1495049 | 1495049 | 2021-07-08 | Covington | Alabama | 1039 | 4338 | 125 |
1495050 | 1495050 | 2021-07-08 | Crenshaw | Alabama | 1041 | 1593 | 57 |
1495051 | 1495051 | 2021-07-08 | Cullman | Alabama | 1043 | 10031 | 202 |
1495052 | 1495052 | 2021-07-08 | Dale | Alabama | 1045 | 4986 | 117 |
1495053 | 1495053 | 2021-07-08 | Dallas | Alabama | 1047 | 3628 | 160 |
1495054 | 1495054 | 2021-07-08 | DeKalb | Alabama | 1049 | 9040 | 190 |
1495055 | 1495055 | 2021-07-08 | Elmore | Alabama | 1051 | 10351 | 215 |
1495056 | 1495056 | 2021-07-08 | Escambia | Alabama | 1053 | 4043 | 81 |
1495057 | 1495057 | 2021-07-08 | Etowah | Alabama | 1055 | 14275 | 366 |
1495058 | 1495058 | 2021-07-08 | Fayette | Alabama | 1057 | 2207 | 63 |
1495059 | 1495059 | 2021-07-08 | Franklin | Alabama | 1059 | 4330 | 81 |
1495060 | 1495060 | 2021-07-08 | Geneva | Alabama | 1061 | 2601 | 81 |
1495061 | 1495061 | 2021-07-08 | Greene | Alabama | 1063 | 938 | 35 |
1495062 | 1495062 | 2021-07-08 | Hale | Alabama | 1065 | 2279 | 77 |
1495063 | 1495063 | 2021-07-08 | Henry | Alabama | 1067 | 1963 | 44 |
1495064 | 1495064 | 2021-07-08 | Houston | Alabama | 1069 | 10906 | 290 |
1495065 | 1495065 | 2021-07-08 | Jackson | Alabama | 1071 | 7080 | 114 |
1495066 | 1495066 | 2021-07-08 | Jefferson | Alabama | 1073 | 81507 | 1576 |
1495067 | 1495067 | 2021-07-08 | Lamar | Alabama | 1075 | 1478 | 38 |
1495068 | 1495068 | 2021-07-08 | Lauderdale | Alabama | 1077 | 9674 | 252 |
1495069 | 1495069 | 2021-07-08 | Lawrence | Alabama | 1079 | 3146 | 100 |
1495070 | 1495070 | 2021-07-08 | Lee | Alabama | 1081 | 16390 | 178 |
1495071 | 1495071 | 2021-07-08 | Limestone | Alabama | 1083 | 10234 | 158 |
1495072 | 1495072 | 2021-07-08 | Lowndes | Alabama | 1085 | 1421 | 54 |
1495073 | 1495073 | 2021-07-08 | Macon | Alabama | 1087 | 1638 | 52 |
1495074 | 1495074 | 2021-07-08 | Madison | Alabama | 1089 | 35941 | 527 |
1495075 | 1495075 | 2021-07-08 | Marengo | Alabama | 1091 | 2516 | 66 |
1495076 | 1495076 | 2021-07-08 | Marion | Alabama | 1093 | 3295 | 106 |
1495077 | 1495077 | 2021-07-08 | Marshall | Alabama | 1095 | 12527 | 232 |
1495078 | 1495078 | 2021-07-08 | Mobile | Alabama | 1097 | 42727 | 841 |
1495079 | 1495079 | 2021-07-08 | Monroe | Alabama | 1099 | 1830 | 41 |
1495080 | 1495080 | 2021-07-08 | Montgomery | Alabama | 1101 | 25182 | 620 |
1495081 | 1495081 | 2021-07-08 | Morgan | Alabama | 1103 | 14695 | 288 |
1495082 | 1495082 | 2021-07-08 | Perry | Alabama | 1105 | 1089 | 28 |
1495083 | 1495083 | 2021-07-08 | Pickens | Alabama | 1107 | 2375 | 62 |
1495084 | 1495084 | 2021-07-08 | Pike | Alabama | 1109 | 3159 | 78 |
1495085 | 1495085 | 2021-07-08 | Randolph | Alabama | 1111 | 1887 | 44 |
1495086 | 1495086 | 2021-07-08 | Russell | Alabama | 1113 | 4573 | 42 |
1495087 | 1495087 | 2021-07-08 | Shelby | Alabama | 1117 | 25847 | 255 |
1495088 | 1495088 | 2021-07-08 | St. Clair | Alabama | 1115 | 10229 | 250 |
1495089 | 1495089 | 2021-07-08 | Sumter | Alabama | 1119 | 1063 | 32 |
1495090 | 1495090 | 2021-07-08 | Talladega | Alabama | 1121 | 8498 | 185 |
1495091 | 1495091 | 2021-07-08 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1495092 | 1495092 | 2021-07-08 | Tuscaloosa | Alabama | 1125 | 26301 | 465 |
1495093 | 1495093 | 2021-07-08 | Walker | Alabama | 1127 | 7400 | 283 |
1495094 | 1495094 | 2021-07-08 | Washington | Alabama | 1129 | 1709 | 39 |
1495095 | 1495095 | 2021-07-08 | Wilcox | Alabama | 1131 | 1272 | 31 |
1495096 | 1495096 | 2021-07-08 | Winston | Alabama | 1133 | 2840 | 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);