pa-gov/rate-of-dependent-children-removed-from-their-home-ekf9-na9n
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 years ago
Indexed 1 month ago

Rate of Dependent Children Removed from their Home Where Parental Drug Use was Factor FFY 2017 - Current Human Services

This dataset summarizes the number of dependent children (less than 18 years old) removed from households due to parental drug abuse. The data indicates if the dependent children were placed in kinship care or not.

The total number of children in this data set are provided by the U.S. Census Bureau’s American Community Survey (ACS), which publishes 5 year estimates of the population. The most recent year of entries in this data set may be available before the corresponding ACS population estimates for that year are published. In that case, the data set uses values from the most recently published ACS estimates and notes the year from which those estimates are pulled. These values are updated once the Census Bureau releases the most recent estimates.”

*Kinship care refers to the care of children by relatives or, in some jurisdictions, close family friends (often referred to as fictive kin). Relatives are the preferred resource for children who must be removed from their birth parents because it maintains the children's connections with their families.

*The Adoption and Foster Care Analysis and Reporting System (AFCARS) definition of parental drug abuse is “Principal caretaker’s compulsive use of drugs that is not of a temporary nature.”

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 \"pa-gov/rate-of-dependent-children-removed-from-their-home-ekf9-na9n\".\"rate_of_dependent_children_removed_from_their_home\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • rate_of_dependent_children_removed_from_their_home
     
     
     
     
     
Upstream Metadata