Public-domain publishing finder

App gallery / Business

Public-domain publishing finder: books by issued on, by year, new author form, author record

Shown in Parchment Wine Journal · 16 featured looks, 520+ more to choose from

Public-domain publishing finder

The whole Project Gutenberg catalogue (about 79,000 texts) with each author listed once, with the birth and death years the catalogue gives, and who wrote, translated, illustrated or edited each book. Project Gutenberg's texts are public domain in the United States; in the UK and EU a work is generally free once its author has been dead 70 years, so filter on the died column. Track your own projects: the edition you plan (paperback, ebook, audiobook, annotated, translation), its status, ISBN and target date. Check each work's rights yourself before publishing: translations, illustrations and editors' notes can carry their own rights.

Database app · 4 tables · design: Parchment Wine Journal

Making an app from a pack is for subscribers. Sign in

Tables

  • books9 columns · 78,383 rows in the full data
  • authors5 columns · 36,692 rows in the full data
  • book_authors5 columns · 108,862 rows in the full data
  • projects8 columns

Sources and licences

  • Project Gutenberg catalogue — Public domain metadata (Free to use)
  • Own packs (ours) — Ours (Free to use)

Sample: the whole source. Full data: 223,937 rows, 21.3 MB. Measured 2026-10-22.

Data from www.gutenberg.org, imported 2026-10-22.

The full data, for your own database

223,937 rows, 7.5 MB to download. CreativePower keeps only the made-up sample rows in your project; load the full data into your own PostgreSQL database (Supabase works): download these files into one folder, unzip the .csv.gz files, then run psql "<your connection string>" -f load.sql.