Jon Haveman's

These pages are the brainchild of Jon Haveman. If you find these pages useful, we would appreciate knowing who you are. These pages would also benefit from any concordances or data that you would be willing to make publicly available. If you have found these pages useful, or have something to contribute, or have any requests, please e-mail Raymond Robertson. Thanks in advance for your time, interest, and data!

---

1. Industry Concordances A. From ISIC  B. From SITC C. From usSIC D. From cSIC E. From HS F. From TSUSA G. From NACE H. From NAICS I. From PRODCOM	2. Other Useful Mappings 3. Acronyms - defined 4. Classifications: Verbal descriptions 5. Other Places to Find Concordances

---

Industry Concordances

From ISIC:

• 3 digit ISIC (rev 2) to 2 digit SITC (rev. 2) (1.9kb)
• Table 1.6. Concordance between the 3-digit ISIC, Revision 2, and the 2-Digit SITC, Revision 2
• Source: Maskus, Keith E [1989]:"Comparing International Trade Data and Poduct and National Characteristics Data for the Analysis of Trade Models", pp.42, in: Hooper and Richardson, International Economic Transactions, Vol 55, The University of Chicago Press.
• An excel(v4.0) spreadsheet is also available for concording the data.
• Enter two-digit SITC exports in column A, and two digit SITC imports in column B. The spreadsheet will calculate three digit ISIC exports, imports and net exports for you.

From SITC:

• 4 digit SITC (rev 2) to 4 digit usSIC (1977)
• Courtesy of Pamela Lowry (Illinois Wesleyan University)
• C-program for doing the converting, and a test file.

• 5 digit SITC (rev 2) to ISIC (rev. 2; industry 3----)
• Courtesy of the OECD
• Manufacturing ISIC industries only.

• 5 digit SITC (rev 3) to SIC80 (UK)
• Courtesy of Dr. Robert J.R. Elliott, School of Economics – University of Manchester
• Dr. Elliot also provided an explanation of how the concordance is constructed.

From usSIC:

• 4-digit 1987 usSIC to 1997 NAICS
• Source: U.S. Census Bureau
• Format: Column 1 is usSIC, column 2 is NAICS
• Note that some usSIC codes map to more than one NAICS code. In addition, more than one usSIC code may map to a single NAICS code.

• 4-digit 1987 usSIC to 2002 NAICS
• Source: U.S. Census Bureau
• Format: Excel spreadsheet

• 4 digit usSIC (1972) to 4 digit usSIC (1987) and back - for Manufacturing (2000-3999)
• Courtesy of Bartelsman, Becker and Gray
• This file is from www.nber.org (which also provides the Manufacturing Productivity Database)

• 4 digit usSIC (1977) to 4 digit SITC (rev 2)
• Courtesy of Pamela Lowery (Illinois Weslayan University)
• C-program for doing the converting, and a test file.

• 4 digit usSIC (1987) to 4 digit ISIC (rev 3)
• Courtesy of Statistics Canada: Publication "International Concordance..."

• 4 digit usSIC (1987) to 3 digit HS
• Source: derived from the Census Bureau mapping form 10HS -> 5SIC87
• Notes: Column (1) SIC code......subsequent columns include the set of HS codes into which the SIC code is mapped. A weighting scheme is not provided.

• 5 digit usSIC (1987) to HS
• -- to 4 digit HS
• -- to 3 digit HS
• Source: derived from the Census Bureau mapping form 10HS -> 5SIC87
• Notes: Column (1) SIC code......subsequent columns include the set of HS codes into which the SIC code is mapped. A weighting scheme is not provided.

• 4 digit usSIC (1972) to 3 digit CIC (pre-1983) .

• 4 digit usSIC (1972) to 3 digit CIC (1983+).

• 4 digit usSIC (1987) to 3 digit CIC (pre-1983).

• 4 digit usSIC (1987) to 3 digit CIC (1983+)
• Manufacturing Industries only (2000-3999)

From cSIC:

• 4-digit 1980 cSIC to 1997 NAICS
• Source: Statistics Canada
• Format: Column 1 is cSIC, column 2 is NAICS
• Note that some cSIC codes map to more than one NAICS code. In addition, more than one cSIC code may map to a single NAICS code.

• 4 digit cSIC (1980) to 4 digit ISIC (rev 3)
• Courtesy of Statistics Canada: Publication "International Concordance..."

From HS:

• From HS to HS (10 digit):
• These files map codes that are present in one year and not the next into some other code for the second year.
• Format (10a,1x,50a,5x,10a,1x,50a) (YR1Code, YR1Desc, YR2Code, YR2Desc)
• 1996 to 1997

6digit HS to ISIC rev.2 
Thanks to Cristina Gamboa (Fedesarrollo). The original source is the CDROM "A dataset on trade and production 1976-99" that comes along with the book edited by B.Hoekman, A. Mattoo and P. English, Development, Trade and the WTO: a Handbook.

• 10 digit HS to 5 digit usSIC (1987) (453k)
• From the Census Bureau
• 10 digit HS to 4 digit usMSIC (1987) (292k)
• From the NBER Trade Data CD 1.
• 10 digit HS to 5 digit SITC rev.2 (311k)
• From the NBER Trade Data CD 1.
• 10 digit HS to 5 digit SITC rev.3 (311k)
• From the NBER Trade Data CD 1.

• From 10 digit HS.....

.....to 5 digit usSIC (1987) o 1993 HS Codes (264k) o 1994 HS Codes (272k) o 1995 HS Codes (283k) o 1996 HS Codes (287k) o 1997 HS Codes (295k) o From the Census Bureau

to 5 digit SITC (rev 3) o 1993 HS Codes (264k) o 1994 HS Codes (272k) o 1995 HS Codes (283k) o 1996 HS Codes (287k) o 1997 HS Codes (295k) o From the Census Bureau

to 5 digit END USE o 1993 HS Codes (264k) o 1994 HS Codes (272k) o 1995 HS Codes (283k) o 1996 HS Codes (287k) o 1997 HS Codes (295k) o From the Census Bureau

From TSUSA:

• 7 digit TSUSA to 8 digit usMSIC (1972) (442k)
• From the NBER Trade Data CD 1.

• 7 digit TSUSA to 8 digit usMSIC (1987) (442k)
• From the NBER Trade Data CD 1.

• 7 digit TSUSA to 5 digit SITC Rev. 2 (364k)
• From the NBER Trade Data CD 1.

• 7 digit TSUSA to 3 digit SITC Rev. 3 (312k)
• From the NBER Trade Data CD 1.

From NACE:

• 4 digit NACE (rev 1) to 4 digit ISIC (rev 3) according to the european interpretation of the ISIC codes.
• Courtesy of Statistics Canada: Publication "International Concordance..."
• 4 digit NACE (rev 1) to 4 digit ISIC (rev 3) according to the Canada-US interpretation of the ISIC codes.
• Courtesy of Statistics Canada: Publication "International Concordance..."
• 4 digit NACE (rev 1.1) to 4 digit ISIC – FIFO OST web site
• Includes verbal descriptions
• Also available in German
• 3 digit NACE to NIMEXE
• Courtesy of Alasdair Smith and Eurostat

From NAICS:

• 1997 NAICS to 4-digit 1987 usSIC
• Source: U.S. Census Bureau
• Format: Column 1 is NAICS, column 2 is usSIC
• Note that some NAICS codes map to more than one usSIC code. In addition, more than one NAICS code may map to a single usSIC code.

• 1997 NAICS to 2002 NAICS
• Source: U.S. Census Bureau
• Format: This is an Excel spreadsheet. It should be helpful for mapping data in both directions.
• Includes verbal descriptions.

• 1997 NAICS to 4-digit 1980 cSIC
• Source: Statistics Canada
• Format: Column 1 is NAICS, column 2 is cSIC
• Note that some NAICS codes map to more than one cSIC code. In addition, more than one NAICS code may map to a single cSIC code.

• 2002 NAICS to 4-digit 1987 usSIC
• Source: U.S. Census Bureau
• Format: Excel spreadsheet.
• Includes verbal descriptions.

From PRODCOM:

• Selected Products and Materials of PRODCOM - 97
• According to ISIC Rev. 2 numerical code order
• From the United Nations Statistics Division
• Include