About this Dataset

Open Budget - Appropriations Fiscal Years 2010 - 2025

This dataset includes only those expenditures paid for by city revenue, also known as the General City Budget. The three proprietary departments (Port of LA, Department of Water and Power, Los Angeles World Airports) and non-budgetary departments (Library, Recreation and Parks, City Employee's Retirement Fund) operate at least partly from independent revenue sources. See the open budget websites for more information.
http://cao.lacity.org/budget/
http://openbudget.lacity.org/

Fiscal years 2010 - 2013 have aggregate budgets per department. 2014 - present display line item appropriations.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:06.386219
Tags: appropriations, budget, fiscal-year

Tables

Table 1

@usgov.city_of_los_angeles_open_budget_appropriations_fiscal__b0c3d113.table_1

722.27 kB
58,363 rows
14 columns

CREATE TABLE table_1 (
  "dept_code" VARCHAR,
  "department_name" VARCHAR,
  "subdept_code" VARCHAR,
  "subdepartment_name" VARCHAR,
  "prog_code" VARCHAR,
  "program_name" VARCHAR,
  "program_priority" VARCHAR,
  "source_fund_code" VARCHAR,
  "source_fund_name" VARCHAR,
  "account_code" VARCHAR,
  "account_name" VARCHAR,
  "n__appropriation" DOUBLE  -- Appropriation,
  "fiscal_year" BIGINT,
  "expense_type" VARCHAR
);