Safe Schools Drug and Alcohol Use SY 2012 - Current County Education

This dataset contains summary information by county on Incidents involving Drug and Alcohol reported use in Schools.

School categories are Public School, Charter, Intermediate, Vo-Tech, Non-Public and other.

The data count fields are suppressed when less than 11.

The data and more information is also published and searchable online on the https://www.education.pa.gov/Schools/safeschools/Pages/default.aspx website under School Safety.

Here are the infraction codes and definitions that are utilized within this report as found within appendix Z of the PIMS manual:

http://www.education.pa.gov/Documents/Teachers-Administrators/PIMS/PIMS%20Manuals/2017-2018%20PIMS%20Manual%20Vol%202.pdf

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/safe-schools-drug-and-alcohol-use-sy-2012-current-umiz-nsja\".\"safe_schools_drug_and_alcohol_use_sy_2012_current\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.