Month: May 2017

Data

PSA: If you have a relative in a nursing home or are considering putting one there, check your state’s health department website for licensing reports. Over the past week, I used four and a half years’ worth of Boone County reports to build a database for a nursing home violations story. Some homes have passed inspection perfectly every year. Others have been cited for everything from not storing and cooking food properly to ignoring sprinkler system maintenance to hiring people with a history of neglect or abuse in caregiving situations. I hope to have the story out by next Wednesday.

Now to some lessons learned in the construction of said database. As taught in my computer-assisted reporting class, I started by planning out all the Excel rows and columns needed to cover information in the reports. I made codes for each citation and level of harm, and then began entering information, which is dull work and can lead to errors if you’re not super vigilant. In the next days, I’ll finish adding information, double- and triple-check my data entry and upload the Excel file into Access to start finding trends. What nursing homes have been cited most often, for example? Which citations come up most often? Then on to more traditional news work such as interviewing Health Department officials about inspections.

Is there anything you’d like to see investigated in Boone County?

Coming back to Advanced

Hello! Until August, this will be my blog for Advanced Reporting. (But most of the material here is on Morocco; just scroll down a bit.) I will share weekly updates on my work and what I’ve learned about journalism.

Last week, I was shocked back into Advanced with three stories about fun events in Columbia, another MU dean’s stepping down and the restoration of our iconic Ionic columns.  The columns story taught me the most while highlighting the flaws I need to overcome this semester.

My writing weaknesses are that I can’t seem to escape a formal writing voice (German mother) and that I lose a sense of structure with pieces past 500 words. This means my pieces can be super boring, as was the first draft of the columns story, which contained a description of how to waterproof columns and little else. Luckily, my editor directed me to the Missourian and university archives, and I found interesting folklore and vivid historical articles that showed how important the columns are to MU students. (The writings also showed how boring we students have become — no one has tried to paint the columns since 2000, when an unidentified person spray-painted the made-up term ¡Boño! on them, and no one has climbed to the top since the 1950s.) The research made my article way better.

Here is the article: Long-suffering MU columns to undergo preservation work this summer.