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