About this Dataset

Check List Of Services Provided

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: 2023-09-15T13:47:31.800031
Tags: california-state-controllers-office, city, service

Tables

Check List Of Services Provided

@usgov.ca_gov_check_list_of_services_provided_90872.check_list_of_services_provided

184.77 kB
6,662 rows
33 columns

CREATE TABLE check_list_of_services_provided (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "entity_id" 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_employees" DOUBLE,
  "police_protection_number_of_volunteers" DOUBLE,
  "police_protection_total_number_of_employees" DOUBLE,
  "police_officers_number_of_paid_employees" DOUBLE,
  "police_officers_number_of_volunteers" DOUBLE,
  "police_officers_total_number_of_employees" DOUBLE,
  "fire_protection_number_of_paid_employees" DOUBLE,
  "fire_protection_number_of_volunteers" DOUBLE,
  "fire_protection_total_number_of_employees" DOUBLE,
  "fire_fighters_number_of_paid_employees" DOUBLE,
  "fire_fighters_number_of_volunteers" DOUBLE,
  "fire_fighters_total_number_of_employees" DOUBLE,
  "emergency_medical_number_of_paid_employees" DOUBLE,
  "emergency_medical_number_of_volunteers" DOUBLE,
  "emergency_medical_total_number_of_employees" DOUBLE,
  "if_your_city_reports_transient_lodging_tax_revenue_wha_109d8eaf" DOUBLE  -- If Your City Reports Transient Lodging Tax Revenue; What Is The Tax Rate?,
  "what_is_the_effective_date_of_the_current_tax_rate_00_00_0000" TIMESTAMP  -- What Is The Effective Date Of The Current Tax Rate? (00/00/0000),
  "if_your_city_reports_utility_users_tax_revenue_what_is_4f4141db" DOUBLE  -- If Your City Reports Utility Users Tax Revenue; What Is The Tax Rate?,
  "current_year_property_tax_delinquency_at_end_of_year_a_e1f416f4" DOUBLE  -- Current Year Property Tax Delinquency At End Of Year As A Percent Of Tax Levy
);