ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 155 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2191105 | 2191105 | 2022-02-07 | Kendall | Illinois | 17093 | 29649 | 155 |
2155286 | 2155286 | 2022-01-27 | Coles | Illinois | 17029 | 14122 | 155 |
2152033 | 2152033 | 2022-01-26 | Coles | Illinois | 17029 | 14005 | 155 |
2148781 | 2148781 | 2022-01-25 | Coles | Illinois | 17029 | 13858 | 155 |
2145529 | 2145529 | 2022-01-24 | Coles | Illinois | 17029 | 13719 | 155 |
2145542 | 2145542 | 2022-01-24 | Franklin | Illinois | 17055 | 10979 | 155 |
2142287 | 2142287 | 2022-01-23 | Franklin | Illinois | 17055 | 10661 | 155 |
2139032 | 2139032 | 2022-01-22 | Franklin | Illinois | 17055 | 10661 | 155 |
2135776 | 2135776 | 2022-01-21 | Franklin | Illinois | 17055 | 10661 | 155 |
2122826 | 2122826 | 2022-01-17 | Stephenson | Illinois | 17177 | 9586 | 155 |
2119574 | 2119574 | 2022-01-16 | Stephenson | Illinois | 17177 | 9586 | 155 |
2116322 | 2116322 | 2022-01-15 | Stephenson | Illinois | 17177 | 9586 | 155 |
2113071 | 2113071 | 2022-01-14 | Stephenson | Illinois | 17177 | 9586 | 155 |
2109771 | 2109771 | 2022-01-13 | Jefferson | Illinois | 17081 | 8530 | 155 |
1940754 | 1940754 | 2021-11-22 | Marion | Illinois | 17121 | 7376 | 155 |
1937504 | 1937504 | 2021-11-21 | Marion | Illinois | 17121 | 7348 | 155 |
1934254 | 1934254 | 2021-11-20 | Marion | Illinois | 17121 | 7348 | 155 |
1931003 | 1931003 | 2021-11-19 | Marion | Illinois | 17121 | 7348 | 155 |
1927752 | 1927752 | 2021-11-18 | Marion | Illinois | 17121 | 7324 | 155 |
1924502 | 1924502 | 2021-11-17 | Marion | Illinois | 17121 | 7297 | 155 |
1700356 | 1700356 | 2021-09-09 | Williamson | Illinois | 17199 | 10654 | 155 |
1697107 | 1697107 | 2021-09-08 | Williamson | Illinois | 17199 | 10607 | 155 |
1693859 | 1693859 | 2021-09-07 | Williamson | Illinois | 17199 | 10559 | 155 |
1437206 | 1437206 | 2021-06-20 | Adams | Illinois | 17001 | 8677 | 155 |
1433959 | 1433959 | 2021-06-19 | Adams | Illinois | 17001 | 8677 | 155 |
1430713 | 1430713 | 2021-06-18 | Adams | Illinois | 17001 | 8677 | 155 |
1427468 | 1427468 | 2021-06-17 | Adams | Illinois | 17001 | 8674 | 155 |
1424223 | 1424223 | 2021-06-16 | Adams | Illinois | 17001 | 8669 | 155 |
1420975 | 1420975 | 2021-06-15 | Adams | Illinois | 17001 | 8667 | 155 |
1417730 | 1417730 | 2021-06-14 | Adams | Illinois | 17001 | 8659 | 155 |
1414484 | 1414484 | 2021-06-13 | Adams | Illinois | 17001 | 8654 | 155 |
1411239 | 1411239 | 2021-06-12 | Adams | Illinois | 17001 | 8654 | 155 |
1407994 | 1407994 | 2021-06-11 | Adams | Illinois | 17001 | 8648 | 155 |
1404748 | 1404748 | 2021-06-10 | Adams | Illinois | 17001 | 8644 | 155 |
1401503 | 1401503 | 2021-06-09 | Adams | Illinois | 17001 | 8637 | 155 |
1385368 | 1385368 | 2021-06-04 | Vermilion | Illinois | 17183 | 9937 | 155 |
768570 | 768570 | 2020-11-26 | McHenry | Illinois | 17111 | 13788 | 155 |
583707 | 583707 | 2020-09-30 | Winnebago | Illinois | 17201 | 6300 | 155 |
386621 | 386621 | 2020-07-31 | St. Clair | Illinois | 17163 | 3792 | 155 |
179113 | 179113 | 2020-05-26 | Kane | Illinois | 17089 | 5920 | 155 |
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);