University of Minnesota
University of Minnesota
College of Biological Sciences
http://www.cbs.umn.edu/

Dataset

Log Out

Twin Cities Household Ecosystem Project - Experiment 267


Unique household ID relational to all tables. Data, from participating households, on utility company records and tree survey access for UMN survey team.

Years Available: 2008

Principle Investigators

Baker, Larry
Hobbie, Sarah
Nelson, Kristen
McFadden, Joe
King, Jennifer

View All Experiment and Dataset Methods

ATTRIBUTES

FieldNameDefinitionUnitCode
1Energy_infoThis field indicates whether the household provided utility bill access to the TCHEP researchers. If the field is left blank, it means that there is no utility bill data available for this household. The utility bill data are available upon request to the TCHEP research teamY=Electric and Gas data available, G=only Gas data available
2HH_IDThis field contains the Household ID. Each household that responded to the survey has a unique household ID. The ID is stored as a number that is up to 5 digits and is in the range of 1-15000. This ID allows survey response data in different tables to be related to each other.
3OwnedThis field contains that numeric code for the response to survey question 1 about home ownership. If this record is left blank, it means the household did not provide a response to this question.1=Own,2=Rent
4Owned_YearsThis field contains the answer to question 1A, which asked the number of years a household has owned their home (if they indicated they were a homeowner in Question 1). The unit for values in this field is in Years. If this record is left blank, it means the household did not provide a response to this question.nominalYear
52nd_HomeThis field contains the numeric code for the response to survey question 4 about whether the household owns a second home or cabin. If this record is left blank, it means the household did not provide a response to this question. 1=Yes,2=No
62nd_Home_SpendMonths per year spend at 2nd homenominalMonthsPerYear
7HappynessThis field contains the repsonse to question 31 about how happy the survey respondent feels. If this record is left blank, it means the household did not provide a response to this question. 1=Very happy, 2=Pretty happy, 3=Not too happy
8Main_AgeThis field contains the age of the household member answering the survey given in Question 34. This value is given in the units of years. If this record is left blank, it means the household did not provide a response to this question.nominalYear
9Main_GenderThis field contains the gender of the household member answering the survey given in Question 33. If this record is left blank, it means the household did not provide a response to this question. 1=male,2=female
10Main_Race_TextThis field contains free text associated with the selection of "7=Other" in response to question 33. If Other was selected by the respondent, there was a space for the respondent to write in and that text is contained in this field. Use in association with the fields Main_Race1 and Main_Race2. If this record is left blank, it means the household did not provide a response to this question.
11Main_Race1This field contains one of the race selections by the household member answering the survey given in Question 33. If this record is left blank, it means the household did not provide a response to this question. If the respondent selected 7=Other, there was a space for the respondent to write in and that text can be found in the field called: Main_Race_Text. Additionally, if the respondent provided another race slection, it can be found in the field, Main_Race2. 1=Caucasian,2=Hispanic,3=African American,44=Asian or Pacific Islander,5=Native American,6=Alaskan Native,7=Other
12Main_Race2This field contains one of the race selections by the household member answering the survey given in Question 33. If this record is left blank, it means the household did not provide a response to this question. If the respondent selected 7=Other, there was a space for the respondent to write in and that text can be found in the field called: Main_Race_Text. Additionally, if the respondent provided another race slection, it can be found in the field, Main_Race1.1=Caucasian, 2=Hispanic, 3=African American, 4=Asian or Pacific Islander, 5=Native American, 6=Alaskan Native,7=Other
13Neg_EnvEffThis field contains the response to Question 32 about negative environmental effects affecting quality of life. If this record is left blank, it means the household did not provide a response to this question. 1=Unconcerned, 2=Slightly concerned, 3=Neutral, 4=Concerned, 5=Very Concerned
14PNoneThis field contains part of the response to Question 3 about Pets in the survey, where the respondent could check none to indicate they had no pets. If the respondent selected None, there will be a value of 1 in this field, otherwise it will be blank which means the respondent did not check this box. However a household may not have listed any pets and this value might be blank. To ascertain pets listed in this household, it is best to review the Pets table.1=None
15Total_IncomeThis field contains the response to question 38 about household income. If there is no value in this field, it means the respondent did not answer this question.1=Less than $30000, 2=$30000 to $49999, 3=$50000 to $74999, 4=$75000 to $99999, 5=$100000 to $149999, 6=$150000-$199999, 7=$200000 to $249999, 8=$250000 to $299999, 9=More than $300000
16TripsThis field contains part of the response to Question 11 about Air Travel in the survey, where the respondent could check none to indicate they had no pets. If the respondent selected No Trips, there will be a value of 1 in this field, otherwise it will be blank which means the respondent did not check this box. To ascertain actual trips associated with this household, it is best to review the AirTravel table.1=No Trips
17Permission_VisitThis field contains the response to Question 39 about whether the household gave permission for a site visit. If the respondent answered yes, it does not mean that the TCHEP team conducted a site study, but just that the household were initially agreeing to the possibility. If this record is left blank, it means the household did not provide a response to this question.1=Yes,2=No
18360_SamplePart of the 360 sampleY=part of 360 subset
19PhyloDivProjectThis field indicates whether the household was part of Jeannine Cavender-Bares Phylodiversity Project.Y=part of phylodiversity project
 

SAMPLE DATASET

Energy_infoHH_IDOwnedOwned_Years2nd_Home2nd_Home_SpendHappynessMain_AgeMain_GenderMain_Race_TextMain_Race1Main_Race2Neg_EnvEffPNoneTotal_IncomeTripsPermission_Visit360_SamplePhyloDivProject
Y1192137212511
9122228112412
Y1214224711331
Y1611622771131211
Y211122242211311
Y391112248112511
5512156212512
Y6014213821221
82152163114312
Y83120226827211
97142226111141
Y10113411352
                   

Download dataset able267
Twin Cities Household Ecosystem Project: Unique household ID relational to all tables. Data, from participating households, on utility company records and tree survey access for UMN survey team.

*Read more about EML


Report errors in data files here.