ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where county = "Solano" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946830 | 1946830 | 2021-11-24 | Solano | California | 6095 | 47427 | 356 |
1943579 | 1943579 | 2021-11-23 | Solano | California | 6095 | 47417 | 356 |
1940329 | 1940329 | 2021-11-22 | Solano | California | 6095 | 47417 | 356 |
1937079 | 1937079 | 2021-11-21 | Solano | California | 6095 | 47270 | 356 |
1933829 | 1933829 | 2021-11-20 | Solano | California | 6095 | 47270 | 356 |
1930577 | 1930577 | 2021-11-19 | Solano | California | 6095 | 47270 | 356 |
1927327 | 1927327 | 2021-11-18 | Solano | California | 6095 | 47212 | 353 |
1924077 | 1924077 | 2021-11-17 | Solano | California | 6095 | 47160 | 351 |
1920828 | 1920828 | 2021-11-16 | Solano | California | 6095 | 47137 | 351 |
1917578 | 1917578 | 2021-11-15 | Solano | California | 6095 | 47112 | 351 |
1914328 | 1914328 | 2021-11-14 | Solano | California | 6095 | 47026 | 350 |
1911078 | 1911078 | 2021-11-13 | Solano | California | 6095 | 47026 | 350 |
1907829 | 1907829 | 2021-11-12 | Solano | California | 6095 | 46931 | 350 |
1904580 | 1904580 | 2021-11-11 | Solano | California | 6095 | 46931 | 350 |
1901330 | 1901330 | 2021-11-10 | Solano | California | 6095 | 46876 | 350 |
1898080 | 1898080 | 2021-11-09 | Solano | California | 6095 | 46850 | 350 |
1894830 | 1894830 | 2021-11-08 | Solano | California | 6095 | 46819 | 350 |
1891580 | 1891580 | 2021-11-07 | Solano | California | 6095 | 46702 | 350 |
1888330 | 1888330 | 2021-11-06 | Solano | California | 6095 | 46702 | 350 |
1885080 | 1885080 | 2021-11-05 | Solano | California | 6095 | 46702 | 350 |
1881831 | 1881831 | 2021-11-04 | Solano | California | 6095 | 46648 | 351 |
1878582 | 1878582 | 2021-11-03 | Solano | California | 6095 | 46597 | 350 |
1875333 | 1875333 | 2021-11-02 | Solano | California | 6095 | 46577 | 350 |
1872084 | 1872084 | 2021-11-01 | Solano | California | 6095 | 46529 | 350 |
1868835 | 1868835 | 2021-10-31 | Solano | California | 6095 | 46365 | 346 |
1865586 | 1865586 | 2021-10-30 | Solano | California | 6095 | 46365 | 346 |
1862337 | 1862337 | 2021-10-29 | Solano | California | 6095 | 46365 | 346 |
1859088 | 1859088 | 2021-10-28 | Solano | California | 6095 | 46308 | 346 |
1855839 | 1855839 | 2021-10-27 | Solano | California | 6095 | 46251 | 344 |
1852590 | 1852590 | 2021-10-26 | Solano | California | 6095 | 46229 | 344 |
1849341 | 1849341 | 2021-10-25 | Solano | California | 6095 | 46068 | 341 |
1846091 | 1846091 | 2021-10-24 | Solano | California | 6095 | 46068 | 341 |
1842841 | 1842841 | 2021-10-23 | Solano | California | 6095 | 46068 | 341 |
1839591 | 1839591 | 2021-10-22 | Solano | California | 6095 | 46068 | 341 |
1836342 | 1836342 | 2021-10-21 | Solano | California | 6095 | 46026 | 341 |
1833093 | 1833093 | 2021-10-20 | Solano | California | 6095 | 45963 | 341 |
1829844 | 1829844 | 2021-10-19 | Solano | California | 6095 | 45939 | 339 |
1826595 | 1826595 | 2021-10-18 | Solano | California | 6095 | 45903 | 340 |
1823346 | 1823346 | 2021-10-17 | Solano | California | 6095 | 45766 | 334 |
1820097 | 1820097 | 2021-10-16 | Solano | California | 6095 | 45766 | 334 |
1816848 | 1816848 | 2021-10-15 | Solano | California | 6095 | 45766 | 334 |
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 |
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);