Archives by admin

A. Spin name tests

Posted by admin on 16th October 2015

Spinname is a rather long table with a very wide namefield.

You can download it [is_downtable table=”spinname” text=”here”]

[is_showtable table=”” sql=”SELECT * FROM spinname WHERE nametype=’NO’  AND pid > 60000000 AND pid < 70000000 ORDER BY pid “]

9.8.1 Data upload test

Posted by admin on 14th October 2015

Data in trim_test table:

[is_showtable table=”trim_test”]

Download trim_test:

[is_downtable table=”trim_test”]

9.9.8 Download table sample

Posted by admin on 30th September 2015

Example of Download CSV.

[is_downtable table=”code_db7″ fields=”” text=”Download DB7 codetable here”]


[is_downtable table=”code_nace” fields=”” text=”Download NACE codes  here”]


[is_downtable table=”spinstof” fields=”” text=”Download main substancetable  here”]


[is_downtable table=”spinname” fields=”” text=”Download substance names here”]


[is_downtable table=”useT” fields=”” text=”Download total use data here”]


[is_downtable table=”useI” FIELDS=”” text=”Download use data by industry here”]


[is_downtable table=”useId” fields=”” text=”Download use data by detailed industry here”]


[is_downtable table=”usePC” fields=”” text=”Download use data by Product Category here”]


[is_downtable table=”usePCd” fields=”” text=”Download use data by detailed Product Category here”]


[is_downtable table=”useexpo” fields=”” text=”Download exposure data here”]



9.9.9 Codetable samples

Posted by admin on 17th September 2015

Each code can be described with some text and a lookup to the actual codetable. Here’s some samples for the formating of the lookup:

Format 1
This sample uses the full sql syntax of the wordpress shortcode is_showtable:
sql=”SELECT code as Code, text as Explanation from code_nace  Limit 0,6″
[is_showtable table=”” sql=”SELECT TOP 6 code as Code, text as Explanation from code_nace “]
[is_showtable table=”” sql=”SELECT TOP 6 code as Code, text as Explanation from code_nace”]

Format 2
This sample uses the simple format of is_showtable: table=”code_nace”

[is_showtable table=”code_nace” fields=””]

Format 3
This sample uses the “table and fields” format of is_showtable: table=”code_db7″ fields=”code”

[is_showtable table=”code_db7″ fields=”code”]
[is_downtable table=”” sql=”SELECT TOP 10 code as Code, text as Explanation from code_nace”]

3.6 Colourindex

Posted by admin on 17th September 2015

The colourindex is a classification maintaned by the dye industry. You can find more information here.

Below you find the colourcodes used in SPIN. You can search in this list using your browsers search function: Hit Ctrl + F on your keyboard. Or you can download the entire table as a csv file [is_downtable table=”code_nace” sql=”SELECT code as Code, text as Explanation from code_nace” text=”Download Colourindex codetable here”]
[is_showtable table=” code_nace”] sql=”SELECT code as Code, meaning as Explanation from code_colourindex “

1.2 User manual content

Posted by admin on 8th September 2015

1.2      User manual content


  1. User Manual


1.1         Using the SPIN guide


1.2         User manual content


1.3         Using the SPIN application

1.3.1        Searching in SPIN

1.3.2        Searching in SPIN – using special characters

1.3.3        Searching in SPIN – using operators and ranges

1.3.4        Searching in SPIN – using names and chemical numbers


1.4         Using the SPIN data

1.4.1        Selecting specific “use data” on the screens


1.5         On-line help

1.5.1        On-line help – Main Info

1.5.2        On-line help – Total use

1.5.3        On-line help – Industrial use

1.5.4        On-line help – Use by category

1.5.5        On-line help – References

1.5.6        On-line help – Technical


1.6         Reports in SPIN

1.6.1        NACE Report

1.6.2        UC62 Report

1.6.3        Reports – using the current found set


  1. General Info


2.1         Background


2.2         The nordic product registers


2.3         The kind of data in SPIN


2.4         Substances and products in the Nordic product registers


2.5         The Nordic product registers information on product composition


2.6         Updating of the Nordic product registers and SPIN


2.7         Quality control in the Nordic product registers


2.8         Function of a substance in a product


2.9         Codes for areas of use (industrial categories)


2.10     Codes for technical types of products and preparations (use categories)


2.11     Uncertainties


2.12     Limits in the use of data


2.13     Summary


  1. Codes


3.1         Use categories

3.1.1        UC62 use categories

3.1.2        Danish use categories

3.1.3        Norwegian use categories

3.1.4        Swedish use categories

3.1.5        Finnish use categories


3.2         Industrial categories

3.2.1        NACE codes for industrial categories

3.2.2        Danish industrial use categories

3.2.3        Swedish industrial use categories


3.3         Main category (IUCLID)


3.4         Substance categories (Danish)


3.5         Inventories


  1. Tutorials


4.1         Colouring agents


4.2         High volume substances


  1. Links


5.1         About links from SPIN to the Internet


5.2         SPIN on the Internet


5.3         Additional information about the SMILES notation


5.4         Additional information about Chemicals


  1. Contact


6.1        SPIN contact – Denmark


6.2        SPIN contact – Iceland


6.3        SPIN contact – Finland


6.4        SPIN contact – Norway


6.5        SPIN contact – Sweden

1.1 Using the SPIN guide

Posted by admin on 8th September 2015

1.1      Using the SPIN guide


When you first enter the guide window, none of the content menus are active. To activate a content menu you simply press one of the tab titles. To enter one of the guide documents of the current tab, you then press the title of the document of your interest in the content menu. You can navigate between the document title lines by using the mouse.


The underlying documents of each guide tab are similar to the sections in the printed SPIN Guide, and a few of the documents can also be accessed from the on-line help (see section “1.3 Using the SPIN application”). To change to another guide document you simply press the tab title of interest and select a document from the activated content menu. Pressing the “Close Guide” button closes the guide window and returns you to the window you were in, before you entered the guide.



CAS no for dangerous substances

Posted by admin on 25th April 2015

In Sweden and Denmark lists of substances belonging to generic groups in annex I to directive 67/548/EEC have been developed resulting in tables covering all CAS numbers with harmonised classifications from the authorities. Though the two tables has not yet been worked over to identify differences and possibly errors, NPG has chosen to put the tables with CAS numbers and Index number on our home page, as a help for those, who are not sure if a harmonised classification is available for a specific substance.

Download the document: CAS No for dangerous substances

News in SPIN Exposure Toolbox

Posted by admin on 7th June 2012

The human exposure part in the Use Index (UI) tools has been developed. The former index indicates potential exposure mainly from private consumptions. From 2012, Use Index for “human” is complemented with a new Use Index that covers potential occupational exposure (“occupational”). The Use Index for “human” has at the same time been renamed to “consumer”. The new Use Index was released on SPIN in May 2012, and is applied from 2010 years Product Register data.