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

About this Dataset

City - Revenues

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

Tables

City - Revenues

@usgov.ca_gov_city_revenues_e5da4.city_revenues

38.78 MB
2,382,023 rows
15 columns

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