18751
HAWAII_LL_TRIP_EXPENDITURE_DATA
Entity
Published / External
5662
Hawaii Longline Fishery Trip Expenditure (2004 to present)
Data Set
In Work
This table contains the results of the Hawaii Longline Fishery Trip Expenditure Survey
Theme
ECONOMICS
Theme
Hawaii longline fishery
Theme
PIFSC
Theme
SOCIOECONOMICS
Theme
Trip expenditure
Pacific Islands Fisheries Science Center
Honolulu
HI
USA
Data Table
Yes
The entity table shows the variable names, data storage types, and maximum length of the variables contain in the data file
1
E_TRIPTYPE
Text
15
No
No
Active
Type of fishing trip (e.g. Tuna or Swordfish)
Tuna, Swordfish
2
E_CODE
Long Integer
4
No
No
Active
Filing reference number
3
E_TRIPNUM
Text
10
No
No
Active
Trip Number (primary key)
4
E_VESSELNAME
Text
30
No
No
Active
Name of vessel
5
E_DEPARTDATE
Date
8
No
No
Active
Departure date of vessel for this trip
MM/DD/YYYY
6
E_RETURNDATE
Date
8
No
No
Active
Return date of vessel for this trip
MM/DD/YYYY
7
E_FUELPRICE
Currency
8
No
No
Active
Price of fuel for this trip ($ per gallon)
8
E_FUELUSED
Long Integer
4
No
No
Active
Total amount of fuel used (in gallons) for this trip
9
E_FUELCOST
Currency
8
No
No
Active
Total cost of fuel purchased for this trip
10
E_OILPRICE
Currency
8
No
No
Active
Price of oil for this trip ($ per gallon)
11
E_OILUSED
Long Integer
4
No
No
Active
Number of gallons of oil used for this trip
12
E_OILCOST
Currency
8
No
No
Active
Total cost of oil purchased for this trip
13
E_BAIT1
Text
15
No
No
Active
Type of Bait Type 1 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
Squid, Sardine, Sanma, Mackerel, Anchovy,and Other
14
E_BAIT1PRICE
Currency
8
No
No
Active
Price Per Box for bait type 1
15
E_BAIT1USED
Long Integer
4
No
No
Active
Number of boxes used for bait type 1
16
E_BAIT1COST
Currency
8
No
No
Active
Total cost of bait type 1
17
E_BAIT2
Text
15
No
No
Active
Type of Bait Type 2 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
Squid, Sardine, Sanma, Mackerel, Anchovy,and Other
18
E_BAIT2PRICE
Currency
8
No
No
Active
Price per box for bait type 2
19
E_BAIT2USED
Long Integer
4
No
No
Active
Number of boxes used for bait type 2
20
E_BAIT2COST
Currency
8
No
No
Active
Total cost of bait type 2
21
E_ICEMAKER
Logical
1
No
No
Active
Does the vessel have an icemaker?
22
E_ICEUNIT
Text
10
No
No
Active
Unit of ice (e.g., Block, Ton, Pound)
Block, Ton, Pound
23
E_ICEPRICE
Currency
8
No
No
Active
Ice Price Per Unit
24
E_ICEUSED
Long Integer
4
No
No
Active
Number of units used
25
E_ICECOST
Currency
8
No
No
Active
Total cost of ice purchased
26
E_GEARCOST
Currency
8
No
No
Active
Fishing gear cost
27
E_PROVCOST
Currency
8
No
No
Active
Cost of provisions (e.g. bottled water, food, etc.)
28
E_COMMCOST
Currency
8
No
No
Active
Cost of satellite phone calls, e-mail, etc.
29
E_SFCERT
Text
10
No
No
Active
If swordfish fishing certificate used, indicate if purchased or not purchased
Purchased, Not purchased
30
E_FREESOURCE
Text
10
No
No
Active
If swordfish fishing certificate used and not purchased, indicate how obtained, Own, Other (given by other fishermen), Both (Own and Other used during this trip)
Own, Other, Both
31
E_CERTPURCH
Long Integer
4
No
No
Active
If swordfish fishing certificates were purchased, indicate the number of certificates purchased
32
E_CERTPRICE
Currency
8
No
No
Active
Price per certificate
33
E_CERTCOST
Currency
8
No
No
Active
Total cost for certificates
34
E_LIGHTSTICKPRICE
Currency
8
No
No
Active
Lightstick Price Per Case (500 per case)
35
E_LIGHTSTICKUSED
Long Integer
4
No
No
Active
Number of lightstick cases used
36
E_LIGHTSTICKCOST
Currency
8
No
No
Active
Total cost of lightsticks
37
E_ESTCOSTS
Currency
8
No
No
Active
Estimated total trip cost (by captain or owner)
38
E_CALCTRIPCOSTS
Currency
8
No
No
Active
Summation of itemized fields in form, which include E_FuelCost, E_OilCost, E_Bait1Cost, E_Bait2Cost, E_FreezerCosts, E_IceCost, E_GearCost , E_ProvCost , E_CommCost , E_FreightCost, E_MiscCost
39
E_OPERATOR
Text
20
No
No
Active
Operator for this trip (e.g., Owner operated, Hired captain, Not indicated)
Owner operated, Hired captain, Not indicated
40
E_NUMCREWOLD
Long Integer
4
No
No
Inactive
Number of crew including captain (old form before 2011)
41
E_NUMCREW
Long Integer
4
No
No
Active
Number of crew not including captain (2011 form)
42
E_NUMFOREIGNCREW
Long Integer
4
No
No
Active
Number of total foreign crew (e.g., Kiribati, Marshall Is, Christmas Is, Philippines)
43
E_STATUSCOLLECTION
Text
40
No
No
Active
Indicate if data collected by observer
Yes, No, Other
44
E_OBSNOTE
Text
255
No
No
Active
If E_STATUSCOLLECTION is "Other", include note from observer
45
E_DATATYPE
Text
40
No
No
Active
Choose the specific designation for data type (e.g. Data from captain, Observed data at sea, In office)
Data from captain, Observed data at sea, In office
46
E_OBSNUMBER
Text
10
No
No
Active
Observer i.d. number
47
E_CAPTAINPHONE
Text
12
No
No
Active
Trip operator phone number
Point of Contact
2007-08-22
Person
Pan, Minling
minling.pan@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
(808)725-5349
8:30 a.m. - 5:00 p.m. HST M-F
Confidential
gov.noaa.nmfs.inport:18751
Hing Ling Chan
2013-04-25T21:03:58
SysAdmin InPortAdmin
2022-08-09T17:11:04
2015-12-29
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2015-12-29
1 Year
2016-12-29