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 838
- Los Angeles 837
- Santa Clara 833
- San Francisco 830
- San Diego 822
- Humboldt 812
- Sacramento 811
- Solano 809
- Sonoma 807
- Marin 806
- Napa 806
- Alameda 802
- Placer 801
- San Mateo 801
- Contra Costa 800
- Yolo 798
- Santa Cruz 797
- Fresno 796
- Madera 796
- Riverside 796
- Shasta 795
- Ventura 794
- San Joaquin 793
- Stanislaus 793
- Tulare 792
- San Benito 790
- San Luis Obispo 789
- San Bernardino 788
- Santa Barbara 788
- Nevada 787
- …
state 1
- California · 45,593 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496546 | 2496546 | 2022-05-12 | Santa Clara | California | 6085 | 340266 | 2295 |
2496547 | 2496547 | 2022-05-12 | Santa Cruz | California | 6087 | 52260 | 263 |
2496548 | 2496548 | 2022-05-12 | Shasta | California | 6089 | 36945 | 648 |
2496549 | 2496549 | 2022-05-12 | Sierra | California | 6091 | 324 | 4 |
2496550 | 2496550 | 2022-05-12 | Siskiyou | California | 6093 | 7478 | 105 |
2496551 | 2496551 | 2022-05-12 | Solano | California | 6095 | 89142 | 450 |
2496552 | 2496552 | 2022-05-12 | Sonoma | California | 6097 | 89730 | 490 |
2496553 | 2496553 | 2022-05-12 | Stanislaus | California | 6099 | 136645 | 1694 |
2496554 | 2496554 | 2022-05-12 | Sutter | California | 6101 | 23045 | 234 |
2496555 | 2496555 | 2022-05-12 | Tehama | California | 6103 | 14739 | 201 |
2496556 | 2496556 | 2022-05-12 | Trinity | California | 6105 | 1485 | 20 |
2496557 | 2496557 | 2022-05-12 | Tulare | California | 6107 | 136005 | 1468 |
2496558 | 2496558 | 2022-05-12 | Tuolumne | California | 6109 | 13661 | 181 |
2496559 | 2496559 | 2022-05-12 | Ventura | California | 6111 | 185429 | 1498 |
2496560 | 2496560 | 2022-05-12 | Yolo | California | 6113 | 40934 | 316 |
2496561 | 2496561 | 2022-05-12 | Yuba | California | 6115 | 17944 | 122 |
2493246 | 2493246 | 2022-05-11 | Alameda | California | 6001 | 282539 | 1865 |
2493247 | 2493247 | 2022-05-11 | Alpine | California | 6003 | 126 | 0 |
2493248 | 2493248 | 2022-05-11 | Amador | California | 6005 | 9229 | 86 |
2493249 | 2493249 | 2022-05-11 | Butte | California | 6007 | 40080 | 423 |
2493250 | 2493250 | 2022-05-11 | Calaveras | California | 6009 | 7733 | 120 |
2493251 | 2493251 | 2022-05-11 | Colusa | California | 6011 | 4542 | 21 |
2493252 | 2493252 | 2022-05-11 | Contra Costa | California | 6013 | 208949 | 1302 |
2493253 | 2493253 | 2022-05-11 | Del Norte | California | 6015 | 6364 | 50 |
2493254 | 2493254 | 2022-05-11 | El Dorado | California | 6017 | 30428 | 212 |
2493255 | 2493255 | 2022-05-11 | Fresno | California | 6019 | 257043 | 2754 |
2493256 | 2493256 | 2022-05-11 | Glenn | California | 6021 | 6628 | 67 |
2493257 | 2493257 | 2022-05-11 | Humboldt | California | 6023 | 20952 | 146 |
2493258 | 2493258 | 2022-05-11 | Imperial | California | 6025 | 66692 | 916 |
2493259 | 2493259 | 2022-05-11 | Inyo | California | 6027 | 4607 | 56 |
2493260 | 2493260 | 2022-05-11 | Kern | California | 6029 | 244205 | 2396 |
2493261 | 2493261 | 2022-05-11 | Kings | California | 6031 | 55391 | 447 |
2493262 | 2493262 | 2022-05-11 | Lake | California | 6033 | 11693 | 137 |
2493263 | 2493263 | 2022-05-11 | Lassen | California | 6035 | 10747 | 69 |
2493264 | 2493264 | 2022-05-11 | Los Angeles | California | 6037 | 2901153 | 32007 |
2493265 | 2493265 | 2022-05-11 | Madera | California | 6039 | 43585 | 365 |
2493266 | 2493266 | 2022-05-11 | Marin | California | 6041 | 38274 | 292 |
2493267 | 2493267 | 2022-05-11 | Mariposa | California | 6043 | 3136 | 35 |
2493268 | 2493268 | 2022-05-11 | Mendocino | California | 6045 | 16466 | 124 |
2493269 | 2493269 | 2022-05-11 | Merced | California | 6047 | 72842 | 823 |
2493270 | 2493270 | 2022-05-11 | Modoc | California | 6049 | 1000 | 8 |
2493271 | 2493271 | 2022-05-11 | Mono | California | 6051 | 3127 | 6 |
2493272 | 2493272 | 2022-05-11 | Monterey | California | 6053 | 94867 | 742 |
2493273 | 2493273 | 2022-05-11 | Napa | California | 6055 | 27708 | 143 |
2493274 | 2493274 | 2022-05-11 | Nevada | California | 6057 | 17475 | 127 |
2493275 | 2493275 | 2022-05-11 | Orange | California | 6059 | 598954 | 7019 |
2493276 | 2493276 | 2022-05-11 | Placer | California | 6061 | 71325 | 628 |
2493277 | 2493277 | 2022-05-11 | Plumas | California | 6063 | 3362 | 13 |
2493278 | 2493278 | 2022-05-11 | Riverside | California | 6065 | 625875 | 6525 |
2493279 | 2493279 | 2022-05-11 | Sacramento | California | 6067 | 313543 | 3159 |
2493280 | 2493280 | 2022-05-11 | San Benito | California | 6069 | 13615 | 98 |
2493281 | 2493281 | 2022-05-11 | San Bernardino | California | 6071 | 596557 | 7354 |
2493282 | 2493282 | 2022-05-11 | San Diego | California | 6073 | 821757 | 5257 |
2493283 | 2493283 | 2022-05-11 | San Francisco | California | 6075 | 142863 | 864 |
2493284 | 2493284 | 2022-05-11 | San Joaquin | California | 6077 | 177919 | 2233 |
2493285 | 2493285 | 2022-05-11 | San Luis Obispo | California | 6079 | 57393 | 478 |
2493286 | 2493286 | 2022-05-11 | San Mateo | California | 6081 | 136379 | 755 |
2493287 | 2493287 | 2022-05-11 | Santa Barbara | California | 6083 | 92466 | 693 |
2493288 | 2493288 | 2022-05-11 | Santa Clara | California | 6085 | 340266 | 2295 |
2493289 | 2493289 | 2022-05-11 | Santa Cruz | California | 6087 | 52260 | 263 |
2493290 | 2493290 | 2022-05-11 | Shasta | California | 6089 | 36945 | 648 |
2493291 | 2493291 | 2022-05-11 | Sierra | California | 6091 | 324 | 4 |
2493292 | 2493292 | 2022-05-11 | Siskiyou | California | 6093 | 7478 | 105 |
2493293 | 2493293 | 2022-05-11 | Solano | California | 6095 | 89142 | 450 |
2493294 | 2493294 | 2022-05-11 | Sonoma | California | 6097 | 89730 | 490 |
2493295 | 2493295 | 2022-05-11 | Stanislaus | California | 6099 | 136645 | 1694 |
2493296 | 2493296 | 2022-05-11 | Sutter | California | 6101 | 23045 | 234 |
2493297 | 2493297 | 2022-05-11 | Tehama | California | 6103 | 14739 | 201 |
2493298 | 2493298 | 2022-05-11 | Trinity | California | 6105 | 1485 | 20 |
2493299 | 2493299 | 2022-05-11 | Tulare | California | 6107 | 136005 | 1468 |
2493300 | 2493300 | 2022-05-11 | Tuolumne | California | 6109 | 13661 | 181 |
2493301 | 2493301 | 2022-05-11 | Ventura | California | 6111 | 185429 | 1498 |
2493302 | 2493302 | 2022-05-11 | Yolo | California | 6113 | 40934 | 316 |
2493303 | 2493303 | 2022-05-11 | Yuba | California | 6115 | 17845 | 122 |
2489988 | 2489988 | 2022-05-10 | Alameda | California | 6001 | 282539 | 1896 |
2489989 | 2489989 | 2022-05-10 | Alpine | California | 6003 | 126 | 0 |
2489990 | 2489990 | 2022-05-10 | Amador | California | 6005 | 9229 | 86 |
2489991 | 2489991 | 2022-05-10 | Butte | California | 6007 | 40080 | 423 |
2489992 | 2489992 | 2022-05-10 | Calaveras | California | 6009 | 7733 | 120 |
2489993 | 2489993 | 2022-05-10 | Colusa | California | 6011 | 4542 | 21 |
2489994 | 2489994 | 2022-05-10 | Contra Costa | California | 6013 | 208949 | 1302 |
2489995 | 2489995 | 2022-05-10 | Del Norte | California | 6015 | 6364 | 50 |
2489996 | 2489996 | 2022-05-10 | El Dorado | California | 6017 | 30428 | 212 |
2489997 | 2489997 | 2022-05-10 | Fresno | California | 6019 | 257043 | 2754 |
2489998 | 2489998 | 2022-05-10 | Glenn | California | 6021 | 6628 | 67 |
2489999 | 2489999 | 2022-05-10 | Humboldt | California | 6023 | 20658 | 146 |
2490000 | 2490000 | 2022-05-10 | Imperial | California | 6025 | 66692 | 916 |
2490001 | 2490001 | 2022-05-10 | Inyo | California | 6027 | 4607 | 56 |
2490002 | 2490002 | 2022-05-10 | Kern | California | 6029 | 244205 | 2396 |
2490003 | 2490003 | 2022-05-10 | Kings | California | 6031 | 55391 | 447 |
2490004 | 2490004 | 2022-05-10 | Lake | California | 6033 | 11693 | 137 |
2490005 | 2490005 | 2022-05-10 | Lassen | California | 6035 | 10744 | 69 |
2490006 | 2490006 | 2022-05-10 | Los Angeles | California | 6037 | 2898217 | 32000 |
2490007 | 2490007 | 2022-05-10 | Madera | California | 6039 | 43585 | 365 |
2490008 | 2490008 | 2022-05-10 | Marin | California | 6041 | 38274 | 292 |
2490009 | 2490009 | 2022-05-10 | Mariposa | California | 6043 | 3126 | 34 |
2490010 | 2490010 | 2022-05-10 | Mendocino | California | 6045 | 16466 | 124 |
2490011 | 2490011 | 2022-05-10 | Merced | California | 6047 | 72810 | 823 |
2490012 | 2490012 | 2022-05-10 | Modoc | California | 6049 | 1000 | 8 |
2490013 | 2490013 | 2022-05-10 | Mono | California | 6051 | 3127 | 6 |
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);