中国新闻关联信息数据简介
中国新闻关联信息数据是CnOpenData与通联数据合作的数据库,包含6张表格,分别是:
- 新闻关联公司及情感得分表:获取新闻关联的公司、证券情感分数信息,包含新闻ID、关联公司ID、新闻发布时间、新闻情感分数等信息。
- 新闻关联标签表:记录新闻关联的所有类型属性标签信息,根据新闻来源、新闻篇幅、新闻其他特点(是否是政策类、是否是数据类、是否包含图表)等对新闻自动打标签。标签包括是否是基本面新闻、是否是数据型新闻、是否是政策新闻等,也包含新闻的申万行业分类,新闻类别,是否财经类以及是否重复等信息。
- 新闻证券关联表:记录新闻和期货、基金、债券、股票产品的关联关系,包含关联等级、关联等分、股票交易代码和产品内部代码等。
- 期货标签表:记录公司关联标签表一级分类期货标签的细分结果,包含金融期货、化工、能源、金属、农副产品等,具体到期货产品。
- 政策分类表:记录政策类新闻分类,包含申万一级行业、宏观、非政策类共33个类别。
- 新闻基金经理关联表:记录新闻中提及的公募基金经理表和新闻的关联关系。
时间区间
- 新闻关联公司及情感得分表: 2016.01.01-2023.10.16
- 新闻关联标签表:2016.01.01-2023.10.16
- 新闻证券关联表: 2020.01.01-2023.10.16
- 期货标签表:2019.01.01-2023.10.16
- 政策分类表:2016.01.01-2023.10.16
- 新闻基金经理关联表:2019.01.01 -2023.10.16
字段展示
新闻关联公司及情感得分表
新闻关联公司及情感得分表-英文字段 | 新闻关联公司及情感得分表-中文字段 |
---|
ID | 自增ID |
NEWS_ID | 新闻ID |
RELATED_COMPANY_ID | 公司内部ID |
RELATED_COMPANY_DEGREE | 关联等级 |
DEGREE_PROP_1ST | 关联等级为1的置信度 |
DEGREE_PROP_2ST | 关联等级为2的置信度 |
RELATED_COMPANY_SCORE | 关联得分 |
SENTIMENT | 情感分类 |
SENTIMENT_SCORE | 情感打分 |
UPDATE_TIME | 更新时间 |
EFFECTIVE_TIME | 新闻有效发布时间 |
新闻关联标签表
新闻关联标签表-英文字段 | 新闻关联标签表-中文字段 |
---|
NEWS_ID | 新闻ID |
EFFECTIVE_TIME | 新闻有效发布时间 |
MAIN_GROUP_ID | 新闻在新闻全集中是否重复 |
CLUSTER_ID | 关联类id |
NEWS_GENRE | 新闻类别 |
IS_PRO_SITE | 网站类别标签 |
IS_ECONOM | 是否包含基本面信息 |
IS_DATA | 是否包含数据信息 |
IS_LONG_NEWS | 是否是长新闻 |
IS_SHORT_NEWS | 是否是短新闻 |
IS_MONTH_DATA | 是否是月度数据 |
IS_POLICY | 是否是国家发布的政策 |
IS_PICTURE | 是否是图片式新闻 |
IS_PERIOD | 是否是定期报告 |
IS_WECHARTSTOCK | 是否是公司微信公众号 |
IS_RUMOUR | 是否是传闻 |
IS_RUMOUR_RESPONSE | 是否是传闻回应 |
MINISTRY | 部委新闻的发布来源 |
INDUSTRY_NAME_1ST | 一级分类 |
INDUSTRY_NAME_2ND | 二级分类 |
INDUSTRY_NAME_3RD | 三级分类 |
UPDATE_TIME | 更新时间 |
新闻证券关联表
新闻证券关联表-英文字段 | 新闻证券关联表-中文字段 |
---|
ID | 自增ID |
NEWS_ID | 新闻id |
SECURITY_INT_ID | 证券内部id |
SEC_SHORT_NAME | 证券简称 |
ASSET_CLASS | 证券类型 |
TICKER_SYMBOL | 交易代码 |
PARTY_ID | 机构内部id |
RELATED_DEGREE | 关联等级 |
RELATED_SCORE | 关联得分 |
DEGREE_PROP_1ST | 关联等级为1的置信度 |
DEGREE_PROP_2ED | 关联等级为2的置信度 |
EFFECTIVE_TIME | 新闻有效发布时间 |
INSERT_TIME | 入库时间 |
UPDATE_TIME | 更新时间 |
期货标签表
期货标签表-英文字段 | 期货标签表-中文字段 |
---|
ID | 信息编码 |
NEWS_ID | 新闻ID |
INDUSTRY_NAME_1ST | 一级分类 |
INDUSTRY_NAME_2ND | 二级分类 |
INDUSTRY_NAME_3RD | 三级分类 |
RELATED_SCORE | 关联得分 |
RELATED_DEGREE | 关联等级 |
CREATE_TIME | 创建时间 |
UPDATE_TIME | 更新时间 |
政策分类表
政策分类表-英文字段 | 政策分类表-中文字段 |
---|
ID | 自增ID |
NEWS_ID | 新闻ID |
NEWS_INDUSTRY_NAME | 行业分类名 |
NEWS_SITE_NAME | 抓取网站名 |
SOURCE_NAME | 新闻原始出处 |
NEWS_EFFECTIVE_TIME | 新闻发布时间 |
UPDATE_TIME | 更新时间 |
新闻基金经理关联表
新闻基金经理关联表-英文字段 | 新闻基金经理关联表-中文字段 |
---|
ID | 自增ID |
NEWS_ID | 新闻id |
RELATED_MANAGER_ID | 关联基金经理id |
RELATED_MANAGER_NAME | 关联基金经理名称 |
UPDATE_TIME | 更新时间 |
EFFECTIVE_TIME | 有效发布时间 |
RELATED_PARTY_ID | 关联公司id |
样本数据
新闻关联公司及情感得分表
ID | NEWS_ID | RELATED_COMPANY_ID | RELATED_COMPANY_DEGREE | DEGREE_PROP_1ST | DEGREE_PROP_2ST | RELATED_COMPANY_SCORE | SENTIMENT | SENTIMENT_SCORE | UPDATE_TIME | EFFECTIVE_TIME |
---|
自增ID | 新闻ID | 公司内部ID | 关联等级 | 关联等级为1的置信度 | 关联等级为2的置信度 | 关联得分 | 情感分类 | 情感打分 | 更新时间 | 新闻有效发布时间 |
329986621 | 153124298 | 2073 | 1 | 0.9977434873580933 | 0.0021694533061236143 | 0.5010411969851702 | 0 | 0.05163803696632385 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986622 | 153124298 | 1540781 | 1 | 0.9983526468276978 | 0.0015843490837141871 | 0.5007606724975631 | 0 | 0.010870468616485596 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986623 | 153124298 | 914624 | 1 | 0.9969242215156555 | 0.0029943741392344236 | 0.5014564848970622 | 0 | 0.07697080671787263 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986624 | 153124298 | 33291 | 1 | 0.9981191754341125 | 0.0017950704786926508 | 0.5008546581957489 | 1 | 0.5244924783706666 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986625 | 153124298 | 35321 | 1 | 0.9987963438034058 | 0.00107648316770792 | 0.5004746550694108 | 0 | 0.05099309682846069 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986626 | 153124298 | 37535 | 1 | 0.9986957907676697 | 0.001175141311250627 | 0.5005230366950855 | 0 | 0.04836136698722839 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986627 | 153124298 | 67032 | 1 | 0.9983079433441162 | 0.0015800073742866516 | 0.5007339790463448 | 0 | 0.04962312877178192 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986628 | 153124298 | 6297440 | 1 | 0.9986629486083984 | 0.001230650465004146 | 0.5005621247692034 | 0 | 0.08088825978338718 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986629 | 153124298 | 48 | 1 | 0.9986791014671326 | 0.001196879195049405 | 0.5005364299286157 | 0 | 0.0018266618251800537 | 2023-10-12 00:00:01 | 2023-10-11 23:59:58 |
329986630 | 153124303 | 6299781 | 2 | 0.3662683367729187 | 0.6318308115005493 | 0.8149649798870087 | 0 | 0.0480544775724411 | 2023-10-12 00:00:02 | 2023-10-11 23:59:56 |
329986631 | 153124304 | 662 | 2 | 0.000412617897382 | 0.9995854496955872 | 0.9997917586442782 | -1 | -0.39090460538864136 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986632 | 153124304 | 15750 | 1 | 0.9246727228164673 | 0.035183195024728775 | 0.4975195564329624 | 0 | -0.06726701259613037 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986633 | 153124304 | 6286 | 1 | 0.9442554712295532 | 0.04694878309965134 | 0.519076518714428 | 0 | -0.06654462814331055 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986634 | 153124304 | 6253935 | 1 | 0.9564889669418335 | 0.03284020721912384 | 0.5110846906900406 | 0 | 0.03329164683818817 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986635 | 153124304 | 892487 | 1 | 0.9294070601463318 | 0.04951632767915726 | 0.5142198577523232 | 0 | -0.06350528001785279 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986636 | 153124304 | 73408 | 1 | 0.9320065379142761 | 0.05153271183371544 | 0.5175359807908535 | 0 | -0.06378472447395325 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986637 | 153124304 | 32856 | 1 | 0.9313799738883972 | 0.05681532621383667 | 0.5225053131580353 | 0 | -0.011524277925491332 | 2023-10-12 00:00:03 | 2023-10-11 23:59:56 |
329986638 | 153124311 | 70014 | 1 | 0.5828976035118103 | 0.3681276738643646 | 0.6595764756202698 | 0 | -0.05793848633766174 | 2023-10-12 00:00:22 | 2023-10-11 23:59:32 |
329986639 | 153124311 | 26813 | 1 | 0.9228072762489319 | 0.05449042096734047 | 0.5158940590918064 | 0 | 0.032573872804641725 | 2023-10-12 00:00:22 | 2023-10-11 23:59:32 |
329986640 | 153124311 | 26504 | 0 | 0.012075640261173248 | 0.0000242141923081 | 0.00606203432289476 | 0 | 0.0 | 2023-10-12 00:00:22 | 2023-10-11 23:59:32 |
329986641 | 153124311 | 692 | 0 | 0.15322963893413544 | 0.0007336193230003 | 0.07734843879006803 | 0 | 0.0 | 2023-10-12 00:00:22 | 2023-10-11 23:59:32 |
329986642 | 153124311 | 26959 | 0 | 0.0778961330652237 | 0.0031620694790035486 | 0.042110136011615396 | 0 | 0.0 | 2023-10-12 00:00:22 | 2023-10-11 23:59:32 |
329986643 | 153124312 | 34926 | 2 | 0.025363413617014885 | 0.8993794322013855 | 0.9120611390098929 | 0 | -0.023397231101989747 | 2023-10-12 00:00:46 | 2023-10-12 00:00:44 |
329986644 | 153124312 | 1326269 | 1 | 0.5249148011207581 | 0.3931940495967865 | 0.6556514501571655 | 0 | 0.00951206386089325 | 2023-10-12 00:00:46 | 2023-10-12 00:00:44 |
329986645 | 153124312 | 1326266 | 1 | 0.6807010173797607 | 0.23856352269649506 | 0.5789140313863754 | 0 | 0.00964447557926178 | 2023-10-12 00:00:46 | 2023-10-12 00:00:44 |
329986646 | 153124312 | 6048609 | 1 | 0.6361732482910156 | 0.32223859429359436 | 0.6403252184391022 | 0 | 0.0016840726137161254 | 2023-10-12 00:00:46 | 2023-10-12 00:00:44 |
329986647 | 153124314 | 61 | 2 | 0.0035596729721874 | 0.9962968230247498 | 0.9980766595108435 | 0 | 0.015255710482597351 | 2023-10-12 00:01:08 | 2023-10-12 00:01:06 |
329986648 | 153124314 | 10000571 | 2 | 0.39173391461372375 | 0.5963079333305359 | 0.7921748906373978 | 0 | 0.035366973280906676 | 2023-10-12 00:01:08 | 2023-10-12 00:01:06 |
329986649 | 153124315 | 2306 | 1 | 0.9999051094055176 | 0.0000036177343645 | 0.4999561724371233 | 0 | 0.14057573676109314 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986650 | 153124315 | 3522 | 1 | 0.9998500347137451 | 0.0000065095700847 | 0.4999315269269573 | 0 | -0.014107155799865722 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986651 | 153124315 | 97685 | 1 | 0.9932905435562134 | 0.0000039071937863 | 0.496649178971893 | 0 | 0.025464838743209837 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986652 | 153124315 | 347 | 1 | 0.999868631362915 | 0.0000026332247671 | 0.49993694890622464 | 0 | 0.14298757910728455 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986653 | 153124315 | 1875 | 1 | 0.9998840093612671 | 0.0000023782697554 | 0.4999443829503889 | 0 | 0.024065375328063965 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986654 | 153124315 | 850988 | 1 | 0.9999170303344727 | 0.0000016846094013 | 0.49996019977663764 | 0 | 0.02526373267173767 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986655 | 153124315 | 13866 | 1 | 0.9999041557312012 | 0.0000022927986265 | 0.4999543706642271 | 0 | 0.02526373267173767 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986656 | 153124315 | 69 | 1 | 0.9998540878295898 | 0.0000027616463285 | 0.49992980556112343 | 0 | 0.02526373267173767 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986657 | 153124315 | 1422987 | 1 | 0.9998846054077148 | 0.0000057791744439 | 0.4999480818783013 | -1 | -0.5125256717205048 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986658 | 153124315 | 10001011 | 1 | 0.9936489462852478 | 0.0000023048560251 | 0.49682677799864905 | 0 | 0.02526373267173767 | 2023-10-12 00:01:15 | 2023-10-12 00:00:37 |
329986659 | 153124320 | 1172771 | 1 | 0.9997277855873108 | 0.000118962227134 | 0.49998285502078943 | 0 | 0.04029990136623383 | 2023-10-12 00:01:26 | 2023-10-12 00:00:37 |
329986660 | 153124320 | 1033 | 1 | 0.9997852444648743 | 0.0001224137813551 | 0.5000150360137923 | 0 | 0.03920808136463165 | 2023-10-12 00:01:26 | 2023-10-12 00:00:37 |
329986661 | 153124320 | 40206 | 1 | 0.9927402138710022 | 0.0001678625849308 | 0.49653796952043194 | 0 | 0.03448604643344879 | 2023-10-12 00:01:26 | 2023-10-12 00:00:37 |
329986662 | 153124321 | 61 | 2 | 0.0024911805521696806 | 0.9974820017814636 | 0.9987275920575485 | 0 | 0.018054971098899843 | 2023-10-12 00:01:28 | 2023-10-12 00:01:01 |
329986663 | 153124321 | 10000571 | 2 | 0.41603073477745056 | 0.5559253692626953 | 0.7639407366514206 | 0 | 0.040377870202064514 | 2023-10-12 00:01:28 | 2023-10-12 00:01:01 |
329986664 | 153124323 | 1214 | 2 | 0.004276076797395945 | 0.9956693649291992 | 0.9978074033278972 | 1 | 0.6623147845268249 | 2023-10-12 00:01:28 | 2023-10-12 00:01:01 |
329986665 | 153124324 | 1427057 | 2 | 0.0017754866275936365 | 0.998177170753479 | 0.9990649140672758 | 0 | 0.011575797572731972 | 2023-10-12 00:01:38 | 2023-10-12 00:01:36 |
329986666 | 153124324 | 32244 | 1 | 0.6538084149360657 | 0.31791913509368896 | 0.6448233425617218 | 0 | 0.09265191629528999 | 2023-10-12 00:01:38 | 2023-10-12 00:01:36 |
329986667 | 153124324 | 1422974 | 1 | 0.7025539875030518 | 0.2577027380466461 | 0.608979731798172 | 0 | 0.017001168429851533 | 2023-10-12 00:01:38 | 2023-10-12 00:01:36 |
329986668 | 153124324 | 1533971 | 1 | 0.6847032904624939 | 0.2968199849128723 | 0.6391716301441193 | 0 | 0.05599194169044495 | 2023-10-12 00:01:38 | 2023-10-12 00:01:36 |
329986669 | 153124324 | 70398 | 1 | 0.5183664560317993 | 0.45848074555397034 | 0.71766397356987 | 1 | 0.5720961600542069 | 2023-10-12 00:01:38 | 2023-10-12 00:01:36 |
新闻关联标签表
NEWS_ID | EFFECTIVE_TIME | MAIN_GROUP_ID | CLUSTER_ID | NEWS_GENRE | IS_PRO_SITE | IS_ECONOM | IS_DATA | IS_LONG_NEWS | IS_SHORT_NEWS | IS_MONTH_DATA | IS_POLICY | IS_PICTURE | IS_PERIOD | IS_WECHARTSTOCK | IS_RUMOUR | IS_RUMOUR_RESPONSE | MINISTRY | INDUSTRY_NAME_1ST | INDUSTRY_NAME_2ND | INDUSTRY_NAME_3RD | UPDATE_TIME |
---|
新闻ID | 新闻有效发布时间 | 新闻在新闻全集中是否重复 | 关联类id | 新闻类别 | 网站类别标签 | 是否包含基本面信息 | 是否包含数据信息 | 是否是长新闻 | 是否是短新闻 | 是否是月度数据 | 是否是国家发布的政策 | 是否是图片式新闻 | 是否是定期报告 | 是否是公司微信公众号 | 是否是传闻 | 是否是传闻回应 | 部委新闻的发布来源 | 一级分类 | 二级分类 | 三级分类 | 更新时间 |
153124298 | 2023-10-11 23:59:58 | -1 | 153121471 | 普通新闻 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | stock | 有色金属 | | 2023-10-12 00:05:12 |
153124299 | 2023-10-11 23:59:58 | -1 | 153122263 | 普通新闻 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | none | | | 2023-10-12 00:05:12 |
153124300 | 2023-10-12 00:00:00 | -1 | 148110868 | 普通新闻 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | market | 非银金融 | | 2023-10-12 00:05:12 |
153124301 | 2023-10-11 23:59:56 | -1 | 153124243 | 普通新闻 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | bond | 传媒 | | 2023-10-12 00:05:12 |
153124303 | 2023-10-11 23:59:56 | -1 | 153122706 | 普通新闻 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | none | | | 2023-10-12 00:05:12 |
153124304 | 2023-10-11 23:59:56 | -1 | 153123110 | 普通新闻 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | stock | 医药生物 | | 2023-10-12 00:05:12 |
153124305 | 2023-10-12 00:00:01 | -1 | 153124255 | 普通新闻 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | stock | 农林牧渔 | | 2023-10-12 00:05:12 |
153124306 | 2023-10-12 00:00:01 | -1 | 153124287 | 普通新闻 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | bond | 银行 | | 2023-10-12 00:05:12 |
153124307 | 2023-10-12 00:00:01 | -1 | 153124243 | 普通新闻 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | none | stock | 传媒 | | 2023-10-12 00:05:12 |
153124308 | 2
|