ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 18181 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814161 | 1814161 | 2021-10-14 | White | Indiana | 18181 | 4136 | 63 |
1810912 | 1810912 | 2021-10-13 | White | Indiana | 18181 | 4117 | 61 |
1807663 | 1807663 | 2021-10-12 | White | Indiana | 18181 | 4107 | 61 |
1804412 | 1804412 | 2021-10-11 | White | Indiana | 18181 | 4102 | 61 |
1801163 | 1801163 | 2021-10-10 | White | Indiana | 18181 | 4080 | 60 |
1797914 | 1797914 | 2021-10-09 | White | Indiana | 18181 | 4080 | 60 |
1794665 | 1794665 | 2021-10-08 | White | Indiana | 18181 | 4080 | 60 |
1791417 | 1791417 | 2021-10-07 | White | Indiana | 18181 | 4063 | 60 |
1788168 | 1788168 | 2021-10-06 | White | Indiana | 18181 | 4059 | 60 |
1784919 | 1784919 | 2021-10-05 | White | Indiana | 18181 | 4039 | 60 |
1781670 | 1781670 | 2021-10-04 | White | Indiana | 18181 | 4031 | 59 |
1778420 | 1778420 | 2021-10-03 | White | Indiana | 18181 | 4001 | 59 |
1775170 | 1775170 | 2021-10-02 | White | Indiana | 18181 | 4001 | 59 |
1771920 | 1771920 | 2021-10-01 | White | Indiana | 18181 | 4001 | 59 |
1768671 | 1768671 | 2021-09-30 | White | Indiana | 18181 | 3993 | 59 |
1765422 | 1765422 | 2021-09-29 | White | Indiana | 18181 | 3979 | 59 |
1762173 | 1762173 | 2021-09-28 | White | Indiana | 18181 | 3975 | 59 |
1758925 | 1758925 | 2021-09-27 | White | Indiana | 18181 | 3962 | 59 |
1755677 | 1755677 | 2021-09-26 | White | Indiana | 18181 | 3939 | 59 |
1752429 | 1752429 | 2021-09-25 | White | Indiana | 18181 | 3939 | 59 |
1749180 | 1749180 | 2021-09-24 | White | Indiana | 18181 | 3939 | 59 |
1745930 | 1745930 | 2021-09-23 | White | Indiana | 18181 | 3930 | 58 |
1742681 | 1742681 | 2021-09-22 | White | Indiana | 18181 | 3919 | 58 |
1739432 | 1739432 | 2021-09-21 | White | Indiana | 18181 | 3895 | 58 |
1736183 | 1736183 | 2021-09-20 | White | Indiana | 18181 | 3888 | 58 |
1732933 | 1732933 | 2021-09-19 | White | Indiana | 18181 | 3863 | 58 |
1729683 | 1729683 | 2021-09-18 | White | Indiana | 18181 | 3863 | 58 |
1726433 | 1726433 | 2021-09-17 | White | Indiana | 18181 | 3863 | 58 |
1723184 | 1723184 | 2021-09-16 | White | Indiana | 18181 | 3843 | 58 |
1719935 | 1719935 | 2021-09-15 | White | Indiana | 18181 | 3835 | 58 |
1716687 | 1716687 | 2021-09-14 | White | Indiana | 18181 | 3818 | 58 |
1713441 | 1713441 | 2021-09-13 | White | Indiana | 18181 | 3810 | 58 |
1710194 | 1710194 | 2021-09-12 | White | Indiana | 18181 | 3770 | 58 |
1706947 | 1706947 | 2021-09-11 | White | Indiana | 18181 | 3770 | 58 |
1703699 | 1703699 | 2021-09-10 | White | Indiana | 18181 | 3770 | 58 |
1700449 | 1700449 | 2021-09-09 | White | Indiana | 18181 | 3754 | 58 |
1697200 | 1697200 | 2021-09-08 | White | Indiana | 18181 | 3748 | 57 |
1693952 | 1693952 | 2021-09-07 | White | Indiana | 18181 | 3742 | 57 |
1690703 | 1690703 | 2021-09-06 | White | Indiana | 18181 | 3692 | 57 |
1687453 | 1687453 | 2021-09-05 | White | Indiana | 18181 | 3692 | 57 |
1684203 | 1684203 | 2021-09-04 | White | Indiana | 18181 | 3692 | 57 |
1680952 | 1680952 | 2021-09-03 | White | Indiana | 18181 | 3692 | 57 |
1677704 | 1677704 | 2021-09-02 | White | Indiana | 18181 | 3680 | 57 |
1674457 | 1674457 | 2021-09-01 | White | Indiana | 18181 | 3665 | 57 |
1671208 | 1671208 | 2021-08-31 | White | Indiana | 18181 | 3650 | 57 |
1667961 | 1667961 | 2021-08-30 | White | Indiana | 18181 | 3645 | 56 |
1664714 | 1664714 | 2021-08-29 | White | Indiana | 18181 | 3608 | 56 |
1661466 | 1661466 | 2021-08-28 | White | Indiana | 18181 | 3608 | 56 |
1658218 | 1658218 | 2021-08-27 | White | Indiana | 18181 | 3608 | 56 |
1654970 | 1654970 | 2021-08-26 | White | Indiana | 18181 | 3589 | 56 |
1651723 | 1651723 | 2021-08-25 | White | Indiana | 18181 | 3567 | 56 |
1648474 | 1648474 | 2021-08-24 | White | Indiana | 18181 | 3549 | 56 |
1645226 | 1645226 | 2021-08-23 | White | Indiana | 18181 | 3539 | 55 |
1641977 | 1641977 | 2021-08-22 | White | Indiana | 18181 | 3514 | 55 |
1638727 | 1638727 | 2021-08-21 | White | Indiana | 18181 | 3514 | 55 |
1635477 | 1635477 | 2021-08-20 | White | Indiana | 18181 | 3514 | 55 |
1632227 | 1632227 | 2021-08-19 | White | Indiana | 18181 | 3505 | 55 |
1628980 | 1628980 | 2021-08-18 | White | Indiana | 18181 | 3500 | 55 |
1625733 | 1625733 | 2021-08-17 | White | Indiana | 18181 | 3491 | 55 |
1622486 | 1622486 | 2021-08-16 | White | Indiana | 18181 | 3488 | 55 |
1619239 | 1619239 | 2021-08-15 | White | Indiana | 18181 | 3476 | 55 |
1615991 | 1615991 | 2021-08-14 | White | Indiana | 18181 | 3476 | 55 |
1612742 | 1612742 | 2021-08-13 | White | Indiana | 18181 | 3476 | 55 |
1609494 | 1609494 | 2021-08-12 | White | Indiana | 18181 | 3468 | 55 |
1606245 | 1606245 | 2021-08-11 | White | Indiana | 18181 | 3463 | 55 |
1602996 | 1602996 | 2021-08-10 | White | Indiana | 18181 | 3458 | 55 |
1599747 | 1599747 | 2021-08-09 | White | Indiana | 18181 | 3453 | 55 |
1596499 | 1596499 | 2021-08-08 | White | Indiana | 18181 | 3443 | 55 |
1593250 | 1593250 | 2021-08-07 | White | Indiana | 18181 | 3443 | 55 |
1590001 | 1590001 | 2021-08-06 | White | Indiana | 18181 | 3443 | 55 |
1586752 | 1586752 | 2021-08-05 | White | Indiana | 18181 | 3439 | 55 |
1583502 | 1583502 | 2021-08-04 | White | Indiana | 18181 | 3427 | 55 |
1580252 | 1580252 | 2021-08-03 | White | Indiana | 18181 | 3419 | 55 |
1577003 | 1577003 | 2021-08-02 | White | Indiana | 18181 | 3415 | 55 |
1573755 | 1573755 | 2021-08-01 | White | Indiana | 18181 | 3410 | 55 |
1570507 | 1570507 | 2021-07-31 | White | Indiana | 18181 | 3410 | 55 |
1567259 | 1567259 | 2021-07-30 | White | Indiana | 18181 | 3410 | 55 |
1564011 | 1564011 | 2021-07-29 | White | Indiana | 18181 | 3408 | 55 |
1560763 | 1560763 | 2021-07-28 | White | Indiana | 18181 | 3402 | 55 |
1557516 | 1557516 | 2021-07-27 | White | Indiana | 18181 | 3397 | 55 |
1554269 | 1554269 | 2021-07-26 | White | Indiana | 18181 | 3394 | 55 |
1551022 | 1551022 | 2021-07-25 | White | Indiana | 18181 | 3390 | 55 |
1547775 | 1547775 | 2021-07-24 | White | Indiana | 18181 | 3390 | 55 |
1544528 | 1544528 | 2021-07-23 | White | Indiana | 18181 | 3390 | 55 |
1541280 | 1541280 | 2021-07-22 | White | Indiana | 18181 | 3389 | 55 |
1538033 | 1538033 | 2021-07-21 | White | Indiana | 18181 | 3388 | 55 |
1534785 | 1534785 | 2021-07-20 | White | Indiana | 18181 | 3384 | 55 |
1531538 | 1531538 | 2021-07-19 | White | Indiana | 18181 | 3381 | 55 |
1528291 | 1528291 | 2021-07-18 | White | Indiana | 18181 | 3379 | 55 |
1525044 | 1525044 | 2021-07-17 | White | Indiana | 18181 | 3379 | 55 |
1521796 | 1521796 | 2021-07-16 | White | Indiana | 18181 | 3379 | 55 |
1518548 | 1518548 | 2021-07-15 | White | Indiana | 18181 | 3377 | 55 |
1515301 | 1515301 | 2021-07-14 | White | Indiana | 18181 | 3372 | 55 |
1512055 | 1512055 | 2021-07-13 | White | Indiana | 18181 | 3371 | 55 |
1508808 | 1508808 | 2021-07-12 | White | Indiana | 18181 | 3366 | 55 |
1505562 | 1505562 | 2021-07-11 | White | Indiana | 18181 | 3360 | 55 |
1502316 | 1502316 | 2021-07-10 | White | Indiana | 18181 | 3360 | 55 |
1499070 | 1499070 | 2021-07-09 | White | Indiana | 18181 | 3360 | 55 |
1495823 | 1495823 | 2021-07-08 | White | Indiana | 18181 | 3359 | 55 |
1492577 | 1492577 | 2021-07-07 | White | Indiana | 18181 | 3356 | 55 |
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);