CalCOFI.io CalCOFI.io open data ecosystem

Hydrographic Bottle

CalCOFI Bottle Database

calcofi_bottleCalCOFICC BY 4.0in the release since v2026.05.19ingested

Hydrographic bottle data including temperature, salinity, oxygen, nutrients, pigments, and C14 from CalCOFI cruises. CalCOFI holds 11,135,334 observations from 35,643 sampling events at 222 stations, 1949–2021, 0–5,351 m.

1949–2021
years
11,135,334
observations
35,643
sampling events
222
stations
41
variables
0–5,351 m
depth
What this is

Hydrographic bottle data including temperature, salinity, oxygen, nutrients, pigments, and C14 from CalCOFI cruises. The provider publishes it as two linked files: Cast, one row per hydrographic cast (the rosette the bottles came up on: date, position, weather, bottom depth), and Bottle, one row per bottle depth. That cast is not the CTD Cast Files dataset (calcofi_ctd-cast), although both come from the same station visit.

This record ends in 2021. From 2022 on, the bottle values are the btl_* variables of CTD Cast Files (calcofi_ctd-cast) — 7 of this dataset’s variables (chlorophyll_a, nitrate, nitrite, phaeopigment, phosphate, silicate, temperature), through 2026.

Physical Oceanography
Temperature, salinity, density, oxygen, pressure and dynamic height from bottles and CTD casts
st0-ln10_hist · 722 obs · 1955–1972st20-ln10_hist · 2,075 obs · 1955–1972st40-ln10_hist · 2,159 obs · 1949–1972st60-ln10_hist · 3,567 obs · 1949–1972st80-ln10_hist · 3,615 obs · 1949–1972st100-ln10_hist · 1,871 obs · 1949–1955st0-ln20_hist · 571 obs · 1949–1949st20-ln20_hist · 6,278 obs · 1949–1972st40-ln20_hist · 4,450 obs · 1949–1972st60-ln20_hist · 8,315 obs · 1949–1972st80-ln20_hist · 6,187 obs · 1949–1972st100-ln20_hist · 3,002 obs · 1949–1972st120-ln20_hist · 5,274 obs · 1949–1972st20-ln30_hist · 2,791 obs · 1949–1972st40-ln30_hist · 9,685 obs · 1949–1972st60-ln30_hist · 8,205 obs · 1949–1972st80-ln30_hist · 8,169 obs · 1949–1972st100-ln30_hist · 5,318 obs · 1949–1955st120-ln30_hist · 337 obs · 1949–1949st140-ln30_hist · 527 obs · 1955–1955st40-ln40_hist · 18,951 obs · 1949–1972st60-ln40_hist · 15,726 obs · 1949–1972st80-ln40_hist · 20,289 obs · 1949–1972st100-ln40_hist · 11,935 obs · 1949–1972st120-ln40_hist · 5,149 obs · 1949–1972st140-ln40_hist · 2,624 obs · 1949–1972st100-ln50_hist · 11,973 obs · 1949–1972st120-ln50_hist · 13,870 obs · 1949–1972st140-ln50_hist · 10,199 obs · 1949–1971st40-ln55_hist · 6,295 obs · 1951–1987st60-ln55_hist · 109,188 obs · 1949–1987st80-ln55_hist · 28,481 obs · 1949–1987st53-ln60 · 17,491 obs · 1950–2020st60-ln60 · 40,856 obs · 1950–2020st70-ln60 · 37,423 obs · 1949–2020st80-ln60 · 33,832 obs · 1949–2020st90-ln60 · 32,111 obs · 1949–2020st100-ln60 · 21,130 obs · 1949–1984st110-ln60_hist · 27,326 obs · 1949–1972st140-ln60_hist · 13,499 obs · 1949–1972st160-ln60_hist · 5,495 obs · 1960–1972st180-ln60_hist · 7,043 obs · 1954–1965st200-ln60_hist · 6,983 obs · 1954–1965st52-ln63.3 · 9,085 obs · 1951–2020st55-ln63.3 · 17,093 obs · 1950–2020st60-ln63.3 · 30,971 obs · 1949–2020st70-ln63.3 · 20,257 obs · 1949–2020st80-ln63.3 · 11,516 obs · 1956–2020st90-ln63.3 · 9,340 obs · 1958–2020st100-ln63.3 · 3,483 obs · 1952–1984st50-ln66.7 · 22,920 obs · 1951–2020st55-ln66.7 · 32,215 obs · 1949–2020st60-ln66.7 · 27,953 obs · 1957–2020st65-ln66.7 · 11,389 obs · 1950–2011st70-ln66.7 · 17,968 obs · 1957–2020st75-ln66.7 · 2,259 obs · 2007–2011st80-ln66.7 · 15,846 obs · 1956–2020st85-ln66.7 · 2,145 obs · 2007–2011st90-ln66.7 · 12,544 obs · 1958–2020st95-ln66.7 · 403 obs · 2007–2007st100-ln66.7 · 4,058 obs · 1958–2007st51-ln70 · 14,140 obs · 1950–2021st55-ln70 · 34,402 obs · 1949–2021st60-ln70 · 47,226 obs · 1950–2021st70-ln70 · 46,323 obs · 1949–2021st80-ln70 · 45,665 obs · 1949–2021st90-ln70 · 57,286 obs · 1949–2020st100-ln70 · 45,439 obs · 1949–1984st140-ln70_hist · 25,849 obs · 1949–1971st160-ln70_hist · 1,455 obs · 1950–1971st180-ln70_hist · 1,298 obs · 1950–1965st200-ln70_hist · 7,221 obs · 1950–1972st50-ln73.3 · 8,225 obs · 1950–2020st55-ln73.3 · 31,650 obs · 1949–2020st60-ln73.3 · 53,878 obs · 1949–2020st70-ln73.3 · 22,825 obs · 1949–2020st80-ln73.3 · 15,357 obs · 1955–2020st90-ln73.3 · 15,423 obs · 1955–2020st100-ln73.3 · 3,733 obs · 1968–1984st49-ln76.7 · 26,056 obs · 1953–2021st51-ln76.7 · 69,109 obs · 1951–2021st55-ln76.7 · 109,097 obs · 1950–2021st60-ln76.7 · 100,101 obs · 1952–2021st70-ln76.7 · 103,626 obs · 1950–2021st80-ln76.7 · 93,007 obs · 1955–2021st90-ln76.7 · 88,079 obs · 1955–2021st100-ln76.7 · 78,668 obs · 1968–2021st50.5-ln80 · 5,517 obs · 1984–2021st51-ln80 · 49,096 obs · 1951–2021st55-ln80 · 125,055 obs · 1950–2021st60-ln80 · 143,633 obs · 1950–2021st70-ln80 · 137,983 obs · 1950–2021st80-ln80 · 123,436 obs · 1950–2021st90-ln80 · 121,822 obs · 1950–2021st100-ln80 · 106,443 obs · 1949–2021st140-ln80_hist · 9,191 obs · 1949–1972st160-ln80_hist · 3,317 obs · 1953–1972st180-ln80_hist · 697 obs · 1954–1962st200-ln80_hist · 7,792 obs · 1954–1965st43.5-ln81.7 · 8,412 obs · 1959–2021st46.9-ln81.8 · 114,866 obs · 1953–2021st39.4-ln83.3 · 5,242 obs · 1953–2021st40.6-ln83.3 · 23,892 obs · 1953–2021st42-ln83.3 · 68,847 obs · 1951–2021st51-ln83.3 · 51,704 obs · 1950–2021st55-ln83.3 · 109,234 obs · 1949–2021st60-ln83.3 · 124,389 obs · 1949–2021st70-ln83.3 · 113,677 obs · 1949–2021st80-ln83.3 · 103,729 obs · 1949–2021st90-ln83.3 · 100,514 obs · 1949–2021st100-ln83.3 · 88,537 obs · 1950–2021st110-ln83.3 · 97,081 obs · 1949–2020st35.8-ln85.4 · 19,144 obs · 1951–2021st33-ln86.7 · 25,864 obs · 1972–2021st35-ln86.7 · 106,519 obs · 1950–2021st40-ln86.7 · 123,270 obs · 1950–2021st45-ln86.7 · 110,267 obs · 1953–2021st50-ln86.7 · 40,985 obs · 1950–2021st55-ln86.7 · 94,384 obs · 1953–2021st60-ln86.7 · 116,418 obs · 1950–2021st70-ln86.7 · 108,200 obs · 1950–2021st80-ln86.7 · 100,311 obs · 1950–2021st90-ln86.7 · 94,254 obs · 1950–2021st100-ln86.7 · 79,464 obs · 1960–2021st110-ln86.7 · 69,957 obs · 1951–2020st32.5-ln86.8 · 7,140 obs · 1961–2021st30.1-ln88.5 · 8,566 obs · 1974–2021st27.7-ln90 · 6,564 obs · 1955–2021st28-ln90 · 58,209 obs · 1951–2021st30-ln90 · 134,739 obs · 1950–2021st35-ln90 · 84,691 obs · 1963–2021st37-ln90 · 141,691 obs · 1950–2021st45-ln90 · 155,263 obs · 1949–2021st53-ln90 · 145,986 obs · 1950–2021st60-ln90 · 148,583 obs · 1950–2021st70-ln90 · 153,603 obs · 1950–2021st80-ln90 · 131,614 obs · 1950–2021st90-ln90 · 136,060 obs · 1950–2021st100-ln90 · 115,809 obs · 1950–2021st110-ln90 · 89,783 obs · 1950–2021st120-ln90 · 106,176 obs · 1949–2021st140-ln90_hist · 24,669 obs · 1949–1978st160-ln90_hist · 13,497 obs · 1950–1978st180-ln90_hist · 11,356 obs · 1950–1978st200-ln90_hist · 11,429 obs · 1950–1978st26.4-ln91.7 · 9,867 obs · 1963–2021st26.7-ln93.3 · 38,888 obs · 1951–2021st28-ln93.3 · 97,089 obs · 1952–2021st30-ln93.3 · 156,354 obs · 1950–2021st35-ln93.3 · 87,131 obs · 1958–2021st40-ln93.3 · 129,574 obs · 1949–2021st45-ln93.3 · 91,670 obs · 1949–2021st50-ln93.3 · 134,201 obs · 1949–2021st55-ln93.3 · 85,186 obs · 1949–2021st60-ln93.3 · 124,433 obs · 1949–2021st70-ln93.3 · 119,832 obs · 1949–2021st80-ln93.3 · 125,112 obs · 1949–2021st90-ln93.3 · 115,391 obs · 1949–2021st100-ln93.3 · 101,547 obs · 1949–2021st110-ln93.3 · 85,822 obs · 1949–2021st120-ln93.3 · 88,625 obs · 1949–2021st26.4-ln93.4 · 5,975 obs · 1951–2021st20-ln100_hist · 15,235 obs · 1951–2003st40-ln100_hist · 294,261 obs · 1949–1988st60-ln100_hist · 227,629 obs · 1949–1988st80-ln100_hist · 166,283 obs · 1949–1984st100-ln100_hist · 63,429 obs · 1949–1984st120-ln100_hist · 22,687 obs · 1949–1972st140-ln100_hist · 2,835 obs · 1949–1972st160-ln100_hist · 4,075 obs · 1954–1972st180-ln100_hist · 1,237 obs · 1954–1972st200-ln100_hist · 1,129 obs · 1955–1964st0-ln110_hist · 9,411 obs · 1956–1974st20-ln110_hist · 5,711 obs · 1951–1975st40-ln110_hist · 248,216 obs · 1949–1984st60-ln110_hist · 195,835 obs · 1949–1984st80-ln110_hist · 144,325 obs · 1949–1984st100-ln110_hist · 43,307 obs · 1949–1984st120-ln110_hist · 16,018 obs · 1949–1965st140-ln110_hist · 5,173 obs · 1949–1965st160-ln110_hist · 2,775 obs · 1954–1965st180-ln110_hist · 942 obs · 1954–1972st0-ln120_hist · 37,266 obs · 1956–1974st20-ln120_hist · 24,813 obs · 1950–1981st40-ln120_hist · 193,328 obs · 1949–1981st60-ln120_hist · 181,647 obs · 1949–1981st80-ln120_hist · 107,149 obs · 1949–1984st100-ln120_hist · 37,633 obs · 1949–1971st120-ln120_hist · 14,772 obs · 1949–1971st140-ln120_hist · 570 obs · 1954–1972st160-ln120_hist · 1,054 obs · 1954–1972st-20-ln130_hist · 55 obs · 1957–1957st0-ln130_hist · 27,113 obs · 1956–1974st20-ln130_hist · 19,563 obs · 1951–1981st40-ln130_hist · 166,126 obs · 1950–1984st60-ln130_hist · 119,856 obs · 1950–1981st80-ln130_hist · 29,770 obs · 1950–1972st100-ln130_hist · 8,995 obs · 1950–1972st120-ln130_hist · 11,425 obs · 1949–1972st140-ln130_hist · 3,361 obs · 1949–1954st-20-ln140_hist · 1,359 obs · 1956–1974st0-ln140_hist · 21,394 obs · 1956–1974st20-ln140_hist · 30,120 obs · 1950–1978st40-ln140_hist · 97,051 obs · 1950–1978st60-ln140_hist · 51,940 obs · 1950–1978st80-ln140_hist · 16,018 obs · 1950–1972st100-ln140_hist · 4,092 obs · 1950–1972st120-ln140_hist · 602 obs · 1954–1972st-20-ln150_hist · 4,871 obs · 1956–1965st0-ln150_hist · 17,037 obs · 1956–1974st20-ln150_hist · 41,543 obs · 1950–1984st40-ln150_hist · 30,914 obs · 1950–1972st60-ln150_hist · 15,623 obs · 1950–1972st80-ln150_hist · 5,227 obs · 1950–1972st100-ln150_hist · 2,467 obs · 1950–1972st-40-ln160_hist · 99 obs · 1956–1956st-20-ln160_hist · 10,251 obs · 1956–1974st0-ln160_hist · 14,348 obs · 1950–1972st20-ln160_hist · 10,710 obs · 1950–1972st40-ln160_hist · 7,742 obs · 1950–1972st60-ln160_hist · 4,900 obs · 1950–1972st80-ln160_hist · 1,441 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 · 305,760 obs1950 · 422,155 obs1951 · 215,270 obs1952 · 305,001 obs1953 · 272,875 obs1954 · 135,189 obs1955 · 243,573 obs1956 · 148,233 obs1957 · 197,421 obs1958 · 251,586 obs1959 · 364,888 obs1960 · 291,838 obs1961 · 159,579 obs1962 · 153,496 obs1963 · 139,276 obs1964 · 126,770 obs1965 · 93,722 obs1966 · 131,183 obs1967 · 36,897 obs1968 · 54,081 obs1969 · 247,283 obs1970 · 12,453 obs1971 · 10,753 obs1972 · 292,190 obs1973 · 18,468 obs1974 · 88,755 obs1975 · 185,186 obs1976 · 31,601 obs1977 · 25,574 obs1978 · 385,153 obs1980 · 8,574 obs1981 · 77,974 obs1982 · 7,294 obs1983 · 56,798 obs1984 · 515,957 obs1985 · 121,796 obs1986 · 147,249 obs1987 · 212,836 obs1988 · 199,840 obs1989 · 155,986 obs1990 · 128,991 obs1991 · 133,493 obs1992 · 140,703 obs1993 · 135,094 obs1994 · 129,577 obs1995 · 127,696 obs1996 · 141,910 obs1997 · 136,642 obs1998 · 186,443 obs1999 · 129,406 obs2000 · 129,691 obs2001 · 129,731 obs2002 · 128,721 obs2003 · 141,315 obs2004 · 128,881 obs2005 · 130,903 obs2006 · 132,675 obs2007 · 133,494 obs2008 · 147,935 obs2009 · 153,833 obs2010 · 140,958 obs2011 · 153,672 obs2012 · 134,741 obs2013 · 149,705 obs2014 · 121,747 obs2015 · 141,630 obs2016 · 156,965 obs2017 · 149,553 obs2018 · 132,552 obs2019 · 111,999 obs2020 · 100,504 obs2021 · 43,661 obs19501960197019801990200020102020
Observations per year, 1949–2021.
41 variables · alkalinity_rep1, ammonia, c14_dark, c14_mean, c14_rep1, c14_rep2, chlorophyll_a, dic_rep1, light_pct, nitrate … all 41

obs_env profile · one value at each depth of a cast · 11,135,334 values · 1949–2021 · 26 variables

alkalinity_rep1 umol/kg 2,084ammonia umol/L 90,489c14_dark mgC/m3/hld 23,759c14_mean mgC/m3/hld 23,760c14_rep1 mgC/m3/hld 15,542c14_rep2 mgC/m3/hld 15,524chlorophyll_a ug/L 245,656dic_rep1 umol/kg 1,999light_pct % 19,767nitrate umol/L 364,982nitrite umol/L 364,432oxygen_ml_l ml/L 725,612oxygen_saturation % 690,728oxygen_umol_kg umol/kg 690,680phaeopigment ug/L 245,655phosphate umol/L 440,899r_ammonium umol/L 90,509r_depth m 895,353r_dynamic_height dyn m 848,666r_oxygen_umol_kg umol/kg 690,681r_salinity_sva 10^-8 m3/kg 842,551r_temperature degC 849,300salinity PSS-78 847,996sigma_theta kg/m3 842,652silicate umol/L 381,675temperature degC 884,383

sample_measurement per cast · one value for the whole cast or tow, at no depth · 268,871 values on 35,467 sampling events · 1949–2021 · 15 variables

wind_direction degrees 34,166wind_speed knots 33,964bottom_depth m 33,362weather_code 27,450dry_air_temp degC 20,308barometric_pressure millibars 20,302wet_air_temp degC 20,226wave_direction degrees 13,195wave_height feet 12,740cloud_amount oktas 12,520wave_period seconds 12,267cloud_type 10,456visibility 10,149secchi_depth meters 5,689water_color Forel-Ule 2,077

Also contributes to · Carbonate System (2) · Nutrients & Chemistry (6) · Productivity & Pigments (7) which variables
  • Carbonate System — alkalinity_rep1, dic_rep1
  • Nutrients & Chemistry — ammonia, nitrate, nitrite, phosphate, r_ammonium, silicate
  • Productivity & Pigments — c14_dark, c14_mean, c14_rep1, c14_rep2, chlorophyll_a, light_pct, phaeopigment

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

Ways in

Explorerdb-queryOriginal at CalCOFI.orgERDDAPParquetnetCDFSTACIngest notebookcalcofi.orgAs JSON

Every endpoint 33 · explore 7, get the data 6, code 6, metadata records 7, archives & portals 7

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
Contour ExplorerAcross datasets
Hypoxia StoryStudent contribution
Capstone AppStudent contribution
Cite CalCOFI, 2023

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

CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org.
License: CC-BY-4.0
BibTeX 
@misc{calcofi_bottle,
  title        = {CalCOFI Bottle Database},
  howpublished = {CalCOFI. (2023). CalCOFI Bottle Database 194903-202105. CalCOFI.org.},
  year         = {2023},
  note         = {License: CC-BY-4.0}
}

…and the release it came from

CalCOFI (2026). CalCOFI Integrated Database, release v2026.11.05 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://calcofi.io/db-schema/?v=v2026.11.05
BibTeX 
@misc{calcofi_release_v2026_11_05,
  title     = {CalCOFI Integrated Database, release v2026.11.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.11.05}
}
Provenance source read 2026-11-04 · 4 release tables · 2 changed in v2026.11.05 · 12 source files
source accessed
2026-11-04
record updated
2026-09-07
archive of record
Archive of record: none yet — a CalCOFI program dataset with no DOI-bearing deposit. EDI is the planned archive (the package is built from each release and staged for review; the deposit waits on the EDI account); NCEI planned through the SWFSC data manager. OBIS does not apply (no occurrences). Mirrored on NOAA CoastWatch ERDDAP.

What changed in v2026.11.05

Source files

The original inputs the ingest notebook read, mirrored nightly from the shared Drive to the public files bucket — 12 files, 433 MB.

release changelog ↗

Open questions for the provider 1 on this dataset · 6 open in all
  • Q11 pi_names — proposed

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

Keywords 12 GCMD

Water temperatureOcean salinityOxygenNutrientsChlorophyllCalCOFI NetworkTemperatureSalinityDissolved OxygenDissolved NutrientsOcean Acidification and HypoxiaPhytoplankton Biomass and Diversity

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