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-04-29 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 |
---|---|---|---|---|---|---|---|
1267803 | 1267803 | 2021-04-29 | Autauga | Alabama | 1001 | 6897 | 107 |
1267804 | 1267804 | 2021-04-29 | Baldwin | Alabama | 1003 | 20921 | 305 |
1267805 | 1267805 | 2021-04-29 | Barbour | Alabama | 1005 | 2299 | 56 |
1267806 | 1267806 | 2021-04-29 | Bibb | Alabama | 1007 | 2593 | 63 |
1267807 | 1267807 | 2021-04-29 | Blount | Alabama | 1009 | 6607 | 135 |
1267808 | 1267808 | 2021-04-29 | Bullock | Alabama | 1011 | 1227 | 40 |
1267809 | 1267809 | 2021-04-29 | Butler | Alabama | 1013 | 2151 | 69 |
1267810 | 1267810 | 2021-04-29 | Calhoun | Alabama | 1015 | 14432 | 312 |
1267811 | 1267811 | 2021-04-29 | Chambers | Alabama | 1017 | 3540 | 121 |
1267812 | 1267812 | 2021-04-29 | Cherokee | Alabama | 1019 | 1835 | 45 |
1267813 | 1267813 | 2021-04-29 | Chilton | Alabama | 1021 | 4218 | 111 |
1267814 | 1267814 | 2021-04-29 | Choctaw | Alabama | 1023 | 600 | 24 |
1267815 | 1267815 | 2021-04-29 | Clarke | Alabama | 1025 | 3501 | 60 |
1267816 | 1267816 | 2021-04-29 | Clay | Alabama | 1027 | 1529 | 56 |
1267817 | 1267817 | 2021-04-29 | Cleburne | Alabama | 1029 | 1482 | 41 |
1267818 | 1267818 | 2021-04-29 | Coffee | Alabama | 1031 | 5477 | 115 |
1267819 | 1267819 | 2021-04-29 | Colbert | Alabama | 1033 | 6274 | 134 |
1267820 | 1267820 | 2021-04-29 | Conecuh | Alabama | 1035 | 1098 | 28 |
1267821 | 1267821 | 2021-04-29 | Coosa | Alabama | 1037 | 1063 | 28 |
1267822 | 1267822 | 2021-04-29 | Covington | Alabama | 1039 | 4104 | 116 |
1267823 | 1267823 | 2021-04-29 | Crenshaw | Alabama | 1041 | 1513 | 57 |
1267824 | 1267824 | 2021-04-29 | Cullman | Alabama | 1043 | 9586 | 192 |
1267825 | 1267825 | 2021-04-29 | Dale | Alabama | 1045 | 4800 | 111 |
1267826 | 1267826 | 2021-04-29 | Dallas | Alabama | 1047 | 3526 | 150 |
1267827 | 1267827 | 2021-04-29 | DeKalb | Alabama | 1049 | 8795 | 184 |
1267828 | 1267828 | 2021-04-29 | Elmore | Alabama | 1051 | 9995 | 205 |
1267829 | 1267829 | 2021-04-29 | Escambia | Alabama | 1053 | 3921 | 75 |
1267830 | 1267830 | 2021-04-29 | Etowah | Alabama | 1055 | 13757 | 352 |
1267831 | 1267831 | 2021-04-29 | Fayette | Alabama | 1057 | 2117 | 62 |
1267832 | 1267832 | 2021-04-29 | Franklin | Alabama | 1059 | 4230 | 82 |
1267833 | 1267833 | 2021-04-29 | Geneva | Alabama | 1061 | 2466 | 75 |
1267834 | 1267834 | 2021-04-29 | Greene | Alabama | 1063 | 921 | 34 |
1267835 | 1267835 | 2021-04-29 | Hale | Alabama | 1065 | 2206 | 75 |
1267836 | 1267836 | 2021-04-29 | Henry | Alabama | 1067 | 1879 | 44 |
1267837 | 1267837 | 2021-04-29 | Houston | Alabama | 1069 | 10482 | 280 |
1267838 | 1267838 | 2021-04-29 | Jackson | Alabama | 1071 | 6790 | 110 |
1267839 | 1267839 | 2021-04-29 | Jefferson | Alabama | 1073 | 76073 | 1514 |
1267840 | 1267840 | 2021-04-29 | Lamar | Alabama | 1075 | 1406 | 34 |
1267841 | 1267841 | 2021-04-29 | Lauderdale | Alabama | 1077 | 9367 | 236 |
1267842 | 1267842 | 2021-04-29 | Lawrence | Alabama | 1079 | 2990 | 97 |
1267843 | 1267843 | 2021-04-29 | Lee | Alabama | 1081 | 15773 | 168 |
1267844 | 1267844 | 2021-04-29 | Limestone | Alabama | 1083 | 9914 | 150 |
1267845 | 1267845 | 2021-04-29 | Lowndes | Alabama | 1085 | 1385 | 53 |
1267846 | 1267846 | 2021-04-29 | Macon | Alabama | 1087 | 1585 | 49 |
1267847 | 1267847 | 2021-04-29 | Madison | Alabama | 1089 | 34452 | 498 |
1267848 | 1267848 | 2021-04-29 | Marengo | Alabama | 1091 | 2481 | 64 |
1267849 | 1267849 | 2021-04-29 | Marion | Alabama | 1093 | 3087 | 100 |
1267850 | 1267850 | 2021-04-29 | Marshall | Alabama | 1095 | 12129 | 221 |
1267851 | 1267851 | 2021-04-29 | Mobile | Alabama | 1097 | 40731 | 804 |
1267852 | 1267852 | 2021-04-29 | Monroe | Alabama | 1099 | 1753 | 40 |
1267853 | 1267853 | 2021-04-29 | Montgomery | Alabama | 1101 | 24213 | 583 |
1267854 | 1267854 | 2021-04-29 | Morgan | Alabama | 1103 | 14218 | 277 |
1267855 | 1267855 | 2021-04-29 | Perry | Alabama | 1105 | 1075 | 26 |
1267856 | 1267856 | 2021-04-29 | Pickens | Alabama | 1107 | 2334 | 59 |
1267857 | 1267857 | 2021-04-29 | Pike | Alabama | 1109 | 3084 | 77 |
1267858 | 1267858 | 2021-04-29 | Randolph | Alabama | 1111 | 1789 | 41 |
1267859 | 1267859 | 2021-04-29 | Russell | Alabama | 1113 | 4368 | 38 |
1267860 | 1267860 | 2021-04-29 | Shelby | Alabama | 1117 | 23318 | 246 |
1267861 | 1267861 | 2021-04-29 | St. Clair | Alabama | 1115 | 9553 | 237 |
1267862 | 1267862 | 2021-04-29 | Sumter | Alabama | 1119 | 1038 | 32 |
1267863 | 1267863 | 2021-04-29 | Talladega | Alabama | 1121 | 8149 | 175 |
1267864 | 1267864 | 2021-04-29 | Tallapoosa | Alabama | 1123 | 3981 | 149 |
1267865 | 1267865 | 2021-04-29 | Tuscaloosa | Alabama | 1125 | 25577 | 449 |
1267866 | 1267866 | 2021-04-29 | Walker | Alabama | 1127 | 7199 | 278 |
1267867 | 1267867 | 2021-04-29 | Washington | Alabama | 1129 | 1665 | 39 |
1267868 | 1267868 | 2021-04-29 | Wilcox | Alabama | 1131 | 1262 | 27 |
1267869 | 1267869 | 2021-04-29 | Winston | Alabama | 1133 | 2732 | 72 |
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);