Overview

Here we provide files for download containing data from the Guide to PHARMACOLOGY in various formats. These are the most commonly requested types of data file; other data and file formats are available by emailing us.

We also now provide REST web services to enable computational access to the data in JSON format.

The Guide to PHARMACOLOGY database is licensed under the Open Data Commons Open Database License (ODbL) and its contents are licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported license.

Download data files

Download CSV files with information on targets, ligands and interactions. We also provide mappings between our internal identifiers and URLs to HGNC gene IDs/symbols or UniProt accessions. Read a description of the files here

Download the full database

We provide a copy of the current public relational database (created with PostgreSQL version 9.2) to download (please read the license information above).

View the PostgreSQL database entity relationship diagram (ERD) (generated by SQL Power Architect)

Archived PostgreSQL versions:

MySQL version

We no longer provide an up-to-date MySQL version. We are willing to discuss providing a MySQL version 'on demand', so please get in touch if you'd like to discuss this with us. Email us.
We do provide archived versions created with MySQL 5.6, however, note that this is untested (please send us any feedback). The data are encoded in character set UTF-8; to use it with MySQL you need to enable full UTF-8 4-byte support. Please note that while we hope this information will be useful, the database file is provided "as is" and without any technical support on using PostgreSQL or MySQL.

Archived MySQL versions:

Hosted target and ligand lists

We also host a number of attributed target and ligand lists extracted from the literature as supplementary data or downloaded from databases.

Presentation slides and posters

We also provide a set of generic slides and a poster for public use when producing presentations and teaching materials using the IUPHAR/BPS Guide to PHARMACOLOGY.