ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where deaths = 92, fips = 17141 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1700326 | 1700326 | 2021-09-09 | Ogle | Illinois | 17141 | 6880 | 92 |
1697077 | 1697077 | 2021-09-08 | Ogle | Illinois | 17141 | 6830 | 92 |
1693829 | 1693829 | 2021-09-07 | Ogle | Illinois | 17141 | 6810 | 92 |
1690580 | 1690580 | 2021-09-06 | Ogle | Illinois | 17141 | 6747 | 92 |
1687330 | 1687330 | 2021-09-05 | Ogle | Illinois | 17141 | 6747 | 92 |
1684080 | 1684080 | 2021-09-04 | Ogle | Illinois | 17141 | 6747 | 92 |
1680829 | 1680829 | 2021-09-03 | Ogle | Illinois | 17141 | 6747 | 92 |
1677581 | 1677581 | 2021-09-02 | Ogle | Illinois | 17141 | 6713 | 92 |
1674334 | 1674334 | 2021-09-01 | Ogle | Illinois | 17141 | 6686 | 92 |
1671085 | 1671085 | 2021-08-31 | Ogle | Illinois | 17141 | 6658 | 92 |
1667838 | 1667838 | 2021-08-30 | Ogle | Illinois | 17141 | 6641 | 92 |
1664591 | 1664591 | 2021-08-29 | Ogle | Illinois | 17141 | 6598 | 92 |
1661343 | 1661343 | 2021-08-28 | Ogle | Illinois | 17141 | 6598 | 92 |
1658095 | 1658095 | 2021-08-27 | Ogle | Illinois | 17141 | 6598 | 92 |
1654847 | 1654847 | 2021-08-26 | Ogle | Illinois | 17141 | 6579 | 92 |
1651600 | 1651600 | 2021-08-25 | Ogle | Illinois | 17141 | 6557 | 92 |
1648351 | 1648351 | 2021-08-24 | Ogle | Illinois | 17141 | 6543 | 92 |
1645103 | 1645103 | 2021-08-23 | Ogle | Illinois | 17141 | 6523 | 92 |
1641854 | 1641854 | 2021-08-22 | Ogle | Illinois | 17141 | 6507 | 92 |
1638604 | 1638604 | 2021-08-21 | Ogle | Illinois | 17141 | 6507 | 92 |
1635354 | 1635354 | 2021-08-20 | Ogle | Illinois | 17141 | 6507 | 92 |
1632104 | 1632104 | 2021-08-19 | Ogle | Illinois | 17141 | 6489 | 92 |
1628857 | 1628857 | 2021-08-18 | Ogle | Illinois | 17141 | 6476 | 92 |
1625610 | 1625610 | 2021-08-17 | Ogle | Illinois | 17141 | 6456 | 92 |
1622363 | 1622363 | 2021-08-16 | Ogle | Illinois | 17141 | 6439 | 92 |
1619116 | 1619116 | 2021-08-15 | Ogle | Illinois | 17141 | 6402 | 92 |
1615868 | 1615868 | 2021-08-14 | Ogle | Illinois | 17141 | 6402 | 92 |
1612619 | 1612619 | 2021-08-13 | Ogle | Illinois | 17141 | 6402 | 92 |
1609371 | 1609371 | 2021-08-12 | Ogle | Illinois | 17141 | 6394 | 92 |
1606122 | 1606122 | 2021-08-11 | Ogle | Illinois | 17141 | 6380 | 92 |
1602873 | 1602873 | 2021-08-10 | Ogle | Illinois | 17141 | 6375 | 92 |
1599624 | 1599624 | 2021-08-09 | Ogle | Illinois | 17141 | 6367 | 92 |
1596376 | 1596376 | 2021-08-08 | Ogle | Illinois | 17141 | 6349 | 92 |
1593127 | 1593127 | 2021-08-07 | Ogle | Illinois | 17141 | 6349 | 92 |
1589878 | 1589878 | 2021-08-06 | Ogle | Illinois | 17141 | 6349 | 92 |
1586629 | 1586629 | 2021-08-05 | Ogle | Illinois | 17141 | 6344 | 92 |
1583379 | 1583379 | 2021-08-04 | Ogle | Illinois | 17141 | 6335 | 92 |
1580129 | 1580129 | 2021-08-03 | Ogle | Illinois | 17141 | 6333 | 92 |
1576880 | 1576880 | 2021-08-02 | Ogle | Illinois | 17141 | 6325 | 92 |
1573632 | 1573632 | 2021-08-01 | Ogle | Illinois | 17141 | 6305 | 92 |
1570384 | 1570384 | 2021-07-31 | Ogle | Illinois | 17141 | 6305 | 92 |
1567136 | 1567136 | 2021-07-30 | Ogle | Illinois | 17141 | 6305 | 92 |
1563888 | 1563888 | 2021-07-29 | Ogle | Illinois | 17141 | 6300 | 92 |
1560640 | 1560640 | 2021-07-28 | Ogle | Illinois | 17141 | 6298 | 92 |
1557393 | 1557393 | 2021-07-27 | Ogle | Illinois | 17141 | 6291 | 92 |
1554146 | 1554146 | 2021-07-26 | Ogle | Illinois | 17141 | 6285 | 92 |
1550899 | 1550899 | 2021-07-25 | Ogle | Illinois | 17141 | 6275 | 92 |
1547652 | 1547652 | 2021-07-24 | Ogle | Illinois | 17141 | 6275 | 92 |
1544405 | 1544405 | 2021-07-23 | Ogle | Illinois | 17141 | 6275 | 92 |
1541157 | 1541157 | 2021-07-22 | Ogle | Illinois | 17141 | 6272 | 92 |
1537910 | 1537910 | 2021-07-21 | Ogle | Illinois | 17141 | 6266 | 92 |
1534662 | 1534662 | 2021-07-20 | Ogle | Illinois | 17141 | 6265 | 92 |
1531415 | 1531415 | 2021-07-19 | Ogle | Illinois | 17141 | 6264 | 92 |
1528168 | 1528168 | 2021-07-18 | Ogle | Illinois | 17141 | 6258 | 92 |
1524921 | 1524921 | 2021-07-17 | Ogle | Illinois | 17141 | 6258 | 92 |
1521673 | 1521673 | 2021-07-16 | Ogle | Illinois | 17141 | 6258 | 92 |
1518425 | 1518425 | 2021-07-15 | Ogle | Illinois | 17141 | 6253 | 92 |
1515178 | 1515178 | 2021-07-14 | Ogle | Illinois | 17141 | 6252 | 92 |
1511932 | 1511932 | 2021-07-13 | Ogle | Illinois | 17141 | 6250 | 92 |
1508685 | 1508685 | 2021-07-12 | Ogle | Illinois | 17141 | 6244 | 92 |
1505439 | 1505439 | 2021-07-11 | Ogle | Illinois | 17141 | 6244 | 92 |
1502193 | 1502193 | 2021-07-10 | Ogle | Illinois | 17141 | 6244 | 92 |
1498947 | 1498947 | 2021-07-09 | Ogle | Illinois | 17141 | 6244 | 92 |
1495700 | 1495700 | 2021-07-08 | Ogle | Illinois | 17141 | 6244 | 92 |
1492454 | 1492454 | 2021-07-07 | Ogle | Illinois | 17141 | 6241 | 92 |
1489207 | 1489207 | 2021-07-06 | Ogle | Illinois | 17141 | 6238 | 92 |
1485960 | 1485960 | 2021-07-05 | Ogle | Illinois | 17141 | 6236 | 92 |
1482714 | 1482714 | 2021-07-04 | Ogle | Illinois | 17141 | 6236 | 92 |
1479467 | 1479467 | 2021-07-03 | Ogle | Illinois | 17141 | 6236 | 92 |
1476221 | 1476221 | 2021-07-02 | Ogle | Illinois | 17141 | 6236 | 92 |
1472975 | 1472975 | 2021-07-01 | Ogle | Illinois | 17141 | 6234 | 92 |
1469729 | 1469729 | 2021-06-30 | Ogle | Illinois | 17141 | 6230 | 92 |
1466484 | 1466484 | 2021-06-29 | Ogle | Illinois | 17141 | 6229 | 92 |
1463239 | 1463239 | 2021-06-28 | Ogle | Illinois | 17141 | 6227 | 92 |
1459994 | 1459994 | 2021-06-27 | Ogle | Illinois | 17141 | 6226 | 92 |
1456749 | 1456749 | 2021-06-26 | Ogle | Illinois | 17141 | 6226 | 92 |
1453504 | 1453504 | 2021-06-25 | Ogle | Illinois | 17141 | 6226 | 92 |
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);