ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 154 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2142274 | 2142274 | 2022-01-23 | Coles | Illinois | 17029 | 13406 | 154 |
2139019 | 2139019 | 2022-01-22 | Coles | Illinois | 17029 | 13406 | 154 |
2135763 | 2135763 | 2022-01-21 | Coles | Illinois | 17029 | 13406 | 154 |
2122793 | 2122793 | 2022-01-17 | Macoupin | Illinois | 17117 | 10387 | 154 |
2119541 | 2119541 | 2022-01-16 | Macoupin | Illinois | 17117 | 10387 | 154 |
2116289 | 2116289 | 2022-01-15 | Macoupin | Illinois | 17117 | 10387 | 154 |
2113038 | 2113038 | 2022-01-14 | Macoupin | Illinois | 17117 | 10387 | 154 |
2109786 | 2109786 | 2022-01-13 | Macoupin | Illinois | 17117 | 10183 | 154 |
2106520 | 2106520 | 2022-01-12 | Jefferson | Illinois | 17081 | 8386 | 154 |
2103269 | 2103269 | 2022-01-11 | Jefferson | Illinois | 17081 | 8290 | 154 |
2100018 | 2100018 | 2022-01-10 | Jefferson | Illinois | 17081 | 8215 | 154 |
2012229 | 2012229 | 2021-12-14 | DeKalb | Illinois | 17037 | 14611 | 154 |
1921253 | 1921253 | 2021-11-16 | Marion | Illinois | 17121 | 7267 | 154 |
1918003 | 1918003 | 2021-11-15 | Marion | Illinois | 17121 | 7246 | 154 |
1914753 | 1914753 | 2021-11-14 | Marion | Illinois | 17121 | 7192 | 154 |
1911503 | 1911503 | 2021-11-13 | Marion | Illinois | 17121 | 7192 | 154 |
1908254 | 1908254 | 2021-11-12 | Marion | Illinois | 17121 | 7192 | 154 |
1905005 | 1905005 | 2021-11-11 | Marion | Illinois | 17121 | 7170 | 154 |
1901755 | 1901755 | 2021-11-10 | Marion | Illinois | 17121 | 7170 | 154 |
1898505 | 1898505 | 2021-11-09 | Marion | Illinois | 17121 | 7133 | 154 |
1895255 | 1895255 | 2021-11-08 | Marion | Illinois | 17121 | 7122 | 154 |
1892005 | 1892005 | 2021-11-07 | Marion | Illinois | 17121 | 7075 | 154 |
1888755 | 1888755 | 2021-11-06 | Marion | Illinois | 17121 | 7075 | 154 |
1885505 | 1885505 | 2021-11-05 | Marion | Illinois | 17121 | 7075 | 154 |
1882256 | 1882256 | 2021-11-04 | Marion | Illinois | 17121 | 7057 | 154 |
1879007 | 1879007 | 2021-11-03 | Marion | Illinois | 17121 | 7035 | 154 |
1875758 | 1875758 | 2021-11-02 | Marion | Illinois | 17121 | 7025 | 154 |
1690610 | 1690610 | 2021-09-06 | Williamson | Illinois | 17199 | 10332 | 154 |
1687360 | 1687360 | 2021-09-05 | Williamson | Illinois | 17199 | 10332 | 154 |
1684110 | 1684110 | 2021-09-04 | Williamson | Illinois | 17199 | 10332 | 154 |
1680859 | 1680859 | 2021-09-03 | Williamson | Illinois | 17199 | 10332 | 154 |
1398258 | 1398258 | 2021-06-08 | Adams | Illinois | 17001 | 8627 | 154 |
1395011 | 1395011 | 2021-06-07 | Adams | Illinois | 17001 | 8625 | 154 |
1391766 | 1391766 | 2021-06-06 | Adams | Illinois | 17001 | 8623 | 154 |
1388521 | 1388521 | 2021-06-05 | Adams | Illinois | 17001 | 8622 | 154 |
1385276 | 1385276 | 2021-06-04 | Adams | Illinois | 17001 | 8618 | 154 |
1382030 | 1382030 | 2021-06-03 | Adams | Illinois | 17001 | 8618 | 154 |
1382122 | 1382122 | 2021-06-03 | Vermilion | Illinois | 17183 | 9926 | 154 |
1339838 | 1339838 | 2021-05-21 | Champaign | Illinois | 17019 | 20826 | 154 |
1336591 | 1336591 | 2021-05-20 | Champaign | Illinois | 17019 | 20798 | 154 |
1034723 | 1034723 | 2021-02-16 | Unknown | Illinois | 0 | 154 | |
1031477 | 1031477 | 2021-02-15 | Unknown | Illinois | 0 | 154 | |
1024941 | 1024941 | 2021-02-13 | Knox | Illinois | 17095 | 4929 | 154 |
1021696 | 1021696 | 2021-02-12 | Knox | Illinois | 17095 | 4924 | 154 |
875700 | 875700 | 2020-12-29 | Whiteside | Illinois | 17195 | 4815 | 154 |
872455 | 872455 | 2020-12-28 | Whiteside | Illinois | 17195 | 4815 | 154 |
869210 | 869210 | 2020-12-27 | Whiteside | Illinois | 17195 | 4800 | 154 |
865965 | 865965 | 2020-12-26 | Whiteside | Illinois | 17195 | 4793 | 154 |
862720 | 862720 | 2020-12-25 | Whiteside | Illinois | 17195 | 4781 | 154 |
859475 | 859475 | 2020-12-24 | Whiteside | Illinois | 17195 | 4770 | 154 |
856230 | 856230 | 2020-12-23 | Whiteside | Illinois | 17195 | 4737 | 154 |
852985 | 852985 | 2020-12-22 | Whiteside | Illinois | 17195 | 4703 | 154 |
849740 | 849740 | 2020-12-21 | Whiteside | Illinois | 17195 | 4558 | 154 |
846495 | 846495 | 2020-12-20 | Whiteside | Illinois | 17195 | 4558 | 154 |
836751 | 836751 | 2020-12-17 | Tazewell | Illinois | 17179 | 9021 | 154 |
667992 | 667992 | 2020-10-26 | Madison | Illinois | 17119 | 7289 | 154 |
664748 | 664748 | 2020-10-25 | Madison | Illinois | 17119 | 7215 | 154 |
661503 | 661503 | 2020-10-24 | Madison | Illinois | 17119 | 7133 | 154 |
658259 | 658259 | 2020-10-23 | Madison | Illinois | 17119 | 7084 | 154 |
383403 | 383403 | 2020-07-30 | St. Clair | Illinois | 17163 | 3708 | 154 |
380186 | 380186 | 2020-07-29 | St. Clair | Illinois | 17163 | 3659 | 154 |
376969 | 376969 | 2020-07-28 | St. Clair | Illinois | 17163 | 3593 | 154 |
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);