ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-06-21" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
258833 | 258833 | 2020-06-21 | Autauga | Alabama | 1001 | 434 | 9 |
258834 | 258834 | 2020-06-21 | Baldwin | Alabama | 1003 | 430 | 9 |
258835 | 258835 | 2020-06-21 | Barbour | Alabama | 1005 | 272 | 1 |
258836 | 258836 | 2020-06-21 | Bibb | Alabama | 1007 | 127 | 1 |
258837 | 258837 | 2020-06-21 | Blount | Alabama | 1009 | 149 | 1 |
258838 | 258838 | 2020-06-21 | Bullock | Alabama | 1011 | 327 | 10 |
258839 | 258839 | 2020-06-21 | Butler | Alabama | 1013 | 576 | 26 |
258840 | 258840 | 2020-06-21 | Calhoun | Alabama | 1015 | 213 | 4 |
258841 | 258841 | 2020-06-21 | Chambers | Alabama | 1017 | 521 | 27 |
258842 | 258842 | 2020-06-21 | Cherokee | Alabama | 1019 | 58 | 6 |
258843 | 258843 | 2020-06-21 | Chilton | Alabama | 1021 | 166 | 3 |
258844 | 258844 | 2020-06-21 | Choctaw | Alabama | 1023 | 186 | 12 |
258845 | 258845 | 2020-06-21 | Clarke | Alabama | 1025 | 216 | 4 |
258846 | 258846 | 2020-06-21 | Clay | Alabama | 1027 | 32 | 2 |
258847 | 258847 | 2020-06-21 | Cleburne | Alabama | 1029 | 22 | 1 |
258848 | 258848 | 2020-06-21 | Coffee | Alabama | 1031 | 317 | 1 |
258849 | 258849 | 2020-06-21 | Colbert | Alabama | 1033 | 304 | 5 |
258850 | 258850 | 2020-06-21 | Conecuh | Alabama | 1035 | 140 | 1 |
258851 | 258851 | 2020-06-21 | Coosa | Alabama | 1037 | 50 | 1 |
258852 | 258852 | 2020-06-21 | Covington | Alabama | 1039 | 228 | 1 |
258853 | 258853 | 2020-06-21 | Crenshaw | Alabama | 1041 | 118 | 3 |
258854 | 258854 | 2020-06-21 | Cullman | Alabama | 1043 | 310 | 1 |
258855 | 258855 | 2020-06-21 | Dale | Alabama | 1045 | 205 | 0 |
258856 | 258856 | 2020-06-21 | Dallas | Alabama | 1047 | 634 | 6 |
258857 | 258857 | 2020-06-21 | DeKalb | Alabama | 1049 | 415 | 5 |
258858 | 258858 | 2020-06-21 | Elmore | Alabama | 1051 | 673 | 11 |
258859 | 258859 | 2020-06-21 | Escambia | Alabama | 1053 | 148 | 6 |
258860 | 258860 | 2020-06-21 | Etowah | Alabama | 1055 | 405 | 12 |
258861 | 258861 | 2020-06-21 | Fayette | Alabama | 1057 | 61 | 1 |
258862 | 258862 | 2020-06-21 | Franklin | Alabama | 1059 | 782 | 10 |
258863 | 258863 | 2020-06-21 | Geneva | Alabama | 1061 | 51 | 0 |
258864 | 258864 | 2020-06-21 | Greene | Alabama | 1063 | 154 | 5 |
258865 | 258865 | 2020-06-21 | Hale | Alabama | 1065 | 263 | 18 |
258866 | 258866 | 2020-06-21 | Henry | Alabama | 1067 | 115 | 3 |
258867 | 258867 | 2020-06-21 | Houston | Alabama | 1069 | 357 | 5 |
258868 | 258868 | 2020-06-21 | Jackson | Alabama | 1071 | 152 | 3 |
258869 | 258869 | 2020-06-21 | Jefferson | Alabama | 1073 | 2987 | 126 |
258870 | 258870 | 2020-06-21 | Lamar | Alabama | 1075 | 55 | 0 |
258871 | 258871 | 2020-06-21 | Lauderdale | Alabama | 1077 | 298 | 4 |
258872 | 258872 | 2020-06-21 | Lawrence | Alabama | 1079 | 78 | 0 |
258873 | 258873 | 2020-06-21 | Lee | Alabama | 1081 | 852 | 35 |
258874 | 258874 | 2020-06-21 | Limestone | Alabama | 1083 | 271 | 0 |
258875 | 258875 | 2020-06-21 | Lowndes | Alabama | 1085 | 420 | 15 |
258876 | 258876 | 2020-06-21 | Macon | Alabama | 1087 | 149 | 6 |
258877 | 258877 | 2020-06-21 | Madison | Alabama | 1089 | 723 | 6 |
258878 | 258878 | 2020-06-21 | Marengo | Alabama | 1091 | 238 | 11 |
258879 | 258879 | 2020-06-21 | Marion | Alabama | 1093 | 173 | 12 |
258880 | 258880 | 2020-06-21 | Marshall | Alabama | 1095 | 1082 | 9 |
258881 | 258881 | 2020-06-21 | Mobile | Alabama | 1097 | 3016 | 133 |
258882 | 258882 | 2020-06-21 | Monroe | Alabama | 1099 | 163 | 2 |
258883 | 258883 | 2020-06-21 | Montgomery | Alabama | 1101 | 3258 | 81 |
258884 | 258884 | 2020-06-21 | Morgan | Alabama | 1103 | 754 | 2 |
258885 | 258885 | 2020-06-21 | Perry | Alabama | 1105 | 87 | 0 |
258886 | 258886 | 2020-06-21 | Pickens | Alabama | 1107 | 166 | 6 |
258887 | 258887 | 2020-06-21 | Pike | Alabama | 1109 | 360 | 3 |
258888 | 258888 | 2020-06-21 | Randolph | Alabama | 1111 | 144 | 8 |
258889 | 258889 | 2020-06-21 | Russell | Alabama | 1113 | 362 | 0 |
258890 | 258890 | 2020-06-21 | Shelby | Alabama | 1117 | 784 | 22 |
258891 | 258891 | 2020-06-21 | St. Clair | Alabama | 1115 | 209 | 2 |
258892 | 258892 | 2020-06-21 | Sumter | Alabama | 1119 | 269 | 12 |
258893 | 258893 | 2020-06-21 | Talladega | Alabama | 1121 | 189 | 6 |
258894 | 258894 | 2020-06-21 | Tallapoosa | Alabama | 1123 | 517 | 70 |
258895 | 258895 | 2020-06-21 | Tuscaloosa | Alabama | 1125 | 1596 | 31 |
258896 | 258896 | 2020-06-21 | Walker | Alabama | 1127 | 693 | 8 |
258897 | 258897 | 2020-06-21 | Washington | Alabama | 1129 | 95 | 6 |
258898 | 258898 | 2020-06-21 | Wilcox | Alabama | 1131 | 246 | 8 |
258899 | 258899 | 2020-06-21 | Winston | Alabama | 1133 | 176 | 1 |
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);