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 2020-04-16 and state = "Alabama" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
61884 | 61884 | 2020-04-16 | Autauga | Alabama | 1001 | 25 | 2 |
61885 | 61885 | 2020-04-16 | Baldwin | Alabama | 1003 | 102 | 2 |
61886 | 61886 | 2020-04-16 | Barbour | Alabama | 1005 | 14 | 0 |
61887 | 61887 | 2020-04-16 | Bibb | Alabama | 1007 | 24 | 0 |
61888 | 61888 | 2020-04-16 | Blount | Alabama | 1009 | 18 | 0 |
61889 | 61889 | 2020-04-16 | Bullock | Alabama | 1011 | 8 | 0 |
61890 | 61890 | 2020-04-16 | Butler | Alabama | 1013 | 11 | 0 |
61891 | 61891 | 2020-04-16 | Calhoun | Alabama | 1015 | 63 | 1 |
61892 | 61892 | 2020-04-16 | Chambers | Alabama | 1017 | 234 | 11 |
61893 | 61893 | 2020-04-16 | Cherokee | Alabama | 1019 | 11 | 0 |
61894 | 61894 | 2020-04-16 | Chilton | Alabama | 1021 | 37 | 0 |
61895 | 61895 | 2020-04-16 | Choctaw | Alabama | 1023 | 13 | 0 |
61896 | 61896 | 2020-04-16 | Clarke | Alabama | 1025 | 24 | 0 |
61897 | 61897 | 2020-04-16 | Clay | Alabama | 1027 | 14 | 0 |
61898 | 61898 | 2020-04-16 | Cleburne | Alabama | 1029 | 12 | 0 |
61899 | 61899 | 2020-04-16 | Coffee | Alabama | 1031 | 50 | 0 |
61900 | 61900 | 2020-04-16 | Colbert | Alabama | 1033 | 13 | 1 |
61901 | 61901 | 2020-04-16 | Conecuh | Alabama | 1035 | 8 | 0 |
61902 | 61902 | 2020-04-16 | Coosa | Alabama | 1037 | 20 | 1 |
61903 | 61903 | 2020-04-16 | Covington | Alabama | 1039 | 19 | 1 |
61904 | 61904 | 2020-04-16 | Crenshaw | Alabama | 1041 | 5 | 0 |
61905 | 61905 | 2020-04-16 | Cullman | Alabama | 1043 | 42 | 1 |
61906 | 61906 | 2020-04-16 | Dale | Alabama | 1045 | 14 | 0 |
61907 | 61907 | 2020-04-16 | Dallas | Alabama | 1047 | 21 | 2 |
61908 | 61908 | 2020-04-16 | DeKalb | Alabama | 1049 | 32 | 1 |
61909 | 61909 | 2020-04-16 | Elmore | Alabama | 1051 | 54 | 0 |
61910 | 61910 | 2020-04-16 | Escambia | Alabama | 1053 | 12 | 0 |
61911 | 61911 | 2020-04-16 | Etowah | Alabama | 1055 | 87 | 8 |
61912 | 61912 | 2020-04-16 | Fayette | Alabama | 1057 | 4 | 0 |
61913 | 61913 | 2020-04-16 | Franklin | Alabama | 1059 | 17 | 1 |
61914 | 61914 | 2020-04-16 | Geneva | Alabama | 1061 | 2 | 0 |
61915 | 61915 | 2020-04-16 | Greene | Alabama | 1063 | 22 | 0 |
61916 | 61916 | 2020-04-16 | Hale | Alabama | 1065 | 22 | 0 |
61917 | 61917 | 2020-04-16 | Henry | Alabama | 1067 | 15 | 0 |
61918 | 61918 | 2020-04-16 | Houston | Alabama | 1069 | 58 | 3 |
61919 | 61919 | 2020-04-16 | Jackson | Alabama | 1071 | 32 | 2 |
61920 | 61920 | 2020-04-16 | Jefferson | Alabama | 1073 | 634 | 22 |
61921 | 61921 | 2020-04-16 | Lamar | Alabama | 1075 | 7 | 0 |
61922 | 61922 | 2020-04-16 | Lauderdale | Alabama | 1077 | 22 | 4 |
61923 | 61923 | 2020-04-16 | Lawrence | Alabama | 1079 | 8 | 0 |
61924 | 61924 | 2020-04-16 | Lee | Alabama | 1081 | 294 | 12 |
61925 | 61925 | 2020-04-16 | Limestone | Alabama | 1083 | 38 | 0 |
61926 | 61926 | 2020-04-16 | Lowndes | Alabama | 1085 | 25 | 0 |
61927 | 61927 | 2020-04-16 | Macon | Alabama | 1087 | 24 | 2 |
61928 | 61928 | 2020-04-16 | Madison | Alabama | 1089 | 198 | 4 |
61929 | 61929 | 2020-04-16 | Marengo | Alabama | 1091 | 24 | 1 |
61930 | 61930 | 2020-04-16 | Marion | Alabama | 1093 | 60 | 4 |
61931 | 61931 | 2020-04-16 | Marshall | Alabama | 1095 | 117 | 2 |
61932 | 61932 | 2020-04-16 | Mobile | Alabama | 1097 | 594 | 23 |
61933 | 61933 | 2020-04-16 | Monroe | Alabama | 1099 | 7 | 1 |
61934 | 61934 | 2020-04-16 | Montgomery | Alabama | 1101 | 201 | 5 |
61935 | 61935 | 2020-04-16 | Morgan | Alabama | 1103 | 44 | 0 |
61936 | 61936 | 2020-04-16 | Perry | Alabama | 1105 | 8 | 0 |
61937 | 61937 | 2020-04-16 | Pickens | Alabama | 1107 | 30 | 0 |
61938 | 61938 | 2020-04-16 | Pike | Alabama | 1109 | 28 | 0 |
61939 | 61939 | 2020-04-16 | Randolph | Alabama | 1111 | 47 | 4 |
61940 | 61940 | 2020-04-16 | Russell | Alabama | 1113 | 35 | 0 |
61941 | 61941 | 2020-04-16 | Shelby | Alabama | 1117 | 242 | 7 |
61942 | 61942 | 2020-04-16 | St. Clair | Alabama | 1115 | 49 | 0 |
61943 | 61943 | 2020-04-16 | Sumter | Alabama | 1119 | 31 | 0 |
61944 | 61944 | 2020-04-16 | Talladega | Alabama | 1121 | 40 | 1 |
61945 | 61945 | 2020-04-16 | Tallapoosa | Alabama | 1123 | 160 | 7 |
61946 | 61946 | 2020-04-16 | Tuscaloosa | Alabama | 1125 | 132 | 0 |
61947 | 61947 | 2020-04-16 | Walker | Alabama | 1127 | 84 | 0 |
61948 | 61948 | 2020-04-16 | Washington | Alabama | 1129 | 13 | 1 |
61949 | 61949 | 2020-04-16 | Wilcox | Alabama | 1131 | 40 | 0 |
61950 | 61950 | 2020-04-16 | Winston | Alabama | 1133 | 9 | 0 |
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);