Variables

HOUSEHOLD

Table Name HOUSEHOLD
Key Column(s) SAMPNO
Relationships PERSON (SAMPNO)
VEHICLE (SAMPNO)
PLACE (SAMPNO)
PLACE_TRANSIT (SAMPNO)
LOCATION (SAMPNO)
GPS_PLACE (SAMPNO)
GPS_POINT (SAMPNO)
What is a HOUSEHOLD record? A record in this table represents a household unit that had all of its residents complete all portions of the survey.

1: SAMPNO


2: TRAVDATE


3: TRAVDAY


4: HHSIZE


5: HHVEH


6: AV_CARS


7: RIDEHAIL


8: SMARTAPPS


9: INTL_SIGNS


10: EV_CARS


11: CARS_FUT


12: TRANSIT_FUT


13: TRUCKS_FUT


14: RAIL_FUT


15: PED_FUT


16: COND_FUT


17: DEVELOP_FUT


18: ENVIRO_FUT


19: SAFETY_FUT


20: TRAFF_FUT


21: FUT_OBST


22: FUT_OBST_O


23: TRANSPROB_NIRPC


24: TRANSPROB_NIRPC_O


25: HLIVE


26: RESTYLAST


27: RESTYLAST_O


28: RESTYLAST_ZIP


29: HHINC2


30: HOMEOWN


31: HOMEOWN_O


32: FUTURESURVEY


33: RESTY


34: RESTY_O


35: HHINC


36: DOWNLOAD


37: HHTRIPS


PERSON

Table Name PERSON
Key Column(s) SAMPNO, PERNO
Relationships HOUSEHOLD (SAMPNO)
LOCATION (SAMPNO, PERNO)
PLACE (SAMPNO, PERNO)
PLACE_TRANSIT (SAMPNO, PERNO)
GPS_PLACE (SAMPNO, PERNO)
GPS_POINT (SAMPNO, PERNO)
What is a PERSON record? A record in this table represents an individual household member. Households were instructed to list all persons living in the household. Persons were ordered by the household member that initially responded to the survey invitation.

1: SAMPNO


2: PERNO


3: DATE_COMPLETED


4: RETMODE


5: PROXY


6: PROXYPERNO


7: AGE


8: AAGE


9: AGE18


10: SEX


11: RELATE


12: RELATE_O


13: LIC


14: HISP


15: HISP_O


16: RACE


17: RACE_O


18: SMRTPHN


19: EMPLY_ASK


20: JOBS


21: WKSTAT


22: WKSTAT_O


23: VOLUN_FREQ


24: WPLACE


25: WMODE


26: WMODE_O


27: WPARKRIDE


28: PERVH


29: WRKHRS


30: WTRAV


31: OCCUP


32: OCCUP_O


33: INDUS


34: INDUS_O


35: EMPLY_TRANSIT


36: EMPLY_TRANSIT_O


37: EMPLY_PARK


38: EMPLY_PARK_O


39: STUDE


40: SCHOL


41: SCHOL_O


42: SLOC


43: SWEB


44: SMODE


45: SMODE_O


46: SPARKRIDE


47: EDUC


48: EDUC_O


49: HPTOL


50: HPTOL_O


51: PAY_ALLDAY


52: TOLLS


53: TOLLTRIP


54: TYPDAY


55: TYPDAY_NO


56: TYPPL


57: CARPTOWK


58: WALKTOWK


59: BIKETOWK


60: RIBUS


61: TCOFF


62: TCDAYS


63: COMPR


64: COMPR_O


65: WKFLEX


66: TNC_USE


67: TNC_TYP


68: TNC_COST


69: TNC_PURP


70: DISAB


71: DTYPE_O


72: DTYPE2


73: NOGOWHY


74: NOGOWHY_O


75: NOGOWHY2_1


76: NOGOWHY2_2


77: NOGOWHY2_3


78: NOGOWHY2_4


79: NOGOWHY2_5


80: NOGOWHY2_RF


81: NOGOWHY2_DK


82: TRAVELDATAUSE


83: TRAVELDATADEVICE_1


84: TRAVELDATADEVICE_2


85: TRAVELDATADEVICE_3


86: TRAVELDATADEVICE_SE


87: TRAVELDATADEVICE_RF


88: TRAVELDATADEVICE_DK


89: TRAVELDATADEVICE_O


90: TRAVELDATAMODE_1


91: TRAVELDATAMODE_2


92: TRAVELDATAMODE_3


93: TRAVELDATAMODE_4


94: TRAVELDATAMODE_5


95: TRAVELDATAMODE_SE


96: TRAVELDATAMODE_RF


97: TRAVELDATAMODE_DK


98: TRAVELDATAMODE_O


99: DTYPE_1


100: DTYPE_2


101: DTYPE_3


102: DTYPE_4


103: DTYPE_5


104: DTYPE_6


105: DTYPE_SE


106: DTYPE_RF


107: DTYPE_DK


108: QC_TRIP_PERSON


109: PERTRIPS


VEHICLE

Table Name VEHICLE
Key Column(s) SAMPNO, VEHNO
Relationships HOUSEHOLD (SAMPNO)
PLACE (SAMPNO, VEHNO)
What is a VEHICLE record? A record in this table represents a household vehicle. Participants were asked to list any vehicle that a household person owned, leased or had available for regular use, including motorcycles, mopeds and RVs.

1: SAMPNO


2: VEHNO


3: VEHYEAR


4: MAKE


5: MAKE_O


6: MODEL


7: MODEL_O


8: BODY


9: BODY_O


10: FUEL


11: FUEL_O


12: TRANSP


13: PARKD


14: PARKD_O


PLACE

Table Name PLACE
Key Column(s) SAMPNO, PERNO, PLACENO
Relationships HOUSEHOLD (SAMPNO)
PERSON (SAMPNO, PERNO)
VEHICLE (SAMPNO, VEHNO)
LOCATION (SAMPNO, LOCNO)
PLACE_TRANSIT (SAMPNO, PERNO, PLACENO)
What is a PLACE record? A record in this table represents a place or destination that was reported individually by a household person for the household's instructed travel date. For the travel day survey portion, household participants older than four years of age were asked to report all locations they went to from 3am to 2:59am the next day, regardless of how long they were there, including trips that may have started and ended at the same location, like walk or bicycle trips for exercise.

1: SAMPNO


2: PERNO


3: TRAVELDAYNO


4: PLACENO


5: LOCNO


6: ARRTIME


7: DEPTIME


8: TRAVTIME


9: ACTDUR


10: DISTANCE


11: MODE


12: MODE_O


13: VEHNO


14: CRAVL


15: FARE


16: PAYF


17: PAYF_O


18: PAYPK


19: PKAMT


20: PKBAS


21: PKBAS_O


22: PRKTY


23: PRKTY_O


24: RAND_A


25: TPURP


26: TPURP_O


27: TPURP2


28: TPURP2_O


29: TPURP_VALID


30: TRIP_APPT


31: TRIP_APPT_WHY_1


32: TRIP_APPT_WHY_2


33: TRIP_APPT_WHY_3


34: TRIP_APPT_WHY_4


35: TRIP_APPT_WHY_5


36: TRIP_APPT_WHY_6


37: TRIP_APPT_WHY_SE


38: TRIP_APPT_WHY_RF


39: TRIP_APPT_WHY_DK


40: TRIP_APPT_WHY_O


41: TRIP_APPT_WHY2_1


42: TRIP_APPT_WHY2_2


43: TRIP_APPT_WHY2_3


44: TRIP_APPT_WHY2_4


45: TRIP_APPT_WHY2_5


46: TRIP_APPT_WHY2_SE


47: TRIP_APPT_WHY2_RF


48: TRIP_APPT_WHY2_DK


49: TRIP_APPT_WHY2_O


50: PERNO_1


51: PERNO_2


52: PERNO_3


53: PERNO_4


54: PERNO_5


55: PERNO_6


56: PERNO_7


57: PERNO_8


58: PERNO_9


59: PERNO_10


60: PERNO_11


61: PERNO_12


62: COMPANIONS


63: HHCOUNT


64: NONHHCOUNT


65: HHPARTY


66: PARTY


67: TRANSFER_COUNT


68: QC_LOC


69: QC_JOINT


70: QC_TIME


71: QC_LOOP


72: QC_DAY


73: PLACEID


PLACE_TRANSIT

Table Name PLACE_TRANSIT
Key Column(s) SAMPNO, PERNO, PLACENO, TRANSITNO
Relationships HOUSEHOLD (SAMPNO)
PERSON (SAMPNO, PERNO)
PLACE (SAMPNO, PERNO, PLACENO)
What is a PLACE_TRANSIT record? A record in this table represents a public transit stop or station within a participant-selected Google transit itinerary. A participant had the option to select a Google transit itinerary if they reported using public transportation to get to the reported place. Participants also had the option to refuse selecting one of the four Google-returned itineraries.

1: SAMPNO


2: PERNO


3: PLACENO


4: TRANSITNO


5: DISTANCE


6: DURATION


7: LATITUDE


8: LONGITUDE


9: MODE


10: AGENCY_NAME


11: LINE_NAME


12: LINE_SHORT_NAME


13: DEPARTURE_STOP_NAME


14: DEPARTURE_TIME


15: ARRIVAL_TIME


16: ARRIVAL_STOP_NAME


17: IMPUTED


LOCATION

Table Name LOCATION
Key Column(s) SAMPNO, LOCNO
Relationships HOUSEHOLD (SAMPNO)
What is a LOCATION record? A record in this table represents a geographic location reported at any level of the household. Every household has a home location record. Every person that is a student or worker has a location record. Every place record has a matching location record.

1: SAMPNO


2: LOCNO


3: PERNO


4: LOCTYPE


5: LONGITUDE


6: LATITUDE


7: LOCNAME


8: STREETADDR


9: CITY


10: STATE


11: ZIP


12: COUNTRY


13: FULLADDR


14: FULL_FIPS


15: STATE_FIPS


16: COUNTY_FIPS


17: TRACT_FIPS


18: BLOCK_FIPS


19: CBSA


20: CSA


GPS_DAY

Table Name GPS_DAY
Key Column(s) SAMPNO, PERNO, DAYNO
Relationships HOUSEHOLD (SAMPNO)

PERSON (SAMPNO, PERNO)

GPS_PLACE (SAMPNO, PERNO, DAYNO)

GPS_POINT (SAMPNO, PERNO, DAYNO)
What is a GPS_DAY record? A record in this table represents one of up to six optional GPS-based MyDailyTravel phone application travel days. The optional travel period begins on the day after the primary travel date and ends seven days after.

1: SAMPNO


2: PERNO


3: DAYNO


4: APPDATE


5: APPTRIPS


6: APP_ACTIVITY_BEGIN


7: APP_ACTIVITY_END


8: LOCATION_ACTIVITY


9: ACCELERATION_ACTIVITY


10: REMOVED_PLACES


11: HOME_START


12: HOME_END


GPS_PLACE

Table Name GPS_PLACE
Key Column(s) SAMPNO, PERNO, DAYNO, PLACENO
Relationships HOUSEHOLD (SAMPNO)
PERSON (SAMPNO, PERNO)
LOCATION (SAMPNO, LOCNO)
GPS_POINT (SAMPNO, PERNO, DAYNO, PLACENO)
What is a GPS_PLACE record? A record in this table represents a place that was reported by the GPS-based MyDailyTravel phone application during participant's travel reporting period, day 2 through 7.

1: SAMPNO


2: PERNO


3: DAYNO


4: PLACENO


5: LOCNO


6: ARRTIME


7: DEPTIME


8: TRAVTIME


9: ACTDUR


10: DISTANCE


11: MODE


12: MODE_O


13: TPURP


14: TPURP_O


15: TPURP2


16: TPURP2_O


17: CRAVL


18: PAYPK


19: PKAMT


20: PKBAS


21: PKBAS_O


22: PRKTY


23: PRKTY_O


24: PAYF


25: PAYF_O


26: FARE


27: TRIP_APPT


28: TRIP_APPT_WHY_1


29: TRIP_APPT_WHY_2


30: TRIP_APPT_WHY_3


31: TRIP_APPT_WHY_4


32: TRIP_APPT_WHY_5


33: TRIP_APPT_WHY_6


34: TRIP_APPT_WHY_SE


35: TRIP_APPT_WHY_RF


36: TRIP_APPT_WHY_DK


37: TRIP_APPT_WHY_O


38: TRIP_APPT_WHY2_1


39: TRIP_APPT_WHY2_2


40: TRIP_APPT_WHY2_3


41: TRIP_APPT_WHY2_4


42: TRIP_APPT_WHY2_5


43: TRIP_APPT_WHY2_SE


44: TRIP_APPT_WHY2_RF


45: TRIP_APPT_WHY2_DK


46: TRIP_APPT_WHY2_O


47: INITIATED_BY


48: PLACEID


GPS_POINT

Table Name GPS_POINT
Key Column(s) SAMPNO, PERNO, POINTNO
Relationships HOUSEHOLD (SAMPNO)
PERSON (SAMPNO, PERNO)
GPS_PLACE (SAMPNO, PERNO, DAYNO, PLACENO)
PLACE (SAMPNO, PERNO, PLACENO)
ACCELERATION (SAMPNO, PERNO, TIME_LOCAL)
What is a GPS_POINT record? A record in this table represents a geographic location logged by the GPS-based MyDailyTravel phone application.

1: SAMPNO


2: PERNO


3: PLACENO


4: POINTNO


5: DAYNO


6: TIME_UTC


7: TIME_LOCAL


8: LATITUDE


9: LONGITUDE


10: ALTITUDE


11: SPEED


12: HEADING


13: HDOP


ACCELERATION

Table Name ACCELERATION
Key Column(s) SAMPNO, PERNO, ACCELNO
Relationships HOUSEHOLD (SAMPNO)
PERSON (SAMPNO, PERNO)
PLACE (SAMPNO, PERNO, PLACENO)
GPS_POINT (SAMPNO, PERNO, TIME_LOCAL)
What is a ACCELERATION record? A record in this table represents an acceleration point logged by the GPS-based MyDailyTravel phone application that is between the start time and end time of a travel day place.

1: SAMPNO


2: PERNO


3: PLACENO


4: ACCELNO


5: DAYNO


6: TIME_LOCAL


7: X


8: Y


9: Z


10: VECTOR_MAGNITUDE


Variable Labels

× Download every variable label in one normalized table for use in other tools and documentation.
{355 rows, about 10kb}

Value Labels

× Download every value label in one normalized table for use in other tools and documentation.
{2,960 rows, about 78kb}

Weights



Description
The household and person level survey weights we have provided for the NIRPC data are calibrated separately to household totals and person totals, respectively, from an external data source (in this case, the American Community Survey 5-year data). This is common practice for household surveys, and aligns the expansion estimates from the survey to external totals at the level of each unit separately (households or persons), but it does not guarantee that person level totals obtained using the person weights and person level totals obtained by applying the household weight to each person in the household will agree. For most general planning, using survey weights computed in this manner is appropriate and recommended.

However, if the desire is to establish calibration based targets for activity based models, a consistent set of totals is required, meaning the person weights must be calibrated to the household weights such that the totals agree. We have developed methodology to create these weights for NIRPC as well, and they are provided in the final dataset. While these weights are necessary for modeling, they have more variation than standard survey weights, resulting in lower precision of resulting estimates. As a result, we recommend using the standard survey weights when possible.