entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_THE_SANAT_KUMARA"
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_THE_SANAT_KUMARA_SECRET | Sanat Kumara ENT_THE_SANAT_KUMARA | Helena P. Blavatsky, The Secret Doctrine (London: Theosophical Publishing Company, 1888) SRC_BLAVATSKY_SECRET_DOCTRINE | H. P. Blavatsky, The Secret Doctrine | H. P. Blavatsky, The Secret Doctrine | cient of Days, Brahma, in his _triune_ form, whose name is also Sanat, the Ancient? Every Kumara bears the prefix of Sanat and Sana. And Shanaishchara is Saturn, the planet Shani, the King Saturn, whose Secretary in Egypt was Thot‐Hermes the first. | H. P. Blavatsky | 1888 | https://www.gutenberg.org/ebooks/54824 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | Located by name; verify volume/page. |
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]);