entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ITA_PICUS"

✎ 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_ITA_PICUS_VIRGIL Picus ENT_ITA_PICUS Virgil, Aeneid (19 BCE) SRC_VIRGIL_AENEID Virgil, Aeneid Aeneid 7.48: But Faunus came from Picus: Picus drew His birth from Saturn, if records be true. Thus King Latinus, in the third degree, Had Saturn author of his family. But this old peaceful prince, as Heav'n decreed, Was blest with no male issue to succeed: His sons in blooming youth were snatch'd by fate; One only daughter heir'd the royal state. Fir'd with her love, and with ambition led, The neighb'ring princes court her nuptial bed. 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]);