Skip to content

data(brand): backfill founded_year + Wikidata logos (Bosch, Orange, Pixio) - #110

Merged
Seungpyo1007 merged 2 commits into
mainfrom
data/import-staging
Jul 8, 2026
Merged

Seungpyo1007 merged 2 commits into
mainfrom
data/import-staging

Conversation

@Seungpyo1007

@Seungpyo1007 Seungpyo1007 commented Jul 8, 2026 •

Copy link
Copy Markdown
Member

Summary

Final brand-metadata backfill of this enrichment run, sourced from Wikidata with strict verification (no fabrication).

  • logo_url — added for Bosch and Orange via website-domain-matched Wikidata P154 (their P856 official-website matched the brand's stored website).
  • founded_year — added for Orange (1988) and Pixio (2016) from Wikidata P571 inception; Bosch already had 1886.
  • ~50 remaining brands without a logo/founded_year are obscure or defunct phone makers (tel-me, wnd, verykool, koorui, innocn, …) with no confident Wikidata entity — the domain / country+company-type match correctly declines them rather than guess. Left unchanged.

All records verified: false. Validation passes. Dump regenerated — 3 changed brand detail pages.

Closes #1

…ixio)

- Bosch, Orange: logo_url from website-matched Wikidata P154.
- Orange (1988), Pixio (2016): founded_year from Wikidata P571 inception.
- Sourced by domain/country-verified entity match; unmatched obscure brands left as-is (no fabrication).

Refs #1
@Seungpyo1007

Copy link
Copy Markdown
Member Author

🤖 TechEngine · data validation

category   changed   verified
brand         3         false
  • python -m app.validate → ✅ passed (0 errors), 108,575 records / 10 categories.
  • Fields added: logo_url ×2 (Bosch, Orange), founded_year ×2 (Orange 1988, Pixio 2016).
  • Dump regenerated: 3 brand detail pages (v1/brands/{bosch,orange,pixio}/).

Additive field fills only — no schema change.

@Seungpyo1007

Copy link
Copy Markdown
Member Author

🤖 TechEngine · verify (Tier 0)

Reality-checked sourcing:

  • logo_url accepted only when a candidate Wikidata entity's P856 (official website) equals the brand's stored website domain → its P154 logo → commons Special:FilePath URL.
  • founded_year taken from P571 (inception) on that same verified entity, gated to plausible years.
  • ~50 obscure/defunct brands with no confident entity stay unfilled — no fabricated values.

verified promotion remains with the verify-network job. Safe to rebase-merge.

@Seungpyo1007 Seungpyo1007 moved this from Todo to In Progress in TechAPI-Project Jul 8, 2026
@Seungpyo1007
Seungpyo1007 merged commit 7c61b12 into main Jul 8, 2026
5 checks passed
@github-project-automation github-project-automation Bot moved this from In Progress to Done in TechAPI-Project Jul 8, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

data Dataset changes enhancement New feature or request

Projects

Status: Done

Development

Successfully merging this pull request may close these issues.

TechAPI dataset roadmap and status: all categories (1989-2026)

1 participant