Database...locked and loaded!

I successfully imported grungy's csv file of the crimes into the database. A few stats:

Unique Values

Total Enteries: 11112 Rows
Somehow I do not think there are 1956 unique locations around campus. Sounds like they need to clean up this database…

A more amusing result:

mysql> select * from rawdata where description like "%porn%";
+------------+----------+------+---------------------------------+-------------------------+----------------------+
| date       | incident | time | description                     | location                | disposition          |
+------------+----------+------+---------------------------------+-------------------------+----------------------+
| 2003-01-31 | 03-01130 | 1320 | Child Pornography               | Gilbert F               | Pending              | 
| 2005-01-09 | 05-00293 | 2212 | Possession of Child Pornography | Smith Hall Computer Lab | Prosecution Declined | 
+------------+----------+------+---------------------------------+-------------------------+----------------------+
2 rows in set (0.02 sec)

Disturbing results I would say. 03-01130 just stood out to grungy and so we looked to see if any other results were there. 05-00293 looks like they consumed 03-01130's product…
Anyways continuing on:

mysql> select * from rawdata where description like "%assault%";
...
83 rows in set (0.02 sec)

mysql> select * from rawdata where description like "DUI";
...
196 rows in set (0.01 sec)

mysql> select * from rawdata where description like "%sex%";
...
19 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%theft%";

2046 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%posses%";
...
440 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%alcohol%";
...
1614 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%drug%";
...
205 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%resist arrest%";
...
82 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%offensive%";
...
123 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%harass%";
...
325 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%mischief%";
...
315 rows in set (0.02 sec)

mysql> select * from rawdata where description like "%terrorist%";
...
48 rows in set (0.02 sec)

Terroristic Threatenings? Gotta love that Patriot Act!
If you want a query run talk to grungy or myself..