CalCOFI.io CalCOFI.io Storage

all releases / v2026.10.21

obs — v2026.10.21

19 partitions · 264.5 MB

partition / filesize
dataset_key=calcofi_2022-edna/data_0.parquet6 KB
dataset_key=calcofi_bottle-derived/data_0.parquet23.5 MB
dataset_key=calcofi_bottle/data_0.parquet72.2 MB
dataset_key=calcofi_ctd-cast/data_0.parquet130.1 MB
dataset_key=calcofi_ctd-derived/data_0.parquet18.8 MB
dataset_key=calcofi_dic/data_0.parquet165 KB
dataset_key=calcofi_mets/data_0.parquet9.3 MB
dataset_key=calcofi_phyllosoma/data_0.parquet25 KB
dataset_key=calcofi_phytoplankton/data_0.parquet247 KB
dataset_key=cce-lter_euphausiids/data_0.parquet695 KB
dataset_key=cce-lter_iron/data_0.parquet7 KB
dataset_key=cce-lter_picoplankton-bacteria/data_0.parquet596 KB
dataset_key=cce-lter_zoodb/data_0.parquet155 KB
dataset_key=cce-lter_zooscan/data_0.parquet600 KB
dataset_key=cdfw_dungeness-crab/data_0.parquet19 KB
dataset_key=farallon_bird-mammal/data_0.parquet745 KB
dataset_key=sio_mesopelagic-fish/data_0.parquet13 KB
dataset_key=swfsc_cufes/data_0.parquet3.3 MB
dataset_key=swfsc_ichthyo/data_0.parquet4.1 MB
Query every partition at once rather than downloading them individually — hive_partitioning exposes the directory name as a column you can filter on:
SELECT * FROM read_parquet('https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.10.21/parquet/obs/**/*.parquet', hive_partitioning = true) LIMIT 10;