_id	qvd bkhnh	bkhnh	Concatenate
1	33.0	WHOOPINGCOUGHDUETOBORDETELLAPERTUSSIS(B.PERTUSSIS)	union select '033.0','1'
2	33.1	WHOOPINGCOUGHDUETOBORDETELLAPARAPERTUSSIS(B.PARAPERTUSSIS)	union select '033.1','1'
3	33.8	WHOOPINGCOUGHDUETOOTHERSPECIFIEDORGANISM	union select '033.8','1'
4	33.9	WHOOPINGCOUGH,UNSPECIFIEDORGANISM	union select '033.9','1'
5	460	ACUTENASOPHARYNGITIS(COMMONCOLD)	union select '460','1'
6	464.0	ACUTELARYNGITIS	union select '464.0','1'
7	464.00	"""ACUTELARYNGITIS,WITHOUTMENTIONOFOBSTRUCTION"""	union select '464.00','1'
8	464.01	ACUTELARYNGITIS,WITHOBSTRUCTION	union select '464.01','1'
9	464.10	ACUTETRACHEITISWITHOUTMENTIONOFOBSTRUCTION	union select '464.10','1'
10	464.11	ACUTETRACHEITISWITHOBSTRUCTION	union select '464.11','1'
11	464.20	ACUTELARYNGOTRACHEITISWITHOUTMENTIONOFOBSTRUCTION	union select '464.20','1'
12	464.21	ACUTELARYNGOTRACHEITISWITHOBSTRUCTION	union select '464.21','1'
13	464.30	ACUTEEPIGLOTTITISWITHOUTMENTIONOFOBSTRUCTION	union select '464.30','1'
14	464.31	ACUTEEPIGLOTTITISWITHOBSTRUCTION	union select '464.31','1'
15	464.4	CROUP	union select '464.4','1'
16	464.50	UNSPECIFIEDSUPRAGLOTTIS,WITHOUTMENTIONOFOBSTRUCTION	union select '464.50','1'
17	464.51	UNSPECIFIEDSUPRAGLOTTIS,WITHOBSTRUCTION	union select '464.51','1'
18	465	ACUTEPHARYNGITIS	union select '465','1'
19	465.0	ACUTELARYNGOPHARYNGITIS	union select '465.0','1'
20	465.8	ACUTEUPPERRESPIRATORYINFECTIONSOFOTHERMULTIPLESITES	union select '465.8','1'
21	465.9	ACUTEUPPERRESPIRATORYINFECTIONSOFUNSPECIFIEDSITE	union select '465.9','1'
22	466.0	ACUTEBRONCHITIS	union select '466.0','1'
23	472.0	CHRONICRHINITIS	union select '472.0','1'
24	472.1	CHRONICPHARYNGITIS	union select '472.1','1'
25	472.2	CHRONICNASOPHARYNGITIS	union select '472.2','1'
26	477.0	ALLERGICRHINITISDUETOPOLLEN	union select '477.0','1'
27	477.1	ALLERGICRHINITIS,DUETOFOOD	union select '477.1','1'
28	477.2	ALLERGICRHINITIS,DUETOANIMAL(CAT)(DOG)HAIRANDDANDER	union select '477.2','1'
29	477.8	ALLERGICRHINITISDUETOOTHERALLERGEN	union select '477.8','1'
30	477.9	"""ALLERGICRHINITIS,CAUSEUNSPECIFIED"""	union select '477.9','1'
31	478.0	HYPERTROPHYOFNASALTURBINATES	union select '478.0','1'
32	478.1	OTHERDISEASESOFNASALCAVITYANDSINUSES	union select '478.1','1'
33	478.11	NASALMUCOSITIS(ULCERATIVE)	union select '478.11','1'
34	478.19	OTHERDISEASEOFNASALCAVITYANDSINUSES	union select '478.19','1'
35	478.20	UNSPECIFIEDDISEASEOFPHARYNX	union select '478.20','1'
36	478.21	CELLULITISOFPHARYNXORNASOPHARYNX	union select '478.21','1'
37	478.22	PARAPHARYNGEALABSCESS	union select '478.22','1'
38	47824	RETROPHARYNGEALABSCESSRETROPHARYNGEALABSCESS	union select '47824','1'
39	478.25	EDEMAOFPHARYNXORNASOPHARYNX	union select '478.25','1'
40	478.26	CYSTOFPHARYNXORNASOPHARYNX	union select '478.26','1'
41	478.29	OTHERDISEASESOFPHARYNXORNASOPHARYNX	union select '478.29','1'
42	478.30	UNSPECIFIEDPARALYSISOFVOCALCORDS	union select '478.30','1'
43	478.31	UNILATERALPARTIALPARALYSISOFVOCALCORDS	union select '478.31','1'
44	478.32	UNILATERALCOMPLETEPARALYSISOFVOCALCORDS	union select '478.32','1'
45	478.33	BILATERALPARTIALPARALYSISOFVOCALCORDS	union select '478.33','1'
46	478.34	BILATERALCOMPLETEPARALYSISOFVOCALCORDS	union select '478.34','1'
47	478.5	OTHERDISEASESOFVOCALCORDS	union select '478.5','1'
48	478.6	EDEMAOFLARYNX	union select '478.6','1'
49	478.71	CELLULITISANDPERICHONDRITISOFLARYNX	union select '478.71','1'
50	478.74	STENOSISOFLARYNX	union select '478.74','1'
51	478.75	LARYNGEALSPASM	union select '478.75','1'
52	478.79	OTHERDISEASESOFLARYNX	union select '478.79','1'
53	478.8	UPPERRESPIRATORYTRACTHYPERSENSITIVITYREACTION,SITEUNSPECIFIED	union select '478.8','1'
54	478.9	OTHERANDUNSPECIFIEDDISEASESOFUPPERRESPIRATORYTRACT	union select '478.9','1'
55	480.0	PNEUMONIADUETOADENOVIRUS	union select '480.0','1'
56	480.1	PNEUMONIADUETORESPIRATORYSYNCYTIALVIRUS	union select '480.1','1'
57	480.2	PNEUMONIADUETOPARAINFLUENZAVIRUS	union select '480.2','1'
58	480.3	PNEUMONIADUETOSARS-ASSOCIATEDCORONAVIRUS	union select '480.3','1'
59	480.8	PNEUMONIADUETOOTHERVIRUSNOTELSEWHERECLASSIFIED	union select '480.8','1'
60	480.9	VIRALPNEUMONIA,UNSPECIFIED	union select '480.9','1'
61	485	"""BRONCHOPNEUMONIA,ORGANISMUNSPECIFIED"""	union select '485','1'
62	486	"""PNEUMONIA,ORGANISMUNSPECIFIED"""	union select '486','1'
63	490	"""BRONCHITIS,NOTSPECIFIEDASACUTEORCHRONIC"""	union select '490','1'
64	491.0	SIMPLECHRONICBRONCHITIS	union select '491.0','1'
65	491.1	MUCOPURULENTCHRONICBRONCHITIS	union select '491.1','1'
66	491.20	"-OBSCHRBRNCW/OACTEXAMENTIONOFACUTEEXACERBATION""""OBSTRUCTIVECHRONICBRONCHITIS,WITHOUT"	union select '491.20','1'
67	491.21	-AC&CHR.BRONCH.WTHCOPD	union select '491.21','1'
68	491.22	OBSTRUCTIVECHRONICBRONCHITISWITHACUTEBRONCHITIS	union select '491.22','1'
69	491.8	OTHERCHRONICBRONCHITIS	union select '491.8','1'
70	491.9	UNSPECIFIEDCHRONICBRONCHITIS	union select '491.9','1'
71	492.0	-EMPHYSEMATOUSBLEB&&	union select '492.0','1'
72	492.8	OTHEREMPHYSEMA	union select '492.8','1'
73	493	ASTHMA	union select '493','1'
74	493.00	EXTRINSICASTHMA,UNSPECIFIC	union select '493.00','1'
75	493.01	EXTRINSICASTHMAWITHSTATUSASTHMATICUS	union select '493.01','1'
76	493.02	"""EXTRINSICASTHMA,WITH(ACUTE)EXACERBATION"""	union select '493.02','1'
77	493.10	INTRINSICASTHMA,UNSPECIFIC	union select '493.10','1'
78	493.11	INTRINSICASTHMAWITHSTATUSASTHMATICUS	union select '493.11','1'
79	493.12	INTRINSICASTHMA,WITH(ACUTE)EXACERBATION	union select '493.12','1'
80	493.20	CHRONICOBSTRUCTIVEASTHMA,UNSPECIFIED	union select '493.20','1'
81	493.21	"""CHRONICOBSTRUCTIVEASTHMA,WITHSTATUSASTHMATICUS"""	union select '493.21','1'
82	493.22	"""CHRONICOBSTRUCTIVEASTHMA,WITH(ACUTE)EXACERBATION"""	union select '493.22','1'
83	493.81	EXERCISEINDUCEDBRONCHOSPASM	union select '493.81','1'
84	493.82	COUGHVARIANTASTHMA	union select '493.82','1'
85	493.90	"""ASTHMA,UNSPECIFIED"""	union select '493.90','1'
86	493.91	"""ASTHMA,UNSPECIFIEDTYPE,WITHSTATUSASTHMATICUS"""	union select '493.91','1'
87	493.92	"-""ASTHMA,NOS,W/ACEXACER""TION""""UNSPECIFIEDASTHMA,WITHACUTEEXACERBA"	union select '493.92','1'
88	494.0	BRONCHIECTASISWITHOUTACUTEEXACERBATION	union select '494.0','1'
89	494.1	BRONCHIECTASISWITHACUTEEXACERBATION	union select '494.1','1'
90	495.0	FARMERS'LUNG	union select '495.0','1'
91	495.4	MALTWORKERS'LUNG	union select '495.4','1'
92	495.7	VENTILATIONPNEUMONITIS	union select '495.7','1'
93	495.8	OTHERSPECIFIEDALLERGICALVEOLITISANDPNEUMONITIS	union select '495.8','1'
94	495.9	UNSPECIFIEDALLERGICALVEOLITISANDPNEUMONITIS	union select '495.9','1'
95	496	"-CHRAIRWAYOBSTRUCTNECRECLASSIFIED""""CHRONICAIRWAYOBSTRUCTION,NOTELSEWHE"	union select '496','1'
96	500	COALWORKERS'PNEUMOCONIOSIS	union select '500','1'
97	501	ASBESTOSIS	union select '501','1'
98	502	PNEUMOCONIOSISDUETOOTHERSILICAORSILICATES	union select '502','1'
99	503	PNEUMOCONIOSISDUETOOTHERINORGANICDUST	union select '503','1'
100	504	PNEUMONOPATHYDUETOINHALATIONOFOTHERDUST	union select '504','1'
101	505	PNEUMOCONIOSIS,UNSPECIFIED	union select '505','1'
102	506.0	BRONCHITISANDPNEUMONITISDUETOFUMESANDVAPORS	union select '506.0','1'
103	506.1	ACUTEPULMONARYEDEMADUETOFUMESANDVAPORS	union select '506.1','1'
104	506.2	-FUM/VAPORUPRESPINFLAMMESANDVAPORSUPPERRESPIRATORYINFLAMMATIONDUETOFU	union select '506.2','1'
105	506.3	OTHERACUTEANDSUBACUTERESPIRATORYCONDITIONSDUETOFUMESANDVAPORS	union select '506.3','1'
106	506.4	CHRONICRESPIRATORYCONDITIONSDUETOFUMESANDVAPORS	union select '506.4','1'
107	506.9	UNSPECIFIEDRESPIRATORYCONDITIONSDUETOFUMESANDVAPORS	union select '506.9','1'
108	508.0	ACUTEPULMONARYMANIFESTATIONSDUETORADIATION	union select '508.0','1'
109	508.1	CHRONICANDOTHERPULMONARYMANIFESTATIONSDUETORADIATION	union select '508.1','1'
110	508.2	RESPIRATORYCONDITIONSDUETOSMOKEINHALATION	union select '508.2','1'
111	508.8	RESPIRATORYCONDITIONSDUETOOTHERSPECIFIEDEXTERNALAGENTS	union select '508.8','1'
112	508.9	RESPIRATORYCONDITIONSDUETOUNSPECIFIEDEXTERNALAGENT	union select '508.9','1'
113	516.32	IDIOPATHICNON-SPECIFICINTERSTITIALPNEUMONITIS	union select '516.32','1'
114	516.33	ACUTEINTERSTITIALPNEUMONITIS	union select '516.33','1'
115	516.34	RESPIRATORYBRONCHIOLITISINTERSTITIALLUNGDISEASE	union select '516.34','1'
116	516.35	IDIOPATHICLYMPHOIDINTERSTITIALPNEUMONIA	union select '516.35','1'
117	516.36	CRYPTOGENICORGANIZINGPNEUMONIA	union select '516.36','1'
118	516.37	DESQUAMATIVEINTERSTITIALPNEUMONIA	union select '516.37','1'
119	516.62	PULMONARYINTERSTITIALGLYCOGENOSIS	union select '516.62','1'
120	516.63	SURFACTANTMUTATIONSOFTHELUNG	union select '516.63','1'
121	516.69	OTHERINTERSTITIALLUNGDISEASESOFCHILDHOOD	union select '516.69','1'
122	516.8	OTHERSPECIFIEDALVEOLARANDPARIETOALVEOLARPNEUMONOPATHIES	union select '516.8','1'
123	516.9	UNSPECIFIEDALVEOLARANDPARIETOALVEOLARPNEUMONOPATHY	union select '516.9','1'
124	517.1	RHEUMATICPNEUMONIA	union select '517.1','1'
125	517.2	LUNGINVOLVEMENTINSYSTEMICSCLEROSIS	union select '517.2','1'
126	517.3	ACUTECHESTSYNDROME	union select '517.3','1'
127	517.8	LUNGINVOLVEMENTINOTHERDISEASESCLASSIFIEDELSEWHERE	union select '517.8','1'
128	518.0	PULMONARYCOLLAPSE	union select '518.0','1'
129	518.1	INTERSTITIALEMPHYSEMA	union select '518.1','1'
130	518.2	COMPENSATORYEMPHYSEMA	union select '518.2','1'
131	518.3	PULMONARYEOSINOPHILIA	union select '518.3','1'
132	518.4	"""ACUTEEDEMAOFLUNG,UNSPECIFIED"""	union select '518.4','1'
133	518.51	ACUTERESPIRATORYFAILUREFOLLOWINGTRAUMAANDSURGERY	union select '518.51','1'
134	518.52	OTHERPULMONARYINSUFFICIENCY,NOTELSEWHERECLASSIFIED,FOLLOWINGTRAUMAANDSURGERY	union select '518.52','1'
135	518.53	ACUTEANDCHRONICRESPIRATORYFAILUREFOLLOWINGTRAUMAANDSURGERY	union select '518.53','1'
136	518.6	ALLERGICBRONCHOPULMONARYASPERGILLOSIS	union select '518.6','1'
137	518.7	TRANSFUSIONRELATEDACUTELUNGINJURY(TRALI)	union select '518.7','1'
138	51881	RESPIRATORYFAILUREACUTERESPIRATORYFAILURE	union select '51881','1'
139	518.82	OTHERPULMONARYINSUFFICIENCY,NOTELSEWHERECLASSIFIED	union select '518.82','1'
140	518.83	CHRONICRESPIRATORYFAILURE	union select '518.83','1'
141	518.84	ACUTEANDCHRONICRESPIRATORYFAILURE	union select '518.84','1'
142	518.89	"""OTHERDISEASESOFLUNG,NOTELSEWHERECLASSIFIED"""	union select '518.89','1'
143	519.00	UNSPECIFIEDTRACHEOSTOMYCOMPLICATION	union select '519.00','1'
144	519.01	INFECTIONOFTRACHEOSTOMY	union select '519.01','1'
145	519.09	OTHERTRACHEOSTOMYCOMPLICATION	union select '519.09','1'
146	519.1	"""OTHERDISEASESOFTRACHEAANDBRONCHUS,NOTELSEWHERECLASSIFIED"""	union select '519.1','1'
147	519.11	ACUTEBRONCHOSPASM	union select '519.11','1'
148	519.19	OTHERDISEASESOFTRACHEAANDBRONCHUS	union select '519.19','1'
149	519.4	DISORDERSOFDIAPHRAGM	union select '519.4','1'
150	519.8	OTHERDISEASESOFRESPIRATORYSYSTEM,NOTELSEWHERECLASSIFIED	union select '519.8','1'
151	519.9	UNSPECIFIEDDISEASEOFRESPIRATORYSYSTEM	union select '519.9','1'
152	786.0	DYSPNEA&RESPIRATORYABNORMALITIES	union select '786.0','1'
153	786.00	"""RESPIRATORYABNORMALITY,UNSPECIFIED"""	union select '786.00','1'
154	786.01	HYPERVENTILATION	union select '786.01','1'
155	786.02	ORTHOPNEA	union select '786.02','1'
156	786.03	APNEA	union select '786.03','1'
157	786.04	CHEYNE-STOKESRESPIRATION	union select '786.04','1'
158	786.05	SHORTNESSOFBREATH	union select '786.05','1'
159	786.06	TACHYPNEA	union select '786.06','1'
160	786.07	WHEEZING	union select '786.07','1'
161	786.09	OTHERDYSPNEAANDRESPIRATORYABNORMALITY	union select '786.09','1'
162	786.09	-RESPIRATORYABNORMNECYOTHERDYSPNEAANDRESPIRATORYABNORMALIT	union select '786.09','1'
163	786.1	STRIDOR	union select '786.1','1'
164	786.2	COUGH	union select '786.2','1'
165	786.3	HEMOPTYSIS	union select '786.3','1'
166	786.30	HEMOPTYSIS,UNSPECIFIED	union select '786.30','1'
167	786.31	ACUTEIDIOPATHICPULMONARYHEMORRHAGEININFANTS[AIPHI]	union select '786.31','1'
168	786.39	OTHERHEMOPTYSIS	union select '786.39','1'
169	786.4	ABNORMALSPUTUM	union select '786.4','1'
170	786.52	PAINFULRESPIRATION	union select '786.52','1'
171	786.59	-CHESTPAINNECOTHERCHESTPAIN	union select '786.59','1'
172	786.7	ABNORMALCHESTSOUNDS	union select '786.7','1'
173	786.8	HICCOUGH	union select '786.8','1'
174	786.9	OTHERSYMPTOMSINVOLVINGRESPIRATORYSYSTEMANDCHEST	union select '786.9','1'