Medi-Cal FPACT Provider Listing by US Government | Healthcare

About this Dataset

Medi-Cal FPACT Provider Listing

This dataset contains information on the Family Planning, Access, Care, and Treatment (Family PACT) Program providers for Calendar Year (CY) 2022. The data comes from the Provider Master File (PMF) in the Management Information System/Decision Support System (MIS/DSS) data warehouse, which is maintained by the California Department of Health Care Services (DHCS), Provider Enrollment Division, and from the DHCS, Office of Family Planning (OFP), which creates its own production files/datasets. This dataset includes the following variables: provider number, owner number, service location number, provider legal name, enrollment status effective date, provider address (city/state/zip).
Organization: State of California
Last updated: 2024-11-27T01:29:40.664163
Tags: california-department-of-health-care-services, familyplanning, fpact, ofp, providers

Tables

Table 1

@usgov.ca_gov_medi_cal_fpact_provider_listing_f1526.table_1

323.51 KB
1890 rows
30 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "rec_id" VARCHAR,
  "provider_source" VARCHAR,
  "provider_number" BIGINT,
  "owner_number" BIGINT,
  "service_location_number" BIGINT,
  "provider_name" VARCHAR,
  "business_name" VARCHAR,
  "enroll_stat_effective_dt" BIGINT,
  "fi_category_of_service_cd" BIGINT,
  "fi_category_of_service" VARCHAR,
  "enroll_stat_cd" BIGINT,
  "fi_provider_type_cd" BIGINT,
  "fi_provider_type" VARCHAR,
  "address_attention" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "zip_4" VARCHAR,
  "dhcs_county_cd" VARCHAR,
  "fips_county_cd" DOUBLE,
  "county" VARCHAR,
  "phone_number" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "countyname" VARCHAR
);