ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
401 rows where county = "Putnam" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Putnam · 401 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1654854 | 1654854 | 2021-08-26 | Putnam | Illinois | 17155 | 515 | 4 |
1651607 | 1651607 | 2021-08-25 | Putnam | Illinois | 17155 | 515 | 4 |
1648358 | 1648358 | 2021-08-24 | Putnam | Illinois | 17155 | 515 | 4 |
1645110 | 1645110 | 2021-08-23 | Putnam | Illinois | 17155 | 516 | 4 |
1641861 | 1641861 | 2021-08-22 | Putnam | Illinois | 17155 | 513 | 4 |
1638611 | 1638611 | 2021-08-21 | Putnam | Illinois | 17155 | 513 | 4 |
1635361 | 1635361 | 2021-08-20 | Putnam | Illinois | 17155 | 513 | 4 |
1632111 | 1632111 | 2021-08-19 | Putnam | Illinois | 17155 | 507 | 4 |
1628864 | 1628864 | 2021-08-18 | Putnam | Illinois | 17155 | 503 | 4 |
1625617 | 1625617 | 2021-08-17 | Putnam | Illinois | 17155 | 501 | 4 |
1622370 | 1622370 | 2021-08-16 | Putnam | Illinois | 17155 | 501 | 4 |
1619123 | 1619123 | 2021-08-15 | Putnam | Illinois | 17155 | 500 | 4 |
1615875 | 1615875 | 2021-08-14 | Putnam | Illinois | 17155 | 500 | 4 |
1612626 | 1612626 | 2021-08-13 | Putnam | Illinois | 17155 | 500 | 4 |
1613532 | 1613532 | 2021-08-13 | Putnam | Missouri | 29171 | 527 | 4 |
1609378 | 1609378 | 2021-08-12 | Putnam | Illinois | 17155 | 497 | 4 |
1610283 | 1610283 | 2021-08-12 | Putnam | Missouri | 29171 | 521 | 4 |
1606129 | 1606129 | 2021-08-11 | Putnam | Illinois | 17155 | 497 | 4 |
1607035 | 1607035 | 2021-08-11 | Putnam | Missouri | 29171 | 518 | 4 |
1602880 | 1602880 | 2021-08-10 | Putnam | Illinois | 17155 | 497 | 4 |
1603786 | 1603786 | 2021-08-10 | Putnam | Missouri | 29171 | 514 | 4 |
1599631 | 1599631 | 2021-08-09 | Putnam | Illinois | 17155 | 497 | 4 |
1600537 | 1600537 | 2021-08-09 | Putnam | Missouri | 29171 | 514 | 4 |
1596383 | 1596383 | 2021-08-08 | Putnam | Illinois | 17155 | 497 | 4 |
1597289 | 1597289 | 2021-08-08 | Putnam | Missouri | 29171 | 514 | 4 |
1593134 | 1593134 | 2021-08-07 | Putnam | Illinois | 17155 | 497 | 4 |
1594040 | 1594040 | 2021-08-07 | Putnam | Missouri | 29171 | 514 | 4 |
1589885 | 1589885 | 2021-08-06 | Putnam | Illinois | 17155 | 497 | 4 |
1590791 | 1590791 | 2021-08-06 | Putnam | Missouri | 29171 | 514 | 4 |
1586636 | 1586636 | 2021-08-05 | Putnam | Illinois | 17155 | 496 | 4 |
1587542 | 1587542 | 2021-08-05 | Putnam | Missouri | 29171 | 509 | 4 |
1583386 | 1583386 | 2021-08-04 | Putnam | Illinois | 17155 | 495 | 4 |
1584291 | 1584291 | 2021-08-04 | Putnam | Missouri | 29171 | 505 | 4 |
1580136 | 1580136 | 2021-08-03 | Putnam | Illinois | 17155 | 495 | 4 |
1581042 | 1581042 | 2021-08-03 | Putnam | Missouri | 29171 | 503 | 4 |
1576887 | 1576887 | 2021-08-02 | Putnam | Illinois | 17155 | 494 | 4 |
1577793 | 1577793 | 2021-08-02 | Putnam | Missouri | 29171 | 502 | 4 |
1573639 | 1573639 | 2021-08-01 | Putnam | Illinois | 17155 | 495 | 4 |
1574545 | 1574545 | 2021-08-01 | Putnam | Missouri | 29171 | 502 | 4 |
1570391 | 1570391 | 2021-07-31 | Putnam | Illinois | 17155 | 495 | 4 |
1571297 | 1571297 | 2021-07-31 | Putnam | Missouri | 29171 | 501 | 4 |
1567143 | 1567143 | 2021-07-30 | Putnam | Illinois | 17155 | 495 | 4 |
1568049 | 1568049 | 2021-07-30 | Putnam | Missouri | 29171 | 500 | 4 |
1563895 | 1563895 | 2021-07-29 | Putnam | Illinois | 17155 | 494 | 4 |
1564801 | 1564801 | 2021-07-29 | Putnam | Missouri | 29171 | 500 | 4 |
1560647 | 1560647 | 2021-07-28 | Putnam | Illinois | 17155 | 494 | 4 |
1561553 | 1561553 | 2021-07-28 | Putnam | Missouri | 29171 | 500 | 4 |
1557400 | 1557400 | 2021-07-27 | Putnam | Illinois | 17155 | 494 | 4 |
1558305 | 1558305 | 2021-07-27 | Putnam | Missouri | 29171 | 499 | 4 |
1554153 | 1554153 | 2021-07-26 | Putnam | Illinois | 17155 | 494 | 4 |
1555058 | 1555058 | 2021-07-26 | Putnam | Missouri | 29171 | 497 | 4 |
1550906 | 1550906 | 2021-07-25 | Putnam | Illinois | 17155 | 493 | 4 |
1551811 | 1551811 | 2021-07-25 | Putnam | Missouri | 29171 | 497 | 4 |
1547659 | 1547659 | 2021-07-24 | Putnam | Illinois | 17155 | 493 | 4 |
1548564 | 1548564 | 2021-07-24 | Putnam | Missouri | 29171 | 497 | 4 |
1544412 | 1544412 | 2021-07-23 | Putnam | Illinois | 17155 | 493 | 4 |
1545317 | 1545317 | 2021-07-23 | Putnam | Missouri | 29171 | 497 | 4 |
1541164 | 1541164 | 2021-07-22 | Putnam | Illinois | 17155 | 493 | 4 |
1542069 | 1542069 | 2021-07-22 | Putnam | Missouri | 29171 | 497 | 4 |
1537917 | 1537917 | 2021-07-21 | Putnam | Illinois | 17155 | 493 | 4 |
1538822 | 1538822 | 2021-07-21 | Putnam | Missouri | 29171 | 493 | 4 |
1534669 | 1534669 | 2021-07-20 | Putnam | Illinois | 17155 | 492 | 4 |
1535575 | 1535575 | 2021-07-20 | Putnam | Missouri | 29171 | 490 | 4 |
1531422 | 1531422 | 2021-07-19 | Putnam | Illinois | 17155 | 492 | 4 |
1532327 | 1532327 | 2021-07-19 | Putnam | Missouri | 29171 | 489 | 4 |
1528175 | 1528175 | 2021-07-18 | Putnam | Illinois | 17155 | 492 | 4 |
1529080 | 1529080 | 2021-07-18 | Putnam | Missouri | 29171 | 489 | 4 |
1524928 | 1524928 | 2021-07-17 | Putnam | Illinois | 17155 | 492 | 4 |
1525833 | 1525833 | 2021-07-17 | Putnam | Missouri | 29171 | 489 | 4 |
1521680 | 1521680 | 2021-07-16 | Putnam | Illinois | 17155 | 492 | 4 |
1522586 | 1522586 | 2021-07-16 | Putnam | Missouri | 29171 | 489 | 4 |
1518432 | 1518432 | 2021-07-15 | Putnam | Illinois | 17155 | 492 | 4 |
1519337 | 1519337 | 2021-07-15 | Putnam | Missouri | 29171 | 490 | 4 |
1515185 | 1515185 | 2021-07-14 | Putnam | Illinois | 17155 | 492 | 4 |
1516090 | 1516090 | 2021-07-14 | Putnam | Missouri | 29171 | 488 | 4 |
1511939 | 1511939 | 2021-07-13 | Putnam | Illinois | 17155 | 491 | 4 |
1512844 | 1512844 | 2021-07-13 | Putnam | Missouri | 29171 | 488 | 4 |
1508692 | 1508692 | 2021-07-12 | Putnam | Illinois | 17155 | 491 | 4 |
1509597 | 1509597 | 2021-07-12 | Putnam | Missouri | 29171 | 488 | 4 |
1505446 | 1505446 | 2021-07-11 | Putnam | Illinois | 17155 | 490 | 4 |
1506351 | 1506351 | 2021-07-11 | Putnam | Missouri | 29171 | 488 | 4 |
1502200 | 1502200 | 2021-07-10 | Putnam | Illinois | 17155 | 490 | 4 |
1503105 | 1503105 | 2021-07-10 | Putnam | Missouri | 29171 | 488 | 4 |
1498954 | 1498954 | 2021-07-09 | Putnam | Illinois | 17155 | 490 | 4 |
1499859 | 1499859 | 2021-07-09 | Putnam | Missouri | 29171 | 488 | 4 |
1495707 | 1495707 | 2021-07-08 | Putnam | Illinois | 17155 | 489 | 4 |
1496613 | 1496613 | 2021-07-08 | Putnam | Missouri | 29171 | 487 | 4 |
1492461 | 1492461 | 2021-07-07 | Putnam | Illinois | 17155 | 489 | 4 |
1493366 | 1493366 | 2021-07-07 | Putnam | Missouri | 29171 | 486 | 4 |
1489214 | 1489214 | 2021-07-06 | Putnam | Illinois | 17155 | 489 | 4 |
1490119 | 1490119 | 2021-07-06 | Putnam | Missouri | 29171 | 486 | 4 |
1485967 | 1485967 | 2021-07-05 | Putnam | Illinois | 17155 | 489 | 4 |
1486872 | 1486872 | 2021-07-05 | Putnam | Missouri | 29171 | 486 | 4 |
1482721 | 1482721 | 2021-07-04 | Putnam | Illinois | 17155 | 489 | 4 |
1483626 | 1483626 | 2021-07-04 | Putnam | Missouri | 29171 | 486 | 4 |
1479474 | 1479474 | 2021-07-03 | Putnam | Illinois | 17155 | 489 | 4 |
1480380 | 1480380 | 2021-07-03 | Putnam | Missouri | 29171 | 486 | 4 |
1476228 | 1476228 | 2021-07-02 | Putnam | Illinois | 17155 | 489 | 4 |
1477133 | 1477133 | 2021-07-02 | Putnam | Missouri | 29171 | 486 | 4 |
1472982 | 1472982 | 2021-07-01 | Putnam | Illinois | 17155 | 488 | 4 |
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);