About this Dataset

Spending - FTE

The San Francisco Controller's Office maintains a database of actual citywide staffing data from fiscal year 2003 forward. This data is presented on the Spending and Revenue report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on a weekly basis.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:08.676351
Tags: fte, open-book, openbook, sfopenbook, spending, staffing

Tables

Table 1

@usgov.city_of_san_francisco_spending_fte.table_1

3.22 MB
552,023 rows
27 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "program_code" VARCHAR,
  "program" VARCHAR,
  "object_code" VARCHAR,
  "object" VARCHAR,
  "fund_type_code" VARCHAR,
  "fund_type" VARCHAR,
  "organization_group_code" BIGINT,
  "fund_code" VARCHAR,
  "organization_group" VARCHAR,
  "fund" VARCHAR,
  "department_code" VARCHAR,
  "fund_category_code" DOUBLE,
  "department" VARCHAR,
  "fund_category" VARCHAR,
  "character_code" VARCHAR,
  "character" VARCHAR,
  "sub_object_code" BIGINT,
  "related_govt_unit" VARCHAR,
  "sub_object" VARCHAR,
  "job_family_code" VARCHAR,
  "job_family" VARCHAR,
  "job_code" VARCHAR,
  "job" VARCHAR,
  "actual" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);