ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where deaths = 82 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 18
county 18
- Napa 33
- Yuba 17
- Calaveras 14
- Kings 11
- Tuolumne 6
- San Luis Obispo 5
- Marin 4
- Humboldt 3
- Lake 3
- Mendocino 3
- San Bernardino 3
- San Mateo 3
- Kern 2
- Monterey 2
- San Francisco 1
- Santa Barbara 1
- Sutter 1
- Ventura 1
state 1
- California · 113 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1898037 | 1898037 | 2021-11-09 | Calaveras | California | 6009 | 4225 | 82 |
1894787 | 1894787 | 2021-11-08 | Calaveras | California | 6009 | 4217 | 82 |
1891537 | 1891537 | 2021-11-07 | Calaveras | California | 6009 | 4164 | 82 |
1888287 | 1888287 | 2021-11-06 | Calaveras | California | 6009 | 4164 | 82 |
1885037 | 1885037 | 2021-11-05 | Calaveras | California | 6009 | 4164 | 82 |
1881788 | 1881788 | 2021-11-04 | Calaveras | California | 6009 | 4146 | 82 |
1878539 | 1878539 | 2021-11-03 | Calaveras | California | 6009 | 4129 | 82 |
1875290 | 1875290 | 2021-11-02 | Calaveras | California | 6009 | 4113 | 82 |
1872041 | 1872041 | 2021-11-01 | Calaveras | California | 6009 | 4106 | 82 |
1868792 | 1868792 | 2021-10-31 | Calaveras | California | 6009 | 4046 | 82 |
1868845 | 1868845 | 2021-10-31 | Yuba | California | 6115 | 10665 | 82 |
1865543 | 1865543 | 2021-10-30 | Calaveras | California | 6009 | 4046 | 82 |
1865596 | 1865596 | 2021-10-30 | Yuba | California | 6115 | 10665 | 82 |
1862294 | 1862294 | 2021-10-29 | Calaveras | California | 6009 | 4046 | 82 |
1862347 | 1862347 | 2021-10-29 | Yuba | California | 6115 | 10665 | 82 |
1859045 | 1859045 | 2021-10-28 | Calaveras | California | 6009 | 4024 | 82 |
1859098 | 1859098 | 2021-10-28 | Yuba | California | 6115 | 10665 | 82 |
1855849 | 1855849 | 2021-10-27 | Yuba | California | 6115 | 10620 | 82 |
1852547 | 1852547 | 2021-10-26 | Calaveras | California | 6009 | 3991 | 82 |
1852600 | 1852600 | 2021-10-26 | Yuba | California | 6115 | 10592 | 82 |
1849351 | 1849351 | 2021-10-25 | Yuba | California | 6115 | 10581 | 82 |
1846101 | 1846101 | 2021-10-24 | Yuba | California | 6115 | 10488 | 82 |
1842851 | 1842851 | 2021-10-23 | Yuba | California | 6115 | 10488 | 82 |
1839601 | 1839601 | 2021-10-22 | Yuba | California | 6115 | 10488 | 82 |
1836352 | 1836352 | 2021-10-21 | Yuba | California | 6115 | 10488 | 82 |
1833103 | 1833103 | 2021-10-20 | Yuba | California | 6115 | 10470 | 82 |
1829854 | 1829854 | 2021-10-19 | Yuba | California | 6115 | 10435 | 82 |
1826605 | 1826605 | 2021-10-18 | Yuba | California | 6115 | 10415 | 82 |
1823356 | 1823356 | 2021-10-17 | Yuba | California | 6115 | 10318 | 82 |
1820107 | 1820107 | 2021-10-16 | Yuba | California | 6115 | 10318 | 82 |
1816858 | 1816858 | 2021-10-15 | Yuba | California | 6115 | 10318 | 82 |
1764836 | 1764836 | 2021-09-29 | Mendocino | California | 6045 | 7131 | 82 |
1761587 | 1761587 | 2021-09-28 | Mendocino | California | 6045 | 7088 | 82 |
1758339 | 1758339 | 2021-09-27 | Mendocino | California | 6045 | 7071 | 82 |
1719338 | 1719338 | 2021-09-15 | Humboldt | California | 6023 | 8027 | 82 |
1716090 | 1716090 | 2021-09-14 | Humboldt | California | 6023 | 7969 | 82 |
1716095 | 1716095 | 2021-09-14 | Lake | California | 6033 | 5887 | 82 |
1712844 | 1712844 | 2021-09-13 | Humboldt | California | 6023 | 7946 | 82 |
1712849 | 1712849 | 2021-09-13 | Lake | California | 6033 | 5859 | 82 |
1709602 | 1709602 | 2021-09-12 | Lake | California | 6033 | 5839 | 82 |
1641423 | 1641423 | 2021-08-22 | Tuolumne | California | 6109 | 5371 | 82 |
1638173 | 1638173 | 2021-08-21 | Tuolumne | California | 6109 | 5331 | 82 |
1634923 | 1634923 | 2021-08-20 | Tuolumne | California | 6109 | 5303 | 82 |
1631674 | 1631674 | 2021-08-19 | Tuolumne | California | 6109 | 5276 | 82 |
1628427 | 1628427 | 2021-08-18 | Tuolumne | California | 6109 | 5240 | 82 |
1625180 | 1625180 | 2021-08-17 | Tuolumne | California | 6109 | 5192 | 82 |
1586171 | 1586171 | 2021-08-05 | Napa | California | 6055 | 10598 | 82 |
1582921 | 1582921 | 2021-08-04 | Napa | California | 6055 | 10574 | 82 |
1579671 | 1579671 | 2021-08-03 | Napa | California | 6055 | 10537 | 82 |
1576423 | 1576423 | 2021-08-02 | Napa | California | 6055 | 10520 | 82 |
1573175 | 1573175 | 2021-08-01 | Napa | California | 6055 | 10448 | 82 |
1569927 | 1569927 | 2021-07-31 | Napa | California | 6055 | 10448 | 82 |
1566679 | 1566679 | 2021-07-30 | Napa | California | 6055 | 10448 | 82 |
1563431 | 1563431 | 2021-07-29 | Napa | California | 6055 | 10423 | 82 |
1560183 | 1560183 | 2021-07-28 | Napa | California | 6055 | 10401 | 82 |
1556936 | 1556936 | 2021-07-27 | Napa | California | 6055 | 10379 | 82 |
1553689 | 1553689 | 2021-07-26 | Napa | California | 6055 | 10363 | 82 |
1381643 | 1381643 | 2021-06-03 | Napa | California | 6055 | 9954 | 82 |
1378398 | 1378398 | 2021-06-02 | Napa | California | 6055 | 9950 | 82 |
1375152 | 1375152 | 2021-06-01 | Napa | California | 6055 | 9949 | 82 |
1371907 | 1371907 | 2021-05-31 | Napa | California | 6055 | 9949 | 82 |
1368662 | 1368662 | 2021-05-30 | Napa | California | 6055 | 9949 | 82 |
1365416 | 1365416 | 2021-05-29 | Napa | California | 6055 | 9942 | 82 |
1362170 | 1362170 | 2021-05-28 | Napa | California | 6055 | 9935 | 82 |
1358923 | 1358923 | 2021-05-27 | Napa | California | 6055 | 9933 | 82 |
1355677 | 1355677 | 2021-05-26 | Napa | California | 6055 | 9927 | 82 |
1352431 | 1352431 | 2021-05-25 | Napa | California | 6055 | 9925 | 82 |
1349185 | 1349185 | 2021-05-24 | Napa | California | 6055 | 9924 | 82 |
1345938 | 1345938 | 2021-05-23 | Napa | California | 6055 | 9919 | 82 |
1342690 | 1342690 | 2021-05-22 | Napa | California | 6055 | 9914 | 82 |
1339442 | 1339442 | 2021-05-21 | Napa | California | 6055 | 9914 | 82 |
1336195 | 1336195 | 2021-05-20 | Napa | California | 6055 | 9907 | 82 |
1332948 | 1332948 | 2021-05-19 | Napa | California | 6055 | 9906 | 82 |
1329701 | 1329701 | 2021-05-18 | Napa | California | 6055 | 9895 | 82 |
1326454 | 1326454 | 2021-05-17 | Napa | California | 6055 | 9892 | 82 |
1323208 | 1323208 | 2021-05-16 | Napa | California | 6055 | 9888 | 82 |
1319962 | 1319962 | 2021-05-15 | Napa | California | 6055 | 9884 | 82 |
1316715 | 1316715 | 2021-05-14 | Napa | California | 6055 | 9878 | 82 |
1313468 | 1313468 | 2021-05-13 | Napa | California | 6055 | 9871 | 82 |
949883 | 949883 | 2021-01-21 | Sutter | California | 6101 | 7855 | 82 |
891455 | 891455 | 2021-01-03 | San Luis Obispo | California | 6079 | 11467 | 82 |
888208 | 888208 | 2021-01-02 | San Luis Obispo | California | 6079 | 11160 | 82 |
884963 | 884963 | 2021-01-01 | San Luis Obispo | California | 6079 | 10846 | 82 |
881718 | 881718 | 2020-12-31 | San Luis Obispo | California | 6079 | 10490 | 82 |
878473 | 878473 | 2020-12-30 | San Luis Obispo | California | 6079 | 10387 | 82 |
635097 | 635097 | 2020-10-16 | Monterey | California | 6053 | 10943 | 82 |
631851 | 631851 | 2020-10-15 | Monterey | California | 6053 | 10887 | 82 |
628596 | 628596 | 2020-10-14 | Kings | California | 6031 | 8111 | 82 |
625353 | 625353 | 2020-10-13 | Kings | California | 6031 | 8106 | 82 |
622110 | 622110 | 2020-10-12 | Kings | California | 6031 | 8094 | 82 |
618867 | 618867 | 2020-10-11 | Kings | California | 6031 | 8078 | 82 |
615625 | 615625 | 2020-10-10 | Kings | California | 6031 | 8071 | 82 |
612384 | 612384 | 2020-10-09 | Kings | California | 6031 | 7982 | 82 |
609142 | 609142 | 2020-10-08 | Kings | California | 6031 | 7956 | 82 |
605899 | 605899 | 2020-10-07 | Kings | California | 6031 | 7943 | 82 |
602657 | 602657 | 2020-10-06 | Kings | California | 6031 | 7933 | 82 |
599414 | 599414 | 2020-10-05 | Kings | California | 6031 | 7919 | 82 |
596171 | 596171 | 2020-10-04 | Kings | California | 6031 | 7912 | 82 |
473196 | 473196 | 2020-08-27 | San Francisco | California | 6075 | 9152 | 82 |
447370 | 447370 | 2020-08-19 | Santa Barbara | California | 6083 | 7508 | 82 |
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);