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-06-17 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1426868 | 1426868 | 2021-06-17 | Autauga | Alabama | 1001 | 7230 | 113 |
1426869 | 1426869 | 2021-06-17 | Baldwin | Alabama | 1003 | 21839 | 313 |
1426870 | 1426870 | 2021-06-17 | Barbour | Alabama | 1005 | 2346 | 59 |
1426871 | 1426871 | 2021-06-17 | Bibb | Alabama | 1007 | 2684 | 64 |
1426872 | 1426872 | 2021-06-17 | Blount | Alabama | 1009 | 6944 | 139 |
1426873 | 1426873 | 2021-06-17 | Bullock | Alabama | 1011 | 1242 | 42 |
1426874 | 1426874 | 2021-06-17 | Butler | Alabama | 1013 | 2240 | 71 |
1426875 | 1426875 | 2021-06-17 | Calhoun | Alabama | 1015 | 14718 | 325 |
1426876 | 1426876 | 2021-06-17 | Chambers | Alabama | 1017 | 3726 | 124 |
1426877 | 1426877 | 2021-06-17 | Cherokee | Alabama | 1019 | 1872 | 45 |
1426878 | 1426878 | 2021-06-17 | Chilton | Alabama | 1021 | 4472 | 116 |
1426879 | 1426879 | 2021-06-17 | Choctaw | Alabama | 1023 | 620 | 25 |
1426880 | 1426880 | 2021-06-17 | Clarke | Alabama | 1025 | 3529 | 61 |
1426881 | 1426881 | 2021-06-17 | Clay | Alabama | 1027 | 1601 | 59 |
1426882 | 1426882 | 2021-06-17 | Cleburne | Alabama | 1029 | 1532 | 44 |
1426883 | 1426883 | 2021-06-17 | Coffee | Alabama | 1031 | 5627 | 127 |
1426884 | 1426884 | 2021-06-17 | Colbert | Alabama | 1033 | 6414 | 140 |
1426885 | 1426885 | 2021-06-17 | Conecuh | Alabama | 1035 | 1134 | 30 |
1426886 | 1426886 | 2021-06-17 | Coosa | Alabama | 1037 | 1114 | 29 |
1426887 | 1426887 | 2021-06-17 | Covington | Alabama | 1039 | 4273 | 122 |
1426888 | 1426888 | 2021-06-17 | Crenshaw | Alabama | 1041 | 1556 | 57 |
1426889 | 1426889 | 2021-06-17 | Cullman | Alabama | 1043 | 9941 | 201 |
1426890 | 1426890 | 2021-06-17 | Dale | Alabama | 1045 | 4929 | 114 |
1426891 | 1426891 | 2021-06-17 | Dallas | Alabama | 1047 | 3607 | 156 |
1426892 | 1426892 | 2021-06-17 | DeKalb | Alabama | 1049 | 8967 | 189 |
1426893 | 1426893 | 2021-06-17 | Elmore | Alabama | 1051 | 10295 | 213 |
1426894 | 1426894 | 2021-06-17 | Escambia | Alabama | 1053 | 4017 | 80 |
1426895 | 1426895 | 2021-06-17 | Etowah | Alabama | 1055 | 14171 | 363 |
1426896 | 1426896 | 2021-06-17 | Fayette | Alabama | 1057 | 2181 | 62 |
1426897 | 1426897 | 2021-06-17 | Franklin | Alabama | 1059 | 4310 | 83 |
1426898 | 1426898 | 2021-06-17 | Geneva | Alabama | 1061 | 2575 | 81 |
1426899 | 1426899 | 2021-06-17 | Greene | Alabama | 1063 | 935 | 34 |
1426900 | 1426900 | 2021-06-17 | Hale | Alabama | 1065 | 2268 | 78 |
1426901 | 1426901 | 2021-06-17 | Henry | Alabama | 1067 | 1938 | 43 |
1426902 | 1426902 | 2021-06-17 | Houston | Alabama | 1069 | 10764 | 288 |
1426903 | 1426903 | 2021-06-17 | Jackson | Alabama | 1071 | 6922 | 113 |
1426904 | 1426904 | 2021-06-17 | Jefferson | Alabama | 1073 | 80953 | 1565 |
1426905 | 1426905 | 2021-06-17 | Lamar | Alabama | 1075 | 1465 | 37 |
1426906 | 1426906 | 2021-06-17 | Lauderdale | Alabama | 1077 | 9596 | 249 |
1426907 | 1426907 | 2021-06-17 | Lawrence | Alabama | 1079 | 3129 | 100 |
1426908 | 1426908 | 2021-06-17 | Lee | Alabama | 1081 | 16265 | 176 |
1426909 | 1426909 | 2021-06-17 | Limestone | Alabama | 1083 | 10182 | 157 |
1426910 | 1426910 | 2021-06-17 | Lowndes | Alabama | 1085 | 1420 | 54 |
1426911 | 1426911 | 2021-06-17 | Macon | Alabama | 1087 | 1629 | 51 |
1426912 | 1426912 | 2021-06-17 | Madison | Alabama | 1089 | 35663 | 525 |
1426913 | 1426913 | 2021-06-17 | Marengo | Alabama | 1091 | 2506 | 65 |
1426914 | 1426914 | 2021-06-17 | Marion | Alabama | 1093 | 3242 | 106 |
1426915 | 1426915 | 2021-06-17 | Marshall | Alabama | 1095 | 12449 | 230 |
1426916 | 1426916 | 2021-06-17 | Mobile | Alabama | 1097 | 42066 | 826 |
1426917 | 1426917 | 2021-06-17 | Monroe | Alabama | 1099 | 1793 | 41 |
1426918 | 1426918 | 2021-06-17 | Montgomery | Alabama | 1101 | 25081 | 612 |
1426919 | 1426919 | 2021-06-17 | Morgan | Alabama | 1103 | 14626 | 285 |
1426920 | 1426920 | 2021-06-17 | Perry | Alabama | 1105 | 1086 | 26 |
1426921 | 1426921 | 2021-06-17 | Pickens | Alabama | 1107 | 2368 | 62 |
1426922 | 1426922 | 2021-06-17 | Pike | Alabama | 1109 | 3140 | 78 |
1426923 | 1426923 | 2021-06-17 | Randolph | Alabama | 1111 | 1870 | 44 |
1426924 | 1426924 | 2021-06-17 | Russell | Alabama | 1113 | 4549 | 41 |
1426925 | 1426925 | 2021-06-17 | Shelby | Alabama | 1117 | 25595 | 254 |
1426926 | 1426926 | 2021-06-17 | St. Clair | Alabama | 1115 | 10160 | 251 |
1426927 | 1426927 | 2021-06-17 | Sumter | Alabama | 1119 | 1057 | 32 |
1426928 | 1426928 | 2021-06-17 | Talladega | Alabama | 1121 | 8458 | 184 |
1426929 | 1426929 | 2021-06-17 | Tallapoosa | Alabama | 1123 | 4136 | 155 |
1426930 | 1426930 | 2021-06-17 | Tuscaloosa | Alabama | 1125 | 26162 | 458 |
1426931 | 1426931 | 2021-06-17 | Walker | Alabama | 1127 | 7335 | 280 |
1426932 | 1426932 | 2021-06-17 | Washington | Alabama | 1129 | 1704 | 39 |
1426933 | 1426933 | 2021-06-17 | Wilcox | Alabama | 1131 | 1270 | 30 |
1426934 | 1426934 | 2021-06-17 | Winston | Alabama | 1133 | 2835 | 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);