> ## Content Index
> Fetch the complete content index at: https://www.philsimon.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Visualizing Mice and Rats in Manhattan
- URL: https://www.philsimon.com/visualizing-mice-and-rats-in-manhattan/
- Published: 2014-02-21T13:46:33.000Z
- Updated: 2025-08-06T13:54:36.000Z
- Description: There's no shortage of new, data-oriented ways to look at old problems.
- Author: Phil Simon
- Tags: Big Data, Dataviz, Open Data, The Visual Organization

Last time I was in New York, I couldn't help but notice this [Yelp dataviz for a dry cleaner](https://www.philsimon.com/blog/big-data/dataviz-and-dry-cleaners/). As one might expect, there are plenty of other ways to visually represent interesting data in a city as big as New York. What about looking at the concentration of reported mice and rats by zip code?

Over at [The Gothamist](https://gothamist.com/2014/02/17/restaurant%5Frat%5Fmap%5Fnyc.php?ref=philsimon.com), [Steven Melendez](https://twitter.com/smelendez?ref=philsimon.com) did that very thing. From the article, here's a bit on Melendez's methodology:

(He) took restaurant inspection data from the [Health Department](https://data.cityofnewyork.us/Health/Restaurant-Inspection-Results/4vkw-7nck?ref=philsimon.com "Opens in a new window") and looked at all the inspections since Jan. 1, 2013\. Then he counted the total number of inspected restaurants and number of restaurants that received citations for "evidence of mice or live mice" or "evidence of rats or live rats" in that time period for each zip code. Then, for each zip code, he added to the info window any restaurant that currently has a C grade and was cited for mice and/or rats in its most recent graded inspection.

This type of data simply wasn't accessible even five years ago.

[Visualizing Healthcare DataWhat happens when consumers can visualize data related to their health?![](https://storage.ghost.io/c/8f/b5/8fb5e321-49a6-4cf5-8a28-c6f6d5417e54/content/images/icon/newlogo-2-85.png)Phil SimonPhil Simon![](https://storage.ghost.io/c/8f/b5/8fb5e321-49a6-4cf5-8a28-c6f6d5417e54/content/images/thumbnail/photo-1504439468489-c8920d796a29)](https://www.philsimon.com/visualizing-health-care-data-health-care-data/)

## Simon Says

As I write in *The Visual Organization*, the notion of [open data](https://en.wikipedia.org/wiki/Open%5Fdata?ref=philsimon.com) has been gaining traction for a while now. Foolish is the organization that only looks at data within its walls. It's never been easier and more important to augment traditional data sources with supplemental ones external to the enterprise.