market

9 rows where retailer_id = 3

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ retailer_id name city zip external_id
18 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
19 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
20 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
21 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
22 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
23 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
35 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
37 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      
40 ALDI Sued 3 ALDI Süd – Sortiment/Aktion      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE market (
  id INTEGER PRIMARY KEY,
  retailer_id INTEGER NOT NULL REFERENCES retailer(id),
  name TEXT NOT NULL,
  city TEXT,
  zip TEXT,
  external_id TEXT,
  UNIQUE(retailer_id, name, zip)
);