Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Access Info
Catalog Details

Summary

Abstract

Explanation of columns included in the Juvenile Swordfish Dataset.

Description

Juvenile Swordfish Collected from 1991-2002.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
FISH_DATA_NUM
VARCHAR
The unique number assigned to each fish for identification purposes. This number is composed of the initials (first, middle, and last) of the collector and the sequential number of collection.
ALT_SPECIMEN_ID
VARCHAR
A specimen may have an Alternative Specimen ID in addition to a FISH_DATA_NUM. The alternative specimen ID was developed before the standardized fish data number. Fish with an alternative specimen ID have also been assigned a FISH_DATA_NUM which is the number used to identify the specimen and its associated information.
DATE_CAUGHT
DATE
The date the specimen was caught.
LL_TRIP_NUM
VARCHAR
The number of the longline trip the specimen was caught during.
SET_NUM
NUMBER
The set number the specimen was caught during.
FISHING_VESSEL
VARCHAR
The fishing or research vessel the specimen was caught on.
GEN_LOCATION
VARCHAR
The general location the specimen was caught.
LAT_DEG
NUMBER
The degrees latitude the specimen was caught.
LAT_MIN
NUMBER
The minutes latitude the specimen was caught.
LAT_DIR
CHAR
The latitude direction the specimen was caught.
LONG_DEG
NUMBER
The degrees longitude the specimen was caught.
LONG_MIN
NUMBER
The minutes longitude the specimen was caught.
LONG_DIR
CHAR
The longitude direction the specimen was caught.
LAT_DEC_DEG
NUMBER
The latitude decimal degrees the specimen was caught.
LONG_DEC_DEG
NUMBER
The longitude decimal degrees the specimen was caught.
INTACT_YN
CHAR
Was the specimen fully intact, yes (Y) or no (N)?
EFL_CM_AT_SEA
NUMBER
The eye to fork length measurement taken by an observer and/or researcher while at sea in centimeters, the value may be different than the one taken at the lab due to conditions at sea that may affect the accuracy of the length measurement.
EFL_CM_AT_LAB
NUMBER
The eye to fork length measurement taken at the receiving lab in centimeters, this measurement may differ from the EFL taken at sea.
LJFL_CM_LAB
NUMBER
The length from the lower jaw to the fork in the tail (LJFL) recorded in centimeters at the receiving lab.
WEIGHT_KG
NUMBER
The weight of the specimen taken at the receiving lab in kilograms.
SEX_MFU
CHAR
The sex of the specimen, either male (M), female (F), or unknown (U).
OTOLITHS_YNU
CHAR
Were otoliths from this specimen extracted, yes (Y), no (N), or unknown (U)?
SAGITTAE
NUMBER
The number of sagittae successfully extracted from the specimen.
LAPILLAE
NUMBER
The number of lapillae successfully extracted from the specimen.
1ST_ANAL_FIN_YNU
CHAR
Was the 1st anal fin from this specimen extracted; yes (Y), no (N), or unknown (U).
NUM_DORSAL_FIN_RAYS
NUMBER
The number of dorsal fin rays the specimen possesses.
NUM_ANAL_FIN_RAYS
NUMBER
The number of anal fin rays the specimen possesses.
PARASITES_YNU
CHAR
Did the specimen have external or internal parasites; yes (Y), no (N), or unknown (U)?
GONADS_YNU
CHAR
Were gonads from this specimen extracted; yes (Y), no (N), or unknown (U)?
STOMACH_YNU
CHAR
Was the stomach from this specimen extracted; yes (Y), no (N), or unknown (U).
MUSCLE_TISSUE_YNU
CHAR
Was muscle tissue from this specimen extracted; yes (Y), no (N), or unknown (U)?
INTESTINES_YNU
CHAR
Were the intestines from this specimen extracted; yes (Y), no (N), or unknown (U)?
GILLS_YNU
CHAR
Were the gills from this specimen extracted; yes (Y), no (N), or unknown (U)?
HEAD_YNU
CHAR
Was the head from this specimen retained; yes (Y), no (N), or unknown (U)?
OTHER_VISCERA_YNU
CHAR
Were any other viscera collected from this specimen; yes (Y), no (N), or unknown (U)?
STABLE_ISOTOPE_YNU
CHAR
Was a muscle tissue sample collected; yes (Y), no (N), or unknown (U)?
NOTES
VARCHAR
Notes about the specimen, such as condition, information on its origin, who collected it, etc.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Column Notes for Juvenile Swordfish Collected from 1991-2002
Status: Completed
Abstract:

Explanation of columns included in the Juvenile Swordfish Dataset.

Purpose:

Provide an explanation of what could be included in each column of this dataset.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None gonads
None Hawaii Longline Observer Program
None Juvenile Swordfish
None lengths
None muscle tissue
None otoliths
None xiphias gladius

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1991-2002

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Australia
None Big Island
None Guam
None Hawaii
None Kiribati
None Midway
None Oahu
None South Pacific Ocean
None Tahiti

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA
Location Description:

Aiea Research Facility

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Juvenile Swordfish Collected from 1991-2002.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISH_DATA_NUM VARCHAR The unique number assigned to each fish for identification purposes. This number is composed of the initials (first, middle, and last) of the collector and the sequential number of collection.
100
ALT_SPECIMEN_ID VARCHAR A specimen may have an Alternative Specimen ID in addition to a FISH_DATA_NUM. The alternative specimen ID was developed before the standardized fish data number. Fish with an alternative specimen ID have also been assigned a FISH_DATA_NUM which is the number used to identify the specimen and its associated information.
100
DATE_CAUGHT DATE The date the specimen was caught.
100
LL_TRIP_NUM VARCHAR The number of the longline trip the specimen was caught during.
100
SET_NUM NUMBER The set number the specimen was caught during.
100
FISHING_VESSEL VARCHAR The fishing or research vessel the specimen was caught on.
100
GEN_LOCATION VARCHAR The general location the specimen was caught.
100
LAT_DEG NUMBER The degrees latitude the specimen was caught.
100
LAT_MIN NUMBER The minutes latitude the specimen was caught.
100
LAT_DIR CHAR The latitude direction the specimen was caught.
100
LONG_DEG NUMBER The degrees longitude the specimen was caught.
100
LONG_MIN NUMBER The minutes longitude the specimen was caught.
100
LONG_DIR CHAR The longitude direction the specimen was caught.
100
LAT_DEC_DEG NUMBER The latitude decimal degrees the specimen was caught.
100
LONG_DEC_DEG NUMBER The longitude decimal degrees the specimen was caught.
100
INTACT_YN CHAR Was the specimen fully intact, yes (Y) or no (N)?
100
EFL_CM_AT_SEA NUMBER The eye to fork length measurement taken by an observer and/or researcher while at sea in centimeters, the value may be different than the one taken at the lab due to conditions at sea that may affect the accuracy of the length measurement.
100
EFL_CM_AT_LAB NUMBER The eye to fork length measurement taken at the receiving lab in centimeters, this measurement may differ from the EFL taken at sea.
100
LJFL_CM_LAB NUMBER The length from the lower jaw to the fork in the tail (LJFL) recorded in centimeters at the receiving lab.
100
WEIGHT_KG NUMBER The weight of the specimen taken at the receiving lab in kilograms.
100
SEX_MFU CHAR The sex of the specimen, either male (M), female (F), or unknown (U).
100
OTOLITHS_YNU CHAR Were otoliths from this specimen extracted, yes (Y), no (N), or unknown (U)?
100
SAGITTAE NUMBER The number of sagittae successfully extracted from the specimen.
100
LAPILLAE NUMBER The number of lapillae successfully extracted from the specimen.
100
1ST_ANAL_FIN_YNU CHAR Was the 1st anal fin from this specimen extracted; yes (Y), no (N), or unknown (U).
100
NUM_DORSAL_FIN_RAYS NUMBER The number of dorsal fin rays the specimen possesses.
100
NUM_ANAL_FIN_RAYS NUMBER The number of anal fin rays the specimen possesses.
100
PARASITES_YNU CHAR Did the specimen have external or internal parasites; yes (Y), no (N), or unknown (U)?
100
GONADS_YNU CHAR Were gonads from this specimen extracted; yes (Y), no (N), or unknown (U)?
100
STOMACH_YNU CHAR Was the stomach from this specimen extracted; yes (Y), no (N), or unknown (U).
100
MUSCLE_TISSUE_YNU CHAR Was muscle tissue from this specimen extracted; yes (Y), no (N), or unknown (U)?
100
INTESTINES_YNU CHAR Were the intestines from this specimen extracted; yes (Y), no (N), or unknown (U)?
100
GILLS_YNU CHAR Were the gills from this specimen extracted; yes (Y), no (N), or unknown (U)?
100
HEAD_YNU CHAR Was the head from this specimen retained; yes (Y), no (N), or unknown (U)?
100
OTHER_VISCERA_YNU CHAR Were any other viscera collected from this specimen; yes (Y), no (N), or unknown (U)?
100
STABLE_ISOTOPE_YNU CHAR Was a muscle tissue sample collected; yes (Y), no (N), or unknown (U)?
100
NOTES VARCHAR Notes about the specimen, such as condition, information on its origin, who collected it, etc.

Attribute Details

FISH_DATA_NUM

CC ID: 45446
Seq. Order: 1
Data Storage Type: VARCHAR
Max Length: 40
Required: Yes
Primary Key: Yes
Status: Active
Description:

The unique number assigned to each fish for identification purposes. This number is composed of the initials (first, middle, and last) of the collector and the sequential number of collection.

Case Restriction: Upper
Null Value: N
Null Value Meaning:

Every fish MUST have a fish data number to associate it with supplemental information collected from that fish.

ALT_SPECIMEN_ID

CC ID: 45447
Seq. Order: 2
Data Storage Type: VARCHAR
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

A specimen may have an Alternative Specimen ID in addition to a FISH_DATA_NUM. The alternative specimen ID was developed before the standardized fish data number. Fish with an alternative specimen ID have also been assigned a FISH_DATA_NUM which is the number used to identify the specimen and its associated information.

Null Value: Yes
Null Value Meaning:

No alternative ID was assigned.

DATE_CAUGHT

CC ID: 45466
Seq. Order: 3
Data Storage Type: DATE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The date the specimen was caught.

Null Value: Yes
Null Value Meaning:

The date was unknown or wasn't recorded.

LL_TRIP_NUM

CC ID: 45454
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The number of the longline trip the specimen was caught during.

Null Value: Yes
Null Value Meaning:

The specimen was not caught on a Hawaii longline vessel or the longline trip number is unknown.

SET_NUM

CC ID: 45455
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The set number the specimen was caught during.

Null Value: Yes
Null Value Meaning:

The specimen was not caught on a Hawaii longline vessel or the set number is unknown.

FISHING_VESSEL

CC ID: 45457
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The fishing or research vessel the specimen was caught on.

Null Value: Yes
Null Value Meaning:

The name of the fishing or research vessel is unknown.

GEN_LOCATION

CC ID: 45456
Seq. Order: 7
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The general location the specimen was caught.

Null Value: Yes
Null Value Meaning:

General location information is not available.

LAT_DEG

CC ID: 45458
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The degrees latitude the specimen was caught.

Null Value: Yes
Null Value Meaning:

The degrees latitude is unknown or wasn't recorded.

LAT_MIN

CC ID: 45459
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The minutes latitude the specimen was caught.

Null Value: Yes
Null Value Meaning:

The minutes latitude are unknown or weren't recorded.

LAT_DIR

CC ID: 45460
Seq. Order: 10
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The latitude direction the specimen was caught.

Null Value: Yes
Null Value Meaning:

The catch location of the specimen is unknown or wasn't recorded.

Allowed Values: N, S

LONG_DEG

CC ID: 45462
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The degrees longitude the specimen was caught.

Null Value: Yes
Null Value Meaning:

The degrees longitude is unknown or wasn't recorded.

LONG_MIN

CC ID: 45463
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The minutes longitude the specimen was caught.

Null Value: Yes
Null Value Meaning:

The minutes longitude is unknown or weren't recorded.

LONG_DIR

CC ID: 45464
Seq. Order: 13
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The longitude direction the specimen was caught.

Null Value: Yes
Null Value Meaning:

The catch location of the specimen is unknown or wasn't recorded.

Allowed Values: E, W

LAT_DEC_DEG

CC ID: 45461
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The latitude decimal degrees the specimen was caught.

Null Value: Yes
Null Value Meaning:

The catch location is unknown or wasn't recorded.

LONG_DEC_DEG

CC ID: 45465
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The longitude decimal degrees the specimen was caught.

Null Value: Yes
Null Value Meaning:

The catch location is unknown or wasn't recorded.

INTACT_YN

CC ID: 45448
Seq. Order: 16
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Was the specimen fully intact, yes (Y) or no (N)?

Null Value: No
Null Value Meaning:

The fish either was or was not intact.

Allowed Values: Y, N

EFL_CM_AT_SEA

CC ID: 45468
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The eye to fork length measurement taken by an observer and/or researcher while at sea in centimeters, the value may be different than the one taken at the lab due to conditions at sea that may affect the accuracy of the length measurement.

Null Value: Yes
Null Value Meaning:

The EFL wasn't measured or recorded at sea.

EFL_CM_AT_LAB

CC ID: 45482
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The eye to fork length measurement taken at the receiving lab in centimeters, this measurement may differ from the EFL taken at sea.

Null Value: Yes
Null Value Meaning:

The EFL wasn't taken at the lab or wasn't recorded.

LJFL_CM_LAB

CC ID: 45467
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The length from the lower jaw to the fork in the tail (LJFL) recorded in centimeters at the receiving lab.

Null Value: Yes
Null Value Meaning:

The LJFL wasn't measured or wasn't recorded.

WEIGHT_KG

CC ID: 45470
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The weight of the specimen taken at the receiving lab in kilograms.

Null Value: Yes
Null Value Meaning:

The weight was not measured or wasn't recorded.

SEX_MFU

CC ID: 45469
Seq. Order: 21
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

The sex of the specimen, either male (M), female (F), or unknown (U).

Null Value: No
Null Value Meaning:

If the sex unknown, a U should be entered in this row.

Allowed Values: M, F, U

OTOLITHS_YNU

CC ID: 45473
Seq. Order: 22
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Were otoliths from this specimen extracted, yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

Otoliths either were or were not extracted or it is unknown if the otoliths were extracted.

Allowed Values: Y, N, U

SAGITTAE

CC ID: 45450
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

The number of sagittae successfully extracted from the specimen.

Null Value: No
Null Value Meaning:

Either 0, 1, or 2 sagittae can be extracted.

Allowed Values: 0, 1, 2

LAPILLAE

CC ID: 45451
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

The number of lapillae successfully extracted from the specimen.

Null Value: No
Null Value Meaning:

Either 0, 1, or 2 lapillae can be extracted.

Allowed Values: 0, 1, 2

1ST_ANAL_FIN_YNU

CC ID: 45476
Seq. Order: 25
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Was the 1st anal fin from this specimen extracted; yes (Y), no (N), or unknown (U).

Null Value: No
Null Value Meaning:

The 1st anal fin either was or was not extracted or it is unknown if the 1st anal fin was extracted.

Allowed Values: Y, N, U

NUM_DORSAL_FIN_RAYS

CC ID: 45471
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The number of dorsal fin rays the specimen possesses.

Null Value: Yes
Null Value Meaning:

The specimen was either too damaged to accurately count the individual fin rays, the count was not completed, or the count was not recorded.

NUM_ANAL_FIN_RAYS

CC ID: 45472
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The number of anal fin rays the specimen possesses.

Null Value: Yes
Null Value Meaning:

The specimen was either too damaged to accurately count the individual fin rays, the count was not completed, or the count was not recorded.

PARASITES_YNU

CC ID: 45449
Seq. Order: 28
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Did the specimen have external or internal parasites; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

The fish either did or did not have parasites or it is unknown if parasites were present.

Allowed Values: Y, N, U

GONADS_YNU

CC ID: 45474
Seq. Order: 29
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Were gonads from this specimen extracted; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

Gonads either were or were not extracted or it is unknown if gonads were extracted.

Allowed Values: Y, N, U

STOMACH_YNU

CC ID: 45475
Seq. Order: 30
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Was the stomach from this specimen extracted; yes (Y), no (N), or unknown (U).

Null Value: No
Null Value Meaning:

The stomach either was or was not extracted or it is unknown if the stomach was extracted.

Allowed Values: Y, N, U

MUSCLE_TISSUE_YNU

CC ID: 45477
Seq. Order: 31
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Was muscle tissue from this specimen extracted; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

Muscle tissue either was or was not extracted or it is unknown if muscle tissue was extracted.

Allowed Values: Y, N, U

INTESTINES_YNU

CC ID: 45478
Seq. Order: 32
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Were the intestines from this specimen extracted; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

The intestines either were or were not extracted or it is unknown if the intestines were extracted.

Allowed Values: Y, N, U

GILLS_YNU

CC ID: 45479
Seq. Order: 33
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Were the gills from this specimen extracted; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

The gills either were or were not extracted or it is unknown if the gills were extracted.

Allowed Values: Y, N, U

HEAD_YNU

CC ID: 45480
Seq. Order: 34
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Was the head from this specimen retained; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

The head either was or was not retained or it is unknown if the head was extracted.

Allowed Values: Y, N, U

OTHER_VISCERA_YNU

CC ID: 45481
Seq. Order: 35
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Were any other viscera collected from this specimen; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

Other viscera either were or were not retained or it is unknown if other viscera were retained.

Allowed Values: Y, N, U

STABLE_ISOTOPE_YNU

CC ID: 45453
Seq. Order: 36
Data Storage Type: CHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Was a muscle tissue sample collected; yes (Y), no (N), or unknown (U)?

Null Value: No
Null Value Meaning:

Muscle tissue either was or was not collected or it is unknown if stable isotopes were extracted.

Allowed Values: Y, N, U

NOTES

CC ID: 45452
Seq. Order: 37
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Notes about the specimen, such as condition, information on its origin, who collected it, etc.

Null Value: Yes
Null Value Meaning:

There were no additional comments about the specimen.

Support Roles

This Catalog Item has no Support Roles that are currently in effect.
View Historical Support Roles

Access Information

Security Class: Confidential
Security Classification System:

Data set contains confidential fisheries data; access is restricted unless necessary approval is granted.

Security Handling Description:

Email data steward or POC for information regarding this data set.

Catalog Details

Catalog Item ID: 11759
GUID: gov.noaa.nmfs.inport:11759
Metadata Record Created By: Meagan A Sundberg
Metadata Record Created: 2012-02-13 20:16+0000
Metadata Record Last Modified By: Michael Chang
Metadata Record Last Modified: 2025-02-13 22:57+0000
Metadata Record Published: 2025-02-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year