About this Dataset

Position Schedule

Sum of the full-time active positions in a title description published in alphabetical order. The Position Schedule is updated and included in the Departmental Estimates and the Supporting Schedule (updated twice a year). The minimum salary, maximum salary, mean salary and annual rate are to the dollar. This dataset is updated two times per year after publication of the Preliminary and Executive Budget, usually in January and April respectively.
Organization: City of New York
Last updated: 2020-11-10T17:02:50.521544
Tags: departmental-estimate, nyc-omb, position-schedule, supporting-schedule

Tables

Table 1

@usgov.city_of_new_york_position_schedule.table_1

1.41 MB
82,104 rows
12 columns

CREATE TABLE table_1 (
  "publication_date" BIGINT,
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "ua_code" BIGINT,
  "ua_name" VARCHAR,
  "title_code" VARCHAR,
  "title_code_name" VARCHAR,
  "minmum_salary" DOUBLE,
  "maxmum_salary" DOUBLE,
  "positions" BIGINT,
  "mean_salary" BIGINT,
  "annual_rate" BIGINT
);