California Medical Intelligence Dataset - SAMPLE

## **Overview**

This dataset delivers a verified, analysis-ready view of 997 licensed medical and cosmetic providers across California’s major metropolitan regions. Covering five commercially valuable specialties—Plastic Surgery, Dermatology, Pain Management, Medical Spas, and Cosmetic Dentistry—the dataset enables organizations to understand provider distribution, service availability, and competitive positioning in one of the nation’s most economically significant healthcare markets.

With exceptionally high cell completeness (99.4%), curated business details, and geographic depth, this dataset is especially attractive to insurers optimizing network coverage, healthcare organizations conducting market expansion analysis, and technology partners building provider intelligence models. Its structured format supports seamless ingestion into Databricks for analytics, enrichment, and machine learning workflows.

## **Provenance**

The dataset originates from publicly available Google Maps listings. It was compiled by **Maths with Kanchana LLC**, following ethical data practices that rely exclusively on public business information without collecting personal or sensitive data. Provider entries were verified during compilation to ensure accuracy and consistency. The data is publicly available and no proprietary or restricted sources were used.

## **Use Cases**

This dataset enables high-value analytics and ML workflows on Databricks:

* **Provider Network Optimization:** Identify coverage gaps, saturation zones, and high-value expansion areas for insurers and health systems.
* **Market Intelligence & Competitive Analysis:** Benchmark specialties and provider density across California metros to support strategic planning.
* **Healthcare Lead Scoring & Segmentation:** Power ML models that classify and prioritize providers for outreach, partnerships, or sales.
* **Geospatial Analysis:** Map provider concentration and regional demand signals using Databricks geospatial libraries.
* **Business Operations Automation:** Feed into CRM, territory planning, or revenue intelligence dashboards for healthcare organizations.

## **Column Dictionary**

* **title** (string): Business or provider practice name.
* **totalScore** (decimal): Average Google Maps rating.
* **reviewsCount** (integer): Total number of public reviews.
* **street** (string): Street address of the provider location.
* **city** (string): City where the business is located.
* **state** (string): State (California).
* **countryCode** (string): Country code (US).
* **website** (string): Official website link if available.
* **phone** (string): Business phone number.
* **categoryName** (string): Primary Google Maps business category.
* **url** (string): Direct Google Maps listing URL.

## **Keywords:**

California healthcare, provider intelligence, medical providers, geospatial dataset, cosmetic providers, dermatology, plastic surgery, insurance analytics, healthcare market data