Icon for Socrata external plugin
Updated over 3 years ago
Indexed 5 hours ago

Budget - 2019 Budget Recommendations - Positions and Salaries

This dataset includes recommended positions and salaries for 2019 by title (without names) and salary. The dataset is excerpted from the 2019 Budget Recommendations, which is the line-item budget proposed by the Mayor to the City Council for approval. Disclaimer: the “Total Budgeted Unit” column displays either A) the number of employees AND vacancies associated with a given position, or B) the number of budgeted units (ie. hours/months) for that position. “Position Control” determines whether Total Budgeted Units column will count employees and vacancies or hours/months. If a Position Control is 1, then employees and vacancies are displayed; if a Position Control is 0, then the total number of hours/months recorded is displayed.

This dataset follows the format of the equivalent datasets from past years except that Section Code and Division Code have changed from Number to Text in order to accommodate non-numeric values.

For more information about the budget process, visit the Budget Documents page:


NameSocrata field nameColumn name in sgr mountData typeDescription
SECTION CODEsection_codesection_codeText
FUND TYPEfund_typefund_typeText
TOTAL BUDGETED AMOUNTtotal_budgeted_amounttotal_budgeted_amountNumber
FUND DESCRIPTIONfund_descriptionfund_descriptionText
DEPARTMENT CODEdepartment_codedepartment_codeNumber
TOTAL BUDGETED UNITtotal_budgeted_unittotal_budgeted_unitNumber
FUND CODEfund_codefund_codeText
SCHEDULE / GRADEschedule_gradeschedule_gradeText
BUDGETED UNITbudgeted_unitbudgeted_unitText
ORGANIZATION CODEorganization_codeorganization_codeNumber
POSITION CONTROLposition_controlposition_controlNumber
TITLE CODEtitle_codetitle_codeText
BUDGETED PAY RATEbudgeted_pay_ratebudgeted_pay_rateNumber
SUB-SECTION DESCRIPTIONsub_section_descriptionsub_section_descriptionText
SUBSECTION CODEsubsection_codesubsection_codeNumber
TITLE DESCRIPTIONtitle_descriptiontitle_descriptionText
ORGANIZATION DESCRIPTIONorganization_descriptionorganization_descriptionText
DEPARTMENT DESCRIPTIONdepartment_descriptiondepartment_descriptionText
SECTION DESCRIPTIONsection_descriptionsection_descriptionText
DIVISION CODEdivision_codedivision_codeText
DIVISION DESCRIPTIONdivision_descriptiondivision_descriptionText
BARGAINING UNITbargaining_unitbargaining_unitNumber
  • budget_2019_budget_recommendations_positions_and
Upstream Metadata