Re: [Gnumed-devel] ICD 9 tables

[Jim Busser]

On 2011-08-01, at 2:59 AM, Karsten Hilbert wrote:

> Someone with knowledge of ICD 9 please suggest a
> table/tables to store the coding system in.

The following is from Statistics Canada (2002)

***************************
Stats Can data structure
***************************
Nosology ICD9 list
 
Record structure:
 
Field            Size            Position            Type            Title
1            2            1 - 2            N            Chapter number
2            6            3 - 8            AN            ICD - 9 code (001 - 
E999.9)
3            1            9            AN            Blank
4            72            10 - 81            AN            ICD - 9 code 
description
5            1            82            AN            Sequence flag
                                                Blank or            1           
 - first record
                                                            2            - 
second record
                                                            3            - 
third record


*********
Sample:
*********

first row (a header):

ICD9,C,5        DESCRIP,C,73    FLAG,C,1

…

rows 210 to 245 inclusive:

040     OTHER BACTERIAL DISEASES        
0400    GAS GANGRENE    
0401    RHINOSCLEROMA   
0402    WHIPPLE'S DISEASE       
0403    NECROBACILLOSIS 
0408    OTHER BACTERIAL DISEASES        
041     BACTERIAL INFECTION IN CONDITIONS CLASSIFIED ELSEWHERE AND OF   1
041      UNSPECIFIED SITE       2
0410    STREPTOCOCCUS   
0411    STAPHYLOCOCCUS  
0412    PNEUMOCOCCUS    
0413    FRIEDLANDER'S BACILLUS  
0414    ESCHERICHIA COLI        
0415    HAEMOPHILUS INFLUENZAE (H.INFLUENZAE)   
0416    PROTEUS (MIRABILIS) (MORGANII)  
0417    PSEUDOMONAS     
0418    OTHER   
0419    BACTERIAL INFECTION, UNSPECIFIED        
042     HUMAN IMMUNODEFICIENCY VIRUS (HIV) INFECTION WITH SPECIFIED CONDITIONS  
0420    HIV INFECTION WITH CERTAIN SPECIFIED INFECTIONS 
0421    HIV INFECTION CAUSING OTHER SPECIFIED INFECTIONS        
0422    HIV INFECTION WITH SPECIFIED MALIGNANT NEOPLASMS        
0429    ACQUIRED IMMUNODEFICIENCY SYNDROME WITH OR WITHOUT OTHER CONDITIONS     
043     HUMAN IMMUNODEFICIENCY VIRUS (HIV) INFECTION CAUSING OTHER SPECIFIED    
1
043      CONDITIONS     2
0430    HIV INFECTION CAUSING LYMPHADENOPATHY (785.6)   
0431    HIV INFECTION CAUSING SPECIFIED DISEASES OF THE CENTRAL NERVOUS SYSTEM  
0432    HIV INFECTION CAUSING OTHER DISORDERS INVOLVING THE IMMUNE MECHANISM    
1
0432     (279)  2
0433    HIV INFECTION CAUSING OTHER SPECIFIED CONDITIONS        
0439    ACQUIRED IMMUNODEFICIENCY SYNDROME-RELATED COMPLEX WITH OR WITHOUT      
1
0439     OTHER CONDITIONS       2
044     OTHER HUMAN IMMUNODEFICIENCY VIRUS (HIV) INFECTION      
0440    HIV INFECTION CAUSING SPECIFIED ACUTE INFECTIONS        
0449    HIV INFECTION NOT OTHERWISE SPECIFIED (WITH OR WITHOUT OTHER    1
0449     CONDITIONS NOT CLASSIFIABLE TO 042, 043, 044.0)        2

…

-- Jim