ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2021-10-08 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793870 | 1793870 | 2021-10-08 | Autauga | Alabama | 1001 | 9839 | 144 |
1793871 | 1793871 | 2021-10-08 | Baldwin | Alabama | 1003 | 36814 | 530 |
1793872 | 1793872 | 2021-10-08 | Barbour | Alabama | 1005 | 3541 | 73 |
1793873 | 1793873 | 2021-10-08 | Bibb | Alabama | 1007 | 4184 | 86 |
1793874 | 1793874 | 2021-10-08 | Blount | Alabama | 1009 | 9970 | 168 |
1793875 | 1793875 | 2021-10-08 | Bullock | Alabama | 1011 | 1511 | 44 |
1793876 | 1793876 | 2021-10-08 | Butler | Alabama | 1013 | 3227 | 93 |
1793877 | 1793877 | 2021-10-08 | Calhoun | Alabama | 1015 | 21924 | 444 |
1793878 | 1793878 | 2021-10-08 | Chambers | Alabama | 1017 | 5523 | 138 |
1793879 | 1793879 | 2021-10-08 | Cherokee | Alabama | 1019 | 2968 | 57 |
1793880 | 1793880 | 2021-10-08 | Chilton | Alabama | 1021 | 6529 | 151 |
1793881 | 1793881 | 2021-10-08 | Choctaw | Alabama | 1023 | 853 | 27 |
1793882 | 1793882 | 2021-10-08 | Clarke | Alabama | 1025 | 4710 | 80 |
1793883 | 1793883 | 2021-10-08 | Clay | Alabama | 1027 | 2367 | 67 |
1793884 | 1793884 | 2021-10-08 | Cleburne | Alabama | 1029 | 2445 | 56 |
1793885 | 1793885 | 2021-10-08 | Coffee | Alabama | 1031 | 9129 | 185 |
1793886 | 1793886 | 2021-10-08 | Colbert | Alabama | 1033 | 8707 | 195 |
1793887 | 1793887 | 2021-10-08 | Conecuh | Alabama | 1035 | 1840 | 50 |
1793888 | 1793888 | 2021-10-08 | Coosa | Alabama | 1037 | 1752 | 36 |
1793889 | 1793889 | 2021-10-08 | Covington | Alabama | 1039 | 6614 | 173 |
1793890 | 1793890 | 2021-10-08 | Crenshaw | Alabama | 1041 | 2418 | 75 |
1793891 | 1793891 | 2021-10-08 | Cullman | Alabama | 1043 | 15124 | 282 |
1793892 | 1793892 | 2021-10-08 | Dale | Alabama | 1045 | 8808 | 179 |
1793893 | 1793893 | 2021-10-08 | Dallas | Alabama | 1047 | 4799 | 193 |
1793894 | 1793894 | 2021-10-08 | DeKalb | Alabama | 1049 | 12451 | 252 |
1793895 | 1793895 | 2021-10-08 | Elmore | Alabama | 1051 | 14810 | 277 |
1793896 | 1793896 | 2021-10-08 | Escambia | Alabama | 1053 | 6676 | 127 |
1793897 | 1793897 | 2021-10-08 | Etowah | Alabama | 1055 | 19652 | 486 |
1793898 | 1793898 | 2021-10-08 | Fayette | Alabama | 1057 | 2853 | 76 |
1793899 | 1793899 | 2021-10-08 | Franklin | Alabama | 1059 | 5904 | 103 |
1793900 | 1793900 | 2021-10-08 | Geneva | Alabama | 1061 | 4542 | 123 |
1793901 | 1793901 | 2021-10-08 | Greene | Alabama | 1063 | 1240 | 44 |
1793902 | 1793902 | 2021-10-08 | Hale | Alabama | 1065 | 2960 | 86 |
1793903 | 1793903 | 2021-10-08 | Henry | Alabama | 1067 | 3082 | 63 |
1793904 | 1793904 | 2021-10-08 | Houston | Alabama | 1069 | 17146 | 394 |
1793905 | 1793905 | 2021-10-08 | Jackson | Alabama | 1071 | 9656 | 169 |
1793906 | 1793906 | 2021-10-08 | Jefferson | Alabama | 1073 | 113504 | 1861 |
1793907 | 1793907 | 2021-10-08 | Lamar | Alabama | 1075 | 2102 | 45 |
1793908 | 1793908 | 2021-10-08 | Lauderdale | Alabama | 1077 | 13923 | 288 |
1793909 | 1793909 | 2021-10-08 | Lawrence | Alabama | 1079 | 4212 | 110 |
1793910 | 1793910 | 2021-10-08 | Lee | Alabama | 1081 | 23008 | 228 |
1793911 | 1793911 | 2021-10-08 | Limestone | Alabama | 1083 | 15029 | 194 |
1793912 | 1793912 | 2021-10-08 | Lowndes | Alabama | 1085 | 1725 | 61 |
1793913 | 1793913 | 2021-10-08 | Macon | Alabama | 1087 | 2264 | 60 |
1793914 | 1793914 | 2021-10-08 | Madison | Alabama | 1089 | 51452 | 661 |
1793915 | 1793915 | 2021-10-08 | Marengo | Alabama | 1091 | 3307 | 89 |
1793916 | 1793916 | 2021-10-08 | Marion | Alabama | 1093 | 4906 | 126 |
1793917 | 1793917 | 2021-10-08 | Marshall | Alabama | 1095 | 18157 | 285 |
1793918 | 1793918 | 2021-10-08 | Mobile | Alabama | 1097 | 71737 | 1304 |
1793919 | 1793919 | 2021-10-08 | Monroe | Alabama | 1099 | 3257 | 59 |
1793920 | 1793920 | 2021-10-08 | Montgomery | Alabama | 1101 | 33721 | 702 |
1793921 | 1793921 | 2021-10-08 | Morgan | Alabama | 1103 | 20427 | 355 |
1793922 | 1793922 | 2021-10-08 | Perry | Alabama | 1105 | 1372 | 39 |
1793923 | 1793923 | 2021-10-08 | Pickens | Alabama | 1107 | 3118 | 77 |
1793924 | 1793924 | 2021-10-08 | Pike | Alabama | 1109 | 4685 | 103 |
1793925 | 1793925 | 2021-10-08 | Randolph | Alabama | 1111 | 3225 | 60 |
1793926 | 1793926 | 2021-10-08 | Russell | Alabama | 1113 | 6196 | 57 |
1793927 | 1793927 | 2021-10-08 | Shelby | Alabama | 1117 | 36998 | 328 |
1793928 | 1793928 | 2021-10-08 | St. Clair | Alabama | 1115 | 15799 | 332 |
1793929 | 1793929 | 2021-10-08 | Sumter | Alabama | 1119 | 1292 | 38 |
1793930 | 1793930 | 2021-10-08 | Talladega | Alabama | 1121 | 13491 | 259 |
1793931 | 1793931 | 2021-10-08 | Tallapoosa | Alabama | 1123 | 6930 | 194 |
1793932 | 1793932 | 2021-10-08 | Tuscaloosa | Alabama | 1125 | 34639 | 579 |
1793933 | 1793933 | 2021-10-08 | Walker | Alabama | 1127 | 10955 | 350 |
1793934 | 1793934 | 2021-10-08 | Washington | Alabama | 1129 | 2502 | 50 |
1793935 | 1793935 | 2021-10-08 | Wilcox | Alabama | 1131 | 1653 | 37 |
1793936 | 1793936 | 2021-10-08 | Winston | Alabama | 1133 | 4406 | 99 |
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);