geoblock_territories

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

25 rows where geoblock_id = "GEO_1PDPG7Q49R30"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1PDPG7Q49R30,AU,1 GEO_1PDPG7Q49R30 AU 1
GEO_1PDPG7Q49R30,BR,1 GEO_1PDPG7Q49R30 BR 1
GEO_1PDPG7Q49R30,DE,1 GEO_1PDPG7Q49R30 DE 1
GEO_1PDPG7Q49R30,ES,1 GEO_1PDPG7Q49R30 ES 1
GEO_1PDPG7Q49R30,FI,1 GEO_1PDPG7Q49R30 FI 1
GEO_1PDPG7Q49R30,FR,1 GEO_1PDPG7Q49R30 FR 1
GEO_1PDPG7Q49R30,GB,1 GEO_1PDPG7Q49R30 GB 1
GEO_1PDPG7Q49R30,HK,1 GEO_1PDPG7Q49R30 HK 1
GEO_1PDPG7Q49R30,IE,1 GEO_1PDPG7Q49R30 IE 1
GEO_1PDPG7Q49R30,IN,1 GEO_1PDPG7Q49R30 IN 1
GEO_1PDPG7Q49R30,IT,1 GEO_1PDPG7Q49R30 IT 1
GEO_1PDPG7Q49R30,JP,1 GEO_1PDPG7Q49R30 JP 1
GEO_1PDPG7Q49R30,MX,1 GEO_1PDPG7Q49R30 MX 1
GEO_1PDPG7Q49R30,MY,1 GEO_1PDPG7Q49R30 MY 1
GEO_1PDPG7Q49R30,NL,1 GEO_1PDPG7Q49R30 NL 1
GEO_1PDPG7Q49R30,NZ,1 GEO_1PDPG7Q49R30 NZ 1
GEO_1PDPG7Q49R30,PK,1 GEO_1PDPG7Q49R30 PK 1
GEO_1PDPG7Q49R30,PL,1 GEO_1PDPG7Q49R30 PL 1
GEO_1PDPG7Q49R30,PT,1 GEO_1PDPG7Q49R30 PT 1
GEO_1PDPG7Q49R30,SE,1 GEO_1PDPG7Q49R30 SE 1
GEO_1PDPG7Q49R30,SG,1 GEO_1PDPG7Q49R30 SG 1
GEO_1PDPG7Q49R30,TH,1 GEO_1PDPG7Q49R30 TH 1
GEO_1PDPG7Q49R30,TW,1 GEO_1PDPG7Q49R30 TW 1
GEO_1PDPG7Q49R30,WORLD,2 GEO_1PDPG7Q49R30 WORLD 2
GEO_1PDPG7Q49R30,ZA,1 GEO_1PDPG7Q49R30 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);