Baselight

County - Expenditures

State of California

@usgov.ca_gov_county_expenditures_1c0b6

Loading...
Loading...

About this Dataset

County - Expenditures

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

Tables

County - Expenditures

@usgov.ca_gov_county_expenditures_1c0b6.county_expenditures
  • 3.76 MB
  • 416898 rows
  • 13 columns
Loading...

CREATE TABLE county_expenditures (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "type" VARCHAR,
  "form_table" VARCHAR,
  "category" VARCHAR,
  "subcategory_1" VARCHAR,
  "subcategory_2" VARCHAR,
  "line_description" VARCHAR,
  "values" BIGINT,
  "zip_code" VARCHAR,
  "estimated_population" BIGINT,
  "area_in_sq_miles" BIGINT,
  "row_number" BIGINT
);

Share link

Anyone who has the link will be able to view this.