ESD_RetailMonitoring2016_v01
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 30969
| Published / External
Created: 2016-02-29
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 29742
ID: 30969
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | ESD_RetailMonitoring2016_v01 |
---|---|
Short Name | |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This data set contains consumer-level prices for a sample of retail markets in Honolulu for 2016. Data include weekly prices for fish species prevalent in Honolulu retail seafood markets. Additionally, each record contains information on the product form, origin of the fish (if known), labeling schemes, quality (where applicable), and the use of preservation methods (such as CO-treatment) |
* Purpose |
The purpose of this data collection effort was to gain a better understanding of retail (consumer) markets in Hawaii. Time series data at the consumer level could support research into price transmission within the Hawaii seafood market. Additionally, having a record of retail pricing and market observations provides valuable insights into the market responses of management actions. There is a record of consumer-level prices for fish in Hawaii between 2007-2011 so this research will provide a comparative time series to this baseline understanding of the retail market sector. |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data File |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Hawaii Seafood Retail Price Monitoring Data (2016). |
Change Summary |
Data Attributes
Note: Metadata requirements do not apply to attributes for non-tabular entities.
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
N/A | No | No | WEEK | Number | Week of the calendar year for observation (1-52) |
N/A | No | No | VENDOR | Number | Vendor ID number (1-20) |
N/A | No | No | GROUP | Text | Species group name (REEF, BOTTOMFISH, PELAGICS, OTHER, TUNA) |
N/A | No | No | SPECIES | Text | Species name for fish |
N/A | No | No | PRICE | Double | Price ($ per pound) for observed fish |
N/A | No | No | FORM | Text | Product form of observed fish (W=Whole, F=Fillet, S=Steak, L=Loin, P=Poke, B=Block, M=Smoked, O=Other) |
N/A | No | No | TYPE | Text | Product type for observed fish (F=Fresh, Z=Frozen, P=Previously Frozen, A=Farmed) |
N/A | No | No | ORIGIN | Text | Country of Origin for observed fish - where applicable (H=Hawaii, I=Import, D=Domestic(USA), U=Unknown, N=Neighbor Island). Blank is unknown. |
N/A | No | No | ORIGIN_NOTES | Text | Specific Country of Origin - when applicable and when labelled (particularly for Import or Neighbor Island fish). Blank is unknown, or not applicable. |
N/A | No | No | GRADE | Text | Quality of fish - generally only for tuna loins/fillets/blocks, as labelled by retailer. The values corresponds to the specific grade language use. Some examples include SASHIMI, PREMIUM, GOOD, VERY GOOD, etc. Blank indicates unknown or not specified by retailer |
N/A | No | No | CO | Text | Indicator or whether the fish was treated with Carbon-Monoxide (tasteless smoke) for color retention (primarily tuna poke). YES indicates that the fish was identified as treated with CO. Blank is not applicable or unknown |
N/A | No | No | QUANTITY | Number | Estimate for the number of fish, by species, on display at the vendor location. Blank indicates unknown or not counted |
N/A | No | No | NOTES | Text | Any notes related to the fish observed. Often this is used to clarify the product form (when listed as Other), or to indicate any other qualitative information. Blank indicates no Notes. |
N/A | No | No | SALE | Text | An indicator as to whether the fish price reflects an advertised sale price. YES indicates a sale price, Blank indicates not on sale or unknown. |
N/A | No | No | MONTH | Number | Month of the calendar year (1-12), where 1= January and 12 = December. |
Attribute Details
Attribute Name | WEEK |
---|---|
Seq. Order | 1 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Week of the calendar year for observation (1-52) |
General Data Type | Integer |
Unit of Measure | week of the calendar year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-52 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VENDOR |
---|---|
Seq. Order | 2 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vendor ID number (1-20) |
General Data Type | Integer |
Unit of Measure | |
Case Restriction | |
Display Example | 1-20 |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GROUP |
---|---|
Seq. Order | 3 |
Data Storage Type | Text |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species group name (REEF, BOTTOMFISH, PELAGICS, OTHER, TUNA) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | REEF, BOTTOMFISH, PELAGICS, OTHER, TUNA |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES |
---|---|
Seq. Order | 4 |
Data Storage Type | Text |
Max Length | 39 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species name for fish |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | EHU, ONAGA |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PRICE |
---|---|
Seq. Order | 5 |
Data Storage Type | Double |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Price ($ per pound) for observed fish |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FORM |
---|---|
Seq. Order | 6 |
Data Storage Type | Text |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Product form of observed fish (W=Whole, F=Fillet, S=Steak, L=Loin, P=Poke, B=Block, M=Smoked, O=Other) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | W, F, S, L, P, B, M, O |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TYPE |
---|---|
Seq. Order | 7 |
Data Storage Type | Text |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Product type for observed fish (F=Fresh, Z=Frozen, P=Previously Frozen, A=Farmed) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | F, Z, P, A |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ORIGIN |
---|---|
Seq. Order | 8 |
Data Storage Type | Text |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Country of Origin for observed fish - where applicable (H=Hawaii, I=Import, D=Domestic(USA), U=Unknown, N=Neighbor Island). Blank is unknown. |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | H, I, D, I, N |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ORIGIN_NOTES |
---|---|
Seq. Order | 9 |
Data Storage Type | Text |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Specific Country of Origin - when applicable and when labelled (particularly for Import or Neighbor Island fish). Blank is unknown, or not applicable. |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | New Zealand, China, Taiwan, etc.. |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRADE |
---|---|
Seq. Order | 10 |
Data Storage Type | Text |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Quality of fish - generally only for tuna loins/fillets/blocks, as labelled by retailer. The values corresponds to the specific grade language use. Some examples include SASHIMI, PREMIUM, GOOD, VERY GOOD, etc. Blank indicates unknown or not specified by retailer |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | SASHIMI, #1, PREMIUM, GOOD, VERY GOOD, etc.. |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CO |
---|---|
Seq. Order | 11 |
Data Storage Type | Text |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicator or whether the fish was treated with Carbon-Monoxide (tasteless smoke) for color retention (primarily tuna poke). YES indicates that the fish was identified as treated with CO. Blank is not applicable or unknown |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | YES, NO |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | QUANTITY |
---|---|
Seq. Order | 12 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Estimate for the number of fish, by species, on display at the vendor location. Blank indicates unknown or not counted |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NOTES |
---|---|
Seq. Order | 13 |
Data Storage Type | Text |
Max Length | 34 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any notes related to the fish observed. Often this is used to clarify the product form (when listed as Other), or to indicate any other qualitative information. Blank indicates no Notes. |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SALE |
---|---|
Seq. Order | 14 |
Data Storage Type | Text |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
An indicator as to whether the fish price reflects an advertised sale price. YES indicates a sale price, Blank indicates not on sale or unknown. |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | YES, NO |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MONTH |
---|---|
Seq. Order | 15 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month of the calendar year (1-12), where 1= January and 12 = December. |
General Data Type | Integer |
Unit of Measure | |
Case Restriction | |
Display Example | 1-12 |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 30969 |
---|---|
Metadata Record Created By | Justin D Hospital |
Metadata Record Created | 2016-02-29 12:24+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2019-05-29 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2019-05-29 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-05-29 |
Tags |
---|