entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ISR_LOT"
This data as json, CSV (advanced)
Suggested facets: verified_on (date)
| citation_id ▼ | entity_id | source_id | work_title | locus | quote | translator | translation_year | source_url | evidence_grade | evidence_note | verified_on | verify_method | display_order | needs_review | review_reason | original_text_url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CIT_ISR_LOT_KJV | Lot ENT_ISR_LOT | The Hebrew Bible / Tanakh (primary text; Masoretic Text tradition; reference editions: Biblia Hebraica Stuttgartensia / Biblia Hebraica Quinta; citations by book, chapter, and verse) SRC_HEBREW_BIBLE | The Bible (King James Version) | Genesis 13:10 | And Lot lifted up his eyes, and beheld all the plain of Jordan, that it was well watered every where, before the LORD destroyed Sodom and Gomorrah, even as the garden of the LORD, like the land of Egypt, as thou comest unto Zoar. | King James Version | 1611 | https://www.gutenberg.org/ebooks/10 | primary-verbatim | English (KJV); chapter:verse is translation-independent — consult the original (linked). | 2026-06-18 | name-anchored to enclosing verse + substring gate (Gutenberg #10 KJV) | 1 | 1 | Verse located by name (note-scored) within the Bible; confirm it is the intended attestation. | https://www.sefaria.org/texts/Tanakh |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "entity_citations" (
[citation_id] TEXT PRIMARY KEY,
[entity_id] TEXT REFERENCES [entities]([entity_id]),
[source_id] TEXT REFERENCES [sources]([source_id]),
[work_title] TEXT,
[locus] TEXT,
[quote] TEXT,
[translator] TEXT,
[translation_year] INTEGER,
[source_url] TEXT,
[evidence_grade] TEXT,
[evidence_note] TEXT,
[verified_on] TEXT,
[verify_method] TEXT,
[display_order] INTEGER,
[needs_review] INTEGER,
[review_reason] TEXT,
[original_text_url] TEXT
);
CREATE INDEX [idx_entity_citations_source_id]
ON [entity_citations] ([source_id]);
CREATE INDEX [idx_entity_citations_entity_id]
ON [entity_citations] ([entity_id]);