Here’s an example from a SQLite database: When data is stored in SQL databases, it tends to follow a rigid structure that looks like a table. We’ll start with a look at the JSON data, then segue into exploration and analysis of the JSON with Python. In this post, focused on learning python programming, we’ll look at how to leverage tools like Pandas to explore and map out police activity in Montgomery County, Maryland. In cases like this, a combination of command line tools and Python can make for an efficient way to explore and analyze the data. Working with large JSON datasets can be a pain, particularly when they are too large to fit into memory.