entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ISR_GOLIATH"
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_GOLIATH_KJV | Goliath ENT_ISR_GOLIATH | 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) | 1 Samuel 17:23 | And as he talked with them, behold, there came up the champion, the Philistine of Gath, Goliath by name, out of the armies of the Philistines, and spake according to the same words: and David heard them. | 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]);