places

Data license: MIT · Data source: jebboone/deitydb

2 rows where source_id = "SRC_THEOI_UNDERWORLD"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ entity_id place_name place_type place_authority_id source_id confidence review_status
6 6 Hecate ENT_HECATE crossroads/household thresholds cult setting   Theoi Underworld Gods index SRC_THEOI_UNDERWORLD B seed_pending
9 9 Python ENT_PYTHON Delphi oracle mythic site   Theoi Underworld Gods index SRC_THEOI_UNDERWORLD B seed_pending

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "places" (
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [place_name] TEXT,
   [place_type] TEXT,
   [place_authority_id] TEXT,
   [source_id] TEXT REFERENCES [sources]([source_id]),
   [confidence] TEXT,
   [review_status] TEXT
);
CREATE INDEX [idx_places_source_id]
    ON [places] ([source_id]);
CREATE INDEX [idx_places_entity_id]
    ON [places] ([entity_id]);