BookWalker

home / database

geoblock_territories

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

12 rows where geoblock_id = "GEO_1GSR46W5XAYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link geoblock_id territory type
GEO_1GSR46W5XAYG,AU,0 GEO_1GSR46W5XAYG AU 0
GEO_1GSR46W5XAYG,CA,0 GEO_1GSR46W5XAYG CA 0
GEO_1GSR46W5XAYG,GB,0 GEO_1GSR46W5XAYG GB 0
GEO_1GSR46W5XAYG,GU,0 GEO_1GSR46W5XAYG GU 0
GEO_1GSR46W5XAYG,IE,0 GEO_1GSR46W5XAYG IE 0
GEO_1GSR46W5XAYG,IM,0 GEO_1GSR46W5XAYG IM 0
GEO_1GSR46W5XAYG,JE,0 GEO_1GSR46W5XAYG JE 0
GEO_1GSR46W5XAYG,NZ,0 GEO_1GSR46W5XAYG NZ 0
GEO_1GSR46W5XAYG,PR,0 GEO_1GSR46W5XAYG PR 0
GEO_1GSR46W5XAYG,UM,0 GEO_1GSR46W5XAYG UM 0
GEO_1GSR46W5XAYG,US,0 GEO_1GSR46W5XAYG US 0
GEO_1GSR46W5XAYG,VI,0 GEO_1GSR46W5XAYG VI 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.599ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS