naming_standards
Naming Standards
When referencing the scriptures, one verse can have many titles. Do you use John 3:16, St. John 3:16, Saint John 3:16 or St John 3:16?
The exports have multiple formats so that users can choose one they like.
Using the SQLite database as an example, you can see the different column names. Here, for volumes:
sqlite> .mode line
sqlite> select * from volumes;
id = 1
volume_title = Old Testament
volume_long_title = The Old Testament
volume_subtitle =
volume_short_title = OT
volume_lds_url = ot
id = 2
volume_title = New Testament
volume_long_title = The New Testament
volume_subtitle = Of our Lord and Saviour Jesus Christ
volume_short_title = NT
volume_lds_url = nt
id = 3
volume_title = Book of Mormon
volume_long_title = The Book of Mormon
volume_subtitle = Another Testament of Jesus Christ
volume_short_title = BoM
volume_lds_url = bm
id = 4
volume_title = Doctrine and Covenants
volume_long_title = The Doctrine and Covenants
volume_subtitle =
volume_short_title = D&C
volume_lds_url = dc
id = 5
volume_title = Pearl of Great Price
volume_long_title = The Pearl of Great Price
volume_subtitle =
volume_short_title = PGP
volume_lds_url = pgp
For books:
id = 1
volume_id = 1
book_title = Genesis
book_long_title = The First Book of Moses called Genesis
book_subtitle =
book_short_title = Gen.
book_lds_url = gen
id = 2
volume_id = 1
book_title = Exodus
book_long_title = The Second Book of Moses called Exodus
book_subtitle =
book_short_title = Ex.
book_lds_url = ex
id = 3
volume_id = 1
book_title = Leviticus
book_long_title = The Third Book of Moses called Leviticus
book_subtitle =
book_short_title = Lev.
book_lds_url = lev
id = 4
volume_id = 1
book_title = Numbers
book_long_title = The Fourth Book of Moses called Numbers
book_subtitle =
book_short_title = Num.
book_lds_url = num
id = 5
volume_id = 1
book_title = Deuteronomy
book_long_title = The Fifth Book of Moses called Deuteronomy
book_subtitle =
book_short_title = Deut.
book_lds_url = deut
id = 6
volume_id = 1
book_title = Joshua
book_long_title = The Book of Joshua
book_subtitle =
book_short_title = Josh.
book_lds_url = josh
id = 7
volume_id = 1
book_title = Judges
book_long_title = The Book of Judges
book_subtitle =
book_short_title = Judg.
book_lds_url = judg
id = 8
volume_id = 1
book_title = Ruth
book_long_title = The Book of Ruth
book_subtitle =
book_short_title = Ruth
book_lds_url = ruth
id = 9
volume_id = 1
book_title = 1 Samuel
book_long_title = The First Book of Samuel
book_subtitle = Otherwise called the First Book of the Kings
book_short_title = 1 Sam.
book_lds_url = 1-sam
id = 10
volume_id = 1
book_title = 2 Samuel
book_long_title = The Second Book of Samuel
book_subtitle = Otherwise called the Second Book of the Kings
book_short_title = 2 Sam.
book_lds_url = 2-sam
id = 11
volume_id = 1
book_title = 1 Kings
book_long_title = The First Book of the Kings
book_subtitle = Commonly called the Third Book of the Kings
book_short_title = 1 Kgs.
book_lds_url = 1-kgs
id = 12
volume_id = 1
book_title = 2 Kings
book_long_title = The Second Book of the King
book_subtitle = Commonly called the Fourth Book of the Kings
book_short_title = 2 Kgs.
book_lds_url = 2-kgs
id = 13
volume_id = 1
book_title = 1 Chronicles
book_long_title = The First Book of the Chronicles
book_subtitle =
book_short_title = 1 Chr.
book_lds_url = 1-chr
id = 14
volume_id = 1
book_title = 2 Chronicles
book_long_title = The Second Book of the Chronicles
book_subtitle =
book_short_title = 2 Chr.
book_lds_url = 2-chr
id = 15
volume_id = 1
book_title = Ezra
book_long_title = Ezra
book_subtitle =
book_short_title = Ezra
book_lds_url = ezra
id = 16
volume_id = 1
book_title = Nehemiah
book_long_title = The Book of Nehemiah
book_subtitle =
book_short_title = Neh.
book_lds_url = neh
id = 17
volume_id = 1
book_title = Esther
book_long_title = The Book of Esther
book_subtitle =
book_short_title = Esth.
book_lds_url = esth
id = 18
volume_id = 1
book_title = Job
book_long_title = The Book of Job
book_subtitle =
book_short_title = Job
book_lds_url = job
id = 19
volume_id = 1
book_title = Psalms
book_long_title = The Book of Psalms
book_subtitle =
book_short_title = Ps.
book_lds_url = ps
id = 20
volume_id = 1
book_title = Proverbs
book_long_title = The Proverbs
book_subtitle =
book_short_title = Prov.
book_lds_url = prov
id = 21
volume_id = 1
book_title = Ecclesiastes
book_long_title = Ecclesiastes or, The Preacher
book_subtitle =
book_short_title = Eccl.
book_lds_url = eccl
id = 22
volume_id = 1
book_title = Solomon's Song
book_long_title = The Song of Solomon
book_subtitle =
book_short_title = Song.
book_lds_url = song
id = 23
volume_id = 1
book_title = Isaiah
book_long_title = The Book of the Prophet Isaiah
book_subtitle =
book_short_title = Isa.
book_lds_url = isa
id = 24
volume_id = 1
book_title = Jeremiah
book_long_title = The Book of the Prophet Jeremiah
book_subtitle =
book_short_title = Jer.
book_lds_url = jer
id = 25
volume_id = 1
book_title = Lamentations
book_long_title = The Lamentations of Jeremiah
book_subtitle =
book_short_title = Lam.
book_lds_url = lam
id = 26
volume_id = 1
book_title = Ezekiel
book_long_title = The Book of the Prophet Ezekiel
book_subtitle =
book_short_title = Ezek.
book_lds_url = ezek
id = 27
volume_id = 1
book_title = Daniel
book_long_title = The Book of Daniel
book_subtitle =
book_short_title = Dan.
book_lds_url = dan
id = 28
volume_id = 1
book_title = Hosea
book_long_title = Hosea
book_subtitle =
book_short_title = Hosea
book_lds_url = hosea
id = 29
volume_id = 1
book_title = Joel
book_long_title = Joel
book_subtitle =
book_short_title = Joel
book_lds_url = joel
id = 30
volume_id = 1
book_title = Amos
book_long_title = Amos
book_subtitle =
book_short_title = Amos
book_lds_url = amos
id = 31
volume_id = 1
book_title = Obadiah
book_long_title = Obadiah
book_subtitle =
book_short_title = Obad.
book_lds_url = obad
id = 32
volume_id = 1
book_title = Jonah
book_long_title = Jonah
book_subtitle =
book_short_title = Jonah
book_lds_url = jonah
id = 33
volume_id = 1
book_title = Micah
book_long_title = Micah
book_subtitle =
book_short_title = Micah
book_lds_url = micah
id = 34
volume_id = 1
book_title = Nahum
book_long_title = Nahum
book_subtitle =
book_short_title = Nahum
book_lds_url = nahum
id = 35
volume_id = 1
book_title = Habakkuk
book_long_title = Habakkuk
book_subtitle =
book_short_title = Hab.
book_lds_url = hab
id = 36
volume_id = 1
book_title = Zephaniah
book_long_title = Zephaniah
book_subtitle =
book_short_title = Zeph.
book_lds_url = zeph
id = 37
volume_id = 1
book_title = Haggai
book_long_title = Haggai
book_subtitle =
book_short_title = Hag.
book_lds_url = hag
id = 38
volume_id = 1
book_title = Zechariah
book_long_title = Zechariah
book_subtitle =
book_short_title = Zech.
book_lds_url = zech
id = 39
volume_id = 1
book_title = Malachi
book_long_title = Malachi
book_subtitle =
book_short_title = Mal.
book_lds_url = mal
id = 40
volume_id = 2
book_title = Matthew
book_long_title = The Gospel According to St Matthew
book_subtitle =
book_short_title = Matt.
book_lds_url = matt
id = 41
volume_id = 2
book_title = Mark
book_long_title = The Gospel According to St Mark
book_subtitle =
book_short_title = Mark
book_lds_url = mark
id = 42
volume_id = 2
book_title = Luke
book_long_title = The Gospel According to St Luke
book_subtitle =
book_short_title = Luke
book_lds_url = luke
id = 43
volume_id = 2
book_title = John
book_long_title = The Gospel According to St John
book_subtitle =
book_short_title = John
book_lds_url = john
id = 44
volume_id = 2
book_title = Acts
book_long_title = The Acts of the Apostles
book_subtitle =
book_short_title = Acts
book_lds_url = acts
id = 45
volume_id = 2
book_title = Romans
book_long_title = The Epistle of Paul the Apostle to the Romans
book_subtitle =
book_short_title = Rom.
book_lds_url = rom
id = 46
volume_id = 2
book_title = 1 Corinthians
book_long_title = The First Epistle of Paul the Apostle to the Corinthians
book_subtitle =
book_short_title = 1 Cor.
book_lds_url = 1-cor
id = 47
volume_id = 2
book_title = 2 Corinthians
book_long_title = The Second Epistle of Paul the Apostle to the Corinthians
book_subtitle =
book_short_title = 2 Cor.
book_lds_url = 2-cor
id = 48
volume_id = 2
book_title = Galatians
book_long_title = The Epistle of Paul the Apostle to the Galatians
book_subtitle =
book_short_title = Gal.
book_lds_url = gal
id = 49
volume_id = 2
book_title = Ephesians
book_long_title = The Epistle of Paul the Apostle to the Ephesians
book_subtitle =
book_short_title = Eph.
book_lds_url = eph
id = 50
volume_id = 2
book_title = Philippians
book_long_title = The Epistle of Paul the Apostle to the Philippians
book_subtitle =
book_short_title = Philip.
book_lds_url = philip
id = 51
volume_id = 2
book_title = Colossians
book_long_title = The Epistle of Paul the Apostle to the Colossians
book_subtitle =
book_short_title = Col.
book_lds_url = col
id = 52
volume_id = 2
book_title = 1 Thessalonians
book_long_title = The First Epistle of Paul the Apostle to the Thessalonians
book_subtitle =
book_short_title = 1 Thes.
book_lds_url = 1-thes
id = 53
volume_id = 2
book_title = 2 Thessalonians
book_long_title = The Second Epistle of Paul the Apostle to the Thessalonians
book_subtitle =
book_short_title = 2 Thes.
book_lds_url = 2-thes
id = 54
volume_id = 2
book_title = 1 Timothy
book_long_title = The First Epistle of Paul the Apostle to Timothy
book_subtitle =
book_short_title = 1 Tim.
book_lds_url = 1-tim
id = 55
volume_id = 2
book_title = 2 Timothy
book_long_title = The Second Epistle of Paul the Apostle to Timothy
book_subtitle =
book_short_title = 2 Tim.
book_lds_url = 2-tim
id = 56
volume_id = 2
book_title = Titus
book_long_title = The Epistle of Paul to Titus
book_subtitle =
book_short_title = Titus
book_lds_url = titus
id = 57
volume_id = 2
book_title = Philemon
book_long_title = The Epistle of Paul to Philemon
book_subtitle =
book_short_title = Philem.
book_lds_url = philem
id = 58
volume_id = 2
book_title = Hebrews
book_long_title = The Epistle of Paul to the Hebrews
book_subtitle =
book_short_title = Heb.
book_lds_url = heb
id = 59
volume_id = 2
book_title = James
book_long_title = The General Epistle of James
book_subtitle =
book_short_title = James
book_lds_url = james
id = 60
volume_id = 2
book_title = 1 Peter
book_long_title = The First Epistle General of Peter
book_subtitle =
book_short_title = 1 Pet.
book_lds_url = 1-pet
id = 61
volume_id = 2
book_title = 2 Peter
book_long_title = The Second Epistle General of Peter
book_subtitle =
book_short_title = 2 Pet.
book_lds_url = 2-pet
id = 62
volume_id = 2
book_title = 1 John
book_long_title = The First Epistle General of John
book_subtitle =
book_short_title = 1 Jn.
book_lds_url = 1-jn
id = 63
volume_id = 2
book_title = 2 John
book_long_title = The Second Epistle of John
book_subtitle =
book_short_title = 2 Jn.
book_lds_url = 2-jn
id = 64
volume_id = 2
book_title = 3 John
book_long_title = The Third Epistle of John
book_subtitle =
book_short_title = 3 Jn.
book_lds_url = 3-jn
id = 65
volume_id = 2
book_title = Jude
book_long_title = The General Epistle of Jude
book_subtitle =
book_short_title = Jude
book_lds_url = jude
id = 66
volume_id = 2
book_title = Revelation
book_long_title = The Revelation of St John the Divine
book_subtitle =
book_short_title = Rev.
book_lds_url = rev
id = 67
volume_id = 3
book_title = 1 Nephi
book_long_title = The First Book of Nephi
book_subtitle = His Reign and Ministry
book_short_title = 1 Ne.
book_lds_url = 1-ne
id = 68
volume_id = 3
book_title = 2 Nephi
book_long_title = The Second Book of Nephi
book_subtitle =
book_short_title = 2 Ne.
book_lds_url = 2-ne
id = 69
volume_id = 3
book_title = Jacob
book_long_title = The Book of Jacob
book_subtitle = The Brother of Nephi
book_short_title = Jacob
book_lds_url = jacob
id = 70
volume_id = 3
book_title = Enos
book_long_title = The Book of Enos
book_subtitle =
book_short_title = Enos
book_lds_url = enos
id = 71
volume_id = 3
book_title = Jarom
book_long_title = The Book of Jarom
book_subtitle =
book_short_title = Jarom
book_lds_url = jarom
id = 72
volume_id = 3
book_title = Omni
book_long_title = The Book of Omni
book_subtitle =
book_short_title = Omni
book_lds_url = omni
id = 73
volume_id = 3
book_title = Words of Mormon
book_long_title = Words of Mormon
book_subtitle =
book_short_title = W of M
book_lds_url = w-of-m
id = 74
volume_id = 3
book_title = Mosiah
book_long_title = The Book of Mosiah
book_subtitle =
book_short_title = Mosiah
book_lds_url = mosiah
id = 75
volume_id = 3
book_title = Alma
book_long_title = The Book of Alma
book_subtitle = The Son of Alma
book_short_title = Alma
book_lds_url = alma
id = 76
volume_id = 3
book_title = Helaman
book_long_title = The Book of Helaman
book_subtitle =
book_short_title = Hel.
book_lds_url = hel
id = 77
volume_id = 3
book_title = 3 Nephi
book_long_title = The Third Book of Nephi
book_subtitle = The Book of Nephi
The Son of Nephi, who was the Son of Helaman
book_short_title = 3 Ne.
book_lds_url = 3-ne
id = 78
volume_id = 3
book_title = 4 Nephi
book_long_title = The Fourth Book of Nephi
book_subtitle = The Book of Nephi
Who is the son of Nephi, one of the disciples of Jesus Christ
book_short_title = 4 Ne.
book_lds_url = 4-ne
id = 79
volume_id = 3
book_title = Mormon
book_long_title = The Book of Mormon
book_subtitle =
book_short_title = Morm.
book_lds_url = morm
id = 80
volume_id = 3
book_title = Ether
book_long_title = The Book of Ether
book_subtitle =
book_short_title = Ether
book_lds_url = ether
id = 81
volume_id = 3
book_title = Moroni
book_long_title = The Book of Moroni
book_subtitle =
book_short_title = Moro.
book_lds_url = moro
id = 82
volume_id = 4
book_title = Doctrine and Covenants
book_long_title = The Doctrine and Covenants
book_subtitle = of the Church of Jesus Christ of Latter-day Saints
book_short_title = D&C
book_lds_url = dc
id = 83
volume_id = 5
book_title = Moses
book_long_title = Selections from the Book of Moses
book_subtitle =
book_short_title = Moses
book_lds_url = moses
id = 84
volume_id = 5
book_title = Abraham
book_long_title = The Book of Abraham
book_subtitle = Translated from the papyrus, by Joseph Smith
book_short_title = Abr.
book_lds_url = abr
id = 85
volume_id = 5
book_title = Joseph Smith--Matthew
book_long_title = Joseph Smith--Matthew
book_subtitle =
book_short_title = JS-M
book_lds_url = js-m
id = 86
volume_id = 5
book_title = Joseph Smith--History
book_long_title = Joseph Smith--History
book_subtitle = Extracts from The History of Joseph Smith, the Prophet
book_short_title = JS-H
book_lds_url = js-h
id = 87
volume_id = 5
book_title = Articles of Faith
book_long_title = The Articles of Faith
book_subtitle = Of The Church of Jesus Christ of Latter-day Saints
book_short_title = A of F
book_lds_url = a-of-f
naming_standards.txt · Last modified: by steve