Name: City - Expenditures
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

City - Expenditures

2002-03 to 2022-23 City Financial Transactions Report - Expenditures, for the finance application.
Organization: State of California
Last updated: 2023-07-29T01:27:41.742432
Tags: california-state-controllers-office, cities, expenditures

Tables

City - Expenditures

@usgov.ca_gov_city_expenditures_86ecf.city_expenditures

16.83 MB
1,253,353 rows
13 columns

CREATE TABLE city_expenditures (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "county" VARCHAR,
  "field_name" VARCHAR,
  "type" VARCHAR,
  "category" VARCHAR,
  "subcategory_1" VARCHAR,
  "subcategory_2" VARCHAR,
  "line_description" VARCHAR,
  "value" DOUBLE,
  "city_state_zip" VARCHAR  -- City, State, Zip,
  "estimated_population" DOUBLE,
  "row_number" BIGINT
);