ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
326 rows where deaths = 18 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Colusa 160
- Mariposa 56
- Mendocino 19
- Marin 15
- Monterey 10
- Lake 9
- Calaveras 4
- Glenn 4
- Lassen 4
- Napa 4
- Del Norte 3
- San Benito 3
- Santa Barbara 3
- Yuba 3
- Amador 2
- Butte 2
- Humboldt 2
- Inyo 2
- San Luis Obispo 2
- Trinity 2
- Ventura 2
- Yolo 2
- El Dorado 1
- Imperial 1
- Madera 1
- Orange 1
- Placer 1
- Riverside 1
- Sacramento 1
- San Diego 1
- …
state 1
- California · 326 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2128850 | 2128850 | 2022-01-19 | Mariposa | California | 6043 | 2272 | 18 |
2125596 | 2125596 | 2022-01-18 | Mariposa | California | 6043 | 2235 | 18 |
2122344 | 2122344 | 2022-01-17 | Mariposa | California | 6043 | 2161 | 18 |
2119092 | 2119092 | 2022-01-16 | Mariposa | California | 6043 | 2161 | 18 |
2115840 | 2115840 | 2022-01-15 | Mariposa | California | 6043 | 2161 | 18 |
2112589 | 2112589 | 2022-01-14 | Mariposa | California | 6043 | 2161 | 18 |
2109337 | 2109337 | 2022-01-13 | Mariposa | California | 6043 | 2081 | 18 |
2106086 | 2106086 | 2022-01-12 | Mariposa | California | 6043 | 2039 | 18 |
2102835 | 2102835 | 2022-01-11 | Mariposa | California | 6043 | 2000 | 18 |
2099584 | 2099584 | 2022-01-10 | Mariposa | California | 6043 | 1975 | 18 |
2096333 | 2096333 | 2022-01-09 | Mariposa | California | 6043 | 1900 | 18 |
2093081 | 2093081 | 2022-01-08 | Mariposa | California | 6043 | 1900 | 18 |
2089829 | 2089829 | 2022-01-07 | Mariposa | California | 6043 | 1900 | 18 |
2086578 | 2086578 | 2022-01-06 | Mariposa | California | 6043 | 1840 | 18 |
2083326 | 2083326 | 2022-01-05 | Mariposa | California | 6043 | 1828 | 18 |
2083357 | 2083357 | 2022-01-05 | Trinity | California | 6105 | 1044 | 18 |
2080074 | 2080074 | 2022-01-04 | Mariposa | California | 6043 | 1794 | 18 |
2080105 | 2080105 | 2022-01-04 | Trinity | California | 6105 | 1044 | 18 |
2076822 | 2076822 | 2022-01-03 | Mariposa | California | 6043 | 1786 | 18 |
2073571 | 2073571 | 2022-01-02 | Mariposa | California | 6043 | 1736 | 18 |
2070320 | 2070320 | 2022-01-01 | Mariposa | California | 6043 | 1736 | 18 |
2067069 | 2067069 | 2021-12-31 | Mariposa | California | 6043 | 1736 | 18 |
2063818 | 2063818 | 2021-12-30 | Mariposa | California | 6043 | 1736 | 18 |
2060568 | 2060568 | 2021-12-29 | Mariposa | California | 6043 | 1716 | 18 |
2057319 | 2057319 | 2021-12-28 | Mariposa | California | 6043 | 1689 | 18 |
2054070 | 2054070 | 2021-12-27 | Mariposa | California | 6043 | 1689 | 18 |
2050820 | 2050820 | 2021-12-26 | Mariposa | California | 6043 | 1689 | 18 |
2047570 | 2047570 | 2021-12-25 | Mariposa | California | 6043 | 1689 | 18 |
2044320 | 2044320 | 2021-12-24 | Mariposa | California | 6043 | 1689 | 18 |
2041071 | 2041071 | 2021-12-23 | Mariposa | California | 6043 | 1681 | 18 |
2037821 | 2037821 | 2021-12-22 | Mariposa | California | 6043 | 1681 | 18 |
2034571 | 2034571 | 2021-12-21 | Mariposa | California | 6043 | 1679 | 18 |
2031321 | 2031321 | 2021-12-20 | Mariposa | California | 6043 | 1678 | 18 |
2028070 | 2028070 | 2021-12-19 | Mariposa | California | 6043 | 1671 | 18 |
2024819 | 2024819 | 2021-12-18 | Mariposa | California | 6043 | 1671 | 18 |
2021568 | 2021568 | 2021-12-17 | Mariposa | California | 6043 | 1671 | 18 |
2018317 | 2018317 | 2021-12-16 | Mariposa | California | 6043 | 1665 | 18 |
2015067 | 2015067 | 2021-12-15 | Mariposa | California | 6043 | 1661 | 18 |
2011816 | 2011816 | 2021-12-14 | Mariposa | California | 6043 | 1658 | 18 |
2008565 | 2008565 | 2021-12-13 | Mariposa | California | 6043 | 1657 | 18 |
2005314 | 2005314 | 2021-12-12 | Mariposa | California | 6043 | 1648 | 18 |
2002063 | 2002063 | 2021-12-11 | Mariposa | California | 6043 | 1648 | 18 |
1998813 | 1998813 | 2021-12-10 | Mariposa | California | 6043 | 1648 | 18 |
1995562 | 1995562 | 2021-12-09 | Mariposa | California | 6043 | 1640 | 18 |
1992311 | 1992311 | 2021-12-08 | Mariposa | California | 6043 | 1640 | 18 |
1989060 | 1989060 | 2021-12-07 | Mariposa | California | 6043 | 1638 | 18 |
1985810 | 1985810 | 2021-12-06 | Mariposa | California | 6043 | 1633 | 18 |
1982560 | 1982560 | 2021-12-05 | Mariposa | California | 6043 | 1622 | 18 |
1979310 | 1979310 | 2021-12-04 | Mariposa | California | 6043 | 1622 | 18 |
1976060 | 1976060 | 2021-12-03 | Mariposa | California | 6043 | 1622 | 18 |
1972811 | 1972811 | 2021-12-02 | Mariposa | California | 6043 | 1617 | 18 |
1969561 | 1969561 | 2021-12-01 | Mariposa | California | 6043 | 1607 | 18 |
1966311 | 1966311 | 2021-11-30 | Mariposa | California | 6043 | 1600 | 18 |
1963059 | 1963059 | 2021-11-29 | Mariposa | California | 6043 | 1598 | 18 |
1959808 | 1959808 | 2021-11-28 | Mariposa | California | 6043 | 1567 | 18 |
1956557 | 1956557 | 2021-11-27 | Mariposa | California | 6043 | 1567 | 18 |
1953306 | 1953306 | 2021-11-26 | Mariposa | California | 6043 | 1567 | 18 |
1950055 | 1950055 | 2021-11-25 | Mariposa | California | 6043 | 1567 | 18 |
1859046 | 1859046 | 2021-10-28 | Colusa | California | 6011 | 3116 | 18 |
1855797 | 1855797 | 2021-10-27 | Colusa | California | 6011 | 3096 | 18 |
1852548 | 1852548 | 2021-10-26 | Colusa | California | 6011 | 3089 | 18 |
1849299 | 1849299 | 2021-10-25 | Colusa | California | 6011 | 3076 | 18 |
1846049 | 1846049 | 2021-10-24 | Colusa | California | 6011 | 3076 | 18 |
1842799 | 1842799 | 2021-10-23 | Colusa | California | 6011 | 3076 | 18 |
1839549 | 1839549 | 2021-10-22 | Colusa | California | 6011 | 3076 | 18 |
1836300 | 1836300 | 2021-10-21 | Colusa | California | 6011 | 3072 | 18 |
1833051 | 1833051 | 2021-10-20 | Colusa | California | 6011 | 3033 | 18 |
1829802 | 1829802 | 2021-10-19 | Colusa | California | 6011 | 3030 | 18 |
1826553 | 1826553 | 2021-10-18 | Colusa | California | 6011 | 3028 | 18 |
1823304 | 1823304 | 2021-10-17 | Colusa | California | 6011 | 3017 | 18 |
1820055 | 1820055 | 2021-10-16 | Colusa | California | 6011 | 3017 | 18 |
1816806 | 1816806 | 2021-10-15 | Colusa | California | 6011 | 3017 | 18 |
1813558 | 1813558 | 2021-10-14 | Colusa | California | 6011 | 3016 | 18 |
1810309 | 1810309 | 2021-10-13 | Colusa | California | 6011 | 3002 | 18 |
1807060 | 1807060 | 2021-10-12 | Colusa | California | 6011 | 3001 | 18 |
1803809 | 1803809 | 2021-10-11 | Colusa | California | 6011 | 2999 | 18 |
1800560 | 1800560 | 2021-10-10 | Colusa | California | 6011 | 2993 | 18 |
1797311 | 1797311 | 2021-10-09 | Colusa | California | 6011 | 2993 | 18 |
1794062 | 1794062 | 2021-10-08 | Colusa | California | 6011 | 2993 | 18 |
1790814 | 1790814 | 2021-10-07 | Colusa | California | 6011 | 2988 | 18 |
1787565 | 1787565 | 2021-10-06 | Colusa | California | 6011 | 2979 | 18 |
1784316 | 1784316 | 2021-10-05 | Colusa | California | 6011 | 2979 | 18 |
1781067 | 1781067 | 2021-10-04 | Colusa | California | 6011 | 2978 | 18 |
1777817 | 1777817 | 2021-10-03 | Colusa | California | 6011 | 2968 | 18 |
1774567 | 1774567 | 2021-10-02 | Colusa | California | 6011 | 2968 | 18 |
1771317 | 1771317 | 2021-10-01 | Colusa | California | 6011 | 2968 | 18 |
1768068 | 1768068 | 2021-09-30 | Colusa | California | 6011 | 2966 | 18 |
1764819 | 1764819 | 2021-09-29 | Colusa | California | 6011 | 2951 | 18 |
1761570 | 1761570 | 2021-09-28 | Colusa | California | 6011 | 2945 | 18 |
1758322 | 1758322 | 2021-09-27 | Colusa | California | 6011 | 2944 | 18 |
1755074 | 1755074 | 2021-09-26 | Colusa | California | 6011 | 2939 | 18 |
1751826 | 1751826 | 2021-09-25 | Colusa | California | 6011 | 2939 | 18 |
1748577 | 1748577 | 2021-09-24 | Colusa | California | 6011 | 2939 | 18 |
1745327 | 1745327 | 2021-09-23 | Colusa | California | 6011 | 2936 | 18 |
1742078 | 1742078 | 2021-09-22 | Colusa | California | 6011 | 2912 | 18 |
1738829 | 1738829 | 2021-09-21 | Colusa | California | 6011 | 2910 | 18 |
1735580 | 1735580 | 2021-09-20 | Colusa | California | 6011 | 2909 | 18 |
1732330 | 1732330 | 2021-09-19 | Colusa | California | 6011 | 2907 | 18 |
1729080 | 1729080 | 2021-09-18 | Colusa | California | 6011 | 2903 | 18 |
1725830 | 1725830 | 2021-09-17 | Colusa | California | 6011 | 2897 | 18 |
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);