ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Ventura" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946838 | 1946838 | 2021-11-24 | Ventura | California | 6111 | 103646 | 1188 |
1943587 | 1943587 | 2021-11-23 | Ventura | California | 6111 | 103597 | 1186 |
1940337 | 1940337 | 2021-11-22 | Ventura | California | 6111 | 103564 | 1186 |
1937087 | 1937087 | 2021-11-21 | Ventura | California | 6111 | 103376 | 1186 |
1933837 | 1933837 | 2021-11-20 | Ventura | California | 6111 | 103376 | 1186 |
1930585 | 1930585 | 2021-11-19 | Ventura | California | 6111 | 103376 | 1186 |
1927335 | 1927335 | 2021-11-18 | Ventura | California | 6111 | 103295 | 1183 |
1924085 | 1924085 | 2021-11-17 | Ventura | California | 6111 | 103187 | 1183 |
1920836 | 1920836 | 2021-11-16 | Ventura | California | 6111 | 103061 | 1183 |
1917586 | 1917586 | 2021-11-15 | Ventura | California | 6111 | 103006 | 1183 |
1914336 | 1914336 | 2021-11-14 | Ventura | California | 6111 | 102908 | 1183 |
1911086 | 1911086 | 2021-11-13 | Ventura | California | 6111 | 102908 | 1183 |
1907837 | 1907837 | 2021-11-12 | Ventura | California | 6111 | 102753 | 1182 |
1904588 | 1904588 | 2021-11-11 | Ventura | California | 6111 | 102753 | 1182 |
1901338 | 1901338 | 2021-11-10 | Ventura | California | 6111 | 102627 | 1182 |
1898088 | 1898088 | 2021-11-09 | Ventura | California | 6111 | 102569 | 1182 |
1894838 | 1894838 | 2021-11-08 | Ventura | California | 6111 | 102510 | 1182 |
1891588 | 1891588 | 2021-11-07 | Ventura | California | 6111 | 102195 | 1180 |
1888338 | 1888338 | 2021-11-06 | Ventura | California | 6111 | 102195 | 1180 |
1885088 | 1885088 | 2021-11-05 | Ventura | California | 6111 | 102195 | 1180 |
1881839 | 1881839 | 2021-11-04 | Ventura | California | 6111 | 102107 | 1178 |
1878590 | 1878590 | 2021-11-03 | Ventura | California | 6111 | 101968 | 1178 |
1875341 | 1875341 | 2021-11-02 | Ventura | California | 6111 | 101901 | 1178 |
1872092 | 1872092 | 2021-11-01 | Ventura | California | 6111 | 101854 | 1178 |
1868843 | 1868843 | 2021-10-31 | Ventura | California | 6111 | 101576 | 1174 |
1865594 | 1865594 | 2021-10-30 | Ventura | California | 6111 | 101576 | 1174 |
1862345 | 1862345 | 2021-10-29 | Ventura | California | 6111 | 101576 | 1174 |
1859096 | 1859096 | 2021-10-28 | Ventura | California | 6111 | 101502 | 1172 |
1855847 | 1855847 | 2021-10-27 | Ventura | California | 6111 | 101388 | 1170 |
1852598 | 1852598 | 2021-10-26 | Ventura | California | 6111 | 101306 | 1167 |
1849349 | 1849349 | 2021-10-25 | Ventura | California | 6111 | 101038 | 1167 |
1846099 | 1846099 | 2021-10-24 | Ventura | California | 6111 | 101038 | 1167 |
1842849 | 1842849 | 2021-10-23 | Ventura | California | 6111 | 101038 | 1167 |
1839599 | 1839599 | 2021-10-22 | Ventura | California | 6111 | 101038 | 1167 |
1836350 | 1836350 | 2021-10-21 | Ventura | California | 6111 | 100984 | 1166 |
1833101 | 1833101 | 2021-10-20 | Ventura | California | 6111 | 100882 | 1166 |
1829852 | 1829852 | 2021-10-19 | Ventura | California | 6111 | 100849 | 1165 |
1826603 | 1826603 | 2021-10-18 | Ventura | California | 6111 | 100801 | 1165 |
1823354 | 1823354 | 2021-10-17 | Ventura | California | 6111 | 100524 | 1164 |
1820105 | 1820105 | 2021-10-16 | Ventura | California | 6111 | 100524 | 1164 |
1816856 | 1816856 | 2021-10-15 | Ventura | California | 6111 | 100524 | 1164 |
1813608 | 1813608 | 2021-10-14 | Ventura | California | 6111 | 100442 | 1162 |
1810359 | 1810359 | 2021-10-13 | Ventura | California | 6111 | 100337 | 1160 |
1807110 | 1807110 | 2021-10-12 | Ventura | California | 6111 | 100191 | 1160 |
1803859 | 1803859 | 2021-10-11 | Ventura | California | 6111 | 100144 | 1160 |
1800610 | 1800610 | 2021-10-10 | Ventura | California | 6111 | 99857 | 1158 |
1797361 | 1797361 | 2021-10-09 | Ventura | California | 6111 | 99857 | 1158 |
1794112 | 1794112 | 2021-10-08 | Ventura | California | 6111 | 99857 | 1158 |
1790864 | 1790864 | 2021-10-07 | Ventura | California | 6111 | 99764 | 1158 |
1787615 | 1787615 | 2021-10-06 | Ventura | California | 6111 | 99632 | 1155 |
1784366 | 1784366 | 2021-10-05 | Ventura | California | 6111 | 99451 | 1153 |
1781117 | 1781117 | 2021-10-04 | Ventura | California | 6111 | 99389 | 1153 |
1777867 | 1777867 | 2021-10-03 | Ventura | California | 6111 | 99135 | 1148 |
1774617 | 1774617 | 2021-10-02 | Ventura | California | 6111 | 99135 | 1148 |
1771367 | 1771367 | 2021-10-01 | Ventura | California | 6111 | 99135 | 1148 |
1768118 | 1768118 | 2021-09-30 | Ventura | California | 6111 | 99034 | 1146 |
1764869 | 1764869 | 2021-09-29 | Ventura | California | 6111 | 98865 | 1144 |
1761620 | 1761620 | 2021-09-28 | Ventura | California | 6111 | 98710 | 1140 |
1758372 | 1758372 | 2021-09-27 | Ventura | California | 6111 | 98624 | 1138 |
1755124 | 1755124 | 2021-09-26 | Ventura | California | 6111 | 98292 | 1134 |
1751876 | 1751876 | 2021-09-25 | Ventura | California | 6111 | 98292 | 1134 |
1748627 | 1748627 | 2021-09-24 | Ventura | California | 6111 | 98292 | 1134 |
1745377 | 1745377 | 2021-09-23 | Ventura | California | 6111 | 98211 | 1128 |
1742128 | 1742128 | 2021-09-22 | Ventura | California | 6111 | 98017 | 1124 |
1738879 | 1738879 | 2021-09-21 | Ventura | California | 6111 | 97899 | 1120 |
1735630 | 1735630 | 2021-09-20 | Ventura | California | 6111 | 97690 | 1120 |
1732380 | 1732380 | 2021-09-19 | Ventura | California | 6111 | 97623 | 1120 |
1729130 | 1729130 | 2021-09-18 | Ventura | California | 6111 | 97472 | 1116 |
1725880 | 1725880 | 2021-09-17 | Ventura | California | 6111 | 97286 | 1115 |
1722631 | 1722631 | 2021-09-16 | Ventura | California | 6111 | 97159 | 1112 |
1719382 | 1719382 | 2021-09-15 | Ventura | California | 6111 | 97002 | 1107 |
1716134 | 1716134 | 2021-09-14 | Ventura | California | 6111 | 96840 | 1107 |
1712888 | 1712888 | 2021-09-13 | Ventura | California | 6111 | 96657 | 1107 |
1709641 | 1709641 | 2021-09-12 | Ventura | California | 6111 | 96489 | 1107 |
1706394 | 1706394 | 2021-09-11 | Ventura | California | 6111 | 96306 | 1104 |
1703146 | 1703146 | 2021-09-10 | Ventura | California | 6111 | 95771 | 1098 |
1699896 | 1699896 | 2021-09-09 | Ventura | California | 6111 | 95506 | 1097 |
1696647 | 1696647 | 2021-09-08 | Ventura | California | 6111 | 95341 | 1093 |
1693399 | 1693399 | 2021-09-07 | Ventura | California | 6111 | 95227 | 1093 |
1690150 | 1690150 | 2021-09-06 | Ventura | California | 6111 | 95099 | 1093 |
1686900 | 1686900 | 2021-09-05 | Ventura | California | 6111 | 94999 | 1090 |
1683650 | 1683650 | 2021-09-04 | Ventura | California | 6111 | 94837 | 1088 |
1680399 | 1680399 | 2021-09-03 | Ventura | California | 6111 | 94705 | 1088 |
1677151 | 1677151 | 2021-09-02 | Ventura | California | 6111 | 94566 | 1089 |
1673904 | 1673904 | 2021-09-01 | Ventura | California | 6111 | 94353 | 1081 |
1670656 | 1670656 | 2021-08-31 | Ventura | California | 6111 | 94210 | 1082 |
1667409 | 1667409 | 2021-08-30 | Ventura | California | 6111 | 94175 | 1082 |
1664162 | 1664162 | 2021-08-29 | Ventura | California | 6111 | 93995 | 1081 |
1660914 | 1660914 | 2021-08-28 | Ventura | California | 6111 | 93835 | 1076 |
1657666 | 1657666 | 2021-08-27 | Ventura | California | 6111 | 93656 | 1080 |
1654418 | 1654418 | 2021-08-26 | Ventura | California | 6111 | 93440 | 1068 |
1651171 | 1651171 | 2021-08-25 | Ventura | California | 6111 | 93138 | 1068 |
1647922 | 1647922 | 2021-08-24 | Ventura | California | 6111 | 92931 | 1063 |
1644674 | 1644674 | 2021-08-23 | Ventura | California | 6111 | 92762 | 1063 |
1641424 | 1641424 | 2021-08-22 | Ventura | California | 6111 | 92529 | 1063 |
1638174 | 1638174 | 2021-08-21 | Ventura | California | 6111 | 92256 | 1061 |
1634924 | 1634924 | 2021-08-20 | Ventura | California | 6111 | 92044 | 1060 |
1631675 | 1631675 | 2021-08-19 | Ventura | California | 6111 | 91806 | 1055 |
1628428 | 1628428 | 2021-08-18 | Ventura | California | 6111 | 91338 | 1053 |
1625181 | 1625181 | 2021-08-17 | Ventura | California | 6111 | 90691 | 1052 |
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);