ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Bristol" and state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812528 | 1812528 | 2021-10-13 | Bristol | Rhode Island | 44001 | 5930 | 149 |
1809279 | 1809279 | 2021-10-12 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1806029 | 1806029 | 2021-10-11 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1802779 | 1802779 | 2021-10-10 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1799530 | 1799530 | 2021-10-09 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1796281 | 1796281 | 2021-10-08 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1793032 | 1793032 | 2021-10-07 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1789783 | 1789783 | 2021-10-06 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1786535 | 1786535 | 2021-10-05 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1783286 | 1783286 | 2021-10-04 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1780037 | 1780037 | 2021-10-03 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1776787 | 1776787 | 2021-10-02 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1773537 | 1773537 | 2021-10-01 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1770287 | 1770287 | 2021-09-30 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1767038 | 1767038 | 2021-09-29 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1763789 | 1763789 | 2021-09-28 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1760540 | 1760540 | 2021-09-27 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1757292 | 1757292 | 2021-09-26 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1754044 | 1754044 | 2021-09-25 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1750796 | 1750796 | 2021-09-24 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1747547 | 1747547 | 2021-09-23 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1744297 | 1744297 | 2021-09-22 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1741048 | 1741048 | 2021-09-21 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1737799 | 1737799 | 2021-09-20 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1734549 | 1734549 | 2021-09-19 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1731299 | 1731299 | 2021-09-18 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1728049 | 1728049 | 2021-09-17 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1724800 | 1724800 | 2021-09-16 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1721551 | 1721551 | 2021-09-15 | Bristol | Rhode Island | 44001 | 5609 | 149 |
1718303 | 1718303 | 2021-09-14 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1715055 | 1715055 | 2021-09-13 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1711809 | 1711809 | 2021-09-12 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1708562 | 1708562 | 2021-09-11 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1705315 | 1705315 | 2021-09-10 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1702065 | 1702065 | 2021-09-09 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1698816 | 1698816 | 2021-09-08 | Bristol | Rhode Island | 44001 | 5533 | 148 |
1695568 | 1695568 | 2021-09-07 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1692320 | 1692320 | 2021-09-06 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1689071 | 1689071 | 2021-09-05 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1685821 | 1685821 | 2021-09-04 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1682570 | 1682570 | 2021-09-03 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1679320 | 1679320 | 2021-09-02 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1676072 | 1676072 | 2021-09-01 | Bristol | Rhode Island | 44001 | 5470 | 147 |
1672825 | 1672825 | 2021-08-31 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1669577 | 1669577 | 2021-08-30 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1666330 | 1666330 | 2021-08-29 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1663082 | 1663082 | 2021-08-28 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1659834 | 1659834 | 2021-08-27 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1656585 | 1656585 | 2021-08-26 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1653338 | 1653338 | 2021-08-25 | Bristol | Rhode Island | 44001 | 5421 | 147 |
1650091 | 1650091 | 2021-08-24 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1646842 | 1646842 | 2021-08-23 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1643593 | 1643593 | 2021-08-22 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1640343 | 1640343 | 2021-08-21 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1637093 | 1637093 | 2021-08-20 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1633843 | 1633843 | 2021-08-19 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1630596 | 1630596 | 2021-08-18 | Bristol | Rhode Island | 44001 | 5352 | 146 |
1627349 | 1627349 | 2021-08-17 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1624102 | 1624102 | 2021-08-16 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1620855 | 1620855 | 2021-08-15 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1617607 | 1617607 | 2021-08-14 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1614359 | 1614359 | 2021-08-13 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1611110 | 1611110 | 2021-08-12 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1607862 | 1607862 | 2021-08-11 | Bristol | Rhode Island | 44001 | 5318 | 146 |
1604613 | 1604613 | 2021-08-10 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1601364 | 1601364 | 2021-08-09 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1598116 | 1598116 | 2021-08-08 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1594867 | 1594867 | 2021-08-07 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1591618 | 1591618 | 2021-08-06 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1588369 | 1588369 | 2021-08-05 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1585119 | 1585119 | 2021-08-04 | Bristol | Rhode Island | 44001 | 5268 | 146 |
1581869 | 1581869 | 2021-08-03 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1578620 | 1578620 | 2021-08-02 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1575372 | 1575372 | 2021-08-01 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1572124 | 1572124 | 2021-07-31 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1568876 | 1568876 | 2021-07-30 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1565628 | 1565628 | 2021-07-29 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1562380 | 1562380 | 2021-07-28 | Bristol | Rhode Island | 44001 | 5236 | 146 |
1559132 | 1559132 | 2021-07-27 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1555885 | 1555885 | 2021-07-26 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1552638 | 1552638 | 2021-07-25 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1549391 | 1549391 | 2021-07-24 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1546144 | 1546144 | 2021-07-23 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1542897 | 1542897 | 2021-07-22 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1539649 | 1539649 | 2021-07-21 | Bristol | Rhode Island | 44001 | 5205 | 146 |
1536402 | 1536402 | 2021-07-20 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1533154 | 1533154 | 2021-07-19 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1529907 | 1529907 | 2021-07-18 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1526660 | 1526660 | 2021-07-17 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1523413 | 1523413 | 2021-07-16 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1520165 | 1520165 | 2021-07-15 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1516917 | 1516917 | 2021-07-14 | Bristol | Rhode Island | 44001 | 5192 | 146 |
1513670 | 1513670 | 2021-07-13 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1510424 | 1510424 | 2021-07-12 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1507177 | 1507177 | 2021-07-11 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1503931 | 1503931 | 2021-07-10 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1500685 | 1500685 | 2021-07-09 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1497439 | 1497439 | 2021-07-08 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1494192 | 1494192 | 2021-07-07 | Bristol | Rhode Island | 44001 | 5190 | 146 |
1490945 | 1490945 | 2021-07-06 | Bristol | Rhode Island | 44001 | 5187 | 145 |
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);