About this Dataset

Scorecard Measures

Departments collect and submit this data to the Controller's Office via the Budget and Performance Measurement System (BPMS). This data is collected to display on the City Performance Scorecard website, a site that provides timely performance information to the public and policy makers by major service area.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:43.493646
Tags: performance, scorecards

Tables

Table 1

@usgov.city_of_san_francisco_scorecard_measures.table_1

190.62 KB
22931 rows
18 columns


CREATE TABLE table_1 (
  "measure_code" BIGINT,
  "department" VARCHAR,
  "goal" VARCHAR,
  "measure_title" VARCHAR,
  "scorecard_update_frequency" VARCHAR,
  "monthly" BOOLEAN,
  "calendar_month" TIMESTAMP,
  "measure_description" VARCHAR,
  "measure_methodology" VARCHAR,
  "actual" DOUBLE,
  "target" DOUBLE,
  "measure_data_type" VARCHAR,
  "category_1" VARCHAR,
  "category_2" VARCHAR,
  "category_3" VARCHAR,
  "category_4" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);