NoSQL JSON to Deduped List using SQLite in Python

We've collected data from Google Search Console. But how to we just get the list of all the URLs spread across all the key/value results? Simple! Iterate through the keys and use list comprehension to add a subset of the JSON object to a growing list that naturally removes duplicates. What part of that was not clear. Look closely at the code. This is a great example of why Python is so preferred for this sort of work. Data gathering is easy. Dealing with different data models is easy. Transforming data between models is easy.