California Product/Label Data Tables
These data tables contain a full set of product information including; product name, registration status (active/canceled), formulation, approval/inactivation dates, registration type, registered use sites, restricted use information, etc. They are structured in an ASCII, fixed width format to enable interested parties to access them using a variety of database and spreadsheet software. Please read the table formats and data dictionary documents for a complete description of the data.
Information on:
- Table Formats, PDF 7/21/2020 – Two tables, compinfo.dat and product.dat, have had certain column sizes and indexes modified. Please refer to the 'Table Formats, PDF' to view these changes if they affect you.
- Simple Entity Relationship Diagram (ERD), PDF
- Data Dictionary - Product, Chemical, Company, Excel
The 38 individual tables can be found on DPR's File Transfer Protocol (FTP) site. In addition, you can download a zip file containing all 38 tables, ZIP.
The FTP site can be used to facilitate the set-up of automatic downloads of the data. New data tables overwrite the existing files on the FTP site at approximately 6:30 p.m. PST Mon-Fri. Disclaimer: Please use Firefox or Internet Explorer to download these files from the FTP site. Other web browsers are not supported.
For content questions, contact:
Chelsea Raycraft
1001 I Street, P.O. Box 4015
Sacramento, CA 95812-4015
Phone: (916) 324-3466
E-mail: Chelsea.Raycraft@cdpr.ca.gov