About this Dataset

Transportation Public Financial Statistics (TPFS)

Transportation Public Financial Statistics (TPFS) provides information on transportation-related revenue and expenditures for all levels of government, including federal, state, and local, and for all modes of transportation.
Organization: Department of Transportation
Last updated: 2024-05-21T13:52:28.969755
Tags: economics, finance, government-expenditures, government-funding, government-revenue, government-transportation-expenditures, government-transportation-revenue, gtfs, transportation, transportation-finance

Tables

Table 1

@usgov.dot_gov_transportation_public_financial_statistics_tpfs.table_1

57.69 kB
2,757 rows
16 columns

CREATE TABLE table_1 (
  "cash_flow" VARCHAR,
  "own_supporting" VARCHAR,
  "user_other" VARCHAR,
  "trust_fund" VARCHAR,
  "exp_type" VARCHAR,
  "gov_level" VARCHAR,
  "desccription" VARCHAR,
  "year" BIGINT,
  "value" DOUBLE,
  "mode" VARCHAR,
  "chained_value" DOUBLE,
  "estimate_actual" VARCHAR,
  "deflator" DOUBLE,
  "gov_level_sort_order" BIGINT,
  "mode_sort_order" BIGINT,
  "user_other_grp" VARCHAR
);