ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6087 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716122 | 1716122 | 2021-09-14 | Santa Cruz | California | 6087 | 19951 | 210 |
1712876 | 1712876 | 2021-09-13 | Santa Cruz | California | 6087 | 19926 | 210 |
1709629 | 1709629 | 2021-09-12 | Santa Cruz | California | 6087 | 19899 | 210 |
1706382 | 1706382 | 2021-09-11 | Santa Cruz | California | 6087 | 19819 | 210 |
1703134 | 1703134 | 2021-09-10 | Santa Cruz | California | 6087 | 19762 | 210 |
1699884 | 1699884 | 2021-09-09 | Santa Cruz | California | 6087 | 19733 | 210 |
1696635 | 1696635 | 2021-09-08 | Santa Cruz | California | 6087 | 19688 | 210 |
1693387 | 1693387 | 2021-09-07 | Santa Cruz | California | 6087 | 19634 | 210 |
1690138 | 1690138 | 2021-09-06 | Santa Cruz | California | 6087 | 19607 | 210 |
1686888 | 1686888 | 2021-09-05 | Santa Cruz | California | 6087 | 19598 | 210 |
1683638 | 1683638 | 2021-09-04 | Santa Cruz | California | 6087 | 19551 | 210 |
1680387 | 1680387 | 2021-09-03 | Santa Cruz | California | 6087 | 19492 | 210 |
1677139 | 1677139 | 2021-09-02 | Santa Cruz | California | 6087 | 19472 | 210 |
1673892 | 1673892 | 2021-09-01 | Santa Cruz | California | 6087 | 19398 | 210 |
1670644 | 1670644 | 2021-08-31 | Santa Cruz | California | 6087 | 19305 | 210 |
1667397 | 1667397 | 2021-08-30 | Santa Cruz | California | 6087 | 19264 | 210 |
1664150 | 1664150 | 2021-08-29 | Santa Cruz | California | 6087 | 19219 | 210 |
1660902 | 1660902 | 2021-08-28 | Santa Cruz | California | 6087 | 19142 | 210 |
1657654 | 1657654 | 2021-08-27 | Santa Cruz | California | 6087 | 19051 | 210 |
1654406 | 1654406 | 2021-08-26 | Santa Cruz | California | 6087 | 18966 | 210 |
1651159 | 1651159 | 2021-08-25 | Santa Cruz | California | 6087 | 18881 | 209 |
1647910 | 1647910 | 2021-08-24 | Santa Cruz | California | 6087 | 18824 | 209 |
1644662 | 1644662 | 2021-08-23 | Santa Cruz | California | 6087 | 18776 | 209 |
1641412 | 1641412 | 2021-08-22 | Santa Cruz | California | 6087 | 18716 | 209 |
1638162 | 1638162 | 2021-08-21 | Santa Cruz | California | 6087 | 18654 | 209 |
1634912 | 1634912 | 2021-08-20 | Santa Cruz | California | 6087 | 18597 | 209 |
1631663 | 1631663 | 2021-08-19 | Santa Cruz | California | 6087 | 18519 | 209 |
1628416 | 1628416 | 2021-08-18 | Santa Cruz | California | 6087 | 18415 | 209 |
1625169 | 1625169 | 2021-08-17 | Santa Cruz | California | 6087 | 18378 | 209 |
1621922 | 1621922 | 2021-08-16 | Santa Cruz | California | 6087 | 18327 | 209 |
1618675 | 1618675 | 2021-08-15 | Santa Cruz | California | 6087 | 18271 | 209 |
1615427 | 1615427 | 2021-08-14 | Santa Cruz | California | 6087 | 18219 | 209 |
1612178 | 1612178 | 2021-08-13 | Santa Cruz | California | 6087 | 18148 | 209 |
1608930 | 1608930 | 2021-08-12 | Santa Cruz | California | 6087 | 18078 | 209 |
1605681 | 1605681 | 2021-08-11 | Santa Cruz | California | 6087 | 18029 | 209 |
1602432 | 1602432 | 2021-08-10 | Santa Cruz | California | 6087 | 17969 | 209 |
1599183 | 1599183 | 2021-08-09 | Santa Cruz | California | 6087 | 17922 | 209 |
1595934 | 1595934 | 2021-08-08 | Santa Cruz | California | 6087 | 17881 | 209 |
1592685 | 1592685 | 2021-08-07 | Santa Cruz | California | 6087 | 17754 | 207 |
1589436 | 1589436 | 2021-08-06 | Santa Cruz | California | 6087 | 17754 | 207 |
1586187 | 1586187 | 2021-08-05 | Santa Cruz | California | 6087 | 17707 | 208 |
1582937 | 1582937 | 2021-08-04 | Santa Cruz | California | 6087 | 17663 | 207 |
1579687 | 1579687 | 2021-08-03 | Santa Cruz | California | 6087 | 17631 | 207 |
1576439 | 1576439 | 2021-08-02 | Santa Cruz | California | 6087 | 17594 | 207 |
1573191 | 1573191 | 2021-08-01 | Santa Cruz | California | 6087 | 17461 | 207 |
1569943 | 1569943 | 2021-07-31 | Santa Cruz | California | 6087 | 17461 | 207 |
1566695 | 1566695 | 2021-07-30 | Santa Cruz | California | 6087 | 17461 | 207 |
1563447 | 1563447 | 2021-07-29 | Santa Cruz | California | 6087 | 17436 | 207 |
1560199 | 1560199 | 2021-07-28 | Santa Cruz | California | 6087 | 17406 | 207 |
1556952 | 1556952 | 2021-07-27 | Santa Cruz | California | 6087 | 17376 | 207 |
1553705 | 1553705 | 2021-07-26 | Santa Cruz | California | 6087 | 17357 | 207 |
1550458 | 1550458 | 2021-07-25 | Santa Cruz | California | 6087 | 17299 | 207 |
1547211 | 1547211 | 2021-07-24 | Santa Cruz | California | 6087 | 17299 | 207 |
1543964 | 1543964 | 2021-07-23 | Santa Cruz | California | 6087 | 17299 | 207 |
1540716 | 1540716 | 2021-07-22 | Santa Cruz | California | 6087 | 17290 | 207 |
1537469 | 1537469 | 2021-07-21 | Santa Cruz | California | 6087 | 17279 | 207 |
1534221 | 1534221 | 2021-07-20 | Santa Cruz | California | 6087 | 17267 | 207 |
1530974 | 1530974 | 2021-07-19 | Santa Cruz | California | 6087 | 17252 | 207 |
1527727 | 1527727 | 2021-07-18 | Santa Cruz | California | 6087 | 17217 | 207 |
1524480 | 1524480 | 2021-07-17 | Santa Cruz | California | 6087 | 17217 | 207 |
1521232 | 1521232 | 2021-07-16 | Santa Cruz | California | 6087 | 17217 | 207 |
1517984 | 1517984 | 2021-07-15 | Santa Cruz | California | 6087 | 17206 | 207 |
1514737 | 1514737 | 2021-07-14 | Santa Cruz | California | 6087 | 17195 | 207 |
1511491 | 1511491 | 2021-07-13 | Santa Cruz | California | 6087 | 17190 | 207 |
1508244 | 1508244 | 2021-07-12 | Santa Cruz | California | 6087 | 17183 | 207 |
1504998 | 1504998 | 2021-07-11 | Santa Cruz | California | 6087 | 17166 | 207 |
1501752 | 1501752 | 2021-07-10 | Santa Cruz | California | 6087 | 17166 | 207 |
1498506 | 1498506 | 2021-07-09 | Santa Cruz | California | 6087 | 17166 | 207 |
1495259 | 1495259 | 2021-07-08 | Santa Cruz | California | 6087 | 17159 | 207 |
1492012 | 1492012 | 2021-07-07 | Santa Cruz | California | 6087 | 16306 | 207 |
1488765 | 1488765 | 2021-07-06 | Santa Cruz | California | 6087 | 16306 | 208 |
1485518 | 1485518 | 2021-07-05 | Santa Cruz | California | 6087 | 16289 | 208 |
1482272 | 1482272 | 2021-07-04 | Santa Cruz | California | 6087 | 16289 | 208 |
1479025 | 1479025 | 2021-07-03 | Santa Cruz | California | 6087 | 16289 | 208 |
1475779 | 1475779 | 2021-07-02 | Santa Cruz | California | 6087 | 16289 | 208 |
1472533 | 1472533 | 2021-07-01 | Santa Cruz | California | 6087 | 16289 | 208 |
1469288 | 1469288 | 2021-06-30 | Santa Cruz | California | 6087 | 16269 | 208 |
1466043 | 1466043 | 2021-06-29 | Santa Cruz | California | 6087 | 16269 | 208 |
1462798 | 1462798 | 2021-06-28 | Santa Cruz | California | 6087 | 16269 | 208 |
1459553 | 1459553 | 2021-06-27 | Santa Cruz | California | 6087 | 16262 | 208 |
1456308 | 1456308 | 2021-06-26 | Santa Cruz | California | 6087 | 16262 | 208 |
1453063 | 1453063 | 2021-06-25 | Santa Cruz | California | 6087 | 16262 | 208 |
1449817 | 1449817 | 2021-06-24 | Santa Cruz | California | 6087 | 16262 | 209 |
1446572 | 1446572 | 2021-06-23 | Santa Cruz | California | 6087 | 16246 | 209 |
1443327 | 1443327 | 2021-06-22 | Santa Cruz | California | 6087 | 16246 | 208 |
1440082 | 1440082 | 2021-06-21 | Santa Cruz | California | 6087 | 16246 | 208 |
1436835 | 1436835 | 2021-06-20 | Santa Cruz | California | 6087 | 16235 | 208 |
1433588 | 1433588 | 2021-06-19 | Santa Cruz | California | 6087 | 16235 | 208 |
1430342 | 1430342 | 2021-06-18 | Santa Cruz | California | 6087 | 16235 | 208 |
1427097 | 1427097 | 2021-06-17 | Santa Cruz | California | 6087 | 16232 | 208 |
1423852 | 1423852 | 2021-06-16 | Santa Cruz | California | 6087 | 16222 | 208 |
1420604 | 1420604 | 2021-06-15 | Santa Cruz | California | 6087 | 16216 | 208 |
1417359 | 1417359 | 2021-06-14 | Santa Cruz | California | 6087 | 16206 | 208 |
1414113 | 1414113 | 2021-06-13 | Santa Cruz | California | 6087 | 16202 | 208 |
1410868 | 1410868 | 2021-06-12 | Santa Cruz | California | 6087 | 16202 | 208 |
1407623 | 1407623 | 2021-06-11 | Santa Cruz | California | 6087 | 16202 | 208 |
1404377 | 1404377 | 2021-06-10 | Santa Cruz | California | 6087 | 16198 | 208 |
1401132 | 1401132 | 2021-06-09 | Santa Cruz | California | 6087 | 16191 | 208 |
1397887 | 1397887 | 2021-06-08 | Santa Cruz | California | 6087 | 16199 | 208 |
1394640 | 1394640 | 2021-06-07 | Santa Cruz | California | 6087 | 16200 | 208 |
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);