This Week in Data: Unlabelled Muffins, Monorail Fires, and more


Every week, a considerable volume of data gets published to Enigma from public data sources all over the world. To shine a light on some particularly interesting datasets, here's a sample of what we've seen in the past few days.

To start exploring Enigma's data, sign up for a free account here.

All of the drugs. The FDA has approved hundreds of drug ingredients in a variety of dosage forms and routes of administration. Each product—for instance, intravenous ibuprofen with a strength of 400MG/4ML—appears in the rather lengthy Approved Drug Products list, also known as the Orange Book.This data set covers all products approved up to mid-June of this year. In addition to ingredient name, dosage, route, and strength, it includes trade names, pharmaceutical company names, and information about exclusivity and patents.

City employees and salaries. With an annual salary of over $200,000, Mayor Rahm Emanuel is only the second-highest paid city employee in Chicago, according to this table. As for first place: her name is Ginger Evans, and she manages the O’Hare-Midway airport system.

If you are in need of a lift. The Elevator Safety unit tracks all elevators, escalators, dumbwaiters, moving walks, and chair lifts in the State of New Jersey. This is a table of every elevator in New Jersey, and the address where you can find each one.

Calls to the Seattle Fire Department. In the past six years, the Seattle Fire Department has received calls regarding nearly 8,000 automatic fire alarms, 200 chimney fires, and 3 monorail fires. There has also been at least one “tunnel rescue.” This data records 911 calls with the Seattle Fire Department, with incident type—to my disappointment, I could not find “cat stuck in tree”—and the location of each responding fire station.

Failed banks. Since October 2000, 545 failed banks have been recorded by the FDIC. Ninety-two were in Georgia, the state with the highest number of failed banks. This data also includes these failed banks’ historical asset values and total estimated loss.

Restaurant inspections. In Boston, all licensed food establishments are inspected at least once a year. This table covers several years of inspections, with the appropriate codes for each violation, restaurant name and address, as well as fantastic individual comments like “properly store all toxic chemicals” and “labels on the muffins are incomplete.”