Family PACT Client Demographics By County
State of California
@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6
State of California
@usgov.ca_gov_family_pact_client_demographics_by_county_0bed6
CREATE TABLE family_pact_client_demographics_by_county_fy_2007_08 (
"fiscal_year" TIMESTAMP,
"client_county" VARCHAR,
"clients_served" DOUBLE,
"clients_served_7d159a" VARCHAR,
"average_age_of_clients_served" DOUBLE,
"adolescent_clients_served" DOUBLE,
"adolescent_clients_served_430302" VARCHAR,
"male_clients_served" DOUBLE,
"male_clients_served_f3e7e3" VARCHAR,
"n__asian_pi_filipino_clients_served" DOUBLE,
"asian_pi_filipino_clients_served" VARCHAR,
"black_clients_served" DOUBLE,
"black_clients_served_b68316" VARCHAR,
"latino_clients_served" DOUBLE,
"latino_clients_served_083cce" VARCHAR,
"white_clients_served" BIGINT,
"white_clients_served_35096c" VARCHAR,
"other_including_native_american_clients_served" DOUBLE,
"other_including_native_american_clients_served_b6360e" VARCHAR,
"spanish_speaking_clients_served" DOUBLE,
"spanish_speaking_clients_served_466f91" VARCHAR,
"english_speaking_clients_served" DOUBLE,
"english_speaking_clients_served_1f1332" VARCHAR,
"other_language" DOUBLE,
"other_language_9a4a9e" VARCHAR,
"annotation_code" DOUBLE,
"annotation_description" VARCHAR
);
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,
"average_age_of_clients_served" DOUBLE,
"adolescents_clients_served" DOUBLE,
"adolescents_clients_served_016d89" VARCHAR,
"male_clients_served" DOUBLE,
"male_clients_served_f3e7e3" VARCHAR,
"latino_clients_served" DOUBLE,
"latino_clients_served_083cce" VARCHAR,
"white_clients_served" DOUBLE,
"n__white_clients_served" VARCHAR,
"african_american_clients_served" DOUBLE,
"n__african_american_black_clients_served" VARCHAR,
"asian_pacific_islander_clients_served" DOUBLE,
"asian_pacific_islander_clients_served_eb91d7" VARCHAR,
"other_including_native_american_clients_served" DOUBLE,
"other_including_native_american_clients_served_b6360e" VARCHAR,
"spanish_speaking_clients_served" DOUBLE,
"spanish_speaking_clients_served_466f91" VARCHAR,
"english_speaking_clients_served" BIGINT,
"english_speaking_clients_served_1f1332" VARCHAR,
"other_language" DOUBLE,
"other_language_9a4a9e" VARCHAR,
"annotation_code" DOUBLE,
"annotation_description" VARCHAR
);
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,
"male_clients_served" DOUBLE,
"male_clients_served_f3e7e3" VARCHAR,
"latino_clients_served" BIGINT,
"latino_clients_served_083cce" VARCHAR,
"white_clients_served" BIGINT,
"white_clients_served_35096c" VARCHAR,
"african_american_clients_served" DOUBLE,
"african_american_clients_served_99d992" VARCHAR,
"asian_filipino_and_pacific_islander_clients_served" DOUBLE,
"asian_filipino_and_pacific_islander_clients_served_cd16cb" VARCHAR,
"native_american_and_other_clients_served" DOUBLE,
"native_american_and_other_clients_served_007745" VARCHAR,
"spanish_speaking_clients_served" DOUBLE,
"spanish_speaking_clients_served_466f91" VARCHAR,
"english_speaking_clients_served" BIGINT,
"english_speaking_clients_served_1f1332" VARCHAR,
"other_language" DOUBLE,
"other_language_9a4a9e" VARCHAR,
"annotation_code" DOUBLE,
"annotation_description" VARCHAR
);
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,
"average_age_of_clients_served" DOUBLE,
"adolescent_clients_served" DOUBLE,
"adolescent_clients_served_430302" VARCHAR,
"male_clients_served" DOUBLE,
"male_clients_served_f3e7e3" VARCHAR,
"latino_clients_served" DOUBLE,
"latino_clients_served_083cce" VARCHAR,
"white_clients_served" DOUBLE,
"white_clients_served_35096c" VARCHAR,
"african_american_clients_served" DOUBLE,
"african_american_clients_served_99d992" VARCHAR,
"asian_fillipino_and_pacific_islander_clients_served" DOUBLE,
"asian_fillipino_and_pacific_islander_clients_served_52544c" VARCHAR,
"native_american_and_other_clients_served" DOUBLE,
"native_american_and_other_clients_served_007745" VARCHAR,
"spanish_speaking_clients_served" DOUBLE,
"spanish_speaking_clients_served_466f91" VARCHAR,
"english_speaking_clients_served" DOUBLE,
"english_speaking_clients_served_1f1332" VARCHAR,
"n__other_language" DOUBLE,
"other_language" VARCHAR,
"annotation_code" DOUBLE,
"annotation_description" VARCHAR
);
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,
"average_age_of_clients_served" DOUBLE,
"adolescent_clients_served" DOUBLE,
"adolescent_clients_served_430302" VARCHAR,
"male_clients_served" DOUBLE,
"male_clients_served_f3e7e3" VARCHAR,
"latino_clients_served" DOUBLE,
"latino_clients_served_083cce" VARCHAR,
"white_clients_served" DOUBLE,
"white_clients_served_35096c" VARCHAR,
"african_american_clients_served" DOUBLE,
"african_american_clients_served_99d992" VARCHAR,
"asian_pacific_islander_clients_served" DOUBLE,
"asian_pacific_islander_clients_served_eb91d7" VARCHAR,
"other_including_native_american_clients_served" DOUBLE,
"other_including_native_american_clients_served_b6360e" VARCHAR,
"spanish_speaking_clients_served" DOUBLE,
"spanish_speaking_clients_served_466f91" VARCHAR,
"english_speaking_clients_served" DOUBLE,
"english_speaking_clients_served_1f1332" VARCHAR,
"other_language" DOUBLE,
"other_language_9a4a9e" VARCHAR,
"annotation_code" DOUBLE,
"annotation_description" VARCHAR
);
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,
"average_age_of_clients_served" DOUBLE,
"adolescents_clients_served" DOUBLE,
"adolescents_clients_served_016d89" VARCHAR,
"male_clients_served" DOUBLE,
"male_clients_served_f3e7e3" VARCHAR,
"latino_clients_served" DOUBLE,
"latino_clients_served_083cce" VARCHAR,
"white_clients_served" DOUBLE,
"n__white_clients_served" VARCHAR,
"african_american_clients_served" DOUBLE,
"n__african_american_black_clients_served" VARCHAR,
"asian_pacific_islander_clients_served" DOUBLE,
"asian_pacific_islander_clients_served_eb91d7" VARCHAR,
"other_including_native_american_clients_served" DOUBLE,
"other_including_native_american_clients_served_b6360e" VARCHAR,
"spanish_speaking_clients_served" DOUBLE,
"spanish_speaking_clients_served_466f91" VARCHAR,
"english_speaking_clients_served" DOUBLE,
"english_speaking_clients_served_1f1332" VARCHAR,
"other_language" DOUBLE,
"other_language_9a4a9e" VARCHAR,
"annotation_code" DOUBLE,
"annotation_description" VARCHAR
);
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_0468a5e8 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_52caa575 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_daa2f626 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE n__dictionary_family_pact_client_demographics_by_count_e4513d9c (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.