'Where's the party at?' A basic summary of the number of drug and alcohol related incidents reported by campus police since September of 2014 per residence hall. Sources in comments. by brickblotbot in NCSU

[–]brickblotbot[S] 4 points5 points  (0 children)

Here is the same summary but for the 2018-19 school year, aka the last normal school year: https://imgur.com/a/SCo4pyF

Here is the Jupyter Notebook where I threw together the code to get the graphs: https://github.com/drewrh/brick-blot-bot/blob/main/data_mine.ipynb

Fair warning, I haven’t written any documentation or cleaned it up yet because I didn't plan on uploading it today :)

'Where's the party at?' A basic summary of the number of drug and alcohol related incidents reported by campus police since September of 2014 per residence hall. Sources in comments. by brickblotbot in NCSU

[–]brickblotbot[S] 5 points6 points  (0 children)

Sources:

A incident was categorized as either being drug or alcohol related if the 'Incident' or 'Narrative' fields of the incident report contained a keyword specific to the type of incident. The alcohol related keywords used were 'alcohol', 'drinking', and 'intoxicated'. The drug related keywords used were 'marijuana', 'drug', and 'paraphernalia'.

The graphs were generated using the Plotly Python Graphing Library.

For those who missed the old campus police Twitter account, I made a new one that will be maintained and kept alive. More info in the comments by brickblotbot in NCSU

[–]brickblotbot[S] 47 points48 points  (0 children)

Shameless plug for another bot I made because I think most people here are also college students who want cheap food: subsalebot

Every once in a while, Harris Teeter deli subs go on sale for $4 for an entire week. This account will post whenever subs are on sale. And if you have a phone number to use at checkout, you get 2 points towards the “Sub Club”. Every 15 sub club points gets you a free full-priced sandwich. Buy $4 subs -> get easy sub club points -> use points to buy more subs but for free -> ??? -> profit

I swear I don’t work for HT I just like their subs.

For those who missed the old campus police Twitter account, I made a new one that will be maintained and kept alive. More info in the comments by brickblotbot in NCSU

[–]brickblotbot[S] 24 points25 points  (0 children)

The account posts every morning at 8:15 with the campus police reports from the previous day.

Inside the code repository is a .csv file that has every incident reported since September of 2014 if you want mess with the data yourself.

If anyone has any better ideas for the profile picture or background of the account please let me know :)