About this Dataset

2011-2023 City Of Pittsburgh Operating Budget

This dataset shows the 2011-YTD operating budgets for the City of Pittsburgh.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:01.594230
Tags: 2011, 2023, budget, office-of-management-and-budget, omb, operating-budget, pittsburgh

Tables

2012 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2012_operating_budget

20.72 kB
3,069 rows
10 columns

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
);

2013 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2013_operating_budget

20.86 kB
1,774 rows
10 columns

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
);

2014 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2014_operating_budget

20.55 kB
1,612 rows
10 columns

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
);

2015 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2015_operating_budget

23.66 kB
1,730 rows
10 columns

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
);

2016 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2016_operating_budget

20.68 kB
834 rows
10 columns

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
);

2017 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2017_operating_budget

21.37 kB
923 rows
10 columns

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
);

2018 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2018_operating_budget

21.35 kB
936 rows
10 columns

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
);

2019 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2019_operating_budget

21.23 kB
911 rows
10 columns

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
);

2020 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2020_operating_budget

25.5 kB
1,515 rows
10 columns

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
);

2021 Amended Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2021_amended_operating_budget

25.06 kB
1,280 rows
10 columns

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
);

2021 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2021_operating_budget

20.73 kB
882 rows
10 columns

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
);

2022 Amended Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2022_amended_operating_budget

24.79 kB
1,630 rows
10 columns

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
);

2022 Operating Budget

@usgov.allegheny_county_city_of_pitts_2011_2023_city_of_pitts_aa317835.n_2022_operating_budget

21.23 kB
894 rows
10 columns

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
);