Description of the dataframes present in the database:
metadata: Table with summarized metadata (only available in newer versions starting from v4.40)
stock: This stores the stock database table
assessment: This stores the assessment database table
taxonomy: This stores the taxonomy database table
management: This stores the management database table
assessor: This stores the assessor database table
assessmetod: This stores the assessmetod database table
area: This stores the area database table
biometrics: This stores the biometrics database table
tsmetrics: This stores the tsmetrics database table
timeseries: The time series data is a matrix object with the following headers/columns: (1) assessid (2) stockid (3) stocklong (4) tsid (5) tsyear (6) tsvalue
bioparams: The parameter data is a matrix object with the following headers/columns: (1) assessid (2) stockid (3) stocklong (4) bioid (5) biovalue (6) bioyear (7) bionotes
timeseries_values_views: This stores the timeseries values with timeseries type along the columns and stocks along the rows
timeseries_units_views: This stores the timeseries values with timeseries type along the columns and stocks along the rows
timeseries_ids_views: This stores the timeseries IDs with timeseries type along the columns and stocks along the rows
timeseries_assessments_views: This stores the timeseries assessments with timeseries type along the columns and stocks along the rows
timeseries_notes_views: This stores the timeseries notes with timeseries type along the columns and stocks along the rows
timeseries_sources_views: This stores the timeseries sources with timeseries type along the columns and stocks along the rows
timeseries_years_views: This stores the timeseries years with timeseries type along the columns and stocks along the rows
bioparams_values_views: This stores the reference point values, with reference point type along the columns and stocks along the rows
bioparams_units_views: This stores the reference point units, with reference point type along the columns and stocks along the rows
bioparams_ids_views: This stores the reference point IDs, with reference point type along the columns and stocks along the rows
bioparams_assessments_views: This stores the reference point assessments, with reference point type along the columns and stocks along the rows
bioparams_sources_views: This stores the reference point sources, with reference point type along the columns and stocks along the rows
bioparams_notes_views: This stores the reference point notes, with reference point type along the columns and stocks along the rows
Newer Versions (v4.40 onwards) also contain tables of individual most-used time series:
tb.data: Total Biomass
ssb.data: Spawning Stock Biomass
tn.data: Total Abundance
r.data: Recruits
tc.data: Total Catch
tl.data: Total Landings
recc.data: Recreational Catch
f.data: Fishing Mortality
er.data: Exploitation Rate
divtb.data: TB/TBmsy
divssb.data: SSB/SSBmsy
ivf.data: F/Fmsy
diver.data: ER/ERmsy
divbpref.data: B/Bmsypref
divupref.data: U/Umsypref
tbbest.data: TBbest
tcbest.data: TCbest
erbest.data: ERbest
divtb.mgt.data: TB/TBmgt
divssb.mgt.data: SSB/SSBmgt
divf.mgt.data: F/Fmgt
diver.mgt.data: ER/ERmgt
divbpref.mgt.data: B/Bmgtpref
divupref.mgt.data: U/Umgtpref
cpair.data: Cpair
tac.data: TAC
cadv.data: Cadvised
survb.data: survB
cpue.data: CPUE
effort.data: EFFORT
Stock Summary Description
Information Contained in the Stock Summary Documents
A list of all stocks present in the region
specifies whether the stock includes B/Bmsy, U/Umsy, B/Bmgt, and U/Umgt time series data
specifies whether TB or SSB is preferred, and whether ER or F is preferred, if both types are present
Kobe plot (MSYpref) – Plots U/Umsy vs. B/Bmsy if available, filling in gaps with U/Umgt and B/Bmgt if available
Kobe plot (MGTpref) – Plots U/Umgt vs. B/Bmgt if available, filling in gaps with U/Umsy and B/Bmsy if available
Spawner Recruitment – Plots recruits vs. spawning-stock biomass
Surplus Production – Plots annual surplus production vs. total biomass
Total Biomass – Preferably plots the most recent TB time series from an assessment with a MSY, management target, or limit reference point available, otherwise plots most recent TB time series.
Spawning stock biomass – Preferably plots the most recent SSB time series from an assessment with a MSY, management target, or limit reference point available, otherwise plots most recent SSB time series.
Total abundance (in numbers) – Preferably plots the most recent TN time series from an assessment with a MSY, management target, or limit reference point available, otherwise plots most recent TN time series.
Fishing mortality (instantaneous rate) – Preferably plots the most recent F time series from an assessment with a MSY, management target, or limit reference point available, otherwise plots most recent F time series.
Exploitation rate (annual proportion) – Preferably plots the most recent ER time series from an assessment with a MSY, management target, or limit reference point available, otherwise plots most recent ER time series.
Recruits – Plots the most recent recruitment time series. If known, the year range during which recruitment deviates were estimated in the assessment model is shaded grey.
TC, TL, RecC – Plots most recent catch and/or landings as well as recreational catch and MSY if they are also available from that assessment. (The year range of moratoriums are shaded grey if available.)
TAC, Cpair, Cadv – Plots most recent total allowable catch or landings (or other measures of total quota), the corresponding catch or landings, and the corresponding scientifically advised catch if available from the same assessment.
survB – Plots the most recent fishery-independent survey biomass time series.
CPUE – Plots the most recent fishery-independent catch-per-unit-effort time series.
EFFORT – Plots the most recent fishing effort time series.
CdivMSY – Plots the ratio of the most recent catch time series to MSY. MSY is drawn from the assessment directly if available, or else is calculated from Bmsy and Umsy reference points (including proxies) if available.
Acronym and Abbreviation Definitions
B – Biomass; may be either total biomass or spawning stock biomass
Bmgt – Biomass at management target reference point
Bmsy – Biomass at MSY
Cadv – Scientifically advised catch
CdivMSY – Catch divided by MSY
Cpair – Catch corresponding to TAC and Cadv
CPUE – Catch per unit effort
EFFORT – Measure of fishing effort (depends on fishery)
ER – Exploitation rate (annual proportion)
F – Fishing mortality (instantaneous rate)
MSY – Maximum Sustainable Yield
RecC – Recreational catch
SSB – Spawning stock biomass
survB – Survey biomass
TAC – Total allowable catch
TB – Total biomass
TC – Total catch
TL – Total landings
TN – Total abundance; in numbers
U – Harvest rate; may be either exploitation rate or fishing mortality
Umsy – Harvest rate at MSY
Umgt – Harvest rate at management target reference point