ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-04-24" 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 |
---|---|---|---|---|---|---|---|
84049 | 84049 | 2020-04-24 | Autauga | Alabama | 1001 | 36 | 2 |
84050 | 84050 | 2020-04-24 | Baldwin | Alabama | 1003 | 147 | 3 |
84051 | 84051 | 2020-04-24 | Barbour | Alabama | 1005 | 32 | 0 |
84052 | 84052 | 2020-04-24 | Bibb | Alabama | 1007 | 34 | 0 |
84053 | 84053 | 2020-04-24 | Blount | Alabama | 1009 | 31 | 0 |
84054 | 84054 | 2020-04-24 | Bullock | Alabama | 1011 | 12 | 0 |
84055 | 84055 | 2020-04-24 | Butler | Alabama | 1013 | 21 | 0 |
84056 | 84056 | 2020-04-24 | Calhoun | Alabama | 1015 | 89 | 3 |
84057 | 84057 | 2020-04-24 | Chambers | Alabama | 1017 | 282 | 17 |
84058 | 84058 | 2020-04-24 | Cherokee | Alabama | 1019 | 12 | 0 |
84059 | 84059 | 2020-04-24 | Chilton | Alabama | 1021 | 49 | 1 |
84060 | 84060 | 2020-04-24 | Choctaw | Alabama | 1023 | 25 | 0 |
84061 | 84061 | 2020-04-24 | Clarke | Alabama | 1025 | 24 | 1 |
84062 | 84062 | 2020-04-24 | Clay | Alabama | 1027 | 19 | 1 |
84063 | 84063 | 2020-04-24 | Cleburne | Alabama | 1029 | 12 | 1 |
84064 | 84064 | 2020-04-24 | Coffee | Alabama | 1031 | 87 | 0 |
84065 | 84065 | 2020-04-24 | Colbert | Alabama | 1033 | 23 | 2 |
84066 | 84066 | 2020-04-24 | Conecuh | Alabama | 1035 | 9 | 0 |
84067 | 84067 | 2020-04-24 | Coosa | Alabama | 1037 | 29 | 1 |
84068 | 84068 | 2020-04-24 | Covington | Alabama | 1039 | 31 | 0 |
84069 | 84069 | 2020-04-24 | Crenshaw | Alabama | 1041 | 10 | 0 |
84070 | 84070 | 2020-04-24 | Cullman | Alabama | 1043 | 47 | 0 |
84071 | 84071 | 2020-04-24 | Dale | Alabama | 1045 | 23 | 0 |
84072 | 84072 | 2020-04-24 | Dallas | Alabama | 1047 | 32 | 2 |
84073 | 84073 | 2020-04-24 | DeKalb | Alabama | 1049 | 61 | 2 |
84074 | 84074 | 2020-04-24 | Elmore | Alabama | 1051 | 74 | 1 |
84075 | 84075 | 2020-04-24 | Escambia | Alabama | 1053 | 22 | 1 |
84076 | 84076 | 2020-04-24 | Etowah | Alabama | 1055 | 121 | 8 |
84077 | 84077 | 2020-04-24 | Fayette | Alabama | 1057 | 4 | 0 |
84078 | 84078 | 2020-04-24 | Franklin | Alabama | 1059 | 32 | 0 |
84079 | 84079 | 2020-04-24 | Geneva | Alabama | 1061 | 6 | 0 |
84080 | 84080 | 2020-04-24 | Greene | Alabama | 1063 | 44 | 0 |
84081 | 84081 | 2020-04-24 | Hale | Alabama | 1065 | 39 | 2 |
84082 | 84082 | 2020-04-24 | Henry | Alabama | 1067 | 22 | 1 |
84083 | 84083 | 2020-04-24 | Houston | Alabama | 1069 | 76 | 3 |
84084 | 84084 | 2020-04-24 | Jackson | Alabama | 1071 | 45 | 2 |
84085 | 84085 | 2020-04-24 | Jefferson | Alabama | 1073 | 797 | 33 |
84086 | 84086 | 2020-04-24 | Lamar | Alabama | 1075 | 10 | 0 |
84087 | 84087 | 2020-04-24 | Lauderdale | Alabama | 1077 | 25 | 2 |
84088 | 84088 | 2020-04-24 | Lawrence | Alabama | 1079 | 12 | 0 |
84089 | 84089 | 2020-04-24 | Lee | Alabama | 1081 | 351 | 22 |
84090 | 84090 | 2020-04-24 | Limestone | Alabama | 1083 | 41 | 0 |
84091 | 84091 | 2020-04-24 | Lowndes | Alabama | 1085 | 36 | 1 |
84092 | 84092 | 2020-04-24 | Macon | Alabama | 1087 | 29 | 2 |
84093 | 84093 | 2020-04-24 | Madison | Alabama | 1089 | 202 | 4 |
84094 | 84094 | 2020-04-24 | Marengo | Alabama | 1091 | 39 | 3 |
84095 | 84095 | 2020-04-24 | Marion | Alabama | 1093 | 69 | 5 |
84096 | 84096 | 2020-04-24 | Marshall | Alabama | 1095 | 267 | 4 |
84097 | 84097 | 2020-04-24 | Mobile | Alabama | 1097 | 845 | 40 |
84098 | 84098 | 2020-04-24 | Monroe | Alabama | 1099 | 11 | 1 |
84099 | 84099 | 2020-04-24 | Montgomery | Alabama | 1101 | 274 | 4 |
84100 | 84100 | 2020-04-24 | Morgan | Alabama | 1103 | 55 | 0 |
84101 | 84101 | 2020-04-24 | Perry | Alabama | 1105 | 9 | 0 |
84102 | 84102 | 2020-04-24 | Pickens | Alabama | 1107 | 45 | 1 |
84103 | 84103 | 2020-04-24 | Pike | Alabama | 1109 | 58 | 0 |
84104 | 84104 | 2020-04-24 | Randolph | Alabama | 1111 | 60 | 4 |
84105 | 84105 | 2020-04-24 | Russell | Alabama | 1113 | 53 | 0 |
84106 | 84106 | 2020-04-24 | Shelby | Alabama | 1117 | 294 | 7 |
84107 | 84107 | 2020-04-24 | St. Clair | Alabama | 1115 | 63 | 0 |
84108 | 84108 | 2020-04-24 | Sumter | Alabama | 1119 | 51 | 1 |
84109 | 84109 | 2020-04-24 | Talladega | Alabama | 1121 | 54 | 2 |
84110 | 84110 | 2020-04-24 | Tallapoosa | Alabama | 1123 | 261 | 17 |
84111 | 84111 | 2020-04-24 | Tuscaloosa | Alabama | 1125 | 182 | 0 |
84112 | 84112 | 2020-04-24 | Walker | Alabama | 1127 | 89 | 0 |
84113 | 84113 | 2020-04-24 | Washington | Alabama | 1129 | 19 | 1 |
84114 | 84114 | 2020-04-24 | Wilcox | Alabama | 1131 | 53 | 1 |
84115 | 84115 | 2020-04-24 | Winston | Alabama | 1133 | 10 | 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);