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

About this Dataset

2020 NCFO Operators File

This is the Operators 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:28:17.379033
Tags: ferry, ferry-operators, ferry-transit, passenger-ferry, transportation, water-transportation, waterways-tonnage

Tables

Table 1

@usgov.dot_gov_2020_ncfo_operators_file.table_1

55.67 kB
164 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
);