Jan 18, 2023

I’ve listened to almost 2000 podcast episodes

I’ve listened to almost 2000 podcast episodes
Meta Description
Ship It Post #
220
Tags
Author
Date
May 26, 2022
Meta Title
Text
Excerpt
Tags
🧠 Second Brain
Publish
Publish
Word Count
218
Meta Keywords
I started listening to podcasts when I was in Japan around 2017.
My podcast player of choice has been Podcast Republic on Android phone.
I just exported my data as a backup, and tried to check it.
It was a SQLITE database format. So I downloaded a Sqlite editor for Windows, and exported the episode info table and play history table to CSV. I imported those into Excel. Then I used VLOOKUP to match the ids from play history (indicating 1923 episodes listened to) with the full episode list (almost 30,000 rows, which seems to list out the full episode catalogue of every podcast I ever subscribed to or viewed.)
So now I have a list of every podcast episode I’ve listened to in the app, since summer of 2018, complete with links and descriptions.
I don’t know how useful this data would be. I have been considering moving to another podcast app like SnipD which lets you “highlight” audio snippets from a podcast and get a transcription of that segment into Readwise. One thing that has been holding me back was losing or disconnecting from the data of my played history within Podcast Republic. Now I don’t have to worry about that any more. It’s an obsessive-compulsive thing, this data hoarding.