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