geoblock_territories

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

15 rows where geoblock_id = "GEO_1NT691A6VGSG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1NT691A6VGSG,CA,0 GEO_1NT691A6VGSG CA 0
GEO_1NT691A6VGSG,DE,0 GEO_1NT691A6VGSG DE 0
GEO_1NT691A6VGSG,ES,0 GEO_1NT691A6VGSG ES 0
GEO_1NT691A6VGSG,FI,0 GEO_1NT691A6VGSG FI 0
GEO_1NT691A6VGSG,FR,0 GEO_1NT691A6VGSG FR 0
GEO_1NT691A6VGSG,GB,0 GEO_1NT691A6VGSG GB 0
GEO_1NT691A6VGSG,IE,0 GEO_1NT691A6VGSG IE 0
GEO_1NT691A6VGSG,IT,0 GEO_1NT691A6VGSG IT 0
GEO_1NT691A6VGSG,NL,0 GEO_1NT691A6VGSG NL 0
GEO_1NT691A6VGSG,PH,0 GEO_1NT691A6VGSG PH 0
GEO_1NT691A6VGSG,PL,0 GEO_1NT691A6VGSG PL 0
GEO_1NT691A6VGSG,PT,0 GEO_1NT691A6VGSG PT 0
GEO_1NT691A6VGSG,SE,0 GEO_1NT691A6VGSG SE 0
GEO_1NT691A6VGSG,US,0 GEO_1NT691A6VGSG US 0
GEO_1NT691A6VGSG,WORLD,2 GEO_1NT691A6VGSG WORLD 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE geoblock_territories (
      geoblock_id TEXT NOT NULL,
      territory TEXT NOT NULL,
      type INTEGER NOT NULL,
      PRIMARY KEY (geoblock_id, territory, type),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_geoblock_territories_geoblock ON geoblock_territories(geoblock_id);