Table 4.
Estimation of the comprehensiveness of industry payment data extracted for eurosfordocs.eu (2019)
| Country* | Total value of payments reported in summary industry data (€m)2 3 | Total value of payments extracted to eurosfordocs.eu (€m)4 5 | Difference (€m) | Difference as a share of summary industry data (%)† | Level of match between summary industry data and eurosfordocs.eu |
| Germany | 629 | 499 | 130 | 21% | Low |
| Ireland | 35 | 35 | 0 | 0% | Exact |
| Sweden | 90 | 82 | 8 | 9% | Close |
| Switzerland | 167 | 155 | 12 | 7% | Close |
| Spain | 601 | 337 | 264 | 44% | Low |
| UK | 619 | 611 | 8 | 1%‡ | Exact/close |
*Only countries covered by both eurosfordocs.eu and available national-level summary data generated by industry trade groups are included.
†Some of the difference between the value of payments based on summary industry data and extracted to eurosfordocs.eu results from the differences in the exchange rates. This is exemplified by the examples of Ireland (both values in euro, no difference) and the UK (original values in the sterling, the difference is caused by different exchange rates used to convert the sterling to euro). By contrast, the 1% difference between eurosfordoscs.eu and Disclosure UK results from two marginally different exchange rates used to convert the sterling to euros.
‡All payment values in non-euro currencies were converted to euros based on the exchange rate obtained from the CurrencyConverter,85 a Python library for exchange rates.
§Sources of national-level summary payment data. (a) Germany,86 Spain,87 Switzerland88—publicly available pharmaceutical industry summary data published by the pharmaceutical industry trade groups. (b) Ireland—a combination of an Europe-wide report published by EFPIA89 and email communication with the Irish pharmaceutical industry trade group.90 (c) Sweden—email communication with the pharmaceutical industry trade group. (d)The UK—calculations based on data obtained from Disclosure UK, the centralised database of industry payments run by the Association of the British Pharmaceutical Industry.91
¶All payment values in non-euro currencies were converted to euros based on the average yearly exchanged rates published by the European Central Bank.
**The source of payment values reported in this column are centralised pharmaceutical industry payment databases (Ireland and the UK) and payment reports covering payments made by individual companies (Germany, Spain, Sweden and Switzerland).