ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-09-10" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1702905 | 1702905 | 2021-09-10 | Autauga | Alabama | 1001 | 9207 | 119 |
1702906 | 1702906 | 2021-09-10 | Baldwin | Alabama | 1003 | 34726 | 411 |
1702907 | 1702907 | 2021-09-10 | Barbour | Alabama | 1005 | 3260 | 67 |
1702908 | 1702908 | 2021-09-10 | Bibb | Alabama | 1007 | 3752 | 74 |
1702909 | 1702909 | 2021-09-10 | Blount | Alabama | 1009 | 9095 | 146 |
1702910 | 1702910 | 2021-09-10 | Bullock | Alabama | 1011 | 1435 | 42 |
1702911 | 1702911 | 2021-09-10 | Butler | Alabama | 1013 | 2979 | 76 |
1702912 | 1702912 | 2021-09-10 | Calhoun | Alabama | 1015 | 19049 | 357 |
1702913 | 1702913 | 2021-09-10 | Chambers | Alabama | 1017 | 5019 | 127 |
1702914 | 1702914 | 2021-09-10 | Cherokee | Alabama | 1019 | 2673 | 49 |
1702915 | 1702915 | 2021-09-10 | Chilton | Alabama | 1021 | 6003 | 127 |
1702916 | 1702916 | 2021-09-10 | Choctaw | Alabama | 1023 | 710 | 25 |
1702917 | 1702917 | 2021-09-10 | Clarke | Alabama | 1025 | 4396 | 68 |
1702918 | 1702918 | 2021-09-10 | Clay | Alabama | 1027 | 2129 | 60 |
1702919 | 1702919 | 2021-09-10 | Cleburne | Alabama | 1029 | 2014 | 46 |
1702920 | 1702920 | 2021-09-10 | Coffee | Alabama | 1031 | 8372 | 149 |
1702921 | 1702921 | 2021-09-10 | Colbert | Alabama | 1033 | 8067 | 158 |
1702922 | 1702922 | 2021-09-10 | Conecuh | Alabama | 1035 | 1673 | 36 |
1702923 | 1702923 | 2021-09-10 | Coosa | Alabama | 1037 | 1540 | 31 |
1702924 | 1702924 | 2021-09-10 | Covington | Alabama | 1039 | 6066 | 153 |
1702925 | 1702925 | 2021-09-10 | Crenshaw | Alabama | 1041 | 2219 | 62 |
1702926 | 1702926 | 2021-09-10 | Cullman | Alabama | 1043 | 13324 | 225 |
1702927 | 1702927 | 2021-09-10 | Dale | Alabama | 1045 | 7971 | 140 |
1702928 | 1702928 | 2021-09-10 | Dallas | Alabama | 1047 | 4489 | 172 |
1702929 | 1702929 | 2021-09-10 | DeKalb | Alabama | 1049 | 11465 | 214 |
1702930 | 1702930 | 2021-09-10 | Elmore | Alabama | 1051 | 13543 | 238 |
1702931 | 1702931 | 2021-09-10 | Escambia | Alabama | 1053 | 6106 | 96 |
1702932 | 1702932 | 2021-09-10 | Etowah | Alabama | 1055 | 18039 | 407 |
1702933 | 1702933 | 2021-09-10 | Fayette | Alabama | 1057 | 2612 | 67 |
1702934 | 1702934 | 2021-09-10 | Franklin | Alabama | 1059 | 5505 | 91 |
1702935 | 1702935 | 2021-09-10 | Geneva | Alabama | 1061 | 4023 | 97 |
1702936 | 1702936 | 2021-09-10 | Greene | Alabama | 1063 | 1171 | 40 |
1702937 | 1702937 | 2021-09-10 | Hale | Alabama | 1065 | 2788 | 81 |
1702938 | 1702938 | 2021-09-10 | Henry | Alabama | 1067 | 2811 | 48 |
1702939 | 1702939 | 2021-09-10 | Houston | Alabama | 1069 | 15571 | 328 |
1702940 | 1702940 | 2021-09-10 | Jackson | Alabama | 1071 | 8710 | 131 |
1702941 | 1702941 | 2021-09-10 | Jefferson | Alabama | 1073 | 106362 | 1687 |
1702942 | 1702942 | 2021-09-10 | Lamar | Alabama | 1075 | 1797 | 38 |
1702943 | 1702943 | 2021-09-10 | Lauderdale | Alabama | 1077 | 12597 | 262 |
1702944 | 1702944 | 2021-09-10 | Lawrence | Alabama | 1079 | 3949 | 101 |
1702945 | 1702945 | 2021-09-10 | Lee | Alabama | 1081 | 21132 | 198 |
1702946 | 1702946 | 2021-09-10 | Limestone | Alabama | 1083 | 13460 | 175 |
1702947 | 1702947 | 2021-09-10 | Lowndes | Alabama | 1085 | 1653 | 55 |
1702948 | 1702948 | 2021-09-10 | Macon | Alabama | 1087 | 2059 | 54 |
1702949 | 1702949 | 2021-09-10 | Madison | Alabama | 1089 | 46513 | 559 |
1702950 | 1702950 | 2021-09-10 | Marengo | Alabama | 1091 | 3128 | 76 |
1702951 | 1702951 | 2021-09-10 | Marion | Alabama | 1093 | 4365 | 112 |
1702952 | 1702952 | 2021-09-10 | Marshall | Alabama | 1095 | 16636 | 251 |
1702953 | 1702953 | 2021-09-10 | Mobile | Alabama | 1097 | 68382 | 1114 |
1702954 | 1702954 | 2021-09-10 | Monroe | Alabama | 1099 | 2983 | 44 |
1702955 | 1702955 | 2021-09-10 | Montgomery | Alabama | 1101 | 31706 | 642 |
1702956 | 1702956 | 2021-09-10 | Morgan | Alabama | 1103 | 18599 | 306 |
1702957 | 1702957 | 2021-09-10 | Perry | Alabama | 1105 | 1308 | 30 |
1702958 | 1702958 | 2021-09-10 | Pickens | Alabama | 1107 | 2905 | 64 |
1702959 | 1702959 | 2021-09-10 | Pike | Alabama | 1109 | 4257 | 87 |
1702960 | 1702960 | 2021-09-10 | Randolph | Alabama | 1111 | 2788 | 54 |
1702961 | 1702961 | 2021-09-10 | Russell | Alabama | 1113 | 5746 | 51 |
1702962 | 1702962 | 2021-09-10 | Shelby | Alabama | 1117 | 34013 | 280 |
1702963 | 1702963 | 2021-09-10 | St. Clair | Alabama | 1115 | 14295 | 266 |
1702964 | 1702964 | 2021-09-10 | Sumter | Alabama | 1119 | 1208 | 35 |
1702965 | 1702965 | 2021-09-10 | Talladega | Alabama | 1121 | 11647 | 196 |
1702966 | 1702966 | 2021-09-10 | Tallapoosa | Alabama | 1123 | 6035 | 163 |
1702967 | 1702967 | 2021-09-10 | Tuscaloosa | Alabama | 1125 | 31795 | 491 |
1702968 | 1702968 | 2021-09-10 | Walker | Alabama | 1127 | 9723 | 300 |
1702969 | 1702969 | 2021-09-10 | Washington | Alabama | 1129 | 2377 | 43 |
1702970 | 1702970 | 2021-09-10 | Wilcox | Alabama | 1131 | 1504 | 33 |
1702971 | 1702971 | 2021-09-10 | Winston | Alabama | 1133 | 3884 | 80 |
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);