ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "Alameda" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174382 | 2174382 | 2022-02-02 | Alameda | California | 6001 | 246626 | 1643 |
2171129 | 2171129 | 2022-02-01 | Alameda | California | 6001 | 245587 | 1618 |
2167876 | 2167876 | 2022-01-31 | Alameda | California | 6001 | 244682 | 1607 |
2164621 | 2164621 | 2022-01-30 | Alameda | California | 6001 | 238446 | 1605 |
2161366 | 2161366 | 2022-01-29 | Alameda | California | 6001 | 238446 | 1613 |
2158110 | 2158110 | 2022-01-28 | Alameda | California | 6001 | 238446 | 1613 |
2154857 | 2154857 | 2022-01-27 | Alameda | California | 6001 | 238446 | 1605 |
2151604 | 2151604 | 2022-01-26 | Alameda | California | 6001 | 230786 | 1591 |
2148352 | 2148352 | 2022-01-25 | Alameda | California | 6001 | 227285 | 1585 |
2145100 | 2145100 | 2022-01-24 | Alameda | California | 6001 | 227285 | 1581 |
2141845 | 2141845 | 2022-01-23 | Alameda | California | 6001 | 214960 | 1578 |
2138590 | 2138590 | 2022-01-22 | Alameda | California | 6001 | 214960 | 1577 |
2135334 | 2135334 | 2022-01-21 | Alameda | California | 6001 | 214960 | 1577 |
2132082 | 2132082 | 2022-01-20 | Alameda | California | 6001 | 210772 | 1578 |
2128829 | 2128829 | 2022-01-19 | Alameda | California | 6001 | 203080 | 1578 |
2125575 | 2125575 | 2022-01-18 | Alameda | California | 6001 | 200628 | 1578 |
2122323 | 2122323 | 2022-01-17 | Alameda | California | 6001 | 198043 | 1578 |
2119071 | 2119071 | 2022-01-16 | Alameda | California | 6001 | 185120 | 1588 |
2115819 | 2115819 | 2022-01-15 | Alameda | California | 6001 | 185120 | 1588 |
2112568 | 2112568 | 2022-01-14 | Alameda | California | 6001 | 185120 | 1588 |
2109316 | 2109316 | 2022-01-13 | Alameda | California | 6001 | 180353 | 1586 |
2106065 | 2106065 | 2022-01-12 | Alameda | California | 6001 | 173979 | 1586 |
2102814 | 2102814 | 2022-01-11 | Alameda | California | 6001 | 170455 | 1582 |
2099563 | 2099563 | 2022-01-10 | Alameda | California | 6001 | 167499 | 1580 |
2096312 | 2096312 | 2022-01-09 | Alameda | California | 6001 | 153358 | 1580 |
2093060 | 2093060 | 2022-01-08 | Alameda | California | 6001 | 153358 | 1581 |
2089808 | 2089808 | 2022-01-07 | Alameda | California | 6001 | 153358 | 1581 |
2086557 | 2086557 | 2022-01-06 | Alameda | California | 6001 | 149622 | 1567 |
2083305 | 2083305 | 2022-01-05 | Alameda | California | 6001 | 147005 | 1569 |
2080053 | 2080053 | 2022-01-04 | Alameda | California | 6001 | 145735 | 1546 |
2076801 | 2076801 | 2022-01-03 | Alameda | California | 6001 | 137131 | 1546 |
2073550 | 2073550 | 2022-01-02 | Alameda | California | 6001 | 137131 | 1544 |
2070299 | 2070299 | 2022-01-01 | Alameda | California | 6001 | 137131 | 1544 |
2067048 | 2067048 | 2021-12-31 | Alameda | California | 6001 | 137131 | 1544 |
2063797 | 2063797 | 2021-12-30 | Alameda | California | 6001 | 135231 | 1542 |
2060547 | 2060547 | 2021-12-29 | Alameda | California | 6001 | 133732 | 1540 |
2057298 | 2057298 | 2021-12-28 | Alameda | California | 6001 | 133215 | 1540 |
2054049 | 2054049 | 2021-12-27 | Alameda | California | 6001 | 130526 | 1540 |
2050799 | 2050799 | 2021-12-26 | Alameda | California | 6001 | 130526 | 1540 |
2047549 | 2047549 | 2021-12-25 | Alameda | California | 6001 | 130526 | 1540 |
2044299 | 2044299 | 2021-12-24 | Alameda | California | 6001 | 130526 | 1540 |
2041050 | 2041050 | 2021-12-23 | Alameda | California | 6001 | 129838 | 1538 |
2037800 | 2037800 | 2021-12-22 | Alameda | California | 6001 | 129244 | 1535 |
2034550 | 2034550 | 2021-12-21 | Alameda | California | 6001 | 128999 | 1535 |
2031300 | 2031300 | 2021-12-20 | Alameda | California | 6001 | 128701 | 1532 |
2028049 | 2028049 | 2021-12-19 | Alameda | California | 6001 | 127820 | 1531 |
2024798 | 2024798 | 2021-12-18 | Alameda | California | 6001 | 127820 | 1530 |
2021547 | 2021547 | 2021-12-17 | Alameda | California | 6001 | 127820 | 1530 |
2018296 | 2018296 | 2021-12-16 | Alameda | California | 6001 | 127579 | 1528 |
2015046 | 2015046 | 2021-12-15 | Alameda | California | 6001 | 127462 | 1524 |
2011795 | 2011795 | 2021-12-14 | Alameda | California | 6001 | 127364 | 1523 |
2008544 | 2008544 | 2021-12-13 | Alameda | California | 6001 | 127265 | 1518 |
2005293 | 2005293 | 2021-12-12 | Alameda | California | 6001 | 126762 | 1518 |
2002042 | 2002042 | 2021-12-11 | Alameda | California | 6001 | 126762 | 1516 |
1998792 | 1998792 | 2021-12-10 | Alameda | California | 6001 | 126762 | 1516 |
1995541 | 1995541 | 2021-12-09 | Alameda | California | 6001 | 126628 | 1513 |
1992290 | 1992290 | 2021-12-08 | Alameda | California | 6001 | 126466 | 1513 |
1989039 | 1989039 | 2021-12-07 | Alameda | California | 6001 | 126368 | 1514 |
1985789 | 1985789 | 2021-12-06 | Alameda | California | 6001 | 126245 | 1513 |
1982539 | 1982539 | 2021-12-05 | Alameda | California | 6001 | 125649 | 1512 |
1979289 | 1979289 | 2021-12-04 | Alameda | California | 6001 | 125649 | 1512 |
1976039 | 1976039 | 2021-12-03 | Alameda | California | 6001 | 125649 | 1512 |
1972790 | 1972790 | 2021-12-02 | Alameda | California | 6001 | 125439 | 1511 |
1969540 | 1969540 | 2021-12-01 | Alameda | California | 6001 | 125257 | 1507 |
1966290 | 1966290 | 2021-11-30 | Alameda | California | 6001 | 125197 | 1504 |
1963038 | 1963038 | 2021-11-29 | Alameda | California | 6001 | 125143 | 1504 |
1959787 | 1959787 | 2021-11-28 | Alameda | California | 6001 | 124679 | 1504 |
1956536 | 1956536 | 2021-11-27 | Alameda | California | 6001 | 124679 | 1500 |
1953285 | 1953285 | 2021-11-26 | Alameda | California | 6001 | 124679 | 1500 |
1950034 | 1950034 | 2021-11-25 | Alameda | California | 6001 | 124679 | 1499 |
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 |
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);