How to export played state from AntennaPod

_ExportAntennaPod.md

AntennaPod is a great podcast player, but you might want to migrate to another app. In order to export your data, you might try the HTML export, but that only includes a list of your subscriptions, and not the played/unplayed state of each episode.

Exporting played/unplayed state

1. From Settings export the database, and then copy it to your computer
2. Install sqlite, with i.e. scoop install sqlite
3. Run sqlite3 -header -csv back.db < export.sql > export.csv
4. Open export.csv in a CSV viewer i.e. Microsoft Excel

export.sql

SELECT 
    Feeds.title Episode
  , FeedItems.title Show
  , datetime(pubDate/1000, 'unixepoch') Published
  , CASE read WHEN 0 THEN 'UNPLAYED' WHEN 1 THEN 'PLAYED' ELSE 'NEW' END State
FROM FeedItems
INNER JOIN Feeds ON FeedItems.Feed = Feeds.id
ORDER BY 
    Feeds.title
  , FeedItems.pubDate DESC