Chemicals In Cosmetics

California Department of Public Health (healthdata.gov)

@kaggle.zarinhelena_chemicals_in_cosmetics

Table List

1 table(2.8 MB)

Chemicals In Cosmetics

@kaggle.zarinhelena_chemicals_in_cosmetics.chemicals_in_cosmetics

2.8 MB
112870 rows
22 columns

cdphid CDPHId	productname ProductName	csfid CSFId	csf CSF	companyid CompanyId	companyname CompanyName	brandname BrandName	primarycategoryid PrimaryCategoryId	primarycategory PrimaryCategory	subcategoryid SubCategoryId	subcategory SubCategory	casid CasId	casnumber CasNumber	chemicalid ChemicalId	chemicalname ChemicalName	initialdatereported InitialDateReported	mostrecentdatereported MostRecentDateReported	discontinueddate DiscontinuedDate	chemicalcreatedat ChemicalCreatedAt	chemicalupdatedat ChemicalUpdatedAt	chemicalcount ChemicalCount
2	ULTRA COLOR RICH EXTRA PLUMP LIPSTICK-ALL SHADES		nan	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		nan	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		nan	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 �		nan	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 �		nan	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 �		nan	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 chemicals_in_cosmetics (
  "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
);