“Heaven and earth shall pass away, but my words shall not pass away.”

Matthew 24:35

“Wherefore, how great the importance to make these things known unto the inhabitants of the earth, that they may know that there is no flesh that can dwell in the presence of God, save it be through the merits, and mercy, and grace of the Holy Messiah, who layeth down his life according to the flesh, and taketh it again by the power of the Spirit, that he may bring to pass the resurrection of the dead, being the first that should rise.”

2 Nephi 2:8

This project's goal is to provide open database and text export formats of scriptures in the public domain for use by developers. The canon of scripture is that used by the Church of Jesus Christ of Latter-day Saints, containing:

King James Version of the Holy Bible

• Old Testament
• New Testament

Translated Scriptures and Modern Revelation

• The Book of Mormon - Another Testament of Jesus Christ
• Doctrine and Covenants
• The Pearl of Great Price

Exports are available for:

• MySQL
• PostgreSQL
• SQLite
• CSV
• JSON
• Microsoft Excel
• Open Document Spreadsheet

The schemas for the databases are intentionally both normalized and non-normalized, which is why you'll see seemingly duplicate tables. This is so that people who want to jump right in, can start running queries against the scriptures table, while those looking for other indexing or more complex queries can use the other ones.

• ChangeLog
• Installation (old)
• Naming Standards
• Omitted Texts

• Character Encoding
• Database Notes
• Database Schema
• Database Views
• Import Process
• Regular Expressions
• Remove Volume from Database
• Sample Queries
• Word Diffs

• Fortune Modules
• lds-scriptures.js

• The Church of Jesus Christ of Latter-day Saints - Scriptures
• Brigham Young University - Scripture Citation Index
• The SWORD Project - Open Source Bible Software

Any kind of feedback is always appreciated. I'm always interested to hear how people are using the exports, if they are helpful, or if there are any bugs they've found or have any feature requests.

Feel free to contact me directly.

What's the copyright status of these exports?

The scriptures, original works and documentation of this project are all part of the public domain in the USA.

Simply speaking, this means you can do whatever you'd like with everything here without having to ask for permission.

Do you include the Topical Guide or Bible Dictionary, chapter headers, indexes, references, etc.?

The downloads don't have exports of any of those. The chapter headers and the Bible Dictionary would be considered original works, and thus subject to U.S. copyright.

The indexes, chapter references, and topical guide could be argued that since they are lists, that they would not fall under copyright. That's probably true, but I don't include them.

Do you have the Scriptures available in other languages?

Just English for now. I get a lot of requests for a Spanish export, which I could do since I can read the language, but I don't feel confident enough to make sure I get a clean copy. Languages other than that, I wouldn't venture to attempt, since I wouldn't be able to make sure they are accurate or not.

Can you make exports for other formats?

Sure! Just let me know what you'd like. I used to have some for Microsoft Access and XML, but since they're pretty obscure, I dropped doing it in newer releases. Making a port to another format can be tedious, but once it's cleanly scripted, it's easy to do.

There's some software I don't have access to, otherwise I'd create database exports myself. Examples include Microsoft SQL Server and Oracle.