The Export Trade data files are at the HS 8 detail level. If you intend to aggregate at the HS 2 or 4 level, do not sum the quantity field as the quantities within these files are at the HS 8 detail level. If you intend to aggregate at the HS 6 level you must find the Unit of Measure assigned at the HS 8 level from the corresponding Metadata and convert to the Unit of Measure assigned on the HS 6 metadata. Canadian Trade Data 1 file per year STATISTICS CANADA INTERNATIONAL TRADE DIVISION CANADIAN EXPORT DATA 1988 - 2001 (Domestic and Re-exports) EXyyyymm.txt FIELD | SIZE| POSITION |TYPE| DESCRIPTION __________________________________________________________________________________________________ | | | | 1 | 4 | 1- 4 | AN | Year | | | | 2 | 1 | 5- 5 | AN | Export Indicator ('X') | | | | 3 | 8 | 6- 13 | AN | HS08 Classification code | | | | 4 | 2 | 14- 15 | AN | Filler ' ' | | | | 5 | 1 | 15- 15 | AN | Filler ' ' | | | | 6 | 3 | 16- 18 | AN | Country of Destination code | | | | 7 | 1 | 19- 19 | AN | Filler ' ' | | | | 8 | 1 | 20- 20 | AN | Filler ' ' | | | | 9 | 1 | 21- 21 | AN | Filler ' ' | | | | 10 | 2 | 22- 23 | AN | US State of Destination | | | | 11 | 1 | 24- 24 | AN | Filler ' ' | | | | 12 | 1 | 25- 25 | AN | Filler ' ' | | | | 13 | 2 | 26- 27 | AN | Province of Origin code | | | | 14 | 1 | 28- 28 | AN | Filler ' ' | | | | 15 | 1 | 29- 29 | AN | Re-Export Indicator 'Y' - Yes, re-exports ' ' - No, domestic | | | | 16 | 1 | 30- 30 | AN | Filler ' ' | | | | 17 | 2 | 31- 32 | AN | Month | | | | 18 | 13 | 33- 45 | N | Quantity '9(11)v99' | | | | 19 | 13 | 46- 58 | N | Value ($CDN) '9(13)' | | | | 20 | 1 | 59- 59 | AN | Filler ' ' | | | | 21 | 1 | 60- 60 | AN | Filler ' ' | | | | 22 | 1 | 61- 61 | AN | Filler ' ' | | | | 23 | 1 | 62- 62 | AN | Filler ' ' | | | | 24 | 1 | 63- 63 | AN | Filler ' ' | | | | 25 | 1 | 64- 64 | AN | Filler ' ' | | | | 26 | 1 | 65- 65 | AN | Filler ' ' | | | | 27 | 1 | 66- 66 | AN | Filler ' ' | | | | 28 | 1 | 67- 67 | AN | Filler ' ' | | | | 29 | 1 | 68- 68 | AN | Filler ' ' | | | | 30 | 1 | 69- 69 | AN | Filler ' ' | | | | 31 | 1 | 70- 70 | AN | Filler ' ' | | | | 32 | 1 | 71- 71 | AN | Filler ' ' | | | | 33 | 2 | 72- 73 | AN | Type Code '39'