Health Datasets/Australian Medical Benefits Scheme (MBS) and Pharmaceutical Benefits Scheme (PBS)

Description
This health care administration dataset contains line data (i.e. not aggregate) 10% of patients that have used the Medical Benefits Scheme (MBS) or the Pharmaceutical Benefits Scheme (PBS) between the years of 1984-2014.

These schemes are at the core of Australia's universal healthcare system (i.e. Medicare) and are primarily administrative in nature. The MBS data is generated by financial reimbursement claims from General Practitioners, Specialists, Allied Health, Hospitals and other health services and the PBS data from pharmacies and other health services. The Australian Government Department of Health is the data custodian for both of the original datasets.

More information about this dataset can be found at http://data.gov.au/dataset/a8e3c0bc-44ac-4e9a-8b3c-b779438ddb10

Source
This dataset was originally found at http://data.gov.au/dataset/a8e3c0bc-44ac-4e9a-8b3c-b779438ddb10 in July 2016, but was pulled for maintenance in September 2016. Dennis Wollersheim imported the dataset, along with related reference tables, into an database, and subsequently setup this resource to document it. Contact him via email or via his talk page for more information.



Tools

 * /Useful SQL Queries/

Individual Table Details
There are 3 major tables: PBS, MBS and Patients. PBS is drug prescription data, MBS is medical procedure data, and Patient holds the data about individual patients.

PBS Table
Pharmaceutical Benefits Scheme.

MBS Table
Medical Benefits Scheme.

Patient Table
Patient details.

Derived data extracts
Due to dataset size, there are several subsets useful for testing queries. Note, the id column is not the same between tables.