I'm looking for a fairly large (>100k) dataset of chemical compounds (and materials) that also has physical and chemical properties (such as boiling point, conductivity, solubility, etc.). I've looked at PubMed, but if you bulk download compounds you don't get any physical/chemical properties, just information about the structure.
I would ideally like to avoid APIs as they have limits, and scraping is too slow. I would like to just download a file containing a compound and it's physical/chemical properties (ie. like a JSON or something).
I've looked through The Materials Project's datasets and they don't have the properties I listed above.