LXX Project

To generate lxx.db, simply run:

python3 main.py

This python script transforms plain text lxx files retreived from http://ccat.sas.upenn.edu into a sqlite3 database. See here for the files.

The resulting database (lxx.db) stores book, verse, and word number attributes as well as root and morphological data in the format:

id|book name|ch|v|w|word|root|morphology ---|---|---|---|---|---|---|--- 183022|Exod|1|1|1|ταῦτα|οὗτος|RD NPN 183023|Exod|1|1|2|τὰ|ὁ|RA NPN 183024|Exod|1|1|3|ὀνόματα|ὄνομα|N3M NPN 183025|Exod|1|1|4|τῶν|ὁ|RA GPM 183026|Exod|1|1|5|υἱῶν|υἱός|N2 GPM 183027|Exod|1|1|6|Ισραηλ|Ἰσραήλ|N GSM 183028|Exod|1|1|7|τῶν|ὁ|RA GPM 183029|Exod|1|1|8|εἰσπεπορευμένων|πορεύομαι εἰς|VX XPPGPM 183030|Exod|1|1|9|εἰς|εἰς|P 183031|Exod|1|1|10|Αἴγυπτον|Αἴγυπτος|N2 ASF

Sample Queries

1. get all the words in a verse

   select word from content where book_name="Gen" and chapter_nr=1 and verse_nr=1 order by word_nr asc;
   

2. get all book names

   select distinct book_name from content;
   

3. get number of chapters in genesis

   select max(chapter_nr) from content where book_name="Gen";
   

4. get number of verses in the first chapter of genesis

   select max(verse_nr) from content where book_name="Gen" and chapter_nr=1;