entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ISR_JEROBOAM_II"
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_JEROBOAM_II_KJV | Jeroboam II ENT_ISR_JEROBOAM_II | 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) | Hosea 1:1 | The word of the LORD that came unto Hosea, the son of Beeri, in the days of Uzziah, Jotham, Ahaz, and Hezekiah, kings of Judah, and in the days of Jeroboam the son of Joash, king 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]);