entity_citations
Data license: MIT · Data source: jebboone/deitydb
2 rows where entity_id = "ENT_ROM_APOLLO"
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_ROM_APOLLO_MEYER | Apollo ENT_ROM_APOLLO | Marvin W. Meyer (ed.), The Ancient Mysteries: A Sourcebook of Sacred Texts (HarperSanFrancisco, 1987) SRC_MEYER_MYSTERIES | The Ancient Mysteries: A Sourcebook | Apollo in the Greco-Roman sacred texts | Marvin W. Meyer (ed.) | 1987 | secondary | Apollo, oracular and solar god named in the mystery sources. | 2026-07-05 | presence verified in context by extraction of Meyer, The Ancient Mysteries (in-copyright) — bibliographic pointer, no text reproduced | 2 | 1 | secondary pointer [v2.1.74] | |||
| CIT_ROM_APOLLO_SEC | Apollo ENT_ROM_APOLLO | Ovid, Fasti SRC_OVID_FASTI | Matthew Bunson, Encyclopedia of Ancient Rome (Facts on File, 1994), s.v. Apollo | Fasti 3.881 | Greek god who was in time accepted by the Romans. | primary-uncited | 2026-06-26 | secondary-scholarship excerpt; substring-gated against Bunson Encyclopedia of Ancient Rome OCR | 2 | 1 | Reference encyclopedia (general reference publisher, not academic press) — brief attributed excerpt; verify against the print edition. |
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]);