ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18039 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174919 | 2174919 | 2022-02-02 | Elkhart | Indiana | 18039 | 53013 | 684 |
2171666 | 2171666 | 2022-02-01 | Elkhart | Indiana | 18039 | 52889 | 679 |
2168413 | 2168413 | 2022-01-31 | Elkhart | Indiana | 18039 | 52730 | 678 |
2165158 | 2165158 | 2022-01-30 | Elkhart | Indiana | 18039 | 52283 | 676 |
2161903 | 2161903 | 2022-01-29 | Elkhart | Indiana | 18039 | 52283 | 676 |
2158648 | 2158648 | 2022-01-28 | Elkhart | Indiana | 18039 | 52283 | 676 |
2155394 | 2155394 | 2022-01-27 | Elkhart | Indiana | 18039 | 51813 | 675 |
2152141 | 2152141 | 2022-01-26 | Elkhart | Indiana | 18039 | 51587 | 674 |
2148889 | 2148889 | 2022-01-25 | Elkhart | Indiana | 18039 | 51486 | 671 |
2145637 | 2145637 | 2022-01-24 | Elkhart | Indiana | 18039 | 51165 | 668 |
2142382 | 2142382 | 2022-01-23 | Elkhart | Indiana | 18039 | 50146 | 666 |
2139127 | 2139127 | 2022-01-22 | Elkhart | Indiana | 18039 | 50146 | 666 |
2135871 | 2135871 | 2022-01-21 | Elkhart | Indiana | 18039 | 50146 | 666 |
2132619 | 2132619 | 2022-01-20 | Elkhart | Indiana | 18039 | 49503 | 662 |
2129366 | 2129366 | 2022-01-19 | Elkhart | Indiana | 18039 | 49023 | 659 |
2126112 | 2126112 | 2022-01-18 | Elkhart | Indiana | 18039 | 48521 | 657 |
2122860 | 2122860 | 2022-01-17 | Elkhart | Indiana | 18039 | 48218 | 656 |
2119608 | 2119608 | 2022-01-16 | Elkhart | Indiana | 18039 | 47414 | 655 |
2116356 | 2116356 | 2022-01-15 | Elkhart | Indiana | 18039 | 47414 | 655 |
2113105 | 2113105 | 2022-01-14 | Elkhart | Indiana | 18039 | 47414 | 655 |
2109853 | 2109853 | 2022-01-13 | Elkhart | Indiana | 18039 | 47050 | 655 |
2106602 | 2106602 | 2022-01-12 | Elkhart | Indiana | 18039 | 46668 | 652 |
2103351 | 2103351 | 2022-01-11 | Elkhart | Indiana | 18039 | 46321 | 644 |
2100100 | 2100100 | 2022-01-10 | Elkhart | Indiana | 18039 | 46004 | 640 |
2096849 | 2096849 | 2022-01-09 | Elkhart | Indiana | 18039 | 45106 | 637 |
2093597 | 2093597 | 2022-01-08 | Elkhart | Indiana | 18039 | 45106 | 637 |
2090345 | 2090345 | 2022-01-07 | Elkhart | Indiana | 18039 | 45106 | 637 |
2087094 | 2087094 | 2022-01-06 | Elkhart | Indiana | 18039 | 44891 | 636 |
2083842 | 2083842 | 2022-01-05 | Elkhart | Indiana | 18039 | 44551 | 633 |
2080590 | 2080590 | 2022-01-04 | Elkhart | Indiana | 18039 | 44274 | 628 |
2077338 | 2077338 | 2022-01-03 | Elkhart | Indiana | 18039 | 44067 | 623 |
2074087 | 2074087 | 2022-01-02 | Elkhart | Indiana | 18039 | 43635 | 620 |
2070836 | 2070836 | 2022-01-01 | Elkhart | Indiana | 18039 | 43635 | 620 |
2067585 | 2067585 | 2021-12-31 | Elkhart | Indiana | 18039 | 43635 | 620 |
2064334 | 2064334 | 2021-12-30 | Elkhart | Indiana | 18039 | 43635 | 620 |
2061084 | 2061084 | 2021-12-29 | Elkhart | Indiana | 18039 | 43354 | 617 |
2057835 | 2057835 | 2021-12-28 | Elkhart | Indiana | 18039 | 43185 | 615 |
2054586 | 2054586 | 2021-12-27 | Elkhart | Indiana | 18039 | 43062 | 608 |
2051336 | 2051336 | 2021-12-26 | Elkhart | Indiana | 18039 | 42720 | 605 |
2048086 | 2048086 | 2021-12-25 | Elkhart | Indiana | 18039 | 42720 | 605 |
2044836 | 2044836 | 2021-12-24 | Elkhart | Indiana | 18039 | 42720 | 605 |
2041587 | 2041587 | 2021-12-23 | Elkhart | Indiana | 18039 | 42720 | 605 |
2038337 | 2038337 | 2021-12-22 | Elkhart | Indiana | 18039 | 42720 | 605 |
2035087 | 2035087 | 2021-12-21 | Elkhart | Indiana | 18039 | 42630 | 602 |
2031837 | 2031837 | 2021-12-20 | Elkhart | Indiana | 18039 | 42533 | 596 |
2028586 | 2028586 | 2021-12-19 | Elkhart | Indiana | 18039 | 42237 | 591 |
2025335 | 2025335 | 2021-12-18 | Elkhart | Indiana | 18039 | 42237 | 591 |
2022084 | 2022084 | 2021-12-17 | Elkhart | Indiana | 18039 | 42237 | 591 |
2018833 | 2018833 | 2021-12-16 | Elkhart | Indiana | 18039 | 42096 | 591 |
2015583 | 2015583 | 2021-12-15 | Elkhart | Indiana | 18039 | 41884 | 589 |
2012332 | 2012332 | 2021-12-14 | Elkhart | Indiana | 18039 | 41766 | 585 |
2009081 | 2009081 | 2021-12-13 | Elkhart | Indiana | 18039 | 41633 | 584 |
2005830 | 2005830 | 2021-12-12 | Elkhart | Indiana | 18039 | 41350 | 580 |
2002579 | 2002579 | 2021-12-11 | Elkhart | Indiana | 18039 | 41350 | 580 |
1999329 | 1999329 | 2021-12-10 | Elkhart | Indiana | 18039 | 41350 | 580 |
1996078 | 1996078 | 2021-12-09 | Elkhart | Indiana | 18039 | 41216 | 578 |
1992827 | 1992827 | 2021-12-08 | Elkhart | Indiana | 18039 | 41008 | 576 |
1989576 | 1989576 | 2021-12-07 | Elkhart | Indiana | 18039 | 40877 | 572 |
1986326 | 1986326 | 2021-12-06 | Elkhart | Indiana | 18039 | 40729 | 571 |
1983076 | 1983076 | 2021-12-05 | Elkhart | Indiana | 18039 | 40378 | 570 |
1979826 | 1979826 | 2021-12-04 | Elkhart | Indiana | 18039 | 40378 | 570 |
1976576 | 1976576 | 2021-12-03 | Elkhart | Indiana | 18039 | 40378 | 570 |
1973327 | 1973327 | 2021-12-02 | Elkhart | Indiana | 18039 | 40188 | 569 |
1970077 | 1970077 | 2021-12-01 | Elkhart | Indiana | 18039 | 39927 | 569 |
1966827 | 1966827 | 2021-11-30 | Elkhart | Indiana | 18039 | 39730 | 566 |
1963575 | 1963575 | 2021-11-29 | Elkhart | Indiana | 18039 | 39568 | 559 |
1960324 | 1960324 | 2021-11-28 | Elkhart | Indiana | 18039 | 39118 | 557 |
1957073 | 1957073 | 2021-11-27 | Elkhart | Indiana | 18039 | 39118 | 557 |
1953822 | 1953822 | 2021-11-26 | Elkhart | Indiana | 18039 | 39118 | 557 |
1950571 | 1950571 | 2021-11-25 | Elkhart | Indiana | 18039 | 39118 | 557 |
1947320 | 1947320 | 2021-11-24 | Elkhart | Indiana | 18039 | 39118 | 557 |
1944069 | 1944069 | 2021-11-23 | Elkhart | Indiana | 18039 | 38949 | 557 |
1940819 | 1940819 | 2021-11-22 | Elkhart | Indiana | 18039 | 38846 | 555 |
1937569 | 1937569 | 2021-11-21 | Elkhart | Indiana | 18039 | 38501 | 552 |
1934319 | 1934319 | 2021-11-20 | Elkhart | Indiana | 18039 | 38501 | 552 |
1931068 | 1931068 | 2021-11-19 | Elkhart | Indiana | 18039 | 38501 | 552 |
1927817 | 1927817 | 2021-11-18 | Elkhart | Indiana | 18039 | 38354 | 549 |
1924567 | 1924567 | 2021-11-17 | Elkhart | Indiana | 18039 | 38145 | 549 |
1921318 | 1921318 | 2021-11-16 | Elkhart | Indiana | 18039 | 38026 | 546 |
1918068 | 1918068 | 2021-11-15 | Elkhart | Indiana | 18039 | 37928 | 546 |
1914818 | 1914818 | 2021-11-14 | Elkhart | Indiana | 18039 | 37687 | 546 |
1911568 | 1911568 | 2021-11-13 | Elkhart | Indiana | 18039 | 37687 | 546 |
1908319 | 1908319 | 2021-11-12 | Elkhart | Indiana | 18039 | 37687 | 546 |
1905070 | 1905070 | 2021-11-11 | Elkhart | Indiana | 18039 | 37547 | 545 |
1901820 | 1901820 | 2021-11-10 | Elkhart | Indiana | 18039 | 37263 | 545 |
1898570 | 1898570 | 2021-11-09 | Elkhart | Indiana | 18039 | 37164 | 545 |
1895320 | 1895320 | 2021-11-08 | Elkhart | Indiana | 18039 | 37091 | 541 |
1892070 | 1892070 | 2021-11-07 | Elkhart | Indiana | 18039 | 36867 | 540 |
1888820 | 1888820 | 2021-11-06 | Elkhart | Indiana | 18039 | 36867 | 540 |
1885570 | 1885570 | 2021-11-05 | Elkhart | Indiana | 18039 | 36867 | 540 |
1882321 | 1882321 | 2021-11-04 | Elkhart | Indiana | 18039 | 36756 | 540 |
1879072 | 1879072 | 2021-11-03 | Elkhart | Indiana | 18039 | 36675 | 539 |
1875823 | 1875823 | 2021-11-02 | Elkhart | Indiana | 18039 | 36606 | 537 |
1872574 | 1872574 | 2021-11-01 | Elkhart | Indiana | 18039 | 36540 | 536 |
1869325 | 1869325 | 2021-10-31 | Elkhart | Indiana | 18039 | 36412 | 536 |
1866076 | 1866076 | 2021-10-30 | Elkhart | Indiana | 18039 | 36412 | 536 |
1862827 | 1862827 | 2021-10-29 | Elkhart | Indiana | 18039 | 36412 | 536 |
1859578 | 1859578 | 2021-10-28 | Elkhart | Indiana | 18039 | 36340 | 535 |
1856329 | 1856329 | 2021-10-27 | Elkhart | Indiana | 18039 | 36259 | 534 |
1853080 | 1853080 | 2021-10-26 | Elkhart | Indiana | 18039 | 36206 | 532 |
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);