Data dictionary: verification pilot

Every field in the RWAWeekly verification pilot dataset, with what it means. Status definitions are on the verification page.

Product fields

Field	Meaning
`attestation`	Independent report on reserves or tokens outstanding: firm, standard and the date it covers.
`available_networks`	Blockchains the source says the product is available on.
`contract_address`	Token contract address on one chain, as listed by the issuer.
`custodian`	Custodian, depositary or vault holding the assets, as named by the source.
`date_of_first_sale`	Date of first sale as filed on Form D (not the same as inception).
`domicile`	Country or territory where the fund or issuer is established.
`expense_ratio`	Annual fund operating expenses, gross and net of waivers.
`fund_aum_published`	Fund net assets as published in a filing or by the issuer.
`fund_legal_name`	Legal name of the fund or issuing entity.
`inception_date`	Date the fund started operations.
`investment_manager`	Investment manager and sub-advisor.
`legal_structure`	Legal form of the product (e.g. debt issued by a bankruptcy-remote entity).
`manager`	Fund manager named by the issuer.
`minimum_investment`	Minimum initial investment stated by the source.
`nav_per_share_reported`	NAV per share as reported in a filing.
`nav_policy`	Stated NAV policy, e.g. seeks a stable $1.00 per share (a policy, not a measurement).
`offering`	Offering type (e.g. Regulation S).
`regulator`	Regulator or regulatory regime stated by the source.
`share_class`	Share class of the fund.
`ticker`	Fund ticker in filings.

Metric	Meaning
`supply`	Tokens outstanding on one chain, read from the issuer-listed contract.
`nav_per_token`	Net asset value per token used for the board.
`aum_calculated`	Our calculation: sum of on-chain supply × nav_per_token.
`aum_issuer_reported`	Fund or token assets as published by the issuer or in an SEC filing.
`value_outstanding_issuer_reported`	Value outstanding as published by the issuer.
`nav_per_share_reported`	NAV per share as filed with the SEC or published by the issuer, in the source's currency.
`supply_issuer_reported`	Tokens or shares outstanding as published by the issuer or in an attestation report, compared with our own on-chain supply.
`reserve_oz_issuer_reported`	Fine troy ounces of gold held as reserves, as stated in an attestation report.
`total_amount_sold_reported`	Total amount sold as filed on SEC Form D.

Column	Meaning
`product_id`	Our product identifier.
`ticker`	Token or fund ticker as listed on the board.
`product_name`	Product name.
`field`	Field or metric name (see the field list below).
`chain`	Blockchain, for per-deployment rows (contract address, supply); empty otherwise.
`value`	The value as found, or 'unavailable'. Numbers are not rounded.
`unit`	usd, usd_per_share, eur, eur_per_share, tokens, troy_oz or text. Values are in the unit the source uses; we do not convert currencies.
`source_url`	Where the value comes from: the issuer page, the SEC filing, or the block explorer page for the contract we read.
`source_type`	onchain_rpc, issuer_oracle, issuer_doc, issuer_site, sec_filing or calculated.
`observed_at`	When we read or retrieved the value (UTC).
`measured_at`	The date or time the value refers to (UTC): block time of an on-chain read, report date of a filing, 'as of' date on an issuer page. Empty when the source gives no date for a static fact.
`method`	How the value was obtained, e.g. totalSupply(), getTokenSupply, issuer on-chain oracle, stable_nav_policy, supply_x_nav, sec_filing.
`verification_status`	One of the statuses defined on this page.
`note`	Context: the passage relied on, conflicts between sources, discrepancy size.

One row per product: identity and fixed attributes.

Column	Meaning
`product_id`	Our product identifier.
`name`	Product name.
`ticker`	Ticker shown on the board.
`issuer`	Issuer or sponsor.
`fund_legal_name`	Legal name of the fund.
`share_class`	Share class.
`domicile`	Domicile.
`regulator`	Regulator.
`asset_class`	Asset class.
`nav_design`	stable_1usd (seeks $1.00), accumulating (price rises with income) or commodity_price (valued at a market price, e.g. gold).
`currency`	Currency of the NAV.
`inception_date`	Inception date.
`in_pilot`	True for the products in the verification pilot.
`active`	True while the product is tracked.
`onchain_symbol`	Token symbol used in our on-chain reads.
`address_source_url`	Issuer page that lists the contract addresses.
`created_at`	Row created (UTC).
`updated_at`	Row last updated (UTC); only empty columns are ever filled, set values are not overwritten.

One row per product, field, value and source (append-only; field-level provenance).

Column	Meaning
`product_id`	Our product identifier.
`field`	Field name.
`value`	Value as found.
`source_url`	Source of the value.
`source_type`	Kind of source.
`retrieved_at`	When we retrieved the source (UTC).
`verification_status`	Status as defined on the verification page.
`note`	Passage relied on, conflicts.
`inserted_at`	When the row was written (UTC).

One row per token contract (product × chain).

Column	Meaning
`deployment_id`	product:chain:contract.
`product_id`	Our product identifier.
`chain`	Blockchain.
`contract_address`	Token contract address.
`token_standard`	Token standard where known.
`decimals`	Token decimals where known.
`address_source_url`	Issuer page that lists the contract addresses.
`address_status`	issuer_listed when the issuer publishes the address.
`address_checked_at`	When we last checked the issuer's address list (UTC).
`first_seen_at`	First time we read this contract (UTC).
`last_seen_at`	Last time we read this contract (UTC).
`active`	True while the product is tracked.

Every measurement, append-only; corrections are separate rows in obs.correction.

Column	Meaning
`obs_id`	Observation identifier.
`product_id`	Our product identifier.
`deployment_id`	product:chain:contract.
`metric`	What was measured (see metrics).
`value_num`	Numeric value.
`value_text`	Value as printed by the source.
`unit`	Unit.
`period`	Period the value covers, where relevant.
`as_of`	Measurement date or time (UTC): what the value refers to.
`observed_at`	Observation time (UTC): when we read it.
`source_type`	Kind of source.
`source_url`	Source of the value.
`source_ref`	Exact item read: chain and contract, or the filing section.
`method`	How it was obtained.
`verification_status`	Status as defined on the verification page.
`input_obs_ids`	For calculations: the observations used.
`supersedes_obs_id`	Reserved; observations are never edited, a later row may supersede an earlier one.
`run_id`	Data run identifier.
`licence_id`	Licence of the source.
`inserted_at`	When the row was written (UTC).

Append-only label corrections for earlier observations (the original row is never changed).

Column	Meaning
`obs_id`	Observation identifier.
`field`	Field name.
`old_value`	Label before the correction.
`new_value`	Label after the correction.
`reason`	Why the label changed.
`corrected_at`	When the correction was appended (UTC).