geoblock_territories

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

26 rows where geoblock_id = "GEO_1KFC45PBKZD0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1KFC45PBKZD0,AU,0 GEO_1KFC45PBKZD0 AU 0
GEO_1KFC45PBKZD0,BR,0 GEO_1KFC45PBKZD0 BR 0
GEO_1KFC45PBKZD0,CA,0 GEO_1KFC45PBKZD0 CA 0
GEO_1KFC45PBKZD0,DE,0 GEO_1KFC45PBKZD0 DE 0
GEO_1KFC45PBKZD0,ES,0 GEO_1KFC45PBKZD0 ES 0
GEO_1KFC45PBKZD0,FI,0 GEO_1KFC45PBKZD0 FI 0
GEO_1KFC45PBKZD0,GB,0 GEO_1KFC45PBKZD0 GB 0
GEO_1KFC45PBKZD0,IE,0 GEO_1KFC45PBKZD0 IE 0
GEO_1KFC45PBKZD0,IN,0 GEO_1KFC45PBKZD0 IN 0
GEO_1KFC45PBKZD0,IT,0 GEO_1KFC45PBKZD0 IT 0
GEO_1KFC45PBKZD0,JP,0 GEO_1KFC45PBKZD0 JP 0
GEO_1KFC45PBKZD0,MX,0 GEO_1KFC45PBKZD0 MX 0
GEO_1KFC45PBKZD0,MY,0 GEO_1KFC45PBKZD0 MY 0
GEO_1KFC45PBKZD0,NL,0 GEO_1KFC45PBKZD0 NL 0
GEO_1KFC45PBKZD0,NZ,0 GEO_1KFC45PBKZD0 NZ 0
GEO_1KFC45PBKZD0,PH,0 GEO_1KFC45PBKZD0 PH 0
GEO_1KFC45PBKZD0,PK,0 GEO_1KFC45PBKZD0 PK 0
GEO_1KFC45PBKZD0,PL,0 GEO_1KFC45PBKZD0 PL 0
GEO_1KFC45PBKZD0,PT,0 GEO_1KFC45PBKZD0 PT 0
GEO_1KFC45PBKZD0,SE,0 GEO_1KFC45PBKZD0 SE 0
GEO_1KFC45PBKZD0,SG,0 GEO_1KFC45PBKZD0 SG 0
GEO_1KFC45PBKZD0,TH,0 GEO_1KFC45PBKZD0 TH 0
GEO_1KFC45PBKZD0,TW,0 GEO_1KFC45PBKZD0 TW 0
GEO_1KFC45PBKZD0,US,0 GEO_1KFC45PBKZD0 US 0
GEO_1KFC45PBKZD0,WORLD,2 GEO_1KFC45PBKZD0 WORLD 2
GEO_1KFC45PBKZD0,ZA,0 GEO_1KFC45PBKZD0 ZA 0

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