Dataset
Twin Cities Household Ecosystem Project - Experiment 267
Survey results. All air travel trips made by households. Business vs. pleasure, miles and number of travelers.
Years Available: 2008
Principle Investigators
Hobbie, Sarah
Baker, Larry
Nelson, Kristen
McFadden, Joe
King, Jennifer
View All Experiment and Dataset Methods
Environmental Data Initiative data package
| EDI Package ID | DOI |
|---|---|
ATTRIBUTES
| Field | Name | Definition | Unit | Code |
|---|---|---|---|---|
| 1 | HH_ID | This 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. | ||
| 2 | Trip_ID | This field contains a unique ID for each trip. A household may have zero to many trips associated with it. | ||
| 3 | Origin | This field contains the original trip origin data, exactly as written by the survey respondent. | ||
| 4 | Destination | This field contains the original trip destination data, exactly as written by the survey respondent. | ||
| 5 | No_Passengers_Original | This field contains the number of passengers for this trip. If there is a blank in a record in this field, the survey respondent did not enter a value. In some analyses, the assumption was made that a blank value should be interpreted one passenger. | number | |
| 6 | Air_Times_Original | This field contains the number of times this trip was made. If there is a blank in a record in this field, the survey respondent did not enter a value. In some analyses, the assumption was made that a blank value should be interpreted one trip. | number | |
| 7 | Purpose | This field contains the code for the purpose of this trip provide by the survey respondent. | 1=personal, 2=business |
SAMPLE DATASET
| HH_ID | Trip_ID | Origin | Destination | No_Passengers_Original | Air_Times_Original | Purpose |
|---|---|---|---|---|---|---|
| 12 | 1 | MINNEAPOLIS | HAWAII | 2 | 1 | 1 |
| 60 | 2 | MINNEAPOLIS | ARIZONA | 4 | 1 | 1 |
| 97 | 3843 | MSP | MKE | 1 | 3 | 2 |
| 97 | 3899 | MSP | ORD | 1 | 2 | 2 |
| 97 | 4050 | MSP | PDX | 1 | 1 | 2 |
| 97 | 4133 | MSP | DFW | 1 | 3 | 2 |
| 97 | 4184 | MSP | RSW | 1 | 2 | 2 |
| 97 | 4219 | MSP | FLL | 1 | 2 | 2 |
| 97 | 4242 | MSP | MCO | 1 | 2 | 2 |
| 97 | 4257 | MSP | BNA | 1 | 2 | 2 |
| 97 | 4266 | MSP | SFO | 1 | 2 | 2 |
| 97 | 4274 | MSP | LAX | 1 | 2 | 2 |
| Download dataset abbe267 Twin Cities Household Ecosystem Project: Survey results. All air travel trips made by households. Business vs. pleasure, miles and number of travelers. | ||
|---|---|---|
| TEXT Format | HTML Format | EML Format* |
*Read more about EML
Report errors in data files here.