ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 146 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
fips 15
county 15
- Humboldt 11
- Tehama 7
- Sonoma 5
- Tuolumne 3
- Ventura 3
- El Dorado 2
- Alameda 1
- Contra Costa 1
- Marin 1
- Monterey 1
- Orange 1
- San Joaquin 1
- Santa Clara 1
- Santa Cruz 1
- Yolo 1
state 1
- California · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499773 | 2499773 | 2022-05-13 | Humboldt | California | 6023 | 20952 | 146 |
2496515 | 2496515 | 2022-05-12 | Humboldt | California | 6023 | 20952 | 146 |
2493257 | 2493257 | 2022-05-11 | Humboldt | California | 6023 | 20952 | 146 |
2489999 | 2489999 | 2022-05-10 | Humboldt | California | 6023 | 20658 | 146 |
2486742 | 2486742 | 2022-05-09 | Humboldt | California | 6023 | 20625 | 146 |
2483484 | 2483484 | 2022-05-08 | Humboldt | California | 6023 | 20625 | 146 |
2480226 | 2480226 | 2022-05-07 | Humboldt | California | 6023 | 20625 | 146 |
2476968 | 2476968 | 2022-05-06 | Humboldt | California | 6023 | 20625 | 146 |
2473710 | 2473710 | 2022-05-05 | Humboldt | California | 6023 | 20625 | 146 |
2470453 | 2470453 | 2022-05-04 | Humboldt | California | 6023 | 20625 | 146 |
2467197 | 2467197 | 2022-05-03 | Humboldt | California | 6023 | 20380 | 146 |
2193948 | 2193948 | 2022-02-08 | Tehama | California | 6103 | 13899 | 146 |
2190695 | 2190695 | 2022-02-07 | Tehama | California | 6103 | 13847 | 146 |
2187442 | 2187442 | 2022-02-06 | Tehama | California | 6103 | 13740 | 146 |
2184189 | 2184189 | 2022-02-05 | Tehama | California | 6103 | 13740 | 146 |
2180937 | 2180937 | 2022-02-04 | Tehama | California | 6103 | 13740 | 146 |
2177686 | 2177686 | 2022-02-03 | Tehama | California | 6103 | 13674 | 146 |
2174433 | 2174433 | 2022-02-02 | Tehama | California | 6103 | 13512 | 146 |
2002096 | 2002096 | 2021-12-11 | Tuolumne | California | 6109 | 7979 | 146 |
1998846 | 1998846 | 2021-12-10 | Tuolumne | California | 6109 | 7979 | 146 |
1995595 | 1995595 | 2021-12-09 | Tuolumne | California | 6109 | 7979 | 146 |
1807063 | 1807063 | 2021-10-12 | El Dorado | California | 6017 | 16888 | 146 |
1803812 | 1803812 | 2021-10-11 | El Dorado | California | 6017 | 16865 | 146 |
972591 | 972591 | 2021-01-28 | Santa Cruz | California | 6087 | 13235 | 146 |
966115 | 966115 | 2021-01-26 | Yolo | California | 6113 | 11276 | 146 |
923889 | 923889 | 2021-01-13 | Marin | California | 6041 | 11126 | 146 |
810306 | 810306 | 2020-12-09 | Monterey | California | 6053 | 17752 | 146 |
712977 | 712977 | 2020-11-09 | Sonoma | California | 6097 | 10424 | 146 |
709733 | 709733 | 2020-11-08 | Sonoma | California | 6097 | 10248 | 146 |
706489 | 706489 | 2020-11-07 | Sonoma | California | 6097 | 10248 | 146 |
703246 | 703246 | 2020-11-06 | Sonoma | California | 6097 | 10170 | 146 |
700003 | 700003 | 2020-11-05 | Sonoma | California | 6097 | 10116 | 146 |
560562 | 560562 | 2020-09-23 | Ventura | California | 6111 | 12507 | 146 |
557326 | 557326 | 2020-09-22 | Ventura | California | 6111 | 12477 | 146 |
554089 | 554089 | 2020-09-21 | Ventura | California | 6111 | 12406 | 146 |
421532 | 421532 | 2020-08-11 | Contra Costa | California | 6013 | 9787 | 146 |
379728 | 379728 | 2020-07-29 | San Joaquin | California | 6077 | 11209 | 146 |
315725 | 315725 | 2020-07-09 | Alameda | California | 6001 | 7428 | 146 |
218642 | 218642 | 2020-06-08 | Santa Clara | California | 6085 | 2973 | 146 |
190919 | 190919 | 2020-05-30 | Orange | California | 6059 | 6176 | 146 |
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);