ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where deaths = 83 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 22
county 22
- Kings 18
- Napa 16
- Amador 10
- Yuba 9
- Santa Cruz 8
- Butte 7
- San Benito 7
- Calaveras 6
- Nevada 5
- San Francisco 5
- Sutter 4
- Marin 3
- Monterey 3
- San Joaquin 3
- Sacramento 2
- El Dorado 1
- Humboldt 1
- Lake 1
- Madera 1
- Sonoma 1
- Tehama 1
- Tuolumne 1
state 1
- California · 113 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278446 | 2278446 | 2022-03-06 | Amador | California | 6005 | 8997 | 83 |
2275193 | 2275193 | 2022-03-05 | Amador | California | 6005 | 8997 | 83 |
2271940 | 2271940 | 2022-03-04 | Amador | California | 6005 | 8997 | 83 |
2268688 | 2268688 | 2022-03-03 | Amador | California | 6005 | 8994 | 83 |
2265435 | 2265435 | 2022-03-02 | Amador | California | 6005 | 8981 | 83 |
2262184 | 2262184 | 2022-03-01 | Amador | California | 6005 | 8955 | 83 |
2258933 | 2258933 | 2022-02-28 | Amador | California | 6005 | 8952 | 83 |
2255682 | 2255682 | 2022-02-27 | Amador | California | 6005 | 8929 | 83 |
2252431 | 2252431 | 2022-02-26 | Amador | California | 6005 | 8929 | 83 |
2249180 | 2249180 | 2022-02-25 | Amador | California | 6005 | 8929 | 83 |
2106099 | 2106099 | 2022-01-12 | San Benito | California | 6069 | 9873 | 83 |
2102848 | 2102848 | 2022-01-11 | San Benito | California | 6069 | 9716 | 83 |
2099597 | 2099597 | 2022-01-10 | San Benito | California | 6069 | 9612 | 83 |
2096346 | 2096346 | 2022-01-09 | San Benito | California | 6069 | 9265 | 83 |
2093094 | 2093094 | 2022-01-08 | San Benito | California | 6069 | 9265 | 83 |
2089842 | 2089842 | 2022-01-07 | San Benito | California | 6069 | 9265 | 83 |
2086591 | 2086591 | 2022-01-06 | San Benito | California | 6069 | 9078 | 83 |
1924034 | 1924034 | 2021-11-17 | Calaveras | California | 6009 | 4313 | 83 |
1920785 | 1920785 | 2021-11-16 | Calaveras | California | 6009 | 4301 | 83 |
1914285 | 1914285 | 2021-11-14 | Calaveras | California | 6009 | 4267 | 83 |
1911035 | 1911035 | 2021-11-13 | Calaveras | California | 6009 | 4267 | 83 |
1907786 | 1907786 | 2021-11-12 | Calaveras | California | 6009 | 4243 | 83 |
1904537 | 1904537 | 2021-11-11 | Calaveras | California | 6009 | 4243 | 83 |
1898090 | 1898090 | 2021-11-09 | Yuba | California | 6115 | 10912 | 83 |
1894840 | 1894840 | 2021-11-08 | Yuba | California | 6115 | 10912 | 83 |
1891590 | 1891590 | 2021-11-07 | Yuba | California | 6115 | 10842 | 83 |
1888340 | 1888340 | 2021-11-06 | Yuba | California | 6115 | 10842 | 83 |
1885090 | 1885090 | 2021-11-05 | Yuba | California | 6115 | 10842 | 83 |
1881841 | 1881841 | 2021-11-04 | Yuba | California | 6115 | 10842 | 83 |
1878592 | 1878592 | 2021-11-03 | Yuba | California | 6115 | 10793 | 83 |
1875343 | 1875343 | 2021-11-02 | Yuba | California | 6115 | 10770 | 83 |
1872094 | 1872094 | 2021-11-01 | Yuba | California | 6115 | 10770 | 83 |
1725876 | 1725876 | 2021-09-17 | Tehama | California | 6103 | 8109 | 83 |
1722587 | 1722587 | 2021-09-16 | Humboldt | California | 6023 | 8135 | 83 |
1719343 | 1719343 | 2021-09-15 | Lake | California | 6033 | 5923 | 83 |
1664135 | 1664135 | 2021-08-29 | Nevada | California | 6057 | 7478 | 83 |
1660887 | 1660887 | 2021-08-28 | Nevada | California | 6057 | 7409 | 83 |
1657639 | 1657639 | 2021-08-27 | Nevada | California | 6057 | 7326 | 83 |
1654391 | 1654391 | 2021-08-26 | Nevada | California | 6057 | 7240 | 83 |
1644673 | 1644673 | 2021-08-23 | Tuolumne | California | 6109 | 5403 | 83 |
1638146 | 1638146 | 2021-08-21 | Napa | California | 6055 | 11219 | 83 |
1634896 | 1634896 | 2021-08-20 | Napa | California | 6055 | 11171 | 83 |
1631647 | 1631647 | 2021-08-19 | Napa | California | 6055 | 11127 | 83 |
1628400 | 1628400 | 2021-08-18 | Napa | California | 6055 | 11061 | 83 |
1625153 | 1625153 | 2021-08-17 | Napa | California | 6055 | 11000 | 83 |
1621906 | 1621906 | 2021-08-16 | Napa | California | 6055 | 10973 | 83 |
1618659 | 1618659 | 2021-08-15 | Napa | California | 6055 | 10932 | 83 |
1615411 | 1615411 | 2021-08-14 | Napa | California | 6055 | 10884 | 83 |
1612162 | 1612162 | 2021-08-13 | Napa | California | 6055 | 10834 | 83 |
1608914 | 1608914 | 2021-08-12 | Napa | California | 6055 | 10786 | 83 |
1605665 | 1605665 | 2021-08-11 | Napa | California | 6055 | 10757 | 83 |
1602416 | 1602416 | 2021-08-10 | Napa | California | 6055 | 10733 | 83 |
1599167 | 1599167 | 2021-08-09 | Napa | California | 6055 | 10722 | 83 |
1595918 | 1595918 | 2021-08-08 | Napa | California | 6055 | 10712 | 83 |
1592669 | 1592669 | 2021-08-07 | Napa | California | 6055 | 10645 | 83 |
1589420 | 1589420 | 2021-08-06 | Napa | California | 6055 | 10645 | 83 |
1160847 | 1160847 | 2021-03-27 | Nevada | California | 6057 | 4222 | 83 |
995278 | 995278 | 2021-02-04 | El Dorado | California | 6017 | 8428 | 83 |
962864 | 962864 | 2021-01-25 | Sutter | California | 6101 | 8069 | 83 |
959619 | 959619 | 2021-01-24 | Sutter | California | 6101 | 7943 | 83 |
956373 | 956373 | 2021-01-23 | Sutter | California | 6101 | 7927 | 83 |
953128 | 953128 | 2021-01-22 | Sutter | California | 6101 | 7927 | 83 |
894706 | 894706 | 2021-01-04 | Santa Cruz | California | 6087 | 9579 | 83 |
891459 | 891459 | 2021-01-03 | Santa Cruz | California | 6087 | 9340 | 83 |
888212 | 888212 | 2021-01-02 | Santa Cruz | California | 6087 | 9146 | 83 |
884967 | 884967 | 2021-01-01 | Santa Cruz | California | 6087 | 8909 | 83 |
881722 | 881722 | 2020-12-31 | Santa Cruz | California | 6087 | 8749 | 83 |
878477 | 878477 | 2020-12-30 | Santa Cruz | California | 6087 | 8492 | 83 |
875232 | 875232 | 2020-12-29 | Santa Cruz | California | 6087 | 8310 | 83 |
871987 | 871987 | 2020-12-28 | Santa Cruz | California | 6087 | 8234 | 83 |
868702 | 868702 | 2020-12-27 | Butte | California | 6007 | 6968 | 83 |
865457 | 865457 | 2020-12-26 | Butte | California | 6007 | 6873 | 83 |
862212 | 862212 | 2020-12-25 | Butte | California | 6007 | 6716 | 83 |
858967 | 858967 | 2020-12-24 | Butte | California | 6007 | 6588 | 83 |
855722 | 855722 | 2020-12-23 | Butte | California | 6007 | 6584 | 83 |
852477 | 852477 | 2020-12-22 | Butte | California | 6007 | 6473 | 83 |
849232 | 849232 | 2020-12-21 | Butte | California | 6007 | 6344 | 83 |
761623 | 761623 | 2020-11-24 | Madera | California | 6039 | 5938 | 83 |
686996 | 686996 | 2020-11-01 | Kings | California | 6031 | 8612 | 83 |
683752 | 683752 | 2020-10-31 | Kings | California | 6031 | 8564 | 83 |
680509 | 680509 | 2020-10-30 | Kings | California | 6031 | 8502 | 83 |
677266 | 677266 | 2020-10-29 | Kings | California | 6031 | 8486 | 83 |
674023 | 674023 | 2020-10-28 | Kings | California | 6031 | 8411 | 83 |
670781 | 670781 | 2020-10-27 | Kings | California | 6031 | 8370 | 83 |
667538 | 667538 | 2020-10-26 | Kings | California | 6031 | 8246 | 83 |
664293 | 664293 | 2020-10-25 | Kings | California | 6031 | 8228 | 83 |
661049 | 661049 | 2020-10-24 | Kings | California | 6031 | 8218 | 83 |
657805 | 657805 | 2020-10-23 | Kings | California | 6031 | 8201 | 83 |
654560 | 654560 | 2020-10-22 | Kings | California | 6031 | 8186 | 83 |
651315 | 651315 | 2020-10-21 | Kings | California | 6031 | 8178 | 83 |
648071 | 648071 | 2020-10-20 | Kings | California | 6031 | 8173 | 83 |
644826 | 644826 | 2020-10-19 | Kings | California | 6031 | 8159 | 83 |
644837 | 644837 | 2020-10-19 | Monterey | California | 6053 | 11117 | 83 |
641578 | 641578 | 2020-10-18 | Kings | California | 6031 | 8151 | 83 |
641589 | 641589 | 2020-10-18 | Monterey | California | 6053 | 11091 | 83 |
638331 | 638331 | 2020-10-17 | Kings | California | 6031 | 8146 | 83 |
638342 | 638342 | 2020-10-17 | Monterey | California | 6053 | 11022 | 83 |
635086 | 635086 | 2020-10-16 | Kings | California | 6031 | 8134 | 83 |
631840 | 631840 | 2020-10-15 | Kings | California | 6031 | 8118 | 83 |
489364 | 489364 | 2020-09-01 | San Francisco | California | 6075 | 9547 | 83 |
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);