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:

 

 

 

From usSIC:

 

 

 

  • 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.

 

From cSIC:

 

 

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)

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.

 

  • 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:

 

From NACE:

 

From NAICS:

 

 

 

 

From PRODCOM:

 

 


Other Useful Mappings

  • Country Codes:
    • Includes a mapping between the following country coding systems:
      • WTDB (Stat-Can)
      • Penn World Tables v5, v5.6
      • World Bank CD.
      • The U.S. Census Bureau

Acronyms

  • cSIC: Standard Industrial Classification (CANADA)
  • usSIC: Standard Industrial Classification (US)
  • usMSIC: Import based - Standard Industrial Classification (US)
  • HS: Harmonized Tariff System (US)
  • SITC: Standard International Trade Classification
  • ISIC: International Standard Industrial Classification (Rev 3) (United Nations)
  • NACE: The European Union (Rev 1)
  • NIMEXE: Used by The European Community until 1987
  • TSUSA: Tariff Schedule of the United States Annotated classification
  • CIC: Census Industry Classification (US)
  • NAICS: North American Classification System, 1997 (US, Mexico, and Canada)

Industry Classifications - Verbal Descriptions

o        Notes:

      • Source: U.S. Census Bureau
      • Not shown here are 6-digit codes ending in 0 that coincide with their parent 5-digit category, for example, 111110 Soybean Farming.
      • The descriptions offered by the Canadians may differ, from that offered by the U.S., but in only 3 cases do the actual content of the codes differ (see below). For more detail, please see the StatCan Website.
        • 323119 Other Printing
        • 332999 All Other Miscellaneous Fabricated Metal Product Manufacturing
        • 334512 Measuring, Medical and Controlling Devices Manufacturing

 

 

 

 

 

  • US Trade Commodity Classification - Schedule B

 

 

 

 

 

 



 

 

  • TSUSA Classification
    • Source: NBER Trade CD 1
    • Format: Code, 1st year used, last year used, description.

 

 

  • HS Classification
    • Source: NBER Trade CD 1
    • Format: Code, 1st year used, last year used, description.
    • 10 digit classification

 

  • HS Classification
    • Source: UNCTAD TRAINS Dataset
    • Format: Code, description.
    • 8 digit classification

 

o       Thank you Dr. John P. Haisken-DeNew, for this information

 


Disclaimer: Please note that I will not vouch for the accuracy of these numbers. They are to the best of my knowledge correct, but if you want 100% accurate numbers, you should double check them yourself. If you do double-check them and you find errors, I would appreciate it if you would inform me. Thank you.


Other Places to Find Concordances:

The GTAP project
The United Nations
Eurostat-RAMON


Raymond Robertson (robertson@macalester.edu)