ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where fips = 6073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1849330 | 1849330 | 2021-10-25 | San Diego | California | 6073 | 382920 | 4183 |
1846080 | 1846080 | 2021-10-24 | San Diego | California | 6073 | 382920 | 4183 |
1842830 | 1842830 | 2021-10-23 | San Diego | California | 6073 | 382920 | 4183 |
1839580 | 1839580 | 2021-10-22 | San Diego | California | 6073 | 382920 | 4183 |
1836331 | 1836331 | 2021-10-21 | San Diego | California | 6073 | 382533 | 4178 |
1833082 | 1833082 | 2021-10-20 | San Diego | California | 6073 | 382120 | 4170 |
1829833 | 1829833 | 2021-10-19 | San Diego | California | 6073 | 381783 | 4169 |
1826584 | 1826584 | 2021-10-18 | San Diego | California | 6073 | 381510 | 4163 |
1823335 | 1823335 | 2021-10-17 | San Diego | California | 6073 | 379944 | 4151 |
1820086 | 1820086 | 2021-10-16 | San Diego | California | 6073 | 379944 | 4151 |
1816837 | 1816837 | 2021-10-15 | San Diego | California | 6073 | 379944 | 4151 |
1813589 | 1813589 | 2021-10-14 | San Diego | California | 6073 | 379399 | 4141 |
1810340 | 1810340 | 2021-10-13 | San Diego | California | 6073 | 379091 | 4137 |
1807091 | 1807091 | 2021-10-12 | San Diego | California | 6073 | 378547 | 4124 |
1803840 | 1803840 | 2021-10-11 | San Diego | California | 6073 | 377873 | 4113 |
1800591 | 1800591 | 2021-10-10 | San Diego | California | 6073 | 376744 | 4111 |
1797342 | 1797342 | 2021-10-09 | San Diego | California | 6073 | 376744 | 4111 |
1794093 | 1794093 | 2021-10-08 | San Diego | California | 6073 | 376744 | 4111 |
1790845 | 1790845 | 2021-10-07 | San Diego | California | 6073 | 376399 | 4104 |
1787596 | 1787596 | 2021-10-06 | San Diego | California | 6073 | 376029 | 4092 |
1784347 | 1784347 | 2021-10-05 | San Diego | California | 6073 | 375360 | 4090 |
1781098 | 1781098 | 2021-10-04 | San Diego | California | 6073 | 374988 | 4081 |
1777848 | 1777848 | 2021-10-03 | San Diego | California | 6073 | 373289 | 4078 |
1774598 | 1774598 | 2021-10-02 | San Diego | California | 6073 | 373289 | 4078 |
1771348 | 1771348 | 2021-10-01 | San Diego | California | 6073 | 373289 | 4078 |
1768099 | 1768099 | 2021-09-30 | San Diego | California | 6073 | 372734 | 4066 |
1764850 | 1764850 | 2021-09-29 | San Diego | California | 6073 | 372208 | 4054 |
1761601 | 1761601 | 2021-09-28 | San Diego | California | 6073 | 371590 | 4054 |
1758353 | 1758353 | 2021-09-27 | San Diego | California | 6073 | 371249 | 4051 |
1755105 | 1755105 | 2021-09-26 | San Diego | California | 6073 | 368852 | 4039 |
1751857 | 1751857 | 2021-09-25 | San Diego | California | 6073 | 368852 | 4039 |
1748608 | 1748608 | 2021-09-24 | San Diego | California | 6073 | 368852 | 4039 |
1745358 | 1745358 | 2021-09-23 | San Diego | California | 6073 | 367967 | 4027 |
1742109 | 1742109 | 2021-09-22 | San Diego | California | 6073 | 367100 | 4021 |
1738860 | 1738860 | 2021-09-21 | San Diego | California | 6073 | 366414 | 4009 |
1735611 | 1735611 | 2021-09-20 | San Diego | California | 6073 | 366060 | 4006 |
1732361 | 1732361 | 2021-09-19 | San Diego | California | 6073 | 365683 | 4006 |
1729111 | 1729111 | 2021-09-18 | San Diego | California | 6073 | 364933 | 4002 |
1725861 | 1725861 | 2021-09-17 | San Diego | California | 6073 | 364307 | 3994 |
1722612 | 1722612 | 2021-09-16 | San Diego | California | 6073 | 363768 | 3983 |
1719363 | 1719363 | 2021-09-15 | San Diego | California | 6073 | 363039 | 3966 |
1716115 | 1716115 | 2021-09-14 | San Diego | California | 6073 | 362482 | 3961 |
1712869 | 1712869 | 2021-09-13 | San Diego | California | 6073 | 361893 | 3942 |
1709622 | 1709622 | 2021-09-12 | San Diego | California | 6073 | 361190 | 3942 |
1706375 | 1706375 | 2021-09-11 | San Diego | California | 6073 | 360008 | 3941 |
1703127 | 1703127 | 2021-09-10 | San Diego | California | 6073 | 358984 | 3929 |
1699877 | 1699877 | 2021-09-09 | San Diego | California | 6073 | 358272 | 3926 |
1696628 | 1696628 | 2021-09-08 | San Diego | California | 6073 | 357544 | 3922 |
1693380 | 1693380 | 2021-09-07 | San Diego | California | 6073 | 357057 | 3922 |
1690131 | 1690131 | 2021-09-06 | San Diego | California | 6073 | 356262 | 3914 |
1686881 | 1686881 | 2021-09-05 | San Diego | California | 6073 | 355583 | 3914 |
1683631 | 1683631 | 2021-09-04 | San Diego | California | 6073 | 354462 | 3911 |
1680380 | 1680380 | 2021-09-03 | San Diego | California | 6073 | 353217 | 3909 |
1677132 | 1677132 | 2021-09-02 | San Diego | California | 6073 | 352137 | 3908 |
1673885 | 1673885 | 2021-09-01 | San Diego | California | 6073 | 351212 | 3888 |
1670637 | 1670637 | 2021-08-31 | San Diego | California | 6073 | 349846 | 3885 |
1667390 | 1667390 | 2021-08-30 | San Diego | California | 6073 | 348849 | 3880 |
1664143 | 1664143 | 2021-08-29 | San Diego | California | 6073 | 348165 | 3880 |
1660895 | 1660895 | 2021-08-28 | San Diego | California | 6073 | 346997 | 3877 |
1657647 | 1657647 | 2021-08-27 | San Diego | California | 6073 | 345111 | 3869 |
1654399 | 1654399 | 2021-08-26 | San Diego | California | 6073 | 344001 | 3859 |
1651152 | 1651152 | 2021-08-25 | San Diego | California | 6073 | 342658 | 3851 |
1647903 | 1647903 | 2021-08-24 | San Diego | California | 6073 | 341371 | 3848 |
1644655 | 1644655 | 2021-08-23 | San Diego | California | 6073 | 340426 | 3848 |
1641405 | 1641405 | 2021-08-22 | San Diego | California | 6073 | 339455 | 3848 |
1638155 | 1638155 | 2021-08-21 | San Diego | California | 6073 | 337937 | 3846 |
1634905 | 1634905 | 2021-08-20 | San Diego | California | 6073 | 336417 | 3839 |
1631656 | 1631656 | 2021-08-19 | San Diego | California | 6073 | 334987 | 3834 |
1628409 | 1628409 | 2021-08-18 | San Diego | California | 6073 | 333893 | 3824 |
1625162 | 1625162 | 2021-08-17 | San Diego | California | 6073 | 332183 | 3824 |
1621915 | 1621915 | 2021-08-16 | San Diego | California | 6073 | 331082 | 3824 |
1618668 | 1618668 | 2021-08-15 | San Diego | California | 6073 | 330424 | 3824 |
1615420 | 1615420 | 2021-08-14 | San Diego | California | 6073 | 329128 | 3821 |
1612171 | 1612171 | 2021-08-13 | San Diego | California | 6073 | 327431 | 3821 |
1608923 | 1608923 | 2021-08-12 | San Diego | California | 6073 | 326241 | 3818 |
1605674 | 1605674 | 2021-08-11 | San Diego | California | 6073 | 325123 | 3815 |
1602425 | 1602425 | 2021-08-10 | San Diego | California | 6073 | 323690 | 3811 |
1599176 | 1599176 | 2021-08-09 | San Diego | California | 6073 | 322818 | 3811 |
1595927 | 1595927 | 2021-08-08 | San Diego | California | 6073 | 321809 | 3811 |
1592678 | 1592678 | 2021-08-07 | San Diego | California | 6073 | 319055 | 3806 |
1589429 | 1589429 | 2021-08-06 | San Diego | California | 6073 | 319055 | 3806 |
1586180 | 1586180 | 2021-08-05 | San Diego | California | 6073 | 317935 | 3805 |
1582930 | 1582930 | 2021-08-04 | San Diego | California | 6073 | 317024 | 3803 |
1579680 | 1579680 | 2021-08-03 | San Diego | California | 6073 | 315856 | 3798 |
1576432 | 1576432 | 2021-08-02 | San Diego | California | 6073 | 314837 | 3798 |
1573184 | 1573184 | 2021-08-01 | San Diego | California | 6073 | 311889 | 3798 |
1569936 | 1569936 | 2021-07-31 | San Diego | California | 6073 | 311889 | 3798 |
1566688 | 1566688 | 2021-07-30 | San Diego | California | 6073 | 311889 | 3798 |
1563440 | 1563440 | 2021-07-29 | San Diego | California | 6073 | 311011 | 3798 |
1560192 | 1560192 | 2021-07-28 | San Diego | California | 6073 | 310243 | 3798 |
1556945 | 1556945 | 2021-07-27 | San Diego | California | 6073 | 309523 | 3793 |
1553698 | 1553698 | 2021-07-26 | San Diego | California | 6073 | 306929 | 3793 |
1550451 | 1550451 | 2021-07-25 | San Diego | California | 6073 | 305671 | 3788 |
1547204 | 1547204 | 2021-07-24 | San Diego | California | 6073 | 305671 | 3788 |
1543957 | 1543957 | 2021-07-23 | San Diego | California | 6073 | 305671 | 3788 |
1540709 | 1540709 | 2021-07-22 | San Diego | California | 6073 | 304985 | 3787 |
1537462 | 1537462 | 2021-07-21 | San Diego | California | 6073 | 304512 | 3786 |
1534214 | 1534214 | 2021-07-20 | San Diego | California | 6073 | 303998 | 3786 |
1530967 | 1530967 | 2021-07-19 | San Diego | California | 6073 | 302106 | 3786 |
1527720 | 1527720 | 2021-07-18 | San Diego | California | 6073 | 301517 | 3786 |
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);