Name: 2020 NCFO Vessels File
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2020 NCFO Vessels File

This is the Vessels 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:56.571195
Tags: ferry, ferry-operators, ferry-transit, passenger-ferry, transportation, water-transportation

Tables

Table 1

@usgov.dot_gov_2020_ncfo_vessels_file.table_1

73.67 kB
756 rows
35 columns

CREATE TABLE table_1 (
  "vessel_id" BIGINT,
  "operator_id" BIGINT,
  "vessel_name" VARCHAR,
  "uscg_number" VARCHAR,
  "in_service" BOOLEAN,
  "carries_passengers" VARCHAR,
  "carries_vehicles" VARCHAR,
  "carries_freight" VARCHAR,
  "passenger_capacity" DOUBLE,
  "vehicle_capacity" DOUBLE,
  "fuel_type" VARCHAR,
  "fuel_other" VARCHAR,
  "typical_speed" DOUBLE,
  "year_built" DOUBLE,
  "main_horsepower_ahead" DOUBLE,
  "main_horsepower_astern" DOUBLE,
  "hull_material" DOUBLE,
  "hull_shape" DOUBLE,
  "propulsion_type" DOUBLE,
  "self_prop_indicator" DOUBLE,
  "registered_breadth" DOUBLE,
  "registered_depth" DOUBLE,
  "registered_length" DOUBLE,
  "registered_net_tons" DOUBLE,
  "registered_gross_tons" DOUBLE,
  "vessel_ownership" VARCHAR,
  "vessel_owned_by" VARCHAR,
  "vessel_operation" VARCHAR,
  "vessel_operated_by" VARCHAR,
  "fuel_mileage" DOUBLE,
  "ada_accessible" VARCHAR,
  "expected_lifespan" DOUBLE,
  "census_year_miles" DOUBLE,
  "census_year" BIGINT,
  "data_year" BIGINT
);