orcities/2018-salary-survey-data-yh2y-34u7
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 5 years ago
Indexed 3 hours ago

2018 Salary Survey Data

This data comes from the 2018 salary survey data. Please notethe following:

  1. Where able, the data has been altered to reflect the annual pay of the average employee in this city and in this position based on the city's salary range.

  2. Not all salaries and wages of less than 1 FTE could be confirmed. As a result, some salaries for positions with less than 1 FTE are either the annual equivelant or the actual pay of the employee throughout a year (ex. if an employee would make $50,000 as a full time employee but only works half-time, some cities marked this as $50,000 or $25,000.

  3. Educational attainment often was provided with a minimum education and experience as well as a preferred level. The minimum of both categories are provided.

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 \"orcities/2018-salary-survey-data-yh2y-34u7\".\"2018_salary_survey_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 2018_salary_survey_data