entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NORR_BIFROST"
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_NORR_BIFROST_PROSE_ | Bifröst (the rainbow bridge) ENT_NORR_BIFROST | Snorri Sturluson, Prose Edda SRC_PROSE_EDDA | Snorri Sturluson, Prose Edda | Snorri Sturluson, Prose Edda | Have you not been told that the gods made a bridge from earth to heaven, which is called Bifrost? You must have seen it. It may be that you call it the rainbow. It has three colors, is very strong, and is made with more craft and skill than other structures. Still, however strong it is, it will break when the sons of Muspel come to ride over it, and then they will have to swim their horses over great rivers in order to get on. | Rasmus B. Anderson | 1880 | https://www.gutenberg.org/ebooks/18947 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (Anderson, The Younger Edda) located by name within the work (not exact chapter); 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]);