← all releases

CalCOFI release v2026.06.26

2026-06-26 · 50 tables · 133,966,996 rows · 3.47 GB

tablerowssize
_spatial_attr.parquet40,298121 KB
_spatial.parquet3,37325.0 MB
bird_mammal_behavior.parquet41 KB
bird_mammal_observation.parquet82,418182 KB
bird_mammal_species.parquet2006 KB
bird_mammal_transect.parquet60,7153.5 MB
bottle_measurement.parquet11,135,60058.9 MB
bottle.parquet895,3713.4 MB
cast_condition.parquet235,513452 KB
casts.parquet35,6441.9 MB
cruise_summary.parquet6918 KB
cruise.parquet6916 KB
ctd_cast.parquet5,550,014128.4 MB
ctd_summary/ 97 parts108,390,2493.07 GB
ctd_thin/ 97 parts5,551,551155.6 MB
cufes_measurement.parquet284,097513 KB
cufes_sample.parquet49,5723.6 MB
dataset.parquet76 KB
dic_measurement.parquet16,391127 KB
dic_sample.parquet4,39127 KB
dic_summary.parquet15,786121 KB
euphausiids_measurement.parquet10,15068 KB
euphausiids_summary.parquet10,145177 KB
euphausiids_tow.parquet10,150187 KB
grid.parquet21898 KB
ichthyo.parquet852,22817.8 MB
invert.parquet9,22328 KB
lookup.parquet262 KB
measurement_type.parquet1065 KB
net.parquet76,512653 KB
phyllosoma_measurement.parquet22,30878 KB
phyllosoma_tow.parquet1,85933 KB
phyto_measurement.parquet159,80491 KB
phyto_sample.parquet4093 KB
phyto_taxon.parquet39910 KB
region.parquet41 KB
segment.parquet60,4132.4 MB
ship.parquet482 KB
site.parquet61,1041.2 MB
species.parquet1,16726 KB
taxa_rank.parquet411 KB
taxon.parquet3,38546 KB
tow.parquet75,506440 KB
zoodb_measurement.parquet30,948112 KB
zoodb_sample.parquet50618 KB
zoodb_taxon.parquet334 KB
zooplankton_tow.parquet99,5301.6 MB
zooscan_measurement.parquet126,692652 KB
zooscan_sample.parquet1,48315 KB
zooscan_taxon.parquet234 KB

Sidecars

Machine-readable descriptions of this release.

filesize
RELEASE_NOTES.md3 KB
catalog.json5 KB
erd.mmd21 KB
index.html15 KB
metadata.json182 KB
relationships.json11 KB
test_results.json2 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.06.26/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.06.26/parquet/obs_ctd_full/**/*.parquet', hive_partitioning = true) LIMIT 10;