ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where deaths = 51 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2193910 | 2193910 | 2022-02-08 | Inyo | California | 6027 | 4435 | 51 |
2190657 | 2190657 | 2022-02-07 | Inyo | California | 6027 | 4429 | 51 |
2187404 | 2187404 | 2022-02-06 | Inyo | California | 6027 | 4407 | 51 |
2184151 | 2184151 | 2022-02-05 | Inyo | California | 6027 | 4407 | 51 |
2180899 | 2180899 | 2022-02-04 | Inyo | California | 6027 | 4407 | 51 |
2177648 | 2177648 | 2022-02-03 | Inyo | California | 6027 | 4403 | 51 |
2174395 | 2174395 | 2022-02-02 | Inyo | California | 6027 | 4232 | 51 |
2008554 | 2008554 | 2021-12-13 | Glenn | California | 6021 | 4626 | 51 |
2005303 | 2005303 | 2021-12-12 | Glenn | California | 6021 | 4622 | 51 |
2002052 | 2002052 | 2021-12-11 | Glenn | California | 6021 | 4622 | 51 |
1998802 | 1998802 | 2021-12-10 | Glenn | California | 6021 | 4622 | 51 |
1995551 | 1995551 | 2021-12-09 | Glenn | California | 6021 | 4621 | 51 |
1992300 | 1992300 | 2021-12-08 | Glenn | California | 6021 | 4605 | 51 |
1989049 | 1989049 | 2021-12-07 | Glenn | California | 6021 | 4603 | 51 |
1985799 | 1985799 | 2021-12-06 | Glenn | California | 6021 | 4603 | 51 |
1982549 | 1982549 | 2021-12-05 | Glenn | California | 6021 | 4585 | 51 |
1979299 | 1979299 | 2021-12-04 | Glenn | California | 6021 | 4585 | 51 |
1976049 | 1976049 | 2021-12-03 | Glenn | California | 6021 | 4585 | 51 |
1972800 | 1972800 | 2021-12-02 | Glenn | California | 6021 | 4582 | 51 |
1969550 | 1969550 | 2021-12-01 | Glenn | California | 6021 | 4574 | 51 |
1966300 | 1966300 | 2021-11-30 | Glenn | California | 6021 | 4574 | 51 |
1963048 | 1963048 | 2021-11-29 | Glenn | California | 6021 | 4566 | 51 |
1959797 | 1959797 | 2021-11-28 | Glenn | California | 6021 | 4551 | 51 |
1956546 | 1956546 | 2021-11-27 | Glenn | California | 6021 | 4551 | 51 |
1953295 | 1953295 | 2021-11-26 | Glenn | California | 6021 | 4551 | 51 |
1950044 | 1950044 | 2021-11-25 | Glenn | California | 6021 | 4551 | 51 |
1946793 | 1946793 | 2021-11-24 | Glenn | California | 6021 | 4551 | 51 |
1943542 | 1943542 | 2021-11-23 | Glenn | California | 6021 | 4549 | 51 |
1872054 | 1872054 | 2021-11-01 | Lassen | California | 6035 | 7671 | 51 |
1868805 | 1868805 | 2021-10-31 | Lassen | California | 6035 | 7671 | 51 |
1865556 | 1865556 | 2021-10-30 | Lassen | California | 6035 | 7671 | 51 |
1862307 | 1862307 | 2021-10-29 | Lassen | California | 6035 | 7671 | 51 |
1859058 | 1859058 | 2021-10-28 | Lassen | California | 6035 | 7650 | 51 |
1855809 | 1855809 | 2021-10-27 | Lassen | California | 6035 | 7634 | 51 |
1764860 | 1764860 | 2021-09-29 | Siskiyou | California | 6093 | 4355 | 51 |
1761611 | 1761611 | 2021-09-28 | Siskiyou | California | 6093 | 4309 | 51 |
1758363 | 1758363 | 2021-09-27 | Siskiyou | California | 6093 | 4295 | 51 |
1755115 | 1755115 | 2021-09-26 | Siskiyou | California | 6093 | 4253 | 51 |
1751867 | 1751867 | 2021-09-25 | Siskiyou | California | 6093 | 4253 | 51 |
1748618 | 1748618 | 2021-09-24 | Siskiyou | California | 6093 | 4253 | 51 |
1745368 | 1745368 | 2021-09-23 | Siskiyou | California | 6093 | 4227 | 51 |
1742119 | 1742119 | 2021-09-22 | Siskiyou | California | 6093 | 4198 | 51 |
1634926 | 1634926 | 2021-08-20 | Yuba | California | 6115 | 7860 | 51 |
1631677 | 1631677 | 2021-08-19 | Yuba | California | 6115 | 7789 | 51 |
1628430 | 1628430 | 2021-08-18 | Yuba | California | 6115 | 7789 | 51 |
1625183 | 1625183 | 2021-08-17 | Yuba | California | 6115 | 7737 | 51 |
1621936 | 1621936 | 2021-08-16 | Yuba | California | 6115 | 7584 | 51 |
1618689 | 1618689 | 2021-08-15 | Yuba | California | 6115 | 7562 | 51 |
1615441 | 1615441 | 2021-08-14 | Yuba | California | 6115 | 7562 | 51 |
1612192 | 1612192 | 2021-08-13 | Yuba | California | 6115 | 7562 | 51 |
1566674 | 1566674 | 2021-07-30 | Mendocino | California | 6045 | 4683 | 51 |
1563426 | 1563426 | 2021-07-29 | Mendocino | California | 6045 | 4683 | 51 |
1563461 | 1563461 | 2021-07-29 | Yuba | California | 6115 | 6985 | 51 |
1560213 | 1560213 | 2021-07-28 | Yuba | California | 6115 | 6949 | 51 |
1556966 | 1556966 | 2021-07-27 | Yuba | California | 6115 | 6916 | 51 |
1553719 | 1553719 | 2021-07-26 | Yuba | California | 6115 | 6878 | 51 |
1550472 | 1550472 | 2021-07-25 | Yuba | California | 6115 | 6843 | 51 |
1547225 | 1547225 | 2021-07-24 | Yuba | California | 6115 | 6843 | 51 |
1543978 | 1543978 | 2021-07-23 | Yuba | California | 6115 | 6843 | 51 |
1508212 | 1508212 | 2021-07-12 | Humboldt | California | 6023 | 4748 | 51 |
1504966 | 1504966 | 2021-07-11 | Humboldt | California | 6023 | 4711 | 51 |
1501720 | 1501720 | 2021-07-10 | Humboldt | California | 6023 | 4711 | 51 |
1498474 | 1498474 | 2021-07-09 | Humboldt | California | 6023 | 4711 | 51 |
1495227 | 1495227 | 2021-07-08 | Humboldt | California | 6023 | 4703 | 51 |
1495273 | 1495273 | 2021-07-08 | Yuba | California | 6115 | 6586 | 51 |
1491980 | 1491980 | 2021-07-07 | Humboldt | California | 6023 | 4614 | 51 |
1492027 | 1492027 | 2021-07-07 | Yuba | California | 6115 | 6577 | 51 |
1488733 | 1488733 | 2021-07-06 | Humboldt | California | 6023 | 4608 | 51 |
1488780 | 1488780 | 2021-07-06 | Yuba | California | 6115 | 6576 | 51 |
1485533 | 1485533 | 2021-07-05 | Yuba | California | 6115 | 6555 | 51 |
1482287 | 1482287 | 2021-07-04 | Yuba | California | 6115 | 6555 | 51 |
1479040 | 1479040 | 2021-07-03 | Yuba | California | 6115 | 6555 | 51 |
1475794 | 1475794 | 2021-07-02 | Yuba | California | 6115 | 6555 | 51 |
1472548 | 1472548 | 2021-07-01 | Yuba | California | 6115 | 6545 | 51 |
1469302 | 1469302 | 2021-06-30 | Yuba | California | 6115 | 6538 | 51 |
1466057 | 1466057 | 2021-06-29 | Yuba | California | 6115 | 6539 | 51 |
1462812 | 1462812 | 2021-06-28 | Yuba | California | 6115 | 6529 | 51 |
1459567 | 1459567 | 2021-06-27 | Yuba | California | 6115 | 6526 | 51 |
1456322 | 1456322 | 2021-06-26 | Yuba | California | 6115 | 6526 | 51 |
1453077 | 1453077 | 2021-06-25 | Yuba | California | 6115 | 6526 | 51 |
1449831 | 1449831 | 2021-06-24 | Yuba | California | 6115 | 6521 | 51 |
1446586 | 1446586 | 2021-06-23 | Yuba | California | 6115 | 6519 | 51 |
1443341 | 1443341 | 2021-06-22 | Yuba | California | 6115 | 6512 | 51 |
1440096 | 1440096 | 2021-06-21 | Yuba | California | 6115 | 6489 | 51 |
1436849 | 1436849 | 2021-06-20 | Yuba | California | 6115 | 6485 | 51 |
1433602 | 1433602 | 2021-06-19 | Yuba | California | 6115 | 6485 | 51 |
1430356 | 1430356 | 2021-06-18 | Yuba | California | 6115 | 6485 | 51 |
1427111 | 1427111 | 2021-06-17 | Yuba | California | 6115 | 6464 | 51 |
1423866 | 1423866 | 2021-06-16 | Yuba | California | 6115 | 6464 | 51 |
1238770 | 1238770 | 2021-04-20 | Calaveras | California | 6009 | 2050 | 51 |
1235523 | 1235523 | 2021-04-19 | Calaveras | California | 6009 | 2047 | 51 |
1232276 | 1232276 | 2021-04-18 | Calaveras | California | 6009 | 2045 | 51 |
1229027 | 1229027 | 2021-04-17 | Calaveras | California | 6009 | 2042 | 51 |
1225779 | 1225779 | 2021-04-16 | Calaveras | California | 6009 | 2039 | 51 |
1222532 | 1222532 | 2021-04-15 | Calaveras | California | 6009 | 2037 | 51 |
1219284 | 1219284 | 2021-04-14 | Calaveras | California | 6009 | 2035 | 51 |
1216036 | 1216036 | 2021-04-13 | Calaveras | California | 6009 | 2033 | 51 |
1212789 | 1212789 | 2021-04-12 | Calaveras | California | 6009 | 2036 | 51 |
1209541 | 1209541 | 2021-04-11 | Calaveras | California | 6009 | 2032 | 51 |
1206292 | 1206292 | 2021-04-10 | Calaveras | California | 6009 | 2028 | 51 |
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);