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-01-02 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
887983 | 887983 | 2021-01-02 | Autauga | Alabama | 1001 | 4268 | 50 |
887984 | 887984 | 2021-01-02 | Baldwin | Alabama | 1003 | 13955 | 169 |
887985 | 887985 | 2021-01-02 | Barbour | Alabama | 1005 | 1528 | 33 |
887986 | 887986 | 2021-01-02 | Bibb | Alabama | 1007 | 1863 | 46 |
887987 | 887987 | 2021-01-02 | Blount | Alabama | 1009 | 4729 | 63 |
887988 | 887988 | 2021-01-02 | Bullock | Alabama | 1011 | 892 | 22 |
887989 | 887989 | 2021-01-02 | Butler | Alabama | 1013 | 1530 | 45 |
887990 | 887990 | 2021-01-02 | Calhoun | Alabama | 1015 | 9692 | 157 |
887991 | 887991 | 2021-01-02 | Chambers | Alabama | 1017 | 2386 | 63 |
887992 | 887992 | 2021-01-02 | Cherokee | Alabama | 1019 | 1435 | 22 |
887993 | 887993 | 2021-01-02 | Chilton | Alabama | 1021 | 3019 | 54 |
887994 | 887994 | 2021-01-02 | Choctaw | Alabama | 1023 | 492 | 22 |
887995 | 887995 | 2021-01-02 | Clarke | Alabama | 1025 | 2438 | 26 |
887996 | 887996 | 2021-01-02 | Clay | Alabama | 1027 | 1158 | 34 |
887997 | 887997 | 2021-01-02 | Cleburne | Alabama | 1029 | 1046 | 16 |
887998 | 887998 | 2021-01-02 | Coffee | Alabama | 1031 | 3678 | 38 |
887999 | 887999 | 2021-01-02 | Colbert | Alabama | 1033 | 4730 | 60 |
888000 | 888000 | 2021-01-02 | Conecuh | Alabama | 1035 | 865 | 17 |
888001 | 888001 | 2021-01-02 | Coosa | Alabama | 1037 | 523 | 7 |
888002 | 888002 | 2021-01-02 | Covington | Alabama | 1039 | 2948 | 40 |
888003 | 888003 | 2021-01-02 | Crenshaw | Alabama | 1041 | 963 | 36 |
888004 | 888004 | 2021-01-02 | Cullman | Alabama | 1043 | 7242 | 78 |
888005 | 888005 | 2021-01-02 | Dale | Alabama | 1045 | 3404 | 63 |
888006 | 888006 | 2021-01-02 | Dallas | Alabama | 1047 | 2827 | 43 |
888007 | 888007 | 2021-01-02 | DeKalb | Alabama | 1049 | 7004 | 62 |
888008 | 888008 | 2021-01-02 | Elmore | Alabama | 1051 | 6625 | 83 |
888009 | 888009 | 2021-01-02 | Escambia | Alabama | 1053 | 2713 | 34 |
888010 | 888010 | 2021-01-02 | Etowah | Alabama | 1055 | 10265 | 96 |
888011 | 888011 | 2021-01-02 | Fayette | Alabama | 1057 | 1456 | 19 |
888012 | 888012 | 2021-01-02 | Franklin | Alabama | 1059 | 3317 | 37 |
888013 | 888013 | 2021-01-02 | Geneva | Alabama | 1061 | 1720 | 20 |
888014 | 888014 | 2021-01-02 | Greene | Alabama | 1063 | 682 | 20 |
888015 | 888015 | 2021-01-02 | Hale | Alabama | 1065 | 1492 | 33 |
888016 | 888016 | 2021-01-02 | Henry | Alabama | 1067 | 1284 | 8 |
888017 | 888017 | 2021-01-02 | Houston | Alabama | 1069 | 7454 | 64 |
888018 | 888018 | 2021-01-02 | Jackson | Alabama | 1071 | 5217 | 34 |
888019 | 888019 | 2021-01-02 | Jefferson | Alabama | 1073 | 53621 | 719 |
888020 | 888020 | 2021-01-02 | Lamar | Alabama | 1075 | 1069 | 15 |
888021 | 888021 | 2021-01-02 | Lauderdale | Alabama | 1077 | 6613 | 70 |
888022 | 888022 | 2021-01-02 | Lawrence | Alabama | 1079 | 2102 | 43 |
888023 | 888023 | 2021-01-02 | Lee | Alabama | 1081 | 10508 | 75 |
888024 | 888024 | 2021-01-02 | Limestone | Alabama | 1083 | 6992 | 58 |
888025 | 888025 | 2021-01-02 | Lowndes | Alabama | 1085 | 956 | 32 |
888026 | 888026 | 2021-01-02 | Macon | Alabama | 1087 | 1011 | 30 |
888027 | 888027 | 2021-01-02 | Madison | Alabama | 1089 | 23115 | 179 |
888028 | 888028 | 2021-01-02 | Marengo | Alabama | 1091 | 1821 | 26 |
888029 | 888029 | 2021-01-02 | Marion | Alabama | 1093 | 2134 | 43 |
888030 | 888030 | 2021-01-02 | Marshall | Alabama | 1095 | 9293 | 86 |
888031 | 888031 | 2021-01-02 | Mobile | Alabama | 1097 | 26431 | 508 |
888032 | 888032 | 2021-01-02 | Monroe | Alabama | 1099 | 1231 | 11 |
888033 | 888033 | 2021-01-02 | Montgomery | Alabama | 1101 | 16333 | 276 |
888034 | 888034 | 2021-01-02 | Morgan | Alabama | 1103 | 10912 | 89 |
888035 | 888035 | 2021-01-02 | Perry | Alabama | 1105 | 883 | 10 |
888036 | 888036 | 2021-01-02 | Pickens | Alabama | 1107 | 1763 | 26 |
888037 | 888037 | 2021-01-02 | Pike | Alabama | 1109 | 2036 | 23 |
888038 | 888038 | 2021-01-02 | Randolph | Alabama | 1111 | 1267 | 30 |
888039 | 888039 | 2021-01-02 | Russell | Alabama | 1113 | 2842 | 6 |
888040 | 888040 | 2021-01-02 | Shelby | Alabama | 1117 | 16034 | 103 |
888041 | 888041 | 2021-01-02 | St. Clair | Alabama | 1115 | 6709 | 73 |
888042 | 888042 | 2021-01-02 | Sumter | Alabama | 1119 | 863 | 24 |
888043 | 888043 | 2021-01-02 | Talladega | Alabama | 1121 | 5254 | 76 |
888044 | 888044 | 2021-01-02 | Tallapoosa | Alabama | 1123 | 2395 | 98 |
888045 | 888045 | 2021-01-02 | Tuscaloosa | Alabama | 1125 | 18947 | 218 |
888046 | 888046 | 2021-01-02 | Walker | Alabama | 1127 | 5357 | 138 |
888047 | 888047 | 2021-01-02 | Washington | Alabama | 1129 | 1211 | 24 |
888048 | 888048 | 2021-01-02 | Wilcox | Alabama | 1131 | 894 | 19 |
888049 | 888049 | 2021-01-02 | Winston | Alabama | 1133 | 2021 | 30 |
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);