CalCOFI release v2026.05.14

2026-05-14 · 28 tables · 133,013,839 rows · 1 KB consolidated

table	rows	size
_spatial_attr.parquet	40,298	121 KB
_spatial.parquet	3,373	25.0 MB
bottle_measurement.parquet	11,135,600	113.8 MB
bottle.parquet	895,371	13.8 MB
cast_condition.parquet	235,513	1.5 MB
casts.parquet	35,644	2.0 MB
cruise_summary.parquet	691	8 KB
cruise.parquet	691	17 KB
ctd_cast.parquet	5,550,014	258.7 MB
ctd_summary/ 98 parts	108,396,787	4.69 GB
ctd_thin/ 98 parts	5,551,571	252.4 MB
dataset.parquet	5	6 KB
dic_measurement.parquet	16,391	189 KB
dic_sample.parquet	4,391	35 KB
dic_summary.parquet	15,786	131 KB
grid.parquet	218	122 KB
ichthyo.parquet	841,417	23.8 MB
invert.parquet	11,815	146 KB
lookup.parquet	26	3 KB
measurement_type.parquet	104	6 KB
net.parquet	76,512	1.9 MB
segment.parquet	60,413	4.0 MB
ship.parquet	48	2 KB
site.parquet	61,104	2.0 MB
species.parquet	1,150	46 KB
taxa_rank.parquet	41	1 KB
taxon.parquet	3,359	68 KB
tow.parquet	75,506	1.8 MB

Sidecars

Machine-readable descriptions of this release.

file	size
RELEASE_NOTES.html	12 KB
RELEASE_NOTES.md	2 KB
catalog.json	3 KB
index.html	13 KB
relationships.json	3 KB

Read directly with DuckDB — no download needed. A single-file table:

SELECT * FROM read_parquet('https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.05.14/parquet/sample.parquet') LIMIT 10;

A partitioned table (note the /**/*.parquet glob and hive_partitioning, which turns the directory names into a real column):

SELECT * FROM read_parquet('https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.05.14/parquet/obs_ctd_full/**/*.parquet',
hive_partitioning = true) LIMIT 10;