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 2020-10-01 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
586433 | 586433 | 2020-10-01 | Alameda | California | 6001 | 21479 | 420 |
586434 | 586434 | 2020-10-01 | Alpine | California | 6003 | 2 | 0 |
586435 | 586435 | 2020-10-01 | Amador | California | 6005 | 293 | 16 |
586436 | 586436 | 2020-10-01 | Butte | California | 6007 | 2858 | 45 |
586437 | 586437 | 2020-10-01 | Calaveras | California | 6009 | 322 | 14 |
586438 | 586438 | 2020-10-01 | Colusa | California | 6011 | 538 | 6 |
586439 | 586439 | 2020-10-01 | Contra Costa | California | 6013 | 16973 | 209 |
586440 | 586440 | 2020-10-01 | Del Norte | California | 6015 | 144 | 1 |
586441 | 586441 | 2020-10-01 | El Dorado | California | 6017 | 1157 | 4 |
586442 | 586442 | 2020-10-01 | Fresno | California | 6019 | 28706 | 390 |
586443 | 586443 | 2020-10-01 | Glenn | California | 6021 | 592 | 3 |
586444 | 586444 | 2020-10-01 | Humboldt | California | 6023 | 515 | 8 |
586445 | 586445 | 2020-10-01 | Imperial | California | 6025 | 11993 | 322 |
586446 | 586446 | 2020-10-01 | Inyo | California | 6027 | 189 | 15 |
586447 | 586447 | 2020-10-01 | Kern | California | 6029 | 32184 | 371 |
586448 | 586448 | 2020-10-01 | Kings | California | 6031 | 7685 | 80 |
586449 | 586449 | 2020-10-01 | Lake | California | 6033 | 567 | 11 |
586450 | 586450 | 2020-10-01 | Lassen | California | 6035 | 742 | 0 |
586451 | 586451 | 2020-10-01 | Los Angeles | California | 6037 | 271371 | 6610 |
586452 | 586452 | 2020-10-01 | Madera | California | 6039 | 4614 | 68 |
586453 | 586453 | 2020-10-01 | Marin | California | 6041 | 6751 | 119 |
586454 | 586454 | 2020-10-01 | Mariposa | California | 6043 | 76 | 2 |
586455 | 586455 | 2020-10-01 | Mendocino | California | 6045 | 971 | 19 |
586456 | 586456 | 2020-10-01 | Merced | California | 6047 | 9019 | 145 |
586457 | 586457 | 2020-10-01 | Modoc | California | 6049 | 27 | 0 |
586458 | 586458 | 2020-10-01 | Mono | California | 6051 | 167 | 2 |
586459 | 586459 | 2020-10-01 | Monterey | California | 6053 | 10181 | 74 |
586460 | 586460 | 2020-10-01 | Napa | California | 6055 | 1729 | 13 |
586461 | 586461 | 2020-10-01 | Nevada | California | 6057 | 544 | 7 |
586462 | 586462 | 2020-10-01 | Orange | California | 6059 | 55437 | 1275 |
586463 | 586463 | 2020-10-01 | Placer | California | 6061 | 3617 | 48 |
586464 | 586464 | 2020-10-01 | Plumas | California | 6063 | 48 | 0 |
586465 | 586465 | 2020-10-01 | Riverside | California | 6065 | 59488 | 1226 |
586466 | 586466 | 2020-10-01 | Sacramento | California | 6067 | 22754 | 426 |
586467 | 586467 | 2020-10-01 | San Benito | California | 6069 | 1355 | 11 |
586468 | 586468 | 2020-10-01 | San Bernardino | California | 6071 | 55394 | 955 |
586469 | 586469 | 2020-10-01 | San Diego | California | 6073 | 47548 | 792 |
586470 | 586470 | 2020-10-01 | San Francisco | California | 6075 | 11335 | 106 |
586471 | 586471 | 2020-10-01 | San Joaquin | California | 6077 | 20457 | 466 |
586472 | 586472 | 2020-10-01 | San Luis Obispo | California | 6079 | 3649 | 31 |
586473 | 586473 | 2020-10-01 | San Mateo | California | 6081 | 10069 | 150 |
586474 | 586474 | 2020-10-01 | Santa Barbara | California | 6083 | 9223 | 115 |
586475 | 586475 | 2020-10-01 | Santa Clara | California | 6085 | 21457 | 326 |
586476 | 586476 | 2020-10-01 | Santa Cruz | California | 6087 | 2427 | 12 |
586477 | 586477 | 2020-10-01 | Shasta | California | 6089 | 976 | 20 |
586478 | 586478 | 2020-10-01 | Sierra | California | 6091 | 6 | 0 |
586479 | 586479 | 2020-10-01 | Siskiyou | California | 6093 | 166 | 0 |
586480 | 586480 | 2020-10-01 | Solano | California | 6095 | 6480 | 71 |
586481 | 586481 | 2020-10-01 | Sonoma | California | 6097 | 7578 | 122 |
586482 | 586482 | 2020-10-01 | Stanislaus | California | 6099 | 16573 | 365 |
586483 | 586483 | 2020-10-01 | Sutter | California | 6101 | 1733 | 11 |
586484 | 586484 | 2020-10-01 | Tehama | California | 6103 | 594 | 5 |
586485 | 586485 | 2020-10-01 | Trinity | California | 6105 | 16 | 0 |
586486 | 586486 | 2020-10-01 | Tulare | California | 6107 | 16322 | 263 |
586487 | 586487 | 2020-10-01 | Tuolumne | California | 6109 | 229 | 4 |
586488 | 586488 | 2020-10-01 | Ventura | California | 6111 | 12968 | 152 |
586489 | 586489 | 2020-10-01 | Yolo | California | 6113 | 2836 | 55 |
586490 | 586490 | 2020-10-01 | Yuba | California | 6115 | 1183 | 8 |
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);