geoblock_territories

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

17 rows where geoblock_id = "GEO_1QWC5EST6G90"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1QWC5EST6G90,BR,1 GEO_1QWC5EST6G90 BR 1
GEO_1QWC5EST6G90,DE,1 GEO_1QWC5EST6G90 DE 1
GEO_1QWC5EST6G90,ES,1 GEO_1QWC5EST6G90 ES 1
GEO_1QWC5EST6G90,FI,1 GEO_1QWC5EST6G90 FI 1
GEO_1QWC5EST6G90,FR,1 GEO_1QWC5EST6G90 FR 1
GEO_1QWC5EST6G90,HK,1 GEO_1QWC5EST6G90 HK 1
GEO_1QWC5EST6G90,IT,1 GEO_1QWC5EST6G90 IT 1
GEO_1QWC5EST6G90,JP,1 GEO_1QWC5EST6G90 JP 1
GEO_1QWC5EST6G90,MX,1 GEO_1QWC5EST6G90 MX 1
GEO_1QWC5EST6G90,MY,1 GEO_1QWC5EST6G90 MY 1
GEO_1QWC5EST6G90,NL,1 GEO_1QWC5EST6G90 NL 1
GEO_1QWC5EST6G90,PL,1 GEO_1QWC5EST6G90 PL 1
GEO_1QWC5EST6G90,PT,1 GEO_1QWC5EST6G90 PT 1
GEO_1QWC5EST6G90,SE,1 GEO_1QWC5EST6G90 SE 1
GEO_1QWC5EST6G90,TH,1 GEO_1QWC5EST6G90 TH 1
GEO_1QWC5EST6G90,TW,1 GEO_1QWC5EST6G90 TW 1
GEO_1QWC5EST6G90,WORLD,2 GEO_1QWC5EST6G90 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);