DFPS Employees 1.5 Average Monthly Salaries by Selected Program and Staff Type FY2014-2023

The average monthly salary for active Child Protective staff as of the last day of the fiscal year by staff type.

The county and region of the employees are determined by the office to which they are assigned.

More information at www.dfps.texas.gov

NOTE: Child Protective Investigations (CPI), Child Care Investigations (CCI), and Child Protective Services (CPS) Staff are all included.

Child Care Investigations (CCI), which is a part of CPI and include Day Care Investigations (DCI) and Residential Child Care Investigations (RCCI) are only available from 2018 onward. This is due to the split of those job functions from Child Care Licensing, which was a part of DFPS until 2017, when it was transferred to the Health and Human Services Commission (HHSC).

This addresses Texas Human Resource Code Section 40.0516(11).

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 \"texas-gov/dfps-employees-15-average-monthly-salaries-by-pedx-fc9i\".\"dfps_employees_15_average_monthly_salaries_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.