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). For instance:Ġ1001001 - 02001005 would capture all verses between Genesis 1:1 through Exodus 1:5. The verse-id system is used for faster, simplified queries. cross_references.txt is the source cross-reference file obtained from Įach verse is accessed by a unique key, the combination of the BOOK+CHAPTER+VERSE id.bible-sqlite.db (SQLite) is a basic simplified database for simpler applications (includes cross-references too).It has been separated to become an optional feature. cross_references-mysql.sql (MySQL) is the cross-reference table.It is suggested you use that for most things, or at least convert the information from it. bible-mysql.sql (MySQL) is the main database and most feature-oriented due to contributions from developers.Looking for deuterocanonical / apocryphal books? Find them here: Summary: Please let me know if any verses/text were inaccurately transferred in conversion. Here you will find the following bible versions in sql, sqlite, xml, csv, json, txt, and md format:Īll included Bible translations are in the public domain. Bible Versions and Cross-Reference Databases: mysql, sqlite, xml, csv, json, txt, md.

Niv bible in xml format