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_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_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_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_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_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_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_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_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_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_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_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_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_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
);
Anyone who has the link will be able to view this.