Here you will find the following bible versions in sql, sqlite, xml, csv, and json format:
- American Standard-ASV1901 (ASV)
- Bible in Basic English (BBE)
- Darby English Bible (DARBY)
- King James Version (KJV)
- Webster's Bible (WBT)
- World English Bible (WEB)
- Young's Literal Translation (YLT)
All included Bible translations are in the public domain.
Also find a Master SQL and SQLite file (top level) containing all tables.
Please let me know if any verses/text were inaccurately transferred in conversion.
Each verse is accessed by a unique key, the combination of the BOOK+CHAPTER+VERSE id.
Example:
Genesis 1:1 (Genesis chapter 1, verse 1) = 01001001 (01 001 001)
Exodus 2:3 (Exodus chapter 2, verse 3) = 02002003 (02 002 003)
The verse-id system is used for faster, simplified queries. For instance:
01001001 - 02001005 would capture all verses between Genesis 1:1 through Exodus 1:5.
Written simply:
SELECT *
FROM bible.t_asv
WHERE id
BETWEEN 01001001
AND 02001005
There is also a number-to-book key (key_english table), a cross-reference list (cross_reference table), and a bible key containing meta information about the included translations (bible_version_key table). See below SQL table layout. These tables work together providing you a great basis for a bible-reading and cross-referencing app.
While its expected that your programs would use the verse-id system, book #, chapter #, and verse # columns have been included in the bible versions tables.
A very special and valuable addition to these databases is the extensive cross-reference table. Its combined from trustworthy sources. Its extremely useful in bible study for discovering related scriptures. For any given verse, you simply query vid (verse id), and a list of rows will be returned. Each of those rows has a rank (r) for relevance, start-verse (sv), and end verse (ev) if there is one.
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(3) unsigned zerofill | NO | PRI | auto_increment | |
| table | text | NO | Corresponding Bible version table name. | ||
| abbreviation | text | NO | Bible version abbreviation. | ||
| language | text | NO | Language translation. | ||
| version | text | NO | Version name. | ||
| info_text | text | NO | Extra info. | ||
| info_url | text | NO | Wiki info or similar URL | ||
| publisher | text | NO | Who published. | ||
| copyright | text | NO | Copyright | ||
| copyright_info | text | NO | More info on copyright. |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| vid | int(8) unsigned zerofill | NO | MUL | VERSE ID | |
| r | int(11) | NO | RANK | ||
| sv | int(8) unsigned zerofill | NO | START VERSE | ||
| ev | int(8) unsigned zerofill | NO | END VERSE |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| b | int(11) | NO | PRI | Book # | |
| n | text | NO | Book Name |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(8) unsigned zerofill | NO | PRI | Verse ID | |
| b | int(11) | NO | Book | ||
| c | int(11) | NO | Chapter | ||
| v | int(11) | NO | Verse | ||
| t | text | NO | Text |
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.