impact-stlouisco/student-homelessness-upy9-6ni8
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 7 years ago
Indexed 1 month ago

Student Homelessness

This dataset includes annual counts of all students reported as homeless by their home school district to the Missouri Department of Elementary and Secondary Education (DESE). Students are identified as homeless if they lack a fixed, regular, and adequate nighttime residence. This includes students who are sharing the housing of other persons due to loss of housing, economic hardship, or a similar reason; are living in motels, hotels, trailer parks, or camping grounds due to the lack of alternative adequate accommodations; are living in emergency or transitional shelters; are abandoned in hospitals; or are awaiting foster care placement; who have a primary nighttime residence that is a public or private place not designed for or ordinarily used as a regular sleeping accommodation for human beings; who are living in cars, parks, public spaces, abandoned buildings, substandard housing, bus or train stations, or similar settings; and migratory children.

The homeless student rate is not calculated or reported by DESE. Instead, a rate has been calculated for the purpose of ImpactSTLCO using the district homeless counts and student enrollment data for each academic year. The rate should be understood as a point-in-time estimate as student enrollment does not include transfer numbers for the school year.

Homeless Students Per 10,000 Students is calculated as:

(Homeless Students Count/Student Enrollment) x 10,000.

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 \"impact-stlouisco/student-homelessness-upy9-6ni8\".\"student_homelessness\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • student_homelessness