Egg prices raw data file structure and explanation

Egg prices raw data file - Report 040

Raw data file structure: 1992010409F9AX11901280

  • 19920104 = Date (format YYYYMMDD)
  • 09 = Provincial code
  • F = Source category
  • 9 = City or Province
  • AX = Grade
  • 1190 = Low range of the price
  • 1280 = High range of the price

Date

The date is in the format YYYYMMDD. This date is always a Saturday. The prices included in these records are the prices which were in effect during the seven days of data up to and including the date of the record (ie. Sunday to Saturday).

Provincial code

  • 00 = Newfoundland and Labrador
  • 01 = Prince Edward Island
  • 02 = Nova Scotia
  • 03 = New Brunswick
  • 04 = Quebec
  • 05 = Ontario
  • 06 = Manitoba
  • 07 = Saskatchewan
  • 08 = Alberta
  • 09 = British Columbia
  • 0A = Northwest Territories

Source category

This is the code which is used to determine which level of pricing is being quoted in the data file.

  • F = Price paid to producers
  • R = Low/High wholesale price paid by retailers
  • M = Weighted wholesale price paid by retailers
  • C = Low/High retail price paid by consumers
  • W = Weighted retail price paid by consumers

City or Province

  • V = Vancouver
  • E = Edmonton
  • C = Calgary
  • S = Saskatoon
  • R = Regina
  • W = Winnipeg
  • T = Toronto
  • L = London
  • O = Ottawa
  • M = Montreal
  • Q = Quebec City
  • F = Fredericton
  • K = Kentville
  • H = Charlottetown
  • J = St-John's



  • 0 = Newfoundland and Labrador
  • 1 = Prince Edward Island
  • 2 = Nova Scotia
  • 3 = New Brunswick
  • 4 = Quebec
  • 5 = Ontario
  • 6 = Manitoba
  • 7 = Saskatchewan
  • 8 = Alberta
  • 9 = British Columbia
  • A = Northwest Territories

Grade

  • AJ = Grade "A" jumbo
  • AX = Grade "A" extra large
  • AL = Grade "A" large
  • AM = Grade "A" medium
  • AS = Grade "A" small
  • AP = Grade "A" peewee
  • B = Grade "B"
  • C = Grade "C"

Price Range

There are only two values for the price range - the low price and the high price - that determine the range. The price in the example above shows a low range of 1190 and a high range of 1280. This can be interpreted as a low price of 1.19 dollars per dozen and a high price of 1.28 dollars per dozen.

A weighted price can be viewed by using the proper Source category i.e. M or W. In these instances, the prices will be the same in both columns.

If you have any questions or require additional information, please send an e-mail to aafc.poultry-volaille.aac@agr.gc.ca

Our service standards

Service standards play a vital role in our market information program’s commitment to planning, reporting and performance management. They clearly define the level of service that clients can expect under normal circumstances.

View the Service standards for poultry reports.