cityofchicago/budget-2018-budget-recommendations-positions-and-bjmn-bz46
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 6 years ago
Indexed 9 days ago

Budget - 2018 Budget Recommendations - Positions and Salaries

This dataset includes recommended positions and salaries for 2018 by title (without names) and salary. The dataset is excerpted from the 2018 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. For more information about the budget process, visit the Budget Documents page: http://j.mp/lPotWf.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/budget-2018-budget-recommendations-positions-and-bjmn-bz46\".\"budget_2018_budget_recommendations_positions_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • budget_2018_budget_recommendations_positions_and
     
     
     
     
     
Upstream Metadata