About this Dataset

Provision Of Selected Family PACT Contraception By County

This dataset includes the following variables: number of contraceptive implants; intrauterine contraceptives (IUCs); Essure procedures and tubal ligation services delivered by providers and the number of female clients receiving these services; number of vasectomies delivered by providers and number received by male clients.
Organization: State of California
Last updated: 2023-08-12T12:51:49.333653
Tags: california-department-of-health-care-services, contraception, contraceptive-implants, county, dhcs, essure, family-pact, family-planning-access-care-and-treatment-program, female-sterilization, intrauterine-contraceptives, iuss, male-sterilization, tubal-ligations, vasectomy

Tables

Provision Of Selected Family PACT Contraception By County FYs 2011-12 To 2013-14

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_03a62743

18.75 kB
177 rows
14 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_03a62743 (
  "fiscal_year" VARCHAR,
  "county" VARCHAR,
  "providers_reimbursed_for_implant_services" BIGINT,
  "clients_receiving_implant_services" DOUBLE,
  "providers_reimbursed_for_iuc_services" BIGINT,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_female_tubal_ligation_sterili_d86ea79c" BIGINT  -- Providers Reimbursed For Female Tubal Ligation Sterilization Services,
  "clients_receiving_female_tubal_ligation_sterilization_services" DOUBLE,
  "providers_reimbursed_for_female_sterilization_essure_services" BIGINT  -- Providers Reimbursed For Female Sterilization (Essure) Services,
  "clients_receiving_female_sterilization_essure_services" DOUBLE  -- Clients Receiving Female Sterilization (Essure) Services,
  "providers_reimbursed_for_male_sterilization_vasectomy_services" BIGINT  -- Providers Reimbursed For Male Sterilization (Vasectomy) Services,
  "clients_receiving_male_sterilization_vasectomy_services" DOUBLE  -- Clients Receiving Male Sterilization (Vasectomy) Services,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Provision Of Selected Family PACT Contraception By County FY 2007-08

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_07387b9f

14.02 kB
59 rows
12 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_07387b9f (
  "fiscal_year" TIMESTAMP,
  "county" VARCHAR,
  "providers_reimbursed_for_ecp_services" BIGINT,
  "clients_receiving_ecp_sevices" DOUBLE,
  "n__providers_reimbursed_for_iuc_services" BIGINT  -- Providers Reimbursed For IUC Services,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_tubal_ligation_female_sterili_686f0e11" BIGINT  -- Providers Reimbursed For Tubal Ligation Female Sterilization Services,
  "clients_receiving_female_sterilization_tubal_ligation_services" DOUBLE  -- Clients Receiving Female Sterilization (Tubal Ligation) Services,
  "providers_reimbursed_for_male_sterilization_vasectomy_services" BIGINT  -- Providers Reimbursed For Male Sterilization (Vasectomy) Services,
  "clients_receiving_male_sterilization_vasectomy_services" DOUBLE  -- Clients Receiving Male Sterilization (Vasectomy) Services,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Provision Of Selected Family PACT Contraception By County FY 2006-07

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_0e48a2a3

18.75 kB
59 rows
16 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_0e48a2a3 (
  "fiscal_year" TIMESTAMP,
  "provider_county" VARCHAR,
  "providers_reimbursed_for_patch_services" BIGINT,
  "n__clients_receiving_patch_services" DOUBLE  -- Clients Receiving Patch Services,
  "n__providers_reimbursed_for_ecp_services" BIGINT  -- Providers Reimbursed For ECP Services,
  "clients_receiving_ecp_services" DOUBLE,
  "providers_reimbursed_for_ring_services" BIGINT,
  "clients_receiving_ring_services" DOUBLE,
  "providers_reimbursed_for_iuc_services" BIGINT,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_tubal_ligation_female_sterili_686f0e11" BIGINT  -- Providers Reimbursed For Tubal Ligation Female Sterilization Services,
  "clients_receiving_female_sterilization_tubal_ligation_services" DOUBLE  -- Clients Receiving Female Sterilization (Tubal Ligation) Services,
  "providers_reimbursed_for_male_sterilization_vasectomy_services" BIGINT  -- Providers Reimbursed For Male Sterilization (Vasectomy) Services,
  "clients_receiving_male_sterilization_vasectomy_services" DOUBLE  -- Clients Receiving Male Sterilization (Vasectomy) Services,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Provision Of Selected Family PACT Contraception By County FYs 2009-10 To 2010-11

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_7c68fa33

17.53 kB
118 rows
14 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_7c68fa33 (
  "fiscal_year" TIMESTAMP,
  "county" VARCHAR,
  "providers_reimbursed_for_iuc_services" BIGINT,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_implant_services" BIGINT,
  "clients_receiving_implant_services" DOUBLE,
  "providers_reimbursed_for_female_tubal_ligation_sterili_7ef1872e" BIGINT  -- Providers Reimbursed For Female Tubal Ligation Sterilization Services,
  "clients_receiving_female_sterilization_tubal_ligation_services" DOUBLE  -- Clients Receiving Female Sterilization (Tubal Ligation) Services,
  "providers_reimbursed_for_female_sterilization_essure_services" BIGINT  -- Providers Reimbursed For Female Sterilization (Essure) Services,
  "clients_receiving_female_sterilization_essure_services" DOUBLE  -- Clients Receiving Female Sterilization (Essure) Services,
  "providers_reimbursed_for_male_sterilization_vasectomy_services" BIGINT  -- Providers Reimbursed For Male Sterilization (Vasectomy) Services,
  "clients_receiving_male_sterilization_vasectomy_services" DOUBLE  -- Clients Receiving Male Sterilization (Vasectomy) Services,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Provision Of Selected Family PACT Contraception By County FYs 2014-15 To Current FY Available

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_88e303b2

22.83 kB
470 rows
14 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_88e303b2 (
  "fiscal_year" VARCHAR,
  "county" VARCHAR,
  "providers_reimbursed_for_implant_services" BIGINT,
  "n__clients_receiving_implant_services" DOUBLE  -- Clients Receiving Implant Services,
  "providers_reimbursed_for_iuc_services" BIGINT,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_tubal_ligation_services_femal_ca2ff354" BIGINT  -- Providers Reimbursed For Tubal Ligation Services (Female Sterilization),
  "clients_receiving_tubal_ligation_services_female_sterilization" DOUBLE  -- Clients Receiving Tubal Ligation Services (Female Sterilization),
  "providers_reimbursed_for_essure_services_female_sterilization" VARCHAR  -- Providers Reimbursed For Essure Services (Female Sterilization),
  "clients_receiving_essure_services_female_sterilization" VARCHAR  -- Clients Receiving Essure Services (Female Sterilization),
  "providers_reimbursed_for_vasectomy_services_male_sterilization" BIGINT  -- Providers Reimbursed For Vasectomy Services (Male Sterilization),
  "clients_receiving_vasectomy_services_male_sterilization" DOUBLE  -- Clients Receiving Vasectomy Services (Male Sterilization),
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Provision Of Selected Family PACT Contraception By County FY 2008-09

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_9fdef90a

16.23 kB
59 rows
14 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_9fdef90a (
  "fiscal_year" TIMESTAMP,
  "county" VARCHAR,
  "n__providers_reimbursed_for_ecp_services" BIGINT  -- Providers Reimbursed For ECP Services,
  "clients_receiving_ecp_services" DOUBLE,
  "providers_reimbursed_for_impant_services" BIGINT,
  "n__clients_receiving_implant_services" DOUBLE  -- Clients Receiving Implant Services,
  "n__providers_reimbursed_for_iuc_services" BIGINT  -- Providers Reimbursed For IUC Services,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_female_tubal_ligation_sterili_7ef1872e" BIGINT  -- Providers Reimbursed For Female Tubal Ligation Sterilization Services,
  "clients_receiving_female_sterilization_tubal_ligation_services" DOUBLE  -- Clients Receiving Female Sterilization (Tubal Ligation) Services,
  "providers_reimbursed_for_male_sterilization_vasectomy_services" BIGINT  -- Providers Reimbursed For Male Sterilization (Vasectomy) Services,
  "clients_receiving_male_sterilization_vasectomy_services" DOUBLE  -- Clients Receiving Male Sterilization (Vasectomy) Services,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Provision Of Selected Family PACT Contraception By County FYs 2003-04 To 2005-06

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_b17cdcce

11.53 kB
177 rows
8 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_b17cdcce (
  "fiscal_year" TIMESTAMP,
  "provider_county" VARCHAR,
  "providers_reimbursed_for_male_sterilization_vasectomy_services" BIGINT,
  "providers_reimbursed_for_tubal_ligation_service_female_382d020c" BIGINT  -- Providers Reimbursed For Tubal Ligation Service Female Sterilization,
  "providers_reimbursed_for_iuc_services" BIGINT,
  "providers_reimbursed_for_patch_services" BIGINT,
  "providers_reimbursed_for_ecp_services" BIGINT,
  "providers_reimbursed_for_ring_service" BIGINT
);

Provision Of Selected Family PACT Contraception By County FY 2014-15 To Current FY Available

@usgov.ca_gov_provision_of_selected_family_pact_contraception_d54baefd.provision_of_selected_family_pact_contraception_by_cou_fe13bfd4

17.35 kB
117 rows
14 columns

CREATE TABLE provision_of_selected_family_pact_contraception_by_cou_fe13bfd4 (
  "fiscal_year" VARCHAR,
  "county" VARCHAR,
  "providers_reimbursed_for_implant_services" BIGINT,
  "n__clients_receiving_implant_services" DOUBLE  -- Clients Receiving Implant Services,
  "providers_reimbursed_for_iuc_services" BIGINT,
  "clients_receiving_iuc_services" DOUBLE,
  "providers_reimbursed_for_tubal_ligation_services_femal_ca2ff354" BIGINT  -- Providers Reimbursed For Tubal Ligation Services (Female Sterilization),
  "clients_receiving_tubal_ligation_services_female_sterilization" DOUBLE  -- Clients Receiving Tubal Ligation Services (Female Sterilization),
  "providers_reimbursed_for_essure_services_female_sterilization" BIGINT  -- Providers Reimbursed For Essure Services (Female Sterilization),
  "clients_receiving_essure_services_female_sterilization" DOUBLE  -- Clients Receiving Essure Services (Female Sterilization),
  "providers_reimbursed_for_vasectomy_services_male_sterilization" BIGINT  -- Providers Reimbursed For Vasectomy Services (Male Sterilization),
  "clients_receiving_vasectomy_services_male_sterilization" DOUBLE  -- Clients Receiving Vasectomy Services (Male Sterilization),
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);