ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marion" and fips = 45067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1799568 | 1799568 | 2021-10-09 | Marion | South Carolina | 45067 | 5348 | 134 |
1796319 | 1796319 | 2021-10-08 | Marion | South Carolina | 45067 | 5348 | 134 |
1793070 | 1793070 | 2021-10-07 | Marion | South Carolina | 45067 | 5332 | 134 |
1789821 | 1789821 | 2021-10-06 | Marion | South Carolina | 45067 | 5318 | 133 |
1786573 | 1786573 | 2021-10-05 | Marion | South Carolina | 45067 | 5312 | 133 |
1783324 | 1783324 | 2021-10-04 | Marion | South Carolina | 45067 | 5304 | 133 |
1780075 | 1780075 | 2021-10-03 | Marion | South Carolina | 45067 | 5244 | 131 |
1776825 | 1776825 | 2021-10-02 | Marion | South Carolina | 45067 | 5244 | 131 |
1773575 | 1773575 | 2021-10-01 | Marion | South Carolina | 45067 | 5244 | 131 |
1770325 | 1770325 | 2021-09-30 | Marion | South Carolina | 45067 | 5219 | 131 |
1767076 | 1767076 | 2021-09-29 | Marion | South Carolina | 45067 | 5185 | 130 |
1763827 | 1763827 | 2021-09-28 | Marion | South Carolina | 45067 | 5166 | 130 |
1760578 | 1760578 | 2021-09-27 | Marion | South Carolina | 45067 | 5148 | 130 |
1757330 | 1757330 | 2021-09-26 | Marion | South Carolina | 45067 | 5075 | 128 |
1754082 | 1754082 | 2021-09-25 | Marion | South Carolina | 45067 | 5075 | 128 |
1750834 | 1750834 | 2021-09-24 | Marion | South Carolina | 45067 | 5075 | 128 |
1747585 | 1747585 | 2021-09-23 | Marion | South Carolina | 45067 | 5046 | 126 |
1744335 | 1744335 | 2021-09-22 | Marion | South Carolina | 45067 | 5027 | 126 |
1741086 | 1741086 | 2021-09-21 | Marion | South Carolina | 45067 | 5012 | 123 |
1737837 | 1737837 | 2021-09-20 | Marion | South Carolina | 45067 | 4988 | 123 |
1734587 | 1734587 | 2021-09-19 | Marion | South Carolina | 45067 | 4866 | 122 |
1731337 | 1731337 | 2021-09-18 | Marion | South Carolina | 45067 | 4866 | 122 |
1728087 | 1728087 | 2021-09-17 | Marion | South Carolina | 45067 | 4866 | 122 |
1724838 | 1724838 | 2021-09-16 | Marion | South Carolina | 45067 | 4836 | 120 |
1721589 | 1721589 | 2021-09-15 | Marion | South Carolina | 45067 | 4816 | 120 |
1718341 | 1718341 | 2021-09-14 | Marion | South Carolina | 45067 | 4797 | 118 |
1715093 | 1715093 | 2021-09-13 | Marion | South Carolina | 45067 | 4751 | 118 |
1711847 | 1711847 | 2021-09-12 | Marion | South Carolina | 45067 | 4652 | 116 |
1708600 | 1708600 | 2021-09-11 | Marion | South Carolina | 45067 | 4652 | 116 |
1705353 | 1705353 | 2021-09-10 | Marion | South Carolina | 45067 | 4652 | 116 |
1702103 | 1702103 | 2021-09-09 | Marion | South Carolina | 45067 | 4638 | 116 |
1698854 | 1698854 | 2021-09-08 | Marion | South Carolina | 45067 | 4617 | 116 |
1695606 | 1695606 | 2021-09-07 | Marion | South Carolina | 45067 | 4599 | 116 |
1692358 | 1692358 | 2021-09-06 | Marion | South Carolina | 45067 | 4566 | 116 |
1689109 | 1689109 | 2021-09-05 | Marion | South Carolina | 45067 | 4443 | 114 |
1685859 | 1685859 | 2021-09-04 | Marion | South Carolina | 45067 | 4443 | 114 |
1682608 | 1682608 | 2021-09-03 | Marion | South Carolina | 45067 | 4443 | 114 |
1679358 | 1679358 | 2021-09-02 | Marion | South Carolina | 45067 | 4403 | 114 |
1676110 | 1676110 | 2021-09-01 | Marion | South Carolina | 45067 | 4371 | 113 |
1672863 | 1672863 | 2021-08-31 | Marion | South Carolina | 45067 | 4355 | 111 |
1669615 | 1669615 | 2021-08-30 | Marion | South Carolina | 45067 | 4337 | 111 |
1666368 | 1666368 | 2021-08-29 | Marion | South Carolina | 45067 | 4240 | 111 |
1663120 | 1663120 | 2021-08-28 | Marion | South Carolina | 45067 | 4240 | 111 |
1659872 | 1659872 | 2021-08-27 | Marion | South Carolina | 45067 | 4240 | 111 |
1656623 | 1656623 | 2021-08-26 | Marion | South Carolina | 45067 | 4214 | 111 |
1653376 | 1653376 | 2021-08-25 | Marion | South Carolina | 45067 | 4199 | 111 |
1650129 | 1650129 | 2021-08-24 | Marion | South Carolina | 45067 | 4190 | 110 |
1646880 | 1646880 | 2021-08-23 | Marion | South Carolina | 45067 | 4164 | 110 |
1643631 | 1643631 | 2021-08-22 | Marion | South Carolina | 45067 | 4078 | 110 |
1640381 | 1640381 | 2021-08-21 | Marion | South Carolina | 45067 | 4078 | 110 |
1637131 | 1637131 | 2021-08-20 | Marion | South Carolina | 45067 | 4078 | 110 |
1633881 | 1633881 | 2021-08-19 | Marion | South Carolina | 45067 | 4048 | 110 |
1630634 | 1630634 | 2021-08-18 | Marion | South Carolina | 45067 | 4043 | 109 |
1627387 | 1627387 | 2021-08-17 | Marion | South Carolina | 45067 | 4035 | 109 |
1624140 | 1624140 | 2021-08-16 | Marion | South Carolina | 45067 | 4012 | 109 |
1620893 | 1620893 | 2021-08-15 | Marion | South Carolina | 45067 | 3925 | 108 |
1617645 | 1617645 | 2021-08-14 | Marion | South Carolina | 45067 | 3925 | 108 |
1614397 | 1614397 | 2021-08-13 | Marion | South Carolina | 45067 | 3925 | 108 |
1611148 | 1611148 | 2021-08-12 | Marion | South Carolina | 45067 | 3883 | 108 |
1607900 | 1607900 | 2021-08-11 | Marion | South Carolina | 45067 | 3865 | 108 |
1604651 | 1604651 | 2021-08-10 | Marion | South Carolina | 45067 | 3855 | 108 |
1601402 | 1601402 | 2021-08-09 | Marion | South Carolina | 45067 | 3838 | 108 |
1598154 | 1598154 | 2021-08-08 | Marion | South Carolina | 45067 | 3760 | 108 |
1594905 | 1594905 | 2021-08-07 | Marion | South Carolina | 45067 | 3760 | 108 |
1591656 | 1591656 | 2021-08-06 | Marion | South Carolina | 45067 | 3760 | 108 |
1588407 | 1588407 | 2021-08-05 | Marion | South Carolina | 45067 | 3742 | 108 |
1585157 | 1585157 | 2021-08-04 | Marion | South Carolina | 45067 | 3731 | 108 |
1581907 | 1581907 | 2021-08-03 | Marion | South Carolina | 45067 | 3719 | 108 |
1578658 | 1578658 | 2021-08-02 | Marion | South Carolina | 45067 | 3714 | 108 |
1575410 | 1575410 | 2021-08-01 | Marion | South Carolina | 45067 | 3685 | 108 |
1572162 | 1572162 | 2021-07-31 | Marion | South Carolina | 45067 | 3685 | 108 |
1568914 | 1568914 | 2021-07-30 | Marion | South Carolina | 45067 | 3685 | 108 |
1565666 | 1565666 | 2021-07-29 | Marion | South Carolina | 45067 | 3678 | 108 |
1562418 | 1562418 | 2021-07-28 | Marion | South Carolina | 45067 | 3666 | 108 |
1559170 | 1559170 | 2021-07-27 | Marion | South Carolina | 45067 | 3658 | 108 |
1555923 | 1555923 | 2021-07-26 | Marion | South Carolina | 45067 | 3644 | 108 |
1552676 | 1552676 | 2021-07-25 | Marion | South Carolina | 45067 | 3617 | 108 |
1549429 | 1549429 | 2021-07-24 | Marion | South Carolina | 45067 | 3617 | 108 |
1546182 | 1546182 | 2021-07-23 | Marion | South Carolina | 45067 | 3617 | 108 |
1542935 | 1542935 | 2021-07-22 | Marion | South Carolina | 45067 | 3601 | 108 |
1539687 | 1539687 | 2021-07-21 | Marion | South Carolina | 45067 | 3597 | 108 |
1536440 | 1536440 | 2021-07-20 | Marion | South Carolina | 45067 | 3598 | 108 |
1533192 | 1533192 | 2021-07-19 | Marion | South Carolina | 45067 | 3595 | 108 |
1529945 | 1529945 | 2021-07-18 | Marion | South Carolina | 45067 | 3580 | 108 |
1526698 | 1526698 | 2021-07-17 | Marion | South Carolina | 45067 | 3580 | 108 |
1523451 | 1523451 | 2021-07-16 | Marion | South Carolina | 45067 | 3580 | 108 |
1520203 | 1520203 | 2021-07-15 | Marion | South Carolina | 45067 | 3578 | 108 |
1516955 | 1516955 | 2021-07-14 | Marion | South Carolina | 45067 | 3577 | 108 |
1513708 | 1513708 | 2021-07-13 | Marion | South Carolina | 45067 | 3576 | 108 |
1510462 | 1510462 | 2021-07-12 | Marion | South Carolina | 45067 | 3574 | 108 |
1507215 | 1507215 | 2021-07-11 | Marion | South Carolina | 45067 | 3575 | 108 |
1503969 | 1503969 | 2021-07-10 | Marion | South Carolina | 45067 | 3575 | 108 |
1500723 | 1500723 | 2021-07-09 | Marion | South Carolina | 45067 | 3575 | 108 |
1497477 | 1497477 | 2021-07-08 | Marion | South Carolina | 45067 | 3572 | 108 |
1494230 | 1494230 | 2021-07-07 | Marion | South Carolina | 45067 | 3572 | 108 |
1490983 | 1490983 | 2021-07-06 | Marion | South Carolina | 45067 | 3572 | 108 |
1487736 | 1487736 | 2021-07-05 | Marion | South Carolina | 45067 | 3571 | 108 |
1484489 | 1484489 | 2021-07-04 | Marion | South Carolina | 45067 | 3568 | 108 |
1481243 | 1481243 | 2021-07-03 | Marion | South Carolina | 45067 | 3568 | 108 |
1477996 | 1477996 | 2021-07-02 | Marion | South Carolina | 45067 | 3568 | 108 |
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);