VirtualSafetyAssistant.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "ace61320",
   "metadata": {
    "toc": true
   },
   "source": [
    "<h1>Table of Contents<span class=\"tocSkip\"></span></h1>\n",
    "<div class=\"toc\"><ul class=\"toc-item\"><li><span><a href=\"#Virtual-Safety-Assistant\" data-toc-modified-id=\"Virtual-Safety-Assistant-1\"><span class=\"toc-item-num\">1&nbsp;&nbsp;</span>Virtual Safety Assistant</a></span><ul class=\"toc-item\"><li><span><a href=\"#PubChem-API-python-Wrapper---PubChemPy\" data-toc-modified-id=\"PubChem-API-python-Wrapper---PubChemPy-1.1\"><span class=\"toc-item-num\">1.1&nbsp;&nbsp;</span>PubChem API python Wrapper - PubChemPy</a></span><ul class=\"toc-item\"><li><span><a href=\"#Get-the-data-as-a-df\" data-toc-modified-id=\"Get-the-data-as-a-df-1.1.1\"><span class=\"toc-item-num\">1.1.1&nbsp;&nbsp;</span>Get the data as a df</a></span></li><li><span><a href=\"#return-the-url\" data-toc-modified-id=\"return-the-url-1.1.2\"><span class=\"toc-item-num\">1.1.2&nbsp;&nbsp;</span>return the url</a></span></li></ul></li><li><span><a href=\"#Extract-data-from-Json\" data-toc-modified-id=\"Extract-data-from-Json-1.2\"><span class=\"toc-item-num\">1.2&nbsp;&nbsp;</span>Extract data from Json</a></span></li><li><span><a href=\"#Robustness-of-getting-json-data\" data-toc-modified-id=\"Robustness-of-getting-json-data-1.3\"><span class=\"toc-item-num\">1.3&nbsp;&nbsp;</span>Robustness of getting json data</a></span></li></ul></li></ul></div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8331c107",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:08:30.580956Z",
     "start_time": "2022-09-22T10:08:30.578523Z"
    }
   },
   "source": [
    "# Virtual Safety Assistant"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d15e542e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:09:03.067590Z",
     "start_time": "2022-09-22T10:09:03.062461Z"
    }
   },
   "source": [
    "Given the name of a list of chemicals, this will automatically return the relevant info you need for your safety assessment (safety codes, molecular weight, etc)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fddbffbb",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:09:43.121703Z",
     "start_time": "2022-09-22T10:09:43.119294Z"
    }
   },
   "source": [
    "## PubChem API python Wrapper - PubChemPy "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "478706de",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:40:26.650568Z",
     "start_time": "2022-09-22T10:40:26.647971Z"
    }
   },
   "outputs": [],
   "source": [
    "import pubchempy as pcp\n",
    "import pandas as pddf1 = pcp.get_compounds('C20H41Br', 'formula', as_dataframe=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d91296db",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:11:03.477425Z",
     "start_time": "2022-09-22T10:11:02.863512Z"
    }
   },
   "outputs": [],
   "source": [
    "comp = Compound.from_cid(1423)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "412661de",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:11:08.174338Z",
     "start_time": "2022-09-22T10:11:08.168915Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CCCCCCCNC1CCCC1CCCCCCC(=O)O\n"
     ]
    }
   ],
   "source": [
    "print(comp.isomeric_smiles)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "66dca5d6",
   "metadata": {},
   "outputs": [],
   "source": [
    ", 'Complexity','ConformerModelRMSD3D',"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "60b808f5",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "51c67937",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T11:20:07.237581Z",
     "start_time": "2022-09-22T11:20:06.445832Z"
    }
   },
   "outputs": [],
   "source": [
    "comps = pcp.get_compounds('benzene', 'name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "8ab10248",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T11:00:26.849211Z",
     "start_time": "2022-09-22T11:00:26.843539Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Compound(8471)"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comps[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "122d5d1a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T11:00:37.702791Z",
     "start_time": "2022-09-22T11:00:37.685031Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': {'id': {'cid': 8471}},\n",
       " 'atoms': {'aid': [1,\n",
       "   2,\n",
       "   3,\n",
       "   4,\n",
       "   5,\n",
       "   6,\n",
       "   7,\n",
       "   8,\n",
       "   9,\n",
       "   10,\n",
       "   11,\n",
       "   12,\n",
       "   13,\n",
       "   14,\n",
       "   15,\n",
       "   16,\n",
       "   17,\n",
       "   18,\n",
       "   19,\n",
       "   20,\n",
       "   21,\n",
       "   22],\n",
       "  'element': [7,\n",
       "   6,\n",
       "   6,\n",
       "   6,\n",
       "   6,\n",
       "   6,\n",
       "   6,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1]},\n",
       " 'bonds': {'aid1': [1,\n",
       "   1,\n",
       "   1,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   3,\n",
       "   3,\n",
       "   3,\n",
       "   4,\n",
       "   4,\n",
       "   4,\n",
       "   5,\n",
       "   5,\n",
       "   5,\n",
       "   6,\n",
       "   6,\n",
       "   6,\n",
       "   7,\n",
       "   7,\n",
       "   7],\n",
       "  'aid2': [2,\n",
       "   3,\n",
       "   4,\n",
       "   5,\n",
       "   8,\n",
       "   9,\n",
       "   6,\n",
       "   10,\n",
       "   11,\n",
       "   7,\n",
       "   12,\n",
       "   13,\n",
       "   14,\n",
       "   15,\n",
       "   16,\n",
       "   17,\n",
       "   18,\n",
       "   19,\n",
       "   20,\n",
       "   21,\n",
       "   22],\n",
       "  'order': [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1]},\n",
       " 'coords': [{'type': [1, 5, 255],\n",
       "   'aid': [1,\n",
       "    2,\n",
       "    3,\n",
       "    4,\n",
       "    5,\n",
       "    6,\n",
       "    7,\n",
       "    8,\n",
       "    9,\n",
       "    10,\n",
       "    11,\n",
       "    12,\n",
       "    13,\n",
       "    14,\n",
       "    15,\n",
       "    16,\n",
       "    17,\n",
       "    18,\n",
       "    19,\n",
       "    20,\n",
       "    21,\n",
       "    22],\n",
       "   'conformers': [{'x': [3.732,\n",
       "      4.5981,\n",
       "      2.866,\n",
       "      3.732,\n",
       "      5.4641,\n",
       "      2,\n",
       "      2.866,\n",
       "      4.9966,\n",
       "      4.1996,\n",
       "      3.2646,\n",
       "      2.4675,\n",
       "      3.9441,\n",
       "      4.3426,\n",
       "      5.1541,\n",
       "      6.001,\n",
       "      5.7741,\n",
       "      1.69,\n",
       "      1.4631,\n",
       "      2.31,\n",
       "      2.556,\n",
       "      2.3291,\n",
       "      3.176],\n",
       "     'y': [0.5,\n",
       "      1,\n",
       "      1,\n",
       "      -0.5,\n",
       "      0.5,\n",
       "      0.5,\n",
       "      -1,\n",
       "      1.475,\n",
       "      1.475,\n",
       "      1.475,\n",
       "      1.475,\n",
       "      -1.0826,\n",
       "      -0.3923,\n",
       "      -0.0369,\n",
       "      0.19,\n",
       "      1.0369,\n",
       "      1.0369,\n",
       "      0.19,\n",
       "      -0.0369,\n",
       "      -0.4631,\n",
       "      -1.31,\n",
       "      -1.5369]}]}],\n",
       " 'charge': 0,\n",
       " 'props': [{'urn': {'label': 'Compound',\n",
       "    'name': 'Canonicalized',\n",
       "    'datatype': 5,\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'ival': 1}},\n",
       "  {'urn': {'label': 'Compound Complexity',\n",
       "    'datatype': 7,\n",
       "    'implementation': 'E_COMPLEXITY',\n",
       "    'version': '3.4.8.18',\n",
       "    'software': 'Cactvs',\n",
       "    'source': 'Xemistry GmbH',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'fval': 25.7}},\n",
       "  {'urn': {'label': 'Count',\n",
       "    'name': 'Hydrogen Bond Acceptor',\n",
       "    'datatype': 5,\n",
       "    'implementation': 'E_NHACCEPTORS',\n",
       "    'version': '3.4.8.18',\n",
       "    'software': 'Cactvs',\n",
       "    'source': 'Xemistry GmbH',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'ival': 1}},\n",
       "  {'urn': {'label': 'Count',\n",
       "    'name': 'Hydrogen Bond Donor',\n",
       "    'datatype': 5,\n",
       "    'implementation': 'E_NHDONORS',\n",
       "    'version': '3.4.8.18',\n",
       "    'software': 'Cactvs',\n",
       "    'source': 'Xemistry GmbH',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'ival': 0}},\n",
       "  {'urn': {'label': 'Count',\n",
       "    'name': 'Rotatable Bond',\n",
       "    'datatype': 5,\n",
       "    'implementation': 'E_NROTBONDS',\n",
       "    'version': '3.4.8.18',\n",
       "    'software': 'Cactvs',\n",
       "    'source': 'Xemistry GmbH',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'ival': 3}},\n",
       "  {'urn': {'label': 'Fingerprint',\n",
       "    'name': 'SubStructure Keys',\n",
       "    'datatype': 16,\n",
       "    'parameters': 'extended 2',\n",
       "    'implementation': 'E_SCREEN',\n",
       "    'version': '3.4.8.18',\n",
       "    'software': 'Cactvs',\n",
       "    'source': 'Xemistry GmbH',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'binary': '00000371C0620000000000000000000000000000000000000000000000000000000000000000001C00000000000000C100040200030000000000000000000000000000000000000800000000000000000000000000008000000000000000000000000000000000000000000000000000000000'}},\n",
       "  {'urn': {'label': 'IUPAC Name',\n",
       "    'name': 'Allowed',\n",
       "    'datatype': 1,\n",
       "    'version': '2.7.0',\n",
       "    'software': 'Lexichem TK',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'N,N-diethylethanamine'}},\n",
       "  {'urn': {'label': 'IUPAC Name',\n",
       "    'name': 'CAS-like Style',\n",
       "    'datatype': 1,\n",
       "    'version': '2.7.0',\n",
       "    'software': 'Lexichem TK',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'N,N-diethylethanamine'}},\n",
       "  {'urn': {'label': 'IUPAC Name',\n",
       "    'name': 'Markup',\n",
       "    'datatype': 1,\n",
       "    'version': '2.7.0',\n",
       "    'software': 'Lexichem TK',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': '<I>N</I>,<I>N</I>-diethylethanamine'}},\n",
       "  {'urn': {'label': 'IUPAC Name',\n",
       "    'name': 'Preferred',\n",
       "    'datatype': 1,\n",
       "    'version': '2.7.0',\n",
       "    'software': 'Lexichem TK',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'N,N-diethylethanamine'}},\n",
       "  {'urn': {'label': 'IUPAC Name',\n",
       "    'name': 'Systematic',\n",
       "    'datatype': 1,\n",
       "    'version': '2.7.0',\n",
       "    'software': 'Lexichem TK',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'N,N-diethylethanamine'}},\n",
       "  {'urn': {'label': 'IUPAC Name',\n",
       "    'name': 'Traditional',\n",
       "    'datatype': 1,\n",
       "    'version': '2.7.0',\n",
       "    'software': 'Lexichem TK',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'triethylamine'}},\n",
       "  {'urn': {'label': 'InChI',\n",
       "    'name': 'Standard',\n",
       "    'datatype': 1,\n",
       "    'version': '1.0.6',\n",
       "    'software': 'InChI',\n",
       "    'source': 'iupac.org',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'InChI=1S/C6H15N/c1-4-7(5-2)6-3/h4-6H2,1-3H3'}},\n",
       "  {'urn': {'label': 'InChIKey',\n",
       "    'name': 'Standard',\n",
       "    'datatype': 1,\n",
       "    'version': '1.0.6',\n",
       "    'software': 'InChI',\n",
       "    'source': 'iupac.org',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'ZMANZCXQSJIPKH-UHFFFAOYSA-N'}},\n",
       "  {'urn': {'label': 'Log P',\n",
       "    'name': 'XLogP3',\n",
       "    'datatype': 7,\n",
       "    'version': '3.0',\n",
       "    'source': 'sioc-ccbg.ac.cn',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'fval': 1.4}},\n",
       "  {'urn': {'label': 'Mass',\n",
       "    'name': 'Exact',\n",
       "    'datatype': 1,\n",
       "    'version': '2.2',\n",
       "    'software': 'PubChem',\n",
       "    'source': 'ncbi.nlm.nih.gov',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': '101.120449483'}},\n",
       "  {'urn': {'label': 'Molecular Formula',\n",
       "    'datatype': 1,\n",
       "    'version': '2.2',\n",
       "    'software': 'PubChem',\n",
       "    'source': 'ncbi.nlm.nih.gov',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'C6H15N'}},\n",
       "  {'urn': {'label': 'Molecular Weight',\n",
       "    'datatype': 1,\n",
       "    'version': '2.2',\n",
       "    'software': 'PubChem',\n",
       "    'source': 'ncbi.nlm.nih.gov',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': '101.19'}},\n",
       "  {'urn': {'label': 'SMILES',\n",
       "    'name': 'Canonical',\n",
       "    'datatype': 1,\n",
       "    'version': '2.3.0',\n",
       "    'software': 'OEChem',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'CCN(CC)CC'}},\n",
       "  {'urn': {'label': 'SMILES',\n",
       "    'name': 'Isomeric',\n",
       "    'datatype': 1,\n",
       "    'version': '2.3.0',\n",
       "    'software': 'OEChem',\n",
       "    'source': 'OpenEye Scientific Software',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': 'CCN(CC)CC'}},\n",
       "  {'urn': {'label': 'Topological',\n",
       "    'name': 'Polar Surface Area',\n",
       "    'datatype': 7,\n",
       "    'implementation': 'E_TPSA',\n",
       "    'version': '3.4.8.18',\n",
       "    'software': 'Cactvs',\n",
       "    'source': 'Xemistry GmbH',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'fval': 3.2}},\n",
       "  {'urn': {'label': 'Weight',\n",
       "    'name': 'MonoIsotopic',\n",
       "    'datatype': 1,\n",
       "    'version': '2.2',\n",
       "    'software': 'PubChem',\n",
       "    'source': 'ncbi.nlm.nih.gov',\n",
       "    'release': '2021.10.14'},\n",
       "   'value': {'sval': '101.120449483'}}],\n",
       " 'count': {'heavy_atom': 7,\n",
       "  'atom_chiral': 0,\n",
       "  'atom_chiral_def': 0,\n",
       "  'atom_chiral_undef': 0,\n",
       "  'bond_chiral': 0,\n",
       "  'bond_chiral_def': 0,\n",
       "  'bond_chiral_undef': 0,\n",
       "  'isotope_atom': 0,\n",
       "  'covalent_unit': 1,\n",
       "  'tautomers': -1}}"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comps[0].record"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "a6c09f30",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:40:41.016428Z",
     "start_time": "2022-09-22T10:40:41.011137Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['__class__',\n",
       " '__delattr__',\n",
       " '__dict__',\n",
       " '__dir__',\n",
       " '__doc__',\n",
       " '__eq__',\n",
       " '__format__',\n",
       " '__ge__',\n",
       " '__getattribute__',\n",
       " '__gt__',\n",
       " '__hash__',\n",
       " '__init__',\n",
       " '__init_subclass__',\n",
       " '__le__',\n",
       " '__lt__',\n",
       " '__module__',\n",
       " '__ne__',\n",
       " '__new__',\n",
       " '__reduce__',\n",
       " '__reduce_ex__',\n",
       " '__repr__',\n",
       " '__setattr__',\n",
       " '__sizeof__',\n",
       " '__str__',\n",
       " '__subclasshook__',\n",
       " '__weakref__',\n",
       " 'aids',\n",
       " 'cids',\n",
       " 'deposited_compound',\n",
       " 'from_sid',\n",
       " 'record',\n",
       " 'sid',\n",
       " 'source_id',\n",
       " 'source_name',\n",
       " 'standardized_cid',\n",
       " 'standardized_compound',\n",
       " 'synonyms',\n",
       " 'to_dict',\n",
       " 'to_series']"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dir(comps[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "34618edf",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T10:41:27.737221Z",
     "start_time": "2022-09-22T10:41:27.731424Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method Substance.to_dict of Substance(589721)>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comps[0].to_dict"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2c9538e7",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T11:15:51.893791Z",
     "start_time": "2022-09-22T11:15:51.890040Z"
    }
   },
   "source": [
    "### Get the data as a df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "0869d69d",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T11:21:50.105650Z",
     "start_time": "2022-09-22T11:21:49.591315Z"
    }
   },
   "outputs": [],
   "source": [
    "df1 = pcp.get_compounds('triethylamine', 'benzene', 'name', as_dataframe=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "a8c68f12",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T11:21:51.932416Z",
     "start_time": "2022-09-22T11:21:51.900952Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>atom_stereo_count</th>\n",
       "      <th>atoms</th>\n",
       "      <th>bond_stereo_count</th>\n",
       "      <th>bonds</th>\n",
       "      <th>cactvs_fingerprint</th>\n",
       "      <th>canonical_smiles</th>\n",
       "      <th>charge</th>\n",
       "      <th>complexity</th>\n",
       "      <th>conformer_id_3d</th>\n",
       "      <th>conformer_rmsd_3d</th>\n",
       "      <th>...</th>\n",
       "      <th>pharmacophore_features_3d</th>\n",
       "      <th>record</th>\n",
       "      <th>rotatable_bond_count</th>\n",
       "      <th>shape_fingerprint_3d</th>\n",
       "      <th>shape_selfoverlap_3d</th>\n",
       "      <th>tpsa</th>\n",
       "      <th>undefined_atom_stereo_count</th>\n",
       "      <th>undefined_bond_stereo_count</th>\n",
       "      <th>volume_3d</th>\n",
       "      <th>xlogp</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cid</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>0</td>\n",
       "      <td>[{'aid': 1, 'number': 6, 'element': 'C', 'y': ...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'aid1': 1, 'aid2': 2, 'order': 2, 'style': 8...</td>\n",
       "      <td>1000000001100000000000000000000000000000000000...</td>\n",
       "      <td>C1=CC=CC=C1</td>\n",
       "      <td>0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>{'id': {'id': {'cid': 241}}, 'atoms': {'aid': ...</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     atom_stereo_count                                              atoms  \\\n",
       "cid                                                                         \n",
       "241                  0  [{'aid': 1, 'number': 6, 'element': 'C', 'y': ...   \n",
       "\n",
       "     bond_stereo_count                                              bonds  \\\n",
       "cid                                                                         \n",
       "241                  0  [{'aid1': 1, 'aid2': 2, 'order': 2, 'style': 8...   \n",
       "\n",
       "                                    cactvs_fingerprint canonical_smiles  \\\n",
       "cid                                                                       \n",
       "241  1000000001100000000000000000000000000000000000...      C1=CC=CC=C1   \n",
       "\n",
       "     charge  complexity conformer_id_3d conformer_rmsd_3d  ...  \\\n",
       "cid                                                        ...   \n",
       "241       0        15.5            None              None  ...   \n",
       "\n",
       "    pharmacophore_features_3d  \\\n",
       "cid                             \n",
       "241                      None   \n",
       "\n",
       "                                                record  rotatable_bond_count  \\\n",
       "cid                                                                            \n",
       "241  {'id': {'id': {'cid': 241}}, 'atoms': {'aid': ...                     0   \n",
       "\n",
       "     shape_fingerprint_3d shape_selfoverlap_3d tpsa  \\\n",
       "cid                                                   \n",
       "241                  None                 None    0   \n",
       "\n",
       "    undefined_atom_stereo_count undefined_bond_stereo_count volume_3d  xlogp  \n",
       "cid                                                                           \n",
       "241                           0                           0      None    2.1  \n",
       "\n",
       "[1 rows x 43 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7eb0d814",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T12:26:01.697973Z",
     "start_time": "2022-09-22T12:26:01.693764Z"
    }
   },
   "source": [
    "### return the url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0e8ac073",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T14:32:06.078130Z",
     "start_time": "2022-09-23T14:32:06.075449Z"
    }
   },
   "outputs": [],
   "source": [
    "def get_url(cid):\n",
    "    \n",
    "    url = f'https://pubchem.ncbi.nlm.nih.gov/rest/pug_view/data/compound/{cid}/JSON/?response_type=display'\n",
    "    \n",
    "    return url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0e0d8e78",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T14:32:06.365345Z",
     "start_time": "2022-09-23T14:32:06.361285Z"
    }
   },
   "outputs": [],
   "source": [
    "def get_cid(identifier, id_type):\n",
    "    \n",
    "    assert id_type in ['name', 'smiles', 'sdf', 'inchi', 'inchikey', 'formula', 'cid']\n",
    "    \n",
    "    if id_type == 'cid':\n",
    "        return identifier\n",
    "    \n",
    "    else:\n",
    "        cid = pcp.get_cids(identifier, id_type)\n",
    "        return cid \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "0d0ac4b5",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T12:12:59.084847Z",
     "start_time": "2022-09-23T12:12:58.572183Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[8471]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_cid('triethylamine', 'name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "47be8f11",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T12:13:02.394795Z",
     "start_time": "2022-09-23T12:13:01.919490Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://pubchem.ncbi.nlm.nih.gov/rest/pug_view/data/compound/962/JSON/?response_type=display'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_url(get_cid('water', 'name')[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1b7a8329",
   "metadata": {},
   "source": [
    "## Extract data from Json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "4e9bbadc",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T14:58:12.063670Z",
     "start_time": "2022-09-23T14:58:11.598492Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "887"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_cid('methanol', 'name')[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "af147f0e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:40:58.410428Z",
     "start_time": "2022-09-23T17:40:56.884317Z"
    }
   },
   "outputs": [],
   "source": [
    "# scraping the web\n",
    " \n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "from requests_html import HTMLSession\n",
    "import json\n",
    "import pubchempy as pcp\n",
    "\n",
    " \n",
    "url =get_url(get_cid('methanol', 'name')[0])\n",
    " \n",
    " \n",
    "read = requests.get(url)\n",
    " \n",
    "html_content = read.content\n",
    "soup = BeautifulSoup(html_content, \"html.parser\")\n",
    " \n",
    "raw = soup.get_text()\n",
    "\n",
    "#data = json.loads(raw)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "50c1bceb",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:44:49.064071Z",
     "start_time": "2022-09-23T17:44:49.058478Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://pubchem.ncbi.nlm.nih.gov/rest/pug_view/data/compound/887/JSON/?response_type=display'"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "ba22ed08",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:43:04.881723Z",
     "start_time": "2022-09-23T17:43:04.863624Z"
    }
   },
   "outputs": [],
   "source": [
    "with open('test.txt', 'w') as f:\n",
    "    f.write(str(html_content))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "58ebb545",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:46:54.310818Z",
     "start_time": "2022-09-23T17:46:54.304566Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "916230"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(raw)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "acf0e017",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:47:44.737957Z",
     "start_time": "2022-09-23T17:47:44.695199Z"
    }
   },
   "outputs": [
    {
     "ename": "JSONDecodeError",
     "evalue": "Expecting value: line 1 column 1 (char 0)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mJSONDecodeError\u001b[0m                           Traceback (most recent call last)",
      "Input \u001b[0;32mIn [61]\u001b[0m, in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0m data2 \u001b[38;5;241m=\u001b[39m json\u001b[38;5;241m.\u001b[39mloads(\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m/Users/dsw46/Downloads/compound_CID_887.json\u001b[39m\u001b[38;5;124m'\u001b[39m)\n",
      "File \u001b[0;32m~/opt/anaconda3/envs/dswigh_default/lib/python3.9/json/__init__.py:346\u001b[0m, in \u001b[0;36mloads\u001b[0;34m(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)\u001b[0m\n\u001b[1;32m    341\u001b[0m     s \u001b[38;5;241m=\u001b[39m s\u001b[38;5;241m.\u001b[39mdecode(detect_encoding(s), \u001b[38;5;124m'\u001b[39m\u001b[38;5;124msurrogatepass\u001b[39m\u001b[38;5;124m'\u001b[39m)\n\u001b[1;32m    343\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m (\u001b[38;5;28mcls\u001b[39m \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m object_hook \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m\n\u001b[1;32m    344\u001b[0m         parse_int \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m parse_float \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m\n\u001b[1;32m    345\u001b[0m         parse_constant \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m object_pairs_hook \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m kw):\n\u001b[0;32m--> 346\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43m_default_decoder\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdecode\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    347\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mcls\u001b[39m \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m    348\u001b[0m     \u001b[38;5;28mcls\u001b[39m \u001b[38;5;241m=\u001b[39m JSONDecoder\n",
      "File \u001b[0;32m~/opt/anaconda3/envs/dswigh_default/lib/python3.9/json/decoder.py:337\u001b[0m, in \u001b[0;36mJSONDecoder.decode\u001b[0;34m(self, s, _w)\u001b[0m\n\u001b[1;32m    332\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mdecode\u001b[39m(\u001b[38;5;28mself\u001b[39m, s, _w\u001b[38;5;241m=\u001b[39mWHITESPACE\u001b[38;5;241m.\u001b[39mmatch):\n\u001b[1;32m    333\u001b[0m     \u001b[38;5;124;03m\"\"\"Return the Python representation of ``s`` (a ``str`` instance\u001b[39;00m\n\u001b[1;32m    334\u001b[0m \u001b[38;5;124;03m    containing a JSON document).\u001b[39;00m\n\u001b[1;32m    335\u001b[0m \n\u001b[1;32m    336\u001b[0m \u001b[38;5;124;03m    \"\"\"\u001b[39;00m\n\u001b[0;32m--> 337\u001b[0m     obj, end \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mraw_decode\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43midx\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43m_w\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m0\u001b[39;49m\u001b[43m)\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mend\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    338\u001b[0m     end \u001b[38;5;241m=\u001b[39m _w(s, end)\u001b[38;5;241m.\u001b[39mend()\n\u001b[1;32m    339\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m end \u001b[38;5;241m!=\u001b[39m \u001b[38;5;28mlen\u001b[39m(s):\n",
      "File \u001b[0;32m~/opt/anaconda3/envs/dswigh_default/lib/python3.9/json/decoder.py:355\u001b[0m, in \u001b[0;36mJSONDecoder.raw_decode\u001b[0;34m(self, s, idx)\u001b[0m\n\u001b[1;32m    353\u001b[0m     obj, end \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mscan_once(s, idx)\n\u001b[1;32m    354\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mStopIteration\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n\u001b[0;32m--> 355\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m JSONDecodeError(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mExpecting value\u001b[39m\u001b[38;5;124m\"\u001b[39m, s, err\u001b[38;5;241m.\u001b[39mvalue) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;28mNone\u001b[39m\n\u001b[1;32m    356\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m obj, end\n",
      "\u001b[0;31mJSONDecodeError\u001b[0m: Expecting value: line 1 column 1 (char 0)"
     ]
    }
   ],
   "source": [
    "data2 = json.loads('/Users/dsw46/Downloads/compound_CID_887.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "5db406da",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:39:01.704606Z",
     "start_time": "2022-09-23T17:39:01.698952Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/linkout\"\\n      }\\n    ]\\n  }\\n}\\n'"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw[916200:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "57be32ba",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:37:18.832226Z",
     "start_time": "2022-09-23T17:37:17.484794Z"
    }
   },
   "outputs": [],
   "source": [
    "# scraping the web\n",
    " \n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "from requests_html import HTMLSession\n",
    "import json\n",
    "import pubchempy as pcp\n",
    "\n",
    " \n",
    "url =get_url(get_cid('triethylamine', 'name')[0])\n",
    " \n",
    " \n",
    "read = requests.get(url)\n",
    " \n",
    "html_content = read.content\n",
    "soup = BeautifulSoup(html_content, \"html.parser\")\n",
    " \n",
    "raw = soup.get_text()\n",
    "\n",
    "data = json.loads(raw)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "ffea26c9",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:37:48.285463Z",
     "start_time": "2022-09-23T17:37:48.279205Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'nlm.nih.gov/projects/linkout\"\\n      }\\n    ]\\n  }\\n}\\n'"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw[-50:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0df08162",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "58f2ae05",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:48:16.750477Z",
     "start_time": "2022-09-23T17:48:16.736169Z"
    }
   },
   "outputs": [],
   "source": [
    "f = open('/Users/dsw46/Downloads/compound_CID_887.json')\n",
    "file = json.load(f)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "c1f24308",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T17:48:35.740372Z",
     "start_time": "2022-09-23T17:48:35.720844Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "777828"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(str(file))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "7215dc5e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:47:14.703605Z",
     "start_time": "2022-09-23T13:47:14.699598Z"
    }
   },
   "outputs": [],
   "source": [
    "raw_s = r'{}'.format(raw)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "09ad82f0",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:52:45.388268Z",
     "start_time": "2022-09-23T13:52:45.375545Z"
    }
   },
   "outputs": [],
   "source": [
    "data = json.loads(raw)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "843972ec",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:55:56.539553Z",
     "start_time": "2022-09-23T13:55:56.535498Z"
    }
   },
   "outputs": [],
   "source": [
    "raw_test = '{}'.format(raw_s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "f744069c",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:56:00.905066Z",
     "start_time": "2022-09-23T13:56:00.857290Z"
    }
   },
   "outputs": [
    {
     "ename": "JSONDecodeError",
     "evalue": "Expecting ',' delimiter: line 18380 column 1 (char 916228)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mJSONDecodeError\u001b[0m                           Traceback (most recent call last)",
      "Input \u001b[0;32mIn [90]\u001b[0m, in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0m test_data \u001b[38;5;241m=\u001b[39m json\u001b[38;5;241m.\u001b[39mloads(raw_test)\n",
      "File \u001b[0;32m~/opt/anaconda3/envs/dswigh_default/lib/python3.9/json/__init__.py:346\u001b[0m, in \u001b[0;36mloads\u001b[0;34m(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)\u001b[0m\n\u001b[1;32m    341\u001b[0m     s \u001b[38;5;241m=\u001b[39m s\u001b[38;5;241m.\u001b[39mdecode(detect_encoding(s), \u001b[38;5;124m'\u001b[39m\u001b[38;5;124msurrogatepass\u001b[39m\u001b[38;5;124m'\u001b[39m)\n\u001b[1;32m    343\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m (\u001b[38;5;28mcls\u001b[39m \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m object_hook \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m\n\u001b[1;32m    344\u001b[0m         parse_int \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m parse_float \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m\n\u001b[1;32m    345\u001b[0m         parse_constant \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m object_pairs_hook \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m kw):\n\u001b[0;32m--> 346\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43m_default_decoder\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdecode\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    347\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mcls\u001b[39m \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m    348\u001b[0m     \u001b[38;5;28mcls\u001b[39m \u001b[38;5;241m=\u001b[39m JSONDecoder\n",
      "File \u001b[0;32m~/opt/anaconda3/envs/dswigh_default/lib/python3.9/json/decoder.py:337\u001b[0m, in \u001b[0;36mJSONDecoder.decode\u001b[0;34m(self, s, _w)\u001b[0m\n\u001b[1;32m    332\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mdecode\u001b[39m(\u001b[38;5;28mself\u001b[39m, s, _w\u001b[38;5;241m=\u001b[39mWHITESPACE\u001b[38;5;241m.\u001b[39mmatch):\n\u001b[1;32m    333\u001b[0m     \u001b[38;5;124;03m\"\"\"Return the Python representation of ``s`` (a ``str`` instance\u001b[39;00m\n\u001b[1;32m    334\u001b[0m \u001b[38;5;124;03m    containing a JSON document).\u001b[39;00m\n\u001b[1;32m    335\u001b[0m \n\u001b[1;32m    336\u001b[0m \u001b[38;5;124;03m    \"\"\"\u001b[39;00m\n\u001b[0;32m--> 337\u001b[0m     obj, end \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mraw_decode\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43midx\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43m_w\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m0\u001b[39;49m\u001b[43m)\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mend\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    338\u001b[0m     end \u001b[38;5;241m=\u001b[39m _w(s, end)\u001b[38;5;241m.\u001b[39mend()\n\u001b[1;32m    339\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m end \u001b[38;5;241m!=\u001b[39m \u001b[38;5;28mlen\u001b[39m(s):\n",
      "File \u001b[0;32m~/opt/anaconda3/envs/dswigh_default/lib/python3.9/json/decoder.py:353\u001b[0m, in \u001b[0;36mJSONDecoder.raw_decode\u001b[0;34m(self, s, idx)\u001b[0m\n\u001b[1;32m    344\u001b[0m \u001b[38;5;124;03m\"\"\"Decode a JSON document from ``s`` (a ``str`` beginning with\u001b[39;00m\n\u001b[1;32m    345\u001b[0m \u001b[38;5;124;03ma JSON document) and return a 2-tuple of the Python\u001b[39;00m\n\u001b[1;32m    346\u001b[0m \u001b[38;5;124;03mrepresentation and the index in ``s`` where the document ended.\u001b[39;00m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m    350\u001b[0m \n\u001b[1;32m    351\u001b[0m \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m    352\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[0;32m--> 353\u001b[0m     obj, end \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mscan_once\u001b[49m\u001b[43m(\u001b[49m\u001b[43ms\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43midx\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    354\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mStopIteration\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n\u001b[1;32m    355\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m JSONDecodeError(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mExpecting value\u001b[39m\u001b[38;5;124m\"\u001b[39m, s, err\u001b[38;5;241m.\u001b[39mvalue) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;28mNone\u001b[39m\n",
      "\u001b[0;31mJSONDecodeError\u001b[0m: Expecting ',' delimiter: line 18380 column 1 (char 916228)"
     ]
    }
   ],
   "source": [
    "test_data = json.loads(raw_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "7912c141",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:57:37.906537Z",
     "start_time": "2022-09-23T13:57:37.901840Z"
    }
   },
   "outputs": [],
   "source": [
    "data = json.loads(\n",
    "    '{ \"employee\":{ \"name\":\"Alice \\\\\"developer\\\\\"\" } }'\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "f6010002",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:57:52.553097Z",
     "start_time": "2022-09-23T13:57:52.548430Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Alice \"developer\"'"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['employee']['name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "a36fbcc9",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:54:13.552260Z",
     "start_time": "2022-09-23T13:54:13.545885Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'    \"Name\": \"FDA Drug Type and Pharmacologic Classification\",\\n        \"Description\": \"The FDA Drug Type and Pharmacologic Classification is created based on the FDA drug types and pharm classes data from the National Drug Code (NDC) Directory.\",\\n        \"URL\": \"https://www.fda.gov/drugs/drug-approvals-and-databases/national-drug-code-directory\",\\n        \"LicenseNote\": \"Unless otherwise noted, the contents of the FDA website (www.fda.gov), both text and graphics, are not copyrighted. They are in the public domain and may be republished, reprinted and otherwise used freely by anyone without the need to obtain permission from FDA. Credit to the U.S. Food and Drug Administration as the source is appreciated but not required.\",\\n        \"LicenseURL\": \"https://www.fda.gov/about-fda/about-website/website-policies#linking\"\\n      },\\n      {\\n        \"ReferenceNumber\": 130,\\n        \"SourceName\": \"EPA Substance Registry Services\",\\n        \"SourceID\": \"epasrs_tree\",\\n        \"Name\": \"EPA SRS List Classification\",\\n        \"Description\": \"Substance Registry Services (SRS) is the Environmental Protection Agency\\'s (EPA) central system for information about substances that are tracked or regulated by EPA or other sources. It is a resource for basic information about chemicals, biological organisms, and other substances of interest to EPA and its state and tribal partners. SRS makes it possible to identify which EPA data systems, environmental statutes, or other sources have information about a substance and which synonym is used by that system or statute.\",\\n        \"URL\": \"https://sor.epa.gov/sor_internet/registry/substreg/LandingPage.do\",\\n        \"LicenseURL\": \"https://www.epa.gov/privacy/privacy-act-laws-policies-and-resources\"\\n      },\\n      {\\n        \"ReferenceNumber\": 131,\\n        \"SourceName\": \"PATENTSCOPE (WIPO)\",\\n        \"Name\": \"SID 403032543\",\\n        \"Description\": \"The PATENTSCOPE database from WIPO includes patent and chemical structure search (with a free account) that gives access to millions of patent documents. The World Intellectual Property Organisation (WIPO) is a specialized United Nations (UN) agency headquartered in Geneva (Switzerland). Our mission is to lead the development of a balanced and effective international Intellectual Property (IP) system that enables innovation and creativity for the benefit of all. We help governments, businesses and society realize the benefits of Intellectual Property and are notably a world reference source for IP information.\",\\n        \"URL\": \"https://pubchem.ncbi.nlm.nih.gov/substance/403032543\"\\n      },\\n      {\\n        \"ReferenceNumber\": 132,\\n        \"SourceName\": \"NCBI\",\\n        \"SourceID\": \"LinkOut\",\\n        \"Description\": \"LinkOut is a service that allows one to link directly from NCBI databases to a wide range of information and services beyond NCBI systems.\",\\n        \"URL\": \"https://www.ncbi.nlm.nih.gov/projects/linkout\"\\n      }\\n    ]\\n  }\\n}\\n'"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw[1405100:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "a14beb39",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:59:28.110002Z",
     "start_time": "2022-09-23T13:59:28.104564Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\n}\\n'"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_s[916227:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "2b3a97c7",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:28:11.266934Z",
     "start_time": "2022-09-23T13:28:11.253883Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "with open('test.txt', 'w') as f:\n",
    "    f.write(str(data))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "893d51e8",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T12:13:06.891427Z",
     "start_time": "2022-09-23T12:13:06.884506Z"
    }
   },
   "outputs": [],
   "source": [
    "def get_hazard_info(data):\n",
    "    # Find the safety and hazards section\n",
    "    # We want the hazard codes from the European Chemicals Agency (ECHA)\n",
    "\n",
    "    for i in range(len(data['Record']['Section'])):\n",
    "        if data['Record']['Section'][i]['TOCHeading'] == 'Safety and Hazards':\n",
    "            for i in range(len(data['Record']['Section'][11]['Section'][0]['Section'][0]['Information'])):\n",
    "                if data['Record']['Section'][11]['Section'][0]['Section'][0]['Information'][i]['Name'] == 'ECHA C&L Notifications Summary':\n",
    "                    pictures_json = data['Record']['Section'][11]['Section'][0]['Section'][0]['Information'][i-4]\n",
    "                    hcodes_json = data['Record']['Section'][11]['Section'][0]['Section'][0]['Information'][i-2]\n",
    "    hcodes = []\n",
    "    hcodes_descriptions = []\n",
    "    for section in hcodes_json['Value']['StringWithMarkup']:\n",
    "        hcode = section['String'][:4]\n",
    "        hcode_description = section['String']\n",
    "        hcodes += [hcode]\n",
    "        hcodes_descriptions += [hcode_description]\n",
    "    \n",
    "    pictures = []\n",
    "    for section in pictures_json['Value']['StringWithMarkup'][0]['Markup']:\n",
    "        picture = section['URL']\n",
    "        pictures += [picture]\n",
    "        \n",
    "    return [hcodes, hcodes_descriptions, pictures]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5ad790c9",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T12:13:15.872406Z",
     "start_time": "2022-09-23T12:13:15.866696Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['H225', 'H302', 'H311', 'H312', 'H314', 'H318', 'H331', 'H332', 'H335'],\n",
       " ['H225 (99.98%): Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "  'H302 (99.98%): Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "  'H311 (45.82%): Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "  'H312 (54.48%): Harmful in contact with skin [Warning Acute toxicity, dermal]',\n",
       "  'H314 (100%): Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "  'H318 (42.76%): Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       "  'H331 (44.84%): Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       "  'H332 (54.53%): Harmful if inhaled [Warning Acute toxicity, inhalation]',\n",
       "  'H335 (48.98%): May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]'],\n",
       " ['https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "  'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "  'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       "  'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg']]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_hazard_info(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "96858afd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bb53c45d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2a62a0f7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "id": "34f3b2af",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:43:23.746848Z",
     "start_time": "2022-09-22T13:43:23.743506Z"
    }
   },
   "outputs": [],
   "source": [
    "hcodes = []\n",
    "hcodes_descriptions = []\n",
    "for section in hcodes_json['Value']['StringWithMarkup']:\n",
    "    hcode = section['String'][:4]\n",
    "    hcode_description = section['String']\n",
    "    hcodes += [hcode]\n",
    "    hcodes_descriptions += [hcode_description]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "id": "4033a449",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:43:24.025761Z",
     "start_time": "2022-09-22T13:43:24.022074Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['H225', 'H302', 'H311', 'H312', 'H314', 'H318', 'H331', 'H332', 'H335']"
      ]
     },
     "execution_count": 203,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hcodes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "id": "5c818813",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:43:24.581870Z",
     "start_time": "2022-09-22T13:43:24.577851Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['H225 (99.98%): Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       " 'H302 (99.98%): Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       " 'H311 (45.82%): Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       " 'H312 (54.48%): Harmful in contact with skin [Warning Acute toxicity, dermal]',\n",
       " 'H314 (100%): Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       " 'H318 (42.76%): Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       " 'H331 (44.84%): Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       " 'H332 (54.53%): Harmful if inhaled [Warning Acute toxicity, inhalation]',\n",
       " 'H335 (48.98%): May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]']"
      ]
     },
     "execution_count": 204,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hcodes_descriptions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "id": "31608e08",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:46:52.143391Z",
     "start_time": "2022-09-22T13:46:52.137591Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg'"
      ]
     },
     "execution_count": 223,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pictures_json['Value']['StringWithMarkup'][0]['Markup'][0]['URL']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 224,
   "id": "cdbe4428",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:47:18.492356Z",
     "start_time": "2022-09-22T13:47:18.489025Z"
    }
   },
   "outputs": [],
   "source": [
    "pictures = []\n",
    "for section in pictures_json['Value']['StringWithMarkup'][0]['Markup']:\n",
    "    picture = section['URL']\n",
    "    pictures += [picture]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 225,
   "id": "33a36d87",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:47:20.780217Z",
     "start_time": "2022-09-22T13:47:20.775889Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       " 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       " 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       " 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg']"
      ]
     },
     "execution_count": 225,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pictures"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "57360e47",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cbb26160",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "id": "e21690db",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:20:30.078460Z",
     "start_time": "2022-09-22T13:20:30.071868Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'ECHA C&L Notifications Summary'"
      ]
     },
     "execution_count": 173,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Record']['Section'][11]['Section'][0]['Section'][0]['Information'][8]['Name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "id": "db57d335",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:21:30.653697Z",
     "start_time": "2022-09-22T13:21:30.644633Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ReferenceNumber': 17,\n",
       " 'Name': 'GHS Hazard Statements',\n",
       " 'Value': {'StringWithMarkup': [{'String': 'H225 (99.98%): Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "    'Markup': [{'Start': 50,\n",
       "      'Length': 6,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSDanger'}]},\n",
       "   {'String': 'H302 (99.98%): Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "    'Markup': [{'Start': 37,\n",
       "      'Length': 7,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSWarning'}]},\n",
       "   {'String': 'H311 (45.82%): Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "    'Markup': [{'Start': 43,\n",
       "      'Length': 6,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSDanger'}]},\n",
       "   {'String': 'H312 (54.48%): Harmful in contact with skin [Warning Acute toxicity, dermal]',\n",
       "    'Markup': [{'Start': 45,\n",
       "      'Length': 7,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSWarning'}]},\n",
       "   {'String': 'H314 (100%): Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "    'Markup': [{'Start': 54,\n",
       "      'Length': 6,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSDanger'}]},\n",
       "   {'String': 'H318 (42.76%): Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       "    'Markup': [{'Start': 42,\n",
       "      'Length': 6,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSDanger'}]},\n",
       "   {'String': 'H331 (44.84%): Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       "    'Markup': [{'Start': 33,\n",
       "      'Length': 6,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSDanger'}]},\n",
       "   {'String': 'H332 (54.53%): Harmful if inhaled [Warning Acute toxicity, inhalation]',\n",
       "    'Markup': [{'Start': 35,\n",
       "      'Length': 7,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSWarning'}]},\n",
       "   {'String': 'H335 (48.98%): May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]',\n",
       "    'Markup': [{'Start': 49,\n",
       "      'Length': 7,\n",
       "      'Type': 'Color',\n",
       "      'Extra': 'GHSWarning'}]}]}}"
      ]
     },
     "execution_count": 179,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Record']['Section'][11]['Section'][0]['Section'][0]['Information'][6]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "a7f743cf",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T13:09:08.859594Z",
     "start_time": "2022-09-22T13:09:08.775893Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'TOCHeading': 'Hazards Identification',\n",
       "  'Description': 'This section identifies the hazards of the chemical presented on the safety data sheet (SDS) and the appropriate warning information associated with those hazards.  The information in this section includes, but are not limited to, the hazard classification of the chemical, signal word, pictograms, hazard statements and precautionary statements.',\n",
       "  'URL': 'https://www.osha.gov/sites/default/files/publications/OSHA3514.pdf',\n",
       "  'Section': [{'TOCHeading': 'GHS Classification',\n",
       "    'Description': 'GHS (Globally Harmonized System of Classification and Labelling of Chemicals) is a United Nations system to identify hazardous chemicals and to inform users about these hazards. GHS has been adopted by many countries around the world and is now also used as the basis for international and national transport regulations for dangerous goods. The GHS hazard statements, class categories, pictograms, signal words, and the precautionary statements can be found on the PubChem GHS page.',\n",
       "    'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/',\n",
       "    'DisplayControls': {'CreateTable': {'FromInformationIn': 'ThisSection',\n",
       "      'NumberOfColumns': 2,\n",
       "      'ColumnContents': ['Name', 'Value']},\n",
       "     'ShowAtMost': 1},\n",
       "    'Information': [{'ReferenceNumber': 16,\n",
       "      'Name': 'Pictogram(s)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '          ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Flammable'},\n",
       "          {'Start': 1,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Corrosive'},\n",
       "          {'Start': 2,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Irritant'}]}]}},\n",
       "     {'ReferenceNumber': 16,\n",
       "      'Name': 'Signal',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Danger',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 16,\n",
       "      'Name': 'GHS Hazard Statements',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'H225: Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H302: Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "         'Markup': [{'Start': 28,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H312: Harmful in contact with skin [Warning Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 36,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H314: Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "         'Markup': [{'Start': 47,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H332: Harmful if inhaled [Warning Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 26,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]}]}},\n",
       "     {'ReferenceNumber': 16,\n",
       "      'Name': 'Precautionary Statement Codes',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'P210, P233, P240, P241, P242, P243, P260, P261, P264, P270, P271, P280, P301+P317, P301+P330+P331, P302+P352, P302+P361+P354, P303+P361+P353, P304+P340, P305+P354+P338, P316, P317, P321, P330, P362+P364, P363, P370+P378, P403+P235, P405, and P501'},\n",
       "        {'String': '(The corresponding statement to each P-code can be found at the GHS Classification page.)',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 18,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/#_prec'}]}]}},\n",
       "     {'ReferenceNumber': 17,\n",
       "      'Name': 'Pictogram(s)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '          ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Flammable'},\n",
       "          {'Start': 1,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Corrosive'},\n",
       "          {'Start': 2,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Acute Toxic'},\n",
       "          {'Start': 3,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Irritant'}]}]}},\n",
       "     {'ReferenceNumber': 17,\n",
       "      'Name': 'Signal',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Danger',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 17,\n",
       "      'Name': 'GHS Hazard Statements',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'H225 (99.98%): Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "         'Markup': [{'Start': 50,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H302 (99.98%): Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "         'Markup': [{'Start': 37,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H311 (45.82%): Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 43,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H312 (54.48%): Harmful in contact with skin [Warning Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 45,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H314 (100%): Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "         'Markup': [{'Start': 54,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H318 (42.76%): Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       "         'Markup': [{'Start': 42,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H331 (44.84%): Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 33,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H332 (54.53%): Harmful if inhaled [Warning Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 35,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H335 (48.98%): May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]',\n",
       "         'Markup': [{'Start': 49,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]}]}},\n",
       "     {'ReferenceNumber': 17,\n",
       "      'Name': 'Precautionary Statement Codes',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'P210, P233, P240, P241, P242, P243, P260, P261, P264, P264+P265, P270, P271, P280, P301+P317, P301+P330+P331, P302+P352, P302+P361+P354, P303+P361+P353, P304+P340, P305+P354+P338, P316, P317, P319, P321, P330, P361+P364, P362+P364, P363, P370+P378, P403+P233, P403+P235, P405, and P501'},\n",
       "        {'String': '(The corresponding statement to each P-code can be found at the GHS Classification page.)',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 18,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/#_prec'}]}]}},\n",
       "     {'ReferenceNumber': 17,\n",
       "      'Name': 'ECHA C&L Notifications Summary',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Aggregated GHS information provided by 5696 companies from 67 notifications to the ECHA C&L Inventory. Each notification may be associated with multiple companies.',\n",
       "         'Markup': [{'Start': 0, 'Length': 167, 'Type': 'Italics'}]},\n",
       "        {'String': 'Reported as not meeting GHS hazard criteria by 2 of 5696 companies. For more detailed information, please visit  ECHA C&L website.',\n",
       "         'Markup': [{'Start': 0, 'Length': 134, 'Type': 'Italics'},\n",
       "          {'Start': 113,\n",
       "           'Length': 20,\n",
       "           'URL': 'https://echa.europa.eu/information-on-chemicals/cl-inventory-database/-/discli/details/127374'}]},\n",
       "        {'String': 'Of the 66 notification(s) provided by 5694 of 5696 companies with hazard statement code(s).',\n",
       "         'Markup': [{'Start': 0, 'Length': 91, 'Type': 'Italics'}]},\n",
       "        {'String': 'Information may vary between notifications depending on impurities, additives, and other factors. The percentage value in parenthesis indicates the notified classification ratio from companies that provide hazard codes. Only hazard codes with percentage values above 10% are shown.',\n",
       "         'Markup': [{'Start': 0, 'Length': 281, 'Type': 'Italics'}]}]}},\n",
       "     {'ReferenceNumber': 24,\n",
       "      'Name': 'Pictogram(s)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '          ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Flammable'},\n",
       "          {'Start': 1,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Corrosive'},\n",
       "          {'Start': 2,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Acute Toxic'},\n",
       "          {'Start': 3,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Irritant'}]}]}},\n",
       "     {'ReferenceNumber': 24,\n",
       "      'Name': 'Signal',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Danger',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 24,\n",
       "      'Name': 'GHS Hazard Statements',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'H225: Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H302: Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "         'Markup': [{'Start': 28,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H311: Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 34,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H314: Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "         'Markup': [{'Start': 47,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H331: Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 24,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H335: May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]',\n",
       "         'Markup': [{'Start': 40,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]}]}},\n",
       "     {'ReferenceNumber': 24,\n",
       "      'Name': 'Precautionary Statement Codes',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'P210, P233, P240, P241, P242, P243, P260, P261, P264, P270, P271, P280, P301+P317, P301+P330+P331, P302+P352, P302+P361+P354, P303+P361+P353, P304+P340, P305+P354+P338, P316, P319, P321, P330, P361+P364, P363, P370+P378, P403+P233, P403+P235, P405, and P501'},\n",
       "        {'String': '(The corresponding statement to each P-code can be found at the GHS Classification page.)',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 18,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/#_prec'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'Pictogram(s)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '          ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Flammable'},\n",
       "          {'Start': 1,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Corrosive'},\n",
       "          {'Start': 2,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Acute Toxic'},\n",
       "          {'Start': 3,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Irritant'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'Signal',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Danger',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'GHS Hazard Statements',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'H225: Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H302: Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "         'Markup': [{'Start': 28,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H311: Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 34,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H314: Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "         'Markup': [{'Start': 47,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H318: Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       "         'Markup': [{'Start': 33,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H331: Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 24,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H335: May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]',\n",
       "         'Markup': [{'Start': 40,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H401: Toxic to aquatic life [Hazardous to the aquatic environment, acute hazard]'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'Precautionary Statement Codes',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'P210, P233, P240, P241, P242, P243, P260, P261, P264, P264+P265, P270, P271, P273, P280, P301+P317, P301+P330+P331, P302+P352, P302+P361+P354, P303+P361+P353, P304+P340, P305+P354+P338, P316, P317, P319, P321, P330, P361+P364, P363, P370+P378, P403+P233, P403+P235, P405, and P501'},\n",
       "        {'String': '(The corresponding statement to each P-code can be found at the GHS Classification page.)',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 18,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/#_prec'}]}]}},\n",
       "     {'ReferenceNumber': 41,\n",
       "      'Name': 'Pictogram(s)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '          ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Flammable'},\n",
       "          {'Start': 1,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Corrosive'},\n",
       "          {'Start': 2,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Acute Toxic'},\n",
       "          {'Start': 3,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Irritant'},\n",
       "          {'Start': 4,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS08.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Health Hazard'}]}]}},\n",
       "     {'ReferenceNumber': 41,\n",
       "      'Name': 'Signal',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Danger',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 41,\n",
       "      'Name': 'GHS Hazard Statements',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'H225: Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H302: Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "         'Markup': [{'Start': 28,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H311: Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 34,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H314: Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "         'Markup': [{'Start': 47,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H318: Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       "         'Markup': [{'Start': 33,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H332: Harmful if inhaled [Warning Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 26,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H335: May cause respiratory irritation [Warning Specific target organ toxicity, single exposure; Respiratory tract irritation]',\n",
       "         'Markup': [{'Start': 40,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H370: Causes damage to organs [Danger Specific target organ toxicity, single exposure]',\n",
       "         'Markup': [{'Start': 31,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H373: Causes damage to organs through prolonged or repeated exposure [Warning Specific target organ toxicity, repeated exposure]',\n",
       "         'Markup': [{'Start': 70,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H401: Toxic to aquatic life [Hazardous to the aquatic environment, acute hazard]'},\n",
       "        {'String': 'H412: Harmful to aquatic life with long lasting effects [Hazardous to the aquatic environment, long-term hazard]'}]}},\n",
       "     {'ReferenceNumber': 41,\n",
       "      'Name': 'Precautionary Statement Codes',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'P210, P233, P240, P241, P242, P243, P260, P261, P264, P264+P265, P270, P271, P273, P280, P301+P317, P301+P330+P331, P302+P352, P302+P361+P354, P303+P361+P353, P304+P340, P305+P354+P338, P308+P316, P316, P317, P319, P321, P330, P361+P364, P363, P370+P378, P403+P233, P403+P235, P405, and P501'},\n",
       "        {'String': '(The corresponding statement to each P-code can be found at the GHS Classification page.)',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 18,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/#_prec'}]}]}},\n",
       "     {'ReferenceNumber': 42,\n",
       "      'Name': 'Pictogram(s)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '          ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS02.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Flammable'},\n",
       "          {'Start': 1,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS05.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Corrosive'},\n",
       "          {'Start': 2,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS06.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Acute Toxic'},\n",
       "          {'Start': 3,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS07.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Irritant'},\n",
       "          {'Start': 4,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/images/ghs/GHS08.svg',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': 'Health Hazard'}]}]}},\n",
       "     {'ReferenceNumber': 42,\n",
       "      'Name': 'Signal',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Danger',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 42,\n",
       "      'Name': 'GHS Hazard Statements',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'H225: Highly Flammable liquid and vapor [Danger Flammable liquids]',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H302: Harmful if swallowed [Warning Acute toxicity, oral]',\n",
       "         'Markup': [{'Start': 28,\n",
       "           'Length': 7,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSWarning'}]},\n",
       "        {'String': 'H311: Toxic in contact with skin [Danger Acute toxicity, dermal]',\n",
       "         'Markup': [{'Start': 34,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H314: Causes severe skin burns and eye damage [Danger Skin corrosion/irritation]',\n",
       "         'Markup': [{'Start': 47,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H318: Causes serious eye damage [Danger Serious eye damage/eye irritation]',\n",
       "         'Markup': [{'Start': 33,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H331: Toxic if inhaled [Danger Acute toxicity, inhalation]',\n",
       "         'Markup': [{'Start': 24,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H370: Causes damage to organs [Danger Specific target organ toxicity, single exposure]',\n",
       "         'Markup': [{'Start': 31,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]},\n",
       "        {'String': 'H372: Causes damage to organs through prolonged or repeated exposure [Danger Specific target organ toxicity, repeated exposure]',\n",
       "         'Markup': [{'Start': 70,\n",
       "           'Length': 6,\n",
       "           'Type': 'Color',\n",
       "           'Extra': 'GHSDanger'}]}]}},\n",
       "     {'ReferenceNumber': 42,\n",
       "      'Name': 'Precautionary Statement Codes',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'P210, P233, P240, P241, P242, P243, P260, P261, P264, P264+P265, P270, P271, P280, P301+P317, P301+P330+P331, P302+P352, P302+P361+P354, P303+P361+P353, P304+P340, P305+P354+P338, P308+P316, P316, P317, P319, P321, P330, P361+P364, P363, P370+P378, P403+P233, P403+P235, P405, and P501'},\n",
       "        {'String': '(The corresponding statement to each P-code can be found at the GHS Classification page.)',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 18,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/#_prec'}]}]}}]},\n",
       "   {'TOCHeading': 'Hazard Classes and Categories',\n",
       "    'Description': 'The Hazard Classes and Categories are aligned with GHS (Globally Harmonized System of Classification and Labelling of Chemicals) hazard statement codes.  The percentage data in the parenthesis from ECHA indicates that the hazard classes and categories information are consolidated from multiple companies.  Also, see the detailed explanation from the above GHS classification section.',\n",
       "    'URL': 'https://pubchem.ncbi.nlm.nih.gov/ghs/',\n",
       "    'DisplayControls': {'ShowAtMost': 2},\n",
       "    'Information': [{'ReferenceNumber': 16,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flam. Liq. 2'},\n",
       "        {'String': 'Acute Tox. 4 *'},\n",
       "        {'String': 'Acute Tox. 4 *'},\n",
       "        {'String': 'Acute Tox. 4 *'},\n",
       "        {'String': 'Skin Corr. 1A'}]}},\n",
       "     {'ReferenceNumber': 17,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flam. Liq. 2 (99.98%)'},\n",
       "        {'String': 'Acute Tox. 4 (99.98%)'},\n",
       "        {'String': 'Acute Tox. 3 (45.82%)'},\n",
       "        {'String': 'Acute Tox. 4 (54.48%)'},\n",
       "        {'String': 'Skin Corr. 1A (100%)'},\n",
       "        {'String': 'Eye Dam. 1 (42.76%)'},\n",
       "        {'String': 'Acute Tox. 3 (44.84%)'},\n",
       "        {'String': 'Acute Tox. 4 (54.53%)'},\n",
       "        {'String': 'STOT SE 3 (48.98%)'}]}},\n",
       "     {'ReferenceNumber': 24,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flammable liquid - category 2'},\n",
       "        {'String': 'Acute toxicity - category 4'},\n",
       "        {'String': 'Acute toxicity - category 3'},\n",
       "        {'String': 'Acute toxicity - category 3'},\n",
       "        {'String': 'Specific target organ toxicity (single exposure) - category 3'},\n",
       "        {'String': 'Skin corrosion - category 1A'}]}},\n",
       "     {'ReferenceNumber': 41,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flammable liquids - Category 2'},\n",
       "        {'String': 'Acute toxicity (Oral) - Category 4'},\n",
       "        {'String': 'Acute toxicity (Dermal) - Category 3'},\n",
       "        {'String': 'Acute toxicity (Inhalation: Vapours) - Category 4'},\n",
       "        {'String': 'Skin corrosion/irritation - Category 1'},\n",
       "        {'String': 'Serious eye damage/eye irritation - Category 1'},\n",
       "        {'String': 'Specific target organ toxicity - Single exposure - Category 1 (central nervous system)_x000D_ \\nCategory 3 (respiratory tract irritation)'},\n",
       "        {'String': 'Specific target organ toxicity - Repeated exposure - Category 2 (respiratory organs)'},\n",
       "        {'String': 'Hazardous to the aquatic environment (Acute) - Category 2'},\n",
       "        {'String': 'Hazardous to the aquatic environment (Long-term) - Category 3'}]}},\n",
       "     {'ReferenceNumber': 42,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flammable liquids - Category 2'},\n",
       "        {'String': 'Acute toxicity (Oral) - Category 4'},\n",
       "        {'String': 'Acute toxicity (Dermal) - Category 3'},\n",
       "        {'String': 'Acute toxicity (Inhalation: Vapours) - Category 3'},\n",
       "        {'String': 'Skin corrosion/irritation - Category 1A-1C'},\n",
       "        {'String': 'Serious eye damage/eye irritation - Category 1'},\n",
       "        {'String': 'Specific target organ toxicity - Single exposure - Category 1 (central nervous system, respiratory system)'},\n",
       "        {'String': 'Specific target organ toxicity - Repeated exposure - Category 1 (central nervous system)'},\n",
       "        {'String': 'Hazardous to the aquatic environment (Acute) - Category 2'},\n",
       "        {'String': 'Hazardous to the aquatic environment (Long-term) - Category 2'}]}},\n",
       "     {'ReferenceNumber': 43,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flammable - 3rd degree'}]}}]},\n",
       "   {'TOCHeading': 'NFPA Hazard Classification',\n",
       "    'Description': 'The National Fire Protection Association (NFPA) Hazard Classification (also known as NFPA 704) provides a simple, readily recognized, easily understood system for identifying the specific hazards of a material and the severity of the hazard that would occur during an emergency response. The system addresses the health, flammability, instability, and special hazards presented from short-term, acute exposures that could occur as a result of a fire, spill, or similar emergency.',\n",
       "    'URL': 'https://www.nfpa.org/News-and-Research/Publications-and-media/Blogs-Landing-Page/NFPA-Today/Blog-Posts/2021/11/05/Hazardous-Materials-Identification',\n",
       "    'DisplayControls': {'CreateTable': {'FromInformationIn': 'ThisSection',\n",
       "      'NumberOfColumns': 2,\n",
       "      'ColumnContents': ['Name', 'Value']},\n",
       "     'ShowAtMost': 1},\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Name': 'NFPA 704 Diamond',\n",
       "      'Value': {'StringWithMarkup': [{'String': '  ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/image/nfpa.cgi?code=330',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': '3-3-0'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'NFPA Health Rating',\n",
       "      'Value': {'StringWithMarkup': [{'String': ' 3 - Materials that, under emergency conditions, can cause serious or permanent injury.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'NFPA Fire Rating',\n",
       "      'Value': {'StringWithMarkup': [{'String': ' 3 - Liquids and solids that can be ignited under almost all ambient temperature conditions. Materials produce hazardous atmospheres with air under almost all ambient temperatures or, though unaffected by ambient temperatures, are readily ignited under almost all conditions.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Name': 'NFPA Instability Rating',\n",
       "      'Value': {'StringWithMarkup': [{'String': ' 0 - Materials that in themselves are normally stable, even under fire conditions.'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'NFPA 704 Diamond',\n",
       "      'Value': {'StringWithMarkup': [{'String': '  ',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 1,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/image/nfpa.cgi?code=330',\n",
       "           'Type': 'Icon',\n",
       "           'Extra': '3-3-0'}]}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'NFPA Health Rating',\n",
       "      'Value': {'StringWithMarkup': [{'String': ' 3 - Materials that, under emergency conditions, can cause serious or permanent injury.'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'NFPA Fire Rating',\n",
       "      'Value': {'StringWithMarkup': [{'String': ' 3 - Liquids and solids that can be ignited under almost all ambient temperature conditions. Materials produce hazardous atmospheres with air under almost all ambient temperatures or, though unaffected by ambient temperatures, are readily ignited under almost all conditions.'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'NFPA Instability Rating',\n",
       "      'Value': {'StringWithMarkup': [{'String': ' 0 - Materials that in themselves are normally stable, even under fire conditions.'}]}}]},\n",
       "   {'TOCHeading': 'Health Hazards',\n",
       "    'Description': \"Description of the chemical's health hazards (e.g., toxicity, corrosivity, and flammability) that can have negative impacts on our short- or long-term health.\",\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': ['U.S. Coast Guard. 1999. Chemical Hazard Response Information System (CHRIS) - Hazardous Chemical Data. Commandant Instruction 16465.12C. Washington, D.C.: U.S. Government Printing Office.'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Vapors irritate nose, throat, and lungs, causing coughing, choking, and difficult breathing. Contact with eyes causes severe burns. Clothing wet with chemical causes skin burns. (USCG, 1999)'}]}}]},\n",
       "   {'TOCHeading': 'Fire Hazards',\n",
       "    'Description': 'Fire hazard means any situation, process, material or condition which may cause a fire or explosion or provide a ready fuel supply to increase the spread or intensity of the fire or explosion and which poses a threat to life or property.  This section provides information on fire hazards involving this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': [\"U.S. Department of Transportation, Transport Canada, and Secretariat of Communications and Transport of Mexico, with collaboration from Argentina's Centro de Información Química para Emergencias. 2016 Emergency Response Guidebook. https://www.phmsa.dot.gov/hazmat/outreach-training/erg (accessed April 26, 2016).\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Excerpt from ERG Guide 132 [Flammable Liquids - Corrosive]:  Flammable/combustible material. May be ignited by heat, sparks or flames. Vapors may form explosive mixtures with air. Vapors may travel to source of ignition and flash back. Most vapors are heavier than air. They will spread along ground and collect in low or confined areas (sewers, basements, tanks). Vapor explosion hazard indoors, outdoors or in sewers. Those substances designated with a (P) may polymerize explosively when heated or involved in a fire. Runoff to sewer may create fire or explosion hazard. Containers may explode when heated. Many liquids are lighter than water. (ERG, 2016)',\n",
       "         'Markup': [{'Start': 640,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Highly flammable. Gives off irritating or toxic fumes (or gases) in a fire. Vapour/air mixtures are explosive.'}]}}]},\n",
       "   {'TOCHeading': 'Hazards Summary',\n",
       "    'Description': 'This section provides an overview of the key hazards information of this compound.',\n",
       "    'Information': [{'ReferenceNumber': 9,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Acute (short-term) exposure of humans to triethylamine vapor causes eye irritation, corneal swelling, and halo vision. People have complained of seeing \"blue haze\" or having \"smoky vision.\" These effects have been reversible upon cessation of exposure. Acute exposure can irritate the skin and mucous membranes in humans. Chronic (long-term) exposure of workers to triethylamine vapor has been observed to cause reversible corneal edema. Chronic inhalation exposure has resulted in respiratory and hematological effects and eye lesions in rats and rabbits. No information is available on the reproductive, developmental, or carcinogenic effects of triethylamine in humans. EPA has not classified triethylamine with respect to potential carcinogenicity.',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 365,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 648,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 696,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 23,\n",
       "      'Reference': ['ACGIH - Documentation of the TLVs and BEIs, 7th Ed. Cincinnati: ACGIH Worldwide, 2020.',\n",
       "       'Quick CPC - Forsberg K, Mansdorf SZ. Quick Selection Guide to Chemical Protective Clothing, 5th Ed. Hoboken, NJ: Wiley-Interscience, 2007.'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'TLV Basis is visual impairment and upper respiratory tract irritation; Transient visual disturbances with blurring and halo vision are reported to occur at 3 to 4 ppm but not at 1 to 1.25 ppm. Mice that inhaled lethal concentrations had respiratory irritation, tremors, and convulsions. [ACGIH] Liquid causes first degree burns on short exposure; [CHRIS] Corrosive to skin; [Quick CPC] Short-term exposure at high concentrations may cause pulmonary edema. [ICSC] May cause permanent eye injury; Transient visual effects (blue haze or halo vision) occur at low concentrations; [CHEMINFO] Experimental animals exposed repeatedly to 100 ppm show evidence of liver, kidney, lung, and heart damage. [HSDB] A corrosive substance that can cause pulmonary edema; [ICSC]'}]}}]},\n",
       "   {'TOCHeading': 'Fire Potential',\n",
       "    'Description': 'This section describes fire potential of this chemical (e.g., whether it is combustible or flammable).',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"Lewis, R.J. Sr. (ed) Sax's Dangerous Properties of Industrial Materials. 11th Edition. Wiley-Interscience, Wiley & Sons, Inc. Hoboken, NJ. 2004., p. 3545\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'A very dangerous fire hazard when exposed to heat, flame, or oxidizers.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Mackison, F. W., R. S. Stricoff, and L. J. Partridge, Jr. (eds.). NIOSH/OSHA - Occupational Health Guidelines for Chemical Hazards. DHHS(NIOSH) Publication No. 81-123 (3 VOLS). Washington, DC: U.S. Government Printing Office, Jan. 1981., p. 2'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Contact with strong oxidizers may cause fires ... .'}]}}]},\n",
       "   {'TOCHeading': 'Skin, Eye, and Respiratory Irritations',\n",
       "    'Description': 'Skin, eye and respiratory irritations caused by exposure to this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['National Fire Protection Association;  Fire Protection Guide to Hazardous Materials. 14TH Edition, Quincy, MA 2010, p. 49-150'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Irritating to skin, eyes, and respiratory system.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Grant, W.M. Toxicology of the Eye. 3rd ed. Springfield, IL: Charles C. Thomas Publisher, 1986., p. 944'],\n",
       "      'Value': {'StringWithMarkup': [{'String': \"/Triethylamine/ is strongly alkaline, and when drop is applied to rabbit's eye, causes severe injury, graded 9 on scale of 1 to 10 after 24 hr /most severe injuries have been rated 10/. Tests of aqueaous solution on rabbit eyes at pH 10 and pH 11 indicate injuriousness /of triethylamine/ is related principally to degree of alkalinity.\",\n",
       "         'Markup': [{'Start': 1,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 274,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"Bingham, E.; Cohrssen, B.; Powell, C.H.; Patty's Toxicology Volumes 1-9 5th ed. John Wiley & Sons. New York, N.Y. (2001)., p. V4 715\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'A 70% solution applied on the skin of guinea pigs caused prompt skin burns leading to necrosis; when held in contact with guinea pig skin for 2 hr, there was severe skin irritation with extensive necrosis and deep scarring.'}]}}]},\n",
       "   {'TOCHeading': 'EPA Hazardous Waste Number',\n",
       "    'Description': 'Identifier for hazardous waste containing this chemical.',\n",
       "    'URL': 'https://www.epa.gov/hw/defining-hazardous-waste-listed-characteristic-and-mixed-radiological-wastes',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'U404; A toxic waste when a discarded commercial chemical product or manufacturing chemical intermediate or an off-specification commercial chemical product or manufacturing chemical intermediate.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'D001; A waste containing triethylamine may (or may not) be characterized a hazardous waste following testing for ignitability characteristics as prescribed by the Resource Conservation and Recovery Act (RCRA) regulations.',\n",
       "         'Markup': [{'Start': 25,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]}]},\n",
       " {'TOCHeading': 'Safety and Hazard Properties',\n",
       "  'Description': \"This section lists the chemical's safety and hazard characteristics, such as the explosive/flammable limits, critical temperature and pressure, exposure limits, etc.\",\n",
       "  'Section': [{'TOCHeading': 'Flammable Limits',\n",
       "    'Description': 'The flammable limits (or the flammability limits) are the minimum and maximum concentrations of fuel vapor or gas in a fuel vapor or gas/gaseous oxidant mixture (usually expressed in percent by volume) defining the concentration range (flammable or explosive range) over which propagation of flame will occur on contact with an ignition source.  Also called explosive (or explosivity) limits.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['National Fire Protection Association;  Fire Protection Guide to Hazardous Materials. 14TH Edition, Quincy, MA 2010, p. 325-110'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Lower flammable limit: 1.2% by volume; upper flammable limit: 8.0% by volume'}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'Name': 'Flammability',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Class IB Flammable Liquid: Fl.P. below 73 °F and BP at or above 100 °F.'}]}}]},\n",
       "   {'TOCHeading': 'Lower Explosive Limit (LEL)',\n",
       "    'Description': 'Lower explosive limit (LEL) means the minimum concentration of vapor in air below which propagation of a flame does not occur in the presence of an ignition source.',\n",
       "    'URL': 'https://www.osha.gov/laws-regs/regulations/standardnumber/1915/1915.11',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': ['U.S. Coast Guard. 1999. Chemical Hazard Response Information System (CHRIS) - Hazardous Chemical Data. Commandant Instruction 16465.12C. Washington, D.C.: U.S. Government Printing Office.'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '1.2 % (USCG, 1999)'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Value': {'StringWithMarkup': [{'String': '1.2%'}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': '1.2%'}]}}]},\n",
       "   {'TOCHeading': 'Upper Explosive Limit (UEL)',\n",
       "    'Description': 'Upper explosive limit (UEL) means the maximum concentration of flammable vapor in air above which propagation of flame does not occur on contact with a source of ignition.',\n",
       "    'URL': 'https://www.osha.gov/laws-regs/regulations/standardnumber/1915/1915.11',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': ['U.S. Coast Guard. 1999. Chemical Hazard Response Information System (CHRIS) - Hazardous Chemical Data. Commandant Instruction 16465.12C. Washington, D.C.: U.S. Government Printing Office.'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '8 % (USCG, 1999)'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Value': {'StringWithMarkup': [{'String': '8%'}]}}]},\n",
       "   {'TOCHeading': 'Critical Temperature & Pressure',\n",
       "    'Description': 'The critical temperature of a substance is the temperature at and above which vapor of the substance cannot be liquefied, no matter how much pressure is applied. The critical pressure of a substance is the pressure required to liquefy a gas at its critical temperature.',\n",
       "    'URL': 'https://chem.libretexts.org/Bookshelves/General_Chemistry/Book%3A_ChemPRIME_(Moore_et_al.)/10%3A_Solids_Liquids_and_Solutions/10.13%3A_Critical_Temperature_and_Pressure',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Haynes, W.M. (ed.). CRC Handbook of Chemistry and Physics. 95th Edition. CRC Press LLC, Boca Raton: FL 2014-2015, p. 6-74'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Critical temperature: 535.6 K; Critical pressure: 3.1 MPa'}]}}]},\n",
       "   {'TOCHeading': 'Physical Dangers',\n",
       "    'Description': 'The possibility of physical injury or sickness that could result in grave physical harm or death.  An example of physical dangers is fire/explosion due to raw materials.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'The vapour is heavier than air and may travel along the ground; distant ignition possible.'}]}}]},\n",
       "   {'TOCHeading': 'Explosive Limits and Potential',\n",
       "    'Description': 'This section shows lower and upper explosive limits of this chemical and other information on its explosive potential.  Explosive limits specify the concentration range of a material in air which will burn or explode in the presence of an ignition source. There are two types of explosive limits: lower explosive limit (LEL) and upper explosive limit (UEL). The explosive limits are usually given as the percent by volume of the material in the air (e.g., 5%).',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"Sax, N.I. and R.J. Lewis, Sr. (eds.). Hawley's Condensed Chemical Dictionary. 11th ed. New York: Van Nostrand Reinhold Co., 1987., p. 1180\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'IN AIR: 1.2 TO 8.0%.'}]}},\n",
       "     {'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Explosive limits , vol% in air: 1.2-8'}]}}]},\n",
       "   {'TOCHeading': 'OSHA Standards',\n",
       "    'Description': 'Occupational Safety and Health Administration (OSHA) standards are rules that describe the methods that employers must use to protect their employees from hazards. These standards limit the amount of hazardous chemicals workers can be exposed to, require the use of certain safe practices and equipment, and require employers to monitor hazards and keep records of workplace injuries and illnesses.',\n",
       "    'URL': 'https://www.osha.gov/laws-regs',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"29 CFR 1910.1000 (USDOL); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Permissible Exposure Limit: Table Z-1 8-hr Time Weighted Avg: 25 ppm (100 mg/cu m).'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['NIOSH. NIOSH Pocket Guide to Chemical Hazards. DHHS (NIOSH) Publication No. 97-140. Washington, D.C. U.S. Government Printing Office, 1997., p. 373'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Vacated 1989 OSHA PEL TWA 10 ppm (40 mg/cu m); STEL 15 ppm (60 mg/cu m) is still enforced in some states.'}]}}]},\n",
       "   {'TOCHeading': 'NIOSH Recommendations',\n",
       "    'Description': 'The National Institute for Occupational Safety and Health (NIOSH) recommendations for chemical safety concerning this compound.',\n",
       "    'URL': 'https://www.cdc.gov/niosh/index.htm',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['NIOSH. NIOSH Pocket Guide to Chemical Hazards. Department of Health & Human Services, Centers for Disease Control & Prevention. National Institute for Occupational Safety & Health. DHHS (NIOSH) Publication No. 2010-168 (2010). Available from:  https://www.cdc.gov/niosh/npg'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'NIOSH questioned whether the PEL proposed by OSHA for triethylamine was adequate to protect workers from recognized health hazards: TWA 10 ppm; STEL 15 ppm.',\n",
       "         'Markup': [{'Start': 54,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]}]},\n",
       " {'TOCHeading': 'First Aid Measures',\n",
       "  'Description': 'This section describes the initial care that should be given to an individual who has been exposed to the chemical.  The information in this section includes the description of the symptoms or effects of exposure to the chemical, necessary first-aid instructions by relevant routes of exposure (inhalation, skin and eye contact, and ingestion), and recommendations for immediate medical care and special treatment needed, when necessary.',\n",
       "  'URL': 'https://www.osha.gov/sites/default/files/publications/OSHA3514.pdf',\n",
       "  'Section': [{'TOCHeading': 'First Aid',\n",
       "    'Description': 'First aid measures for exposure to this chemical through various routes (for example, ingestion, inhalation, skin contact, and eye contact).',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': ['National Toxicology Program, Institute of Environmental Health Sciences, National Institutes of Health (NTP). 1992. National Toxicology Program Chemical Repository Database. Research Triangle Park, North Carolina.'],\n",
       "      'Value': {'StringWithMarkup': [{'String': \"EYES: First check the victim for contact lenses and remove if present. Flush victim's eyes with water or normal saline solution for 20 to 30 minutes while simultaneously calling a hospital or poison control center. Do not put any ointments, oils, or medication in the victim's eyes without specific instructions from a physician. IMMEDIATELY transport the victim after flushing eyes to a hospital even if no symptoms (such as redness or irritation) develop.  SKIN: IMMEDIATELY flood affected skin with water while removing and isolating all contaminated clothing. Gently wash all affected skin areas thoroughly with soap and water. IMMEDIATELY call a hospital or poison control center even if no symptoms (such as redness or irritation) develop. IMMEDIATELY transport the victim to a hospital for treatment after washing the affected areas.  INHALATION: IMMEDIATELY leave the contaminated area; take deep breaths of fresh air. If symptoms (such as wheezing, coughing, shortness of breath, or burning in the mouth, throat, or chest) develop, call a physician and be prepared to transport the victim to a hospital. Provide proper respiratory protection to rescuers entering an unknown atmosphere. Whenever possible, Self-Contained Breathing Apparatus (SCBA) should be used; if not available, use a level of protection greater than or equal to that advised under Protective Clothing.  INGESTION: DO NOT INDUCE VOMITING. Corrosive chemicals will destroy the membranes of the mouth, throat, and esophagus and, in addition, have a high risk of being aspirated into the victim's lungs during vomiting which increases the medical problems. If the victim is conscious and not convulsing, give 1 or 2 glasses of water to dilute the chemical and IMMEDIATELY call a hospital or poison control center. IMMEDIATELY transport the victim to a hospital. If the victim is convulsing or unconscious, do not give anything by mouth, ensure that the victim's airway is open and lay the victim on his/her side with the head lower than the body. DO NOT INDUCE VOMITING. Transport the victim IMMEDIATELY to a hospital. (NTP, 1992)\",\n",
       "         'Markup': [{'Start': 96,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 105,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/normal%20saline',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-5234'},\n",
       "          {'Start': 502,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 625,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 1702,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': '(See procedures)',\n",
       "         'Markup': [{'Start': 1,\n",
       "           'Length': 14,\n",
       "           'URL': 'https: //www.cdc.gov/niosh/npg/firstaid.html'}]},\n",
       "        {'String': 'Eye: Irrigate immediately  - If this chemical contacts the eyes, immediately wash (irrigate) the eyes with large amounts of water, occasionally lifting the lower and upper lids. Get medical attention immediately.',\n",
       "         'Markup': [{'Start': 124,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]},\n",
       "        {'String': 'Skin: Soap wash immediately  - If this chemical contacts the skin, immediately wash the contaminated skin with soap and water. If this chemical penetrates the clothing, immediately remove the clothing, wash the skin with soap and water, and get medical attention promptly.',\n",
       "         'Markup': [{'Start': 120,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 230,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]},\n",
       "        {'String': 'Breathing: Respiratory support'},\n",
       "        {'String': 'Swallow: Medical attention immediately  - If this chemical has been swallowed, get medical attention immediately.'}]}}]},\n",
       "   {'TOCHeading': 'Inhalation First Aid',\n",
       "    'Description': 'First aid measures for exposure to this chemical through inhalation.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Fresh air, rest. Half-upright position. Artificial respiration may be needed. Refer for medical attention.'}]}}]},\n",
       "   {'TOCHeading': 'Skin First Aid',\n",
       "    'Description': 'First aid measures for exposure to this chemical through skin contact.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Remove contaminated clothes. Rinse skin with plenty of water or shower. Refer for medical attention .',\n",
       "         'Markup': [{'Start': 55,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]},\n",
       "   {'TOCHeading': 'Eye First Aid',\n",
       "    'Description': 'First aid measures for exposure to this chemical through eye contact.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'First rinse with plenty of water for several minutes (remove contact lenses if easily possible), then refer for medical attention.',\n",
       "         'Markup': [{'Start': 27,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]},\n",
       "   {'TOCHeading': 'Ingestion First Aid',\n",
       "    'Description': 'First aid measures for exposure to this chemical through ingestion.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Rinse mouth. Do NOT induce vomiting. Give one or two glasses of water to drink. Refer for medical attention .',\n",
       "         'Markup': [{'Start': 64,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]}]},\n",
       " {'TOCHeading': 'Fire Fighting',\n",
       "  'Description': 'This section provides fire fighting information, including fire fighting procedures and hazards.',\n",
       "  'Information': [{'ReferenceNumber': 1,\n",
       "    'Reference': [\"U.S. Department of Transportation, Transport Canada, and Secretariat of Communications and Transport of Mexico, with collaboration from Argentina's Centro de Información Química para Emergencias. 2016 Emergency Response Guidebook. https://www.phmsa.dot.gov/hazmat/outreach-training/erg (accessed April 26, 2016).\"],\n",
       "    'Value': {'StringWithMarkup': [{'String': 'Excerpt from ERG Guide 132 [Flammable Liquids - Corrosive]:  Some of these materials may react violently with water.  SMALL FIRE: Dry chemical, CO2, water spray or alcohol-resistant foam.  LARGE FIRE: Water spray, fog or alcohol-resistant foam. Move containers from fire area if you can do it without risk. Dike fire-control water for later disposal; do not scatter the material. Do not get water inside containers.  FIRE INVOLVING TANKS OR CAR/TRAILER LOADS: Fight fire from maximum distance or use unmanned hose holders or monitor nozzles. Cool containers with flooding quantities of water until well after fire is out. Withdraw immediately in case of rising sound from venting safety devices or discoloration of tank. ALWAYS stay away from tanks engulfed in fire. For massive fire, use unmanned hose holders or monitor nozzles; if this is impossible, withdraw from area and let fire burn. (ERG, 2016)',\n",
       "       'Markup': [{'Start': 110,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'},\n",
       "        {'Start': 149,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'},\n",
       "        {'Start': 201,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'},\n",
       "        {'Start': 325,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'},\n",
       "        {'Start': 391,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'},\n",
       "        {'Start': 586,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'}]}]}},\n",
       "   {'ReferenceNumber': 28,\n",
       "    'Value': {'StringWithMarkup': [{'String': 'Use alcohol-resistant foam, powder, carbon dioxide. In case of fire: keep drums, etc., cool by spraying with water.',\n",
       "       'Markup': [{'Start': 36,\n",
       "         'Length': 14,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/carbon%20dioxide',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-280'},\n",
       "        {'Start': 109,\n",
       "         'Length': 5,\n",
       "         'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "         'Type': 'PubChem Internal Link',\n",
       "         'Extra': 'CID-962'}]}]}}],\n",
       "  'Section': [{'TOCHeading': 'Fire Fighting Procedures',\n",
       "    'Description': 'This section provides information on the actions to be taken in the event of a fire emergency involving this chemical, to prevent the spread of and extinguish fires.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Suitable extinguishing media: Use water spray, alcohol-resistant foam, dry chemical, or carbon dioxide.',\n",
       "         'Markup': [{'Start': 34,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 88,\n",
       "           'Length': 14,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/carbon%20dioxide',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-280'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Advice for firefighters: Wear self-contained breathing apparatus for firefighting if necessary.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Use water spray to cool unopened containers.',\n",
       "         'Markup': [{'Start': 4,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['National Fire Protection Association;  Fire Protection Guide to Hazardous Materials. 14TH Edition, Quincy, MA 2010, p. 49-150'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Use water spray to keep fire-exposed containers cool. Use water spray, dry chemical, \"alcohol resistant\" foam, or carbon dioxide.',\n",
       "         'Markup': [{'Start': 4,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 58,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 114,\n",
       "           'Length': 14,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/carbon%20dioxide',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-280'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'For more Fire Fighting Procedures (Complete) data for TRIETHYLAMINE (6 total), please visit the HSDB record page.',\n",
       "         'Markup': [{'Start': 96,\n",
       "           'Length': 16,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/source/hsdb/896#section=Fire-Fighting-Procedures-(Complete)'},\n",
       "          {'Start': 54,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TRIETHYLAMINE',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]},\n",
       "   {'TOCHeading': 'Firefighting Hazards',\n",
       "    'Description': 'Hazards associated with firefighting operations (such as smoke, oxygen deficiency, elevated temperatures, and poisonous atmospheres).',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['National Fire Protection Association;  Fire Protection Guide to Hazardous Materials. 14TH Edition, Quincy, MA 2010, p. 49-150'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Vapors are heavier than air and may travel to a source of ignition and flash back.'}]}}]}]},\n",
       " {'TOCHeading': 'Accidental Release Measures',\n",
       "  'Description': 'This section provides recommendations on the appropriate response to spills, leaks, or releases, including containment and cleanup practices to prevent or minimize exposure to people, properties, or the environment. It may also include recommendations distinguishing between responses for large and small spills where the spill volume has a significant impact on the hazard.',\n",
       "  'URL': 'https://www.osha.gov/sites/default/files/publications/OSHA3514.pdf',\n",
       "  'Section': [{'TOCHeading': 'Isolation and Evacuation',\n",
       "    'Description': 'Isolation and evacuation measures to take when a large amount of this chemical is accidentally released in an emergency.',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': [\"U.S. Department of Transportation, Transport Canada, and Secretariat of Communications and Transport of Mexico, with collaboration from Argentina's Centro de Información Química para Emergencias. 2016 Emergency Response Guidebook. https://www.phmsa.dot.gov/hazmat/outreach-training/erg (accessed April 26, 2016).\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Excerpt from ERG Guide 132 [Flammable Liquids - Corrosive]:  As an immediate precautionary measure, isolate spill or leak area for at least 50 meters (150 feet) in all directions.  SPILL: Increase, in the downwind direction, as necessary, the isolation distance shown above.  FIRE: If tank, rail car or tank truck is involved in a fire, ISOLATE for 800 meters (1/2 mile) in all directions; also, consider initial evacuation for 800 meters (1/2 mile) in all directions. (ERG, 2016)'}]}}]},\n",
       "   {'TOCHeading': 'Spillage Disposal',\n",
       "    'Description': 'Methods for containment and safety measures to protect workers dealing with a spillage of this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Evacuate danger area! Consult an expert! Personal protection: complete protective clothing including self-contained breathing apparatus. Ventilation. Remove all ignition sources. Do NOT let this chemical enter the environment. Collect leaking and spilled liquid in sealable containers as far as possible. Absorb remaining liquid in sand or inert absorbent. Then store and dispose of according to local regulations.'}]}}]},\n",
       "   {'TOCHeading': 'Cleanup Methods',\n",
       "    'Description': 'Procedures for cleanup of chemical spill or hazardous waste',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'ACCIDENTAL RELEASE MEASURES: Personal precautions, protective equipment and emergency procedures: Wear respiratory protection. Avoid breathing vapors, mist or gas. Ensure adequate ventilation. Remove all sources of ignition. Evacuate personnel to safe areas. Beware of vapors accumulating to form explosive concentrations. Vapors can accumulate in low areas. Environmental precautions: Prevent further leakage or spillage if safe to do so. Do not let product enter drains. Discharge into the environment must be avoided. Methods and materials for containment and cleaning up: Contain spillage, and then collect with an electrically protected vacuum cleaner or by wet-brushing and place in container for disposal according to local regulations.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Mackison, F. W., R. S. Stricoff, and L. J. Partridge, Jr. (eds.). NIOSH/OSHA - Occupational Health Guidelines for Chemical Hazards. DHHS(NIOSH) Publication No. 81-123 (3 VOLS). Washington, DC: U.S. Government Printing Office, Jan. 1981., p. 4'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '1. Remove all ignition sources. 2. Ventilate area of spill or leak. For small quantities, absorb on paper towels. Evaporate in a safe place (such as a fume hood). Allow sufficient time for evaporating vapors to completely clear the hood ductwork. Burn the paper in a suitable location away from combustible materials. Large quantities can be collected and atomized in a suitable combustion chamber equipped with an appropriate effluent gas cleaning device.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Association of American Railroads; Bureau of Explosives. Emergency Handling of Hazardous Materials in Surface Transportation. Association of American Railroads, Pueblo, CO. 2005, p. 909'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Environmental considerations-land spill: Dig a pit, pond, lagoon, holding area to contain liquid or solid material. /SRP: If time permits, pits, ponds, lagoons, soak holes, or holding areas should be sealed with an impermeable flexible membrane liner./ Dike surface flow using soil, sand bags, foamed polyurethane, or foamed concrete. Absorb bulk liquid with fly ash, cement powder, or commercial sorbents. Apply \"universal\" gelling agent to immobilize spill. Neutralize with sodium bisulfate (NaHSO4).',\n",
       "         'Markup': [{'Start': 301,\n",
       "           'Length': 12,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/polyurethane',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-12254'},\n",
       "          {'Start': 476,\n",
       "           'Length': 16,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/sodium%20bisulfate',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-516919'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Association of American Railroads; Bureau of Explosives. Emergency Handling of Hazardous Materials in Surface Transportation. Association of American Railroads, Pueblo, CO. 2005, p. 909'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Environmental considerations-water spill: Add sodium bisulfate (NaHSO4). If dissolved, in region of 10 ppm or greater concentration, apply activated carbon at ten times the spilled amount. Use mechanical dredges or lifts to remove immobilized masses of pollutants and precipitates.',\n",
       "         'Markup': [{'Start': 29,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 46,\n",
       "           'Length': 16,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/sodium%20bisulfate',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-516919'},\n",
       "          {'Start': 149,\n",
       "           'Length': 6,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/element/Carbon',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'Element-Carbon'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Association of American Railroads; Bureau of Explosives. Emergency Handling of Hazardous Materials in Surface Transportation. Association of American Railroads, Pueblo, CO. 2005, p. 909'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Environmental considerations-air spill: Apply water spray or mist to knock down vapors. Vapor knockdown water is corrosive or toxic and should be diked for containment.',\n",
       "         'Markup': [{'Start': 46,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 104,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]},\n",
       "   {'TOCHeading': 'Disposal Methods',\n",
       "    'Description': 'Disposal methods or procedures for this chemical or hazardous waste containing it.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 240-280, 300-306, 702-799 (USEPA); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of April 2, 2015: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Generators of waste (equal to or greater than 100 kg/mo) containing this contaminant, EPA hazardous waste number U404 and D001, must conform with USEPA regulations in storage, transportation, treatment and disposal of waste.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'SRP: Wastewater from contaminant suppression, cleaning of protective clothing/equipment, or contaminated sites should be contained and evaluated for subject chemical or decomposition product concentrations. Concentrations shall be lower than applicable environmental discharge or disposal criteria. Alternatively, pretreatment and/or discharge to a permitted wastewater treatment facility is acceptable only after review by the governing authority and  assurance that \"pass through\" violations will not occur. Due consideration shall be given to  remediation worker exposure (inhalation, dermal and ingestion) as well as fate during treatment, transfer and disposal. If it is not practicable to manage the chemical in this fashion, it must be evaluated in accordance with EPA 40 CFR Part 261, specifically Subpart B, in order to determine the appropriate local, state and federal requirements for disposal.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Product: Burn in a chemical incinerator equipped with an afterburner and scrubber but exert extra care in igniting as this material is highly flammable. Offer surplus and non-recyclable solutions to a licensed disposal company. Contact a licensed professional waste disposal service to dispose of this material; Contaminated packaging: Dispose of as unused product.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Suetaka T, Munemori M; Nippon Kagaku Kaishi 4: 650-5 (1984)'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Deodorization by catalytic combustion of triethylamine was studied.',\n",
       "         'Markup': [{'Start': 41,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Mackison, F. W., R. S. Stricoff, and L. J. Partridge, Jr. (eds.). NIOSH/OSHA - Occupational Health Guidelines for Chemical Hazards. DHHS(NIOSH) Publication No. 81-123 (3 VOLS). Washington, DC: U.S. Government Printing Office, Jan. 1981., p. 3'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '/Absorb small spills with paper and/ burn the paper in a suitable location away from combustible materials. Large quantities can be reclaimed or collected & atomized in suitable combustion chamber equipped with appropriate effluent gas cleaning device.'}]}}]},\n",
       "   {'TOCHeading': 'Preventive Measures',\n",
       "    'Description': 'Preventive measures to take to avoid suffering negative health effects from this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'ACCIDENTAL RELEASE MEASURES: Personal precautions, protective equipment and emergency procedures: Wear respiratory protection. Avoid breathing vapors, mist or gas. Ensure adequate ventilation. Remove all sources of ignition. Evacuate personnel to safe areas. Beware of vapors accumulating to form explosive concentrations. Vapors can accumulate in low areas. Environmental precautions: Prevent further leakage or spillage if safe to do so. Do not let product enter drains. Discharge into the environment must be avoided.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Precautions for safe handling: Avoid contact with skin and eyes. Avoid inhalation of vapor or mist. Use explosion-proof equipment. Keep away from sources of ignition - No smoking. Take measures to prevent the build up of electrostatic charge.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Appropriate engineering controls: Avoid contact with skin, eyes and clothing. Wash hands before breaks and immediately after handling the product.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': \"Gloves must be inspected prior to use. Use proper glove removal technique (without touching glove's outer surface) to avoid skin contact with this product. Dispose of contaminated gloves after use in accordance with applicable laws and good laboratory practices. Wash and dry hands.\"}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'For more Preventive Measures (Complete) data for TRIETHYLAMINE (11 total), please visit the HSDB record page.',\n",
       "         'Markup': [{'Start': 92,\n",
       "           'Length': 16,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/source/hsdb/896#section=Preventive-Measures-(Complete)'},\n",
       "          {'Start': 49,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TRIETHYLAMINE',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]}]},\n",
       " {'TOCHeading': 'Handling and Storage',\n",
       "  'Description': 'This section provides guidance on the safe handling practices and storage conditions for this chemical.  The information in this section includes precautions for safe handling, such as recommendations for handling incompatible chemicals, minimizing the release of the chemical into the environment, and providing advice on general hygiene practices (e.g., eating, drinking, and smoking in work areas is prohibited).  In addition, this section provides recommendations on the conditions for safe storage (including any incompatibilities) as well as advice on specific storage requirements (e.g., ventilation requirements).  ',\n",
       "  'URL': 'https://www.osha.gov/sites/default/files/publications/OSHA3514.pdf',\n",
       "  'Section': [{'TOCHeading': 'Nonfire Spill Response',\n",
       "    'Description': 'Emergency response measures to take in the event of a chemical spill (without a fire).',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': [\"U.S. Department of Transportation, Transport Canada, and Secretariat of Communications and Transport of Mexico, with collaboration from Argentina's Centro de Información Química para Emergencias. 2016 Emergency Response Guidebook. https://www.phmsa.dot.gov/hazmat/outreach-training/erg (accessed April 26, 2016).\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Excerpt from ERG Guide 132 [Flammable Liquids - Corrosive]:  Fully encapsulating, vapor-protective clothing should be worn for spills and leaks with no fire. ELIMINATE all ignition sources (no smoking, flares, sparks or flames in immediate area). All equipment used when handling the product must be grounded. Do not touch or walk through spilled material. Stop leak if you can do it without risk. Prevent entry into waterways, sewers, basements or confined areas. A vapor-suppressing foam may be used to reduce vapors. Absorb with earth, sand or other non-combustible material and transfer to containers (except for Hydrazine). Use clean, non-sparking tools to collect absorbed material.  LARGE SPILL: Dike far ahead of liquid spill for later disposal. Water spray may reduce vapor, but may not prevent ignition in closed spaces. (ERG, 2016)',\n",
       "         'Markup': [{'Start': 617,\n",
       "           'Length': 9,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Hydrazine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-9321'},\n",
       "          {'Start': 754,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]},\n",
       "   {'TOCHeading': 'Safe Storage',\n",
       "    'Description': 'Measures to take for safe storage of this chemical.',\n",
       "    'URL': 'https://www.ncbi.nlm.nih.gov/books/NBK379129/',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Fireproof. Separated from incompatible materials and food and feedstuffs. See Chemical Dangers.'}]}}]},\n",
       "   {'TOCHeading': 'Storage Conditions',\n",
       "    'Description': 'Conditions for safe storage of this compound, including any incompatible chemicals and specific storage requirements (e.g., ventilation requirements).',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Keep container tightly closed in a dry and well-ventilated place. Containers which are opened must be carefully resealed and kept upright to prevent leakage. Storage class (TRGS 510): Flammable liquids.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['National Fire Protection Association;  Fire Protection Guide to Hazardous Materials. 14TH Edition, Quincy, MA 2010, p. 49-150'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Avoid oxidizing materials, acids, and sources of halogens. Store in cool, dry, well-ventilated location.'}]}}]}]},\n",
       " {'TOCHeading': 'Exposure Control and Personal Protection',\n",
       "  'Description': 'This section provides information on the exposure limits, engineering controls, and personal protective measures that can be used to minimize worker exposure.  The information in this section includes OSHA Permissible Exposure Limits (PELs), American Conference of Governmental Industrial Hygienists (ACGIH) Threshold Limit Values (TLVs), and any other exposure limit used or recommended by the chemical manufacturer, importer, or employer preparing the safety data sheet, where available. In addition, this section contains information on appropriate engineering controls (e.g., use local exhaust ventilation, or use only in an enclosed system) as well as recommendations for personal protective measures to prevent illness or injury from exposure to chemicals, such as personal protective equipment (PPE) (e.g., appropriate types of eye, face, skin or respiratory protection needed based on hazards and potential exposure).',\n",
       "  'URL': 'https://www.osha.gov/sites/default/files/publications/OSHA3514.pdf',\n",
       "  'Information': [{'ReferenceNumber': 23,\n",
       "    'Name': 'RD50 (Exposure concentration producing a 50% respiratory rate decrease)',\n",
       "    'Value': {'StringWithMarkup': [{'String': '184.0 [mmHg]'}]}},\n",
       "   {'ReferenceNumber': 23,\n",
       "    'Name': 'Maximum Allowable Concentration (MAK)',\n",
       "    'Value': {'StringWithMarkup': [{'String': '1.0 [ppm]'}]}}],\n",
       "  'Section': [{'TOCHeading': 'Recommended Exposure Limit (REL)',\n",
       "    'Description': 'The recommended exposure limit (REL) is the maximum amount or concentration of a chemical that a worker may be exposed to.  The RELs are guidelines established and recommended by the NIOSH (National Institute for Occupational Safety and Health).  The RELs can be given in three ways. [1] Time-weighted average (REL-TWA): average exposure based on up to10h/day, 40h/week work schedule. [2] Short-term exposure limit (REL-STEL): a 15-minute TWA exposure that should not be exceeded at any time during a workday. [3] Ceiling limit (REL-C): absolute exposure limit that should not be exceeded at any time.',\n",
       "    'URL': 'https://www.cdc.gov/niosh/npg/pgintrod.html#exposure',\n",
       "    'Information': [{'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'See Appendix D',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 14,\n",
       "           'URL': 'https://www.cdc.gov/niosh/npg/nengapdxd.html'}]}]}}]},\n",
       "   {'TOCHeading': 'Permissible Exposure Limit (PEL)',\n",
       "    'Description': 'The permissible exposure limit (PEL) is the maximum amount or concentration of a chemical that a worker may be exposed to under OSHA regulations.  The PEL can be given in three ways. [1] Time-weighted average (PEL-TWA): average exposure based on an 8h/day, 40h/week work schedule. [2] Short-term exposure limit (PEL-STEL): a 15-minute TWA exposure that should not be exceeded at any time during a workday. [3] Ceiling limit (PEL-C): absolute exposure limit that should not be exceeded at any time.',\n",
       "    'URL': 'https://www.osha.gov/annotated-pels/',\n",
       "    'Information': [{'ReferenceNumber': 23,\n",
       "      'Value': {'StringWithMarkup': [{'String': '25.0 [ppm]'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'PEL-TWA (8-Hour Time Weighted Average)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '25 ppm (100 mg/m³)'}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'TWA 25 ppm (100 mg/m3) See Appendix G',\n",
       "         'Markup': [{'Start': 20, 'Length': 1, 'Type': 'Superscript'},\n",
       "          {'Start': 23,\n",
       "           'Length': 14,\n",
       "           'URL': 'https://www.cdc.gov/niosh/npg/nengapdxg.html'}]}]}}]},\n",
       "   {'TOCHeading': 'Immediately Dangerous to Life or Health (IDLH)',\n",
       "    'Description': 'The Immediately Dangerous to Life or Health air concentration values (IDLH values) characterize high-risk exposure concentrations and conditions and are used as a component of respirator selection criteria.  IDLH values are established (1) to ensure that the worker can escape from a given contaminated environment in the event of failure of the respiratory protection equipment and (2) to indicate a maximum level above which only a highly reliable breathing apparatus, providing maximum worker protection, is permitted.',\n",
       "    'URL': 'https://www.cdc.gov/niosh/idlh/default.html',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': ['National Institute of Occupational Safety and Health. NIOSH Pocket Guide to Chemical Hazards (full website version). https://www.cdc.gov/niosh/npg (accessed August 2016).'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '200 ppm (NIOSH, 2016)'}]}},\n",
       "     {'ReferenceNumber': 23,\n",
       "      'Value': {'StringWithMarkup': [{'String': '200.0 [ppm]'},\n",
       "        {'String': 'Excerpts from Documentation for IDLHs: Basis for original (SCP) IDLH: The chosen IDLH is based on the UCC [1970] report that a 4\\xadhour exposure to 1,000 ppm killed 1 of 6 rats. . . . Human data: None relevant for use in determining the revised IDLH.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['NIOSH. NIOSH Pocket Guide to Chemical Hazards. Department of Health & Human Services, Centers for Disease Control & Prevention. National Institute for Occupational Safety & Health. DHHS (NIOSH) Publication No. 2010-168 (2010). Available from:  https://www.cdc.gov/niosh/npg'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '200 ppm'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Value': {'StringWithMarkup': [{'String': '200 ppm'}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': '200 ppm'},\n",
       "        {'String': 'See: 121448',\n",
       "         'Markup': [{'Start': 5,\n",
       "           'Length': 6,\n",
       "           'URL': 'https://www.cdc.gov/niosh/idlh/121448.html'}]}]}}]},\n",
       "   {'TOCHeading': 'Threshold Limit Values (TLV)',\n",
       "    'Description': 'The threshold limit value (TLV) of a chemical is an airborne concentration at which a worker can be exposed day after day for a working lifetime without adverse effect.  There are three types of TLVs for chemicals. [1] Threshold limit value - time-weighted average (TLV-TWA): average exposure on the basis of a 8h/day, 40h/week work schedule. [2] Threshold limit value - short-term exposure limit (TLV-STEL): a 15-minute TWA exposure that should not be exceeded at any time during a workday, even if the 8-hour TWA is within the TLV-TWA. [3] Threshold limit value - ceiling limit (TLV-C): absolute exposure limit that should not be exceeded at any time. TLVs are developed by the American Conference of Governmental Industrial Hygienist.  While TLVs are widely accepted occupational exposure limits, they are not standards enforced by the U.S. Government.',\n",
       "    'URL': 'https://www.acgih.org/science/tlv-bei-guidelines/tlv-chemical-substances-introduction/',\n",
       "    'Information': [{'ReferenceNumber': 23,\n",
       "      'Value': {'StringWithMarkup': [{'String': '0.5 [ppm]'}]}},\n",
       "     {'ReferenceNumber': 23,\n",
       "      'Name': 'TLV-STEL',\n",
       "      'Value': {'StringWithMarkup': [{'String': '1.0 [ppm]'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['American Conference of Governmental Industrial Hygienists TLVs and BEIs. Threshold Limit Values for Chemical Substances and Physical Agents and Biological Exposure Indices. Cincinnati, OH 2016, p. 59'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '8 hr Time Weighted Avg (TWA): 0.5 ppm; 15 min Short Term Exposure Limit (STEL): 1 ppm, skin'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['American Conference of Governmental Industrial Hygienists TLVs and BEIs. Threshold Limit Values for Chemical Substances and Physical Agents and Biological Exposure Indices. Cincinnati, OH 2016, p. 59'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'A4: Not classifiable as a human carcinogen.'}]}},\n",
       "     {'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': '0.5 ppm as TWA; 1 ppm as STEL; (skin); A4 (not classifiable as a human carcinogen).'}]}},\n",
       "     {'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': '4.2 mg/m3, 1 ppm; peak limitation category: I(2); pregnancy risk group: D.'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'TLV-TWA (Time Weighted Average)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '0.5 ppm [2014]'}]}},\n",
       "     {'ReferenceNumber': 46,\n",
       "      'Name': 'TLV-STEL (Short Term Exposure Limit)',\n",
       "      'Value': {'StringWithMarkup': [{'String': '1 ppm [2014]'}]}}]},\n",
       "   {'TOCHeading': 'Other Standards Regulations and Guidelines',\n",
       "    'Description': 'Safety and hazard standards, regulations, and guidelines for this this compound that is not shown in other sections.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['International Labour Office. Encyclopedia of Occupational Health and Safety. Vols. I&II. Geneva, Switzerland: International Labour Office, 1983., p. 140'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Max allowable concn (USSR) 1 mg/cu m'}]}}]},\n",
       "   {'TOCHeading': 'Inhalation Risk',\n",
       "    'Description': 'Risk of exposure to this chemical through inhalation.  Note that the terms \"risk\" and \"hazard\" have different meanings.  A hazard is something that has the potential to cause harm, while risk is the likelihood of harm taking place, based on exposure to that hazard.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'A harmful contamination of the air can be reached very quickly on evaporation of this substance at 20 °C.'}]}}]},\n",
       "   {'TOCHeading': 'Effects of Short Term Exposure',\n",
       "    'Description': 'This section provides health effects of short-term exposure to this compound.  The short-term exposure (also called acute exposure) is a short contact with a chemical. It may last a few seconds or a few hours. For example, it might take a few minutes to clean windows with ammonia, use nail polish remover or spray a can of paint. The fumes someone might inhale during these activities are examples of acute exposures.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'The substance is corrosive to the eyes, skin and respiratory tract. Corrosive on ingestion. Inhalation may cause lung oedema. The effects may be delayed. Medical observation is indicated. The substance may cause effects on the central nervous system.'}]}}]},\n",
       "   {'TOCHeading': 'Personal Protective Equipment (PPE)',\n",
       "    'Description': 'Personal protective equipment (PPE) to use when handling this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Reference': ['National Institute of Occupational Safety and Health. NIOSH Pocket Guide to Chemical Hazards (full website version). https://www.cdc.gov/niosh/npg (accessed August 2016).'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Skin: Wear appropriate personal protective clothing to prevent skin contact.  Eyes: Wear appropriate eye protection to prevent eye contact.  Wash skin: The worker should immediately wash the skin when it becomes contaminated.  Remove: Work clothing that becomes wet should be immediately removed due to its flammability hazard(i.e. for liquids with flash point   Change: No recommendation is made specifying the need for the worker to change clothing after the work shift.  Provide: Eyewash fountains should be provided (when concentration is >1%) in areas where there is any possibility that workers could be exposed to the substance; this is irrespective of the recommendation involving the wearing of eye protection. Facilities for quickly drenching the body should be provided (when concentration is >1%) within the immediate work area for emergency use where there is a possibility of exposure. [Note: It is intended that these facilities provide a sufficient quantity or flow of water to quickly remove the substance from any body areas likely to be exposed. The actual determination of what constitutes an adequate quick drench facility depends on the specific circumstances. In certain instances, a deluge shower should be readily available, whereas in others, the availability of water from a sink or hose could be considered adequate.] (NIOSH, 2016)',\n",
       "         'Markup': [{'Start': 985,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 1289,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Eye/face protection: Tightly fitting safety goggles. Faceshield (8-inch minimum). Use equipment for eye protection tested and approved under appropriate government standards such as NIOSH (US) or EN 166(EU).'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Skin protection: Handle with gloves.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Body Protection: Complete suit protecting against chemicals. Flame retardant antistatic protective clothing. The type of protective equipment must be selected according to the concentration and amount of the dangerous substance at the specific workplace.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Respiratory protection: Where risk assessment shows air-purifying respirators are appropriate use a full-face respirator with multipurpose combination (US) or type ABEK (EN 14387) respirator cartridges as a backup to engineering controls. If the respirator is the sole means of protection, use a full-face supplied air respirator. Use respirators and components tested and approved under appropriate government standards such as NIOSH (US) or CEN (EU).'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'For more Personal Protective Equipment (PPE) (Complete) data for TRIETHYLAMINE (13 total), please visit the HSDB record page.',\n",
       "         'Markup': [{'Start': 108,\n",
       "           'Length': 16,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/source/hsdb/896#section=Personal-Protective-Equipment-(PPE)-(Complete)'},\n",
       "          {'Start': 65,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TRIETHYLAMINE',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': '(See protection codes)',\n",
       "         'Markup': [{'Start': 1,\n",
       "           'Length': 20,\n",
       "           'URL': 'https: //www.cdc.gov/niosh/npg/protect.html'}]},\n",
       "        {'String': 'Skin: Prevent skin contact  - Wear appropriate personal protective clothing to prevent skin contact.'},\n",
       "        {'String': 'Eyes: Prevent eye contact  - Wear appropriate eye protection to prevent eye contact.'},\n",
       "        {'String': 'Wash skin: When contaminated'},\n",
       "        {'String': 'Remove: When wet (flammable)'},\n",
       "        {'String': 'Change: No recommendation'},\n",
       "        {'String': 'Provide: Eyewash (>1%), Quick drench (>1%)'}]}}]},\n",
       "   {'TOCHeading': 'Respirator Recommendations',\n",
       "    'Description': \"This section provides a list of allowable respirators to be used for this chemical, according to the NIOSH's Respirator Selection Recommendations.\",\n",
       "    'URL': 'https://www.cdc.gov/niosh/npg/pgintrod.html#mustread',\n",
       "    'Information': [{'ReferenceNumber': 68,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'OSHA'},\n",
       "        {'String': 'Up to 200 ppm:'},\n",
       "        {'String': '(APF = 25) Any supplied-air respirator operated in a continuous-flow mode'},\n",
       "        {'String': '(APF = 50) Any self-contained breathing apparatus with a full facepiece'},\n",
       "        {'String': '(APF = 50) Any supplied-air respirator with a full facepiece'},\n",
       "        {'String': 'Emergency or planned entry into unknown concentrations or IDLH conditions:'},\n",
       "        {'String': '(APF = 10,000) Any self-contained breathing apparatus that has a full facepiece and is operated in a pressure-demand or other positive-pressure mode'},\n",
       "        {'String': '(APF = 10,000) Any supplied-air respirator that has a full facepiece and is operated in a pressure-demand or other positive-pressure mode in combination with an auxiliary self-contained positive-pressure breathing apparatus'},\n",
       "        {'String': 'Escape:'},\n",
       "        {'String': '(APF = 50) Any air-purifying, full-facepiece respirator (gas mask) with a chin-style, front- or back-mounted canister providing protection against the compound of concern'},\n",
       "        {'String': 'Any appropriate escape-type, self-contained breathing apparatus'},\n",
       "        {'String': 'Important additional information about respirator selection',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 59,\n",
       "           'URL': 'https://www.cdc.gov/niosh/npg/pgintrod.html#mustread'}]}]}}]},\n",
       "   {'TOCHeading': 'Fire Prevention',\n",
       "    'Description': 'Precautionary measures to prevent fires from this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'NO open flames, NO sparks and NO smoking. Closed system, ventilation, explosion-proof electrical equipment and lighting.'}]}}]},\n",
       "   {'TOCHeading': 'Exposure Prevention',\n",
       "    'Description': 'Prevention measures to avoid exposure to this chemical through various routes (for example, ingestion, inhalation, skin contact, and eye contact).',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'AVOID ALL CONTACT!'}]}}]},\n",
       "   {'TOCHeading': 'Inhalation Prevention',\n",
       "    'Description': 'Precautionary measures to avoid inhalation of this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Use ventilation, local exhaust or breathing protection.'}]}}]},\n",
       "   {'TOCHeading': 'Skin Prevention',\n",
       "    'Description': 'Precautionary measures to avoid skin exposure to this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Protective gloves. Protective clothing.'}]}}]},\n",
       "   {'TOCHeading': 'Eye Prevention',\n",
       "    'Description': 'Precautionary measures to avoid eye exposure to this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Wear face shield or eye protection in combination with breathing protection.'}]}}]},\n",
       "   {'TOCHeading': 'Ingestion Prevention',\n",
       "    'Description': 'Precautionary measures to avoid ingestion of this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Do not eat, drink, or smoke during work.'}]}}]}]},\n",
       " {'TOCHeading': 'Stability and Reactivity',\n",
       "  'Description': 'This section describes the stability and reactivity hazards of the chemical.  For some compounds, related information may also be found in the \"Stability/Shelf Life\" section under Experimental Properties (if available).',\n",
       "  'URL': 'https://www.osha.gov/sites/default/files/publications/OSHA3514.pdf',\n",
       "  'Section': [{'TOCHeading': 'Air and Water Reactions',\n",
       "    'Description': 'Special alerts if this chemical reacts with air, water, or moisture. ',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Highly flammable. Soluble in water.',\n",
       "         'Markup': [{'Start': 29,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]},\n",
       "   {'TOCHeading': 'Reactive Group',\n",
       "    'Description': 'List of reactive groups that this chemical belongs to, according to CAMEO Chemicals at the U.S. National Oceanic and Atmospheric Administration (NOAA).',\n",
       "    'URL': 'https://cameochemicals.noaa.gov/help/reactivity/reactive_groups.htm',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Amines, Phosphines, and Pyridines'}]}}]},\n",
       "   {'TOCHeading': 'Reactivity Alerts',\n",
       "    'Description': 'Special alerts if the chemical is especially reactive.',\n",
       "    'URL': 'https://cameochemicals.noaa.gov/help/reactivity/reactivity_alerts.htm',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Highly Flammable'}]}}],\n",
       "    'Section': [{'TOCHeading': 'CSL Reaction Information',\n",
       "      'Description': 'Reaction information for potentially hazardous chemicals, integrated from the Pistoia Alliance Chemical Safety Library (CSL).',\n",
       "      'URL': 'https://safescience.cas.org/',\n",
       "      'DisplayControls': {'CreateTable': {'FromInformationIn': 'ThisSection',\n",
       "        'NumberOfColumns': 2,\n",
       "        'ColumnContents': ['Name', 'Value']}},\n",
       "      'Information': [{'ReferenceNumber': 47,\n",
       "        'Name': 'CSL No',\n",
       "        'Value': {'StringWithMarkup': [{'String': 'CSL00105'}]}},\n",
       "       {'ReferenceNumber': 47,\n",
       "        'Name': 'Reactants/Reagents',\n",
       "        'Value': {'StringWithMarkup': [{'String': 'SODIUM HYPOCHLORITE; TRIETHYLAMINE',\n",
       "           'Markup': [{'Start': 0,\n",
       "             'Length': 19,\n",
       "             'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/SODIUM%20HYPOCHLORITE',\n",
       "             'Type': 'PubChem Internal Link',\n",
       "             'Extra': 'CID-23665760'},\n",
       "            {'Start': 21,\n",
       "             'Length': 13,\n",
       "             'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TRIETHYLAMINE',\n",
       "             'Type': 'PubChem Internal Link',\n",
       "             'Extra': 'CID-8471'}]}]}},\n",
       "       {'ReferenceNumber': 47,\n",
       "        'Name': 'GHS Category',\n",
       "        'Value': {'StringWithMarkup': [{'String': 'Explosive'}]}},\n",
       "       {'ReferenceNumber': 47,\n",
       "        'Name': 'Warning Message',\n",
       "        'Value': {'StringWithMarkup': [{'String': 'Potentially explosive'}]}},\n",
       "       {'ReferenceNumber': 47,\n",
       "        'Name': 'Source Reference',\n",
       "        'Value': {'StringWithMarkup': [{'String': 'User-Reported'}]}},\n",
       "       {'ReferenceNumber': 47,\n",
       "        'Name': 'CSL Status',\n",
       "        'Value': {'StringWithMarkup': [{'String': 'Approved'}]}},\n",
       "       {'ReferenceNumber': 47,\n",
       "        'Name': 'Modified Date',\n",
       "        'Value': {'StringWithMarkup': [{'String': '8/7/2018'}]}}]}]},\n",
       "   {'TOCHeading': 'Reactivity Profile',\n",
       "    'Description': \"Description of the chemical's potential reactivity with other chemicals, air, and water. Also it includes any other intrinsic reactive hazards (such as polymerizable or peroxidizable).\",\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'TRIETHYLAMINE reacts violently with oxidizing agents. Reacts with Al and Zn. Neutralizes acids in exothermic reactions to form salts plus water. May be incompatible with isocyanates, halogenated organics, peroxides, phenols (acidic), epoxides, anhydrides, and acid halides. Flammable gaseous hydrogen may be generated in combination with strong reducing agents, such as hydrides.',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TRIETHYLAMINE',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 138,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 292,\n",
       "           'Length': 8,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/element/Hydrogen',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'Element-Hydrogen'}]}]}}]},\n",
       "   {'TOCHeading': 'Hazardous Reactivities and Incompatibilities',\n",
       "    'Description': 'This compound may undergo hazardous reactions with other chemicals.  Therefore, it is considered incompatible with those chemicals and should not be used with them.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Sigma-Aldrich; Safety Data Sheet for Triethylamine. Product Number: T0886 Version 4.13 (Revision Date 05/24/2016). Available from, as of July 1, 2016: https://www.sigmaaldrich.com/safety-center.html'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Incompatible materials: Strong oxidizing agents.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Mackison, F. W., R. S. Stricoff, and L. J. Partridge, Jr. (eds.). NIOSH/OSHA - Occupational Health Guidelines for Chemical Hazards. DHHS(NIOSH) Publication No. 81-123 (3 VOLS). Washington, DC: U.S. Government Printing Office, Jan. 1981., p. 2'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Toxic gases and vapors (such as oxides of nitrogen and carbon monoxide) may be released in fire involving triethylamine.',\n",
       "         'Markup': [{'Start': 55,\n",
       "           'Length': 15,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/carbon%20monoxide',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-281'},\n",
       "          {'Start': 106,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Mackison, F. W., R. S. Stricoff, and L. J. Partridge, Jr. (eds.). NIOSH/OSHA - Occupational Health Guidelines for Chemical Hazards. DHHS(NIOSH) Publication No. 81-123 (3 VOLS). Washington, DC: U.S. Government Printing Office, Jan. 1981., p. 2'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Contact with strong acids may cause violent spattering.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Bretherick, L. Handbook of Reactive Chemical Hazards. 4th ed. Boston, MA: Butterworth-Heinemann Ltd., 1990, p. 1355'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'The complex, containing excess /dinitrogen tetraoxide/ over ... /triethylamine/, exploded at below 0 °C when free of solvent.',\n",
       "         'Markup': [{'Start': 32,\n",
       "           'Length': 21,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/dinitrogen%20tetraoxide',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-25352'},\n",
       "          {'Start': 65,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"Lewis, R.J. Sr. (ed) Sax's Dangerous Properties of Industrial Materials. 11th Edition. Wiley-Interscience, Wiley & Sons, Inc. Hoboken, NJ. 2004., p. 3545\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Incompatible with N2O4.'}]}}]}]},\n",
       " {'TOCHeading': 'Transport Information',\n",
       "  'Description': 'Transport information lists the U.S. Department of Transportation (DOT) requirements and related information for shipping and transporting of hazardous chemical(s) by road, air, rail, or sea.',\n",
       "  'URL': 'https://www.phmsa.dot.gov/hazmat/erg/emergency-response-guidebook-erg',\n",
       "  'Section': [{'TOCHeading': 'DOT Emergency Guidelines',\n",
       "    'Description': 'U.S. Department of Transportation (DOT) Emergency Guidelines for this chemical.  The information in this section is collected from the Hazardous Substances Data Bank (HSDB).  For updated emergency guidelines, see the DOT Emergency Response Guidebook.',\n",
       "    'URL': 'https://www.phmsa.dot.gov/hazmat/erg/emergency-response-guidebook-erg',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['U.S. Department of Transportation. 2012 Emergency Response Guidebook. Washington, D.C. 2012'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '/GUIDE 132 FLAMMABLE LIQUIDS - CORROSIVE/ Fire or Explosion: Flammable/combustible material. May be ignited by heat, sparks or flames. Vapors may form explosive mixtures with air. Vapors may travel to source of ignition and flash back. Most vapors are heavier than air. They will spread along ground and collect in low or confined areas (sewers, basements, tanks). Vapor explosion hazard indoors, outdoors or in sewers. Those substances designated with a (P) may polymerize explosively when heated or involved in a fire. Runoff to sewer may create fire or explosion hazard. Containers may explode when heated. Many liquids are lighter than water.',\n",
       "         'Markup': [{'Start': 640,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['U.S. Department of Transportation. 2012 Emergency Response Guidebook. Washington, D.C. 2012'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '/GUIDE 132 FLAMMABLE LIQUIDS - CORROSIVE/ Health: May cause toxic effects if inhaled or ingested/swallowed. Contact with substance may cause severe burns to skin and eyes. Fire will produce irritating, corrosive and/or toxic gases. Vapors may cause dizziness or suffocation. Runoff from fire control or dilution water may cause pollution.',\n",
       "         'Markup': [{'Start': 312,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['U.S. Department of Transportation. 2012 Emergency Response Guidebook. Washington, D.C. 2012'],\n",
       "      'Value': {'StringWithMarkup': [{'String': '/GUIDE 132 FLAMMABLE LIQUIDS - CORROSIVE/ Public Safety: CALL Emergency Response Telephone Number on Shipping Paper first. If Shipping Paper not available or no answer, refer to appropriate telephone number listed on the inside back cover. As an immediate precautionary measure, isolate spill or leak area for at least 50 meters (150 feet) in all directions. Keep unauthorized personnel away. Stay upwind. Keep out of low areas. Ventilate closed spaces before entering.'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['U.S. Department of Transportation. 2012 Emergency Response Guidebook. Washington, D.C. 2012'],\n",
       "      'Value': {'StringWithMarkup': [{'String': \"/GUIDE 132 FLAMMABLE LIQUIDS - CORROSIVE/ Protective Clothing: Wear positive pressure self-contained breathing apparatus (SCBA). Wear chemical protective clothing that is specifically recommended by the manufacturer. It may provide little or no thermal protection. Structural firefighters' protective clothing provides limited protection in fire situations ONLY; it is not effective in spill situations where direct contact with the substance is possible.\"}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Value': {'StringWithMarkup': [{'String': 'For more DOT Emergency Guidelines (Complete) data for TRIETHYLAMINE (8 total), please visit the HSDB record page.',\n",
       "         'Markup': [{'Start': 96,\n",
       "           'Length': 16,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/source/hsdb/896#section=DOT-Emergency-Guidelines-(Complete)'},\n",
       "          {'Start': 54,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TRIETHYLAMINE',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]},\n",
       "   {'TOCHeading': 'DOT ID and Guide',\n",
       "    'Description': 'U.S. Department of Transportation (DOT) identification (ID) number and the corresponding guide number. The DOT ID, also called the North American (NA) number, is identical to the United Nations (UN) number, except that some substances without a UN number may have a DOT ID/NA number.',\n",
       "    'URL': 'https://www.fmcsa.dot.gov/registration/do-i-need-usdot-number',\n",
       "    'Information': [{'ReferenceNumber': 8,\n",
       "      'URL': 'https://www.phmsa.dot.gov/sites/phmsa.dot.gov/files/2020-08/ERG2020-WEB.pdf',\n",
       "      'Value': {'StringWithMarkup': [{'String': '1296 132'}]}},\n",
       "     {'ReferenceNumber': 68,\n",
       "      'URL': 'https://www.phmsa.dot.gov/sites/phmsa.dot.gov/files/2020-08/ERG2020-WEB.pdf',\n",
       "      'Value': {'StringWithMarkup': [{'String': '1296 132'}]}}]},\n",
       "   {'TOCHeading': 'Shipping Name/ Number DOT/UN/NA/IMO',\n",
       "    'Description': 'When dangerous goods are transported/shipped, one of the proper shipping names (along with corresponding identification numbers) shown in Dangerous Goods List of the applicable transport regulations (e.g., IATA-DGR, IMO-IMDG code, and 49 CFR 171-180) must be used to meet labelling, marking, and documentation requirements.  This section provides this chemical\\'s appropriate shipping names and identification numbers, such as the U.S. Department of Transportation (DOT) identification number (also known as \"United Nations (UN) number\" or \"North America (NA) number\") and the International Maritime Organization (IMO)\\'s International Maritime Dangerous Goods (IMDG) Code.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'UN 1296; Triethylamine'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'IMO 3; Triethylamine'}]}}]},\n",
       "   {'TOCHeading': 'Standard Transportation Number',\n",
       "    'Description': 'This section provides the Standard Transportation Commodity Code (STCC) for this chemical.  The STCC is a seven digit numeric code representing 38 commodity groupings and used on waybills and other shipping documents.  If the first two digits of an STCC are 48 or 49, the STCC is also called the Hazardous Materials Response Code (HMRC) or Hazmat STCC, and is used when transporting a hazardous material or dangerous good by rail in North America. ',\n",
       "    'URL': 'https://public.railinc.com/resources/standard-transportation-commodity-code',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Value': {'StringWithMarkup': [{'String': '49 078 77; Triethylamine'}]}}]},\n",
       "   {'TOCHeading': 'Shipment Methods and Regulations',\n",
       "    'Description': 'Shipment methods and regulations of this compound.  The information in this section includes the U.S. Hazardous Materials Regulations (49 CFR Subchapter C), the International Air Transport Association (IATA) Dangerous Goods Regulations, the International Maritime Dangerous Goods (IMDG) Code, and other regulations.',\n",
       "    'URL': 'https://www.govinfo.gov/content/pkg/CFR-2009-title49-vol2/pdf/CFR-2009-title49-vol2-part171.pdf',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"49 CFR 171.2 (USDOT); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 28, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'No person may /transport,/ offer or accept a hazardous material for transportation in commerce unless that person is registered in conformance ... and the hazardous material is properly classed, described, packaged, marked, labeled, and in condition for shipment as required or authorized by ... /the hazardous materials regulations (49 CFR 171-177)./'}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['International Air Transport Association. Dangerous Goods Regulations. 57th Edition. Montreal, Quebec Canada. 2016., p. 329'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'The International Air Transport Association (IATA) Dangerous Goods Regulations are published by the IATA Dangerous Goods Board pursuant to IATA Resolutions 618 and 619 and constitute a manual of industry carrier regulations to be followed by all IATA Member airlines when transporting hazardous materials. Triethylamine is included on the dangerous goods list.',\n",
       "         'Markup': [{'Start': 306,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['International Maritime Organization. IMDG Code. International Maritime Dangerous Goods Code Volume 2 2014, p. 57'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'The International Maritime Dangerous Goods Code lays down basic principles for transporting hazardous chemicals. Detailed recommendations for individual substances and a number of recommendations for good practice are included in the classes dealing with such substances. A general index of technical names has also been compiled. This index should always be consulted when attempting to locate the appropriate procedures to be used when shipping any substance or article. Triethylamine is included on the dangerous goods list.',\n",
       "         'Markup': [{'Start': 473,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]},\n",
       "   {'TOCHeading': 'DOT Label',\n",
       "    'Description': 'U.S. Department of Transportation (DOT) hazard warning label for the chemical (such as flammable liquid or corrosive). This label must be displayed on shipped packages, railroad tank cars, and tank trucks according to specifications described in 49 CFR 172.',\n",
       "    'URL': 'https://www.govinfo.gov/content/pkg/CFR-2020-title49-vol2/pdf/CFR-2020-title49-vol2-part172.pdf',\n",
       "    'Information': [{'ReferenceNumber': 1,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Flammable Liquid Corrosive'}]}}]},\n",
       "   {'TOCHeading': 'Packaging and Labelling',\n",
       "    'Description': \"Warnings and instructions for packaging and labelling of chemical products.  The information in this section is from the International Labour Organization (ILO)'s International Chemical Safety Cards (ICSC).\",\n",
       "    'URL': 'https://www.ilo.org/safework/info/publications/WCMS_113134/lang--en/index.htm',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Do not transport with food and feedstuffs.'}]}}]},\n",
       "   {'TOCHeading': 'EC Classification',\n",
       "    'Description': 'European Commission (EC) classification for hazardous material.',\n",
       "    'URL': 'https://ec.europa.eu/growth/sectors/chemicals/classification-labelling_en',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Symbol: F, C; R: 11-20/21/22-35; S: (1/2)-3-16-26-29-36/37/39-45'}]}}]},\n",
       "   {'TOCHeading': 'UN Classification',\n",
       "    'Description': 'Classification of this chemical, according to the Agreement concerning the International Carriage of Dangerous Goods by Road (ADR).  ADR is a United Nations treaty that governs transnational transport of hazardous materials.',\n",
       "    'URL': 'https://unece.org/about-adr',\n",
       "    'Information': [{'ReferenceNumber': 28,\n",
       "      'Value': {'StringWithMarkup': [{'String': 'UN Hazard Class: 3; UN Subsidiary Risks: 8; UN Pack Group: II'}]}}]}]},\n",
       " {'TOCHeading': 'Regulatory Information',\n",
       "  'Description': 'This section lists the safety, health, and environmental regulations concerning the chemical and products containing it.  The information may include any national and/or regional regulatory information of the chemical or mixtures.',\n",
       "  'Section': [{'TOCHeading': 'Atmospheric Standards',\n",
       "    'Description': 'This section provides atmospheric standards related to the chemical, established by regulatory agencies.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 60.489 (USEPA); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'This action promulgates standards of performance for equipment leaks of Volatile Organic Compounds (VOC) in the Synthetic Organic Chemical Manufacturing Industry (SOCMI). The intended effect of these standards is to require all newly constructed, modified, and reconstructed SOCMI process units to use the best demonstrated system of continuous emission reduction for equipment leaks of VOC, considering costs, non air quality health and environmental impact and energy requirements. Triethylamine is produced, as an intermediate or a final product, by process units covered under this subpart.',\n",
       "         'Markup': [{'Start': 484,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Clean Air Act as amended in 1990, Sect. 112 (b) (1) Public Law 101-549 Nov. 15, 1990'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Listed as a hazardous air pollutant (HAP) generally known or suspected to cause serious health problems. The Clean Air Act, as amended in 1990, directs EPA to set standards requiring major sources to sharply reduce routine emissions of toxic pollutants. EPA is required to establish and phase in specific performance based standards for all air emission sources that emit one or more of the listed pollutants. Triethylamine is included on this list.',\n",
       "         'Markup': [{'Start': 410,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]},\n",
       "   {'TOCHeading': 'Clean Water Act Requirements',\n",
       "    'Description': 'The Clean Water Act (CWA) of 1972 establishes the basic structure for regulating discharges of pollutants into the waters of the United States and regulating quality standards for surface waters.  Under CWA, the U.S. Environmental Protection Agency (EPA) developed the Toxic Pollutant List (40 CFR Part 401.15) and the Priority Pollutant List (40 CFR Part 423, Appendix A). These lists are to be used by EPA and States to develop the Effluent Guidelines regulations and ensure water quality criteria and standards.',\n",
       "    'URL': 'https://www.epa.gov/laws-regulations/summary-clean-water-act',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 116.4 (USEPA); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Triethylamine is designated as a hazardous substance under section 311(b)(2)(A) of the Federal Water Pollution Control Act and further regulated by the Clean Water Act Amendments of 1977 and 1978. These regulations apply to discharges of this substance. This designation includes any isomers and hydrates, as well as any solutions and mixtures containing this substance.',\n",
       "         'Markup': [{'Start': 0,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 95,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 158,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}}]},\n",
       "   {'TOCHeading': 'CERCLA Reportable Quantities',\n",
       "    'Description': 'The CERCLA reportable quantity for a hazardous substance is the minimum quantity of the substance which, if released, must be reported, under the Comprehensive Environmental Response, Compensation, and Liability Act of 1980 (CERCLA, also commonly known as Superfund).',\n",
       "    'URL': 'https://www.epa.gov/epcra/cercla-and-epcra-continuous-release-reporting',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 302.4 (USEPA); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Persons in charge of vessels or facilities are required to notify the National Response Center (NRC) immediately, when there is a release of this designated hazardous substance, in an amount equal to or greater than its reportable quantity of 5000 lb or 2270 kg. The toll free number of the NRC is (800) 424-8802. The rule for determining when notification is required is stated in 40 CFR 302.4 (section IV. D.3.b).'}]}}]},\n",
       "   {'TOCHeading': 'TSCA Requirements',\n",
       "    'Description': 'This section provides information on requirements concerning this chemical under the Toxic Substances Control Act (TSCA) of 1976.  TSCA provides EPA with authority to require reporting, record-keeping and testing requirements, and restrictions relating to chemical substances and/or mixtures. Certain substances are generally excluded from TSCA, including, among others, food, drugs, cosmetics and pesticides.',\n",
       "    'URL': 'https://www.epa.gov/chemicals-under-tsca',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 716.120 (USEPA);  U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Pursuant to section 8(d) of TSCA, EPA promulgated a model Health and Safety Data Reporting Rule. The section 8(d) model rule requires manufacturers, importers, and processors of listed chemical substances and mixtures to submit to EPA copies and lists of unpublished health and safety studies. Ethanamine, N,N-diethyl- is included on this list. Effective date: 1/13/84; Sunset date: 1/13/94.',\n",
       "         'Markup': [{'Start': 28,\n",
       "           'Length': 4,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/TSCA',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-110408'},\n",
       "          {'Start': 294,\n",
       "           'Length': 10,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/Ethanamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-20482971'}]}]}}]},\n",
       "   {'TOCHeading': 'RCRA Requirements',\n",
       "    'Description': 'The Resource Conservation and Recovery Act (RCRA) is the public law that creates the framework for the proper management of hazardous and non-hazardous solid waste. The law describes the waste management program mandated by Congress that gave EPA authority to develop the RCRA program. The term RCRA is often used interchangeably to refer to the law, regulations and EPA policy and guidance.',\n",
       "    'URL': 'https://www.epa.gov/rcra',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 261.33 (USEPA); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'U404; As stipulated in 40 CFR 261.33, when triethylamine, as a commercial chemical product or manufacturing chemical intermediate or an off-specification commercial chemical product or a manufacturing chemical intermediate, becomes a waste, it must be managed according to Federal and/or State hazardous waste regulations. Also defined as a hazardous waste is any residue, contaminated soil, water, or other debris resulting from the cleanup of a spill, into water or on dry land, of this waste. Generators of small quantities of this waste may qualify for partial exclusion from hazardous waste regulations (40 CFR 261.5).',\n",
       "         'Markup': [{'Start': 43,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'},\n",
       "          {'Start': 392,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'},\n",
       "          {'Start': 459,\n",
       "           'Length': 5,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/water',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-962'}]}]}},\n",
       "     {'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': [\"40 CFR 261.21 (USEPA); U.S. National Archives and Records Administration's Electronic Code of Federal Regulations. Available from, as of June 27, 2016: https://www.ecfr.gov\"],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'D001; A solid waste containing triethylamine may become characterized as a hazardous waste when subjected to testing for ignitability as stipulated in 40 CFR 261.21, and if so characterized, must be managed as a  hazardous waste.',\n",
       "         'Markup': [{'Start': 31,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]}]},\n",
       " {'TOCHeading': 'Other Safety Information',\n",
       "  'Description': 'Miscellaneous safety information for this chemical that is not shown in other sections, such as history, incidents, special reports, and so on.',\n",
       "  'Section': [{'TOCHeading': 'Toxic Combustion Products',\n",
       "    'Description': 'Toxic products (e.g., gases and vapors) produced from the combustion of this chemical.',\n",
       "    'Information': [{'ReferenceNumber': 25,\n",
       "      'Description': 'PEER REVIEWED',\n",
       "      'Reference': ['Mackison, F. W., R. S. Stricoff, and L. J. Partridge, Jr. (eds.). NIOSH/OSHA - Occupational Health Guidelines for Chemical Hazards. DHHS(NIOSH) Publication No. 81-123 (3 VOLS). Washington, DC: U.S. Government Printing Office, Jan. 1981., p. 2'],\n",
       "      'Value': {'StringWithMarkup': [{'String': 'Toxic gases and vapors (such as oxides of nitrogen and carbon monoxide) may be released in fire involving triethylamine.',\n",
       "         'Markup': [{'Start': 55,\n",
       "           'Length': 15,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/carbon%20monoxide',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-281'},\n",
       "          {'Start': 106,\n",
       "           'Length': 13,\n",
       "           'URL': 'https://pubchem.ncbi.nlm.nih.gov/compound/triethylamine',\n",
       "           'Type': 'PubChem Internal Link',\n",
       "           'Extra': 'CID-8471'}]}]}}]}]}]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Record']['Section'][11]['Section']#['Hazards Identification']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7594a100",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "62341fb8",
   "metadata": {},
   "source": [
    "## Robustness of getting json data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "79d3de9b",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T12:12:30.013607Z",
     "start_time": "2022-09-23T12:12:29.618876Z"
    }
   },
   "outputs": [],
   "source": [
    "import pubchempy as pcp\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "from requests_html import HTMLSession\n",
    "import json\n",
    "\n",
    "query_id_types = ['name', 'smiles', 'sdf', 'inchi', 'inchikey', 'formula', 'cid']\n",
    "\n",
    "def get_url(cid):\n",
    "    \n",
    "    url = f'https://pubchem.ncbi.nlm.nih.gov/rest/pug_view/data/compound/{cid}/JSON/?response_type=display'\n",
    "    \n",
    "    return url\n",
    "\n",
    "\n",
    "def _get_cid(identifier, id_type):\n",
    "    \n",
    "    assert id_type in query_id_types \n",
    "    \n",
    "    if id_type == 'cid':\n",
    "        return identifier\n",
    "    \n",
    "    else:\n",
    "        cid = pcp.get_cids(identifier, id_type)\n",
    "        return cid[0]\n",
    "\n",
    "def get_json(url):\n",
    " \n",
    "    read = requests.get(url)\n",
    "    \n",
    "    html_content = read.content\n",
    "    soup = BeautifulSoup(html_content, \"html.parser\")\n",
    "    \n",
    "    raw = soup.get_text()\n",
    "\n",
    "    data = json.loads(raw)\n",
    "    return data\n",
    "\n",
    "def get_hazard_info(data):\n",
    "    # Find the safety and hazards section\n",
    "    # We want the hazard codes from the European Chemicals Agency (ECHA)\n",
    "\n",
    "    for i in range(len(data['Record']['Section'])):\n",
    "        if data['Record']['Section'][i]['TOCHeading'] == 'Safety and Hazards':\n",
    "            for j in range(len(data['Record']['Section'][i]['Section'][0]['Section'][0]['Information'])):\n",
    "                if data['Record']['Section'][i]['Section'][0]['Section'][0]['Information'][j]['Name'] == 'ECHA C&L Notifications Summary':\n",
    "                    pictures_json = data['Record']['Section'][i]['Section'][0]['Section'][0]['Information'][j-4]\n",
    "                    hcodes_json = data['Record']['Section'][i]['Section'][0]['Section'][0]['Information'][j-2]\n",
    "    hcodes = []\n",
    "    hcodes_descriptions = []\n",
    "    \n",
    "    try:\n",
    "        for section in hcodes_json['Value']['StringWithMarkup']:\n",
    "            hcode = section['String'][:4]\n",
    "            hcode_description = section['String']\n",
    "            hcodes += [hcode]\n",
    "            hcodes_descriptions += [hcode_description]\n",
    "\n",
    "        pictures = []\n",
    "        for section in pictures_json['Value']['StringWithMarkup'][0]['Markup']:\n",
    "            picture = section['URL']\n",
    "            pictures += [picture]\n",
    "\n",
    "        return hcodes, hcodes_descriptions, pictures\n",
    "    except UnboundLocalError:\n",
    "        return 'Nothing found', None, None\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "id": "d6336ffd",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T14:30:32.762649Z",
     "start_time": "2022-09-22T14:30:31.563629Z"
    }
   },
   "outputs": [],
   "source": [
    "identifier = 'water'\n",
    "id_type = 'name'\n",
    "cid = _get_cid(identifier, id_type)\n",
    "url = get_url(cid)\n",
    "data = get_json(url)\n",
    "hcodes, hcodes_descriptions, pictures = get_hazard_info(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "id": "36f288a7",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T14:30:32.883799Z",
     "start_time": "2022-09-22T14:30:32.880606Z"
    }
   },
   "outputs": [],
   "source": [
    "hcodes, hcodes_descriptions, pictures = get_hazard_info(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "id": "ed4ee6a1",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-22T14:30:34.334231Z",
     "start_time": "2022-09-22T14:30:34.328878Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Nothing found'"
      ]
     },
     "execution_count": 265,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hcodes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "105b9a42",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:11:44.078399Z",
     "start_time": "2022-09-23T13:11:43.300541Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "ee780c70",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:11:44.169221Z",
     "start_time": "2022-09-23T13:11:44.164160Z"
    }
   },
   "outputs": [],
   "source": [
    "df = pd.DataFrame({'num_legs': [2, 4, 8, 0],\n",
    "                    'num_wings': [2, 0, 0, 0],\n",
    "                    'num_specimen_seen': [10, 2, 1, 8]},\n",
    "                   index=['falcon', 'dog', 'spider', 'fish'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "256ff7d4",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-09-23T13:15:58.295290Z",
     "start_time": "2022-09-23T13:15:58.289772Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'falcon dog spider fish'"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a = df.index.tolist()\n",
    "' '.join(a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ce69ed9b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "dswigh_default",
   "language": "python",
   "name": "dswigh_default"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.10"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": true,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}