ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Fayette" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- …
state 1
- Illinois · 677 ✖
fips 1
- 17051 677
county 1
- Fayette · 677 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174822 | 2174822 | 2022-02-02 | Fayette | Illinois | 17051 | 6834 | 92 |
2171569 | 2171569 | 2022-02-01 | Fayette | Illinois | 17051 | 6809 | 92 |
2168316 | 2168316 | 2022-01-31 | Fayette | Illinois | 17051 | 6780 | 92 |
2165061 | 2165061 | 2022-01-30 | Fayette | Illinois | 17051 | 6682 | 91 |
2161806 | 2161806 | 2022-01-29 | Fayette | Illinois | 17051 | 6682 | 91 |
2158551 | 2158551 | 2022-01-28 | Fayette | Illinois | 17051 | 6682 | 91 |
2155297 | 2155297 | 2022-01-27 | Fayette | Illinois | 17051 | 6640 | 91 |
2152044 | 2152044 | 2022-01-26 | Fayette | Illinois | 17051 | 6599 | 91 |
2148792 | 2148792 | 2022-01-25 | Fayette | Illinois | 17051 | 6521 | 91 |
2145540 | 2145540 | 2022-01-24 | Fayette | Illinois | 17051 | 6445 | 90 |
2142285 | 2142285 | 2022-01-23 | Fayette | Illinois | 17051 | 6332 | 89 |
2139030 | 2139030 | 2022-01-22 | Fayette | Illinois | 17051 | 6332 | 89 |
2135774 | 2135774 | 2022-01-21 | Fayette | Illinois | 17051 | 6332 | 89 |
2132522 | 2132522 | 2022-01-20 | Fayette | Illinois | 17051 | 6263 | 88 |
2129269 | 2129269 | 2022-01-19 | Fayette | Illinois | 17051 | 6196 | 86 |
2126015 | 2126015 | 2022-01-18 | Fayette | Illinois | 17051 | 6069 | 85 |
2122763 | 2122763 | 2022-01-17 | Fayette | Illinois | 17051 | 5847 | 83 |
2119511 | 2119511 | 2022-01-16 | Fayette | Illinois | 17051 | 5847 | 83 |
2116259 | 2116259 | 2022-01-15 | Fayette | Illinois | 17051 | 5847 | 83 |
2113008 | 2113008 | 2022-01-14 | Fayette | Illinois | 17051 | 5847 | 83 |
2109756 | 2109756 | 2022-01-13 | Fayette | Illinois | 17051 | 5737 | 81 |
2106505 | 2106505 | 2022-01-12 | Fayette | Illinois | 17051 | 5654 | 81 |
2103254 | 2103254 | 2022-01-11 | Fayette | Illinois | 17051 | 5588 | 80 |
2100003 | 2100003 | 2022-01-10 | Fayette | Illinois | 17051 | 5524 | 80 |
2096752 | 2096752 | 2022-01-09 | Fayette | Illinois | 17051 | 5435 | 77 |
2093500 | 2093500 | 2022-01-08 | Fayette | Illinois | 17051 | 5435 | 77 |
2090248 | 2090248 | 2022-01-07 | Fayette | Illinois | 17051 | 5435 | 77 |
2086997 | 2086997 | 2022-01-06 | Fayette | Illinois | 17051 | 5390 | 76 |
2083745 | 2083745 | 2022-01-05 | Fayette | Illinois | 17051 | 5339 | 76 |
2080493 | 2080493 | 2022-01-04 | Fayette | Illinois | 17051 | 5288 | 76 |
2077241 | 2077241 | 2022-01-03 | Fayette | Illinois | 17051 | 5235 | 76 |
2073990 | 2073990 | 2022-01-02 | Fayette | Illinois | 17051 | 5161 | 76 |
2070739 | 2070739 | 2022-01-01 | Fayette | Illinois | 17051 | 5161 | 76 |
2067488 | 2067488 | 2021-12-31 | Fayette | Illinois | 17051 | 5161 | 76 |
2064237 | 2064237 | 2021-12-30 | Fayette | Illinois | 17051 | 5161 | 76 |
2060987 | 2060987 | 2021-12-29 | Fayette | Illinois | 17051 | 5105 | 75 |
2057738 | 2057738 | 2021-12-28 | Fayette | Illinois | 17051 | 5085 | 75 |
2054489 | 2054489 | 2021-12-27 | Fayette | Illinois | 17051 | 5045 | 75 |
2051239 | 2051239 | 2021-12-26 | Fayette | Illinois | 17051 | 5021 | 75 |
2047989 | 2047989 | 2021-12-25 | Fayette | Illinois | 17051 | 5021 | 75 |
2044739 | 2044739 | 2021-12-24 | Fayette | Illinois | 17051 | 5021 | 75 |
2041490 | 2041490 | 2021-12-23 | Fayette | Illinois | 17051 | 5021 | 75 |
2038240 | 2038240 | 2021-12-22 | Fayette | Illinois | 17051 | 4973 | 75 |
2034990 | 2034990 | 2021-12-21 | Fayette | Illinois | 17051 | 4946 | 75 |
2031740 | 2031740 | 2021-12-20 | Fayette | Illinois | 17051 | 4925 | 75 |
2028489 | 2028489 | 2021-12-19 | Fayette | Illinois | 17051 | 4883 | 75 |
2025238 | 2025238 | 2021-12-18 | Fayette | Illinois | 17051 | 4883 | 75 |
2021987 | 2021987 | 2021-12-17 | Fayette | Illinois | 17051 | 4883 | 75 |
2018736 | 2018736 | 2021-12-16 | Fayette | Illinois | 17051 | 4865 | 74 |
2015486 | 2015486 | 2021-12-15 | Fayette | Illinois | 17051 | 4847 | 74 |
2012235 | 2012235 | 2021-12-14 | Fayette | Illinois | 17051 | 4832 | 74 |
2008984 | 2008984 | 2021-12-13 | Fayette | Illinois | 17051 | 4817 | 74 |
2005733 | 2005733 | 2021-12-12 | Fayette | Illinois | 17051 | 4789 | 74 |
2002482 | 2002482 | 2021-12-11 | Fayette | Illinois | 17051 | 4789 | 74 |
1999232 | 1999232 | 2021-12-10 | Fayette | Illinois | 17051 | 4789 | 74 |
1995981 | 1995981 | 2021-12-09 | Fayette | Illinois | 17051 | 4777 | 74 |
1992730 | 1992730 | 2021-12-08 | Fayette | Illinois | 17051 | 4763 | 74 |
1989479 | 1989479 | 2021-12-07 | Fayette | Illinois | 17051 | 4756 | 74 |
1986229 | 1986229 | 2021-12-06 | Fayette | Illinois | 17051 | 4732 | 74 |
1982979 | 1982979 | 2021-12-05 | Fayette | Illinois | 17051 | 4702 | 74 |
1979729 | 1979729 | 2021-12-04 | Fayette | Illinois | 17051 | 4702 | 74 |
1976479 | 1976479 | 2021-12-03 | Fayette | Illinois | 17051 | 4702 | 74 |
1973230 | 1973230 | 2021-12-02 | Fayette | Illinois | 17051 | 4692 | 73 |
1969980 | 1969980 | 2021-12-01 | Fayette | Illinois | 17051 | 4670 | 73 |
1966730 | 1966730 | 2021-11-30 | Fayette | Illinois | 17051 | 4652 | 73 |
1963478 | 1963478 | 2021-11-29 | Fayette | Illinois | 17051 | 4629 | 73 |
1960227 | 1960227 | 2021-11-28 | Fayette | Illinois | 17051 | 4595 | 72 |
1956976 | 1956976 | 2021-11-27 | Fayette | Illinois | 17051 | 4595 | 72 |
1953725 | 1953725 | 2021-11-26 | Fayette | Illinois | 17051 | 4595 | 72 |
1950474 | 1950474 | 2021-11-25 | Fayette | Illinois | 17051 | 4595 | 72 |
1947223 | 1947223 | 2021-11-24 | Fayette | Illinois | 17051 | 4595 | 72 |
1943972 | 1943972 | 2021-11-23 | Fayette | Illinois | 17051 | 4567 | 72 |
1940722 | 1940722 | 2021-11-22 | Fayette | Illinois | 17051 | 4550 | 72 |
1937472 | 1937472 | 2021-11-21 | Fayette | Illinois | 17051 | 4534 | 72 |
1934222 | 1934222 | 2021-11-20 | Fayette | Illinois | 17051 | 4534 | 72 |
1930971 | 1930971 | 2021-11-19 | Fayette | Illinois | 17051 | 4534 | 72 |
1927720 | 1927720 | 2021-11-18 | Fayette | Illinois | 17051 | 4525 | 71 |
1924470 | 1924470 | 2021-11-17 | Fayette | Illinois | 17051 | 4522 | 71 |
1921221 | 1921221 | 2021-11-16 | Fayette | Illinois | 17051 | 4510 | 70 |
1917971 | 1917971 | 2021-11-15 | Fayette | Illinois | 17051 | 4495 | 70 |
1914721 | 1914721 | 2021-11-14 | Fayette | Illinois | 17051 | 4465 | 70 |
1911471 | 1911471 | 2021-11-13 | Fayette | Illinois | 17051 | 4465 | 70 |
1908222 | 1908222 | 2021-11-12 | Fayette | Illinois | 17051 | 4465 | 70 |
1904973 | 1904973 | 2021-11-11 | Fayette | Illinois | 17051 | 4451 | 70 |
1901723 | 1901723 | 2021-11-10 | Fayette | Illinois | 17051 | 4451 | 70 |
1898473 | 1898473 | 2021-11-09 | Fayette | Illinois | 17051 | 4439 | 70 |
1895223 | 1895223 | 2021-11-08 | Fayette | Illinois | 17051 | 4426 | 70 |
1891973 | 1891973 | 2021-11-07 | Fayette | Illinois | 17051 | 4416 | 70 |
1888723 | 1888723 | 2021-11-06 | Fayette | Illinois | 17051 | 4416 | 70 |
1885473 | 1885473 | 2021-11-05 | Fayette | Illinois | 17051 | 4416 | 70 |
1882224 | 1882224 | 2021-11-04 | Fayette | Illinois | 17051 | 4404 | 69 |
1878975 | 1878975 | 2021-11-03 | Fayette | Illinois | 17051 | 4398 | 68 |
1875726 | 1875726 | 2021-11-02 | Fayette | Illinois | 17051 | 4393 | 68 |
1872477 | 1872477 | 2021-11-01 | Fayette | Illinois | 17051 | 4383 | 68 |
1869228 | 1869228 | 2021-10-31 | Fayette | Illinois | 17051 | 4370 | 68 |
1865979 | 1865979 | 2021-10-30 | Fayette | Illinois | 17051 | 4370 | 68 |
1862730 | 1862730 | 2021-10-29 | Fayette | Illinois | 17051 | 4370 | 68 |
1859481 | 1859481 | 2021-10-28 | Fayette | Illinois | 17051 | 4361 | 67 |
1856232 | 1856232 | 2021-10-27 | Fayette | Illinois | 17051 | 4354 | 67 |
1852983 | 1852983 | 2021-10-26 | Fayette | Illinois | 17051 | 4346 | 67 |
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);