entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_SINDRI"
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_SINDRI_PROSE_ | Sindri ENT_NOR_SINDRI | Snorri Sturluson, Prose Edda SRC_PROSE_EDDA | Snorri Sturluson, Prose Edda | Snorri Sturluson, Prose Edda | Thereupon Loke wagered his head with the dwarf, who hight Brok, that his brother Sindre would not be able to make three other treasures equally as good as these were. But when they came to the smithy, Sindre laid a pig-skin in the furnace and requested Brok to blow the bellows, and not to stop blowing before he (Sindre) had taken out of the furnace what he had put into it. | 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]);