CalCOFI CalCOFI CalCOFI.io open data ecosystem

CalCOFI Integrated Database

v2026.09.052026-09-05all versions

Every ingested CalCOFI dataset assembled into one versioned, frozen database — 23 tables, 348,657,010 rows, 2.3 GB of Parquet with a JSON catalog. It is what calcofi4r, calcofi4py, the browser SQL playground, ERDDAP and every app on calcofi.io read.

Access

catalog.json every table and object in this release, with bytes and sha256
datasets.json the record every page on this site is built from (schema 1.0)
release folder the sidecars: metadata, coverage, the station grid, spatial layers
db-schema tables, columns and the entity-relationship diagram at this version
db-query SQL in your browser, straight over the released Parquet
R · calcofi4r 
con <- calcofi4r::cc_get_db()   # v2026.09.05
Python · calcofi4py 
con = calcofi4py.cc_get_db()   # v2026.09.05
RELEASES.md what changed between releases, and why

Cite

CalCOFI (2026). CalCOFI Integrated Database, release v2026.09.05 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.09.05
BibTeX 
@misc{calcofi_release_v2026_09_05,
  title     = {CalCOFI Integrated Database, release v2026.09.05},
  author    = {CalCOFI},
  year      = {2026},
  publisher = {Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife},
  url       = {https://calcofi.io/db-schema/?v=v2026.09.05}
}

Parts

16 datasets are part of this release.

© 2026 CalCOFI · calcofi.io