Name: Transportation Planning Agencies - Revenues
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Transportation Planning Agencies - Revenues

2002-03 to 2022-23 Transportation Planning Agencies Financial Transactions Report - Revenues, for the finance application.
Organization: State of California
Last updated: 2023-07-29T01:29:00.168599
Tags: california-state-controllers-office, revenues, tpa

Tables

Transportation Planning Agencies - Revenues

@usgov.ca_gov_transportation_planning_agencies_revenues_6556f.transportation_planning_agencies_revenues

638.13 kB
78,871 rows
12 columns

CREATE TABLE transportation_planning_agencies_revenues (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "form_table" VARCHAR,
  "type" VARCHAR,
  "category" VARCHAR,
  "subcategory1" VARCHAR,
  "subcategory2" VARCHAR,
  "line_description" VARCHAR,
  "value" BIGINT,
  "city_state" VARCHAR  -- City, State,
  "zip_code" VARCHAR,
  "line_item_number" BIGINT
);