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

About this Dataset

2022 NCFO Operators File

A data base of responses to the 2022 National Census of Ferries.

This file gives information about ferry operators.
Organization: Department of Transportation
Last updated: 2024-06-26T20:36:49.759570
Tags: ferry, ferry-operators, ferry-transit, ncfo, passenger-ferry

Tables

Table 1

@usgov.dot_gov_2022_ncfo_operators_file.table_1

54.21 kB
141 rows
51 columns

CREATE TABLE table_1 (
  "operator_id" BIGINT,
  "operator_name" VARCHAR,
  "op_strcity" VARCHAR,
  "op_state" VARCHAR,
  "op_strzip" VARCHAR,
  "op_country" VARCHAR,
  "url" VARCHAR,
  "federal_state_local" BOOLEAN,
  "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,
  "other_funding_revenue" DOUBLE,
  "trip_purpose_commuter_transit" BOOLEAN,
  "trip_purpose_pleasure" BOOLEAN,
  "trip_purpose_emergency" BOOLEAN,
  "trip_purpose_roadway_conn" BOOLEAN,
  "trip_purpose_lifeline" BOOLEAN,
  "trip_purpose_nps" BOOLEAN,
  "trip_purpose_other" BOOLEAN,
  "trip_purpose_other_desc" VARCHAR,
  "accepts_public_funding" BOOLEAN,
  "pub_fund_type_1" VARCHAR,
  "pub_fund_source_1" VARCHAR,
  "pub_fund_prog_1" VARCHAR,
  "pub_fund_type_2" VARCHAR,
  "pub_fund_source_2" VARCHAR,
  "pub_fund_prog_2" VARCHAR,
  "pub_fund_type_3" VARCHAR,
  "pub_fund_source_3" VARCHAR,
  "pub_fund_prog_3" VARCHAR,
  "pub_fund_type_4" VARCHAR,
  "pub_fund_source_4" VARCHAR,
  "pub_fund_prog_4" VARCHAR,
  "pub_fund_type_5" VARCHAR,
  "pub_fund_source_5" VARCHAR,
  "pub_fund_prog_5" VARCHAR,
  "pub_fund_type_6" VARCHAR,
  "pub_fund_source_6" VARCHAR,
  "pub_fund_prog_6" VARCHAR,
  "pub_fund_type_7" VARCHAR,
  "pub_fund_source_7" VARCHAR,
  "pub_fund_prog_7" VARCHAR,
  "pub_fund_type_8" VARCHAR,
  "pub_fund_source_8" VARCHAR,
  "pub_fund_prog_8" VARCHAR,
  "census_year" BIGINT,
  "data_year" BIGINT
);