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 );