ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946783 | 1946783 | 2021-11-24 | Alameda | California | 6001 | 124679 | 1494 |
1943532 | 1943532 | 2021-11-23 | Alameda | California | 6001 | 124627 | 1491 |
1940282 | 1940282 | 2021-11-22 | Alameda | California | 6001 | 124504 | 1489 |
1937032 | 1937032 | 2021-11-21 | Alameda | California | 6001 | 124120 | 1489 |
1933782 | 1933782 | 2021-11-20 | Alameda | California | 6001 | 124120 | 1489 |
1930530 | 1930530 | 2021-11-19 | Alameda | California | 6001 | 124120 | 1489 |
1927280 | 1927280 | 2021-11-18 | Alameda | California | 6001 | 123974 | 1487 |
1924030 | 1924030 | 2021-11-17 | Alameda | California | 6001 | 123835 | 1486 |
1920781 | 1920781 | 2021-11-16 | Alameda | California | 6001 | 123757 | 1481 |
1917531 | 1917531 | 2021-11-15 | Alameda | California | 6001 | 123655 | 1479 |
1914281 | 1914281 | 2021-11-14 | Alameda | California | 6001 | 123433 | 1467 |
1911031 | 1911031 | 2021-11-13 | Alameda | California | 6001 | 123433 | 1467 |
1907782 | 1907782 | 2021-11-12 | Alameda | California | 6001 | 123173 | 1467 |
1904533 | 1904533 | 2021-11-11 | Alameda | California | 6001 | 123173 | 1467 |
1901283 | 1901283 | 2021-11-10 | Alameda | California | 6001 | 123044 | 1466 |
1898033 | 1898033 | 2021-11-09 | Alameda | California | 6001 | 122976 | 1463 |
1894783 | 1894783 | 2021-11-08 | Alameda | California | 6001 | 122895 | 1460 |
1891533 | 1891533 | 2021-11-07 | Alameda | California | 6001 | 122492 | 1457 |
1888283 | 1888283 | 2021-11-06 | Alameda | California | 6001 | 122492 | 1440 |
1885033 | 1885033 | 2021-11-05 | Alameda | California | 6001 | 122492 | 1440 |
1881784 | 1881784 | 2021-11-04 | Alameda | California | 6001 | 122349 | 1441 |
1878535 | 1878535 | 2021-11-03 | Alameda | California | 6001 | 122172 | 1441 |
1875286 | 1875286 | 2021-11-02 | Alameda | California | 6001 | 122090 | 1432 |
1872037 | 1872037 | 2021-11-01 | Alameda | California | 6001 | 122002 | 1432 |
1868788 | 1868788 | 2021-10-31 | Alameda | California | 6001 | 121563 | 1419 |
1865539 | 1865539 | 2021-10-30 | Alameda | California | 6001 | 121563 | 1432 |
1862290 | 1862290 | 2021-10-29 | Alameda | California | 6001 | 121563 | 1432 |
1859041 | 1859041 | 2021-10-28 | Alameda | California | 6001 | 121418 | 1432 |
1855792 | 1855792 | 2021-10-27 | Alameda | California | 6001 | 121257 | 1427 |
1852543 | 1852543 | 2021-10-26 | Alameda | California | 6001 | 121216 | 1418 |
1849294 | 1849294 | 2021-10-25 | Alameda | California | 6001 | 120713 | 1415 |
1846044 | 1846044 | 2021-10-24 | Alameda | California | 6001 | 120713 | 1400 |
1842794 | 1842794 | 2021-10-23 | Alameda | California | 6001 | 120713 | 1400 |
1839544 | 1839544 | 2021-10-22 | Alameda | California | 6001 | 120713 | 1400 |
1836295 | 1836295 | 2021-10-21 | Alameda | California | 6001 | 120551 | 1400 |
1833046 | 1833046 | 2021-10-20 | Alameda | California | 6001 | 120423 | 1391 |
1829797 | 1829797 | 2021-10-19 | Alameda | California | 6001 | 120387 | 1384 |
1826548 | 1826548 | 2021-10-18 | Alameda | California | 6001 | 120304 | 1381 |
1823299 | 1823299 | 2021-10-17 | Alameda | California | 6001 | 119908 | 1374 |
1820050 | 1820050 | 2021-10-16 | Alameda | California | 6001 | 119908 | 1372 |
1816801 | 1816801 | 2021-10-15 | Alameda | California | 6001 | 119908 | 1372 |
1813553 | 1813553 | 2021-10-14 | Alameda | California | 6001 | 119795 | 1365 |
1810304 | 1810304 | 2021-10-13 | Alameda | California | 6001 | 119671 | 1357 |
1807055 | 1807055 | 2021-10-12 | Alameda | California | 6001 | 119617 | 1358 |
1803804 | 1803804 | 2021-10-11 | Alameda | California | 6001 | 119537 | 1358 |
1800555 | 1800555 | 2021-10-10 | Alameda | California | 6001 | 119111 | 1356 |
1797306 | 1797306 | 2021-10-09 | Alameda | California | 6001 | 119111 | 1356 |
1794057 | 1794057 | 2021-10-08 | Alameda | California | 6001 | 119111 | 1356 |
1790809 | 1790809 | 2021-10-07 | Alameda | California | 6001 | 118916 | 1354 |
1787560 | 1787560 | 2021-10-06 | Alameda | California | 6001 | 118802 | 1353 |
1784311 | 1784311 | 2021-10-05 | Alameda | California | 6001 | 118679 | 1349 |
1781062 | 1781062 | 2021-10-04 | Alameda | California | 6001 | 118585 | 1349 |
1777812 | 1777812 | 2021-10-03 | Alameda | California | 6001 | 118019 | 1349 |
1774562 | 1774562 | 2021-10-02 | Alameda | California | 6001 | 118019 | 1345 |
1771312 | 1771312 | 2021-10-01 | Alameda | California | 6001 | 118019 | 1345 |
1768063 | 1768063 | 2021-09-30 | Alameda | California | 6001 | 117832 | 1343 |
1764814 | 1764814 | 2021-09-29 | Alameda | California | 6001 | 117676 | 1334 |
1761565 | 1761565 | 2021-09-28 | Alameda | California | 6001 | 117538 | 1334 |
1758317 | 1758317 | 2021-09-27 | Alameda | California | 6001 | 117408 | 1328 |
1755069 | 1755069 | 2021-09-26 | Alameda | California | 6001 | 116821 | 1333 |
1751821 | 1751821 | 2021-09-25 | Alameda | California | 6001 | 116821 | 1331 |
1748572 | 1748572 | 2021-09-24 | Alameda | California | 6001 | 116821 | 1331 |
1745322 | 1745322 | 2021-09-23 | Alameda | California | 6001 | 116669 | 1331 |
1742073 | 1742073 | 2021-09-22 | Alameda | California | 6001 | 116554 | 1330 |
1738824 | 1738824 | 2021-09-21 | Alameda | California | 6001 | 116426 | 1330 |
1735575 | 1735575 | 2021-09-20 | Alameda | California | 6001 | 116235 | 1330 |
1732325 | 1732325 | 2021-09-19 | Alameda | California | 6001 | 116089 | 1330 |
1729075 | 1729075 | 2021-09-18 | Alameda | California | 6001 | 115859 | 1330 |
1725825 | 1725825 | 2021-09-17 | Alameda | California | 6001 | 115559 | 1330 |
1722576 | 1722576 | 2021-09-16 | Alameda | California | 6001 | 115287 | 1330 |
1719327 | 1719327 | 2021-09-15 | Alameda | California | 6001 | 115068 | 1330 |
1716079 | 1716079 | 2021-09-14 | Alameda | California | 6001 | 114898 | 1330 |
1712833 | 1712833 | 2021-09-13 | Alameda | California | 6001 | 114700 | 1323 |
1709586 | 1709586 | 2021-09-12 | Alameda | California | 6001 | 114454 | 1321 |
1706339 | 1706339 | 2021-09-11 | Alameda | California | 6001 | 114125 | 1321 |
1703091 | 1703091 | 2021-09-10 | Alameda | California | 6001 | 113753 | 1321 |
1699841 | 1699841 | 2021-09-09 | Alameda | California | 6001 | 113520 | 1321 |
1696592 | 1696592 | 2021-09-08 | Alameda | California | 6001 | 113250 | 1319 |
1693344 | 1693344 | 2021-09-07 | Alameda | California | 6001 | 113057 | 1317 |
1690095 | 1690095 | 2021-09-06 | Alameda | California | 6001 | 112873 | 1317 |
1686845 | 1686845 | 2021-09-05 | Alameda | California | 6001 | 112644 | 1317 |
1683595 | 1683595 | 2021-09-04 | Alameda | California | 6001 | 112336 | 1316 |
1680344 | 1680344 | 2021-09-03 | Alameda | California | 6001 | 112077 | 1316 |
1677096 | 1677096 | 2021-09-02 | Alameda | California | 6001 | 111775 | 1316 |
1673849 | 1673849 | 2021-09-01 | Alameda | California | 6001 | 111462 | 1312 |
1670601 | 1670601 | 2021-08-31 | Alameda | California | 6001 | 110359 | 1312 |
1667354 | 1667354 | 2021-08-30 | Alameda | California | 6001 | 110119 | 1312 |
1664107 | 1664107 | 2021-08-29 | Alameda | California | 6001 | 109632 | 1312 |
1660859 | 1660859 | 2021-08-28 | Alameda | California | 6001 | 109247 | 1312 |
1657611 | 1657611 | 2021-08-27 | Alameda | California | 6001 | 108771 | 1312 |
1654363 | 1654363 | 2021-08-26 | Alameda | California | 6001 | 108261 | 1312 |
1651116 | 1651116 | 2021-08-25 | Alameda | California | 6001 | 107851 | 1312 |
1647867 | 1647867 | 2021-08-24 | Alameda | California | 6001 | 107454 | 1311 |
1644619 | 1644619 | 2021-08-23 | Alameda | California | 6001 | 107071 | 1309 |
1641369 | 1641369 | 2021-08-22 | Alameda | California | 6001 | 106813 | 1309 |
1638119 | 1638119 | 2021-08-21 | Alameda | California | 6001 | 106344 | 1309 |
1634869 | 1634869 | 2021-08-20 | Alameda | California | 6001 | 105808 | 1309 |
1631620 | 1631620 | 2021-08-19 | Alameda | California | 6001 | 105228 | 1309 |
1628373 | 1628373 | 2021-08-18 | Alameda | California | 6001 | 104775 | 1309 |
1625126 | 1625126 | 2021-08-17 | Alameda | California | 6001 | 104448 | 1305 |
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);