{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["chinascope_sam_supply_chain_rel","sam_dict_product_rs","sam_dict_industry","sam_base_stock"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"chinascope_sam_supply_chain_rel","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"flags":["formulas_cached_only"]}
["id","primary_code","primary_en","primary","primary_type","related_code","related_product_en","related_product","related_type","relationship","create_time","update_time"]
["5c1349033471fa6c54b34500","PS00800203","Construction Project Design and Investigation","Âª∫Á≠ëÂ∑•Á®ãËÆæËÆ°‰∏éÂãòÂØü","T","UT00200808","Heating Engineering","‰æõÊöñÂ∑•Á®ã","P",1,"2018-12-14T22:13:09","2018-12-14T22:13:09"]
["562efdbb9128fa1a48768cf7","FA00703701","Packaging Machinery","ÂåÖË£ÖÊú∫Ê¢∞","A","FP0010030110","Noodles","Èù¢Êù°","P",1,"2018-12-11T00:54:51","2018-12-11T00:54:51"]
["56849d0c11c0d215b0f3d1a9","FA00800802","Trade of Non-metallic Minerals","ÈùûÈáëÂ±ûÁüø‰∫ßË¥∏Êòì","D","MM00400204","Graphite and Related Products","Áü≥Â¢®ÂèäÁü≥Â¢®Âà∂ÂìÅ","P",-1,"2018-12-11T01:50:56","2018-12-11T01:50:56"]
["5c18bc4e3471fa6c54b34c01","PS00400101","Writing Tools","Á¨îÁ±ª","P","CC001006140304","Polypropylene Resin","PPÊ†ëËÑÇ","M",-1,"2018-12-19T01:23:39","2018-12-19T01:23:39"]
["5c25c9d53471fa6c54b355c1","PS001002","Printing of Anti-counterfeit Labels","Èò≤‰º™Ê†áÁ≠æÂç∞Âà∑","T","PH00300303","Medicinal glass bottle","ËçØÁî®ÁéªÁíÉÁì∂","P",1,"2018-12-28T23:01:49","2018-12-28T23:01:49"]
["56c5656a11c0d20c08ca126c","FA00300111","Medical Architectural Engineering","ÂåªÁñóÂª∫Á≠ëÂ∑•Á®ã","P","FA002013","Basic Construction Products","Âü∫Á°ÄÂª∫Á≠ë‰∫ßÂìÅ","M",-1,"2018-12-11T02:57:49","2018-12-11T02:57:49"]
["5c08bf183471fa6c54b33e0f","HW00102107","Trunking Communication System Equipment","ÈõÜÁæ§ÈÄö‰ø°Á≥ªÁªüËÆæÂ§á","P","FA0040010301","Relays","ÁªßÁîµÂô®","M",-1,"2018-12-11T01:44:46","2018-12-11T01:44:46"]
["56c40ee511c0d20c08ca115e","CG001001","Apparel","ÊúçË£Ö","P","PS005011","Apparel Design","ÊúçË£ÖËÆæËÆ°","T",-1,"2018-12-11T02:38:46","2018-12-11T02:38:46"]
["5c32fe443471fa79ec64c9eb","MM00200109","Cathode Copper","Èò¥ÊûÅÈìú","P","FA0080080902","Trade of Non-ferrous Metals","ÊúâËâ≤ÈáëÂ±ûË¥∏Êòì","D",1,"2019-01-07T23:32:34","2019-01-07T23:32:34"]
["5b67f9683471fa13646d21f9","AC0010030502","Cylinder Blocks","Ê±ΩÁº∏‰Ωì","M","FA0050010402","Steam Turbines","Ê±ΩËΩÆÊú∫","P",1,"2018-12-11T03:14:40","2018-12-11T03:14:40"]

{"sheet":"sam_dict_product_rs","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"flags":["formulas_cached_only"]}
["id","code","name","name_en","parent","ancestors","valid","industry_code","rem_szh","rem_en","create_time","update_time"]
[5984,"FP00200108","ÁÅ´ÈîÖÂ∫ïÊñô","Hotpot Seasoning","FP002001","FP002, FP002020, FP002001",1,"CSF_30202030","ÊåáÁî®‰∫éË∞ÉÂà∂ÁÅ´ÈîÖÊ±§ÁöÑË∞ÉÂë≥Êñô„ÄÇ","It refers to seasoning used to make hot pot soup.","2019-04-02T14:01:34","2019-04-03T00:49:21"]
[5463,"CM00100103","ÈõÜÊñô","Construction Aggregate","CM001001","CM001, CM001001",1,"CSF_15102010","ÂèàÁß∞È™®Êñô„ÄÇÈ™®ÊñôÂàÜ‰∏∫Á≤óÈ™®ÊñôÂíåÁªÜÈ™®Êñô„ÄÇÊ∑∑ÂáùÂúüÁöÑ‰∏ªË¶ÅÁªÑÊàêÊùêÊñô‰πã‰∏Ä„ÄÇ","It refers to a major type of material for concrete, including coarse aggregate and fine aggregate.","2016-03-09T14:38:14","2019-03-28T02:36:47"]
[3114,"FA007050","ËøûÈì∏ÁîµÁ£ÅÊêÖÊãå","Electromagnetic Stirring of Continuous Casting","FA00704901","FA007, FA007064, FA007049, FA00704901",1,"CSF_20106020","‰∏ªË¶ÅÊòØÂÄüÂä©ÁîµÁ£ÅÊêÖÊãå‰∫ßÁîüÁöÑÁîµÁ£ÅÂäõÁöÑ‰ΩúÁî®Êù•Âº∫ÂåñÈì∏ÂùØ‰∏≠Êú™ÂáùÂõ∫Èí¢Ê∂≤ÁöÑËøêÂä®Ôºå‰ªéËÄåÊîπÂèòÈí¢Ê∂≤ÂáùÂõ∫ËøáÁ®ã‰∏≠ÁöÑÊµÅÂä®Ôºå‰º†ÁÉ≠ÂèäËøÅÁßªËøáÁ®ãÔºåËææÂà∞ÊîπÂñÑÈì∏ÂùØË¥®ÈáèÁöÑÁõÆÁöÑ„ÄÇ","It refers to, for the purpose of improving the quality of casting blanks, the intensification of the movement of unset molten steel in casting blanks by the effect of electromagnetic force generated from electromagnetic stirring, which will change the processes of flowing, heat transfer, and migration during the solidification of molten steel.","2013-11-12T09:28:54","2019-03-28T02:36:48"]
[461,"MM00400104","ÂÖ∂‰ªñÂêàÈáëÂà∂ÂìÅ","Other Alloy Products","MM004001","MM00400109, MM004001",1,"CSF_15104035","‰∏çËÉΩÂÖ∑‰ΩìÂàÜÁ±ªÂà∞ÁâπÂÆöÈáëÂ±ûÂêàÈáëÂà∂ÂìÅÁöÑ‰∏ÄÁ±ª‰∫ßÂìÅÁöÑÊÄªÁß∞„ÄÇ","It refers to alloy products not falling into any specific category.","2013-07-09T08:00:00","2019-05-05T17:18:58"]
[4120,"CS003003","ÊïôËÇ≤Âí®ËØ¢","Education Consulting","CS003","CS003",1,"CSF_25302010","ÊåáÊèê‰æõÊïôËÇ≤ËµÑÊ∫ê‰ø°ÊÅØÂíåÂÜ≥Á≠ñÁöÑÊúçÂä°ÔºåÂåÖÊã¨ÁïôÂ≠¶‰∏≠‰ªãÁ≠â„ÄÇ","It refers to services related to education resource information and decision-making. It includes study abroad agencies.","2014-07-21T17:04:41","2019-05-08T16:05:58"]
[5850,"CC0050010522","Â°ëÊñôÂèëÊ≥°ÂâÇ","Plastic Foamer","CC0050010523","CC005, CC005001, CC00500105, CC0050010524, CC0050010523",1,"CSF_15101050","‰∏ªË¶ÅÊåá‰∏∫Âà∂ÈÄ†ÂèëÊ≥°Â°ëÊñôËÄåÊ∑ªÂä†ÁöÑ‰∏ÄÁ±ªÂä©ÂâÇ„ÄÇ","It refers to additives used in manufacture of expanded plastic.","2017-12-29T10:05:32","2019-03-28T02:36:46"]
[4913,"CC00500161","ÂºÇÊ∞∞ÈÖ∏ÈÖØ","Isocyanate","CC005001","CC005, CC005001",1,"CSF_15101050","ÊòØÊó†Ëâ≤Ê∏Ö‰∫ÆÊ∂≤‰Ωì, ÊúâÂº∫Âà∫ÊøÄÊÄßÁöÑÂºÇÊ∞∞ÈÖ∏ÂêÑÁßçÈÖØÊÄªÁß∞„ÄÇ","It refers to a colorless and clear liquid which is dangerously irritant.","2015-07-07T14:50:27","2019-03-28T02:36:46"]
[2432,"EE001005","ÂÆâÈò≤ÁõëÊéßËÆæÂ§á","Security Monitoring Equipment","EE001008","EC004, EE001, EE001015, EE001008",1,"CSF_45203030","‰∏ªË¶ÅÊåáÈÄöËøáÊëÑÂÉèÊú∫ÁõëÊéßÊù•Á°Æ‰øùÂÆâÂÖ®ÁöÑËÆæÂ§áÔºåÂåÖÊã¨ÁîµËßÜÁõëÊéßÁ≥ªÁªü„ÄÅÊä•Ë≠¶ÊéßÂà∂Á≥ªÁªü„ÄÅËøúÁ®ãÂõæÂÉè‰º†ËæìËÆæÂ§á‰∫ßÂìÅÁ≠â„ÄÇ","It refers to equipment used to ensure security with monitoring by cameras. It includes television supervisory systems, alarming control systems, and remote image transmission equipment.","2013-07-09T08:00:00","2019-05-05T19:03:05"]
[3867,"LP00100403","ËΩ¶Á±ªÁé©ÂÖ∑","Toy Vehicles","LP001004","LP001, LP001004",1,"CSF_25202010","ËΩ¶Á±ªÁé©ÂÖ∑ÔºåÂåÖÊã¨Áé©ÂÖ∑Ê±ΩËΩ¶Áé©ÂÖ∑ÁÅ´ËΩ¶Á≠â","It refers to toys in the form of vehicles, such as cars, trains, etc.","2014-07-16T14:25:53","2019-04-27T18:18:36"]
[1536,"ME00100802","È£ûÊú∫Â™í‰ªã‰ª£ÁêÜ","Aircraft Advertising Agent Services","ME001008","ME001, ME001011, ME00101102, ME00101105, ME001008",1,"CSF_25401055","Êåá‰ª£ÁêÜÈîÄÂîÆ‰ª•È£ûÊú∫‰Ωú‰∏∫ËΩΩ‰ΩìÁöÑÂ™í‰ΩìÂπøÂëäËµÑÊ∫êÊâÄËé∑ÂæóÁöÑÊî∂ÂÖ•„ÄÇ","It refers to sales agent services of advertising resources with aircraft as the media.","2013-07-09T08:00:00","2019-03-28T02:36:50"]

{"sheet":"sam_dict_industry","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"flags":["formulas_cached_only"]}
["id","code","name","name_en","parent","ancestors","create_time","update_time"]
["5141beb016f2555859123101","CSF_4020","ÁªºÂêàÈáëËûç","Diversified Financials","CSF_40","CSF_40","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230b5","CSF_25302020","ÁâπÊÆäÊ∂àË¥πËÄÖÊúçÂä°","Specialized Consumer Services","CSF_253020","CSF_25, CSF_2530, CSF_253020","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f255585912308c","CSF_203020","Ëà™Á©∫ÂÖ¨Âè∏","Airlines","CSF_2030","CSF_20, CSF_2030","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f2555859123075","CSF_201040","ÁîµÊ∞îËÆæÂ§á","Electrical Equipment","CSF_2010","CSF_20, CSF_2010","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230e8","CSF_351020","ÂåªÁñó‰øùÂÅ•Êèê‰æõÂïÜ‰∏éÊúçÂä°","Health Care Providers & Services","CSF_3510","CSF_35, CSF_3510","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230d5","CSF_302010","È•ÆÊñô","Beverages","CSF_3020","CSF_30, CSF_3020","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230f1","CSF_35201010","ÁîüÁâ©ÁßëÊäÄ","Biotechnology","CSF_352010","CSF_35, CSF_3520, CSF_352010","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230b1","CSF_25301030","Ê∂àÈó≤ËÆæÊñΩ","Leisure Facilities","CSF_253010","CSF_25, CSF_2530, CSF_253010","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230ad","CSF_2530","Ê∂àË¥πËÄÖÊúçÂä°","Consumer Services","CSF_25","CSF_25","2013-03-14T08:00:00","2013-03-14T08:00:00"]
["5141beb016f25558591230e7","CSF_35101020","ÂåªÁñó‰øùÂÅ•Áî®ÂìÅ","Health Care Supplies","CSF_351010","CSF_35, CSF_3510, CSF_351010","2013-03-14T08:00:00","2013-03-14T08:00:00"]

{"sheet":"sam_base_stock","index":3,"n_rows":11,"n_cols":15,"rows_kept":11,"flags":["formulas_cached_only"]}
["id","code","ticker","orgid","abbr","abbr_en","abbr_py","mkt_code","mkt_en","mkt","list_status","list_dt","list_edt","create_time","update_time"]
["S000451","08305_HK_EQ_DL","08305DL",10004837,"Ê±üÊô®ÂõΩÈôÖ","JIANGCHEN INTL","jcgj",1007,"HKEX GEM","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄÂàõ‰∏öÊùø","TF","2015-03-27","2016-08-15","2012-09-05T08:00:00","2019-03-25T18:34:15"]
["S10001376","08320_HK_EQ_DL","08320DL",10061314,"ÊÄùÂüéÊéßËÇ°","C CHENG HLDGS","sckg",1007,"HKEX GEM","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄÂàõ‰∏öÊùø","TF","2013-12-20","2015-07-31","2013-12-18T11:35:21","2016-10-21T02:12:23"]
["S10001164","08185_HK_EQ",8185,10061108,"Âæ°ËçØÂ†Ç","RM GROUP","yyt",1007,"HKEX GEM","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄÂàõ‰∏öÊùø","TF","2013-10-11","2015-11-19","2013-11-26T19:16:58","2018-07-18T03:09:21"]
["S10006113","03699_HK_EQ_DL","03699DL",10065851,"‰∏áËææÂïÜ‰∏ö","Wanda Comm","wdsy",1006,"HKEX Main Board","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄ‰∏ªÊùø","DL","2014-12-23","2016-09-20","2014-12-10T14:47:23","2019-03-25T18:44:05"]
["S10001264","03386_HK_EQ",3386,10061204,"‰∏úÈπèÊéßËÇ°","DONGPENG HLDG","dpkg",1006,"HKEX Main Board","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄ‰∏ªÊùø","DL","2013-12-09","2016-06-22","2013-12-03T13:14:59","2018-05-26T02:41:37"]
["S10002433","06199_HK_EQ",6199,10008071,"‰∏≠ÂõΩÂåóËΩ¶-H","CNR-H","zgbc",1006,"HKEX Main Board","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄ‰∏ªÊùø","DL","2014-05-22","2015-05-20","2014-05-15T15:35:05","2019-03-25T18:43:42"]
["S10005543","01438_HK_EQ",1438,10065826,"ÂØåË¥µÁîüÂëΩ","Nirvana Asia","fgsm",1006,"HKEX Main Board","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄ‰∏ªÊùø","DL","2014-12-17","2016-10-06","2014-12-08T09:05:49","2019-03-22T23:42:55"]
["S10001537","08309_HK_EQ_DL","08309DL",10061469,"Êó∂Â∞öÁéØÁêÉ","RUNWAY GLOBAL","sshq",1007,"HKEX GEM","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄÂàõ‰∏öÊùø","TF","2013-12-03","2015-05-29","2014-01-02T14:48:54","2017-11-07T00:34:49"]
["S10001162","08036_HK_EQ_DL","08036DL",10061103,"Êô∂ËäØÁßëÊäÄÊéßËÇ°","GOLDENMARS","jxkjkg",1007,"HKEX GEM","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄÂàõ‰∏öÊùø","DL","2013-09-09","2016-03-29","2013-11-26T19:16:58","2018-07-02T17:59:54"]
["S10001536","08107_HK_EQ_DL","08107DL",10061468,"Ë™âÂÆ¥ÈõÜÂõ¢","U BANQUET GP","yyjt",1007,"HKEX GEM","È¶ôÊ∏ØËØÅÂà∏‰∫§ÊòìÊâÄÂàõ‰∏öÊùø","DL","2013-12-10","2015-08-28","2014-01-02T14:48:54","2018-04-25T19:30:33"]