entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ROM_MAGNA_MATER"
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_ROM_MAGNA_MATER_LIVY | Magna Mater ENT_ROM_MAGNA_MATER | Livy, Ab Urbe Condita (Books 1–10, 21–45; c. 27 BCE – 9 CE) SRC_LIVY_AUC | Livy, Ab Urbe Condita | Livy, Ab Urbe Condita | Do you wish, according to the example of your ancestors, to augment the Roman state by admitting the vanquished among your citizens? Materials for extending your power by the highest glory are at hand. That government is certainly by far the most secure, which the subjects feel a pleasure in obeying. But whatever determination ye wish to come to, it is necessary that it be speedy. | Canon Roberts | 1912 | https://www.gutenberg.org/ebooks/19725 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (Canon Roberts, Everyman ed.) located by name; verify book.chapter. |
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]);