ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 154 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- California · 21 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2245978 | 2245978 | 2022-02-24 | Tehama | California | 6103 | 14444 | 154 |
1878543 | 1878543 | 2021-11-03 | El Dorado | California | 6017 | 17592 | 154 |
1875294 | 1875294 | 2021-11-02 | El Dorado | California | 6017 | 17567 | 154 |
1872045 | 1872045 | 2021-11-01 | El Dorado | California | 6017 | 17550 | 154 |
1868796 | 1868796 | 2021-10-31 | El Dorado | California | 6017 | 17461 | 154 |
1865547 | 1865547 | 2021-10-30 | El Dorado | California | 6017 | 17461 | 154 |
1862298 | 1862298 | 2021-10-29 | El Dorado | California | 6017 | 17461 | 154 |
1859049 | 1859049 | 2021-10-28 | El Dorado | California | 6017 | 17432 | 154 |
1755119 | 1755119 | 2021-09-26 | Sutter | California | 6101 | 13228 | 154 |
1751871 | 1751871 | 2021-09-25 | Sutter | California | 6101 | 13228 | 154 |
1748622 | 1748622 | 2021-09-24 | Sutter | California | 6101 | 13228 | 154 |
943360 | 943360 | 2021-01-19 | Marin | California | 6041 | 11691 | 154 |
820042 | 820042 | 2020-12-12 | Monterey | California | 6053 | 18421 | 154 |
654568 | 654568 | 2020-10-22 | Merced | California | 6047 | 9439 | 154 |
651323 | 651323 | 2020-10-21 | Merced | California | 6047 | 9415 | 154 |
609167 | 609167 | 2020-10-08 | San Mateo | California | 6081 | 10395 | 154 |
605924 | 605924 | 2020-10-07 | San Mateo | California | 6081 | 10347 | 154 |
602697 | 602697 | 2020-10-06 | Ventura | California | 6111 | 13224 | 154 |
599454 | 599454 | 2020-10-05 | Ventura | California | 6111 | 13197 | 154 |
338018 | 338018 | 2020-07-16 | Alameda | California | 6001 | 8648 | 154 |
334823 | 334823 | 2020-07-15 | Alameda | California | 6001 | 8499 | 154 |
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);