Chemicals In Cosmetics
State of California
@usgov.ca_gov_chemicals_in_cosmetics_d55bf
Table 1
@usgov.ca_gov_chemicals_in_cosmetics_d55bf.table_1
This data is from the California Safe Cosmetics Program (CSCP) in the California Department of Public Health. The primary purpose of the CSCP is to collect information on hazardous and potentially hazardous ingredients in cosmetic products sold in California and to make this information available to the public. For all cosmetic products sold in California, the California Safe Cosmetics Act requires the manufacturer, packer, and/or distributor named on the product label to provide to the CSCP a list of all cosmetic products that contain any ingredients known or suspected to cause cancer, birth defects, or other developmental or reproductive harm. The CSCP maintains a list of “reportable” ingredients. Companies with reportable ingredients in their products must submit information to the California Safe Cosmetics Program if the company: •Has annual aggregate sales of cosmetic products of one million dollars or more, and •Has sold cosmetic products in California on or after January 1, 2007. The data table consists of: label names of cosmetic/personal care products, company/manufacturer names, product brand names, product categories, Chemical Abstracts Service registry numbers (CAS#) of the reported chemical ingredients, names of reported chemical ingredients, the number of reported chemicals for each product, and dates of reporting, product discontinuation or reformulation if applicable. The data reflect information that has been reported to the CSCP. All products containing carcinogens or developmental or reproductive toxicants may not be included, due to companies failing to report. Note: Primary key-These fields together are the unique identifier for an individual product/chemical profile: CDPHId, CSFId, SubCategoryId, ChemicalId
- 2.84 MB
- 114635 rows
- 22 columns
cdphidCDPHId | productnameProductName | csfidCSFId | csfCSF | companyidCompanyId | companynameCompanyName | brandnameBrandName | primarycategoryidPrimaryCategoryId | primarycategoryPrimaryCategory | subcategoryidSubCategoryId | subcategorySubCategory | casidCasId | casnumberCasNumber | chemicalidChemicalId | chemicalnameChemicalName | initialdatereportedInitialDateReported | mostrecentdatereportedMostRecentDateReported | discontinueddateDiscontinuedDate | chemicalcreatedatChemicalCreatedAt | chemicalupdatedatChemicalUpdatedAt | chemicaldateremovedChemicalDateRemoved | chemicalcountChemicalCount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | ULTRA COLOR RICH EXTRA PLUMP LIPSTICK-ALL SHADES | 4 | New Avon LLC | AVON | 44 | Makeup Products (non-permanent) | 53 | Lip Color - Lipsticks, Liners, and Pencils | 656 | 13463-67-7 | 6 | Titanium dioxide | Wed Jun 17 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Aug 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Feb 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | |||
| 3 | Glover's Medicated Shampoo | 338 | J. Strickland & Co. | Glover's | 18 | Hair Care Products (non-coloring) | 25 | Hair Shampoos (making a cosmetic claim) | 889 | 65996-92-1 | 4 | Distillates (coal tar) | Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 2 | ||||
| 3 | Glover's Medicated Shampoo | 338 | J. Strickland & Co. | Glover's | 18 | Hair Care Products (non-coloring) | 25 | Hair Shampoos (making a cosmetic claim) | 293 | 140-67-0 | 5 | Estragole | Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 02 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 02 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 2 | ||||
| 4 | PRECISION GLIMMER EYE LINER-ALL SHADES � | 4 | New Avon LLC | AVON | 44 | Makeup Products (non-permanent) | 46 | Eyeliner/Eyebrow Pencils | 656 | 13463-67-7 | 7 | Titanium dioxide | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Aug 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | ||||
| 5 | AVON BRILLIANT SHINE LIP GLOSS-ALL SHADES � | 4 | New Avon LLC | AVON | 44 | Makeup Products (non-permanent) | 52 | Lip Gloss/Shine | 656 | 13463-67-7 | 8 | Titanium dioxide | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Aug 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Feb 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | |||
| 6 | JILLIAN DEMPSEY FOR AVON CELESTIAL EYESHADOW-ALL SHADES � | 4 | New Avon LLC | AVON | 44 | Makeup Products (non-permanent) | 48 | Eye Shadow | 656 | 13463-67-7 | 9 | Titanium dioxide | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Aug 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Nov 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | |||
| 7 | ABSOLUTE Precision Color Powder System - All Shades | 310 | 5858-81-1 | 11 | OPI PRODUCTS INC. | OPI | 59 | Nail Products | 60 | Artificial Nails and Related Products | 656 | 13463-67-7 | 12178 | Titanium dioxide | Mon Jul 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | ||
| 7 | ABSOLUTE Precision Color Powder System - All Shades | 311 | D&C RED 7 CALCIUM LAKE | 11 | OPI PRODUCTS INC. | OPI | 59 | Nail Products | 60 | Artificial Nails and Related Products | 656 | 13463-67-7 | 12178 | Titanium dioxide | Mon Jul 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | ||
| 7 | ABSOLUTE Precision Color Powder System - All Shades | 312 | D&C RED 28 | 11 | OPI PRODUCTS INC. | OPI | 59 | Nail Products | 60 | Artificial Nails and Related Products | 656 | 13463-67-7 | 12178 | Titanium dioxide | Mon Jul 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | ||
| 8 | ABSOLUTE Precision Color Powder System Opaque Pink | 313 | D&C RED 7 CALCIUM LAKE | 11 | OPI PRODUCTS INC. | ABSOLUTE | 59 | Nail Products | 60 | Artificial Nails and Related Products | 656 | 13463-67-7 | 17903 | Titanium dioxide | Mon Jul 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jun 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jun 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 |
CREATE TABLE table_1 (
"cdphid" BIGINT,
"productname" VARCHAR,
"csfid" DOUBLE,
"csf" VARCHAR,
"companyid" BIGINT,
"companyname" VARCHAR,
"brandname" VARCHAR,
"primarycategoryid" BIGINT,
"primarycategory" VARCHAR,
"subcategoryid" BIGINT,
"subcategory" VARCHAR,
"casid" BIGINT,
"casnumber" VARCHAR,
"chemicalid" BIGINT,
"chemicalname" VARCHAR,
"initialdatereported" TIMESTAMP,
"mostrecentdatereported" TIMESTAMP,
"discontinueddate" TIMESTAMP,
"chemicalcreatedat" TIMESTAMP,
"chemicalupdatedat" TIMESTAMP,
"chemicaldateremoved" TIMESTAMP,
"chemicalcount" BIGINT
);