2022 NCFO Operator Segments File
Department of Transportation
@usgov.dot_gov_2022_ncfo_operator_segments_file
Department of Transportation
@usgov.dot_gov_2022_ncfo_operator_segments_file
CREATE TABLE table_1 (
"operator_id" BIGINT,
"segment_id" BIGINT,
"segment_length" DOUBLE,
"average_trip_time" BIGINT,
"segment_season_start" VARCHAR,
"segment_season_end" VARCHAR,
"trips_per_year" DOUBLE,
"route_rates_regulated" VARCHAR,
"route_rate_regulator" VARCHAR,
"most_used_vessel_id" VARCHAR,
"vessel_id1" DOUBLE,
"vessel_id2" DOUBLE,
"vessel_id3" DOUBLE,
"vessel_id4" DOUBLE,
"vessel_id5" DOUBLE,
"vessel_id6" DOUBLE,
"vessel_id7" DOUBLE,
"vessel_id8" DOUBLE,
"vessel_id9" DOUBLE,
"vessel_id10" DOUBLE,
"vessel_id11" DOUBLE,
"vessel_id12" DOUBLE,
"vessel_id13" DOUBLE,
"passengers" DOUBLE,
"vehicles" DOUBLE,
"avg_daily_brd_pax" DOUBLE,
"avg_daily_brd_veh" DOUBLE,
"census_year" BIGINT,
"data_year" BIGINT
);
Anyone who has the link will be able to view this.