About this Dataset

Transportation Planning Agencies - Expenditures/Expenses

2002-03 to 2022-23 Transportation Planning Agencies Financial Transactions Report - Expenditures/Expenses, for the finance application.
Organization: State of California
Last updated: 2023-07-29T01:28:57.475869
Tags: california-state-controllers-office, expenditures, tpa

Tables

Transportation Planning Agencies - Expenditures/Expenses

@usgov.ca_gov_transportation_planning_agencies_expenditures_e_8513f4a0.transportation_planning_agencies_expenditures_expenses

496.33 kB
62,443 rows
12 columns

CREATE TABLE transportation_planning_agencies_expenditures_expenses (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "form_table" VARCHAR,
  "type" VARCHAR,
  "category" VARCHAR,
  "subcategory_1" VARCHAR,
  "subcategory_2" VARCHAR,
  "line_description" VARCHAR,
  "value" BIGINT,
  "city_state" VARCHAR  -- City, State,
  "zip_code" VARCHAR,
  "line_item_number" BIGINT
);