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 362
- Los Angeles 361
- Santa Clara 356
- San Francisco 354
- San Diego 346
- Humboldt 336
- Sacramento 335
- Solano 332
- Marin 330
- Napa 330
- Sonoma 330
- Alameda 326
- Placer 325
- San Mateo 325
- Contra Costa 324
- Yolo 321
- Fresno 320
- Madera 320
- Riverside 320
- Santa Cruz 320
- Shasta 318
- San Joaquin 317
- Ventura 317
- Stanislaus 316
- Tulare 315
- San Benito 314
- San Luis Obispo 313
- San Bernardino 312
- Santa Barbara 312
- Nevada 311
- …
state 1
- California · 17,961 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946587 | 946587 | 2021-01-20 | Alameda | California | 6001 | 68670 | 788 |
946588 | 946588 | 2021-01-20 | Alpine | California | 6003 | 71 | 0 |
946589 | 946589 | 2021-01-20 | Amador | California | 6005 | 3023 | 30 |
946590 | 946590 | 2021-01-20 | Butte | California | 6007 | 9528 | 123 |
946591 | 946591 | 2021-01-20 | Calaveras | California | 6009 | 1621 | 23 |
946592 | 946592 | 2021-01-20 | Colusa | California | 6011 | 1796 | 9 |
946593 | 946593 | 2021-01-20 | Contra Costa | California | 6013 | 53349 | 460 |
946594 | 946594 | 2021-01-20 | Del Norte | California | 6015 | 867 | 2 |
946595 | 946595 | 2021-01-20 | El Dorado | California | 6017 | 7743 | 44 |
946596 | 946596 | 2021-01-20 | Fresno | California | 6019 | 83200 | 968 |
946597 | 946597 | 2021-01-20 | Glenn | California | 6021 | 2299 | 19 |
946598 | 946598 | 2021-01-20 | Humboldt | California | 6023 | 2427 | 25 |
946599 | 946599 | 2021-01-20 | Imperial | California | 6025 | 25333 | 473 |
946600 | 946600 | 2021-01-20 | Inyo | California | 6027 | 891 | 29 |
946601 | 946601 | 2021-01-20 | Kern | California | 6029 | 87240 | 572 |
946602 | 946602 | 2021-01-20 | Kings | California | 6031 | 19588 | 148 |
946603 | 946603 | 2021-01-20 | Lake | California | 6033 | 2625 | 30 |
946604 | 946604 | 2021-01-20 | Lassen | California | 6035 | 5199 | 13 |
946605 | 946605 | 2021-01-20 | Los Angeles | California | 6037 | 1038495 | 14384 |
946606 | 946606 | 2021-01-20 | Madera | California | 6039 | 13528 | 151 |
946607 | 946607 | 2021-01-20 | Marin | California | 6041 | 11726 | 157 |
946608 | 946608 | 2021-01-20 | Mariposa | California | 6043 | 346 | 4 |
946609 | 946609 | 2021-01-20 | Mendocino | California | 6045 | 3171 | 32 |
946610 | 946610 | 2021-01-20 | Merced | California | 6047 | 24570 | 316 |
946611 | 946611 | 2021-01-20 | Modoc | California | 6049 | 385 | 3 |
946612 | 946612 | 2021-01-20 | Mono | California | 6051 | 1106 | 4 |
946613 | 946613 | 2021-01-20 | Monterey | California | 6053 | 36464 | 255 |
946614 | 946614 | 2021-01-20 | Napa | California | 6055 | 7673 | 44 |
946615 | 946615 | 2021-01-20 | Nevada | California | 6057 | 3234 | 74 |
946616 | 946616 | 2021-01-20 | Orange | California | 6059 | 229132 | 2508 |
946617 | 946617 | 2021-01-20 | Placer | California | 6061 | 17490 | 184 |
946618 | 946618 | 2021-01-20 | Plumas | California | 6063 | 509 | 5 |
946619 | 946619 | 2021-01-20 | Riverside | California | 6065 | 251000 | 2676 |
946620 | 946620 | 2021-01-20 | Sacramento | California | 6067 | 81182 | 1128 |
946621 | 946621 | 2021-01-20 | San Benito | California | 6069 | 5003 | 46 |
946622 | 946622 | 2021-01-20 | San Bernardino | California | 6071 | 256914 | 1560 |
946623 | 946623 | 2021-01-20 | San Diego | California | 6073 | 218618 | 2174 |
946624 | 946624 | 2021-01-20 | San Francisco | California | 6075 | 29505 | 266 |
946625 | 946625 | 2021-01-20 | San Joaquin | California | 6077 | 58843 | 788 |
946626 | 946626 | 2021-01-20 | San Luis Obispo | California | 6079 | 16056 | 140 |
946627 | 946627 | 2021-01-20 | San Mateo | California | 6081 | 32887 | 309 |
946628 | 946628 | 2021-01-20 | Santa Barbara | California | 6083 | 25083 | 236 |
946629 | 946629 | 2021-01-20 | Santa Clara | California | 6085 | 94905 | 1130 |
946630 | 946630 | 2021-01-20 | Santa Cruz | California | 6087 | 12461 | 113 |
946631 | 946631 | 2021-01-20 | Shasta | California | 6089 | 9750 | 123 |
946632 | 946632 | 2021-01-20 | Sierra | California | 6091 | 40 | 0 |
946633 | 946633 | 2021-01-20 | Siskiyou | California | 6093 | 1457 | 13 |
946634 | 946634 | 2021-01-20 | Solano | California | 6095 | 25988 | 107 |
946635 | 946635 | 2021-01-20 | Sonoma | California | 6097 | 24184 | 242 |
946636 | 946636 | 2021-01-20 | Stanislaus | California | 6099 | 47506 | 766 |
946637 | 946637 | 2021-01-20 | Sutter | California | 6101 | 7828 | 79 |
946638 | 946638 | 2021-01-20 | Tehama | California | 6103 | 3876 | 42 |
946639 | 946639 | 2021-01-20 | Trinity | California | 6105 | 261 | 4 |
946640 | 946640 | 2021-01-20 | Tulare | California | 6107 | 42186 | 515 |
946641 | 946641 | 2021-01-20 | Tuolumne | California | 6109 | 3403 | 40 |
946642 | 946642 | 2021-01-20 | Ventura | California | 6111 | 62774 | 462 |
946643 | 946643 | 2021-01-20 | Yolo | California | 6113 | 10789 | 138 |
946644 | 946644 | 2021-01-20 | Yuba | California | 6115 | 4996 | 27 |
943340 | 943340 | 2021-01-19 | Alameda | California | 6001 | 67973 | 765 |
943341 | 943341 | 2021-01-19 | Alpine | California | 6003 | 71 | 0 |
943342 | 943342 | 2021-01-19 | Amador | California | 6005 | 3015 | 29 |
943343 | 943343 | 2021-01-19 | Butte | California | 6007 | 9474 | 121 |
943344 | 943344 | 2021-01-19 | Calaveras | California | 6009 | 1617 | 23 |
943345 | 943345 | 2021-01-19 | Colusa | California | 6011 | 1733 | 9 |
943346 | 943346 | 2021-01-19 | Contra Costa | California | 6013 | 52965 | 450 |
943347 | 943347 | 2021-01-19 | Del Norte | California | 6015 | 866 | 2 |
943348 | 943348 | 2021-01-19 | El Dorado | California | 6017 | 7707 | 44 |
943349 | 943349 | 2021-01-19 | Fresno | California | 6019 | 82485 | 932 |
943350 | 943350 | 2021-01-19 | Glenn | California | 6021 | 2177 | 19 |
943351 | 943351 | 2021-01-19 | Humboldt | California | 6023 | 2393 | 24 |
943352 | 943352 | 2021-01-19 | Imperial | California | 6025 | 25317 | 464 |
943353 | 943353 | 2021-01-19 | Inyo | California | 6027 | 872 | 29 |
943354 | 943354 | 2021-01-19 | Kern | California | 6029 | 86718 | 565 |
943355 | 943355 | 2021-01-19 | Kings | California | 6031 | 19435 | 145 |
943356 | 943356 | 2021-01-19 | Lake | California | 6033 | 2591 | 30 |
943357 | 943357 | 2021-01-19 | Lassen | California | 6035 | 5195 | 13 |
943358 | 943358 | 2021-01-19 | Los Angeles | California | 6037 | 1032277 | 14122 |
943359 | 943359 | 2021-01-19 | Madera | California | 6039 | 13443 | 151 |
943360 | 943360 | 2021-01-19 | Marin | California | 6041 | 11691 | 154 |
943361 | 943361 | 2021-01-19 | Mariposa | California | 6043 | 346 | 4 |
943362 | 943362 | 2021-01-19 | Mendocino | California | 6045 | 3114 | 32 |
943363 | 943363 | 2021-01-19 | Merced | California | 6047 | 24452 | 308 |
943364 | 943364 | 2021-01-19 | Modoc | California | 6049 | 385 | 3 |
943365 | 943365 | 2021-01-19 | Mono | California | 6051 | 1101 | 4 |
943366 | 943366 | 2021-01-19 | Monterey | California | 6053 | 36126 | 255 |
943367 | 943367 | 2021-01-19 | Napa | California | 6055 | 7602 | 40 |
943368 | 943368 | 2021-01-19 | Nevada | California | 6057 | 3206 | 73 |
943369 | 943369 | 2021-01-19 | Orange | California | 6059 | 227321 | 2477 |
943370 | 943370 | 2021-01-19 | Placer | California | 6061 | 17380 | 180 |
943371 | 943371 | 2021-01-19 | Plumas | California | 6063 | 506 | 5 |
943372 | 943372 | 2021-01-19 | Riverside | California | 6065 | 250436 | 2645 |
943373 | 943373 | 2021-01-19 | Sacramento | California | 6067 | 80677 | 1111 |
943374 | 943374 | 2021-01-19 | San Benito | California | 6069 | 4963 | 43 |
943375 | 943375 | 2021-01-19 | San Bernardino | California | 6071 | 256109 | 1560 |
943376 | 943376 | 2021-01-19 | San Diego | California | 6073 | 216898 | 2109 |
943377 | 943377 | 2021-01-19 | San Francisco | California | 6075 | 29324 | 262 |
943378 | 943378 | 2021-01-19 | San Joaquin | California | 6077 | 58290 | 786 |
943379 | 943379 | 2021-01-19 | San Luis Obispo | California | 6079 | 15929 | 136 |
943380 | 943380 | 2021-01-19 | San Mateo | California | 6081 | 32596 | 309 |
943381 | 943381 | 2021-01-19 | Santa Barbara | California | 6083 | 25083 | 236 |
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);