CalCOFI.io CalCOFI.io open data ecosystem

Bottle Derived Products

CalCOFI Bottle Derived Hydrographic Products

calcofi_bottle-derivedCalCOFIunstatedin the release since v2026.10.20

Hydrographic values DERIVED from the CalCOFI Bottle Database rather than measured: spice (spiciness at 0 dbar) and the TEOS-10 sigma-theta at every bottle with a temperature and a salinity, from the start of the record … CalCOFI holds 1,683,346 observations from 34,790 sampling events at 222 stations, 1949–2021, 0–5,351 m.

1949–2021
years
1,683,346
observations
34,790
sampling events
222
stations
2
variables
0–5,351 m
depth
What this is

Hydrographic values DERIVED from the CalCOFI Bottle Database rather than measured: spice (spiciness at 0 dbar) and the TEOS-10 sigma-theta at every bottle with a temperature and a salinity, from the start of the record in 1949, computed from each bottle’s own temperature and salinity after the provider’s quality flags are applied. The bottle database’s own sigma-theta, computed by the legacy DECODR software, stays in the CalCOFI Bottle Database beside it.

Physical Oceanography
Temperature, salinity, density, oxygen, pressure and dynamic height from bottles and CTD casts
st0-ln10_hist · 152 obs · 1955–1972st20-ln10_hist · 374 obs · 1955–1972st40-ln10_hist · 426 obs · 1949–1972st60-ln10_hist · 660 obs · 1949–1972st80-ln10_hist · 660 obs · 1949–1972st100-ln10_hist · 320 obs · 1949–1955st0-ln20_hist · 98 obs · 1949–1949st20-ln20_hist · 1,138 obs · 1949–1972st40-ln20_hist · 762 obs · 1949–1972st60-ln20_hist · 1,518 obs · 1949–1972st80-ln20_hist · 1,066 obs · 1949–1972st100-ln20_hist · 560 obs · 1949–1972st120-ln20_hist · 880 obs · 1949–1972st20-ln30_hist · 474 obs · 1949–1972st40-ln30_hist · 1,730 obs · 1949–1972st60-ln30_hist · 1,474 obs · 1949–1972st80-ln30_hist · 1,440 obs · 1949–1972st100-ln30_hist · 934 obs · 1949–1955st120-ln30_hist · 62 obs · 1949–1949st140-ln30_hist · 98 obs · 1955–1955st40-ln40_hist · 3,422 obs · 1949–1972st60-ln40_hist · 2,946 obs · 1949–1972st80-ln40_hist · 3,786 obs · 1949–1972st100-ln40_hist · 2,170 obs · 1949–1972st120-ln40_hist · 920 obs · 1949–1972st140-ln40_hist · 510 obs · 1949–1972st100-ln50_hist · 2,264 obs · 1949–1972st120-ln50_hist · 2,486 obs · 1949–1972st140-ln50_hist · 1,752 obs · 1949–1971st40-ln55_hist · 1,184 obs · 1951–1987st60-ln55_hist · 21,152 obs · 1949–1987st80-ln55_hist · 5,574 obs · 1949–1987st53-ln60 · 2,736 obs · 1950–2020st60-ln60 · 6,980 obs · 1950–2020st70-ln60 · 6,492 obs · 1949–2020st80-ln60 · 5,774 obs · 1949–2020st90-ln60 · 5,518 obs · 1949–2020st100-ln60 · 3,560 obs · 1949–1984st110-ln60_hist · 4,758 obs · 1949–1972st140-ln60_hist · 2,362 obs · 1949–1972st160-ln60_hist · 992 obs · 1960–1972st180-ln60_hist · 1,210 obs · 1954–1965st200-ln60_hist · 1,194 obs · 1954–1965st52-ln63.3 · 1,492 obs · 1951–2020st55-ln63.3 · 2,834 obs · 1950–2020st60-ln63.3 · 5,214 obs · 1949–2020st70-ln63.3 · 3,430 obs · 1949–2020st80-ln63.3 · 2,008 obs · 1956–2020st90-ln63.3 · 1,630 obs · 1958–2020st100-ln63.3 · 488 obs · 1952–1984st50-ln66.7 · 3,536 obs · 1951–2020st55-ln66.7 · 5,378 obs · 1949–2020st60-ln66.7 · 4,634 obs · 1957–2020st65-ln66.7 · 1,986 obs · 1950–2011st70-ln66.7 · 3,008 obs · 1957–2020st75-ln66.7 · 384 obs · 2007–2011st80-ln66.7 · 2,588 obs · 1957–2020st85-ln66.7 · 364 obs · 2007–2011st90-ln66.7 · 2,064 obs · 1958–2020st95-ln66.7 · 56 obs · 2007–2007st100-ln66.7 · 638 obs · 1958–2007st51-ln70 · 2,344 obs · 1950–2021st55-ln70 · 5,718 obs · 1949–2021st60-ln70 · 7,848 obs · 1950–2021st70-ln70 · 7,808 obs · 1949–2021st80-ln70 · 7,708 obs · 1949–2021st90-ln70 · 9,878 obs · 1949–2020st100-ln70 · 7,604 obs · 1949–1984st140-ln70_hist · 4,472 obs · 1949–1971st160-ln70_hist · 224 obs · 1950–1971st180-ln70_hist · 228 obs · 1950–1965st200-ln70_hist · 1,286 obs · 1950–1972st50-ln73.3 · 1,214 obs · 1950–2020st55-ln73.3 · 5,136 obs · 1949–2020st60-ln73.3 · 9,220 obs · 1949–2020st70-ln73.3 · 3,790 obs · 1949–2020st80-ln73.3 · 2,500 obs · 1955–2020st90-ln73.3 · 2,530 obs · 1955–2020st100-ln73.3 · 518 obs · 1968–1984st49-ln76.7 · 2,972 obs · 1953–2021st51-ln76.7 · 8,706 obs · 1951–2021st55-ln76.7 · 15,066 obs · 1950–2021st60-ln76.7 · 13,274 obs · 1953–2021st70-ln76.7 · 13,724 obs · 1950–2021st80-ln76.7 · 11,632 obs · 1955–2021st90-ln76.7 · 10,978 obs · 1955–2021st100-ln76.7 · 9,264 obs · 1968–2021st50.5-ln80 · 640 obs · 1984–2021st51-ln80 · 6,978 obs · 1951–2021st55-ln80 · 17,616 obs · 1950–2021st60-ln80 · 19,786 obs · 1950–2021st70-ln80 · 19,856 obs · 1950–2021st80-ln80 · 17,262 obs · 1950–2021st90-ln80 · 16,996 obs · 1950–2021st100-ln80 · 13,956 obs · 1949–2021st140-ln80_hist · 1,636 obs · 1949–1972st160-ln80_hist · 584 obs · 1953–1972st180-ln80_hist · 124 obs · 1954–1962st200-ln80_hist · 1,384 obs · 1954–1965st43.5-ln81.7 · 1,246 obs · 1959–2021st46.9-ln81.8 · 15,436 obs · 1953–2021st39.4-ln83.3 · 672 obs · 1953–2021st40.6-ln83.3 · 2,984 obs · 1953–2021st42-ln83.3 · 9,682 obs · 1951–2021st51-ln83.3 · 7,082 obs · 1950–2021st55-ln83.3 · 15,054 obs · 1949–2021st60-ln83.3 · 18,062 obs · 1949–2021st70-ln83.3 · 15,306 obs · 1949–2021st80-ln83.3 · 13,992 obs · 1949–2021st90-ln83.3 · 13,292 obs · 1949–2021st100-ln83.3 · 10,540 obs · 1950–2021st110-ln83.3 · 12,686 obs · 1949–2020st35.8-ln85.4 · 4,022 obs · 1951–2021st33-ln86.7 · 3,092 obs · 1972–2021st35-ln86.7 · 14,182 obs · 1950–2021st40-ln86.7 · 16,738 obs · 1950–2021st45-ln86.7 · 15,262 obs · 1953–2021st50-ln86.7 · 5,544 obs · 1950–2021st55-ln86.7 · 12,616 obs · 1953–2021st60-ln86.7 · 16,488 obs · 1950–2021st70-ln86.7 · 14,518 obs · 1950–2021st80-ln86.7 · 13,040 obs · 1950–2021st90-ln86.7 · 12,160 obs · 1950–2021st100-ln86.7 · 9,386 obs · 1960–2021st110-ln86.7 · 8,134 obs · 1986–2020st32.5-ln86.8 · 892 obs · 1961–2021st30.1-ln88.5 · 1,420 obs · 1974–2021st27.7-ln90 · 762 obs · 1955–2021st28-ln90 · 8,480 obs · 1951–2021st30-ln90 · 18,816 obs · 1950–2021st35-ln90 · 10,178 obs · 1963–2021st37-ln90 · 20,456 obs · 1950–2021st45-ln90 · 22,066 obs · 1949–2021st53-ln90 · 20,860 obs · 1950–2021st60-ln90 · 20,868 obs · 1950–2021st70-ln90 · 21,774 obs · 1950–2021st80-ln90 · 18,138 obs · 1950–2021st90-ln90 · 18,702 obs · 1950–2021st100-ln90 · 14,876 obs · 1950–2021st110-ln90 · 10,964 obs · 1950–2021st120-ln90 · 13,482 obs · 1949–2021st140-ln90_hist · 4,108 obs · 1949–1978st160-ln90_hist · 2,124 obs · 1950–1978st180-ln90_hist · 1,764 obs · 1950–1978st200-ln90_hist · 1,892 obs · 1950–1978st26.4-ln91.7 · 1,848 obs · 1963–2021st26.7-ln93.3 · 4,590 obs · 1951–2021st28-ln93.3 · 13,096 obs · 1952–2021st30-ln93.3 · 22,874 obs · 1950–2021st35-ln93.3 · 10,636 obs · 1958–2021st40-ln93.3 · 18,734 obs · 1949–2021st45-ln93.3 · 10,982 obs · 1949–2021st50-ln93.3 · 18,910 obs · 1949–2021st55-ln93.3 · 10,702 obs · 1949–2021st60-ln93.3 · 17,124 obs · 1949–2021st70-ln93.3 · 16,436 obs · 1949–2021st80-ln93.3 · 16,684 obs · 1949–2021st90-ln93.3 · 15,444 obs · 1949–2021st100-ln93.3 · 12,954 obs · 1949–2021st110-ln93.3 · 10,300 obs · 1949–2021st120-ln93.3 · 10,810 obs · 1949–2021st26.4-ln93.4 · 648 obs · 1975–2021st20-ln100_hist · 2,758 obs · 1951–2003st40-ln100_hist · 52,914 obs · 1949–1988st60-ln100_hist · 41,476 obs · 1949–1988st80-ln100_hist · 29,460 obs · 1949–1984st100-ln100_hist · 10,292 obs · 1949–1984st120-ln100_hist · 3,826 obs · 1949–1972st140-ln100_hist · 586 obs · 1949–1972st160-ln100_hist · 750 obs · 1954–1972st180-ln100_hist · 248 obs · 1954–1972st200-ln100_hist · 174 obs · 1955–1964st0-ln110_hist · 1,206 obs · 1956–1974st20-ln110_hist · 944 obs · 1951–1975st40-ln110_hist · 44,744 obs · 1949–1984st60-ln110_hist · 34,616 obs · 1949–1984st80-ln110_hist · 25,446 obs · 1949–1984st100-ln110_hist · 6,948 obs · 1949–1984st120-ln110_hist · 2,834 obs · 1949–1965st140-ln110_hist · 980 obs · 1949–1965st160-ln110_hist · 524 obs · 1954–1965st180-ln110_hist · 230 obs · 1954–1972st0-ln120_hist · 5,818 obs · 1956–1974st20-ln120_hist · 4,678 obs · 1950–1981st40-ln120_hist · 36,498 obs · 1949–1981st60-ln120_hist · 33,186 obs · 1949–1981st80-ln120_hist · 19,570 obs · 1949–1984st100-ln120_hist · 6,542 obs · 1949–1971st120-ln120_hist · 2,594 obs · 1949–1971st140-ln120_hist · 160 obs · 1954–1972st160-ln120_hist · 210 obs · 1954–1972st-20-ln130_hist · 10 obs · 1957–1957st0-ln130_hist · 4,448 obs · 1956–1974st20-ln130_hist · 3,866 obs · 1951–1981st40-ln130_hist · 31,022 obs · 1950–1981st60-ln130_hist · 21,980 obs · 1950–1981st80-ln130_hist · 5,264 obs · 1950–1972st100-ln130_hist · 1,608 obs · 1950–1972st120-ln130_hist · 2,056 obs · 1949–1972st140-ln130_hist · 596 obs · 1949–1954st-20-ln140_hist · 224 obs · 1956–1974st0-ln140_hist · 3,664 obs · 1956–1974st20-ln140_hist · 5,486 obs · 1950–1978st40-ln140_hist · 17,094 obs · 1950–1978st60-ln140_hist · 9,028 obs · 1950–1978st80-ln140_hist · 2,772 obs · 1950–1972st100-ln140_hist · 748 obs · 1950–1972st120-ln140_hist · 172 obs · 1954–1972st-20-ln150_hist · 854 obs · 1956–1965st0-ln150_hist · 2,960 obs · 1956–1974st20-ln150_hist · 7,466 obs · 1950–1974st40-ln150_hist · 5,572 obs · 1950–1972st60-ln150_hist · 2,692 obs · 1950–1972st80-ln150_hist · 910 obs · 1950–1972st100-ln150_hist · 458 obs · 1950–1972st-40-ln160_hist · 18 obs · 1956–1956st-20-ln160_hist · 1,888 obs · 1956–1974st0-ln160_hist · 2,624 obs · 1950–1972st20-ln160_hist · 1,996 obs · 1950–1972st40-ln160_hist · 1,342 obs · 1950–1972st60-ln160_hist · 802 obs · 1950–1972st80-ln160_hist · 256 obs · 1950–1960135°W130°W125°W120°W115°W110°W105°W20°N25°N30°N35°N40°N45°Nextent continues beyond the frame
222 CalCOFI stations sampled, sized by observations, over the survey grid; the record’s extent continues beyond the frame.

What is in it

1949 · 53,382 obs1950 · 73,604 obs1951 · 22,776 obs1952 · 56,332 obs1953 · 57,424 obs1954 · 36,550 obs1955 · 44,822 obs1956 · 27,470 obs1957 · 37,062 obs1958 · 47,876 obs1959 · 67,378 obs1960 · 53,132 obs1961 · 27,594 obs1962 · 27,318 obs1963 · 24,510 obs1964 · 22,442 obs1965 · 18,102 obs1966 · 23,556 obs1967 · 8,220 obs1968 · 11,388 obs1969 · 47,428 obs1970 · 1,734 obs1971 · 1,590 obs1972 · 59,510 obs1973 · 2,322 obs1974 · 17,176 obs1975 · 48,210 obs1976 · 8,842 obs1977 · 3,484 obs1978 · 49,330 obs1980 · 2,448 obs1981 · 16,008 obs1982 · 1,396 obs1983 · 8,260 obs1984 · 60,950 obs1985 · 14,706 obs1986 · 18,078 obs1987 · 31,398 obs1988 · 29,734 obs1989 · 18,760 obs1990 · 15,388 obs1991 · 15,996 obs1992 · 16,796 obs1993 · 16,098 obs1994 · 15,566 obs1995 · 15,442 obs1996 · 17,234 obs1997 · 16,758 obs1998 · 24,340 obs1999 · 15,598 obs2000 · 15,558 obs2001 · 15,628 obs2002 · 15,562 obs2003 · 17,184 obs2004 · 15,516 obs2005 · 15,866 obs2006 · 16,208 obs2007 · 16,374 obs2008 · 16,484 obs2009 · 17,044 obs2010 · 15,892 obs2011 · 17,134 obs2012 · 14,740 obs2013 · 16,570 obs2014 · 13,272 obs2015 · 15,762 obs2016 · 17,872 obs2017 · 16,784 obs2018 · 15,142 obs2019 · 12,378 obs2020 · 11,762 obs2021 · 3,096 obs19501960197019801990200020102020
Observations per year, 1949–2021.
2 variables · sigma_theta_teos10, spiciness0 units and counts

obs_env profile · one value at each depth of a cast · 1,683,346 values · 1949–2021 · 2 variables

sigma_theta_teos10 kg/m3 841,673spiciness0 kg/m3 841,673

Every month of the year · extent 18.4–47.9°N, 164.1–106.0°W · 1949-02 to 2021-02

Ways in

Explorerdb-queryOriginal at CalCOFI.orgParquetSTACIngest notebookAs JSON

Every endpoint 21 · explore 4, get the data 2, code 4, metadata records 5, archives & portals 6

Every endpoint this dataset can be reached through, grouped by how you would use it. Each name is the link; the copy button beside it copies the address. Everything is in the release record and was answered when the release was cut.

Apps that read this dataset from the release. The icons after a name are the app’s lenses — the spatial grain it shows the data at.

CalCOFI ExplorerAcross datasetsopens on this dataset
Station ExplorerAcross datasetsopens on this dataset
Hexagon ExplorerAcross datasetsopens on this dataset
Cruise ExplorerAcross datasetsopens on this dataset
Cite CalCOFI, 2026

This dataset's own citation. What to cite, and how, is a chapter of the docs book.

CalCOFI. (2026). CalCOFI Bottle Derived Hydrographic Products (from the CalCOFI Bottle Database 194903-202105). CalCOFI.io. https://calcofi.io/workflows/ingest_calcofi_bottle-derived.html
BibTeX 
@misc{calcofi_bottle-derived,
  title        = {CalCOFI Bottle Derived Hydrographic Products},
  howpublished = {CalCOFI. (2026). CalCOFI Bottle Derived Hydrographic Products (from the CalCOFI Bottle Database 194903-202105). CalCOFI.io. https://calcofi.io/workflows/ingest_calcofi_bottle-derived.html},
  year         = {2026}
}

…and the release it came from

CalCOFI (2026). CalCOFI Integrated Database, release v2026.10.21 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.10.21
BibTeX 
@misc{calcofi_release_v2026_10_21,
  title     = {CalCOFI Integrated Database, release v2026.10.21},
  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.10.21}
}
Provenance source read 2026-10-21 · 2 release tables · 1 changed in v2026.10.21
source accessed
2026-10-21
release tables
obsmeasurement_type

What changed in v2026.10.21

  • obs 23.5 MB · since v2026.10.20

release changelog ↗

Open questions for the provider 1 on this dataset · 4 open in all
  • Q01 the dataset — proposed

Each is a field the record proposes and the provider has not yet confirmed.

Keywords 3 GCMD

DensityWater temperatureOcean salinity

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.

© 2026 CalCOFI · calcofi.io