Public Schools Reporting Incidents of Crime, by Incident Type and Selected School (Statistical Abstract 2008 Table 0235)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. A few files had extraneous characters in the title. These were
   corrected to be consistent. A few files have a sheet of crufty
   gibberish in the first slot. The sheet order was shuffled but no
   data were changed.

1. The first four files have been restructured to allow full
   comprehension of the table. If you’d like to help clean up the data
   follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Notes (pg 2)

1. Violent incidents include rape, sexual battery other than rape, physical attack
   or fight with or without a weapon, threat of physical attack with or without a weapon,
   or fight with or without a weapon, threat of physical attack with or without a weapon,
   and robbery with or without a weapon.
   and robbery with or without a weapon.

1. Serious violent incidents include rape, sexual battery other than rape, physical
   attack or fight with a weapon, threat of physical attack with a weapon,
   attack or fight with a weapon, threat of physical attack with a weapon,
   and robbery with or without a weapon.
   and robbery with or without a weapon.

1. Theft or larceny (taking things worth over $10 without personal confrontation).
   Includes are pocket
   Includes pocket
   picking, stealing purse or backpack (if left unattended or no force was used to take
   picking, stealing purse or backpack (if left unattended or no force was used to take
   from owner), theft from motor vehicles, etc.
   from owner), theft from motor vehicles, etc.

1. Other incidents include possession of a firearm or explosive device, possession
   of knife or sharp object, distribution of illegal drugs, possession or use
   of knife or sharp object, distribution of illegal drugs, possession or use
   of alcohol or illegal drugs, and vandalism.
   of alcohol or illegal drugs, and vandalism.

1. Primary schools are defined as schools in which the lowest grade is not higher
   than grade 3 and the highest grade is not higher than grade 8. Middle schools are
   than grade 3 and the highest grade is not higher than grade 8. Middle schools are
   defined as schools in which the lowest grade is not lower than grade 4 and the
   defined as schools in which the lowest grade is not lower than grade 4 and the
   highest grade is not higher than grade 9. High schools are defined as schools in
   highest grade is not higher than grade 9. High schools are defined as schools in
   which the lowest grade is not lower than grade 9 and the highest grade is not
   which the lowest grade is not lower than grade 9 and the highest grade is not
   higher than grade 12. Combined schools include all other combination of grades,
   higher than grade 12. Combined schools include all other combination of grades,
   including K-12 schools.
   including K-12 schools.

1. These estimates exclude data from Tennessee because schools in this state
   did not report estimates of student race.
   did not report estimates of student race.
   |

[For school year. Includes incidents
< nr >[< bold >For school year. < med >Includes incidents
that happen in school buildings, on schools grounds, on school buses, and at places
< nr >that happen in school buildings, on school grounds, on school buses, and at places
that hold school-sponsored events or activities. Based on sample; see source for details]
< nr >that hold school-sponsored events or activities. Based on sample; see source for details]
$del

table: [30, 18]

0235

2008