ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Peoria" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109802 | 2109802 | 2022-01-13 | Peoria | Illinois | 17143 | 40275 | 486 |
2106551 | 2106551 | 2022-01-12 | Peoria | Illinois | 17143 | 39817 | 480 |
2103300 | 2103300 | 2022-01-11 | Peoria | Illinois | 17143 | 39419 | 476 |
2100049 | 2100049 | 2022-01-10 | Peoria | Illinois | 17143 | 39005 | 475 |
2096798 | 2096798 | 2022-01-09 | Peoria | Illinois | 17143 | 37833 | 470 |
2093546 | 2093546 | 2022-01-08 | Peoria | Illinois | 17143 | 37833 | 470 |
2090294 | 2090294 | 2022-01-07 | Peoria | Illinois | 17143 | 37833 | 470 |
2087043 | 2087043 | 2022-01-06 | Peoria | Illinois | 17143 | 37252 | 469 |
2083791 | 2083791 | 2022-01-05 | Peoria | Illinois | 17143 | 36771 | 458 |
2080539 | 2080539 | 2022-01-04 | Peoria | Illinois | 17143 | 36307 | 449 |
2077287 | 2077287 | 2022-01-03 | Peoria | Illinois | 17143 | 36026 | 449 |
2074036 | 2074036 | 2022-01-02 | Peoria | Illinois | 17143 | 34463 | 447 |
2070785 | 2070785 | 2022-01-01 | Peoria | Illinois | 17143 | 34463 | 447 |
2067534 | 2067534 | 2021-12-31 | Peoria | Illinois | 17143 | 34463 | 447 |
2064283 | 2064283 | 2021-12-30 | Peoria | Illinois | 17143 | 34463 | 447 |
2061033 | 2061033 | 2021-12-29 | Peoria | Illinois | 17143 | 34046 | 446 |
2057784 | 2057784 | 2021-12-28 | Peoria | Illinois | 17143 | 33570 | 442 |
2054535 | 2054535 | 2021-12-27 | Peoria | Illinois | 17143 | 33236 | 440 |
2051285 | 2051285 | 2021-12-26 | Peoria | Illinois | 17143 | 32053 | 437 |
2048035 | 2048035 | 2021-12-25 | Peoria | Illinois | 17143 | 32053 | 437 |
2044785 | 2044785 | 2021-12-24 | Peoria | Illinois | 17143 | 32053 | 437 |
2041536 | 2041536 | 2021-12-23 | Peoria | Illinois | 17143 | 32053 | 437 |
2038286 | 2038286 | 2021-12-22 | Peoria | Illinois | 17143 | 32053 | 437 |
2035036 | 2035036 | 2021-12-21 | Peoria | Illinois | 17143 | 31595 | 437 |
2031786 | 2031786 | 2021-12-20 | Peoria | Illinois | 17143 | 31571 | 437 |
2028535 | 2028535 | 2021-12-19 | Peoria | Illinois | 17143 | 31128 | 435 |
2025284 | 2025284 | 2021-12-18 | Peoria | Illinois | 17143 | 31128 | 435 |
2022033 | 2022033 | 2021-12-17 | Peoria | Illinois | 17143 | 31128 | 435 |
2018782 | 2018782 | 2021-12-16 | Peoria | Illinois | 17143 | 30959 | 435 |
2015532 | 2015532 | 2021-12-15 | Peoria | Illinois | 17143 | 30796 | 433 |
2012281 | 2012281 | 2021-12-14 | Peoria | Illinois | 17143 | 30452 | 427 |
2009030 | 2009030 | 2021-12-13 | Peoria | Illinois | 17143 | 30452 | 427 |
2005779 | 2005779 | 2021-12-12 | Peoria | Illinois | 17143 | 30153 | 426 |
2002528 | 2002528 | 2021-12-11 | Peoria | Illinois | 17143 | 30153 | 426 |
1999278 | 1999278 | 2021-12-10 | Peoria | Illinois | 17143 | 30153 | 426 |
1996027 | 1996027 | 2021-12-09 | Peoria | Illinois | 17143 | 30045 | 425 |
1992776 | 1992776 | 2021-12-08 | Peoria | Illinois | 17143 | 29931 | 424 |
1989525 | 1989525 | 2021-12-07 | Peoria | Illinois | 17143 | 29789 | 424 |
1986275 | 1986275 | 2021-12-06 | Peoria | Illinois | 17143 | 29649 | 424 |
1983025 | 1983025 | 2021-12-05 | Peoria | Illinois | 17143 | 29349 | 422 |
1979775 | 1979775 | 2021-12-04 | Peoria | Illinois | 17143 | 29349 | 422 |
1976525 | 1976525 | 2021-12-03 | Peoria | Illinois | 17143 | 29349 | 422 |
1973276 | 1973276 | 2021-12-02 | Peoria | Illinois | 17143 | 29258 | 422 |
1970026 | 1970026 | 2021-12-01 | Peoria | Illinois | 17143 | 29151 | 422 |
1966776 | 1966776 | 2021-11-30 | Peoria | Illinois | 17143 | 28981 | 422 |
1963524 | 1963524 | 2021-11-29 | Peoria | Illinois | 17143 | 28914 | 422 |
1960273 | 1960273 | 2021-11-28 | Peoria | Illinois | 17143 | 28580 | 420 |
1957022 | 1957022 | 2021-11-27 | Peoria | Illinois | 17143 | 28580 | 420 |
1953771 | 1953771 | 2021-11-26 | Peoria | Illinois | 17143 | 28580 | 420 |
1950520 | 1950520 | 2021-11-25 | Peoria | Illinois | 17143 | 28580 | 420 |
1947269 | 1947269 | 2021-11-24 | Peoria | Illinois | 17143 | 28580 | 420 |
1944018 | 1944018 | 2021-11-23 | Peoria | Illinois | 17143 | 28471 | 420 |
1940768 | 1940768 | 2021-11-22 | Peoria | Illinois | 17143 | 28404 | 420 |
1937518 | 1937518 | 2021-11-21 | Peoria | Illinois | 17143 | 28255 | 419 |
1934268 | 1934268 | 2021-11-20 | Peoria | Illinois | 17143 | 28255 | 419 |
1931017 | 1931017 | 2021-11-19 | Peoria | Illinois | 17143 | 28255 | 419 |
1927766 | 1927766 | 2021-11-18 | Peoria | Illinois | 17143 | 28135 | 419 |
1924516 | 1924516 | 2021-11-17 | Peoria | Illinois | 17143 | 28050 | 418 |
1921267 | 1921267 | 2021-11-16 | Peoria | Illinois | 17143 | 27984 | 418 |
1918017 | 1918017 | 2021-11-15 | Peoria | Illinois | 17143 | 27930 | 413 |
1914767 | 1914767 | 2021-11-14 | Peoria | Illinois | 17143 | 27817 | 413 |
1911517 | 1911517 | 2021-11-13 | Peoria | Illinois | 17143 | 27817 | 413 |
1908268 | 1908268 | 2021-11-12 | Peoria | Illinois | 17143 | 27817 | 413 |
1905019 | 1905019 | 2021-11-11 | Peoria | Illinois | 17143 | 27769 | 412 |
1901769 | 1901769 | 2021-11-10 | Peoria | Illinois | 17143 | 27721 | 412 |
1898519 | 1898519 | 2021-11-09 | Peoria | Illinois | 17143 | 27659 | 412 |
1895269 | 1895269 | 2021-11-08 | Peoria | Illinois | 17143 | 27611 | 410 |
1892019 | 1892019 | 2021-11-07 | Peoria | Illinois | 17143 | 27499 | 409 |
1888769 | 1888769 | 2021-11-06 | Peoria | Illinois | 17143 | 27499 | 409 |
1885519 | 1885519 | 2021-11-05 | Peoria | Illinois | 17143 | 27499 | 409 |
1882270 | 1882270 | 2021-11-04 | Peoria | Illinois | 17143 | 27463 | 409 |
1879021 | 1879021 | 2021-11-03 | Peoria | Illinois | 17143 | 27422 | 407 |
1875772 | 1875772 | 2021-11-02 | Peoria | Illinois | 17143 | 27384 | 407 |
1872523 | 1872523 | 2021-11-01 | Peoria | Illinois | 17143 | 27356 | 406 |
1869274 | 1869274 | 2021-10-31 | Peoria | Illinois | 17143 | 27278 | 405 |
1866025 | 1866025 | 2021-10-30 | Peoria | Illinois | 17143 | 27278 | 405 |
1862776 | 1862776 | 2021-10-29 | Peoria | Illinois | 17143 | 27278 | 405 |
1859527 | 1859527 | 2021-10-28 | Peoria | Illinois | 17143 | 27255 | 405 |
1856278 | 1856278 | 2021-10-27 | Peoria | Illinois | 17143 | 27225 | 405 |
1853029 | 1853029 | 2021-10-26 | Peoria | Illinois | 17143 | 27185 | 403 |
1849780 | 1849780 | 2021-10-25 | Peoria | Illinois | 17143 | 27170 | 403 |
1846530 | 1846530 | 2021-10-24 | Peoria | Illinois | 17143 | 27108 | 403 |
1843280 | 1843280 | 2021-10-23 | Peoria | Illinois | 17143 | 27108 | 403 |
1840030 | 1840030 | 2021-10-22 | Peoria | Illinois | 17143 | 27108 | 403 |
1836781 | 1836781 | 2021-10-21 | Peoria | Illinois | 17143 | 27081 | 403 |
1833532 | 1833532 | 2021-10-20 | Peoria | Illinois | 17143 | 27052 | 402 |
1830283 | 1830283 | 2021-10-19 | Peoria | Illinois | 17143 | 26990 | 400 |
1827034 | 1827034 | 2021-10-18 | Peoria | Illinois | 17143 | 26966 | 399 |
1823785 | 1823785 | 2021-10-17 | Peoria | Illinois | 17143 | 26885 | 399 |
1820536 | 1820536 | 2021-10-16 | Peoria | Illinois | 17143 | 26885 | 399 |
1817287 | 1817287 | 2021-10-15 | Peoria | Illinois | 17143 | 26885 | 399 |
1814039 | 1814039 | 2021-10-14 | Peoria | Illinois | 17143 | 26848 | 399 |
1810790 | 1810790 | 2021-10-13 | Peoria | Illinois | 17143 | 26813 | 399 |
1807541 | 1807541 | 2021-10-12 | Peoria | Illinois | 17143 | 26770 | 397 |
1804290 | 1804290 | 2021-10-11 | Peoria | Illinois | 17143 | 26733 | 396 |
1801041 | 1801041 | 2021-10-10 | Peoria | Illinois | 17143 | 26650 | 396 |
1797792 | 1797792 | 2021-10-09 | Peoria | Illinois | 17143 | 26650 | 396 |
1794543 | 1794543 | 2021-10-08 | Peoria | Illinois | 17143 | 26650 | 396 |
1791295 | 1791295 | 2021-10-07 | Peoria | Illinois | 17143 | 26620 | 396 |
1788046 | 1788046 | 2021-10-06 | Peoria | Illinois | 17143 | 26592 | 396 |
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);