Release date: 2026-05-19 Documented with v2026.05.14 – v2026.05.20.
ctd_thin introduced as the headline CTD series (one direction, canonical types, 10 m grid +
inflections + bottle depths); schema browser site and the test_release → promote pipeline with
test_results.json; ERD and metadata.json sidecars from v2026.05.19.
Contents (generated)
| table | rows | |
|---|---|---|
_spatial |
3,373 | |
_spatial_attr |
40,298 | |
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,396,787 | partitioned |
ctd_thin |
5,551,571 | partitioned |
dataset |
5 | |
dic_measurement |
16,391 | |
dic_sample |
4,391 | |
dic_summary |
15,786 | |
grid |
218 | |
ichthyo |
852,228 | |
invert |
9,223 | |
lookup |
26 | |
measurement_type |
105 | |
net |
76,512 | |
segment |
60,413 | |
ship |
48 | |
site |
61,104 | |
species |
1,167 | |
taxa_rank |
41 | |
taxon |
3,385 | |
tow |
75,506 |
28 tables, 133,022,102 rows, 5.77 GB.
Datasets (5): calcofi_bottle, calcofi_ctd-cast, calcofi_dic, swfsc_ichthyo, swfsc_invert
How to cite
CalCOFI (2026). CalCOFI Integrated Database, release v2026.05.19 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.05.19
Cite the source datasets you use alongside the release:
calcofi_bottle— CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org. · license pendingcalcofi_ctd-cast— CalCOFI. (2023). CalCOFI CTD Cast Files. CalCOFI.org. · license pendingcalcofi_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.0swfsc_ichthyo— NOAA Fisheries SWFSC. CalCOFI Ichthyoplankton Database. · license pendingswfsc_invert— NOAA Fisheries SWFSC. CalCOFI Invertebrate Database. · license pending
Access
con <- calcofi4r::cc_get_db(version = "v2026.05.19")
con = calcofi4py.cc_get_db("v2026.05.19")
Parquet: https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.05.19/parquet/{table}.parquet;
full history: RELEASES.md.