UNSPSC Reference

Purpose:Provide relevant aspects of the UNSPSC taxonomy.
Table Name:unspsc_reference
Structure and Description:
ColumnTypeColumn Content
commodity_codeDecimal(8,0)UNSPSC commodity code
commodity_titleCharacter Varying(150)UNSPSC commodity title
class_codeDecimal(8,0)UNSPSC class code
class_titleCharacter Varying(150)UNSPSC class title
family_codeDecimal(8,0)UNSPSC family code
family_titleCharacter Varying(150)UNSPSC family title
segment_codeDecimal(8,0)UNSPSC segment code
segment_titleCharacter Varying(150)UNSPSC segment title

This file contains a listing of commodities in the United Nations Standard Products and Services Code (UNSPSC), version 23.0701. The UNSPSC is a four-level taxonomy for the classification of products and services, provided by the United Nations Development Programme. In the taxonomy, the Segment is the most general element and the Commodity is the most specific. One example is listed below:

Segment:43000000Information Technology Broadcasting and Telecommunications
Family:43230000Software
Class:43232100Content authoring and editing software
Commodity:43232104Word processing software

Each technology or tool example is classified under this taxonomy; the “Commodity Code” and “Commodity Title” columns in the Technology Skills and Tools Used files can be used as a cross-reference into this file.

The file is displayed in 8 tab delimited fields with the columns named Commodity Code, Commodity Title, Class Code, Class Title, Family Code, Family Title, Segment Code, and Segment Title. The 8 fields are represented by one row. There are a total of 4,262 rows of data in this file.

For more information, see:

File Structure Changes:
Release NumberDescription of Change
20.1Added as a new file
20.2 - 28.1No structure changes

Data Example - unspsc_reference:
commodity_​codecommodity_​titleclass_​codeclass_​titlefamily_​codefamily_​titlesegment_​codesegment_​title
12131704Explosive initiators12131700Igniters12130000Explosive materials12000000Chemicals including Bio Chemicals and Gas Materials
12131707Lighters12131700Igniters12130000Explosive materials12000000Chemicals including Bio Chemicals and Gas Materials
14111513Ledger paper14111500Printing and writing paper14110000Paper products14000000Paper Materials and Products
14111802Receipts or receipt books14111800Business use papers14110000Paper products14000000Paper Materials and Products