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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
date (date) >30 ✖
- 2020-04-12 67
- 2020-04-13 67
- 2020-04-14 67
- 2020-04-15 67
- 2020-04-16 67
- 2020-04-17 67
- 2020-04-18 67
- 2020-04-19 67
- 2020-04-20 67
- 2020-04-21 67
- 2020-04-22 67
- 2020-04-23 67
- 2020-04-24 67
- 2020-04-25 67
- 2020-04-26 67
- 2020-04-27 67
- 2020-04-28 67
- 2020-04-29 67
- 2020-04-30 67
- 2020-05-01 67
- 2020-05-02 67
- 2020-05-03 67
- 2020-05-04 67
- 2020-05-05 67
- 2020-05-06 67
- 2020-05-07 67
- 2020-05-08 67
- 2020-05-09 67
- 2020-05-10 67
- 2020-05-11 67
- …
county >30
- 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
- …
state 1
- Alabama · 52,312 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1620 | 1620 | 2020-03-13 | Elmore | Alabama | 1051 | 1 | 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 |
1938 | 1938 | 2020-03-14 | Limestone | Alabama | 1083 | 1 | 0 |
1939 | 1939 | 2020-03-14 | Montgomery | Alabama | 1101 | 1 | 0 |
2310 | 2310 | 2020-03-15 | Baldwin | Alabama | 1003 | 1 | 0 |
2311 | 2311 | 2020-03-15 | Elmore | Alabama | 1051 | 1 | 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 |
2739 | 2739 | 2020-03-16 | Baldwin | Alabama | 1003 | 1 | 0 |
2740 | 2740 | 2020-03-16 | Elmore | Alabama | 1051 | 1 | 0 |
2742 | 2742 | 2020-03-16 | Lee | Alabama | 1081 | 1 | 0 |
2743 | 2743 | 2020-03-16 | Limestone | Alabama | 1083 | 1 | 0 |
3215 | 3215 | 2020-03-17 | Baldwin | Alabama | 1003 | 1 | 0 |
3219 | 3219 | 2020-03-17 | Limestone | Alabama | 1083 | 1 | 0 |
3220 | 3220 | 2020-03-17 | Madison | Alabama | 1089 | 1 | 0 |
3223 | 3223 | 2020-03-17 | St. Clair | Alabama | 1115 | 1 | 0 |
3761 | 3761 | 2020-03-18 | Baldwin | Alabama | 1003 | 1 | 0 |
3762 | 3762 | 2020-03-18 | Calhoun | Alabama | 1015 | 1 | 0 |
3766 | 3766 | 2020-03-18 | Limestone | Alabama | 1083 | 1 | 0 |
3767 | 3767 | 2020-03-18 | Madison | Alabama | 1089 | 1 | 0 |
3770 | 3770 | 2020-03-18 | St. Clair | Alabama | 1115 | 1 | 0 |
3771 | 3771 | 2020-03-18 | Talladega | Alabama | 1121 | 1 | 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 |
4407 | 4407 | 2020-03-19 | Limestone | Alabama | 1083 | 1 | 0 |
4409 | 4409 | 2020-03-19 | Mobile | Alabama | 1097 | 1 | 0 |
4412 | 4412 | 2020-03-19 | St. Clair | Alabama | 1115 | 1 | 0 |
4413 | 4413 | 2020-03-19 | Talladega | Alabama | 1121 | 1 | 0 |
4415 | 4415 | 2020-03-19 | Walker | Alabama | 1127 | 1 | 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 |
5172 | 5172 | 2020-03-20 | Jackson | Alabama | 1071 | 1 | 0 |
5174 | 5174 | 2020-03-20 | Lamar | Alabama | 1075 | 1 | 0 |
5175 | 5175 | 2020-03-20 | Lauderdale | Alabama | 1077 | 1 | 0 |
5177 | 5177 | 2020-03-20 | Limestone | Alabama | 1083 | 1 | 0 |
5182 | 5182 | 2020-03-20 | St. Clair | Alabama | 1115 | 1 | 0 |
5183 | 5183 | 2020-03-20 | Talladega | Alabama | 1121 | 1 | 0 |
5185 | 5185 | 2020-03-20 | Walker | Alabama | 1127 | 1 | 0 |
5186 | 5186 | 2020-03-20 | Washington | Alabama | 1129 | 1 | 0 |
6084 | 6084 | 2020-03-21 | Calhoun | Alabama | 1015 | 1 | 0 |
6085 | 6085 | 2020-03-21 | Chambers | Alabama | 1017 | 1 | 0 |
6088 | 6088 | 2020-03-21 | Jackson | Alabama | 1071 | 1 | 0 |
6090 | 6090 | 2020-03-21 | Lamar | Alabama | 1075 | 1 | 0 |
6093 | 6093 | 2020-03-21 | Limestone | Alabama | 1083 | 1 | 0 |
6095 | 6095 | 2020-03-21 | Marion | Alabama | 1093 | 1 | 0 |
6099 | 6099 | 2020-03-21 | St. Clair | Alabama | 1115 | 1 | 0 |
6100 | 6100 | 2020-03-21 | Talladega | Alabama | 1121 | 1 | 0 |
6102 | 6102 | 2020-03-21 | Walker | Alabama | 1127 | 1 | 0 |
6103 | 6103 | 2020-03-21 | Washington | Alabama | 1129 | 1 | 0 |
7118 | 7118 | 2020-03-22 | Calhoun | Alabama | 1015 | 1 | 0 |
7122 | 7122 | 2020-03-22 | Jackson | Alabama | 1071 | 1 | 0 |
7124 | 7124 | 2020-03-22 | Lamar | Alabama | 1075 | 1 | 0 |
7127 | 7127 | 2020-03-22 | Limestone | Alabama | 1083 | 1 | 0 |
7129 | 7129 | 2020-03-22 | Marion | Alabama | 1093 | 1 | 0 |
7134 | 7134 | 2020-03-22 | Talladega | Alabama | 1121 | 1 | 0 |
7136 | 7136 | 2020-03-22 | Walker | Alabama | 1127 | 1 | 0 |
7137 | 7137 | 2020-03-22 | Washington | Alabama | 1129 | 1 | 0 |
8260 | 8260 | 2020-03-23 | Franklin | Alabama | 1059 | 1 | 0 |
8261 | 8261 | 2020-03-23 | Houston | Alabama | 1069 | 1 | 0 |
8262 | 8262 | 2020-03-23 | Jackson | Alabama | 1071 | 1 | 0 |
8264 | 8264 | 2020-03-23 | Lamar | Alabama | 1075 | 1 | 0 |
8267 | 8267 | 2020-03-23 | Limestone | Alabama | 1083 | 1 | 0 |
8269 | 8269 | 2020-03-23 | Marion | Alabama | 1093 | 1 | 0 |
8274 | 8274 | 2020-03-23 | Talladega | Alabama | 1121 | 1 | 0 |
8275 | 8275 | 2020-03-23 | Tallapoosa | Alabama | 1123 | 1 | 0 |
8278 | 8278 | 2020-03-23 | Washington | Alabama | 1129 | 1 | 0 |
9481 | 9481 | 2020-03-24 | Autauga | Alabama | 1001 | 1 | 0 |
9487 | 9487 | 2020-03-24 | Franklin | Alabama | 1059 | 1 | 0 |
9488 | 9488 | 2020-03-24 | Houston | Alabama | 1069 | 1 | 0 |
9491 | 9491 | 2020-03-24 | Lamar | Alabama | 1075 | 1 | 0 |
9496 | 9496 | 2020-03-24 | Marion | Alabama | 1093 | 1 | 0 |
9506 | 9506 | 2020-03-24 | Washington | Alabama | 1129 | 1 | 0 |
10838 | 10838 | 2020-03-25 | Blount | Alabama | 1009 | 1 | 0 |
10839 | 10839 | 2020-03-25 | Butler | Alabama | 1013 | 1 | 0 |
10842 | 10842 | 2020-03-25 | Cherokee | Alabama | 1019 | 1 | 0 |
10843 | 10843 | 2020-03-25 | Chilton | Alabama | 1021 | 1 | 0 |
10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
10845 | 10845 | 2020-03-25 | Cleburne | Alabama | 1029 | 1 | 0 |
10846 | 10846 | 2020-03-25 | Colbert | Alabama | 1033 | 1 | 0 |
10855 | 10855 | 2020-03-25 | Lamar | Alabama | 1075 | 1 | 0 |
10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
10862 | 10862 | 2020-03-25 | Marshall | Alabama | 1095 | 1 | 0 |
10866 | 10866 | 2020-03-25 | Pickens | Alabama | 1107 | 1 | 0 |
10867 | 10867 | 2020-03-25 | Pike | Alabama | 1109 | 1 | 0 |
10868 | 10868 | 2020-03-25 | Russell | Alabama | 1113 | 1 | 0 |
10875 | 10875 | 2020-03-25 | Washington | Alabama | 1129 | 1 | 0 |
10876 | 10876 | 2020-03-25 | Wilcox | Alabama | 1131 | 1 | 0 |
12372 | 12372 | 2020-03-26 | Butler | Alabama | 1013 | 1 | 0 |
12375 | 12375 | 2020-03-26 | Cherokee | Alabama | 1019 | 1 | 0 |
12377 | 12377 | 2020-03-26 | Choctaw | Alabama | 1023 | 1 | 0 |
12378 | 12378 | 2020-03-26 | Clay | Alabama | 1027 | 1 | 0 |
12379 | 12379 | 2020-03-26 | Cleburne | Alabama | 1029 | 1 | 0 |
12380 | 12380 | 2020-03-26 | Colbert | Alabama | 1033 | 1 | 0 |
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);