CalCOFI integrated database release v2026.06.26

Release date: 2026-06-26

CCE-LTER ZooDB holoplankton and ZooScan PRPOOS ingested with reproducible acquisition scripts; measurement_type → dataset membership derived rather than asserted.

Contents (generated)

table	rows
`_spatial`	3,373
`_spatial_attr`	40,298
`bird_mammal_behavior`	4
`bird_mammal_observation`	82,418
`bird_mammal_species`	200
`bird_mammal_transect`	60,715
`bottle`	895,371
`bottle_measurement`	11,135,600
`cast_condition`	235,513
`casts`	35,644
`cruise`	691
`cruise_summary`	691
`ctd_cast`	5,550,014
`ctd_summary`	108,390,249	partitioned
`ctd_thin`	5,551,551	partitioned
`cufes_measurement`	284,097
`cufes_sample`	49,572
`dataset`	7
`dic_measurement`	16,391
`dic_sample`	4,391
`dic_summary`	15,786
`euphausiids_measurement`	10,150
`euphausiids_summary`	10,145
`euphausiids_tow`	10,150
`grid`	218
`ichthyo`	852,228
`invert`	9,223
`lookup`	26
`measurement_type`	106
`net`	76,512
`phyllosoma_measurement`	22,308
`phyllosoma_tow`	1,859
`phyto_measurement`	159,804
`phyto_sample`	409
`phyto_taxon`	399
`region`	4
`segment`	60,413
`ship`	48
`site`	61,104
`species`	1,167
`taxa_rank`	41
`taxon`	3,385
`tow`	75,506
`zoodb_measurement`	30,948
`zoodb_sample`	506
`zoodb_taxon`	33
`zooplankton_tow`	99,530
`zooscan_measurement`	126,692
`zooscan_sample`	1,483
`zooscan_taxon`	23

50 tables, 133,966,996 rows, 3.73 GB.

Datasets (12): calcofi_bird_mammal_census, calcofi_bottle, calcofi_ctd-cast, calcofi_dic, calcofi_phyllosoma, calcofi_phytoplankton, cce-lter_euphausiids, cce-lter_zoodb, cce-lter_zooscan, pic_zooplankton, swfsc_cufes, swfsc_ichthyo

Validation: 9 pass / 0 fail / 4 skip (consumer-contract suite, 2026-06-26T18:01:51Z).

How to cite

CalCOFI (2026). CalCOFI Integrated Database, release v2026.06.26 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.06.26

Cite the source datasets you use alongside the release:

calcofi_bird_mammal_census — citation pending · license pending
calcofi_bottle — CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org. · license pending
calcofi_ctd-cast — CalCOFI. (2023). CalCOFI CTD Cast Files. CalCOFI.org. · license pending
calcofi_dic — Keeling, C.D.; Lueker, T.J.; Emanuele, G.; Dickson, A.G.; Martz, T.R.; Wolfe, W.H.; Mau, A. (2025). Discrete profile dissolved inorganic carbon, total alkalinity, water temperature and salinity measurements for CalCOFI (NCEI Accession 0301029). NOAA NCEI. https://doi.org/10.25921/3w9f-jd72 · CC BY 4.0
calcofi_phyllosoma — citation pending · license pending
calcofi_phytoplankton — citation pending · license pending
cce-lter_euphausiids — citation pending · license pending
cce-lter_zoodb — citation pending · license pending
cce-lter_zooscan — citation pending · license pending
pic_zooplankton — citation pending · license pending
swfsc_cufes — citation pending · license pending
swfsc_ichthyo — NOAA Fisheries SWFSC. CalCOFI Ichthyoplankton Database. · license pending

Access

con <- calcofi4r::cc_get_db(version = "v2026.06.26")

con = calcofi4py.cc_get_db("v2026.06.26")

Parquet: https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.06.26/parquet/{table}.parquet; full history: RELEASES.md.