ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2022-04-02 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 58
- 6001 1
- 6003 1
- 6005 1
- 6007 1
- 6009 1
- 6011 1
- 6013 1
- 6015 1
- 6017 1
- 6019 1
- 6021 1
- 6023 1
- 6025 1
- 6027 1
- 6029 1
- 6031 1
- 6033 1
- 6035 1
- 6037 1
- 6039 1
- 6041 1
- 6043 1
- 6045 1
- 6047 1
- 6049 1
- 6051 1
- 6053 1
- 6055 1
- 6057 1
- 6059 1
- 6061 1
- 6063 1
- 6065 1
- 6067 1
- 6069 1
- 6071 1
- 6073 1
- 6075 1
- 6077 1
- 6079 1
- 6081 1
- 6083 1
- 6085 1
- 6087 1
- 6089 1
- 6091 1
- 6093 1
- 6095 1
- 6097 1
- 6099 1
- 6101 1
- 6103 1
- 6105 1
- 6107 1
- 6109 1
- 6111 1
- 6113 1
- 6115 1
county 58
- Alameda 1
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
state 1
- California · 58 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2366269 | 2366269 | 2022-04-02 | Alameda | California | 6001 | 269551 | 1830 |
2366270 | 2366270 | 2022-04-02 | Alpine | California | 6003 | 125 | 0 |
2366271 | 2366271 | 2022-04-02 | Amador | California | 6005 | 9130 | 86 |
2366272 | 2366272 | 2022-04-02 | Butte | California | 6007 | 39643 | 396 |
2366273 | 2366273 | 2022-04-02 | Calaveras | California | 6009 | 7610 | 119 |
2366274 | 2366274 | 2022-04-02 | Colusa | California | 6011 | 4525 | 21 |
2366275 | 2366275 | 2022-04-02 | Contra Costa | California | 6013 | 201921 | 1291 |
2366276 | 2366276 | 2022-04-02 | Del Norte | California | 6015 | 6214 | 50 |
2366277 | 2366277 | 2022-04-02 | El Dorado | California | 6017 | 29944 | 200 |
2366278 | 2366278 | 2022-04-02 | Fresno | California | 6019 | 253293 | 2722 |
2366279 | 2366279 | 2022-04-02 | Glenn | California | 6021 | 6559 | 66 |
2366280 | 2366280 | 2022-04-02 | Humboldt | California | 6023 | 20002 | 140 |
2366281 | 2366281 | 2022-04-02 | Imperial | California | 6025 | 66394 | 907 |
2366282 | 2366282 | 2022-04-02 | Inyo | California | 6027 | 4547 | 56 |
2366283 | 2366283 | 2022-04-02 | Kern | California | 6029 | 242458 | 2294 |
2366284 | 2366284 | 2022-04-02 | Kings | California | 6031 | 55094 | 443 |
2366285 | 2366285 | 2022-04-02 | Lake | California | 6033 | 11572 | 136 |
2366286 | 2366286 | 2022-04-02 | Lassen | California | 6035 | 10713 | 69 |
2366287 | 2366287 | 2022-04-02 | Los Angeles | California | 6037 | 2835021 | 31683 |
2366288 | 2366288 | 2022-04-02 | Madera | California | 6039 | 43400 | 354 |
2366289 | 2366289 | 2022-04-02 | Marin | California | 6041 | 35743 | 287 |
2366290 | 2366290 | 2022-04-02 | Mariposa | California | 6043 | 3013 | 33 |
2366291 | 2366291 | 2022-04-02 | Mendocino | California | 6045 | 16052 | 119 |
2366292 | 2366292 | 2022-04-02 | Merced | California | 6047 | 71977 | 813 |
2366293 | 2366293 | 2022-04-02 | Modoc | California | 6049 | 993 | 8 |
2366294 | 2366294 | 2022-04-02 | Mono | California | 6051 | 3089 | 6 |
2366295 | 2366295 | 2022-04-02 | Monterey | California | 6053 | 92730 | 732 |
2366296 | 2366296 | 2022-04-02 | Napa | California | 6055 | 26726 | 143 |
2366297 | 2366297 | 2022-04-02 | Nevada | California | 6057 | 17176 | 123 |
2366298 | 2366298 | 2022-04-02 | Orange | California | 6059 | 587408 | 6886 |
2366299 | 2366299 | 2022-04-02 | Placer | California | 6061 | 70097 | 614 |
2366300 | 2366300 | 2022-04-02 | Plumas | California | 6063 | 3163 | 14 |
2366301 | 2366301 | 2022-04-02 | Riverside | California | 6065 | 618706 | 6474 |
2366302 | 2366302 | 2022-04-02 | Sacramento | California | 6067 | 303101 | 3080 |
2366303 | 2366303 | 2022-04-02 | San Benito | California | 6069 | 13421 | 98 |
2366304 | 2366304 | 2022-04-02 | San Bernardino | California | 6071 | 586037 | 6865 |
2366305 | 2366305 | 2022-04-02 | San Diego | California | 6073 | 803862 | 5178 |
2366306 | 2366306 | 2022-04-02 | San Francisco | California | 6075 | 133484 | 843 |
2366307 | 2366307 | 2022-04-02 | San Joaquin | California | 6077 | 175524 | 2202 |
2366308 | 2366308 | 2022-04-02 | San Luis Obispo | California | 6079 | 56292 | 475 |
2366309 | 2366309 | 2022-04-02 | San Mateo | California | 6081 | 127776 | 743 |
2366310 | 2366310 | 2022-04-02 | Santa Barbara | California | 6083 | 90453 | 678 |
2366311 | 2366311 | 2022-04-02 | Santa Clara | California | 6085 | 324974 | 2259 |
2366312 | 2366312 | 2022-04-02 | Santa Cruz | California | 6087 | 49458 | 259 |
2366313 | 2366313 | 2022-04-02 | Shasta | California | 6089 | 36737 | 610 |
2366314 | 2366314 | 2022-04-02 | Sierra | California | 6091 | 315 | 4 |
2366315 | 2366315 | 2022-04-02 | Siskiyou | California | 6093 | 7413 | 105 |
2366316 | 2366316 | 2022-04-02 | Solano | California | 6095 | 87401 | 446 |
2366317 | 2366317 | 2022-04-02 | Sonoma | California | 6097 | 85756 | 487 |
2366318 | 2366318 | 2022-04-02 | Stanislaus | California | 6099 | 136645 | 1694 |
2366319 | 2366319 | 2022-04-02 | Sutter | California | 6101 | 22672 | 231 |
2366320 | 2366320 | 2022-04-02 | Tehama | California | 6103 | 14652 | 198 |
2366321 | 2366321 | 2022-04-02 | Trinity | California | 6105 | 1466 | 20 |
2366322 | 2366322 | 2022-04-02 | Tulare | California | 6107 | 133169 | 1410 |
2366323 | 2366323 | 2022-04-02 | Tuolumne | California | 6109 | 13463 | 181 |
2366324 | 2366324 | 2022-04-02 | Ventura | California | 6111 | 182326 | 1462 |
2366325 | 2366325 | 2022-04-02 | Yolo | California | 6113 | 39542 | 313 |
2366326 | 2366326 | 2022-04-02 | Yuba | California | 6115 | 17674 | 120 |
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);