entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_GRR_MOURNING_FIELDS"
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_MOURNING_FIELDS_VIRGIL | The Mourning Fields (Lugentes Campi) ENT_GRR_MOURNING_FIELDS | Virgil, Aeneid (19 BCE) SRC_VIRGIL_AENEID | Virgil, Aeneid | Virgil, Aeneid | Not far from thence, the Mournful Fields appear So call'd from lovers that inhabit there. The souls whom that unhappy flame invades, In secret solitude and myrtle shades Make endless moans, and, pining with desire, Lament too late their unextinguish'd fire. Here Procris, Eriphyle here he found, Baring her breast, yet bleeding with the wound Made by her son. He saw Pasiphae there, With Phaedra's ghost, a foul incestuous pair. | 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
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]);