ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 162 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 12
- Sonoma 5
- San Mateo 4
- Alameda 3
- Imperial 2
- San Diego 1
- San Francisco 1
- Santa Clara 1
- Santa Cruz 1
- Stanislaus 1
- Tehama 1
- Tuolumne 1
- Ventura 1
state 1
- California · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333788 | 2333788 | 2022-03-23 | Tehama | California | 6103 | 14621 | 162 |
2171183 | 2171183 | 2022-02-01 | Tuolumne | California | 6109 | 11936 | 162 |
1014788 | 1014788 | 2021-02-10 | Santa Cruz | California | 6087 | 14092 | 162 |
823310 | 823310 | 2020-12-13 | Sonoma | California | 6097 | 14705 | 162 |
820064 | 820064 | 2020-12-12 | Sonoma | California | 6097 | 14475 | 162 |
816818 | 816818 | 2020-12-11 | Sonoma | California | 6097 | 14282 | 162 |
813572 | 813572 | 2020-12-10 | Sonoma | California | 6097 | 14168 | 162 |
810328 | 810328 | 2020-12-09 | Sonoma | California | 6097 | 13912 | 162 |
794092 | 794092 | 2020-12-04 | San Francisco | California | 6075 | 16239 | 162 |
712969 | 712969 | 2020-11-09 | San Mateo | California | 6081 | 11937 | 162 |
709725 | 709725 | 2020-11-08 | San Mateo | California | 6081 | 11810 | 162 |
706481 | 706481 | 2020-11-07 | San Mateo | California | 6081 | 11810 | 162 |
703238 | 703238 | 2020-11-06 | San Mateo | California | 6081 | 11710 | 162 |
654600 | 654600 | 2020-10-22 | Ventura | California | 6111 | 14050 | 162 |
411913 | 411913 | 2020-08-08 | Stanislaus | California | 6099 | 9665 | 162 |
354028 | 354028 | 2020-07-21 | Imperial | California | 6025 | 8606 | 162 |
350814 | 350814 | 2020-07-20 | Alameda | California | 6001 | 9277 | 162 |
350826 | 350826 | 2020-07-20 | Imperial | California | 6025 | 8606 | 162 |
347613 | 347613 | 2020-07-19 | Alameda | California | 6001 | 9258 | 162 |
344413 | 344413 | 2020-07-18 | Alameda | California | 6001 | 9131 | 162 |
303089 | 303089 | 2020-07-05 | Santa Clara | California | 6085 | 5273 | 162 |
115567 | 115567 | 2020-05-05 | San Diego | California | 6073 | 4223 | 162 |
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);