entity_citations

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_AGATHOS_DAIMON"

✎ 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_AGATHOS_DAIMON_PGM Agathos Daimon ENT_AGATHOS_DAIMON Hans Dieter Betz (ed.), The Greek Magical Papyri in Translation, Including the Demotic Spells (2nd ed., University of Chicago Press, 1992) SRC_BETZ_PGM The Greek Magical Papyri in Translation Hymn invoking Agathos Daimon ("for whom heaven has become the processional way")   Hans Dieter Betz (ed.) 1992   secondary Agathos Daimon (the Good Spirit) invoked as a cosmic serpent-god. 2026-07-05 presence verified in context by extraction of Betz, Greek Magical Papyri (in-copyright) — bibliographic pointer, no text reproduced 2 1 secondary pointer [v2.1.72]  
CIT_AGATHOS_DAIMON_SEC Agathos Daimon ENT_AGATHOS_DAIMON Aristophanes, Knights (Hippeis), 424 BCE SRC_ARISTOPHANES_KNIGHTS Aristophanes, Knights (Hippeis), 424 BCE Knights 85:         primary-uncited     Track-2 formalization of the entity's existing source attestation (no verbatim quote — pointer + grade + flag) 2 1 Primary source identified but not yet quoted verbatim; the on-page summary is an editorial paraphrase pending verification against this text.  

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