Dataset: Medi-Cal Managed Care Provider Listing

About this Dataset

Medi-Cal Managed Care Provider Listing

This file contains provider data, including details and address, for the Medi-Cal Managed Care Plans (MCPs.) This data is submitted to DHCS monthly via X12 274 Transaction files, each of the MCPs submit one file per County in which they operate. As of October 2023, there are 26 Managed Care Plans.

There are elements within the file that are not submitted by the plan, but are looked up from the Managed Care Annual Network Certification (ANC) Provider Taxonomy crosswalk. The submitted taxonomy is looked up and the Managed Care Provider Category and ANC Provider Type fields are returned. The most recent version the APL and other ANC related information can be found at: https://www.dhcs.ca.gov/formsandpubs/Pages/AllPlanLetters.aspx.
Organization: State of California
Last updated: 2024-11-27T01:21:38.790959
Tags: 274, california-department-of-health-care-services, caopendata, dhcs, managed-care, mcqmd, medical-provider, odp, provider

Tables

Table 1

@usgov.ca_gov_medi_cal_managed_care_provider_listing_d0091.table_1

120.89 MB
3268559 rows
32 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "managedcareplan" VARCHAR,
  "subnetwork" VARCHAR,
  "plancode" BIGINT,
  "recordtype" VARCHAR,
  "npi" DOUBLE,
  "facilityname" VARCHAR,
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "taxonomy" VARCHAR,
  "mcnaprovidergroup" VARCHAR,
  "mcnaprovidertype" VARCHAR,
  "facilitytype" VARCHAR,
  "licensuretype" VARCHAR,
  "primarycare" VARCHAR,
  "specialist" VARCHAR,
  "seeschildren" VARCHAR,
  "telehealth" VARCHAR,
  "bhindicator" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "zip_4" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "dhcscountycode" BIGINT,
  "fipscd" DOUBLE,
  "county" VARCHAR
);