ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-11-30" 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 |
---|---|---|---|---|---|---|---|
780890 | 780890 | 2020-11-30 | Autauga | Alabama | 1001 | 2780 | 42 |
780891 | 780891 | 2020-11-30 | Baldwin | Alabama | 1003 | 8890 | 98 |
780892 | 780892 | 2020-11-30 | Barbour | Alabama | 1005 | 1178 | 11 |
780893 | 780893 | 2020-11-30 | Bibb | Alabama | 1007 | 1196 | 17 |
780894 | 780894 | 2020-11-30 | Blount | Alabama | 1009 | 2997 | 40 |
780895 | 780895 | 2020-11-30 | Bullock | Alabama | 1011 | 702 | 19 |
780896 | 780896 | 2020-11-30 | Butler | Alabama | 1013 | 1178 | 42 |
780897 | 780897 | 2020-11-30 | Calhoun | Alabama | 1015 | 6430 | 121 |
780898 | 780898 | 2020-11-30 | Chambers | Alabama | 1017 | 1779 | 50 |
780899 | 780899 | 2020-11-30 | Cherokee | Alabama | 1019 | 1034 | 24 |
780900 | 780900 | 2020-11-30 | Chilton | Alabama | 1021 | 2274 | 38 |
780901 | 780901 | 2020-11-30 | Choctaw | Alabama | 1023 | 427 | 13 |
780902 | 780902 | 2020-11-30 | Clarke | Alabama | 1025 | 1598 | 19 |
780903 | 780903 | 2020-11-30 | Clay | Alabama | 1027 | 920 | 24 |
780904 | 780904 | 2020-11-30 | Cleburne | Alabama | 1029 | 778 | 14 |
780905 | 780905 | 2020-11-30 | Coffee | Alabama | 1031 | 2483 | 15 |
780906 | 780906 | 2020-11-30 | Colbert | Alabama | 1033 | 3296 | 42 |
780907 | 780907 | 2020-11-30 | Conecuh | Alabama | 1035 | 688 | 14 |
780908 | 780908 | 2020-11-30 | Coosa | Alabama | 1037 | 354 | 4 |
780909 | 780909 | 2020-11-30 | Covington | Alabama | 1039 | 2204 | 34 |
780910 | 780910 | 2020-11-30 | Crenshaw | Alabama | 1041 | 720 | 30 |
780911 | 780911 | 2020-11-30 | Cullman | Alabama | 1043 | 4515 | 42 |
780912 | 780912 | 2020-11-30 | Dale | Alabama | 1045 | 2362 | 54 |
780913 | 780913 | 2020-11-30 | Dallas | Alabama | 1047 | 2268 | 32 |
780914 | 780914 | 2020-11-30 | DeKalb | Alabama | 1049 | 4922 | 36 |
780915 | 780915 | 2020-11-30 | Elmore | Alabama | 1051 | 4129 | 64 |
780916 | 780916 | 2020-11-30 | Escambia | Alabama | 1053 | 1989 | 31 |
780917 | 780917 | 2020-11-30 | Etowah | Alabama | 1055 | 6439 | 66 |
780918 | 780918 | 2020-11-30 | Fayette | Alabama | 1057 | 925 | 16 |
780919 | 780919 | 2020-11-30 | Franklin | Alabama | 1059 | 2564 | 34 |
780920 | 780920 | 2020-11-30 | Geneva | Alabama | 1061 | 1243 | 8 |
780921 | 780921 | 2020-11-30 | Greene | Alabama | 1063 | 428 | 18 |
780922 | 780922 | 2020-11-30 | Hale | Alabama | 1065 | 978 | 31 |
780923 | 780923 | 2020-11-30 | Henry | Alabama | 1067 | 875 | 6 |
780924 | 780924 | 2020-11-30 | Houston | Alabama | 1069 | 5377 | 38 |
780925 | 780925 | 2020-11-30 | Jackson | Alabama | 1071 | 3298 | 23 |
780926 | 780926 | 2020-11-30 | Jefferson | Alabama | 1073 | 33064 | 500 |
780927 | 780927 | 2020-11-30 | Lamar | Alabama | 1075 | 689 | 8 |
780928 | 780928 | 2020-11-30 | Lauderdale | Alabama | 1077 | 4223 | 54 |
780929 | 780929 | 2020-11-30 | Lawrence | Alabama | 1079 | 1316 | 36 |
780930 | 780930 | 2020-11-30 | Lee | Alabama | 1081 | 7814 | 66 |
780931 | 780931 | 2020-11-30 | Limestone | Alabama | 1083 | 4333 | 45 |
780932 | 780932 | 2020-11-30 | Lowndes | Alabama | 1085 | 802 | 29 |
780933 | 780933 | 2020-11-30 | Macon | Alabama | 1087 | 745 | 22 |
780934 | 780934 | 2020-11-30 | Madison | Alabama | 1089 | 13596 | 148 |
780935 | 780935 | 2020-11-30 | Marengo | Alabama | 1091 | 1231 | 24 |
780936 | 780936 | 2020-11-30 | Marion | Alabama | 1093 | 1436 | 36 |
780937 | 780937 | 2020-11-30 | Marshall | Alabama | 1095 | 6353 | 55 |
780938 | 780938 | 2020-11-30 | Mobile | Alabama | 1097 | 19951 | 362 |
780939 | 780939 | 2020-11-30 | Monroe | Alabama | 1099 | 790 | 11 |
780940 | 780940 | 2020-11-30 | Montgomery | Alabama | 1101 | 12435 | 236 |
780941 | 780941 | 2020-11-30 | Morgan | Alabama | 1103 | 6861 | 50 |
780942 | 780942 | 2020-11-30 | Perry | Alabama | 1105 | 690 | 6 |
780943 | 780943 | 2020-11-30 | Pickens | Alabama | 1107 | 1257 | 18 |
780944 | 780944 | 2020-11-30 | Pike | Alabama | 1109 | 1599 | 14 |
780945 | 780945 | 2020-11-30 | Randolph | Alabama | 1111 | 1049 | 21 |
780946 | 780946 | 2020-11-30 | Russell | Alabama | 1113 | 2238 | 3 |
780947 | 780947 | 2020-11-30 | Shelby | Alabama | 1117 | 10616 | 77 |
780948 | 780948 | 2020-11-30 | St. Clair | Alabama | 1115 | 4325 | 55 |
780949 | 780949 | 2020-11-30 | Sumter | Alabama | 1119 | 586 | 22 |
780950 | 780950 | 2020-11-30 | Talladega | Alabama | 1121 | 3593 | 54 |
780951 | 780951 | 2020-11-30 | Tallapoosa | Alabama | 1123 | 1843 | 91 |
780952 | 780952 | 2020-11-30 | Tuscaloosa | Alabama | 1125 | 13246 | 154 |
780953 | 780953 | 2020-11-30 | Walker | Alabama | 1127 | 3710 | 111 |
780954 | 780954 | 2020-11-30 | Washington | Alabama | 1129 | 922 | 19 |
780955 | 780955 | 2020-11-30 | Wilcox | Alabama | 1131 | 642 | 18 |
780956 | 780956 | 2020-11-30 | Winston | Alabama | 1133 | 1351 | 23 |
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);