ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where county = "San Diego" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946819 | 1946819 | 2021-11-24 | San Diego | California | 6073 | 404771 | 4319 |
1943568 | 1943568 | 2021-11-23 | San Diego | California | 6073 | 404269 | 4317 |
1940318 | 1940318 | 2021-11-22 | San Diego | California | 6073 | 402884 | 4317 |
1937068 | 1937068 | 2021-11-21 | San Diego | California | 6073 | 402284 | 4311 |
1933818 | 1933818 | 2021-11-20 | San Diego | California | 6073 | 402284 | 4311 |
1930566 | 1930566 | 2021-11-19 | San Diego | California | 6073 | 402284 | 4311 |
1927316 | 1927316 | 2021-11-18 | San Diego | California | 6073 | 401906 | 4301 |
1924066 | 1924066 | 2021-11-17 | San Diego | California | 6073 | 401342 | 4287 |
1920817 | 1920817 | 2021-11-16 | San Diego | California | 6073 | 400752 | 4284 |
1917567 | 1917567 | 2021-11-15 | San Diego | California | 6073 | 399540 | 4280 |
1914317 | 1914317 | 2021-11-14 | San Diego | California | 6073 | 399540 | 4280 |
1911067 | 1911067 | 2021-11-13 | San Diego | California | 6073 | 399540 | 4280 |
1907818 | 1907818 | 2021-11-12 | San Diego | California | 6073 | 398335 | 4272 |
1904569 | 1904569 | 2021-11-11 | San Diego | California | 6073 | 398335 | 4272 |
1901319 | 1901319 | 2021-11-10 | San Diego | California | 6073 | 397700 | 4272 |
1898069 | 1898069 | 2021-11-09 | San Diego | California | 6073 | 397260 | 4259 |
1894819 | 1894819 | 2021-11-08 | San Diego | California | 6073 | 396868 | 4250 |
1891569 | 1891569 | 2021-11-07 | San Diego | California | 6073 | 395126 | 4246 |
1888319 | 1888319 | 2021-11-06 | San Diego | California | 6073 | 395126 | 4246 |
1885069 | 1885069 | 2021-11-05 | San Diego | California | 6073 | 395126 | 4246 |
1881820 | 1881820 | 2021-11-04 | San Diego | California | 6073 | 394654 | 4241 |
1878571 | 1878571 | 2021-11-03 | San Diego | California | 6073 | 393968 | 4232 |
1875322 | 1875322 | 2021-11-02 | San Diego | California | 6073 | 393571 | 4232 |
1872073 | 1872073 | 2021-11-01 | San Diego | California | 6073 | 393131 | 4218 |
1868824 | 1868824 | 2021-10-31 | San Diego | California | 6073 | 391534 | 4213 |
1865575 | 1865575 | 2021-10-30 | San Diego | California | 6073 | 391534 | 4213 |
1862326 | 1862326 | 2021-10-29 | San Diego | California | 6073 | 391534 | 4213 |
1859077 | 1859077 | 2021-10-28 | San Diego | California | 6073 | 391107 | 4207 |
1855828 | 1855828 | 2021-10-27 | San Diego | California | 6073 | 385878 | 4198 |
1852579 | 1852579 | 2021-10-26 | San Diego | California | 6073 | 385221 | 4196 |
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 |
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);