When Police Pull You Over

The picture was referenced from Youtube.

Timeline of A Map Production

1. used OpenRefine to clean data:

2. Opened the Excel document and used Pivot Table to simplified data:


3. Imported the Excel document into Tableau:

4. visualized the data to make a map in #sheet 1, and put it in the #story 1 worksheet:

5. Exported and shared visual graphic:

The Final interactive graphic map: 


Story Type: an interaction story.

Story Proposal: Compared with the map of pulling over by races and locations (left) and another map of income by location (right). You can see that there were less chances to be pulled over in higher-income locations, and were more likely to be Whites. Vice versa, there were more chances to be pulled over in lower-income communities, and were more likely to be Blacks.


These two data visualization graphics have related parts. It involved in “races”, “economy”, and “locations”. Does it show that police paid more cautions on lower-income-black communities or more lower-income-black communities’ residents got out of lines? It can be the next step to dig.

Thus, depending on the question, I built one more map by locations and stop reasons.

You can see that the locations where had higher chances of pulling over had more “investigation” reason to stop the cars, the lower chances of pulling over had more “radio call”, “motor vehicle violence”, and even “others” reasons.

About Yaling Hou 7 Articles
Yaling is a videographer and a bilingual writer who accept journalism education both in China and America. She is passionate about education, cross-cultural communication and youth development. She writes, produces, edits and assists multimedia stories for organizations like Sampan Newspaper and Chronicle, WCVB in Boston.