ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,693 rows where state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Orange 720
- Los Angeles 719
- Santa Clara 714
- San Francisco 712
- San Diego 704
- Humboldt 694
- Sacramento 693
- Solano 690
- Marin 688
- Napa 688
- Sonoma 688
- Alameda 684
- Placer 683
- San Mateo 683
- Contra Costa 682
- Yolo 679
- Fresno 678
- Madera 678
- Riverside 678
- Santa Cruz 678
- Shasta 676
- San Joaquin 675
- Ventura 675
- Stanislaus 674
- Tulare 673
- San Benito 672
- San Luis Obispo 671
- San Bernardino 670
- Santa Barbara 670
- Nevada 669
- …
state 1
- California · 38,732 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109316 | 2109316 | 2022-01-13 | Alameda | California | 6001 | 180353 | 1586 |
2109317 | 2109317 | 2022-01-13 | Alpine | California | 6003 | 117 | 0 |
2109318 | 2109318 | 2022-01-13 | Amador | California | 6005 | 6482 | 71 |
2109319 | 2109319 | 2022-01-13 | Butte | California | 6007 | 29391 | 348 |
2109320 | 2109320 | 2022-01-13 | Calaveras | California | 6009 | 5281 | 93 |
2109321 | 2109321 | 2022-01-13 | Colusa | California | 6011 | 3599 | 21 |
2109322 | 2109322 | 2022-01-13 | Contra Costa | California | 6013 | 139908 | 1077 |
2109323 | 2109323 | 2022-01-13 | Del Norte | California | 6015 | 4251 | 43 |
2109324 | 2109324 | 2022-01-13 | El Dorado | California | 6017 | 22358 | 175 |
2109325 | 2109325 | 2022-01-13 | Fresno | California | 6019 | 179628 | 2413 |
2109326 | 2109326 | 2022-01-13 | Glenn | California | 6021 | 5033 | 55 |
2109327 | 2109327 | 2022-01-13 | Humboldt | California | 6023 | 13463 | 128 |
2109328 | 2109328 | 2022-01-13 | Imperial | California | 6025 | 47613 | 813 |
2109329 | 2109329 | 2022-01-13 | Inyo | California | 6027 | 3407 | 49 |
2109330 | 2109330 | 2022-01-13 | Kern | California | 6029 | 179110 | 1958 |
2109331 | 2109331 | 2022-01-13 | Kings | California | 6031 | 39230 | 391 |
2109332 | 2109332 | 2022-01-13 | Lake | California | 6033 | 7861 | 117 |
2109333 | 2109333 | 2022-01-13 | Lassen | California | 6035 | 8535 | 61 |
2109334 | 2109334 | 2022-01-13 | Los Angeles | California | 6037 | 2132227 | 27985 |
2109335 | 2109335 | 2022-01-13 | Madera | California | 6039 | 29794 | 329 |
2109336 | 2109336 | 2022-01-13 | Marin | California | 6041 | 26028 | 251 |
2109337 | 2109337 | 2022-01-13 | Mariposa | California | 6043 | 2081 | 18 |
2109338 | 2109338 | 2022-01-13 | Mendocino | California | 6045 | 10417 | 109 |
2109339 | 2109339 | 2022-01-13 | Merced | California | 6047 | 52218 | 720 |
2109340 | 2109340 | 2022-01-13 | Modoc | California | 6049 | 1199 | 11 |
2109341 | 2109341 | 2022-01-13 | Mono | California | 6051 | 2552 | 4 |
2109342 | 2109342 | 2022-01-13 | Monterey | California | 6053 | 62561 | 653 |
2109343 | 2109343 | 2022-01-13 | Napa | California | 6055 | 17646 | 109 |
2109344 | 2109344 | 2022-01-13 | Nevada | California | 6057 | 12089 | 111 |
2109345 | 2109345 | 2022-01-13 | Orange | California | 6059 | 451612 | 5916 |
2109346 | 2109346 | 2022-01-13 | Placer | California | 6061 | 51997 | 501 |
2109347 | 2109347 | 2022-01-13 | Plumas | California | 6063 | 2232 | 12 |
2109348 | 2109348 | 2022-01-13 | Riverside | California | 6065 | 478326 | 5661 |
2109349 | 2109349 | 2022-01-13 | Sacramento | California | 6067 | 216000 | 2582 |
2109350 | 2109350 | 2022-01-13 | San Benito | California | 6069 | 10046 | 87 |
2109351 | 2109351 | 2022-01-13 | San Bernardino | California | 6071 | 463256 | 6222 |
2109352 | 2109352 | 2022-01-13 | San Diego | California | 6073 | 587767 | 4529 |
2109353 | 2109353 | 2022-01-13 | San Francisco | California | 6075 | 92571 | 691 |
2109354 | 2109354 | 2022-01-13 | San Joaquin | California | 6077 | 129868 | 1948 |
2109355 | 2109355 | 2022-01-13 | San Luis Obispo | California | 6079 | 39929 | 373 |
2109356 | 2109356 | 2022-01-13 | San Mateo | California | 6081 | 85171 | 638 |
2109357 | 2109357 | 2022-01-13 | Santa Barbara | California | 6083 | 63270 | 578 |
2109358 | 2109358 | 2022-01-13 | Santa Clara | California | 6085 | 218660 | 1972 |
2109359 | 2109359 | 2022-01-13 | Santa Cruz | California | 6087 | 29900 | 235 |
2109360 | 2109360 | 2022-01-13 | Shasta | California | 6089 | 28544 | 502 |
2109361 | 2109361 | 2022-01-13 | Sierra | California | 6091 | 253 | 0 |
2109362 | 2109362 | 2022-01-13 | Siskiyou | California | 6093 | 5337 | 81 |
2109363 | 2109363 | 2022-01-13 | Solano | California | 6095 | 59459 | 386 |
2109364 | 2109364 | 2022-01-13 | Sonoma | California | 6097 | 57381 | 422 |
2109365 | 2109365 | 2022-01-13 | Stanislaus | California | 6099 | 105299 | 1503 |
2109366 | 2109366 | 2022-01-13 | Sutter | California | 6101 | 16944 | 204 |
2109367 | 2109367 | 2022-01-13 | Tehama | California | 6103 | 11315 | 141 |
2109368 | 2109368 | 2022-01-13 | Trinity | California | 6105 | 1092 | 19 |
2109369 | 2109369 | 2022-01-13 | Tulare | California | 6107 | 96787 | 1192 |
2109370 | 2109370 | 2022-01-13 | Tuolumne | California | 6109 | 9266 | 152 |
2109371 | 2109371 | 2022-01-13 | Ventura | California | 6111 | 138203 | 1222 |
2109372 | 2109372 | 2022-01-13 | Yolo | California | 6113 | 28837 | 270 |
2109373 | 2109373 | 2022-01-13 | Yuba | California | 6115 | 12811 | 101 |
2106065 | 2106065 | 2022-01-12 | Alameda | California | 6001 | 173979 | 1586 |
2106066 | 2106066 | 2022-01-12 | Alpine | California | 6003 | 116 | 0 |
2106067 | 2106067 | 2022-01-12 | Amador | California | 6005 | 6408 | 71 |
2106068 | 2106068 | 2022-01-12 | Butte | California | 6007 | 28835 | 347 |
2106069 | 2106069 | 2022-01-12 | Calaveras | California | 6009 | 5175 | 93 |
2106070 | 2106070 | 2022-01-12 | Colusa | California | 6011 | 3509 | 21 |
2106071 | 2106071 | 2022-01-12 | Contra Costa | California | 6013 | 135644 | 1077 |
2106072 | 2106072 | 2022-01-12 | Del Norte | California | 6015 | 4211 | 43 |
2106073 | 2106073 | 2022-01-12 | El Dorado | California | 6017 | 21890 | 174 |
2106074 | 2106074 | 2022-01-12 | Fresno | California | 6019 | 176980 | 2404 |
2106075 | 2106075 | 2022-01-12 | Glenn | California | 6021 | 4966 | 55 |
2106076 | 2106076 | 2022-01-12 | Humboldt | California | 6023 | 12923 | 126 |
2106077 | 2106077 | 2022-01-12 | Imperial | California | 6025 | 46115 | 812 |
2106078 | 2106078 | 2022-01-12 | Inyo | California | 6027 | 3332 | 49 |
2106079 | 2106079 | 2022-01-12 | Kern | California | 6029 | 177220 | 1944 |
2106080 | 2106080 | 2022-01-12 | Kings | California | 6031 | 38807 | 391 |
2106081 | 2106081 | 2022-01-12 | Lake | California | 6033 | 7691 | 117 |
2106082 | 2106082 | 2022-01-12 | Lassen | California | 6035 | 8281 | 61 |
2106083 | 2106083 | 2022-01-12 | Los Angeles | California | 6037 | 2087285 | 27850 |
2106084 | 2106084 | 2022-01-12 | Madera | California | 6039 | 29136 | 329 |
2106085 | 2106085 | 2022-01-12 | Marin | California | 6041 | 25388 | 251 |
2106086 | 2106086 | 2022-01-12 | Mariposa | California | 6043 | 2039 | 18 |
2106087 | 2106087 | 2022-01-12 | Mendocino | California | 6045 | 10061 | 109 |
2106088 | 2106088 | 2022-01-12 | Merced | California | 6047 | 51637 | 715 |
2106089 | 2106089 | 2022-01-12 | Modoc | California | 6049 | 1191 | 11 |
2106090 | 2106090 | 2022-01-12 | Mono | California | 6051 | 2458 | 4 |
2106091 | 2106091 | 2022-01-12 | Monterey | California | 6053 | 59797 | 653 |
2106092 | 2106092 | 2022-01-12 | Napa | California | 6055 | 17235 | 109 |
2106093 | 2106093 | 2022-01-12 | Nevada | California | 6057 | 11876 | 110 |
2106094 | 2106094 | 2022-01-12 | Orange | California | 6059 | 439765 | 5914 |
2106095 | 2106095 | 2022-01-12 | Placer | California | 6061 | 50911 | 500 |
2106096 | 2106096 | 2022-01-12 | Plumas | California | 6063 | 2168 | 12 |
2106097 | 2106097 | 2022-01-12 | Riverside | California | 6065 | 472262 | 5648 |
2106098 | 2106098 | 2022-01-12 | Sacramento | California | 6067 | 208287 | 2576 |
2106099 | 2106099 | 2022-01-12 | San Benito | California | 6069 | 9873 | 83 |
2106100 | 2106100 | 2022-01-12 | San Bernardino | California | 6071 | 456355 | 6198 |
2106101 | 2106101 | 2022-01-12 | San Diego | California | 6073 | 563128 | 4520 |
2106102 | 2106102 | 2022-01-12 | San Francisco | California | 6075 | 88170 | 691 |
2106103 | 2106103 | 2022-01-12 | San Joaquin | California | 6077 | 127599 | 1944 |
2106104 | 2106104 | 2022-01-12 | San Luis Obispo | California | 6079 | 38881 | 372 |
2106105 | 2106105 | 2022-01-12 | San Mateo | California | 6081 | 81301 | 638 |
2106106 | 2106106 | 2022-01-12 | Santa Barbara | California | 6083 | 61715 | 578 |
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);