Unclipped Spring Chinook Cohort Juvenile Migration Timing and Conditions Graph and Table

Migration Timing Characteristics
Juvenile Unclipped Spring Chinook at Sacramento Trawls (Raw Catch), 10/1 - 9/30
Brood Year 2007 - 2020

Brood Year	Sampling Dates (MM/DD/YYYY)									Duration Middle 80% Days	Duration Middle 50% Days	Duration Middle 90% Days	Run Size	"Today" (08/07) %	View Data (opens new window)
	First	5%	10%	25%	50%	75%	90%	95%	Last
Brood Year	First	5%	10%	25%	50%	75%	90%	95%	Last	Duration Middle 80% Days	Duration Middle 50% Days	Duration Middle 90% Days	Run Size	"Today" (08/07) %	View Data (opens new window)
	Sampling Dates (MM/DD/YYYY)
2021 1 YTD	12/26/2021								05/16/2022				99 (YTD)		Graph w/Table
Average (2007 - 2020)	01/06	02/22	03/06	03/25	04/10	04/19	04/24	04/27	05/10	51	27	64	475	100.0%
Average 95% CI	12/18-01/25	01/30-03/16	02/11-03/28	03/07-04/11	04/06-04/13	04/15-04/22	04/20-04/27	04/23-04/30	05/02-05/17				78-871	100.0-100.0%
Median (2007 - 2020)	01/09	03/02	03/24	04/03	04/12	04/20	04/26	04/27	05/08	36	18	58	241	100%
Median 95% CI	12/05-02/11	02/04-04/01	02/22-04/03	03/24-04/13	04/07-04/16	04/16-04/24	04/19-05/02	04/22-05/03	05/04-05/11				148-676	100-100%
2020	02/04/2021	02/25/2021	03/29/2021	04/11/2021	04/12/2021	04/22/2021	04/29/2021	04/29/2021	04/29/2021	32	12	64	89	100.0%	Graph w/Table
2019	12/12/2019	03/31/2020	04/02/2020	04/05/2020	04/06/2020	04/10/2020	04/16/2020	04/20/2020	05/10/2020	15	6	21	676	100.0%	Graph w/Table
2018	12/03/2018	02/04/2019	03/01/2019	03/31/2019	04/09/2019	04/21/2019	04/23/2019	04/26/2019	05/09/2019	54	22	82	489	100.0%	Graph w/Table
2017	02/15/2018	03/04/2018	03/15/2018	03/24/2018	04/11/2018	04/16/2018	04/20/2018	04/27/2018	05/11/2018	37	24	55	148	100.0%	Graph w/Table
2016	11/23/2016	03/28/2017	04/01/2017	04/05/2017	04/12/2017	05/01/2017	05/05/2017	05/07/2017	06/21/2017	35	27	41	2,741	100.0%	Graph w/Table
2015	01/11/2016	03/25/2016	03/30/2016	04/01/2016	04/13/2016	04/15/2016	04/15/2016	04/18/2016	05/06/2016	17	15	25	205	100.0%	Graph w/Table
2014	12/05/2014	12/08/2014	12/15/2014	12/24/2014	03/27/2015	04/17/2015	04/27/2015	04/29/2015	04/29/2015	135	116	144	66	100.0%	Graph w/Table
2013	02/11/2014	02/15/2014	02/22/2014	03/07/2014	04/07/2014	04/11/2014	04/14/2014	04/18/2014	05/13/2014	52	36	63	753	100.0%	Graph w/Table
2012	12/03/2012	04/01/2013	04/01/2013	04/10/2013	04/17/2013	04/19/2013	04/19/2013	04/22/2013	05/07/2013	19	10	22	410	100.0%	Graph w/Table
2011	01/25/2012	03/16/2012	03/19/2012	03/30/2012	03/30/2012	04/18/2012	04/25/2012	04/25/2012	05/03/2012	38	20	41	258	100.0%	Graph w/Table
2010	12/08/2010	12/20/2010	01/03/2011	04/13/2011	04/20/2011	04/22/2011	04/27/2011	04/27/2011	05/10/2011	115	10	130	350	100.0%	Graph w/Table
2009	02/03/2010	03/01/2010	04/09/2010	04/16/2010	04/16/2010	04/23/2010	04/30/2010	04/30/2010	05/11/2010	22	8	61	169	100.0%	Graph w/Table
2008	02/23/2009	04/02/2009	04/10/2009	04/15/2009	04/16/2009	04/24/2009	05/02/2009	05/07/2009	05/07/2009	23	10	36	224	100.0%	Graph w/Table
2007	01/07/2008	01/07/2008	01/11/2008	02/27/2008	04/14/2008	04/25/2008	05/02/2008	05/02/2008	05/02/2008	113	59	117	67	100.0%	Graph w/Table

Notes:

1. Brood Year 2021 is incomplete. Data presented in Migration Timing Characteristics table is data through today's date.
2. Brood Year 2022 has not started. Data presented in Migration Timing Characteristics table is data through today's date.
3. Data Courtesy of USFWS, Lodi
4. Date Calculations:
   1. Query database for sampling/passage estimates for requested number of years, species, run, and location.
   2. Based on brood year assignment at Red Bluff, regroup calendar year based data into brood year based data for Chinook.
      • Winter, July-June
      • Spring, October-September
      • Fall, December-November
      • LateFall, April-March
   3. Based on query results, calculate total number of fish for each brood year (reported as "Run Size" in table).
   4. Based on query results, calculate cumulative number of fish by day in the year.
   5. Based on query results, calculate the Day of Year when fish passage % is equal to or greater than the target percent, e.g., 5% passage. Passage % for a day = cumulative number of fish for day / total fish in year.
   6. For each individual year target passage percent, first date, and last date results: convert Day of Year to Calendar Date for given year, taking into consideration leap year. Report calendar date in table.
   7. For each individual year middle run duration: 80% duration = 1 + (90% Day of Year - 10% Day of Year), 50% duration = 1 + (75% Day of Year - 25% Day of Year), 90% duration = 1 + (95% Day of Year - 5% Day of Year). Report days in table.
   8. For each target passage percent, first date, and last date: calculate average Day of Year for that passage target percent from each individual year Day of Year values. Convert result into integer. Treat integer as Day of Year and convert into Calendar Date for a non-leap year. Report as Average.
   9. For each target passage percent, first date, and last date: calculate median Day of Year for that passage target percent from individual Day of Year values. Convert median Day of Year into Calendar Date for a non-leap year. Report as Median.
   10. Individual year calendar date values reported in table honor leap year. Calculated calendar date values (Average and Median) treat results as non-leap year dates.