Containing BackwardsFRAM and 'forward' StockIDs. The BackwardsFRAM table contains additional rows of summed marked and unmarked per-stock; these are NA for forward fields.
lu_chin_stockdata frame (tbl_df) with 116 rows and 11 cols:
character Chinook or NA
integer 5 or NA
numeric forward FRAM stock ID
numeric rarely used, value or NA
numeric rarely used, value or NA
character forward FRAM stock name
character forward FRAM long name
numeric BKFRAM ID
numeric BackwardsFRAM ID of associated total
character definition of return elements used
character string of geographic domain
see vignette 'chinook_lookup_creation'; R7.1 Chinook FRAM project database tables 'Stock' and 'BackwardsFRAM', with derivation in chin_valid_2020.Rmd from FRAMEscapeV2 sheets in ChinRSScalers and Valid2018 workbooks
lu_chin_stock |> dplyr::filter(!is.na(StockID))
#> # A tibble: 78 x 11
#> Species StockVersion StockID ProductionRegionNumb~ ManagementUnitN~ StockName
#> <chr> <int> <dbl> <int> <int> <chr>
#> 1 CHINOOK 5 1 1 1 U-NkSm FF
#> 2 CHINOOK 5 2 1 2 M-NkSm FF
#> 3 CHINOOK 5 3 1 5 U-NK SP ~
#> 4 CHINOOK 5 4 1 6 M-NK Sp ~
#> 5 CHINOOK 5 5 1 9 U-NK Sp ~
#> 6 CHINOOK 5 6 1 10 M-NK Sp ~
#> 7 CHINOOK 5 7 2 1 U-Skag FF
#> 8 CHINOOK 5 8 2 2 M-Skag FF
#> 9 CHINOOK 5 9 2 5 U-SkagFYr
#> 10 CHINOOK 5 10 2 6 M-SkagFYr
#> # ... with 68 more rows, and 5 more variables: StockLongName <chr>,
#> # bkfram_id <dbl>, bkfram_id_tot <dbl>, bk_run_def <chr>, region <chr>