CalCOFI CalCOFI CalCOFI.io open data ecosystem

CUFES Fish Eggs

CalCOFI Underway CUFES Fish Eggs

swfsc_cufesNOAA SWFSCCustom terms stated by the providerv2026.09.05ingested

years
1996–2022
observations
284,097
sampling events
49,572
stations
128
taxa
6
depth
0–0 m
observations per year, 1996–2022
st0-ln10_hist · 4,500 obsst20-ln10_hist · 2,502 obsst40-ln10_hist · 282 obsst60-ln10_hist · 24 obsst0-ln20_hist · 4,608 obsst20-ln20_hist · 4,104 obsst40-ln20_hist · 876 obsst60-ln20_hist · 240 obsst0-ln30_hist · 66 obsst20-ln30_hist · 6,300 obsst40-ln30_hist · 4,572 obsst60-ln30_hist · 1,026 obsst80-ln30_hist · 42 obsst40-ln40_hist · 5,520 obsst60-ln40_hist · 1,836 obsst80-ln40_hist · 540 obsst100-ln50_hist · 90 obsst20-ln100_hist · 186 obsst40-ln100_hist · 328 obsst60-ln100_hist · 321 obsst80-ln100_hist · 204 obsst70-ln60 · 1,131 obsst80-ln60 · 774 obsst90-ln60 · 288 obsst70-ln63.3 · 1,973 obsst80-ln63.3 · 1,423 obsst90-ln63.3 · 684 obsst70-ln66.7 · 2,811 obsst100-ln63.3 · 18 obsst80-ln66.7 · 2,448 obsst90-ln66.7 · 1,240 obsst70-ln70 · 2,455 obsst100-ln66.7 · 198 obsst80-ln70 · 2,150 obsst90-ln70 · 953 obsst70-ln73.3 · 3,183 obsst100-ln70 · 176 obsst80-ln73.3 · 2,617 obsst90-ln73.3 · 1,308 obsst70-ln76.7 · 3,707 obsst100-ln73.3 · 528 obsst80-ln76.7 · 3,083 obsst90-ln76.7 · 2,265 obsst70-ln80 · 2,988 obsst100-ln76.7 · 1,897 obsst80-ln80 · 2,557 obsst90-ln80 · 2,102 obsst70-ln83.3 · 3,427 obsst100-ln80 · 1,876 obsst80-ln83.3 · 2,772 obsst90-ln83.3 · 2,373 obsst70-ln86.7 · 3,313 obsst100-ln83.3 · 1,835 obsst80-ln86.7 · 3,005 obsst110-ln83.3 · 1,721 obsst90-ln86.7 · 1,987 obsst70-ln90 · 2,505 obsst100-ln86.7 · 1,840 obsst80-ln90 · 2,163 obsst110-ln86.7 · 1,657 obsst90-ln90 · 2,303 obsst70-ln93.3 · 2,867 obsst100-ln90 · 2,042 obsst80-ln93.3 · 2,639 obsst110-ln90 · 1,914 obsst90-ln93.3 · 2,379 obsst120-ln90 · 1,955 obsst100-ln93.3 · 2,073 obsst110-ln93.3 · 1,935 obsst120-ln93.3 · 1,808 obsst60-ln60 · 1,169 obsst50-ln60 · 771 obsst55-ln60 · 1,181 obsst50-ln63.3 · 1,068 obsst55-ln63.3 · 1,744 obsst60-ln63.3 · 1,918 obsst45-ln66.7 · 6 obsst50-ln66.7 · 2,237 obsst55-ln66.7 · 2,521 obsst60-ln66.7 · 2,448 obsst50-ln70 · 948 obsst55-ln70 · 2,469 obsst60-ln70 · 2,264 obsst50-ln73.3 · 1,555 obsst55-ln73.3 · 2,181 obsst60-ln73.3 · 2,680 obsst50-ln76.7 · 2,572 obsst55-ln76.7 · 2,559 obsst60-ln76.7 · 3,440 obsst45-ln80 · 261 obsst50-ln80 · 5,107 obsst55-ln80 · 3,526 obsst35-ln83.3 · 277 obsst60-ln80 · 2,554 obsst40-ln83.3 · 5,352 obsst45-ln83.3 · 3,804 obsst50-ln83.3 · 4,347 obsst30-ln86.7 · 265 obsst55-ln83.3 · 5,014 obsst35-ln86.7 · 4,493 obsst60-ln83.3 · 2,612 obsst40-ln86.7 · 3,063 obsst45-ln86.7 · 3,061 obsst25-ln90 · 54 obsst50-ln86.7 · 2,372 obsst30-ln90 · 3,472 obsst55-ln86.7 · 2,123 obsst35-ln90 · 2,834 obsst60-ln86.7 · 2,748 obsst40-ln90 · 2,338 obsst45-ln90 · 1,934 obsst25-ln93.3 · 1,453 obsst50-ln90 · 1,677 obsst30-ln93.3 · 6,017 obsst55-ln90 · 1,615 obsst35-ln93.3 · 3,171 obsst60-ln90 · 2,338 obsst40-ln93.3 · 2,318 obsst45-ln93.3 · 1,774 obsst50-ln93.3 · 1,944 obsst55-ln93.3 · 1,813 obsst60-ln93.3 · 2,465 obsst110-ln60_hist · 24 obsst110-ln70_hist · 78 obsst110-ln80_hist · 162 obsst80-ln55_hist · 1,914 obsst60-ln55_hist · 8,002 obsst40-ln55_hist · 1,044 obs130°W125°W120°W30°N35°N40°N45°Nextent continues beyond the frame
128 CalCOFI stations sampled, sized by observations, over the survey grid; the record’s extent continues beyond the frame.

Overview

Continuous Underway Fish Egg Sampler (CUFES) egg counts (sardine, anchovy, jack mackerel, hake, squid, other) with underway environmental conditions, from CalCOFI cruises (1996-present). Source: NOAA CoastWatch ERDDAP erdCalCOFIcufes.

Principal investigators
Noelle Bowlin
Keywords
EARTH SCIENCE > BIOLOGICAL CLASSIFICATION > ANIMALS/VERTEBRATES > FISHEARTH SCIENCE > BIOLOGICAL CLASSIFICATION > ANIMALS/VERTEBRATES > FISH > RAY-FINNED FISHES > ANCHOVIES/HERRINGS

Open with the provider

  • Q06 citation_main — proposed

Coverage

1 variable

abundance

Life stages

egg

Access

Every endpoint this dataset can be reached through, grouped by how you would use it. Every URL is in the release record and answered when the release was cut.

Explore

Apps that read this dataset from the release. A row marked “this dataset” opens with it already selected.

CalCOFI Explorerthis datasetAcross datasets

https://calcofi.io/explore/?datasets=swfsc_cufes

Station Explorerthis datasetAcross datasets

https://app.calcofi.io/station/?dataset=swfsc_cufes

Hexagon Explorerthis datasetAcross datasets

https://app.calcofi.io/hex/?datasets=swfsc_cufes

Cruise Explorerthis datasetAcross datasets

https://app.calcofi.io/cruise/?datasets=swfsc_cufes

Query

SQL against the release itself, in the browser — nothing to install and nothing downloaded until a query asks for it. __TBL:obs__ resolves to the pinned release’s parquet.

db-query — the SQL shell, prefilledDuckDB-WASM over the released parquet, in your browser
-- swfsc_cufes in the CalCOFI release v2026.09.05
SELECT *
FROM __TBL:obs__
WHERE dataset_key = 'swfsc_cufes'
LIMIT 100;

https://calcofi.io/db-query/?sql=--+swfsc_cufes+in+the+CalCOFI+release+v2026.09.05%0ASELECT+%2A%0AFROM+__TBL%3Aobs__%0AWHERE+dataset_key+%3D+%27swfsc_cufes%27%0ALIMIT+100%3B#sql-shell--shell

Code

The same release, from a script.

con <- calcofi4r::cc_get_db()
calcofi4r::cc_cite("swfsc_cufes")
con = calcofi4py.cc_get_db()
calcofi4py.cite("swfsc_cufes")
DuckDB, anywhereno CalCOFI package needed — the object is a plain parquet file
SELECT * FROM read_parquet('https://storage.googleapis.com/calcofi-db/ducklake-staging/tables/obs/dataset_key=swfsc_cufes/41f6b0060d3538ea82892d2c/data_0.parquet') LIMIT 100;

Get the data

Every way to have the bytes, by source. Nothing here asks you to register first.

Files from the release (Parquet)

The frozen objects this release is made of. A partition holds only this dataset’s rows; a shared table holds every dataset’s, so filter on dataset_key.

obsthis dataset’s rows · 2.6 MB · since v2026.09.04sha256 f053e9fa7f31…

https://storage.googleapis.com/calcofi-db/ducklake-staging/tables/obs/dataset_key=swfsc_cufes/41f6b0060d3538ea82892d2c/data_0.parquet

measurement_typewhole table, shared with every dataset in it · 11.7 KB · since v2026.09.04sha256 a5c62f4ab5f3…

https://storage.googleapis.com/calcofi-db/ducklake-staging/tables/measurement_type/43134b000012a2ce69281979/measurement_type.parquet

CF netCDF

One self-describing file, for a tool that reads netCDF.

CF netCDF80.2 MBsha256 bd0ad255ba03…
how far this file is CF

Fully CF: an underway series on a moving platform is a CF trajectory. One trajectory per cruise; time, latitude and longitude vary along the observation dimension rather than being fixed per instance.

https://storage.calcofi.io/calcofi-files-public/netcdf/swfsc_cufes/v2026.09.04/swfsc_cufes.nc

ERDDAP (erddap.calcofi.io)

One ERDDAP dataset per grain, each with its own data formats and its own pages. Subset in the browser or query it from a script.

ERDDAP dataset grain data & pagesswfsc_cufes observations CSVnetCDFJSON pageinfograph swfsc_cufes_sample sampling events CSVnetCDFJSON pageinfograph
observations
one row per measurement, joined to the event it was taken on
sampling events
one row per cast, tow or transect — when, where and how it was sampled

From the provider

The dataset as its provider publishes it, before CalCOFI ingested it.

sourceexternalNOAA CoastWatch ERDDAP

https://coastwatch.pfeg.noaa.gov/erddap/tabledap/erdCalCOFIcufes.html

Metadata records

Records about the data, in the standards each portal harvests.

ISO 19115-3XML, from the ERDDAP WAF

https://erddap.calcofi.io/erddap/metadata/iso19115/xml/swfsc_cufes_iso19115.xml

https://erddap.calcofi.io/erddap/metadata/fgdc/xml/swfsc_cufes_fgdc.xml

JSON-LD (schema.org/Dataset)what this page publishes to Google Dataset Search

https://calcofi.io/datasets/swfsc_cufes.jsonld

the record, verbatimthe release’s own entry for this dataset — everything on this page comes from it

https://calcofi.io/datasets/swfsc_cufes.json

DCAT-US 1.1the whole catalog, for data.gov and any CKAN

https://calcofi.io/data.json

STAC collectionone Collection per dataset, an Item per release

https://calcofi.io/stac/#/collections/swfsc_cufes/collection.json

Archives & portals

Where this dataset is registered outside calcofi.io, by the identifier each portal knows it as.

ERDDAP (calcofi.io)swfsc_cufespublished

https://erddap.calcofi.io/erddap/info/swfsc_cufes/index.html

OBISn/a
EDIn/a
NCEIn/a
CalOOSplanned
Zenodo10.5281/zenodo.22281994publishedas part of the integrated database release

https://doi.org/10.5281/zenodo.22281994

Everything here is open — nothing on calcofi.io asks you to register first. If this dataset ends up in something you build or publish, register your use so it can be credited and linked back; to hear when a release changes it, stay informed. Questions: data@calcofi.io.

Cite

The provider has not confirmed a citation for this dataset yet. Cite the release below, and name the dataset by its key.

CalCOFI Underway CUFES Fish Eggs [dataset].
License: custom (https://coastwatch.pfeg.noaa.gov/erddap/tabledap/erdCalCOFIcufes.das)
BibTeX
@misc{swfsc_cufes,
  title = {CalCOFI Underway CUFES Fish Eggs},
  note  = {License: custom (https://coastwatch.pfeg.noaa.gov/erddap/tabledap/erdCalCOFIcufes.das)}
}

…and the release it came from

CalCOFI (2026). CalCOFI Integrated Database, release v2026.09.05 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.09.05
BibTeX
@misc{calcofi_release_v2026_09_05,
  title     = {CalCOFI Integrated Database, release v2026.09.05},
  author    = {CalCOFI},
  year      = {2026},
  publisher = {Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife},
  url       = {https://calcofi.io/db-schema/?v=v2026.09.05}
}