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

Summary

Abstract

Table holding the information from the Crew Survey Section 2 (Expenditure Impacts of Fishing Industry in New England) Table 1

Description

Table holding the information from the Crew Survey Section 2 (Expenditure Impacts of Fishing Industry in New England) Table 1

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CSec21ID
Number
Autonumber key
CrewID
Number
Crew Identifier
LastName
Text
Crew Last Name
FirstName
Text
Crew First Name
Vessel1Permit#
Text
Vessels Multispecies Groundfish Permit Number
Csec21VesHome1
Number
1. Vessel Home Port Downeast Maine
Csec21VesHome2
Number
1. Vessel Home Port Upper Mid-Coast Maine
Csec21VesHome3
Number
1. Vessel Home Port Lower Mid-Coast Maine
Csec21VesHome4
Number
1. Vessel Home Port Southern Maine
Csec21VesHome5
Number
1. Vessel Home Port New Hampshire Coast
Csec21VesHome6
Number
1. Vessel Home Port Gloucester/North Shore
Csec21VesHome7
Number
1. Vessel Home Port Boston/South Shore
Csec21VesHome8
Number
1. Vessel Home Port Cape and Islands
Csec21VesHome9
Number
1. Vessel Home Port New Bedford Area
Csec21VesHome10
Number
1. Vessel Home Port Rhode Island
Csec21VesHome11
Number
1. Vessel Home Port Connecticut Coast
Csec21VesHome12
Number
1. Vessel Home Port Non-Coastal New England
Csec21VesHome13
Number
1. Vessel Home Port Outside New England
Csec21Home1
Number
2. Crew Home Downeast Maine
Csec21Home2
Number
2. Crew Home Upper Mid-Coast Maine
Csec21Home3
Number
2. Crew Home Lower Mid-Coast Maine
Csec21Home4
Number
2. Crew Home Southern Maine
Csec21Home5
Number
2. Crew Home New Hampshire Coast
Csec21Home6
Number
2. Crew Home Gloucester/North Shore
Csec21Home7
Number
2. Crew Home Boston/South Shore
Csec21Home8
Number
2. Crew Home Cape and Islands
Csec21Home9
Number
2. Crew Home New Bedford Area
Csec21Home10
Number
2. Crew Home Rhode Island
Csec21Home11
Number
2. Crew Home Connecticut Coast
Csec21Home12
Number
2. Crew Home Non-Coastal New England
Csec21Home13
Number
2. Crew Home Outside New England
Csec21Spent%1
Text
3. Percent breakdown of spending Downeast Maine
Csec21Spent%2
Text
3. Percent breakdown of spending Upper Mid-Coast Maine
Csec21Spent%3
Text
3. Percent breakdown of spending Lower Mid-Coast Maine
Csec21Spent%4
Text
3. Percent breakdown of spending Southern Maine
Csec21Spent%5
Text
3. Percent breakdown of spending New Hampshire Coast
Csec21Spent%6
Text
3. Percent breakdown of spending Gloucester/North Shore
Csec21Spent%7
Text
3. Percent breakdown of spending Boston/South Shore
Csec21Spent%8
Text
3. Percent breakdown of spending Cape and Islands
Csec21Spent%9
Text
3. Percent breakdown of spending New Bedford Area
Csec21Spent%10
Text
3. Percent breakdown of spending Rhode Island
Csec21Spent%11
Text
3. Percent breakdown of spending Connecticut Coast
Csec21Spent%12
Text
3. Percent breakdown of spending Non-Coastal New England
Csec21Spent%13
Text
3. Percent breakdown of spending Outside New England

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: TblCrewSec21
Short Name: TblCrewSec21
Status: Completed
Abstract:

Table holding the information from the Crew Survey Section 2 (Expenditure Impacts of Fishing Industry in New England) Table 1

Entity Information

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

Table holding the information from the Crew Survey Section 2 (Expenditure Impacts of Fishing Industry in New England) Table 1

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CSec21ID Number Autonumber key
100
CrewID Number Crew Identifier
100
LastName Text Crew Last Name
100
FirstName Text Crew First Name
100
Vessel1Permit# Text Vessels Multispecies Groundfish Permit Number
100
Csec21VesHome1 Number 1. Vessel Home Port Downeast Maine
100
Csec21VesHome2 Number 1. Vessel Home Port Upper Mid-Coast Maine
100
Csec21VesHome3 Number 1. Vessel Home Port Lower Mid-Coast Maine
100
Csec21VesHome4 Number 1. Vessel Home Port Southern Maine
100
Csec21VesHome5 Number 1. Vessel Home Port New Hampshire Coast
100
Csec21VesHome6 Number 1. Vessel Home Port Gloucester/North Shore
100
Csec21VesHome7 Number 1. Vessel Home Port Boston/South Shore
100
Csec21VesHome8 Number 1. Vessel Home Port Cape and Islands
100
Csec21VesHome9 Number 1. Vessel Home Port New Bedford Area
100
Csec21VesHome10 Number 1. Vessel Home Port Rhode Island
100
Csec21VesHome11 Number 1. Vessel Home Port Connecticut Coast
100
Csec21VesHome12 Number 1. Vessel Home Port Non-Coastal New England
100
Csec21VesHome13 Number 1. Vessel Home Port Outside New England
100
Csec21Home1 Number 2. Crew Home Downeast Maine
100
Csec21Home2 Number 2. Crew Home Upper Mid-Coast Maine
100
Csec21Home3 Number 2. Crew Home Lower Mid-Coast Maine
100
Csec21Home4 Number 2. Crew Home Southern Maine
100
Csec21Home5 Number 2. Crew Home New Hampshire Coast
100
Csec21Home6 Number 2. Crew Home Gloucester/North Shore
100
Csec21Home7 Number 2. Crew Home Boston/South Shore
100
Csec21Home8 Number 2. Crew Home Cape and Islands
100
Csec21Home9 Number 2. Crew Home New Bedford Area
100
Csec21Home10 Number 2. Crew Home Rhode Island
100
Csec21Home11 Number 2. Crew Home Connecticut Coast
100
Csec21Home12 Number 2. Crew Home Non-Coastal New England
100
Csec21Home13 Number 2. Crew Home Outside New England
100
Csec21Spent%1 Text 3. Percent breakdown of spending Downeast Maine
100
Csec21Spent%2 Text 3. Percent breakdown of spending Upper Mid-Coast Maine
100
Csec21Spent%3 Text 3. Percent breakdown of spending Lower Mid-Coast Maine
100
Csec21Spent%4 Text 3. Percent breakdown of spending Southern Maine
100
Csec21Spent%5 Text 3. Percent breakdown of spending New Hampshire Coast
100
Csec21Spent%6 Text 3. Percent breakdown of spending Gloucester/North Shore
100
Csec21Spent%7 Text 3. Percent breakdown of spending Boston/South Shore
100
Csec21Spent%8 Text 3. Percent breakdown of spending Cape and Islands
100
Csec21Spent%9 Text 3. Percent breakdown of spending New Bedford Area
100
Csec21Spent%10 Text 3. Percent breakdown of spending Rhode Island
100
Csec21Spent%11 Text 3. Percent breakdown of spending Connecticut Coast
100
Csec21Spent%12 Text 3. Percent breakdown of spending Non-Coastal New England
100
Csec21Spent%13 Text 3. Percent breakdown of spending Outside New England

Attribute Details

CSec21ID

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

Autonumber key

General Data Type: Number

CrewID

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

Crew Identifier

General Data Type: Number

LastName

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

Crew Last Name

General Data Type: Text

FirstName

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

Crew First Name

General Data Type: Text

Vessel1Permit#

CC ID: 363655
Seq. Order: 5
Data Storage Type: Text
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Vessels Multispecies Groundfish Permit Number

General Data Type: Text

Csec21VesHome1

CC ID: 363656
Seq. Order: 6
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Downeast Maine

General Data Type: Number

Csec21VesHome2

CC ID: 363657
Seq. Order: 7
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Upper Mid-Coast Maine

General Data Type: Number

Csec21VesHome3

CC ID: 363658
Seq. Order: 8
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Lower Mid-Coast Maine

General Data Type: Number

Csec21VesHome4

CC ID: 363659
Seq. Order: 9
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Southern Maine

General Data Type: Number

Csec21VesHome5

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

1. Vessel Home Port New Hampshire Coast

General Data Type: Number

Csec21VesHome6

CC ID: 363661
Seq. Order: 11
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Gloucester/North Shore

General Data Type: Number

Csec21VesHome7

CC ID: 363662
Seq. Order: 12
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Boston/South Shore

General Data Type: Number

Csec21VesHome8

CC ID: 363663
Seq. Order: 13
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Cape and Islands

General Data Type: Number

Csec21VesHome9

CC ID: 363664
Seq. Order: 14
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port New Bedford Area

General Data Type: Number

Csec21VesHome10

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

1. Vessel Home Port Rhode Island

General Data Type: Number

Csec21VesHome11

CC ID: 363666
Seq. Order: 16
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Connecticut Coast

General Data Type: Number

Csec21VesHome12

CC ID: 363667
Seq. Order: 17
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Non-Coastal New England

General Data Type: Number

Csec21VesHome13

CC ID: 363668
Seq. Order: 18
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

1. Vessel Home Port Outside New England

General Data Type: Number

Csec21Home1

CC ID: 363669
Seq. Order: 19
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Downeast Maine

General Data Type: Number

Csec21Home2

CC ID: 363670
Seq. Order: 20
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Upper Mid-Coast Maine

General Data Type: Number

Csec21Home3

CC ID: 363671
Seq. Order: 21
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Lower Mid-Coast Maine

General Data Type: Number

Csec21Home4

CC ID: 363672
Seq. Order: 22
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Southern Maine

General Data Type: Number

Csec21Home5

CC ID: 363673
Seq. Order: 23
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home New Hampshire Coast

General Data Type: Number

Csec21Home6

CC ID: 363674
Seq. Order: 24
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Gloucester/North Shore

General Data Type: Number

Csec21Home7

CC ID: 363675
Seq. Order: 25
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Boston/South Shore

General Data Type: Number

Csec21Home8

CC ID: 363676
Seq. Order: 26
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Cape and Islands

General Data Type: Number

Csec21Home9

CC ID: 363677
Seq. Order: 27
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home New Bedford Area

General Data Type: Number

Csec21Home10

CC ID: 363678
Seq. Order: 28
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Rhode Island

General Data Type: Number

Csec21Home11

CC ID: 363679
Seq. Order: 29
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Connecticut Coast

General Data Type: Number

Csec21Home12

CC ID: 363680
Seq. Order: 30
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Non-Coastal New England

General Data Type: Number

Csec21Home13

CC ID: 363681
Seq. Order: 31
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

2. Crew Home Outside New England

General Data Type: Number

Csec21Spent%1

CC ID: 363682
Seq. Order: 32
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Downeast Maine

General Data Type: Text

Csec21Spent%2

CC ID: 363683
Seq. Order: 33
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Upper Mid-Coast Maine

General Data Type: Text

Csec21Spent%3

CC ID: 363684
Seq. Order: 34
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Lower Mid-Coast Maine

General Data Type: Text

Csec21Spent%4

CC ID: 363685
Seq. Order: 35
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Southern Maine

General Data Type: Text

Csec21Spent%5

CC ID: 363686
Seq. Order: 36
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending New Hampshire Coast

General Data Type: Text

Csec21Spent%6

CC ID: 363687
Seq. Order: 37
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Gloucester/North Shore

General Data Type: Text

Csec21Spent%7

CC ID: 363688
Seq. Order: 38
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Boston/South Shore

General Data Type: Text

Csec21Spent%8

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

3. Percent breakdown of spending Cape and Islands

General Data Type: Text

Csec21Spent%9

CC ID: 363690
Seq. Order: 40
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending New Bedford Area

General Data Type: Text

Csec21Spent%10

CC ID: 363691
Seq. Order: 41
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Rhode Island

General Data Type: Text

Csec21Spent%11

CC ID: 363692
Seq. Order: 42
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Connecticut Coast

General Data Type: Text

Csec21Spent%12

CC ID: 363693
Seq. Order: 43
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Non-Coastal New England

General Data Type: Text

Csec21Spent%13

CC ID: 363694
Seq. Order: 44
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3. Percent breakdown of spending Outside New England

General Data Type: Text

Catalog Details

Catalog Item ID: 35964
GUID: gov.noaa.nmfs.inport:35964
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-14 12:34+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-14
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-14