us-counties-recent
Data source: Big Local News · About: big-local-datasette
94,127 rows sorted by state
This data as json, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1 | 1 | 2021-01-31 | Autauga | Alabama | 1001 | 5669 | 69 |
2 | 2 | 2021-01-31 | Baldwin | Alabama | 1003 | 18126 | 224 |
3 | 3 | 2021-01-31 | Barbour | Alabama | 1005 | 1951 | 40 |
4 | 4 | 2021-01-31 | Bibb | Alabama | 1007 | 2307 | 52 |
5 | 5 | 2021-01-31 | Blount | Alabama | 1009 | 5713 | 100 |
6 | 6 | 2021-01-31 | Bullock | Alabama | 1011 | 1086 | 29 |
7 | 7 | 2021-01-31 | Butler | Alabama | 1013 | 1812 | 60 |
8 | 8 | 2021-01-31 | Calhoun | Alabama | 1015 | 12011 | 232 |
9 | 9 | 2021-01-31 | Chambers | Alabama | 1017 | 3203 | 76 |
10 | 10 | 2021-01-31 | Cherokee | Alabama | 1019 | 1704 | 35 |
11 | 11 | 2021-01-31 | Chilton | Alabama | 1021 | 3544 | 79 |
12 | 12 | 2021-01-31 | Choctaw | Alabama | 1023 | 535 | 24 |
13 | 13 | 2021-01-31 | Clarke | Alabama | 1025 | 3227 | 38 |
14 | 14 | 2021-01-31 | Clay | Alabama | 1027 | 1328 | 50 |
15 | 15 | 2021-01-31 | Cleburne | Alabama | 1029 | 1281 | 28 |
16 | 16 | 2021-01-31 | Coffee | Alabama | 1031 | 4915 | 72 |
17 | 17 | 2021-01-31 | Colbert | Alabama | 1033 | 5736 | 104 |
18 | 18 | 2021-01-31 | Conecuh | Alabama | 1035 | 1007 | 23 |
19 | 19 | 2021-01-31 | Coosa | Alabama | 1037 | 678 | 19 |
20 | 20 | 2021-01-31 | Covington | Alabama | 1039 | 3581 | 87 |
21 | 21 | 2021-01-31 | Crenshaw | Alabama | 1041 | 1312 | 48 |
22 | 22 | 2021-01-31 | Cullman | Alabama | 1043 | 8551 | 149 |
23 | 23 | 2021-01-31 | Dale | Alabama | 1045 | 4290 | 98 |
24 | 24 | 2021-01-31 | Dallas | Alabama | 1047 | 3224 | 111 |
25 | 25 | 2021-01-31 | DeKalb | Alabama | 1049 | 8133 | 137 |
26 | 26 | 2021-01-31 | Elmore | Alabama | 1051 | 8602 | 134 |
27 | 27 | 2021-01-31 | Escambia | Alabama | 1053 | 3523 | 48 |
28 | 28 | 2021-01-31 | Etowah | Alabama | 1055 | 12515 | 246 |
29 | 29 | 2021-01-31 | Fayette | Alabama | 1057 | 1856 | 38 |
30 | 30 | 2021-01-31 | Franklin | Alabama | 1059 | 3842 | 60 |
31 | 31 | 2021-01-31 | Geneva | Alabama | 1061 | 2258 | 52 |
32 | 32 | 2021-01-31 | Greene | Alabama | 1063 | 801 | 27 |
33 | 33 | 2021-01-31 | Hale | Alabama | 1065 | 1958 | 54 |
34 | 34 | 2021-01-31 | Henry | Alabama | 1067 | 1675 | 32 |
35 | 35 | 2021-01-31 | Houston | Alabama | 1069 | 9471 | 209 |
36 | 36 | 2021-01-31 | Jackson | Alabama | 1071 | 6245 | 70 |
37 | 37 | 2021-01-31 | Jefferson | Alabama | 1073 | 66884 | 1128 |
38 | 38 | 2021-01-31 | Lamar | Alabama | 1075 | 1248 | 28 |
39 | 39 | 2021-01-31 | Lauderdale | Alabama | 1077 | 8180 | 156 |
40 | 40 | 2021-01-31 | Lawrence | Alabama | 1079 | 2647 | 70 |
41 | 41 | 2021-01-31 | Lee | Alabama | 1081 | 13829 | 128 |
42 | 42 | 2021-01-31 | Limestone | Alabama | 1083 | 8676 | 106 |
43 | 43 | 2021-01-31 | Lowndes | Alabama | 1085 | 1232 | 39 |
44 | 44 | 2021-01-31 | Macon | Alabama | 1087 | 1288 | 38 |
45 | 45 | 2021-01-31 | Madison | Alabama | 1089 | 29680 | 287 |
46 | 46 | 2021-01-31 | Marengo | Alabama | 1091 | 2188 | 34 |
47 | 47 | 2021-01-31 | Marion | Alabama | 1093 | 2613 | 74 |
48 | 48 | 2021-01-31 | Marshall | Alabama | 1095 | 10780 | 152 |
49 | 49 | 2021-01-31 | Mobile | Alabama | 1097 | 33060 | 611 |
50 | 50 | 2021-01-31 | Monroe | Alabama | 1099 | 1569 | 22 |
51 | 51 | 2021-01-31 | Montgomery | Alabama | 1101 | 20921 | 370 |
52 | 52 | 2021-01-31 | Morgan | Alabama | 1103 | 13001 | 175 |
53 | 53 | 2021-01-31 | Perry | Alabama | 1105 | 1027 | 20 |
54 | 54 | 2021-01-31 | Pickens | Alabama | 1107 | 2095 | 33 |
55 | 55 | 2021-01-31 | Pike | Alabama | 1109 | 2746 | 41 |
56 | 56 | 2021-01-31 | Randolph | Alabama | 1111 | 1518 | 37 |
57 | 57 | 2021-01-31 | Russell | Alabama | 1113 | 3751 | 19 |
58 | 58 | 2021-01-31 | Shelby | Alabama | 1117 | 20216 | 160 |
59 | 59 | 2021-01-31 | St. Clair | Alabama | 1115 | 8159 | 155 |
60 | 60 | 2021-01-31 | Sumter | Alabama | 1119 | 930 | 28 |
61 | 61 | 2021-01-31 | Talladega | Alabama | 1121 | 6837 | 117 |
62 | 62 | 2021-01-31 | Tallapoosa | Alabama | 1123 | 3325 | 114 |
63 | 63 | 2021-01-31 | Tuscaloosa | Alabama | 1125 | 22421 | 302 |
64 | 64 | 2021-01-31 | Walker | Alabama | 1127 | 6158 | 197 |
65 | 65 | 2021-01-31 | Washington | Alabama | 1129 | 1474 | 27 |
66 | 66 | 2021-01-31 | Wilcox | Alabama | 1131 | 1137 | 22 |
67 | 67 | 2021-01-31 | Winston | Alabama | 1133 | 2379 | 44 |
3248 | 3248 | 2021-02-01 | Autauga | Alabama | 1001 | 5683 | 69 |
3249 | 3249 | 2021-02-01 | Baldwin | Alabama | 1003 | 18211 | 224 |
3250 | 3250 | 2021-02-01 | Barbour | Alabama | 1005 | 1956 | 40 |
3251 | 3251 | 2021-02-01 | Bibb | Alabama | 1007 | 2309 | 52 |
3252 | 3252 | 2021-02-01 | Blount | Alabama | 1009 | 5720 | 100 |
3253 | 3253 | 2021-02-01 | Bullock | Alabama | 1011 | 1089 | 29 |
3254 | 3254 | 2021-02-01 | Butler | Alabama | 1013 | 1827 | 60 |
3255 | 3255 | 2021-02-01 | Calhoun | Alabama | 1015 | 12062 | 232 |
3256 | 3256 | 2021-02-01 | Chambers | Alabama | 1017 | 3210 | 76 |
3257 | 3257 | 2021-02-01 | Cherokee | Alabama | 1019 | 1707 | 35 |
3258 | 3258 | 2021-02-01 | Chilton | Alabama | 1021 | 3553 | 79 |
3259 | 3259 | 2021-02-01 | Choctaw | Alabama | 1023 | 535 | 24 |
3260 | 3260 | 2021-02-01 | Clarke | Alabama | 1025 | 3228 | 38 |
3261 | 3261 | 2021-02-01 | Clay | Alabama | 1027 | 1330 | 50 |
3262 | 3262 | 2021-02-01 | Cleburne | Alabama | 1029 | 1286 | 28 |
3263 | 3263 | 2021-02-01 | Coffee | Alabama | 1031 | 4922 | 72 |
3264 | 3264 | 2021-02-01 | Colbert | Alabama | 1033 | 5745 | 104 |
3265 | 3265 | 2021-02-01 | Conecuh | Alabama | 1035 | 1010 | 23 |
3266 | 3266 | 2021-02-01 | Coosa | Alabama | 1037 | 681 | 19 |
3267 | 3267 | 2021-02-01 | Covington | Alabama | 1039 | 3589 | 87 |
3268 | 3268 | 2021-02-01 | Crenshaw | Alabama | 1041 | 1313 | 48 |
3269 | 3269 | 2021-02-01 | Cullman | Alabama | 1043 | 8574 | 149 |
3270 | 3270 | 2021-02-01 | Dale | Alabama | 1045 | 4310 | 98 |
3271 | 3271 | 2021-02-01 | Dallas | Alabama | 1047 | 3228 | 111 |
3272 | 3272 | 2021-02-01 | DeKalb | Alabama | 1049 | 8139 | 137 |
3273 | 3273 | 2021-02-01 | Elmore | Alabama | 1051 | 8640 | 134 |
3274 | 3274 | 2021-02-01 | Escambia | Alabama | 1053 | 3548 | 48 |
3275 | 3275 | 2021-02-01 | Etowah | Alabama | 1055 | 12550 | 246 |
3276 | 3276 | 2021-02-01 | Fayette | Alabama | 1057 | 1858 | 38 |
3277 | 3277 | 2021-02-01 | Franklin | Alabama | 1059 | 3846 | 60 |
3278 | 3278 | 2021-02-01 | Geneva | Alabama | 1061 | 2266 | 52 |
3279 | 3279 | 2021-02-01 | Greene | Alabama | 1063 | 806 | 27 |
3280 | 3280 | 2021-02-01 | Hale | Alabama | 1065 | 1961 | 54 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties-recent] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );