ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
220 rows where deaths = 78 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 |
---|---|---|---|---|---|---|---|
2360262 | 2360262 | 2022-03-31 | Shelby | Illinois | 17173 | 6192 | 78 |
2334174 | 2334174 | 2022-03-23 | Edgar | Illinois | 17045 | 5122 | 78 |
2330920 | 2330920 | 2022-03-22 | Edgar | Illinois | 17045 | 5123 | 78 |
2327668 | 2327668 | 2022-03-21 | Edgar | Illinois | 17045 | 5123 | 78 |
2324415 | 2324415 | 2022-03-20 | Edgar | Illinois | 17045 | 5122 | 78 |
2321161 | 2321161 | 2022-03-19 | Edgar | Illinois | 17045 | 5122 | 78 |
2317907 | 2317907 | 2022-03-18 | Edgar | Illinois | 17045 | 5122 | 78 |
2314654 | 2314654 | 2022-03-17 | Edgar | Illinois | 17045 | 5123 | 78 |
2311401 | 2311401 | 2022-03-16 | Edgar | Illinois | 17045 | 5124 | 78 |
2308148 | 2308148 | 2022-03-15 | Edgar | Illinois | 17045 | 5124 | 78 |
2304897 | 2304897 | 2022-03-14 | Edgar | Illinois | 17045 | 5124 | 78 |
2301645 | 2301645 | 2022-03-13 | Edgar | Illinois | 17045 | 5123 | 78 |
2298393 | 2298393 | 2022-03-12 | Edgar | Illinois | 17045 | 5123 | 78 |
2295141 | 2295141 | 2022-03-11 | Edgar | Illinois | 17045 | 5123 | 78 |
2291889 | 2291889 | 2022-03-10 | Edgar | Illinois | 17045 | 5122 | 78 |
2288637 | 2288637 | 2022-03-09 | Edgar | Illinois | 17045 | 5119 | 78 |
2285386 | 2285386 | 2022-03-08 | Edgar | Illinois | 17045 | 5116 | 78 |
2282134 | 2282134 | 2022-03-07 | Edgar | Illinois | 17045 | 5114 | 78 |
2278881 | 2278881 | 2022-03-06 | Edgar | Illinois | 17045 | 5112 | 78 |
2275628 | 2275628 | 2022-03-05 | Edgar | Illinois | 17045 | 5112 | 78 |
2272375 | 2272375 | 2022-03-04 | Edgar | Illinois | 17045 | 5112 | 78 |
2269123 | 2269123 | 2022-03-03 | Edgar | Illinois | 17045 | 5109 | 78 |
2210676 | 2210676 | 2022-02-13 | Wayne | Illinois | 17191 | 5156 | 78 |
2207423 | 2207423 | 2022-02-12 | Wayne | Illinois | 17191 | 5156 | 78 |
2204170 | 2204170 | 2022-02-11 | Wayne | Illinois | 17191 | 5156 | 78 |
2200917 | 2200917 | 2022-02-10 | Wayne | Illinois | 17191 | 5156 | 78 |
2165077 | 2165077 | 2022-01-30 | Jersey | Illinois | 17083 | 5926 | 78 |
2165115 | 2165115 | 2022-01-30 | Richland | Illinois | 17159 | 4852 | 78 |
2161822 | 2161822 | 2022-01-29 | Jersey | Illinois | 17083 | 5926 | 78 |
2161860 | 2161860 | 2022-01-29 | Richland | Illinois | 17159 | 4852 | 78 |
2158567 | 2158567 | 2022-01-28 | Jersey | Illinois | 17083 | 5926 | 78 |
2158605 | 2158605 | 2022-01-28 | Richland | Illinois | 17159 | 4852 | 78 |
2155313 | 2155313 | 2022-01-27 | Jersey | Illinois | 17083 | 5892 | 78 |
2155351 | 2155351 | 2022-01-27 | Richland | Illinois | 17159 | 4811 | 78 |
2152060 | 2152060 | 2022-01-26 | Jersey | Illinois | 17083 | 5855 | 78 |
2152098 | 2152098 | 2022-01-26 | Richland | Illinois | 17159 | 4754 | 78 |
2148808 | 2148808 | 2022-01-25 | Jersey | Illinois | 17083 | 5827 | 78 |
2148846 | 2148846 | 2022-01-25 | Richland | Illinois | 17159 | 4680 | 78 |
2145556 | 2145556 | 2022-01-24 | Jersey | Illinois | 17083 | 5785 | 78 |
2145594 | 2145594 | 2022-01-24 | Richland | Illinois | 17159 | 4623 | 78 |
2142301 | 2142301 | 2022-01-23 | Jersey | Illinois | 17083 | 5669 | 78 |
2142339 | 2142339 | 2022-01-23 | Richland | Illinois | 17159 | 4476 | 78 |
2139046 | 2139046 | 2022-01-22 | Jersey | Illinois | 17083 | 5669 | 78 |
2139084 | 2139084 | 2022-01-22 | Richland | Illinois | 17159 | 4476 | 78 |
2135790 | 2135790 | 2022-01-21 | Jersey | Illinois | 17083 | 5669 | 78 |
2135828 | 2135828 | 2022-01-21 | Richland | Illinois | 17159 | 4476 | 78 |
2132538 | 2132538 | 2022-01-20 | Jersey | Illinois | 17083 | 5610 | 78 |
2132576 | 2132576 | 2022-01-20 | Richland | Illinois | 17159 | 4400 | 78 |
1983015 | 1983015 | 2021-12-05 | McDonough | Illinois | 17109 | 4128 | 78 |
1979765 | 1979765 | 2021-12-04 | McDonough | Illinois | 17109 | 4128 | 78 |
1976515 | 1976515 | 2021-12-03 | McDonough | Illinois | 17109 | 4128 | 78 |
1973266 | 1973266 | 2021-12-02 | McDonough | Illinois | 17109 | 4108 | 78 |
1970016 | 1970016 | 2021-12-01 | McDonough | Illinois | 17109 | 4062 | 78 |
1966766 | 1966766 | 2021-11-30 | McDonough | Illinois | 17109 | 4060 | 78 |
1963514 | 1963514 | 2021-11-29 | McDonough | Illinois | 17109 | 4040 | 78 |
1960263 | 1960263 | 2021-11-28 | McDonough | Illinois | 17109 | 3988 | 78 |
1957012 | 1957012 | 2021-11-27 | McDonough | Illinois | 17109 | 3988 | 78 |
1953761 | 1953761 | 2021-11-26 | McDonough | Illinois | 17109 | 3988 | 78 |
1950510 | 1950510 | 2021-11-25 | McDonough | Illinois | 17109 | 3988 | 78 |
1947259 | 1947259 | 2021-11-24 | McDonough | Illinois | 17109 | 3988 | 78 |
1944008 | 1944008 | 2021-11-23 | McDonough | Illinois | 17109 | 3972 | 78 |
1940758 | 1940758 | 2021-11-22 | McDonough | Illinois | 17109 | 3962 | 78 |
1937508 | 1937508 | 2021-11-21 | McDonough | Illinois | 17109 | 3926 | 78 |
1934258 | 1934258 | 2021-11-20 | McDonough | Illinois | 17109 | 3926 | 78 |
1931007 | 1931007 | 2021-11-19 | McDonough | Illinois | 17109 | 3926 | 78 |
1927756 | 1927756 | 2021-11-18 | McDonough | Illinois | 17109 | 3917 | 78 |
1924506 | 1924506 | 2021-11-17 | McDonough | Illinois | 17109 | 3907 | 78 |
1921257 | 1921257 | 2021-11-16 | McDonough | Illinois | 17109 | 3895 | 78 |
1918007 | 1918007 | 2021-11-15 | McDonough | Illinois | 17109 | 3891 | 78 |
1914757 | 1914757 | 2021-11-14 | McDonough | Illinois | 17109 | 3867 | 78 |
1911507 | 1911507 | 2021-11-13 | McDonough | Illinois | 17109 | 3867 | 78 |
1908258 | 1908258 | 2021-11-12 | McDonough | Illinois | 17109 | 3867 | 78 |
1905009 | 1905009 | 2021-11-11 | McDonough | Illinois | 17109 | 3842 | 78 |
1901759 | 1901759 | 2021-11-10 | McDonough | Illinois | 17109 | 3842 | 78 |
1898509 | 1898509 | 2021-11-09 | McDonough | Illinois | 17109 | 3826 | 78 |
1895259 | 1895259 | 2021-11-08 | McDonough | Illinois | 17109 | 3825 | 78 |
1892009 | 1892009 | 2021-11-07 | McDonough | Illinois | 17109 | 3815 | 78 |
1888759 | 1888759 | 2021-11-06 | McDonough | Illinois | 17109 | 3815 | 78 |
1885509 | 1885509 | 2021-11-05 | McDonough | Illinois | 17109 | 3815 | 78 |
1810756 | 1810756 | 2021-10-13 | Iroquois | Illinois | 17075 | 4161 | 78 |
1807507 | 1807507 | 2021-10-12 | Iroquois | Illinois | 17075 | 4159 | 78 |
1804256 | 1804256 | 2021-10-11 | Iroquois | Illinois | 17075 | 4128 | 78 |
1801007 | 1801007 | 2021-10-10 | Iroquois | Illinois | 17075 | 4128 | 78 |
1797758 | 1797758 | 2021-10-09 | Iroquois | Illinois | 17075 | 4128 | 78 |
1794509 | 1794509 | 2021-10-08 | Iroquois | Illinois | 17075 | 4128 | 78 |
1791261 | 1791261 | 2021-10-07 | Iroquois | Illinois | 17075 | 4115 | 78 |
1788012 | 1788012 | 2021-10-06 | Iroquois | Illinois | 17075 | 4105 | 78 |
1784763 | 1784763 | 2021-10-05 | Iroquois | Illinois | 17075 | 4100 | 78 |
1781505 | 1781505 | 2021-10-04 | Fulton | Illinois | 17057 | 5031 | 78 |
1781514 | 1781514 | 2021-10-04 | Iroquois | Illinois | 17075 | 4086 | 78 |
1778255 | 1778255 | 2021-10-03 | Fulton | Illinois | 17057 | 5000 | 78 |
1778264 | 1778264 | 2021-10-03 | Iroquois | Illinois | 17075 | 4066 | 78 |
1775005 | 1775005 | 2021-10-02 | Fulton | Illinois | 17057 | 5000 | 78 |
1775014 | 1775014 | 2021-10-02 | Iroquois | Illinois | 17075 | 4066 | 78 |
1771755 | 1771755 | 2021-10-01 | Fulton | Illinois | 17057 | 5000 | 78 |
1771764 | 1771764 | 2021-10-01 | Iroquois | Illinois | 17075 | 4066 | 78 |
1768506 | 1768506 | 2021-09-30 | Fulton | Illinois | 17057 | 4984 | 78 |
1765257 | 1765257 | 2021-09-29 | Fulton | Illinois | 17057 | 4976 | 78 |
1762008 | 1762008 | 2021-09-28 | Fulton | Illinois | 17057 | 4960 | 78 |
1758760 | 1758760 | 2021-09-27 | Fulton | Illinois | 17057 | 4953 | 78 |
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);