DATASET · fundamental

XBRL 财务事实

fundamental.xbrl_fact

财务与估值

以实体、XBRL concept 和期间为粒度保存原子财务事实，适合需要精确科目与维度的研究。

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

字段26

关键字段3

更新口径daily

时间列period_end

单页上限5000

分页窄筛选

PIT不支持

规模10M-99M

WHAT IT ANSWERS

这张表适合回答什么

查询特定 XBRL 科目
自定义财务报表映射
核对标准化财务指标来源

GRAIN & TIME

一行代表什么

业务粒度: 每行代表“XBRL 财务事实”的一条记录；逻辑粒度由 entity_id × concept × period_end 共同确定。
时间口径: 以 period_end 为主要查询时间轴；除下方限制特别说明外，时间戳按 UTC、日期按来源市场日历解释。
更新节奏: 通常按交易日或自然日更新；具体最新日期请以返回数据为准。

KEY FIELDS

先看这些字段

entity_id: 用于识别 entity 的业务标识。
concept: 用于确定该表业务粒度或默认顺序的 concept 字段。
period_end: 用于确定该表业务粒度或默认顺序的 period end 字段。

RECOMMENDED JOINS

怎样和其他表关联

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

HOW TO QUERY SAFELY

查询方法与已知限制

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

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

MACHINE CONTRACT

筛选、排序与分页

UNVERSIONED

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

可用 filters

accession_no→ accession_no · string

concept→ concept · string

entity_id→ entity_id · string

taxonomy→ taxonomy · 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/xbrl_fact/rows?limit=100&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', 'xbrl_fact', limit=100, start='2026-08-01', end='2026-08-01')
    print(page.data)
    if page.has_more:
        print("next cursor:", page.next_cursor)

CLI

friends-data get-dataset-rows fundamental xbrl_fact --limit 100 --start 2026-08-01 --end 2026-08-01

MCP TOOL CALL

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

FIELD DICTIONARY

26 个返回字段

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

筛选字段

#	字段	ClickHouse 类型	JSON	可空	角色	说明
1	`entity_id`	`String`	`string`	no	filter, default_order, warehouse_primary_key	Identifier for entity.名称推导
2	`accession_no`	`String`	`string`	no	filter, warehouse_primary_key	SEC accession number identifying one filing submission.标准术语表
3	`taxonomy`	`LowCardinality(String)`	`string`	no	filter, warehouse_primary_key	Source-normalized field: taxonomy.名称推导
4	`concept`	`String`	`string`	no	filter, default_order, warehouse_primary_key	Source-normalized field: concept.名称推导
5	`period_start`	`Nullable(Date)`	`string / date`	yes	value	Source-normalized field: period start.名称推导
6	`period_end`	`Date`	`string / date`	no	time, default_order, warehouse_primary_key	Source-normalized field: period end.名称推导
7	`filing_date`date	`Nullable(Date)`	`string / date`	yes	value	Date on which the filing was submitted or published.标准术语表
8	`fiscal_year`	`Nullable(Int32)`	`integer`	yes	value	Source-normalized field: fiscal year.名称推导
9	`fiscal_period`	`LowCardinality(String)`	`string`	no	value	Source-normalized field: fiscal period.名称推导
10	`unit`	`LowCardinality(String)`	`string`	no	value	Unit attached to the numeric observation.标准术语表
11	`value`	`Nullable(Float64)`	`number`	yes	value	Numeric or source-normalized value for the metric.标准术语表
12	`dimensions_hash`	`String`	`string`	no	warehouse_primary_key	Source-normalized field: dimensions hash.名称推导
13	`source`	`LowCardinality(String)`	`string`	no	provenance	Normalized upstream source identifier.标准术语表
14	`provider`	`LowCardinality(String)`	`string`	no	provenance	Upstream data provider identifier.标准术语表
15	`source_url`	`String`	`string`	no	provenance	URL of the upstream evidence or record when distributable.标准术语表
16	`source_record_id`	`String`	`string`	no	provenance	Provider-side identifier for the source record.标准术语表
17	`raw_payload_hash`	`String`	`string`	no	provenance	Opaque fingerprint of the normalized source payload for provenance checks.标准术语表
18	`parser_version`	`LowCardinality(String)`	`string`	no	provenance	Version of the parser or normalizer that produced the row.标准术语表
19	`quality_status`	`LowCardinality(String)`	`string`	no	provenance	Machine-readable data-quality classification.标准术语表
20	`license_scope`	`LowCardinality(String)`	`string`	no	provenance	License or redistribution scope attached to the row.标准术语表
21	`visibility_tier`	`LowCardinality(String)`	`string`	no	provenance	Serving visibility tier attached to the row.标准术语表
22	`ingest_run_id`	`String`	`string`	no	provenance	Identifier of the ingestion run that produced the row.标准术语表
23	`version`	`UInt64`	`integer`	no	provenance	Monotonic row version used for correction-aware reads.标准术语表
24	`is_deleted`	`UInt8`	`integer`	no	value	Soft-delete marker; public serving excludes current tombstones.标准术语表
25	`created_at`UTC_datetime	`DateTime64(3, 'UTC')`	`string / date-time`	no	value	UTC timestamp when the warehouse row was first created.标准术语表
26	`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。