About this Dataset

Family PACT Providers, Clients And Reimbursement By County

This dataset includes the following variables: percentage of private sector and public sector enrolled providers by county and the percentage and average reimbursement of clients served.
Organization: State of California
Last updated: 2023-08-12T11:25:52.724476
Tags: access, california-department-of-health-care-services, care, clients, county, dhcs, family-pact-providers, family-planning, pharmacies, reimbursements, treatment-program

Tables

Family PACT Providers, Clients, And Reimbursement By County FYs 2010-11 To 2013-14

@usgov.ca_gov_family_pact_providers_clients_and_reimbursement_98684def.family_pact_providers_clients_and_reimbursement_by_cou_04c12928

25.92 KB
236 rows
19 columns


CREATE TABLE family_pact_providers_clients_and_reimbursement_by_cou_04c12928 (
  "fiscal_year" VARCHAR,
  "provider_county" VARCHAR,
  "enrolled_private_sector_providers" DOUBLE,
  "enrolled_public_sector_providers" DOUBLE,
  "total" DOUBLE,
  "percentage" VARCHAR,
  "number_change_from_previous_year" BIGINT,
  "number_change_over_5_years" BIGINT,
  "participating_pharmacies" BIGINT,
  "clients_served" DOUBLE,
  "percentage_of_clients_served" VARCHAR,
  "n__change_from_previous_year" VARCHAR,
  "n__change_over_5_years" VARCHAR,
  "reimbursement_amount" VARCHAR,
  "reimbursement_percentage" VARCHAR,
  "average_reimbursement_per_client_served" VARCHAR,
  "projected_population_of_reproductive_age" BIGINT,
  "annotation_code" VARCHAR,
  "annotation_description" VARCHAR
);

Family PACT Providers, Clients And Reimbursement By County From July 1, 2014 Through Current Year Of Data Available

@usgov.ca_gov_family_pact_providers_clients_and_reimbursement_98684def.family_pact_providers_clients_and_reimbursement_by_cou_0e35bd8b

29.47 KB
473 rows
14 columns


CREATE TABLE family_pact_providers_clients_and_reimbursement_by_cou_0e35bd8b (
  "fiscal_year" VARCHAR,
  "provider_county" VARCHAR,
  "enrolled_private_sector_providers" BIGINT,
  "enrolled_public_sector_providers" BIGINT,
  "total" BIGINT,
  "percentage" VARCHAR,
  "participating_pharmacies" BIGINT,
  "clients_served" VARCHAR,
  "percentage_of_clients_served" VARCHAR,
  "n__reimbursement_amount" VARCHAR,
  "reimbursement_percentage" VARCHAR,
  "average_reimbursement_per_client" VARCHAR,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Providers, Clients, And Reimbursement By County FYs 2004-05 To 2009-10

@usgov.ca_gov_family_pact_providers_clients_and_reimbursement_98684def.family_pact_providers_clients_and_reimbursement_by_cou_0f9d4b6f

26.07 KB
358 rows
15 columns


CREATE TABLE family_pact_providers_clients_and_reimbursement_by_cou_0f9d4b6f (
  "fiscal_year" TIMESTAMP,
  "provider_county" VARCHAR,
  "enrolled_private_sector_providers" BIGINT,
  "enrolled_public_sector_providers" BIGINT,
  "total" BIGINT,
  "percentage" VARCHAR,
  "participating_pharmacies" BIGINT,
  "clients_served" DOUBLE,
  "percentage_of_clients_served" VARCHAR,
  "reimbursement_amount" VARCHAR,
  "reimbursement_percentage" VARCHAR,
  "average_reimbursement_per_client_served" VARCHAR,
  "projected_population_of_reproductive_age" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Providers, Clients, And Reimbursement By County From FY 2014-15 To The Current Year Available

@usgov.ca_gov_family_pact_providers_clients_and_reimbursement_98684def.family_pact_providers_clients_and_reimbursement_by_cou_d21c05a8

15.86 KB
119 rows
14 columns


CREATE TABLE family_pact_providers_clients_and_reimbursement_by_cou_d21c05a8 (
  "fiscal_year" VARCHAR,
  "provider_county" VARCHAR,
  "enrolled_private_sector_providers" BIGINT,
  "enrolled_public_sector_providers" BIGINT,
  "total" BIGINT,
  "percentage" VARCHAR,
  "participating_pharmacies" BIGINT,
  "clients_served" DOUBLE,
  "percentage_of_clients_served" VARCHAR,
  "n__reimbursement_amount" VARCHAR,
  "reimbursement_percentage" VARCHAR,
  "average_reimbursement_per_client" VARCHAR,
  "annotation_code" VARCHAR,
  "annotation_description" VARCHAR
);

Family PACT Providers, Clients, And Reimbursement By County FY 2003-04

@usgov.ca_gov_family_pact_providers_clients_and_reimbursement_98684def.family_pact_providers_clients_and_reimbursement_by_cou_f2166ae6

13.96 KB
60 rows
14 columns


CREATE TABLE family_pact_providers_clients_and_reimbursement_by_cou_f2166ae6 (
  "fiscal_year" TIMESTAMP,
  "provider_county" VARCHAR,
  "enrolled_private_sector_providers" BIGINT,
  "enrolled_public_sector_providers" BIGINT,
  "total" BIGINT,
  "percentage" VARCHAR,
  "participating_pharmacies" BIGINT,
  "clients_served" BIGINT,
  "percentage_of_clients_served" VARCHAR,
  "reimbursement_amount" VARCHAR,
  "reimbursement_percentage" VARCHAR,
  "average_reimbursement_per_client_served" VARCHAR,
  "annotation_code" VARCHAR,
  "annotation_description" VARCHAR
);