Budget - FTE by US Government | Media and Entertainment

About this Dataset

Budget - FTE

The San Francisco Controller's Office maintains a database of budgetary staffing data that appears in summarized form in each Annual Salary Ordinance (ASO). This data is presented on the Budget report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on an annual basis when the ASO is published for each new fiscal year. Data is available from fiscal year 2010 forward.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:10.791228
Tags: budget, fte, open-book, openbook, sfopenbook, staffing

Tables

Table 1

@usgov.city_of_san_francisco_budget_fte.table_1

543.12 KB
90689 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" BIGINT,
  "department" VARCHAR,
  "fund_category" VARCHAR,
  "related_govt_unit" VARCHAR,
  "character_code" VARCHAR,
  "character" VARCHAR,
  "sub_object_code" BIGINT,
  "sub_object" VARCHAR,
  "job_family_code" VARCHAR,
  "job_family" VARCHAR,
  "job_code" VARCHAR,
  "job" VARCHAR,
  "budget" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);