2020 Fort Collins City Employee Base Pay

City employee base salary as of 2020-12-31.

Starting with 2020 data, in an effort to provide greater consumable and comparable data we're moving away from reporting individual employee earnings and instead provide base salaries as assigned per position. Due to this change this dataset cannot be directly combined with previous years' earnings data. The data represents a snapshot of salaries as of 2020-12-31 rather than actual paid amounts in 2020. Personnel spending data can be found on openbook.fcgov.com

These data are for the contracted position of each employee and therefore don't account for interim roles; the City of Fort Collins pay policy states that the employees in interim roles may be making up to 6% more than the reported salary.

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 \"opendata-fcgov/2020-fort-collins-city-employee-base-pay-nit5-kfur\".\"2020_fort_collins_city_employee_base_pay\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.