entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_PORPHYRION"

✎ 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_PORPHYRION_APOLLOD Porphyrion ENT_PORPHYRION Pseudo-Apollodorus, Library (Bibliotheca) (1st-2nd century CE); trans. J. G. Frazer (Loeb Classical Library, 1921) SRC_APOLLODORUS_LIBRARY Pseudo-Apollodorus, Library Library 1.6.1-2 But in the battle Porphyrion attacked Hercules and Hera. Nevertheless Zeus inspired him with lust for Hera, and when he tore her robes and would have forced her, she called for help, and Zeus smote him with a thunderbolt, and Hercules shot him dead with an arrow. J. G. Frazer 1921 https://www.theoi.com/Text/Apollodorus1.html primary-verbatim   2026-06-26 name + substring gate against Frazer Apollodorus 1 1 Named in the Gigantomachy of Apollodorus 1.6 (Frazer); verify section.  

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