latest update:
[RecallRadar]

Data dictionary · provenance + exported fields

Every value in the dataset is traceable to a source record. This page covers the provenance model, null policy, and the dataset field catalog shipped through the REST API and snapshot exports.

Provenance model

Provenance is a side table, not a footnote. For each exported field in a record there is a corresponding provenance row recording the source identifier, source URL, source class, and effective value state. Values without commercial-use cleared provenance are excluded from the paid export path.

_provenance entry shape (inline on API responses)json
{
  "field":         "field_name",
  "value":         "...",
  "source":        "accc",
  "source_class":  "government | registry | manufacturer | aggregator | derived",
  "source_url":    "https://www.productsafety.gov.au",
  "effective":     true,
  "superseded_at": null
}

Export shape

The primary entity is recalls. The export combines the canonical entity table with active provenance from 8 sources. JSON responses and the full JSON download include nested provenance. CSV, Parquet, and SQLite are explicitly curated flat extracts and do not carry nested or separate provenance tables.

Key fields

These fields are selected from the field catalog as the main dimensions for filtering, grouping, matching, and API usage:

  • authoritySource authority code, such as cpsc, eu-safety-gate, health-canada, gov-uk-opss, accc, fr-rappelconso, tw-bsmi, or fi-tukes-historical.Notice identity
  • idUnique numeric notice identifier within RecallRadar.Notice identity
  • source_notice_refAuthority-specific reference number or ID, such as a CPSC recall number or RAPEX alert ID.Notice identity
  • is_recallTrue when the notice is a formal recall; false for alerts or warnings that stop short of recall.Recall classification
  • category_sourceCategory source value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columns
  • country_of_originCountry of origin value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columns
  • jurisdictionJurisdiction value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columns
  • risk_levelRisk level value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columns
  • summarySummary value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columns
  • titleTitle value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columns
  • hazard_textProse description of the hazard as stated by the issuing authority.Notice content
  • remedy_textProse description of the required consumer remedy, such as return, repair, refund, or stop use.Notice content
  • published_atDate the notice was published by the source authority.Notice identity
  • category_codeUnified product category slug from the RecallRadar taxonomy.Recall classification
  • hazard_typesHazard types value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Schema fields
  • languageLanguage value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Schema fields

Field catalog

The catalog below contains 20 documented fields from the same field model rendered on this page. Field types and descriptions come from the export contract and source registry. Nullable means unknown or not applicable; it does not mean zero, false, or inferred.

Machine-readable catalogue: /docs/data-dictionary/fields.json.

Notice identity4 fields

nametypescopedescriptionsources
idintidentity / matching
Unique numeric notice identifier within RecallRadar.
example: 274019
Provenance: Generated by the notice ingestion spine and stable within the published snapshot.
Caveat: Ids are RecallRadar-assigned and are not authority recall numbers.
derived
authoritytextidentity / matching
Source authority code, such as cpsc, eu-safety-gate, health-canada, gov-uk-opss, accc, fr-rappelconso, tw-bsmi, or fi-tukes-historical.
example: cpsc
Provenance: Mapped directly from the source connector and source registry code.
Caveat: Authority coverage reflects included public sources and does not imply global recall completeness.
8
source_notice_reftextidentity / matching
Authority-specific reference number or ID, such as a CPSC recall number or RAPEX alert ID.
example: 23-742
Provenance: Copied from the original notice identifier when the authority publishes one.
source authority
published_atdateidentity / matching
Date the notice was published by the source authority.
authority

Exported flat columns6 fields

nametypescopedescriptionsources
jurisdictiontextdomain attribute
Jurisdiction value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
titletextdomain attribute
Title value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
summarytextdomain attribute
Summary value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
risk_leveltextdomain attribute
Risk level value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
category_sourcetextdomain attribute
Category source value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
country_of_origintextdomain attribute
Country of origin value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies

Recall classification2 fields

nametypescopedescriptionsources
is_recallboolclassification
True when the notice is a formal recall; false for alerts or warnings that stop short of recall.
example: true
Provenance: Derived from authority notice type and source-specific recall/alert labels.
authority
category_codetextclassification
Unified product category slug from the RecallRadar taxonomy.
derived

Notice content2 fields

nametypescopedescriptionsources
hazard_texttextnotice
Prose description of the hazard as stated by the issuing authority.
authority
remedy_texttextnotice
Prose description of the required consumer remedy, such as return, repair, refund, or stop use.
authority

Provenance2 fields

nametypescopedescriptionsources
source_record_urltextprovenance payload
Canonical URL of the original notice on the authority website.
example: https://www.cpsc.gov/Recalls/2026/example
Provenance: Copied from the source notice URL used for audit and citation.
registry
_provenancejsonbprovenance payload
Per-field provenance map with source, confidence, fetched timestamp, and source URL.
derived

Schema fields4 fields

nametypescopedescriptionsources
risk_level_codetextdomain attribute
Risk level code value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
measure_typestextdomain attribute
Measure types value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
hazard_typestextdomain attribute
Hazard types value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies
languagetextdomain attribute
Language value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.
varies

NULL policy

A missing field on a record is a missing field: not a zero, not a negative assertion, and not an imputed value. Fields that do not apply to a record are explicitly NULL. Coverage gaps are visible by design.

Audit trail

Every provenance row carries the observed value, source code, source record URL, effective state, and ingest context. Snapshot manifests and source licence notes document which upstream records were cleared for commercial use.

Field requests are reviewed against the same commercial-use source gate as the rest of the export. A field only ships when its source terms permit commercial use in the buyer-facing dataset.