ESG public opinion label information data is a database jointly developed by CnOpenData and Tonglian Data, which contains 2 tables, namely:
- ESG news event label table: record ESG feature label events.
- ESG news classification reference table: record ESG feature news event label system.
Time interval
2018.01.01-2023.10.16
Field display
< td>Category name < /tr>| ESG news event label table-English field | ESG news event label table-Chinese field | ESG News classification parameter table - English fields | ESG news classification parameter table - Chinese fields |
|---|---|---|---|
| ID | Auto-increment ID | ID | Information code |
| NEWS_ID | News ID | CLA SSIFY_NAME | Classification parameter name |
| COMPANY_ID | Company ID | TYPE_ID | Classification code |
| EVENT_ID | Event ID | TYPE_NAME | |
| EVENT_NAME | Event name | TYPE_LEVEL | Level |
| EVENT_PROP | Event confidence | PARENT_ID | Parent node |
| EFFECTIVE_TIME | Effective release time of news | UPDATE_TIME | Update time |
| UPDATE_TIME | Update time |
Sample data
ESG news event label table
2023-10-12 01:18:34| ID | NEWS_ID | COMPANY_ID | EVENT_ID | EVENT_NAME | EVENT_PROP | EFFECTIVE_TIME | UPDATE_TIME | |
|---|---|---|---|---|---|---|---|---|
| Auto-increment ID | News ID | Company ID | Event ID | Event Name | Event Confidence | Effective release time of news | Update time | |
| 4047992 | 153124440 | 24215 | 002002001 | Charity donation | 0.9723829627037048 | 2023-10-12 00:06:20 | 2023-10-12 00:06:22 | |
| 4047993 | 153124488 | 26966 | 003001001 | Executive changes | 0.9889287352561951 | 2023-10-12 00:05:30 | 2023-10-12 00:07:19 | |
| 4047994 | 153124488 | 26503 | 003001001 | Executive change | 0.99394291639328 | 202 3-10-12 00:05:30 | 2023-10-12 00:07:19 | |
| 4047995 | 153124808 | 24215 | 002002001 | Charity donation | 0.9723829627037048 | 2023-10-12 00:24:35 | 2023-10-12 00:24:37 | |
| 4047996 | 153124809 | 24215 | 002002001 | Public donation | 0.997191846370697 | 2 023-10-12 00:24:35 | 2023-10-12 2 023-10-12 00:25:21 | 2023-10-12 00:25:23 |
| 4047998 | 153124874 | 58 | 003001001 | Executive change | 0.9989582300186157 | 2023 -10-12 00:28:18 | 2023-10-12 00:28:23 | |
| 4047999 | 153124875 | 1667 | 003001001 | Executive change | 0.9993189573287964 | 20 23-10-12 00:28:20 | 2023-10-12 00:28:24 | |
| 4048000 | 153125023 | 1892 | 003001001 | Executive change | 0.9992903470993042 | 20 23-10-12 00:41:51 | 2023-10-12 00:41:52 | |
| 4048001 | 153125030 | 37396 | 001004004 | Green Finance | 0.998953104019165 | 20 23-10-12 00:43:55 | 2023-10-12 00:43:57 | |
| 4048002 | 153125075 | 58 | 003001001 | Executive change | 0.9989582300186157 | 2023 -10-12 00:48:32 | 2023-10-12 00:48:36 | |
| 4048003 | 153125766 | 26465 | 003001001 | Executive change | 0.23947295546531677 | 2023-10-12 2 023-10-12 01:22:42 | 2023-10-12 01:22:46 | |
| 4048005 | 153125800 | 38724 | 003001001 | Executive change | 0.174346923828125 | 20 23-10-12 01:23:11 | 2023-10-12 01:23:15 | |
| 4048006 | 153125835 | 26465 | 003001001 | Executive change | 0.2114531695842743 | 2 023-10-12 01:26:10 | 2023-10-12 01:26:13 | |
| 4048007 | 153125870 | 2029 | 003001001 | Executive change | 0.9993684887886047 | 20 23-10-12 01:28:56 | 2023-10-12 01:29:00 | |
| 4048008 | 153125883 | 24215 | 002002001 | Charity donation | 0.9723829627037048 | 2023-10-12 01:30:30 | 2023-10-12 01:30:33 | |
| 4048009 | 153125942 | 10001313 | 003001001 | Executive change | 0.9985091090202332 | 2023-10-12 01:35:55 | ||
| 4048010 | 153125942 | 956640 | 003001001 | Executive change | 0.9989253878593445 | 2023-10-12 01:35:55 | ||
| 4048011 | 153125987 | 10001313 | 003001001 | Executive change | 0.9989351630210876 | 2023-10-12 01:39:40 | ||
| 4048012 | 153125987 | 956640 | 003001001 | Executive change | 0.9990548491477966 | 2023-10-12 01:39:40 | ||
| 4048013 | 153126082 | 2029 | 003001001 | Executive change | 0.9993684887886047 | 20 23-10-12 01:49:59 | 2023-10-12 01:50:01 | |
| 4048016 | 153126255 | 10001313 | 003001001 | Executive change | 0.9989351630210876 | 2023-10-12 02:07:56 | ||
| 4048017 | 153126255 | 956640 | 003001001 | Executive change | 0.9990548491477966 | 2023-10-12 02:07:56 | ||
| 4048018 | 153126324 | 26503 | 003001001 | Executive change | 0.9996641874313354 | 2 023-10-12 02:16:24 | 2023-10-12 02:16:26 | |
| 4048019 | 153126324 | 26966 | 003001001 | Executive change | 0.9994710087776184 | 2 023-10-12 02:16:24 | 2023-10-12 02:16:26 | |
| 4048021 | 153126408 | 65908 | 002001005 | Employee Motivation | 0.4625566601753235 | 2 023-10-12 02:25:34 | 2023-10-12 02:25:42 | |
| 4048022 | 153126448 | 1310048 | 003001001 | Executive change | 0.5016881823539734 | 2023-10-12 02:30:32 | ||
| 4048023 | 153126448 | 1786 | 003001001 | Executive change | 0.7117650508880615 | 20 23-10-12 02:30:30 | 2023-10-12 02:30:32 | |
| 4048024 | 153126450 | 7427 | 002001005 | Employee Motivation | 0.948205828666687 | 202 3-10-12 02:30:44 | 2023-10-12 02:30:47 | |
| 4048025 | 153126533 | 27288 | 003001001 | Executive change | 0.9947911500930786 | 2 023-10-12 02:34:29 | 2023-10-12 02:34:30 | |
| 4048026 | 153126534 | 1334175 | 003001001 | Executive change | 0.8566380143165588 | 2023-10-12 02:34:37 | ||
| 4048027 | 153126867 | 65274 | 003001001 | Executive change | 0.993966817855835 | 20 23-10-12 02:48:22 | 2023-10-12 02:48:26 | |
| 4048028 | 153128225 | 67041 | 003001001 | Executive change | 0.9731431603431702 | 2 023-10-12 03:14:19 | 2023-10-12 03:14:22 | |
| 4048029 | 153128621 | 1495110 | 003001001 | Executive change | 0.9933308959007263 | 2023-10-12 03:25:21 | ||
| 4048030 | 153128641 | 1110130 | 003001001 | Executive change | 0.9844978451728821 | 2023-10-12 03:25:29 | ||
| 4048031 | 153128694 | 871108 | 002001005 | Employee Motivation | 0.9965229034423828 | 2023-10-12 03:25:42 | ||
| 4048032 | 153128700 | 1259206 | 003001001 | Executive change | 0.35759395360946655 | 2023-10-12 03:25:55 | ||
| 4048033 | 153128723 | 102 | 003001001 | Executive change | 0.9959152340888977 | 202 3-10-12 03:26:53 | 2023-10-12 03:26:54 | |
| 4048034 | 153128726 | 1892 | 003001001 | Executive change | 0.99395751953125 | 2023 -10-12 03:26:57 | 2023-10-12 03:27:00 | |
| 4048035 | 153128728 | 2029 | 003001001 | Executive change | 0.992270827293396 | 202 3-10-12 03:27:05 | 2023-10-12 03:27:07 | |
| 4048036 | 153128733 | 687 | 003001001 | Executive change | 0.9970587491989136 | 202 3-10-12 03:27:06 | 2023-10-12 03:27:12 | |
| 4048037 | 153128740 | 1346073 | 003001001 | Executive change | 0.2647198438644409 | 2023-10-12 03:27:29 | ||
| 4048038 | 153128834 | 928 | 003001001 | Executive change | 0.6575040221214294 | 202 3-10-12 03:28:20 | 2023-10-12 03:28:24 | |
| 4048039 | 153128834 | 6003439 | 003001001 | Executive change | 0.8543674945831299 | 2023-10-12 03:28:24 | ||
| 4048040 | 153128849 | 482 | 002001005 | Employee Motivation | 0.8951786160469055 | 202 3-10-12 03:28:33 | 2023-10-12 03:28:36 | |
| 4048041 | 153128850 | 1130 | 003001001 | Executive change | 0.2187199890613556 | 20 23-10-12 03:28:34 | 2023-10-12 03:28:36 | |
| 4048042 | 153128853 | 740 | 002001005 | Employee Motivation | 0.7727004289627075 | 202 3-10-12 03:28:39 | 2023-10-12 03:28:42 | |
| 4048043 | 153128857 | 13578 | 002001005 | Employee Motivation | 0.9876299500465393 | 2 023-10-12 03:28:51 | 2023-10-12 03:28:54 |
ESG News Classification Parameter Table
| ID | CLASSIFY_NAME | TYPE_ID | TYPE_NAME | TYPE_LEVEL | PARENT_ID | UPDATE _TIME |
|---|---|---|---|---|---|---|
| Information encoding | Classification parameter name | Classification code | Classification name | Belonging level | Parent node | Update time |
| 137 | ESG company event label | 001 | Environment | 1 | 0 | 2023-08-03 11:18:16 |
| 138 | ESG company event label | 002 | Society | 1 | 0 | 2023-08-03 11:18:16 |
| 139 | ESG company event label | 003 | Governance | 1 | 0 | 2023-08-03 11:18:16 |
| 141 | ESG company event label | 001002 | Pollution prevention | 2 | 001 | 2023-08-03 11:18:17 |
| 143 | ESG company event label | 001004 | Environmental management | 2 | 001 | 2023-08-03 11:18:17 |
| 145 | ESG company event label | 002001 | Employee rights | 2 | 002 | 2023-08-03 11:18:17 |
| 146 | ESG company event label | 002002 | Social response | 2 | 002 | 2023-08-03 11:18:17 |
| 148 | ESG company event label | 002004 | Product problem | 2 | 002 | 2023-08-03 11:18:17 |
| 149 | ESG company event label | 002005 | Supply chain management | 2 | 002 | 2023-08-03 11:18:17 |
| 151 | ESG company event label | 002007 | R&D and innovation | 2 | 002 | 2023-08-03 11:18:17 |
| 152 | ESG company event label | 002008 | Information security and privacy protection | 2 | 002 | 2023-08-03 11:18:17 |
| 154 | ESG company event label | 003001 | Governance structure | 2 | 003 | 2023-08-03 11:18:17 |
| 155 | ESG company event label | 003002 | Information disclosure | 2 | 003 | 2023-08-03 11:18:17 |
| 157 | ESG company event label | 003004 | Business ethics | 2 | 003 | 2023-08-03 11:18:17 |
| 158 | ESG company event label | 003005 | Risk management | 2 | 003 | 2023-08-03 11:18:18 |
| 162 | ESG company event label | 001002001 | Exceeding emission standards | 3 | 001002 | 2023-08-03 11:18:18 |
| 167 | ESG company event label | 001004001 | Ecological damage | 3 | 001004 | 2023-08-03 11:18:18 |
| 170 | ESG company event label | 001004004 | Green finance | 3 | 001004 | 2023-08-03 11:18:18 |
| 175 | ESG company event label | 002001001 | Employee casualties | 3 | 002001 | 2023-08-03 11:18:18 |
| 176 | ESG company event label | 002001002 | Poor working conditions | 3 | 002001 | 2023-08-03 11:18:18 |
| 177 | ESG company event label | 002001003 | Safety accident | 3 | 002001 | 2023-08-03 11:18:18 |
| 179 | ESG company event label | 002001005 | Employee incentives | 3 | 002001 | 2023-08-03 11:18:18 |
| 184 | ESG company event label | 002002001 | Charity donation | 3 | 002002 | 2023-08-03 11:18:18 |
| 187 | ESG company event label | 002004001 | Product problem | 3 | 002004 | 2023-08-03 11:18:18 |
| 190 | ESG company event label | 002005001 | Funds in arrears | 3 | 002005 | 2023-08-03 11:18:18 |
| 193 | ESG company event label | 002007001 | Intellectual property infringement | 3 | 002007 | 2023-08-03 11:18:18 |
| 196 | ESG company event label | 002008002 | Privacy violation | 3 | 002008 | 2023-08-03 11:18:18 |
| 199 | ESG company event label | 003001001 | Executive changes | 3 | 003001 | 2023-08-03 11:18:18 |
| 202 | ESG company event label | 003001004 | Change of actual controller | 3 | 003001 | 2023-10-07 17:48:09 |
| 203 | ESG company event label | 003001005 | Legal person change | 3 | 003001 | 2023-08-03 11:18:18 |
| 204 | ESG company event label | 003002001 | Information disclosure violation | 3 | 003002 | 2023-08-03 11:18:18 |
| 205 | ESG company event label | 003002002 | Financial fraud | 3 | 003002 | 2023-08-03 11:18:18 |
| 206 | ESG company event label | 003002003 | Non-standard opinion | 3 | 003002 | 2023-08-03 11:18:18 |
| 207 | ESG company event label | 003002004 | Disclosure extension | 3 | 003002 | 2023-08-03 11:18:18 |
| 215 | ESG company event label | 003003007 | Change of purpose of raised funds | 3 | 003003 | 2023-10-07 17:48:09 |
| 220 | ESG company event label | 003004001 | Corruption and bribery | 3 | 003004 | 2023-08-03 11:18:18 |
| 221 | ESG company event label | 003004002 | Misappropriation of funds | 3 | 003004 | 2023-08-03 11:18:18 |
| 223 | ESG company event label | 003005001 | Bond default | 3 | 003005 | 2023-08-03 11:18:18 |
| 231 | ESG company event label | 003005009 | Stop work and production | 3 | 003005 | 2023-08-03 11:18:18 |
Data update frequency
Annual update, please contact us for special needs