Affiliate
Ownership + shareholder affiliation relationships.
Buy by the field
41 priced fields
Pick the fields you need — priced individually below.
20% off buying every field
Pay annually · save 20% — $21,158/yr
ⓘ Take the whole set from the field list below — select everything, add it to your basket, and check out there.
Affiliate
affiliateSource DataOwnership + shareholder affiliation relationships.
Daily source stitch · data frontier 2026-08-02
9. Field reference — every column
The full field dictionary — every table, every column, with its type and meaning. One real sample row is shown per table.
equity_parent_company
Table · pick one of 9
equity_parent_company
18 columns · grain (primary key): id
| Column | Name | Type | Null | Description |
|---|---|---|---|---|
operation | Change-feed flag (A/U/D) | string | yes | Change-feed flag marking whether the row adds (A), updates (U), or deletes (D) a parent/controller record, so subscribers can apply the data as an incremental change stream. Across the full dataset only 'A' (Add) occurs. |
id ·PK | Record ID | string | no | Unique record identifier (primary key), one value per row — a stable handle for referencing or de-duplicating each parent/controller record. |
secu | Security code | string | yes | The listed company's ChinaScope standard security code, carrying an exchange suffix — _SH_EQ (Shanghai), _SZ_EQ (Shenzhen), or _BJ_EQ (Beijing) — that identifies which A-share company this ownership record describes. About 4,920 companies appear. |
ticker | Ticker (plain exchange code) | string | yes | The listed company's plain exchange code — the six-digit stock number without the market suffix (e.g. 301281). The exchange-qualified form (301281_SZ_EQ) is carried in the Security code field. |
rpt | Report period-end date | date | no | The reporting period-end date the ownership snapshot is stated as of — the point-in-time anchor for as-of and historical queries. Period-ends are semi-annual (June 30 and December 31), spanning 2021 through 2025 in the current data. |
parent_orig | Parent / controller (as reported) | string | yes | The parent or controlling shareholder's name exactly as disclosed in filings (raw, unstandardized text). The value can be an organization (e.g. 力诺投资控股集团有限公司) or an individual (e.g. 李庆海); the resolved id is carried in Parent / controller ID. About 12% of rows leave this blank. |
parent_cat | Parent entity type | string | yes | An entity-type flag for the parent/controlling shareholder: 1 = natural person, 2 = organization/institution, 0 = invalid/unresolved. Code 2 covers ~71% of rows, 1 ~14%, 0 ~5%, and ~10% are blank. Use it to separate individual controllers from corporate ones; it is not an ownership or size measure. |
parent_id | Parent / controller ID | string | yes | The resolved ChinaScope entity id for the parent/controlling shareholder. The scheme covers both organizations (CSF…/ICN… company ids) and individuals (P… person ids), so the same controller joins across different listed companies and over time. About 15% of rows carry a blank id where the parent was not resolved (these line up with the 0/blank values of Parent entity type). |
reg_orig | Registered location (as reported) | string | yes | The parent/controller's registered location exactly as disclosed (raw text such as 济南市历城区 or 香港). About 29% of rows are blank where the location was not reported. |
reg_std | Registered location (standardized) | string | yes | The parent/controller's registered location cleaned to a standardized place name (e.g. 济南市, 中国香港特别行政区), collapsing ~2,200 raw spellings to about 299 standard names so controllers group cleanly by geography. About 30% of rows are blank. |
data_unit | Amount unit | string | yes | A scale marker for the monetary field (registered capital); its value is 元 on every row, meaning amounts are stated in whole units (not 万/ten-thousands). It does not set the currency — the actual denomination is given by the Currency field (usually CNY, sometimes a foreign currency) — so read capital as 'this many whole units of the row's currency.' |
currency | Currency | string | yes | The currency the registered-capital amount is denominated in. Nine currency codes appear — CNY (Chinese yuan) dominates at ~81% of rows, with HKD and USD the main foreign ones and a short tail (JPY, EUR, SGD, TWD, DKK, AMD); ~15% of rows are blank. Because denominations are mixed, read capital together with this field and don't compare raw amounts across currencies. |
capital | Registered capital | number · 元 | yes | The parent/controller's registered capital, in the row's currency (see Currency) and in whole units (see Amount unit). Treat it as a rough size indicator: the median is about 0.42 billion and the middle half runs ~50 million to ~3 billion. The field is very wide and holds extreme, sometimes implausible outliers (a few rows reach the quadrillions and look like unit/entry errors), so sanity-check large magnitudes and never compare raw amounts across currencies. About 30% of rows are blank and a handful are 0 (not reported or not applicable). |
ratio | Holding ratio | number · pct | yes | The parent/controlling shareholder's economic ownership stake in the listed company, a decimal fraction between 0 and 1 (e.g. 0.4687 = 46.87%). The median holding is about 0.31 (31%) and the middle half runs ~0.20 to ~0.45. A few outlier rows exceed 1 (max ~30.8) and are data-quality artifacts; about 12% of rows are blank. |
vote_ratio | Voting ratio | number · pct | yes | The parent/controlling shareholder's share of voting rights in the listed company, a decimal fraction between 0 and 1 (max 1.0). The median is about 0.33 (33%), typically at or slightly above the economic stake because voting control can diverge from ownership. About 21% of rows are blank. |
company_id | Listed-company ID (standard org code) | string | yes | The resolved ChinaScope entity id for the listed company itself — a stable key (populated on every row) for connecting this issuer to other records about the same company across the dataset. |
create_time | Record create timestamp | timestamp | yes | The timestamp when this record first entered the dataset — a data-vintage/audit marker, not a corporate or filing event date. |
update_time | Record update timestamp | timestamp | yes | The timestamp when this record was last updated; it also serves as the ordering key for the change feed, so successive updates to the same relationship can be sequenced and de-duplicated correctly. |
Sample row:
operation: A
id: 100002
secu: 301281_SZ_EQ
ticker: 301281
rpt: 2025-12-31 00:00:00
parent_orig: 力诺投资控股集团有限公司
parent_cat: 2
parent_id: CSF246652418
reg_orig: 济南市历城区
reg_std: 济南市
data_unit: 元
currency: CNY
capital: 431800000.0
ratio: 0.3439
vote_ratio: 0.3439
company_id: CSF238243439
create_time: 2026-04-16 22:46:38
update_time: 2026-04-16 22:46:38
Sourced as-delivered from ChinaScope, with resolved codes and structural links computed by Numinor. Licensing passes through to you; fields are served exactly as the vendor issues them.
Access & FAQ
- How do I buy just a few fields?
- Check the fields you want and you'll see your running subtotal. Select every field and the whole-set price applies automatically. Add them to your basket and check out — this dataset, or fields combined across several.
- Can I evaluate these fields in the Matrix before I buy?
- Yes — load the actual source tables in the Matrix and analyze them with an AI agent (point-in-time lagged) to check the fields fit your use case before you buy. Once your selection is activated, export the fields you choose via the API.
- How is it delivered?
- Apache Parquet over a signed-URL REST API, the same pipe as Construct Data. The free Matrix sandbox serves a time-delayed view for evaluation.
- When is each update available, and how reliable is it?
- Source data refreshes on the ChinaScope cadence and is delivered through the same signed-URL pipeline as Construct Data, with the same manifest/status behaviour. Evaluate freshness yourself in the Matrix before you commit.
- Why are some fields free and others cost thousands?
- Price tracks non-replicability. Resolved codes and structural links are the moat; machine scores and raw text are cheap; identifier keys are free. Figures are priced per table; codes are charged once per dataset.
Still have questions? Contact Sales →