City - Revenues by US Government | Demographics and Population Studies

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

36.99 MB
2382023 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,
  "estimated_population" VARCHAR,
  "row_number" BIGINT
);