geoblock_territories

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

15 rows where geoblock_id = "GEO_1K3P9BJYD9FG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1K3P9BJYD9FG,AU,0 GEO_1K3P9BJYD9FG AU 0
GEO_1K3P9BJYD9FG,CA,0 GEO_1K3P9BJYD9FG CA 0
GEO_1K3P9BJYD9FG,FI,0 GEO_1K3P9BJYD9FG FI 0
GEO_1K3P9BJYD9FG,GB,0 GEO_1K3P9BJYD9FG GB 0
GEO_1K3P9BJYD9FG,IE,0 GEO_1K3P9BJYD9FG IE 0
GEO_1K3P9BJYD9FG,IN,0 GEO_1K3P9BJYD9FG IN 0
GEO_1K3P9BJYD9FG,JP,0 GEO_1K3P9BJYD9FG JP 0
GEO_1K3P9BJYD9FG,NL,0 GEO_1K3P9BJYD9FG NL 0
GEO_1K3P9BJYD9FG,NZ,0 GEO_1K3P9BJYD9FG NZ 0
GEO_1K3P9BJYD9FG,PH,0 GEO_1K3P9BJYD9FG PH 0
GEO_1K3P9BJYD9FG,SE,0 GEO_1K3P9BJYD9FG SE 0
GEO_1K3P9BJYD9FG,SG,0 GEO_1K3P9BJYD9FG SG 0
GEO_1K3P9BJYD9FG,US,0 GEO_1K3P9BJYD9FG US 0
GEO_1K3P9BJYD9FG,WORLD,2 GEO_1K3P9BJYD9FG WORLD 2
GEO_1K3P9BJYD9FG,ZA,0 GEO_1K3P9BJYD9FG 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);