HHTBS 2016 Dataset Person Day Level Trip Diary

Person day-level trip diary

SQL Table: [hhtbs2016].[day]

Dataset Fields

Field	Description
day_id	unique surrogate key
person_id	unique identifier of person
household_id	unique identifier of household
travel_date	date of travel
travel_day_number	travel day number for person (1-7)
travel_day_of_week	travel day of week
data_source	trip was recorded by rMove or online
completed_household_survey	all household surveys completed on travel date of trip
completed_person_survey	all surveys completed by person on travel date of trip
completed_date	rMove trip; date and time survey was completed
revised_at	rMove trip; Date and time survey was last revised
revised_count	rMove trip; Number of revisions to survey
diary_start_time	online diary; time started diary
diary_end_time	online diary; time ended diary
diary_duration	online diary; minutes spend taking online diary survey
survey_status	diary/summary survey completion status
proxy	online diary; completed by proxy
made_trips	made trips on travel date
no_trips_reason_1	no trips; reason for no trips on travel date
no_trips_reason_2	no trips; reason for no trips on travel date
no_trips_reason_specify_other	no trips; specify other reason for no trips on travel date
number_trips	number of unlinked trips on travel date
number_surveys	number of trip surveys completed on travel date
start_location	online diary; location at 3am on travel date
start_location_other	online diary; specify other location at 3am on travel date
end_location	online diary; location at 3am on day after travel date
end_location_other	online diary; specify other location at 3am on day after travel date
time_telework	employed/volunteer (non-active duty or deployed), all rMoves, 18+ online diary; time spent teleworking on travel date (hours)
time_shop	all rMoves, 18+ online diary; time spent shopping online on travel date (hours)
toll_road	rMove diary; used toll road
toll_road_express	rMove diary; used toll road with express lane
deliver_package	all rMoves, first adult answer online diary; received mailed packages on travel date
deliver_food	all rMoves, first adult answer online diary; had food delivered on travel date
deliver_work	all rMoves, first adult answer online diary; someone came to house to do service/work on travel date
weight_household_456x	household weight recommended for use
weight_household_multiday_factor	household multi-day weight factor
weight_person_multiday_456x	factored person-day weight

Missings Report

Field	Valid Count	Missing Count	Pct. Missing
day_id	62397	0	0
person_id	62397	0	0
household_id	62397	0	0
travel_date	62397	0	0
travel_day_number	62397	0	0
travel_day_of_week	62397	0	0
data_source	62397	0	0
completed_household_survey	61179	1218	2
completed_person_survey	62397	0	0
completed_date	45786	16611	26.6
revised_at	3622	58775	94.2
revised_count	45786	16611	26.6
diary_start_time	4080	58317	93.5
diary_end_time	4080	58317	93.5
diary_duration	4080	58317	93.5
survey_status	62397	0	0
proxy	4080	58317	93.5
made_trips	62397	0	0
no_trips_reason_1	6233	56164	90
no_trips_reason_2	57	62340	99.9
no_trips_reason_specify_other	62397	0	0
number_trips	62397	0	0
number_surveys	62397	0	0
start_location	4079	58318	93.5
start_location_other	62397	0	0
end_location	4080	58317	93.5
end_location_other	62397	0	0
time_telework	34217	28180	45.2
time_shop	49466	12931	20.7
toll_road	40290	22107	35.4
toll_road_express	40273	22124	35.5
deliver_package	48010	14387	23.1
deliver_food	48010	14387	23.1
deliver_work	48011	14386	23.1
weight_household_456x	61179	1218	2
weight_household_multiday_factor	61179	1218	2
weight_person_multiday_456x	61179	1218	2

Categorical Variables Values Report

Field	Count	Pct.
travel_day_of_week
Monday	8331	13.4
Tuesday	9658	15.5
Wednesday	9708	15.6
Thursday	9707	15.6
Friday	8331	13.4
Saturday	8331	13.4
Sunday	8331	13.4
Missing	0	0.0
data_source
rMove	58317	93.5
Online	4080	6.5
Missing	0	0.0
completed_household_survey
No	17555	28.1
Yes	43624	69.9
Not Applicable	1218	2.0
Missing	0	0.0
completed_person_survey
No	8684	13.9
Yes	53713	86.1
Missing	0	0.0
survey_status
Diary/daily summary survey not complete	2124	3.4
Diary/daily summary survey complete	49822	79.8
Diary/daily summary survey not asked	10451	16.7
Not Applicable	0	0.0
proxy
No	2530	4.1
Present while other member filled out survey	728	1.2
Not present while other member filled out survey	822	1.3
Not Applicable	58317	93.5
made_trips
Yes	53938	86.4
No	8459	13.6
Missing	0	0.0
no_trips_reason_1
Did travel, but rMove did not collect any trips	1250	2.0
Not scheduled to work/took day off	1048	1.7
Worked at home (for pay)	424	0.7
Worked around home (not for pay)	1746	2.8
Kids were on school vacation/break	72	0.1
No available transportation	91	0.1
Was sick or caring for another person	628	1.0
Was waiting for visitor/delivery	68	0.1
Other reason (no reason given)	0	0.0
Stayed on base all day	0	0.0
Other reason	906	1.5
Participant non-response	880	1.4
Technical error	0	0.0
Missing	2033	3.3
Not Applicable	53251	85.3
no_trips_reason_2
Did travel, but rMove did not collect any trips	0	0.0
Not scheduled to work/took day off	28	0.0
Worked at home (for pay)	0	0.0
Worked around home (not for pay)	16	0.0
Kids were on school vacation/break	1	0.0
No available transportation	0	0.0
Was sick or caring for another person	5	0.0
Was waiting for visitor/delivery	1	0.0
Other reason (no reason given)	0	0.0
Stayed on base all day	0	0.0
Other reason	6	0.0
Participant non-response	0	0.0
Technical error	0	0.0
Not Applicable	62340	99.9
start_location
Home	3893	6.2
Work (Primary)	25	0.0
Work (Second Jobs)	2	0.0
Other	159	0.3
Not Applicable	58317	93.5
Missing	1	0.0
end_location
Home	3871	6.2
Work (Primary)	25	0.0
Work (Second Jobs)	0	0.0
Other	184	0.3
Not Applicable	58317	93.5
Missing	0	0.0
toll_road
Yes	1859	3.0
No	38431	61.6
Participant non-response	1961	3.1
Technical error	0	0.0
Not Applicable	20146	32.3
toll_road_express
No	39072	62.6
Yes	1201	1.9
Participant non-response	1977	3.2
Technical error	0	0.0
Not Applicable	20147	32.3
deliver_package
No	40750	65.3
Yes	7260	11.6
Participant non-response	2143	3.4
Technical error	0	0.0
Not Applicable	12244	19.6
deliver_food
No	46090	73.9
Yes	1920	3.1
Participant non-response	2143	3.4
Technical error	0	0.0
Not Applicable	12244	19.6
deliver_work
No	42648	68.3
Yes	5363	8.6
Participant non-response	2142	3.4
Technical error	0	0.0
Not Applicable	12244	19.6

Go To Top