2011-2023 City Of Pittsburgh Operating Budget
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835
CREATE TABLE n_2023_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" VARCHAR
);
CREATE TABLE n_2022_amended_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2022_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2021_amended_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2021_operating_budget (
"year" DOUBLE,
"type" VARCHAR,
"cost_center" DOUBLE,
"department" VARCHAR,
"object_account" DOUBLE,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2020_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2019_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2018_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2017_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2016_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2015_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" BIGINT
);
CREATE TABLE n_2014_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2013_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2012_operating_budget (
"year" BIGINT,
"type" VARCHAR,
"cost_center" BIGINT,
"department" VARCHAR,
"object_account" BIGINT,
"account_description" VARCHAR,
"subledger_type" VARCHAR,
"subledger" VARCHAR,
"subledger_description" VARCHAR,
"amount" BIGINT
);
Anyone who has the link will be able to view this.