DATASET · fundamental

SEC 风险因素分类

fundamental.risk_factor_massive

财务与估值

从 10-K 和 10-Q 的 Risk Factors 中抽取文本并归入主要风险类别，保留公司和申报日期。

下载本类 JSON 下载完整 JSON.gz 先获取 Key

字段25

关键字段3

更新口径weekly

时间列filing_date

单页上限5000

分页窄筛选

PIT不支持

规模100K-999K

WHAT IT ANSWERS

这张表适合回答什么

比较公司风险披露变化
检索特定风险主题
构建风险文本特征

GRAIN & TIME

一行代表什么

业务粒度: 每行代表“SEC 风险因素分类”的一条记录；逻辑粒度由 cik × filing_date × primary_category 共同确定。
时间口径: 以 filing_date 为主要查询时间轴；除下方限制特别说明外，时间戳按 UTC、日期按来源市场日历解释。
更新节奏: 通常每周随上游披露或批处理更新；不是实时数据。

KEY FIELDS

先看这些字段

cik: SEC Central Index Key，用于识别申报主体。
filing_date: 申报提交或公开日期。
primary_category: 用于确定该表业务粒度或默认顺序的 primary category 字段。

RECOMMENDED JOINS

怎样和其他表关联

该表主要按自身业务键使用，目前没有推荐的跨表主键联接。

HOW TO QUERY SAFELY

查询方法与已知限制

先用 catalog 确认当前契约；可按 catalog 中列出的 filters 进一步缩小范围；单页最多 5000 行，该表不提供稳定 cursor，结果过大时必须缩小标的、日期或其他筛选。

返回范围仍受 Friends 权限、单页上限和 catalog 中的筛选契约约束。

MACHINE CONTRACT

筛选、排序与分页

UNVERSIONED

默认排序: filing_date, ticker, primary_category
唯一键: —
读取模式: canonical_final_active
最大时间窗: 未单独限制

可用 filters

cik→ cik · string

primary_category→ primary_category · string

secondary_category→ secondary_category · string

source→ source · string

ticker→ ticker · string

POINT IN TIME

可复现读取

NOT AVAILABLE

该资产没有 PIT 契约。普通 rows 端点仍按当前公开读模式返回数据；不要把它表述成历史时点快照。

COPY-READY CALLS

怎么调用

同一数据集可用 HTTP、Python SDK、CLI 或 MCP；Key 始终只通过环境变量/Bearer Header 传递。

READ ONLY

HTTP

curl --fail-with-body -H "Authorization: Bearer $FRIENDS_DATA_API_KEY" "https://api.alphahubs.uk/api/v1/data/datasets/fundamental/risk_factor_massive/rows?limit=100&cik=0000320193&start=2026-08-01&end=2026-08-01"

PYTHON SDK

from friends_data_api import FriendsDataClient, Settings

async with FriendsDataClient(Settings.from_env()) as client:
    page = await client.get_dataset_rows('fundamental', 'risk_factor_massive', limit=100, start='2026-08-01', end='2026-08-01', filters={'cik': '0000320193'})
    print(page.data)
    if page.has_more:
        print("next cursor:", page.next_cursor)

CLI

friends-data get-dataset-rows fundamental risk_factor_massive --limit 100 --start 2026-08-01 --end 2026-08-01 --filter cik=0000320193

MCP TOOL CALL

{
  "arguments": {
    "dataset": "risk_factor_massive",
    "end": "2026-08-01",
    "filters": {
      "cik": "0000320193"
    },
    "limit": 100,
    "namespace": "fundamental",
    "start": "2026-08-01"
  },
  "tool": "get_dataset_rows"
}

FIELD DICTIONARY

25 个返回字段

descriptionSource 可在 JSON 中区分仓库注释、标准术语表和名称推导说明。

筛选字段

#	字段	ClickHouse 类型	JSON	可空	角色	说明
1	`ticker`	`String`	`string`	no	filter, default_order, warehouse_primary_key	Ticker symbol reported by the source or mapped security master.标准术语表
2	`cik`	`Nullable(String)`	`string`	yes	filter	SEC Central Index Key identifying the filer.标准术语表
3	`filing_date`date	`Date`	`string / date`	no	time, default_order, warehouse_primary_key	Date on which the filing was submitted or published.标准术语表
4	`primary_category`	`LowCardinality(String)`	`string`	no	filter, default_order, warehouse_primary_key	Source-normalized field: primary category.名称推导
5	`secondary_category`	`LowCardinality(String)`	`string`	no	filter, warehouse_primary_key	Source-normalized field: secondary category.名称推导
6	`tertiary_category`	`String`	`string`	no	warehouse_primary_key	Source-normalized field: tertiary category.名称推导
7	`supporting_text`	`String`	`string`	no	value	Source-normalized field: supporting text.名称推导
8	`publish_ts`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	provenance	UTC point-in-time availability timestamp used by PIT reads.标准术语表
9	`source_ts`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	provenance	Timestamp asserted by the upstream source.标准术语表
10	`ingested_at`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	provenance	UTC timestamp when the source record entered the warehouse.标准术语表
11	`source`	`LowCardinality(String)`	`string`	no	filter, warehouse_primary_key, provenance	Normalized upstream source identifier.标准术语表
12	`provider`	`LowCardinality(String)`	`string`	no	provenance	Upstream data provider identifier.标准术语表
13	`source_url`	`String`	`string`	no	provenance	URL of the upstream evidence or record when distributable.标准术语表
14	`source_record_id`	`String`	`string`	no	warehouse_primary_key, provenance	Provider-side identifier for the source record.标准术语表
15	`raw_payload_hash`	`String`	`string`	no	provenance	Opaque fingerprint of the normalized source payload for provenance checks.标准术语表
16	`parser_version`	`LowCardinality(String)`	`string`	no	provenance	Version of the parser or normalizer that produced the row.标准术语表
17	`quality_status`	`LowCardinality(String)`	`string`	no	provenance	Machine-readable data-quality classification.标准术语表
18	`license_scope`	`LowCardinality(String)`	`string`	no	provenance	License or redistribution scope attached to the row.标准术语表
19	`visibility_tier`	`LowCardinality(String)`	`string`	no	provenance	Serving visibility tier attached to the row.标准术语表
20	`ingest_run_id`	`String`	`string`	no	provenance	Identifier of the ingestion run that produced the row.标准术语表
21	`version`	`UInt64`	`integer`	no	provenance	Monotonic row version used for correction-aware reads.标准术语表
22	`version_ts`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	provenance	UTC timestamp associated with the row version.标准术语表
23	`is_deleted`	`UInt8`	`integer`	no	value	Soft-delete marker; public serving excludes current tombstones.标准术语表
24	`created_at`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	value	UTC timestamp when the warehouse row was first created.标准术语表
25	`updated_at`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	value	UTC timestamp when the warehouse row was last updated.标准术语表

字典口径

结构来自 Friends 只读身份可见的真实 serving relation；权限、过滤、排序、PIT 与分页来自可执行 DatasetSpec。Schema observed at 2026-10-06T18:08:52Z。