ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
204 rows where date = "2020-03-11" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
state >30
- California 24
- Florida 15
- Washington 14
- Georgia 12
- Oregon 10
- Colorado 9
- Indiana 8
- New Jersey 8
- New York 8
- Texas 8
- Massachusetts 6
- Pennsylvania 6
- South Dakota 5
- Illinois 4
- Maryland 4
- Minnesota 4
- South Carolina 4
- Tennessee 4
- Utah 4
- Virginia 4
- Wisconsin 4
- Arizona 3
- Kentucky 3
- Louisiana 3
- New Mexico 3
- Iowa 2
- Michigan 2
- Nevada 2
- New Hampshire 2
- North Carolina 2
- …
fips >30
county >30
- Jefferson 5
- Douglas 3
- Johnson 3
- Montgomery 3
- Clark 2
- Fayette 2
- Lee 2
- Marion 2
- Middlesex 2
- Monroe 2
- Nassau 2
- Pierce 2
- Polk 2
- Suffolk 2
- Washington 2
- Wayne 2
- Adams 1
- Alachua 1
- Alameda 1
- Anoka 1
- Arapahoe 1
- Arlington 1
- Baltimore 1
- Bartow 1
- Beadle 1
- Bennington 1
- Bergen 1
- Berkshire 1
- Bernalillo 1
- Bexar 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1161 | 1161 | 2020-03-11 | Maricopa | Arizona | 4013 | 3 | 0 |
1162 | 1162 | 2020-03-11 | Pima | Arizona | 4019 | 1 | 0 |
1163 | 1163 | 2020-03-11 | Pinal | Arizona | 4021 | 5 | 0 |
1164 | 1164 | 2020-03-11 | Jefferson | Arkansas | 5069 | 1 | 0 |
1165 | 1165 | 2020-03-11 | Alameda | California | 6001 | 25 | 0 |
1166 | 1166 | 2020-03-11 | Contra Costa | California | 6013 | 9 | 0 |
1167 | 1167 | 2020-03-11 | Fresno | California | 6019 | 1 | 0 |
1168 | 1168 | 2020-03-11 | Humboldt | California | 6023 | 1 | 0 |
1169 | 1169 | 2020-03-11 | Los Angeles | California | 6037 | 28 | 1 |
1170 | 1170 | 2020-03-11 | Madera | California | 6039 | 1 | 0 |
1171 | 1171 | 2020-03-11 | Marin | California | 6041 | 4 | 0 |
1172 | 1172 | 2020-03-11 | Napa | California | 6055 | 1 | 0 |
1173 | 1173 | 2020-03-11 | Orange | California | 6059 | 6 | 0 |
1174 | 1174 | 2020-03-11 | Placer | California | 6061 | 7 | 1 |
1175 | 1175 | 2020-03-11 | Riverside | California | 6065 | 4 | 0 |
1176 | 1176 | 2020-03-11 | Sacramento | California | 6067 | 9 | 1 |
1177 | 1177 | 2020-03-11 | San Diego | California | 6073 | 2 | 0 |
1178 | 1178 | 2020-03-11 | San Francisco | California | 6075 | 17 | 0 |
1179 | 1179 | 2020-03-11 | San Joaquin | California | 6077 | 1 | 0 |
1180 | 1180 | 2020-03-11 | San Mateo | California | 6081 | 15 | 0 |
1181 | 1181 | 2020-03-11 | Santa Clara | California | 6085 | 48 | 1 |
1182 | 1182 | 2020-03-11 | Santa Cruz | California | 6087 | 2 | 0 |
1183 | 1183 | 2020-03-11 | Shasta | California | 6089 | 1 | 0 |
1184 | 1184 | 2020-03-11 | Solano | California | 6095 | 12 | 0 |
1185 | 1185 | 2020-03-11 | Sonoma | California | 6097 | 3 | 0 |
1186 | 1186 | 2020-03-11 | Stanislaus | California | 6099 | 2 | 0 |
1187 | 1187 | 2020-03-11 | Ventura | California | 6111 | 2 | 0 |
1188 | 1188 | 2020-03-11 | Yolo | California | 6113 | 1 | 0 |
1189 | 1189 | 2020-03-11 | Arapahoe | Colorado | 8005 | 3 | 0 |
1190 | 1190 | 2020-03-11 | Denver | Colorado | 8031 | 6 | 0 |
1191 | 1191 | 2020-03-11 | Douglas | Colorado | 8035 | 3 | 0 |
1192 | 1192 | 2020-03-11 | Eagle | Colorado | 8037 | 4 | 0 |
1193 | 1193 | 2020-03-11 | El Paso | Colorado | 8041 | 1 | 0 |
1194 | 1194 | 2020-03-11 | Gunnison | Colorado | 8051 | 3 | 0 |
1195 | 1195 | 2020-03-11 | Jefferson | Colorado | 8059 | 4 | 0 |
1196 | 1196 | 2020-03-11 | Larimer | Colorado | 8069 | 1 | 0 |
1197 | 1197 | 2020-03-11 | Pitkin | Colorado | 8097 | 9 | 0 |
1198 | 1198 | 2020-03-11 | Fairfield | Connecticut | 9001 | 3 | 0 |
1199 | 1199 | 2020-03-11 | New Castle | Delaware | 10003 | 1 | 0 |
1200 | 1200 | 2020-03-11 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1201 | 1201 | 2020-03-11 | Alachua | Florida | 12001 | 1 | 0 |
1202 | 1202 | 2020-03-11 | Broward | Florida | 12011 | 5 | 0 |
1203 | 1203 | 2020-03-11 | Charlotte | Florida | 12015 | 1 | 0 |
1204 | 1204 | 2020-03-11 | Collier | Florida | 12021 | 3 | 0 |
1205 | 1205 | 2020-03-11 | Hillsborough | Florida | 12057 | 2 | 0 |
1206 | 1206 | 2020-03-11 | Lee | Florida | 12071 | 2 | 1 |
1207 | 1207 | 2020-03-11 | Manatee | Florida | 12081 | 2 | 0 |
1208 | 1208 | 2020-03-11 | Miami-Dade | Florida | 12086 | 1 | 0 |
1209 | 1209 | 2020-03-11 | Nassau | Florida | 12089 | 1 | 0 |
1210 | 1210 | 2020-03-11 | Okaloosa | Florida | 12091 | 1 | 0 |
1211 | 1211 | 2020-03-11 | Pasco | Florida | 12101 | 1 | 0 |
1212 | 1212 | 2020-03-11 | Pinellas | Florida | 12103 | 2 | 0 |
1213 | 1213 | 2020-03-11 | Santa Rosa | Florida | 12113 | 1 | 1 |
1214 | 1214 | 2020-03-11 | St. Johns | Florida | 12109 | 1 | 0 |
1215 | 1215 | 2020-03-11 | Volusia | Florida | 12127 | 2 | 0 |
1216 | 1216 | 2020-03-11 | Bartow | Georgia | 13015 | 3 | 0 |
1217 | 1217 | 2020-03-11 | Charlton | Georgia | 13049 | 1 | 0 |
1218 | 1218 | 2020-03-11 | Cherokee | Georgia | 13057 | 1 | 0 |
1219 | 1219 | 2020-03-11 | Cobb | Georgia | 13067 | 8 | 0 |
1220 | 1220 | 2020-03-11 | DeKalb | Georgia | 13089 | 4 | 0 |
1221 | 1221 | 2020-03-11 | Fayette | Georgia | 13113 | 1 | 0 |
1222 | 1222 | 2020-03-11 | Floyd | Georgia | 13115 | 2 | 0 |
1223 | 1223 | 2020-03-11 | Fulton | Georgia | 13121 | 6 | 0 |
1224 | 1224 | 2020-03-11 | Gwinnett | Georgia | 13135 | 2 | 0 |
1225 | 1225 | 2020-03-11 | Lee | Georgia | 13177 | 1 | 0 |
1226 | 1226 | 2020-03-11 | Lowndes | Georgia | 13185 | 1 | 0 |
1227 | 1227 | 2020-03-11 | Polk | Georgia | 13233 | 1 | 0 |
1228 | 1228 | 2020-03-11 | Honolulu | Hawaii | 15003 | 2 | 0 |
1229 | 1229 | 2020-03-11 | Cook | Illinois | 17031 | 22 | 0 |
1230 | 1230 | 2020-03-11 | Kane | Illinois | 17089 | 1 | 0 |
1231 | 1231 | 2020-03-11 | Lake | Illinois | 17097 | 1 | 0 |
1232 | 1232 | 2020-03-11 | McHenry | Illinois | 17111 | 1 | 0 |
1233 | 1233 | 2020-03-11 | Adams | Indiana | 18001 | 1 | 0 |
1234 | 1234 | 2020-03-11 | Boone | Indiana | 18011 | 1 | 0 |
1235 | 1235 | 2020-03-11 | Hendricks | Indiana | 18063 | 2 | 0 |
1236 | 1236 | 2020-03-11 | Howard | Indiana | 18067 | 1 | 0 |
1237 | 1237 | 2020-03-11 | Johnson | Indiana | 18081 | 3 | 0 |
1238 | 1238 | 2020-03-11 | Marion | Indiana | 18097 | 1 | 0 |
1239 | 1239 | 2020-03-11 | Noble | Indiana | 18113 | 1 | 0 |
1240 | 1240 | 2020-03-11 | St. Joseph | Indiana | 18141 | 1 | 0 |
1241 | 1241 | 2020-03-11 | Johnson | Iowa | 19103 | 13 | 0 |
1242 | 1242 | 2020-03-11 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1243 | 1243 | 2020-03-11 | Johnson | Kansas | 20091 | 1 | 0 |
1244 | 1244 | 2020-03-11 | Fayette | Kentucky | 21067 | 3 | 0 |
1245 | 1245 | 2020-03-11 | Harrison | Kentucky | 21097 | 3 | 0 |
1246 | 1246 | 2020-03-11 | Jefferson | Kentucky | 21111 | 1 | 0 |
1247 | 1247 | 2020-03-11 | Caddo | Louisiana | 22017 | 1 | 0 |
1248 | 1248 | 2020-03-11 | Jefferson | Louisiana | 22051 | 1 | 0 |
1249 | 1249 | 2020-03-11 | Orleans | Louisiana | 22071 | 11 | 0 |
1250 | 1250 | 2020-03-11 | Baltimore | Maryland | 24005 | 1 | 0 |
1251 | 1251 | 2020-03-11 | Harford | Maryland | 24025 | 1 | 0 |
1252 | 1252 | 2020-03-11 | Montgomery | Maryland | 24031 | 6 | 0 |
1253 | 1253 | 2020-03-11 | Prince George's | Maryland | 24033 | 5 | 0 |
1254 | 1254 | 2020-03-11 | Berkshire | Massachusetts | 25003 | 9 | 0 |
1255 | 1255 | 2020-03-11 | Essex | Massachusetts | 25009 | 1 | 0 |
1256 | 1256 | 2020-03-11 | Middlesex | Massachusetts | 25017 | 41 | 0 |
1257 | 1257 | 2020-03-11 | Norfolk | Massachusetts | 25021 | 22 | 0 |
1258 | 1258 | 2020-03-11 | Suffolk | Massachusetts | 25025 | 20 | 0 |
1259 | 1259 | 2020-03-11 | Worcester | Massachusetts | 25027 | 2 | 0 |
1260 | 1260 | 2020-03-11 | Oakland | Michigan | 26125 | 1 | 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);