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-16 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1819863 | 1819863 | 2021-10-16 | Autauga | Alabama | 1001 | 9893 | 146 |
1819864 | 1819864 | 2021-10-16 | Baldwin | Alabama | 1003 | 37069 | 540 |
1819865 | 1819865 | 2021-10-16 | Barbour | Alabama | 1005 | 3554 | 75 |
1819866 | 1819866 | 2021-10-16 | Bibb | Alabama | 1007 | 4216 | 86 |
1819867 | 1819867 | 2021-10-16 | Blount | Alabama | 1009 | 10094 | 174 |
1819868 | 1819868 | 2021-10-16 | Bullock | Alabama | 1011 | 1517 | 44 |
1819869 | 1819869 | 2021-10-16 | Butler | Alabama | 1013 | 3247 | 94 |
1819870 | 1819870 | 2021-10-16 | Calhoun | Alabama | 1015 | 22142 | 470 |
1819871 | 1819871 | 2021-10-16 | Chambers | Alabama | 1017 | 5559 | 142 |
1819872 | 1819872 | 2021-10-16 | Cherokee | Alabama | 1019 | 2999 | 57 |
1819873 | 1819873 | 2021-10-16 | Chilton | Alabama | 1021 | 6587 | 160 |
1819874 | 1819874 | 2021-10-16 | Choctaw | Alabama | 1023 | 869 | 27 |
1819875 | 1819875 | 2021-10-16 | Clarke | Alabama | 1025 | 4727 | 82 |
1819876 | 1819876 | 2021-10-16 | Clay | Alabama | 1027 | 2403 | 67 |
1819877 | 1819877 | 2021-10-16 | Cleburne | Alabama | 1029 | 2469 | 58 |
1819878 | 1819878 | 2021-10-16 | Coffee | Alabama | 1031 | 9182 | 189 |
1819879 | 1819879 | 2021-10-16 | Colbert | Alabama | 1033 | 8789 | 200 |
1819880 | 1819880 | 2021-10-16 | Conecuh | Alabama | 1035 | 1856 | 52 |
1819881 | 1819881 | 2021-10-16 | Coosa | Alabama | 1037 | 1785 | 38 |
1819882 | 1819882 | 2021-10-16 | Covington | Alabama | 1039 | 6682 | 179 |
1819883 | 1819883 | 2021-10-16 | Crenshaw | Alabama | 1041 | 2435 | 75 |
1819884 | 1819884 | 2021-10-16 | Cullman | Alabama | 1043 | 15306 | 290 |
1819885 | 1819885 | 2021-10-16 | Dale | Alabama | 1045 | 8859 | 181 |
1819886 | 1819886 | 2021-10-16 | Dallas | Alabama | 1047 | 4882 | 199 |
1819887 | 1819887 | 2021-10-16 | DeKalb | Alabama | 1049 | 12569 | 259 |
1819888 | 1819888 | 2021-10-16 | Elmore | Alabama | 1051 | 15075 | 284 |
1819889 | 1819889 | 2021-10-16 | Escambia | Alabama | 1053 | 6732 | 127 |
1819890 | 1819890 | 2021-10-16 | Etowah | Alabama | 1055 | 19758 | 496 |
1819891 | 1819891 | 2021-10-16 | Fayette | Alabama | 1057 | 2906 | 79 |
1819892 | 1819892 | 2021-10-16 | Franklin | Alabama | 1059 | 5930 | 105 |
1819893 | 1819893 | 2021-10-16 | Geneva | Alabama | 1061 | 4564 | 126 |
1819894 | 1819894 | 2021-10-16 | Greene | Alabama | 1063 | 1255 | 44 |
1819895 | 1819895 | 2021-10-16 | Hale | Alabama | 1065 | 3091 | 87 |
1819896 | 1819896 | 2021-10-16 | Henry | Alabama | 1067 | 3109 | 65 |
1819897 | 1819897 | 2021-10-16 | Houston | Alabama | 1069 | 17302 | 405 |
1819898 | 1819898 | 2021-10-16 | Jackson | Alabama | 1071 | 9789 | 180 |
1819899 | 1819899 | 2021-10-16 | Jefferson | Alabama | 1073 | 113997 | 1910 |
1819900 | 1819900 | 2021-10-16 | Lamar | Alabama | 1075 | 2158 | 46 |
1819901 | 1819901 | 2021-10-16 | Lauderdale | Alabama | 1077 | 14143 | 294 |
1819902 | 1819902 | 2021-10-16 | Lawrence | Alabama | 1079 | 4264 | 117 |
1819903 | 1819903 | 2021-10-16 | Lee | Alabama | 1081 | 23142 | 240 |
1819904 | 1819904 | 2021-10-16 | Limestone | Alabama | 1083 | 15202 | 198 |
1819905 | 1819905 | 2021-10-16 | Lowndes | Alabama | 1085 | 1737 | 61 |
1819906 | 1819906 | 2021-10-16 | Macon | Alabama | 1087 | 2305 | 62 |
1819907 | 1819907 | 2021-10-16 | Madison | Alabama | 1089 | 51970 | 686 |
1819908 | 1819908 | 2021-10-16 | Marengo | Alabama | 1091 | 3340 | 89 |
1819909 | 1819909 | 2021-10-16 | Marion | Alabama | 1093 | 4955 | 126 |
1819910 | 1819910 | 2021-10-16 | Marshall | Alabama | 1095 | 18245 | 300 |
1819911 | 1819911 | 2021-10-16 | Mobile | Alabama | 1097 | 72227 | 1323 |
1819912 | 1819912 | 2021-10-16 | Monroe | Alabama | 1099 | 3302 | 62 |
1819913 | 1819913 | 2021-10-16 | Montgomery | Alabama | 1101 | 33953 | 725 |
1819914 | 1819914 | 2021-10-16 | Morgan | Alabama | 1103 | 20639 | 372 |
1819915 | 1819915 | 2021-10-16 | Perry | Alabama | 1105 | 1380 | 40 |
1819916 | 1819916 | 2021-10-16 | Pickens | Alabama | 1107 | 3138 | 82 |
1819917 | 1819917 | 2021-10-16 | Pike | Alabama | 1109 | 4719 | 105 |
1819918 | 1819918 | 2021-10-16 | Randolph | Alabama | 1111 | 3270 | 63 |
1819919 | 1819919 | 2021-10-16 | Russell | Alabama | 1113 | 6259 | 58 |
1819920 | 1819920 | 2021-10-16 | Shelby | Alabama | 1117 | 37279 | 341 |
1819921 | 1819921 | 2021-10-16 | St. Clair | Alabama | 1115 | 15912 | 337 |
1819922 | 1819922 | 2021-10-16 | Sumter | Alabama | 1119 | 1310 | 38 |
1819923 | 1819923 | 2021-10-16 | Talladega | Alabama | 1121 | 13715 | 272 |
1819924 | 1819924 | 2021-10-16 | Tallapoosa | Alabama | 1123 | 7044 | 195 |
1819925 | 1819925 | 2021-10-16 | Tuscaloosa | Alabama | 1125 | 34934 | 599 |
1819926 | 1819926 | 2021-10-16 | Walker | Alabama | 1127 | 11085 | 366 |
1819927 | 1819927 | 2021-10-16 | Washington | Alabama | 1129 | 2509 | 51 |
1819928 | 1819928 | 2021-10-16 | Wilcox | Alabama | 1131 | 1674 | 38 |
1819929 | 1819929 | 2021-10-16 | Winston | Alabama | 1133 | 4473 | 101 |
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);