entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_WEL_AMAETHON"
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_WEL_AMAETHON_MABINO | Amaethon ENT_WEL_AMAETHON | The Mabinogion SRC_MABINOGION | The Mabinogion | The Mabinogion | No husbandman can till or prepare this land, so wild is it, except Amaethon the son of Don, and he will not come with thee by his own free will, and thou wilt not be able to compel him." "It will be easy for me to compass this, although thou mayest think that it will not be easy." "Though thou get this, there is yet that which thou wilt not get. | Lady Charlotte Guest | 1877 | https://www.gutenberg.org/ebooks/5160 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation located by name within the work; verify locus. |
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]);