entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_AST_PERFECT_NATURE"

✎ 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_PERFECT_NATURE_PICATR Perfect Nature (al-Tiba al-Tamm) ENT_AST_PERFECT_NATURE Picatrix (Ghayat al-Hakim), trans. Greer & Warnock; ed. Pingree SRC_PICATRIX Picatrix (Ghayat al-Hakim) Picatrix (Ghayat al-Hakim) Perfectus est anno 1256 Domini nostri, Caesaris 1295, Alexandri 1568, Arabum 655. Nonnisi sapientibus hoc dedicatum opus. a (I ii I) Magica sapientiam sonat. Sic appellamus omnia quae homo operatur et ex quibus sensus et spiritus sequuntur illo opere per omnes partes et pro rebus mirabilibus qui bus operantem quod spiritus sequatur ea adiuvando administrandoque. Et ista sunt difficilia intellectui ratione sensus ut visui certant suis similitudinibus. 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]);