HDPBC Data Sets

Last updated: June 30, 2025

Click here to download the Excel file containing HDPBC metadata.

What You Can Do:

  • Query HDPBC Data: Easily find and filter data by health authority, diagnosis codes, procedures, patient demographics, and more.
  • Generate SQL Queries: Use the metadata to guide the generation of SQL queries for aggregating, filtering, and summarizing data in complex ways.
  • Use AI Prompts: Leverage AI prompts to automate your analysis. From identifying relevant datasets to writing SQL queries, AI prompts can help streamline your workflow and provide more advanced insights. Examples of AI Prompts:
    • "Which data holdings do I need to access to count home care visits by health authorities, which is a regional subdivision of British Columbia?"
    • "Please use the provided metadata file to help me understand what table I should use to determine the number of births in a given year across Vancouver Island Health Authority."
    • "Write a SQL query to sum the number of home visit days by health authorities in British Columbia."
    • "Write a SQL query to select rows from the MSP_CORE table with a diagnosis code in a list of specific codes."
    • "Write a SQL query to create a summary report of patient demographics (e.g., age, gender, region) in the dataset."

Disclaimer:

  • The quality of the results may vary depending on the AI model used. It’s important to review and validate the outputs to ensure accuracy.
  • You are responsible for ensuring the results generated meet your needs and are appropriate for your analysis.

New Data Set Available in HDPBC

BC Employment and Assistance (BCEA) - Jan 2005 to Dec 2024

HDPBC regularly refreshes its data. To find information about HDPBC datasets such as years covered, last updated, and if additional approval is required, search for keywords, or click on the tile to expand and view details.