中国上市公司新闻关联表


时间区间

2016.01.01-2023.10.16


字段展示

中国上市公司新闻关联表-英文字段中国上市公司新闻关联表-中文字段
ID自增ID
NEWS_ID新闻id
RELATED_COMPANY_ID公司内部ID
TICKER_SYMBOL交易代码
EXCHANGE_CD交易市场代码
SEC_SHORT_NAME证券简称
RELATED_COMPANY_DEGREE关联等级
DEGREE_PROP_1ST关联等级为1的置信度
DEGREE_PROP_2ST关联等级为2的置信度
RELATED_COMPANY_SCORE关联得分
EFFECTIVE_TIME新闻有效发布时间
UPDATE_TIME更新时间

样本数据

IDNEWS_IDRELATED_COMPANY_IDTICKER_SYMBOLEXCHANGE_CDSEC_SHORT_NAMERELATED_COMPANY_DEGREEDEGREE_PROP_1STDEGREE_PROP_2STRELATED_COMPANY_SCOREEFFECTIVE_TIMEUPDATE_TIME
自增ID新闻id公司内部ID交易代码交易市场代码证券简称关联等级关联等级为1的置信度关联等级为2的置信度关联得分新闻有效发布时间更新时间
3026366821531242982073002594XSHE比亚迪10.9999703168869020.00000455213375970.4999897105772112023-10-11 23:59:582023-10-12 00:00:01
302636684153124298914624300750XSHE宁德时代10.9999748468399050.00000447849470220.4999919019146552023-10-11 23:59:582023-10-12 00:00:01
30263668615312429835321300014XSHE亿纬锂能10.9999645948410030.00000326442977890.4999855618502812023-10-11 23:59:582023-10-12 00:00:01
30263668715312429837535002460XSHE赣锋锂业10.9999742507934570.00000375996728510.4999908853640142023-10-11 23:59:582023-10-12 00:00:01
30263668815312429867032300438XSHE鹏辉能源10.9999675750732420.00000362048672290.4999874080233442023-10-11 23:59:582023-10-12 00:00:01
3026366891531242986297440688567XSHG孚能科技10.999970793724060.0000037972688460.4999891941308762023-10-11 23:59:582023-10-12 00:00:01
30263669015312429848000049XSHE德赛电池10.9999762773513790.00000424244944950.4999923811251392023-10-11 23:59:582023-10-12 00:00:01
30263669515312430415750601162XSHG天风证券10.9999781847000120.00000482638870380.499993918738712023-10-11 23:59:562023-10-12 00:00:02
30263669815312430432856002262XSHE恩华药业10.9999563694000240.00000677498792360.4999849596879362023-10-11 23:59:562023-10-12 00:00:02
302636692153124304662600079XSHG人福医药20.00001059762689690.9999783039093020.999983602722752023-10-11 23:59:562023-10-12 00:00:02
30263669915312431170014603958XSHG哈森股份20.00000789118348620.9999839067459110.9999878523376542023-10-11 23:59:322023-10-12 00:00:22
30263670815312431461000069XSHE华侨城A20.00004035883102920.9999544620513920.9999746414669062023-10-12 00:01:062023-10-12 00:01:08
302636710153124315347000786XSHE北新建材10.999938845634460.00000976191768130.4999791847349112023-10-12 00:00:372023-10-12 00:01:14
30263671615312431569000100XSHETCL科技10.9998456239700320.00014110413030720.5000639161153232023-10-12 00:00:372023-10-12 00:01:14
3026367171531243153522000333XSHE美的集团10.9999738931655880.00001097075073630.499997917333532023-10-12 00:00:372023-10-12 00:01:14
3026367121531243151422987688295XSHG中复神鹰20.00008647592767370.9998986721038820.9999419100677192023-10-12 00:00:372023-10-12 00:01:14
30263672015312432040206601519XSHG大智慧10.9999196529388430.00000522960908710.4999650560785082023-10-12 00:00:372023-10-12 00:01:26
3026367211531243201033600519XSHG贵州茅台10.9998962879180910.0000145821077240.4999627260667692023-10-12 00:00:372023-10-12 00:01:26
30263672315312432161000069XSHE华侨城A20.00001680955756460.9999769926071170.9999853973858992023-10-12 00:01:012023-10-12 00:01:28
3026367251531243231214600708XSHG光明地产20.00001248392345590.9999800920486450.9999863340103732023-10-12 00:01:012023-10-12 00:01:28
3026367261531243241427057301307XSHE美利信20.00008778285700830.9998126626014710.9998565540299752023-10-12 00:01:362023-10-12 00:01:38
30263672815312432470398601127XSHG赛力斯20.07612466067075730.923716664314270.9617789946496492023-10-12 00:01:362023-10-12 00:01:38
30263673415312432730826688235XSHG百济神州10.9999785423278810.00000526564554090.4999945368094812023-10-12 00:01:432023-10-12 00:01:46
302636749153124332848616603477XSHG巨星农牧20.00001085290750780.9999823570251460.99998778347892023-10-12 00:01:312023-10-12 00:01:51
3026367531531243332060600048XSHG保利发展10.9999027252197270.00008404396066910.5000354065705322023-10-12 00:01:492023-10-12 00:01:51
3026367551531243334673001979XSHE招商蛇口10.9895573258399960.01038786210119720.5051665250211952023-10-12 00:01:492023-10-12 00:01:51
30263675615312433332000031XSHE大悦城10.9705204367637630.02939871698617940.5146589353680612023-10-12 00:01:492023-10-12 00:01:51
3026367581531243333000002XSHE万科A10.999859333038330.00000660580235490.499936272321522023-10-12 00:01:492023-10-12 00:01:51
30263676915312433832991601668XSHG中国建筑10.9999743700027470.00001082221842810.4999980072198012023-10-12 00:01:492023-10-12 00:01:54
30263678515312435337274601012XSHG隆基绿能10.9999748468399050.00000354453504770.4999909679552023-10-12 00:01:402023-10-12 00:02:36
3026367881531243536275110688469XSHG中芯集成10.9999791383743290.00000463050173490.4999941996888992023-10-12 00:01:402023-10-12 00:02:36
30263679115312435329262002230XSHE科大讯飞10.9999619722366330.00000726393409420.4999882500524112023-10-12 00:01:402023-10-12 00:02:36
3026367981531243563000002XSHE万科A10.9999673366546630.00000402556952390.4999876938968552023-10-12 00:01:532023-10-12 00:02:52
3026368151531243573000002XSHE万科A10.9999781847000120.00000981455832520.4999989069083312023-10-12 00:01:532023-10-12 00:03:04
302636818153124357824600258XSHG首旅酒店10.9998195767402650.00016217840311580.5000719667732482023-10-12 00:01:532023-10-12 00:03:04
3026368091531243622073002594XSHE比亚迪10.9999755620956420.00000358882061850.499991369868442023-10-12 00:02:562023-10-12 00:03:00
302636810153124362226000625XSHE长安汽车10.9999780654907230.00000394965536540.4999929824007272023-10-12 00:02:562023-10-12 00:03:00
30263681215312436392187603239XSHG浙江仙通20.00001135101592810.9999833106994630.9999889862074272023-10-12 00:03:012023-10-12 00:03:04
30263682315312436766234300408XSHE三环集团10.8417872786521910.1581405848264690.5790342241525652023-10-12 00:03:052023-10-12 00:03:07
3026368301531243696003326300779XSHE惠城环保10.9999749660491940.00000649703542880.4999939800600262023-10-12 00:03:362023-10-12 00:03:40
30263683415312436992106830832XBEI齐鲁华信10.9999712705612180.0000124325806610.499998067861272023-10-12 00:03:362023-10-12 00:03:40
30263684615312438176872300677XSHE英科医疗10.971451401710510.02845682762563230.5141825284808872023-10-12 00:04:022023-10-12 00:04:04
3026368401531243822060600048XSHG保利发展10.9999568462371830.00003267663851150.5000110997571032023-10-12 00:04:022023-10-12 00:04:04
3026368411531243821893601728XSHG中国电信10.9999779462814330.0000055537184380.4999945268591552023-10-12 00:04:022023-10-12 00:04:04
3026368431531243824673001979XSHE招商蛇口10.9999120235443120.00007401553739330.5000300273095492023-10-12 00:04:022023-10-12 00:04:04
302636850153124383818616300733XSHE西菱动力20.00000816298233990.9999822378158570.9999863193070272023-10-11 22:58:022023-10-12 00:04:20
30263685215312438427288002945XSHE华林证券20.00003819942503470.9999555349349980.9999746346475152023-10-11 22:58:012023-10-12 00:04:20
302636863153124386200000596XSHE古井贡酒10.71993476152420.2797095775604250.6396769583225252023-10-12 00:04:212023-10-12 00:04:24
302636864153124386359000799XSHE酒鬼酒10.9999740123748780.00000745736815590.4999944635555952023-10-12 00:04:212023-10-12 00:04:24

数据更新频率

年度更新,特殊需求另行联系