home / prices

product_market

4 rows where market_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: url

id ▼ product_id market_id url
1 frosta-butter-chicken-indian-style-500g 1 REWE Markt Bremen 1 https://www.rewe.de/produkte/frosta-butter-chicken-indian-style-500g/8995995
2 coca-cola-12x1l 2 REWE Markt Bremen 1 https://www.rewe.de/produkte/coca-cola-12x1l/8002614
3 kerrygold-original-irische-butter-250g/ 3 REWE Markt Bremen 1 https://www.rewe.de/produkte/kerrygold-original-irische-butter-250g/4529316
7 kerrygold-original-irische-butter-250g 51 REWE Markt Bremen 1 https://www.rewe.de/produkte/kerrygold-original-irische-butter-250g/4529316

Advanced export

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

CSV options:

CREATE TABLE product_market (
  id INTEGER PRIMARY KEY,
  product_id INTEGER NOT NULL REFERENCES product(id),
  market_id INTEGER NOT NULL REFERENCES market(id),
  url TEXT NOT NULL,
  UNIQUE(product_id, market_id)
);
Powered by Datasette · Queries took 7.004ms