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-04-12 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
51088 | 51088 | 2020-04-12 | Autauga | Alabama | 1001 | 19 | 1 |
51089 | 51089 | 2020-04-12 | Baldwin | Alabama | 1003 | 71 | 1 |
51090 | 51090 | 2020-04-12 | Barbour | Alabama | 1005 | 10 | 0 |
51091 | 51091 | 2020-04-12 | Bibb | Alabama | 1007 | 16 | 0 |
51092 | 51092 | 2020-04-12 | Blount | Alabama | 1009 | 13 | 0 |
51093 | 51093 | 2020-04-12 | Bullock | Alabama | 1011 | 4 | 0 |
51094 | 51094 | 2020-04-12 | Butler | Alabama | 1013 | 7 | 0 |
51095 | 51095 | 2020-04-12 | Calhoun | Alabama | 1015 | 60 | 0 |
51096 | 51096 | 2020-04-12 | Chambers | Alabama | 1017 | 200 | 8 |
51097 | 51097 | 2020-04-12 | Cherokee | Alabama | 1019 | 9 | 0 |
51098 | 51098 | 2020-04-12 | Chilton | Alabama | 1021 | 30 | 0 |
51099 | 51099 | 2020-04-12 | Choctaw | Alabama | 1023 | 10 | 0 |
51100 | 51100 | 2020-04-12 | Clarke | Alabama | 1025 | 19 | 0 |
51101 | 51101 | 2020-04-12 | Clay | Alabama | 1027 | 14 | 0 |
51102 | 51102 | 2020-04-12 | Cleburne | Alabama | 1029 | 12 | 0 |
51103 | 51103 | 2020-04-12 | Coffee | Alabama | 1031 | 32 | 0 |
51104 | 51104 | 2020-04-12 | Colbert | Alabama | 1033 | 9 | 1 |
51105 | 51105 | 2020-04-12 | Conecuh | Alabama | 1035 | 5 | 0 |
51106 | 51106 | 2020-04-12 | Coosa | Alabama | 1037 | 18 | 0 |
51107 | 51107 | 2020-04-12 | Covington | Alabama | 1039 | 13 | 0 |
51108 | 51108 | 2020-04-12 | Crenshaw | Alabama | 1041 | 3 | 0 |
51109 | 51109 | 2020-04-12 | Cullman | Alabama | 1043 | 39 | 1 |
51110 | 51110 | 2020-04-12 | Dale | Alabama | 1045 | 8 | 0 |
51111 | 51111 | 2020-04-12 | Dallas | Alabama | 1047 | 14 | 0 |
51112 | 51112 | 2020-04-12 | DeKalb | Alabama | 1049 | 26 | 0 |
51113 | 51113 | 2020-04-12 | Elmore | Alabama | 1051 | 33 | 0 |
51114 | 51114 | 2020-04-12 | Escambia | Alabama | 1053 | 8 | 0 |
51115 | 51115 | 2020-04-12 | Etowah | Alabama | 1055 | 77 | 7 |
51116 | 51116 | 2020-04-12 | Fayette | Alabama | 1057 | 4 | 0 |
51117 | 51117 | 2020-04-12 | Franklin | Alabama | 1059 | 10 | 0 |
51118 | 51118 | 2020-04-12 | Geneva | Alabama | 1061 | 1 | 0 |
51119 | 51119 | 2020-04-12 | Greene | Alabama | 1063 | 17 | 0 |
51120 | 51120 | 2020-04-12 | Hale | Alabama | 1065 | 15 | 0 |
51121 | 51121 | 2020-04-12 | Henry | Alabama | 1067 | 11 | 0 |
51122 | 51122 | 2020-04-12 | Houston | Alabama | 1069 | 44 | 1 |
51123 | 51123 | 2020-04-12 | Jackson | Alabama | 1071 | 25 | 2 |
51124 | 51124 | 2020-04-12 | Jefferson | Alabama | 1073 | 597 | 15 |
51125 | 51125 | 2020-04-12 | Lamar | Alabama | 1075 | 8 | 0 |
51126 | 51126 | 2020-04-12 | Lauderdale | Alabama | 1077 | 21 | 4 |
51127 | 51127 | 2020-04-12 | Lawrence | Alabama | 1079 | 8 | 0 |
51128 | 51128 | 2020-04-12 | Lee | Alabama | 1081 | 236 | 8 |
51129 | 51129 | 2020-04-12 | Limestone | Alabama | 1083 | 37 | 0 |
51130 | 51130 | 2020-04-12 | Lowndes | Alabama | 1085 | 14 | 0 |
51131 | 51131 | 2020-04-12 | Macon | Alabama | 1087 | 14 | 1 |
51132 | 51132 | 2020-04-12 | Madison | Alabama | 1089 | 187 | 3 |
51133 | 51133 | 2020-04-12 | Marengo | Alabama | 1091 | 21 | 1 |
51134 | 51134 | 2020-04-12 | Marion | Alabama | 1093 | 52 | 3 |
51135 | 51135 | 2020-04-12 | Marshall | Alabama | 1095 | 99 | 2 |
51136 | 51136 | 2020-04-12 | Mobile | Alabama | 1097 | 454 | 15 |
51137 | 51137 | 2020-04-12 | Monroe | Alabama | 1099 | 6 | 1 |
51138 | 51138 | 2020-04-12 | Montgomery | Alabama | 1101 | 120 | 4 |
51139 | 51139 | 2020-04-12 | Morgan | Alabama | 1103 | 39 | 0 |
51140 | 51140 | 2020-04-12 | Perry | Alabama | 1105 | 6 | 0 |
51141 | 51141 | 2020-04-12 | Pickens | Alabama | 1107 | 22 | 0 |
51142 | 51142 | 2020-04-12 | Pike | Alabama | 1109 | 20 | 0 |
51143 | 51143 | 2020-04-12 | Randolph | Alabama | 1111 | 36 | 4 |
51144 | 51144 | 2020-04-12 | Russell | Alabama | 1113 | 24 | 0 |
51145 | 51145 | 2020-04-12 | Shelby | Alabama | 1117 | 213 | 5 |
51146 | 51146 | 2020-04-12 | St. Clair | Alabama | 1115 | 42 | 0 |
51147 | 51147 | 2020-04-12 | Sumter | Alabama | 1119 | 20 | 0 |
51148 | 51148 | 2020-04-12 | Talladega | Alabama | 1121 | 34 | 0 |
51149 | 51149 | 2020-04-12 | Tallapoosa | Alabama | 1123 | 99 | 4 |
51150 | 51150 | 2020-04-12 | Tuscaloosa | Alabama | 1125 | 119 | 0 |
51151 | 51151 | 2020-04-12 | Walker | Alabama | 1127 | 83 | 0 |
51152 | 51152 | 2020-04-12 | Washington | Alabama | 1129 | 12 | 1 |
51153 | 51153 | 2020-04-12 | Wilcox | Alabama | 1131 | 30 | 0 |
51154 | 51154 | 2020-04-12 | Winston | Alabama | 1133 | 4 | 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);