ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,312 rows where state = "Alabama" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 67
- 1051 792
- 1073 792
- 1083 792
- 1101 792
- 1125 792
- 1003 791
- 1081 790
- 1117 790
- 1089 788
- 1115 788
- 1015 787
- 1121 787
- 1017 786
- 1097 786
- 1127 786
- 1043 785
- 1071 785
- 1075 785
- 1077 785
- 1129 785
- 1093 784
- 1059 782
- 1069 782
- 1123 782
- 1001 781
- 1103 781
- 1009 780
- 1013 780
- 1019 780
- 1021 780
- 1027 780
- 1029 780
- 1033 780
- 1047 780
- 1055 780
- 1079 780
- 1095 780
- 1107 780
- 1109 780
- 1113 780
- 1131 780
- 1011 779
- 1023 779
- 1037 779
- 1041 779
- 1049 779
- 1085 779
- 1091 779
- 1039 778
- 1053 778
- 1063 778
- 1111 778
- 1133 778
- 1099 777
- 1087 776
- 1007 775
- 1057 775
- 1065 775
- 1119 775
- 1025 773
- 1035 773
- 1045 773
- 1031 772
- 1005 771
- 1067 771
- 1105 765
- 1061 762
county 67
- Elmore 792
- Jefferson 792
- Limestone 792
- Montgomery 792
- Tuscaloosa 792
- Baldwin 791
- Lee 790
- Shelby 790
- Madison 788
- St. Clair 788
- Calhoun 787
- Talladega 787
- Chambers 786
- Mobile 786
- Walker 786
- Cullman 785
- Jackson 785
- Lamar 785
- Lauderdale 785
- Washington 785
- Marion 784
- Franklin 782
- Houston 782
- Tallapoosa 782
- Autauga 781
- Morgan 781
- Blount 780
- Butler 780
- Cherokee 780
- Chilton 780
- Clay 780
- Cleburne 780
- Colbert 780
- Dallas 780
- Etowah 780
- Lawrence 780
- Marshall 780
- Pickens 780
- Pike 780
- Russell 780
- Wilcox 780
- Bullock 779
- Choctaw 779
- Coosa 779
- Crenshaw 779
- DeKalb 779
- Lowndes 779
- Marengo 779
- Covington 778
- Escambia 778
- Greene 778
- Randolph 778
- Winston 778
- Monroe 777
- Macon 776
- Bibb 775
- Fayette 775
- Hale 775
- Sumter 775
- Clarke 773
- Conecuh 773
- Dale 773
- Coffee 772
- Barbour 771
- Henry 771
- Perry 765
- Geneva 762
state 1
- Alabama · 52,312 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
9481 | 9481 | 2020-03-24 | Autauga | Alabama | 1001 | 1 | 0 |
10836 | 10836 | 2020-03-25 | Autauga | Alabama | 1001 | 4 | 0 |
12368 | 12368 | 2020-03-26 | Autauga | Alabama | 1001 | 6 | 0 |
14026 | 14026 | 2020-03-27 | Autauga | Alabama | 1001 | 6 | 0 |
15804 | 15804 | 2020-03-28 | Autauga | Alabama | 1001 | 6 | 0 |
17687 | 17687 | 2020-03-29 | Autauga | Alabama | 1001 | 6 | 0 |
19656 | 19656 | 2020-03-30 | Autauga | Alabama | 1001 | 7 | 0 |
21728 | 21728 | 2020-03-31 | Autauga | Alabama | 1001 | 7 | 0 |
23881 | 23881 | 2020-04-01 | Autauga | Alabama | 1001 | 10 | 0 |
26102 | 26102 | 2020-04-02 | Autauga | Alabama | 1001 | 10 | 0 |
28397 | 28397 | 2020-04-03 | Autauga | Alabama | 1001 | 12 | 0 |
30754 | 30754 | 2020-04-04 | Autauga | Alabama | 1001 | 12 | 0 |
33158 | 33158 | 2020-04-05 | Autauga | Alabama | 1001 | 12 | 0 |
35597 | 35597 | 2020-04-06 | Autauga | Alabama | 1001 | 12 | 1 |
38085 | 38085 | 2020-04-07 | Autauga | Alabama | 1001 | 12 | 1 |
40627 | 40627 | 2020-04-08 | Autauga | Alabama | 1001 | 12 | 1 |
43200 | 43200 | 2020-04-09 | Autauga | Alabama | 1001 | 17 | 1 |
45798 | 45798 | 2020-04-10 | Autauga | Alabama | 1001 | 17 | 1 |
48427 | 48427 | 2020-04-11 | Autauga | Alabama | 1001 | 19 | 1 |
51088 | 51088 | 2020-04-12 | Autauga | Alabama | 1001 | 19 | 1 |
53766 | 53766 | 2020-04-13 | Autauga | Alabama | 1001 | 19 | 1 |
56458 | 56458 | 2020-04-14 | Autauga | Alabama | 1001 | 23 | 1 |
59166 | 59166 | 2020-04-15 | Autauga | Alabama | 1001 | 25 | 1 |
61884 | 61884 | 2020-04-16 | Autauga | Alabama | 1001 | 25 | 2 |
64617 | 64617 | 2020-04-17 | Autauga | Alabama | 1001 | 26 | 2 |
67365 | 67365 | 2020-04-18 | Autauga | Alabama | 1001 | 25 | 2 |
70127 | 70127 | 2020-04-19 | Autauga | Alabama | 1001 | 27 | 2 |
72896 | 72896 | 2020-04-20 | Autauga | Alabama | 1001 | 28 | 1 |
75672 | 75672 | 2020-04-21 | Autauga | Alabama | 1001 | 30 | 1 |
78455 | 78455 | 2020-04-22 | Autauga | Alabama | 1001 | 32 | 2 |
81248 | 81248 | 2020-04-23 | Autauga | Alabama | 1001 | 33 | 2 |
84049 | 84049 | 2020-04-24 | Autauga | Alabama | 1001 | 36 | 2 |
86857 | 86857 | 2020-04-25 | Autauga | Alabama | 1001 | 37 | 2 |
89673 | 89673 | 2020-04-26 | Autauga | Alabama | 1001 | 37 | 2 |
92491 | 92491 | 2020-04-27 | Autauga | Alabama | 1001 | 39 | 3 |
95321 | 95321 | 2020-04-28 | Autauga | Alabama | 1001 | 40 | 4 |
98166 | 98166 | 2020-04-29 | Autauga | Alabama | 1001 | 43 | 4 |
101016 | 101016 | 2020-04-30 | Autauga | Alabama | 1001 | 42 | 4 |
103871 | 103871 | 2020-05-01 | Autauga | Alabama | 1001 | 42 | 3 |
106736 | 106736 | 2020-05-02 | Autauga | Alabama | 1001 | 45 | 3 |
109605 | 109605 | 2020-05-03 | Autauga | Alabama | 1001 | 48 | 3 |
112480 | 112480 | 2020-05-04 | Autauga | Alabama | 1001 | 53 | 3 |
115363 | 115363 | 2020-05-05 | Autauga | Alabama | 1001 | 53 | 3 |
118322 | 118322 | 2020-05-06 | Autauga | Alabama | 1001 | 58 | 3 |
121288 | 121288 | 2020-05-07 | Autauga | Alabama | 1001 | 61 | 3 |
124268 | 124268 | 2020-05-08 | Autauga | Alabama | 1001 | 67 | 4 |
127253 | 127253 | 2020-05-09 | Autauga | Alabama | 1001 | 68 | 4 |
130243 | 130243 | 2020-05-10 | Autauga | Alabama | 1001 | 74 | 4 |
133233 | 133233 | 2020-05-11 | Autauga | Alabama | 1001 | 84 | 4 |
136223 | 136223 | 2020-05-12 | Autauga | Alabama | 1001 | 91 | 4 |
139214 | 139214 | 2020-05-13 | Autauga | Alabama | 1001 | 93 | 4 |
142210 | 142210 | 2020-05-14 | Autauga | Alabama | 1001 | 104 | 4 |
145209 | 145209 | 2020-05-15 | Autauga | Alabama | 1001 | 103 | 4 |
148212 | 148212 | 2020-05-16 | Autauga | Alabama | 1001 | 110 | 4 |
151221 | 151221 | 2020-05-17 | Autauga | Alabama | 1001 | 110 | 4 |
154233 | 154233 | 2020-05-18 | Autauga | Alabama | 1001 | 120 | 4 |
157249 | 157249 | 2020-05-19 | Autauga | Alabama | 1001 | 127 | 4 |
160273 | 160273 | 2020-05-20 | Autauga | Alabama | 1001 | 136 | 3 |
163301 | 163301 | 2020-05-21 | Autauga | Alabama | 1001 | 147 | 3 |
166333 | 166333 | 2020-05-22 | Autauga | Alabama | 1001 | 149 | 3 |
169369 | 169369 | 2020-05-23 | Autauga | Alabama | 1001 | 155 | 3 |
172410 | 172410 | 2020-05-24 | Autauga | Alabama | 1001 | 159 | 3 |
175453 | 175453 | 2020-05-25 | Autauga | Alabama | 1001 | 168 | 3 |
178498 | 178498 | 2020-05-26 | Autauga | Alabama | 1001 | 189 | 3 |
181542 | 181542 | 2020-05-27 | Autauga | Alabama | 1001 | 192 | 3 |
184594 | 184594 | 2020-05-28 | Autauga | Alabama | 1001 | 205 | 3 |
187651 | 187651 | 2020-05-29 | Autauga | Alabama | 1001 | 212 | 3 |
190715 | 190715 | 2020-05-30 | Autauga | Alabama | 1001 | 216 | 4 |
193781 | 193781 | 2020-05-31 | Autauga | Alabama | 1001 | 221 | 4 |
196851 | 196851 | 2020-06-01 | Autauga | Alabama | 1001 | 234 | 5 |
199924 | 199924 | 2020-06-02 | Autauga | Alabama | 1001 | 240 | 5 |
203000 | 203000 | 2020-06-03 | Autauga | Alabama | 1001 | 240 | 5 |
206079 | 206079 | 2020-06-04 | Autauga | Alabama | 1001 | 242 | 5 |
209161 | 209161 | 2020-06-05 | Autauga | Alabama | 1001 | 249 | 5 |
212246 | 212246 | 2020-06-06 | Autauga | Alabama | 1001 | 260 | 5 |
215333 | 215333 | 2020-06-07 | Autauga | Alabama | 1001 | 266 | 5 |
218423 | 218423 | 2020-06-08 | Autauga | Alabama | 1001 | 273 | 5 |
221515 | 221515 | 2020-06-09 | Autauga | Alabama | 1001 | 283 | 5 |
224611 | 224611 | 2020-06-10 | Autauga | Alabama | 1001 | 296 | 6 |
227712 | 227712 | 2020-06-11 | Autauga | Alabama | 1001 | 316 | 6 |
230816 | 230816 | 2020-06-12 | Autauga | Alabama | 1001 | 327 | 6 |
233921 | 233921 | 2020-06-13 | Autauga | Alabama | 1001 | 335 | 6 |
237028 | 237028 | 2020-06-14 | Autauga | Alabama | 1001 | 361 | 6 |
240136 | 240136 | 2020-06-15 | Autauga | Alabama | 1001 | 368 | 6 |
243247 | 243247 | 2020-06-16 | Autauga | Alabama | 1001 | 373 | 7 |
246360 | 246360 | 2020-06-17 | Autauga | Alabama | 1001 | 375 | 7 |
249472 | 249472 | 2020-06-18 | Autauga | Alabama | 1001 | 400 | 8 |
252587 | 252587 | 2020-06-19 | Autauga | Alabama | 1001 | 411 | 8 |
255706 | 255706 | 2020-06-20 | Autauga | Alabama | 1001 | 431 | 9 |
258833 | 258833 | 2020-06-21 | Autauga | Alabama | 1001 | 434 | 9 |
261960 | 261960 | 2020-06-22 | Autauga | Alabama | 1001 | 442 | 9 |
265089 | 265089 | 2020-06-23 | Autauga | Alabama | 1001 | 453 | 9 |
268218 | 268218 | 2020-06-24 | Autauga | Alabama | 1001 | 469 | 11 |
271352 | 271352 | 2020-06-25 | Autauga | Alabama | 1001 | 479 | 11 |
274492 | 274492 | 2020-06-26 | Autauga | Alabama | 1001 | 488 | 11 |
277640 | 277640 | 2020-06-27 | Autauga | Alabama | 1001 | 498 | 12 |
280788 | 280788 | 2020-06-28 | Autauga | Alabama | 1001 | 503 | 12 |
283934 | 283934 | 2020-06-29 | Autauga | Alabama | 1001 | 527 | 12 |
287080 | 287080 | 2020-06-30 | Autauga | Alabama | 1001 | 537 | 12 |
290230 | 290230 | 2020-07-01 | Autauga | Alabama | 1001 | 553 | 12 |
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);