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 |
---|---|---|---|---|---|---|---|
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 |
1849831 | 1849831 | 2021-10-25 | Elkhart | Indiana | 18039 | 36148 | 529 |
1846581 | 1846581 | 2021-10-24 | Elkhart | Indiana | 18039 | 36053 | 529 |
1843331 | 1843331 | 2021-10-23 | Elkhart | Indiana | 18039 | 36053 | 529 |
1840081 | 1840081 | 2021-10-22 | Elkhart | Indiana | 18039 | 36053 | 529 |
1836832 | 1836832 | 2021-10-21 | Elkhart | Indiana | 18039 | 35992 | 528 |
1833583 | 1833583 | 2021-10-20 | Elkhart | Indiana | 18039 | 35911 | 527 |
1830334 | 1830334 | 2021-10-19 | Elkhart | Indiana | 18039 | 35856 | 527 |
1827085 | 1827085 | 2021-10-18 | Elkhart | Indiana | 18039 | 35800 | 526 |
1823836 | 1823836 | 2021-10-17 | Elkhart | Indiana | 18039 | 35649 | 521 |
1820587 | 1820587 | 2021-10-16 | Elkhart | Indiana | 18039 | 35649 | 521 |
1817338 | 1817338 | 2021-10-15 | Elkhart | Indiana | 18039 | 35649 | 521 |
1814090 | 1814090 | 2021-10-14 | Elkhart | Indiana | 18039 | 35570 | 520 |
1810841 | 1810841 | 2021-10-13 | Elkhart | Indiana | 18039 | 35477 | 520 |
1807592 | 1807592 | 2021-10-12 | Elkhart | Indiana | 18039 | 35382 | 518 |
1804341 | 1804341 | 2021-10-11 | Elkhart | Indiana | 18039 | 35321 | 518 |
1801092 | 1801092 | 2021-10-10 | Elkhart | Indiana | 18039 | 35179 | 517 |
1797843 | 1797843 | 2021-10-09 | Elkhart | Indiana | 18039 | 35179 | 517 |
1794594 | 1794594 | 2021-10-08 | Elkhart | Indiana | 18039 | 35179 | 517 |
1791346 | 1791346 | 2021-10-07 | Elkhart | Indiana | 18039 | 35044 | 516 |
1788097 | 1788097 | 2021-10-06 | Elkhart | Indiana | 18039 | 34922 | 515 |
1784848 | 1784848 | 2021-10-05 | Elkhart | Indiana | 18039 | 34822 | 514 |
1781599 | 1781599 | 2021-10-04 | Elkhart | Indiana | 18039 | 34742 | 513 |
1778349 | 1778349 | 2021-10-03 | Elkhart | Indiana | 18039 | 34539 | 511 |
1775099 | 1775099 | 2021-10-02 | Elkhart | Indiana | 18039 | 34539 | 511 |
1771849 | 1771849 | 2021-10-01 | Elkhart | Indiana | 18039 | 34539 | 511 |
1768600 | 1768600 | 2021-09-30 | Elkhart | Indiana | 18039 | 34423 | 511 |
1765351 | 1765351 | 2021-09-29 | Elkhart | Indiana | 18039 | 34298 | 510 |
1762102 | 1762102 | 2021-09-28 | Elkhart | Indiana | 18039 | 34180 | 510 |
1758854 | 1758854 | 2021-09-27 | Elkhart | Indiana | 18039 | 34101 | 509 |
1755606 | 1755606 | 2021-09-26 | Elkhart | Indiana | 18039 | 33905 | 508 |
1752358 | 1752358 | 2021-09-25 | Elkhart | Indiana | 18039 | 33905 | 508 |
1749109 | 1749109 | 2021-09-24 | Elkhart | Indiana | 18039 | 33905 | 508 |
1745859 | 1745859 | 2021-09-23 | Elkhart | Indiana | 18039 | 33753 | 508 |
1742610 | 1742610 | 2021-09-22 | Elkhart | Indiana | 18039 | 33647 | 507 |
1739361 | 1739361 | 2021-09-21 | Elkhart | Indiana | 18039 | 33553 | 506 |
1736112 | 1736112 | 2021-09-20 | Elkhart | Indiana | 18039 | 33442 | 505 |
1732862 | 1732862 | 2021-09-19 | Elkhart | Indiana | 18039 | 33231 | 505 |
1729612 | 1729612 | 2021-09-18 | Elkhart | Indiana | 18039 | 33231 | 505 |
1726362 | 1726362 | 2021-09-17 | Elkhart | Indiana | 18039 | 33231 | 505 |
1723113 | 1723113 | 2021-09-16 | Elkhart | Indiana | 18039 | 33109 | 504 |
1719864 | 1719864 | 2021-09-15 | Elkhart | Indiana | 18039 | 32933 | 502 |
1716616 | 1716616 | 2021-09-14 | Elkhart | Indiana | 18039 | 32784 | 502 |
1713370 | 1713370 | 2021-09-13 | Elkhart | Indiana | 18039 | 32659 | 499 |
1710123 | 1710123 | 2021-09-12 | Elkhart | Indiana | 18039 | 32364 | 497 |
1706876 | 1706876 | 2021-09-11 | Elkhart | Indiana | 18039 | 32364 | 497 |
1703628 | 1703628 | 2021-09-10 | Elkhart | Indiana | 18039 | 32364 | 497 |
1700378 | 1700378 | 2021-09-09 | Elkhart | Indiana | 18039 | 32224 | 497 |
1697129 | 1697129 | 2021-09-08 | Elkhart | Indiana | 18039 | 32068 | 496 |
1693881 | 1693881 | 2021-09-07 | Elkhart | Indiana | 18039 | 32028 | 495 |
1690632 | 1690632 | 2021-09-06 | Elkhart | Indiana | 18039 | 31640 | 495 |
1687382 | 1687382 | 2021-09-05 | Elkhart | Indiana | 18039 | 31640 | 495 |
1684132 | 1684132 | 2021-09-04 | Elkhart | Indiana | 18039 | 31640 | 495 |
1680881 | 1680881 | 2021-09-03 | Elkhart | Indiana | 18039 | 31640 | 495 |
1677633 | 1677633 | 2021-09-02 | Elkhart | Indiana | 18039 | 31537 | 495 |
1674386 | 1674386 | 2021-09-01 | Elkhart | Indiana | 18039 | 31429 | 495 |
1671137 | 1671137 | 2021-08-31 | Elkhart | Indiana | 18039 | 31311 | 495 |
1667890 | 1667890 | 2021-08-30 | Elkhart | Indiana | 18039 | 31224 | 495 |
1664643 | 1664643 | 2021-08-29 | Elkhart | Indiana | 18039 | 31070 | 494 |
1661395 | 1661395 | 2021-08-28 | Elkhart | Indiana | 18039 | 31070 | 494 |
1658147 | 1658147 | 2021-08-27 | Elkhart | Indiana | 18039 | 31070 | 494 |
1654899 | 1654899 | 2021-08-26 | Elkhart | Indiana | 18039 | 30958 | 494 |
1651652 | 1651652 | 2021-08-25 | Elkhart | Indiana | 18039 | 30868 | 493 |
1648403 | 1648403 | 2021-08-24 | Elkhart | Indiana | 18039 | 30809 | 493 |
1645155 | 1645155 | 2021-08-23 | Elkhart | Indiana | 18039 | 30745 | 493 |
1641906 | 1641906 | 2021-08-22 | Elkhart | Indiana | 18039 | 30655 | 492 |
1638656 | 1638656 | 2021-08-21 | Elkhart | Indiana | 18039 | 30655 | 492 |
1635406 | 1635406 | 2021-08-20 | Elkhart | Indiana | 18039 | 30655 | 492 |
1632156 | 1632156 | 2021-08-19 | Elkhart | Indiana | 18039 | 30592 | 492 |
1628909 | 1628909 | 2021-08-18 | Elkhart | Indiana | 18039 | 30551 | 490 |
1625662 | 1625662 | 2021-08-17 | Elkhart | Indiana | 18039 | 30499 | 490 |
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);