Family PACT Providers Profile by US Government | Healthcare

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 2021-2022

@usgov.ca_gov_family_pact_providers_profile_4838f.family_pact_providers_profile_cy_2021_2022

159.73 KB
1556 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

175.38 KB
1516 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
);

Family PACT Providers Profile CY 2019

@usgov.ca_gov_family_pact_providers_profile_4838f.family_pact_providers_profile_cy_2019

169.72 KB
1649 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
);