CT DCF Abuse/Neglect Reports and Allegations by Town and State Fiscal Year

This dataset contains aggregate data concerning abuse/neglect reports accepted for a response from DCF. Traditionally, DCF has had only one manner of responding to such reports, which was a mandated Child Protective Services (CPS) Investigation. As of April 2012, DCF began responding to low-risk reports through a voluntary Family Assessment Response (FAR) process. Reports handled through a FAR response still contain allegations that meet the statutory definitions of neglect, but they do not receive a decision concerning whether they are substantiated or not. This policy has resulted in fewer substantiated allegations since its implementation, but the agency continues to serve as many or more families reported for abuse/neglect.

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 \"ct-gov/ct-dcf-abuseneglect-reports-and-allegations-by-337d-73fs\".\"ct_dcf_abuseneglect_reports_and_allegations_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.