ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Wapello" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418015 | 1418015 | 2021-06-14 | Wapello | Iowa | 19179 | 4335 | 122 |
1414769 | 1414769 | 2021-06-13 | Wapello | Iowa | 19179 | 4333 | 122 |
1411524 | 1411524 | 2021-06-12 | Wapello | Iowa | 19179 | 4333 | 122 |
1408279 | 1408279 | 2021-06-11 | Wapello | Iowa | 19179 | 4333 | 122 |
1405033 | 1405033 | 2021-06-10 | Wapello | Iowa | 19179 | 4334 | 122 |
1401788 | 1401788 | 2021-06-09 | Wapello | Iowa | 19179 | 4331 | 122 |
1398543 | 1398543 | 2021-06-08 | Wapello | Iowa | 19179 | 4331 | 122 |
1395296 | 1395296 | 2021-06-07 | Wapello | Iowa | 19179 | 4331 | 122 |
1392051 | 1392051 | 2021-06-06 | Wapello | Iowa | 19179 | 4328 | 122 |
1388806 | 1388806 | 2021-06-05 | Wapello | Iowa | 19179 | 4328 | 122 |
1385561 | 1385561 | 2021-06-04 | Wapello | Iowa | 19179 | 4328 | 122 |
1382315 | 1382315 | 2021-06-03 | Wapello | Iowa | 19179 | 4328 | 122 |
1379070 | 1379070 | 2021-06-02 | Wapello | Iowa | 19179 | 4327 | 122 |
1375824 | 1375824 | 2021-06-01 | Wapello | Iowa | 19179 | 4328 | 122 |
1372579 | 1372579 | 2021-05-31 | Wapello | Iowa | 19179 | 4325 | 122 |
1369334 | 1369334 | 2021-05-30 | Wapello | Iowa | 19179 | 4326 | 122 |
1366088 | 1366088 | 2021-05-29 | Wapello | Iowa | 19179 | 4325 | 122 |
1362842 | 1362842 | 2021-05-28 | Wapello | Iowa | 19179 | 4325 | 122 |
1359595 | 1359595 | 2021-05-27 | Wapello | Iowa | 19179 | 4325 | 122 |
1356349 | 1356349 | 2021-05-26 | Wapello | Iowa | 19179 | 4324 | 122 |
1353103 | 1353103 | 2021-05-25 | Wapello | Iowa | 19179 | 4321 | 122 |
1349857 | 1349857 | 2021-05-24 | Wapello | Iowa | 19179 | 4320 | 122 |
1346610 | 1346610 | 2021-05-23 | Wapello | Iowa | 19179 | 4319 | 122 |
1343362 | 1343362 | 2021-05-22 | Wapello | Iowa | 19179 | 4319 | 122 |
1340114 | 1340114 | 2021-05-21 | Wapello | Iowa | 19179 | 4320 | 122 |
1336867 | 1336867 | 2021-05-20 | Wapello | Iowa | 19179 | 4317 | 122 |
1333620 | 1333620 | 2021-05-19 | Wapello | Iowa | 19179 | 4316 | 122 |
1330373 | 1330373 | 2021-05-18 | Wapello | Iowa | 19179 | 4311 | 122 |
1327126 | 1327126 | 2021-05-17 | Wapello | Iowa | 19179 | 4306 | 122 |
1323880 | 1323880 | 2021-05-16 | Wapello | Iowa | 19179 | 4303 | 122 |
1320634 | 1320634 | 2021-05-15 | Wapello | Iowa | 19179 | 4302 | 122 |
1317387 | 1317387 | 2021-05-14 | Wapello | Iowa | 19179 | 4299 | 122 |
1314140 | 1314140 | 2021-05-13 | Wapello | Iowa | 19179 | 4300 | 122 |
1310893 | 1310893 | 2021-05-12 | Wapello | Iowa | 19179 | 4299 | 122 |
1307647 | 1307647 | 2021-05-11 | Wapello | Iowa | 19179 | 4298 | 122 |
1304401 | 1304401 | 2021-05-10 | Wapello | Iowa | 19179 | 4291 | 122 |
1301154 | 1301154 | 2021-05-09 | Wapello | Iowa | 19179 | 4288 | 122 |
1297907 | 1297907 | 2021-05-08 | Wapello | Iowa | 19179 | 4287 | 122 |
1294661 | 1294661 | 2021-05-07 | Wapello | Iowa | 19179 | 4287 | 122 |
1291415 | 1291415 | 2021-05-06 | Wapello | Iowa | 19179 | 4286 | 122 |
1288169 | 1288169 | 2021-05-05 | Wapello | Iowa | 19179 | 4283 | 122 |
1284923 | 1284923 | 2021-05-04 | Wapello | Iowa | 19179 | 4278 | 122 |
1281676 | 1281676 | 2021-05-03 | Wapello | Iowa | 19179 | 4272 | 122 |
1278429 | 1278429 | 2021-05-02 | Wapello | Iowa | 19179 | 4271 | 122 |
1275182 | 1275182 | 2021-05-01 | Wapello | Iowa | 19179 | 4267 | 122 |
1271935 | 1271935 | 2021-04-30 | Wapello | Iowa | 19179 | 4266 | 122 |
1268688 | 1268688 | 2021-04-29 | Wapello | Iowa | 19179 | 4264 | 122 |
1265441 | 1265441 | 2021-04-28 | Wapello | Iowa | 19179 | 4263 | 122 |
1262194 | 1262194 | 2021-04-27 | Wapello | Iowa | 19179 | 4262 | 122 |
1258947 | 1258947 | 2021-04-26 | Wapello | Iowa | 19179 | 4260 | 122 |
1255700 | 1255700 | 2021-04-25 | Wapello | Iowa | 19179 | 4259 | 122 |
1252453 | 1252453 | 2021-04-24 | Wapello | Iowa | 19179 | 4258 | 122 |
1249206 | 1249206 | 2021-04-23 | Wapello | Iowa | 19179 | 4258 | 121 |
1245959 | 1245959 | 2021-04-22 | Wapello | Iowa | 19179 | 4255 | 121 |
1242712 | 1242712 | 2021-04-21 | Wapello | Iowa | 19179 | 4255 | 121 |
1239465 | 1239465 | 2021-04-20 | Wapello | Iowa | 19179 | 4255 | 120 |
1236218 | 1236218 | 2021-04-19 | Wapello | Iowa | 19179 | 4254 | 120 |
1232971 | 1232971 | 2021-04-18 | Wapello | Iowa | 19179 | 4254 | 120 |
1229722 | 1229722 | 2021-04-17 | Wapello | Iowa | 19179 | 4253 | 120 |
1226474 | 1226474 | 2021-04-16 | Wapello | Iowa | 19179 | 4251 | 120 |
1223227 | 1223227 | 2021-04-15 | Wapello | Iowa | 19179 | 4250 | 120 |
1219979 | 1219979 | 2021-04-14 | Wapello | Iowa | 19179 | 4250 | 120 |
1216731 | 1216731 | 2021-04-13 | Wapello | Iowa | 19179 | 4248 | 120 |
1213484 | 1213484 | 2021-04-12 | Wapello | Iowa | 19179 | 4246 | 120 |
1210236 | 1210236 | 2021-04-11 | Wapello | Iowa | 19179 | 4246 | 120 |
1206987 | 1206987 | 2021-04-10 | Wapello | Iowa | 19179 | 4243 | 120 |
1203739 | 1203739 | 2021-04-09 | Wapello | Iowa | 19179 | 4237 | 120 |
1200491 | 1200491 | 2021-04-08 | Wapello | Iowa | 19179 | 4233 | 120 |
1197242 | 1197242 | 2021-04-07 | Wapello | Iowa | 19179 | 4231 | 120 |
1193994 | 1193994 | 2021-04-06 | Wapello | Iowa | 19179 | 4230 | 120 |
1190744 | 1190744 | 2021-04-05 | Wapello | Iowa | 19179 | 4227 | 119 |
1187497 | 1187497 | 2021-04-04 | Wapello | Iowa | 19179 | 4226 | 119 |
1184250 | 1184250 | 2021-04-03 | Wapello | Iowa | 19179 | 4226 | 119 |
1181003 | 1181003 | 2021-04-02 | Wapello | Iowa | 19179 | 4225 | 118 |
1177756 | 1177756 | 2021-04-01 | Wapello | Iowa | 19179 | 4223 | 118 |
1174509 | 1174509 | 2021-03-31 | Wapello | Iowa | 19179 | 4219 | 116 |
1171262 | 1171262 | 2021-03-30 | Wapello | Iowa | 19179 | 4215 | 116 |
1168014 | 1168014 | 2021-03-29 | Wapello | Iowa | 19179 | 4209 | 116 |
1164766 | 1164766 | 2021-03-28 | Wapello | Iowa | 19179 | 4207 | 116 |
1161518 | 1161518 | 2021-03-27 | Wapello | Iowa | 19179 | 4204 | 116 |
1158270 | 1158270 | 2021-03-26 | Wapello | Iowa | 19179 | 4203 | 116 |
1155023 | 1155023 | 2021-03-25 | Wapello | Iowa | 19179 | 4200 | 115 |
1151776 | 1151776 | 2021-03-24 | Wapello | Iowa | 19179 | 4198 | 114 |
1148529 | 1148529 | 2021-03-23 | Wapello | Iowa | 19179 | 4194 | 114 |
1145282 | 1145282 | 2021-03-22 | Wapello | Iowa | 19179 | 4184 | 114 |
1142035 | 1142035 | 2021-03-21 | Wapello | Iowa | 19179 | 4180 | 114 |
1138789 | 1138789 | 2021-03-20 | Wapello | Iowa | 19179 | 4180 | 114 |
1135543 | 1135543 | 2021-03-19 | Wapello | Iowa | 19179 | 4171 | 114 |
1132296 | 1132296 | 2021-03-18 | Wapello | Iowa | 19179 | 4149 | 114 |
1129048 | 1129048 | 2021-03-17 | Wapello | Iowa | 19179 | 4141 | 114 |
1125802 | 1125802 | 2021-03-16 | Wapello | Iowa | 19179 | 4137 | 114 |
1122556 | 1122556 | 2021-03-15 | Wapello | Iowa | 19179 | 4131 | 114 |
1119309 | 1119309 | 2021-03-14 | Wapello | Iowa | 19179 | 4121 | 114 |
1116062 | 1116062 | 2021-03-13 | Wapello | Iowa | 19179 | 4117 | 112 |
1112816 | 1112816 | 2021-03-12 | Wapello | Iowa | 19179 | 4110 | 112 |
1109570 | 1109570 | 2021-03-11 | Wapello | Iowa | 19179 | 4101 | 112 |
1106324 | 1106324 | 2021-03-10 | Wapello | Iowa | 19179 | 4094 | 111 |
1103078 | 1103078 | 2021-03-09 | Wapello | Iowa | 19179 | 4064 | 110 |
1099832 | 1099832 | 2021-03-08 | Wapello | Iowa | 19179 | 4059 | 110 |
1096584 | 1096584 | 2021-03-07 | Wapello | Iowa | 19179 | 4035 | 110 |
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);