entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ISR_KINGS_ISRAEL"
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_KINGS_ISRAEL_KJV | The Kings of the Northern Kingdom of Israel ENT_ISR_KINGS_ISRAEL | 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) | Joshua 5:1 | And it came to pass, when all the kings of the Amorites, which were on the side of Jordan westward, and all the kings of the Canaanites, which were by the sea, heard that the LORD had dried up the waters of Jordan from before the children of Israel, until we were passed over, that their heart melted, neither was there spirit in them any more, because of the children of Israel. | 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]);