ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 256 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 9
state 1
- Illinois · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2288715 | 2288715 | 2022-03-09 | Williamson | Illinois | 17199 | 22437 | 256 |
2285464 | 2285464 | 2022-03-08 | Williamson | Illinois | 17199 | 22437 | 256 |
2282212 | 2282212 | 2022-03-07 | Williamson | Illinois | 17199 | 22426 | 256 |
2278959 | 2278959 | 2022-03-06 | Williamson | Illinois | 17199 | 22400 | 256 |
2275706 | 2275706 | 2022-03-05 | Williamson | Illinois | 17199 | 22400 | 256 |
2272453 | 2272453 | 2022-03-04 | Williamson | Illinois | 17199 | 22400 | 256 |
2178148 | 2178148 | 2022-02-03 | Whiteside | Illinois | 17195 | 14524 | 256 |
2174895 | 2174895 | 2022-02-02 | Whiteside | Illinois | 17195 | 14524 | 256 |
1853021 | 1853021 | 2021-10-26 | McLean | Illinois | 17113 | 23203 | 256 |
1849772 | 1849772 | 2021-10-25 | McLean | Illinois | 17113 | 23165 | 256 |
1846522 | 1846522 | 2021-10-24 | McLean | Illinois | 17113 | 23073 | 256 |
1843272 | 1843272 | 2021-10-23 | McLean | Illinois | 17113 | 23073 | 256 |
1840022 | 1840022 | 2021-10-22 | McLean | Illinois | 17113 | 23073 | 256 |
1833506 | 1833506 | 2021-10-20 | Kankakee | Illinois | 17091 | 17910 | 256 |
1830257 | 1830257 | 2021-10-19 | Kankakee | Illinois | 17091 | 17875 | 256 |
1827008 | 1827008 | 2021-10-18 | Kankakee | Illinois | 17091 | 17848 | 256 |
1158076 | 1158076 | 2021-03-26 | Unknown | Illinois | 0 | 256 | |
982769 | 982769 | 2021-01-31 | Peoria | Illinois | 17143 | 15821 | 256 |
979523 | 979523 | 2021-01-30 | Peoria | Illinois | 17143 | 15788 | 256 |
976278 | 976278 | 2021-01-29 | Peoria | Illinois | 17143 | 15736 | 256 |
973051 | 973051 | 2021-01-28 | Tazewell | Illinois | 17179 | 12523 | 256 |
969806 | 969806 | 2021-01-27 | Tazewell | Illinois | 17179 | 12463 | 256 |
966544 | 966544 | 2021-01-26 | Peoria | Illinois | 17143 | 15571 | 256 |
956799 | 956799 | 2021-01-23 | McHenry | Illinois | 17111 | 22153 | 256 |
768594 | 768594 | 2020-11-26 | St. Clair | Illinois | 17163 | 13858 | 256 |
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);