geoblock_territories

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

18 rows where geoblock_id = "GEO_1GJFXJ5CVYNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link geoblock_id territory type
GEO_1GJFXJ5CVYNG,AU,0 GEO_1GJFXJ5CVYNG AU 0
GEO_1GJFXJ5CVYNG,CA,0 GEO_1GJFXJ5CVYNG CA 0
GEO_1GJFXJ5CVYNG,GB,0 GEO_1GJFXJ5CVYNG GB 0
GEO_1GJFXJ5CVYNG,GU,0 GEO_1GJFXJ5CVYNG GU 0
GEO_1GJFXJ5CVYNG,IE,0 GEO_1GJFXJ5CVYNG IE 0
GEO_1GJFXJ5CVYNG,IM,0 GEO_1GJFXJ5CVYNG IM 0
GEO_1GJFXJ5CVYNG,IN,0 GEO_1GJFXJ5CVYNG IN 0
GEO_1GJFXJ5CVYNG,JE,0 GEO_1GJFXJ5CVYNG JE 0
GEO_1GJFXJ5CVYNG,NZ,0 GEO_1GJFXJ5CVYNG NZ 0
GEO_1GJFXJ5CVYNG,PH,0 GEO_1GJFXJ5CVYNG PH 0
GEO_1GJFXJ5CVYNG,PK,0 GEO_1GJFXJ5CVYNG PK 0
GEO_1GJFXJ5CVYNG,PR,0 GEO_1GJFXJ5CVYNG PR 0
GEO_1GJFXJ5CVYNG,SA,0 GEO_1GJFXJ5CVYNG SA 0
GEO_1GJFXJ5CVYNG,SG,0 GEO_1GJFXJ5CVYNG SG 0
GEO_1GJFXJ5CVYNG,UM,0 GEO_1GJFXJ5CVYNG UM 0
GEO_1GJFXJ5CVYNG,US,0 GEO_1GJFXJ5CVYNG US 0
GEO_1GJFXJ5CVYNG,VI,0 GEO_1GJFXJ5CVYNG VI 0
GEO_1GJFXJ5CVYNG,ZA,0 GEO_1GJFXJ5CVYNG 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);