← all releases

CalCOFI release v2026.04.02

2026-04-02 · 43 tables · 361,152,303 rows · 11.23 GB

tablerowssize
boem_wind_planning.parquet9,8331.4 MB
bottle_measurement.parquet11,135,60044.8 MB
bottle.parquet895,3715.7 MB
ca_assembly_districts.parquet803.5 MB
ca_cdfw_regions.parquet74.3 MB
ca_county_boundaries.parquet583.1 MB
ca_cowcod_conservation.parquet25 KB
ca_marine_protected_areas.parquet1551.1 MB
ca_maritime_boundaries.parquet2855 KB
ca_ports.parquet19415 KB
ca_senate_districts.parquet403.2 MB
ca_swqpa.parquet36766 KB
ca_watershed_boundaries.parquet14019.3 MB
cast_condition.parquet235,513722 KB
casts.parquet35,6441.4 MB
cruise.parquet6915 KB
ctd_cast.parquet6,065,096168.9 MB
ctd_measurement/ 98 parts236,782,2947.94 GB
ctd_summary/ 97 parts104,828,7683.01 GB
dataset.parquet55 KB
dic_measurement_summary.parquet15,78695 KB
dic_measurement.parquet16,39199 KB
dic_sample.parquet4,39127 KB
grid.parquet21897 KB
ichthyo.parquet830,87314.6 MB
invert_count.parquet9,628213 KB
invert_size.parquet4,57459 KB
lookup.parquet262 KB
measurement_type.parquet1045 KB
meow_ecoregions.parquet232356 KB
net.parquet76,512802 KB
noaa_aquaculture_aoas.parquet103 KB
noaa_iea_regions.parquet1144 KB
noaa_maritime_boundaries.parquet2602.6 MB
noaa_ocean_disposal.parquet2,1482.3 MB
noaa_onms_sanctuaries.parquet162.8 MB
segment.parquet60,4132.6 MB
ship.parquet481 KB
site.parquet61,104866 KB
species.parquet1,14428 KB
taxa_rank.parquet411 KB
taxon.parquet3,34848 KB
tow.parquet75,506462 KB

Sidecars

Machine-readable descriptions of this release.

filesize
RELEASE_NOTES.md3 KB
catalog.json4 KB
index.html13 KB
relationships.json3 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.04.02/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.04.02/parquet/obs_ctd_full/**/*.parquet', hive_partitioning = true) LIMIT 10;