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.
{
"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 identityidUnique numeric notice identifier within RecallRadar.Notice identitysource_notice_refAuthority-specific reference number or ID, such as a CPSC recall number or RAPEX alert ID.Notice identityis_recallTrue when the notice is a formal recall; false for alerts or warnings that stop short of recall.Recall classificationcategory_sourceCategory source value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columnscountry_of_originCountry of origin value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columnsjurisdictionJurisdiction value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columnsrisk_levelRisk level value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columnssummarySummary value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columnstitleTitle value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Exported flat columnshazard_textProse description of the hazard as stated by the issuing authority.Notice contentremedy_textProse description of the required consumer remedy, such as return, repair, refund, or stop use.Notice contentpublished_atDate the notice was published by the source authority.Notice identitycategory_codeUnified product category slug from the RecallRadar taxonomy.Recall classificationhazard_typesHazard types value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated.Schema fieldslanguageLanguage 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.
Notice identity4 fields
| name | type | scope | description | sources |
|---|---|---|---|---|
| id | int | identity / 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 |
| authority | text | identity / 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_ref | text | identity / 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_at | date | identity / matching | Date the notice was published by the source authority. | authority |
Exported flat columns6 fields
| name | type | scope | description | sources |
|---|---|---|---|---|
| jurisdiction | text | domain attribute | Jurisdiction value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| title | text | domain attribute | Title value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| summary | text | domain attribute | Summary value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| risk_level | text | domain attribute | Risk level value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| category_source | text | domain attribute | Category source value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| country_of_origin | text | domain 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
| name | type | scope | description | sources |
|---|---|---|---|---|
| is_recall | bool | classification | 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_code | text | classification | Unified product category slug from the RecallRadar taxonomy. | derived |
Notice content2 fields
| name | type | scope | description | sources |
|---|---|---|---|---|
| hazard_text | text | notice | Prose description of the hazard as stated by the issuing authority. | authority |
| remedy_text | text | notice | Prose description of the required consumer remedy, such as return, repair, refund, or stop use. | authority |
Provenance2 fields
| name | type | scope | description | sources |
|---|---|---|---|---|
| source_record_url | text | provenance 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 |
| _provenance | jsonb | provenance payload | Per-field provenance map with source, confidence, fetched timestamp, and source URL. | derived |
Schema fields4 fields
| name | type | scope | description | sources |
|---|---|---|---|---|
| risk_level_code | text | domain attribute | Risk level code value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| measure_types | text | domain attribute | Measure types value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| hazard_types | text | domain attribute | Hazard types value emitted by the recalls export. Use the record provenance payload to inspect source attribution when populated. | varies |
| language | text | domain 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.