ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where deaths = 99 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
state 1
- Iowa · 130 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2308395 | 2308395 | 2022-03-15 | Plymouth | Iowa | 19149 | 6304 | 99 |
2305144 | 2305144 | 2022-03-14 | Plymouth | Iowa | 19149 | 6304 | 99 |
2301892 | 2301892 | 2022-03-13 | Plymouth | Iowa | 19149 | 6304 | 99 |
2298640 | 2298640 | 2022-03-12 | Plymouth | Iowa | 19149 | 6304 | 99 |
2295388 | 2295388 | 2022-03-11 | Plymouth | Iowa | 19149 | 6304 | 99 |
2292136 | 2292136 | 2022-03-10 | Plymouth | Iowa | 19149 | 6304 | 99 |
2288884 | 2288884 | 2022-03-09 | Plymouth | Iowa | 19149 | 6304 | 99 |
2194557 | 2194557 | 2022-02-08 | Jasper | Iowa | 19099 | 8185 | 99 |
2191303 | 2191303 | 2022-02-07 | Jasper | Iowa | 19099 | 8185 | 99 |
2188050 | 2188050 | 2022-02-06 | Jasper | Iowa | 19099 | 8185 | 99 |
2184797 | 2184797 | 2022-02-05 | Jasper | Iowa | 19099 | 8185 | 99 |
2181545 | 2181545 | 2022-02-04 | Jasper | Iowa | 19099 | 8185 | 99 |
2178294 | 2178294 | 2022-02-03 | Jasper | Iowa | 19099 | 8185 | 99 |
2175041 | 2175041 | 2022-02-02 | Jasper | Iowa | 19099 | 8185 | 99 |
1807687 | 1807687 | 2021-10-12 | Clinton | Iowa | 19045 | 6667 | 99 |
1804436 | 1804436 | 2021-10-11 | Clinton | Iowa | 19045 | 6667 | 99 |
1801187 | 1801187 | 2021-10-10 | Clinton | Iowa | 19045 | 6667 | 99 |
1797938 | 1797938 | 2021-10-09 | Clinton | Iowa | 19045 | 6667 | 99 |
1794689 | 1794689 | 2021-10-08 | Clinton | Iowa | 19045 | 6667 | 99 |
1791441 | 1791441 | 2021-10-07 | Clinton | Iowa | 19045 | 6667 | 99 |
1788192 | 1788192 | 2021-10-06 | Clinton | Iowa | 19045 | 6667 | 99 |
1784943 | 1784943 | 2021-10-05 | Clinton | Iowa | 19045 | 6510 | 99 |
1781694 | 1781694 | 2021-10-04 | Clinton | Iowa | 19045 | 6510 | 99 |
1778444 | 1778444 | 2021-10-03 | Clinton | Iowa | 19045 | 6510 | 99 |
1775194 | 1775194 | 2021-10-02 | Clinton | Iowa | 19045 | 6510 | 99 |
1771944 | 1771944 | 2021-10-01 | Clinton | Iowa | 19045 | 6510 | 99 |
1768695 | 1768695 | 2021-09-30 | Clinton | Iowa | 19045 | 6510 | 99 |
1765446 | 1765446 | 2021-09-29 | Clinton | Iowa | 19045 | 6510 | 99 |
1603022 | 1603022 | 2021-08-10 | Dallas | Iowa | 19049 | 11614 | 99 |
1603092 | 1603092 | 2021-08-10 | Webster | Iowa | 19187 | 5564 | 99 |
1599773 | 1599773 | 2021-08-09 | Dallas | Iowa | 19049 | 11614 | 99 |
1599843 | 1599843 | 2021-08-09 | Webster | Iowa | 19187 | 5564 | 99 |
1596525 | 1596525 | 2021-08-08 | Dallas | Iowa | 19049 | 11614 | 99 |
1596595 | 1596595 | 2021-08-08 | Webster | Iowa | 19187 | 5564 | 99 |
1593276 | 1593276 | 2021-08-07 | Dallas | Iowa | 19049 | 11614 | 99 |
1593346 | 1593346 | 2021-08-07 | Webster | Iowa | 19187 | 5564 | 99 |
1590027 | 1590027 | 2021-08-06 | Dallas | Iowa | 19049 | 11614 | 99 |
1590097 | 1590097 | 2021-08-06 | Webster | Iowa | 19187 | 5564 | 99 |
1586778 | 1586778 | 2021-08-05 | Dallas | Iowa | 19049 | 11614 | 99 |
1586848 | 1586848 | 2021-08-05 | Webster | Iowa | 19187 | 5564 | 99 |
1583528 | 1583528 | 2021-08-04 | Dallas | Iowa | 19049 | 11614 | 99 |
1583598 | 1583598 | 2021-08-04 | Webster | Iowa | 19187 | 5564 | 99 |
1580278 | 1580278 | 2021-08-03 | Dallas | Iowa | 19049 | 11506 | 99 |
1577029 | 1577029 | 2021-08-02 | Dallas | Iowa | 19049 | 11506 | 99 |
1573781 | 1573781 | 2021-08-01 | Dallas | Iowa | 19049 | 11506 | 99 |
1570533 | 1570533 | 2021-07-31 | Dallas | Iowa | 19049 | 11506 | 99 |
1567285 | 1567285 | 2021-07-30 | Dallas | Iowa | 19049 | 11506 | 99 |
1564037 | 1564037 | 2021-07-29 | Dallas | Iowa | 19049 | 11506 | 99 |
1560789 | 1560789 | 2021-07-28 | Dallas | Iowa | 19049 | 11506 | 99 |
1557542 | 1557542 | 2021-07-27 | Dallas | Iowa | 19049 | 11440 | 99 |
1554295 | 1554295 | 2021-07-26 | Dallas | Iowa | 19049 | 11440 | 99 |
1551048 | 1551048 | 2021-07-25 | Dallas | Iowa | 19049 | 11440 | 99 |
1547801 | 1547801 | 2021-07-24 | Dallas | Iowa | 19049 | 11440 | 99 |
1544554 | 1544554 | 2021-07-23 | Dallas | Iowa | 19049 | 11440 | 99 |
1541306 | 1541306 | 2021-07-22 | Dallas | Iowa | 19049 | 11440 | 99 |
1538059 | 1538059 | 2021-07-21 | Dallas | Iowa | 19049 | 11440 | 99 |
1534811 | 1534811 | 2021-07-20 | Dallas | Iowa | 19049 | 11392 | 99 |
1531564 | 1531564 | 2021-07-19 | Dallas | Iowa | 19049 | 11392 | 99 |
1528317 | 1528317 | 2021-07-18 | Dallas | Iowa | 19049 | 11392 | 99 |
1525070 | 1525070 | 2021-07-17 | Dallas | Iowa | 19049 | 11392 | 99 |
1521822 | 1521822 | 2021-07-16 | Dallas | Iowa | 19049 | 11392 | 99 |
1518574 | 1518574 | 2021-07-15 | Dallas | Iowa | 19049 | 11392 | 99 |
1515327 | 1515327 | 2021-07-14 | Dallas | Iowa | 19049 | 11392 | 99 |
1512081 | 1512081 | 2021-07-13 | Dallas | Iowa | 19049 | 11372 | 99 |
1508834 | 1508834 | 2021-07-12 | Dallas | Iowa | 19049 | 11372 | 99 |
1505588 | 1505588 | 2021-07-11 | Dallas | Iowa | 19049 | 11372 | 99 |
1502342 | 1502342 | 2021-07-10 | Dallas | Iowa | 19049 | 11372 | 99 |
1499096 | 1499096 | 2021-07-09 | Dallas | Iowa | 19049 | 11372 | 99 |
1495849 | 1495849 | 2021-07-08 | Dallas | Iowa | 19049 | 11372 | 99 |
1492603 | 1492603 | 2021-07-07 | Dallas | Iowa | 19049 | 11372 | 99 |
1489356 | 1489356 | 2021-07-06 | Dallas | Iowa | 19049 | 11305 | 99 |
1486109 | 1486109 | 2021-07-05 | Dallas | Iowa | 19049 | 11305 | 99 |
1482863 | 1482863 | 2021-07-04 | Dallas | Iowa | 19049 | 11305 | 99 |
1479616 | 1479616 | 2021-07-03 | Dallas | Iowa | 19049 | 11305 | 99 |
1476370 | 1476370 | 2021-07-02 | Dallas | Iowa | 19049 | 11304 | 99 |
1473124 | 1473124 | 2021-07-01 | Dallas | Iowa | 19049 | 11303 | 99 |
1469878 | 1469878 | 2021-06-30 | Dallas | Iowa | 19049 | 11303 | 99 |
1466633 | 1466633 | 2021-06-29 | Dallas | Iowa | 19049 | 11300 | 99 |
1463388 | 1463388 | 2021-06-28 | Dallas | Iowa | 19049 | 11300 | 99 |
1460143 | 1460143 | 2021-06-27 | Dallas | Iowa | 19049 | 11299 | 99 |
1456898 | 1456898 | 2021-06-26 | Dallas | Iowa | 19049 | 11297 | 99 |
1453653 | 1453653 | 2021-06-25 | Dallas | Iowa | 19049 | 11297 | 99 |
1450407 | 1450407 | 2021-06-24 | Dallas | Iowa | 19049 | 11296 | 99 |
1447162 | 1447162 | 2021-06-23 | Dallas | Iowa | 19049 | 11293 | 99 |
1443917 | 1443917 | 2021-06-22 | Dallas | Iowa | 19049 | 11294 | 99 |
1440672 | 1440672 | 2021-06-21 | Dallas | Iowa | 19049 | 11291 | 99 |
1437425 | 1437425 | 2021-06-20 | Dallas | Iowa | 19049 | 11289 | 99 |
1434178 | 1434178 | 2021-06-19 | Dallas | Iowa | 19049 | 11289 | 99 |
1430932 | 1430932 | 2021-06-18 | Dallas | Iowa | 19049 | 11289 | 99 |
1427687 | 1427687 | 2021-06-17 | Dallas | Iowa | 19049 | 11289 | 99 |
1424442 | 1424442 | 2021-06-16 | Dallas | Iowa | 19049 | 11287 | 99 |
1421194 | 1421194 | 2021-06-15 | Dallas | Iowa | 19049 | 11287 | 99 |
1417949 | 1417949 | 2021-06-14 | Dallas | Iowa | 19049 | 11286 | 99 |
1414703 | 1414703 | 2021-06-13 | Dallas | Iowa | 19049 | 11284 | 99 |
1411458 | 1411458 | 2021-06-12 | Dallas | Iowa | 19049 | 11281 | 99 |
1408213 | 1408213 | 2021-06-11 | Dallas | Iowa | 19049 | 11280 | 99 |
1404967 | 1404967 | 2021-06-10 | Dallas | Iowa | 19049 | 11275 | 99 |
1401722 | 1401722 | 2021-06-09 | Dallas | Iowa | 19049 | 11276 | 99 |
1398477 | 1398477 | 2021-06-08 | Dallas | Iowa | 19049 | 11273 | 99 |
1395230 | 1395230 | 2021-06-07 | Dallas | Iowa | 19049 | 11271 | 99 |
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);