HHTBS 2016 Dataset Households

Household list

SQL Table: [hhtbs2016].[households]

Dataset Fields

Field	Description
household_id	unique identifier of household
sample_segment	sample segment name
sample_group	sample participation group
travel_date_start	assigned travel date
recruit_survey_where	where recruit survey was completed
recruit_survey_mobile	recruit survey was completed on mobile device
recruit_survey_start	recruit survey start time PST
recruit_survey_end	recruit survey end time PST
number_rmove_participants	number of rMove participants in household
participate_future_studies	willing to participate in future studies
household_completed	household has one day where all surveys are answered
completed_days	number of days where all surveys answered by household
language	preferred language for future communications
language_other	specify other language if selected
persons	number of household members
adults	number of household adults
children	number of household children
workers	number of household workers
vehicles	number of household vehicles
bicycles	number of household bicycles
has_share_car	household belongs to a car share
has_share_bicycle	household belongs to a bike share
has_share_vanpool	household belongs to a van-pool
address	home address
latitude	home location latitude
longitude	home location longitude
shape	home location shape attribute (EPSG: 2230)
mgra_13	home location Series 13 MGRA
residence_duration	duration at current residence
residence_tenure_status	residence tenure status
residence_type	type of residence
income_category_detailed	previous year household income detailed categories
income_category_broad	previous year household income broad categories
use_paper_maps	household uses paper maps for trip planning
freq_paper_maps	frequency household uses paper maps for trip planning
use_car_navigation	household uses car navigation for trip planning
freq_car_navigation	frequency household uses car navigation for trip planning
use_511sd	household uses 511sd for trip planning
freq_511sd	frequency household uses 511sd for trip planning
use_apple_maps	household uses apple maps for trip planning
freq_apple_maps	frequency household uses apple maps for trip planning
use_car2go	household uses car2go for trip planning
freq_car2go	frequency household uses car2go for trip planning
use_google_maps	household uses google maps for trip planning
freq_google_maps	frequency household uses google maps for trip planning
use_icommutesd	household uses iCommuteSD for trip planning
freq_icommutesd	frequency household uses iCommuteSD for trip planning
use_lyft	household uses Lyft for trip planning
freq_lyft	frequency household uses Lyft for trip planning
use_mapmyride	household uses MapMyRide for trip planning
freq_mapmyride	frequency household uses MapMyRide for trip planning
use_mapquest	household uses MapQuest for trip planning
freq_mapquest	frequency household uses MapQuest for trip planning
use_sdmts	household uses SD MTS for trip planning
freq_sdmts	frequency household uses SD MTS for trip planning
use_nctd	household uses NCTD for trip planning
freq_nctd	frequency household uses NCTD for trip planning
use_waze	household uses Waze for trip planning
freq_waze	frequency household uses Waze for trip planning
use_uber	household uses Uber for trip planning
freq_uber	frequency household uses Uber for trip planning
use_other_tool	household uses other tool for trip planning
specify_other_tool	specify other tool household uses for trip planning
freq_other_tool	frequency household uses other tool for trip planning
use_no_navigation_tools	household uses no navigation tools
freq_cross_border	frequency household crosses the border
weight_household_initial	initial household expansion weight
weight_household_4x	household weight with maximum of 4x initial weight
weight_household_456x	household weight recommended for use

Missings Report

Field	Valid Count	Missing Count	Pct. Missing
household_id	6300	0	0
sample_segment	6300	0	0
sample_group	6300	0	0
travel_date_start	6284	16	0.3
recruit_survey_where	6199	101	1.6
recruit_survey_mobile	6300	0	0
recruit_survey_start	6300	0	0
recruit_survey_end	6300	0	0
number_rmove_participants	6300	0	0
participate_future_studies	5426	874	13.9
household_completed	6300	0	0
completed_days	6300	0	0
language	6300	0	0
language_other	6300	0	0
persons	6300	0	0
adults	6300	0	0
children	6300	0	0
workers	6300	0	0
vehicles	6300	0	0
bicycles	6300	0	0
has_share_car	6300	0	0
has_share_bicycle	6300	0	0
has_share_vanpool	6300	0	0
address	6300	0	0
latitude	6300	0	0
longitude	6300	0	0
shape	6300	0	0
mgra_13	6300	0	0
residence_duration	6300	0	0
residence_tenure_status	6300	0	0
residence_type	6300	0	0
income_category_detailed	6300	0	0
income_category_broad	6300	0	0
use_paper_maps	6300	0	0
freq_paper_maps	1368	4932	78.3
use_car_navigation	6300	0	0
freq_car_navigation	1932	4368	69.3
use_511sd	6300	0	0
freq_511sd	283	6017	95.5
use_apple_maps	6300	0	0
freq_apple_maps	1266	5034	79.9
use_car2go	6300	0	0
freq_car2go	93	6207	98.5
use_google_maps	6300	0	0
freq_google_maps	4958	1342	21.3
use_icommutesd	6300	0	0
freq_icommutesd	64	6236	99
use_lyft	6300	0	0
freq_lyft	886	5414	85.9
use_mapmyride	6300	0	0
freq_mapmyride	394	5906	93.7
use_mapquest	6300	0	0
freq_mapquest	1767	4533	72
use_sdmts	6300	0	0
freq_sdmts	1123	5177	82.2
use_nctd	6300	0	0
freq_nctd	392	5908	93.8
use_waze	6300	0	0
freq_waze	1304	4996	79.3
use_uber	6300	0	0
freq_uber	1549	4751	75.4
use_other_tool	6300	0	0
specify_other_tool	6300	0	0
freq_other_tool	479	5821	92.4
use_no_navigation_tools	6300	0	0
freq_cross_border	6300	0	0
weight_household_initial	6199	101	1.6
weight_household_4x	6199	101	1.6
weight_household_456x	6199	101	1.6

Categorical Variables Values Report

Field	Count	Pct.
sample_segment
AT segment	101	1.6
Hispanic oversample	495	7.9
Other oversample	479	7.6
Regular	2983	47.3
Transportation oversample	2242	35.6
Missing	0	0.0
sample_group
Group 1: rMove only	3912	62.1
Group 3: Online diary only	2077	33.0
Group 4: Split HH: some rMove, some online diary	210	3.3
Group 5: AT/Intercept (rMove only)	101	1.6
Missing	0	0.0
recruit_survey_where
Recruit survey completed online	5650	89.7
Recruit survey completed via call center	549	8.7
Not Applicable	101	1.6
Missing	0	0.0
recruit_survey_mobile
Recruit survey was not completed on mobile device	5399	85.7
Recruit survey was completed on mobile device	901	14.3
Missing	0	0.0
participate_future_studies
Yes	5024	79.7
No	402	6.4
Missing	874	13.9
household_completed
No	24	0.4
Yes	6276	99.6
Missing	0	0.0
language
English	6239	99.0
Spanish	49	0.8
Other	12	0.2
Missing	0	0.0
persons
0	0	0.0
1	2520	40.0
2	2411	38.3
3	645	10.2
4	510	8.1
5	154	2.4
6	47	0.7
7	8	0.1
8	2	0.0
9	1	0.0
10	1	0.0
11	0	0.0
12+	1	0.0
Missing	0	0.0
adults
0	0	0.0
1	2703	42.9
2	3147	50.0
3	330	5.2
4	83	1.3
5	29	0.5
6	5	0.1
7	2	0.0
8	0	0.0
9	0	0.0
10	0	0.0
11	1	0.0
12+	0	0.0
Missing	0	0.0
children
0	5149	81.7
1	549	8.7
2	447	7.1
3	118	1.9
4	31	0.5
5	5	0.1
6	0	0.0
7	1	0.0
8	0	0.0
9	0	0.0
10	0	0.0
11+	0	0.0
Missing	0	0.0
workers
0	1943	30.8
1	2580	41.0
2	1616	25.7
3	122	1.9
4	26	0.4
5	13	0.2
6	0	0.0
7	0	0.0
8	0	0.0
9	0	0.0
10	0	0.0
11+	0	0.0
Missing	0	0.0
vehicles
0	496	7.9
1	2633	41.8
2	2295	36.4
3	631	10.0
4	191	3.0
5	35	0.6
6	10	0.2
7+	9	0.1
Missing	0	0.0
bicycles
0	3042	48.3
1	1302	20.7
2	1053	16.7
3	418	6.6
4	275	4.4
5	115	1.8
6	57	0.9
7	21	0.3
8	17	0.3
9	0	0.0
10+	0	0.0
Missing	0	0.0
has_share_car
No	6109	97.0
Yes	191	3.0
Missing	0	0.0
has_share_bicycle
No	6275	99.6
Yes	25	0.4
Missing	0	0.0
has_share_vanpool
No	6279	99.7
Yes	21	0.3
Missing	0	0.0
residence_duration
Less than a year	661	10.5
Between 1 and 2 years	672	10.7
Between 2 and 3 years	557	8.8
Between 3 and 5 years	779	12.4
Between 5 and 10 years	1027	16.3
Between 10 and 20 years	1333	21.2
More than 20 years	1271	20.2
Missing	0	0.0
residence_tenure_status
Own/Buying (paying mortgage)	3669	58.2
Rent	2454	39.0
Provided by job or military	30	0.5
Other	80	1.3
Prefer not to answer	67	1.1
Missing	0	0.0
residence_type
Single-family house (detached house)	2905	46.1
Townhouse (attached house)	616	9.8
Building with 3 or fewer apartments/condos	217	3.4
Building with 4 or more apartments/condos	2339	37.1
Mobile home/trailer	188	3.0
Dorm, barracks, or institutional housing	20	0.3
Other (including boat, RV, van, etc.)	15	0.2
Missing	0	0.0
income_category_detailed
Under $15,000	446	7.1
$15,000-$29,999	549	8.7
$30,000-$44,999	565	9.0
$45,000-$59,999	586	9.3
$60,000-$74,999	550	8.7
$75,000-$99,999	790	12.5
$100,000-$124,999	644	10.2
$125,000-$149,999	415	6.6
$150,000-$199,999	440	7.0
$200,000-$249,999	208	3.3
$250,000 or more	209	3.3
Prefer not to answer	898	14.3
Missing	0	0.0
income_category_broad
Under $30,000	1030	16.3
$30,000-$59,999	1197	19.0
$60,000-$99,999	1406	22.3
$100,000-$149,999	1118	17.7
$150,000 or more	925	14.7
Prefer not to answer	624	9.9
Missing	0	0.0
use_paper_maps
No	4932	78.3
Yes	1368	21.7
Missing	0	0.0
freq_paper_maps
Less than once a week	1244	19.7
A few times a week	109	1.7
Daily or more	15	0.2
Not Applicable	4932	78.3
use_car_navigation
No	4368	69.3
Yes	1932	30.7
Missing	0	0.0
freq_car_navigation
Less than once a week	981	15.6
A few times a week	687	10.9
Daily or more	264	4.2
Not Applicable	4368	69.3
use_511sd
No	6017	95.5
Yes	283	4.5
Missing	0	0.0
freq_511sd
Less than once a week	217	3.4
A few times a week	53	0.8
Daily or more	13	0.2
Not Applicable	6017	95.5
use_apple_maps
No	5034	79.9
Yes	1266	20.1
Missing	0	0.0
freq_apple_maps
Less than once a week	489	7.8
A few times a week	591	9.4
Daily or more	186	3.0
Not Applicable	5034	79.9
use_car2go
No	6207	98.5
Yes	93	1.5
Missing	0	0.0
freq_car2go
Less than once a week	84	1.3
A few times a week	6	0.1
Daily or more	3	0.0
Not Applicable	6207	98.5
use_google_maps
No	1342	21.3
Yes	4958	78.7
Missing	0	0.0
freq_google_maps
Less than once a week	1892	30.0
A few times a week	2053	32.6
Daily or more	1013	16.1
Not Applicable	1342	21.3
use_icommutesd
No	6236	99.0
Yes	64	1.0
Missing	0	0.0
freq_icommutesd
Less than once a week	56	0.9
A few times a week	5	0.1
Daily or more	3	0.0
Not Applicable	6236	99.0
use_lyft
No	5414	85.9
Yes	886	14.1
Missing	0	0.0
freq_lyft
Less than once a week	748	11.9
A few times a week	129	2.0
Daily or more	9	0.1
Not Applicable	5414	85.9
use_mapmyride
No	5906	93.7
Yes	394	6.3
Missing	0	0.0
freq_mapmyride
Less than once a week	234	3.7
A few times a week	132	2.1
Daily or more	28	0.4
Not Applicable	5906	93.7
use_mapquest
No	4533	72.0
Yes	1767	28.0
Missing	0	0.0
freq_mapquest
Less than once a week	1382	21.9
A few times a week	345	5.5
Daily or more	40	0.6
Not Applicable	4533	72.0
use_sdmts
No	5177	82.2
Yes	1123	17.8
Missing	0	0.0
freq_sdmts
Less than once a week	892	14.2
A few times a week	179	2.8
Daily or more	52	0.8
Not Applicable	5177	82.2
use_nctd
No	5908	93.8
Yes	392	6.2
Missing	0	0.0
freq_nctd
Less than once a week	347	5.5
A few times a week	38	0.6
Daily or more	7	0.1
Not Applicable	5908	93.8
use_waze
No	4996	79.3
Yes	1304	20.7
Missing	0	0.0
freq_waze
Less than once a week	633	10.0
A few times a week	379	6.0
Daily or more	292	4.6
Not Applicable	4996	79.3
use_uber
No	4751	75.4
Yes	1549	24.6
Missing	0	0.0
freq_uber
Less than once a week	1352	21.5
A few times a week	181	2.9
Daily or more	16	0.3
Not Applicable	4751	75.4
use_other_tool
No	5821	92.4
Yes	479	7.6
Missing	0	0.0
freq_other_tool
Less than once a week	252	4.0
A few times a week	142	2.3
Daily or more	85	1.3
Not Applicable	5821	92.4
use_no_navigation_tools
No	6026	95.7
Yes	274	4.3
Missing	0	0.0
freq_cross_border
0	5752	91.3
1	304	4.8
2	99	1.6
3	46	0.7
4	18	0.3
5	21	0.3
6	5	0.1
7	0	0.0
8	6	0.1
9	1	0.0
10+	24	0.4
Do not know	24	0.4
Missing	0	0.0

Go To Top