entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_AST_PLANETARY_SPIRITS"

✎ 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_AST_PLANETARY_SPIRITS_PICATR The Seven Planetary Spirits of the Picatrix ENT_AST_PLANETARY_SPIRITS Picatrix (Ghayat al-Hakim), trans. Greer & Warnock; ed. Pingree SRC_PICATRIX Picatrix (Ghayat al-Hakim) Picatrix (Ghayat al-Hakim) FOREWORD THIS THIRD VERSION of the text of Picatrix to be published by the Warburg Institute appears more than fifty years after Hellmut Ritter first made the Arabic available in 1933 (Studien der Bibliothek Warburg, 12). The German translation made from the Arabic by Ritter and by Martin Plessner came out. in 1962. as the twenty-seventh of the English series, Studies of the Warburg Institute. Greer & Warnock 2011 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 In-copyright translation — brief flagged excerpt; verify.  

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