Local Market Price Comparison Data
This dataset provides weekly comparative pricing for goods across local markets, including detailed market and product attributes, price statistics, and contextual information. It enables supply chain professionals, retailers, and analysts to track price trends, benchmark across locations, and optimize pricing strategies for maximum profitability and competitiveness.
Sample rows
preview · 8 of 207 rows · all 20 columns| market_idstring | product_categorystring | price_sample_sizeinteger | market_statestring | market_namestring | market_street_addressstring | market_citystring | market_postal_codestring | market_countrystring | week_start_datedate | week_end_datedate | product_idstring | product_namestring | unit_of_measurestring | average_pricefloat | min_pricefloat | max_pricefloat | currencystring | price_sourcestring | price_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MKT001 | Produce | 18 | CA | San Francisco Farmers Market | 101 Market St | San Francisco | 94105 | USA | 2024-01-02 | 2024-01-08 | PRD001 | Organic Apples | kg | 4.15 | 4 | 4.25 | USD | market survey | blank |
| MKT002 | Dairy | 23 | ON | Toronto St. Lawrence Market | 93 Front St E | Toronto | M5E1C3 | Canada | 2024-01-09 | 2024-01-15 | PRD002 | Whole Milk | liter | 2.55 | 2.5 | 2.6 | CAD | market survey | Winter demand spike |
| MKT003 | Seafood | 14 | NSW | Sydney Fish Market | Bank St | Sydney | 2009 | Australia | 2024-01-16 | 2024-01-22 | PRD003 | King Prawns | kg | 22.5 | 22.25 | 22.8 | AUD | market survey | Peak season |
| MKT004 | Produce | 7 | blank | Brixton Village Market | Coldharbour Ln | London | SW9 8PS | UK | 2024-01-23 | 2024-01-29 | PRD004 | Fresh Spinach | kg | 3.3 | 3.1 | 3.35 | GBP | retailer report | Organic batch |
| MKT005 | Bakery | 30 | blank | Paris Marché Bastille | Boulevard Richard Lenoir | Paris | 75011 | France | 2024-01-30 | 2024-02-05 | PRD005 | Baguette | piece | 1.05 | 0.95 | 1.1 | EUR | market survey | blank |
| MKT006 | Oils | 15 | MH | Mumbai Crawford Market | Dr D N Road | Mumbai | 400001 | India | 2024-02-06 | 2024-02-12 | PRD006 | Sunflower Oil | liter | 185 | 182.5 | 187.5 | INR | market survey | Festival week |
| MKT007 | Produce | 20 | WC | Cape Town Neighbourgoods | Old Biscuit Mill | Cape Town | 7925 | South Africa | 2024-02-13 | 2024-02-19 | PRD007 | Grapes | kg | 2.8 | 2.6 | 2.85 | ZAR | market survey | Harvest peak |
| MKT008 | Seafood | 11 | blank | Lisbon Mercado da Ribeira | Avenida 24 de Julho | Lisbon | 1200-479 | Portugal | 2024-02-20 | 2024-02-26 | PRD008 | Sardines | kg | 8.6 | 8.5 | 8.75 | EUR | retailer report | Bulk purchase rates |
| MKT009 | Dairy | 5 | blank | Dublin Temple Bar Market | Meeting House Sq | Dublin | D02 XF86 | Ireland | 2024-02-27 | 2024-03-04 | PRD009 | Cheddar Cheese | kg | 9.25 | 9 | 9.5 | EUR | retailer report | Irish specialty |
| MKT010 | Bakery | 16 | blank | Berlin Markthalle Neun | blank | Berlin | 10997 | Germany | 2024-03-05 | 2024-03-11 | PRD010 | Brown Bread | piece | 1.3 | 1.25 | 1.4 | EUR | market survey | blank |
| MKT011 | Produce | 12 | NY | New York Union Square | 17 Union Sq W | New York | 10003 | USA | 2024-03-12 | 2024-03-18 | PRD011 | Baby Carrots | kg | 2.3 | 2.25 | 2.4 | USD | market survey | blank |
| MKT012 | Seafood | 8 | AUK | Auckland Fish Market | 22 Jellicoe St | Auckland | 1010 | New Zealand | 2024-03-19 | 2024-03-25 | PRD012 | Green Mussels | dozen | 10.45 | 10.4 | 10.5 | NZD | market survey | Low catch week |
| MKT013 | Grains | 17 | WB | Kolkata New Market | Lindsay St | Kolkata | 700087 | India | 2024-03-26 | 2024-04-01 | PRD013 | Basmati Rice | kg | 115 | 114.5 | 115.75 | INR | market survey | Bulk purchase |
| MKT014 | Produce | 21 | GP | Johannesburg Rosebank | Oxford Rd | Johannesburg | 2196 | South Africa | 2024-04-02 | 2024-04-08 | PRD014 | Fresh Oranges | kg | 3.65 | 3.5 | 3.75 | ZAR | market survey | Harvest surplus |
| MKT015 | Dairy | 3 | blank | London Borough Market | blank | London | SE1 9AL | UK | 2024-04-09 | 2024-04-15 | PRD015 | Eggs | dozen | 2.1 | 2.05 | 2.15 | GBP | retailer report | Organic eggs |
| MKT016 | Produce | 9 | CA | Los Angeles Grand Central | 317 S Broadway | Los Angeles | 90013 | USA | 2024-04-16 | 2024-04-22 | PRD016 | Strawberries | kg | 5.95 | 5.9 | 6.1 | USD | market survey | blank |
| MKT017 | Produce | 22 | WC | Cape Town Oranjezicht | Granger Bay Blvd | Cape Town | 8005 | South Africa | 2024-04-23 | 2024-04-29 | PRD017 | Avocado | piece | 1.7 | 1.65 | 1.75 | ZAR | market survey | Season start |
| MKT018 | Beverages | 35 | SH | Shanghai Yuyuan Market | Fuyou Rd | Shanghai | 200010 | China | 2024-04-30 | 2024-05-06 | PRD018 | Green Tea | g | 0.6 | 0.55 | 0.65 | CNY | retailer report | blank |
| MKT019 | Oils | 13 | LA | Lagos Balogun Market | Broad St | Lagos | 100001 | Nigeria | 2024-05-07 | 2024-05-13 | PRD019 | Palm Oil | liter | 250 | 248 | 252 | NGN | market survey | Festival week |
| MKT020 | Produce | 20 | BC | Vancouver Granville Island | 1661 Duranleau St | Vancouver | V6H3S3 | Canada | 2024-05-14 | 2024-05-20 | PRD020 | Blueberries | kg | 7.2 | 7 | 7.35 | CAD | market survey | blank |
What the 207 rows show
from the 207-row sampleBakery (product category) stands out: mean price_
- 14median price_
sample_ size - 2price sources
- 5unit of measures
- 23currencies
- 30market countries
- 4.3median average_
price
Median 14, from 1 to 40.
- string 14
- integer 1
- float 3
- date 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
market_id | string | Unique identifier for the local market | MKT001 |
market_name | string | Name of the local market | Sydney Fish Market |
market_street_address | string | Street address of the local marketoptional | 101 Market St |
market_city | string | City where the market is located | San Francisco |
market_state | string | State or region of the marketoptional | CA |
market_postal_code | string | Postal code of the market locationoptional | 94105 |
market_country | string | Country where the market is located | USA |
product_id | string | Unique identifier for the product or good | PRD001 |
product_name | string | Name of the product or good | Organic Apples |
product_category | string | Category of the product (e.g., produce, dairy, meat)8 categories · optional | Produce |
unit_of_measure | string | Unit in which the product is priced (e.g., kg, lb, piece)5 measures | kg |
currency | string | Currency code used for pricing (ISO 4217 format) | USD |
price_source | string | Source of the price data (e.g., market survey, retailer report)2 sources · optional | market survey |
price_notes | string | Additional notes or comments about the price dataoptional | Winter demand spike |
| Numbers 4 columns | |||
average_price | float | Average price of the product for the week in local currency0 or more | 4.15 |
min_price | float | Minimum recorded price of the product for the week0 or more · optional | 4 |
max_price | float | Maximum recorded price of the product for the week0 or more · optional | 4.25 |
price_sample_size | integer | Number of price samples collected for the product in the week1 or more · optional | 18 |
| Dates and times 2 columns | |||
week_start_date | date | Start date of the week for which prices are recorded | 2024-01-02 |
week_end_date | date | End date of the week for which prices are recorded | 2024-01-08 |
Use it for
A logistics dashboard
Price_
sample_ size by product_ category and a breakdown of market_ state. Excel, Power BI or Tableau. Why do the 24 Bakery rows have a mean price_
sample_ size of 29.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Markets207MKT00118ProduceMKT00223DairyMKT00314Seafood
A software demo
Believable markets with market_
name, market_ street_ address and market_ city to fill a screen in front of a buyer.
blueprint · local-market-price-comparison-data
Behind this dataset
Same schema. As many rows as you need.
These 207 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Include product category
- Record vendor type
- Track weekly price changes
- Flag seasonal price trends
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- local-market-price-comparison-data