entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ART_ARTHUR"
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_ART_ARTHUR_GEOFFR | King Arthur ENT_ART_ARTHUR | Geoffrey of Monmouth, Historia Regum Britanniae, c. 1136 CE SRC_GEOFFREY_MONMOUTH | Geoffrey of Monmouth, Historia Regum Britanniae | Geoffrey of Monmouth, Historia Regum Britanniae | XX.--_Arthur prepares for a war, and refuses to pay tribute to the Romans._ King Arthur, seeing all unanimously ready for his service, ordered them to return back to their countries with speed, and get ready the forces which they had promised, and to hasten to the general rendezvous upon the kalends of August, at the mouth of the river Barba, that from thence they might advance with them to the borders of the Allobroges, to meet the Romans. | J. A. Giles | 1848 | https://www.gutenberg.org/ebooks/37848 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (J. A. Giles, in Old English Chronicles, Gutenberg #37848) located by name; verify book.chapter. |
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]);