geoblock_territories

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

26 rows where geoblock_id = "GEO_1KHA99CW3V20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

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