About this Dataset

Check List Of Services Provided For Fiscal Years 2016-17 To 2022-23

Data on how certain services are provided to the populace of cities. See attachment for explanation of codes by clicking on the red "About" button towards the far right and scrolling down to the Attachments Section.
Organization: State of California
Last updated: 2025-07-23T21:27:24.429148
Tags: california-state-controllers-office, city, service

Tables

Check List Of Services Provided For Fiscal Years 2016-17 To 2022-23

@usgov.ca_gov_check_list_of_services_provided_for_fiscal_year_3e5c2269.check_list_of_services_provided_for_fiscal_years_2016__088daa31

100.75 kB
3,372 rows
29 columns

CREATE TABLE check_list_of_services_provided_for_fiscal_years_2016__088daa31 (
  "entity_name" VARCHAR,
  "entity_id" BIGINT,
  "fiscal_year" BIGINT,
  "police_service" VARCHAR,
  "fire_service" VARCHAR,
  "emergency_medical_service" VARCHAR,
  "street_lighting_service" VARCHAR,
  "public_transit_service" VARCHAR,
  "community_development_planning_service" VARCHAR  -- Community Development - Planning Service,
  "solid_waste_service" VARCHAR,
  "sewers_service" VARCHAR,
  "parks_and_recreation_service" VARCHAR,
  "libraries_service" VARCHAR,
  "water_service" VARCHAR,
  "police_protection_number_of_paid_city_employees" DOUBLE,
  "police_protection_number_of_volunteers" DOUBLE,
  "police_protection_total_number_of_employees" DOUBLE,
  "police_officers_number_of_paid_city_employees" DOUBLE,
  "police_officers_number_of_volunteers" DOUBLE,
  "police_officers_total_number_of_employees" DOUBLE,
  "fire_protection_number_of_paid_city_employees" DOUBLE,
  "fire_protection_number_of_volunteers" DOUBLE,
  "fire_protection_total_number_of_employees" DOUBLE,
  "fire_fighters_number_of_paid_city_employees" DOUBLE,
  "fire_fighters_number_of_volunteers" DOUBLE,
  "fire_fighters_total_number_of_employees" DOUBLE,
  "emergency_medical_number_of_paid_city_employees" DOUBLE,
  "emergency_medical_number_of_volunteers" DOUBLE,
  "emergency_medical_total_number_of_employees" DOUBLE
);