entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_THOR"

✎ 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_NOR_THOR_POETIC Thor ENT_NOR_THOR Poetic Edda SRC_POETIC_EDDA The Poetic Edda The Poetic Edda My sire, fierce of mood, a kettle owns, a capacious cauldron, a rast in depth." _Thor_. 6. "Knowest thou whether we can get the liquor-boiler?" _Ty_. "Yes, friend! if we stratagem' employ." Rapidly they drove forward that day from Asgard, till to the giant's home they came. 7. Thor stalled his goats, splendid of horn, then turned him to the hall that Hymir owned. 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 located by name within the work (not exact stanza); 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]);