Country-of-origin density in the PartsPerk published catalog

Sample size (live DB aggregates)

Captured 2026-11-14T19:40:44.627Z · source live_db_published_scope

• Published identities: 50,832
• With Country of Origin attribute: 42,561 (83.7%)
• Distinct origins: 83
• Singleton origins (1 product): 40
• Small (2–9 products): 25
• Medium (10–99 products): 11
• Large (≥100 products): 7
• Max products per origin: 39,186
• Average products per origin: 512.8
• Top-10 origin product share: 42,278 (83.2%)
• Top-50 origin product share: 42,528 (83.7%)

Download aggregate JSON (counts only) — origin country names/values and row-level catalog export are not offered.

Methodology

1. Denominator is independent_catalog_products rows with publicationState = 'published'.
2. Origin present means at least one independent_catalog_attributes row with label = 'Country of Origin' and non-empty trim(value) joined to that published product.
3. Distinct origins are COUNT(DISTINCT lower(trim(value))) over published products with a non-empty Country of Origin attribute (one origin key per product via MIN of lower(trim(value)) when multiple attribute rows exist).
4. Density buckets group those distinct origins by published product count: singleton (=1), small (2–9), medium (10–99), large (≥100).
5. Top-10 / top-50 origin product shares sum product counts for the largest origins by count (country names/values are not published in this report).
6. Average products per origin is round(avg(count) * 10) / 10 over the distinct-origin groups.
7. Percentages are rounded to one decimal place: round(1000 * part / total) / 10.
8. Counts are existence and concentration aggregates only — no origin names, titles, or private evidence are published in this report.

Limitations

• This is PartsPerk’s published catalog Country of Origin attributes only — not a customs, FAA, DLA, or industry-wide origin census.
• A Country of Origin attribute on a catalog row does not imply stock, authorization, interchange, airworthiness, export clearance, or price.
• Origin string quality (canonicalization beyond lower(trim), multi-value rows, source assertion accuracy) is out of scope for these density counts.
• When DATABASE_URL is unavailable at render time, the page states aggregates unavailable rather than inventing figures.
• Row-level CSV/JSON export of catalog identities or origin country rosters is not offered (licensing / privacy); only aggregate JSON is downloadable.

Provenance

• Tables: independent_catalog_products, independent_catalog_attributes
• Publication filter: publicationState = 'published'
• Attribute filter: label = 'Country of Origin' AND length(trim(value)) > 0
• Loader: loadCountryOfOriginDensityAggregates() in aviation-intelligence-os.ts
• Public path: /market-intelligence/country-of-origin-density
• Aggregate JSON: /api/public/market-intelligence/country-of-origin-density