Reclaiming the Republic
Episode Database
Every episode of the Reclaiming the Republic podcast, indexed by date and searchable by topic — so a listener can type in a subject, a founder, or an amendment and go straight to the shows that cover it.
Browse by keyword
No episodes match
Try a different word, or clear the search and keyword filter to see the whole catalog.
Keeping the database current
The episode data lives in a simple five-column spreadsheet — Date, Show Title, Show Link, Keywords, Description — the same format as the delivered Excel file. This page works directly with it:
Load the latest spreadsheet
Export the episode spreadsheet as a CSV file (in Excel or Google Sheets: Save As / Download → CSV), then load it here. The catalog below updates instantly — check the search, the keywords, and the counts before publishing.
Take the results out
Download whatever the catalog is currently showing — the full database, or just the episodes a search turns up — as a CSV file that opens in Excel or Google Sheets.
Installing it on your own web host
Yes — this interface is built to be handed over as a finished deliverable. The entire database, search, and keyword index live in one single HTML file. There is no database server to set up, no software to install, and nothing to maintain or pay for monthly. If a web host can serve an ordinary web page, it can run this.
-
Download the file.
One click saves the complete, working database as a single file, with the episode data currently loaded baked in.
-
Upload it to any web host.
Use the host's file manager, FTP, or drag-and-drop upload (cPanel hosts, Netlify Drop, GitHub Pages, and every standard shared host all work). Rename it to
index.htmlinside its own folder — for exampleyoursite.com/episodes/— or keep its name and link to it directly. -
Link to it and you're done.
Add a link from the podcast's existing pages and visitors get the full searchable catalog. To publish new episodes later: load the updated spreadsheet CSV above, download the refreshed file, and re-upload it over the old one. A one-minute job, start to finish.
The episode audio stays where it already lives — each entry links straight to the MP3 on reclaimingtherepublic.org, so the file itself stays small (a few kilobytes per hundred episodes) and loads fast anywhere.