SAMPLE Canadian Physician Registry | 93K+ Providers Across Ontario, Quebec & Alberta | ...

The Canadian Physician Registry is a comprehensive, analysis-ready dataset that unifies physician directory data from three major Canadian provincial medical registries into a single, standardized format.

DATA SOURCES & COVERAGE

The dataset consolidates records from three authoritative provincial registries:

- College of Physicians and Surgeons of Ontario (CPSO): 52,900+ physicians covering Canada's largest province
- College des Medecins du Quebec (CMQ): 26,600+ physicians from Quebec's official medical regulatory body
- College of Physicians & Surgeons of Alberta (CPSA): 13,500+ physicians from Alberta's regulatory college

Together, these three provinces represent over 80% of Canada's physician workforce, providing unmatched coverage of the Canadian healthcare provider landscape.

WHAT'S INCLUDED

Each provider record contains:
- Provider identification: Unique ID, provincial registration/license number
- Demographics: First name, last name, province, province code
- Contact information: Practice address, city, postal code, phone number, fax
- Professional details: Raw and normalized specialty classifications, registration status (Active, Inactive, Suspended, Deceased)
- Metadata: Record creation and last-update timestamps for change tracking

KEY STATISTICS

- 93,150 total provider records across all three provinces
- 84,200+ active physicians (90% of total)
- 150+ unique medical specialties including Family Medicine (34,000+), Psychiatry (4,500+), Internal Medicine (3,600+), and Anesthesiology (3,100+)
- Province distribution: Ontario 57%, Quebec 29%, Alberta 15%

DATA QUALITY & PROCESSING

Raw data is extracted directly from each provincial registry's official systems (JSON API, HTML, and PDF sources), then cleaned, normalized, and unified into a consistent schema. Specialty names are standardized across provinces for cross-registry analysis. Registration statuses are harmonized. All records include lineage metadata for full traceability back to source.

UPDATE FREQUENCY

The dataset is refreshed weekly (every Monday) with automated pipelines. Monthly snapshots are preserved for historical comparison and trend analysis.

USE CASES

- Healthcare Market Intelligence: Size the Canadian physician market by specialty, geography, and registration status
- Provider Outreach & Marketing: Build targeted contact lists of active physicians by specialty and location
- Workforce Analytics: Track physician supply across provinces, identify specialty shortages and distribution patterns
- Network Adequacy: Assess provider coverage for health plan network design and regulatory compliance
- Academic Research: Study physician demographics, specialty distribution, and geographic access to care
- Competitive Intelligence: Monitor physician registration trends and new entrants by province

DELIVERY OPTIONS

Available via Snowflake Marketplace (shared database), Databricks Unity Catalog, or direct S3 export to your AWS account. Full schema documentation and data dictionary included. Custom data packages available on request.