ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1621879 | 1621879 | 2021-08-16 | Alameda | California | 6001 | 104056 | 1302 |
1618632 | 1618632 | 2021-08-15 | Alameda | California | 6001 | 103701 | 1302 |
1615384 | 1615384 | 2021-08-14 | Alameda | California | 6001 | 103326 | 1299 |
1612135 | 1612135 | 2021-08-13 | Alameda | California | 6001 | 102868 | 1299 |
1608887 | 1608887 | 2021-08-12 | Alameda | California | 6001 | 102436 | 1299 |
1605638 | 1605638 | 2021-08-11 | Alameda | California | 6001 | 102167 | 1296 |
1602389 | 1602389 | 2021-08-10 | Alameda | California | 6001 | 101892 | 1296 |
1599140 | 1599140 | 2021-08-09 | Alameda | California | 6001 | 101531 | 1291 |
1595891 | 1595891 | 2021-08-08 | Alameda | California | 6001 | 101208 | 1292 |
1592642 | 1592642 | 2021-08-07 | Alameda | California | 6001 | 100448 | 1291 |
1589393 | 1589393 | 2021-08-06 | Alameda | California | 6001 | 100448 | 1291 |
1586144 | 1586144 | 2021-08-05 | Alameda | California | 6001 | 99873 | 1291 |
1582894 | 1582894 | 2021-08-04 | Alameda | California | 6001 | 99641 | 1290 |
1579644 | 1579644 | 2021-08-03 | Alameda | California | 6001 | 99320 | 1286 |
1576396 | 1576396 | 2021-08-02 | Alameda | California | 6001 | 99141 | 1286 |
1573148 | 1573148 | 2021-08-01 | Alameda | California | 6001 | 97645 | 1282 |
1569900 | 1569900 | 2021-07-31 | Alameda | California | 6001 | 97645 | 1282 |
1566652 | 1566652 | 2021-07-30 | Alameda | California | 6001 | 97645 | 1282 |
1563404 | 1563404 | 2021-07-29 | Alameda | California | 6001 | 97331 | 1282 |
1560156 | 1560156 | 2021-07-28 | Alameda | California | 6001 | 96994 | 1274 |
1556909 | 1556909 | 2021-07-27 | Alameda | California | 6001 | 96748 | 1274 |
1553662 | 1553662 | 2021-07-26 | Alameda | California | 6001 | 96458 | 1272 |
1550415 | 1550415 | 2021-07-25 | Alameda | California | 6001 | 95482 | 1272 |
1547168 | 1547168 | 2021-07-24 | Alameda | California | 6001 | 95482 | 1272 |
1543921 | 1543921 | 2021-07-23 | Alameda | California | 6001 | 95482 | 1272 |
1540673 | 1540673 | 2021-07-22 | Alameda | California | 6001 | 95152 | 1272 |
1537426 | 1537426 | 2021-07-21 | Alameda | California | 6001 | 94777 | 1272 |
1534178 | 1534178 | 2021-07-20 | Alameda | California | 6001 | 94509 | 1272 |
1530931 | 1530931 | 2021-07-19 | Alameda | California | 6001 | 94314 | 1271 |
1527684 | 1527684 | 2021-07-18 | Alameda | California | 6001 | 93498 | 1271 |
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);