2050 Transportation Mode Shares
County-Level Person and Vehicle Trip Data
@kaggle.thedevastator_2050_transportation_mode_shares
County-Level Person and Vehicle Trip Data
@kaggle.thedevastator_2050_transportation_mode_shares
CREATE TABLE n_0_bau_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_0_bau_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_0_bau_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_0_bau_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_0_bau_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_0_bau_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_1a_hd_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_1a_hd_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_1a_hd_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_1a_hd_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_1a_hd_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_1a_hd_tripmodebycounty_2050_raw (
"o_county" BIGINT,
"d_county" BIGINT,
"sov_sdptm" BIGINT,
"hov2_sdptm" BIGINT,
"hov3_sdptm" BIGINT,
"bike_sdptm" BIGINT,
"transit_sdptm" BIGINT,
"sb_sdptm" BIGINT,
"walk_sdptm" BIGINT,
"sov_ldptm" BIGINT,
"hov2_ldptm" BIGINT,
"hov3_ldptm" BIGINT,
"air_ldptm" BIGINT,
"rail_ldptm" BIGINT,
"hsr_ldptm" BIGINT
);
CREATE TABLE n_1b_hdub_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_1b_hdub_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_1b_hdub_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_1b_hdub_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_1b_hdub_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_1b_hdub_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_2a_pricing_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_2a_pricing_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_2a_pricing_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_2a_pricing_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_2a_pricing_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_2a_pricing_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_2b_pricingub_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_2b_pricingub_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_2b_pricingub_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_2b_pricingub_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_2b_pricingub_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_2b_pricingub_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_4a_sharing_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_4a_sharing_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_4a_sharing_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_4a_sharing_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_4a_sharing_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_4a_sharing_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_4b_sharingub_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_4b_sharingub_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_4b_sharingub_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_4b_sharingub_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_4b_sharingub_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_4b_sharingub_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_5a_sharingpricing_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_5a_sharingpricing_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_5a_sharingpricing_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_5a_sharingpricing_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_5a_sharingpricing_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_5a_sharingpricing_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE n_5b_sharingpricingub_tredisexternalpersontripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_5b_sharingpricingub_tredisexternalvehicletripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_pk" DOUBLE,
"hov2_pk" DOUBLE,
"hov3_pk" DOUBLE,
"sov_op" DOUBLE,
"hov2_op" DOUBLE,
"hov3_op" DOUBLE
);
CREATE TABLE n_5b_sharingpricingub_tredispersontripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"bike_sdptm_pk" DOUBLE,
"transit_sdptm_pk" DOUBLE,
"walk_sdptm_pk" DOUBLE,
"n__sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"air_ldptm_pk" DOUBLE,
"rail_ldptm_pk" DOUBLE,
"hsr_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"bike_sdptm_op" DOUBLE,
"transit_sdptm_op" DOUBLE,
"walk_sdptm_op" DOUBLE,
"n__sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE,
"air_ldptm_op" DOUBLE,
"rail_ldptm_op" DOUBLE,
"hsr_ldptm_op" DOUBLE
);
CREATE TABLE n_5b_sharingpricingub_tredisvehicletripsmodebycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm_pk" DOUBLE,
"hov2_sdptm_pk" DOUBLE,
"hov3_sdptm_pk" DOUBLE,
"sov_ldptm_pk" DOUBLE,
"hov2_ldptm_pk" DOUBLE,
"hov3_ldptm_pk" DOUBLE,
"sov_sdptm_op" DOUBLE,
"hov2_sdptm_op" DOUBLE,
"hov3_sdptm_op" DOUBLE,
"sov_ldptm_op" DOUBLE,
"hov2_ldptm_op" DOUBLE,
"hov3_ldptm_op" DOUBLE
);
CREATE TABLE n_5b_sharingpricingub_tredis_cvm_tripsbycounty_2050 (
"o_county" DOUBLE,
"d_county" DOUBLE,
"lcv_pk" DOUBLE,
"mcv_pk" DOUBLE,
"hcv_pk" DOUBLE,
"lcv_op" DOUBLE,
"mcv_op" DOUBLE,
"hcv_op" DOUBLE
);
CREATE TABLE n_5b_sharingpricingub_tripmodebycounty_2050_raw (
"o_county" DOUBLE,
"d_county" DOUBLE,
"sov_sdptm" DOUBLE,
"hov2_sdptm" DOUBLE,
"hov3_sdptm" DOUBLE,
"bike_sdptm" DOUBLE,
"transit_sdptm" DOUBLE,
"sb_sdptm" DOUBLE,
"walk_sdptm" DOUBLE,
"sov_ldptm" DOUBLE,
"hov2_ldptm" DOUBLE,
"hov3_ldptm" DOUBLE,
"air_ldptm" DOUBLE,
"rail_ldptm" DOUBLE,
"hsr_ldptm" DOUBLE
);
CREATE TABLE em_all (
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE,
"sc_name" VARCHAR
);
CREATE TABLE em_vmt_0 (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_1a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_1b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_2a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_2b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_3a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_3b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_4a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_4b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_5a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_5b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_6a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE em_vmt_6b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE,
"co2_auto" DOUBLE,
"nox_auto" DOUBLE,
"pm25_auto" DOUBLE,
"rog_auto" DOUBLE,
"co2_truck" DOUBLE,
"nox_truck" DOUBLE,
"pm25_truck" DOUBLE,
"rog_truck" DOUBLE,
"co2_tol" DOUBLE,
"nox_tol" DOUBLE,
"pm25_tol" DOUBLE,
"rog_tol" DOUBLE
);
CREATE TABLE vmt_0 (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_1a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_1b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_2a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_2b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_3a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_3b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_4a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_4b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_5a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_5b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_6a (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
CREATE TABLE vmt_6b (
"county_code" DOUBLE,
"county_name" VARCHAR,
"vmt_tol" DOUBLE,
"vmt_auto" DOUBLE,
"vmt_truck" DOUBLE
);
Anyone who has the link will be able to view this.