About this Dataset

2016 National Census Of Ferry Operators (NCFO)

The 2016 NCFO dataset is comprised of the responses of all operators who completed the 2016 NCFO. The dataset is made up of ferry operator, vessel, terminal and segment data for the 2015 calendar year.
Organization: Department of Transportation
Last updated: 2020-11-12T12:37:06.666077
Tags: ferry, freight, maritime, passenger, terminals, transit, travel, vessels

Tables

Table 1

@usgov.dot_gov_2016_national_census_of_ferry_operators_ncfo.table_1

309.17 kB
880 rows
161 columns

CREATE TABLE table_1 (
  "operator_id" BIGINT,
  "operator_name" VARCHAR,
  "op_strcity" VARCHAR,
  "op_strzip" VARCHAR,
  "url" VARCHAR,
  "op_country" VARCHAR,
  "ticket_revenue" DOUBLE,
  "private_contract_revenue" DOUBLE,
  "advertising_revenue" DOUBLE,
  "public_contract_revenue" DOUBLE,
  "federal_funding_revenue" DOUBLE,
  "state_funding_revenue" DOUBLE,
  "local_funding_revenue" DOUBLE,
  "federal_state_local" DOUBLE,
  "pub_fund_type_1" DOUBLE,
  "pub_fund_source_1" VARCHAR,
  "pub_fund_prog_1" VARCHAR,
  "pub_fund_type_2" DOUBLE,
  "pub_fund_source_2" VARCHAR,
  "pub_fund_prog_2" VARCHAR,
  "pub_fund_type_3" DOUBLE,
  "pub_fund_source_3" VARCHAR,
  "pub_fund_prog_3" VARCHAR,
  "pub_fund_type_4" DOUBLE,
  "pub_fund_source_4" VARCHAR,
  "pub_fund_prog_4" VARCHAR,
  "pub_fund_type_5" DOUBLE,
  "pub_fund_source_5" VARCHAR,
  "pub_fund_prog_5" VARCHAR,
  "pub_fund_type_6" DOUBLE,
  "pub_fund_source_6" VARCHAR,
  "pub_fund_prog_6" VARCHAR,
  "pub_fund_type_7" DOUBLE,
  "pub_fund_source_7" VARCHAR,
  "pub_fund_prog_7" VARCHAR,
  "pub_fund_type_8" DOUBLE,
  "pub_fund_source_8" VARCHAR,
  "pub_fund_prog_8" VARCHAR,
  "surveyyear" BIGINT,
  "segment_id" BIGINT,
  "seg_length" DOUBLE,
  "average_trip_time" BIGINT,
  "season_start_month" DOUBLE,
  "season_start_day" DOUBLE,
  "season_end_month" DOUBLE,
  "season_end_day" DOUBLE,
  "route_rates_regulated" BIGINT,
  "route_rate_regulator" VARCHAR,
  "passengers" DOUBLE,
  "vehicles" DOUBLE,
  "avg_daily_brd_pax" DOUBLE,
  "avg_daily_brd_veh" DOUBLE,
  "vessel1_id" DOUBLE,
  "vessel1_name" VARCHAR,
  "vessel2_id" DOUBLE,
  "vessel2_name" VARCHAR,
  "vessel3_id" DOUBLE,
  "vessel3_name" VARCHAR,
  "segment_name" VARCHAR,
  "seg_terminal1_id" BIGINT,
  "seg_terminal2_id" BIGINT,
  "seg_type" BIGINT,
  "serves_nps" BIGINT,
  "terminal_name1" VARCHAR,
  "term_city1" VARCHAR,
  "term_state1" VARCHAR,
  "term_country1" VARCHAR,
  "terminal_1_location" VARCHAR,
  "parking1" BIGINT,
  "local_bus1" BIGINT,
  "intercity_bus1" BIGINT,
  "local_rail1" BIGINT,
  "intercity_rail1" BIGINT,
  "terminal_ownership1" BIGINT,
  "terminal_operation1" BIGINT,
  "terminal_name2" VARCHAR,
  "term_city2" VARCHAR,
  "term_state2" VARCHAR,
  "term_country2" VARCHAR,
  "n__terminal_location2" VARCHAR  -- TERMINAL LOCATION2,
  "parking2" BIGINT,
  "local_bus2" BIGINT,
  "intercity_bus2" BIGINT,
  "local_rail2" BIGINT,
  "intercity_rail2" BIGINT,
  "terminal_ownership2" BIGINT,
  "terminal_operation2" BIGINT,
  "mainhorsepowerahead" DOUBLE,
  "mainhorsepowerastern" DOUBLE,
  "hullmaterial" DOUBLE,
  "hullshape" DOUBLE,
  "propulsiontype" DOUBLE,
  "selfpropindicator" BIGINT,
  "vessel_owned_by" VARCHAR,
  "vessel_operated_by" VARCHAR,
  "uscg_number1" DOUBLE,
  "in_service1" DOUBLE,
  "carries_passengers1" DOUBLE,
  "carries_vehicles1" DOUBLE,
  "carries_freight1" DOUBLE
);