About this Dataset

City Revenues And Expenses

City Revenues and Expenses from the Operating Budget from 2012 to Present, updated every night from the City's JD Edwards ledger.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:04.890324
Tags: expenditures, expenses, finances, income, revenues, spending

Tables

City Wide Revenues And Expenses

@usgov.allegheny_county_city_of_pitts_city_revenues_and_expenses.city_wide_revenues_and_expenses

9.16 MB
617,753 rows
13 columns

CREATE TABLE city_wide_revenues_and_expenses (
  "n__id" BIGINT  -- Id,
  "fund_number" BIGINT,
  "fund_description" VARCHAR,
  "department_number" BIGINT,
  "department_name" VARCHAR,
  "cost_center_number" BIGINT,
  "cost_center_description" VARCHAR,
  "object_account_number" BIGINT,
  "object_account_description" VARCHAR,
  "general_ledger_date" TIMESTAMP,
  "amount" DOUBLE,
  "ledger_code" BIGINT,
  "ledger_descrpition" VARCHAR
);