Data mining the Podcast Index (opens in new tab)

The Podcast Index - released by Adam Curry and Dave Jones more than five years ago - is a super-useful thing to go data mining into the wide world of podcasts. There’s a weekly-updated file containing every public feed in the Podcast Index - , and is about 1.8GB. Unzip it, and it becomes a 5GB file, which you can “easily” interrogate using a thing like . Once you’ve installed the SQLite browser - if you have brew install --cask db-browser-for-sqlite … Open the podcastindex_feeds.db file. Hit ...