San Francisco Citywide Performance Metrics by US Government | Politics and Governance

About this Dataset

San Francisco Citywide Performance Metrics

A. SUMMARY This data set reports key performance metrics for departments and programs in the City and County of San Francisco. B. HOW THE DATASET IS CREATED City departments report updates about their key metrics to the Controller’s Office. The Controller's Office uses an online application to collect and organize this data. Departments update most metrics once or twice each year. Some metrics may not display data for every year. C. UPDATE PROCESS Most metrics update twice each year. Updates with results for the first 6 months of each fiscal year are published in the spring, typically between April and May. Updates with results for each full fiscal year are published in the fall, typically in November. D. HOW TO USE THIS DATASET Each row represents one metric and one fiscal year for a department, with multiple values for each fiscal year. Some metrics do not include values for all fields or fiscal years. Some results for the latest fiscal year are unavailable because of known lags in reporting. Users should review any data notes reported for each row for guidance about interpreting values. All values are reported as numbers without formatting, but the column [Measure Data Type] describes the intended format. For example, a value appearing as “0.50” with [Measure Data Type] reported as “Percent” should be displayed as “50%”.
Organization: City of San Francisco
Last updated: 2022-01-25T01:58:23.466236
Tags: government-performance, performance, scorecards

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_citywide_performan_786ddecf.table_1

310.67 KB
10017 rows
13 columns


CREATE TABLE table_1 (
  "department_name" VARCHAR,
  "strategic_goal" VARCHAR,
  "measure_title" VARCHAR,
  "measure_description" VARCHAR,
  "measure_methodology" VARCHAR,
  "measure_data_type" VARCHAR,
  "fiscal_year" VARCHAR,
  "end_calendar_year" BIGINT,
  "target" DOUBLE,
  "mid_year_result" DOUBLE,
  "mid_year_projection" DOUBLE,
  "full_year_result" DOUBLE,
  "data_notes" VARCHAR
);