BookWalker

home / database

geoblock_territories

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

17 rows where geoblock_id = "GEO_1JG84XMCBM8G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link geoblock_id territory type
GEO_1JG84XMCBM8G,AU,0 GEO_1JG84XMCBM8G AU 0
GEO_1JG84XMCBM8G,CA,0 GEO_1JG84XMCBM8G CA 0
GEO_1JG84XMCBM8G,DE,0 GEO_1JG84XMCBM8G DE 0
GEO_1JG84XMCBM8G,ES,0 GEO_1JG84XMCBM8G ES 0
GEO_1JG84XMCBM8G,FI,0 GEO_1JG84XMCBM8G FI 0
GEO_1JG84XMCBM8G,FR,0 GEO_1JG84XMCBM8G FR 0
GEO_1JG84XMCBM8G,GB,0 GEO_1JG84XMCBM8G GB 0
GEO_1JG84XMCBM8G,IE,0 GEO_1JG84XMCBM8G IE 0
GEO_1JG84XMCBM8G,IT,0 GEO_1JG84XMCBM8G IT 0
GEO_1JG84XMCBM8G,NL,0 GEO_1JG84XMCBM8G NL 0
GEO_1JG84XMCBM8G,NZ,0 GEO_1JG84XMCBM8G NZ 0
GEO_1JG84XMCBM8G,PH,0 GEO_1JG84XMCBM8G PH 0
GEO_1JG84XMCBM8G,PL,0 GEO_1JG84XMCBM8G PL 0
GEO_1JG84XMCBM8G,PT,0 GEO_1JG84XMCBM8G PT 0
GEO_1JG84XMCBM8G,SE,0 GEO_1JG84XMCBM8G SE 0
GEO_1JG84XMCBM8G,US,0 GEO_1JG84XMCBM8G US 0
GEO_1JG84XMCBM8G,WORLD,2 GEO_1JG84XMCBM8G WORLD 2

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.08ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS