Normalized chemical composition data for 19,645 commercial beauty products across 44,816 canonical INCI compounds. Cleaned, joined, and canonicalized from public regulatory registries and open cosmetic data into query-ready flat files.
SELECT
i.inci_name,
i.primary_function,
i.is_common_allergen,
pi.position_index AS concentration_rank
FROM 'product_ingredients.parquet' pi
JOIN '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 | primary_function | is_common_allergen | concentration_rank|
-- +---------------------------------+------------------+--------------------+------------------+
-- | WATER/EAU/AQUA | Solvent | 0 | 1 |
-- | LACTIC ACID | Exfoliant | 0 | 2 |
-- | OPUNTIA TUNA FRUIT EXTRACT | Humectant | 0 | 3 |
-- | SQUALANE | Emollient | 0 | 4 |
-- | CYMBOPOGON SCHOENANTHUS OIL | Fragrance | 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.
Community product database (barcodes, brands, on-pack ingredient lists) under the Open Database License (ODbL).
Deduplicated INCI nomenclature with CAS mapping, ordered position indexes, and referential integrity across every table.
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.
Open data (ODbL) — one-time delivery with optional support.
Secure card checkout via Stripe (card / Apple Pay / Google Pay) with instant download after payment. Company invoice, custom slices, or questions? Open the contact form.
Core regulatory, chemical normalization, and data integration queries for beauty developers and formulators.
INCIDB cross-references compound designations against EU CosIng and US FDA substance registries, mapping synonym variations, botanical Latin binominals, and trade names to canonical INCI primary keys alongside verified CAS registry numbers.
The Modernization of Cosmetics Regulation Act (MoCRA) mandates explicit disclosure of fragrance and contact allergens. INCIDB sets a binary flag (`is_common_allergen = 1`) for all mandatory regulatory sensitizers, including Citral, Linalool, Limonene, and Phenoxyethanol.
While CSV provides universal compatibility for Excel and basic scripts, columnar Apache Parquet files reduce storage footprint by up to 80% and enable sub-second filtering of 19,645+ formulations using PyArrow, Pandas, or DuckDB without loading the entire dataset into memory.
Comedogenic ratings (0.0 to 5.0 scale) and Malassezia (fungal acne) trigger flags are derived from peer-reviewed dermatological literature and CosIng lipid/ester profiles, highlighting pore-clogging fatty acids and esters.
Explore canonical ingredient monographs by cosmetic functional role.
Squalane, Caprylic/Capric Triglyceride, Petrolatum, and essential barrier-repair lipids.
Phenoxyethanol, Methylparaben, and regulatory antimicrobial stabilizers.
Water/Eau/Aqua, Glycerin, Cetearyl Alcohol, and emulsion-forming bases.
Lactic Acid, AHA/BHA exfoliants, botanical extracts, and clinical humectants.