Help with Access?

As the first summer session winds down, the Missourian is publishing several interesting stories that reporters have worked on for a long time. Karlee wrote about a Ghanaian student hoping to mitigate infectious diseases in his country. Gabriela obviously had fun writing an informative piece about damage the solar eclipse can do to retinas. And, on a lighter note, Lucy covered the headache a local bar made for the city when it threw a ridiculous party, fake snow included.

Meanwhile, I’m still working on the nursing home violation story. It’s coming together, with everything double-, triple- and headed toward a quadruple check. But what I still can’t figure out is how to analyze the database for the most common violations in Boone County and the most recurrent violations per nursing facility. And no, Googling the question has not helped, though I would imagine that running this type of code is commonplace. Can anyone suggest what codes to run, either in Excel or Access? Doing it all by hand is not the best solution, by far.

The wild world of records requests

So, I’m still waist-deep in the nursing home story due to the sheer amount of time it takes to create this sort of database. Worth it, of course. What bothers me is that there’s a chance I’m not even accessing all of the inspection reports for the past 4 1/2 years. Take a look at this ambiguously worded note:

PLEASE NOTE: Statements of Deficiencies and Plans of Correction prompted by full inspections, second inspections and complaint-only investigations that resulted in deficiencies after January 1, 2013, are available on this website until approximately 30 days after all necessary re-visits have been completed.

(Source: health.mo.gov)

Therefore, I’ve decided to put in a records requests for all reports from the past 10 years that aren’t already posted on the department website. According to the department, this will cost $170, as an employee paid a little over $20 an hour will need eight to accomplish it.

Any thoughts on how to avoid this charge?



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.

Melilla, Spain: A Small Piece of Europe in North Africa

Hello! Last weekend, a journalism assignment took Gi., Gy. and I across the Moroccan border to Melilla, a Spanish enclave on the African continent. We had incredible experiences but are now swamped with work related to our articles. So, until my Saturday post — which will recount part one of our border-crossing, stolen-camera, musician-kidnapping experience, please enjoy this picture of a city street in front of our hotel.