About this Dataset

Reference: Department Code List

These department codes are maintained in the City's financial system of record. Department Groups, Divisions, Sections, Units, Sub Units and Departments are nested in the dataset from left to right. Each nested unit has both a code and an associated name.

The dataset represents a flattened tree (hierarchy) so that each leaf on the tree has it's own row. Thus certain rows will have repeated codes across columns.

Data changes as needed.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:40.419922
Tags: city-reference-data

Tables

Table 1

@usgov.city_of_san_francisco_reference_department_code_list.table_1

370.35 KB
16991 rows
14 columns


CREATE TABLE table_1 (
  "department_code" VARCHAR,
  "department_group_code" VARCHAR,
  "department_group_name" VARCHAR,
  "division_code" VARCHAR,
  "division_name" VARCHAR,
  "section_code" VARCHAR,
  "section_name" VARCHAR,
  "unit_code" VARCHAR,
  "unit_name" VARCHAR,
  "sub_unit_code" VARCHAR,
  "sub_unit_name" VARCHAR,
  "department_name" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);