ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 6095 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813600 | 1813600 | 2021-10-14 | Solano | California | 6095 | 45739 | 334 |
1810351 | 1810351 | 2021-10-13 | Solano | California | 6095 | 45686 | 329 |
1807102 | 1807102 | 2021-10-12 | Solano | California | 6095 | 45644 | 329 |
1803851 | 1803851 | 2021-10-11 | Solano | California | 6095 | 45601 | 329 |
1800602 | 1800602 | 2021-10-10 | Solano | California | 6095 | 45435 | 329 |
1797353 | 1797353 | 2021-10-09 | Solano | California | 6095 | 45435 | 329 |
1794104 | 1794104 | 2021-10-08 | Solano | California | 6095 | 45435 | 329 |
1790856 | 1790856 | 2021-10-07 | Solano | California | 6095 | 45355 | 328 |
1787607 | 1787607 | 2021-10-06 | Solano | California | 6095 | 45294 | 325 |
1784358 | 1784358 | 2021-10-05 | Solano | California | 6095 | 45237 | 322 |
1781109 | 1781109 | 2021-10-04 | Solano | California | 6095 | 45196 | 322 |
1777859 | 1777859 | 2021-10-03 | Solano | California | 6095 | 44945 | 321 |
1774609 | 1774609 | 2021-10-02 | Solano | California | 6095 | 44945 | 321 |
1771359 | 1771359 | 2021-10-01 | Solano | California | 6095 | 44945 | 321 |
1768110 | 1768110 | 2021-09-30 | Solano | California | 6095 | 44869 | 321 |
1764861 | 1764861 | 2021-09-29 | Solano | California | 6095 | 44778 | 316 |
1761612 | 1761612 | 2021-09-28 | Solano | California | 6095 | 44708 | 314 |
1758364 | 1758364 | 2021-09-27 | Solano | California | 6095 | 44663 | 314 |
1755116 | 1755116 | 2021-09-26 | Solano | California | 6095 | 44457 | 312 |
1751868 | 1751868 | 2021-09-25 | Solano | California | 6095 | 44457 | 312 |
1748619 | 1748619 | 2021-09-24 | Solano | California | 6095 | 44457 | 312 |
1745369 | 1745369 | 2021-09-23 | Solano | California | 6095 | 44395 | 312 |
1742120 | 1742120 | 2021-09-22 | Solano | California | 6095 | 44320 | 311 |
1738871 | 1738871 | 2021-09-21 | Solano | California | 6095 | 44252 | 312 |
1735622 | 1735622 | 2021-09-20 | Solano | California | 6095 | 44156 | 312 |
1732372 | 1732372 | 2021-09-19 | Solano | California | 6095 | 44066 | 312 |
1729122 | 1729122 | 2021-09-18 | Solano | California | 6095 | 43998 | 312 |
1725872 | 1725872 | 2021-09-17 | Solano | California | 6095 | 43892 | 312 |
1722623 | 1722623 | 2021-09-16 | Solano | California | 6095 | 43782 | 312 |
1719374 | 1719374 | 2021-09-15 | Solano | California | 6095 | 43673 | 307 |
1716126 | 1716126 | 2021-09-14 | Solano | California | 6095 | 43575 | 306 |
1712880 | 1712880 | 2021-09-13 | Solano | California | 6095 | 43483 | 306 |
1709633 | 1709633 | 2021-09-12 | Solano | California | 6095 | 43418 | 306 |
1706386 | 1706386 | 2021-09-11 | Solano | California | 6095 | 43304 | 305 |
1703138 | 1703138 | 2021-09-10 | Solano | California | 6095 | 43155 | 303 |
1699888 | 1699888 | 2021-09-09 | Solano | California | 6095 | 43155 | 303 |
1696639 | 1696639 | 2021-09-08 | Solano | California | 6095 | 42881 | 300 |
1693391 | 1693391 | 2021-09-07 | Solano | California | 6095 | 42793 | 300 |
1690142 | 1690142 | 2021-09-06 | Solano | California | 6095 | 42706 | 300 |
1686892 | 1686892 | 2021-09-05 | Solano | California | 6095 | 42633 | 300 |
1683642 | 1683642 | 2021-09-04 | Solano | California | 6095 | 42476 | 300 |
1680391 | 1680391 | 2021-09-03 | Solano | California | 6095 | 42312 | 294 |
1677143 | 1677143 | 2021-09-02 | Solano | California | 6095 | 42213 | 293 |
1673896 | 1673896 | 2021-09-01 | Solano | California | 6095 | 42035 | 289 |
1670648 | 1670648 | 2021-08-31 | Solano | California | 6095 | 40954 | 290 |
1667401 | 1667401 | 2021-08-30 | Solano | California | 6095 | 40855 | 290 |
1664154 | 1664154 | 2021-08-29 | Solano | California | 6095 | 40578 | 290 |
1660906 | 1660906 | 2021-08-28 | Solano | California | 6095 | 40315 | 287 |
1657658 | 1657658 | 2021-08-27 | Solano | California | 6095 | 39995 | 286 |
1654410 | 1654410 | 2021-08-26 | Solano | California | 6095 | 39816 | 286 |
1651163 | 1651163 | 2021-08-25 | Solano | California | 6095 | 39623 | 283 |
1647914 | 1647914 | 2021-08-24 | Solano | California | 6095 | 39511 | 283 |
1644666 | 1644666 | 2021-08-23 | Solano | California | 6095 | 39388 | 283 |
1641416 | 1641416 | 2021-08-22 | Solano | California | 6095 | 39322 | 281 |
1638166 | 1638166 | 2021-08-21 | Solano | California | 6095 | 39113 | 277 |
1634916 | 1634916 | 2021-08-20 | Solano | California | 6095 | 38924 | 273 |
1631667 | 1631667 | 2021-08-19 | Solano | California | 6095 | 38711 | 271 |
1628420 | 1628420 | 2021-08-18 | Solano | California | 6095 | 38431 | 269 |
1625173 | 1625173 | 2021-08-17 | Solano | California | 6095 | 38205 | 263 |
1621926 | 1621926 | 2021-08-16 | Solano | California | 6095 | 38089 | 263 |
1618679 | 1618679 | 2021-08-15 | Solano | California | 6095 | 38006 | 263 |
1615431 | 1615431 | 2021-08-14 | Solano | California | 6095 | 37873 | 264 |
1612182 | 1612182 | 2021-08-13 | Solano | California | 6095 | 37749 | 262 |
1608934 | 1608934 | 2021-08-12 | Solano | California | 6095 | 37631 | 262 |
1605685 | 1605685 | 2021-08-11 | Solano | California | 6095 | 37536 | 262 |
1602436 | 1602436 | 2021-08-10 | Solano | California | 6095 | 37422 | 262 |
1599187 | 1599187 | 2021-08-09 | Solano | California | 6095 | 37320 | 262 |
1595938 | 1595938 | 2021-08-08 | Solano | California | 6095 | 37227 | 262 |
1592689 | 1592689 | 2021-08-07 | Solano | California | 6095 | 37019 | 262 |
1589440 | 1589440 | 2021-08-06 | Solano | California | 6095 | 37019 | 262 |
1586191 | 1586191 | 2021-08-05 | Solano | California | 6095 | 36794 | 262 |
1582941 | 1582941 | 2021-08-04 | Solano | California | 6095 | 36674 | 261 |
1579691 | 1579691 | 2021-08-03 | Solano | California | 6095 | 36573 | 260 |
1576443 | 1576443 | 2021-08-02 | Solano | California | 6095 | 36521 | 260 |
1573195 | 1573195 | 2021-08-01 | Solano | California | 6095 | 36061 | 263 |
1569947 | 1569947 | 2021-07-31 | Solano | California | 6095 | 36061 | 263 |
1566699 | 1566699 | 2021-07-30 | Solano | California | 6095 | 36061 | 263 |
1563451 | 1563451 | 2021-07-29 | Solano | California | 6095 | 35925 | 262 |
1560203 | 1560203 | 2021-07-28 | Solano | California | 6095 | 35768 | 261 |
1556956 | 1556956 | 2021-07-27 | Solano | California | 6095 | 35665 | 259 |
1553709 | 1553709 | 2021-07-26 | Solano | California | 6095 | 35538 | 259 |
1550462 | 1550462 | 2021-07-25 | Solano | California | 6095 | 35198 | 259 |
1547215 | 1547215 | 2021-07-24 | Solano | California | 6095 | 35198 | 259 |
1543968 | 1543968 | 2021-07-23 | Solano | California | 6095 | 35198 | 259 |
1540720 | 1540720 | 2021-07-22 | Solano | California | 6095 | 35049 | 258 |
1537473 | 1537473 | 2021-07-21 | Solano | California | 6095 | 34933 | 258 |
1534225 | 1534225 | 2021-07-20 | Solano | California | 6095 | 34858 | 261 |
1530978 | 1530978 | 2021-07-19 | Solano | California | 6095 | 34811 | 261 |
1527731 | 1527731 | 2021-07-18 | Solano | California | 6095 | 34635 | 263 |
1524484 | 1524484 | 2021-07-17 | Solano | California | 6095 | 34635 | 263 |
1521236 | 1521236 | 2021-07-16 | Solano | California | 6095 | 34635 | 263 |
1517988 | 1517988 | 2021-07-15 | Solano | California | 6095 | 34544 | 268 |
1514741 | 1514741 | 2021-07-14 | Solano | California | 6095 | 34514 | 268 |
1511495 | 1511495 | 2021-07-13 | Solano | California | 6095 | 34455 | 268 |
1508248 | 1508248 | 2021-07-12 | Solano | California | 6095 | 34433 | 268 |
1505002 | 1505002 | 2021-07-11 | Solano | California | 6095 | 34274 | 268 |
1501756 | 1501756 | 2021-07-10 | Solano | California | 6095 | 34274 | 268 |
1498510 | 1498510 | 2021-07-09 | Solano | California | 6095 | 34274 | 268 |
1495263 | 1495263 | 2021-07-08 | Solano | California | 6095 | 34255 | 268 |
1492016 | 1492016 | 2021-07-07 | Solano | California | 6095 | 34154 | 268 |
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);