BookWalker

home / database

geoblock_territories

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

80 rows where geoblock_id = "GEO_1GPSER10N8P0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link geoblock_id territory type
GEO_1GPSER10N8P0,AR,0 GEO_1GPSER10N8P0 AR 0
GEO_1GPSER10N8P0,AS,0 GEO_1GPSER10N8P0 AS 0
GEO_1GPSER10N8P0,AT,0 GEO_1GPSER10N8P0 AT 0
GEO_1GPSER10N8P0,AU,0 GEO_1GPSER10N8P0 AU 0
GEO_1GPSER10N8P0,BE,0 GEO_1GPSER10N8P0 BE 0
GEO_1GPSER10N8P0,BG,0 GEO_1GPSER10N8P0 BG 0
GEO_1GPSER10N8P0,BO,0 GEO_1GPSER10N8P0 BO 0
GEO_1GPSER10N8P0,BR,0 GEO_1GPSER10N8P0 BR 0
GEO_1GPSER10N8P0,BZ,0 GEO_1GPSER10N8P0 BZ 0
GEO_1GPSER10N8P0,CA,0 GEO_1GPSER10N8P0 CA 0
GEO_1GPSER10N8P0,CH,0 GEO_1GPSER10N8P0 CH 0
GEO_1GPSER10N8P0,CL,0 GEO_1GPSER10N8P0 CL 0
GEO_1GPSER10N8P0,CO,0 GEO_1GPSER10N8P0 CO 0
GEO_1GPSER10N8P0,CR,0 GEO_1GPSER10N8P0 CR 0
GEO_1GPSER10N8P0,CY,0 GEO_1GPSER10N8P0 CY 0
GEO_1GPSER10N8P0,CZ,0 GEO_1GPSER10N8P0 CZ 0
GEO_1GPSER10N8P0,DE,0 GEO_1GPSER10N8P0 DE 0
GEO_1GPSER10N8P0,DK,0 GEO_1GPSER10N8P0 DK 0
GEO_1GPSER10N8P0,DO,0 GEO_1GPSER10N8P0 DO 0
GEO_1GPSER10N8P0,EC,0 GEO_1GPSER10N8P0 EC 0
GEO_1GPSER10N8P0,EE,0 GEO_1GPSER10N8P0 EE 0
GEO_1GPSER10N8P0,ES,0 GEO_1GPSER10N8P0 ES 0
GEO_1GPSER10N8P0,FI,0 GEO_1GPSER10N8P0 FI 0
GEO_1GPSER10N8P0,FR,0 GEO_1GPSER10N8P0 FR 0
GEO_1GPSER10N8P0,GB,0 GEO_1GPSER10N8P0 GB 0
GEO_1GPSER10N8P0,GG,0 GEO_1GPSER10N8P0 GG 0
GEO_1GPSER10N8P0,GR,0 GEO_1GPSER10N8P0 GR 0
GEO_1GPSER10N8P0,GT,0 GEO_1GPSER10N8P0 GT 0
GEO_1GPSER10N8P0,GU,0 GEO_1GPSER10N8P0 GU 0
GEO_1GPSER10N8P0,GY,0 GEO_1GPSER10N8P0 GY 0
GEO_1GPSER10N8P0,HK,0 GEO_1GPSER10N8P0 HK 0
GEO_1GPSER10N8P0,HN,0 GEO_1GPSER10N8P0 HN 0
GEO_1GPSER10N8P0,HU,0 GEO_1GPSER10N8P0 HU 0
GEO_1GPSER10N8P0,ID,0 GEO_1GPSER10N8P0 ID 0
GEO_1GPSER10N8P0,IE,0 GEO_1GPSER10N8P0 IE 0
GEO_1GPSER10N8P0,IL,0 GEO_1GPSER10N8P0 IL 0
GEO_1GPSER10N8P0,IM,0 GEO_1GPSER10N8P0 IM 0
GEO_1GPSER10N8P0,IN,0 GEO_1GPSER10N8P0 IN 0
GEO_1GPSER10N8P0,IS,0 GEO_1GPSER10N8P0 IS 0
GEO_1GPSER10N8P0,IT,0 GEO_1GPSER10N8P0 IT 0
GEO_1GPSER10N8P0,JE,0 GEO_1GPSER10N8P0 JE 0
GEO_1GPSER10N8P0,KN,0 GEO_1GPSER10N8P0 KN 0
GEO_1GPSER10N8P0,KR,0 GEO_1GPSER10N8P0 KR 0
GEO_1GPSER10N8P0,KW,0 GEO_1GPSER10N8P0 KW 0
GEO_1GPSER10N8P0,LI,0 GEO_1GPSER10N8P0 LI 0
GEO_1GPSER10N8P0,LT,0 GEO_1GPSER10N8P0 LT 0
GEO_1GPSER10N8P0,LU,0 GEO_1GPSER10N8P0 LU 0
GEO_1GPSER10N8P0,LV,0 GEO_1GPSER10N8P0 LV 0
GEO_1GPSER10N8P0,MH,0 GEO_1GPSER10N8P0 MH 0
GEO_1GPSER10N8P0,MP,0 GEO_1GPSER10N8P0 MP 0
GEO_1GPSER10N8P0,MT,0 GEO_1GPSER10N8P0 MT 0
GEO_1GPSER10N8P0,MX,0 GEO_1GPSER10N8P0 MX 0
GEO_1GPSER10N8P0,MY,0 GEO_1GPSER10N8P0 MY 0
GEO_1GPSER10N8P0,NG,0 GEO_1GPSER10N8P0 NG 0
GEO_1GPSER10N8P0,NI,0 GEO_1GPSER10N8P0 NI 0
GEO_1GPSER10N8P0,NL,0 GEO_1GPSER10N8P0 NL 0
GEO_1GPSER10N8P0,NO,0 GEO_1GPSER10N8P0 NO 0
GEO_1GPSER10N8P0,NZ,0 GEO_1GPSER10N8P0 NZ 0
GEO_1GPSER10N8P0,PA,0 GEO_1GPSER10N8P0 PA 0
GEO_1GPSER10N8P0,PE,0 GEO_1GPSER10N8P0 PE 0
GEO_1GPSER10N8P0,PH,0 GEO_1GPSER10N8P0 PH 0
GEO_1GPSER10N8P0,PK,0 GEO_1GPSER10N8P0 PK 0
GEO_1GPSER10N8P0,PL,0 GEO_1GPSER10N8P0 PL 0
GEO_1GPSER10N8P0,PR,0 GEO_1GPSER10N8P0 PR 0
GEO_1GPSER10N8P0,PT,0 GEO_1GPSER10N8P0 PT 0
GEO_1GPSER10N8P0,PY,0 GEO_1GPSER10N8P0 PY 0
GEO_1GPSER10N8P0,RO,0 GEO_1GPSER10N8P0 RO 0
GEO_1GPSER10N8P0,SE,0 GEO_1GPSER10N8P0 SE 0
GEO_1GPSER10N8P0,SG,0 GEO_1GPSER10N8P0 SG 0
GEO_1GPSER10N8P0,SI,0 GEO_1GPSER10N8P0 SI 0
GEO_1GPSER10N8P0,SK,0 GEO_1GPSER10N8P0 SK 0
GEO_1GPSER10N8P0,SR,0 GEO_1GPSER10N8P0 SR 0
GEO_1GPSER10N8P0,SV,0 GEO_1GPSER10N8P0 SV 0
GEO_1GPSER10N8P0,TH,0 GEO_1GPSER10N8P0 TH 0
GEO_1GPSER10N8P0,TW,0 GEO_1GPSER10N8P0 TW 0
GEO_1GPSER10N8P0,UM,0 GEO_1GPSER10N8P0 UM 0
GEO_1GPSER10N8P0,US,0 GEO_1GPSER10N8P0 US 0
GEO_1GPSER10N8P0,UY,0 GEO_1GPSER10N8P0 UY 0
GEO_1GPSER10N8P0,VI,0 GEO_1GPSER10N8P0 VI 0
GEO_1GPSER10N8P0,ZA,0 GEO_1GPSER10N8P0 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);
Powered by Datasette · Queries took 6.174ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS