Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Missing "Maps to" relationships to map NDC to Standard concepts #100

Closed
hamedabedtash opened this issue Jan 9, 2017 · 31 comments
Closed

Missing "Maps to" relationships to map NDC to Standard concepts #100

hamedabedtash opened this issue Jan 9, 2017 · 31 comments
Labels
NDC

Comments

@hamedabedtash
Copy link

I am using the code below to map NDC codes to standard concepts (RxNorm), but there are some NDCs that do not map to the respective RxNorm concept. This has happended (mostly) for those NDC concept with current valid dates (VALID_END_DATE=20991231) but their 'Maps to' relationships is denoted as updated ("U") or deleted ("D"), however no "updated" relationships exist in CONCEPT_RELATIONSHIP table. Any thoughts appreciated!

Here are some examples:

Dulaglutide:

From CONCEPT table:

CONCEPT_ID CONCEPT_NAME DOMAIN_ID VOCABULARY_ID CONCEPT_CLASS_ID STANDARD_CONCEPT CONCEPT_CODE VALID_START_DATE VALID_END_DATE INVALID_REASON

45871642	0.5 ML dulaglutide 1.5 MG/ML Auto-Injector [Trulicity]	Drug	NDC	11-digit NDC	NULL	00002143380	20141101	20991231	NULL
45863229	0.5 ML dulaglutide 1.5 MG/ML Auto-Injector [Trulicity]	Drug	NDC	11-digit NDC	NULL	00002143361	20141101	20991231	NULL
45875930	0.5 ML dulaglutide 1.5 MG/ML Auto-Injector [Trulicity]	Drug	NDC	11-digit NDC	NULL	00002143301	20141101	20991231	NULL
45873750	0.5 ML dulaglutide 3 MG/ML Auto-Injector [Trulicity]	Drug	NDC	11-digit NDC	NULL	00002143401	20141101	20991231	NULL
45869475	0.5 ML dulaglutide 3 MG/ML Auto-Injector [Trulicity]	Drug	NDC	11-digit NDC	NULL	00002143480	20141101	20991231	NULL
45865301	0.5 ML dulaglutide 3 MG/ML Auto-Injector [Trulicity]	Drug	NDC	11-digit NDC	NULL	00002143461	20141101	20991231	NULL
45804392	dulaglutide .75mg/.5mL SUBCUTANEOUS INJECTION, SOLUTION [trulicity]	Drug	NDC	9-digit NDC	NULL	000021433	20141107	20991231	NULL
45804393	dulaglutide 1.5mg/.5mL SUBCUTANEOUS INJECTION, SOLUTION [trulicity]	Drug	NDC	9-digit NDC	NULL	000021434	20141107	20991231	NULL

From CONCEPT_RELATIONSHIP table:

CONCEPT_ID_1 CONCEPT_ID_2 RELATIONSHIP_ID VALID_START_DATE VALID_END_DATE INVALID_REASON 

45871642	45774442	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45863229	45774442	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45875930	45774442	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45873750	45774448	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45869475	45774448	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45865301	45774448	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45804392	45774442	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45804393	45774448	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D

Lantus:
From CONCEPT table:

CONCEPT_ID CONCEPT_NAME DOMAIN_ID VOCABULARY_ID CONCEPT_CLASS_ID STANDARD_CONCEPT CONCEPT_CODE VALID_START_DATE VALID_END_DATE INVALID_REASON 

45104771	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54569646200	20140101	20991231	NULL
45860264	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54569646201	20140601	20991231	NULL
45310203	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54868623100	20110501	20991231	NULL
45282164	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	00088221900	20101101	20991231	NULL
45026277	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	00088221905	20101101	20991231	NULL
45207570	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54868576500	20090501	20991231	NULL
45207570	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54868576500	20090501	20991231	NULL
45310203	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54868623100	20110501	20991231	NULL
45207570	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	54868576500	20090501	20991231	NULL
45026277	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	00088221905	20101101	20991231	NULL
45282164	3 ML Insulin Glargine 100 UNT/ML Pen Injector [Lantus]	Drug	NDC	11-digit NDC	NULL	00088221900	20101101	20991231	NULL

From CONCEPT_RELATIONSHIP table:

CONCEPT_ID_1 CONCEPT_ID_2 RELATIONSHIP_ID VALID_START_DATE VALID_END_DATE INVALID_REASON 

45104771	1502910	Maps to	2014-03-03 00:00:00	2016-05-01 00:00:00	D
45860264	1502910	Maps to	2015-07-08 00:00:00	2016-05-01 00:00:00	D
45310203	1502910	Maps to	2011-05-02 00:00:00	2016-05-01 00:00:00	D
45282164	1502910	Maps to	2010-11-01 00:00:00	2016-05-01 00:00:00	D
45026277	1502910	Maps to	2010-11-01 00:00:00	2016-05-01 00:00:00	D
45207570	1502910	Maps to	2009-05-04 00:00:00	2016-05-01 00:00:00	D
45207570	19078559	Maps to	2008-01-01 00:00:00	2015-10-15 00:00:00	D
45310203	19071700	Maps to	2011-03-01 00:00:00	2015-10-15 00:00:00	D
45207570	19071700	Maps to	2007-09-01 00:00:00	2015-10-15 00:00:00	D
45026277	19071700	Maps to	2010-09-01 00:00:00	2015-10-15 00:00:00	D
45282164	19071700	Maps to	2010-09-01 00:00:00	2015-10-15 00:00:00	D

__

Here is the code used to map source codes to standard concepts:

image
@hamedabedtash
Copy link
Author

Hi @dimshitc,
Have you had a chance to look at this issue? Really appreciated!

Hamed

@dimshitc
Copy link
Contributor

Hi, @hamedabedtash
Thanks for your attention to this issue,
We already fixed that internally, so the next release will not contain it.

@hamedabedtash
Copy link
Author

@dimshitc, Great! Thanks for the update. Any idea when the next release will be?

Thanks,
Hamed

@ericaVoss
Copy link

Ran across this myself today looking for gemcitabine in US claims and found nothing.

The query belows shows NDCs that go no where in standard terminologies. 144,124 in V20161218. Didn't check a newer Vocabulary version so this may be fixed already.

WITH CTE_NDC AS (
	SELECT CONCEPT_CODE, CONCEPT_NAME
	FROM CONCEPT
	WHERE VOCABULARY_ID = 'NDC'
),
CTE_VOCAB_MAP AS (
       SELECT c.concept_code AS SOURCE_CODE, c.concept_id AS SOURCE_CONCEPT_ID, c.concept_name AS SOURCE_CODE_DESCRIPTION, c.vocabulary_id AS SOURCE_VOCABULARY_ID, 
                           c.domain_id AS SOURCE_DOMAIN_ID, c.CONCEPT_CLASS_ID AS SOURCE_CONCEPT_CLASS_ID, 
                                                   c.VALID_START_DATE AS SOURCE_VALID_START_DATE, c.VALID_END_DATE AS SOURCE_VALID_END_DATE, c.INVALID_REASON AS SOURCE_INVALID_REASON, 
                           c1.concept_id AS TARGET_CONCEPT_ID, c1.concept_name AS TARGET_CONCEPT_NAME, c1.VOCABULARY_ID AS TARGET_VOCABUALRY_ID, c1.domain_id AS TARGET_DOMAIN_ID, c1.concept_class_id AS TARGET_CONCEPT_CLASS_ID, 
                           c1.INVALID_REASON AS TARGET_INVALID_REASON, c1.standard_concept AS TARGET_STANDARD_CONCEPT
       FROM CONCEPT C
             JOIN CONCEPT_RELATIONSHIP CR
                        ON C.CONCEPT_ID = CR.CONCEPT_ID_1
                        AND CR.invalid_reason IS NULL
                        AND cr.relationship_id = 'Maps To'
              JOIN CONCEPT C1
                        ON CR.CONCEPT_ID_2 = C1.CONCEPT_ID
                        AND C1.INVALID_REASON IS NULL
       UNION
       SELECT source_code, SOURCE_CONCEPT_ID, SOURCE_CODE_DESCRIPTION, source_vocabulary_id, c1.domain_id AS SOURCE_DOMAIN_ID, c2.CONCEPT_CLASS_ID AS SOURCE_CONCEPT_CLASS_ID,
                                        c1.VALID_START_DATE AS SOURCE_VALID_START_DATE, c1.VALID_END_DATE AS SOURCE_VALID_END_DATE, 
                     stcm.INVALID_REASON AS SOURCE_INVALID_REASON,target_concept_id, c2.CONCEPT_NAME AS TARGET_CONCEPT_NAME, target_vocabulary_id, c2.domain_id AS TARGET_DOMAIN_ID, c2.concept_class_id AS TARGET_CONCEPT_CLASS_ID, 
                     c2.INVALID_REASON AS TARGET_INVALID_REASON, c2.standard_concept AS TARGET_STANDARD_CONCEPT
       FROM source_to_concept_map stcm
              LEFT OUTER JOIN CONCEPT c1
                     ON c1.concept_id = stcm.source_concept_id
              LEFT OUTER JOIN CONCEPT c2
                     ON c2.CONCEPT_ID = stcm.target_concept_id
       WHERE stcm.INVALID_REASON IS NULL
)
SELECT n.*
FROM CTE_NDC n
	LEFT OUTER JOIN CTE_VOCAB_MAP m
		ON m.SOURCE_CODE = n.CONCEPT_CODE
WHERE m.SOURCE_CODE IS NULL

@ericaVoss
Copy link

ericaVoss commented Dec 16, 2017 •
edited
Loading

In Vocabulary 20171201 there are now 156,402 of these.

I bounced them off some claims data to see how often they are used.

SELECT DRUG_SOURCE_VALUE, COUNT(*) AS ROW_COUNT, COUNT(DISTINCT PERSON_ID) AS PERSON_COUNT
FROM DRUG_EXPOSURE
WHERE DRUG_SOURCE_VALUE IN (
'005485900','69717000415','49288003505','64011019926','045802400','69152107101','90891060069','11344005334','08590006100','38779008100','059088106','156310228','702810102','13537098623','58154010760','617150026','061715028','758740424','64117029401','691520571','68745200201','607640092','055648631','52000000205','301420690','50051000204','44911015501','10237076101','59779060204','641170206','12753030702','489510076','136300101','08011802002','76357020009','11701001405','045861017','055390346','063736339','037808171','62778004003','13537067002','021695338','69945045002','69157001501','063717276','059726019','37000018073','690580400','38779001703','61037041306','010885002','057664361','699450094','42546017030','08290305615','08462122220','54859050108','118229007','049349723','68828018206','62902000101','43846005501','065841622','011489076','55714221700','68703015259','68455010620','00548635500','08080109300','48951904301','75839025325','582320649','664920001','061727313','10578000801','055390159','51305000197','049781013','701860578','021695489','992070500','063347501','43419000608','58443012804','055289730','156310546','61380013011','00220905407','57627016302','51523001001','056062678','82607053551','548600011','575200764','62991284302','043269779','696930717','438530002','715960034','35781021002','66854000702','715670002','51927329900','51927186000','010812201','065365003','63776017014','051079585','035356999','015127082','011559011','025010215','50539022108','00942631702','661340015','66579002602','08524001702','62106025900','67938139201','69761011030','15482088013','698710004','013733019','35192000602','38779122601','041520463','037000317','64942122702','75990096810','065841129','27434001226','75936013507','62991165203','69221020101','003600387','16042001059','041520085','066336428','042549672','51552010607','60681230201','712200067','58443016704','51552038007','67938083101','51346037201','694221101','156312479','051346001','08380019204','068084154','49452093002','037000603','065862574','049348704','38779000801','38779080208','52747071204','449110427','502680586','043063171','102370804','688280147','691521003','52389082904','62795102202','51927470500','056062702','53346130605','87701040272','438570439','08373013400','68405100702','057344154','81317002516','489519000','17191000062','049349665','063148251','00469133020','044717532','48951712101','620320103','15631236703','15631236501','43419052331','51552105007','055648715','017312001','068472136','59779038303','041616635','055111404','62712022124','541187141','15631062203','43269091116','51688965105','49452539001','38779036009','035356694','54473023001','076449050','13537029810','10939080033','64282010012','016590906','51414070009','370000140','62991140604','035356814','055390506','068196299','050111398','156310183','08380019253','049884534','067046953','690380005','060429249','11701085421','15631036803','065841705','030142477','64772030003','054838558','575200032','60892060101','11701088694','523890173','064117524','54838000980','51523046633','013734128','497940048','15631041701','596670026','98132088118','00847059000','08884712100','49452722002','15631014300','010019321','411900441','025021211','50114600502','510600031','060429540','003380665','00026655510','051861020','248540300','59135000249','037012977','764851042','15631012303','047335576','489519175','15631007704','50428489362','53303009010','076237278','059115093','52372082701','449110291','042254302','13537025062','147830990','615940003','15631235602','051386706','067457222','684280123','068645300','438570022','027190100','37000041878','00467810210','692242001','87701040480','59899000601','65954076869','619571021','69152108501','61941022604','060429102','00062331100','92771013508','54973314601','59351032001','51927283400','525840050','00074722217','38779062505','38779056102','61553017478','64117054802','67172049401','057881333','37000015114','15631018101','067457340','13537029809','041163897','10742847002','48951120001','063304652','438570283','432690884','57520005301','033261112','059779238','497150010','64117021001','068180117','40986001532','434190028','050419703','055315333','00555113010','43857022901','15631026501','62180509401','672261021','650442620','635090002','59779002156','049999538','49527073201','698420508','61500554704','684280207','041268437','041163742','684280479','10939072011','052810213','135370352','764851056','38779193405','51688515806','011673063','69017030101','537270104','51991091390','00209690022','065862042','00338007904','054312925','063029644','50845011201','10812039790','076509050','068462340','030803001','042549609','44911017901','051862163','064376656','55566030201','760490555','068084094','51927209000','54575092810','037808415','605126152','65447005002','041520498','635450689','420020441','68327006701','061727302','37945086065','437720022','58597807201','051293611','050241011','42508015902','156310319','763540804','136300075','15631017603','55390000601','08080356700','11822935030','61553012078','08290305155','15631056104','59088035200','62257036517','62991299401','063029301','58733000110','47993021502','68647019310','55714224801','76049000300','108120438','00364112801','38779031609','449110345','70074056420','15631055700','62991109803','69915000401','42673000203','685726005','61553042948','69998005001','050458515','676230001','586682951','00212196762','43526011602','114100528','489513140','64942141702','51552037806','43846001801','42421052815','762140052','023155219','115237291','250210405','38396040325','041163013','11701083415','62991116902','12866018902','437420511','063323406','049349988','449110034','021749607','557144589','505800433','021695037','61553012609','557144574','00406158253','61957090801','51927113800','50924088250','049643371','415953022','13537040405','066869147','042507234','24840150402','64117029302','35000062523','030142251','050390113','068428063','037000690','068026525','065841695','53276105004','425460812','51927307200','049349745','83490044068','76439027430','438570400','15631052101','055700002','043345002','62991115101','042593001','51688621002','042291310','052544210','62991304303','62106880204','43269090416','691900322','043269823','52685037230','437420019','684720102','42421061315','596670039','037808720','041163809','13537064310','515230661','62713081101','064990605','761470221','049726036','055315731','054575182','51927101000','24562000130','046672138','649421346','70074055967','631870890','10356082525','51552084502','694240170','66343003050','051523021','690080017','698420233','15631046704','010056700','00009091101','301420922','50845010902','00338935737','068703112','51552045504','065084442','076250110','51552081103','044924016','617270310','24840171101','049726015','053807515','061314646','08373081310','60512907708','605054643','037000085','067046224','066993413','025021130','89134074002','449110319','065162672','049643416','016729123','54022100801','426270229','00182142923','24840151101','69761002030','15631015905','10135012501','641170963','13537070702','493490684','61553031370','046122204','762140056','76485103101','492150006','24200025710','492880762','15631061505','105780051','027293017','51523011602','499670906','047682808','438460016','51552004505','37012072611','62991136501','051345111','49288058405','34834000301','068382701','003630017','051009107','31645017102','585180020','068084359','063517016','61553045875','684280288','51552078502','51927281100','49738037262','042291375','049643388','021695606','584110263','00590001571','049781022','10096031901','60764000501','474690190','049348100','49288061605','616570952','22840010107','045802368','55714229301','51552063004','584790038','764721134','61867010152','684280669','67181021630','64762087130','557144607','49288058605','11701088561','063941002','51552115807','00223807250','061578204','13537014801','54416000404','76354062901','14783025004','65371005101','61553052569','249090901','58411022630','050242018','449110285','068462461','49452112003','15631060902','59535590101','595357301','38779225900','50184700001','041250080','60858031603','51389010101','00409420101','60681540501','059924001','51927301800','61500552701','683820513','529930110','15631025000','50428889379','15631000202','504030050','00395263794','062713921','712170008','063304779','513460419','068016222','229550012','055289334','061245153','010544278','050988232','49022037209','042731012','70105000205','035356216','053057001','012634969','617220275','635450644','437420166','08026020016','00642007908','030142306','48951400903','000235738','021695033','501141164','69998008001','035356965','672250421','52685036730','32671020201','00178030103','437420104','51927164300','49452609003','688280082','63354088057','49452692103','498170016','050419344','500510014','067692361','52268050101','49288057603','63868062250','633540992','981320184','15631006103','576870284','011673390','13537099903','51688988702','57955616202','577080888','461220400','00074795113','054575420','049738394','055111423','489518164','89269045426','58443015104','52372085603','049035525','582320045','575200179','00904437560','573370091','24200009010','059779922','055910068','705180764','033261904','08214035721','065121682','24463000005','55926001802','702650120','059779339','434190506','66277032204','030142160','115237398','42546002510','58443021404','518857500','10223030301','526850381','53645107001','707711020','10096020102','033261545','11026303003','51927306400','156310330','712520080','08617192104','579556205','052125327','08522000061','43857032201','50419034210','00395063516','233590100','515140213','055111321','15631026205','62991170105','15631036704','051009197','54575029602','136300026','49288000705','51552015104','700601502','00074962805','63286140103','584430243','049643346','055111208','067046282','688280100','043063118','068647112','051012001','61601119508','016590815','38779128108','62778026501','15631013103','684280902','63354009316','76509015202','43858013020','041520199','710760003','055289969','579556162','025021122','55714446201','579552800','51552067407','62991200103','049349367','011410201','050804630','54973295802','51552131501','50114011006','036800825','066993053','15631063602','115237303','036800115','51552046402','584110271','641170198','713930008','49452622104','043063195','62991293403','046123017','694230119','670460008','08287126300','50260080001','050438303','64117012901','060429041','51927218200','62257022113','62157022801','38779023003','15631235801','29965019910','024236262','066758043','53499357202','50428150745','11098050305','688280201','551380001','51688938702','00074811715','60512802506','059427110','00074794102','677720018','021695576','037000732','544730238','437420179','65643041508','00094004606','050268660','17191042601','049348992','47784009630','55714459301','049873402','066479582','053329169','010019955','68758000901','627951115','52372078002','050383018','55714225301','52372086702','62802014708','691521223','400460066','147830875','068084659','08373561600','063481698','672250523','449110063','706190010','586680351','61059007517','023155029','69597000331','14783087715','037808180','58443009204','698940210','500901583','51927211900','619570909','42627026402','544730230','42406000400','013668021','037808020','033261831','11559072401','066993461','69424035001','061578302','041250065','15631055303','049349430','049781055','08590010300','00381009630','641597089','052747902','686470167','000743275','699980090','51552098204','041190647','63941081043','051346032','52731703302','063717910','40337000740','059779912','57955002002','00019095415','51688843802','047593381','13537063114','690390207','049999818','492880931','049349034','052959694','14783086102','049349999','501146150','049349957','48951123503','684280688','670460920','156310566','449110309','51688964702','551330040','065862637','67345078300','515230262','15631058602','412500269','066915413','56151086301','434190032','557144599','24200020113','066184135','00548654812','156310120','51129435602','15631060104','527317018','010167200','055111119','48107004911','057896381','15631057804','51688628902','758471704','65857030030','14783030105','66854001602','477810597','52670055130','61553091148','559100841','47144005509','021130742','38779003408','694990004','599580240','690510201','041250525','49575000407','021695759','00395268501','00573190024','48951820302','763943811','075870003','52731700101','38779007105','108120013','08214025740','068391479','055319169','63629172702','00026650330','62991303802','698460110','08881202389','049349537','425080532','042377001','492880682','61553088248','68428016001','016864001','013537428','48951307307','068400203','052183359','43455001900','49452244902','063777214','049348543','68745107002','075854309','528540531','54087032518','021130950','08080322200','43744055755','15631231700','49452278002','00363903111','51688981602','062584612','054235205','691032550','00440801190','053942406','489518260','40032003001','42627020301','32671000503','57627013202','68703008859','51346020701','065162415','53885044801','10348000601','041250884','43853000802','57955603002','51688942202','42851005545','049967332','61722027700','44911003201','066336055','068382205','687452086','653640222','00067079570','13537041614','489511279','030142818','659660015','694230126','043063270','701080005','98716060130','63732200604','51927263300','065862015','13537049901','93815099695','068647130','60816254001','037205009','48951408502','107426757','15631052605','137330016','00074799803','438570079','55714222700','15631054605','049520301','761195307','697770100','513460442','713800005','62106701204','058593286','38779212504','076282225','61919081572','51688624802','055648967','067046127','00314068570','002200785','437420941','34666006060','46584041120','15631067806','033261876','61957108001','526860234','016110111','492880940','370000696','58668067901','10939055944','058633233','11026275509','042291721','024385307','51688627202','13925011990','687451154','51645074201','58411013610','526860315','030142224','981320670','13537087103','054218500','037000263','11822151150','60681180202','08326300001','68703008459','15631022603','212200125','619572503','059262241','63713004434','50600054326','52372646401','24200028980','68745204401','137340110','062175128','62106112808','68479031301','62106724504','15631046900','24200029264','055289394','50728051002','521641104','063824283','51414020012','11559001202','067877268','51688976602','052982101','098132123','061314631','69231000202','136300048','057287100','37000090630','70163000101','679382002','15631003601','692880002','052125127','00363608002','002204622','639410332','00019133321','059779411','042637811','58930005101','059726211','648090105','86035000501','709050011','691521065','067457419','51927295800','609050022','055315238','70017002001','57520047901','108120042','49288069403','036800990','54118710902','704650005','15631054601','00024077702','501810034','50865068978','764200641','013537342','51688968502','059970174','680714039','75854030190','14783095401','981320709','063739484','108120701','049349944','057237011','016729035','043269876','055316656','053590104','15631005300','15631238003','60512645201','24840113401','55553043702','15631047002','696210394','055670130','52318000204','47884018950','08290324909','049671001','700000255','46122012078','052533002','38779058608','68647020310','052083233','49452259103','068001177','052959132','13537002704','62032016010','156312352','36987001502','064117156','51414060004','449110204','424060019','62991290801','047066402','15631022001','135370885','70321000201','062337415','48951827302','49972000609','079596097','035356748','549130001','434190365','437420985','15631052303','48951804601','10939059011','586682691','58414873001','004720310','59886034966','55714230800','051852101','15631044200','528100217','43742078201','051079879','10130002328','51688610502','059702661','531570121','68455010758','68033010704','525330059','58912100101','024208353','81317090630','011673054','37000026840','063824353','08080732000','641170263','14783084502','438570163','346660002','08567509387','49288078203','066220207','048883005','041520422','065862166','68428016501','010544215','670460453','449110150','680711621','37945086806','055292911','055289054','55714435900','38415002501','037000290','639410951','584110141','513934006','49452246502','016714383','068405002','041250521','615891823','057469011','059158719','063304539','575200560','00074163601','049884043','17191072520','610160002','041250449','92771077208','059640024','13537015137','15631237807','015127874','063304505','031382898','15631027202','055390809','061336001','62991283504','035356843','059779574','533890573','58518001001','51346025301','042192712','055264007','64778123201','08290309606','49967051601','063739113','694230004','24840130102','981320220','053746511','08290381434','15631058606','035356668','043538240','635500192','437420634','15631042402','058404002','668540011','680714099','48951917003','050111482','067457431','016590579','584110327','52372085302','61553011909','021695726','156310662','621061322','49022047627','64578008001','508130003','24200095149','008139616','00245021460','060760054','684790009','526850335','055910291','53660000333','15631054207','43419052731','50845010402','076074153','00005436556','68807030601','076314001','15631055605','055289095','489518193','035356590','52372731501','010631278','61589184001','60258019701','545320017','54569381001','041250094','57687023920','61531010001','00407141108','339920612','49452315602','051346127','001137915','57520051301','498170070','699240027','64942140201','010544265','489519034','38779056604','684280535','049349255','759360115','69439400101','50181004801','00019132352','43846005901','053208414','052183375','053341515','037808400','035356542','15631038301','51552066301','62991304001','15631019905','63868062060','680260112','156310327','10939012033','49817006101','15631060301','15631052305','065862449','536451161','024236254','021695735','684280348','055621004','526850442','62991271503','063940614','052125553','66277025306','064893802','707711089','45802060440','51769089050','051346176','758572153','605126613','049483242','061715054','61601112609','51688506102','49288066903','31645015001','52685038210','50419018846','500480015','89123700164','619570800','063776370','52769088022','076067100','69038000400','51621008701','010893600','068453993','694240100','68115063713','058593780','575200244','641170954','098132714','010812819','66579004901','621067139','43458100409','59535013101','15631008702','60432008316','526860266','55910035434','24208039183','64942131402','57955831501','08137004267','579550142','010812344','042254015','14783004962','067692000','370000765','700000314','064141916','70321000301','052125731','00548635100','705180678','58668286101','58411025850','108120228','538520002','713300104','583705001','035356770','15631031104','10237081010','010812422','051270115','649421112','61010560102','059779208','49817008801','606818001','037012160','98132090302','039765007','049738974','049999050','068084005','489514121','66854000401','064720328','055670143','714900039','52372077601','14783084901','57599881401','50685000501','701980102','051706504','590780115','699260008','51688649402','156310090','013925507','00270131535','010678011','691521559','64942101006','63275997401','021695894','65044286302','00259030320','49288000804','057664141','489517000','670460807','51060005701','068084443','62991301901','68472006001','15631003905','16514022902','606815404','041163415','13537067502','519181002','016590198','68828023002','063029102','496931101','38779052605','066116434','063304791','049643342','035356656','489511264','758540311','065862113','63323029297','40565011873','052125496','64942133103','057664634','64578009201','064117233','51927169000','63370000550','49288065502','173120032','014783101','00009029703','100560700','021130384','51060003101','055390208','052125334','063304192','438570212','670460929','98132013001','701180002','51688643402','08881882712','43596002000','002209313','641170987','627424079','52372600305','28691250102','67938205901','054473222','156310213','495270009','016590595','041520129','684280410','52372767610','051346187','42632001818','00395030396','675100082','61763022472','58914080244','614800124','062584781','08970100864','15631016203','52686026410','59779003701','22840001709','52533011648','630490105','052685351','011673922','055651025','62362012902','08290005540','51552118701','60905004502','051706507','44911012601','201510074','00381019902','62742404801','055111623','61957033001','00074794507','62106877504','67777023501','59555010608','063029700','61553074803','51698024410','036800310','062756826','135370612','449110072','62080180101','62839081101','068462425','70380025001','61589185701','036800044','043269868','100960188','68745113202','055648154','54702050151','51552109102','068084201','670460123','049035913','61924019908','025225022','049643359','690580200','037205381','066487001','49452046003','81317085001','649420689','43419054583','61553001320','62106115508','076074143','059779010','061139513','66184049002','587370118','66738070101','049884678','698940320','61077012133','41405131850','021749415','068604231','48951901502','51552117101','00409239105','068428155','57955027802','76105052501','68455010260','052183383','042507595','15631023903','38779040308','249590001','70805000701','010237646','679381074','13925012860','042291305','052686300','62381762301','48951701201','15631033402','08290491001','48951701602','38779034104','052125190','51688647902','544730269','68654058503','055648171','016590018','472190203','068828158','48883000411','024385357','526850449','51688423906','64616009302','060927115','556920010','15631231103','532410010','49669162301','059779494','11523705401','58016073160','498110001','492880864','691570025','22431035902','08290001025','049035558','66318041227','11822205390','098132885','62991111303','64117023102','75874082002','135370439','075983495','15631006701','052959119','605126558','665592978','068084603','698420151','764721128','528100206','61553072303','64942121902','55926001502','060913999','066184437','65342000300','055390010','043074115','120270104','037808688','688280055','033261770','59762503702','64942130102','35000086814','15631058401','57520062001','497150003','002647644','497810057','010685697','15631063106','22840003006','063739447','013537533','00409606211','709370104','68828006102','11822330300','687030289','438570322','51927279000','00074113321','489511182','66647614711','575200232','64942136001','584148725','010370176','51552121801','51785044501','056062798','17228085904','42627021101','011559039','15631038202','00173321113','51552121301','63533022107','59555010510','10019001501','649800368','068001118','63370009035','715780004','62778026403','000235703','559260011','64117053401','052862003','49452792402','066129210','030142249','055301210','58826070733','010812350','059115088','606815403','052959902','627424081','013537254','48582000520','449110120','55714453802','49614061252','052685465','49967006501','526850351','51552068204','021130826','156310110','49452690001','68455010482','698420130','135370638','068345620','017089416','076420527','76439034710','437420850','13630010104','62106106202','00007314304','17204009650','08290001319','48951400201','010544001','62991157102','67938206903','90891026415','061715055','041616882','049035823','049738829','035356786','575200653','54973295603','00024141480','37000072645','51688509102','50428846387','053145040','547540101','31645017302','000199120','52533020539','670460420','068828096','00220904642','442243300','08462555095','49967065101','61919091921','58597824206','449462005','44911002701','51552021606','005271669','058605151','63275998308','041190987','40565012159','37000074973','055319534','062756538','108120347','014783045','64942114202','049643437','076358195','021695139','43857035201','600550623','55714170200','670460469','062584746','438580112','52533012461','57627012302','38779257508','00193739301','13537069723','36000032519','043269693','024571113','614800137','00573190151','63370090515','43857022301','54162080008','68209095204','15631069307','641170992','70341034001','58668110301','605120004','049999631','00093727401','054365200','76300038501','021130092','057627138','00338634803','010812336','38779263804','42508026509','63275997904','597621808','062175310','43857022101','52731700202','051769888','013537355','108420200','694230199','62991216004','489518088','076378012','068084413','055312145','437420200','70506012001','049999476','00363606002','38396040505','61957040301','94688001555','10742845801','528540500','437420375','516680509','50600051462','496430501','981320217','584430022','42851005721','52372079003','70074062688','579555515','68745115404','51688950302','047682017','00395043101','712610006','049349224','051079195','61703035991','51927322700','002209070','48951207802','62991285001','467080249','69288000101','38703010080','49452653002','63370010435','54118797602','68647011210','016729219','010812332','024385028','013537036','426270207','013551701','052584931','62257051213','510600106','135370015','62991149901','68405101301','301420576','059735100','10237090210','549733107','042589001','679380826','51688613302','64942113101','00047200922','70074051741','037000092','63275996902','61722006400','69494040410','712200003','068428053','64942118802','51552010308','415200312','62157007801','597460735','60512803606','51759000206','697390120','68702072436','49452601001','54629059606','067457478','42069000101','70574000101','041163NEW','076157347','135370671','50181003301','51552008206','00574003016','052747620','003639031','023710035','00363911303','060949050','16500055016','51927211800','068084588','69424009001','62991206804','135370983','69049000801','108930220','61763020709','66977001410','068382177','61553014848','521660002','15631237402','08484990432','052244450','056062489','068084638','010849001','51688955302','43857036701','37205055872','51927270200','13533064612','65342000200','04351079810','698940100','047682247','08214065714','068047186','063323280','690380038','704701408','42632002828','10812034401','052685435','42192033330','76015090001','010370169','702650050','08327051089','69881092240','66184043602','51688631302','15631008001','08290383520','049795416','704450271','64679075905','010237816','52372080603','08462005110','057664419','08214085054','043269803','037000053','10812040001','061387249','14783087001','059779373','555600109','00268027130','059746233','61118080755','147830815','156310251','49884087705','51552004809','61553019448','62172030918','57520104301','08326281102','045802237','059958202','684280084','55143010801','60914000102','438611013','38703000435','10096936301','48951813905','00223789402','08026483100','055319033','049035565','059779188','049349193','060793604','059630911','678770499','70810000101','68703000880','63830022127','108890113','08884437100','006995720','042507002','08214046533','066949875','516210038','068084085','55714151300','38703002464','021130553','15631000304','00220903316','489517046','59260013509','68455010259','060429061','64117012002','55714458801','22840000604','076214044','62991269903','70074062569','037205834','532620001','90891024822','068382095','037000849','680713179','049643316','49288036402','041520475','031722529','370000080','057627157','50845007401','062257367','021130054','064092109','067544302','15631070500','64942129501','021130080','49035022201','69278010601','62991289401','10812042601','51927229800','052007140','066949878','52152050603','438570337','61553031072','13703010152','694230112','62991119901','15631052502','060429234','49288036401','594690170','66647403525','48951907801','052125582','08080712200','068016143','36000021719','052959428','049035175','049349966','24571011605','064893500','002204178','053057010','067253191','48951200402','15631056500','64117053402','51927107600','063981478','066220729','61059014515','64616009102','68745201803','075866307','49967086301','57955601102','624000033','43742070401','557144464','13537055601','055312235','00019666391','51688616102','633540825','13537037001','48951503701','063941072','705180646','063824274','065162538','48951201601','15631055204','11845122305','135370637','694240250','62106105102','24200000204','021695192','62991254202','52533016075','55714641701','49452657002','13734010563','37803273907','51346031801','15631024000','049349391','10191193702','684050070','051079190','44911022901','41520084543','553190013','15631063001','38779199908','64942117902','51688616402','10481301316','051060025','51552077306','54973106806','575200226','68455010402','063354031','011673532','13537024108','68455010695','633040193','064597301','046123035','536451210','033342075','13537033502','051079942','029300135','59672073202','64578013001','513460129','00118998806','52304071850','135370035','49288992404','00113080701','68428005501','014783473','15631026905','641170274','48951822203','53499509008','694610002','062802148','00074187668','689980950','026637321','05632084030','00074018810','15631028500','051079692','108120966','620820100','00270014955','066993408','649420786','036800210','680714066','135370738','703490013','421920341','48951206201','60565015001','064272736','051285040','068462498','036800438','049483334','064679975','037808532','11523718301','052544048','61589531101','649421282','54973602003','704840005','556182006','08380015402','60512615401','69945088707','499670246','489514011','58597809506','55910060204','11822900106','049999081','057664175','08380079540','08333359001','49836074001','049884214','00074462002','15631235203','57520016001','699680299','68405800306','036800258','11701082010','690490009','043547275','050390109','437720044','575200610','068428058','61924017816','62991286302','51927273300','437420742','92450040802','64942115102','043386510','42361000701','51927151000','66915060801','059572503','586685961','044523568','042507141','437420833','551380004','08290305915','00338002312','49452317601','068012102','147830891','691520049','50428369087','594690131','043419303','492300200','016590372','58232031701','438460004','490350143','68428014101','684280872','981320179','68428074114','156310407','24385026171','400460050','438570234','55714800801','649421372','69779002401','059779410','49452214101','035418801','08380003722','042291699','041520189','587370170','052544162','010526003','66184050502','040092500','062756432','101911569','052533104','08326281002','63732200206','15631019105','51414020011','52124011701','38415042401','47219025110','51552090207','57771005001','14783095501','114100802','437420299','068084181','050523567','595350215','068828133','15631041201','51552030404','49452111504','63730017105','052682024','557000558','060764007','69423002373','27281000796','13537094801','15630101220','64117020702','57520007901','013668030','500300003','11701080720','65923049214','38779015305','059779483','68225001501','008690789','92771067614','635170452','38396031114','49022014372','62157010601','56151030101','684280130','57955500202','037012379','579550145','15631065406','00482013013','002201613','00270082125','57691000242','057664345','067046430','24840157001','51688507602','703410110','021695794','412500026','15631011805','15631067202','38779248907','052427285','00641670924','691060280','51552064304','136300053','135370212','054473212','052584021','64117060001','021695548','44946104509','005170234','104240161','62032012590','69423008910','49452641002','500510015','11701083710','057664242','61553011961','051138058','51552128806','434190602','076063773','94046000158','030142590','51552024405','38779007104','64942117103','24200043504','60564000101','69038004430','51927364500','51688526002','013537532','62991170101','066336135','37803121908','48951103503','68455010913','55714449301','52686022310','621064838','575200636','066116316','37000011973','045802989','136300078','042637810','61957220001','10237075916','61957090101','065862549','049884009','049035357','059779369','060899100','51688939602','449462006','49452779003','551543915','052389166','579555149','62991203701','301420410','042794018','549736436','370000112','00024141251','052125037','08080631000','036800066','53329011112','017089304','08290309659','500903130','098132158','54575096330','41250043945','38779086907','059726530','065841067','437420256','51801000340','449110171','43742017801','479930240','045802952','049852162','043419601','59158076001','66343001150','68479023000','15631010805','068025056','53885079750','060429018','051079379','75839013300','013537308','62795103602','00065915272','42248012902','37803180002','051523026','15631030500','156310023','449110252','694230143','437420684','50114112404','08380003749','49893030001','049349658','019392100','055143102','69256033416','13774013741','680260128','15631062102','94688001770','15631016702','053329826','053389200','575200701','066908532','013537354','115237061','67871000710','16500055008','068669522','61553035379','762600103','052125594','076260104','25121000602','13537002604','49967024301','08373975100','00053748610','052544733','44911032201','060927116','65044084201','068382189','633540921','067046742','054622389','70074056278','557144472','36000012856','15631038405','10939097433','64117011002','48951314002','38779002201','056062516','51552012704','00074118501','687451153','00074226651','67510008305','36000019183','704140105','08290301603','041190072','586682841','534991371','057472004','65966001701','605128018','66472003701','058892721','049527022','51346000201','68828023101','703410450','758571100','052584796','060760130','61553086648','57955016202','51709000503','489519219','063717326','049999969','51688505602','763310807','08080127012','66096018206','494040104','44911029001','43742073301','62991290303','64117098202','042507298','438570325','061703362','42627020501','38779068704','552640102','69676002101','62257060713','57515009315','052685325','059630480','060429021','15631069407','051660035','49452164002','55714446601','489517107','61919058360','500900430','39822509005','441180800','08970705018','497810112','057627167','606870340','57955031902','08380009343','10678000503','317200702','38779783102','00096074104','050988197','51131566552','042507368','055390052','533290092','068570812','51927169300','024653800','010631099','40185077100','49614000012','696280010','43857029101','10130025301','00019133310','048102012','490350898','24200011510','688280075','50051000904','24840157002','49348065112','064024969','691520509','055390077','15631006204','045802050','41250039606','62257051228','437420586','449110125','11523738401','62991112005','625870119','064678211','016714532','055648312','44911035801','023155111','548600060','055910325','063739805','43419002004','64024096903','10939073811','08567509382','024236809','639720008','063621356','51927362300','12843054120','041163016','49967015901','10158009708','51688936102','64380002110','050242061','151270004','057525016','00212358151','43742035501','136300058','54087030252','041250393','80040052070','712760110','532080442','052686287','066184490','65447037600','53885014301','15377000801','57520028004','716920001','605128002','050078101','370000178','15631000604','08380003763','055390171','08380097541','435980539','00087146645','013537215','00024141310','00074117102','51927122500','62296786604','90891024616','62991207102','013537124','37000090930','007813440','54973310702','13537070602','557144538','17630202101','068084577','035000701','48951920401','44911023401','13537007117','697160090','70172001030','61924019901','51688619402','033261013','108120435','472021402','76354071501','061827056','049972002','495570576','43742003801','50546071010','49614025787','043374575','64942134603','622170029','047335330','060913008','596670082','62991413302','060793855','66647611800','052982100','437420490','24200204053','056104008','513460244','532080524','62991202401','62157005801','526860341','59667003002','47469018001','515140323','316450198','00193222920','48951300405','049349130','068001204','00074490023','38396031225','61553025436','67555015430','050419253','575200265','68703009459','15631015500','024471200','052686262','69888010502','068084159','15631023101','15631001005','055390373','051060010','15631008801','42508015102','00418208230','69811010311','81317071400','049999797','067544581','606810102','43319006001','55714231400','043419859','41318071768','00517701025','716190130','00015722699','51688519602','515230026','75847300101','057664370','068391175','15631046901','15631069201','42361003801','049999180','66277032201','76354071701','62991129301','037012527','683270054','15631039505','654470050','15631045000','43742076701','08395081505','59535380101','08080800480','62991291603','13537031902','67345608800','58232992801','049035559','684280294','08380003892','64942134301','056062467','61553021602','68828006702','50865021341','068084525','43857023101','049349110','065862470','041250124','016590301','586681621','062750054','43269088601','50114801504','61481300201','042254268','575200374','068084536','490350252','575200137','15631053007','713460020','068703002','045802032','068180412','661840420','63713105220','030142289','055133040','688280066','00015797096','037205369','49967059901','00338930972','053389130','58411016630','52372073501','137340147','61059059036','053462502','036800468','38779191308','54575094902','065841750','08380003669','00409238505','00026056464','65342100400','41595700901','38779088705','38703000150','00338938348','700760201','010056872','57243081043','37000084001','694230201','521641109','61553027723','489519079','610960022','51552005906','67172021231','10096929801','499720006','15631067504','35356037990','11822318800','54575092830','61096101201','37000072917','13537089037','61657095601','042507409','049349773','50924088110','103450022','49452084901','61553030628','41520086924','526640004','66915061019','50845020502','76485106101','51927157100','661840455','60512901109','50419032511','684280417','661840115','646160093','016714386','62991127803','00839656506','00703535703','56151021601','43689000702','66647237320','016590119','076366001','031645165','13925050910','059726470','26974041081','61553006003','37012084543','714720090','51688503702','063824344','684280653','495270013','052125172','033261798','055111557','00067208320','57145000282','52372089104','059779524','00003131604','64942141102','10542001010','51552036001','061715045','048417712','75854030330','69894032001','08380008631','43526010601','619571018','41735003771','05632084035','57520022401','055316063','044873002','065862007','035356891','135370937','055711064','15631006905','61734009102','68428000514','31720050216','054575092','76369500101','08290002151','54973310902','52854003001','492880830','063323426','54859051530','15082025182','13537061424','51552084107','55714455402','576870272','530281001','08522000026','622953014','156310279','15631030100','066908107','054305802','702810214','076214028','57520111101','00074583301','15631021105','68828018102','043063479','110860152','068382008','51552112308','10135010102','680713363','41163402205','54868324301','15631029102','049884085','049349870','51367001058','049349752','009426492','067046714','10210000201','147830824','49452384501','37803273504','49452312002','38396042037','90962062013','579557225','400280512','014783226','42421081511','49726000202','49972000615','64942101401','10797026104','115237349','021695265','00003131440','135370676','076237106','08522000014','08380014906','10424015640','84389011249','16042001045','515230173','047593506','55714462702','139920005','059746175','51523047537','15631062501','054295302','055289389','035356339','51552122905','400460037','052125399','042627201','67879030411','52544020499','50600051776','68647019710','076378015','108930350','680711814','24200111810','041250546','37000091419','25121000203','14783081002','615437515','158280106','051079436','57955556602','69926000401','696760071','057237054','064117980','00407141497','66184044502','489513048','49452641001','63044015001','49735017794','62032015099','627424053','50051001704','00220904508','11559074601','042291526','00490706703','67228025203','694391001','47884017602','49735018328','051138063','42421064111','08290301029','49288087003','51552077501','63730039106','00074245327','067777244','549732927','016590178','51927433900','370000711','52685030230','010889100','052125601','037205969','016714370','48951306401','64117014002','08380009782','48951813102','401040283','49452453001','38779008207','102370833','009241805','489517068','062037862','75887000303','13537062502','46144044401','61553023457','042507274','049349296','434190742','38779000609','38779027508','49817006002','557893106','513460382','66184010001','08380014604','437420342','010702008','58016084040','43419038628','489511231','032909728','08380019252','62802010206','57955127002','70170000401','513460208','54602001105','00074154002','49967058303','576910585','15631005102','51927357300','249090203','51927912700','43744055762','57472000604','684720075','44911020301','011673124','52686027380','045124001','47887018600','10191100502','516210122','62991112203','437420864','64942120601','052000008','052125509','065162554','041190255','51346000401','08567529937','50419034415','557144571','81317082020','60512103901','499670392','50419019510','15631237000','715960028','65954006048','08333152501','13537095704','49452464504','68327001102','52372082003','631870876','068220140','049349118','00003140710','629900690','13537011931','10096026801','066490041','81317065000','526860299','049349639','55714457500','064117128','017478064','11673066316','15631059105','052125577','068472119','437420403','44911015301','10742898002','499670864','51927355500','063868132','49693100101','713800004','62991118202','59535143101','437420021','758660306','15631060003','042808100','068084345','50428217083','059746306','08884711501','13537003201','147830020','036800461','075921469','500900255','068453825','041250478','063783008','11410005329','021695231','067692339','08214057716','00085460402','69103253305','58411019860','047593279','054473109','064376803','62991135901','50600052285','55714426902','062584266','027505004','65044117005','526860325','37000027085','645780087','694230009','10939058701','049349739','41595551502','61553034009','076237252','50845004601','068703097','578843002','49967027201','55714800901','46584069163','010812008','61553020261','068645443','526850399','68745109501','50924007920','055910456','70602000201','024208315','694230176','52125017902','60512000606','08380003184','67938010501','049999292','49452440702','051769124','627424060','51479001701','052183289','156310590','679381472','00517037510','684280040','15631054003','055390404','135370622','057896793','86679024899','08380097941','62106113008','53885000775','64117081002','683430003','025000140','57515025110','412500000','058406435','065162513','24200029404','147830093','072036069','109670100','57520054501','51552007906','505550020','51927152800','67938205101','030142122','00551015003','40046007301','54973062504','62106711004','51688621902','08026989300','051769980','44911016701','438460028','044019002','010812128','055316588','022700127','14783020625','003600043','68828015012','378080898','40046005501','70506014001','68745114102','11701088651','61252300602','013537415','51824002202','052125162','55714200304','11822300700','061767002','13537050102','017156235','15631033603','050988252','054458887','100190631','24445033430','16169006003','60681210701','64117055302','98302013941','08380014702','068624001','054575179','043063418','101911562','69676002601','614810037','059779055','52372083003','69423004573','043419512','029300125','66647248221','52372075201','22955001220','59779020802','617220140','011673811','044206439','38779012901','764721152','69946002001','08214030725','068645470','49557057627','48951117103','696210343','67226214506','049571002','011980180','43857003001','64370308602','065923559','58443006902','055289932','370000361','064117264','08080896710','584180786','00642007812','51927247700','037205625','15631029705','42627020102','55714170901','13537034302','00264165600','432690903','042508255','575200206','055111729','00186101013','51129421001','051660352','38779064406','66579002302','66318041475','10337040030','38779009108','050967620','51552030706','035356677','030142381','011559769','08373074200','015370033','61062000601','063777217','08592000130','684720138','15630100210','068382065','31645016702','69713002150','85017000001','62041004001','00364301558','055111145','579552708','619570906','49452344001','67684200005','62542077500','68455011460','68828040002','68703010759','11845070801','00469750030','41405530801','50428212266','62991107402','630290721','605126448','051346105','51552015406','15631037900','042858003','08619050206','156310291','38779070505','021695850','142222265','135370022','76472114501','516210071','051079960','08290370200','43419000213','15631039001','15631033902','51927169900','489512015','763540717','498170088','14783025602','050458307','549733316','16958068458','051439001','38779104608','068703119','489518272','08380003837','010736009','08380003843','64942117201','13734002540','61601113406','65044286204','08617164444','688280156','56151021001','08881540166','708790752','17191000051','051079622','492880917','063323127','00641240241','708670102','543400702','035356758','010337434','049738369','411670470','53208037402','513460133','11701003132','43742005301','680260103','49726001704','43742021401','656920303','38779006305','38396032970','58607032600','43742006001','08565016915','08137115314','037000557','38779088408','575200157','582320748','042783111','08011961016','052685404','035000847','55714232600','694230121','00009258691','08290001104','15631001805','628390125','049643349','060782000','068628500','068462435','489511117','13537024904','69990010001','758471701','51346010301','58443004304','063667923','22201200101','38415001129','49452003002','23710000110','52533004824','08496310401','065923561','30142065534','496931601','45183074204','065862211','52731700102','058238229','438460064','15631064405','043063401','13533064624','000090920','504410005','61553062648','62032012190','049738374','08080357500','489517054','068084393','08080714250','38396040202','660960686','023155065','617150025','244530200','068180844','028595800','035356927','58503004201','99073070822','170890406','64117018301','068645466','042508150','037012733','62991409901','044873005','449110353','08970605003','16364011505','525330198','55918000120','69017030102','13537098624','054575169','51688521406','68225002201','011527161','035356272','301420803','55553046802','37803141003','656430173','63370014010','016729114','010812814','024653271','11822086101','499670489','492880784','013734111','557146283','694230139','042192115','607090105','679382051','054575123','00555111707','052533161','037808541','61722014000','003951211','592620363','57955081503','38779170008','51927104300','398920304','060193100','051445101','61589184901','055289786','00019133351','068105004','68479090004','103560327','08222710017','15631056202','50428337097','006420120','616010082','030142006','067046663','557144551','08080818101','058930043','156312454','049349104','00369330511','58668506101','051079578','499670428','08567509388','617270401','043269725','59707012901','15631018800','715820001','680260108','00642009230','063824122','694230187','61553001473','051079667','014783140','64117098702','15631006302','021695670','48951918403','57955015802','64942128502','684280957','573370042','438570141','549737510','36987001803','00019132487','08489714220','61118086025','08380014803','08080281900','67938073202','58067020010','00641514133','016729023','042291509','62713080602','69065000104','058111105','156310219','76329191105','40337000504','037000612','37000011725','063304461','61995020404','15631035803','042291609','100960215','64117015302','52686010660','69152059001','08333901120','14783001403','102370903','682588001','68026054140','43742024101','63354005118','00178089110','08463920350','59779005404','15631045002','51927111500','15631062200','035356798','022700133','66647600325','049643398','635450659','51927128700','703410360','08290305905','499670288','51414070004','08380008594','595350223','052125839','68455011172','068472135','059262362','00026654810','48883000401','38779236701','00209685622','684720121','761500139','065841057','068737233','033261218','64942068902','010578035','51414030002','64942132003','677870348','59781056623','67938111102','64942105202','060764001','64942112801','055910022','575200035','00179150305','055312310','492880772','70224001001','762140068','08214053501','764460004','08380014707','65342700105','51688996902','65729038402','513460404','068828078','060533002','043386060','62991269906','49452391705','62991127902','58016081728','051079759','622170174','061919031','43742020801','156310518','36000014242','55714445602','434190745','760490879','51688981202','61722020700','38779095609','00944048202','49288089003','064809105','08611505001','57515091004','059779006','136300025','49856008401','551547878','70716781302','15631023802','08222092199','62991280001','15631031502','052125400','058088001','641170264','595359301','64117010302','061625682','044237009','68428072614','11410074917','17630204401','61703034735','00409798530','068428111','69435160601','00096072216','61553008402','32909010510','51552122003','14783024807','764851030','055289872','15631050803','51552078001','053462308','017238610','08590001400','063739535','645780062','716110008','70074050457','68455011206','680260204','047781331','42632041009','54473024202','00004200378','013537190','37803042957','043269663','024338852','15631053305','38779031508','013107020','024882325','15631066903','08884474027','513460259','05632084040','764721150','627424067','064220421','066336581','055301852','068163709','063776385','15631005702','43857013201','51389025000','009426495','13734014780','38779131107','051138064','061387250','489519204','49527000101','065162659','049999846','58016084025','647620862','627951037','607811004','684720028','10345004501','024090496','035356913','035356298','08222094193','065862103','08611506101','76354020451','068428719','51927123300','54416000405','48951107303','31645016602','068400111','51630000301','76420022201','68455011318','001137456','08080103800','042961003','69106012001','53499597202','02120000302','055292303','037205539','049854001','54087030906','049643309','049999122','050844175','56151081350','49817005402','68745104301','108120524','70332010401','438460021','15631016103','62991299404','00186091566','501841040','557142288','08470046501','51927123000','69945005109','13537025502','576870275','44911003701','102370760','57520021201','435960013','13537098123','051285690','493580544','61722000600','060429195','64117015602','51552132305','021695425','496720100','15631237005','041520065','049035240','434060006','49452497002','002209075','068001160','699980070','545691660','61392040725','423150002','033261039','010544210','043538900','08380078501','055648924','147830872','583180004','69942005001','58466010804','08011420614','067046162','62794008564','605121033','52372078703','52372090905','51552089506','62991104006','003634009','49288022205','62778008202','15631040502','057337019','400460032','043063088','051444005','035356215','045802455','00074909332','049738002','684280916','438530010','049884561','076280197','55714171501','061077019','068084348','51927209200','49735011887','16129000110','42908007600','033261594','617220293','11523735001','412500939','062175710','055111730','69244000401','15631039402','429080072','61220000101','58607081120','348340001','50181000101','68472010601','505030002','118229016','017714135','51702011401','57520001801','54629205921','08881250024','068001229','510600051','49735012301','489518169','653210032','433330456','51552105601','62991110402','18011080690','62991253805','38779039503','011673912','10451000202','00641095523','63275302504','59911590802','693460101','15631057903','52796017312','68703004580','551180978','69968013302','15631063607','053045106','15631064601','101578008','098132171','350000701','65966011102','063354450','24200760104','063941411','54973310601','15631069801','516210081','025021111','52372600115','050222501','687030258','37000023315','049349582','11701010226','00019095312','11701080210','052568001','011673667','680260125','051009106','437420372','65781239610','10812010001','437420298','692690815','51688530602','37000072673','063981224','49452195001','060432140','15631057805','51552026706','010812973','370000357','584430025','508130007','042254074','00268065010','010073001','621061201','041520531','13537045601','053145047','38703010030','49735010026','051079516','63775070402','043063062','059970041','582320512','61601112909','708110001','036800590','050580324','60681270201','64117095702','438570463','08080647400','08333295501','64616005602','15631045505','024330410','41442013301','56151014260','62991201506','66318041110','156310354','438570370','024385141','62991203105','00074234401','63370097135','628020773','08380014303','135370367','24200025882','58016081704','00703485291','061509104','042281003','49452173001','051138045','030142822','59779045701','49452308001','156310650','437420304','704740101','712610001','57273000217','621068224','633470601','037205204','684280087','575200457','660510210','48951904805','011673020','035356844','08214535716','64942138804','067253320','67857080330','759130311','063824451','61763022680','00024158301','712200058','065121683','43526011601','013537430','068382398','61553014202','10135058610','055328900','628020107','669930576','00703800501','69219010313','70271042801','08026498900','033261546','59351033201','649421532','51301058316','100960233','057902817','455670040','042002447','430630795','00407141217','037205980','607640038','575200134','83490031062','10119003018','10578004390','08326290110','00942648702','10191190902','024236156','031645166','499670941','15631235106','449110147','68745104102','034666006','688280072','70074056649','68745115302','13537025203','012634111','67234004101','08290385100','557144407','64942101306','62991292703','575200210','46584041342','649421274','51386071000','518080210','51552026508','659540769','38779025609','694230031','649421120','33031000009','52486000430','08395078490','81317707900','62257093807','058160825','621068213','037012479','65923034925','55714442902','370000604','055648271','526850409','616570052','051079346','61553015448','57687027620','370000821','00363201301','49022033781','15631038800','054748203','50600053404','50419032512','004043099','067147221','533290674','08884732000','575200966','762140041','584660023','10356011130','13537080141','62991137803','08462556595','62106112408','691520089','55282200101','70465000501','62157014401','613800303','00641012323','054748301','59779005311','51621010302','15631034900','51927209100','049738205','052605122','064764254','055118610','437421008','08462554095','055289379','08080600320','145370967','48951902802','24200004104','065862361','00074117630','041520416','08380096144','711050303','64578007801','059779062','489514014','119940090','699680201','38779087509','017089389','067711001','591580760','15482011200','53305006501','59535310101','504360521','12090008202','24840110401','20146400801','49452611001','051346083','684720103','055111643','037205958','51552118901','53276105003','11701088693','13537034901','58914083008','51552003806','62106530104','764851059','15631058505','076436135','64942123201','15631064906','58411010250','15631068900','68745204901','15631031900','010237746','17089004620','621068367','51927300900','046122050','068084214','43857020201','068428062','24385022234','067979500','051079182','052347111','68702063202','068012495','89269045502','51688639802','590880805','58597855909','035000003','054092513','135370215','013537362','15082021582','10797023004','662670943','70764020152','53414010001','049035049','016714404','063667242','068330002','553010036','38779234101','063323162','058892356','15631063305','068462255','492150001','00065905080','634330200','52684002602','510960005','052959289','156310081','489516046','499670445','699680177','055111474','045802222','00220908104','043498100','14783032002','713010003','031720209','049348228','043353731','49452472705','370000790','115238003','606810801','38779255504','43526010101','00703846301','58930004401','50813001001','49452131301','498172016','00264112000','515140232','53499534900','054575126','55714222801','38779781402','584110113','81317031000','51927306200','11489008801','65044116804','052584026','76439035930','43742022401','08080822113','59667009202','08317761102','20513001001','58016048570','055910975','603191001','981320719','684280962','48951902001','58232004001','489517010','499670028','013537280','52584011539','41260034699','605120015','699460040','87701040465','15631054004','51552049805','050390703','49527001401','054340682','050523632','08290309572','021130104','063941153','08290007161','62107003628','068084613','060429313','449240114','00065906870','553010810','061715072','053389035','51927282500','69968012201','055111527','37000017826','57520035801','058194003','08881250545','762140053','052915040','11523722104','41442015201','10096031601','55961022420','068084099','54473025001','043386330','51552055204','076138202','527960174','51414010102','052553001','063459512','38779234107','716090001','62620700101','049884660','08395081470','684280427','695170143','036800552','021695439','063824213','075997028','250210803','11410010104','015310110','08380095164','55714457402','010544119','030142862','31190032030','103450048','679381397','00548103800','508450039','00074426601','15631046003','042549514','15631046302','685993502','068405098','013734105','50419018902','67938094901','52731700301','710411601','005731911','068047342','00019550510','492880667','55714455201','046122038','002209044','135370631','37000036373','049781043','15631021800','48951808602','63874053801','055289324','49452535001','068645310','35000070205','58479000200','76420022001','041520100','684280443','52372087501','08290309620','017714016','48951208201','60512710101','061715037','54031032401','59555010303','659540065','57627012902','708050003','059779923','579550382','066993405','17238020102','607640079','61553041658','38779009601','79596009811','764721145','81317050360','329090945','068645400','688070307','061703341','649421380','58869010101','62991289201','10782020160','77890012583','13537029436','041250047','49288020201','28691250001','15631014000','63323050574','556182005','067152001','35000086103','052296111','15631026202','035356503','64116002501','15631067006','61589531501','68647016910','021695453','037205679','036000045','244630013','12866018704','50428147524','70074050190','43742005401','38779004303','43900036508','055910117','024909145','52372080901','15631044505','557144566','664720042','684620325','433530580','513460359','156312453','51688640202','15631064804','52584026950','616010081','584430181','17191000738','51927135500','076237275','52372767601','00603254821','065841753','43900034958','649800357','055289112','696030401','49288085503','15631051503','063824320','029300114','10578011690','62991271401','00023570317','060760258','059834202','063304739','049035384','051334946','17191006300','508040826','492880702','060764002','066758015','370000121','62991412405','042508159','43857035001','51927148100','58228010104','49452781001','51927308200','37803203504','64942101303','50845007701','58411016120','52773024301','370000379','100960868','050563204','063645111','066096684','15631063206','68455010626','28465004501','51552111709','052083289','694230136','38779192308','14209058514','043353725','48107004946','38779273504','053057004','43900015194','51346031101','059115126','489511097','08521010310','50845023101','062584163','060429361','059640113','981320170','517690411','63433012222','065862147','51927189500','055289074','00067210015','50428587618','551430010','00418403001','10135022410','37000042047','030142998','08395041450','050268565','063323482','579557020','69761013701','37205005765','51552042602','47593048731','000960741','37000035350','041250224','69716002001','15631063101','08884424600','760530003','43857028901','438570224','447810170','65517000902','500900199','13537002802','62778004101','043063112','10812096001','412500412','49967057804','492880828','068682004','070253527','60512908504','041163002','621710070','13703010312','637300395','016590207','63868033102','52124116604','69269013170','49452196004','83268010505','14783020836','64117071802','66184040001','041442133','524860020','030142884','057664116','101911201','516210068','051079299','58443015404','63275410002','050405004','51688612902','48951318605','047593307','13537087919','68428013301','590880594','434190733','049349925','055150179','016252571','49757000201','697160210','68971000206','706943687','64942121901','050844292','58443018303','51552009805','49452213902','51552026406','55550010201','11793830102','68455010698','021695532','549732916','058411107','037808238','063395201','54629205911','04795061002','037205669','68327005701','08290328440','63029044402','100960304','68025004230','28785022100','49735012670','156310376','064121056','042281001','55586000022','05632083010','75990096827','69968018401','13537012201','050268455','067777001','51552005307','00234061500','684280523','498172019','067253461','412500155','55037030205','489516011','10356080125','54838021280','59958024001','684050188','08567509393','45749001781','10939058233','688280272','10237092240','51346031601','67345078700','684280252','51552039503','67777012010','49502020802','51927900900','489514111','57472000614','054340751','115590013','021695881','065162711','064117975','054092063','10939051844','063739452','699580010','013537039','687030033','49288092703','00273010603','110840089','009420641','435260102','60715509301','00024074810','13537063216','024909132','016590251','11822280140','70506010001','076237107','54973315801','066302325','00699572503','515314330','007813005','709600682','016252572','81317011600','13537062501','623320386','15631065003','50845022401','70074056369','14783094601','37000041911','60512615301','041250535','47202140201','61553012725','41415014777','76261012601','700601503','586681511','58503006401','033261867','62991261602','57955150402','08326290310','051009198','576870283','052125856','17191067425','58411022030','65044513805','434980101','062175486','156310045','15631035302','062713811','40046003201','63354020036','053208521','036800866','68455012341','08484990435','641170984','063029200','063739458','534997233','11701040685','15631002303','11701012503','21247000003','035356760','42937070510','703410030','041268302','08004041300','055289505','61392061765','64117097701','51688641502','08567509396','62991109506','52166000405','81317062200','59503260502','67345070300','055494100','63736099303','15631053805','449110397','51117000101','691520611','050111470','00395008916','011489073','513460482','68032027060','38779027805','62362013974','99073070792','049348019','435960039','052584414','15631066202','597790109','58364119604','63275996905','11098006105','69607000301','067172585','589300026','73796001160','516210112','052959204','036800489','055910913','15631025305','38779029804','38779033005','63354016361','67938206002','51688940102','109670644','694230010','684280978','063824020','49967022201','278540105','438570174','575200214','69779001101','24571011306','62991295703','51552041204','53303000209','691520034','00259012802','53873321104','068094852','53144300101','13537041002','076245220','063777130','062856243','52372078501','049349902','003100668','70148000101','61252300503','549731114','021695845','607640018','068026528','23490052603','00418652146','011489084','498172029','050268507','15630101415','059779474','51552039002','653421403','013537255','053145300','51927155700','64578014101','068737236','42352700101','66915060408','051523003','063776710','15631065100','043275170','115237189','15631044301','042291337','49514047216','605126188','15631056205','010678005','489518004','434190389','55714171300','065162542','621065134','13537001824','58597835208','049348983','058517040','15631037301','63275994909','013668102','641170129','370000306','68405101501','031722282','10742863701','54629033115','050988405','58016091830','58668411101','028107002','640240479','08080685001','051079529','156310440','700470006','051285124','370000207','680711594','15631004201','65364021236','00019095315','38779032404','691520527','693460006','764200260','68455010276','66647201042','147830836','15631023604','55714426702','51531748108','100960201','75862001850','49288043103','62180128601','13537031302','705540848','370000767','15631021004','050804167','51688521206','586686190','011344984','536451141','709200100','75847150101','15631056306','042508160','15631237301','579550165','523890608','52372084804','706190020','058411156','10019097002','052584019','08290328438','621067878','51927871600','055315560','001871721','38779083401','059779995','66012001513','981320747','054305676','052125366','062678206','64117021102','59535133101','684280328','059779882','55513082310','067618315','90891030030','37867088001','51552120109','64942112201','37803036808','49967002701','597790036','063304502','051079903','541110128','622060314','49452605303','518491250','51552085806','51552075704','698420120','437420364','15631237806','068382055','62991298104','532080377','037012482','00003069660','060193101','102100003','058930046','11822319060','65364021500','11463025001','584110188','010812961','11793880301','52372083902','605128036','062037560','50636000465','00019988909','003600163','00002163501','62991200505','38779031608','69366020610','22840000508','560620700','65044285801','049281400','15631061100','51927363800','557142350','702180030','38396070693','508450224','08380008747','51552035204','043498103','55714440301','049852172','055700019','62991406401','51552071209','41163040263','67938147001','27293003628','68405806836','15631018203','54629033110','51386070500','15631027300','10130023610','24840111202','61480012561','423610022','10742859801','036800337','156310340','649421208','13537034801','699680263','609050500','033261756','13537054201','489511055','58232980901','08290309603','39892090001','135370621','059779216','052125624','697160230','596670035','055319194','201510110','055315127','76261012701','15631047305','00039006908','51927319400','043353389','62257051210','619571001','010578027','51927328500','049035460','064893310','55714222402','758300001','43857015401','15631015900','10345002801','50580007348','57520065601','00268023930','15631050704','10096022403','64942089101','063941204','016714313','063783501','57520040901','605126456','062191010','51621008901','24840153201','525120161','049825134','035356817','595350207','610770137','15667739603','42406000900','13537024002','70074040718','011673958','649421548','036800609','69969001101','51552010804','147830032','70238070201','055111118','663430029','38779111502','063287211','063029622','17518000201','13630008903','136300102','62991282401','049349772','48951401003','063323383','051346175','53057000601','49452573703','55714230301','628390803','62742408102','51688650802','18027005006','055312825','015127821','059779221','13537064513','69305000201','068084075','695430386','065055501','626730162','701860575','308073003','343310202','174780010','69154007001','64942117302','050844227','033261873','156310597','434190757','052125427','066184125','08888492033','059779164','43419005831','38779006001','526420032','37803190803','76296000840','64942130407','50865021350','575200348','68745203501','065862357','063029703','63370005850','147830121','046123009','76331091030','575200599','061727301','137340158','050804244','016714338','059115097','619410101','55714228200','14783025107','016590097','00859236501','42627026002','63275992302','63354040061','63533058507','59779037203','703255003','55714450102','10356032225','81131031162','52686025960','060760413','15631011200','62991306404','042254142','63148045007','62991267704','63533022111','063354218','670460729','58768030040','64578010802','65448307001','00026657530','041250871','021695638','064117144','62991285202','10889042001','57520004501','41391012121','15631034703','52686024460','68455010227','64942134604','00074329551','08290309596','068387440','62106774704','60709010001','58443002604','49452813601','69152006201','037205711','58370600101','38779019501','08380003812','64117027602','60512908601','135370669','372050729','15631037702','065862374','544730246','013537226','11701090493','63354029156','702810217','703540001','697570101','058930037','011673510','00096072416','62991283501','62991273703','063736910','00702737510','660970001','10139005710','435960001','81317082000','055312766','059779120','89126100301','23594008005','076157321','619570004','61553024522','48951914502','050228105','052686261','58016073130','108120429','51927121800','064533000','173120022','69888010501','049349899','037000235','15631062606','08317113000','64117023902','68428072029','59078001001','063323297','706870001','38779777301','50924047550','69231000801','508130006','61553072203','48951207109','61727032805','763350005','11822342002','049873078','13537038303','42627025701','00394002553','61553030772','058160821','135370277','068345874','38779063407','60724010122','69352002001','043269896','043063194','51688935202','53389004622','037205317','067046108','14783060108','064117970','047335285','00003045551','08327051455','434190064','054473202','590780144','037000402','037205696','052533216','156310201','660960178','00310029050','049884304','700310002','066479021','52686030910','011819305','621061125','489511261','49452102501','065841029','049035992','37000074118','368000247','31645017801','060055018','65044285404','48951823103','173120035','64117092602','052125703','715030006','049349952','58414873501','37000026245','062584142','65044262105','41250003522','64579004125','69152117701','011084538','037000325','055648712','054272202','041520231','037012333','645780098','64117026301','69780001301','607640105','698420106','691520095','515140331','33031000078','13537061823','022431328','051009167','014783324','70170000101','579550300','508450212','051060048','055312397','052125403','635170021','54973301001','557144588','76147012302','51523039330','684280184','055513209','033342078','059115069','010544011','49817006801','58892013001','649421244','137340013','57627015001','63739040710','437420500','56151091001','543400771','14783025105','51346004701','57520075501','512850204','15631235404','063550850','760700120','49288057604','227000154','08881516937','43419000508','587370174','699240057','041520472','00254938058','617220318','38779054301','147830326','047593478','00002149725','049981002','14783088121','76157022603','66738070102','030142291','44924001202','590880843','62991128101','043269698','00065908070','11701092072','13349001028','51952023004','08080180600','70784000301','042507046','08026009300','69152111601','38779254105','030142225','37803070104','317200708','13703010340','13811053530','649421285','057664228','764990002','024338850','15631067307','109670617','063304591','00074421902','68428002214','68026052130','61657010401','45713058600','098132666','013537152','100960265','637980821','489513064','051079246','13537092621','412500036','63354029253','048102004','62991158302','08080228300','64942114902','49452799001','17575000705','68807030208','00019N180','57515007239','605126189','63275998504','49452261702','13537050201','51552063701','10939055411','508450126','00058030540','055289989','13537072102','15631032303','55259400102','596670061','593510319','10858008100','58479000900','10742852601','00074468802','52549403701','08011015914','00074421401','062802581','054575194','60512664301','063717876','00074453218','55714229802','068462244','059779759','51346001301','584430233','17110010102','51688537106','69359000000','08380015403','076214031','301420413','687887028','557142342','70654001002','55714229102','42248013302','024338200','012753305','653421002','620320124','68455010453','49735018323','132670234','628390857','76300037810','063739468','576910162','498250133','156310276','67996093811','61553079468','058914785','11509000401','08380008468','31774100101','489513133','037000082','536451220','68455010572','38779020203','55714221400','049230212','649421183','00406200109','76509015102','068163081','51927378200','13537014802','438570399','449110066','25715024950','590621210','424210575','049035337','57691010930','005172350','049998332','051346093','066993877','003600132','43498010015','010424152','055312369','701860577','15631004202','067544750','12547032993','51270011601','67938207202','498171999','045802144','044118800','50184640001','50051002404','38779078001','57520061401','61500552708','492150007','068828048','047682915','60512908701','52372082702','69423000373','060429372','517850899','607640095','063323462','66129021039','24559000100','614027131','049348266','24200003716','79596009021','38779190103','680160213','068007203','010812268','70074050461','526850431','49452469003','38779073106','650445136','61553023157','00024074604','68647017810','068084666','619952389','17089045618','63370030025','057691569','052376035','70392001401','052125640','50845004202','049348263','066336915','68654058528','41616095340','00270086050','055118530','715880006','67732040516','15631064706','114100602','15631057002','049967079','024385005','38779187103','050302310','63354033126','056136004','10345004001','076204100','053228001','051824534','57520043201','064679965','687452021','57520009501','011673994','00074653801','156310223','595351271','680711740','524103066','044019111','51346030301','49452606102','764390242','051079042','760490123','492880711','293000255','65133018007','021695507','114890124','043269738','69368245404','70074062075','08290843002','055319619','036800016','650449960','64117012001','063739520','062257606','08080216017','69152156901','56136000701','043269677','055315184','694230027','64117020101','37000027956','38779067303','068084335','52372076701','63533058517','00310032115','51927174300','49967006401','00270131698','55714460702','035356643','68115075130','051079127','57955002402','64117095902','449110060','065923902','10096802601','00024154901','010544065','036800507','51927222400','147830074','61553011597','059158913','607640089','51523047212','687030275','575200364','489515011','690390204','61553022302','051389122','492880930','55714436901','063323446','063323130','70592001002','50845004501','22840006406','049348329','51688532402','57955702301','605126013','52372811150','55714229302','62991259601','063323327','24200021016','052183335','15631014902','69259210201','621062022','591940001','51552009409','15631069807','055316467','684280413','60905000102','046672200','046084061','42248012702','679381169','063459205','350000870','10578002790','62991201404','050580318','605129163','489518006','064117138','010019163','684280198','076388713','050458191','437420582','013537364','584430100','055301117','687030006','35000066205','40565012073','37000064666','052584006','43857004901','24200032592','08881820008','64117095801','38779038406','67938107702','686470177','70123000101','51552032606','064092012','55118060511','016714697','58914081084','63286631009','370000141','057707058','51552049602','047335962','001780798','55714150400','43538042016','049483061','64117099901','021695329','62991274101','101579535','055910002','00525051690','050988174','068479216','438570432','49288061103','69652000000','58597856809','54973290404','010596334','61553041703','068001211','54629077801','032909652','048433347','65028000301','44206026972','53897000101','61010112206','586682521','17191079105','13537018821','647620884','013537244','65342100600','49452533001','557142227','69152106301','063354150','61553027161','050844390','042507548','697130025','57520032801','042291342','54842077601','021695558','08026483300','046287014','68327006601','046122018','10742845702','062756402','063667507','13537052801','489511196','34690300104','50428428836','52731702002','526860290','55714221101','033261076','035000114','064543125','049643314','61919018960','062756147','15631065802','65133018024','61553022048','15631028205','55714230801','076157514','52686025060','684280314','10096031301','037012272','010544541','51414070014','43319002001','054092700','670460150','15631236404','449110071','44911020601','20513001006','662670888','340570006','51523012202','64942136501','597790270','00007335216','49203073002','50428489356','036800020','673450788','62185000101','66184052501','423610007','067046166','24200032580','69423006173','014783434','62991215005','57826045502','62991115603','041520107','002209045','043269888','10893050015','66336079990','010345020','51927353100','438570028','54973310201','016571203','60512661101','65923055744','47884017550','637760628','15631041602','059779329','75857930106','037808186','14783002851','114100605','049349252','68220008330','707850022','15631057007','45861001805','052544383','62742406401','016729194','61703022676','08470074001','04351098810','013925506','011084177','557144432','047335004','51552037902','51927115900','11564000302','687887021','08214029750','42627022901','059726580','047335861','38396042057','400570001','513460452','50428440185','55714222202','98132073901','052125011','61957212001','49288000803','033261996','663430002','76439022430','437420950','055312117','694230076','62802011685','054575288','68455010631','50184470002','548600064','08884711568','52372082502','57520066301','649421132','66184040501','41250003356','08380007906','00186116404','69231000501','068382702','108120968','021695048','489517015','59262035513','489511232','62991107803','063777314','94046000125','10019006006','65342700300','437420838','58414872801','68647019510','052533042','068084356','037000455','59623000602','60681107501','68428086406','037000799','057664178','11701080919','053675135','595351541','15631055901','068084654','100190634','658570450','055111264','007815992','83490017805','037205145','075921241','575200237','51927192500','53104021100','022431112','501148510','489514043','068084309','049483003','47993030407','048102101','57520077601','10889041001','549733124','526410302','11701040591','70074051362','11727000706','762800231','060723032','617270335','174780404','495200301','76300037710','76439025910','66594078809','067457227','43744055711','059779903','041250016','00053749001','703530004','76300052319','699580080','065224615','047219210','037808072','15631042503','602326200','680890004','15631034205','068703082','61589381601','13537005201','37000027373','684790120','51927197100','11523739602','056062215','62991200902','67345051200','52533002461','15631037604','758482600','016590312','76331081030','54473016801','030142121','51927164600','617220274','24200074850','002688069','08380014206','00363092703','533461359','58962001001','38779259008','15631064700','58411019020','57627012202','701460000','70784000102','048883004','050211001','76150013313','060760007','055910678','061748025','13537024806','037012302','14783030501','51621007801','050742207','709080050','052473001','584110209','15631001203','063739032','064117643','068016021','043538130','61571055010','762140014','765090800','049348397','14783024404','533461371','449110023','449110238','108120336','438570010','68428004501','052559576','053329642','66096017906','557142351','135370725','059115094','684280989','011410022','51688762002','67938094403','052000003','687451065','57520044001','067172393','00884127102','060429360','08333295401','633540458','710260006','61059012313','037000202','49288058601','13537034401','00884304208','021695695','49967041601','605120012','045405001','041163434','526850326','08222710000','48951401301','068647181','621064820','063347511','104240167','49452131701','70326010301','63275996504','13537055002','37803201204','43419032420','59535163101','50481320101','060429236','15631063905','521244016','698420751','046708036','10096086801','076332004','043063275','69968018301','00074592101','047593496','057896638','51927149200','55396001010','51552111002','068084481','15631008004','69976000301','37000018514','58597817109','52731703802','557000551','15631069003','63533022108','557141511','489513121','034057001','046783161','15631035404','51414060001','043419853','500900350','553010206','041163161','646160118','055312289','575200351','10797003103','43742058901','055312489','68455010487','60512699701','15631065903','030698911','10736001202','043419019','52372083601','00015798195','350000860','50181005301','38396041070','011673205','438460025','51552049802','52372088102','438570184','94046000188','438570015','066689025','00186063501','61763022543','49288082403','029300124','59535157101','762090234','48951106001','68828013902','17191000132','437420557','76173100402','706480005','00026668710','055289917','66184011001','489515061','058503042','00686003402','584110117','042291161','61727040130','34690700103','00024077803','76214005901','051991836','055910478','011673563','050268566','10939055444','08290002152','041520957','64942111203','449110038','00013562693','49452750001','11701080090','449110077','10096521901','20151006302','51552102206','620320121','758400094','061442175','38779135404','526860677','049035006','758579300','053145304','49452782001','14783089510','38779008009','51389011603','43251335307','526640005','08317112000','513460156','516210098','38396076339','049349827','054473164','684280124','64942120806','42673000204','98132018702','549733123','489513143','577180050','056062964','61392040730','62839145501','010544576','08214043520','54973311001','08321081028','063304653','065162475','08462556095','38779008206','52372080504','587370167','59135000248','68428008501','51927311900','69949029802','10135017001','15631054505','08380009785','54157010601','38779092603','691060310','762140057','65342209002','62991109802','614770210','49967042801','48951806701','31720020908','62839163001','575200398','064175525','65862015549','050580449','049349838','010544108','57627011301','55714456402','50845005801','38779208703','013734032','579558198','055111302','068462161','064455140','053045265','036800101','65954076992','61760069000','67938096401','55553046902','51552080604','54162067014','24200071013','029565400','38779005105','042291695','076354006','38779189501','042571020','69927000401','115590932','575201044','029300330','00019906820','90891011425','14783085902','062713802','59667006402','067692072','041250026','611970001','596720230','41595700801','052959144','533461349','075862014','489511269','004091258','024236860','052533045','13733013001','63370022425','050580519','048433100','53303002281','53303001220','068703031','00015055641','066336921','063323468','055390308','54973295002','50428695756','69894001001','649421232','052125014','010812836','51927200000','076439205','015127863','370000048','703410100','613280009','00009753103','435260111','69888010102','052584052','023155228','021695662','49288003702','435960059','158280213','58443002504','51552001807','87473120109','350000729','54973750501','76485103901','135370347','144980001','51552030605','17110010101','68455010254','046122055','48951800401','43742016301','48951317701','584790000','60681230801','584430234','51645087599','692690200','38779225709','44206022601','575200957','38396070293','021695815','619570122','11701090487','24200069852','423610042','51552035508','010237755','75936012403','063777145','53208060201','13537033101','15631069802','51552053302','51927435000','582320635','15631236206','56151086501','51927446200','68647011610','14783020211','15631236307','51552082205','557142331','42627026301','49817198808','44911034701','11994001104','49452338802','049035159','53885020801','13537016042','036800393','049643313','076151210','66915061035','036800153','653421390','449110336','00026069025','517690124','14783060625','69039055901','682200089','43455001000','053698001','64997005002','049349041','060760985','50452022107','00942643002','037000113','014783016','50428798066','575200245','063029662','43419030603','035356651','70474011001','076237214','063874489','15631029203','054473173','526860258','08881533130','021749520','063736240','712200025','031722534','63830058524','53119057520','137340129','592620101','22840010100','695020501','61553059461','60565001501','059779191','684280633','059115139','00381026181','707711033','00574054301','066619131','57520103201','011701045','066758046','049778002','616490001','135370989','59535020501','37000031148','59351032201','437420032','48951105102','62991115808','579550074','055289457','049349313','043063205','48951310002','81317058600','033261761','513460332','52533012526','52686033311','664720026','43853010003','707650750','049730111','49452075702','062756633','055648670','609340003','10075011074','15631235302','20221026028','449110438','021695522','500210304','063304972','710260009','049349973','054575159','55961098128','526850321','684280380','759360110','497260018','16047002301','62991276503','62991282501','002201106','050952003','83490051004','08496295511','037808678','049673424','52731701802','38779064008','38779112601','067692470','714460002','492880780','043063096','48951703501','10812086304','057664210','055289045','55714231100','60512661801','055319244','607640006','64772030006','557142210','61703022322','065862082','58479001900','147830051','08080306300','617220283','028595500','021130340','13703010130','046122138','15631057706','056062703','69515005001','48951919801','00268042780','68703011059','024385590','55648075903','981320208','00264121420','035356547','156310038','10596071060','055316090','00186105003','69519010105','55714225200','058406455','58479001101','10096010301','11489008401','50600051493','75936013504','670460943','054575963','57520033701','557144550','36000021331','764130149','62106598604','059899001','51552006606','076237265','42508016101','068180559','62257058528','66854000105','58411010510','61553000765','51552069707','691521039','063824351','055550001','065862535','54235020608','58737012201','705060060','023155102','45713018800','51346024101','114890076','37000019880','38779269405','050419421','041163884','14783045517','15631006502','51552054907','62991250102','013734114','075997025','34690800102','61059052714','00023496313','513937522','58988182001','51688527606','049035236','14783030201','61059030724','50063000303','049643358','016714062','052862008','063459225','076045006','043063327','61919041030','042507685','105960342','62991205802','064117545','08290309633','00456075330','037000755','51645073906','47884018400','628020644','00686801025','068180334','49452585002','052685302','62080114001','049349316','64117022402','76169010201','709330190','437720017','51927440900','62106758704','62742406602','43689002002','042043191','489514042','62932014221','38779040305','68455010148','058517080','15631237905','697800001','065841684','670460170','054575940','049967279','15631007902','055910893','511430951','62106114208','599700075','66647613244','573370075','55926001702','021695326','060432464','060258866','70074056312','699680274','53731000106','687452033','62106871604','043353724','38779017704','499670208','00067026068','055289280','062756138','156310360','596670047','098132132','69152050901','062257364','619570350','489511208','057664239','135370506','036800190','13537021106','00573190112','525120162','350000394','353780008','063736948','00703822903','04351079710','437420130','69761001030','434190718','11822311570','00407222216','049884929','714543646','00338932602','00259060180','26974042001','08496303501','492880701','683270066','524710100','49856009704','50845012201','696770293','061077125','011410305','065862014','623620129','60512101001','38779023004','70763001001','699240041','508450181','17040041494','076074151','00407141447','058281561','10096018801','013668019','37803201008','68703001380','11727000606','052685434','69072001001','049348315','08395078960','036800177','616010079','424060009','64159697201','70260042601','15631038104','698420578','48951404602','51927147200','052544966','38779077008','00024073910','113440604','42508013300','69424036001','55553047702','060637002','00440801315','51688521006','17191005106','70605000412','699690003','035356091','38779036209','15631036800','15631045203','135370355','59321003301','66854000601','584430240','049349913','003633112','13734003160','52372082103','021695665','049738461','49452484002','690390215','58016081883','43857028501','11673081045','15631030903','699610040','64616010602','68828019901','433860358','63354021523','52735002501','016110080','037205241','049884109','076282412','89123700167','64942139801','068382034','500480012','675100112','701860571','437420649','707711088','621067756','049351016','068828062','596670073','30142090416','683270051','50367010001','14222202201','37000033105','058154101','51688630302','021130009','00015722595','05539043605','61553091952','053329092','437720025','059779471','64579025100','035000800','11694064601','532253230','10812040102','135370521','51688616902','557144544','042283004','051079134','15631026400','670460808','49404011401','499670038','70074040756','65903017101','059779429','61553002909','98302013939','700470003','434190527','10025087601','049808201','068047350','62157013001','08620217921','059115090','068828059','15631031105','055315165','059779408','156310504','49288086403','08080989100','15482099055','10356032603','640240915','684280979','63776027014','616570972','515310332','049035118','489517108','11701080820','52959017906','14783024206','048102007','147830866','41163040260','50730710001','156310195','501145325','316450170','10939043133','51688634705','15631024001','067475114','49288088503','050580488','052559575','108120232','49817006201','11822284070','439790446','098132719','51552029305','076151221','137340138','021695812','48951312801','53499033901','62991303501','075854304','534992590','59707028101','669150608','575200203','70030013881','438570255','031720913','060608012','013537300','068105003','15631018803','063940541','066129140','043063065','249090713','38779049708','43742076401','51927172100','51927422600','13537060627','010812002','52372075902','609050025','437420069','047335573','49452240704','43526011502','64942141801','00074654401','052125291','24200029766','43742016601','42268600101','15631001200','49326032560','15631030103','61392004630','57955024202','52166000701','051870000','049520103','55714462601','55714221801','050111918','062856274','055648978','61553019361','587370142','010237739','003600110','62839080801','00703822803','449110139','041268094','054738952','010356101','645780147','69926000901','62991400501','051079409','534998933','053040994','521240110','51688616602','105780041','13537027701','50390011300','15455070102','055390105','068084420','037808190','050523740','617270054','10096025801','89137050050','010424162','61957020101','052125853','680713316','024208635','52257100201','44911002201','052584029','52810050111','11845121405','48951825003','064117199','10719026204','51927227500','691521030','15631069105','595353701','51552003107','582320065','13537014935','11845122201','49967026401','62157011601','38779123404','011410606','19458022106','00406067252','69038000700','049852011','13537043402','055111661','043538230','15631039800','15630004678','00407069012','75839026305','49452005904','43900097370','37000042023','049349057','11014098762','48951807701','050268795','489518156','050111471','15631053403','08290305935','067046651','00019903508','667156821','051367009','70519000301','59196011901','049643380','007035775','51393753301','59713000112','54473024601','063550851','10158005306','489519225','489518132','00548143000','00102313030','55714232300','68405829836','51927281000','64117017302','049035445','51927132300','002209324','75887000201','043393203','68702062718','053389211','59351032401','86679031459','08627000301','586663121','627951023','75990096811','021695273','619952515','668540006','64117029102','65702025010','707711083','36000019570','684280873','15631065107','002680247','584140004','492889932','705510002','00074829503','055390072','698420051','76300070601','041163412','38396030514','64117070502','068428095','068025053','49452722003','11701090614','620320509','434190384','57627010901','15631236802','010671100','981320760','49967058302','050563151','065162541','042507010','11822396830','686930006','054575401','13537052901','51552027205','427073001','68472010301','24200045104','59667009302','13537025701','08580301001','51393722202','049349591','051079119','014743536','38396041437','489517094','15631052104','55390000501','047682161','055111428','064679630','14783020003','001780821','50419018837','501147050','51991090990','042507161','060215411','438570025','00074491301','035356865','051079697','00212458072','010596330','08214071201','049035388','135370930','037000016','049348020','021695539','058930026','423610015','15631029103','34362023201','003630275','055550200','059262356','00087140945','38779004308','57520074001','49452439501','649420819','049349843','010056368','69945060110','62991103102','049348169','058160811','627424056','035000868','48951604501','51688618902','050563136','86227018155','594010019','53303002280','61607033101','51552047204','052544045','43857019701','043734002','00264161400','08881560265','013537418','067457341','043419021','021695358','08539055003','51927222800','76214004301','653710055','687030153','065862173','372050732','63354030356','51927353200','049967728','000935417','508650689','57515059359','640090056','69152011301','557142292','037808700','43596000601','068540001','51009083214','489515037','049349318','64942135403','539430210','51552124902','00338023383','38779057808','068462226','68016030554','606811256','248540400','15631005203','24200036280','051079995','438570394','575200123','51552118602','051991201','051991630','692593324','043063357','003782245','59614041101','717250030','761470230','52346001501','43406009901','61147800502','46144070001','066129045','694230059','73796007124','050111468','54973308403','49404020101','044781110','13537042901','589122001','00536509008','680714118','52372757525','98716066380','00409793025','98939000200','15482075205','063779340','51927318000','67684190101','48951708401','51552005005','054092003','316450159','64616010302','052959389','049349663','761380202','55926002102','489511050','065862120','609050045','38779012303','58668075101','65954006593','712200020','55714456902','489511168','058411149','08881200326','15631044705','049514076','057896941','60258043416','055319195','52372089801','38779036007','492880004','52372731603','49452330002','82891021010','758471713','057844130','489513201','437720005','49452261101','649421133','050728510','57718002001','00525051090','272810010','062908013','11845056205','627500045','15631059806','051486003','51552002105','649421347','38779003103','65044435202','104240164','68807032511','66977010105','103450017','524540001','156310468','49452075005','62991135105','08881533056','08395081360','10267102705','59078004201','049999852','687030295','55714457201','58668228101','62991405005','016571160','55714425901','68025001110','681960002','708030420','055111671','00407141396','17191067125','00363356002','076282239','052584115','43419071002','49452115501','13537002701','693790012','59535130101','549732906','34690500102','08080142200','08395085461','00268021605','682330903','691521004','11822303320','585750161','030142096','055150120','68702031101','49304001301','00003141125','55714500203','057237044','049967272','13734014960','57520013401','059779259','055301004','055301329','063940121','049349166','50556000101','061748219','076095100','00482011819','48951115802','372050731','67777030803','541620195','043598313','81317082350','00065920075','51523011802','002203023','700840230','579550125','003600255','437420035','62106110908','52731705001','68828016312','68647016310','61957222401','438570196','041520195','156310192','51927428300','062756023','068084022','680260541','00186111513','000675126','098132161','24200060807','368000599','548685428','49288081803','350000618','557144581','023155030','619570114','00046326510','10882052707','70519000201','13537015001','584110350','050302300','00264514410','063481668','68647020110','49288000701','021749806','51131566521','37000090915','13537062323','616011236','010578024','68814014502','053329947','068391306','15631032602','051991333','645780081','715690664','70186057101','93815099837','070253307','051991294','051079139','706020002','054838101','08026500300','045264009','621910010','69142000101','053208545','663430014','622170008','52372088905','62795400309','034666141','000936902','499670080','67938090802','51191204602','00212185551','08080720450','50428146988','013811073','068196571','31720030213','049643383','010812968','579551010','69570010211','50428882127','49557057608','579132869','68828006201','118227701','108120607','052685334','051079929','061570112','00074381412','11489009101','489513001','052584950','041163075','049348443','108120388','57520043601','059115055','49022007425','705180723','060429524','098132166','584430066','55714228000','437420448','691570002','15631032103','51393611202','051079129','665790061','62802022016','442240299','508450101','692599692','684280383','08484050364','049349673','13734012330','77890032257','62802065106','010056699','43251224102','57826041463','052125118','70074062724','716820001','042291616','14783010901','589300027','64117014602','59535430102','052003016','08287126424','606870343','043547278','37000034765','115237337','620030002','714390050','17191087103','699450895','00642007416','59430010130','042023120','670150000','38779022704','575200358','050242136','064117259','55553047402','068084539','94688011220','050790100','068703005','58016081872','57515009355','098132723','57955512502','049349708','48951909201','635450142','61957111101','703410430','60681211101','053746143','549735230','703410470','50428512491','37205025672','549731120','69259410901','549739104','43742018501','059212658','08380088700','055312217','08881305018','699240030','38779059901','679380938','108120459','761570232','171560610','656430334','49520010151','55714440901','532080494','063941161','052125546','50051001404','051645711','38779132705','557144553','00074490018','49452465803','606811901','61328000901','69676001101','684280261','12027020301','061352002','050383087','57520022301','62991252301','49726000802','064125139','053329058','38779169800','34022010212','596720032','43419072809','710170150','49452001603','064483007','525330137','70074058062','15631052202','62991251801','076138101','618770001','61553030765','68472009501','060716020','59663013004','62795102602','76472113601','698370100','051079973','58411021930','51927215600','036000006','061314126','68807032522','70117000101','00074962902','00268021602','042507829','62991256004','066472034','15631036102','042254223','76472113001','068828102','049999855','57687028520','685996110','57520006401','579558196','62991260401','08026449000','758870003','594690151','054162500','016729117','633540931','670460214','437420219','067767121','350000206','010812440','060793145','698150754','49288046001','059779380','69017030201','516210111','08080072030','693074496','44911028701','532080521','045963342','059883721','538080452','058165028','050111788','43857032301','15631006505','063667958','52257100101','013537224','38779782803','438570403','86679001008','76420031260','041190458','15631006401','101911822','62991110303','003630229','58411018220','08080360600','590780325','55714223101','055315393','021695215','49288991504','633540010','38779030108','000937116','051991702','38779190105','44437055902','047682681','058356001','041250698','016590581','51927331300','068387559','51688937502','156310698','48951114101','693020207','520530001','055289272','105780023','61995203709','62778006101','13811051630','651210884','690390209','001137798','69152000301','115237410','489512009','62991139001','57627015701','317741001','699240042','08080760100','13734014030','049348042','18029083008','619572130','65044286203','58443002304','680714108','060429713','105960401','606870349','15631065605','684280482','43772001601','055138005','15631060006','57472000607','10019003682','76420029930','08326284001','489515098','201464007','620320300','75839022900','60681170402','557142269','049789040','037012588','51393688801','48951925801','018860253','049852025','068084419','49967094401','67938206801','61957221001','499670022','043419367','055289609','00338940902','049967425','075997022','00074562302','001152722','76420017260','045802571','16042001022','57520003001','049873114','58331003003','017478931','08214029724','059779349','578260420','049999150','51523002801','62106670104','076470003','11701087524','14783007262','43406011201','042254126','10812940001','043386050','434190324','48951124301','518853302','69423001445','684280862','641170121','203670113','38779115600','00407222206','530780070','08290381467','55714230700','43742030401','63275996005','00264123500','041520336','595358801','59707003105','368000523','10237070812','043063244','665790065','575200167','62991143101','14783091345','010812234','66277032202','85017000042','076282406','059115049','15631061202','076439308','055316002','68455011185','38485050010','137330004','15631003805','56151109901','575200603','58411010810','49967037301','08970705013','59667001302','79854010925','049349905','51552095305','055754123','001875493','051346208','052584140','438570363','57664020308','043063113','08517352936','49230019461','557146612','17191000610','73796007115','688070313','64233022113','053622001','00220904509','037205023','61703022185','70341032001','10578010490','08396800200','55946032250','049999906','48951313704','08080104400','38779238705','51552021406','059021008','61553038304','57520049001','51129434702','049349977','24200068710','492880664','62991167304','62991289502','51552010002','684280446','13537074223','064720190','021695085','423610202','00074910518','62908001101','037000132','67938095101','44911030301','011673519','61727031021','066993056','55714110301','051346006','59535720101','068645477','057910400','11822221180','058517200','57520004201','90891026810','017089420','00536238085','059779370','759090180','62991298701','603193001','055150178','53389024113','041520376','49288991803','489513204','061561012','160470020','58597822709','10939006401','75847171001','438570223','00270080444','055289733','501142324','00418228546','11410061248','37000023275','68703010059','00011836120','024208735','759360130','516210031','076056001','68828017902','38779023905','063917001','063323117','043269627','51531265601','11084098065','62257060615','08026731100','00064015008','87701024748','39769028905','064376611','38779201909','38779104605','51552039202','521250139','58668713001','024236323','068642783','067544840','49452058501','37000021027','36000011956','00003141128','692916230','45713018050','680010336','064117221','638680120','42673000201','00641226341','049349840','31190021020','64942134901','633540730','52533021718','037000718','59667008102','699680162','617220067','495200302','60512647901','056062311','052584160','021695436','532080531','020276550','36000055505','52123004001','556550269','13537095801','005731929','38779076904','76354071901','449110424','52685030830','584110176','15631054305','043269795','434190864','014743086','637760171','62991240001','64616010402','98132015902','502680655','08011802001','147830474','002703876','64942106603','69100300101','005175710','707161900','15631052003','48951121002','063736018','38779037409','62007002216','610651003','052959518','043269814','76420099106','32909075401','649421196','68994400101','068828160','040032360','059779798','08407690041','38779170003','13537006506','11701015936','761500133','135370108','50114106406','60258019409','61553020648','691520623','51927184700','050544004','08080441205','55926002302','021695769','113440984','067467643','683270061','49452608702','00316205520','066794020','08080673000','042248127','63868061301','38779253605','068391227','50503000101','010812321','076237179','042799113','650280003','22840003104','052083400','653421395','066854004','063739545','70074056417','063304599','43846000501','24200026610','057243016','54473022801','64942120401','067858515','684280499','010237656','51060001129','51688993902','059779525','687451020','108120812','055316742','08522000013','054458947','610770003','08333152701','00220110963','684280214','68455011116','60512803105','12333940602','513936659','586689909','63370090509','580480003','526860330','052545505','064735021','35000062205','059779619','002688056','52372089302','15631008501','15631000005','08290007184','00525041030','501841039','43742058101','067877211','684620639','059779557','587370139','58232075202','52686025530','764390325','51927264400','10596033126','035356391','12866034201','515230033','51927108600','25121000302','64117014702','62991275501','61571044001','003630790','43857005801','62991205706','053519618','596670055','38779175404','64942109001','068001235','49288024103','51552044507','55048060830','557144401','591580723','061047824','596670002','49738080101','670460914','00019132421','37000027756','57520099401','67938205602','660780368','43846001601','50924014510','08080716500','62257073824','680629103','278540100','51688630402','068084306','693290600','584430148','055390299','08080602200','51552026804','64942114802','042893052','38779055309','062750027','58411020360','016252569','497380104','68308044090','86035000401','626701525','012546720','135370436','08290005074','586682191','59115008701','00270069655','49288046002','10812043801','437420033','52422010050','696730635','79854040010','67544021430','93764060184','057627161','707061002','705910120','704150402','58668096101','64117096801','679382012','22840001704','68428011601','029978606','52533021460','15631232203','38779228903','055910180','641170270','698420152','68455011324','53157012092','052959540','90166085055','61047081475','055289772','041520807','57627013402','51552013105','051824547','20146100101','021130175','010956788','00192064920','017271503','001350524','21749098797','011673197','437420355','575200474','00074606203','607420005','037000245','042507660','51688515106','14783095402','557146091','51552112801','08214030720','649421035','98515000103','616490002','57520083601','49967078702','076282405','69036022115','51552068506','38779815201','010812611','001151750','49358055501','51386073200','38779005305','021695162','035356783','63275999404','055670600','68807030303','052685373','57955400103','68455011330','050419455','51552063506','38779003400','115237183','55714428901','062802103','38779021903','489518301','621061055','645780058','076446003','62991284801','10889041801','615437770','51552027204','024658302','52372091002','526860320','50403022630','649421524','61601113803','68455011008','518010008','575200466','051346221','00409217212','002701411','42851015201','70074056016','51688956202','041520485','10075003930','14783083402','059779302','042291683','054340783','61553022635','708180015','042423270','037000182','55714426900','68472009301','060429113','70334015260','08080812701','52915005029','00074581901','14783084802','489511128','316450193','10939009022','42361003501','51688636702','051706305','057237009','52372077902','051346110','118229005','41595554501','00008257306','981320130','69761018701','050268324','060724101','037205680','50428265259','449110134','059779232','23490675701','15631050705','068084310','637760454','00536344801','00083232725','716000012','156312316'
)
GROUP BY DRUG_SOURCE_VALUE
HAVING COUNT(DISTINCT PERSON_ID) > 10
ORDER BY COUNT(DISTINCT PERSON_ID) DESC

DRUG_SOURCE_VALUE	ROW_COUNT	PERSON_COUNT
53885014301	787114	375224
53885044801	187474	168750
99073070822	578005	162268
04351079710	107362	88695
08290328438	315523	71675
53885020801	58655	56688
50924047550	221911	48877
67857080330	47196	27597
51927279000	48550	24631
56151014260	44619	21898
08290328440	81269	19181
00525041030	71720	16234
13925050910	33195	14872
60258019701	40485	14662
68220008330	47934	11920
60258043416	13664	11902
08290309572	28211	10570
00525051090	55111	10132
49884087705	27476	9613
23710000110	12999	8604
60258019409	25215	7824
44946104509	23799	7817
38779036209	10148	6837
00642007812	21986	5494
51927273300	15284	5417
68025004230	9420	4849
00062331100	4534	4315
00603254821	14497	4277
75854030330	14739	4188
08290324909	10147	4127
04351079810	4189	4099
38779004308	14462	3901
51927101000	13300	3608
08222094193	9551	3410
75854030190	9122	3206
81131031162	8935	3147
10542001010	19418	2981
38396040202	7909	2894
56151091001	7079	2801
08290305155	6219	2724
10782020160	13161	2688
13811053530	7133	2489
57599881401	2655	2416
64011019926	5815	2400
62991215005	9392	2298
51927428300	6768	2184
38779004303	8550	2181
52372082003	4307	2177
18011080690	6720	2068
94046000188	2219	2059
51991090990	7603	2057
49452278002	9732	1971
56151030101	4996	1826
68025001110	4096	1714
51927184700	8983	1637
56151081350	4238	1578
51552030706	2266	1492
50924088250	2890	1461
32671020201	1645	1453
63044015001	3453	1448
49452606102	6703	1424
51991091390	4700	1415
38779175404	3865	1399
00245021460	2374	1376
38779022704	1947	1354
13925012860	2692	1304
08470046501	2755	1272
63370097135	4513	1255
08496310401	3584	1214
08222092199	3832	1213
00642007416	2834	1212
42937070510	2659	1170
51927322700	5099	1144
00193739301	1173	1112
51927319400	2154	1104
08627000301	1321	1064
94046000158	2011	1056
50924088110	1691	932
13925011990	3532	889
08321081028	1996	888
41163402205	3485	872
49452608702	1080	856
16958068458	868	856
55513082310	2561	818
49502020802	827	795
38779003103	3584	710
10267102705	2497	706
51927169900	930	674
51927900900	1470	634
08290005540	1346	634
52372082103	801	600
08290309606	1095	591
76439035930	2090	557
76439022430	1941	552
38396031114	762	533
51552069707	1017	520
38779088705	1692	506
42192033330	953	493
54629077801	718	492
00406158253	1705	486
63275998504	1557	482
63275998308	1490	472
51552090207	827	471
51552117101	2649	470
11026275509	785	459
38396031225	746	458
62991306404	792	443
50924007920	1064	435
08290309596	862	433
49452391705	605	424
51927283400	1082	415
45749001781	737	403
76300037810	2338	400
08290305905	892	392
38779000801	943	391
51927122500	866	374
42546002510	916	367
83490051004	370	364
38779009108	441	362
99073070792	726	357
53885000775	635	351
38779056604	385	348
38396030514	467	340
08290309603	679	328
63275996005	517	322
08373013400	321	319
63275994909	2018	316
38779039503	493	306
83490044068	308	298
62991104006	458	289
49452240704	474	288
51927115900	768	283
51927357300	513	271
52372079003	703	266
08565016915	502	261
38779005305	406	261
08396800200	588	258
38396070693	632	253
38779007104	375	244
42546017030	727	244
08290309659	523	242
38396070293	616	242
08373074200	240	233
08214085054	916	221
63370014010	1034	219
62991127803	679	218
38779169800	415	218
00395030396	310	215
49452465803	903	215
68032027060	461	211
38396040325	772	201
39822509005	311	196
76300037710	1153	189
49452214101	601	181
59707028101	361	180
38779064008	537	177
49452384501	674	176
08214053501	341	176
04351098810	181	175
51552085806	300	173
49452641001	228	172
00085460402	189	171
10858008100	182	170
38779062505	198	168
51927132300	634	161
49452440702	871	161
51927189500	335	159
38779228903	539	155
51927108600	320	150
47884017550	320	150
62991205802	155	147
08611506101	272	146
08373975100	148	144
62991271401	364	140
63370009035	622	134
08290843002	350	134
50924014510	222	134
08214035721	233	128
59707003105	372	125
51552049805	286	122
00074909332	173	121
08290309620	387	118
38779067303	527	114
38779023905	124	113
63275992302	302	111
51552006606	173	110
51927192500	268	109
08290305935	227	107
08484990435	239	105
63275410002	200	104
38779208703	182	103
08214046533	185	103
32671000503	445	102
49452246502	207	102
08214535716	206	101
49452781001	230	100
73796007115	99	97
51927470500	239	96
51552053302	340	94
51552075704	301	91
51552030404	168	88
38779253605	208	86
38779190103	216	86
62991202401	115	85
68016030554	129	85
62991111303	129	84
51927121800	118	84
38779020203	130	82
00083232725	296	79
53885079750	217	78
08290309633	133	77
57515009315	171	76
68405806836	175	76
67555015430	303	76
62991167304	102	75
38779027508	152	73
57515009355	157	73
08214057716	226	71
51552024405	115	70
00536344801	119	69
51552077501	129	69
62991110303	124	68
51927152800	149	68
46144070001	280	65
38779008100	88	65
00004200378	221	65
70074058062	566	63
51552027204	76	62
83490031062	62	62
52372085603	65	60
08970100864	194	58
08214029724	261	58
51709000503	222	56
08290301603	155	56
62991115603	75	56
08517352936	148	54
00259030320	63	54
38396076339	182	54
63370030025	87	54
08611505001	74	52
51927169000	63	52
49452244902	233	50
51552102206	88	50
52372088102	163	49
52372757525	92	48
49452722003	213	48
38779001703	72	47
70074050461	229	47
00047200922	157	47
51552003806	52	46
38779073106	216	45
08214030725	104	45
38779031508	109	45
68405829836	66	45
66977010105	59	44
51552111002	246	44
62991201404	72	44
76331081030	93	44
38779019501	68	43
51927113800	55	43
51552054907	53	43
38779257508	47	41
54838021280	45	40
38779068704	90	40
66594078809	123	40
73796007124	40	39
38779037409	60	39
08326281102	54	38
62991135105	66	38
62991140604	171	37
00212185551	181	36
38396042057	101	36
54868324301	56	36
51552066301	80	36
51927200000	351	36
08496303501	62	34
68405100702	105	34
55566030201	69	34
00904437560	65	34
51927353200	111	33
51552002105	43	33
49452722002	127	33
52372082702	198	33
08326290110	67	33
51927422600	159	33
51927211800	66	31
55390000501	43	31
51927295800	77	30
38779031608	155	29
49452046003	50	29
08326300001	52	29
38779008009	97	29
93815099695	109	29
50428147524	29	29
38396042037	55	28
76439025910	71	28
76300038501	38	28
38779086907	115	28
08881305018	42	28
51552010607	34	27
38779023004	109	27
38779031609	108	27
38779225709	78	27
00395268501	68	27
08214043520	32	27
51927107600	26	26
38779023003	56	26
52372087501	60	26
56151086501	29	26
76420099106	34	26
49452213902	40	26
70074040718	69	26
49452792402	33	25
38779009601	51	25
62991254202	47	25
65781239610	126	25
38779007105	30	25
49452131301	56	24
00087146645	52	24
38779236701	41	24
51552112801	92	24
50428428836	26	24
68115063713	25	24
51927218200	37	23
51552049602	57	22
08620217921	31	22
62991109506	26	22
63275302504	109	22
00053748610	183	22
38779006305	25	22
49452641002	29	22
51552049802	33	22
62991200103	62	21
38779076904	46	21
49452261702	66	21
90166085055	43	21
59196011901	26	21
51927263300	29	20
10939055944	37	20
51552037806	21	20
59707012901	43	20
62991261602	57	20
68405800306	31	20
08881516937	50	20
51552046402	25	19
51552010308	35	19
51927169300	33	19
51552055204	26	19
49452539001	45	19
08373081310	20	19
49669162301	129	19
63275999404	52	19
62991165203	26	18
51927378200	69	18
00007335216	58	18
49452439501	28	18
51552112308	37	18
51927311900	25	18
08214029750	21	17
49452535001	68	17
51927435000	46	17
38779029804	37	17
52372090905	36	17
51927912700	49	16
08484990432	28	16
35781021002	32	16
64116002501	47	16
50428882127	15	15
49452317601	91	15
37803036808	18	15
00005436556	51	14
08290491001	19	14
51927123000	21	14
89134074002	40	14
00096072216	21	14
00074117630	16	14
55586000022	23	14
62991109802	20	14
08290305915	31	14
37803070104	23	13
49452601001	24	13
62991170101	29	13
68308044090	33	13
28465004501	36	13
61924017816	20	13
62991116902	43	13
49735012670	104	13
00555111707	58	13
51927155700	43	13
38396041437	36	12
38779052605	13	12
00574003016	15	12
51552044507	28	12
51927128700	21	12
38779080208	22	11
49452472705	11	11
52372089302	14	11
62991274101	29	11
62991405005	31	11
62991103102	18	11
38779030108	33	11
54569381001	23	11
49735012301	62	11
51927281100	70	11

@aostropolets
Copy link
Contributor

aostropolets commented Jun 7, 2018 •
edited
Loading

to start with something:
@hamedabedtash your drugs are mapped
@ericaVoss some of your top records are devices. We need to either make them standard or start the big project on devices standardization. They won't cause you much trouble anyway, as they are all types of needles and glucose strips. And we've improved the mapping rate, so the picture should be better now

@ericaVoss
Copy link

Looks like we have a lot more NDCs, there are 173315 that don't have a map.

But I do see some drugs in there, just randomly going through:
CONCEPT_CODE
004043099 benzocaine 230mg/mL DENTAL GEL [benzo-jel pina colada]
00548635500 Morphine Sulfate 50 MG/ML Injectable Solution
00555113010 Morphine Sulfate 1 MG/ML Injectable Solution
62180509401 Epirubicin Hydrochloride 2 MG/ML Injectable Solution
035356843 Duloxetine hydrochloride 60 mg/1 CAPSULE, DELAYED RELEASE [Cymbalta]
059779574 Acetaminophen 325; 200; 30 mg/1; mg/1; mg/1 TABLET [Severe Sinus Congestion]

Maybe we just keep this issue open and review time to time?

@abedtashh
Copy link

@ericaVoss I agree. The topic is very broad that covers any missing NDC-to-standard mapping, so let's keep it open.

@abedtashh
Copy link

@aostropolets Found another set of NDCs with missing relationships to RxNorm, below:

I suspect the reason is RxNorm does not provide the mapping of ingredient (ANTI-INTERLEUKIN-1.ALPHA. IMMUNOGLOBULIN G RABBIT) to other RxNorm TTYs.

Id Code Name Vocabulary
36487510 63776034715 MUSKEL - anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, bos taurus joint capsule, sus scrofa joint capsule, brain-derived neurotrophic factor human, metenkefalin, ersofermin, bos taurus solar plexus, sus NDC
36490013 63776040215 OUCH - anti-interleukin-1.alpha. immunoglobulin g rabbit, apomorphine, arnica montana, metenkefalin, bryonia alba root, hypericum perforatum, bos taurus hypothalamus, sus scrofa hypothalamus, bos taurus limbic system, sus scrofa limbic system, bos taurus NDC
44485227 637760402 anti-interleukin-1.alpha. immunoglobulin g rabbit, apomorphine, arnica montana, metenkefalin, bryoni... 3[hp_X]/mL / 4[hp_X]/mL / 5[hp_X]/mL / 6[hp_X]/mL / 30[kp_C]/mL / 200[kp_C]/mL ORAL SPRAY NDC
44910699 17089398 ANTI-INTERLEUKIN-1.ALPHA. IMMUNOGLOBULIN G RABBIT- CANAKINUMAB 4; 4 [hp_C]/30mL; [hp_C]/30mL SOLUTION/ DROPS [GUNA-ANTI IL 1] NDC
44979309 63776610 Anti-interleukin-1.alpha. Immunoglobulin G Rabbit 30 {kp_C}/mL SPRAY [AIL-1] NDC
44996228 63776035 anti-interleukin-1.alpha. immunoglobulin g rabbit, .alpha.-ketoglutaric acid, .alpha.-lipoic acid, apomorphine, bos taurus joint capsule, sus scrofa joint capsule, ascorbic acid, bos taurus adrenal gland, sus scrofa adrenal gland, brain-derived neurotroph NDC
45115693 63776037 anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, metenkefalin, ersofermin, bos taurus achilles tendon, sus scrofa achilles tendon, bos taurus hip joint, sus scrofa hip joint, bos taurus knee joint, sus scr NDC
45132561 63776249 aconitum napellus, anti-interleukin-1.alpha. immunoglobulin g rabbit, apis mellifera, bos taurus adrenal gland, sus scrofa adrenal gland, atropa belladonna, metenkefalin, citric acid monohydrate, bos taurus solar plexus, sus scrofa solar plexus, bryonia a NDC
45200916 63776347 anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, bos taurus joint capsule, sus scrofa joint capsule, brain-derived neurotrophic factor human, metenkefalin, ersofermin, bos taurus solar plexus, sus scrofa s NDC
45218023 63776100 anti-interleukin-1.alpha. immunoglobulin g rabbit, ascorbic acid, metenkefalin, ersofermin, bos taurus cartilage, sus scrofa cartilage, pork collagen, bos taurus red blood cell, sus scrofa red blood cell, interleukin-3, interleukin-3, beef liver, pork liv NDC
45252325 63776400 anti-interleukin-1.alpha. immunoglobulin g rabbit, apomorphine, arnica montana, metenkefalin, bryonia alba root, hypericum perforatum, bos taurus hypothalamus, sus scrofa hypothalamus, bos taurus limbic system, sus scrofa limbic system, bos taurus nerve, NDC
45810162 170890398 anti-interleukin-1.alpha. immunoglobulin g rabbit- canakinumab 4[hp_C]/30mL ORAL SOLUTION/ DROPS NDC
45810179 170890459 anti-interleukin-1.alpha. immunoglobulin g rabbit - canakinumab - binetrakin - interleukin-10 - mete... 4[hp_C]/30mL ORAL SOLUTION/ DROPS NDC
45847597 637760035 anti-interleukin-1.alpha. immunoglobulin g rabbit, .alpha.-ketoglutaric acid, .alpha.-lipoic acid, a... 30[kp_C]/mL / 200[hp_Q]/mL / 200[kp_C]/mL ORAL SPRAY NDC
45847598 637760037 anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, m... 30[kp_C]/mL / 200[kp_C]/mL ORAL SPRAY NDC
45847602 637760100 anti-interleukin-1.alpha. immunoglobulin g rabbit, ascorbic acid, metenkefalin, ersofermin, bos taur... 30[kp_C]/mL / 200[kp_C]/mL ORAL SPRAY NDC
45847606 637760249 aconitum napellus, anti-interleukin-1.alpha. immunoglobulin g rabbit, apis mellifera, bos taurus adr... 30[kp_C]/mL / 200[kp_C]/mL ORAL SPRAY NDC
45847612 637760347 anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, b... 200[kp_C]/mL ORAL SPRAY NDC
45847616 637760400 anti-interleukin-1.alpha. immunoglobulin g rabbit, apomorphine, arnica montana, metenkefalin, bryoni... 3[hp_X]/mL / 4[hp_X]/mL / 5[hp_X]/mL / 6[hp_X]/mL / 8[hp_X]/mL / 9[hp_X]/mL / 30{kp_C}/mL / 200{kp_C ORAL SPRAY NDC
45847626 637760610 anti-interleukin-1.alpha. immunoglobulin g rabbit 30[kp_C]/mL ORAL SPRAY NDC
46333999 63776040014 OUCH - anti-interleukin-1.alpha. immunoglobulin g rabbit, apomorphine, arnica montana, metenkefalin, bryonia alba root, hypericum perforatum, bos taurus hypothalamus, sus scrofa hypothalamus, bos taurus limbic system, sus scrofa limbic system, bos taurus NDC
46339342 63776034714 MUSKEL-S - anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, bos taurus joint capsule, sus scrofa joint capsule, brain-derived neurotrophic factor human, metenkefalin, ersofermin, bos taurus solar plexus, s NDC
46340430 63776003514 ARTHROS - anti-interleukin-1.alpha. immunoglobulin g rabbit, .alpha.-ketoglutaric acid, .alpha.-lipoic acid, apomorphine, bos taurus joint capsule, sus scrofa joint capsule, ascorbic acid, bos taurus adrenal gland, sus scrofa adrenal gland, brain-derived NDC
46346708 63776061014 AIL-1 - anti-interleukin-1.alpha. immunoglobulin g rabbit spray NDC
46347650 63776003714 ARTICULA - anti-interleukin-1.alpha. immunoglobulin g rabbit, bos taurus ankle joint, sus scrofa ankle joint, metenkefalin, ersofermin, bos taurus achilles tendon, sus scrofa achilles tendon, bos taurus hip joint, sus scrofa hip joint, bos taurus knee joi NDC
46353828 17089045918 GUNA-VTL - anti-interleukin-1.alpha. immunoglobulin g rabbit - canakinumab - binetrakin - interleukin-10 - metenkefalin solution/ drops NDC
46354724 17089039818 GUNA-ANTI IL 1 - anti-interleukin-1.alpha. immunoglobulin g rabbit- canakinumab solution/ drops NDC
46356833 63776010014 CONNECTISSUE - anti-interleukin-1.alpha. immunoglobulin g rabbit, ascorbic acid, metenkefalin, ersofermin, bos taurus cartilage, sus scrofa cartilage, pork collagen, bos taurus red blood cell, sus scrofa red blood cell, interleukin-3, interleukin-3, beef NDC
46358898 63776024914 INFLA - aconitum napellus, anti-interleukin-1.alpha. immunoglobulin g rabbit, apis mellifera, bos taurus adrenal gland, sus scrofa adrenal gland, atropa belladonna, metenkefalin, citric acid monohydrate, bos taurus solar plexus, sus scrofa solar plexus, b NDC

@abedtashh
Copy link

@aostropolets Here are some more:

Id Code Name Vocabulary Ingredient
36482020 62157047001 AX PHARMACEUTICAL CORP - flumethasone powder NDC flumethasone
44453098 62157022301 X - flumethasone powder NDC flumethasone
45132560 063776027 acetylcholine chloride, bos taurus adrenal gland, sus scrofa adrenal gland, epinephrine, onion, ammonium carbonate, apis mellifera, arsenic trioxide, histamine, interferon gamma-1a, interleukin-12 human, manganese gluconate, luffa operculata fruit, sus sc NDC interferon gamma-1a
45847622 637760454 acetylcholine chloride, histamine, interferon gamma-1a, interleukin-12 human, serotonin 200[kp_C]/mL ORAL SPRAY NDC interferon gamma-1a
45320566 063776165 activated charcoal, ageratina aromatica root, ferrous iodide, gelsemium sempervirens root, calcium sulfide, histamine, interleukin-12 human, interferon gamma-1a, iodine, potassium gluconate, lycopodium clavatum spore, cajuput oil, black currant, rosa cani NDC interferon gamma-1a
46357046 63776024414 IMMUNEXX - bos taurus adrenal gland, sus scrofa adrenal gland, ascorbic acid, bos taurus bone marrow, sus scrofa bone marrow, bos taurus red blood cell, sus scrofa red blood cell, filgrastim, aldesleukin, interferon gamma-1a, bos taurus lymph, sus scrofa NDC interferon gamma-1a
46347656 63776002714 ALLER BALANCE - acetylcholine chloride, bos taurus adrenal gland, sus scrofa adrenal gland, epinephrine, onion, ammonium carbonate, apis mellifera, arsenic trioxide, histamine, interferon gamma-1a, interleukin-12 human, manganese gluconate, luffa opercula NDC interferon gamma-1a
46342751 63776016514 FOODS - activated charcoal, ageratina aromatica root, ferrous iodide, gelsemium sempervirens root, calcium sulfide, histamine, interleukin-12 human, interferon gamma-1a, iodine, potassium gluconate, lycopodium clavatum spore, cajuput oil, black currant, r NDC interferon gamma-1a
45149576 063776451 acetylcholine chloride, prunus cerasifera flower, clematis vitalba flower, interleukin-12 human, histamine, interleukin-12 human, impatiens glandulifera flower, interferon gamma-1a, helianthemum nummularium flower, serotonin, ornithogalum umbellatum 200; NDC interferon gamma-1a
44843099 063776244 bos taurus adrenal gland, sus scrofa adrenal gland, ascorbic acid, bos taurus bone marrow, sus scrofa bone marrow, bos taurus red blood cell, sus scrofa red blood cell, filgrastim, aldesleukin, interferon gamma-1a, bos taurus lymph, sus scrofa lymph, bos NDC interferon gamma-1a
46332937 63776069414 G-12 - interleukin-12 human, interferon gamma-1a spray NDC interferon gamma-1a
36484485 63776002715 ALLER BALANCE - choline chloride, bos taurus adrenal gland, sus scrofa adrenal gland, epinephrine, onion, ammonium carbonate, apis mellifera, arsenic trioxide, histamine, interferon gamma-1a, interleukin-12 human, manganese gluconate, luffa operculata fru NDC interferon gamma-1a
45115696 063776454 acetylcholine chloride, histamine, interferon gamma-1a, interleukin-12 human, serotonin 200; 200; 200; 200; 200 {kp_C}/mL; {kp_C}/mL; {kp_C}/mL; {kp_C}/mL; {kp_C}/mL SPRAY [Relief 3-G12] NDC interferon gamma-1a
45064614 063776694 interleukin-12 human, interferon gamma-1a 200; 200 {kp_C}/mL; {kp_C}/mL SPRAY [G-12] NDC interferon gamma-1a
46363167 63776045114 RELIEF PLUS G12 - acetylcholine chloride, prunus cerasifera flower, clematis vitalba flower, interleukin-12 human, histamine, interleukin-12 human, impatiens glandulifera flower, interferon gamma-1a, helianthemum nummularium flower, serotonin, ornithogalu NDC interferon gamma-1a
45847629 637760694 interleukin-12 human, interferon gamma-1a 200{kp_C}/mL ORAL SPRAY NDC interferon gamma-1a
46361995 63776045414 RELIEF 3-G12 - acetylcholine chloride, histamine, interferon gamma-1a, interleukin-12 human, serotonin spray NDC interferon gamma-1a
46348131 62157010001 X - kanamycin a sulfate powder NDC kanamycin a
45371520 063323359 KANAMYCIN A SULFATE 333 mg/mL INJECTION, SOLUTION [Kanamycin] NDC kanamycin a

@cgreich
Copy link
Contributor

cgreich commented Jul 9, 2018

@hamedabedtash:

They are all homeopathics, as far as I can tell. RxNorm pulled all the homeopathic drugs in 2012. We are trying tot convince them putting them back in, but they really hate them.

Do you have a use case for this stuff?

@cgreich
Copy link
Contributor

cgreich commented Jul 9, 2018

And the second list contains also homeopathics and raw powder (ingredient). These are not products.

@abedtashh
Copy link

abedtashh commented Jul 9, 2018 •
edited
Loading

@cgreich We hate them too! If that's case not to map homeopathic products, I'm fine with that. But, there are 4 products in the last post that are Rx. We need to map these.

I'm not sure about the last one (NDC: 063323359). A very similar NDC (63323-359-03) exists on DailyMed that gives me the impression the NDC might be an error. Do we know where this record came from?

Id Code Name Vocabulary Ingredient
36482020 62157047001 AX PHARMACEUTICAL CORP - flumethasone powder NDC flumethasone
44453098 62157022301 X - flumethasone powder NDC flumethasone
46348131 62157010001 X - kanamycin a sulfate powder NDC kanamycin a
45371520 063323359 KANAMYCIN A SULFATE 333 mg/mL INJECTION, SOLUTION [Kanamycin] NDC kanamycin a

@cgreich
Copy link
Contributor

cgreich commented Jul 10, 2018

@hamedabedtash:

Rows 1-3 are raw ingredient as powder. Patients cannot get that in a pharmacy. The pharmacy can order it to create created compounded (self-made) product. That's really not typical these days. Do you have those in your data?
Row 4: It really looks like a butchered NDC, where somebody filled the dashes and missing zeros wrongly. There is NDC 63323035903 (9-digit NDC 633230359) "Kanamycin 333 MG/ML Injectable Solution" (concept_id 45074471), which nicely maps to 1784768 "Kanamycin 333 MG/ML Injectable Solution" as it should. What have you got in your data?

@cgreich
Copy link
Contributor

cgreich commented Jul 10, 2018

Ah. Just saw your second paragraph. Yes, that's what it seems to be the case. Where it's coming from? Hard to tell. But the code seems to never appear in the data, so no damage made. Still, will kill.

@abedtashh
Copy link

@cgreich Thanks! So, the bottomline: We don't map homeopathic and bulk products because it is not likely to show up in observational data. I keep the comments here for future reference.

@cgreich
Copy link
Contributor

cgreich commented Jul 10, 2018

@hamedabedtash:

"don't" is a strong word. Right now, we are a little less keen on polishing those. But if somebody comes and has data and a use case we will bring them in. As usual - bring on the analytic.

@aostropolets
Copy link
Contributor

@hamedabedtash we can close it, right?

@ericaVoss ericaVoss mentioned this issue Sep 14, 2018
Closed
@abedtashh
Copy link

Found two NDC concepts with missing relationship to RxNorm. Please add the relationship:

1583470 63539018711 palbociclib 75mg/1 ORAL CAPSULE 11-digit NDC
1583469 63539018811 palbociclib 100mg/1 ORAL CAPSULE 11-digit NDC

@aostropolets
Copy link
Contributor

Good. Any others? Easier to do them in batches.

@abedtashh
Copy link

Just these 2 for now that I need for the study. I'll let you know if I found more.

@abedtashh
Copy link

abedtashh commented Jan 14, 2019 •
edited
Loading

Here are some more 😃
Update: Just added the Migraine pack at the bottom too, for which "sumatriptan" is more important but would be nice to have the full relationship for all ingredients:

36186003 AX PHARMACEUTICAL CORP - anastrozole powder 11-digit NDC 62157055001
36186029 AX PHARMACEUTICAL CORP - anastrozole powder 11-digit NDC 62157057601
36186052 AX PHARMACEUTICAL CORP - anastrozole powder 11-digit NDC 62157060101
36491356 AX PHARMACEUTICAL CORP - anastrozole powder 11-digit NDC 62157044401
42845894 letrozole 2.5mg/1 ORAL TABLET, FILM COATED 11-digit NDC 65841074406
42845895 letrozole 2.5mg/1 ORAL TABLET, FILM COATED 11-digit NDC 65841074410
42845896 letrozole 2.5mg/1 ORAL TABLET, FILM COATED 11-digit NDC 65841074430
42845897 letrozole 2.5mg/1 ORAL TABLET, FILM COATED 11-digit NDC 68382036306
42845898 letrozole 2.5mg/1 ORAL TABLET, FILM COATED 11-digit NDC 68382036310
42845899 letrozole 2.5mg/1 ORAL TABLET, FILM COATED 11-digit NDC 68382036330
36186367 MIGRAINE PACK - sumatriptan succinate, mentholum, belladonna, iris versicolor, sanguinaria canadensis kit 11-digit NDC 63936087001

@abedtashh
Copy link

@aostropolets Any updates on this?

@aostropolets
Copy link
Contributor

aostropolets commented Feb 7, 2019 •
edited
Loading

I do not think that the major update will be released soon due to automation process, so you can indicate if you need those concepts urgently and the team will take care of that.

@Alexdavv
Copy link
Member

We are planning to update the NDC-RxNorm 'Maps to' relations starting from requests from people.
@hamedabedtash @ericaVoss If you have something else prioritized, please let us know.

The current list includes the NDC drugs mentioned above and the following:
#218
OHDSI/CommonDataModel#254
Forum post @mgurley

@abedtashh
Copy link

New NDCs with missing relationships to RxNorm concepts:
The "Eligard" NDCs could be mapped to dose-form-agnostic concepts (eg, ingredient, branded)

NAME CLASS ID CODE
1.5 ml leuprolide 20 mg/ml prefilled syringe [lupron] 11-digit NDC 00074368001
1.5 ml leuprolide 20 mg/ml prefilled syringe [lupron] 11-digit NDC 00074368301
1.5 ml leuprolide 20 mg/ml prefilled syringe [lupron] 11-digit NDC 00300368001
1.5 ml leuprolide acetate 20 mg/ml prefilled syringe [lupron] 11-digit NDC 11532142802
1.5 ml leuprolide acetate 20 mg/ml prefilled syringe [lupron] 11-digit NDC 11532368000
1.5 ml leuprolide acetate 20 mg/ml prefilled syringe [lupron] 11-digit NDC 11532368008
eligard - leuprolide acetate kit 11-digit NDC 62935022405
eligard - leuprolide acetate kit 11-digit NDC 62935022505
eligard - leuprolide acetate kit 11-digit NDC 62935030030
eligard - leuprolide acetate kit 11-digit NDC 62935030430
eligard - leuprolide acetate kit 11-digit NDC 62935045045
eligard - leuprolide acetate kit 11-digit NDC 62935045545
eligard - leuprolide acetate kit 11-digit NDC 62935075075
eligard - leuprolide acetate kit 11-digit NDC 62935075575

@Alexdavv
Copy link
Member

@hamedabedtash @ericaVoss
Except for the homeopathic drugs, everything requested should be covered for now.
We performed some NDC code refactoring so the upcoming request can be fulfilled in time.

Do we need to keep this issue open?

@shinjinaka
Copy link

I found 2744 NDC missing mapped_to link. I couldn't enter here all, so added the top 50 by count.

@Alexdavv
Copy link
Member

I found 2744 NDC missing mapped_to link. I couldn't enter here all, so added the top 50 by count.

Hi @shinjinaka ,

Can you please attach the whole file?
To do it, just drag and drop it to the new message window.

@shinjinaka
Copy link

OHDSI_concept_relationship_need_mapping.xlsx

@OHDSI OHDSI deleted a comment from shinjinaka Feb 25, 2020
@OHDSI OHDSI deleted a comment from shinjinaka Feb 25, 2020
@OHDSI OHDSI deleted a comment from shinjinaka Feb 25, 2020
@Alexdavv
Copy link
Member

Alexdavv commented Aug 18, 2020 •
edited
Loading

Most of the NDC codes requested were mapped a long time ago.

@Alexdavv Alexdavv changed the title Missing "Maps to" relationships to map NDC to RxNorm concepts Missing "Maps to" relationships to map NDC to Standard concepts Sep 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
NDC
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
8 participants
@cgreich @ericaVoss @dimshitc @aostropolets @hamedabedtash @abedtashh @Alexdavv @shinjinaka