entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_THALASSA"

✎ 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_THALASSA_THEOG Thalassa ENT_THALASSA Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY Hesiod, Theogony lines 233-239 And Sea begat Nereus, the eldest of his children, who is true and lies not: and men call him the Old Man because he is trusty and gentle and does not forget the laws of righteousness, but thinks just and kindly thoughts. And yet again he got great Thaumas and proud Phorcys, being mated with Earth, and fair-cheeked Ceto and Eurybia who has a heart of flint within her. Hugh G. Evelyn-White 1914 https://www.gutenberg.org/ebooks/348 primary-verbatim   2026-06-17 deterministic verbatim extraction + substring gate (Gutenberg #348, line-numbered) 1 0    

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