ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 19021 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417935 | 1417935 | 2021-06-14 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1414689 | 1414689 | 2021-06-13 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1411444 | 1411444 | 2021-06-12 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1408199 | 1408199 | 2021-06-11 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1404953 | 1404953 | 2021-06-10 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1401708 | 1401708 | 2021-06-09 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1398463 | 1398463 | 2021-06-08 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1395216 | 1395216 | 2021-06-07 | Buena Vista | Iowa | 19021 | 4261 | 40 |
1391971 | 1391971 | 2021-06-06 | Buena Vista | Iowa | 19021 | 4260 | 40 |
1388726 | 1388726 | 2021-06-05 | Buena Vista | Iowa | 19021 | 4259 | 40 |
1385481 | 1385481 | 2021-06-04 | Buena Vista | Iowa | 19021 | 4260 | 40 |
1382235 | 1382235 | 2021-06-03 | Buena Vista | Iowa | 19021 | 4260 | 40 |
1378990 | 1378990 | 2021-06-02 | Buena Vista | Iowa | 19021 | 4259 | 40 |
1375744 | 1375744 | 2021-06-01 | Buena Vista | Iowa | 19021 | 4257 | 40 |
1372499 | 1372499 | 2021-05-31 | Buena Vista | Iowa | 19021 | 4255 | 40 |
1369254 | 1369254 | 2021-05-30 | Buena Vista | Iowa | 19021 | 4256 | 40 |
1366008 | 1366008 | 2021-05-29 | Buena Vista | Iowa | 19021 | 4256 | 40 |
1362762 | 1362762 | 2021-05-28 | Buena Vista | Iowa | 19021 | 4256 | 40 |
1359515 | 1359515 | 2021-05-27 | Buena Vista | Iowa | 19021 | 4255 | 40 |
1356269 | 1356269 | 2021-05-26 | Buena Vista | Iowa | 19021 | 4255 | 40 |
1353023 | 1353023 | 2021-05-25 | Buena Vista | Iowa | 19021 | 4254 | 40 |
1349777 | 1349777 | 2021-05-24 | Buena Vista | Iowa | 19021 | 4252 | 40 |
1346530 | 1346530 | 2021-05-23 | Buena Vista | Iowa | 19021 | 4252 | 40 |
1343282 | 1343282 | 2021-05-22 | Buena Vista | Iowa | 19021 | 4250 | 40 |
1340034 | 1340034 | 2021-05-21 | Buena Vista | Iowa | 19021 | 4249 | 40 |
1336787 | 1336787 | 2021-05-20 | Buena Vista | Iowa | 19021 | 4250 | 40 |
1333540 | 1333540 | 2021-05-19 | Buena Vista | Iowa | 19021 | 4249 | 40 |
1330293 | 1330293 | 2021-05-18 | Buena Vista | Iowa | 19021 | 4249 | 40 |
1327046 | 1327046 | 2021-05-17 | Buena Vista | Iowa | 19021 | 4249 | 40 |
1323800 | 1323800 | 2021-05-16 | Buena Vista | Iowa | 19021 | 4249 | 40 |
1320554 | 1320554 | 2021-05-15 | Buena Vista | Iowa | 19021 | 4247 | 40 |
1317307 | 1317307 | 2021-05-14 | Buena Vista | Iowa | 19021 | 4247 | 40 |
1314060 | 1314060 | 2021-05-13 | Buena Vista | Iowa | 19021 | 4246 | 40 |
1310813 | 1310813 | 2021-05-12 | Buena Vista | Iowa | 19021 | 4245 | 40 |
1307567 | 1307567 | 2021-05-11 | Buena Vista | Iowa | 19021 | 4245 | 40 |
1304321 | 1304321 | 2021-05-10 | Buena Vista | Iowa | 19021 | 4245 | 40 |
1301074 | 1301074 | 2021-05-09 | Buena Vista | Iowa | 19021 | 4241 | 40 |
1297827 | 1297827 | 2021-05-08 | Buena Vista | Iowa | 19021 | 4241 | 40 |
1294581 | 1294581 | 2021-05-07 | Buena Vista | Iowa | 19021 | 4241 | 40 |
1291335 | 1291335 | 2021-05-06 | Buena Vista | Iowa | 19021 | 4240 | 40 |
1288089 | 1288089 | 2021-05-05 | Buena Vista | Iowa | 19021 | 4240 | 40 |
1284843 | 1284843 | 2021-05-04 | Buena Vista | Iowa | 19021 | 4240 | 40 |
1281596 | 1281596 | 2021-05-03 | Buena Vista | Iowa | 19021 | 4240 | 40 |
1278349 | 1278349 | 2021-05-02 | Buena Vista | Iowa | 19021 | 4239 | 40 |
1275102 | 1275102 | 2021-05-01 | Buena Vista | Iowa | 19021 | 4238 | 40 |
1271855 | 1271855 | 2021-04-30 | Buena Vista | Iowa | 19021 | 4238 | 40 |
1268608 | 1268608 | 2021-04-29 | Buena Vista | Iowa | 19021 | 4237 | 40 |
1265361 | 1265361 | 2021-04-28 | Buena Vista | Iowa | 19021 | 4236 | 40 |
1262114 | 1262114 | 2021-04-27 | Buena Vista | Iowa | 19021 | 4233 | 40 |
1258867 | 1258867 | 2021-04-26 | Buena Vista | Iowa | 19021 | 4231 | 40 |
1255620 | 1255620 | 2021-04-25 | Buena Vista | Iowa | 19021 | 4231 | 40 |
1252373 | 1252373 | 2021-04-24 | Buena Vista | Iowa | 19021 | 4228 | 40 |
1249126 | 1249126 | 2021-04-23 | Buena Vista | Iowa | 19021 | 4227 | 40 |
1245879 | 1245879 | 2021-04-22 | Buena Vista | Iowa | 19021 | 4226 | 40 |
1242632 | 1242632 | 2021-04-21 | Buena Vista | Iowa | 19021 | 4220 | 40 |
1239385 | 1239385 | 2021-04-20 | Buena Vista | Iowa | 19021 | 4219 | 40 |
1236138 | 1236138 | 2021-04-19 | Buena Vista | Iowa | 19021 | 4220 | 40 |
1232891 | 1232891 | 2021-04-18 | Buena Vista | Iowa | 19021 | 4218 | 40 |
1229642 | 1229642 | 2021-04-17 | Buena Vista | Iowa | 19021 | 4217 | 40 |
1226394 | 1226394 | 2021-04-16 | Buena Vista | Iowa | 19021 | 4216 | 40 |
1223147 | 1223147 | 2021-04-15 | Buena Vista | Iowa | 19021 | 4214 | 40 |
1219899 | 1219899 | 2021-04-14 | Buena Vista | Iowa | 19021 | 4214 | 40 |
1216651 | 1216651 | 2021-04-13 | Buena Vista | Iowa | 19021 | 4215 | 40 |
1213404 | 1213404 | 2021-04-12 | Buena Vista | Iowa | 19021 | 4212 | 40 |
1210156 | 1210156 | 2021-04-11 | Buena Vista | Iowa | 19021 | 4211 | 40 |
1206907 | 1206907 | 2021-04-10 | Buena Vista | Iowa | 19021 | 4207 | 40 |
1203659 | 1203659 | 2021-04-09 | Buena Vista | Iowa | 19021 | 4207 | 40 |
1200411 | 1200411 | 2021-04-08 | Buena Vista | Iowa | 19021 | 4207 | 40 |
1197162 | 1197162 | 2021-04-07 | Buena Vista | Iowa | 19021 | 4203 | 40 |
1193914 | 1193914 | 2021-04-06 | Buena Vista | Iowa | 19021 | 4202 | 40 |
1190664 | 1190664 | 2021-04-05 | Buena Vista | Iowa | 19021 | 4200 | 40 |
1187417 | 1187417 | 2021-04-04 | Buena Vista | Iowa | 19021 | 4195 | 40 |
1184170 | 1184170 | 2021-04-03 | Buena Vista | Iowa | 19021 | 4194 | 40 |
1180923 | 1180923 | 2021-04-02 | Buena Vista | Iowa | 19021 | 4192 | 39 |
1177676 | 1177676 | 2021-04-01 | Buena Vista | Iowa | 19021 | 4189 | 39 |
1174429 | 1174429 | 2021-03-31 | Buena Vista | Iowa | 19021 | 4187 | 39 |
1171182 | 1171182 | 2021-03-30 | Buena Vista | Iowa | 19021 | 4182 | 39 |
1167934 | 1167934 | 2021-03-29 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1164686 | 1164686 | 2021-03-28 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1161438 | 1161438 | 2021-03-27 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1158190 | 1158190 | 2021-03-26 | Buena Vista | Iowa | 19021 | 4179 | 39 |
1154943 | 1154943 | 2021-03-25 | Buena Vista | Iowa | 19021 | 4178 | 39 |
1151696 | 1151696 | 2021-03-24 | Buena Vista | Iowa | 19021 | 4173 | 39 |
1148449 | 1148449 | 2021-03-23 | Buena Vista | Iowa | 19021 | 4172 | 39 |
1145202 | 1145202 | 2021-03-22 | Buena Vista | Iowa | 19021 | 4169 | 38 |
1141955 | 1141955 | 2021-03-21 | Buena Vista | Iowa | 19021 | 4166 | 38 |
1138709 | 1138709 | 2021-03-20 | Buena Vista | Iowa | 19021 | 4166 | 38 |
1135463 | 1135463 | 2021-03-19 | Buena Vista | Iowa | 19021 | 4163 | 38 |
1132216 | 1132216 | 2021-03-18 | Buena Vista | Iowa | 19021 | 4160 | 38 |
1128968 | 1128968 | 2021-03-17 | Buena Vista | Iowa | 19021 | 4159 | 38 |
1125722 | 1125722 | 2021-03-16 | Buena Vista | Iowa | 19021 | 4156 | 38 |
1122476 | 1122476 | 2021-03-15 | Buena Vista | Iowa | 19021 | 4152 | 37 |
1119229 | 1119229 | 2021-03-14 | Buena Vista | Iowa | 19021 | 4149 | 37 |
1115982 | 1115982 | 2021-03-13 | Buena Vista | Iowa | 19021 | 4148 | 37 |
1112736 | 1112736 | 2021-03-12 | Buena Vista | Iowa | 19021 | 4144 | 37 |
1109490 | 1109490 | 2021-03-11 | Buena Vista | Iowa | 19021 | 4140 | 37 |
1106244 | 1106244 | 2021-03-10 | Buena Vista | Iowa | 19021 | 4138 | 37 |
1102998 | 1102998 | 2021-03-09 | Buena Vista | Iowa | 19021 | 4135 | 37 |
1099752 | 1099752 | 2021-03-08 | Buena Vista | Iowa | 19021 | 4133 | 37 |
1096504 | 1096504 | 2021-03-07 | Buena Vista | Iowa | 19021 | 4126 | 37 |
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);