Slide Menu
Search Help Show/Hide Menu

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