ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 135 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
county 12
- Lake 10
- Humboldt 9
- Santa Barbara 6
- San Mateo 4
- Sutter 2
- Alameda 1
- Imperial 1
- San Luis Obispo 1
- Santa Cruz 1
- Stanislaus 1
- Tuolumne 1
- Ventura 1
state 1
- California · 38 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450923 | 2450923 | 2022-04-28 | Lake | California | 6033 | 11638 | 135 |
2447667 | 2447667 | 2022-04-27 | Lake | California | 6033 | 11638 | 135 |
2444411 | 2444411 | 2022-04-26 | Lake | California | 6033 | 11638 | 135 |
2337007 | 2337007 | 2022-03-24 | Lake | California | 6033 | 11553 | 135 |
2333753 | 2333753 | 2022-03-23 | Lake | California | 6033 | 11554 | 135 |
2330499 | 2330499 | 2022-03-22 | Lake | California | 6033 | 11552 | 135 |
2327247 | 2327247 | 2022-03-21 | Lake | California | 6033 | 11549 | 135 |
2323994 | 2323994 | 2022-03-20 | Lake | California | 6033 | 11538 | 135 |
2320740 | 2320740 | 2022-03-19 | Lake | California | 6033 | 11538 | 135 |
2317486 | 2317486 | 2022-03-18 | Lake | California | 6033 | 11538 | 135 |
2223181 | 2223181 | 2022-02-17 | Humboldt | California | 6023 | 19151 | 135 |
2219930 | 2219930 | 2022-02-16 | Humboldt | California | 6023 | 19066 | 135 |
2216679 | 2216679 | 2022-02-15 | Humboldt | California | 6023 | 19033 | 135 |
2213428 | 2213428 | 2022-02-14 | Humboldt | California | 6023 | 18979 | 135 |
2210176 | 2210176 | 2022-02-13 | Humboldt | California | 6023 | 18827 | 135 |
2206923 | 2206923 | 2022-02-12 | Humboldt | California | 6023 | 18827 | 135 |
2203670 | 2203670 | 2022-02-11 | Humboldt | California | 6023 | 18827 | 135 |
2200417 | 2200417 | 2022-02-10 | Humboldt | California | 6023 | 18698 | 135 |
2197163 | 2197163 | 2022-02-09 | Humboldt | California | 6023 | 18542 | 135 |
1914335 | 1914335 | 2021-11-14 | Tuolumne | California | 6109 | 7608 | 135 |
1660909 | 1660909 | 2021-08-28 | Sutter | California | 6101 | 11764 | 135 |
1657661 | 1657661 | 2021-08-27 | Sutter | California | 6101 | 11764 | 135 |
962857 | 962857 | 2021-01-25 | Santa Cruz | California | 6087 | 13009 | 135 |
940134 | 940134 | 2021-01-18 | San Luis Obispo | California | 6079 | 15658 | 135 |
777871 | 777871 | 2020-11-29 | Santa Barbara | California | 6083 | 11481 | 135 |
774626 | 774626 | 2020-11-28 | Santa Barbara | California | 6083 | 11340 | 135 |
771381 | 771381 | 2020-11-27 | Santa Barbara | California | 6083 | 11277 | 135 |
768136 | 768136 | 2020-11-26 | Santa Barbara | California | 6083 | 11205 | 135 |
764890 | 764890 | 2020-11-25 | Santa Barbara | California | 6083 | 11205 | 135 |
761645 | 761645 | 2020-11-24 | Santa Barbara | California | 6083 | 11166 | 135 |
531429 | 531429 | 2020-09-14 | Ventura | California | 6111 | 11855 | 135 |
508767 | 508767 | 2020-09-07 | San Mateo | California | 6081 | 8617 | 135 |
505535 | 505535 | 2020-09-06 | San Mateo | California | 6081 | 8617 | 135 |
502301 | 502301 | 2020-09-05 | San Mateo | California | 6081 | 8617 | 135 |
499067 | 499067 | 2020-09-04 | San Mateo | California | 6081 | 8452 | 135 |
399040 | 399040 | 2020-08-04 | Stanislaus | California | 6099 | 9308 | 135 |
328456 | 328456 | 2020-07-13 | Imperial | California | 6025 | 7977 | 135 |
287261 | 287261 | 2020-06-30 | Alameda | California | 6001 | 5985 | 135 |
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);