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 628
- Los Angeles 627
- Santa Clara 622
- San Francisco 620
- San Diego 612
- Humboldt 602
- Sacramento 601
- Solano 598
- Marin 596
- Napa 596
- Sonoma 596
- Alameda 592
- Placer 591
- San Mateo 591
- Contra Costa 590
- Yolo 587
- Fresno 586
- Madera 586
- Riverside 586
- Santa Cruz 586
- Shasta 584
- San Joaquin 583
- Ventura 583
- Stanislaus 582
- Tulare 581
- San Benito 580
- San Luis Obispo 579
- San Bernardino 578
- Santa Barbara 578
- Nevada 577
- …
state 1
- California · 33,396 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810304 | 1810304 | 2021-10-13 | Alameda | California | 6001 | 119671 | 1357 |
1810305 | 1810305 | 2021-10-13 | Alpine | California | 6003 | 102 | 0 |
1810306 | 1810306 | 2021-10-13 | Amador | California | 6005 | 5359 | 63 |
1810307 | 1810307 | 2021-10-13 | Butte | California | 6007 | 23129 | 256 |
1810308 | 1810308 | 2021-10-13 | Calaveras | California | 6009 | 3795 | 75 |
1810309 | 1810309 | 2021-10-13 | Colusa | California | 6011 | 3002 | 18 |
1810310 | 1810310 | 2021-10-13 | Contra Costa | California | 6013 | 98986 | 960 |
1810311 | 1810311 | 2021-10-13 | Del Norte | California | 6015 | 3651 | 40 |
1810312 | 1810312 | 2021-10-13 | El Dorado | California | 6017 | 16902 | 148 |
1810313 | 1810313 | 2021-10-13 | Fresno | California | 6019 | 143365 | 2042 |
1810314 | 1810314 | 2021-10-13 | Glenn | California | 6021 | 4272 | 40 |
1810315 | 1810315 | 2021-10-13 | Humboldt | California | 6023 | 9042 | 108 |
1810316 | 1810316 | 2021-10-13 | Imperial | California | 6025 | 35503 | 761 |
1810317 | 1810317 | 2021-10-13 | Inyo | California | 6027 | 1918 | 39 |
1810318 | 1810318 | 2021-10-13 | Kern | California | 6029 | 143272 | 1597 |
1810319 | 1810319 | 2021-10-13 | Kings | California | 6031 | 32093 | 312 |
1810320 | 1810320 | 2021-10-13 | Lake | California | 6033 | 6500 | 97 |
1810321 | 1810321 | 2021-10-13 | Lassen | California | 6035 | 7418 | 43 |
1810322 | 1810322 | 2021-10-13 | Los Angeles | California | 6037 | 1474114 | 26362 |
1810323 | 1810323 | 2021-10-13 | Madera | California | 6039 | 23319 | 277 |
1810324 | 1810324 | 2021-10-13 | Marin | California | 6041 | 17551 | 242 |
1810325 | 1810325 | 2021-10-13 | Mariposa | California | 6043 | 1231 | 15 |
1810326 | 1810326 | 2021-10-13 | Mendocino | California | 6045 | 7480 | 86 |
1810327 | 1810327 | 2021-10-13 | Merced | California | 6047 | 41912 | 581 |
1810328 | 1810328 | 2021-10-13 | Modoc | California | 6049 | 794 | 8 |
1810329 | 1810329 | 2021-10-13 | Mono | California | 6051 | 1624 | 5 |
1810330 | 1810330 | 2021-10-13 | Monterey | California | 6053 | 50592 | 586 |
1810331 | 1810331 | 2021-10-13 | Napa | California | 6055 | 12769 | 97 |
1810332 | 1810332 | 2021-10-13 | Nevada | California | 6057 | 9008 | 90 |
1810333 | 1810333 | 2021-10-13 | Orange | California | 6059 | 322299 | 5508 |
1810334 | 1810334 | 2021-10-13 | Placer | California | 6061 | 38714 | 405 |
1810335 | 1810335 | 2021-10-13 | Plumas | California | 6063 | 1518 | 6 |
1810336 | 1810336 | 2021-10-13 | Riverside | California | 6065 | 368590 | 5068 |
1810337 | 1810337 | 2021-10-13 | Sacramento | California | 6067 | 157142 | 2256 |
1810338 | 1810338 | 2021-10-13 | San Benito | California | 6069 | 7350 | 71 |
1810339 | 1810339 | 2021-10-13 | San Bernardino | California | 6071 | 355666 | 5563 |
1810340 | 1810340 | 2021-10-13 | San Diego | California | 6073 | 379091 | 4137 |
1810341 | 1810341 | 2021-10-13 | San Francisco | California | 6075 | 53860 | 643 |
1810342 | 1810342 | 2021-10-13 | San Joaquin | California | 6077 | 101461 | 1702 |
1810343 | 1810343 | 2021-10-13 | San Luis Obispo | California | 6079 | 29562 | 331 |
1810344 | 1810344 | 2021-10-13 | San Mateo | California | 6081 | 53724 | 618 |
1810345 | 1810345 | 2021-10-13 | Santa Barbara | California | 6083 | 44720 | 515 |
1810346 | 1810346 | 2021-10-13 | Santa Clara | California | 6085 | 144154 | 1883 |
1810347 | 1810347 | 2021-10-13 | Santa Cruz | California | 6087 | 20819 | 218 |
1810348 | 1810348 | 2021-10-13 | Shasta | California | 6089 | 23083 | 334 |
1810349 | 1810349 | 2021-10-13 | Sierra | California | 6091 | 169 | 0 |
1810350 | 1810350 | 2021-10-13 | Siskiyou | California | 6093 | 4557 | 56 |
1810351 | 1810351 | 2021-10-13 | Solano | California | 6095 | 45686 | 329 |
1810352 | 1810352 | 2021-10-13 | Sonoma | California | 6097 | 40613 | 398 |
1810353 | 1810353 | 2021-10-13 | Stanislaus | California | 6099 | 84709 | 1302 |
1810354 | 1810354 | 2021-10-13 | Sutter | California | 6101 | 13721 | 168 |
1810355 | 1810355 | 2021-10-13 | Tehama | California | 6103 | 9156 | 103 |
1810356 | 1810356 | 2021-10-13 | Trinity | California | 6105 | 854 | 11 |
1810357 | 1810357 | 2021-10-13 | Tulare | California | 6107 | 78346 | 944 |
1810358 | 1810358 | 2021-10-13 | Tuolumne | California | 6109 | 6842 | 107 |
1810359 | 1810359 | 2021-10-13 | Ventura | California | 6111 | 100337 | 1160 |
1810360 | 1810360 | 2021-10-13 | Yolo | California | 6113 | 20028 | 247 |
1810361 | 1810361 | 2021-10-13 | Yuba | California | 6115 | 10284 | 71 |
1807055 | 1807055 | 2021-10-12 | Alameda | California | 6001 | 119617 | 1358 |
1807056 | 1807056 | 2021-10-12 | Alpine | California | 6003 | 102 | 0 |
1807057 | 1807057 | 2021-10-12 | Amador | California | 6005 | 5344 | 62 |
1807058 | 1807058 | 2021-10-12 | Butte | California | 6007 | 23075 | 253 |
1807059 | 1807059 | 2021-10-12 | Calaveras | California | 6009 | 3795 | 75 |
1807060 | 1807060 | 2021-10-12 | Colusa | California | 6011 | 3001 | 18 |
1807061 | 1807061 | 2021-10-12 | Contra Costa | California | 6013 | 98924 | 960 |
1807062 | 1807062 | 2021-10-12 | Del Norte | California | 6015 | 3647 | 39 |
1807063 | 1807063 | 2021-10-12 | El Dorado | California | 6017 | 16888 | 146 |
1807064 | 1807064 | 2021-10-12 | Fresno | California | 6019 | 143220 | 2036 |
1807065 | 1807065 | 2021-10-12 | Glenn | California | 6021 | 4259 | 39 |
1807066 | 1807066 | 2021-10-12 | Humboldt | California | 6023 | 9026 | 106 |
1807067 | 1807067 | 2021-10-12 | Imperial | California | 6025 | 35443 | 761 |
1807068 | 1807068 | 2021-10-12 | Inyo | California | 6027 | 1891 | 39 |
1807069 | 1807069 | 2021-10-12 | Kern | California | 6029 | 142932 | 1596 |
1807070 | 1807070 | 2021-10-12 | Kings | California | 6031 | 32073 | 309 |
1807071 | 1807071 | 2021-10-12 | Lake | California | 6033 | 6489 | 97 |
1807072 | 1807072 | 2021-10-12 | Lassen | California | 6035 | 7318 | 43 |
1807073 | 1807073 | 2021-10-12 | Los Angeles | California | 6037 | 1473123 | 26346 |
1807074 | 1807074 | 2021-10-12 | Madera | California | 6039 | 23300 | 275 |
1807075 | 1807075 | 2021-10-12 | Marin | California | 6041 | 17546 | 242 |
1807076 | 1807076 | 2021-10-12 | Mariposa | California | 6043 | 1223 | 15 |
1807077 | 1807077 | 2021-10-12 | Mendocino | California | 6045 | 7467 | 86 |
1807078 | 1807078 | 2021-10-12 | Merced | California | 6047 | 41855 | 571 |
1807079 | 1807079 | 2021-10-12 | Modoc | California | 6049 | 763 | 8 |
1807080 | 1807080 | 2021-10-12 | Mono | California | 6051 | 1620 | 5 |
1807081 | 1807081 | 2021-10-12 | Monterey | California | 6053 | 50579 | 586 |
1807082 | 1807082 | 2021-10-12 | Napa | California | 6055 | 12752 | 96 |
1807083 | 1807083 | 2021-10-12 | Nevada | California | 6057 | 9004 | 90 |
1807084 | 1807084 | 2021-10-12 | Orange | California | 6059 | 322084 | 5504 |
1807085 | 1807085 | 2021-10-12 | Placer | California | 6061 | 38673 | 404 |
1807086 | 1807086 | 2021-10-12 | Plumas | California | 6063 | 1499 | 6 |
1807087 | 1807087 | 2021-10-12 | Riverside | California | 6065 | 368263 | 5063 |
1807088 | 1807088 | 2021-10-12 | Sacramento | California | 6067 | 156888 | 2245 |
1807089 | 1807089 | 2021-10-12 | San Benito | California | 6069 | 7341 | 71 |
1807090 | 1807090 | 2021-10-12 | San Bernardino | California | 6071 | 355472 | 5557 |
1807091 | 1807091 | 2021-10-12 | San Diego | California | 6073 | 378547 | 4124 |
1807092 | 1807092 | 2021-10-12 | San Francisco | California | 6075 | 53834 | 643 |
1807093 | 1807093 | 2021-10-12 | San Joaquin | California | 6077 | 101376 | 1687 |
1807094 | 1807094 | 2021-10-12 | San Luis Obispo | California | 6079 | 29538 | 331 |
1807095 | 1807095 | 2021-10-12 | San Mateo | California | 6081 | 53694 | 618 |
1807096 | 1807096 | 2021-10-12 | Santa Barbara | California | 6083 | 44662 | 515 |
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);