DFPS Employees 1.2 Staff Tenure on 31 August by Program and Staff Type FY2014-2023

Tenure with DFPS represents tenure with the agency and not in a specific position.

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).

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-12-staff-tenure-on-31-august-by-ybwi-b7kw\".\"dfps_employees_12_staff_tenure_on_31_august_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.