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


Survey results. Make and model of each car or truck owned by household. Odometer reading, year and month of purchase, number of cylinders and odometer reading at time of survey. MPG estimate from US EPA vehicle databases by vehicle.

Years Available: 2008

Principle Investigators

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

View All Experiment and Dataset Methods

ATTRIBUTES

FieldNameDefinitionUnitCode
1HH_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.
2Vehicle_IDThis field contains the Vehicle ID. Each vehicle in this table has a unique ID.
3ModelThis field contains the interpreted MODEL of the vehicle as determined by the TCHEP researchers from the text in the Make_Model field. The researchers made their best effort to determine what the correct model of the vehicle was from the text provide and in doing so may have correct spelling mistakes or interpret the vehicle make based on year, model and any other criteria available in the survey response. This data field contains an interpreted value.
4Make_ModelThis field contains the response to the specific part of survey question 40 that asked about Vehicle make and model. The response is typed in exactly as the respondent wrote it in their survey. If this field is left blank, the area was left blank by the respondent.
5CylindersThis field contains the response to the specific part of survey question 40 that asked about number of cylinders. If this field is blank, the area was left blank by the respondent.
6Purch_YearThis field contains the response to the specific part of survey question 40 that asked about Year the vehicle was purchased. If this field is blank, the area was left blank by the respondent. The value contained in this field is a year.nominalYear
7Purch_MonthThis field contains the response to the specific part of survey question 40 that asked about Month the vehicle was purchased. The value in this field is a number that represents the month from 1-12, where 1=January and 12=December. If this field is blank, the area was left blank by the respondent.
8Purch_MilesThis field contains the response to the specific part of survey question 40 that asked about the number of miles on the vehicle when it was purchased. If this field is left blank, the area was left blank by the respondent. The units are in miles.mile
9Vehicle_yearThis field contains the response to the specific part of survey question 40 that asked about Vehicle Year. The response is typed in exactly as the respondent wrote it in their survey. If this field is blank, the area was left blank by the respondent.nominalYear
10Current_OdometerThis field contains the response to the specific part of survey question 40 that asked about the current odometer value of the vehicle at the time of the survey. If this field is blank, the area was left blank by the respondent. The units are in miles.mile
 

SAMPLE DATASET

HH_IDVehicle_IDModelMake_ModelCylindersPurch_YearPurch_MonthPurch_MilesVehicle_yearCurrent_Odometer
11CHEVY TRUCK820030200356000
12332Yukon 1500 AWDGMC YUKON820060200722000
94208F150 Pickup 2WDFord F15081995500001990208000
95185MalibuChevy Malibu62000180001999155000
95540MalibuChevy Malibu42008522000200724000
122ChargerDODGE CHARGER6200690200613622
122333GMC PICKUP8200215000200087629
123784MalibuCHEVY MALIBU6200827020064447
124084CHEVY PICKUP61997900001992181393
163AltimaNISSON2003
162334AltimaALTIMA4200338000200354000
163785Ranger Pickup 2WDFORD RANGER6199801998155000
          

Download dataset abte267
Twin Cities Household Ecosystem Project: Survey results. Make and model of each car or truck owned by household. Odometer reading, year and month of purchase, number of cylinders and odometer reading at time of survey. MPG estimate from US EPA vehicle databases by vehicle.

*Read more about EML


Report errors in data files here.