Baselight
Sign In

Family PACT Client Demographics By County

State of California

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6

Loading...
Loading...

About this Dataset

Family PACT Client Demographics By County

This dataset includes the following variables: client county; number, percentage, average, and age of clients served, number and percentage of adolescent client served, number and percentage of male clients served , and clients served by race and ethnicity (Latino, White, African American, Asian and Pacific Islander, Other (including Native American); and clients served by primary language (Spanish, English, Other).
Organization: State of California
Last updated: 2025-07-23T21:41:34.334866
Tags: access, adolescent, california-department-of-health-care-services, care, client, county, demographics, dhcs, family-pact, family-planning, family-planning-access-care-and-treatment-program, males, treatment-program

Tables

Family PACT Client Demographics By County FY 2007-08

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.family_pact_client_demographics_by_county_fy_2007_08
  • 28.02 kB
  • 59 rows
  • 27 columns
Loading... 
CREATE TABLE family_pact_client_demographics_by_county_fy_2007_08 (
  "fiscal_year" TIMESTAMP,
  "client_county" VARCHAR,
  "clients_served" DOUBLE,
  "clients_served_7d159a" VARCHAR  -- Clients Served %,
  "average_age_of_clients_served" DOUBLE,
  "adolescent_clients_served" DOUBLE,
  "adolescent_clients_served_430302" VARCHAR  -- Adolescent Clients Served %,
  "male_clients_served" DOUBLE,
  "male_clients_served_f3e7e3" VARCHAR  -- Male Clients Served %,
  "n__asian_pi_filipino_clients_served" DOUBLE  -- Asian, PI, Filipino Clients Served,
  "asian_pi_filipino_clients_served" VARCHAR  -- Asian, PI, Filipino Clients Served %,
  "black_clients_served" DOUBLE,
  "black_clients_served_b68316" VARCHAR  -- Black Clients Served %,
  "latino_clients_served" DOUBLE,
  "latino_clients_served_083cce" VARCHAR  -- Latino Clients Served %,
  "white_clients_served" BIGINT,
  "white_clients_served_35096c" VARCHAR  -- White Clients Served %,
  "other_including_native_american_clients_served" DOUBLE  -- Other (Including Native American) Clients Served,
  "other_including_native_american_clients_served_b6360e" VARCHAR  -- Other (Including Native American) Clients Served %,
  "spanish_speaking_clients_served" DOUBLE,
  "spanish_speaking_clients_served_466f91" VARCHAR  -- Spanish Speaking Clients Served %,
  "english_speaking_clients_served" DOUBLE,
  "english_speaking_clients_served_1f1332" VARCHAR  -- English Speaking Clients Served %,
  "other_language" DOUBLE,
  "other_language_9a4a9e" VARCHAR  -- Other Language %,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Client Demographics By County FY 2014-15 To The Current Year Available

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.family_pact_client_demographics_by_county_fy_2014_15_t_f7cd1d1d
  • 35.29 kB
  • 118 rows
  • 27 columns
Loading... 
CREATE TABLE family_pact_client_demographics_by_county_fy_2014_15_t_f7cd1d1d (
  "fiscal_year" VARCHAR,
  "client_county" VARCHAR,
  "clients_served" BIGINT,
  "clients_served_7d159a" VARCHAR  -- Clients Served %,
  "average_age_of_clients_served" DOUBLE,
  "adolescents_clients_served" DOUBLE,
  "adolescents_clients_served_016d89" VARCHAR  -- Adolescents Clients Served %,
  "male_clients_served" DOUBLE,
  "male_clients_served_f3e7e3" VARCHAR  -- Male Clients Served %,
  "latino_clients_served" DOUBLE,
  "latino_clients_served_083cce" VARCHAR  -- Latino Clients Served %,
  "white_clients_served" DOUBLE,
  "n__white_clients_served" VARCHAR  -- White Clients Served %,
  "african_american_clients_served" DOUBLE,
  "n__african_american_black_clients_served" VARCHAR  -- African American Black Clients Served %,
  "asian_pacific_islander_clients_served" DOUBLE,
  "asian_pacific_islander_clients_served_eb91d7" VARCHAR  -- Asian/Pacific Islander Clients Served %,
  "other_including_native_american_clients_served" DOUBLE  -- Other (Including Native American) Clients Served,
  "other_including_native_american_clients_served_b6360e" VARCHAR  -- Other (Including Native American) Clients Served %,
  "spanish_speaking_clients_served" DOUBLE,
  "spanish_speaking_clients_served_466f91" VARCHAR  -- Spanish Speaking Clients Served %,
  "english_speaking_clients_served" BIGINT,
  "english_speaking_clients_served_1f1332" VARCHAR  -- English Speaking Clients Served %,
  "other_language" DOUBLE,
  "other_language_9a4a9e" VARCHAR  -- Other Language %,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Client Demographics By County FYs 2003-04 To 2004-05

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.family_pact_client_demographics_by_county_fys_2003_04__55c4c04b
  • 30.73 kB
  • 118 rows
  • 25 columns
Loading... 
CREATE TABLE family_pact_client_demographics_by_county_fys_2003_04__55c4c04b (
  "fiscal_year" TIMESTAMP,
  "client_county" VARCHAR,
  "average_age_of_clients_served" DOUBLE,
  "adolescent_clients_served" BIGINT,
  "adolescent_clients_served_430302" VARCHAR  -- Adolescent Clients Served %,
  "male_clients_served" DOUBLE,
  "male_clients_served_f3e7e3" VARCHAR  -- Male Clients Served %,
  "latino_clients_served" BIGINT,
  "latino_clients_served_083cce" VARCHAR  -- Latino Clients Served %,
  "white_clients_served" BIGINT,
  "white_clients_served_35096c" VARCHAR  -- White Clients Served %,
  "african_american_clients_served" DOUBLE,
  "african_american_clients_served_99d992" VARCHAR  -- African American Clients Served %,
  "asian_filipino_and_pacific_islander_clients_served" DOUBLE  -- Asian, Filipino, And Pacific Islander Clients Served,
  "asian_filipino_and_pacific_islander_clients_served_cd16cb" VARCHAR  -- Asian, Filipino, And Pacific Islander Clients Served %,
  "native_american_and_other_clients_served" DOUBLE,
  "native_american_and_other_clients_served_007745" VARCHAR  -- Native American And Other Clients Served %,
  "spanish_speaking_clients_served" DOUBLE,
  "spanish_speaking_clients_served_466f91" VARCHAR  -- Spanish Speaking Clients Served %,
  "english_speaking_clients_served" BIGINT,
  "english_speaking_clients_served_1f1332" VARCHAR  -- English Speaking Clients Served %,
  "other_language" DOUBLE,
  "other_language_9a4a9e" VARCHAR  -- Other Language %,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Client Demographics By County FYs 2005-06 To 2006-07

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.family_pact_client_demographics_by_county_fys_2005_06__9c96ced5
  • 33.06 kB
  • 118 rows
  • 27 columns
Loading... 
CREATE TABLE family_pact_client_demographics_by_county_fys_2005_06__9c96ced5 (
  "fiscal_year" TIMESTAMP,
  "client_county" VARCHAR,
  "clients_served" DOUBLE,
  "clients_served_7d159a" VARCHAR  -- Clients Served %,
  "average_age_of_clients_served" DOUBLE,
  "adolescent_clients_served" DOUBLE,
  "adolescent_clients_served_430302" VARCHAR  -- Adolescent Clients Served %,
  "male_clients_served" DOUBLE,
  "male_clients_served_f3e7e3" VARCHAR  -- Male Clients Served %,
  "latino_clients_served" DOUBLE,
  "latino_clients_served_083cce" VARCHAR  -- Latino Clients Served %,
  "white_clients_served" DOUBLE,
  "white_clients_served_35096c" VARCHAR  -- White Clients Served %,
  "african_american_clients_served" DOUBLE,
  "african_american_clients_served_99d992" VARCHAR  -- African American Clients Served %,
  "asian_fillipino_and_pacific_islander_clients_served" DOUBLE  -- Asian, Fillipino, And Pacific Islander Clients Served,
  "asian_fillipino_and_pacific_islander_clients_served_52544c" VARCHAR  -- Asian, Fillipino, And Pacific Islander Clients Served %,
  "native_american_and_other_clients_served" DOUBLE,
  "native_american_and_other_clients_served_007745" VARCHAR  -- Native American And Other Clients Served %,
  "spanish_speaking_clients_served" DOUBLE,
  "spanish_speaking_clients_served_466f91" VARCHAR  -- Spanish Speaking Clients Served %,
  "english_speaking_clients_served" DOUBLE,
  "english_speaking_clients_served_1f1332" VARCHAR  -- English Speaking Clients Served %,
  "n__other_language" DOUBLE  -- Other Language,
  "other_language" VARCHAR  -- Other Language %,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Client Demographics By County FYs 2008-09 To 2013-14

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.family_pact_client_demographics_by_county_fys_2008_09__754335ab
  • 48.87 kB
  • 354 rows
  • 27 columns
Loading... 
CREATE TABLE family_pact_client_demographics_by_county_fys_2008_09__754335ab (
  "fiscal_year" VARCHAR,
  "client_county" VARCHAR,
  "clients_served" DOUBLE,
  "clients_served_7d159a" VARCHAR  -- Clients Served %,
  "average_age_of_clients_served" DOUBLE,
  "adolescent_clients_served" DOUBLE,
  "adolescent_clients_served_430302" VARCHAR  -- Adolescent Clients Served %,
  "male_clients_served" DOUBLE,
  "male_clients_served_f3e7e3" VARCHAR  -- Male Clients Served %,
  "latino_clients_served" DOUBLE,
  "latino_clients_served_083cce" VARCHAR  -- Latino Clients Served %,
  "white_clients_served" DOUBLE,
  "white_clients_served_35096c" VARCHAR  -- White Clients Served %,
  "african_american_clients_served" DOUBLE,
  "african_american_clients_served_99d992" VARCHAR  -- African American Clients Served %,
  "asian_pacific_islander_clients_served" DOUBLE,
  "asian_pacific_islander_clients_served_eb91d7" VARCHAR  -- Asian/Pacific Islander Clients Served %,
  "other_including_native_american_clients_served" DOUBLE  -- Other (Including Native American) Clients Served,
  "other_including_native_american_clients_served_b6360e" VARCHAR  -- Other (Including Native American) Clients Served %,
  "spanish_speaking_clients_served" DOUBLE,
  "spanish_speaking_clients_served_466f91" VARCHAR  -- Spanish Speaking Clients Served %,
  "english_speaking_clients_served" DOUBLE,
  "english_speaking_clients_served_1f1332" VARCHAR  -- English Speaking Clients Served %,
  "other_language" DOUBLE,
  "other_language_9a4a9e" VARCHAR  -- Other Language %,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Family PACT Client Demographics By County FYs 2014-15 To The Current Year Available

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.family_pact_client_demographics_by_county_fys_2014_15__3779f53d
  • 69.26 kB
  • 472 rows
  • 27 columns
Loading... 
CREATE TABLE family_pact_client_demographics_by_county_fys_2014_15__3779f53d (
  "fiscal_year" VARCHAR,
  "client_county" VARCHAR,
  "clients_served" DOUBLE,
  "clients_served_7d159a" VARCHAR  -- Clients Served %,
  "average_age_of_clients_served" DOUBLE,
  "adolescents_clients_served" DOUBLE,
  "adolescents_clients_served_016d89" VARCHAR  -- Adolescents Clients Served %,
  "male_clients_served" DOUBLE,
  "male_clients_served_f3e7e3" VARCHAR  -- Male Clients Served %,
  "latino_clients_served" DOUBLE,
  "latino_clients_served_083cce" VARCHAR  -- Latino Clients Served %,
  "white_clients_served" DOUBLE,
  "n__white_clients_served" VARCHAR  -- White Clients Served %,
  "african_american_clients_served" DOUBLE,
  "n__african_american_black_clients_served" VARCHAR  -- African American Black Clients Served %,
  "asian_pacific_islander_clients_served" DOUBLE,
  "asian_pacific_islander_clients_served_eb91d7" VARCHAR  -- Asian/Pacific Islander Clients Served %,
  "other_including_native_american_clients_served" DOUBLE  -- Other (Including Native American) Clients Served,
  "other_including_native_american_clients_served_b6360e" VARCHAR  -- Other (Including Native American) Clients Served %,
  "spanish_speaking_clients_served" DOUBLE,
  "spanish_speaking_clients_served_466f91" VARCHAR  -- Spanish Speaking Clients Served %,
  "english_speaking_clients_served" DOUBLE,
  "english_speaking_clients_served_1f1332" VARCHAR  -- English Speaking Clients Served %,
  "other_language" DOUBLE,
  "other_language_9a4a9e" VARCHAR  -- Other Language %,
  "annotation_code" DOUBLE,
  "annotation_description" VARCHAR
);

Data Dictionary - Family PACT Client Demographics By County FYs 2008-09 To 2013-14

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.n__dictionary_family_pact_client_demographics_by_count_0468a5e8
  • 5.45 kB
  • 27 rows
  • 4 columns
Loading... 
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_0468a5e8 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Family PACT Client Demographics By County FY 2007-08

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.n__dictionary_family_pact_client_demographics_by_count_52caa575
  • 5.37 kB
  • 27 rows
  • 4 columns
Loading... 
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_52caa575 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Family PACT Client Demographics By County FYs 2005-06 To 2006-07

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.n__dictionary_family_pact_client_demographics_by_count_daa2f626
  • 5.53 kB
  • 27 rows
  • 4 columns
Loading... 
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_daa2f626 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Family PACT Client Demographics By County FYs 2003-04 To 2004-05

@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6.n__dictionary_family_pact_client_demographics_by_count_e4513d9c
  • 5.62 kB
  • 25 rows
  • 4 columns
Loading... 
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_e4513d9c (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Share link

Anyone who has the link will be able to view this.