新闻关联公司及情感得分表
时间区间
2016.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 | 新闻有效发布时间 |
样本数据
| 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 |
数据更新频率
年度更新，特殊需求另行联系