2020 NCFO Operator Segment File by US Government | Environmental and Climate Sciences

About this Dataset

2020 NCFO Operator Segment File

This is the Operator Segment file for the 2020 National Census of Ferry Operators. It is one of five data sets that make up the 2020 NCFO
Organization: Department of Transportation
Last updated: 2022-04-28T23:27:59.576615
Tags: ferry, ferry-operators, ferry-transit, passenger-ferry, transportation, water-transportation

Tables

Table 1

@usgov.dot_gov_2020_ncfo_operator_segment_file.table_1

63.66 KB
963 rows
42 columns


CREATE TABLE table_1 (
  "operator_id" BIGINT,
  "segment_id" BIGINT,
  "seg_length" DOUBLE,
  "average_trip_time" DOUBLE,
  "segment_season_start" VARCHAR,
  "segment_season_end" VARCHAR,
  "trips_per_year" DOUBLE,
  "route_rates_regulated" BIGINT,
  "route_rate_regulator" VARCHAR,
  "most_used_vessel_id" DOUBLE,
  "vessel1_id" DOUBLE,
  "vessel2_id" DOUBLE,
  "vessel3_id" DOUBLE,
  "vessel4_id" DOUBLE,
  "vessel5_id" DOUBLE,
  "vessel6_id" DOUBLE,
  "vessel7_id" DOUBLE,
  "vessel8_id" DOUBLE,
  "vessel9_id" DOUBLE,
  "vessel10_id" DOUBLE,
  "vessel11_id" DOUBLE,
  "vessel12_id" DOUBLE,
  "vessel13_id" DOUBLE,
  "vessel14_id" VARCHAR,
  "vessel15_id" VARCHAR,
  "vessel16_id" VARCHAR,
  "vessel17_id" VARCHAR,
  "vessel18_id" VARCHAR,
  "vessel19_id" VARCHAR,
  "vessel20_id" VARCHAR,
  "vessel21_id" VARCHAR,
  "vessel22_id" VARCHAR,
  "vessel23_id" VARCHAR,
  "vessel24_id" VARCHAR,
  "vessel25_id" VARCHAR,
  "vessel26_id" VARCHAR,
  "passengers" DOUBLE,
  "vehicles" DOUBLE,
  "avg_daily_brd_pax" DOUBLE,
  "avg_daily_brd_veh" DOUBLE,
  "census_year" BIGINT,
  "data_year" BIGINT
);