Steven Rich, the database editor for the investigations team at The Washington Post, recently gained access to a database that traced every pain pill distributed across the US between 2006 and 2012. The database provides a look at where opioids have been distributed by which pharmaceutical companies, and shows that the federal government has long been aware of the scope of the opioid crisis. Rich spoke to MuckRock about taking advantage of a lawsuit to gain access to the Drug Enforcement Administration pain pill database and how to use public records to report on private companies.

In this week’s FOIA round-up, the Washington Post and HD Media gain access to a database that tracks opioid distribution, emails obtained through a FOIA request reveal the extent of a top Department of the Interior official’s violations of federal ethics rules, and city and court records reveal that in one Alaska town every single police officer has been convicted of domestic violence.

A 1987 report from the National Narcotics Intelligence Consumers Committee offers insight into the drug threats that concerned the Reagan era.