Extracting Solubility Data from PubChem
This website is a teaching tool for the Fall 2017 chemistry class 'Chemical Informatics'.PubChem (https://pubchem.ncbi.nlm.nih.gov/) has a hugh amount of data about medically related chemicals. The data on this site was downloaded from PubChem in JSON format and ingested into a MySQL database using PHP scripts. The data was linked to it's chemical system using programmatic calls to the PubChem application programming interface (API). Subsequently, the textual data in the annotations was analyzed to extract the solubility, its unit, the chemical constitutes (solute/solvent) and if available the conditions under which the solubility was measured.