entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_LOFN"
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_LOFN_EDDA | Lofn ENT_NOR_LOFN | Snorri Sturluson, Prose Edda SRC_PROSE_EDDA | Snorri Sturluson, Prose Edda (Gylfaginning) | Gylfaginning | The goddess is Lofn, who is kind and good to those who call upon her, and she has permission from Alfather or Frigg to bring together men and women, no matter what difficulties may stand in the way; therefore “love” is so called from her name, and also that which is much loved by men. | Rasmus B. Anderson | 1880 | https://www.gutenberg.org/ebooks/18947 | primary-verbatim | 2026-06-26 | name + substring gate against Snorri Sturluson, Prose Edda (Gylfaginning) | 1 | 1 | Named in Snorri Sturluson, Prose Edda (Gylfaginning); verify. |
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]);