ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where deaths = 188 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2191078 | 2191078 | 2022-02-07 | DeKalb | Illinois | 17037 | 22446 | 188 |
2187825 | 2187825 | 2022-02-06 | DeKalb | Illinois | 17037 | 22328 | 188 |
2184572 | 2184572 | 2022-02-05 | DeKalb | Illinois | 17037 | 22328 | 188 |
2181320 | 2181320 | 2022-02-04 | DeKalb | Illinois | 17037 | 22328 | 188 |
2178069 | 2178069 | 2022-02-03 | DeKalb | Illinois | 17037 | 22002 | 188 |
2174816 | 2174816 | 2022-02-02 | DeKalb | Illinois | 17037 | 22002 | 188 |
1969955 | 1969955 | 2021-12-01 | Adams | Illinois | 17001 | 14429 | 188 |
1966705 | 1966705 | 2021-11-30 | Adams | Illinois | 17001 | 14399 | 188 |
1963453 | 1963453 | 2021-11-29 | Adams | Illinois | 17001 | 14307 | 188 |
1960202 | 1960202 | 2021-11-28 | Adams | Illinois | 17001 | 14146 | 188 |
1956951 | 1956951 | 2021-11-27 | Adams | Illinois | 17001 | 14146 | 188 |
1953700 | 1953700 | 2021-11-26 | Adams | Illinois | 17001 | 14146 | 188 |
1950449 | 1950449 | 2021-11-25 | Adams | Illinois | 17001 | 14146 | 188 |
1947198 | 1947198 | 2021-11-24 | Adams | Illinois | 17001 | 14146 | 188 |
1853058 | 1853058 | 2021-10-26 | Williamson | Illinois | 17199 | 12126 | 188 |
1849809 | 1849809 | 2021-10-25 | Williamson | Illinois | 17199 | 12112 | 188 |
1716503 | 1716503 | 2021-09-14 | Champaign | Illinois | 17019 | 25413 | 188 |
1697099 | 1697099 | 2021-09-08 | Vermilion | Illinois | 17183 | 12376 | 188 |
1674311 | 1674311 | 2021-09-01 | Knox | Illinois | 17095 | 6169 | 188 |
1671062 | 1671062 | 2021-08-31 | Knox | Illinois | 17095 | 6148 | 188 |
1667815 | 1667815 | 2021-08-30 | Knox | Illinois | 17095 | 6129 | 188 |
1664568 | 1664568 | 2021-08-29 | Knox | Illinois | 17095 | 6081 | 188 |
1661320 | 1661320 | 2021-08-28 | Knox | Illinois | 17095 | 6081 | 188 |
1658072 | 1658072 | 2021-08-27 | Knox | Illinois | 17095 | 6081 | 188 |
1654824 | 1654824 | 2021-08-26 | Knox | Illinois | 17095 | 6056 | 188 |
1651577 | 1651577 | 2021-08-25 | Knox | Illinois | 17095 | 6039 | 188 |
1648328 | 1648328 | 2021-08-24 | Knox | Illinois | 17095 | 6015 | 188 |
1645080 | 1645080 | 2021-08-23 | Knox | Illinois | 17095 | 6002 | 188 |
1641831 | 1641831 | 2021-08-22 | Knox | Illinois | 17095 | 5965 | 188 |
1638581 | 1638581 | 2021-08-21 | Knox | Illinois | 17095 | 5965 | 188 |
1635331 | 1635331 | 2021-08-20 | Knox | Illinois | 17095 | 5965 | 188 |
1632081 | 1632081 | 2021-08-19 | Knox | Illinois | 17095 | 5949 | 188 |
1628834 | 1628834 | 2021-08-18 | Knox | Illinois | 17095 | 5942 | 188 |
1625587 | 1625587 | 2021-08-17 | Knox | Illinois | 17095 | 5920 | 188 |
1622340 | 1622340 | 2021-08-16 | Knox | Illinois | 17095 | 5908 | 188 |
1619093 | 1619093 | 2021-08-15 | Knox | Illinois | 17095 | 5876 | 188 |
1615845 | 1615845 | 2021-08-14 | Knox | Illinois | 17095 | 5876 | 188 |
1612596 | 1612596 | 2021-08-13 | Knox | Illinois | 17095 | 5876 | 188 |
1609348 | 1609348 | 2021-08-12 | Knox | Illinois | 17095 | 5866 | 188 |
1606099 | 1606099 | 2021-08-11 | Knox | Illinois | 17095 | 5861 | 188 |
1602850 | 1602850 | 2021-08-10 | Knox | Illinois | 17095 | 5840 | 188 |
1599601 | 1599601 | 2021-08-09 | Knox | Illinois | 17095 | 5830 | 188 |
1596353 | 1596353 | 2021-08-08 | Knox | Illinois | 17095 | 5807 | 188 |
1593104 | 1593104 | 2021-08-07 | Knox | Illinois | 17095 | 5807 | 188 |
1589855 | 1589855 | 2021-08-06 | Knox | Illinois | 17095 | 5807 | 188 |
1586606 | 1586606 | 2021-08-05 | Knox | Illinois | 17095 | 5793 | 188 |
1583356 | 1583356 | 2021-08-04 | Knox | Illinois | 17095 | 5778 | 188 |
1580106 | 1580106 | 2021-08-03 | Knox | Illinois | 17095 | 5772 | 188 |
1576857 | 1576857 | 2021-08-02 | Knox | Illinois | 17095 | 5768 | 188 |
1573609 | 1573609 | 2021-08-01 | Knox | Illinois | 17095 | 5743 | 188 |
1570361 | 1570361 | 2021-07-31 | Knox | Illinois | 17095 | 5743 | 188 |
1567113 | 1567113 | 2021-07-30 | Knox | Illinois | 17095 | 5743 | 188 |
1563865 | 1563865 | 2021-07-29 | Knox | Illinois | 17095 | 5738 | 188 |
1560617 | 1560617 | 2021-07-28 | Knox | Illinois | 17095 | 5735 | 188 |
1557370 | 1557370 | 2021-07-27 | Knox | Illinois | 17095 | 5728 | 188 |
1554123 | 1554123 | 2021-07-26 | Knox | Illinois | 17095 | 5727 | 188 |
1550876 | 1550876 | 2021-07-25 | Knox | Illinois | 17095 | 5712 | 188 |
1547629 | 1547629 | 2021-07-24 | Knox | Illinois | 17095 | 5712 | 188 |
1544382 | 1544382 | 2021-07-23 | Knox | Illinois | 17095 | 5712 | 188 |
1541134 | 1541134 | 2021-07-22 | Knox | Illinois | 17095 | 5711 | 188 |
1537887 | 1537887 | 2021-07-21 | Knox | Illinois | 17095 | 5707 | 188 |
1534639 | 1534639 | 2021-07-20 | Knox | Illinois | 17095 | 5706 | 188 |
1060696 | 1060696 | 2021-02-24 | Whiteside | Illinois | 17195 | 5960 | 188 |
1057450 | 1057450 | 2021-02-23 | Whiteside | Illinois | 17195 | 5955 | 188 |
1054204 | 1054204 | 2021-02-22 | Whiteside | Illinois | 17195 | 5928 | 188 |
1050957 | 1050957 | 2021-02-21 | Whiteside | Illinois | 17195 | 5928 | 188 |
1028202 | 1028202 | 2021-02-14 | McLean | Illinois | 17113 | 14274 | 188 |
1024957 | 1024957 | 2021-02-13 | McLean | Illinois | 17113 | 14271 | 188 |
1011968 | 1011968 | 2021-02-09 | Macon | Illinois | 17115 | 9285 | 188 |
1008722 | 1008722 | 2021-02-08 | Macon | Illinois | 17115 | 9271 | 188 |
1005476 | 1005476 | 2021-02-07 | Macon | Illinois | 17115 | 9254 | 188 |
1002230 | 1002230 | 2021-02-06 | Macon | Illinois | 17115 | 9239 | 188 |
969762 | 969762 | 2021-01-27 | Kankakee | Illinois | 17091 | 11779 | 188 |
966518 | 966518 | 2021-01-26 | Kankakee | Illinois | 17091 | 11760 | 188 |
564245 | 564245 | 2020-09-24 | St. Clair | Illinois | 17163 | 7153 | 188 |
200544 | 200544 | 2020-06-02 | Kane | Illinois | 17089 | 6514 | 188 |
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);