ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Boone" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716602 | 1716602 | 2021-09-14 | Boone | Indiana | 18011 | 8203 | 115 |
1713356 | 1713356 | 2021-09-13 | Boone | Indiana | 18011 | 8172 | 115 |
1710109 | 1710109 | 2021-09-12 | Boone | Indiana | 18011 | 8089 | 115 |
1706862 | 1706862 | 2021-09-11 | Boone | Indiana | 18011 | 8089 | 115 |
1703614 | 1703614 | 2021-09-10 | Boone | Indiana | 18011 | 8089 | 115 |
1700364 | 1700364 | 2021-09-09 | Boone | Indiana | 18011 | 8055 | 115 |
1697115 | 1697115 | 2021-09-08 | Boone | Indiana | 18011 | 8023 | 114 |
1693867 | 1693867 | 2021-09-07 | Boone | Indiana | 18011 | 8009 | 114 |
1690618 | 1690618 | 2021-09-06 | Boone | Indiana | 18011 | 7904 | 114 |
1687368 | 1687368 | 2021-09-05 | Boone | Indiana | 18011 | 7904 | 114 |
1684118 | 1684118 | 2021-09-04 | Boone | Indiana | 18011 | 7904 | 114 |
1680867 | 1680867 | 2021-09-03 | Boone | Indiana | 18011 | 7904 | 114 |
1677619 | 1677619 | 2021-09-02 | Boone | Indiana | 18011 | 7887 | 114 |
1674372 | 1674372 | 2021-09-01 | Boone | Indiana | 18011 | 7844 | 114 |
1671123 | 1671123 | 2021-08-31 | Boone | Indiana | 18011 | 7821 | 114 |
1667876 | 1667876 | 2021-08-30 | Boone | Indiana | 18011 | 7801 | 112 |
1664629 | 1664629 | 2021-08-29 | Boone | Indiana | 18011 | 7718 | 111 |
1661381 | 1661381 | 2021-08-28 | Boone | Indiana | 18011 | 7718 | 111 |
1658133 | 1658133 | 2021-08-27 | Boone | Indiana | 18011 | 7718 | 111 |
1654885 | 1654885 | 2021-08-26 | Boone | Indiana | 18011 | 7691 | 111 |
1651638 | 1651638 | 2021-08-25 | Boone | Indiana | 18011 | 7667 | 111 |
1648389 | 1648389 | 2021-08-24 | Boone | Indiana | 18011 | 7648 | 111 |
1645141 | 1645141 | 2021-08-23 | Boone | Indiana | 18011 | 7639 | 111 |
1641892 | 1641892 | 2021-08-22 | Boone | Indiana | 18011 | 7590 | 111 |
1638642 | 1638642 | 2021-08-21 | Boone | Indiana | 18011 | 7590 | 111 |
1635392 | 1635392 | 2021-08-20 | Boone | Indiana | 18011 | 7590 | 111 |
1632142 | 1632142 | 2021-08-19 | Boone | Indiana | 18011 | 7574 | 111 |
1628895 | 1628895 | 2021-08-18 | Boone | Indiana | 18011 | 7553 | 111 |
1625648 | 1625648 | 2021-08-17 | Boone | Indiana | 18011 | 7537 | 110 |
1622401 | 1622401 | 2021-08-16 | Boone | Indiana | 18011 | 7522 | 110 |
1619154 | 1619154 | 2021-08-15 | Boone | Indiana | 18011 | 7481 | 110 |
1615906 | 1615906 | 2021-08-14 | Boone | Indiana | 18011 | 7481 | 110 |
1612657 | 1612657 | 2021-08-13 | Boone | Indiana | 18011 | 7481 | 110 |
1609409 | 1609409 | 2021-08-12 | Boone | Indiana | 18011 | 7464 | 110 |
1606160 | 1606160 | 2021-08-11 | Boone | Indiana | 18011 | 7437 | 110 |
1602911 | 1602911 | 2021-08-10 | Boone | Indiana | 18011 | 7414 | 110 |
1599662 | 1599662 | 2021-08-09 | Boone | Indiana | 18011 | 7407 | 110 |
1596414 | 1596414 | 2021-08-08 | Boone | Indiana | 18011 | 7377 | 109 |
1593165 | 1593165 | 2021-08-07 | Boone | Indiana | 18011 | 7377 | 109 |
1589916 | 1589916 | 2021-08-06 | Boone | Indiana | 18011 | 7377 | 109 |
1586667 | 1586667 | 2021-08-05 | Boone | Indiana | 18011 | 7365 | 109 |
1583417 | 1583417 | 2021-08-04 | Boone | Indiana | 18011 | 7336 | 109 |
1580167 | 1580167 | 2021-08-03 | Boone | Indiana | 18011 | 7308 | 109 |
1576918 | 1576918 | 2021-08-02 | Boone | Indiana | 18011 | 7298 | 109 |
1573670 | 1573670 | 2021-08-01 | Boone | Indiana | 18011 | 7255 | 109 |
1570422 | 1570422 | 2021-07-31 | Boone | Indiana | 18011 | 7255 | 109 |
1567174 | 1567174 | 2021-07-30 | Boone | Indiana | 18011 | 7255 | 109 |
1563926 | 1563926 | 2021-07-29 | Boone | Indiana | 18011 | 7240 | 109 |
1560678 | 1560678 | 2021-07-28 | Boone | Indiana | 18011 | 7230 | 109 |
1557431 | 1557431 | 2021-07-27 | Boone | Indiana | 18011 | 7203 | 109 |
1554184 | 1554184 | 2021-07-26 | Boone | Indiana | 18011 | 7192 | 109 |
1550937 | 1550937 | 2021-07-25 | Boone | Indiana | 18011 | 7164 | 109 |
1547690 | 1547690 | 2021-07-24 | Boone | Indiana | 18011 | 7164 | 109 |
1544443 | 1544443 | 2021-07-23 | Boone | Indiana | 18011 | 7164 | 109 |
1541195 | 1541195 | 2021-07-22 | Boone | Indiana | 18011 | 7156 | 109 |
1537948 | 1537948 | 2021-07-21 | Boone | Indiana | 18011 | 7146 | 109 |
1534700 | 1534700 | 2021-07-20 | Boone | Indiana | 18011 | 7142 | 109 |
1531453 | 1531453 | 2021-07-19 | Boone | Indiana | 18011 | 7131 | 109 |
1528206 | 1528206 | 2021-07-18 | Boone | Indiana | 18011 | 7111 | 109 |
1524959 | 1524959 | 2021-07-17 | Boone | Indiana | 18011 | 7111 | 109 |
1521711 | 1521711 | 2021-07-16 | Boone | Indiana | 18011 | 7111 | 109 |
1518463 | 1518463 | 2021-07-15 | Boone | Indiana | 18011 | 7106 | 109 |
1515216 | 1515216 | 2021-07-14 | Boone | Indiana | 18011 | 7100 | 109 |
1511970 | 1511970 | 2021-07-13 | Boone | Indiana | 18011 | 7098 | 109 |
1508723 | 1508723 | 2021-07-12 | Boone | Indiana | 18011 | 7088 | 109 |
1505477 | 1505477 | 2021-07-11 | Boone | Indiana | 18011 | 7078 | 109 |
1502231 | 1502231 | 2021-07-10 | Boone | Indiana | 18011 | 7078 | 109 |
1498985 | 1498985 | 2021-07-09 | Boone | Indiana | 18011 | 7078 | 109 |
1495738 | 1495738 | 2021-07-08 | Boone | Indiana | 18011 | 7075 | 109 |
1492492 | 1492492 | 2021-07-07 | Boone | Indiana | 18011 | 7066 | 108 |
1489245 | 1489245 | 2021-07-06 | Boone | Indiana | 18011 | 7062 | 108 |
1485998 | 1485998 | 2021-07-05 | Boone | Indiana | 18011 | 7054 | 108 |
1482752 | 1482752 | 2021-07-04 | Boone | Indiana | 18011 | 7054 | 108 |
1479505 | 1479505 | 2021-07-03 | Boone | Indiana | 18011 | 7054 | 108 |
1476259 | 1476259 | 2021-07-02 | Boone | Indiana | 18011 | 7054 | 108 |
1473013 | 1473013 | 2021-07-01 | Boone | Indiana | 18011 | 7049 | 108 |
1469767 | 1469767 | 2021-06-30 | Boone | Indiana | 18011 | 7044 | 108 |
1466522 | 1466522 | 2021-06-29 | Boone | Indiana | 18011 | 7039 | 106 |
1463277 | 1463277 | 2021-06-28 | Boone | Indiana | 18011 | 7031 | 106 |
1460032 | 1460032 | 2021-06-27 | Boone | Indiana | 18011 | 7016 | 106 |
1456787 | 1456787 | 2021-06-26 | Boone | Indiana | 18011 | 7016 | 106 |
1453542 | 1453542 | 2021-06-25 | Boone | Indiana | 18011 | 7016 | 106 |
1450296 | 1450296 | 2021-06-24 | Boone | Indiana | 18011 | 7013 | 106 |
1447051 | 1447051 | 2021-06-23 | Boone | Indiana | 18011 | 6998 | 107 |
1443806 | 1443806 | 2021-06-22 | Boone | Indiana | 18011 | 6995 | 107 |
1440561 | 1440561 | 2021-06-21 | Boone | Indiana | 18011 | 6991 | 107 |
1437314 | 1437314 | 2021-06-20 | Boone | Indiana | 18011 | 6985 | 107 |
1434067 | 1434067 | 2021-06-19 | Boone | Indiana | 18011 | 6985 | 107 |
1430821 | 1430821 | 2021-06-18 | Boone | Indiana | 18011 | 6962 | 107 |
1427576 | 1427576 | 2021-06-17 | Boone | Indiana | 18011 | 6958 | 107 |
1424331 | 1424331 | 2021-06-16 | Boone | Indiana | 18011 | 6951 | 107 |
1421083 | 1421083 | 2021-06-15 | Boone | Indiana | 18011 | 6941 | 107 |
1417838 | 1417838 | 2021-06-14 | Boone | Indiana | 18011 | 6936 | 107 |
1414592 | 1414592 | 2021-06-13 | Boone | Indiana | 18011 | 6930 | 107 |
1411347 | 1411347 | 2021-06-12 | Boone | Indiana | 18011 | 6930 | 107 |
1408102 | 1408102 | 2021-06-11 | Boone | Indiana | 18011 | 6928 | 107 |
1404856 | 1404856 | 2021-06-10 | Boone | Indiana | 18011 | 6925 | 107 |
1401611 | 1401611 | 2021-06-09 | Boone | Indiana | 18011 | 6923 | 107 |
1398366 | 1398366 | 2021-06-08 | Boone | Indiana | 18011 | 6922 | 107 |
1395119 | 1395119 | 2021-06-07 | Boone | Indiana | 18011 | 6916 | 107 |
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);