geoblock_territories

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

26 rows where geoblock_id = "GEO_1P9DF0AHYE6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

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