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 2022-02-17 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2222983 | 2222983 | 2022-02-17 | Autauga | Alabama | 1001 | 15387 | 181 |
2222984 | 2222984 | 2022-02-17 | Baldwin | Alabama | 1003 | 54663 | 631 |
2222985 | 2222985 | 2022-02-17 | Barbour | Alabama | 1005 | 5422 | 91 |
2222986 | 2222986 | 2022-02-17 | Bibb | Alabama | 1007 | 6345 | 98 |
2222987 | 2222987 | 2022-02-17 | Blount | Alabama | 1009 | 14632 | 215 |
2222988 | 2222988 | 2022-02-17 | Bullock | Alabama | 1011 | 2271 | 49 |
2222989 | 2222989 | 2022-02-17 | Butler | Alabama | 1013 | 5011 | 114 |
2222990 | 2222990 | 2022-02-17 | Calhoun | Alabama | 1015 | 31302 | 574 |
2222991 | 2222991 | 2022-02-17 | Chambers | Alabama | 1017 | 8394 | 149 |
2222992 | 2222992 | 2022-02-17 | Cherokee | Alabama | 1019 | 5032 | 77 |
2222993 | 2222993 | 2022-02-17 | Chilton | Alabama | 1021 | 10409 | 186 |
2222994 | 2222994 | 2022-02-17 | Choctaw | Alabama | 1023 | 1990 | 34 |
2222995 | 2222995 | 2022-02-17 | Clarke | Alabama | 1025 | 6990 | 94 |
2222996 | 2222996 | 2022-02-17 | Clay | Alabama | 1027 | 4045 | 73 |
2222997 | 2222997 | 2022-02-17 | Cleburne | Alabama | 1029 | 3510 | 66 |
2222998 | 2222998 | 2022-02-17 | Coffee | Alabama | 1031 | 13249 | 215 |
2222999 | 2222999 | 2022-02-17 | Colbert | Alabama | 1033 | 16004 | 227 |
2223000 | 2223000 | 2022-02-17 | Conecuh | Alabama | 1035 | 2825 | 63 |
2223001 | 2223001 | 2022-02-17 | Coosa | Alabama | 1037 | 2883 | 53 |
2223002 | 2223002 | 2022-02-17 | Covington | Alabama | 1039 | 9199 | 213 |
2223003 | 2223003 | 2022-02-17 | Crenshaw | Alabama | 1041 | 3760 | 86 |
2223004 | 2223004 | 2022-02-17 | Cullman | Alabama | 1043 | 24162 | 338 |
2223005 | 2223005 | 2022-02-17 | Dale | Alabama | 1045 | 12359 | 213 |
2223006 | 2223006 | 2022-02-17 | Dallas | Alabama | 1047 | 8247 | 228 |
2223007 | 2223007 | 2022-02-17 | DeKalb | Alabama | 1049 | 18415 | 302 |
2223008 | 2223008 | 2022-02-17 | Elmore | Alabama | 1051 | 22754 | 320 |
2223009 | 2223009 | 2022-02-17 | Escambia | Alabama | 1053 | 9908 | 154 |
2223010 | 2223010 | 2022-02-17 | Etowah | Alabama | 1055 | 28534 | 570 |
2223011 | 2223011 | 2022-02-17 | Fayette | Alabama | 1057 | 4624 | 90 |
2223012 | 2223012 | 2022-02-17 | Franklin | Alabama | 1059 | 9739 | 126 |
2223013 | 2223013 | 2022-02-17 | Geneva | Alabama | 1061 | 6124 | 149 |
2223014 | 2223014 | 2022-02-17 | Greene | Alabama | 1063 | 1844 | 48 |
2223015 | 2223015 | 2022-02-17 | Hale | Alabama | 1065 | 4635 | 97 |
2223016 | 2223016 | 2022-02-17 | Henry | Alabama | 1067 | 4403 | 69 |
2223017 | 2223017 | 2022-02-17 | Houston | Alabama | 1069 | 24704 | 463 |
2223018 | 2223018 | 2022-02-17 | Jackson | Alabama | 1071 | 14800 | 219 |
2223019 | 2223019 | 2022-02-17 | Jefferson | Alabama | 1073 | 181028 | 2168 |
2223020 | 2223020 | 2022-02-17 | Lamar | Alabama | 1075 | 3577 | 63 |
2223021 | 2223021 | 2022-02-17 | Lauderdale | Alabama | 1077 | 23698 | 354 |
2223022 | 2223022 | 2022-02-17 | Lawrence | Alabama | 1079 | 7470 | 145 |
2223023 | 2223023 | 2022-02-17 | Lee | Alabama | 1081 | 37382 | 295 |
2223024 | 2223024 | 2022-02-17 | Limestone | Alabama | 1083 | 24417 | 255 |
2223025 | 2223025 | 2022-02-17 | Lowndes | Alabama | 1085 | 2592 | 69 |
2223026 | 2223026 | 2022-02-17 | Macon | Alabama | 1087 | 3814 | 72 |
2223027 | 2223027 | 2022-02-17 | Madison | Alabama | 1089 | 87330 | 852 |
2223028 | 2223028 | 2022-02-17 | Marengo | Alabama | 1091 | 5100 | 101 |
2223029 | 2223029 | 2022-02-17 | Marion | Alabama | 1093 | 7892 | 139 |
2223030 | 2223030 | 2022-02-17 | Marshall | Alabama | 1095 | 26990 | 357 |
2223031 | 2223031 | 2022-02-17 | Mobile | Alabama | 1097 | 111056 | 1535 |
2223032 | 2223032 | 2022-02-17 | Monroe | Alabama | 1099 | 5229 | 73 |
2223033 | 2223033 | 2022-02-17 | Montgomery | Alabama | 1101 | 54060 | 842 |
2223034 | 2223034 | 2022-02-17 | Morgan | Alabama | 1103 | 35471 | 467 |
2223035 | 2223035 | 2022-02-17 | Perry | Alabama | 1105 | 2067 | 42 |
2223036 | 2223036 | 2022-02-17 | Pickens | Alabama | 1107 | 5082 | 95 |
2223037 | 2223037 | 2022-02-17 | Pike | Alabama | 1109 | 7374 | 121 |
2223038 | 2223038 | 2022-02-17 | Randolph | Alabama | 1111 | 5028 | 72 |
2223039 | 2223039 | 2022-02-17 | Russell | Alabama | 1113 | 9935 | 77 |
2223040 | 2223040 | 2022-02-17 | Shelby | Alabama | 1117 | 58359 | 408 |
2223041 | 2223041 | 2022-02-17 | St. Clair | Alabama | 1115 | 24800 | 384 |
2223042 | 2223042 | 2022-02-17 | Sumter | Alabama | 1119 | 2514 | 45 |
2223043 | 2223043 | 2022-02-17 | Talladega | Alabama | 1121 | 21721 | 335 |
2223044 | 2223044 | 2022-02-17 | Tallapoosa | Alabama | 1123 | 11233 | 218 |
2223045 | 2223045 | 2022-02-17 | Tuscaloosa | Alabama | 1125 | 53992 | 710 |
2223046 | 2223046 | 2022-02-17 | Walker | Alabama | 1127 | 18321 | 406 |
2223047 | 2223047 | 2022-02-17 | Washington | Alabama | 1129 | 3646 | 53 |
2223048 | 2223048 | 2022-02-17 | Wilcox | Alabama | 1131 | 2828 | 42 |
2223049 | 2223049 | 2022-02-17 | Winston | Alabama | 1133 | 7434 | 117 |
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);