About this Dataset

2022 - 2023 NTD Annual Data - Federal Funding Allocation

Dataset containing all of the Federal Funding Allocation inputs submitted by reporting transit agencies to the National Transit Database in the 2022 and 2023 report years. This reflects the most recently published data within the Federal Transit Administration's NTD Data website.
Organization: Department of Transportation
Last updated: 2020-11-12T12:37:20.482324
Tags: allocation, funding, transit

Tables

Table 1

@usgov.dot_gov_federal_funding_allocation.table_1

662.69 kB
12,436 rows
41 columns

CREATE TABLE table_1 (
  "agency" VARCHAR,
  "ntd_id" BIGINT,
  "reporter_type" VARCHAR,
  "mode" VARCHAR,
  "mode_name" VARCHAR,
  "type_of_service" VARCHAR,
  "year" BIGINT,
  "urbanized_area_code" BIGINT,
  "urbanized_area_name" VARCHAR,
  "urbanized_area_population" DOUBLE,
  "urbanized_area_square_miles" DOUBLE,
  "uza_reporting_method" VARCHAR,
  "fg_nfg_reporting_method" VARCHAR,
  "total_actual_vehicle_revenue_hours" DOUBLE,
  "total_unlinked_passenger_trips" DOUBLE,
  "total_actual_vehicle_revenue_miles" BIGINT,
  "total_passenger_miles_traveled" DOUBLE,
  "total_operating_expenses" BIGINT,
  "non_fixed_guideway_vehicle_revenue_miles" DOUBLE,
  "non_fixed_guideway_passenger_miles" DOUBLE,
  "non_fixed_guideway_operating_expenses" DOUBLE,
  "fixed_guideway_vehicle_revenue_miles" DOUBLE,
  "fixed_guideway_passenger_miles" DOUBLE,
  "fixed_guideway_operating_expenses" DOUBLE,
  "fixed_guideway_directional_route_miles" DOUBLE,
  "sgr_fg_directional_route_miles" DOUBLE,
  "sgr_fg_vehicle_revenue_miles" DOUBLE,
  "sgr_hib_directional_route_miles" DOUBLE,
  "sgr_hib_vehicle_revenue_miles" DOUBLE,
  "primary_uza" BOOLEAN,
  "total_actual_vrh_questionable" VARCHAR,
  "total_upt_questionable" VARCHAR,
  "total_actual_vrm_questionable" VARCHAR,
  "total_pmt_questionable" VARCHAR,
  "total_oe_questionable" VARCHAR,
  "nfg_vrm_questionable" VARCHAR,
  "nfg_pmt_questionable" VARCHAR,
  "drm_questionable" VARCHAR,
  "fg_oe_questionable" VARCHAR,
  "fg_vrm_questionable" VARCHAR,
  "state_ntd_id" VARCHAR
);