ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where deaths = 108 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 18
county 18
- El Dorado 14
- Humboldt 8
- San Mateo 7
- Nevada 3
- Sonoma 3
- Tuolumne 3
- Sacramento 2
- San Francisco 2
- Yolo 2
- Contra Costa 1
- Kings 1
- Monterey 1
- Napa 1
- San Bernardino 1
- Santa Clara 1
- Solano 1
- Tehama 1
- Yuba 1
state 1
- California · 53 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2216725 | 2216725 | 2022-02-15 | Yuba | California | 6115 | 17080 | 108 |
2086584 | 2086584 | 2022-01-06 | Napa | California | 6055 | 15709 | 108 |
2028077 | 2028077 | 2021-12-19 | Nevada | California | 6057 | 10354 | 108 |
2024826 | 2024826 | 2021-12-18 | Nevada | California | 6057 | 10354 | 108 |
2021575 | 2021575 | 2021-12-17 | Nevada | California | 6057 | 10354 | 108 |
1836306 | 1836306 | 2021-10-21 | Humboldt | California | 6023 | 9243 | 108 |
1833057 | 1833057 | 2021-10-20 | Humboldt | California | 6023 | 9195 | 108 |
1833097 | 1833097 | 2021-10-20 | Tehama | California | 6103 | 9448 | 108 |
1826559 | 1826559 | 2021-10-18 | Humboldt | California | 6023 | 9171 | 108 |
1823310 | 1823310 | 2021-10-17 | Humboldt | California | 6023 | 9102 | 108 |
1823353 | 1823353 | 2021-10-17 | Tuolumne | California | 6109 | 6891 | 108 |
1820061 | 1820061 | 2021-10-16 | Humboldt | California | 6023 | 9102 | 108 |
1820104 | 1820104 | 2021-10-16 | Tuolumne | California | 6109 | 6891 | 108 |
1816812 | 1816812 | 2021-10-15 | Humboldt | California | 6023 | 9102 | 108 |
1816855 | 1816855 | 2021-10-15 | Tuolumne | California | 6109 | 6891 | 108 |
1813564 | 1813564 | 2021-10-14 | Humboldt | California | 6023 | 9085 | 108 |
1810315 | 1810315 | 2021-10-13 | Humboldt | California | 6023 | 9042 | 108 |
1222536 | 1222536 | 2021-04-15 | El Dorado | California | 6017 | 9625 | 108 |
1219288 | 1219288 | 2021-04-14 | El Dorado | California | 6017 | 9609 | 108 |
1216040 | 1216040 | 2021-04-13 | El Dorado | California | 6017 | 9588 | 108 |
1212793 | 1212793 | 2021-04-12 | El Dorado | California | 6017 | 9575 | 108 |
1209545 | 1209545 | 2021-04-11 | El Dorado | California | 6017 | 9549 | 108 |
1206296 | 1206296 | 2021-04-10 | El Dorado | California | 6017 | 9528 | 108 |
1203048 | 1203048 | 2021-04-09 | El Dorado | California | 6017 | 9513 | 108 |
1199800 | 1199800 | 2021-04-08 | El Dorado | California | 6017 | 9500 | 108 |
1196551 | 1196551 | 2021-04-07 | El Dorado | California | 6017 | 9489 | 108 |
1193303 | 1193303 | 2021-04-06 | El Dorado | California | 6017 | 9463 | 108 |
1190053 | 1190053 | 2021-04-05 | El Dorado | California | 6017 | 9455 | 108 |
1186806 | 1186806 | 2021-04-04 | El Dorado | California | 6017 | 9448 | 108 |
1183559 | 1183559 | 2021-04-03 | El Dorado | California | 6017 | 9437 | 108 |
1180312 | 1180312 | 2021-04-02 | El Dorado | California | 6017 | 9393 | 108 |
949880 | 949880 | 2021-01-21 | Solano | California | 6095 | 26196 | 108 |
855734 | 855734 | 2020-12-23 | Kings | California | 6031 | 14952 | 108 |
855775 | 855775 | 2020-12-23 | Yolo | California | 6113 | 7388 | 108 |
852530 | 852530 | 2020-12-22 | Yolo | California | 6113 | 7266 | 108 |
729171 | 729171 | 2020-11-14 | Monterey | California | 6053 | 12769 | 108 |
599436 | 599436 | 2020-10-05 | San Francisco | California | 6075 | 11483 | 108 |
596193 | 596193 | 2020-10-04 | San Francisco | California | 6075 | 11478 | 108 |
528185 | 528185 | 2020-09-13 | Sonoma | California | 6097 | 6701 | 108 |
524949 | 524949 | 2020-09-12 | Sonoma | California | 6097 | 6666 | 108 |
521713 | 521713 | 2020-09-11 | Sonoma | California | 6097 | 6623 | 108 |
376480 | 376480 | 2020-07-28 | Contra Costa | California | 6013 | 7304 | 108 |
370080 | 370080 | 2020-07-26 | Sacramento | California | 6067 | 8902 | 108 |
366870 | 366870 | 2020-07-25 | Sacramento | California | 6067 | 8635 | 108 |
306251 | 306251 | 2020-07-06 | San Mateo | California | 6081 | 3599 | 108 |
303087 | 303087 | 2020-07-05 | San Mateo | California | 6081 | 3536 | 108 |
299923 | 299923 | 2020-07-04 | San Mateo | California | 6081 | 3536 | 108 |
296761 | 296761 | 2020-07-03 | San Mateo | California | 6081 | 3441 | 108 |
293605 | 293605 | 2020-07-02 | San Mateo | California | 6081 | 3376 | 108 |
290451 | 290451 | 2020-07-01 | San Mateo | California | 6081 | 3268 | 108 |
287300 | 287300 | 2020-06-30 | San Mateo | California | 6081 | 3170 | 108 |
121492 | 121492 | 2020-05-07 | San Bernardino | California | 6071 | 2562 | 108 |
98376 | 98376 | 2020-04-29 | Santa Clara | California | 6085 | 2134 | 108 |
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);