ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 18081 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814111 | 1814111 | 2021-10-14 | Johnson | Indiana | 18081 | 24852 | 460 |
1810862 | 1810862 | 2021-10-13 | Johnson | Indiana | 18081 | 24775 | 457 |
1807613 | 1807613 | 2021-10-12 | Johnson | Indiana | 18081 | 24730 | 456 |
1804362 | 1804362 | 2021-10-11 | Johnson | Indiana | 18081 | 24698 | 455 |
1801113 | 1801113 | 2021-10-10 | Johnson | Indiana | 18081 | 24603 | 451 |
1797864 | 1797864 | 2021-10-09 | Johnson | Indiana | 18081 | 24603 | 451 |
1794615 | 1794615 | 2021-10-08 | Johnson | Indiana | 18081 | 24603 | 451 |
1791367 | 1791367 | 2021-10-07 | Johnson | Indiana | 18081 | 24517 | 451 |
1788118 | 1788118 | 2021-10-06 | Johnson | Indiana | 18081 | 24471 | 451 |
1784869 | 1784869 | 2021-10-05 | Johnson | Indiana | 18081 | 24402 | 449 |
1781620 | 1781620 | 2021-10-04 | Johnson | Indiana | 18081 | 24358 | 447 |
1778370 | 1778370 | 2021-10-03 | Johnson | Indiana | 18081 | 24225 | 445 |
1775120 | 1775120 | 2021-10-02 | Johnson | Indiana | 18081 | 24225 | 445 |
1771870 | 1771870 | 2021-10-01 | Johnson | Indiana | 18081 | 24225 | 445 |
1768621 | 1768621 | 2021-09-30 | Johnson | Indiana | 18081 | 24148 | 445 |
1765372 | 1765372 | 2021-09-29 | Johnson | Indiana | 18081 | 24070 | 444 |
1762123 | 1762123 | 2021-09-28 | Johnson | Indiana | 18081 | 24005 | 441 |
1758875 | 1758875 | 2021-09-27 | Johnson | Indiana | 18081 | 23932 | 439 |
1755627 | 1755627 | 2021-09-26 | Johnson | Indiana | 18081 | 23796 | 436 |
1752379 | 1752379 | 2021-09-25 | Johnson | Indiana | 18081 | 23796 | 436 |
1749130 | 1749130 | 2021-09-24 | Johnson | Indiana | 18081 | 23796 | 436 |
1745880 | 1745880 | 2021-09-23 | Johnson | Indiana | 18081 | 23754 | 435 |
1742631 | 1742631 | 2021-09-22 | Johnson | Indiana | 18081 | 23678 | 435 |
1739382 | 1739382 | 2021-09-21 | Johnson | Indiana | 18081 | 23593 | 435 |
1736133 | 1736133 | 2021-09-20 | Johnson | Indiana | 18081 | 23535 | 434 |
1732883 | 1732883 | 2021-09-19 | Johnson | Indiana | 18081 | 23336 | 433 |
1729633 | 1729633 | 2021-09-18 | Johnson | Indiana | 18081 | 23336 | 433 |
1726383 | 1726383 | 2021-09-17 | Johnson | Indiana | 18081 | 23336 | 433 |
1723134 | 1723134 | 2021-09-16 | Johnson | Indiana | 18081 | 23261 | 433 |
1719885 | 1719885 | 2021-09-15 | Johnson | Indiana | 18081 | 23176 | 432 |
1716637 | 1716637 | 2021-09-14 | Johnson | Indiana | 18081 | 23071 | 430 |
1713391 | 1713391 | 2021-09-13 | Johnson | Indiana | 18081 | 22966 | 429 |
1710144 | 1710144 | 2021-09-12 | Johnson | Indiana | 18081 | 22764 | 428 |
1706897 | 1706897 | 2021-09-11 | Johnson | Indiana | 18081 | 22764 | 428 |
1703649 | 1703649 | 2021-09-10 | Johnson | Indiana | 18081 | 22764 | 428 |
1700399 | 1700399 | 2021-09-09 | Johnson | Indiana | 18081 | 22623 | 428 |
1697150 | 1697150 | 2021-09-08 | Johnson | Indiana | 18081 | 22494 | 426 |
1693902 | 1693902 | 2021-09-07 | Johnson | Indiana | 18081 | 22423 | 424 |
1690653 | 1690653 | 2021-09-06 | Johnson | Indiana | 18081 | 22072 | 424 |
1687403 | 1687403 | 2021-09-05 | Johnson | Indiana | 18081 | 22072 | 424 |
1684153 | 1684153 | 2021-09-04 | Johnson | Indiana | 18081 | 22072 | 424 |
1680902 | 1680902 | 2021-09-03 | Johnson | Indiana | 18081 | 22072 | 424 |
1677654 | 1677654 | 2021-09-02 | Johnson | Indiana | 18081 | 21922 | 423 |
1674407 | 1674407 | 2021-09-01 | Johnson | Indiana | 18081 | 21770 | 422 |
1671158 | 1671158 | 2021-08-31 | Johnson | Indiana | 18081 | 21625 | 422 |
1667911 | 1667911 | 2021-08-30 | Johnson | Indiana | 18081 | 21534 | 420 |
1664664 | 1664664 | 2021-08-29 | Johnson | Indiana | 18081 | 21204 | 418 |
1661416 | 1661416 | 2021-08-28 | Johnson | Indiana | 18081 | 21204 | 418 |
1658168 | 1658168 | 2021-08-27 | Johnson | Indiana | 18081 | 21204 | 418 |
1654920 | 1654920 | 2021-08-26 | Johnson | Indiana | 18081 | 21056 | 419 |
1651673 | 1651673 | 2021-08-25 | Johnson | Indiana | 18081 | 20888 | 418 |
1648424 | 1648424 | 2021-08-24 | Johnson | Indiana | 18081 | 20743 | 417 |
1645176 | 1645176 | 2021-08-23 | Johnson | Indiana | 18081 | 20616 | 416 |
1641927 | 1641927 | 2021-08-22 | Johnson | Indiana | 18081 | 20327 | 416 |
1638677 | 1638677 | 2021-08-21 | Johnson | Indiana | 18081 | 20327 | 416 |
1635427 | 1635427 | 2021-08-20 | Johnson | Indiana | 18081 | 20327 | 416 |
1632177 | 1632177 | 2021-08-19 | Johnson | Indiana | 18081 | 20159 | 415 |
1628930 | 1628930 | 2021-08-18 | Johnson | Indiana | 18081 | 20077 | 414 |
1625683 | 1625683 | 2021-08-17 | Johnson | Indiana | 18081 | 19984 | 414 |
1622436 | 1622436 | 2021-08-16 | Johnson | Indiana | 18081 | 19912 | 414 |
1619189 | 1619189 | 2021-08-15 | Johnson | Indiana | 18081 | 19691 | 413 |
1615941 | 1615941 | 2021-08-14 | Johnson | Indiana | 18081 | 19691 | 413 |
1612692 | 1612692 | 2021-08-13 | Johnson | Indiana | 18081 | 19691 | 413 |
1609444 | 1609444 | 2021-08-12 | Johnson | Indiana | 18081 | 19610 | 413 |
1606195 | 1606195 | 2021-08-11 | Johnson | Indiana | 18081 | 19517 | 413 |
1602946 | 1602946 | 2021-08-10 | Johnson | Indiana | 18081 | 19441 | 413 |
1599697 | 1599697 | 2021-08-09 | Johnson | Indiana | 18081 | 19395 | 413 |
1596449 | 1596449 | 2021-08-08 | Johnson | Indiana | 18081 | 19249 | 412 |
1593200 | 1593200 | 2021-08-07 | Johnson | Indiana | 18081 | 19249 | 412 |
1589951 | 1589951 | 2021-08-06 | Johnson | Indiana | 18081 | 19249 | 412 |
1586702 | 1586702 | 2021-08-05 | Johnson | Indiana | 18081 | 19203 | 412 |
1583452 | 1583452 | 2021-08-04 | Johnson | Indiana | 18081 | 19134 | 412 |
1580202 | 1580202 | 2021-08-03 | Johnson | Indiana | 18081 | 19087 | 411 |
1576953 | 1576953 | 2021-08-02 | Johnson | Indiana | 18081 | 19057 | 411 |
1573705 | 1573705 | 2021-08-01 | Johnson | Indiana | 18081 | 18966 | 411 |
1570457 | 1570457 | 2021-07-31 | Johnson | Indiana | 18081 | 18966 | 411 |
1567209 | 1567209 | 2021-07-30 | Johnson | Indiana | 18081 | 18966 | 411 |
1563961 | 1563961 | 2021-07-29 | Johnson | Indiana | 18081 | 18947 | 411 |
1560713 | 1560713 | 2021-07-28 | Johnson | Indiana | 18081 | 18910 | 409 |
1557466 | 1557466 | 2021-07-27 | Johnson | Indiana | 18081 | 18889 | 409 |
1554219 | 1554219 | 2021-07-26 | Johnson | Indiana | 18081 | 18874 | 408 |
1550972 | 1550972 | 2021-07-25 | Johnson | Indiana | 18081 | 18822 | 408 |
1547725 | 1547725 | 2021-07-24 | Johnson | Indiana | 18081 | 18822 | 408 |
1544478 | 1544478 | 2021-07-23 | Johnson | Indiana | 18081 | 18822 | 408 |
1541230 | 1541230 | 2021-07-22 | Johnson | Indiana | 18081 | 18801 | 408 |
1537983 | 1537983 | 2021-07-21 | Johnson | Indiana | 18081 | 18777 | 408 |
1534735 | 1534735 | 2021-07-20 | Johnson | Indiana | 18081 | 18754 | 408 |
1531488 | 1531488 | 2021-07-19 | Johnson | Indiana | 18081 | 18746 | 407 |
1528241 | 1528241 | 2021-07-18 | Johnson | Indiana | 18081 | 18697 | 407 |
1524994 | 1524994 | 2021-07-17 | Johnson | Indiana | 18081 | 18697 | 407 |
1521746 | 1521746 | 2021-07-16 | Johnson | Indiana | 18081 | 18697 | 407 |
1518498 | 1518498 | 2021-07-15 | Johnson | Indiana | 18081 | 18683 | 407 |
1515251 | 1515251 | 2021-07-14 | Johnson | Indiana | 18081 | 18676 | 407 |
1512005 | 1512005 | 2021-07-13 | Johnson | Indiana | 18081 | 18662 | 407 |
1508758 | 1508758 | 2021-07-12 | Johnson | Indiana | 18081 | 18651 | 406 |
1505512 | 1505512 | 2021-07-11 | Johnson | Indiana | 18081 | 18633 | 406 |
1502266 | 1502266 | 2021-07-10 | Johnson | Indiana | 18081 | 18633 | 406 |
1499020 | 1499020 | 2021-07-09 | Johnson | Indiana | 18081 | 18633 | 406 |
1495773 | 1495773 | 2021-07-08 | Johnson | Indiana | 18081 | 18627 | 406 |
1492527 | 1492527 | 2021-07-07 | Johnson | Indiana | 18081 | 18611 | 406 |
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);