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

About this Dataset

County - Revenues

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

Tables

County - Revenues

@usgov.ca_gov_county_revenues_581ae.county_revenues

5.82 MB
526,452 rows
15 columns

CREATE TABLE county_revenues (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "type" VARCHAR,
  "form_table" VARCHAR,
  "category" VARCHAR,
  "subcategory_1" VARCHAR,
  "subcategory_2" VARCHAR,
  "subcategory_3" VARCHAR,
  "subcategory_4" VARCHAR,
  "line_description" VARCHAR,
  "values" BIGINT,
  "zip_code" VARCHAR,
  "estimated_population" BIGINT,
  "area_in_sq_miles" BIGINT  -- Area In Sq. Miles,
  "row_number" BIGINT
);