Item Identification

Title: ESD_RetailMonitoring2016_v01
Status: Completed
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.

Entity Information

Entity Type: Data File
Active Version?: Yes
Description:

Hawaii Seafood Retail Price Monitoring Data (2016).

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
WEEK Number Week of the calendar year for observation (1-52)
N/A
VENDOR Number Vendor ID number (1-20)
N/A
GROUP Text Species group name (REEF, BOTTOMFISH, PELAGICS, OTHER, TUNA)
N/A
SPECIES Text Species name for fish
N/A
PRICE Double Price ($ per pound) for observed fish
N/A
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
TYPE Text Product type for observed fish (F=Fresh, Z=Frozen, P=Previously Frozen, A=Farmed)
N/A
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
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
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
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
QUANTITY Number Estimate for the number of fish, by species, on display at the vendor location. Blank indicates unknown or not counted
N/A
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
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
MONTH Number Month of the calendar year (1-12), where 1= January and 12 = December.

Attribute Details

WEEK

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

Week of the calendar year for observation (1-52)

General Data Type: Integer
Unit of Measure: week of the calendar year
Allowed Values: 1-52

VENDOR

CC ID: 300379
Seq. Order: 2
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Vendor ID number (1-20)

General Data Type: Integer
Display Example: 1-20

GROUP

CC ID: 300381
Seq. Order: 3
Data Storage Type: Text
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Species group name (REEF, BOTTOMFISH, PELAGICS, OTHER, TUNA)

General Data Type: Text
Display Example: REEF, BOTTOMFISH, PELAGICS, OTHER, TUNA

SPECIES

CC ID: 300382
Seq. Order: 4
Data Storage Type: Text
Max Length: 39
Required: No
Primary Key: No
Status: Active
Description:

Species name for fish

General Data Type: Text
Display Example: EHU, ONAGA

PRICE

CC ID: 300383
Seq. Order: 5
Data Storage Type: Double
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Price ($ per pound) for observed fish

General Data Type: Number

FORM

CC ID: 300384
Seq. Order: 6
Data Storage Type: Text
Max Length: 1
Required: No
Primary Key: No
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
Display Example: W, F, S, L, P, B, M, O

TYPE

CC ID: 300385
Seq. Order: 7
Data Storage Type: Text
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Product type for observed fish (F=Fresh, Z=Frozen, P=Previously Frozen, A=Farmed)

General Data Type: Text
Display Example: F, Z, P, A

ORIGIN

CC ID: 300386
Seq. Order: 8
Data Storage Type: Text
Max Length: 1
Required: No
Primary Key: No
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
Display Example: H, I, D, I, N

ORIGIN_NOTES

CC ID: 300387
Seq. Order: 9
Data Storage Type: Text
Max Length: 16
Required: No
Primary Key: No
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
Display Example: New Zealand, China, Taiwan, etc..

GRADE

CC ID: 300388
Seq. Order: 10
Data Storage Type: Text
Max Length: 9
Required: No
Primary Key: No
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
Display Example: SASHIMI, #1, PREMIUM, GOOD, VERY GOOD, etc..

CO

CC ID: 300389
Seq. Order: 11
Data Storage Type: Text
Max Length: 3
Required: No
Primary Key: No
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
Display Example: YES, NO

QUANTITY

CC ID: 300390
Seq. Order: 12
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
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

NOTES

CC ID: 300391
Seq. Order: 13
Data Storage Type: Text
Max Length: 34
Required: No
Primary Key: No
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

SALE

CC ID: 300392
Seq. Order: 14
Data Storage Type: Text
Max Length: 3
Required: No
Primary Key: No
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
Display Example: YES, NO

MONTH

CC ID: 300393
Seq. Order: 15
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Month of the calendar year (1-12), where 1= January and 12 = December.

General Data Type: Integer
Display Example: 1-12

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: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-29
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-29