entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NORR_MIDGARD"

✎ View and edit SQL

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_MIDGARD_PROSE_ Midgard (Miðgarðr) ENT_NORR_MIDGARD Snorri Sturluson, Prose Edda SRC_PROSE_EDDA Snorri Sturluson, Prose Edda Snorri Sturluson, Prose Edda From them all mankind is descended, and a dwelling-place was given them under Midgard. In the next place, the sons of Bor made for themselves in the middle of the world a burg, which is called Asgard, and which we call Troy. There dwelt the gods and their race, and thence were wrought many tidings and adventures, both on earth and in the sky. 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

CSV options: 

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]);