entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_GRR_PLAIN_LETHE"

✎ 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_GRR_PLAIN_LETHE_VIRGIL The Plain of Lethe ENT_GRR_PLAIN_LETHE Virgil, Aeneid (19 BCE) SRC_VIRGIL_AENEID Virgil, Aeneid Virgil, Aeneid The god was wroth, and at his temples threw A branch in Lethe dipp'd, and drunk with Stygian dew: The pilot, vanquish'd by the pow'r divine, Soon clos'd his swimming eyes, and lay supine. Scarce were his limbs extended at their length, The god, insulting with superior strength, Fell heavy on him, plung'd him in the sea, And, with the stern, the rudder tore away. Headlong he fell, and, struggling in the main, Cried out for helping hands, but cried in vain. John Dryden 1697 https://www.gutenberg.org/ebooks/228 primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 English verse translation located by name; the locus is the Latin line-numbering — consult the original. https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.02.0055

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