Updated

Pharmaceutical Drug Spending by countries

1.4K

Pharmaceutical Drug Spending by countries with indicators such as a share of total health spending, in USD per capita (using economy-wide PPPs) and as a share of GDP. Plus, total spending by each coun...

API Access

Access dataset files directly from scripts, code, or AI agents.

Browse dataset files
Dataset Files

Each file has a stable URL (r-link) that you can use directly in scripts, apps, or AI agents. These URLs are permanent and safe to hardcode.

/core/pharmaceutical-drug-spending/
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/.gitignore
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/README.md
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/UPDATE_SCRIPT_MAINTENANCE_REPORT.md
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/merge-all.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/merge-health-gdp.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/perc-gdp.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/perc-health-spend.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/pharma-spending.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/population.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/archive/usd-cap.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/data/data.csv
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/datapackage.json
Key Files

Start with these files — they give you everything you need to understand and access the dataset.

datapackage.jsonmetadata & schema
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/datapackage.json
README.mddocumentation
https://datahub.io/core/pharmaceutical-drug-spending/_r/-/README.md
Typical Usage
  1. 1. Fetch datapackage.json to inspect schema and resources
  2. 2. Download data resources listed in datapackage.json
  3. 3. Read README.md for full context

Data Previews

data

Loading data...

Schema

nametypedescription
LOCATIONstringCountry code
TIMEyearDate in the form of %Y
PC_HEALTHXPnumber% of Health spending
PC_GDPnumber% of GDP
USD_CAPnumberin USD per capita (using economy-wide PPPs)
TOTAL_SPENDnumberTotal spending in millions

Data Files

FileDescriptionSizeLast modifiedDownload
data
51.2 kBabout 1 month ago
data
FilesSizeFormatCreatedUpdatedLicenseSource
151.2 kBcsv21 days agoOpen Data Commons Public Domain Dedication and Licence (PDDL)Pharmaceutical Drug Spending from Organisation for Economic Cooperation and Development

badge

Pharmaceutical Drug Spending by countries with indicators such as a share of total health spending, in USD per capita (using economy-wide PPPs) and as a share of GDP. Plus, total spending by each countries in the specific year.

Data

Data comes from Organisation for Economic Cooperation and Development on https://data.oecd.org/healthres/pharmaceutical-spending.htm

It consists of useful information about percent of health spending, percent of GDP and US dollars per capita for specific countries. Also, we added total spending by countries using their population data.

Population data comes from DataHub http://datahub.io/core/population since it is regularly updated and includes all country codes.

Preparation

There are several steps have been done to get final data.

  • We extracted separately each resource by "percent of health spending", "percent of GDP" and "US dollars per capita"
  • We merged them into one resource and added new column "TOTAL_SPEND"

"TOTAL_SPEND" is calculated using "US dollars per capita" and "population" data. Source for original pharmacy drug spending: https://stats.oecd.org/sdmx-json/data/DP_LIVE/.PHARMAEXP…/OECD?contentType=csv&detail=code&separator=comma&csv-lang=en.

Process is recorded and automated in python script:

# to get population.csv
python scripts/population.py 
# to get final data.csv
python scripts/process.py

License

Public Domain Dedication and License (PDDL)