entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_FREKI"
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_NOR_FREKI_POETIC | Freki ENT_NOR_FREKI | Poetic Edda SRC_POETIC_EDDA | The Poetic Edda | The Poetic Edda | Odin,' replied Har, 'gives the meat that is set before him to two wolves, called Geri and Freki, for he himself stands in no need of food. Wine is for him both meat and drink. "Two ravens sit on Odin's shoulders and whisper in his ear the tidings and events they have heard and witnessed. They are called Hugin and Munin. He sends them out at dawn of day to fly over the whole world, and they return at eve towards meal time. | Benjamin Thorpe | 1866 | https://www.gutenberg.org/ebooks/14726 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (Benjamin Thorpe, in the Norroena ed. Gutenberg #14726) located by name within the work (not exact stanza); 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]);