geoblock_territories

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

17 rows where geoblock_id = "GEO_1QER4KFM1ZTG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1QER4KFM1ZTG,AU,1 GEO_1QER4KFM1ZTG AU 1
GEO_1QER4KFM1ZTG,DE,1 GEO_1QER4KFM1ZTG DE 1
GEO_1QER4KFM1ZTG,ES,1 GEO_1QER4KFM1ZTG ES 1
GEO_1QER4KFM1ZTG,FI,1 GEO_1QER4KFM1ZTG FI 1
GEO_1QER4KFM1ZTG,FR,1 GEO_1QER4KFM1ZTG FR 1
GEO_1QER4KFM1ZTG,GB,1 GEO_1QER4KFM1ZTG GB 1
GEO_1QER4KFM1ZTG,IE,1 GEO_1QER4KFM1ZTG IE 1
GEO_1QER4KFM1ZTG,IN,1 GEO_1QER4KFM1ZTG IN 1
GEO_1QER4KFM1ZTG,IT,1 GEO_1QER4KFM1ZTG IT 1
GEO_1QER4KFM1ZTG,NL,1 GEO_1QER4KFM1ZTG NL 1
GEO_1QER4KFM1ZTG,NZ,1 GEO_1QER4KFM1ZTG NZ 1
GEO_1QER4KFM1ZTG,PK,1 GEO_1QER4KFM1ZTG PK 1
GEO_1QER4KFM1ZTG,PL,1 GEO_1QER4KFM1ZTG PL 1
GEO_1QER4KFM1ZTG,PT,1 GEO_1QER4KFM1ZTG PT 1
GEO_1QER4KFM1ZTG,SE,1 GEO_1QER4KFM1ZTG SE 1
GEO_1QER4KFM1ZTG,WORLD,2 GEO_1QER4KFM1ZTG WORLD 2
GEO_1QER4KFM1ZTG,ZA,1 GEO_1QER4KFM1ZTG ZA 1

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);