places

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ASCLEPIUS"

✎ 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
8 8 Asclepius ENT_ASCLEPIUS Epidaurus healing sanctuary   Theoi Deified Mortals index SRC_THEOI_DEIFIED 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]);