About this Dataset

MediCal Dental FFS Provider Listing

The dataset provides enrollment and geographic data for Fee-for-Service (FFS) providers enrolled in the Medi-Cal Dental program and Safety Net Clinics (SNCs) who provide dental services. The data is based on a point in time and is expected to be updated regularly as it becomes available. This dataset does not include Dental Managed Care providers.
Organization: State of California
Last updated: 2025-09-23T12:39:38.594418
Tags: ca, california, california-department-of-health-care-services, dental, fee-for-service, ffs, medi-cal, medi-cal-ffs

Tables

Table 1

@usgov.ca_gov_medical_dental_ffs_provider_listing.table_1

2.35 MB
50,359 rows
25 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "provider_npi" BIGINT,
  "billing_provider_number" VARCHAR,
  "service_location_number" DOUBLE,
  "provider_legal_name" VARCHAR,
  "enrollment_status_effective_dat" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_code_desc" VARCHAR,
  "provider_specialty_code" DOUBLE,
  "provider_specialty_code_desc" VARCHAR,
  "provider_language_code" VARCHAR,
  "provider_language_code_desc" VARCHAR,
  "provider_county_code" DOUBLE,
  "provider_county_desc" VARCHAR,
  "billing_provider_address_attent" VARCHAR,
  "billing_provider_address_1" VARCHAR,
  "billing_provider_address_2" VARCHAR,
  "billing_provider_city" VARCHAR,
  "billing_provider_state" VARCHAR,
  "billing_provider_zip" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "countyname" VARCHAR
);