Data library / L14
L14 Okanagan sockeye run timing
Manual
The file is Wells Dam daily adult sockeye counts and fishway water temperature, 1977 to 2026, from DART. Wells Dam counts include fish bound for other rivers, so Canadian arrivals are lower. Say which number you are quoting. A blank count is a day with no sockeye reported. Five days carry small negative counts exactly as DART publishes them, and 27 impossible temperatures were removed; both are tagged in the qc column. The Okanagan-specific timing is in the other three files, from public DFO and peer-reviewed sources: when fish pass Zosel Dam into Osoyoos Lake, how long they hold there, when they reach the spawning grounds near Oliver, and when fry emerge and smolts leave. Half the run passes Wells about 20 July, Zosel about 2 August, and reaches the spawning grounds about 14 October. The raw daily survey records behind the tables are not public and are not on this site.
- What it contains, and where it is
- Wells Dam adult counts, public on Columbia River DART. Counts at Wells include fish bound for other rivers, so Canadian arrivals are lower. Okanagan-specific timing is held by ONA; ask the instructor before relying on it
- Stage it helps
- 3, test it
Download
The same data in two formats. CSV opens anywhere; Excel opens without a conversion dialogue.
- L14_wells_dam_sockeye_daily_20261015.csvCSVExcel
- L14_okanagan_sockeye_timing_20261016.csvCSVExcel
Life-history timing from Columbia mouth to smolt outmigration, 22 rows. timing_as_published is the source's words; the date columns are filled only where the source prints a date. basis says whether a row is observed, a description, or a management period.
- L14_zosel_dam_annual_passage_20261016.csvCSVExcel
Zosel Dam (Osoyoos Lake outlet) adult sockeye, the 17 years with daily counts, 1937 to 2016, July to September: first and last count date, mean and maximum daily count, total. 1993 exceeds the Wells count and is tagged in note.
- L14_okanagan_river_spawner_surveys_20261016.csvCSVExcel
Weekly spawning-ground surveys near Oliver, 2000 to 2018: first and last survey date and weekly counts. sum_of_weekly_counts counts a fish once for every week it is seen, so it is not a number of fish.
Where to get it
https://www.cbr.washington.edu/dart/query/adult_daily
https://waves-vagues.dfo-mpo.gc.ca/library-bibliotheque/40898829.pdf
https://pmc.ncbi.nlm.nih.gov/articles/PMC11549111/
https://a100.gov.bc.ca/pub/acat/documents/r53493/1.2018FisheriesTimingWindowsUpdate_1519080202110_9079782445.pdf
Part of this row has no public link and is not on this site. The note above says who holds it.