Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table describes data associated with each Pacific hake collected by Department of Fisheries and Oceans, Canada (DFO) and Washington Department of Fish and Wildlife (WDFW).

Description

This table describes data associated with each Pacific hake collected by Department of Fisheries and Oceans, Canada (DFO) and Washington Department of Fish and Wildlife (WDFW).

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
REG
VARCHAR2
Region where fish were collected. The Department of Fisheries and Ocean Canada (DFO) collected data in the Strait of Georgia. The Washington Department of Fish and Wildlife (WDFW) collected data in Port Susan in Puget Sound.
YR
NUMBER
Year fish were collected.
SITE
VARCHAR2
Site were fish were collected. Fish collected by WDFW were collected from Port Susan.
FISH_ID
VARCHAR2
Unique identifier for each fish that (includes collection year).
WHT
NUMBER
The weigth of the fish. Units for values are grams.
TL
NUMBER
Total length of the fish. Units for values are mm.
SEX
VARCHAR2
The sex of the fish (M=Male, F=Female).
AGE
NUMBER
Age determined from otolith annuli. Units for values are years old.
HATCHYR
NUMBER
Year when fish was hatched. Units for values are year.
DAYGR
NUMBER
Daily growth rate of the fish. Units for values are microns/day.
OTOWDSUMRYR1
NUMBER
Otolith width corresponding to first summer. Units for values are microns.
OTOWDWINTYR1
NUMBER
Otolith width corresponding to first winter. Units for values are microns.
OTOWDSUMRYR2
NUMBER
Otolith width corresponding to second summer. Units for values are microns.
OTOWDWINTYR2
NUMBER
Otolith width corresponding to second winter. Units for values are microns.
OTOWDSUMRYR3
NUMBER
Otolith width corresponding to third summer. Units for values are microns.
OTOWDWINTYR3
NUMBER
Otolith width corresponding to third winter. Units for values are microns.
OTOWDSUMRYR4
NUMBER
Otolith width corresponding to fourth summer. Units for values are microns.
OTOWDWINTYR4
NUMBER
Otolith width corresponding to fourth winter. Units for values are microns.
OTOWDSUMRYR5
NUMBER
Otolith width corresponding to fifth summer. Units for values are microns.
OTOWDWINTYR5
NUMBER
Otolith width corresponding to fifth winter. Units for values are microns.
RADSUMYR1
NUMBER
Otolith radius at end of first summer. Units for values are microns.
RADWINTYR1
NUMBER
Otolith radius at end of first winter. Units for values are microns.
RADSUMYR2
NUMBER
Otolith radius at end of second summer. Units for values are microns.
RADWINTYR2
NUMBER
Otolith radius at end of second winter. Units for values are microns.
RADSUMYR3
NUMBER
Otolith radius at end of third summer. Units for values are microns.
RADWINTYR3
NUMBER
Otolith radius at end of third winter. Units for values are microns.
RADSUMYR4
NUMBER
Otolith radius at end of fourth summer. Units for values are microns.
RADWINTYR4
NUMBER
Otolith radius at end of fourth winter. Units for values are microns.
RADSUMYR5
NUMBER
Otolith radius at end of fifth summer. Units for values are microns.
RADWINTYR5
NUMBER
Otolith radius at end of fifth winter. Units for values are microns.
TOTRAD
NUMBER
Total otolith radius. Units for values are microns.
EDGEMg
NUMBER
Mg25 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
EDGEMn
NUMBER
Mn55 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
EDGESr
NUMBER
Sr86 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
EDGEBa
NUMBER
Ba138 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
EDGEPb
NUMBER
Pb208 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
NATALMg
NUMBER
Mg25 concentration quantified from 100microns otolith radius. Units for values are ppm.
NATALMn
NUMBER
Mn55 concentration quantified from 100microns otolith radius. Units for values are ppm.
NATALSr
NUMBER
Sr86 concentration quantified from 100microns otolith radius. Units for values are ppm.
NATALBa
NUMBER
Ba138 concentration quantified from 100microns otolith radius. Units for values are ppm.
NATALPb
NUMBER
Pb208 concentration quantified from 100microns otolith radius. Units for values are ppm.
WHOLEMg
NUMBER
Mg25 concentration quantified from ablation across whole otolith. Units for values are ppm.
WHOLEMn
NUMBER
Mn55 concentration quantified from ablation across whole otolith. Units for values are ppm.
WHOLESr
NUMBER
Sr86 concentration quantified from ablation across whole otolith. Units for values are ppm.
WHOLEBa
NUMBER
Ba138 concentration quantified from ablation across whole otolith. Units for values are ppm.
WHOLEPb
NUMBER
Pb208 concentration quantified from ablation across whole otolith. Units for values are ppm.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

Item Identification

Title: Sampled Fish Pacific Hake
Short Name: Sampled Fish Pacific Hake
Status: Planned
Abstract:

This table describes data associated with each Pacific hake collected by Department of Fisheries and Oceans, Canada (DFO) and Washington Department of Fish and Wildlife (WDFW).

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

This table describes data associated with each Pacific hake collected by Department of Fisheries and Oceans, Canada (DFO) and Washington Department of Fish and Wildlife (WDFW).

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REG VARCHAR2 Region where fish were collected. The Department of Fisheries and Ocean Canada (DFO) collected data in the Strait of Georgia. The Washington Department of Fish and Wildlife (WDFW) collected data in Port Susan in Puget Sound.
100
YR NUMBER Year fish were collected.
100
SITE VARCHAR2 Site were fish were collected. Fish collected by WDFW were collected from Port Susan.
100
FISH_ID VARCHAR2 Unique identifier for each fish that (includes collection year).
100
WHT NUMBER The weigth of the fish. Units for values are grams.
100
TL NUMBER Total length of the fish. Units for values are mm.
100
SEX VARCHAR2 The sex of the fish (M=Male, F=Female).
100
AGE NUMBER Age determined from otolith annuli. Units for values are years old.
100
HATCHYR NUMBER Year when fish was hatched. Units for values are year.
100
DAYGR NUMBER Daily growth rate of the fish. Units for values are microns/day.
100
OTOWDSUMRYR1 NUMBER Otolith width corresponding to first summer. Units for values are microns.
100
OTOWDWINTYR1 NUMBER Otolith width corresponding to first winter. Units for values are microns.
100
OTOWDSUMRYR2 NUMBER Otolith width corresponding to second summer. Units for values are microns.
100
OTOWDWINTYR2 NUMBER Otolith width corresponding to second winter. Units for values are microns.
100
OTOWDSUMRYR3 NUMBER Otolith width corresponding to third summer. Units for values are microns.
100
OTOWDWINTYR3 NUMBER Otolith width corresponding to third winter. Units for values are microns.
100
OTOWDSUMRYR4 NUMBER Otolith width corresponding to fourth summer. Units for values are microns.
100
OTOWDWINTYR4 NUMBER Otolith width corresponding to fourth winter. Units for values are microns.
100
OTOWDSUMRYR5 NUMBER Otolith width corresponding to fifth summer. Units for values are microns.
100
OTOWDWINTYR5 NUMBER Otolith width corresponding to fifth winter. Units for values are microns.
100
RADSUMYR1 NUMBER Otolith radius at end of first summer. Units for values are microns.
100
RADWINTYR1 NUMBER Otolith radius at end of first winter. Units for values are microns.
100
RADSUMYR2 NUMBER Otolith radius at end of second summer. Units for values are microns.
100
RADWINTYR2 NUMBER Otolith radius at end of second winter. Units for values are microns.
100
RADSUMYR3 NUMBER Otolith radius at end of third summer. Units for values are microns.
100
RADWINTYR3 NUMBER Otolith radius at end of third winter. Units for values are microns.
100
RADSUMYR4 NUMBER Otolith radius at end of fourth summer. Units for values are microns.
100
RADWINTYR4 NUMBER Otolith radius at end of fourth winter. Units for values are microns.
100
RADSUMYR5 NUMBER Otolith radius at end of fifth summer. Units for values are microns.
100
RADWINTYR5 NUMBER Otolith radius at end of fifth winter. Units for values are microns.
100
TOTRAD NUMBER Total otolith radius. Units for values are microns.
100
EDGEMg NUMBER Mg25 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
100
EDGEMn NUMBER Mn55 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
100
EDGESr NUMBER Sr86 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
100
EDGEBa NUMBER Ba138 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
100
EDGEPb NUMBER Pb208 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.
100
NATALMg NUMBER Mg25 concentration quantified from 100microns otolith radius. Units for values are ppm.
100
NATALMn NUMBER Mn55 concentration quantified from 100microns otolith radius. Units for values are ppm.
100
NATALSr NUMBER Sr86 concentration quantified from 100microns otolith radius. Units for values are ppm.
100
NATALBa NUMBER Ba138 concentration quantified from 100microns otolith radius. Units for values are ppm.
100
NATALPb NUMBER Pb208 concentration quantified from 100microns otolith radius. Units for values are ppm.
100
WHOLEMg NUMBER Mg25 concentration quantified from ablation across whole otolith. Units for values are ppm.
100
WHOLEMn NUMBER Mn55 concentration quantified from ablation across whole otolith. Units for values are ppm.
100
WHOLESr NUMBER Sr86 concentration quantified from ablation across whole otolith. Units for values are ppm.
100
WHOLEBa NUMBER Ba138 concentration quantified from ablation across whole otolith. Units for values are ppm.
100
WHOLEPb NUMBER Pb208 concentration quantified from ablation across whole otolith. Units for values are ppm.

Attribute Details

REG

CC ID: 732837
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Region where fish were collected. The Department of Fisheries and Ocean Canada (DFO) collected data in the Strait of Georgia. The Washington Department of Fish and Wildlife (WDFW) collected data in Port Susan in Puget Sound.

General Data Type: VARCHAR2

YR

CC ID: 732838
Seq. Order: 2
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Year fish were collected.

General Data Type: NUMBER

SITE

CC ID: 732839
Seq. Order: 3
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Site were fish were collected. Fish collected by WDFW were collected from Port Susan.

General Data Type: VARCHAR2

FISH_ID

CC ID: 732840
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for each fish that (includes collection year).

General Data Type: VARCHAR2

WHT

CC ID: 732841
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The weigth of the fish. Units for values are grams.

General Data Type: NUMBER
Unit of Measure: grams

TL

CC ID: 732842
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Total length of the fish. Units for values are mm.

General Data Type: NUMBER
Unit of Measure: mm

SEX

CC ID: 732843
Seq. Order: 7
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The sex of the fish (M=Male, F=Female).

General Data Type: VARCHAR2
Null Value: blank
Null Value Meaning:

gender unknown

AGE

CC ID: 732844
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Age determined from otolith annuli. Units for values are years old.

General Data Type: NUMBER
Unit of Measure: years old

HATCHYR

CC ID: 732845
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Year when fish was hatched. Units for values are year.

General Data Type: NUMBER
Unit of Measure: year

DAYGR

CC ID: 732846
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Daily growth rate of the fish. Units for values are microns/day.

General Data Type: NUMBER
Unit of Measure: microns/day

OTOWDSUMRYR1

CC ID: 732847
Seq. Order: 11
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to first summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDWINTYR1

CC ID: 732848
Seq. Order: 12
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to first winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDSUMRYR2

CC ID: 732849
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to second summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDWINTYR2

CC ID: 732850
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to second winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDSUMRYR3

CC ID: 732851
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to third summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDWINTYR3

CC ID: 732852
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to third winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDSUMRYR4

CC ID: 732853
Seq. Order: 17
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to fourth summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDWINTYR4

CC ID: 732854
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to fourth winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDSUMRYR5

CC ID: 732855
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to fifth summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

OTOWDWINTYR5

CC ID: 732856
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith width corresponding to fifth winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADSUMYR1

CC ID: 732857
Seq. Order: 21
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of first summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADWINTYR1

CC ID: 732858
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of first winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADSUMYR2

CC ID: 732859
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of second summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADWINTYR2

CC ID: 732860
Seq. Order: 24
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of second winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADSUMYR3

CC ID: 732861
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of third summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADWINTYR3

CC ID: 732862
Seq. Order: 26
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of third winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADSUMYR4

CC ID: 732863
Seq. Order: 27
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of fourth summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADWINTYR4

CC ID: 732864
Seq. Order: 28
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of fourth winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADSUMYR5

CC ID: 732865
Seq. Order: 29
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of fifth summer. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

RADWINTYR5

CC ID: 732866
Seq. Order: 30
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Otolith radius at end of fifth winter. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

TOTRAD

CC ID: 732867
Seq. Order: 31
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Total otolith radius. Units for values are microns.

General Data Type: NUMBER
Unit of Measure: microns

EDGEMg

CC ID: 732868
Seq. Order: 32
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mg25 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

EDGEMn

CC ID: 732869
Seq. Order: 33
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mn55 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

EDGESr

CC ID: 732870
Seq. Order: 34
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sr86 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

EDGEBa

CC ID: 732871
Seq. Order: 35
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Ba138 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

EDGEPb

CC ID: 732872
Seq. Order: 36
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Pb208 concentration quantified from 100microns perpendicular to the otolith edge. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

NATALMg

CC ID: 732873
Seq. Order: 37
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mg25 concentration quantified from 100microns otolith radius. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

NATALMn

CC ID: 732874
Seq. Order: 38
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mn55 concentration quantified from 100microns otolith radius. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

NATALSr

CC ID: 732875
Seq. Order: 39
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sr86 concentration quantified from 100microns otolith radius. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

NATALBa

CC ID: 732876
Seq. Order: 40
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Ba138 concentration quantified from 100microns otolith radius. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

NATALPb

CC ID: 732877
Seq. Order: 41
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Pb208 concentration quantified from 100microns otolith radius. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

WHOLEMg

CC ID: 732878
Seq. Order: 42
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mg25 concentration quantified from ablation across whole otolith. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

WHOLEMn

CC ID: 732879
Seq. Order: 43
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Mn55 concentration quantified from ablation across whole otolith. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

WHOLESr

CC ID: 732880
Seq. Order: 44
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sr86 concentration quantified from ablation across whole otolith. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

WHOLEBa

CC ID: 732881
Seq. Order: 45
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Ba138 concentration quantified from ablation across whole otolith. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

WHOLEPb

CC ID: 732882
Seq. Order: 46
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Pb208 concentration quantified from ablation across whole otolith. Units for values are ppm.

General Data Type: NUMBER
Unit of Measure: ppm

Catalog Details

Catalog Item ID: 35558
GUID: gov.noaa.nmfs.inport:35558
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-11-04 19:22+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-02-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-02-27