About this Dataset

Family PACT Providers Profile

This dataset contains information on the Family Planning, Access, Care, and Treatment (Family PACT) Program (https://www.dhcs.ca.gov/services/ofp/Pages/OfficeofFamilyPlanning.aspx) providers. 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, name, type, specialty, geographic information, etc.
Organization: State of California
Last updated: 2024-05-14T20:11:49.208291
Tags: california-department-of-health-care-services, county, dhcs, enrollment-status-effective-date, mssa-id, national-provider-identification-number, provider-address, provider-latitude, provider-legal-name, provider-license-code, provider-longitude, provider-specialty-code, provider-type-code, provider-type-code-description, tract-id

Tables

Family PACT Providers Profile CY 2019

@usgov.ca_gov_family_pact_providers_profile_4838f.family_pact_providers_profile_cy_2019

173.8 kB
1,649 rows
25 columns

CREATE TABLE family_pact_providers_profile_cy_2019 (
  "provider_number" BIGINT,
  "npi_provider_number" BIGINT,
  "owner_number" BIGINT,
  "service_location_number" BIGINT,
  "provider_business_legal_name" VARCHAR,
  "enrollment_status_effective_date" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_code_desc" VARCHAR,
  "provider_license_number" VARCHAR,
  "provider_specialty_code" BIGINT,
  "provider_specialty_code_desc" VARCHAR,
  "out_of_state_ind" BIGINT,
  "out_of_state_ind_desc" VARCHAR,
  "provider_address_county_code" BIGINT,
  "provider_address_county_code_description" VARCHAR,
  "attention_line" VARCHAR,
  "provider_address_line1" VARCHAR,
  "provider_address_line2" VARCHAR,
  "provider_address_city" VARCHAR,
  "provider_address_state" VARCHAR,
  "provider_address_zip" BIGINT,
  "provider_address_latitude" DOUBLE,
  "provider_address_longitude" DOUBLE,
  "mssa_id" VARCHAR,
  "tract_id" DOUBLE
);

Family PACT Providers Profile CY 2021-2022

@usgov.ca_gov_family_pact_providers_profile_4838f.family_pact_providers_profile_cy_2021_2022

163.56 kB
1,556 rows
25 columns

CREATE TABLE family_pact_providers_profile_cy_2021_2022 (
  "provider_number" BIGINT,
  "npi_provider_number" BIGINT,
  "owner_number" BIGINT,
  "service_location_number" BIGINT,
  "provider_business_legal_name" VARCHAR,
  "enrollment_status_effective_date" VARCHAR,
  "provider_type_code" BIGINT,
  "provider_type_code_desc" VARCHAR,
  "provider_license_number" VARCHAR,
  "provider_specialty_code" DOUBLE,
  "provider_specialty_code_desc" VARCHAR,
  "out_of_state_ind" BIGINT,
  "out_of_state_ind_desc" VARCHAR,
  "provider_address_county_code" DOUBLE,
  "provider_address_county_desc" VARCHAR,
  "attention_line" VARCHAR,
  "provider_address_line1" VARCHAR,
  "provider_address_line2" VARCHAR,
  "provider_address_city" VARCHAR,
  "provider_address_state" VARCHAR,
  "provider_address_zip" BIGINT,
  "provider_address_latitude" DOUBLE,
  "provider_address_longitude" DOUBLE,
  "mssa_id" VARCHAR,
  "tract_id" DOUBLE
);

Family PACT Providers Profile CYs 2020-2021

@usgov.ca_gov_family_pact_providers_profile_4838f.family_pact_providers_profile_cys_2020_2021

179.59 kB
1,516 rows
26 columns

CREATE TABLE family_pact_providers_profile_cys_2020_2021 (
  "provider_number" BIGINT,
  "npi_provider_number" BIGINT,
  "owner_number" BIGINT,
  "service_location_number" BIGINT,
  "provider_business_legal_name" VARCHAR,
  "enrollment_status_effective_date" VARCHAR,
  "provider_type_code" BIGINT,
  "provider_type_code_desc" VARCHAR,
  "provider_license_number" VARCHAR,
  "provider_specialty_code" DOUBLE,
  "provider_specialty_code_desc" VARCHAR,
  "out_of_state_ind" BIGINT,
  "out_of_state_ind_desc" VARCHAR,
  "provider_address_county_code" DOUBLE,
  "provider_address_county_desc" VARCHAR,
  "attention_line" VARCHAR,
  "provider_address_line1" VARCHAR,
  "provider_address_line2" VARCHAR,
  "provider_address_city" VARCHAR,
  "provider_address_state" VARCHAR,
  "provider_address_zip" VARCHAR,
  "provider_phone_number" VARCHAR,
  "provider_address_latitude" DOUBLE,
  "provider_address_longitude" DOUBLE,
  "mssa_id" VARCHAR,
  "tract_id" DOUBLE
);