entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ART_BEDIVERE"
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_BEDIVERE_GEOFFR | Bedivere ENT_ART_BEDIVERE | Geoffrey of Monmouth, Historia Regum Britanniae, c. 1136 CE SRC_GEOFFREY_MONMOUTH | Geoffrey of Monmouth, Historia Regum Britanniae | Geoffrey of Monmouth, Historia Regum Britanniae | Fly, dear sir, fly, for fear he may come, as he usually does, to lie with me, and finding you here most barbarously butcher you." Bedver, moved at what she said, as much as it is possible for human nature to be, endeavoured with kind words to assuage her grief, and to comfort her with the promise of speedy help: and then returned back to Arthur, and gave him an account of what he had met with. | 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]);