Normalized chemical composition data for 19,847 commercial beauty products across 57,181 canonical INCI compounds. Enriched with clinical safety monographs, contact dermatitis allergens, and toxicology profiles from 8 global regulatory registries.
SELECT
i.inci_name,
i.ewg_hazard_score,
i.is_common_allergen,
pi.position_index AS concentration_rank
FROM 'data/exports/parquet/product_ingredients.parquet' pi
JOIN 'data/exports/parquet/ingredients.parquet' i ON pi.ingredient_id = i.ingredient_id
WHERE pi.product_id = 67455
ORDER BY pi.position_index ASC;
-- Output: Good Genes All-In-One Lactic Acid Treatment (Brand: Sunday Riley)
-- +---------------------------------+------------------+--------------------+------------------+
-- | inci_name | ewg_hazard_score | is_common_allergen | concentration_rank|
-- +---------------------------------+------------------+--------------------+------------------+
-- | WATER/EAU/AQUA | 1.0 | 0 | 1 |
-- | LACTIC ACID | 4.0 | 0 | 2 |
-- | OPUNTIA TUNA FRUIT EXTRACT | 1.0 | 0 | 3 |
-- | SQUALANE | 1.0 | 0 | 4 |
-- | CYMBOPOGON SCHOENANTHUS OIL | 2.0 | 1 (FDA MoCRA Alert)| 12 |
-- +---------------------------------+------------------+--------------------+------------------+Official EU chemical inventory mappings with exact CAS registry numbers and restricted formulation thresholds.
Explicit flags for mandatory Modernization of Cosmetics Regulation Act contact dermatitis fragrance allergens.
Granular hazard scores (1-10) with explicit sub-score flags for Carcinogenicity and Endocrine Disruption.
Expert Panel peer-reviewed safety monographs ("Safe as used", "Safe with qualifications") and concentration limits.
Formulations harvested from US National Library of Medicine clinical dermatological topical drug labels.
Functional whitening, barrier repair, and anti-wrinkle actives from the Korean Ministry of Food and Drug Safety.
One-time snapshot archives with perpetual commercial licensing.