Item Identification

Title: Social_Vulnerability_Entities

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Data dictionary for the social vulnerability indices used in the "Coral Reef Resilience and Social Vulnerability to Climate Change" reports for the main Hawaiian Islands, Guam, the Commonwealth of the Northern Mariana Islands, and American Samoa.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Community TEXT Layman's description of Community area.
100
CCD TEXT Census County Division name (long form).
100
CCD_Name TEXT Census County Division name (short form).
100
GEO_ID2 NUMBER Census County Division fully qualified geographic identifier (American Community Census, geoid2). This is the field to join the data in this table with the GEOID field in the TIGER Line shapefiles for County Subdivisions, so the data can be plotted in a mapping application (e.g., ArcGIS).
100
County NUMBER County Code, (American Community Census).
100
State NUMBER State Code, (American Community Census).
100
Island.Group TEXT Regional two-letter code. HI=Hawaii, AS=American Samoa, GU=Guam, and MP=Commonwealth of the Northern Mariana Islands.
100
Raw.Index.Val_Housing.Charcter. NUMBER Un-normalized principal component analysis (PCA) axis metric of Housing Characteristics: The housing characteristics index highlights the character of housing available within a community and measures the median rent (lowers vulnerability), median number of rooms in family dwellings (lowers vulnerability), and the percentage of houses that lack plumbing facilities (increases vulnerability).
100
Raw.Index.Val_Labor.Force NUMBER Un-normalized principal component analysis (PCA) axis metric of Labor Force Structure: Labor force structure index provides an indication of the strength and stability of the labor force, including variables on the percent of females in the labor force (lowers vulnerability), the percent of those in the service industry (lowers vulnerability), as well as the percent of families with income under $10,000 (increases vulnerability).
100
Raw.Index.Val_Personal.Disruption NUMBER Un-normalized principal component analysis (PCA) axis metric of Personal Disruption: The personal disruption index includes variables that might indicate unstable personal circumstances, including poverty (increases vulnerability), unemployment (increases vulnerability), and low educational attainment (increases vulnerability).
100
Raw.Index.Val_Population.Comp. NUMBER Un-normalized principal component analysis (PCA) axis metric of Population Composition: The population composition index describes demographic variables identified as indicators of socially vulnerable populations, including the percent of young children (increases vulnerability), the percent of female-headed households (increases vulnerability), and the percent of people without a Bachelor's degree (increases vulnerability).
100
Raw.Index.Val_Poverty NUMBER Un-normalized principal component analysis (PCA) axis metric of Poverty: The poverty index highlights the percentage of the total population in poverty (increases vulnerability) as well as the percentage in poverty of other vulnerable groups such as children (under 18; increases vulnerability), families with children under 5 (increases vulnerability), and single-female headed families (increases vulnerability).
100
Flag_RegionalReference_Housing.Charcter. NUMBER Leveled Housing Characteristic Metric: Housing Characteristic principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).
100
Flag_RegionalReference_Labor.Force NUMBER Leveled Labor Force Structure Metric: Labor Force Structure principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).
100
Flag_RegionalReference_Personal.Disruption NUMBER Leveled Personal Disruption Metric: Personal Disruption principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).
100
Flag_RegionalReference_Population.Comp. NUMBER Leveled Population Composition Metric: Population Composition principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).
100
Flag_RegionalReference_Poverty NUMBER Leveled Poverty Metric: Poverty principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).
100
Flag_RegionalReference_Overall_Aggregate NUMBER Number of underlying leveled social vulnerability metrics rated as "High". Values range from 0-5.

Attribute Details

Community

CC ID: 909067
Seq. Order: 1
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Layman's description of Community area.

CCD

CC ID: 909068
Seq. Order: 2
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Census County Division name (long form).

CCD_Name

CC ID: 909069
Seq. Order: 3
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Census County Division name (short form).

GEO_ID2

CC ID: 909070
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Census County Division fully qualified geographic identifier (American Community Census, geoid2). This is the field to join the data in this table with the GEOID field in the TIGER Line shapefiles for County Subdivisions, so the data can be plotted in a mapping application (e.g., ArcGIS).

County

CC ID: 909071
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

County Code, (American Community Census).

State

CC ID: 909072
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

State Code, (American Community Census).

Island.Group

CC ID: 909073
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Regional two-letter code. HI=Hawaii, AS=American Samoa, GU=Guam, and MP=Commonwealth of the Northern Mariana Islands.

Raw.Index.Val_Housing.Charcter.

CC ID: 909074
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Un-normalized principal component analysis (PCA) axis metric of Housing Characteristics: The housing characteristics index highlights the character of housing available within a community and measures the median rent (lowers vulnerability), median number of rooms in family dwellings (lowers vulnerability), and the percentage of houses that lack plumbing facilities (increases vulnerability).

Raw.Index.Val_Labor.Force

CC ID: 909075
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Un-normalized principal component analysis (PCA) axis metric of Labor Force Structure: Labor force structure index provides an indication of the strength and stability of the labor force, including variables on the percent of females in the labor force (lowers vulnerability), the percent of those in the service industry (lowers vulnerability), as well as the percent of families with income under $10,000 (increases vulnerability).

Raw.Index.Val_Personal.Disruption

CC ID: 909076
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Un-normalized principal component analysis (PCA) axis metric of Personal Disruption: The personal disruption index includes variables that might indicate unstable personal circumstances, including poverty (increases vulnerability), unemployment (increases vulnerability), and low educational attainment (increases vulnerability).

Raw.Index.Val_Population.Comp.

CC ID: 909077
Seq. Order: 11
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Un-normalized principal component analysis (PCA) axis metric of Population Composition: The population composition index describes demographic variables identified as indicators of socially vulnerable populations, including the percent of young children (increases vulnerability), the percent of female-headed households (increases vulnerability), and the percent of people without a Bachelor's degree (increases vulnerability).

Raw.Index.Val_Poverty

CC ID: 909078
Seq. Order: 12
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Un-normalized principal component analysis (PCA) axis metric of Poverty: The poverty index highlights the percentage of the total population in poverty (increases vulnerability) as well as the percentage in poverty of other vulnerable groups such as children (under 18; increases vulnerability), families with children under 5 (increases vulnerability), and single-female headed families (increases vulnerability).

Flag_RegionalReference_Housing.Charcter.

CC ID: 909079
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Leveled Housing Characteristic Metric: Housing Characteristic principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).

Flag_RegionalReference_Labor.Force

CC ID: 909080
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Leveled Labor Force Structure Metric: Labor Force Structure principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).

Flag_RegionalReference_Personal.Disruption

CC ID: 909081
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Leveled Personal Disruption Metric: Personal Disruption principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).

Flag_RegionalReference_Population.Comp.

CC ID: 909082
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Leveled Population Composition Metric: Population Composition principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).

Flag_RegionalReference_Poverty

CC ID: 909083
Seq. Order: 17
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Leveled Poverty Metric: Poverty principal component analysis (PCA) data broken into four levels dependent upon the distribution of values within a Census County Division's region: 1, "Low" (values greater than mean plus one standard deviation); 2, "Med-Low" (values falling between the mean and the mean plus one standard deviation); 3, "Med-High" (values falling between the mean minus one standard deviation and the mean); 4, "High" (values less than the mean minus one standard deviation).

Flag_RegionalReference_Overall_Aggregate

CC ID: 909084
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Number of underlying leveled social vulnerability metrics rated as "High". Values range from 0-5.

Catalog Details

Catalog Item ID: 59259
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2020-04-08 22:48+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-06-26 21:52+0000
Metadata Record Published: 2020-06-26
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-06-27