us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows sorted by state
This data as json, copyable, CSV (advanced)
| Link | rowid | date | county | state ▼ | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 1620 | 1620 | 2020-03-13 | Elmore | Alabama | 1051 | 1 | 0 |
| 1621 | 1621 | 2020-03-13 | Jefferson | Alabama | 1073 | 2 | 0 |
| 1622 | 1622 | 2020-03-13 | Limestone | Alabama | 1083 | 1 | 0 |
| 1623 | 1623 | 2020-03-13 | Montgomery | Alabama | 1101 | 1 | 0 |
| 1624 | 1624 | 2020-03-13 | Tuscaloosa | Alabama | 1125 | 1 | 0 |
| 1935 | 1935 | 2020-03-14 | Baldwin | Alabama | 1003 | 1 | 0 |
| 1936 | 1936 | 2020-03-14 | Elmore | Alabama | 1051 | 1 | 0 |
| 1937 | 1937 | 2020-03-14 | Jefferson | Alabama | 1073 | 6 | 0 |
| 1938 | 1938 | 2020-03-14 | Limestone | Alabama | 1083 | 1 | 0 |
| 1939 | 1939 | 2020-03-14 | Montgomery | Alabama | 1101 | 1 | 0 |
| 1940 | 1940 | 2020-03-14 | Tuscaloosa | Alabama | 1125 | 2 | 0 |
| 2310 | 2310 | 2020-03-15 | Baldwin | Alabama | 1003 | 1 | 0 |
| 2311 | 2311 | 2020-03-15 | Elmore | Alabama | 1051 | 1 | 0 |
| 2312 | 2312 | 2020-03-15 | Jefferson | Alabama | 1073 | 13 | 0 |
| 2313 | 2313 | 2020-03-15 | Lee | Alabama | 1081 | 1 | 0 |
| 2314 | 2314 | 2020-03-15 | Limestone | Alabama | 1083 | 1 | 0 |
| 2315 | 2315 | 2020-03-15 | Montgomery | Alabama | 1101 | 1 | 0 |
| 2316 | 2316 | 2020-03-15 | Shelby | Alabama | 1117 | 2 | 0 |
| 2317 | 2317 | 2020-03-15 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
| 2739 | 2739 | 2020-03-16 | Baldwin | Alabama | 1003 | 1 | 0 |
| 2740 | 2740 | 2020-03-16 | Elmore | Alabama | 1051 | 1 | 0 |
| 2741 | 2741 | 2020-03-16 | Jefferson | Alabama | 1073 | 17 | 0 |
| 2742 | 2742 | 2020-03-16 | Lee | Alabama | 1081 | 1 | 0 |
| 2743 | 2743 | 2020-03-16 | Limestone | Alabama | 1083 | 1 | 0 |
| 2744 | 2744 | 2020-03-16 | Montgomery | Alabama | 1101 | 2 | 0 |
| 2745 | 2745 | 2020-03-16 | Shelby | Alabama | 1117 | 3 | 0 |
| 2746 | 2746 | 2020-03-16 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
| 3215 | 3215 | 2020-03-17 | Baldwin | Alabama | 1003 | 1 | 0 |
| 3216 | 3216 | 2020-03-17 | Elmore | Alabama | 1051 | 2 | 0 |
| 3217 | 3217 | 2020-03-17 | Jefferson | Alabama | 1073 | 21 | 0 |
| 3218 | 3218 | 2020-03-17 | Lee | Alabama | 1081 | 3 | 0 |
| 3219 | 3219 | 2020-03-17 | Limestone | Alabama | 1083 | 1 | 0 |
| 3220 | 3220 | 2020-03-17 | Madison | Alabama | 1089 | 1 | 0 |
| 3221 | 3221 | 2020-03-17 | Montgomery | Alabama | 1101 | 2 | 0 |
| 3222 | 3222 | 2020-03-17 | Shelby | Alabama | 1117 | 4 | 0 |
| 3223 | 3223 | 2020-03-17 | St. Clair | Alabama | 1115 | 1 | 0 |
| 3224 | 3224 | 2020-03-17 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
| 3761 | 3761 | 2020-03-18 | Baldwin | Alabama | 1003 | 1 | 0 |
| 3762 | 3762 | 2020-03-18 | Calhoun | Alabama | 1015 | 1 | 0 |
| 3763 | 3763 | 2020-03-18 | Elmore | Alabama | 1051 | 4 | 0 |
| 3764 | 3764 | 2020-03-18 | Jefferson | Alabama | 1073 | 25 | 0 |
| 3765 | 3765 | 2020-03-18 | Lee | Alabama | 1081 | 7 | 0 |
| 3766 | 3766 | 2020-03-18 | Limestone | Alabama | 1083 | 1 | 0 |
| 3767 | 3767 | 2020-03-18 | Madison | Alabama | 1089 | 1 | 0 |
| 3768 | 3768 | 2020-03-18 | Montgomery | Alabama | 1101 | 2 | 0 |
| 3769 | 3769 | 2020-03-18 | Shelby | Alabama | 1117 | 4 | 0 |
| 3770 | 3770 | 2020-03-18 | St. Clair | Alabama | 1115 | 1 | 0 |
| 3771 | 3771 | 2020-03-18 | Talladega | Alabama | 1121 | 1 | 0 |
| 3772 | 3772 | 2020-03-18 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
| 4401 | 4401 | 2020-03-19 | Baldwin | Alabama | 1003 | 1 | 0 |
| 4402 | 4402 | 2020-03-19 | Calhoun | Alabama | 1015 | 1 | 0 |
| 4403 | 4403 | 2020-03-19 | Chambers | Alabama | 1017 | 1 | 0 |
| 4404 | 4404 | 2020-03-19 | Elmore | Alabama | 1051 | 5 | 0 |
| 4405 | 4405 | 2020-03-19 | Jefferson | Alabama | 1073 | 34 | 0 |
| 4406 | 4406 | 2020-03-19 | Lee | Alabama | 1081 | 10 | 0 |
| 4407 | 4407 | 2020-03-19 | Limestone | Alabama | 1083 | 1 | 0 |
| 4408 | 4408 | 2020-03-19 | Madison | Alabama | 1089 | 5 | 0 |
| 4409 | 4409 | 2020-03-19 | Mobile | Alabama | 1097 | 1 | 0 |
| 4410 | 4410 | 2020-03-19 | Montgomery | Alabama | 1101 | 3 | 0 |
| 4411 | 4411 | 2020-03-19 | Shelby | Alabama | 1117 | 9 | 0 |
| 4412 | 4412 | 2020-03-19 | St. Clair | Alabama | 1115 | 1 | 0 |
| 4413 | 4413 | 2020-03-19 | Talladega | Alabama | 1121 | 1 | 0 |
| 4414 | 4414 | 2020-03-19 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
| 4415 | 4415 | 2020-03-19 | Walker | Alabama | 1127 | 1 | 0 |
| 5167 | 5167 | 2020-03-20 | Baldwin | Alabama | 1003 | 2 | 0 |
| 5168 | 5168 | 2020-03-20 | Calhoun | Alabama | 1015 | 1 | 0 |
| 5169 | 5169 | 2020-03-20 | Chambers | Alabama | 1017 | 1 | 0 |
| 5170 | 5170 | 2020-03-20 | Cullman | Alabama | 1043 | 1 | 0 |
| 5171 | 5171 | 2020-03-20 | Elmore | Alabama | 1051 | 6 | 0 |
| 5172 | 5172 | 2020-03-20 | Jackson | Alabama | 1071 | 1 | 0 |
| 5173 | 5173 | 2020-03-20 | Jefferson | Alabama | 1073 | 50 | 0 |
| 5174 | 5174 | 2020-03-20 | Lamar | Alabama | 1075 | 1 | 0 |
| 5175 | 5175 | 2020-03-20 | Lauderdale | Alabama | 1077 | 1 | 0 |
| 5176 | 5176 | 2020-03-20 | Lee | Alabama | 1081 | 11 | 0 |
| 5177 | 5177 | 2020-03-20 | Limestone | Alabama | 1083 | 1 | 0 |
| 5178 | 5178 | 2020-03-20 | Madison | Alabama | 1089 | 7 | 0 |
| 5179 | 5179 | 2020-03-20 | Mobile | Alabama | 1097 | 2 | 0 |
| 5180 | 5180 | 2020-03-20 | Montgomery | Alabama | 1101 | 3 | 0 |
| 5181 | 5181 | 2020-03-20 | Shelby | Alabama | 1117 | 10 | 0 |
| 5182 | 5182 | 2020-03-20 | St. Clair | Alabama | 1115 | 1 | 0 |
| 5183 | 5183 | 2020-03-20 | Talladega | Alabama | 1121 | 1 | 0 |
| 5184 | 5184 | 2020-03-20 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
| 5185 | 5185 | 2020-03-20 | Walker | Alabama | 1127 | 1 | 0 |
| 5186 | 5186 | 2020-03-20 | Washington | Alabama | 1129 | 1 | 0 |
| 6083 | 6083 | 2020-03-21 | Baldwin | Alabama | 1003 | 2 | 0 |
| 6084 | 6084 | 2020-03-21 | Calhoun | Alabama | 1015 | 1 | 0 |
| 6085 | 6085 | 2020-03-21 | Chambers | Alabama | 1017 | 1 | 0 |
| 6086 | 6086 | 2020-03-21 | Cullman | Alabama | 1043 | 2 | 0 |
| 6087 | 6087 | 2020-03-21 | Elmore | Alabama | 1051 | 6 | 0 |
| 6088 | 6088 | 2020-03-21 | Jackson | Alabama | 1071 | 1 | 0 |
| 6089 | 6089 | 2020-03-21 | Jefferson | Alabama | 1073 | 61 | 0 |
| 6090 | 6090 | 2020-03-21 | Lamar | Alabama | 1075 | 1 | 0 |
| 6091 | 6091 | 2020-03-21 | Lauderdale | Alabama | 1077 | 2 | 0 |
| 6092 | 6092 | 2020-03-21 | Lee | Alabama | 1081 | 12 | 0 |
| 6093 | 6093 | 2020-03-21 | Limestone | Alabama | 1083 | 1 | 0 |
| 6094 | 6094 | 2020-03-21 | Madison | Alabama | 1089 | 9 | 0 |
| 6095 | 6095 | 2020-03-21 | Marion | Alabama | 1093 | 1 | 0 |
| 6096 | 6096 | 2020-03-21 | Mobile | Alabama | 1097 | 2 | 0 |
| 6097 | 6097 | 2020-03-21 | Montgomery | Alabama | 1101 | 3 | 0 |
| 6098 | 6098 | 2020-03-21 | Shelby | Alabama | 1117 | 16 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );