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-07-11 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
321893 | 321893 | 2020-07-11 | Autauga | Alabama | 1001 | 684 | 15 |
321894 | 321894 | 2020-07-11 | Baldwin | Alabama | 1003 | 1224 | 12 |
321895 | 321895 | 2020-07-11 | Barbour | Alabama | 1005 | 398 | 2 |
321896 | 321896 | 2020-07-11 | Bibb | Alabama | 1007 | 224 | 1 |
321897 | 321897 | 2020-07-11 | Blount | Alabama | 1009 | 307 | 1 |
321898 | 321898 | 2020-07-11 | Bullock | Alabama | 1011 | 382 | 11 |
321899 | 321899 | 2020-07-11 | Butler | Alabama | 1013 | 654 | 29 |
321900 | 321900 | 2020-07-11 | Calhoun | Alabama | 1015 | 500 | 5 |
321901 | 321901 | 2020-07-11 | Chambers | Alabama | 1017 | 690 | 27 |
321902 | 321902 | 2020-07-11 | Cherokee | Alabama | 1019 | 128 | 7 |
321903 | 321903 | 2020-07-11 | Chilton | Alabama | 1021 | 331 | 3 |
321904 | 321904 | 2020-07-11 | Choctaw | Alabama | 1023 | 213 | 12 |
321905 | 321905 | 2020-07-11 | Clarke | Alabama | 1025 | 313 | 6 |
321906 | 321906 | 2020-07-11 | Clay | Alabama | 1027 | 85 | 2 |
321907 | 321907 | 2020-07-11 | Cleburne | Alabama | 1029 | 42 | 1 |
321908 | 321908 | 2020-07-11 | Coffee | Alabama | 1031 | 429 | 4 |
321909 | 321909 | 2020-07-11 | Colbert | Alabama | 1033 | 505 | 6 |
321910 | 321910 | 2020-07-11 | Conecuh | Alabama | 1035 | 232 | 8 |
321911 | 321911 | 2020-07-11 | Coosa | Alabama | 1037 | 65 | 1 |
321912 | 321912 | 2020-07-11 | Covington | Alabama | 1039 | 437 | 13 |
321913 | 321913 | 2020-07-11 | Crenshaw | Alabama | 1041 | 131 | 3 |
321914 | 321914 | 2020-07-11 | Cullman | Alabama | 1043 | 581 | 6 |
321915 | 321915 | 2020-07-11 | Dale | Alabama | 1045 | 394 | 1 |
321916 | 321916 | 2020-07-11 | Dallas | Alabama | 1047 | 1009 | 9 |
321917 | 321917 | 2020-07-11 | DeKalb | Alabama | 1049 | 951 | 7 |
321918 | 321918 | 2020-07-11 | Elmore | Alabama | 1051 | 1047 | 20 |
321919 | 321919 | 2020-07-11 | Escambia | Alabama | 1053 | 480 | 8 |
321920 | 321920 | 2020-07-11 | Etowah | Alabama | 1055 | 964 | 14 |
321921 | 321921 | 2020-07-11 | Fayette | Alabama | 1057 | 85 | 1 |
321922 | 321922 | 2020-07-11 | Franklin | Alabama | 1059 | 937 | 16 |
321923 | 321923 | 2020-07-11 | Geneva | Alabama | 1061 | 96 | 0 |
321924 | 321924 | 2020-07-11 | Greene | Alabama | 1063 | 195 | 9 |
321925 | 321925 | 2020-07-11 | Hale | Alabama | 1065 | 353 | 23 |
321926 | 321926 | 2020-07-11 | Henry | Alabama | 1067 | 154 | 4 |
321927 | 321927 | 2020-07-11 | Houston | Alabama | 1069 | 600 | 9 |
321928 | 321928 | 2020-07-11 | Jackson | Alabama | 1071 | 422 | 3 |
321929 | 321929 | 2020-07-11 | Jefferson | Alabama | 1073 | 6504 | 172 |
321930 | 321930 | 2020-07-11 | Lamar | Alabama | 1075 | 88 | 1 |
321931 | 321931 | 2020-07-11 | Lauderdale | Alabama | 1077 | 571 | 6 |
321932 | 321932 | 2020-07-11 | Lawrence | Alabama | 1079 | 128 | 0 |
321933 | 321933 | 2020-07-11 | Lee | Alabama | 1081 | 1611 | 38 |
321934 | 321934 | 2020-07-11 | Limestone | Alabama | 1083 | 628 | 4 |
321935 | 321935 | 2020-07-11 | Lowndes | Alabama | 1085 | 485 | 24 |
321936 | 321936 | 2020-07-11 | Macon | Alabama | 1087 | 221 | 9 |
321937 | 321937 | 2020-07-11 | Madison | Alabama | 1089 | 2150 | 10 |
321938 | 321938 | 2020-07-11 | Marengo | Alabama | 1091 | 354 | 11 |
321939 | 321939 | 2020-07-11 | Marion | Alabama | 1093 | 279 | 14 |
321940 | 321940 | 2020-07-11 | Marshall | Alabama | 1095 | 1942 | 11 |
321941 | 321941 | 2020-07-11 | Mobile | Alabama | 1097 | 4778 | 144 |
321942 | 321942 | 2020-07-11 | Monroe | Alabama | 1099 | 258 | 4 |
321943 | 321943 | 2020-07-11 | Montgomery | Alabama | 1101 | 4478 | 114 |
321944 | 321944 | 2020-07-11 | Morgan | Alabama | 1103 | 1283 | 5 |
321945 | 321945 | 2020-07-11 | Perry | Alabama | 1105 | 236 | 2 |
321946 | 321946 | 2020-07-11 | Pickens | Alabama | 1107 | 272 | 6 |
321947 | 321947 | 2020-07-11 | Pike | Alabama | 1109 | 478 | 5 |
321948 | 321948 | 2020-07-11 | Randolph | Alabama | 1111 | 260 | 9 |
321949 | 321949 | 2020-07-11 | Russell | Alabama | 1113 | 683 | 0 |
321950 | 321950 | 2020-07-11 | Shelby | Alabama | 1117 | 1674 | 25 |
321951 | 321951 | 2020-07-11 | St. Clair | Alabama | 1115 | 528 | 3 |
321952 | 321952 | 2020-07-11 | Sumter | Alabama | 1119 | 292 | 13 |
321953 | 321953 | 2020-07-11 | Talladega | Alabama | 1121 | 406 | 8 |
321954 | 321954 | 2020-07-11 | Tallapoosa | Alabama | 1123 | 637 | 70 |
321955 | 321955 | 2020-07-11 | Tuscaloosa | Alabama | 1125 | 2654 | 55 |
321956 | 321956 | 2020-07-11 | Walker | Alabama | 1127 | 1077 | 31 |
321957 | 321957 | 2020-07-11 | Washington | Alabama | 1129 | 144 | 8 |
321958 | 321958 | 2020-07-11 | Wilcox | Alabama | 1131 | 306 | 8 |
321959 | 321959 | 2020-07-11 | Winston | Alabama | 1133 | 300 | 5 |
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);