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-06-01 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1374939 | 1374939 | 2021-06-01 | Autauga | Alabama | 1001 | 7150 | 111 |
1374940 | 1374940 | 2021-06-01 | Baldwin | Alabama | 1003 | 21661 | 311 |
1374941 | 1374941 | 2021-06-01 | Barbour | Alabama | 1005 | 2337 | 59 |
1374942 | 1374942 | 2021-06-01 | Bibb | Alabama | 1007 | 2665 | 64 |
1374943 | 1374943 | 2021-06-01 | Blount | Alabama | 1009 | 6887 | 139 |
1374944 | 1374944 | 2021-06-01 | Bullock | Alabama | 1011 | 1233 | 42 |
1374945 | 1374945 | 2021-06-01 | Butler | Alabama | 1013 | 2220 | 71 |
1374946 | 1374946 | 2021-06-01 | Calhoun | Alabama | 1015 | 14637 | 324 |
1374947 | 1374947 | 2021-06-01 | Chambers | Alabama | 1017 | 3671 | 123 |
1374948 | 1374948 | 2021-06-01 | Cherokee | Alabama | 1019 | 1864 | 45 |
1374949 | 1374949 | 2021-06-01 | Chilton | Alabama | 1021 | 4437 | 115 |
1374950 | 1374950 | 2021-06-01 | Choctaw | Alabama | 1023 | 613 | 25 |
1374951 | 1374951 | 2021-06-01 | Clarke | Alabama | 1025 | 3526 | 61 |
1374952 | 1374952 | 2021-06-01 | Clay | Alabama | 1027 | 1581 | 57 |
1374953 | 1374953 | 2021-06-01 | Cleburne | Alabama | 1029 | 1506 | 43 |
1374954 | 1374954 | 2021-06-01 | Coffee | Alabama | 1031 | 5609 | 121 |
1374955 | 1374955 | 2021-06-01 | Colbert | Alabama | 1033 | 6349 | 138 |
1374956 | 1374956 | 2021-06-01 | Conecuh | Alabama | 1035 | 1122 | 30 |
1374957 | 1374957 | 2021-06-01 | Coosa | Alabama | 1037 | 1100 | 29 |
1374958 | 1374958 | 2021-06-01 | Covington | Alabama | 1039 | 4218 | 119 |
1374959 | 1374959 | 2021-06-01 | Crenshaw | Alabama | 1041 | 1542 | 57 |
1374960 | 1374960 | 2021-06-01 | Cullman | Alabama | 1043 | 9857 | 199 |
1374961 | 1374961 | 2021-06-01 | Dale | Alabama | 1045 | 4905 | 114 |
1374962 | 1374962 | 2021-06-01 | Dallas | Alabama | 1047 | 3599 | 154 |
1374963 | 1374963 | 2021-06-01 | DeKalb | Alabama | 1049 | 8908 | 188 |
1374964 | 1374964 | 2021-06-01 | Elmore | Alabama | 1051 | 10241 | 208 |
1374965 | 1374965 | 2021-06-01 | Escambia | Alabama | 1053 | 3977 | 77 |
1374966 | 1374966 | 2021-06-01 | Etowah | Alabama | 1055 | 14013 | 359 |
1374967 | 1374967 | 2021-06-01 | Fayette | Alabama | 1057 | 2150 | 62 |
1374968 | 1374968 | 2021-06-01 | Franklin | Alabama | 1059 | 4278 | 82 |
1374969 | 1374969 | 2021-06-01 | Geneva | Alabama | 1061 | 2561 | 81 |
1374970 | 1374970 | 2021-06-01 | Greene | Alabama | 1063 | 930 | 34 |
1374971 | 1374971 | 2021-06-01 | Hale | Alabama | 1065 | 2254 | 78 |
1374972 | 1374972 | 2021-06-01 | Henry | Alabama | 1067 | 1935 | 43 |
1374973 | 1374973 | 2021-06-01 | Houston | Alabama | 1069 | 10721 | 285 |
1374974 | 1374974 | 2021-06-01 | Jackson | Alabama | 1071 | 6870 | 112 |
1374975 | 1374975 | 2021-06-01 | Jefferson | Alabama | 1073 | 80260 | 1540 |
1374976 | 1374976 | 2021-06-01 | Lamar | Alabama | 1075 | 1452 | 37 |
1374977 | 1374977 | 2021-06-01 | Lauderdale | Alabama | 1077 | 9520 | 245 |
1374978 | 1374978 | 2021-06-01 | Lawrence | Alabama | 1079 | 3081 | 100 |
1374979 | 1374979 | 2021-06-01 | Lee | Alabama | 1081 | 16135 | 173 |
1374980 | 1374980 | 2021-06-01 | Limestone | Alabama | 1083 | 10126 | 156 |
1374981 | 1374981 | 2021-06-01 | Lowndes | Alabama | 1085 | 1412 | 54 |
1374982 | 1374982 | 2021-06-01 | Macon | Alabama | 1087 | 1623 | 50 |
1374983 | 1374983 | 2021-06-01 | Madison | Alabama | 1089 | 35369 | 514 |
1374984 | 1374984 | 2021-06-01 | Marengo | Alabama | 1091 | 2503 | 65 |
1374985 | 1374985 | 2021-06-01 | Marion | Alabama | 1093 | 3188 | 102 |
1374986 | 1374986 | 2021-06-01 | Marshall | Alabama | 1095 | 12348 | 228 |
1374987 | 1374987 | 2021-06-01 | Mobile | Alabama | 1097 | 41590 | 817 |
1374988 | 1374988 | 2021-06-01 | Monroe | Alabama | 1099 | 1790 | 41 |
1374989 | 1374989 | 2021-06-01 | Montgomery | Alabama | 1101 | 24896 | 600 |
1374990 | 1374990 | 2021-06-01 | Morgan | Alabama | 1103 | 14529 | 283 |
1374991 | 1374991 | 2021-06-01 | Perry | Alabama | 1105 | 1083 | 26 |
1374992 | 1374992 | 2021-06-01 | Pickens | Alabama | 1107 | 2358 | 62 |
1374993 | 1374993 | 2021-06-01 | Pike | Alabama | 1109 | 3134 | 77 |
1374994 | 1374994 | 2021-06-01 | Randolph | Alabama | 1111 | 1848 | 43 |
1374995 | 1374995 | 2021-06-01 | Russell | Alabama | 1113 | 4514 | 40 |
1374996 | 1374996 | 2021-06-01 | Shelby | Alabama | 1117 | 25437 | 253 |
1374997 | 1374997 | 2021-06-01 | St. Clair | Alabama | 1115 | 10084 | 247 |
1374998 | 1374998 | 2021-06-01 | Sumter | Alabama | 1119 | 1056 | 32 |
1374999 | 1374999 | 2021-06-01 | Talladega | Alabama | 1121 | 8387 | 181 |
1375000 | 1375000 | 2021-06-01 | Tallapoosa | Alabama | 1123 | 4078 | 153 |
1375001 | 1375001 | 2021-06-01 | Tuscaloosa | Alabama | 1125 | 26067 | 457 |
1375002 | 1375002 | 2021-06-01 | Walker | Alabama | 1127 | 7296 | 278 |
1375003 | 1375003 | 2021-06-01 | Washington | Alabama | 1129 | 1689 | 39 |
1375004 | 1375004 | 2021-06-01 | Wilcox | Alabama | 1131 | 1272 | 30 |
1375005 | 1375005 | 2021-06-01 | Winston | Alabama | 1133 | 2793 | 73 |
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);