August 2022 update

1. The updated database has monthly prices from over 400 supermarkets across six chains (all Shufersal stores, plus ~20 per chain for the other chains), from March 2022-August 2022. Before march there is a steady increase in the number of stores.
2. The current database has combined all the supermarket chains, which required adding two columns - 'ChainName' is the supermarket chain, and 'store_code' is a concatenation of the store_id and the beginning of the chain name, to solve the duplicate store_ids.
3. A new table was constructed to try and identify the manufacturers of each product, given the significant discrepancies in the retailers' reporting. This table ("manufacturer_finder") has identified the likely supplier of around half of the products in the database, and can be used to track specific suppliers (producers/importers).

This dataset was created to analyze changes in prices in the Israeli grocery retail market. It was created based on the files retailers are legally required to upload, available here: https://www.gov.il/he/departments/legalInfo/cpfta_prices_regulations

The data is not complete and downloads increased gradually. Beginning in May 2020 there are sporadic files for three specific Shufersal stores. Starting in November 2021 Downloads increased, ~20-50 stores downloaded at various times from Shufersal, and ~5-10 stores downloaded from a few other retailers.

Different table for each retailer. The table "snifim" specifies the names for stores for Shufersal (in the main table you can find store_id which can be joined to the names).

Description of columns in the Prices tables: Filename - original file name (without the xml extension) store_id - ID of the store upload_date - date of file download. Upload dates before 2020 - unclear what they are, probably of stores which shut down.
PriceUpdateDate - Last date of price change of the item. ItemCode - a unique ID of the item. ItemName - name. ManufacturerName - manufacturer. These data are messy. ManufactureCountry - country of production. ManufacturerItemDescription - similar to ItemName UnitQty - unit of measure Quantity - quantity. UnitOfMeasure - also unit of measure ItemPrice - price (NIS) UnitOfMeasurePrice - price divided by quantity AllowDiscount - boolean/dummy variable.

Supplementary data can be found here: https://docs.google.com/spreadsheets/d/1LYyCt3BTJ-QInja-4iN1vqZ91xV6TAwhywgJxecSOkM/edit?usp=sharing Including: - Analysis of suppliers - different labels associated with each supplier - A table linking Shufersal stores with their store_id - A table with details on how many price files (stores) were downloaded each date.

What are we looking for? - Price collusion - producers raising prices at the same time. - Which producers saw the greatest price increase? - Which is the most expensive store? - Which products are most promoted? You can go to the source and find "promo" tables. - Can you create a user-friendly tool to analyze these data for non-data scientists?

Monthly average retail prices for selected products, for Canada and provinces. Prices are presented for the current month and the previous four months. Prices are based on transaction data from Canadian retailers, and are presented in Canadian current dollars.

All white pre-packaged regular bread regardless of size. Includes frozen and fresh bread.

Fresh whole milk, fortified, sold per gallon regardless of packaging type. Includes organic and non-organic milk."

In Canada, one kilogram of ground beef cost an average 11.72 Canadian dollars in March 2024. Ground, otherwise known as minced, beef is often considered a cheaper and more versatile alternative to other cuts of beef. For example, prime rib roast cost an average 43.16 Canadian dollars per kilogram in February 2022, over three times as much as ground beef. Trends in Canadian meat consumption As of 2022, beef was the second most consumed meat in Canada, after chicken. Beef consumption has been decreasing though, at just about 25.7 kilograms per capita in 2022. This is compared to almost 40 kilograms per capita in1980. Just under half of Canadians stated that they consume meat daily when surveyed. With up and coming trends in eating behavior in Canada , such as vegetarianism and veganism, it is possible that consumption will decrease in the coming years and decades.