geoblock_territories

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

28 rows where geoblock_id = "GEO_1K03XHYJRK80"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

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